SUMMARY:

• 10+ years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing and testing.
• Over 6 years of Technical and Functional experience in Decision Support Systems - Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.1/8.6,
• Over 5 years of experience of leading multiple ETL projectsof team members between 5-10 members.
• Experience in UNIX shell scripting (file validations, file downloads, workflow executions).
• Good knowledge in interacting with Informatica Data Explorer (IDE), andData validation Option (DVO)
• Have worked in multiple projects acrossRetail, Insurance, Investment domainsat various client locationsin United States America.
• Experienced in writing design documents, validating requirement, perform code review, code tuning
• Worked on both waterfall model as well as agile methodology projects.
• Worked on tools like QC for defect tracking.
• Involved in24*7 production supportfor ETL job runs and reporting.
• Experience in writing Testing scripts & scenarios based on Functional & Business requirements and solution design.
• Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.
• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Worked with the team to ensure deliverables on time.
• Presented WSR/MSR reports to client for effective effort tracking.
• Effectively participated in code verification.
• Involved in training the trainee graduates in the technology and project perspective.
• Preparing the project traceability matrix tracking the project status inline to the estimates.
• Trouble shooting of long runningsessionsand fixing the issues.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scriptsfrom development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved inproduction support. Implementedfixes/solutionsto issues/tickets raised by user community.
• Modified theshellscripts as per the business requirements.
• Maintainednaming standards and warehouse standardsfor future application development.
• Used Workflow Manager for creating, validating, testing and running thesequential and concurrentsessions.
• Preparing ETL mapping Documents for every mapping andData Migrationdocument for smooth transfer of project from development to testing environment and then to production environment.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Tech Lead

Responsibilities:

• Confidential sells Encompass Insurance branded property and casualty products exclusively through Independent Agents.
• In the current environment, the independent agent facing reports are obtained from a variety of source data stores. Among them, Independent Agent Enterprise Data Warehouse (IAEDW), Actuarial Data Mart (ACTM) and Agency Data Mart (ADM) are the primary sources for most of the information. There are also significant, localized reports maintained at the business unit level. Thus exists a disparate reporting environment supported by a variety of underlying technologies, leading to multiple versions of truth.
• The recently concluded analytics and reporting strategy and data design project at Encompass had laid out a roadmap to consolidate the reporting environment and provide access improvement.
• The scope of this project will be to Build & Implement the Agency Data Mart.

Informatica Tech Lead and Developer

Confidential

Responsibility:

• Requirement gathering, designing (Technical Design) ETL interfaces, reviewing mapping design by team members as well as leading the team in coding, testing, performance tuning in developing Informatica mappings and workflows, production migration and providing stabilization support.
• Admin related activities, Requirement gathering, preparing detailed design documents, check-in sheets, reviewing mapping design by team members, testing, production migration and providing stabilization support.
• This project was to migrate old legacy (PL-SQL) code to newInformaticacode to generate 29 incremental extracts (daily/weekly) mainly for order management/commerce related data from newly build ATG-10 and Sterling database for third party of the client for loading into their e-commerce data marts. Since source system building was also in progress parallel hence it made it more challenging with day to day requirement changes. Source was Oracle11g and target as flat files.

Confidential

Informatica Developer

Responsibilities:

• Analyze the specifications and identify source data, which needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Implemented Slowly Changing Dimension type2 methodology for accessing the full history of accounts and transaction information.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used Debugger to check the data flow in the mapping and made appropriate changes in the mappings to generate the required results.
• Developed mappings to load data in slowly changing dimensions.
• Created Sessions in workflow manager and monitored it using workflow monitor.

Confidential

Informatica Developer& Production support

Responsibilities:

• Involved in gathering the business requirements and converting them in to the technical specifications required for the conversions team.
• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files (excel/access) to Oracle.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Created the Tivoli Job flow and dependencies document and coordinated with production support to get the job flows created and scheduled as per the requirement.

Confidential

Sony Electronics

Responsibilities:

• Handling operations as a Data Analyst with prime responsibilities of data profiling through usage of Informatica; data analysis for inference of business rules from the available data and make recommendations for data quality.
• Interacting with user to understand the data importance and creating rules document for providing to developers for design the code.