SUMMARY:

• Nine Plus (9+) years of IT experience in Software Analysis, Design, Development, Implementation of business applications for Health Care ( Confidential, EngagePoing), Insurance (Metlife Insurance, Confidential: Confidential ), Pharmaceutical (Novartis), Financial ( Confidential ) .
• Six Plus (6+) years of Datawarehousing experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 9.5/9.1/ 8.6/ 7.1/7.0/6.2/6.1/5.2/5.1/1.7 , 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.
• 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 4.5/4.0/3.5.5/3.5.2 ) 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.
• Nine Plus ( 9+) years of experience using Oracle 10g/9i/8i/7.x, MS SQL Server 2012/2000, 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
• Five years (5) years of Extensive experience in sitting up Procedures to Extract, Transform & Load ( ETL ) data from Operational & Legacy Systems to the Data Warehouse by Using Informatica. Extensive knowledge of Folder creation, version migration from older version into latest version. Developed common logic using Reusable transformations and Mapplets. Defined the Source databases and Target databases in Informatica.
• Five years (5) years of experience Working on several Transformations including Filter Transformations, Aggregate Transformations, Router Transformations, Joiner Transformations, Rand Transformations, Sequence Generator Transformations, Stored Procedure Transformations & Expression Transformations in Informatica.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 10.1/9.5/8.1/7.1/7.0/6.2/6.1/5.2, Informatica 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 12c/11g/10g/9i/8i, D2 8.0/7.0, IMS Data, Sybase 12.0/11.x, MS 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, SFDC

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

SR. INFORMATICA ETL DEVELOPER/ Reporting Analyst

Responsibilities:

• Maintain and deliver ETL/BO solutions associated with a Confidential Speciality Health project supporting over 2,700 caseworkers supporting services to over 700,000 citizens. This project was over $130 million dollar Prime contract and included building analytical solutions, reports and dashboards for management review.
• 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 4.5. Used Informatica Cloud to transfer data from Salesforce to Oracle/Salesforce.
• Helped in the Design the Dimensional Data Model of the Data Warehouse Confirmation of source data layouts and needs and testing of functionalities of different SFDC objects, apps
• 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 Contrast, Transaction, Benefit, Producer, Demographics, Loans and Rider information from ODS tables.
• 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.
• Coordinated with the testers and helped in the process of Unit and integration testing.

Environment: Informatica PowerCenter 7.1/8.1, Power Connect, Erwin 4.1, PL/SQL, Business Objects 4.2/3.1,Visio 2003, Putty Client.

Confidential, Calverton, MD

SR. INFORMATICA ETL LEAD

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. Responsible for metadata management, business semantics, data modeling, and metadata workflow management
• 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.

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

SR. 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 to complete resolve issue using advanced knowledge of business intelligence applications (e.g., Business Objects Webi Reporting), data warehousing concepts and SQL.
• Developing and maintaining a formal description of the data and data structures which can include data definitions, data models, data flow diagrams
• 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. Creation of metadata registry
• 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. Provide a standard design for the construction of data mapping documents and oversee their generation
• 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

SR. DW 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. Ability to define requirements by conducting interviews and facilitating/participation in data modeling sessions with business clients
• 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.

Confidential, NYC, NY

DW INFORMATICA DEVELOPER

Responsibilities:

• Responsible for Systems Study and Analysis.
• Understand the business needs and implement the same into a functional database design.
• Defined the ETL strategy for Data Warehouse population.
• Data Quality Analysis to determine cleansing requirements.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources.
• Installed, Maintained and Documented the Informatica Power Center setup on multiple environments. Execute the design, analysis, or evaluation using database design principles and adhering to business standards, practices, procedures, and product / program requirements
• Coordinating with source system owners, day-to-day ETL progress monitoring, data warehouse target schema Design (Star Schema) and maintenance.
• 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.
• Worked on Informatica Power Center 5.2 and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations user were like the Source qualifier, Aggregators, lookups, Filters & Sequence generators.
• Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Extensively used ETL to load data from various source databases to the Target database.
• Developed Korn shell scripts for Informatica pre-session, post session procedures.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints. Written complex stored procedures and triggers and optimized for maximum performance. Highly organized and detail-oriented with well-developed oral and written communication skills. Excellent interpersonal skills with the ability to interface with health plan representatives, physicians, and other professional personnel in a tactful, informed and customer oriented manner.
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources. Performed Database Migration from sources to the Data Warehousing database.
• Worked closely with Oracle DBA for migration support.
• Created UNIX shell scripts (Scheduler utilities) for automating the backup of Database/ Transaction log. Able to adjust to multiple shifting priorities and respond to critical needs as they may arise.
• Designed and developed Reporting System using Cognos 5.0 impromptu and PowerPlay.

Environment: Informatica PowerCenter 5.1/5.2, Power Connect for Mainframes, Oracle 8i, DB2, Teradata, TOAD, SQL Navigator, SQL Server 2000, Erwin 3.5.2, PL/SQL, XML, Cognos 5.0, Windows NT 4.0, HP-UX 11

Confidential

D W INFORMATICA DEVELOPER

Responsibilities:

• Source data analysis and design.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin. Assist in supporting multiple SQL Server data repository, which may include documenting database architecture and analyzing datasets to identify missing, incomplete, or invalid information. Knowledge of ICD10-/ICD9-CM and CPT coding
• Extensively used Informatica PowerCenter 5.1 as an ETL tool to extract, transform and load data from remote sources to EDW.
• Building of the WMS module of the EDW based on the third party Bright point system
• Building of RMS & HRS modules of the EDW based on the internal transactional system.
• Wrote shell scripts and stored procedures to automate the aggregate building process.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Created multiple mappings using Reusable Transformations and Mapplets.
• Created, launched & scheduled sessions and batches using PowerCenter Server/Workflow Manager.
• Developed a prototype for designed interface and estimated the performance criteria.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constaints.
• Used Connected and unconnected lookups in various complex mappings.
• Reviewed and documented existing SQL*Loader ETL scripts.
• Worked on Debugging, Troubleshooting and documentation of the Data Warehouse.
• Indentified the underlying tables and business rules by forward and reverse engineering using ERWIN. Model business and systems pro cesses based on findings through use case scenarios, workflow diagrams, and data models
• Responsible for development, test and productions mappings migration using repository manager.
• Also used Repository Manager to maintain the metadata, Security and Reporting. Tuning the Informatica Repository and Mappings for optimum performances
• Customized data by adding Calculations, summaries and functions.
• Created standard and Ad hoc reports using Business Objects.
• Developed and published reports on the web through WebIntelligence.

Environment: Informatica PowerCenter 5.1, Power Plug, Siebel, SAP, Business Objects 4.1, Erwin 3.5, PL/SQL, Oracle 8i/7i, DB2, Windows NT 4.0, HP-UX, AIX 4.3.3, Shell Scripting, Autosys.