Mr. Seetharam

Devulpally

My Contact:408-***-****. Email:acek1m@r.postjobfree.com

OBJECTIVE:

To obtain a challenging position as a Sr .ETL Developer/Analyst, where I can utilize my skills and expertise that

will enable business, add value and provide opportunities for professional growth

PROFESSIONAL SUMMARY:

• 13+ years of solid experience with a wide repertoire of technical qualifications. Expertise in

analysis, design, development and implementation of large Data Warehouse, BI and other DB

applications in Financial and Manufacturing sectors.

• Expertise in ETL design and Application Database development using Informatica 8.x /7.x and

Oracle10g /SQL server/Informix Databases as backend, Skilled in UNIX shell scripts, knowledge

of CGI Perl and Java.

• Expert level skills in Oracle (11g/10g/9.i/8.i)application development using SQL*PLUS,

PL/SQL Packages, Procedures, Functions, Triggers and Arrays.

• Expert level usage of various Informatica (8.6/8.5/8.1/7.1) ETL tool components (Designer,

Workflow Manager, Workflow Monitor, Repository Manager) to Extract, Transform, and Load (ETL) the

data into the data warehousing tables.

• Strong in Data Analysis, Data Modeling, Data Migration, Data Conversion, and other Data

Integration tasks.

• Strong programming skills in UNIX and Perl scripts.

• Strong in Data Warehouse Architecture, and Business Intelligence (BI) solutions.

• Excellent Analytical skills with strong experience in data and Business analysis.

PROFESSIONAL EXPERIENCE:

Kaiser Permanente – Pasadena, CA Mar. ’12 to Present

Sr. Informatica Database Developer

Project: Medicare total sales Solutions - Kaiser Permanente Age-In(KPMAI) program requires monthly data

flow to generate prospect data in MTSS, Schedule outbound calls and initiate fulfillment of enrollment

material, The overall goal is to process the prospect list generated by Campaign data operations, leads,

enrollment, call scheduling and revenue generation from Medicare members.

• Analyze, Design, Develop and implement ETL interfaces using Informatica Designer and

workflow and extract data from various interfaces and loads the data into either flat files or staging

tables and further classified data into de-normalized form and make it available for the Reporting

team.

Technologies Used: Oracle Database (11g/10g), SQL Server 2008, Informatica - /9.0/8.6/8.1/7.0 (Designer,

Workflow Manager, Repository Manager, Deployment Groups), UNIX, SQL*Plus, PL/SQL, TOAD 9.7

Lockheed Martin – Sunnyvale, CA Jan. ‘09 to Dec. ‘11

Sr. ETL Developer

Page 1 of 4

Mr. Seetharam

Devulpally

Project: Enterprise Hyperion (EHP) - The Goal of the EHP project is to replace existing long range planning

and reporting tools with the Enterprise Hyperion planning system, thus providing a standard, efficient, and

effective planning and reporting system more closely integrated across the company.

• Analyze, Design, Develop and implement ETL interfaces through AGILE process which enables

Hyperion Planning team to use the data against the planning and forecasting data for future

businesses.

• Extract the data from multiple sources through GWX (Gateway exchange), Load and Transform

them through Informatica ETL process into the centralized data warehouse location and map the data

against Hyperion Planning, Schedule jobs through Run books.

• Provide product support after implemented into the production and fix Bugs.

Technologies Used: Oracle Database (11g/10g), Informatica - 8.6/8.1/7.0 ( Designer, Workflow Manager,

Repository Manager, Deployment Groups),Unix, SQL*Plus, PL/SQL,TOAD 9.7, HP Quality center tool,

Enterprise Hyperion Essbase Admin services and Planning tool, smartview, Unity Shared Point

Project: Transport Security Agency (TSA) - HRAccess Hiring Database (IHS)

• Role in this project is to extract source data from multiple hiring database interfaces and load the

data through datastage into the RAW, STAGE and ODW (Operational Data warehousing) tables.

• Responsibilities also includes develop build scripts for the migration of code into the Development,

Test and Production Environments.

Technologies Used: Informatica 8.6/8.1, Oracle 10g, SQL*PLUS, TOAD, PERL, clearquest and Linux

Project: (MS2/CFS/STS)

• Role in this project was to support financial group of MS2/CFS/STS clients by studying their

requirements, do analysis, design, develop ETL mappings, workflows using Informatica to load the

data from SAP systems and various other interfaces in to the Staging and ODS layers of the Oracle

data warehousing tables and make the data available for the reporting team.

• Responsibilities also include develop build and migration scripts to roll the code into the test and

production environment as a part of SDLC process and support post production issues and

enhancement of the end users.

Technologies Used: Oracle Database (11g/10g), Informatica - 8.6/8.1/7.0 (Designer, Workflow Manager,

Repository Manager, Deployment Groups), UNIX, SQL*Plus, PL/SQL, TOAD 9.7, BMC Remedy, SAP

Front end

Intuit –Folsom, CA Jan. ’02 to Dec. ‘08

Sr. Software Engineer

Project: Internet Banking and Bill Pay

The primary task of this project was to integrate the data stored in various physical infrastructure locations

and bring the data into the centralized location of the data warehouse repository which enables the Business

and Reporting team to access the data for their future forecast. Responsibilities include analyze user

requirements, build star schema for the data warehousing RAW, STAGE, ODS targets. Design and Develop

Informatica ETL mappings, workflows for loading data from various online banking and bill pay interface

sources and load the data into the target layers of the data warehousing /data mart tables.

• Used reusable objects like maplets, transformations and several other complex transformations like

(Aggregate, Normalizer, Joiners and Lookups) and tuned the Informatica caches to speed up the SQL

queries.

• Developed required SQL scripts, Stored Procedures, Functions and triggers to apply in the

transformations of the mappings.

Page 2 of 4

Mr. Seetharam

Devulpally

• Perform QA and Code review for my code and other developer’s code.

• Followed Agile SDLC process to roll the code into the Dev/Test/Prod environments.

Technologies Used: Oracle (10g), Informatica - 8.6/8.1/7.0 (Designer, Workflow Manager, Workflow

Monitor, Repository Manager) UNIX, PERL, SQL*Plus, PL/SQL (Packages, Stored procedures, Functions,

Triggers) TOAD 9.7

Project: Home Banking and Lending Application

Digital Insight ® Corporation is the leading online banking provider for financial institutions. Digital Insight

enables banks and credit unions to become the trusted transaction hub for their retail and commercial

customers. Digital Insight offers consumer and business Internet banking, online lending, electronic bill

payment and presentment, check imaging, account-to-account transfers.

• Analyzing requirements, work with various groups of project and hold discussions in nailing down

the various modules of the project, work with developers to integrate the various pieces of code.

• Implemented Object tree/XSL/XSQL /PLSQLDOM technology for XML parsing for the first time in

Digital Insight.

• Developed PL/SQL Stored Procedure, Triggers, Packages, Functions and views, Created

Object Types, Collection Types, Tables, and Indexes.

• Performed Application Tuning (Analyze Statistics, Running Explain plan to check the

optimization and tune the SQL queries).

• Used BLOB, CLOB, BFILE data types to retrieve and store the lending applicant data

including other details that comes in the form of XML generated data

Technologies Used: Oracle (10g), Informatica - 8.6/8.1/7.0 (Designer, Workflow Manager, Workflow

Monitor, Repository Manager) UNIX, PERL, SQL*Plus, PL/SQL (Packages, Stored procedures, Functions,

Triggers) TOAD 9.7

Fortuna Technologies Consulting Company - Sunnyvale, CA Feb. ‘97 to Dec. ‘01

Software Engineer

Client: Offroad Capital (Private Capital Financing) – San Francisco, CA (Apr 00 – Dec 01)

Project: Brokerage Operations Support & Schwab Revenue Sharing System

• Designed and developed UI /relevant Reports using (PERL/CGI) to enable the brokerage operations

team to handle multiple deals and to perform various operations like buys, sell, deliver transfer,

deliver out, etc. on behalf of investors who have invested in pre IPO companies looking for private

funds

• Developed a suite of reports, stored procedures and views based on which, Member Relations can

find the list of non-verified Schwab Members and get them verified, Brokerage Operations can look

at the transactions made by these investors, and a summary, based on which Finance can make the

payment.

Client: Cisco Systems - Sunnyvale, CA (Oct 98 – Mar 00)

Project: Engineering Failure Analysis (EFA) - EFA is a Web tool application for the Quality and Service

department that enable online support to internal Cisco users and external Cisco customers on Failure Parts.

EFA tool automatically queries and generates various online Web Reports and checklists to the quality

engineers, support, maintenance and Cisco customers.

• Involved in Analysis, Design, Development, and implementation of EFA GUI System which includes

development of table structures, stored procedures, functions and database triggers for the, above

system.

• Supported the Maintenance Group

Page 3 of 4

Mr. Seetharam

Devulpally

Client: Applied Materials – Sunnyvale, CA (Jan 98 – Sep 98)

Project: Part Failure Analysis System - Part failure analysis system is a tracking of failure parts that arrives

from different customers in different databases

• Responsible for design, development, testing and implementation.

Client: Pharmchem Laboratory Inc. – Menlo Park, CA (Feb 97 – Dec 97)

Project: Drug testing lab Maintenance and Billing System

• Responsible for the development of the customer drug tracking system to keep track of various drug

tests conducted for customers to ensure that the client is drug free and eligible to take job.

• Developed table structures, packages, stored procedures, functions, database triggers and responsible

for backend connectivity using JDBC-ODBC Bridge.

TECHNICAL SKILLS:

ETL: Informatica (8.6/8.5/8.1 and 7.1.4), datastage 8.1, Oracle Hyperion Plugins

Reporting Tool: Hyperion Planning and Hyperion Essbase

Databases: Oracle (11g/10g/9.i/8.i), SQL Server 7.0/2000, Informix 7.x

Tools Used: Erwin 4.1, Toad 9.7 Application Development Tool, BI (Business

Intelligence), Visio, Putty

Languages: SQL, PL/SQL, C, Perl CGI 5.0, Java 2.0 /JDBC

DB Tools: Oracle SQL Loader, SQL*PLUS

Shells: UNIX Scripting (C, KORN, AWK, And BOURNE) Java Tools: Eclipse

Applications: MS-VISIO, MS-Office

Configuration Management Tool: BMC Remedy, UNIX RCS, MS-SourceSafe, P4 (Perforce),

clearquest

Platforms: AIX 5L (Ver. 5.3), Linux OS, Sun Solaris, WINDOWS XP/NT/2000

BMC Remedy

Others: Basic Knowledge of SAP Front end, UltraEdit

EDUCATION:

Bachelors of Science in Mathematics

Diploma in Computer Applications

Page 4 of 4

Contact this candidate