SUMMARY

• Over 9+ years of experience in Information Technology including Data Warehouse/Data Mart development using ETL/Informatica Power Center.
• Excellent exposure in working with Microstrategy, Cognos and Datastage tools.
• Worked on various domains including Insurance, Finance, Banking, Pharmaceutical and Retail.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
• Worked in various Heterogeneous Source Systems like Oracle, DB2 UDB, Teradata, MS SQL Server, Flat files and Legacy systems.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good understanding of views, Synonyms, Indexes, Joins and Sub-Queries. Extensively used Cursors and Ref Cursors.
• Expertise in creating very detailed design documents and performing Proof of Concepts (POC).
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability.
• Experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
• Experience in developing ETL scripts using PL/SQL functions, stored procedures and packages.
• Providing the right level of data quality management for the appropriate business user.
• Experience in Data flux and Informatica Data explorer (IDE)/Informatica Data Quality (IDQ) tools for data Analysis / Data Profiling and Data governance and Data Quality using First Logic.
• Hands on experience in designing and developing ETL mappings and scripts using Informatica Power Center 9.1.0/8.6.1/8.0/7.1 using Designer, Repository Manager, Repository Server, Workflow Manager, Workflow Monitor, Operational Data Store(ODS)
• Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Testing, Production Support of Database/Data warehousing /Legacy applications for various industries using Data Modeling, Data Extraction, Data Transformation and Data Loading.
• Extensive experience in Tuning and scaling the procedures for better performance by running explain plan and using different approaches like hints and bulk load.

TECHNICAL SKILLS

ETL/BITools: Informatica Power Center 9.1.0/8.6.1/8.0/7.1 , Microstrategy, Cognos, Datastage

Databases: MS SQL Server 6.5/7/2000/2005/2008 , Oracle 8.1/9i/10g/6.0, MS Access, MySQL

Query Tools: Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Modeling Tools: Erwin 4.0, ER studio

Languages: Siebel script/VB Script, Java, JavaScript, C, C++, HTML, Visual Basic, ASP, XML

Project Management tools: Microsoft Project Server.

GUI: Siebel Versions 6.0.3/7.5.3/7.8

Reporting Tools: Business Objects, OBIEE and Business Intelligence

Others: Visual Source Safe, Heat, MKS Tool kit

Operating Systems: Windows (NT, 95, 98, 2000, 2007), Windows XP, Windows 7, MS DOS

PROFESSIONAL EXPERIENCE

Confidential - Chicago

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Extracted source data using power exchange from legacy systems.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Extensively used PL/SQL to embed complex business logic in stored procedures
• Developed Informatica sessions and workflows for all mappings.
• Used mapping parameters and variables.
• Automated the load process using UNIX shell scripts.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Developing UNIX scripts and PERL scripts for pre data manipulation.
• Supported migration of ETL code from development to QA and then from QA to production

Environment: InformaticaPower Center 9.1,InformaticaPower Connect, Flat files, XML Files, Oracle 10g/9i, MS SQL Server 2000, Shell Programming, SQL * Loader, Toad, Excel and Unix scripting, Sun Solaris, Windows XP, Tidal

Confidential - Watertown, Boston

Responsibilities:

• Analyze requirements provided by various business users.
• Create Source and Target Definitions in the repository usingInformaticaSource Analyzer and Warehouse Designer.
• Identify source systems, connectivity, tables, and fields to ensure data suitability for mapping.
• Created different levels of stored displays to help different groups, users and executives to easily understand the data model according to their requirements.
• Collection of data from source systems into database.
• Using Report Builder Template built model reports in HTML, Text, and RTF format
• Implemented Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Periodic documentation of reverse/forward engineering versions after changes to the structures within the database.
• Involved in ensuring security in Framework Manager and Transformer
• Developed Multidimensional Cubes using Transformer.
• Developed Dashboards, Complex Reports having many calculations, child reports, HTML items etc. in Report Studio
• Design, develop and documentInformaticamappings as per the requirements.
• Extensively created mapplets, common functions, reusable transformations, look-ups.
• Created and implemented PRE/POST scripts at both schema and table level.
• Implement the error handling and exception reporting as per the user requirements.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets

Environment: InformaticaPower Center 9.0,InformaticaPower Connect, Flat files, XML Files, Oracle 10g/9i, MS SQL Server 2000, Shell Programming, SQL * Loader, Toad, Excel and Unix scripting, Sun Solaris, Windows XP, Autosys

Confidential

Responsibilities:

• Worked on a total of 70 mappings, 10 stored procedures.
• Develop, test and maintainETLprocedures employing bothETLtools and custom PL/SQL
• Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
• Performed production support duties on a 24/7 basis.
• Involved in business requirements gathering to enable Data Integration across all business groups.
• Extensively used PL/SQL to embed complex business logic in stored procedures.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Implemented logic to control job dependencies between ETLs solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.
• Used most of the transformations such as the Connected & Unconnected lookups, Filters, Routers, Joiners, Stored Procedure transformations & Sequence Generators.
• Worked on making session runs more flexible through the use of mapping parameters and variables and used parameter files and variable functions to manipulate them.
• Configured the mappings to implement Slowly Changing Dimensions (Type-2).
• Defined Target Load Order Plan and Constraint based loading.
• Wrote DOS scripts to merge files, append timestamp to filenames and move files.
• Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.
• Implemented entireETLjob plan (50 jobs) through Informatica Scheduler.
• Formulated procedures and policies required for data management, processing and quality assessment functions
• Made sure to upkeep the organizational data and prevent it from tampering, alterations etc
• Ensured that the data complies with the user needs and expectations as per quality and authenticity
• Training staff members on quality assessment techniques and quality maintenance skills

Environment: Windows 2000, Informatica Power Center 9.0,Tera Data 13.x,SQL Server 2008, Oracle 9i, SQL Server, SQL*Plus, TOAD, IBM Rational Clear Case versioning tool.

Confidential

Responsibilities:

• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Designed Sources to Targets mapping using Informatica Power Center for their Claims department. Created Reports using Business Objects.
• Conducted design review meetings with the architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Used MS-Visio to populate the Informatica design flows.
• Assisted in Informatica Administration using Repository manager.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.
• Well versed with Informatica Team based development (Versioning)
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Wrote complex SQL queries to test the data generated by ETL process against target data base.
• Used Golden and also Toad to access the Oracle tables execute SQL queries.
• Designed complex mappings involving target load order and constraint based loading.
• Performance tuning, bug fixing and error handling.
• Created parameter files for the all the designed mappings and used parameter files for defining all the connection values (Source, Target, Lookup) and mapping parameters used in the Informatica sessions.
• Used Delta loading to extract New Claims in Informatica and processed the data and loaded the target data to Oracle tables.
• Used BO for reporting purposes.
• Designed Technical documents, ETL Unit test plan document, Migration Check list document.

Environment: Informatica Power Center 8.1/8.6, (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Business Objects XI, Oracle 11g,SQL Server 2008, Erwin 4.5, Oracle 10g/9i, MS Visio, Windows, ICD / CPT codes

Confidential

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Created Functional Design documents and Technical design Specification and mapping specifications documents for ETL process based on the requirements.
• Migrated and Stored reformatted data form relational, flat file, XML files usingInformatica.
• Designed and developed ETL process usingInformaticaPower Center
• Created common objects in shared folders for the ETL team to maintain the common code.
• Created mappings, mapplets and reusable objects for ETL Process.
• Used parameters and variables in the mappings and sessions
• Used workflow manager to create sessions, Worklets and Workflows.
• Involved in Performance tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Involved in Code migration and merging from development environment to integration and production environments
• Created documents forInformaticaconfiguration, workflow migration and impact analysis for database changes
• Involved in scheduling and monitoring the ETL jobs in development, QA and Production environments
• Supported the Quality Assurance team in testing and validating the data.

Environment: InformaticaPower Center 8.5/7.1, Oracle 10g, MS SQL Server 2005, SQL, T-SQL, Toad, SQL*Loader, UNIX, Windows 2000/NT

Confidential

Responsibilities:

• Designing & implementing the architecture and guiding in design & development of the project.
• Responsible for building the ETL and Database environments.
• Responsible for providing the technical leadership during crucial, early phases of a client initiative, focusing particularly on requirements gathering, technology selection, developing prototypes, proof of concepts and initial system design.
• Responsible for recommending appropriate tools at various phases of the project and for quality of design and deliverables.
• Responsible for setting up, supporting & administering the tools and controlling the access through security roles.
• Gather and analyze the feasibility of business requirements from customer.
• Responsible for providing the technical guidance & support to the team throughout the development process.
• Responsible for conducting various team meetings such as weekly team meetings, Look Ahead Meetings, Release plan meetings etc.
• Coordinating with onsite team for any clarifications during the development of the scripts
• Reviewing the deliverables by the team and providing review comments to ensure defect free deliverables.
• Identifying and resolving issues in the development scripts by the team.
• Improve the performance of the scripts by finding out the bottle necks in the scripts and resolving the issues with them.
• Requirements gathering and analysis of the difficult and complex objects.
• Build the ETL scripts for critical & complex objects such as Task Lists & Maintenance Plans.
• Ensure proper data transformation and zero issues post data load.
• Responsible for tracking & reporting of the work from offshore and inform the management.
• Participate in change control board meetings.
• Do impact analysis for the architecture change requests.
• Ensure the compliance of the project for various organizational quality & security standards.
• Complete responsible for delivery of the qualitative and defect free work products from offshore.
• Developed the Excel based reusable component to generate SAP Ready flat files from the database directly and saved huge development effort

Confidential

Responsibilities:

• Worked onInformatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources transformed and loaded into Data Warehouse Targets usingInformatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing ofInformatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on theInformaticaServer usingInformaticaServer Manager/Workflow Manager.
• Used UNIX cron jobs to schedule the sessions to automate the update process in the workflow manager
• Worked closely with the reporting teams to design the Data mart which was further used by SAS team to customize reports as per business requirement
• Worked with different sources such as Oracle, MS SQL Server and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Optimizing the mappings by changing the logic to reduce run time

Environment: Oracle, Cogno’s BI, SQL Server 2005,InformaticaPower center, MS Access, VB Macros, Business Objects Reporting

Confidential

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Extracted source data using power exchange from legacy systems.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Designed and Developed ETL logic for implementing CDC (change data capture) by tracking the changes in critical fields required by the user.
• Developed Informatica sessions and workflows for all mappings.
• Used mapping parameters and variables.
• Automated the load process using UNIX shell scripts.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Developing UNIX scripts and PERL scripts for pre data manipulation.
• Responsible for regression testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then from QA to production.

Environment: Informatica Power Center 8.1, Teradata: V2R5, Erwin, TOAD, PL/SQL, Oracle 10g and UNIX Scripting.