SUMMARY:

• Multifaceted ETL Lead with over 12 years of diversified, enterprise level experience aligning and translating business and technical requirements into technical specifications and data models, implement and support large scale backend enterprise level operational business/Business Intelligence systems, data warehousing, MDM Hub Formerly Siperian, web development, database analysis, functional/design specifications, coding, system testing, implementation and post implementation data support.
• Strengths include working with the business stakeholders to developing a big picture view while maintaining a holistic, detailed approach to data transformations that include:
• Collaborating with business users and development team to design, develop and implement data warehousing projects.
• Providing a holistic, detailed approach of understanding dimensional data models for Data warehouse projects and building reporting environments.
• Designing and developing ETL applications to populate the data warehouse and dependent data marts.
• Review and participate in design, development, testing and implementation of the data warehouse applications.
• Producing detail functional and technical documentation for all phases of the data warehouse.
• Following software development standards and procedures.
• Providing on - going support of existing warehouse as well as continually re-evaluate current processes and techniques for increased efficiency and Maintainability.
• Ensuring completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements.
• Maintaining an awareness of existing, new and emerging data warehouse technologies.
• Providing detailed estimates of time for each phase of the software development efforts.
• Developing test plans and test applications at the unit level.
• Proficiently applying appropriate methodologies to support the creation and maintenance of business objects universe and reports to support customer Requirements, ensuring the integrity of data and data feed, identifying relationships between data.

TECHNICAL SKILLS:

Middleware: BEA Web logic Server 7.1/6.x

Software: Informatica 9.1, 8.1/7.2.7.1/6.2.2/5.1/4.7 (Power Center, Power Mart, Power Connect, Informatica Profiler, Informatica Data Quality8.5,9.1, Data Explorer 9.1, Business Objects 5.x, 6.x, Cognos, Cognos Impromptu, Framework Manager and Powerplay,Crystal Reports 8.0,9.0, ERWIN, Siebel Analytics(OBIEE), DAC, Business Object Data Integrator 11.7

Databases: Oracle 11i/9i/8.x, DB2, UDB, SQL Server 2005/7.0/6.5, MS Access 7.0/2000

Operating System: Windows NT/XP/2000, HP-UX, Solaris 2.6/2.7/2.8

Languages: PL/SQL, UNIX Shell Scripting (Bourne Shell, Korn Shell), SQL, VBScript

PROFESSIONAL EXPERIENCE:

Confidential (Boston, MA)

Responsibilities:

• Integrated Provider Management (IPM) refers to the tools, applications, methodology and strategy used to re-architect how the corporation stores, utilizes, accesses and maintains provider information, leveraging McKesson’s Portico platform.
• Gathered requirement of business for each component such as Migration, Integration and Outbound
• Estimate the scope of work effort and assess the timeline, resource and cost of the project.
• Assess requirements for completeness and accuracy.
• Designed and architected overall ETL process
• Collaborated with product development team and ensure client satisfaction
• Used Informatica IDQ for Data cleansing.
• Presented Data Cleansing Results and IDQ plans results to the SMEs.
• Migrated Network Pro data and loaded to McKesson’s Protico platform
• Documented functional, technical and business requirement

Environment: Informatica 9.0.1, IDQ 9.0.1, Oracle 11i, Erwin 7.2.Toad,Sql server

Confidential (New York)

Responsibilities:

• Provides a comprehensive inventory and understanding of inbound data across Risk and Finance that sets the basis for rationalization with supplier system and organizations.
• Set up IDE lab
• Analyze data and profile data for overlap and duplication

Environment: Informatica 9.0.1, Data Explorer9.0.1, Oracle 11i, Erwin 7.2., MDM (EBX5)

Confidential (New York, NY)

ETL Lead Developer

Responsibilities:

• MDM Initiative/EDA (Enterprise Data Architecture) - Confidential is the National Corpsof outstanding recent college graduates of all academic majors who commit two years to teachin urban and rural public schools and become lifelong leaders in the effort to expand al opportunity. Every Person that is hired by Confidential (TFA) goes through a number of steps from recruitment to becoming a Corps Member. Different department handles every Step start to finish up till now every department had their own database. Master Data hub integrates alldepartments’data to a centralized database and gives one complete picture of the Candidate, as he or she goes through the complete workflow cycle.
• Extracted data from various application such as SFDC, TALEO, MDR, TFANET, OIM, Red Wood and Workday data.
• Loaded data to MDM Base table
• Used power exchange and Web services to extract data from Workday and SFDC data.
• Developed and maintained complex Informatica mappings.
• Used Informatica Data Masking transformation to mask the data
• Design the ETL based on the project requirements and client guidelines.
• Created reusable components, developed Error handling.
• Created complex work flow run nightly and daily jobs
• Migrated Sales Logic and Raiser's edge data to Sales Force using Power Exchange for Sales ForceResponsible for cleansing, matching and merging school and principal data from Sales force.com and updated back Saleforce.com with cleanse data.
• Worked with business SMEs on developing the business rules for cleansing.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Used Match and Marge functionality before uploading data back to SFDC
• Integrated IDQ with Informatica mapping.
• Presented Data Cleansing Results and IDQ plans results to the SMEs.
• Documented Cleansing Rules discovered from data cleansing and profiling

Environment: Informatica 9.0.1, Informatica Developer 9.0.1, Oracle 11i, Erwin 7.2., Sales Force, MDM (Formerly Siperian), SOA/ESB, Data Validation, Unix AIX

Confidential (Falls church, VA)

ETL Lead

Responsibilities:

• DMHRSi, a human resource management support tool, is the source for all human resource data in DoD Health Affairs as well as the official HR management/reporting system
• Installed and configured Informatica Power Center and Data Quality software in Unix server
• Analyzed source data, created prototype for the using Informatica. Designing overall ETL process to load date to DMHRSi environment
• Interacted with Informaticavendor technical team to resolve issues with Power Center and Data Quality
• Developed overall ETL Architecture for project
• Worked with Enterprise Architect team to create data mart
• Supported, monitored and tuned Informatica ETL processes.
• Developed and maintained complex Informatica mappings.
• Perform data validation tests using complex SQL statements.
• Informatica administration functions including server upgrade, mapping and session migration, user administration and performance tuning.
• Developed documentation, for both business and technical staff, related to my activities.

Environment: Informatica 8.6.1, Oracle 11i, Oracle HRMS, Erwin 7.2. Informatica DQ 8.6.1, Metadata 8.6.1 Manager, Unix AIX

Confidential (Tulsa, OK)

ETL Lead

Responsibilities:

• Designed and developed over all ETL process to load data from SAP and non - SAP systems to Enterprise Data Warehouse
• Developed test plans

Environment: Informatica 8.1,Business Objects XI 3.1, Web, Designer, Reporter, Web Intelligence and Info View, Business Objects Performance Manager, Windows NT, Oracle 11i, Erwin 7.2. SQL Server 2005,SAP

Confidential (New York, NY)

ETL Lead

Responsibilities:

• Overall responsibility for the backend ETL development of global, enterprise digital and traditional media performance and campaign management systems for the inclusion of a global business intelligence solution.
• Designed and developed mappings that extract data from various source systems such as Yahoo, Google, Monster, DFA, Atlas, third part data sources
• Collaborated with global and local teams in EMEA, Pacific Asia and Ann Arbor on technical and business specifications
• Installed Informatica Power center in Windows Enviornment
• Fine-tunedInformaticamappings
• Built a comprehensive scheduling system to run the job in parallel by usingSql
• Built the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
• Developed BO reports by using Web intelligence Rich client
• Analyzed master data for Media data and Created Data mart for Media Flow reporting system.

Environment: Informatica 8.1,Business Objects XI 3.1, Web, Designer, Reporter, Web Intelligence and Info View, Business Objects Performance Manager, Windows NT, Oracle 11i, Erwin 7.2. SQL Server 2005

Confidential (New York, NY)

ETL Lead Developer

Responsibilities:

• Responsible for gathering requirement for DSNY (Department of Sanitation), created design document, source to target mapping doc, analyze data and wrote business rules to extract data from the flat file to oracle database.
• Created over 20 mapping to load DSNY data mart, tested and configured the task to run on a DAC(Data Access control)
• Worked on full life cycle of project of DSNY (Department of Sanitation) datamart
• Used EXPLAIN PLAN tune SQL queries
• Used Data Quality Workbench to design, test and deploy data quality
• Used OBIEE Siebel Analytics create a report

Environment: Siebel Analytics (OBIEE), Informatica Power Center 7.2,8.1 Windows NT, Oracle 11i, Erwin 4.0. Toad, Unix AIX

Confidential (Emeryville, CA)

Senior Data Warehouse ETL Engineer

Responsibilities:

• As a Senior ETL Engineer, worked on Supply Chain, POS, Forecast and Sales Analysis subject areas of the Enterprise Data Warehouse
• Supported the datamart environment with over 100 Cognos reports and 13 CognosPowerPlay Cubes
• Installed and configured Informatica 8.1 and migrated all the mapping 7.1
• Tested, debugged and maintained over 50 Informatica mappings
• Responsible for production and administrative support for the data warehouse environment and ETL processes. Some of the tasks involved are scheduling, loading and monitoring the ETL process on daily basis
• Participated in migration of Oracle application from 11.3 to 11i.and Informatica to the Unix environment
• Created Forecast Datamart - Data Model, physical tables, mapping
• Extensively used Erwin for data modeling and Dimensional Data Modeling
• Used EXPLAIN PLAN, TKPROF to tune SQL queries
• Performance tuning using round robin, hash auto key, Key range partitioning.

Environment: Informatica Power Center 7.1,8.1, Informatica Profiler, Windows NT, DB Artesan, Oracle 11i, Erwin 4.0. Toad, Cognos 7 v2, Cognos Impromptu and Powerplay, SQL server, Unix

Confidential (San Ramon, CA)

Senior Informatica Developer - Data Warehouse

Responsibilities:

• This Project is Pricing Automation data warehouse which has centralized data for product sales
• Modified some of the mappings according to the design document
• Performed edit checks on all the mappings
• Performed data cleansing and cache optimization
• Worked on several transformations such as Source Qualifier, Filter, Aggregator, Stored Procedure, Lookup, Router, Update Strategy, Sequence generator transformation
• Created UNIX Shell Scripts for job automation of data loads

Environment: Informatica Power Center 6.2, AIX 5.2, Windows NT, Oracle 9i, Teradata, TPump, Multiload, Fastload, SQL/PLS designer

Confidential (Walnut Creek, CA)

Senior Informatica Developer - Data Warehouse

Responsibilities:

• The PHSCDW data warehouse project is to integrate Northern and Southern California data sources to provide one integrated data
• The PHSCDW ETL process provide business users with clean and integrated pharmacy supply chain data from different NCAL and SCAL source systems
• The PHSCDW is used for analysis and reporting across NCAL and SCAL region
• Responsible for designing, developing and testing the ETL processes using Informatica 7.1, PL/SQL and UNIX shell scripts to maintain the data marts
• Created mappings, mapplets and workflows
• Worked with Cobol files, created source definition for Cobol files Created re-usable lookup transformations
• Developed and fine-tuned Informatica mappings
• Used several transformations - Filter, Aggregator, Joiner, Stored Procedure, Advanced External Procedure, Lookup, Router, Update Strategy, Sequence, Union and Rank transformation.
• Created Stored Procedures in DB2 UDB for converting the date format
• Performed data cleansing
• Performed cache optimization
• Involved in testing application - unit, functional and integration testing and user acceptance testing method
• Created scripts for loading the error Master table
• Involved in testing, debugging, maintaining and generating reports
• Created reports for PPI (Pharmacy physical inventory) using Business Objects
• Created report using crystal report
• Created Universe for Remedy application to create the Adhoc reports against the DB2
• Extensively used Erwin for data modeling and Dimensional Data Modeling
• Performance tuning using round robin, hash auto key, Key range partitioning

Environment: Informatica Power Center 7.1, UNIX AIX, Perl Script, Teradata, TPump, Multiload, Fastload DB2, DB Artesan, Oracle 8i, Erwin 4.0. Toad, Business Object 6.1

Confidential

ETL Developer

Responsibilities:

• The data warehouse was implemented to keep track of school revenue, expenditure, teacher and student records of all the Burroughs of New York City
• Created design Documentation
• Interacted with users and analysts

Environment: Informatica Power Center 6.1, AIX, Windows NT, DB2, DB Artesan, Oracle 8i, Erwin 4.0. Toad, Business Object 6.1

Confidential

Senior Data Warehouse Developer/Lead

Responsibilities:

• Confidential implemented Enterprise Data Warehouse that integrated data from various applications and retail stores
• The data sources were SAP, Oracle, DB2, Access, and spread sheets
• The data warehouse is used by Financial, Marketing and Publishing departments to analyze financial status, profitability, marketing effort, marketing cost, retail store analysis, zone analysis, type of book being sold by author, by region etc
• Installed, configured and administered Informatica 5.1 server and client on Windows NT.
• Extracted data from SAP R/3 into Data Warehousing
• Designed and built Data Marts for Retail Sales and Marketing
• Optimized Query and Session Performance
• Used Erwin for data modeling
• Involved in testing application - unit testing, functional testing, integration and user acceptance testing
• Provided 24/7 Production support

Environment: InformaticaPowerCenter 4.7/5.1, XML, SAP R/3 4.6, Erwin 3.5.2, Oracle 8i, DB2, SQL Server 2000/7.0, PL/SQL, SQL*Plus, SQL*Loader, WinNT 4.0, Shell Scripting