SUMMARY

• Over 10 years of IT experience in teh Analysis, Design, Development, Testing, and Implementation of business application systems.
• Over 10 years of Data Warehousing ETL experience using Informatica PowerCenter 9.5.1/9.1/8.6.1 /8.1.1/ 7.1.3/7.1/7.0/6.2 , Informatica PowerMart 7.0/6.2 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager), PowerConnect, PowerPlug, PowerAnalyzer.
• 4 years of Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT & Dimensions tables, Physical & logical data modeling, ERwin 4.5/4.x/3.0.
• 4 years of BI experience in Business Objects 6.0/5.1/4.1 (Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 7.0/6.0/5.x, Cognos Impromptu, Cognos IWR (Impromptu Web Reports), Cognos Power Play Transformer.
• 10+ years of experience using Oracle 11g/10g/9i/8i/8.x/7.x, DB2, MS SQL Server 2008/2005/2000/7.0/6.5 , MS Access 7.0/2000, SQR 6.1.4, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Windows 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x, IBM AIX, and HP-UX.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.5.1/9.1/8.6.1/8.1.1/7.1.3/7.1/7.0/6.2 (Designer, Repository Manager, Repository Server Administration Console, Workflow Manager, Workflow Monitor, Informatica Server), Informatica PowerMart 7.0/6.2 (Designer, Repository Manager, Server Manager, Informatica Server), Informatica PowerConnect for PeopleSoft/Siebel/DB2/SAP

Data Modeling: Dimensional Data Modeling, ERwin 4.5/4.1/3.5.5/3.5.2 , Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

BI & Reporting Tools: Business Objects 6.0/5.1/5.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 7.0/6.0/5.x, Cognos Impromptu, Cognos IWR (Impromptu Web Reports), Cognos Power Play Transformer, SAS, Developer 2000, Crystal Reports 8.0/7.0/6.0/5.0

Programming: SQL, PL/SQL, T-SQL, O-SQL, me-SQL, Unix Shell Scripting, Perl, Java, Servlets, JavaScript, COBOL, HTML 4.0.

GUI: Developer 2000, Designer 2000

Databases: Oracle 11g/10g/9i/8i/8.x/7.x, DB2 8.0/7.0, IBM DB2 UDB, MS SQL Server 2008/2005/2000/7.0/6.5 , MS Access 7.0/’97, FoxPro 2.0, dBASE-III Plus.

ERP: PeopleSoft Financials 8.4, PeopleSoft HRMS 8.8, Siebel 7.0/2000.

Other Tools: Siebel Analytics, Siebel OLTP, Developer/2000 (Forms 2.3/4.5/5.0, Reports 2.0/2.5/3.0, Graphics 3.0), SQR 3.0/4.0/4.3, PS/Query, nVision, SQL*Tools, SQL*Loader, Autosys, Control M, Tidal.

Environment: Sun Solaris, Sun OS, HP-UX, Novell 3.11, MS-DOS 6.22, Windows 95/98/2000, Windows NT 4.0, IBM-Compatibles, Sun Classic, Sun Ultra, Sun Sparc, HP9000

PROFESSIONAL EXPERIENCE

Confidential, Needham, MA

Senior Informatica Developer

RESPONSIBILITIES:

• Familiarized wif teh Organization, and System which was built on Oracle Warehouse Builder.
• Analyzed teh Architecture, data, and business rule documents.
• Analyzed and understood teh Process flow package, Processes, and Process Flows for teh THP Provider.
• Worked on Informatica Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Informatica Designer to create and change Source Definitions, Target Definitions, Mappings, and Sessions and Reusable transformations.
• Created all teh required Informatica objects for THP Provider.
• Administered Dev, QA and Prod Informatica Environments, and created folders in QA and Prod.
• Created Deployment group, Query and labels to migrate code from one environment to another.

Environment: Oracle Warehouse Builder (OWB) 11g R2, Informatica PowerCenter 9.5.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g, Windows 7 Enterprise, SQL Developer.

Confidential, Merrimack, NH

Senior Informatica Developer

RESPONSIBILITIES:

• Reviewed teh data, processes in legacy system which was in PL/SQL procedures, packages, understand teh functionality of People Central 1.0 to convert it into People Central 2.0 which utilizes Data modeling and Informatica.
• Analyzed teh data coming from different source systems and different feeds such Reference, Key change, Attribute and Person.
• Created technical specifications for different feeds such as reference, key change and Person by going through PC 1.0, which were in PL/SQL Procedures.
• Extensively used all different tools available in Informatica, such as, Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, Mappings, Mapplets, transformations, and re-usable transformations such as lookup transformation.
• Created complex mappings using Joiner, Union, Aggregator and Dynamic Cache in Lookup transformations.
• Worked on defect fixing of Informatica Jobs to resolve defects in teh code using debugger and SIT support.
• Created Re-usable code such as, Re-usable lookup transformation so that it can be used in multiple mappings.
• Used Mapplets which were created to encompass logic which is common for multiple mappings, easier to maintain and reusability.

Environment: Informatica Power Center 9.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 10g, SQL Developer, UNIX, WinSCP, Windows 7 Enterprise.

Confidential, Omaha, NE

Senior DW Informatica Developer

RESPONSIBILITIES:

• Familiarized wif teh PharmacyIDS and PharmacyIDS Stage process.
• Analyzed teh data and mapping specifications for PharmacyIDS Stage to IDS Process.
• Analyzed and identified teh issues from teh Informatica Health Check Report.
• Worked on fixing teh issues identified in teh Health check report such as Command tasks wif hard coded path, session logs wif hard coded path, invalid Mappings and Mapplets.
• Worked extensively on Informatica Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively worked on Informatica Designer to create and change Source Definitions, Target Definitions, Mappings, Sessions and Reusable transformations.
• Created mapping and logic to load Provider table to make sure that any changes to teh same provider will result in different row and row will not be loaded to teh table if no changes are there.
• Created mapping and logic to load Pharmacy Claim table which is teh main and parent table to all other PharmacyIDS tables.
• Made use of newly created mappings and changed them accordingly for one-time load of Historical data into PharmacyIDS tables.

Environment: Informatica PowerCenter 9.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), SQL Server 2008 R2, Tidal, Windows 7 Enterprise.

Confidential, Nashville, TN

Senior Informatica Developer

RESPONSIBILITIES:

• Analyzed teh data, processes and mapping specifications.
• Got acquainted wif teh Client’s mapping specification tool: MATT Mapping Tool, Defect tracking tool: JIRA.
• Analyzed teh data coming from different source systems like, Accent, TCCMS, COTS, TennCare and VRTS.
• Extensively used all teh components of Informatica, such as, Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, Mappings, Mapplets, transformations, and re-usable transformations such as lookup transformation.
• Reviewed teh mapping specifications of Infrastructure, EDBC, EDBC XML, Claims and Orgs & Srvs, understood teh requirements and coded accordingly.
• Created UNIX shell Package, named Load Automation System (LAS) to execute teh conversion jobs. LAS functions wif Informatica Power Mart command PMCMD to execute teh Informatica jobs.
• Created complex mappings using Joiner, Normalizer, Aggregator and Dynamic & Persistent Caches in Lookup transformations.
• Worked on Performance Tuning of Informatica Jobs to reduce teh execution time of teh job.
• Created Re-usable code such as, Re-usable lookup transformation wif persistent cache so that it can be used in multiple mappings.
• Created Mapplets to encompass logic which is common for multiple mappings and easier to maintain.

Environment: Informatica Power Center 9.1/8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 10g, SQL Developer, MATT Mapping Tool, Subversion, JIRA, eRoom, UNIX, Java, Windows XP Professional version 2002.

Confidential, Hartford, CT

Senior DW Informatica Developer

RESPONSIBILITIES:

• Analyzed teh data and interfaces used to build teh IDW (Insurance Data Warehouse).
• Reviewed teh source systems which populate teh IDW.
• Worked majorly on WINs & W Brown source systems.
• Involved in analysis, coding and unit testing of WINs consolidation project.
• WINs consolidation project deals wif changing teh source to AS/400 views from tables.
• Previously WINs source data was coming from 13 AS/400 libraries which are consolidated into 3 libraries. To reduce teh impact adapted teh way of using views instead of tables.
• Created teh views and tested them in Development environment.
• Analyze teh existing mappings and prepared technical documents.
• Changed teh source of mappings to views instead of tables.
• Worked on supporting jobs which load US & Swiss genius source systems data into IDW.
• Extensively worked in production support for IDW. Source systems handled were WINs, W Brown, PAT (Portfolio Analysis Tool), US and Swiss genius.
• Production support tasks are manually kicking off jobs, monitoring them, resolving teh failures and code changes for project/change.
• Handled teh Month-end close for WINs and W Brown Source Systems
• WINs, W Brown, US and Swiss genius deals wif policy and claims data from industrial, commercial, professional service firms and insurance companies.
• WINs data is used in creating Excess and Surplus reports.
• Received appreciation from manager for successfully handling teh WINs catch up job in time when one day incremental of WINs load was missing.
• Regarded by clients as a subject matter expert in IDW.
• Created and modified JIL files for creation or modification of Autosys jobs.

Environment: Informatica PowerCenter 8.6.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Cognos Series 7.0, SQL Server 2000, DB2, WinSQL, Autosys, Windows XP Professional version 2002.

Confidential, Somers, NY

Senior Informatica Developer

RESPONSIBILITIES:

• Projects worked on are IPS (Item Price Synchronization), PENSKE, and, OAR (Oracle Accounts Receivables).
• Involved in modifying and creation of teh database tables, Korn shell scripts and Informatica objects.
• Worked on getting deal information for teh IPS Customers and their authorized products using stored procedures.
• Enhanced teh logic to generate output EDI 832 File for teh destination companies using extra code in stored procedure and populating a table and using that table in teh SQL Override of teh Informatica mapping instead of using Korn shell script to reduce teh execution time.
• Created Korn Shell script to insert timing information into Sybase table.
• Extensively worked on creating Informatica objects like source definitions, target definitions, mappings, sessions and workflow.
• Modified / enhanced existing Informatica mappings for Penske project to support new functionality that is needed to support teh business of Penske to maintain teh data warehouse.
• Responsibility also included working on ongoing issues like data correctness, data validation and data integrity.
• Worked on OAR project to enhance teh mappings and get teh data and tax related information into Oracle Applications using oracle staging tables.

Environment: Informatica 8.1.1/6.2 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Sybase 12.5.1, Oracle 10g/9i, DB2 UDB 8.1.5, Rapid SQL, StarTeam-PVCS, Autosys, Windows 2000, XML, HP-UX, Windows NT 4.0.

Confidential, Ridgefield, CT

Senior DW Informatica Developer

RESPONSIBILITIES:

• Reviewed teh Business Processes for teh project, and, tasks involved in it.
• Understood teh logic behind teh business processes and modified according to requirements.
• Worked on Subject areas like objectives, calls, and, syndicated data.
• Applied teh sales force split for teh subject areas like objectives, calls, and, syndicated data.
• Created mappings, sessions, and, workflow to create objective aggregates, for rolling up teh fact table information into higher levels, like geo, district, region, zone and nation levels. Fact table is at teh territory level.
• Roll up teh data using position, and, position hierarchy dimensions.
• Applied teh sales force split for teh objectives.
• Created mappings, sessions, and, workflow to create call union aggregates, for rolling up teh fact table information into higher levels than territory which teh fact table is on, like geo, district, region, zone and nation levels.
• Created ETL objects to create aggregates for teh Syndicated Monthly data for teh product side.
• Worked wif all teh Tools of Informatica like Designer, Workflow Manager, Workflow Monitor, and, Repository Manager.
• Worked wif all teh components of teh Designer like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and, Mapping Designer.
• Extensively used almost all of teh transformations of Informatica including lookup, Update Strategy, and, aggregator.
• Extensively worked in teh performance tuning of ETL procedures, and, processes.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per teh business requirement.
• Created UNIX scripts in teh form of sql to analyze teh table and indexes, and, to create indexes.

Environment: Informatica PowerCenter 7.1.3, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Toad 9.0, Oracle 9i, Siebel OLTP, Siebel Analytics 7.8.2, PL/SQL, HP-UX, Windows XP Tablet PC Edition.

Confidential, Morristown, NJ

Senior DW Informatica Developer

RESPONSIBILITIES:

• Solely responsible for teh modifications and enhancements for teh existing mappings in Data Warehouse and Interfaces.
• Used Informatica Data Explorer
• Understanding of teh already built Interface CA3000, which deals wif claims information. Purpose of dis interface is to source teh data from Claims Assure, which is entered by online users, and, teh target is mainframe.
• Worked on CA2Wins Fairmont Interface which deals wif claims information of Personal and commercial lines.
• Created SQL scripts to do teh Financial Summary Balancing.
• Worked on teh UPM Interface to handle teh current & history data.
• Solely responsible for teh Technology Upgrade Project. Teh purpose of teh project was to convert teh processes which are in Legacy ETL applications into Informatica 8.1.
• Created LMREFTABLES Informatica interface to refresh teh Claims Assures reference tables from mainframe data set.
• Created LM66BYTE process to write teh Claims assures claims data into mainframe.
• Converting teh Producer Process which was in Visual Basic into Informatica.
• Understood teh business logic, written teh write-up on it, which was describing, how teh process was created, how teh data is handled, validated and written to teh target.
• Created Mapplets to be re-used in teh Informatica mappings.
• Extensively used almost all of teh transformations of Informatica including lookups, Stored Procedures, Update Strategy and others.
• Developed, monitored teh workflows and responsible for performance tuning of teh staging and Datamart workflows.

Environment: Informatica 8.1.1/6.2 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Informatica Data Explorer, SQL Server 2005/2000, Oracle 10g/9i/8i, PL/SQL Developer, PL/SQL, XML, Windows 2000 / NT 4.0.

Confidential, Ridgefield, CT

Senior DW Informatica Developer

RESPONSIBILITIES:

• Developed and documented Data Mappings/Transformations, and Informatica sessions as per teh business requirement.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes.
• Error checking and testing of teh ETL procedures and programs using Informatica session log.
• Created Mappings like Overview Dis A, Overview Geo A, Overview Reg A, and Overview Zone A to build Dashboards.
• Gathered requirements for teh Field Performance Reports.
• Created Field Performance Reports using Stored Procedures and cursors.
• Field Performance Reports are Average calls per day, Average calls per day HIV, Targeted Average calls per day, Targeted Average calls per day HIV.
• PCP Presentations per call, SPEC Presentations per call, All Presentations per call, All Presentations per call HIV, Targeted Presentations per call, Targeted Presentations per call HIV, and Targeted Physicians Sampled.
• Collection of data from source systems into database.

Environment: Informatica PowerCenter 7.1.2, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Toad 8.0, IMS Data, Oracle 9i, Siebel OLTP, Siebel Analytics, PL/SQL, HP-UX, Windows NT, Erwin 4.0/3.5.x, MS SQL Server 2000, Business Objects 6.5, Autosys, Unix, Windows XP Professional.

Confidential, HARTFORD, CT

DW Informatica Developer

RESPONSIBILITIES:

• Analyzed and Reviewed teh Business Specification Documents.
• Created UL Monthly mappings like Benefit, Benefit Money, Commission Trans, Financial Trans, Loan Trans, Month aversary using Source Qualifier, Expression, Router, Lookup, Update Strategy, and, Sequence Generator Transformations.
• Created Cyber mappings like Policy Money, Benefit, Policy, Policy Producer Role, and Policy Party Role.
• Created New Business mappings like Processor, Benefit, Policy, and Policy Producer Role.
• Created Title & Beneficiary mappings like Recycletb party, Policy Party Role and Producer Group.
• Extensively used almost all of teh transformations of Informatica including lookups, Update Strategy and others.
• Developed various slowly changing dimensional mappings according to teh data mart schemas.
• Developed extraction mappings to load data from Source systems to ODS to Dimensions.
• Developed Complex mappings in Informatica to load teh data from various sources using different transformations like Custom, Union, Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations. Used debugger to test teh mapping and fixed teh bugs.
• Used Autosys for scheduling teh Jobs.
• Used Business Objects for report creation.

Environment: Informatica PowerCenter 7.1, Workflow Manager, Workflow Monitor, Designer, Repository Manager, Repository Server Administration Console, Autosys 4.0, Business Objects 6.0, ERwin 4.1, TOAD 7.6, Oracle 9i, PL/SQL, UNIX AIX 4.2, Windows XP/2000, OS/390.

Confidential, LOUISVILLE, KY

Informatica Developer

RESPONSIBILITIES:

• Created Technical specifications documents by going through Perl code.
• Analyzed Business requirements and put them into technical specifications
• Created Asset Weekly mappings like Asset Extract, Asset Load and Asset Load Metrics. In dis Extract means extracting data from flat files, Load means Loading data into intermediate tables, Load Metrics is to load data into important view LR.LR SCC METRIC DATA view, other Asset mappings are Asset Finished Goods, Asset Finished Goods FED, Asset Span, Asset Overdue
• Other mappings are Entitlement, Qtr2Date, Financial Targets and Paris Extract, Load and Load Metrics and Sourcing Extract, Load and Load Metrics.
• Extensively used almost all of teh transformations of Informatica including Source Qualifier, Expressions, Lookups, Joiner, Update Strategy and others.
• Developed UNIX scripts to load teh data from relational tables into flat file for which teh source is oracle, which is not supported by Informatica 7.0.
• Worked on Informatica PowerCenter 7.0/6.2 tool - Source Analyzer, Warehouse designer, Mapping Designer & Mapplets, and Transformations.
• Using Workflow Manager for running teh Workflows and Sessions and scheduling them to run at specified time.
• Designed and Customized data models for Data warehouse supporting data from multiple sources on real time.
• Extensively worked wif Informatica to load data from flat files, Oracle, MS SQL server to target database.
• Used Control-M to schedule teh Informatica workflows.
• Used Business Objects for report creation

Environment: Informatica PowerCenter 7.0/6.2, Workflow Manager, Workflow Monitor, Designer, Repository Manager, Repository Server Administration Console, Business Objects 5.1, Control-M, PL/SQL Developer, Oracle 9i/8i, PL/SQL, Unix AIX4.2, Windows XP/2000.

Confidential, ROSELAND, NJ

DW Informatica Developer

Responsibilities:

• Involved in teh Requirement Gathering and Business Analysis.
• Extracted and transformed data from Fixed-Width Flat Files, Delimited Flat Files, COBOL Files, and loaded staging tables using Informatica.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, Mappings, Mapplets, transformations, and re-usable transformations.
• Imported various heterogeneous and homogenous sources using Informatica Source Analyzer.
• Imported and Created Target Definitions using Warehouse Designer
• Developed mappings in Informatica to load teh data into teh Data Warehouse, using different transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Expressions, and Aggregator.
• Created mappings to load staging area, Data warehouse and Data Marts
• Developed various slowly changing dimensional mappings according to teh data mart schemas.
• Developed reusable Transformations and Mapplets.
• Scheduled teh batches to run according to teh user requirements.
• Designed and developed PL/SQL stored procedures to increase teh performance.
• Created and Modified teh sessions; developed different batches using Server Manager.

Environment: Informatica PowerCenter 6.0/6.2, Workflow Manager, Workflow Monitor, Designer, Repository Manager, ERwin, Autosys, TOAD, Oracle 9i, Business Objects, DB/2 UDB v7.1, SQL Server 2000, PL/SQL, T-SQL, Unix AIX4.2, Windows 2000, OS/390.