Senior ETL Consultant
Resume:
[pic]
[pic]
Shubha Maihar
abn3jc@r.postjobfree.com
Informatica Certified Professional
925-***-**** (Cell)
[pic]
Professional Summary:
An accomplished, versatile, highly organized self-starter with outstanding
career track known throughout the industry with 7+ years expertise in all
aspects of project development life cycle in Data Warehousing from the
source systems data extractions, data transformations, data staging,
movement and aggregation. Exceptional communicator with exceptional problem
solving capabilities and taking initiatives in supporting management
policies and objectives quickly and effectively. Aggressively identified
opportunities, developed focus and provided tactical business solutions.
Competencies:
. 7+ years of focused experience in Information Technology with a strong
background in Database development and Data warehousing and ETL and
Reporting process using Informatica PowerCenter 7.1.2/8.1.0, Microsoft
SQL Server Integration Service, Microsoft SQL Server Integration
Service and Oracle Business Intelligence.
. Extensively worked with large Databases in Production environments.
. Data Processing experience in designing and implementing Data Mart
applications, mainly transformation processes using ETL tools.
. Proficiency in using ETL tool to design data conversions from wide
variety of source system.
. Extensive work in ETL process consisting of data transformation, data
sourcing, mapping, conversion and loading and knowledge in Data
Modeling.
. Strong in Data warehousing concepts, dimensional Star Schema and
Snowflakes Schema methodologies.
. Proficient in understanding business processes / requirements and
translating them into technical requirements.
. Extensive experience in implementation of Data Cleanup procedures,
transformations, Scripts, Stored Procedures and execution of test
plans for loading the data successfully into the targets.
. Experience in database design, entity-relationship modeling,
dimensional modeling
. Proficient in Relational Database Management Systems.
. Expertise in developing SQL and PL/SQL codes through various
procedures, functions, and packages to implement the business logics
of database in Oracle.
. Experience in UNIX Shell Scripting.
. A Team Player with excellent communication, analytical, verbal and
writing skills.
Skill Sets:
Data Modelling: CA Erwin 4.0/3.5.5/3.5.2, Star-Schema Modeling, Snowflake
Schema Modeling, FACT & Dimension Tables
Data Warehousing: Informatica PowerCenter 7.1.2/7.1.4/8.1.0, Informatica
PowerMart 7.0/6.2/5.1/4.7, Mapping Designer, Warehouse Designer, (Work Flow
Manager, Monitor & Designer), Informatica PowerConnect for
SAP/PeopleSoft/Siebel/DB2, Ab-Initio, Ab-Initio EME
Databases: Oracle 8i/8.0/7.x, MSSQL Server 2000/7.0/6.5, SQL Server
12.0/11.x, Teradata ODBC 12.0.0.3, Teradata OLEDB 12.0.0.1, Teradata SQL
Assistant 7.1
Business Intelligence: Siebel Analytics, Informatica and Siebel Data
Warehouse Application Console (DAC), OBI 10.1.3.2.1, SQL Server 2005
Analysis and Integration Services with Performance Point Server
integration. (SSAS, SSIS and SSRS)
Programming: SQL, TOAD Transact SQL, PL/SQL, Embedded SQL, UNIX Shell
Scripting, C, Java, HTML 4.0, DHTML
Environment: Windows NT 4.0, Windows XP, Win 95/98/2000, Sun Solaris 10,
Toad.
Professional Experience:
Company: Kaiser Permanente
Duration: Nov 2009 - Till Date
Programming Analysis Specialist.
The Supply Chain Management Data Warehouse (SCMDW) supports Kaiser
Permanente with consolidated view of detailed and aggregated supply chain
information related to invoices, vouchers, general ledgers, purchase
orders, vendors, items inventory. SCMDW receives its data from disparate
transactional systems across all different regions in Kaiser. SCMDW needs
to be configured to receive data from that system as well to maintain its
ability to perform enterprise-wide reporting to build an integrated data
warehouse model so that all supply chain data will be available in one
location.
Performance Measurement Data Warehouse for Remedy Application. It is the
system of record and data from Remedy is loaded daily into PMDW using the
ETL process and is used by senior management in order to view the reports
based on the tickets raised through Remedy application such as severity of
tickets that were raised, incidents count - Critical, Medium, High, MTTR,
RFC %Successful, outage if any, alerts, alarms, SLA Attainment, Incident
priority, etc.
Responsibilities:
. Data analysis, Designing, and documenting program structure and
code;
. Establishing the reliability of the existing code;
. Interacting with various Information Technology and business teams
within Kaiser as necessary;
. Developing applications using Informatica, Oracle, and DB2 and
mainframe datasets;
. Preparing Change requests & Service requests for migrating ETL
(Extract, Transform, and Load) code to new servers;
. Testing and conformance of an input program to the programming
standards;
. Tracking defects;
. Performing regression testing;
. Maintaining documentation for programming code;
. Preparing reports on the status of the issues and highlights.
. Assess mapping between disparate legacy sources and create Mappings
using various transformations like Update Strategy, Lookup, Stored
Procedure, Router, Joiner, Aggregator and Expression.
. Modifying the existing cron job interfaces to extend and migrate to
the IBM Tivoli Work loader Scheduler as scheduled scripts with
appropriate job dependencies.
. Used SQL tools like TOAD to run SQL queries and validate the data
in warehouse and mart.
. Involved in the error checking and debugging of the ETL procedures
and programs using Informatica session log and Debugger tool in the
designer.
. Creating Ab-initio sandboxes for the UNIX and Mainframe
environments, customizing the Ab-inito scripts and execution graphs
in the GDE. Framing Unit Testing Plan and User Acceptance Testing
with the client and promoting the project to production.
. Involved in different types of loading like Normal and Bulk loading
challenges related to Initial Loads, Incremental Loads, Daily loads
and monthly loads.
. Working on session partitioning and Performance Tuning of mappings
and sessions to overcome the bottlenecks. Developed Unit Test Cases
for mapping and code reviews.
Environment:
Informatica PowerCenter 7.1.2/8.1.6 (Repository Manger, Designer,
Workflow Monitor, Workflow Manager), Oracle 9i, Oracle 10g, PL/SQL, Ab-
initio, Ab-initio EME, Teradata ODBC 12.0.0.3, Teradata OLEDB
12.0.0.1, Teradata SQL Assistant 7.1, Mainframe, IBM DB2, Shell
scripts
Company: Infosys Technologies Ltd.
Duration: May 2006 - Nov 2009
Business System Analyst
(Aug 2009 - Nov 2009)
Client: American Express
Location: Phoenix, Arizona, US
Interactive Voice Response Reporting Application:
The project is about assessing the current dialer reporting environment and
working towards significant opportunities that existed across dialer
reporting environments to improve content and delivery. The reports
involved real time, intra-day, historical, ad-hoc reports for Campaign,
Agent Management, agent Analysis, Transaction & Summary, Project and
Transaction Analysis.
Responsibilities:
. Working with Business to understand the requirements, analyzing the
requirements, requirement gathering and preparing Business
Requirement and Functional Requirement documents along with Business
Use Cases.
. Process automated reports generated by the system, reducing error
opportunities and developing dynamic end user report portal as One
source for all the reports, delivering reports to right users at
defined frequency.
. Improved content providing rich information to fill critical
business needs like Pacing, Promises meant for Inbound/Outbound
call, Average time intervals handling the call, etc..
. Delivering reports and analyzing reports for strategy planning and
tactical adjustments.
. Replacing excel based spreadsheets that existed as primary means of
report delivery to dynamic web portal for end user desktop.
Environment:
SQL Server 2005 Reporting Services Developer 9.0.3042, PL/SQL, MS SQL
database server
Technical Lead/Business Analyst (Jul 2009 -
Aug 2009)
Client: Sears Holdings
Location: Hoffman Estate, Illinois, US
Craftsman Club Reward Program:
The project is about developing the reports for the senior management
business to evaluate the effectiveness of the new program they have
launched in Craftsman Club called as Craftsman Rewards. Craftsman Rewards
is a new level of benefits to be added to Craftsman Club in August 2009.
Responsibilities:
. Working with Business to understand the requirements, analyzing the
requirements, requirement gathering and preparing Business
Requirement and Functional Requirement documents along with Business
Use Cases.
. Doing data modeling using snowflake schema as per the requirement by
defining the grain, identified the facts and dimensions, defined the
relationships between them and defined their attributes.
. Working on doing data quality check, source to target ETL Design,
deciding on various stages to be included in the process based on
the quality of data, creating high level and low level design
documents, deciding on various logics to be implemented to ensure
proper development, incremental load and full load.
. Leading/ Coordinating with the Offshore and reviewing SSIS and SSRS
packages to make sure the proper ETL and Reporting development has
been done. Doing significant changes wherever desired.
. Working on Unit Testing, Acceptance Testing and Performance Testing
with the client and implementing the project.
Environment:
SQL Server 2005 Integration Services /Reporting Services Developer
9.0.3042, Teradata ODBC 12.0.0.3, Teradata OLEDB 12.0.0.1, Teradata
SQL Assistant 7.1, Fast Load, BTEQ scripts, Multi Load, PL/SQL
Technical ETL/Informatica/BI Consultant (Feb 2009 -
Jun 2009)
Client: CVS Pharma Inc.
Location: Woonsocket, Rhode Island, US
Sales Audit Replacement Project:
The project is about replacing the existing Mainframe Sales Audit
application of CVS with a UNIX based vendor product from a company called
EPICOR. For this project, the data needs to be imported from various
sources to the new sales audit system's database; and export the audited
data from sales audit to multiple applications.
Responsibilities:
. Working on designing layer for data acquisition, refinement, and
aggregation-data sources, selecting the correct data elements,
refining-filters, and summarizing data elements to produce output
suitable for loading into the data layer.
. Creating Mappings using various transformations like Normalization,
Update Strategy, Lookup, Stored Procedure, Router, Joiner,
Aggregator and Expression.
. Designing to collect as much information as possible from each of
the major IT sources, mainframe and distributed. Manual input will
be kept to a bare minimum, improving data quality and eliminating a
plethora of manual data collection procedures resulting in more
reliable data and reduction in the number of tools and procedures
used throughout the firm, leading to cost savings and efficiencies.
. Involved in different types of loading like Normal and Bulk loading
challenges related to Initial Loads, Incremental Loads, Daily loads
and monthly loads.
. Working on session partitioning and Performance Tuning of mappings
and sessions to overcome the bottlenecks. Developed Unit Test Cases
for mapping and code reviews.
Environment:
Informatica PowerCenter 8.1.0, Informatica PowerConnect, Oracle 10g/9i,
PL/SQL, UNIX, Mainframes
ETL and Siebel Analytics Developer (May
2008 - Jan 2009)
Client: Charles Schwab
Marketing Practice Project:
The project aimed to architect real time data warehouse integrations using
the application of intellectual knowledge that comes with every Siebel
Analytics Application in the form of Siebel RMW, Siebel Analytics
Repository, DAC Metadata and Ab-Initio mappings & workflows eliminating
unnecessary development of custom mart.
Responsibilities:
. Developed strategy and project plan for migration of data to data
warehouse, integration with ETL processes and integration with BI
environment.
. Perform detailed process and data requirement analysis and
documentation. Worked closely in creating logical data model (Star
Schema).
. Built the Siebel Analytics repository/DAC metadata (Physical Layer,
Business Model and Mapping Layer and Presentation Layer) and created
the subject area where reporting and analysis are centered on
customized execution plan.
. Designed, customized vanilla mappings, developed informatica
mappings, enabling the extract, transport and loading of the data
into target tables using multiple transformations.
. Involved in different types of loading like Normal and Bulk loading
challenges related to Initial Loads, Incremental Loads, Daily loads
and monthly loads.
. Worked on session partitioning and Performance Tuning of mappings
and sessions to overcome the bottlenecks. Developed Unit Test Cases
for mapping and code reviews.
Environment:
Informatica PowerCenter 7.1.2/8.1.0, Informatica PowerConnect,
(Repository Manger, Designer, Workflow Monitor, Workflow Manager),
ETL, Flat files, Oracle 10g, Erwin 4.2/3.5.x, MS SQL Server 2000,
PL/SQL, OBI 10.1.3.2.1, DAC 7.9.2
Business Intelligence Solutions Developer (Dec
2007 - Mar 2008)
Client: Infosys Internal Project for Audit
The project aim to give BI and other projects a jump start in analyzing,
designing and building ETL interfaces, providing insight to common ETL
programming patterns such as common error handling mappings to develop
functions dealing with error handling, logging, and authoring error
handling rules and modify the way the errors could be logged and
application configuration guidance.
Responsibilities:
. Develop and deploy ETL job workflow with reliable error/exception
handling and supported operations by identifying, researching and
resolving performance and production issues.
. Involved in the error checking and debugging of the ETL procedures
and programs using Informatica session log and Debugger tool in the
designer.
. Developed conceptual, logical and physical data models using ERWIN
with proficiency in using Informatica workflow manager, Workflow
monitor, pmcmd (Informatica command line utility) to create,
schedule and control workflows, tasks, and sessions.
. Worked on different Schemas (Star and Snow Flake) to fit reporting,
dashboards, query and business analysis requirements.
. Implementation of transformations, Scripts, Stored Procedures and
execution of test plans for loading the data successfully into the
targets.
Environment:
Informatica PowerCenter 7.1.2, Oracle 10g/9i, PL/SQL, Active Perl,
UNIX Shell Scripting, Erwin 4.2
ETL and Siebel Analytics Developer (Jun
2007 - Nov 2007)
Client: Equifax
The Project involves design of high performance data warehouse that greatly
exceed current performance barriers by exploring new technologies and new
approaches to existing problems.
Responsibilities:
. Involved in the Installation of Informatica PowerCenter 7.1.2/8.1.0.
. Participated in the detailed requirement analysis for the design of
data marts and star schemas.
. Created Mappings using various transformations like Update Strategy,
Lookup, Stored Procedure, Router, Joiner, Aggregator and Expression.
. Designed many Multi Source Single Target mappings and vice versa.
. Involved in the error checking and debugging of the ETL procedures and
programs using Informatica session log and Debugger tool in the
designer.
. Used SQL tools like TOAD to run SQL queries and validate the data in
warehouse and mart.
. Performed Data Validation and testing and created Unit Test Cases to
validate the quality of data from source to target.
. Involved in Performance tuning and testing at mapping level.
. Involved in end user training and support.
. Participated in data modeling of the project using Erwin.
. Involved in the scheduling of the jobs and workflows as per the
business requirement.
Environment:
Informatica PowerCenter 7.1.2/8.1.0, Informatica PowerConnect,
(Repository Manger, Designer, Workflow Monitor, Workflow Manager),
ETL, Flat files, Oracle 10g, Erwin 4.2/3.5.x, MS SQL Server 2000,
PL/SQL
ETL Developer (May 2006 -
May 2007)
Client: Dunn & Bradstreet
The Project involves building a new detailed trade data environment to
store the history of aging details of trade information, and make it
available to online processes, as well as batch scoring products. This
would increase the predictive power of D&B's scoring products, the value
and usefulness of various solutions provided to their customers.
Responsibilities:
. Involved in the Installation of Informatica PowerCenter 7.1.2/8.1.0.
. Created Mappings using various transformations like Update Strategy,
Lookup, Stored Procedure, Router, Joiner, Aggregator and Expression.
. Designed many Multi Source Single Target mappings and vice versa.
. Used SQL tools like TOAD to run SQL queries and validate the data in
warehouse and mart.
. Developed reusable transformations in the Transformation Developer for
reusable purpose.
. Performed Data Validation and testing and created Unit Test Cases to
validate the quality of data from source to target.
. Involved in Performance tuning and testing at mapping level.
Environment:
Informatica PowerCenter 7.1.2/8.1.0 (Repository Manger, Designer,
Workflow Monitor, Workflow Manager), ETL, Flat files, Cobol files,
Oracle 10g, Erwin 4.2/3.5.x, MS SQL Server 2000, PL/SQL
Internal Project:
Trainee Software Engineer (Sept
2004 - Apr 2006)
. Extracted, transformed, cleansed, and loaded (ETL) Fire Prevention
Department data from their legacy Access system to Oracle.
. Extracted, transformed, cleansed, and loaded (ETL) Long Range Planning
Department data from their legacy system to Oracle
. Prepared Fire Prevention Department data to use an Automated
Inspection Request System for maximum effectiveness, virtually
eliminating their staff time for inspection request data entry and
reporting.
. Automated manual processes by creating Oracle SQL scripts, PL/SQL
cursors, packages, procedures, functions, triggers, mutating table
triggers, tables, indexes, views, and constraints.
. These were used to check and correct data entry and automatically
update data records to improve the accuracy of data and the speed of
the system.
. Created and modified many Oracle control files for data loads.
. Created and streamlined over 50 reports Writer daily, weekly and
monthly reports used for day-to-day operations and management
decisions.
. Clarified user procedures for best results in their new software.
. Coordinated and conducted weekly project status meetings.
Trainings / Certifications:
. Certification in Informatica Design & Development through examination
"N - Mapping Design 7.x",
"P - Advance Mapping Design 7.x"
"M - Architecture & Administration 7.x" &
"S - Mapping Design 8.x"
. Attended a complete corporate training in Siebel Analytics and Siebel
Data Warehouse Administration Console.
. Active Participant at the online courses covering Leadership
development, Self-Confidence and Assertiveness Skills, Time Management
Skills and Customer Service Skills and delivering improvements in
Performance.
Educational Qualification:
. Completed Bachelor of Electrical & Electronics Engineering (4 years)
from Rajeev Gandhi Technical University, Madhya Pradesh with 69%.
[First class]
Contact this candidate