ETL Developer
Resume:
Objective: ETL (BODS) Developer position
in Greensboro, NC
SUMMARY
. 8+ years of total IT experience in data warehousing large to mid-size
projects in a fast paced environment for Bank of America, CVS-Caremark,
SaskPower and CIBC Bank.
. 3+ years of experience on (BODS) Data Services 4x/XI3.2/3.1 and
Informatica Power Center 8.6/8.1 with good understanding of business
needs and extraction, transformation and loading large data from
various data sources i.e SQL Server, Oracle, DB2, Teradata, and flat
files.
. Worked on Tickets and provided support to resolve production issues.
. Worked extensively on various BODS Transformations i.e. Data Integrator,
Data Quality, Platform, and Text Data
Processing.
. Strong experience in the integration of BODS with SAP ECC,
HANA and Non-SAP data sources.
. Experience in SAP modules (FI/CO, SD), Tcodes, Transport Requests,
Mapping, Gap analysis, Configuration, Testing, SAP ECC and ASAP
methodology.
. Experience in writing SQL, PL/SQL, Shell scripts.
. Designed/Edited/Tested Source-Transformations-Target; exception-handling
and email-alerts.
. Broad understanding of SAP ECC tables and SAP BW objects.
. Performed Unit and User Acceptance Testing. Wrote test cases, test plan,
ETL technical specifications doc.
. 4 years of experience in BI Reports - Microstrategy, SAP Business
Objects suite 4.1, Crystal, SSRS, Tableau, Qlikview.
. Knowledge of conceptual, logical and physical data modelling,
Normalization and tools like Erwin, and Visio.
. Experience in identifying and resolving performance bottlenecks in
various levels like sources, mappings and sessions.
. Familiar with Scrum, Agile methodologies, OLAP and OLTP database
schemas.
. Capable of understanding business needs and translate business
requirements into technical solutions.
. Diverse background with fast learning and creative analytical abilities
with good technical, communication and interpersonal skills.
. Served as a liaison with other divisions such as Sales, Accounts
Receivable, and Risk Management in an effort to ensure accurate and
timely transaction processing.
. Experience working with off-shore team in India and North America;
Provided 24/7 production support.
TECHNICAL SKILLS
ETL Tools: BODS 4x/XI3.2/3.1, Informatica PowerCenter 9.1/8.6/8.1, SSIS
2005/2008/20012.
RDBMS: Oracle10g/9i, SQL Server 2000/2005/2008, DB2, AS400, Teradata
BI Tools: SAP Business Objects 4.1, Crystal, Tableau, SSRS,
MicroStrategy, Tableau, QlikView
Operating System: UNIX, Linux, Windows NT/2000/XP/7
Defect Management tools: HP Quality Center 9x, Test Director, Remedy 7x
Languages: SQL, PL/SQL, ABAP, Shell Scripting
Modeling Tools: MS Visio, Erwin
EXPERIENCE
Bank of America, Jacksonville FL Sept.2014-Feb.2015
Developer-Contractor
Description: Bank of America is an American multinational banking and
financial services corporation headquartered in Charlotte, North Carolina.
It is the second largest bank holding company in the United States by
assets.
Responsibilities
. Worked with Teradata DBAs, Data Analyst, ETL Developers and Business
Analysts to analyze and gather business requirements.
. Designed complex mappings, mapplets, created sessions and workflows to
load data, and monitored workflow progress.
. Implemented Slowly changing Dimension(Type 1/2/3), Case, Map_Operation,
Merge, Query, Row_Generation, SQL, Validation, Data_Transfer,
Date_Generation, Effective_Date, Hierarchy_Flattening, History_Preserving,
Key_Generation, Map_CDC_Operation, Pivot, Reverse Pivot, Table_Comparison,
XML_Pipeline, etc.
. Defined Mapping parameters and variables, breakpoints, email-alerts as
per requirements.
. Worked on CDC (change Data Capture) to capture insert, update, and
delete changes made to Enterprise Data Sources.
. Wrote SQL, PL/SQL scripts. Created/edited shell scripts to write post-
session & pre-session scripts.
. Scheduled and monitored BODS jobs sequentially and conditionally.
. Created/edited Local, Central and Profiler repositories as per
requirements.
. Wrote SQL queries. Created/Edited shell scripts for pre or post-
session.
. Wrote BRDs, ETL technical specification docs, test plan, ETL test cases,
and other supporting documents
. Performed testing from source to target, performance tuning and
exception-handling.
. Scheduled and monitored jobs using Autosys.
. Worked on data cleansing, data profiling and CASS error handling
strategies, standards used by USPS.
. Worked on Tickets and provided tech support to resolved production
issues. Worked with QA team to follow up on testing.
. Participated on daily/weekly team meetings on the Project. Provide
24/7 on-call to provide production support.
Environment: SAP BODS, Teradata, Teradata SQL Assistant, Oracle, Toad,
DVO, PL/SQL, MS Visio, Linux, Remedy, SharePoint, Autosys, Hadoop
CVS-Caremark, Scottsdale AZ Aug'2013 to Feb'2014
Developer-Contractor
Description: CVS Caremark (NYSE: CVS), headquartered in Woonsocket, RI, is
the largest pharmacy health care provider in the US with integrated
offerings across the entire spectrum of pharmacy care.
Responsibilities:
Worked on BODS 4.0
. Created complex Jobs, Work Flows, Data Flows, and Scripts using
various Transforms (Integrator, Quality, Platform and Text Data) to
successfully load data from multiple sources into a desired target.
. Worked with DBAs, stakeholders and Analysts for data requirements and
wrote entire ETL design specifications doc.
. Implemented Slowly changing Dimension(Type 1/2/3), Case, Map_Operation,
Merge, Query, Row_Generation, SQL, Validation, Data_Transfer,
Date_Generation, Effective_Date, Hierarchy_Flattening, History_Preserving,
Key_Generation, Map_CDC_Operation, Pivot, Reverse Pivot, Table_Comparison,
XML_Pipeline, etc.
. Defined Mapping parameters and variables, breakpoints, email-alerts as
per requirements.
. Worked on CDC (change Data Capture) to capture insert, update, and
delete changes made to Enterprise Data Sources.
. Wrote SQL, PL/SQL scripts. Created/edited shell scripts to write post-
session & pre-session scripts.
Scheduled and monitored BODS jobs. Created RFC (Remote Function Call)
connections to SAP systems
. Created/edited Local, Central and Profiler repositories as per
requirements.
. Extracted data from various data sources i.e. SAP ECC tables, Hana,
Oracle, SQL Server & flat files to provide analytical, BI Reporting, &
data warehouse solutions in a structured data-centric environment.
. Did data cleansing, data mapping, data conversion.
. Wrote BRDs, ETL Technical Specification Docs, Test Plan, ETL Test Cases,
Migration Plan Doc and performed Dev testing.
. Created/edited/ tested various Reports, Dashboard, Graphs, Charts using
SAP Business Objects (WEBI)
. Worked on Tickets and provided support to resolve production issues.
Worked with QA team to follow up on testing.
. Worked extensively with SAP SD module (Sales & Distribution) team for
data migration from Legacy system to SAP.
. Participated on daily/weekly team meetings on the Project and
interacted with DBAs, Analysts, Stakeholders, Developers and Testers.
Environment: BODS 4x, SAP ECC6.0, MS SQL server 2008, Oracle10g, Toad,
PL/SQL, MS Visio, UNIX, Quality Center 11, Remedy, Windows, SharePoint,
Siebel, Business Objects WebI, Explorer, LiveOffice, John Galt, Dashboard,
ABAP.
SaskPower, Regina SK Jan '09 - Jun'13
Developer (BODS)
Description: SaskPower is the principal Electric Utility company in
Saskatchewan. SQL Server, Oracle, SAP, Mainframe and Custom Applications.
Responsibilities: .
. Worked with SAP functional consultants (FI/CO), DBAs, Business Analysts,
Data Analyst, stakeholders to understand the business processes,
workflows, business rules and business needs.
. Analyzed and designed ETL jobs for SAP data and non-SAP data to address
BI Reporting & DW Solutions.
. Created complex jobs, workflows, dataflows, datastore, format and
scripts using various Transforms (Integrator, Quality, Platform and
Text Data) to successfully connected and loading data into a
desired target.
. Implemented Slowly changing Dimension(Type 1/2/3), Case, Map_Operation,
Merge, Query, Row_Generation, SQL, Validation, Data_Transfer,
Date_Generation, Effective_Date, Hierarchy_Flattening, History_Preserving,
Key_Generation, Map_CDC_Operation, Pivot, Reverse Pivot, Table_Comparison,
XML_Pipeline, etc.
. Defined Mapping parameters and variables, breakpoints, email-alerts as
per requirements.
. Extracted data from various data sources i.e. SAP ECC, Oracle, Hana, SQL
Server, & flat files.
. Worked on CDC to capture insert, update, and delete changes made to
enterprise data sources.
. Wrote SQL, PL/SQL scripts.
. Did data conversion, data cleansing and data profiling.
. Scheduled and monitored BODS jobs.
. Wrote detailed ETL design specifications Documents.
. Created/edited/ tested various Reports, Dashboard, Graphs, Charts
using BOBJ.
. Wrote test cases and performed testing and followed up with QA team.
. Worked on Tickets and provided support to resolved production issues.
. Participated in daily/ weekly team meetings.
Environment: Data Services XI3.2/3.1, Oracle, Toad, SAP ECC6.0, SQL Server
2008, ABAP, Erwin, Windows, TFS, UNIX, Remedy, Quality Center, Sharepoint,
Business Objects suite.
Lafarge Corp. Toronto ON. Mar'08 - Jan'09
ETL Developer (Informatica)
Description: Lafarge North America is the largest diversified supplier of
Construction Materials in the U.S. and Canada.
Responsibilities:
Designed ETL packages using Informatica Power Center 8.6.
. Worked with SAP Functional Consultants (SD), DBAs and Business Analysts
for data requirements to address BI Solutions.
. Designed complex ETL jobs, source-transformations-target; mappings
using various types of transformations such as Active, Passive, Connected
and Unconnected.
. Worked extensively on Power Center Client tools (Designer, Repository
Manager, Workflow Manager, Workflow Monitor).
. Implemented Source Qualifier, SCDs(1/2/3), Joiner, Filter, Router, Rank,
Expression, Lookup, Aggregator, Sorter, Normalization, Update Strategy,
Sequence Generator, Stored Procedure transformations, Union, etc.
. Defined Mapping parameters and variables, set breakpoints, Email-
Alerts.
. Created/edited mapplets, validated mappings, error-handling.
. Wrote SQL, PL/SQL scripts.
. Wrote BRDs, Technical Specification Docs, Test Plan, Test Cases,
Migration Plan.
. Extracted large data from various sources i.e. Oracle, SQL Server, SAP
R/3, and flat files.
. Performed Dev testing and worked with QA team.
. Provided 24/7 tech support to resolved production issues.
. Participated on daily/weekly team meetings on the Project.
Environment: Informatica PowerCenter 8.6, SAP, MS SQL Server 2005/2008,
Oracle, Toad, PL/SQL, MS Visio, UNIX, Quality Center, Windows.
CIBC Bank, Toronto ON May'05- Feb'08
ETL Analyst (Informatica)
Description: The Canadian Imperial Bank of Commerce, commonly known as
CIBC, is one of Canada's chartered banks, fifth largest by deposits. The
bank is headquartered at Commerce Court in Toronto, Ontario.
Responsibilities:
. Gathered requirements from stakeholders, DBAs, Business Analysts, Data
Analysts to provide BI/DW solutions.
. Analyzed Database tables, data requirements for loading data from
Oracle, SQL Server, and flat files.
. Created various transformations such as Active, Passive, Connected and
Unconnected.
. Organized meetings and worked with DBAs, Business Analysts, Data
Analysts to understand ETL data requirements and documented detailed ETL
design technical specifications.
. Worked extensively on Power Center Client tools (Designer, Repository
Manager, Workflow Manager, Workflow Monitor).
. Implemented successfully various transformations i.e. Source
Qualifier, SCDs(1/2/3), Joiner, Filter, Router, Rank, Expression, Lookup,
Aggregator, Sorter, Normalization, Update Strategy, Sequence Generator,
Stored Procedure transformations, Union, etc.
. Created/edited mapping parameters, variables, set breakpoints,
exception-handling;
. Worked on tickets to resolve production issues. Provided 24/7 tech
support.
. Wrote SQL, PL/SQL scripts.
. Wrote test cases and performed testing and followed up with QA team.
. Scheduled and monitored jobs.
. Participated in daily/weekly team meetings.
Environment: Informatica 8.6/8.1, Oracle, SQL Server 2005, SQL, PL/SQL,
VISIO, Windows, Quality Center, SSRS.
EDUCATION
. Bachelors in Computer Science - University of Saskatchewan, Canada
. 10 weeks part-time course in SAP BI 7.0 from IIBS, Toronto ON
SOFT SKILLS
. Excellent communication and problem solving skills;
. Reliable team member, organized, positive attitude, and work well under
pressure;
Contact this candidate