SUMMARY

• ACI certified Accredited Scrum Master (ASM) with expert working noledge of both waterfall and agile methodologies in software development life cycle.
• Over 9 years of experience in Analysis, Design, Development and Implementation of Data warehouse applications in various roles like SME, Team lead and Project lead.
• Extensive Data Warehousing experience in designing and creating mappings using Informatica Power Center 9.5.1/9.5.0 /8.6/7.1.3/6.1.2 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Expertise in implementing the business rules by creating transformations like (Expression, Joiner, Source Qualifier, Filter, Aggregator, Lookup, Router, Update Strategy, Router, SQL transformation etc), and developing mappings.
• Solid experience in all phases of Data warehouse life cycle involving design, development, analysis & testing of Data warehouses using ETL and Data Modeling.
• Extensive experience using Informatica,DB2, Oracle 10g/9i/8i, SQL,SQL Server, PL/SQL, UNIX Shell Scripting, Windows 95/98/2002/2003/2008 , Windows NT/XP.
• Expertise in designing Relational Database Model, Client/Server applications and creating various SQL server objects like Tables, Indexes, Indexed Views, Stored Procedures and Functions.
• Worked with cross functional teams such as QA, DBA to deploy the code from development to QA and QA to Production
• Excellent communication and interpersonal skills. Committed and Motivated team player with good Analytical skills.
• Highly competent in quantitative and qualitative analysis and critical thinking.
• Good understanding of the different work/behavior styles.
• Experienced dealing with outsourced technical resources and coordinating global development efforts.
• TEMPHas a strong ability to articulate and present complex technical concepts so dat business users can realize the value of these technologies.
• Self - reliant and quick to identify and understand business problems and develop solutions.

TECHNICAL SKILLS

OLAP tools: Cognos Report net, Cognos Impromptu

RDBMS: Oracle 8i, 9i, 10g, Teradata SQL Assistant

Data Modeling Tools: Microsoft Visio Professional

ETL tools: Informatica 7.1.3/8.1, 9.5.1/9.5.0 , Informatica Power Exchange 8.6.1

Operating Systems: Windows XP/2000/NT

Languages: Oracle SQL, DB2,SQL Server, PL/SQL,UNIX Shell Scripting,Teradata SQL

Other Tools: TOAD,SQL Developer

Scheduling Tools: Autosys,CA-7,Control-M & Autoflow

Software Development Skills: Worked on all the phases of Project Life Cycle i.e. Requirement Analysis, Design, Implementation and Testing in various projects.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

ETL Team Lead/Developer

Responsibilities:

• Involved in gathering requirements, development of design and mapping documents.
• Worked with a group of Business Analysts, DBA, Architects and other senior developers to review and analyze the ETL requirements and develop the data migration plan according to company’s methodology in line with the risk management strategy.
• Worked on project estimates, delegation of tasks and duties as well as signed off on all designs and reviews.
• Created target-source matrices and made sure dat all the transformation logics were included.
• Done the Data Assessment to find out the orphan records by working on the database and created the document by looking with Logical Design Model to find out orphan records when database is not set up for RI. Appreciated by the Client for dis effort for capturing the counts in very short time.
• Done Data Assessment on all tables and columns (character and varchar columns) by developing Macro-enabled worksheet which executes 97536 queries to check the existence of special character(193 characters).The output of these queries will be the counts of record having the special characters in the column .The counts are needed to assess the life data. Ran the data assessment using crontab.
• Card Source data is complicated in such a way the data stored in application. All Name, Address, phone are all free format fields and all these needs to be parsed to get the details from the Client database. Worked on the assessment on different Phone formats and validating with Business SMC’s.
• Used the debugger to find out which transformation is causing the error usually by passing just one record from the Source Qualifier.
• Designed and developed complex mappings using various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy and Router etc. to load data and effectively used debugger for identifying errors and resolving them.
• Created mappings and generated the Report to find the mismatch data and reported to SMC’s and Business Analysts to correct the data when their are data issues
• Designed and developed workflows for all load process.
• Created parameter files for running migration workflows/session.
• Debug the mappings and validate the data in the target tables once it was loaded.
• Preparation of test cases and test plan.
• Involved in tuning of mappings for better performance and efficiency and also implemented partitioning to enhance the performance tuning procedures.
• Worked on bug fixes on existing mappings to produce correct output.
• Working with various relational, flat file (fixed width, delimited) data sources.
• Created Jobs in Control-M as well as Scheduling jobs.

Environment: Informatica Power Center 9.1.0, Informatica Power Exchange, Windows XP, UNIX, Teradata, Control-M 8.0, Tortoise SVN.

Confidential, Bloomington, IL

ETL Team Lead

Responsibilities:

• As a ETL Lead, understand the business and functional design to enable correct integration of the module with overall system design.
• Worked closely with the business and business analysts to properly define requirements and deliverables.
• Define Informatica ETL Strategy and design a low level.
• Prepared technical document for each functional unit.
• Development and Unit Testing of Informatica components.
• Designed and Developed the ETL Load Strategy Documents.
• Involved with the Architects in finalizing the load sequence of the created ETL objects.
• Designed the ETL Mapping Documents for development team members for their implementations.
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet designer, and Transformation designer.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others.
• Designed and developed the Workflows for all load process.
• Design and development of SQL scripts.
• Suggested changes to the Physical Data Warehouse Model based on the ETL and Referential Integrity gap requirements.
• Developed Informatica mappings & tuned them for better performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Carry out high level and low level ETL Design to extract the data from mainframe, oracle and build the DataMart in Oracle.
• Monitored the daily load data progress and gave team updates on a daily basis.
• Scheduling of the jobs using CA-7
• Preparing Test cases and test data for Unit testing
• Reviewing the Code changes as per the development checklist and Informatica standards
• Designed and developed workflows for all load process.
• Created parameter files for running migration workflows/session.
• Debug the mappings and validate the data in the target tables once it was loaded.
• Preparation of test cases and test plan.
• Involved in tuning of mappings for better performance and efficiency and also implemented partitioning to enhance the performance tuning procedures.
• Worked on bug fixes on existing mappings to produce correct output.
• Working with various relational, flat file (fixed width, delimited) data sources.

Environment: Informatica Power Center 9.5.1, Informatica Power Center 9.1.0, IBM Data Studio 3.1.1, Windows XP, UNIX, SQL Server, FINEOS.

Confidential, Cleveland, Ohio

Module Lead/ETL Developer

Responsibilities:

• Requirement gathering and understand the business needs.
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Implemented Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Extensively used ETL and Informatica to load data from Excel spreadsheet, flat files and XML files into the target Oracle 9i database.
• Extracted the data from the oracle database into a flat file.
• Developed Informatica mappings & tuned them for better performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Responsible for creating the DATA MAPS, extracting CDC data from Mainframe sources, exporting and updating them to the Repository, importing the required source files on to the staging environment by using Informatica Power Exchange.
• Used Informatica Designer to import, edit the metadata of sources and targets.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user’s privileges.
• Involved in ETL process under development, test and production environments.
• Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet designer, and Transformation designer.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Designed and developed the Workflows for all load process.
• Design and development of SQL scripts.
• Suggested changes to the Physical Data Warehouse Model based on the ETL and Referential Integrity gap requirements.
• Developed Informatica mappings & tuned them for better performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Monitored the daily load data progress and gave team updates on a daily basis.
• Preparing Test cases and test data for Unit testing
• Reviewing the Code changes as per the development checklist and Informatica standards

Environment: Informatica Power Center 8.1, Oracle 10g, TOAD, Windows XP, Oracle 11i, PL/SQL, SQL, WinSCP, UNIX.

Confidential, Chicago, IL

Module Lead/ETL Developer

Responsibilities:

• Involved in gathering requirements and created design and mapping documents.
• Worked with a group of Business Analysts, DBA, Architects and other senior developers to review and analyze the ETL requirements and develop the data migration plan according to Company s methodology.
• Created target - source matrices and made sure dat all the transformation logics were included.
• Created mapplets for complete target-source matrices.
• Designed and developed complex mappings using various transformations like JoinerAggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc. to load data and effectively used debugger for identifying errors and resolving them.
• Extensively used transformations like Stored Procedures which were called to generate the sequence for the primary key in many tables. Also used stored procedure transformation to insert every incoming row into the error table if a certain condition is not satisfied.
• Worked with Oracle SQL Developer to analyze the data and perform various DDL, DML functions.
• Used the debugger to find out which transformation is causing the error usually by passing
• Just one record from the Source Qualifier.
• Extracted the data from the files Infoman, Clarity, PTM.
• Debug the mappings and validate the data in the target tables once it was loaded.
• Preparation of test cases and test plan.
• Involved in tuning of mappings for better performance and efficiency and also
• Implemented partitioning to enhance the performance tuning procedures.
• Worked on bug fixes on existing mappings to produce correct output.
• Worked on moving the code from development into QA and Production using the tool CA7.
• Playing a key role in managing the off-shore team and assigning tasks to the off-shore team on daily basis.

Environment: Informatica Power Center 7.1.3, Oracle 10g, SQL, Windows 2000.

Confidential, Tampa, FL

Technical Lead

Responsibilities:

• Requirement gathering and understand the business needs.
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Implemented Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Extensively used ETL and Informatica to load data from Excel spreadsheet, flat files and XML files into the target Oracle 9i database.
• Created Informatica mappings to build business rules to load data. Used most of the transformations such as the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
• Extracted the data from the oracle database into a flat file.
• Developed Informatica mappings & tuned them for better performance.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Responsible for creating the DATA MAPS, extracting CDC data from Mainframe sources, exporting and updating them to the Repository, importing the required source files on to the staging environment by using Informatica Power Exchange.
• Used Informatica Designer to import, edit the metadata of sources and targets.
• Imported, created and edited the table definitions using Informatica Designer. Used repository manager to create folders and managed the user’s privileges.
• Involved in ETL process under development, test and production environments.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.

Environment: Informatica Power Center 7.1.3, UNIX, Oracle 9i, SQL, PL/SQL, Autosys, Informatica Power Exchange 8.6.1.

Confidential, TX

Technical Lead

Responsibilities:

• dis is completely production support project, mostly worked on enhancements and monitoring production jobs.
• Understanding the requirements of customers.
• Understanding database design schemas for different sources.
• Used Informatica as an ETL Tool to extract data from source systems to Target systems
• Providing implementation support.
• Involved in automation of manual jobs using UNIX shell scripts to reduce manual intervention.
• Played a Key Role in managing the off-shore team and assigning tasks to the off-shore team.
• Conducting the meetings between offshore and onsite team & with the client on daily basis.
• Managing the ad-hoc requests from the end user. Analyzing the request and need to find the root cause the analysis and based upon the severity of the issue, it will be fixed.
• Interface to the mid and senior level management on technical deliverables.

Environment: Teradata SQL Assistant, UNIX Shell Scripting, Informatica, Oracle 9i, SQL, Windows.

Confidential 

ETL Developer

Responsibilities:

• Understand the business needs.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.
• Developing of Mappings/Transformations/Mapplets in Informatica to transform source data as per business rules and populate the data warehouse.
• Replicate operational tables into staging tables, transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• Developed Informatica objects - Mappings, sessions, workflows based on the prepared low level design documents.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Worked on performance issues by doing test runs and incorporating tuning measures like joining tables in database using pre-session SQL rather than Joiner, keeping the Filter as close as possible to the source, using unconnected lookup, optimize SQL overrides, increasing target commit intervals etc.
• Experienced working with various relational, flat file (fixed width, delimited) data sources
• Developed the reports by retrieving the data from a cross reference file.
• Created the reports for different regions and demands for future forecasting.
• Monitoring the data load and developing the Reports.
• Assisted users in troubleshooting their reports.

Environment: Cognos (Impromptu), Informatica 7.1.3, ReportNet, Windows NT, Oracle 9i database.