SUMMARY:

• Over 9+ Years of experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse Consultant.
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, DataTransformation and loading using Informatica Power center 9.6.1/9.1/8. 6.1/ 7. x/6.2, IDQ and Trillium.
• Experience in Informatica Data Quality (IDQ - Informatica developer 9.6.1/9.1) for cleansing and formatting customer master data.
• Experience in Informatica Analyst to analyze customer master data. used Informatica Analyst to perform profiling.
• Created business rules and populated those rules Pass, Fail percentages and failed records(rule breaks) in DQP dashboard using Qlik view.
• Create logical data object model, Customized data objects in Informatica developer.
• Created reference tables for standardization.
• Experience in Trillium to scrub, standardize and match customer address.
• Used BCI to extract data from SAP R/3.
• Good understanding of Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inmon Snow Flake schema methodology.
• Strong understanding of OLAP and OLTP Concepts
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 etc.
• Experience in SQL, PL/SQL, T-SQL and UNIX shell scripting.
• Performed data modelling using Teradata.
• Documented the process for rule analysis, designing, mapping, Unix SCP Process, DQP dash board, CM Synergy, rational change.
• Migrated code using IBM CM Synergy process.
• Created change requests and attached assigned task which created in IBM rational synergy and solution records for code migration in IBM Rational Change.
• Experience with the data-modeling tool using Erwin.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Used 3rd generation programming languages like C++, COBOL & Java.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
• Dealt with Master data, Transaction data, Control data etc.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Adept in UNIX operating system commands & Shell Scripting.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETLDevelopment.
• Strong decision-making and interpersonal skills with result oriented dedication towards goals.
• Worked in onsite-off shore model.
• Worked extensively in Data analysis and quality assurance.
• Participated in requirements gathering with business and functional teams and worked independently on given objects.
• Performed performance tuning to work efficiently.
• Knowledge of B2B data exchange and data transformation tool.
• Experienced in Chemical, Finance, Materials, Sales and distribution, manufacturing, entertainment and healthcare domains.
• Worked on Big data Editions

SOFTWARE

ETL Tools: Informatica Power center 9.6.1/9.1/8. x/7.x/6.x, Data Stage 7.5

Cleansing Tools: Informatica Data Quality (IDQ 9.6.1/9.5), Trillium

Reporting Tools: Crystal Report XI/10/9, Business Object XI, Cognos 8

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database: Oracle 10g/9i, SQL Server, DB2,Teradata14.10

Database GUI Tools: TOAD

Web Development: HTML, XML

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script, C, C++.

Supporting Tools: Microsoft Visio

Software: DB Artisan, Rapid Sql, IBM Rational Synergy, TWS

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Experience in SQL, PL/SQL, T-SQL and UNIX shell scripting.
• Performed data modelling using Teradata.
• Documented the process for rule analysis, designing, mapping, Unix SCP Process, DQP dash board, CM Synergy, rational change.
• Migrated code using IBM CM Synergy process.
• Created change requests and attached assigned task which created in IBM rational synergy and solution records for code migration in IBM Rational Change.
• Experience with the data-modeling tool using Erwin.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Used 3rd generation programming languages like C++, COBOL & Java.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
• Dealt with Master data, Transaction data, Control data etc.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes with Query optimizations as part of ETL Development process.
• Adept in UNIX operating system commands & Shell Scripting.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETLDevelopment.
• Strong decision-making and interpersonal skills with result oriented dedication towards goals.
• Worked in onsite-off shore model.
• Worked extensively in Data analysis and quality assurance.
• Participated in requirements gathering with business and functional teams and worked independently on given objects.
• Performed performance tuning to work efficiently.
• Knowledge of B2B data exchange and data transformation tool.
• Experienced in Chemical, Finance, Materials, Sales and distribution, manufacturing, entertainment and healthcare domains.
• Worked on Big data Editions