We provide IT Staff Augmentation Services!

Data Warehouse Resume

Portland, OR

CAREER PROFILE

  • Nine Plus (9+) years of total IT experience which includes Business Requirements Analysis, Design, Development, Implementation, and Testing of Data Warehousing applications in Retail, Financial, Healthcare, ecommerce, and Telecommunication industries.
  • Eight (8) years of strong Data Warehousing and ETL experience using Informatica PowerCenter 9.1/8.6.1/7.1.4/6.2.1, Informatica PowerMart 6.2/5.1
  • Informatica Certified Developer
  • Profound experience in performing all functions of System Development Life Cycle including Requirements Analysis, writing Design documents, conduct Unit and System testing.
  • Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, Sybase, SQL Server, MS Access, DB2 and Worked on integrating data from flat files, CSV files, COBOL files and XML files.
  • Experience in Performance Tuning of sources, targets, mappings, sessions and system level.
  • Experience in developing Entity-Relationship diagrams, Logical and Physical Data Models, and the use of Data modeling tools.
  • Expert in coding SQL, PL/SQL stored procedures, Triggers and Packages.
  • An efficient Team Leader and a Team Player. Efficient in Task assignment and mentoring the team members.
  • Capable of working under high stress environment with resource constraints
  • Self-motivated and energetic, able to set priorities with adherence to guidelines and deadlines.
  • Possess excellent communication, interpersonal skills and leadership qualities.

TECHNICAL SKILL SET

Data Warehousing:

Informatica PowerCenter 9.1/8.6.1/7.1.4/6.2.1, Abinitio 3.1.14,
Informatica Data Profiler Manager 7.1.2, Informatica Powerconnect for SAP R3, SAP BW

Data Modeling:

Erwin 4.x/3.x, and Oracle Designer, MS Visio 2002

Databases:

Oracle 10g/9i/8i/8.x/7.x, DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0, Progress, and MS Access 7.0/2000

Programming:

SQL, PL/SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, Java, HTML, DHTML, C, C++, VB Script, JavaScript, ASP 2.0/3.0 and Unix Shell Scripting.

EDUCATION

  • Certified Informatica Developer
  • Masters in Computer Science
  • Postgraduate Diploma in Network Centered Computing
  • Bachelors in Computer Science Engineering

PROFESSIONAL EXPERIENCE

Employer:Confidential,Portland, OR Dec 2010 - Current
Client: Confidential, Beaverton, OR Dec 2010 – Current
Sr. Data Warehouse Developer

Confidential,formed with a vision to build and deliver the next-generation mortgage loan fulfillment capabilities. LBPS provides lenders an opportunity to leverage leading, SOA-based technology to standardize and automate mortgage origination processes to drive down costs and reduce risks.
Responsibilities:

  • Design and implement SQL Server-based BI data warehouse and datamarts
  • Design dimensional and integrated data models to meet analytical and operational needs
  • Develop job management procedures, including implementing Autosys scheduling
  • Designed error logging and parameter management for the project.
  • Provide 24x7 on call support for Informatica loads.
  • Implemented the Change Data Capture extensively to send only the delta records to the target systems.
  • Implemented Informatica code migration using deployment groups and documented the process.
  • Increased Performance by tuning mapping, session and SQL Queries.
  • Raise tickets/issues with respective teams in the event of production failures and get in touch the respective teams to get the issues fixed as earliest as possible.

Environment: Informatica 9.1/8.6.1, SQL Server, SSRS, Autosys

Employer: Confidential,Princeton, NJ Jun 2005 – Dec 2010
Client: Confidential,Lake Oswego, OR Aug 2009 – Dec 2010
Team Lead/Sr. ETL Developer

Confidential,project is to build a dashboard for Southern California that delivers actionable information to Southern California Regional Executives and Senior Leadership. The purpose of the Southern California Health Plan/Hospitals Performance E-Card Dashboard is to provide a tool that allows both leadership to track Regional performance against thresholds, targets, stretch goals, and baselines. .

Membership Data Warehouse (MDW 2.0) Program is a single trusted source of cross-regional membership data to support all membership-related data marts and reporting functions by providing an accurate, up to date (within 24 hours), view of core membership information from across all Regions.
Responsibilities:

  • Involved in design, development and maintenance of Membership data warehouse Informatica Power Center 8.6.1
  • Implemented 3 projects end-to-end as ETL Lead.
  • As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications, administration and mentoring.
  • Converted more then 25 maps from Informatica 7.1 to 8.6
  • Developed Work Breakdown Structure for each project and delegated the development tasks/defects to the team.
  • Conducted a series of discussions with team members to convert business rules into Informatica mappings.
  • Worked with the BI reporting team to ensure end to end data flow.
  • Involved in preparing templates/formats for high level design and technical specifications.
  • Involved in design and development of common framework for error logging and parameter management for the project.
  • Performed data analysis on all feeds to ensure granularity matching on targets
  • Wrote standards documents, code templates, and introduced reusable objects to speed up development.

Environment: Informatica Power Center 8.6.1, Abinitio, Oracle 10g, Shell Scripts, Tivoli, Cognos

Client: Confidential,Beaverton, OR Feb 2008 – Jun 2009
Team Lead

In 2007 Nike established the goal of reaching $23 billion in revenues by fiscal year 2011 and outlined a strategy for achieving that goal. Nike estimates that 25 percent of the company’s targeted revenue growth in the next four years will be generated by Retail department.
Project:
Merchandise Planning aims at generating revenue for the company using SAS application. Legacy data from AS400 is transferred into SAS using Informatica.

Responsibilities:

  • Performed duties of a Team lead and coordinated the project.
  • Involved in design, development and maintenance of Merchandise Planning Informatica Power Center 8.6.1
  • Interacting with the Client in gathering the requirements for developing the Data Mart.
  • Involved in preparing the mapping specifications.
  • Discussing with the Client and identify new Tasks/Change Requests
  • Tuning mappings and sessions for optimum performance. Conducted a series of discussions with team members to convert business rules into Informatica mappings.
  • Extracted data from various sources like AS400, flat files, Oracle and loaded into the target Oracle 10g database.
  • Developed data and performed Unit testing and System Testing.
  • Implemented Slowly Changing Dimensions methodology to keep track of historical data.
  • Created Mapplets for reusable business rules.
  • Performed data analysis on all feeds to ensure granularity matching on targets
  • Wrote standards documents, code templates, and introduced reusable objects to speed up development.
  • Created 70+ new mappings/workflows and converted 20+ existing objects to new modularized and parameterized format.
  • Performed data analysis on flat file loads to determine granularity, domain values and ranges.
  • Created UNIX script which ran through source files looking for erroneous values, format errors, sorting problems and other potential errors prior to loading of data

Environment: Informatica Power Center 8.6.1, IBM AIX, Oracle 10g, AS400, Shell Scripts, Autosys

Client: Confidential,Eagan, MN Nov 2007 – Jan 2008
Sr. ETL Developer

Confidential,a leading provider of integrated information solutions to business and professional markets worldwide, brought together the venerable businesses that composed Thomson Legal Publishing with West Publishing Co. This merger resulted in the formation of West, the foremost provider of integrated information solutions to the U.S. legal market.
Project:
Finance + was a major project for Thomson in terms of acquisitions of vendors globally. The project was to obtain General Ledger (GL) data like Chart of Accounts, Cost center, Profit center and Material Master of all the acquired companies. There was conversion of existing data and also creation of interfaces for future data. Conversion and Interface data was implemented through Informatica.

Responsibilities:

  • Implemented SAP IDOC mappings to load target into SAP CRM
  • Extracted data from various sources like MS SQL Server, Oracle, flat files, and loaded into the target Oracle, MS SQL Server database and SAP.
  • Created UNIX shell scripting for automation of ETL processes.
  • Interacted with clients from Hong Kong, Australia, London, New Zealand.
  • Involved in code movement and Production support.
  • Involved in migrating and documenting mappings, sessions and workflows between development, test and production environments.
  • Posted data in SAP by creating SM35 sessions.
  • Created Change Request documents for code migration.
  • Designed use of mapplets in Informatica to promote reusability, eliminate coding redundancy and ease maintenance of version control.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica Power Center 8.1, Power Connect, Oracle 9i, MS SQL Server, Shell Scripts, SAP 7.1

Client: Confidential,St.Paul, MN Jun 2005 – Oct 2007
Sr.ETL Developer/Team Lead

Confidential,with a single product and a single employee, doing business in a single market.
Today with $5 billion in global sales, Ecolab is the world\'s leading provider of cleaning, food safety and health protection products and services for the hospitality, foodservice, healthcare and industrial markets.

Project:
Confidential,a million dollar project describes Ecolab’s corporate strategy to continually expand the range of related products and services it offers to existing customers. Ecolab built a Customer Master database on the SAP CRM using Informatica.

Responsibilities:

  • Involved in design, development and maintenance of online transactions Data Mart using Informatica Power Center 7.
  • Performed Informatica Admin role by creating new repositories, users and maintaining TEST and PROD environments.
  • Implemented SAP IDOC mappings to load target into SAP CRM
  • Involved in designing the ETL architecture for the project.
  • Involved in ETL process from development to testing and production environments.
  • Extracted data from various sources like MS SQL Server, DB2, flat files, and loaded into the target DB2 and MS SQL Server database.
  • Involved in conversion from Informatica 6.2.1 to Informatica 7.1.2
  • Installed Data Profile Manager 7.1.2 and developed various data profile reports for databases sources like SQL Server, DB2, flat files.
  • Installed and configured Power Connect for SAP R/3 and SAP BW.
  • Created UNIX shell scripting for automation of ETL processes.
  • Designing of Error processing and Job control processes.
  • Automated mappings using UC4 scheduler.
  • Involved in performance tuning of SQL Queries, Sources, Targets and sessions.

Environment: ERWin, Informatica Power Center 7.1.4/6.2.1, MS SQL Server, DB2, PL/SQL, SQL*PLUS, Shell Scripts, Extra Personal Client 6.7, UC4.

Employer: Confidential,Stamford, CT Sep 2003 – Jun 2005
Client: Confidential,NJ Sep 2003 – Jun 2005
ETL Developer

Confidential,is one of the largest life insurance companies in the U.S. On May 1, 2003 Prudential completed the closing process with Swedish-based Skandia Insurance Company Ltd., to acquire its U.S. division American Skandia, Inc. which is the largest distributor of variable annuities through independent financial planners in the United States. The acquisition propels Prudential into a top 10 spot in the annuity marketplace. This acquisition was accomplished by a major integration project from AS/400 to Progress. An Information System designed for (VPAS) Variable Prudential Annuity System.
Project:
This project was aimed to develop a central data warehouse to stage the products (Insurance policies, Annuities, Mutual Funds) data, sales data, customer data etc.

  • Involved in design, development and maintenance of Insurance policies and Annuities transactions Data Mart using Informatica Power Center 6.
  • Gathered ETL requirements and implemented in Informatica.
  • Extracted data from various sources like MS SQL Server, DB2, flat files, Oracle and loaded into the target Oracle 8i database.
  • Developed data and performed Unit testing and System Testing.
  • Implemented Slowly Changing Dimensions methodology to keep track of historical data.
  • Involved in creations of various snapshots like transaction level snapshots, periodic snapshots and Accumulated Snapshots.
  • Created Mapplets for reusable business rules.
  • Implemented different tasks in workflows which included sessions, command task, decision task, timer, assignment, event-wait, event-raise, e-mail etc.
  • Tuned mappings and SQL queries for better performance and efficiency.
  • Planning and Implementation of Change Request.
  • Created UNIX shell scripting and automation of ETL processes using Crontab.

Environment: ERWin, Informatica Power Center 6.2.1/ 5.x, Cognos Impromptu, Power Play, Transformer, HP-UX 10.2, MS SQL Server, DB2, Oracle 8i, SQL, PL/SQL, XML Files, SQL*PLUS, SQL*Loader, TOAD, Import/Export Utilities, Shell Scripts.

Hire Now