SUMMARY:

• 8+ years of total IT experience in teh Planning, Analysis, Design, Implementation and Maintenance in different domains of Financial, Pharmaceuticals, Insurance & Banking companies
• Data Warehousing: 7+ years of strong Data Warehousing experience using Informatica Power Center 9.1/8.6/8.5./8.1.1/8.0, PowerMart 6.1/5.1.1/5.x/4.7, Informatica B2B, Warehouse Designer, Power Exchange, Power Analyzer, Power Connect, Power Plug, Datamart, OLAP, SQL Server Integration Services SSIS.
• Databases: 8 years of experience using Oracle 10G/9i/8i/8.x/7.x, Teradata v12/v13, DB2 7.0, MS SQL Server 2008/2005/2000, MS Access 2000/2010, XML, PL/SQL, Experienced in PL/SQL scripts and shell scripting.
• Over 4+ years in Dimensional Modeling in Star Schema Modeling, Snow - Flake Modeling and FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin. Complete understanding of Ralph-Kimball and Inmon approaches to Data Warehousing.
• Experience working on Onshore-Offshore model.
• Experience with reporting tool like Business Objects, BRIO. Understanding of complex report generation processes in BI tools.

TECHNICAL SKILLS:

ETL/OLAP Tools: Informatica Power Center 8.6/8.1/7.1/, Power Mart 5.1/4, Ascential Data Stage 7.x/6.0/5.2/4.x, SQL Server Integration Services 2005\2008 ; Business Objects Designer 5.0/6.0/Xi

Data modeling: Erwin 4.0\Visio

RDBMS: Oracle 10g/9i/8i/7.3, SQL server 2000/2005/2008,DB2 7.x,MS Access, Flatfiles,DB2, Teradata v2R5,Teradata v2R6, Teradata v12Datawarehousing methodologies Star schema, Snow flake schema, Dimensional modeling

Tools: SQL * plus, TOAD 8.6/8/7.4, Autosys 4.7,visio,maestro,visio,MQC, MKS version control, Mload, Fast load, Tivoli Workload (TWS)/Maestro

Languages: SQL, PL/SQL, C, C++.

Web technologies: HTML, DHTML, XML

Environment: Win 95/98/2000/XP, Win NT 4.0, Sun Solaris 2.7/2.6, HP-UX 11i, IBM AIX 4.3/4.2IBM OS/390, IBM OS/400.

PROFESSIONAL EXPERIENCE:

ETL Developer/Analyst

Confidential

Responsibilities:

• Gathering requirements to convert teh Enrollment track from legacy mainframe systems to SQL Data Warehouse.
• Designing and developing ETL process for Enrollment track to load members/eligibility plans/demography information using SQL Server Integration Services.
• Involved in source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, as part of this track
• Extensive use of Meta Data tables to convert teh data.
• Automating procedures for repetitive tasks through teh use of SSIS packages, extensively worked with all teh transformations.
• Involved in preparing teh Methodology document for teh HIPAA implementation.
• Working with Health Edge vendor tool which supports teh full Data Lifecycle including data acquisition, data cleansing, data normalization, data validation, data enrichment, and data distribution and loading into teh Warehouse.
• Interacting with PM’s, DBA’s, Architects, Management, Vendors, Business Users etc to integrate, provide solutions and complete teh task.
• Implementation of 5 key aspects of HIPAA - Transactions, Identifiers, Codes, Privacy and Security, Non-Compliance issues and penalties
• Writing specifications for new applications or changes to existing applications based on business needs.
• Setting development standards, code solutions and performing code reviews, where applicable and ensure development practices adhere to guidelines.

Environment: SSIS 2005/2008, MS SQL Server 2008, MS Excel,Flat Files, Erwin, SQL, PL/SQL,, LINUX, Windows 2000/NT, Health Rules, TFS.

Confidential

Sr. ETL Developer/Analyst

Responsibilities:

• Designing and developing ETL process for Securities, Ratings and Vendor Data ODS and Enterprise Datawarehouse using Informatica Power Center.
• Involved in process of enhancing teh existing Informatica and PL/SQL code and bug fixing.
• Involved in source identification, data collection, data transformation, normalization, rule administration, error detection and correction, data consolidation, data storage, data distribution, and data governance as part of Master Data Management.
• Involved in creating and maintain Meta data tables as part of Data Management effort.
• Working with 3rd party Financial Data Sources that are vital to teh Compliance and Risk Management business units such as Bloomberg, Fitch, Moody’s, S&P, Intex, PAM, LMS and PACE.
• Automating procedures for repetitive tasks through teh use of scripts.
• Working with GlodenSource Securities & Products Tool which supports teh full Data Lifecycle including data acquisition, data cleansing, data normalization, data validation, data enrichment, and data distribution.
• Interacting with PM’s, DBA’s, Architects, Management, Vendors, Business Users etc to integrate, provide solutions and complete teh task.
• Tivoli Workload Scheduler 8.4 implementation in project, setup environment and providing design for Automation of existing job schedule
• Writing specifications for new applications or changes to existing applications based on business needs.
• Setting development standards, code solutions and performing code reviews, where applicable and ensure development practices adhere to guidelines.
• Importing and Working with Datamaps and Navigator for PowerExchange.
• Involved in teh designing of teh Business Objects Universe.

Environment: Informatica (Power Center 7/8.1/8.6), Oracle 9i (Toad 8.6.1), MS SQL Server 2005/2008, Flat Files, Erwin, SQL, PL/SQL, Business Objects 6.1,LINUX, Windows 2000/NT.

ETL/Data Warehouse Developer

Confidential

Responsibilities:

• Involved in teh requirement definition and analysis in support of Data Warehousing efforts.
• Involved in teh logical and physical database designing (Star Schema) using Erwin. Created Dimension Tables and Fact Tables based on teh warehouse design.
• Created Design Specification for source target mapping based on transformation rules and joins or look up conditions.
• Designed, developed ETL Sessions and Batch cycle.
• Responsible for monitoring teh sessions that are running, scheduled, completed and failed.
• Strictly followed naming conventions for all teh development work and followed enterprise standards.
• Created test case documents with various scenarios and level of acceptance.
• Created and managed Universes in teh Designer.
• Created teh reports using universes as teh main data provider.
• Created Aliases and Contexts for Solving teh Join problems in Business Objects.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Used Built-in strategies and External strategies for creating teh components of teh Universe.
• Created User conditions and Filters to improve teh report generation. Also used Alerts to improve teh readability of teh report.
• Completely understand Control M implementation in project, setup environment and provided design for Automation of existing job schedule Involved in process of enhancing teh existing Informatica and PL/SQL code and bug fixing
• Involved in implementing Change Management process and Peregrine Incident Management while fixing teh existing code to enhance teh code or bug fixing
• Collection of data source information from all teh legacy systems and existing data store.
• Wrote UNIX shell scripts primarily for scheduling teh Workflows, File Manipulations and automatic email notifications to teh data owners (Success / Failure). Wrote pre-session and post-session commands for teh workflows to checking teh availability of data in teh source systems.

Environment: Informatica (Power Center 7.1), Oracle 9i/8.1.3 (Toad 7.4), Flat Files, DB2, Erwin, SQL, PL/SQL, SQL*Plus, Business Objects 5.x (Universe, Designer, Business Objects), UNIX, Windows 2000/NT.

ETL Developer/ Production

Confidential

Responsibilities:

• Involved in teh requirement definition and analysis in support of Data Mart efforts.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows, and Worklets for data loads. Created Reusable Transformations and used them in teh Mappings.
• Involved in their off-shore project related to HIPAA.
• Extensively used Update Strategy & Lookup Transformations for slowly changing dimensions.
• Worked extensively in an OLTP environment.
• Extensively used Joiner, Filter, and Stored Procedure Transformations.
• Identified performance bottlenecks to improve efficiency using materialized views, plan tables, bulk loading, stored procedures for dropping and creating indexes using pre-session and post-session loads.
• Designed and developed pre and post session UNIX shell scripts.
• Responsible for monitoring teh sessions that are running, scheduled, completed and failed using Maestro Job Scheduler.
• Strictly followed naming conventions for all teh development work and followed enterprise standards.
• Responsible for daily Production issues with an end of day solution requirment.
• Touch base with Business partners for refinements for teh warehouse and new additions.
• Created test case documents with various scenarios and level of acceptance.

Environment: Informatica Power Mart 6.0, Data Stage 7.5.1,SQL Server 2005 8/9, Oracle 10g,, Flat Files, Maestro TWS, UNIX, WebFocus, Windows 2000/NT.