Manager Data

SUDHAMSH CHINTAPATALA

Mobile: 510-***-****

Mail :********.************@*****.***

Linkedin: http://www.linkedin.com/in/sudhamshc

SUMMARY OF EXPERIENCE

. Seven 7 years of work experience in IT industry which includes Analysis,

Development and Maintenance of various software applications in client-

server and Data warehouse environment. Expertise in providing Business

Intelligence solutions in Data Warehousing using Informatica, Oracle,

Teradata and Cognos Tools.

. Over Six (6+) years experience on Oracle Databases, RDBMS design and

developing stored procedures, functions, packages, triggers, views,

cursors using SQL and PL/SQL.

. Over Four (4+) years experience in Informatica PowerCenter

8.6/8.5/7.2/6.2 with expertise in designing the Tasks, Workflows,

Sessions, Mappings, Mapplets and scheduling the Workflows/Sessions using

Informatica.

. Two (2) years of Active Data Warehouse experience in TERADATA. Expertise

in building Enterprise Data Warehouses (EDW), Operational Data Store

(ODS), Data Marts, and Decision Support Systems (DSS) using

Multidimensional Model (Kimball and Inmon), Star and Snowflake schema

design addressing Slowly Changing Dimensions (SCDs).

. Two (2) years of Cognos 8 experience in FrameWork Manager, Query Studio

and Report Studio.

. Experience in full system development life cycle (SDLC).

. Experience in working on Unix Shell Scripting, SQL tuning, in UNIX

environment.

. Experienced in SQL*Loader, Import, Export, UTL_FILE, External Tables,

optimization using (analyze, explain plan, TKPROF), snapshots.

. Proficient in Oracle Tools and Utilities such as SQL*Loader and TOAD.

. Involved in exhaustive performance tuning, sessions monitoring and

optimization of PL/SQL blocks in both development and production

environment, for Oracle databases.

. Involved in large volume data migration to Enterprise Data Warehouse

(EDW) using PL/SQL, UNIX scripts, SQL*Loader.

. Excellent skills in developing both technical and functional specs.

. Extensive experience using Informatica Repository Manager, Designer,

Workflow Manager and Workflow Monitor including installation,

configuration and administration on Client/Server environment.

. Experience in integration of various data sources like Oracle, DB2, SQL

Server, Flat Files, XML files using Informatica.

. Extensive experience in designing and developing complex mappings from

varied transformation logic like Unconnected and Connected lookups,

Router, Filter, Expression, Aggregator, Joiner, Update Strategy.

. Experience in supply chain production support on Informatica and

Oracle environments.

. Extensive knowledge with Teradata SQL Assistant, Fast Export, Fast Load,

Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and

finely tuned the queries to enhance performance.

. Experience in identifying Bottlenecks in ETL Processes, improving the

Performance of the production applications using, ETL Tuning, Database

Tuning, Partitioning Primary Index Usage, Aggregate Tables, and

Normalization / Denormalization strategies.

. Experience with ERWIN in creating data models involved in Forward

Engineering/ Reverse Engineering

. Excellent communication skills, strong decision making skills,

organizational skills, and customer service oriented.

EDUCATIONAL QUALIFICATION

. Bachelors in Computer Applications (2000 - 2003)

Bangalore University,

INDIA.

. Masters in Computer Networks and Communications (2004 - 2005)

University of Westminster,

LONDON,

UNITED KINGDOM.

TECHNICAL SKILLS

Languages :SQL, PL/SQL, Unix-shell scripting, HTML and C.

Database Tools :Oracle SQL*Plus, SQL*Loader, TOAD,

Erwin, Teradata SQL Assistant.

ETL Tools :Informatica Power Center 8.6/8.5/7.1, Informatica Power

mart 5.1

RDBMS Servers :Oracle 7.x/8i/9i/10g, Teradata, MS SQL Server 7.0, DB2

Apache Tomcat 4.0.1.

GUI Tools :Oracle Reports 6i, Oracle Forms 6i, Cognos 8

Operating Systems :UNIX (HP Solaris 8/2.x, Red Hat Linux 7.x/6.x),

Windows NT.

PROFESSIONAL EXPERIENCE

Employer: E-BASE TECHNOLOGIES.

Client :- Wells Fargo, March 2010- Present

San Francisco, CA

ROLE :Sr Informatica ETL, Oracle, Teradata Database Developer/Analyst

Project Description

Wells Fargo Bank offers complete banking and financial services to their

customers. The project is based on Wells Fargo acquiring Wachovia Bank,

which involves system, databases integration. The development of data

warehouse is inextricably linked to the business needs of an enterprise.

Project's ultimate goal is for the bank to provide enterprise reports for

their internal and external use for making intelligent banking decisions

based on data available over a period of time. Data from existing Database

will be Extracted, Transformed and Loaded into Data Warehouse.

ETL Responsibilities

. Involved in Business analysis and requirements gathering from both Wells

Fargo and Wachovia business teams.

. Assisted in Creating Logical and Physical Data Modeling.

. Creating the design and technical specifications for the ETL process of

the project.

. Extensively used Informatica Power Center 8.6 for Extraction,

Transformation and Loading process.

. Assisted in creating fact and dimension table implementation in Star

Schema model based on requirements.

. Worked on the SCD (Slowly Changing Dimensions) models like Type 1, 2 and

type 2 variant.

. Wrote Unix Shell Scripts to validate extracted flat file data from

various sources like Oracle, DB2 and Teradata.

. Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer

and Warehouse Designer and Transformation Developer.

. Designed and developed Informatica Mappings and sessions based on

business rules.

. Developed several Mappings and Mapplets using corresponding Sources,

Targets and Transformations.

. Designed ETL process flow for entire DWH application and developed data

mapping spread sheets to define transformation rules for each stage of ETL

process.

. Extensively used transformations such as Expression, Joiner, Aggregator,

Lookup, Update strategy, Filter, Router and Union

. Implemented performance tuning logic on targets, sources, mappings,

sessions to provide maximum efficiency and performance.

. Created various PL/SQL stored procedures for dropping and recreating

indexes on target tables.

. Used workflow manager for session management, database connection

management and scheduling of jobs.

. Analyzed business process workflows and assisted in the development of

ETL procedures for moving data from source to target systems.

. Extensively developed Informatica mappings & tuned them for better

performance.

. Maintain Development, Test and Production mapping migration Using

Repository Manager

Environment

Informatica Power Center 8.6 (Power Center Designer, workflow manager,

workflow monitor), Oracle9i, Erwin 3.5.2, Windows XP professional,

Embarcadero Rapid SQL.

Employer: E-BASE TECHNOLOGIES.

Client :- NIKE, August 2007- Jan 2010

Beaverton, OR

ROLE :Sr Oracle, Teradata Database Developer/Informatica ETL Developer

Project 1:Description

The purpose of the Central Repository is to create and maintain a central

data warehouse and to create reports for the functional group for further

business analysis. Central repository contains data from numerous

production systems and other sources. The data is organized according to

requirements of the organization, such as by customers, products, vendors.

The Data Warehouse is structured for rapid online queries, summaries and

will contain both summary and detail data. The Source for the Data

Warehouse is SAP systems.

ETL Responsibilities

. Worked closely with Business Analyst team, discussed and gathered the

Analytics requirements and created the Business Model using Star schemas.

. Worked in ETL process using Informatica for various transactions and

loading data from different sources like Flat Files, XML sources and

Relational Database.

. Created numerous Mappings and Mapplets using Transformations like

Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter,

Joiner and Update Strategy.

. Created Sessions and Worklets in Workflow manager having event tasks like

e-mails.

. Used Parameter files to define values for parameters and variables used

in the mappings and sessions.

. Dropping and re-creating Indexes on the database Target table using pre-

sql and post-sql techniques while loading huge tables.

. Worked on performance tuning by finding out the bottlenecks in various

mappings.

. Involved in solving complex kintanas (tickets). These include SL1, SL2

and SL3.

. Handled Unix operating system tasks by generating Pre and Post-Session

UNIX Shell Scripts.

. Designed new Informatica mappings which extract data from PDM system and

load into DSS systems.

. Involved in creating Autosys Jobs which call Informatica Workflows, that

run in the supply chain environment.

. Involved in the migration of Informatica repository form version7.2 to

version8.5

. Played a key role in day to day production support of the Informatica

batch.

Environment: Informatica PowerCenter 8.6/8.1, Toad 9.1, Oracle 10g/9i,

PL/SQL, HP UNIX.

Project 2: Description

The goal of the Data Mart project is to implement a data warehouse as a

single repository of data and enhance business processes to capture

additional functional data that enable ad-hoc analysis and reporting. DM

is a consolidation of different OLTP systems like PRD, PRA and CDB.

Database Responsibilities

. Participated in gathering the user requirements and involved in writing

technical design documents.

. Developed several packages, standalone stored procedures and functions

for various business requirements.

. Extensively worked with SQL scripts to validate the pre and post load

data.

. Created database tables with complex constraints applicable to the

business rules.

. Optimized and tuned SQL and PL/SQL script using EXPLAIN PLAN and

TKPROF.

. Involved in the production release cycles and provide technical support

for the same.

. Create database links between production, quality and development

databases.

. Migrated tables and indexes to different tablespaces.

. Participate in data sourcing, extract data investigation process and work

with teams to develop PL/SQL code to extract, clean and sort data for flat

file generation.

. Involved in solving complex kintanas (tickets). These include SL1, SL2

and SL3.

. Technically involved in making sure the active batch loads meets SLA

(Service Level Agreement)

. Involved in identifying depreciated hints when migrating form Oracle 9i

to Oracle 10g.

. Worked on SQL Tuning and Query Optimization Techniques for complex SQL

Statements to improve performance.

. Worked in creation of Views for security and reducing the complexity of

Queries.

. Wrote various Unix shell scripts to automate the database process based

on the requirements.

. Modified BTEQ scripts to load data from Teradata Staging area to

Teradata data mart.

. Wrote numerous BTEQ scripts to run complex queries on the Teradata

Database directly rather than implementing the same in Informatica, to

reduce the time it takes for successful execution.

. Used PMON to find out the users logged into the system, CPU and IO'S used

by different jobs, to find out whether any daily incremental jobs are

being blocked.

. Created proper Primary Index (PI) taking into consideration of both

planned access of data and even distribution of data across all the

available AMPS.

. Created Teradata External Loader connections such as MLoad Upsert, MLoad

Update, FastLoad and Tpump in the Informatica Workflow Manager while

loading data into the target tables in Teradata Database.

. Performed tuning and optimization of complex SQL queries using Teradata

Explain. Created several custom tables, views and macros to support

reporting and analytic requirements.

. Expertise in Troubleshooting the problems encountered due to failure of

jobs that uses the loaders MLOAD UPSERT, MLOAD INSERT, MLOAD UPDATE and

FASTLOAD.

. Worked on ERWIN in creating data models

. Consistently coordinated with production support and also responsible for

estimating the time factor for several long running jobs depending upon

the data volume size and other database loads.

Environment: Teradata V2R5, Multi load, Fast load, Fast export, Tpump

Oracle 9i/10g, HP UNIX, TKPROF, TOAD 9.0.

Employer: E-BASE TECHNOLOGIES.

Client :- CISCO Jan 2007-July 2007

San Jose, CA

ROLE: Oracle, Teradata Database, Informatica ETL Developer

Project Description

The Enterprise Data Warehouse project aimed to design and construct a

consolidated Data Warehouse form an integrated Supplier Information System

(SIS) and a central billing system to establish a robust and cost effective

supplier management process. Distributed data residing in heterogeneous

data sources is consolidated into the target Oracle 9i enterprise Data

Warehouse. Power Center is used to extract data from various sources like

Microsoft SQL Server and Oracle to load into the Oracle9i Central Data

Warehouse

Responsibilities

. Involved in analysis, requirements gathering, function/technical

specifications, development, deploying and testing

. Used the Informatica Power Center designer to develop the required

mapping based on the ETL spreadsheet.

. Created various transformations like Filter, Router, Lookups, Stored

Procedure, Joiner, Update Strategy, Expressions and Aggregator to

pipeline data to Data Warehouse/Data Marts and monitored the Daily and

Weekly Loads.

. Debugged and performance tuned sources, mappings, targets and sessions by

reducing Data Flow, Eliminating I/O & bottlenecks, optimize resources,

optimize common ETL processes and data parallelism.

. Experience in designing and developing complex Informatica mappings

including Type-II slowly changing dimensions based on near Real Time

architecture set to run in batch processes.

. Worked extensively on Workflow Manager, Workflow Monitor and Worklet

Designer to create, edit and run workflows, tasks, shell scripts.

. Enhanced performance for Informatica session using large data files by

using partitions, increasing block size, data cache size, sequence buffer

length and target based commit interval.

. Used various Informatica Error handling technique to debug failed session

. Performed bulk data loads from multiple data sources to Teradata

Warehouse using BTEQ, Fastload, Multiload and Tpump.

. Coding the scripts using the utilities like Mload, Fast load, Fast

export, Bteq etc.

. Involved in creating secondary, join and hash indexes for efficient

access of data based on the requirements.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL, PL/SQL, TOAD,

UNIX Shell Scripts, Windows NT, UNIX.

College Of Applied Sciences Jun2005-Aug2006

London, Neasden

ROLE: Masters Intern Oracle Database Developer

Project Description

College Of Applied Sciences is one of the fastest growing educational

institutions in the United Kingdom, offering a wide range of courses, in

addition, research and development works (R&D), workshops, seminars, and

extends the consultancy services in the current and most demanding areas of

national and international interest. The SMS (Staff Maintenance System)

accepts the employees details and maintains the staff information in one

database. The system also maintains the personal records of the students

and generates the student reports on a monthly, quarterly, half year and

yearly basis.

Responsibilities

. Involved in analysis, requirements gathering, functional/technical

specification, development, deploying and testing.

. Provided back-end support for customized forms for students, supplier

maintenance, bill, receipt, letter of credit, invoice, debit and credit

notes.

. Doing unit testing on forms, reports, PL/SQL stored procedures,

functions, triggers, packages, views and cursors.

. Analyze, design and develop stored objects in PL/SQL to support payment

processing using Credit Cards, Electronic Check and Money Orders.

. Design screens using Oracle Developer Forms.

. Design and develop relevant triggers, stored procedures, sub-programs and

packages with advanced PL/SQL programming techniques such as ref cursor,

collections, and bulk operation.

. Code and test Oracle stored procedures using PL/SQL.

Environment: Oracle 8i, TKPROF, Forms 6i, Reports 6i, PL/SQL Developer and

TOAD.

Airwin Networks, India June2003-

Aug2004

ROLE: Intern Oracle Data Base Developer

Description

The Sales & Order Tracking System developed for Airwin to keep track of the

orders and information of the Sales generated. The orders are entered by

the Marketing department and are authorized by the Accounting department.

The order flows to the Production department on approval from Accounts.

Progress of the orders is entered by the Sales & Supply department and the

status of the orders is maintained in the system, on completion, order

flows back to Accounting for invoicing.

Responsibilities

. Performed analysis, database design and development.

. Provided back-end support for customized forms like customer and supplier

maintenance, bill, receipt, letter of credit, invoice, debit and credit

notes.

. Developed PL/SQL packages to monitor revenue earnings and expenses and to

maintain the general ledger of the organization.

. Developed stored procedures and functions using PL/SQL for complex

updates and audit trails.

. Wrote database triggers for audit and data validation.

. Designed the entity-relationship model and normalized database.

. Conducted re-sizing of data files, managed table spaces and data files.

Environment: Oracle 7.x, SQL, PL/SQL and Windows NT.

Contact this candidate