SUMMARY:

• 20+ years of total IT experience, in Business Requirement Gathering, Analysis, Application Design, Data Modeling, Development, Migration, Implementation and Testing of Data warehouse applications for Power sector, Pharmaceutical, Financial, Healthcare and Insurance industries.
• Around 15+ years of Data warehousing experience utilizing Informatica 1.7 / 4.x / 5.x / 6.x/7.x/8.x (High Availability, Team Base)/9.x for ETL (Extract, Transform, Load) on Sun Solaris, Linux, AIX, HP - Unix and Windows operating systems.
• 8+ years of Data Modeling experience using Relational, Enterprise and Dimensional Data modeling, Worked on various architectures like Independent, Bus Architecture, Hub-and-Spoke ( corporate information factory), Centralized Data Warehouse & Federated Architecture and created Physical & logical data modeling using ERWIN 3.x/4.x/7.x
• Extensive knowledge in OLAP Tools such as, Business Objects 5.1.1 (Supervisor, Designer & Web Intelligence 2.6) & Cognos (Impromptu administrator 5.0, Power Play 6.5, Scheduler 5.0, Impromptu Web Reports & Script Writer).
• Developed database oriented web sites using Active Server Pages (Asps), VB Script, Vignette Story Server 4.2/5.0/5.5/5.6, TCL 7.6/8.2 and JavaScript.
• Extensive 10+ years of database experience using Oracle 11g/10g/9i/8i/7.x (PL/SQL, SQL*Plus, Developer 2000), Sybase SQL Server 12.0/11.x,Teradeta V2R 4.0/5.0/12/15, Netezza 4.0.x/3.x, DB2, MS SQL Server 2000/7.0/6.5, MS Access 7.0/2000, and Informix on Win 3.x/95/98/2000, Win XP, Win NT 4.0, HP-UNIX 11.1 and Sun Solaris 2.x.
• Experience with total of Eight ETL integration efforts of various data sources into staging area, ODS, Warehouse and to Data Mart; Installation and Administration of Powermart/Powercenter, Developed common logic using reusable transformations and Mapplets.
• Lead the technical teams for On-shore/Off-shore Global delivery. Interaction across all levels of Business and Technology management. Strong and effective management of technology, process and people. Mentored and developed junior staff members.

TECHNICAL SKILLS:

Technical: Sun Solaris 8, IBM AIX 4.3.3, HP UNIX 11 and Windows NT/2000; JavaScript, Vignette Story Server 4.2/5.0/5.5/5.6, TCL 7.6/8.2, Shell Programming, PASCAL, COBOL, PL/SQL; Oracle 11g/10g/9i/8i/7.x, MS-SQL Server 2000/7.0/6.5, DB2 UDB 7.0, Netezza 4.0.x/3.x, Teradeta V2R 4.0/5.0/12/15 and MS Access; ASP, Visual Basic 6.0, Forms 6i, Reports 6i; Informatica (Power Mart/Power Center 4.7/1.7/5.1/6.1/6.2/7.1/8.1.1/8.6/ 9.1.0/9.5.0 /9.6.1 ), Power Connect 8.x for SAP/Peopesoft/DB2/ Netezza/Siebel/TPT, Power Exchange 5.1/8.x, Informatica B2B Data Exchange 8.6.1/8.6.2, Metadata Manager 8.6.1,IDE 9.1.0/9.5.0, IDQ 9.1.0/9.5.0, Web Services, Data Mirror 6.0, Kimball Methodology, Cognos (Impromptu administrator 5.0, Power Play 6.5, Scheduler 5.0, Impromptu Web Reports, Script Writer), Business Objects 5.1.1 (Supervisor, Designer, BO) Web Intelligence 2.6, Erwin 3.x/4.1/7.2.5, Trillium 5.0, Toad 7.4/8.5/9.2, SQL Navigator 4.1/3.2/5.5.2.742, composite 4.6/Data Federation 8.6.1, XML, Visual Source Safe, Web sphere, Apache Web Server and IIS.

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville,PA/ Peapack,NJ/Madison,NJ/Groton,CT

Technical Consultant

Responsibilities:

• Created and executed profiles in Informatica Developer to discover data quality issues in a data set and to understand the relationships between columns in a data set.
• Worked independently to create ad-hoc analyses and troubleshoot issues at the request of users.
• Worked closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs. performed peer code review, analysis, requirements gathering, assisting offshore developers, developed/Tested ETL objects
• Hands on development of the POC and Framework, used/managed Offshore and Onshore implementation team to deliver in a significantly reduced time to meet the aggressive time line.
• Prepared architectural guideline documents related to data naming standards, list of valid class words, naming and abbreviation standards glossary (.nsm) which can be imported in ER-Win
• Performed End to end Data analysis and Data Lineage tracking from Source System Target Downstream System and Conduct data analysis and investigation when issues with data are identified
• Documented Best Practices and troubleshooted complex situations land modified the code behave optimally and efficiently.
• Responsible for migration of data out of STAR system to oracle database. Designed the logical and physical data models, provided data flow diagrams, transformation logic, source to target data mapping spreadsheets, data dictionary etc.
• Drive discussions with business partners to extract and document the requirements and critical business logic necessary for the data and operational reporting needs of the business lines, and recommend solutions to enable the business lines to meet their goals.
• Create end-to-end data and business flows, leveraging insight maps to visualize and expose impacts, independencies, duplication, fragmentation, and more using various facets of AXON
• Hands-on experience using Informatica Data Services (v9.x), Data Quality Developer (v9.x) and Informatica Data Quality Analyst tool (version 9.x) to analyze, profile, and develop cleansing and standardization rules, EIC, AXON 5.0 HotFix2
• Developed reusable codes, data look-ups, common mapplets to handle error logging and Error handling, Data exception logging.

Environment: ETL-Informatica - 10.2/ 9.1.0/9.5.0 /9.5.5/9.6.1/8.1.1/8.6(High Availability, Team Base), IDS 9.5.0, Power Exchange/Connect 8.0 (for CDC), IDE 9.1.0, IDQ 9.1.0, Web Services, AXON 5.0, EIC, composite 4.6/Data Federation 8.6.1, Power Center Metadata Manager 8.6.1, Sales Forge, Veeva, OBIEE, Spotfire, Trillium 5.0, Tableau, Business Objects, Teradata 15/12 (fastload, multiload & tpump), PowerExchange for Teradata Parallel Transporter API, Oracle 10g/11g, SQL Loader, MS SQL Server 2000, SQL Navigator 5.5/4.1/3.2, Flat Files, Toad 9.1.0.62 /8.5.1/, Visio 2007, ERWIN 3.5.2/4.x/7.2.5, SharePoint, Shell Script, Unix SUNOS 2.8 and Windows XP.

Confidential, Swiftwater,PA

Technical Consultant

Responsibilities:

• Served as DW/ETL Architect for a global strategic enterprise implementation of Sales & Marketing DW and Operational Data store.
• In-depth knowledge on Informatica B2B Data transformation for Complex XML parsing.
• Reduced time to market for New product On-boarding from 12 months to 8 weeks.
• State of Art Error management and exception handling Strategy.
• Designed Complex DB model for and, Transaction and data quality Exception.
• Provided suggestion to improve Enterprise Architecture (Advanced XML like FTML) for the benefits of data sourcing for Data warehouse and the Down Stream consumers.
• Documented Best Practices and troublesooted complex situations like resource, cpu usage and modified the code behave optimally and efficiently.
• Developed reusable codes for B2B XML Parsers, data look-ups, common mapplets to handle error logging and Error handling, Data exception logging.
• Designed the parameterized code base to support multiple environment with multi-Stacks.

Environment: Oracle 11g (v2), Informatica 8.6.1 (HF-12)/9.x, sql/Plsql, ksh, Sybase Power Designer, MS Visio, B2B Data Studio 8.6.2, Power Exchange (SAP), Auto Sys.

Confidential, Broadway, NY

Technical Consultant

Responsibilities:

• Managed the ETL offshore developers and ETL functions within the Data Warehouse group
• Assist team members in developing complex ETL using Informatica, SQL and UNIX Shell Scripts to meet data load requirements of business
• Provided technical leadership and consider long-range technical issues
• Forecasting the completion dates and reliably delivering against those estimates for projects and work requests
• Allocation of team members to projects and work requests to ensure project schedules are met
• Interface with business users, project managers and technical teams to define requirements and specifications
• Technically Responsible for:
• Involved in Tuning SQL, PL/SQL codes, Stored Procedures and Database Trigger .
• Work with the Data Warehouse Reporting team, Web Engineering team and Business Systems team to understand data sources and implement new requirements
• Developed various mapping using Informatica Power Center, Testing the mapping.
• Responsible for mentoring various team members with Informatica and the overall architecture of the ETL process.
• Automated the Process for scheduling the job using Autosys Scheduler and from UNIX command line.

Environment: ETL-Informatica - 8.1.1/8.6(High Availability, Team Base), Oracle 10g, Autosys, Unix, Erwin 7.2 and HP UNIX

Confidential, New London, CT

Technical Consultant

Responsibilities:

• Analyze and design Common Dimension Layer (CDL) and implemented Slowly Changing dimensions (Type1, Type2, Type3 & Type 6).
• Created projects estimates and developing various scenarios to come up with the best.
• Wrote documents for ETL mapping design, error log design, Data load strategy, unit and system testing, system migration and job schedules.
• Implement a zero-defect data quality process that includes rigorous checkpoints throughout the systems development lifecycle (SDLC), regression testing, end-to-end traceability of data transformations, and automated reconciliation
• Resolved data and process support Issues. Defined and deployed QC process to help the Business Team to cleanse the source data.
• Analyzes 3rd party clinical trial flat files data from CRO/IVRS, FSP, ClinPhone and designed/developed mappings.
• Designs overall error handling strategies, loading strategy’s for various projects.
• Helped the ETL Testing team for effective testing of transformed data and defining the test cases.
• Designed Packages to make changes to “Unix/Perl/Netezza SQL Scripts”. Implemented designed Packages by using check in and check out process.
• Creates materialized views, table partitions, dynamic index (Bitmap, B-tree) creations, analyzed tables and indexes, Wrote Optimal PLSQL packages and procedures using bulk collect and bind methods. Tuned query for source data selection and populating fact and summary tables.
• Implemented Change Data Capture (CDC) technique to detect the changes and load accordingly into the warehouse.
• Ensured deadlines are met; all best practices and enterprise standards are followed.
• Working with Power Exchange Client for Power Center in real time extract changed data that represents the changes to a source from the change stream.
• Worked with various transformations like SQL, Flexible Key, Application source qualifier, Application Multi Group Source Qualifier etc.
• Conduct code reviews and enforce quality standards for changes and enhancements
• Worked on Data Mirror for creating a pro-type project for Oracle Clinical.
• Performed ETL performance tuning with modifying Index and Data Cache size, DTM Buffer size, Pipeline Partitioning, defining additional partition points and modifying partition type.
• Handled tables from 30 millions to 2 billion records using various techniques like brute force, CDC, timestamp and difference of views.
• Acquired knowledge on service oriented architecture of informatica 8.x

Environment: ETL-Informatica - 8.1.1/8.6(High Availability, Team Base)/6.2.2 Power Center, Power Exchange/Connect 8.0 (for CDC), Power Exchange (for SAP), composite 4.6/Data Federation 8.6.1, Power Center Metadata Manager 8.6.1, Trillium 5.0, Business Objects, Oracle 8.2.74.32/9.2.0.6 64/10 g, SQL Loader, MS SQL Server 2000, SQL Navigator 5.5/4.1/3.2, Flat Files, Toad 9.1.0.62 /8.5.1/ 8.0/7.2, Visio 2003, ERWIN 3.5.2/4.x/7.2.5, Live link, SharePoint, Concurrent Version System (CVS), Data Mirror 6.0, Tortoise, Shell Script, Unix SUNOS 2.8 and Windows 2000/XP.

Confidential, Bridge Water, NJ

Lead. Data Warehousing Developer

Responsibilities:

• Decided the error handling, reconciliation process and educated the developers.
• Interacted with business users and gathered the requirements and detailed out into technical specification for PCSA.
• Created data base objects for updating protocol category and subject area on HTS, DG and LTS (operational data base) and RSDB (Warehouse database).
• Created MS-DOS command files and SQL scripts for the conversion process.
• Created procedures, functions, triggers, packages for the target system, which is Activity Base 5.0.10 database schema implemented on Teradata, Oracle Database sever and RSDB data warehouse.
• Worked extensively on various Teradata load utilities like FastLoad, MLoad & TPump to populate data into Teradata tables.
• Created test plan, test design, test cases, test reports and anomaly reports in the process of testing the application.
• IDBS Activity Base is a suite of applications to capture, analyze, manage, and utilize biological and chemical data.

Environment: ETL-Informatica - 7.1 Power Center, Teradata V2R4.0, Oracle 8i, Visio 2003, IDBS Activity Base 5.0.10, SQL-loader, Toad 7.x, HP-Unix 11.1

Confidential, Canal Street, NY

Technical Consultant

Responsibilities:

• Installation, configuration and optimization of Informatica on Windows 2003.
• Gathered requirements from the business users and business analyst and created estimates for Informatica mappings.
• Identified and mange project risks, define standards, issues and conflicts
• Prepared the functional requirements by inter acting with the business users, high-level & low-level design documents.
• Decided the error handling, reconciliation process and educated the developers.
• Defined ETL design and implementation standards and procedures for MIG2, FIS, MTS and MDS systems

Environment: ETL-Informatica - 7.1 Power Center (Designer, Repository manager, Workflow manager, Workflow Monitor), UDB DB2, COBOL, Informix, MS SQL Server 2000, Cognos Report net 1.1, PVCS, Visio 2003, ERWIN and Windows 2003

Confidential, Juno Beach, FL

Lead Data Warehousing Developer and data analyst

Responsibilities:

• Worked as a Lead ETL Developer on this project
• Prepared the functional requirements by inter acting with the business users, high-level & low-level design documents and translates them into source to target matrix.
• Decided the error handling, reconciliation process and educate the developers.
• Prepared the data base entities and their fields, which can handle the business logic, error handling and reconciliation process.
• Created the db object scripts and executed them in database successfully.
• Prepared the test scenarios and test the total process in Test & QA environment.
• Based on the System Delivery Specification (SDS) prepared transformation matrix (Mapping Specifications), Source layouts and Target layouts for AMS/DMS/DSS.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager, Workflow Monitor. The objective is to extract data from FACT, Oracle and to load finally into a Oracle.
• Developed and implemented Error Handling Strategies.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed process flows, functional specifications and technical specifications for developing Informatica mappings.
• Executed all the mappings and sessions in Development, Test and QA using workflow Manager.
• Benchmark testing of Hardware Vs Process Speeds for Informatica mappings to calculate the lead times for batch processing.
• Developed common logic for AMS/DMS project using Mapplets.
• Developed integration test plans, test scenarios, test schedules, and Validated test scenarios during AMS/DMS integration
• Developed, Migrating from QA to production and tested all the backend programs, Informatica mappings and update processes.
• Extensively used Informatica variables and parameters to develop PPD stack mappings.
• Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints optimized for maximum performance
• Involved in migrating existing 5.1 repositories into 6.1 (version migration)
• Tuned the mappings using Power Center- Designer perform better using different logic’s to provide maximum efficiency and performance complete
• Extensively used various transformations like connected, unconnected, dynamic lookup's, normalizer, store procedure, router etc.

Environment: ETL-Informatica - 6.1 Power Center (Designer, Repository manager, Workflow manager, Workflow Monitor), Oracle 8i, Teradata V2R4.0,Cognos 6.1, SQL Navigator 4.1, PVCS, Visio, ERWIN, Shell Script and AIX-UNIX

Confidential, Bridgewater, NJ

Lead Data Warehousing Developer

Responsibilities:

• Based on the System Delivery Specification (SDS) prepared transformation matrix (Mapping Specifications), Source layouts and Target layouts for FIRST DATA BANK DRUG FILES and IMSRxDM.
• Analyzed the systems, met with end users and business units in order to define the requirements, while working with Business Analysts.
• Created inbound XML target definitions from a DTD and Schema files.
• Involved in designing process flows, design documents, field to field matrixes and data analysis.
• Created Inbound XML target definitions based on relational sources.
• Used various transformations like sorter, router to build mappings for IMSRxDM and First Data Bank (MDDB).
• Extensively used Transformation Language Components to build mappings for Manufacturer, Standard form type, Standard Package Type, Product USA etc
• Used Mapping Variables and Mapping parameters for building mappings for USAFNCMDDB.
• Developed reusable Mapplets and Transformations
• Developed and Implemented error-handling strategies for First data bank and IMSRxDM data.
• Developed various mappings for First Data Bank File MDDB), implementations which has to maintain accurate and timely NDCs-UPCs-HRIs and NDC-UPC-HRI information, so that processing of prescription drug data for healthcare applications is correct and complete.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager, Workflow Monitor. The objective is to extract data from FACT, Oracle and to load finally into a XML and Oracle.
• Extensively used Tasks (SESSIONS, EVENT RAISE & DESISON), Workflow and Work lets.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Tuned mappings using Power Center- Designer to perform better using different logics to provide maximum efficiency and performance complete.

Environment: ETL-Informatica - 6.1 Power Center (Designer, Repository manager, Workflow manager, Workflow Monitor), Toad 7.4, XML, Oracle 8i/9i, Visual Source Safe ReflectionX, Java, Syncsort, Web sphere application server, XML SPY, EJB, JDBC, JSP, Shell Script and HP/UNIX 11.1.

Confidential, WI

Data Warehousing Developer

Responsibilities:

• Analyzed the systems, met with end users and business units in order to define the requirements, while working with Business Analysts.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Have a thorough understanding of these current and potential requirements helped the Data Architect, and Project Manager to design a flexible and scalable solution that meets the needs of the business community.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Maintained and improved integrity by identifying and creating relations-ships between tables
• Developed and implemented Error Handling Strategies.
• Developed data Mappings between source systems and warehouse components.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• The objective is to extract data stored in different databases such as Oracle and DB2 and to load finally into a single Data Warehouse i.e. DB2.

Environment: ETL-Informatica - 5.1 Power Mart/Power Center (Meta Data Repository, Designer, Server Manager), Power Connect for Main Frames 3.1.0, Business Objects 5.1, Web Intelligence 2.6, Broad Cast Agent, Oracle 8i, DB2 UDB 7.0, SQL, PL/SQL, Erwin, UNIX Shell Script, IBM AIX 4.3.3, and OS 390.

Confidential, CA

Data Warehousing Developer

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created and Monitored Sessions and Batches using Informatica Power Center Server.
• Managed the Metadata associated with the ETL processes to populate the Data Warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in the performance tuning of the mappings, ETL Procedures and processes.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Repository Manager and Server Manager.

Environment: ETL-Informatica - Power Center and Power Mart 1.7.2/5.1/4.7.2/5.1 (Meta Data Repository, Designer, Server Manager), Business Objects 4.1.5, Web Intelligence 2.6, Broad Cast Agent, Oracle 8i, MS SQL SERVER, SQL, PL/SQL, Erwin, SQL*Loader, Shell Script, SUN Solaris, Win 2000/NT.

Confidential, CA

Data Warehousing Developer

Responsibilities:

• Involved in designing technical specifications for building Data Mart.
• Project life cycle, from analysis to production implementation, with emphasis on testing plans, execution, analysis, and results.
• Worked on Informatica Designer tool in developing mappings and mapplets to extract and load the data from flat files, Oracle, SQL Server, DB2 databases to Oracle.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.,
• Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints optimized for maximum performance.
• Creating and running Sessions & Batches using Server Manager to load the data into the Target Database.
• Testing for the Data integrity and Consistency.
• Documenting the issues related to cleansing of the Data.
• Tuned the mappings using Power Mart- Designer perform better using different logic’s to provide maximum efficiency and performance complete.
• Created Effective Test Data and Unit Test cases to ensure the successful execution of the data loading processes.

Environment: ETL-Informatica -Power Mart, Power Center 1.5/1.7 (Meta Data Repository, Designer, Server Manager), Oracle8.x, MS SQL Server 6.5, PL/SQL, SQL Navigator, Erwin 3.5, Cognos- Impromptu, Power Play and Transformation server, WinNT & UNIX.