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:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

• Confidential is a second largest company that sells prescription drugs and worldwide assortment of general merchandise, including over-the-counter drugs, beauty products and cosmetics, film and photo finishing services. It provides Minute Clinic healthcare clinics as well as their Diabetes Care Centers.
• Worked on WFM Work Force Management project it requires Front store and Pharmacy point of sale transactions in order to identify labor demand for front and pharmacy store related activities. As a team member in this project, I learn in out operations of CVS stores and ease functioning of such a huge chain of stores.
• Interacted with Business analyst and Project Manager to identify the business requirements and data realties. Walkthrough the Work Force Management and CVS.COM 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.
• CVS.COM Drug Info 2.0 is a project that supports CVS.COM website that has drug info pages with drug information in it. My roles is to provide the data to CVS.COM database by extracting data from different externals sources like Gold standard Data Third party tool , RX Connect data, Endeca and Bazaarvoice.
• Working with CVS.COM 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 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.

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

Sr. Informatica Developer

• Confidential is a company that develops, delivers and supports information structure and virtual infrastructure hardware, software and services. EMC's product line ranges from enterprise storage arrays to content management systems to storage area networks, backup, recovery and archiving solutions and information security.
• The Objective of the BIAAS BI as a service Project is to deliver customer data for the Analytical use and give support for the Greenplum data warehouse users. Loading the data to Greenplum database extracting data from GDW Global Data Warehouse-Oracle , SAP BW and ECC of EMC.
• 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 EMC 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

Informatica Developer

Confidential is one of the largest electronics companies in the world .Philips organized in a number of sectors like Philips consumer lifestyle Consumer electronics and Domestic appliances, personal care , Confidential

• The objective of the project APEX Availability and performance in excellence is to give the Materials, Equipments and Customer, Contract etc details to Philips customer service system Clarify for there customer support.
• Objective of Consumer Objects project is to extract the data from BW systems to comops system by incremental loading and full load for Business expansion.
• 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

Informatica/ETL Developer

• TD Ameritrade is a leading financial and stock brokerage company that offers trading of stocks, futures, ETFs, Option, mutual funds, fixed income and cash management services.
• The objective of this project was to upgrade the existing Informatica INFA Power Center versions 7.1/8.1 to Informatica 9.0.1. As part of this upgrade project, we also had to convert the existing First Logic FL code into Informatica Data Quality IDQ as FL is not supported by INFA 9.0.1.
• Other then UPGRADE project, I also involved in the development of SAM Supervision Assistance Module lead by Mantass.SAM mainly considers the supervision of AML Anti money laundering and BCTC Brokerage compliance and Trading compliance .Main Functions are Advisor direct,amerivest,fixed income and other solicited trades,Bonds,stocks of ameritrade.

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

Informatica Developer

Confidential Inc is one of the leading health insurance companies in Western New York, providing innovative health plans, dental and vision benefits, pharmacy benefit management services and other short-term healthcare plans. The project was aimed to build a data warehousing EMPI Enterprise Master Person Index system which received three types of Source Data- Member, Employer and Provider Office record, Physician Manual Reference for the customers who have different health insurance policies for better understanding and improving processing efficiency. The functionality of this project was to get data from various OLTP application sources and selectively extract, transform and load it into the Oracle/DB2 data warehouse using Informatica Power Center 8.1 tool and then transform data from data warehouse into an OLAP server to provide Business Intelligence Analysis services.

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

Informatica Developer

Confidential and Trust is a leading finance company providing financial services to various clients located in Europe and America. Investors Bank Trust processes securities for such financial asset managers as mutual funds, investment advisors, banks and insurance companies. IBT primary securities services are fund accounting, custody, fund administration and transfer agency services. Working with the financial data is always challenging and we build many custom complex applications for our clients.

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

Developed mappings for various application groups such as Purchase Order management, customer relations, and sales.

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

Engineering maintenance system is a web based intranet application. In large organizations maintenance of the machinery is a big task as it involves learning all details of every equipment, its previous problems, the solutions worked out etc. To schedule the tasks of maintenance and to help the engineer collect all information of the machine including a printout of the machine diagram before going to service it, this application is designed. There are three modules in this project Maintenance Scheduling, Problem logging and Reports. Users will log the complaint online in their system, which is reflected at the engineering department. The user can also check the status of his complaint. Depending on the problem severity the department will respond to problem without the effecting the production. This application has also been integrated with other applications in the organization.

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