SUMMARY

• Seven Plus (7+) years of IT experience in Software Analysis, Design, Development, Implementation of business applications for Medicaid ( Confidential ), Insurance (Metlife Insurance, Citigroup) and Pharmaceutical (Novartis).
• Six Plus (6+) years of Datawarehousing experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 9.6/9.5/ 9.X/8.6/7.1/7.0/6.2/6.1, PowerMart 6.2/6.1/5.2/5.1/4.7, using Designer, repository Manager, Repository Server, Workflow Manager & Workflow Monitor, Informatica PowerConnect, Informatica PowerAnalyzer 4, Data Profiling, Data Cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Start Schema, Snowflake Schema, OLTP, SQL*Loader, File Feeds, XML Feeds, WebServices.
• Three Years (3) of experience Delivering Responsibilities as different capacities as Developer, Analyst and Programmer including interaction with Business Users for Requirements Gathering, Creating Technical specifications, Design, Development, Feasibility studies, Scope Definition, Business Requirements Gathering, Business Process Analysis, Functional Specifications, Datamodelling, Design, Development. Implementation and Production Support and Maintenance.
• Four Plus (+4) years of Dimensional Data modeling experience of Data modeling (FACT & Dimensions tables), Erwin Modeling (Erwin 9.1/4.5/4.0) Star Schema/Snowflake modeling. Physical & logical data modeling using Oracle Designer.
• In - depth understanding of fundamental data warehousing concepts such as dimensional modeling, Ralph Kimball Approach, star, snowflake and starflake schemas, Datamarts, OLAP concepts, security and deployment. Also experienced in modeling and developing relational databases using entity-relationship modeling tools like Erwin and Rational Rose.
• Four Plus (+4) years of experience in Business Objects XI//6.5/6.0/5.1/4.1 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0) building Universes, retrieving data using 7.0/6.0, Crystal Reports, Microstrategy.
• Nine Plus ( 9+) years of experience using Oracle 12c/11g,10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5, Sybase 12.0/11.x, Teradata V2R5/V2R4/V2R3, DB2 UDB 8.0/7.0/6.0, Ms Access 7.0/2000, IMS Data, SQR 3.0, SQL, PL/SQl, SQL*Plus, Sun Solaris 2.x, HP-UX, AIX, SCO-UNIX, Sun-Ultra, Sun-Sparc
• Authorized to work in the US for any employer.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.6/9.5, 8.1/7.1/7.0/6.2/6.1/5.2/5.1Informatica Powermart 6.2/6.1/5.2/5.1/4.7, Informatica PowerAnalyzer 4, Power Connect, Data Profilling, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, SnowFlake Modeling, FACT and Dimensions Tables, Physical and Logical Data ModelingErwin 4.5/4.0/3.5.2/3.x, Oracle Designer

Databases: Oracle 10g/9i/8i/8.0/7.0, D2 8.0/7.0, IMS Data, Sybase 12.0/11.xMS SQL 7.0, SQL Server 2000, MS Access 2000/7.0/97, Teradata V2R5/V2R4/V2R3

BI & Reporting Tools: Business Objects XI/6.5/6.0/5.1/4.1(Web-Intelligence 2.5, Designer 5.0And Developer Suite & Set Analyzer 2.0) building Universes, retrieving Data using Universes, Personal data files, Stored Procedures and Freehand SQL methods, Cognos Series 7.0/6.0, Crystal Reports

GUI: Visual Basic 5.0/6.0, Oracle Forms 6.0, Oracle Reports 6.0, VC++MS Excel VBA Macros, MS Word(VBA) Macros, FrontPage, Visio

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*PLUS 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, UNIX Shell Scripting

Environment: HP-UX111/10/9, IBM-AIX4.0/3.1, AS/400, SunSolaris9/8/7/2.6/2.5SCO-UNIX, LINUX, Windows95/98/2000/Xp, WinNT4.0, MSDOS6.22

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

INFORMATICA/ETL INTEGRATION SPECIALIST

Responsibilities:

• Business requirement analysis by interacting with Report Users, Business Analysts to understand document requirements & translate them to Technical specifications for designing the informatica Mappings.
• Worked on putting together a comprehensive strategy for migration and QA activities.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Helped in the Design of the Data models for Datamarts. Created Logical and Physical Data models using Erwin 9.1.
• Helped in the Design the Dimensional Data Model of the Data Warehouse Confirmation of source data layouts and needs. Design and created a MEDES front-end using Qilkview stats dashboard.
• Assisted in the Development and design of Datamarts extensively using Star Schema.
• Assisted in Design of the target data warehouse using Star Schema.
• Developed and maintained the Informatica Folder and Schema Structures.
• Managed users and groups, global/local repository relationships and security levels.
• Responsible for coordinating migrations, maintaining database connections, establishing and promoting naming conventions and development standards.
• Developed back-up and restore procedures for the repositories.
• Worked during the Architect, Build and Deploy phases to plan, configure, support and maintain the desired Repository configuration.
• Extraction, Transformation & Loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping designer, Workflow Manager & Workflow Monitor.
• Integrated various sources in the Staging area in Data warehouse to perform Integrating and Cleansing data.
• Advanced understanding in fundamentals and principles of Velocity framework, version control, error handling, data validation, change data capture and Slowly changing dimension strategies
• Knowledge of best practices in Data Warehousing and Business Intelligence. Experience with Ralph Kimball concepts and Informatica Velocity.
• Worked with Power Center - Designer tool in developing Mappings and Mapplets to extract and load the data from various sources.
• Designed and implemented ETL processes to extract historical and latest Benefit, Demographics, Loans and Medicaid Claims information from CURAM tables for Management and Administrative Reporting Subsystem (MARS) and Surveillance, Utilization Review Subsystem (SURS) and TPL.
• Parsed high-level design spec to simple ETL coding and mapping standards.
• Created physical and logical models and used Erwin for Dimensional data Modeling.
• Developed various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Stored procedure Transformations, Expressions and Sequence Generator for loading the data into target Datamart.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Modified the existing mappings and created the new ones based on specification documents.
• Parsing, Compiling, optimizing and executing Lookup and Source Qualifier queries to improve performance.
• Usage of aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Developed various reusable transformations using the Transformation Developer in the Informatica PowerCenter Designer.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Extensively worked on Conformed Dimensions for the purpose of incremental loading of the target database.
• Involved in Debugging & Performance Tuning of the Informatica mappings and sessions.
• Tuned the session Parameters to increase the efficiency of the sessions in Workflow Manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed and developed UNIX scripts and used Control-M for job scheduling.
• Used pmrep command to create backups, copy and delete repositories.
• Developed Korn shell scripts for informatica pre-session, post session procedures.
• Used pmcmd to interact with Informatica Server from command mode.
• Assisted in the Creation of Universes using Business objects for pulling the data for online reporting and Analysis.
• OLAP and OLTP environment
• Coordinated with the testers and helped in the process of Unit and integration testing.
• Experienced using various testing tools, defect management tools and project management

  tools, e.g Clear Quest.ClearCase, RFT, RPT, RQM, RTC, RPM, Testlink, QC, JIRA soapUI, Loadrunner.

Environment: Informatica PowerCenter 9.6/9.5, Power Connect, Erwin 9.1, PL/SQL, DB2 10.5, IBM-AIX 4.1, SQL*Loader, MicroStrategy 8, Lotus Notes 6.5, Visio 2003, Putty Client, QlikView 10

Confidential

SR. INFORMATICA ETL DEVELOPER

Responsibilities:

• Business requirement analysis by interacting with Report Users, Business Analysts to understand & document requirements & translate them to Technical Specifications for designing the Informatica Mappings.
• Worked on putting together a comprehensive strategy for migration and QA activities.
• Designed the Data models for Datamart. Created Logical and Physical Data models using Erwin 4.5
• Designed the Dimensional Data Model of the Data Warehouse Confirmation of source data layouts and needs
• Developed and designed Datamarts extensively using Star Schema.
• Designed the target data warehouse using Star Schema.
• Created Templates for standardizing the Structure of our Corporate Documents.
• Involved in Extraction, Transformation & Loading (ETL) process and used Informatica power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Integrated various sources in the Staging area in Data warehouse to Integrating and Cleansing data.
• Advanced understanding in fundamentals and principles of Velocity framework, version control, error handling, data validation, change data capture and slowly changing dimension strategies.
• Knowledge of best practices in Data Warehousing and Business Intelligence. Experience with Ralph Kimball concepts and Informatica’ Velocity.
• Worked with design and integration of data warehouse at Enterprise level.
• Created Informatica standards and best practices for data integration.
• Developed definitions for Informatica infrastructure and strategies for future growth of the data warehouse.
• Worked with Power Center - Designer tool in developing mappings and Mapplets to extract and load the data from various sources.
• Every phase of development including feasibility studies, system design, business scope and technical requirements.
• Designed and implemented ETL, processes to extract historical and latest Contract, Transaction, Benefit, Producer, Demographics, Loans and Rider information from ODS tables.
• Parsed high-levels design spec to simple ETL coding and mapping standards.
• Created physical and logical models and used Erwin for Dimensional Data Modeling.
• Developed various transformations like Source Qualifier, Joiner transformations, Update Strategy, Lookup transformation, Stored procedure Transformations, Expressions and Sequence Generator for loading the data into target Data Mart.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Modified the existing mappings and created the new ones based on specification documents.
• Worked with DBA in the Up gradation process of Informatica from PowerCenter 6.2 to PowerCenter 7.1.
• Parsing, compiling, optimizing and executing Lookup and Source Qualifier queries to improve performance.
• Usage of Aggregator, SWL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Developed various reusable transformations using the Transformation Developer in the Informatica PowerCenter Designer.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Extensively worked on Conformed Dimensions for the purpose of incremental loading of the target database.
• Involved in Debugging & Performance Tuning of the Informatica mappings and sessions.
• Tuned the Session Parameters to increase the efficiency of the sessions in Workflow Manager.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Designed and developed UNIX scripts (Cron job Scheduler) and used AUTOSYS for job scheduling.
• Developed Korn shell scripts for Informatica pre-session, post session procedures.
• Used pmcmd to interact with Informatica Server from command mode.
• Created Universes using Business Objects for pulling the data for online reporting and Analysis.
• Used pmrep command to create backups, copy and delete repositories.
• Coordinated with the testers and helped in the process of Unit and integration testing.
• OLAP and OLTP environment

Environment: Informatica PowerCenter 7.1/8.1, Power Connect for Main Frames (STRIVA DETAIL 4.2), Erwin 4.1, Business Objects 5.1, Corn Scheduler, SQL Server 2000, TOAD 7.5, Oracle 10g/9i, DB2 8.0, Sun Solaris 5.8, AIX 4.1, Windows XP Professional, SQL*Loader, MicroStrategy 8, Lotus Notes 6.5, Visio 2003, PVCS 6.7, Putty Client.

Confidential HARTFORD, CT

INFORMATICA ETL DEVELOPER

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements.
• For Customer system, developed logical & physical data model by defining strategy for Star schema with Fact & Dimension tables with Detail, Summary, loop-up tables, Indexes and views.
• Worked with DBA in the Upgradation process of Informatica from PowerCenter 6.2 to PowerCenter 7.1
• Used Informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and performed loading.
• Performed data analysis on the source data coming from legacy systems.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookups and stored procedures.
• Created source, target, lookups, transformation, session, batches and defined schedules for those batches and sessions.
• Worked on Dimensional modeling to design and develop Star schemas by identifying the facts and dimension.
• Designed logical models (relationship, cardinality, attributes, candidate keys) as per business requirements using Erwin Data Modeler.
• Designed and customized data models in Erwin for Data warehouse supporting data from multiple sources on real time.
• Worked on PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked with Informatica Power Center - Designer tool in developing Complex mappings using Unconnected, Lookups, and Aggregate and Router transformations for populating target table in efficient manner.
• Gathered business scope and technical requirements.
• Improved development time by leveraging metadata, and reduce IT coordination costs by providing a common working business model across the enterprise architecture.
• Used transformations like, Source Qualifier, Joiner, Update, Lookup, Stored procedure, Expression and Sequence Generator for loading the data into target Data Mart.
• Created events and tasks in the work flows using workflow manager.
• Designed testing procedures and test plans.
• Extensively used UNIX shell scripts for cleansing.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using Unix Shell scripts.
• Experience in backup and restoring of Repository.
• Prepared the Schedules for the Historical Load run and regular Load runs.
• Designed and developed Oracle PL/SQL scripts for Data import/Export, Data Conversions and Data Cleansing.

Environment: Informatica PowerCenter 7.1/6.2, Power Connect, Erwin 4.1, Business Objects 6.0, Corn Scheduler, SQL Server 2000, SQL*Loader, Oracle 10g/9i, DB2 8.0, Sun Solaris 5.8, Windows 2000.

Confidential, EAST HANOVER, NJ

INFORMATICA DEVELOPER

Responsibilities:

• Requirements gathering and Business Analysis.
• Designed and developed end-to-end ETL process for Sales Data Mart.
• Handled all Datamodeling aspects of the Data Mart. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Modeled the data warehousing data marts in Star join schema.
• Analyzed IMS Data using IMS tools such as DDD, Xponent and Xponent Plantrak, regarding segmentation & profiling
• Drilled out each of the data flow on a page to plan which tables to work on, and for sequencing the transformations within each data set.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Router, Lookups, Rank, Filter, Expression, Update, Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Extensively used Autosys for scheduling jobs and implemented UNIX shell script jobs.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Created Event Driven and Time Dependent Sessions.
• Created Worklets to run several sessions sequentially and concurrently.
• Developed schedules to automate the updated processes and Informatica Sessions/Worklets.
• Created different types of reports, such as Master/Detail, Cross Tab and Chart, conform
• Worked with DBA in the Upgradation process of Informatica from PowerCenter 5.1 to PowerCenter 6.2
• Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.
• Tuning of SQL queries for better performance.
• Exported the universes to the Repository to make resources available to the users and to generate reports for the Sales and Marketing department.
• Maintained hierarchies in the designing of the Universe for drill down capabilities.
• Generated Ad hoc reports using the Business Objects free hand SQL.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Coordinated with the testers and helped in the process of Integration testing.

Environment: Informatica PowerCenter 6.1/5.2, Power Connect, Erwin 4.0, Business Objects 6.0, Web Intelligence, IMS Data (DDD, Xponent and Xponent Plantrak), Oracle 10g/9i, PL/SQL, Shell Scripting, Corn Scheduler, Autosys, MS SQL Server 2000, DB2, Cobol, Sun Solaris UNIX, Windows 2000.