*Hi,*
*Here are the profiles. Please reply with your interest ONLY TO
k...@delightconsulting.com <k...@delightconsulting.com> with complete Job
details and we would be glad to assist you. Thanks*
*Name of the Consultant: Vamshi Availability and hourly rate: Immediate/
Open BestRelocation : Open*
*Com skills: Good*
*Technical skills: Good*
- Around 8 years of experience in IT in the areas of analysis, design,
development and testing in client server environment with focus on Data
warehousing applications using ETL/OLAP tools like *Informatica*, *Business
Objects with Oracle, SQL Server databases.*
- Experience in business requirements gathering, define and capture
metadata for business rules, system analysis, design, development,
production support, testing, user training, and strategic decision making,
problem solving associated with the ETL processes by working closely with
BI team.
- Implemented *Data Warehousing, Data Marts, Dimensional Modeling, Star/
Snow Flake Schema Modeling, Entity-Relationship Modeling, OLAP and OLTP *
concepts.
- Implemented *Change Data Capture/Incremental Loading* and *slowly-changing
Dimensions.*
- Extensive experience in extraction, transform and loading of data
directly from different heterogeneous source systems *like Flat files
(Fixed width & Delimited), COBOL files, VSAM, IBM DB2, Excel, Oracle, MS
SQL Server*, *Teradata, DB2.*
- Familiarity with* PL/SQL* *Functions, Cursors, Packages, Views,
Indexes and extensive experience in writing SQL queries and Stored
Procedures.*
- Experience in working closely with the project management to ensure
timely delivery of solutions and learning *business concepts* quickly
and relate them to specific project needs.
- Created *Design and Mapping Documents* after interacting with business
analysts to clarify requirements.
- Experience in Performance Tuning. Identified and fixed bottlenecks and
tuned the complex Informatica mappings for better Performance.
- Experience in writing complex sub queries, PL/SQL programs (functions,
procedures, packages), stored procedures, and shell scripting to run pre
session and post session commands.
- Expertise in using GUI tolls like Erwin, Toad, SQL Developer, SQL
Navigator and SQL *Loader.
- Proficiency in developing standards and re-usable logics using *ETL
Informatica* tool.
- Strong Knowledge of applying various transformations like *Aggregator,
Joiner, Connected and Un Connected lookup, SQL transformation, Un Connected
Store Procedure, Normalizer and XML parser *in developing code to
*Integrate,
Archive data *as desired by the organizations.
- *Created shortcuts* for source and target instances and mappings in
specified folders.
- Adapted *performance tuning* techniques to optimize ETL processes.
- Implemented proof of concepts on Hadoop Stack and different Bigdata
analytic tools, migration from different database ( i.e.
Teradata,Oracle,Mysql) to Hadoop
- Experience in *UNIX shell scripting* to locate files on server, make
record count and generate parameter files and emails.
- Collaborated with admin team to migrate code to different environments.
- *Involved in production support*, resolving the production job
failures, interacting with the operations support group for resuming the
failed jobs.
- Familiarity with V and *Agile* environments.
*TECHNICAL SKILLS**:*
*ETL Tools:* InformaticaPower Center
9.5/9.1/8.6/7.x,SalesForce,InformaticaCloud,InformaticaPower Exchange
5.1/4.7/1.7, Power Analyzer 3.5, Informatica Power Connect and Metadata
Manager.
*Databases:* Oracle10g/9i/8i/8.0/7.x,Teradata13,DB2 UDB
8.1, MS SQLServer 2008/2005, Netezaa 4.0 and Sybase ASE 12.5.3/15.
*Operating Systems:* UNIX (Sun-Solaris, HP-UX), Windows NT/XP/Vista,
MSDOS
*Programming *SQL, SQL-Plus, PL/SQL, UNIX Shell Scripting
*Reporting Tools:* Business ObjectsXIR2/6.5/5.0/5.1, Cognos
Impromptu 7.0/6.0/5.0,Informatica Analytics Delivery Platform,
MicroStrategy.
*Modeling Tools:* Erwin 4.1 and MS Visio
*Other Tools: *SQL Navigator, Rapid SQL for DB2, Quest Toad
for Oracle, SQL Developer 1.5.1, Autosys, SAS, Telnet, MS SharePoint,
Mercury Quality center, Tivoli Job Scheduling Console,JIRA
*Methodologies**:* Ralph Kimball.
*PROFESSIONAL EXPERIENCE:*
*Automobile Client, MI* *Jan14– Present*
*ETL Developer/Analyst*
*Responsibilities:*
· Worked with business team and architects to translate business
requirement into tech design.
· Worked on Power Center client tools like Source Analyzer,
Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations
Developer.
· Involved in Performance tuning for better performance.
· Participated in weekly end-user meetings to discuss data quality,
performance issues and ways to improve data accuracy and new requirements,
etc.
· Participated in Test Case walkthroughs, inspection meetings,
Interacted and worked with the Development and Data warehouse team to solve
the problems encountered in test execution.
· Participated in review meetings with Dev team to meet the testing
targets, Participated in daily status meetings to report any bugs, issues
and risks.
· Involved in Unit, System integration, User Acceptance Testing of
Mappings. Prepared complex SQL override scripts at source qualifier level
to avoid Informatica joiners and Look-ups to improve the performance as the
volume of the data was heavy.
· Responsible for the developing ETL process/Programs with
Informatica power center to extract data from client’s operational
databases Transform and filter the data and load it into target data base.
· Responsible for Creating workflows and worklets. Created Session,
Event, Command, and Control Decision and Email tasks in Workflow Manager.
· Provided application support to the data warehouse. Especially to
the portion of the data warehouse which I am responsible for.
· Created Perl scripts to generate Email Notifications and to load
data from different Source systems like flat files and Oracle databases
(ETL) and to schedule workflows.
· Created high-level Technical Design Document and Unit Test Plans.
· Documented Informatica mappings, design and validation rules.
*Environment: Informatica Power Center 9.5.1, Oracle 11g/10g, TOAD,
Business Objects XI3.5, Solaris 11/10, Teradata, clear case,** Tivoli Job
Scheduler*
*Blue Cross Blue Shield of Nebraska, Omaha, NE
**Nov
12 – Dec13*
*Sr. Datawarehouse Developer *
*Responsibilities:*
· Involved in Analysis, Requirement Gathering with business users
and Design process.
· Extracted data from flat files, VSAM, XML and RDBMS systems like
Oracle, Netezza, SQL server and DB2 systems.
· Developed number of complex Informatica mappings and mapplets to
implement business logic.
· Developed Informatica mappings by usage of Aggregator, SQL
Overrides in Lookups, filter in Source Qualifier, and data flow management
into multiple targets using Router transformations.
· Provided Production support for the production issues by
troubleshooting the session logs, bad files, tables and mappings.
· Data is migrated from Oracle database to Hadoop using Informatica
· Developed the Informatica scripts in order to populate the Global
repository from the local repository Worked with Scheduler to run the
Informatica session on daily basis and to send an email after the
completion of loading Conducted Unit testing and Integration testing
Analyzed the reliability, hypothesis and restriction in documentation of
the Functional, Technical and Architecture which are confidential.
*Environment:** Informatica Power Center 9.1.0/8.6.1 Oracle 10g, Hadoop
,SQL Server 2008, SAS, Toad, SQL Plus, SQL Query Analyzer, SQL Developer,
MS Access, Windows NT, Shell Scripting, Clear Quest, Tivoli Job Scheduler*
Name: Sai Reddy
Relocation: Open
Availability: Within 2 weeks
Visa: H1B
Rate: $55/hr C2C or best!
Com Skills: Excellent
Technical: Sound
F2F: Open but depends on schedule as candidate is on a project now and
looking for a project with better rate)
- 7 years of IT experience in *Design, Development *and* Maintenance* of
various software applications in client-server environment using Oracle
Technologies & *Data Warehousing* on Windows Platforms.
- Involved in all phases of *Software Development Life Cycle *(SDLC)
from Analysis, Design, Development, Test, Implementation, Documentation and
Support.
- Expertise in development of business applications using *Oracle
11g/10g/9i/8i, SQL, PL/SQL, Toad, **SQL***Loader.*
- Created database objects such as *Tables*, *Views*, *Synonyms,*
Indexes, *Sequences* and Database Links as well as Custom Packages
tailored to business requirements.
- Experience in the development of PL/SQL *Stored Procedures*,
*Functions*, *Triggers* and Packages to implement business logic.
- Good knowledge in front end development using *oracle
forms/reports6i/9i/10g*
- Experience in *developing forms* based on *views, tables and
procedures* in tabular and form layouts.
- Experience in developing both *web layout and paper lay out reports* in
various styles based on the user requirements.
- Worked with scripting languages like *JAVASCRIPT,* *HTML* and *XML*
- Excellent in writing *UNIX* and *LINUX *Scripts.
- Possess strong Documentation skill and knowledge sharing among team,
conducted data modeling.
- Extensive experience in working for different user groups, facilitated
common data models between different applications, participated in
requirement sessions to identify Logical entities.
- Experience in *UNIX*, Perl & *Shell scripting.*
- Experienced in *Performance Tuning *and *Query Optimization* using
Explain Plan and re-designing of poorly designed process flow of data.
- Experience in *Data Extraction*, *Transformation* and *Loading *(ETL)
processes.
· Experience in developing reports using Cognos 8 Report Net.
- Involved in programming, debugging, and unit and system integration
testing of modules.
*TECHNICAL SKILLS*
*Databases* Oracle 11g/10g/9i/8i, MS-SQL Server
2000/2005, Netezza 6.x, MS Access
*Scripting* SQL, PL/SQL, Shell Scripting, Perl
*GUI *TOAD, SQL*Loader, SQL Developer,
SQL* PLUS, Rapid SQL, Oracle
Forms 6i/9i/10g and Reports
6i/9i/10g
*Languages *C, C++, Visual Basic, Python
*Tools *ODI 11g/10g, Informatica 8.1, Cognos
*Data Modeling Tools *SQL Developer, Erwin
*Operating Systems * Windows 2k3/2k/XP, UNIX Sun Solaris4/5/7/8,
LINUX, HP-UX
*EXPERIENCE*
*Company: Healthcare Insurance
Norfolk, VA*
*Position: **Oracle Developer**
Mar** 2015-Present*
*Description: *
Client is dedicated to offering real solutions that improve health care
access and quality for its members, while proactively working to reduce the
overall cost of care to taxpayers. .
*Responsibilities:*
- Developed *PL/SQL stored procedures*, *functions*, *packages* and
package constructors to enforce business rules.
- Extensively used *Cursors,* *Ref Cursors* and *Exceptions* in
developing Packaged Procedures and Functions.
- Implemented complex Interface business rules using Oracle Database
*Triggers* constructs.
- Utilized *Partitions* to fine-tune SQL data load.
- Extensively used Indexes and Hints for better performance of queries.
- Optimized SQL and PL/SQL performance using Oracle utilities like *Explain
Plan*, *SQL-Trace* Analysis and *TK-Prof*
- Extensively wrote UNIX Shell scripts to automate the data load from
SQL *Loader to staging tables
- Created various *UNIX Shell Scripts* for scheduling various data
loading process. Maintained the batch processes using Unix Shell Scripts.
- Created relevant staging tables to load data, identified the business
validation rules.
- Created SQL Loader scripts using UNIX shell scripting and PL/SQL
- Build several *Unix Shell scripts* for PLSQL programs to schedule them
on *Control M*
- Implemented Data loading process using UNIX Korn shell scripts
resolved application issues in UNIX production environment. Read and
interpreted UNIX logs
- Implemented various automated UNIX shell scripts to invoke
PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
- Implemented various UNIX scripts to generate the data in txt, csv
format.
*Environment*: Oracle 11g, SQL, PL/SQL, SQL, PLSQL, SSIS, SSRS, CVS, TOAD,
UNIX Sun Solaris, Microsoft Visual Studio
*Company: Interval International
Coral Gables, FL*
*Position: Sr **Oracle Developer**
Jan** 2014- Feb 2015*
*Description: *
Interval International is a leading global provider of membership and
leisure services to the vacation industry. My role in the operational data
storage project as oracle developer is to develop packages to load and
integrate the data and several other processes from newly acquired Hyatt
Group Resorts.
*Responsibilities:*
- Involved in designing Data flow diagrams, Use case diagrams, Process
flow diagrams.
· Worked on Packages that enable the grouping of related PL/SQL
objects, such as *Procedures, Variables, Cursors,* *Constructors* *and
Functions*.
· Worked in *Operational data store* team that is responsible develops
processes and integrates the Hyatt resorts data from different sources.
· Involved in creation and updates of several SQL *packages* and
*Procedures*.
· Worked on *Triggers* to provide a way of executing PL/SQL code on
the occurrence of specific database events.
- Modified existing codes, PL/SQL packages to perform Certain
Specialized functions / enhancement on oracle Application.
- Loaded the data into database tables using *SQL*loader *from text and
excel files.
· Developed database objects like *Tables*, *Views*, *Indexes*,
*Synonyms* and *Sequences*.
· Create XML objects using Oracle functions for
*reservations*, *availability
*and* points calculator.*
· Used *Soap API* for testing the XML inbound and outbound *web
service calls.*
· Worked on *Form triggers* and *Built-in packages*.
· Used *PVCS* version control tool to manage source repository.
· Documenting *procedures* and *scripting*, and eventually be
drafting up them into *Unit test* plans.
· Used *RAPID-SQL*, *SQL-DEVELOPER, TOAD* developer tools for
faster application development.
· Tested the entire application with production data.
· Involved in production support and resolved many critical issues
by providing emergency cleanup scripts.
- Modified Forms on *PowerBuilder* (Windows Forms Application) to
accommodate new data entry fields and also modified the code to call newly
built objects.
- Utilize JIRA for bug tracking.
*Environment:* Oracle 11g, SQL Developer, SQL*PLUS, Rapid SQL, SQL Loader,
SOAP API, TOAD, Data Power, PVCS, UNIX Solaris, JIRA, Resort Solutions.
*Please reply with your interest ONLY TO k...@delightconsulting.com
<k...@delightconsulting.com> with complete Job details and we would be glad
to assist you. Thanks*
*Regards*
Santosh
Delight Consulting Services LLC.
2565 S. Rochester Road,
Suite# 107A,
Rochester, MI 48307.
Phone: 248-680-6684 ext 307
Fax: 248-498-6195
k...@delightconsulting.com
Note: We respect your Online Privacy.
This is not an unsolicited mail. Under Bill s.1618 Title III passed by the
105th U.S. Congress this mail cannot be considered Spam as long as we
include Contact information and a method to be removed from our mailing
list. If you are not interested in receiving our e-mails then please reply
with a "remove" in the subject line and mention all the e-mail addresses to
be removed with any e-mail addresses which might be diverting the e-mails
to you.
--
You received this message because you are subscribed to the Google Groups "SAP
BASIS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-basis+unsubscr...@googlegroups.com.
To post to this group, send email to sap-basis@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-basis.
For more options, visit https://groups.google.com/d/optout.
