SUMMARY:

• Data Warehousing: Have 9+ years of solid experience in end - to-end implementation of Data warehousing projects, which include Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design (Logical and Physical model), Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• ETL: 8 years of experience in Data Warehousing, ETL using Informatica Power Center 10.1.0/9.1/8.6.1 /7. x (Designer, Workflow Manager, Workflow Monitor, Repository manager), Power connect, Power Analyzer,, IBM Data Stage 8.5/8.1, ETL, Data mart, OLAP, OLTP, SQL, T-SQL, PL/SQL, Stored Procedures, Database Triggers, Data Profiling, Materialized Views, Complex Analytical functions, Performance Tuning, Unix shell scripting.
• Data Modeling: Expertise in Develop and build Enterprise level Data warehouse and subject oriented Data marts using Ralph Kimball and Bill Inman methodologies, Multidimensional data modeling using Star and Snowflake schema design, Surrogate keys, Facts & Dimensions, Erwin 4.5/4.0
• Data Cleansing: 4 years of Data cleansing experience-using Trillium 7.6/6.5 (Converter, Parser, Converter & Geocoder), First logic 4.2/3.6.
• Business Intelligence: 5+ years of Business Intelligence experience using Cognos 8.0/7.0/6.0, Micro strategy 8.0, iDashboard, Business Objects, Seagate Crystal Reports 6.x/5.x.
• Databases: Expertise in using Oracle 10g/9i/8i/8.0/7.0, DB 2 8.0/7.0/6.0, DB2/400, MS SQL Server 2005/ 2000/7.0/6.0 , Sybase 12.x/11.x, Informix, MS Access 7.0/2000, SQL, XML, Netezza, Teradata, BTEQ, SQL Assistant.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.1/8.6.1/7. X/6.2/5.1, IBM Data Stage and Quality stage8.5/8.1, Data mart, OLAP, OLTP, SQL*Loader, Oracle Warehouse Builder, SQL Loader

Dimensional Data Modeling: Dimensional Data Modeling, Star & Snowflake design, FACT and Dimension Tables, Logical & Physical Design, 3NF, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio

Data Cleansing: Trillium 7.6/6.0 (Converter, Parser, Geocoder, Matcher), First Logic

BI Tools: Cognos Report Net 1.01/1.1(Report Studio & Query Studio), Cubes, Cognos Frame work manager, Micro Strategy, Business Objects XI/6.5/6.0/5.1, Tableu, iDashboard

Databases: Teradata, BTEQ, SQL Assistant, Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, DB2/400, MS SQL Server 2000/7.0/6.0 , Sybase 12.x/11.x, Informix, MS Access, Netezza

Programming: C, C++, PL/SQL, HTML, XML, Unix Shell Scripting, PERL Programming, BTEQ

Other Tools: Wincvs (version control), Tidal Scheduler, Quality center 9.0/Test Director, Remedy, Win SQL, TOAD, Putty, Win SCP, Microsoft Project, SQL AssistantEnvironment: Windows NT, Sun Solaris 5.5/5.4, IBM AIX 5.3/4.3, Red Hat Linux, Win XP, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Responsibilities:

• Worked on SABER 2 application that built for purpose of calculating and reporting the firm’s regulatory capital and Risk Weighted Assets for multiple products across several line of business work streams (Retail lending and wholesale channels). It is to handle calculating and reporting the regulatory and economic capital requirements for in support of Enterprise Capital Management (ECM).
• Worked on Consolidation project in SABER 2 by consolidating data from different work streams like Retail, Wholesale, Recon, traded products which involves the calculation of EC RWA.
• Involved in Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design, Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from Teradata (SABER) to load into Netezza Data warehouse (SABER 2).
• Fine-tuned the SQL queries and worked on Push down optimization techniques while loading data from source to target.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. 
• Performed audit on ETLs and validated source data Vs target table loads.
• Worked with multiple teams such as Release, Production control, Test data management teams and coordinated the migration activities.

Environment: Informatica Power Center 9.61, Teradata, Netezza, UNIX, Control Panel.

Confidential, Richmond, VA

Responsibilities:

• Worked on several projects which includes Clinical, and Membership, claims, and revenue subject areas.
• Experience of Business Analysis, System Analysis, Team Lead, Onsite-Offshore co-ordination, Design and Development.
• Involved in Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design, Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• Worked on RTM to gather requirements and used the same for Defect tracking.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from Oracle, SQL Server, Flat files to load into Staging, Data warehouse.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. 
• Performed audit on ETLs and validated source data Vs target table loads.
• Worked with multiple teams such as Release, Production control, Test data management teams and coordinated the migration activities.
• Closely worked with ITT team and UAT team to close the defects
• Worked on source system WGS, CS90 ACES, and FEP and provided reporting data to CII.

Environment: Teradata version 14, BTEQ, SQL assistant, Rational Clear Case, Rational Clear quest, IP Switch, UNIX, Informatica Power Center 9.1, WLM, Control M.

Confidential, Charlotte, NC

Responsibilities:

• Involved in Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design, Coding, Testing, Support, Code migration, and prepared Documentation.
• Developed mappings using Informatica Power Center to transform and load the data from XML, Oracle source systems to Oracle.
• Worked on UAT and System Integration Testing users.

Environment: Informatica Power Center 9.1, UNIX, Oracle 11i, AUTOSYS, XML, HP Application Life cycle management Tool.

Confidential, Richmond, VA

Responsibilities:

• Experience of Business Analysis, System Analysis, Team Lead, Onsite-Offshore co-ordination, Design and Development.
• Worked on several projects which includes Clinical, and Membership subject areas
• Involved in Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design, Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from Oracle, SQL Server, Flat files to load into Staging, Data warehouse.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. 
• Performed audit on ETLs and validated source data Vs target table loads.
• Worked with multiple teams such as Release, Production control, Test data management teams and coordinated the migration activities.
• Closely worked with ITT team and UAT team to close the defects

Environment: Teradata version 14, BTEQ, SQL assistant, Rational Clear Case, Rational Clear quest, IP Switch, UNIX, Informatica Power Center 9.1, WLM.

Confidential, Charlotte, NC

Responsibilities:

• Worked on several projects including Health maintenance, Meaningful use, Claims, and One bill (financial side), IDX billing and scheduling and ICD 9 to ICD 10 code conversion for procedures and diagnosis
• Involved in Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design (Logical and Physical model), Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from Oracle, SQL Server, Flat files to load into Staging, Data warehouse,
• Extensively used various types of Informatica transformations such as Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Joiner, Filter, Router, Update strategy, and Stored Procedure Rank, Normalizer, Sequence Generator, Sorter, Reusable transformations, Mapplets, Lookup Caches (Static, Dynamic).
• Developed PL/SQL Stored Programs (Procedures & Functions) to do data transformations and integrated them with Informatica programs.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created UNIX shell scripts for Automation and to invoke the stored procedures for the control process and parameter file generation.
• Extensively worked on source/target flat files and used FTP, SFTP, and SSH in Unix scripts.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Fine-Tune the ETL processes Informatica mappings, sessions, workflows, Oracle SQL queries, PL/SQL procedures to improve the efficiency of the load process.
• Worked on Informatica Data Quality to resolve customers address related issues.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.  Performed audit on ETLs and validated source data Vs target table loads.
• Worked on ETL Conversion project from Informatica To IBM DataStage
• Updated ETL mapping logic for targets in to Fast track
• Designed and Developed Data stage Jobs to extract data from heterogeneous source, Applied transform logic to extracted data and loaded the data in to Netezza

Environment: INFORMATICA Power Center 9.1/8.6.1,, IBM Data Stage and Quality stage 8.5/8, Netezza, Oracle 10g/9i, SQL Server 2005, SQL*Plus, PL/SQL, TOAD, Win SCP, Unix (Sun Solaris), Ult tra Edit, Maestro (Job scheduling tool), Reflection tool.

Confidential, PA

Responsibilities:

• Involved in end-to-end implementation of Data warehousing projects, which include Business Requirements gathering, Analysis, System study, Prepare Functional & Technical specifications, Design (Logical and Physical model), Coding, Testing, Code migration, Implementation, System maintenance, Support, and Documentation.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from DB2, DB2/400, Oracle, SQL Server, Flat files to load into Staging, ODS, Enterprise Data warehouse, and subject oriented Data marts for Sales, Marketing and Finance departments.
• Extensively worked on source/target flat files and used FTP, SFTP, and SSH in UNIX scripts.
• Design ETL procedures to efficiently process large volumes of data in to Oracle database.
• Implemented complex business rules using various complex transformations, Oracle packages, stored procedures, function, triggers, analytical functions
• Fine-Tune the ETL processes Informatica mappings, sessions, workflows, Oracle SQL queries, PL/SQL procedures to improve the efficiency of the load process.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.  Performed audit on ETLs and validated source data vs target table loads.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, DB2/400, SQL Server 2005, SQL*Plus, PL/SQL, TOAD, AS/400, Erwin 4.0, Windows NT, Putty, IBM AIX, Win SCP, Netezza, TIDAL Scheduler (job scheduling), Quality Center 9.0, Win CVS (version control), REMEDY, Cognos Cubes and Report Net (Report Studio and Query Studio).

Confidential, MA

Responsibilities:

• Involved in Dimensional Data Modeling and populating the business rules using mapping into the repository for Metadata Management
• Designed and developed Informatica Mappings for data load and data cleansing
• Extracted, transformed data from various sources such as Flat files, MS SQL Server and transferred data to the target data warehouse Oracle9i database and Flat files
• Created Stored Procedures, Functions and Triggers as per the business requirements
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements. Designed and developed complex aggregate, joiner, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data
• Worked on Informatica Data Quality to resolve customers address related issues.
• Utilized the Aggregate, Joiner, Router, Look up and Update transformations to model various standardized business processes. Used SQL Loader for bulk loading. Developed the Informatica scripts in order to populate the Global repository from the local repository

Environment: Informatica Power Center 7.1, SQL Loader, Erwin 3.5, Oracle 9i, Flat file, MS SQL Server, Windows 2000, Autosys, Test Director, Clear case, Sun Solaris, TOAD, Putty.