Data Project

[pic]

[pic]

Maruthi Siddam

Email: *************@*****.***

Phone: 336-***-****

Summary:

. Over 8 years of total IT experience in Software development, designing

and implementing, with major focus in Data Warehousing, Business

Intelligence and Database Applications.

. Over 6 years of experience in design and development of data warehouse

solutions using Informatica Power Center 9.1.0/8.6.1

. Around 2 years of experience in Base SAS in implementing procedures,

macros, and applications for data cleaning, reporting, and

documentation. Developed Macros for generic coding and reusable

modules.

. Worked primarily in the domain of ETL for the financial

services/banking domain.

. Very strong skills in developing, mappings/sessions/workflows and

maintaining them in Informatica PowerCenter 9.1/8/6

. Performed debugging, troubleshooting, monitoring and performance

tuning using Informatica.

. Very Good Knowledge in Data Warehousing Concepts.

. Sound Knowledge in Relational Database Management Systems (RDBMS).

. Code SQL and PL/SQL in ORACLE 9i.

. Technological forte is Informatica PowerCenter, Informatica IDQ,

Abinitio, Base SAS, UNIX Shell Scripting, Oracle (SQL and PL/SQL),

Teradata, DB2.

. Possess a good analytical ability to understand the client's Business.

. Oracle Certified Associate - PL/SQL Developer

. Certified Informatica Developer

Skill Set:

Functional Skills

Management and Onsite Coordinator: Working with clients as a single

Leadership point of contact from Capgemini and responsible for

Skills executing and delivering projects. Leading a team of 8-10

offshore resources and managing their tasks and

utilization.

Business Regulatory Reporting: Worked on regulatory reporting for

knowledge 10th Largest US Bank. Possess in-depth knowledge of

Mortgage lending and Direct Retail Lending.

Banking & Credit Risk: Worked on Credit Risk Management,

a solution which is now a part of Capgemini's offering to

multiple Fortune 1000 Banks.

Technical Skills

ETL/BI Tools Informatica Power Center 9.1.0/8.6.1,Abinitio,BaseSAS

RDBMS Oracle (SQL & PLSQL), Teradata, DB2

Languages PL/SQL, Shell scripting, MS-DOS Scripting

Tools: Control-M, ESP Scheduler, Toad, Nexus, Bteq, Remedy,

PUTTY, Win SCP, CVS

Work Experience:

BB&T, Winston-Salem, NC

Feb'13 - Current

Project Description:

CCAR Regulatory Reporting

The Federal Reserve issued a capital plans final rule requiring U.S. bank

holding companies with total assets of $50 billion or more to submit to an

annual capital planning review process referred to as the Comprehensive

Capital Analysis and Review (CCAR). The monthly FR Y-14M comprises three

loan- and portfolio-level collections, and one detailed address matching

collection to supplement two of the loan-level collections.

The project involves creation of the monthly loan level files for

submission to Federal Reserve Board on a monthly basis. The project also

supports queries raised by FRB on data quality or other concerns.

Client Description:

The BB&T Corporation is one of America's largest banks, offering full-

service commercial and retail banking services along with other financial

services like insurance, investments, retail brokerage, mortgage, corporate

finance, consumer finance, payment services, international banking, leasing

and trust.

Role & Responsibilities:

. Onsite Coordinator

. As a subject matter expert on Mortgage and direct retail lending

portfolio for the Bank I am involved in identifying of critical data

elements required for reporting loan level data as per the

requirement.

. I am involved in creation of code using Base SAS to extract data from

multiple sources required for reporting.

. I am also involved in identifying missing information that the Bank

needs to capture on a regular basis and also create a roadmap to

identify data cleansing and standardization processes.

Environment:

Windows, UNIX, Base SAS, DB2 Client

BB&T, Winston-Salem, NC (India)

Jul'10 - Jan'13

Project Description:

RED-C Expansion

Client wanted to have some solution, which can give them the report of

their business process for making better business decisions. Based on the

client requirement the data mart is being built.

This engagement is for providing a Corporate Credit Risk Reporting and

Analytics Assessment and Roadmap service for BB&T. The resulting work from

this Roadmap will enable the client develop a credit risk business

intelligence data warehousing solution. The current centralized data

repository for CCRM is called LGRED (Lending Group Risk Exposure Data)

which has been developed in SAS. The critical concern with LGRED is its

lack of scalability to respond to increased business needs which will

constrain the current environment and limit the variety of analytics which

can be done.

The first phase of the engagement involves migrating History SAS datasets

into DB2 based credit risk mart and replace current monthly SAS programs

with Informatica code.

Client Description:

The BB&T Corporation is one of America's largest banks, offering full-

service commercial and retail banking services along with other financial

services like insurance, investments, retail brokerage, mortgage, corporate

finance, consumer finance, payment services, international banking, leasing

and trust.

Roles & Responsibilities:

. Offshore Coordinator and as an Informatica/ETL Developer

. Understanding Business and Functional requirements.

. Involved in Data profiling and Data Cleansing activity.

. Understanding the Existing architecture and source code (SAS).

. Suggesting low level design solutions.

. Technical Specs for History and monthly load.

. Development of Informatica Mappings and History load scripts (DB2 SQL)

. Coordination between Onsite team and Offshore Team in terms of queries

and doubts.

. Reviewing the offshore deliverables.

. Quality process management for the project.

Environment:

Informatica 8.6.1/9/1.0, Base SAS, Windows, UNIX, IBM DB2

DELL International Services, Austin, TX

Jan'10 - July'10

Project Description:

GEMS (Global Email Marketing System)

GEMS is the email marketing system of record for US, EMEA and APJ. Several

online and offline sources feed GEMS (sales tools, Dell Sub Center/my

account, ESP's).Email Service Providers (ESP's) check GEMS subscriber and

subscription status before emailing customer for email able flag. Acxiom

Digital & e-Dialog send undeliverables, unsubscribes and subscribes back to

GEMS.

GEMS Subscriber and Subscription tables are in DDW which is useful to

analyze the customer behavior and to run email campaigns.

Client Description:

Dell International Services is a global provider of innovative solutions

and capabilities to clients worldwide. Dell has deep industry expertise and

a portfolio of interrelated consulting, business processes, application,

and infrastructure services, necessary to create innovative solutions that

achieve and sustain measurable results.

Roles & Responsibilities:

. Informatica/ETL Developer

. Creating new mappings, sessions, workflows using source as Oracle and

target as Teradata

. Involved in complete development and Unit testing

. Query tuning and optimization

. Fixing TTs(bugs) and Implementation of CRs(change request)

. Worked on Reusable transformations, Reusable mappings and sessions.

. Used basic command level UNIX for file movement or searching in

directories including sed and awk scripts.

Environment:

Informatica 8.6.1, Windows, UNIX, Oracle 9i, Teradata, ER (Golden Gate)

DELL International Services, Austin, TX

May'09 - Dec'09

Project Description:

Saved Cart (Marketing Project)

The Saved Cart Marketing project was initiated to leverage online saved

cart information and market to these Dell customers in a relevant and

timely manner in order to get them to complete the sale of the system they

configured. These carts can be saved as a 'saved', 'emailed', or 'wish

list' carts. The purpose of this data set is to have SAS CI campaign

management tool generate marketing campaign.

Client Description:

Dell International Services is a global provider of innovative solutions

and capabilities to clients worldwide. Dell has deep industry expertise and

a portfolio of interrelated consulting, business processes, application,

and infrastructure services, necessary to create innovative solutions that

achieve and sustain measurable results.

Roles & Responsibilities:

. Informatica Developer

. Create mappings, sessions, workflows and mapplets for data migration

. Create/import sources or targets involving Oracle, flat files and other

relational databases as well

. Involved in complete development and Unit testing

. Involved Query tuning and optimization in Teradata

. Fixing production issues and Implementation of CRs(change request)

. Worked on Reusable transformations, Reusable mappings and sessions.

. Used basic command level UNIX for file movement or searching in

directories.

Environment:

Informatica 8.6.1, Windows, UNIX, Oracle 9i, Teradata, ER (Golden Gate)

DELL International Services, Austin, TX

July'08 - Nov'08

Project Description:

COE (Centre of Excellence)

To provide application (Informatica, Abinitio and D3 reporting) support in

the production environment related to Finance, Manufacturing, Services,

Sales and Marketing pipelines. Investigate the underlying cause of a fault

or disruption which affects the normal operation of applications and aim to

prevent incidents of a similar nature from recurring. By removing errors

which often requires a structural change to the IT infrastructure like bad

record issues, Duplicate data issues, Null values, data loaded on the wrong

load sequence numbers, data catch up for missing days from the collection

server and doing a manual ETL to the base tables on the Teradata databases.

Looking for tie out issues on the production and disaster recovery

databases and auctioning them.

Client Description:

Dell International Services is a global provider of innovative solutions

and capabilities to clients worldwide. Dell has deep industry expertise and

a portfolio of interrelated consulting, business processes, application,

and infrastructure services, necessary to create innovative solutions that

achieve and sustain measurable results.

Roles & Responsibilities:

. Remedy: Fixing and documenting Sev3 and Sev2 issues with respect to

Dell Data warehousing

. Fail: Fixing the routine failures with the control-M application

monitoring tool

. ETL Processes: Monitoring the collections and ETL process and making

sure SLA's are met

. Escalations: Handling escalations from the Senior Management teams

. Data: Working on duplicate data issues while the data is loaded on to

the table

. Restatements: Doing manual data restatements

. Dell7 and Dell8 Synch-Up: Synch up when the data is having a tie out

issue with production and disaster recovery databases

. Teradata - Performance and Tuning: generally do not write any code,

but we make suggestions

. Handling Oracle - Errors like table space, password expired, unhandled

exceptions, disk I/O, data error, time out, tns listener not available

etc.

. Oracle - Table space Reorg

. Process Improvements: Working on service reduction initiatives in

order to get the recurring issues fixed.

. Interacted with the Data Warehouse pipeline, subject Matter Experts

and business users to understand the severity and the downstream

impact

. Proposed multiple solutions to a given issue and extrapolating one

optimal solution

. Ensured Application Stability and availability in all domains

. Implemented changes to processes through a formal change ticket

process by making the approvers understand the impact of change.

. Took key responsibilities in building the Warehouse Knowledge base

. Trained new hires in the team on Problem Management, business view,

tools required for the efficient problem solving

. Used basic command level UNIX for file movement or searching in

directories including sed and awk scripts.

Amperion Inc, USA

Mar'07 -July'08

Project Description:

This project involves developing ETL solutions for the Enterprise

Datawarehouse for the client. The scope of the current phase is to maintain

the customer master data and the product master data.

Responsibilities:

. Create mappings, sessions, workflows and mapplets for data migration.

. Create/import sources or targets involving Oracle, flat files and

other relational databases as well.

. Develop mappings to load the data in slowly changing dimensions such

as Type1 and Type 2 according to the requirements

. Write SQL and PL/SQL extensively for Data set-up and data selection

for Stored Procedure Transformations.

. Analyze the design documents (functional specifications) for the new

requirements.

. Create index for faster access of rows in the table.

. Impose unique constraints on table columns for key retrieval.

. Code stored procedures and functions for functionality centralizations

. Code triggers to enforce data integrity.

. Create views to enforce security on the base tables by providing

access based on privileges.

. Create synonyms when objects are to be shared among different users.

. Unit Test the modules developed.

. Use basic command level UNIX for file movement or searching in

directories.

Environment:

Informatica Power Center 6, 7.1.4, Oracle, UNIX, Windows

ABN AMRO Bank N.V.

July'05 - Mar'07

Project Description:

Asset Management

This project involves developing ETL solutions for Data cleansing. The data

is about the portfolios - part of Asset Management division of the bank.

The data is stored by different applications into different databases. With

the help of ETL, the data is being validated for format and also semantics.

This is the first phase of the complete warehouse building.

The data is being generated into different databases by different

applications like Trade capture, pre-trade compliance, performance and

attribution etc. This data is in the first phase refined to meet all the

validations and then loaded into a warehouse for further analysis and

reporting. The first phase is being handled in this project.

Client Description:

ABN AMRO Bank N.V. is a Dutch state-owned bank with headquarters in

Amsterdam.

ABN AMRO serves retail, private and commercial banking customers in the

Netherlands and across the globe. Along with a comprehensive range of

products and services, ABN offer in-depth financial expertise, extensive

knowledge of numerous sectors and an international network supporting our

customers' domestic and international operations.

Roles & Responsibilities:

. Informatica/ETL Developer

. Create mappings, sessions, workflows and mapplets for data

integration.

. Create/import sources or targets involving Oracle, flat files and

other relational databases like mySQL.

. Write SQL and PL/SQL extensively for data selection and for Stored

Procedure Transformations.

. Analyze the design documents (functional specifications) for the new

requirements.

. Many types of lookups have been created for data semantic validations.

. Test functions of data type are extensively used for data format

validations.

. Code triggers to enforce data integrity.

. Create synonyms when objects are to be shared among different users.

. Unit Test the modules developed.

. Used basic command level UNIX for file movement or searching in

directories.

Environment:

Informatica Power Center 7.1.4, Oracle 9i, UNIX, Windows

Contact this candidate