RESUME
Shilpashree H.V
Ph num: +1-571-***-****
(:
acodhn@r.postjobfree.com
Summary:
Having around 5 years of overall experience in Requirement analysis, Effort
estimation, Design, Development, Testing and Production Support in Data
Warehousing.
Strong working experience in the Data Analysis, Design, Development,
Implementation and
Testing of Data Warehousing using ETL.
1. Knowledge on Data warehousing with ETL Tools Ab initio and
Informatica.
2. Well versed with the Financial and Banking Domains.
3. Complete implementation of the SDLC life cycle in the projects.
4. Experience with the Agile delivery methodology & Strong communication
skills
5. Extensively worked on Ab initio Tool using various components like
rollup, join reformat etc and parallel processing techniques.
6. Worked on Ab Initio EME for dependency/impact analysis and
configuration management.
7. Knowledge on using Informatica Power center. (Designer, Repository
Manager, Workflow Manager, and Workflow Monitor) in design of data
warehouses and datamarts.
8. Knowledge on creating Transformations and Mappings using Informatica
designer.
9. Strong understanding of Data warehousing concepts, OLTP, OLAP,
Normalization, Star and Snow Flake data models.
Implementation of Data warehouses and Business Data marts with Star Schemas
and Snow flake Schemas.
Worked on multiple projects involving Extraction, Transformation and
loading of data from various db sources like Oracle, terradata, db2 and
also Flat Files.
Work experience in UNIX and shell scripting.
Used SQL and PL/SQL to write Stored Procedures, Functions, Packages and
Triggers.
One Year of Experience in Leading a Team.
Employment History
Company Designation Duration
IBM India pvt ltd. Data Specialist May 2012 - Oct 2013
Wipro Technologies, Project Engineer Dec 2009 - May 2012
Bangalore
Software Paradigms Ltd Software Engineer Jan 2009 - Dec 2009
Education Qualification
Course College & Location Year of passing
Bachelor of Engg in GSSS Institute of 2008
Information science Engg, Mysore
MBA in HR IGNOU University 2012
ACHIEVEMENTS
Awarded 'FEATHER IN THE CAP AWARD' for the out of box thinking and
excellent contribution and outstanding performance in Wipro.
Received appreciation from the client, Supervisors and team members for
quality deliverables.
PROJECT EXPERIENCE
Project Name BPC (Business Planning and Consolidation)
Project
Description
The SAP BPC (Business Planning and consolidation)
is an initiative to automate, streamline the
planning,budgeting,forecasting and consolidation
activities for shorter budget cycles,a faster
close and improved regulatory compliance loads
into SAP database
Business Domain Banking Domain
Technology Data Warehousing
Role in Project Developer
Roles and Worked on various Line of Business.
Responsibilities
Worked with Onsite counterpart to understand the
requirement and get the walk through as given by
the requirement Team.
Worked with the source system team (product
processors) to understand/Standardize the data
layout.
Work with other developers/BA to create a Best in
class ETL solution.
Task allocation among the Team members and monthly
preparation of multiple metrics documents.
Create a design and framework for the generic
Abinitio Code to handle the multiple and ever
expanding list of data files coming from source.
Implementation of multiple generic
graphs,psets,dmls,xfrs and Wrappers .
Dealing with different kind of source: Flat Files
with different delimeters,CSV and DB2 tables.
Create a Validation layer and response file
creation system to validate and provide an
automated response to the source systems
indicating the errors in the data.
Create a transform and load code in Abinitio and
Shell scripts using Multiload, Fastload.
End to End Unit Testing of the code via GDE and
execution of the Unix scripts.
Verification and Peer Review of the code.
Checking In the list of new and modified Objects
into the EME and dependency Analysis on it.
Detail documentation of the Test results and
uploading into the share Point
Detail documentation of the object Lists added and
Modified in the EME.
Assisting QA team in technical issues.
Assisting Production Support Team in any kind of
job failure and critical issues.
Bank of Montreal(BMO)
Client
Project Name FPP
Project Financial Pipeline Program (FPP) is an initiative
Description that included an IT Strategy to improve sourcing
and delivery of financial information and reduce
any associated risks. The FPP initiative delivered
a future state IT vision and a roadmap for
Finance. The overriding goal of the FPP program
is to create a financial environment that provides
consistent, accurate and timely financial
information (current & future) for both internal
and external reporting requirements.
Business Domain Banking Domain
Technology Data Warehousing
Role in Project Developer
Roles and Worked on various Line of Business.
Responsibilities
Knowledge on the Legacy system via walkthrough by
the SME.
Analysis of Technical specification t and mapping
documents.
Periodic discussion with Requirement Team and
Onsite counterparts to understand and freeze the
requirements.
Worked with different Lines of Business-Developing
a New Line of business and modifying the existing
functionality.
Understanding and enhancing the implementation of
existing Lines of Business.
Task allocation among the Team members and monthly
preparation of multiple metrics documents.
Designing and Implementation of complex graphs
using rollup, normalize,join reformat etc.
Creation and Usage of Catalog concept to maintain
the list of Lookup files and the keys. Usage of
Catalog in the graphs instead of explicit lookups
thus optimizing the code.
Creation and Usage of generic Load Utility to load
the data in Update,Append or snapshot mode as
specified in the cfg file.
Implementation of Delta and Surrogate key Process.
Preparing the Shell scripts which acts as the
wrapper to the Abinitio and aid in the command
line firing of the jobs.
Verification and Peer Review of the code.
End to End Unit Testing of the code via GDE and
execution of the Unix scripts.
Checking and Checking out using version control
tool PVCS.
Detail documentation of the Test results and
uploading into the share Point.
Detail documentation of the object Lists added and
Modified in the PVCS Tool
Assisting QA team in technical issues.
Assisting Production Support Team in any kind of
job failure and critical issues.
Documentation of all the Line of Business aiding
for easy understanding to New Team members.
Client Bank of Montreal(BMO)
Project Name BCL
Project Basel Committee on Banking Supervision, which
Description recommends certain standards and regulations for
banks. The main recommendation of this document is
that in order to lower risk, banks should hold
enough capital to equal at least 8% of its
risk-weighted assets.Bank of Montreal(BMO)comply
with Basel II. This involved dml, rc creation,
code changes as per the business requirement,
script changes and unit testing.
Business Domain Banking Domain
Module Name BASEL -II
Technology Data Warehousing
Role in Project Developer
Roles and Analysis of the technical specification document
Responsibilities (TSD) and Mapping Document(MD).
Designing a generic Validation graph and the
inputs for every Line of Business.
Create a Validation layer and response file
creation system to validate and provide an
automated response to the source systems
indicating the errors in the data
Coding of the Validation Rules as per the
requirement document.
Implementing generic functions used in the Abintio
code via Shell Scripts.
Usage of multiple static and dynamic lookups.
Using Catalog to avoid creation of Lookup in the
graph.
Development and Usage of Reusable Utilities for
-Extracting data, Loading Data, Parallel loading
of Multiple Data, Ftp data to different server,
run commands in the wrapper step wise,
reconciliation of data for validation, setting
system date etc .
Involved in creating and updating the Visio
document for highlighting the job dependency for
new or change requests worked.
Verification and Peer Review of the code.
Vigorous End to End Testing of every function
coded with multiple scenarios.
Detailed documentation of every test scenario
implemented in UTC documents and uploaded into
share point.
Assisting QA and Production Support Team.
Client Bank of Montreal(BMO)
Project Name Digital Analytics
Project
Description
Customer Data Integration (CDI) is the combination
of the technology, processes, and services needed
to create and maintain an accurate, timely and
complete view of the customer across multiple
channels, business lines, and, potentially,
enterprises, where there are multiple sources of
customer data in multiple application systems and
databases. This involved dml creation, code
changes as per the business requirement, wrapper
changes and regressive testing.
Business Domain Banking Domain
Module Name CDI(Customer Data Integration)
Technology Data Warehousing
Role in Project Developer
Roles and Involved in Knowledge Transfer by Subject Matter
Responsibilities Experts.
Discussion with requirement Team and Onsite
Counter Part in Understanding the requirements and
clarification of any queries.
Application of complex business rules into
Abinitio using components like
rollup,join,reformat,normalize etc.
Implemented performance tuning logic on targets,
sources, mappings, sessions to provide maximum
efficiency and performance.
Performance enhancing the existing/new features of
application using techniques like parallel
processing.
Implemenation of Surrogate Process using Assign
Key Componets.
Create a transform and load code in Abinitio and
Shell scripts using Utility and API modes.
Documentation for creation, modification or
deletion of Jobs as per the requirement in Ctrl-M
Analysis of dependency of jobs in Ctrl-M
Usage of Web-EME to track data dependency and
understand upstream and downstream processes.
Raising a Ticket in HPSM for Creation of New Job
or rescheduling of the Job and following it up
with the concerned Team.
Worked with Agile Model and completed the work
assigned for every Sprint.
Checking In the list of new and modified Objects
and data dependency Analysis and data lineage
analysis on it.
Fix all the data Dependency and Data Lineage
issues found.
Assist QA and production Support Team until
Go-Live.
Client CAPITALONE
Project Name Digital Analytics
Project INGD, INGSB and Merchant services source
Description integration into CDI
Business Domain Banking Domain
Module Name CDI(Customer Data Integration)
Technology Data Warehousing
Role in Project Developer
Roles and Discussion with requirement Team and Onsite
Responsibilities Counter Part in Understanding the requirements and
clarification of any queries.
Preparation of High Level Design, Verification and
upload into SharePoint.
Preparation of detailed Level Design, Verification
and upload into SharePoint.
Adding Three New Line of Business into the
existing system-INGD, INGSB, Merchant Services.
Worked with the source system team(product
processors) to understand/Standardize the data
layout.
Work with other developers/BA to create a Best in
class ETL solution.
Involved in Designing the graph and using
optimized techniques.
Optimizing the design by generalizing the graph as
much as possible, Usage of Parallel Processing and
Conditional Components.
Logic to decompose and aggregation of data.
End to End Testing for every Line of Business.
Documentation for creation of Jobs as per the
requirement in Ctrl-M.
Usage of Web-EME to track data dependency and
understand upstream and downstream processes.
Raising a Ticket for Creation of New Job and
following it up with the concerned Team.
Assist QA and production Support Team until
Go-Live.
Client CAPITALONE
Project Name Digital Analytics
Project The objective of this project is to build
Description relationships.
Worked on the enhancements of the following module
Data Acquisition Module: Details on Data
Extraction from clean files on DDE.
Building Relationship Module: Builds all the
customer to customer and customer to account
relationships as per the requirements.
SBB Business Logic Module: Builds Vertical, Credit
and Horizontal Relationships.
Business Domain Banking Domain
Module Name SBB(small Business Banking)
Technology Data Warehousing
Role in Project Developer
Roles and Involved in Knowledge Transfer by Subject Matter
Responsibilities Experts.
Discussion with requirement Team and Onsite
Counter Part in Understanding the requirements and
clarification of any queries.
Preparation of High Level Design, Verification and
upload into SharePoint.
Preparation of detailed Level Design, Verification
and upload into SharePoint.
Application of complex business rules into
Abinitio using components like
rollup,join,reformat etc.
Implemented performance tuning logic on targets,
sources, mappings, sessions to provide maximum
efficiency and performance.
Generalization of the graphs for 12 different Line
of Business and creation of different psets and
Wrappers for each of them in Data Acquisition
Module.
Logic to find SBB and Non SBB customer by building
SBB, Non SBB lookups.
Usage of Multiple joins to group all related
customers into a relationship in Building
Relationship Module.
Performance enhancing the existing/new features of
application using techniques like parallel
processing and making use of Partitioning
Components.
Verification and Peer Review.
End to End Testing for every Line of Business.
Documentation for creation, modification or
deletion of Jobs as per the requirement in Ctrl-M
Analysis of dependency of jobs in Ctrl-M
Usage of Web-EME to track data dependency and
understand upstream and downstream processes.
Raising a Ticket for Creation of New Job or
rescheduling of the Job and following it up with
the concerned Team.
Worked with Agile Model and completed the work
assigned for every Sprint.
Checking In the list of new and modified Objects
and data dependency Analysis and data lineage
analysis on it.
Fix all the data Dependency and Data Lineage
issues found.
Assist QA and production Support Team until
Go-Live.
Client CAPITALONE
Project Name BDW
Project The Objective of the project is to Purge File from
Description error, log, reject, main directories based on the
retention period.
Business Domain Banking Domain
Module Name SBB(small Business Banking)
Technology Data Warehousing
Role in Project Developer
Roles and Requirement for Housekeeping of multiple files
Responsibilities getting created on a daily basis.
Optimizing by design for purging the jobs based on
the type of files and the retention period
mentioned for the type of file.
Implementation of Clean Up in Parallel File
System.
Requirement for Housekeeping of multiple files
getting created on a daily basis.
Implementation of clean Up on a Daily Basis By
Verifying the Retention Period and path for the
type of File using Abinitio graph and Shell
Scripting.
End to End Testing for All types of Files and All
Retention Period.
Verification and Peer Review.
Detailed documentation of the test Results.
Detailed documentation of the scheduling details
for the purge Job and Scheduling it in Ctrl-M
Assisting QA and Production Support Team in
Implementation until Go-Live.
Client CAPITALONE
DECLARATION
I hereby declare that the above written particulars are true to the
best of my knowledge and belief.
Shilpashree H.V