SUMMARY:

• Seven (7+) years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Designing, testing and documentation. Implementation of Warehousing and Database business systems for Pharmaceutical, Healthcare, Financial and Banking services, Insurance and Data storage systems. Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Seven (7) of strong Data Warehousing experience using Informatica Power Center Tools (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation developer),Informatica Data quality Developer,OLAP,OLTP,Operational Data Sources.
• Developed Batch Jobs using UNIX Shell scripts (csh, bash, ksh) to automate the process of loading, pushing and pulling data from & two different servers.
• Worked extensively with scheduling tools like Control m, Tidal and Autosys.
• Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Two plus (2+) years of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensional tables, Physical & logical data modeling. Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, Type1/2/3 dimension mappings.
• Three plus (3+) years Business Intelligence experience using Business Objects. Good Knowledge of Cognos, Crystal reports and Micro strategy.
• Seven (7+) years of database development and maintenance experience using Oracle, Greenplum, MS SQL Server, Teradata V2R5/V2R4 (Multiload, Fast Load, T - PUMP, BTEQ), SQL, PL/SQL. Used database tools like WinSQL professional, POSGRES sql, SQL*Plus, and TOAD.
• Excellent Verbal and Communication Skills, has clear understanding of Business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

Data Warehouse: Informatica Power Center 9.1/8.6.0/8.1.1/7.1.4 , Informatica Data Quality (9.0.1, 8.6.0), IDQ Developer, OLAP, OLTP, First logic, SSIS, ODI.

BI & Reporting: Business Objects, Cognos Series 7.0/6.0, Seagate Crystal Reports 8.0, Dashboard Development, Micro strategy

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensional Tables, Physical and Logical Data Modeling.

Databases: Oracle 11i/10g/9i/8i/8.0, NETEZZA 4.5/5, GREENPLUM, MS SQL Server 2008/2005/2000 , Teradata V2R5/V2R4/V2R3, SAP R3 and BW, Flat Files, PL/SQL.

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows 2000/XP/98, Linux SUSE 10, HP 9000, Mainframes.

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Sr. Informatica Developer

Responsibilities:

• Interacted with Business analyst and Project Manager to identify the business requirements and data realties.
• Walkthrough the Work Force Management and Confidential project architecture and scopes.
• Worked as Techincal lead about the Informatica Standards and design of new files into Reflexes’ system from different source systems like Vertical system, PIM, 3rd party Rejection rate, Patient adherence calls and RX. Managing four developers, assigning design tasks, and organizing meetings with Project Manager and Business Analyst.
• Imported Source/Target file structures from the respective source files and Business requirement documents.
• Created Mappings in mapping designer with Call counts by each 15-minute time interval for each store, date and time. Created Reusable sessions, worklets and workflows in Workflow manager with Header and Trailer worklets. Header and Trailer worklets used to found out the target file name and number of records in a session.
• Used param file on workflow level to pass hard coded Input, Output, Lookup, Bad files and PM Session log files.
• Performed unit and integration testing, testing the job with 100,000,000 records in a file . Participated in testing with TCOE team and solved the issues raised by TCOE team.
• Created control m jobs and ran manual loads.
• Working with Confidential Drug Info 2.0, Gather the requirements put in a Functional spec and created Technical Design document.
• Based on the requirement documents estimated efforts for Informatica design, development, integration testing, UAT testing, bug fixing, Control M Job design, migrating code with sub version tool.
• Once TD approved by manager and Technical advisors then started creating Oracle tables based on Functional Design document and followed the referential integrity between tables, design of Informatica mappings, sessions, workflows and Control M jobs.
• Moved to Informatica shared folder and started integration testing with testing team and fixing the bugs raised by testing team.
• Gathering all the third party sources (GSDD, RXDW, ENDECA and Bazaarvoice) together and organizing in order to load as per functional document.
• Performed unit a nd system level performance testing. Associated with production support team in various performance related issues. Participated in testing with TCOE team and solved the issues raised by TCOE team.
• Created Unit Test and QA/Peer review documents for the migration of Informatica jobs to next level and written TD (Technical Design) documents by using ICC Utility tool.

Environment: Informatica Power Center 9.1,Oracle, MS SQL Server, Flat Files, Windows XP and 7, UNIX Shell Scripting, Control M, Team Track, Toad, SVN.

Confidential, Southborough, MA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business analyst, Project Manager, Application Lead, BOBJ developers and Greenplum DBA has to identify the business requirements and data realties, Greenplum database architecture.
• Worked with Application lead about the Confidential Informatica Standards and design of new tables into Greenplum and Teradata, Setup of Control M Jobs for that need to know the GDW Dependency jobs.
• Imported Source/Target tables from the respective GDW, SAP BW and RSAM files and created Mappings in Mapping designer with Sequence generator transformation for creating row id’s.
• Created Reusable sessions and workflows in Workflow manager, used Greenplum writer option for fast load of data with Merge Option (Both INSERT and UPDATE) and INSERT/TRUNCATE for deletion of records from target table.
• After loading the Target table based on last Update Date from parameter file we again loaded control table for next run and Control table have columns like session number(Track all the sessions or objects),Workflow name, Session Name, Start and end run time, control id(Sequence key) and Number of rows.
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Worked on SQL tools like SQL Developer/TOAD/POST Gres SQL to run SQL queries and to validate the data.
• Worked on the Greenplum database to create tables and external tables, based on external table created base table and then assigned original data types. After we created mapping with imported source and target with same structure of target and loaded from RSAM flat file to GP Table.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments by using labeling and creation of deployment group .
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues. Participated in testing with TCOE team and solved the issues raised by TCOE team.
• Created Unit Test and QA/Peer review documents for the migration of Informatica jobs to next level and written TD (Technical Design) documents by using ICC Utility tool.
• Provided production support by monitoring the processes running daily.
• Created the control M jobs by using control m tool and run jobs through enterprise manager tool.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards.

Environment: Informatica Power Center 9.1, Power Mart, Power center (Repository Manger, Designer, Workflow Monitor, Workflow Manager),Business Objects XI/6.0,Oracle 11i/10g, Green Plum 4.1, MS SQL Server 2005/2000,Database Systems, RSAM Data, Flat Files, SAPBW, PL/SQL Developer, TOAD,WINSQL, Windows XP and 7, UNIX Shell Scripting, Perl, Control M, SQL*Loader, Microsoft visual studio, HTML 4.

Confidential, Andover, MA

Informatica Developer

Responsibilities:

• Interacted with Business analyst, SAP developers, Clarify (Customer service team) developers and SAP Functional consultants to identify the business requirements and data realties.
• Worked with Functional consultant and SAP developers to design the function modules for extract the data from SAP R3 systems
• Imported Source/Target tables from the respective SAP R3 and BW systems, created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Java, Expression and Aggregator) inside a mapping designer, and created new mappings using Designer. Writing a Function module code in Informatica Power Center and call function module by passing parameters to load the customer healthcare data incrementally and full
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Worked with SAP Developers to create Function modules that can called by passing parameters to fill the transparent (Z Table in SAP) tables for Migration /Loading of Data from SAP IDOCs, SAP R3, SAP BW to Oracle and then loading to external targets like SQL Server and Flat files.
• Worked on SQL tools like PLSQL Developer/SQL Plus/MS SQL Visual studio to run SQL queries and validate the data.
• Worked along with SAP Functional team on SAP Solution manager and service manager tool for transferring or Transporting programs from one level to another level in SAP(Landscape like Development, Integration testing, UAT, Regression testing and Production).
• Worked on the performance tuning of Informatica Power Center Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments.
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues. Created testing documents for the migration of SAP programs to next level for the approval of SAP functional team.
• Provided production support by monitoring the processes running daily.
• Scheduled the Jobs by using Informatica scheduler .
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Involved in designing and developing the reporting requirements by using Business Object 6.0XI, Business Objects Report Designer.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment: Informatica Power Center 9.0.1/8.6.1 , Power Mart, Power center (Repository Manger, Designer, OLAP, Service Manager, Workflow Monitor, Workflow Manager),Business Objects XI/6.0, Erwin 4.5,Oracle 11.5/10g,SQL, PL/SQL Developer, WINSQL, MS SQL Server 2005/2000,Database Systems, Flat Files, SAP, Windows XP, UNIX Shell Scripting, Perl, Tidal, SQL*Loader, Microsoft visual studio, HTML 4.

Confidential, Baltimore, Maryland

Informatica/ETL Developer

Responsibilities:

• Interacted with Business community and database administrators to identify the Business requirements and data realties.
• Worked with Business analyst to take control of enterprise wide data enhancement and cleansing initiatives by Data Quality, Data Explorer and Data profiling by using First logic tool.
• Analyzed the parsed data of Phone, Email, Names, and Addresses in the EDW and understood the existing First Logic rules.
• Worked extensively on the Informatica Developer tool to develop the IDQ mapplets each for Phone, Email, Name, and Addresses to ensure they match the rules in the existing First logic transformations.
• Worked extensively on the Informatica Analyzer tool to do data profiling for validation of the data parsed by the IDQ mapplets.
• Exported these IDQ applets from INFA developer and imported them into the INFA Power Center mappings for integration and tested the functionality to ensure the target data loaded by the IDQ and First Logic is closely matching in EDW.
• Worked on the IDQ maps to source the data from discrete systems such as Netezza, Oracle database and loaded the data into Flat-files for unit testing purposes.
• Worked extensively with NETEZZA as source and target database load and extract I overcome the serialization errors in Netezza by installing Netezza before Informatica installation.
• Worked on database health checks and tuned the databases using Teradata Manager, did error handling and performance tuning on Teradata queries and utilities like Bteq, FastLoad and MultiLoad.
• Extensively worked with Informatica Power Center client tools like Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer.
• Worked with the Informatica Admin during the migration of the Power Center mappings that had IDQ mapplets to production environment and made sure to support them during the initial production run.
• Initial run of Production I participated running the jobs through DAC Schedular tool.
• Worked on SQL Tools like WINSQL to run the SQL Queries to validate the data.
• Created the design documents and held knowledge transfer sessions with the team. Also, assisted the team during the testing of the other INFA power center mappings as part of upgrade.
• SAM development perspective developed mappings that have sourcing from salesforce, Netezza, Flatfiles and loading to oracle. By the Data behavior detection we generate alerts and that alerts send to alert management.

Environment: Informatica Power Center 9.0.1/8.6.1 /7.1.4, IDQ 9.0.1/8.6.1 , Power Mart, Power center (Repository Manger, Designer, OLAP, Server Manager, Workflow Monitor, Workflow Manager), Business Objects XI, Oracle 11.5/10g, NETEZZA, Teradata BTEQ, FASTLOAD and MULTILOAD, SQL, PL/SQL Developer, WINSQL, MS SQL Server 2005/2000, Database Systems, Flat Files, Windows XP, UNIX Shell Scripting, Perl, TIDAL, SQL*Loader, TOAD, First Logic, HTML 4.

Confidential, Buffalo, New York

Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Worked with Business analyst to take control of enterprise wide data enhancement and cleansing initiatives by Data Quality, Data integration and Data Profiling by using tool First Logic.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin.
• Imported Source/Target tables from the respective database and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator) inside a mapplet and created new mappings using Designer module of Informatica Power Center to implement the business logic and to load the customer health insurance data incrementally.
• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively used Experience in Migration /Loading of Data from EXCEL, Flat File, SQL Server By using ORACLE.
• Worked on SQL tools like TOAD/DB2 Visualizer/OS/400 to run SQL queries and validate the data.
• Extensively work on the performance tuning of Informatica Power Center Mappings as well as the tuning of the sessions.
• Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
• Migrated mappings, sessions, and workflows from Development to Testing and then to Production environments.
• Performed unit, integration and system level performance testing. Associated with production support team in various performance related issues.
• Provided production support by monitoring the processes running daily.
• Created Unix Shell scripting to automate the execution of the workflows.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simple ETL coding and mapping standards
• Involved in designing and developing the reporting requirements by using Business Object 6.0XI, Business Objects Report Designer.
• Created various geographical reports like Reports by Policy, Reports by Customer, and Reports by Period, Demographic reports and Comparative reports.
• Involved in writing project documentation using Microsoft VISIO for different diagrams.

Environment: Informatica Power Center 8.6, Informatica Power Connect for DB2,( Workflow Monitor, Workflow Manager), Power Exchange, Business Object XI/6.0, Oracle 9i, DB2 UDB, Database Systems, MS SQL Server 2005/2000, Flat Files, Erwin 4.5,Windows XP, AS/400, HP-UNIX(Reflection Unix, Reflection FTP), Tidal, SQL*Loader, DB2Visualizer, TOAD, PL/SQL, Microsoft VISIO.

Confidential, Boston, MA

Informatica Developer

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Designed and developed solutions for very complex business logics. Designed and build reusable objects (Informatica Mapplets, Sessions, Email Task, Worklets and more) as a Standard for multiple projects.
• For Informatica updated user groups and their privileges, created project folders, deployment groups, labels and deployed objects in ITEST and PROD environments.
• Design and build snowflake schema dimensional models for the first data warehouse of IBT.
• Extensively used ETL and Informatica to load data from MS SQL Server, MS Access, Excel spreadsheet, flat files and XML files into the targets like Oracle, Flat Files, and SQL Server.
• Utilized various Transformations in Mappings like Joiner, Aggregate, Union, Transaction Control, XML SQ, XML Parser, XML Generator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Used various tasks like session, email, command, Event wait, Event raise etc.
• Developed very complex workflows and mappings for complex business requirements.
• Created Windows Batch Scripts for Informatica workflows to start, schedule, unscheduled workflows using pmcmd as well as to modify, delete, rename, move flat files.
• Created UNIX shell scripts for PL/SQL jobs and scheduled them using Corn Tab.
• Extensively used Parameter Files for every workflow to setup Parameters and Variables.
• Created SQL Server stored procedures, tables and imported them in Informatica.
• Created modified Oracle objects, PL/SQL functions, procedures, packages, triggers and global objects.
• Supported all the Informatica workflows for MFA Systems as SME.
• Created UNIX shell scripting and automation of Oracle processes using Crontab.

Environment: Informatica Power Center 8.1,Oracle 9i, SQL Server 2005, XML, Excel 3000, Flat Files (CSV, Fixed Width), SQL*Plus, PL/SQL,SQL developer, SQL Query Analyzer 8.00.194, Database Systems, TOAD 8.6.1, Windows XP, Outlook Prolify.

Confidential

Informatica Developer

Responsibilities:

• Experience with ETL/ETI (Informatica) (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database.
• Created different transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Reused mapping, Mapplets and transformations.
• Scheduled sessions and batches on the Informatica Server using Informatica Server.
• Tuned the transformations and mappings in Informatica.
• Implemented slowly changing dimensions.
• Developed Unix Shell Scripts and PL/SQL procedures.

Environment: Informatica Power center 7. 1, Shell Scripts, Database Systems, SQL and PL/SQL, Windows NT, Oracle8i and UNIX.

Confidential

Programmer Analyst

Responsibilities:

• Designed all input forms
• Created users, groups and setup general security options and server access options
• Created views for different access level
• Designed navigators for different views
• Developed agents to automate tasks, accomplish several functions and sending e-mail.

Environment: Oracle 8.0.3, PL/SQL, SQL*Loader, Windows