SUMMARY

• An accomplished IT Analyst with over seven (7) years of IT experience in Data Warehousing and Business Intelligence Technology.
• Exposure to multiple industry domains like Banking and Finance, P&C Insurance and Media.
• Good knowledge of Data Warehouse concepts and principles.
• Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, and support.
• Extracted the data from different sources like Netezza, DB2, Oracle, and Flat files.
• Worked on Unconnected Lookup, and Transaction Control transformations, and incremental loading using Mapping Variables.
• Experience in identifying bottlenecks in ETL processes and performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Unit testing for validating the data to meet Business requirements.
• Comprehensive knowledge and experience in Agile BI - Scrum Methodology.
• In Cognos, I worked on conditional formatting, static choice prompts to provide user friendly interfaces.
• Worked on creating drill through between reports, master-detail reports using the Report Studio.
• Provided L2 support for various applications, understanding end user’s requirement and validating them.
• Issues raised by the end users were closed on priority basis by working closely with collaborative teams.
• Acquired in depth knowledge about client business.
• Have a proven track record of providing quick solutions to business functionality, resolving defects with use of innovative ways and can guide/mentor team members.
• Developed Aggregated reports, Detailed reports, Grouping reports, Grand Total summary reports by using Crystal Reports.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Good Communication skills and a team player.

TECHNICAL SKILLS

Languages: C,C++,PL/SQL

Operating System: UNIX (Sun Solaris 2.x, HP/UX), Win 95/NT/98/2000/XP

GUI: Squirrel and TOAD

Database: Oracle 8i

ETL Tools: Informatica 8.x, 9.x.

Reporting Tools: Cognos, Crystal Reports.

Data Bases: DB2, Netezza and Oracle 11i/10g

Scheduling Tools: Control-M

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

ETL Developer and Offshore Lead

Responsibilities:

• Attend Daily Agile Scrum meetings.
• Analyze the business requirement document share by bureaus and preparing design documents.
• Interact frequently with the business to understand the requirement and rules specified for entire report.
• Use various transformations like Source Qualifier, Aggregator, Joiner, Lookup, Router, Filter, Expression and Update Strategy, Sequence Generator.
• Create Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Work on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Identify performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Schedule jobs in Control-M scheduler.
• Heavily use Unix Scripting to generate each Parm file specific to a job which helpful in fixing any issues faced during Prod Parallel testing.
• Responsible of ensuring that production parallel runs of all the reports developed ran properly and validated in the warranty phase of each project.
• Created an automation technique called RECON validation which was responsible to reconcile all the data based on KEY level, Amounts levels (both Premium and Loss) to match to the source systems.
• Collaborate in Knowledge Sharing session to Operations & Maintenance Team.
• Involved in the task plan for ETL developers for a specific project and is responsible for reviewing all coding done by offshore.
• Actively involved in Peer Programing and brain storming on issues faced during development phase of the report.
• Create and Configure Workflows and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.
• Involved in Analysis and representing from offshore.
• ETL development and supervise and guide ETL development activities of other developers
• Work closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies on other teams
• Use Informatica PowerCenter Designer to analyze the source data to Extract & Transform from various source systems (DB2, Netezza and flat files) by incorporating business rules using different objects and functions that the tool supports
• Use Informatica PowerCenter to create mappings and mapplets to transform the data according to the business rules.

Confidential, Phoenix, Arizona

ETL Developer

Responsibilities:

• Understand requirements and preparation/review of High level, Low level design documents and technical specification documents.
• Enhancement of Daily and Historical workflows according to the requirements.
• Create mappings using Informatica PowerCenter Designer 8.6, as per ETL specification document.
• Integration of various data sources like Netezza, DB2 and flat files into staging area.
• Implement best practices, tuning and optimization for ETL code.
• Involved in developing in ETL Overview Document which has all the job details and utilized the recovering process whenever job fails which would be later extensively used by the Operations & Maintenance team.
• Design and develop the logic for handling slowly changing dimension table loads by flagging the record using update strategy for populating the desired.
• Perform Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Analysis of the specifications provided according to the requirement.
• Preparing Informatica Case Studies.
• Giving training to peers by using case studies.
• Responsible for supportingand fixing problems in Production, UAT.

Confidential

Assistant Systems Engineer

Responsibilities:

• Develop Mappings using Aggregator, Expression, Filter, Router, Joiner, Rank and Sorter Transformations.
• Create transformations unconnected lookup and mappings using Informatica PowerCenter and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Integration of various data sources like Oracle, SQL server, DB2 and flat files into staging area.
• Analysis of the specifications provided according to the requirement.
• Prepare Informatica Case Studies.
• Give training to peers by using case studies.
• Responsible for developing differenttypes of reports by using Crystal Report.
• Responsible for supportingand fixing problems in Production, UAT and System testing.

Confidential

ETL Developer

Responsibilities:

• Create, run, and monitor workflows.
• Develop mappings using Source Qualifier, Filter, Sorter, Router, Aggregator, Joiner, Lookup, Sequence generator, Update Strategy transformations.
• Create transformations Transaction Control, unconnected lookup and mappings using Informatica Power Center and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Provide L2 support for various applications, understanding end user’s requirement and validating them.
• Issues raised by the end users were closed on priority basis by working closely with collaborative teams.
• Analysis of the specifications provided according to the requirement.
• Undergone training on Cognos.
• Responsible for coordinating onsite and offshore team.
• Production support activities.
• Develop List Reports, Cross-tab Reports, Chart Reports and Master Detail Reports using Report Studio Project.
• Develop Query Prompts, Calculations, Conditions and Filters in the reports.
• Develop List reports, Cross tab Reports with drill through functionalities.
• Design the reports model using Cognos Framework Manager.
• Design reports with conditional formatting using different styles.

Confidential

ETL Team Member

Responsibilities:

• Create Mappings and writing the test cases.
• Execute Test cases.
• Performance monitoring of the job.
• Follow up with the concern team for incident and defect raised.
• Documentation of the design.
• Conduct reviews for design.