SUMMARY

• 8 years of experience in IT field, providing technical services to wide range of customers based on their business requirements.
• Experience in all aspects of Project Development Life Cycles including Requirements gathering, Analysis, Design, Development, Testing, Implementation and Support.
• Extensive experience in ETL Projects with expert Data Analysis Skills along with good knowledge in Data Warehousing Concepts.
• Comprehensive hands - on experience in analyzing, designing & developing ETL Mappings using Informatica PowerCenter 9.1/8.x(Workflow Manager, Workflow Monitor, Power center Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, and Informatica Server).
• Experience in working with various Databases like DB2, Oracle, and Teradata.
• Comprehensive hands-on experience in writing complex SQL Queries mainly for Data Analysis, Data Extraction & Data Validation.
• Extensive experience with Data Extraction, Transformation, and Loading from data sources like Flat Files & Databases for Data Integration and Reporting.
• Having Business Intelligence experience using Business Objects 5.X/XI R2.
• Experience in Effort Estimations (based on SDLC), Planning (back out, Contingency etc.) & Execution of projects.
• Provided mentoring, training and guidance to other team members. Have experience of working in Onshore - Offshore Model.
• Experience in handling teams and also aids in scaling them versatile.
• Proficient in understanding business processes / requirements and translating them into technical requirement specifications.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and from QA to Production server.
• Good Experience in creation of Quality related documents (Function specification, High Level and Low Level design, and Unit Test Case documents).
• Self-Starter who can adapt and learn fast with excellent analytical & problem solving skills along with good communication skills.
• Interested in taking up challenging tasks and to learn new technologies.

TECHNICAL SKILLS

DW/BI Tools: Informatica PowerCenter 8.5/8.6/9.1, Business Objects 5.X/XI R2

Databases: DB2, Oracle 10g/11g, Teradata

DB Tools: TOAD, SQL Developer

Scripting Languages: UNIX Shell Scripting

Scheduler: TWS, DAC, Control M

Operating System: Windows 2000/2003/2007/ XP

Other clients: Putty, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Technology Lead

Responsibilities:

• Involved in gathering requirements from business team based on the Technical Design Document and prepared the project layout.
• Worked on developing the Informatica mapping to extract data from OLTP system to Staging area and applied given complex logic ( using Source Qualifier, Router, Filter, Connected and unconnected lookup, update strategy, applet etc.) to load into OLAP.
• Worked on creating SCD Type 1 and Type 2 mapping.
• Involved in preparing unit test plans and test cases, end to end testing.
• Worked on complete project life cycle project planning, requirement gathering, Analysis, Build, Test, Production Implementation.
• Worked on fine tuning the query using Hints to improve performance of long running query.
• Involved in creating UNIX scripts to validate Nonfunctional requirements when using flat file as source.
• Worked on creating execution plan, Subject area, tasks In DAC
• Created Design document, Project support documents and warranty document for the transition team.
• Worked on preparing estimation plan for the given change request by the users.
• Lead team and assisted them in critical situations and provided extendable support.
• Involved in creating the application support and other transition documentation to Support team.

Environment: Informatica PowerCenter 9.1, UNIX Shell Script, Data warehouse Administration Console (DAC), Oracle 11g, Putty, TOAD

Confidential, Minneapolis, MN

Technology Lead

Responsibilities:

• Primarily responsible to make sure the business is not impacted in case of any failure in the system.
• Worked along with multiple cross commit teams in handling and implementing severity one issues during crisis situation in a stringent timeline.
• Involved in project design gatherings and provided valuable ideas based on the customer needs and requirements.
• Worked on the enhancement projects followed SDLC process which includes Requirement gathering, Analysis, Design, Build, Test, Implement, Maintain the project
• Followed best Practices & Tuning tips while designing mappings and work flows resulting in efficient and quality products.
• Involved in analyzing the data and providing fix to the production issues in a given stringent time line.
• Worked on improving the performance of the mapping by making sure code follows the mapping build standards and also addressing mapping, session bottle necks. E.g. Use Sorter before Aggregator/Joiner transformation for better performance. And make sure to check the SORTED INPUT check box. Session - Run session on Grids.
• Worked with different tasks like Command, Email etc.
• Worked on SQL Developer for Database activities.
• Extensively worked on creating UNIX scripts to check Nonfunctional requirements.
• Created customized job streams, jobs and its dependencies to run on a customized calendar
• Involved in preparing the test plans and testing the code end to end.
• Worked on the estimation plan for the given change request by the users.
• Handled offshore team and provided extensive support in most critical scenarios.
• Involved in creating the application support and other transition documentation to Support team.
• Effectively maintained multiple projects at a given span of time.
• Involved in creating the ETL management page in Confidential wiki page.

Environment: Informatica PowerCenter 8.5/9.1, UNIX Shell Script, IBM TWS, Control M, Oracle 10g/11g, WinSCP, SQL Developer

Confidential, Fort Worth, TX

Senior Developer

Responsibilities:

• Analyzed functional specifications and identified the source data that needed to be pulled on to the report.
• Participated in the Design Team and user requirement gathering meetings
• Involved in enhancing report using Alphablox reporting tool based on changing needs and incorporated identified factors.
• Involved in analyzing reports of corporate Dashboard.
• Worked on java and java scripts to develop reports.
• Involved in writing the query in Mainframe for analyzing data.
• Worked on creating Design Documents and other support documents.
• Involved in testing the reports and made sure the business requirements are incorporated.

Environment: Teradata, Essbase, Alphablox, Java, Mainframe

Confidential, Houston, TX

Developer

Responsibilities:

• Involved in preparation of the required application design documents based on functionality needed.
• Based on the requirements, used various transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner and Sequence Generator in the mapping.
• Developed Reusable Transformations and tasks for reusability.
• Involved in peer and end to end testing of the code to verify/ validate code meets its standards and requirements.
• Involved in writing the test cases to test the code for both positive and negative cases.
• Involved in ordering and scheduling jobs in Control M

Environment: Informatica PowerCenter 8.5, Control M, DB2, Netezza

Confidential, Rhode Island, TX

Developer

Responsibilities:

• Participated in the Design team and user requirement gathering meetings
• Involved in Modifying report based on changing needs and incorporated them into the existing reports.
• Involved in testing the reports to ensure it meets the business requirements.
• Involved in scheduling the reports

Environment: Business object XI R2

Confidential, Houston, TX

Developer

Responsibilities:

• Involved in analyzing Reports for any data discrepancies and customized reports based on the business needs.
• Worked on altering the design document.
• Involved in preparation of Impact Analysis document.
• Involved in preparing the Unit test Plans and test cases for positive and negative scenarios.
• Involved in testing the reports against the given requirement specifications and also provided UAT support.
• Worked on new enhancement of the report.
• Involved in creating BO universe classes and objects.
• Involved in Code Set up and migration to testing environment.
• Involved in Mentoring to new joiners and maintaining offshore-on site coordination

Environment: Business object 5.1.8/XI R2, MS Access, DB2