Data Developer

SREENIVASAREDDY

901-***-**** / *********@*****.***

SUMMARY

* Over 10 years of IT experience in Software Development,Designing

and

Implementing with major focus on Datawarehousing, Business

Intelligence and

Data base applications.

* 5 years and 5 months of Experience in Design and Development of Data

warehouse & Business intelligence solutions using ETL tool

Ab Initio

* Over 5 years of experience in Data warehousing with large database

environments.

* Well Versed with all the Parallelism Features of Ab Initio 2.15.6.2

including Data parallelism, Pipeline parallelism and Component

parallelism.

* Extensive experience in Extract, Transform and Load process for ODS and

DSS Database instance using Ab Initio.

* Extensive experience in Data validations, Data profiling, Data cleansing

based upon the business requirements.

* Extensive experience with, Oracle (9i, 8i, 8.x) Coded well-tuned SQL, PL-

SQL,

* Extensive coding experience with SQL, PL/SQL, SQL *Loader, Unix Shell

Script(ksh).

* Designed and deployed well-tuned Ab Initio graphs for ODS and DSS

instance in both windows and Unix environments.

EDUCATION

* Master of Computer Applications from India.

* Bachelor of Computer Science from India.

SKILLS

ETL Tools Ab Initio(GDE 1.15.11, Co-op 2.15.6.2) Informatica

6.2/5.1

Data Modeling Erwin 3.5.2/4.0

Databases Oracle 9i/8i/8/7.x, MS Access, SQL server 2000,

DB2, Sybase 12/11.2/10 Teradata V2R6.2

Languages C, C++,SQL, PL/SQL, Visual Basic 6.0/5.0,

Developer 2000,Designer 2000, COBOL,

Cobol/400,CL/400, RPG/400

Scripting Languages Korn Shell Script

Web Technologies Java 2.0,HTML

Operating System Windows95/98/2000/XP,NT,UNIX(HP-UX 10.20,

SunSolaris)

Hardware IBM PC Compatibles, HP-UX, Solaris, AS/400

EXPERIENCE

Sep '08 to Nov'2010 Sr. AbInitio Developer, GE, St.Paul, MN

Real-time Middleware Platform: Involved in setting up the Real Time

Middleware Platform at GE Sales Finance. Developed web services using

Abinitio Continuous flow's components. These web services provided Real

Time data access to several E-commerce Applications and backend data

sources via SOAP calls.

. Worked with Business users to get the detailed requirements for the

Design of AbInitio web services in accordance with SDLC methodology.

. Data requests are received from E-com applications as SOAP wrapped

messages. These requests were processed and appropriate data, after

application of business rules, from backend data us returned to

requesting application.

. Developed various web services to retrieve and update Merchant Data,

Account Data, Demographic Data, Client ID Data, Dealer Data and Promo

Data in real time

. Extensively worked with Abinitio RPC Components like RPC-Subscribe &

RPC-Publish to accept e-com data requests and to return response

information.

. Implemented necessary data validation rules for Input fields before

sending to backend systems. Bad data is not processed and appropriate

data error is returned to requesting application.

. Generated WSDL(interface specification) for Input and Output non web

dml fields by using dml-to-WSDL command and converted WSDL to input &

output web dml's via wsdl-to-dml.

. Errors and other data validation errors are returned to requesting

application.

. Extensively used AbInitio components like Read_xml_Transform,

Write_xml_Transform, Multi reformat, Reformat,

Partition_by_expression,

Gather, Read_xml_Transform, call webservice, Publish, Multi_publish,

continuous Join with DB, Fuse, Update Table, Join, Normalization,

Sort,

Dedup Sort, Filter_by_Expression, Lookup file, Input file, Output

file, Input

table, Output table, Universal adapter

. Setup webservices on AbInitio Admin Plug-in page

. Unit tested all web services by using SOAP Utilities called SOAPUI by

issuing a request information to get the response from the back end

systems.

. Prepared test cases and performed Unit & Integration testing . Co-

ordinated with QA, UAT & Production teams to resolve issues.

. Created new Projects in DEV, QA & PRODUCTION Enterprise Meta

environments (EME's).

. Performed Check-In and check-out operations at sandbox level as well as

at graph

level into EME.

. Performed code migration by creating TAG's at sandbox level as well as

at graph level in EME. Created SAVE files and loaded them into

target EMEs.

. Used switch parameters to enable web services sense the environment

and to eliminate errors during code-

migration.

. Installed new Co-operating system software in Production servers.

. Written necessary wrapper scripts to schedule batch graphs.

. Involved in Production support of web services in case of any

failures.

Environment: Ab Initio GDE 1.15.11, Co>Operating System 2.15.6.2, Oracle

10.2, Unix Sun Solaris 5.10, DbVisualizer 7.0.6, Windows XP Professional,

Excel, Ms Word.

Jun '08 to Sep'08 Ab Initio Developer, AT&T, Dallas, TX

Parse TeaLeaf Archieve

Parse TeaLeaf Archieve retrieves the online transactions of customer

activations of cell phones.

. Extensively worked with business users in order to get the detailed

requirements of this project to proceed with phases of SDLC.

. Extensively worked with Internet components like Call Web Service

component to call the web services through URL's of different dates.

. Developed graphs to populate the XML SessionID's and to parse XML Source

from URL's of Call web service component through Read XML Component and

placed in local Ab Initio Queues.

. The second graph will subscriber the queue to extract the data and

compare with already existing the transaction in the database oracle in

order to Insert or Update the transactions.

. Extensively used Ab Intio Components like Call Web Service, Read XML,

BatchSubscribe,Redefine,Reformat,Normalization,Sort, Partition_by_key,

Partition_by_RoundRobin,Join,Filter_by_Expression, Lookup file,Input file,

Output file, Output Table, Update Table.

. Converted XML to DML to using utility called xml-to-dml.

. Created 4way multifile system to run the graphs parallel in both

development and production servers.

. Deploy the jobs in production and scheduled with planit and crontab

. Extensively worked on unit testing and prepared test cases to test the

data in oracle database.

Environment: Ab Initio GDE 1.14.37, Co>Operating System 2.14.109, Oracle

10.2, Unix Sun Solaris 5.10, SQL Navigator 5.5, Windows XP Professional,

Excel, Ms Word.

Sept' 06 to Mar '08 Abinitio Developer, Fedex Services, Memphis, TN

Customer Fusion Interaction History concentrates on capturing and storing

of customer Interaction history and dynamic profile elements that are of

interest across the enterprise. It will enable a single source for

customer interactions and profile elements across channels (Sales,

Marketing, Fedex.com, Customer Service, etc) and OpCkos (Express and

Ground) to enable the sharing of customer interaction data. FedEx business

areas will publish their interactions with customer's realtime for

subscribers to pull and store. DB2 will store 60 days of data and ISH will

provide 2 years of data.

. Extensively worked with phases of SDLC by analyzing the business

requirements and review with the detailed design schema with XML

designers.

. Coordinate with the FMQA core team regarding the Factory, Destination,

JNDI properties.

. Subscribe to JMS Server Back Bone using the JMS Subscriber and publish

the xml messages using FedEx custom made component to Write Multiple

Queues to Ab Initio Queues.

. XML Messages are pulled from JMS Server and stored in local Ab Initio

Queues.

. Batch Subscriber is used to subscribe to local Abinitio Queues and

Read XML component is used to convert to XML to DML.

. Created 21 Ab Initio Queues to store the XML messages from JMS Server

. Developed the front_end_graph in order to retrive the XML messages

from JMS Server with the help of JMS Subscriber component and placed

the respective messages to respective queues by using custom made

component Write multiple queues. This graphs works continuously 24/7

365 days.

. Developed 21 back_end_graphs in order to subscribe with Batch

Subscribe Component to 21 respective queues and convert the XML to

DML with the help of Read XML component and based upon account type to

split to create two flat files.

. Developed shell scripts to create a single or multiple queues, delete

a single or multiple queues, to find number of messages in each queue

.

. Developed Acquisition scripts like Create, Fastload, Insert, Delete to

load the data from flat files to Teradata.

. Developed Wrapper scripts for the Ab Initio graphs in order to

schedule in $Universe scheduler.

. Prepared the test cases to test the data in Teradata tables.

. Prepared MTP Document to move the source code to production.

Environment: Ab Initio GDE 1.14.35, Co>Operating System 2.14.93, Teradata

V2R6.2, Unix Sun Solaris, $Universe, Queryman 7.1, Windows XP Professional,

Excel, Ms Word.

July' 05 - June 06 Abinitio Developer, American Express, Phoenix, AZ

American Express Company is a diversified worldwide travel and financial

services company. It is a global payments, network and travel services

provider and international banking company. Develop and manage all aspects

of our vitally important relationships with merchants and card issuers

throughout the world.

. The projects in which I involved in IDN(Information Delivery Network)

and the feeds which developed in order to transform the data into

warehouse and to access the data for the analysis and to business

users.

. Extracted Data from Various Mainframes systems and transferred into

Oracle by using ETL tool Ab Initio.

. Created sandbox and EME Datastore settings in order to access the

Metadata.

. Created all the feeds with pre-graphs and then send into one-to-one

graphs in order to validate the data by using generated validation

graphs.

. Used Abinitio components like Reformat, Filter by Expression, Join,

Rollup,Scan, Dedup Sorted, Normalize,Denormalize Sorted, FTP from,

Fuse,Multi Reformat,Replicate,Partition by key,Partition by

Expression, Gather, Merge, Concatenate.

. Used Datasets components like Input File, Output File, Lookup File

Intermediate File, InputTable in pregraphs and one-to-one graphs.

. Used the cobol-to-dml utility in order to convert cobol copy books

into input layout by using the option called Import Cobol.

. Implemented a 4 way and 8 way multi-file system that is composed of

individual files on different nodes that are partitioned and stored in

distributed directories (using Multi-directories).

. Written conditional DMLs in order to match the condition with record-

type to access the data from the Input data file

. Interaction with Mainframe personnel is needed to get the Input data

files(Data sets) and cobol copy books.

. Involved in Unit testing, System testing and debugging.

. After Developed the pregraphs and one-to-one graphs, Check In into as

a new versions under source control in the EME datastore.

. Extensively used SQL in Oracle in order to create table and load the

data into table, writing the queries to test the data.

. Extensively Involved 24/7 in Production support with pager alert

daily,weekly and monthly on production engine.

Environment: Ab Initio GDE 1.13.22, Co>Operating System 2.13.1, DB2, Oracle

9i, Unix, Windows XP Professional, Excel, Ms Word.

Mar'04 - April' 05 AbInitio Developer, Providian Financial,

Cincinatti, OH

Providian Financial Corporation is a leading provider of lending and

deposit products to customers nationwide. Providian Financial is one of the

ten largest issuers of credit cards and a leader in developing innovative

financial products. It provides a wide array of credit-related services

like Instant Credit Card Approval System, 24-hour online account access,

Balance Transfers, Credit Card Activation, Online Customer Servicing,

Instant Rewards, Associate Programs, Personal Shopper for convenient online

shopping and more.

. Analyzing the Data Model.

. Understanding and reading Business rules from mapping document.

. Used Ab Initio as ETL tool to pull data from source systems, cleanse,

transform & load data into databases.

. Replicate operational tables into staging tables, Transform and load

data into warehouse tables using Ab Initio GDE and responsible for

automating the ETL process through scheduling.

. Created Sandbox and edited Sandbox parameter according to repository.

. Implemented Data Parallelism through graphs, which deals with data,

divided into segments and operates on each segment simultaneously

through the Ab Initio partition components to segment data.

. Implemented a 12 way multifile system that is composed of individual

files on different nodes that are partitioned and stored in

distributed directories (using Multidirectories).

. Responsible to configure the dbconfiguration file to connect to the

ODS and DSS to Load the data.

. Translating the logical data model in Erwin to a physical database

design, database construction, design optimization and functional

testing of the constructed database after reading the Functional

document.

. Designed and deployed the Extract, Transform and Load process using Ab

Initio for ODS and DSS instance by studying the business requirement

from the business users.

. Extensively used components like Input File, Output File, Input Table,

Output Table, Lookup, Join, FilterbyExpression, Aggregator,Reformat,

Rollup, Scan, Sort, Normalize, Denormalize, Partition and Departition

components.

. Automated both Monthly and Weekly refresh (data load) using the Unix

shell scripts

. Implemented the Parallel application by replicating the components-

datasets and processing modules into number of partitions by using

Partition by key, Partition by Roundrobin, and Broadcast components.

. Involved in data validation.

. Responsible for de-duping and consolidating customer records from

various sources to create master customer list.

. Created Summary tables using Rollup component.

. Configured Ab Initio graphs in wrapper script.

. Involved in writing Unit Test scripts, support documents and

implementation plan.

. Wrote UNIX Korn Shell Scripts as part of the Component Price Point

Verification.

. Involved in Ab Initio Graph Design and Performance tuning to Load

graph process.

. Responsible for analyzing the source data and reporting data quality

levels using Ab Initio as an OLAP tool.

. Responsible for creating test cases to make sure the data originating

from source is making into target properly in the right format.

Environment: Ab Initio 2.11.8, GDE 1.11.7/1.13.1, Oracle 9i, PL/SQL,

SQL*Plus 8.1.7, Erwin, Perl, TOAD 7.5, Unix, Unix shell scripting, Windows

NT/2000.

Mar'03 - Dec'03 ETL Developer, Aon Reinsurence, Chicago, IL

Aon Insurance is world leader in risk management, retail and reinsurance.

Informatica was used as ETL tool to extract data from source system to

target systems. There were numerous sources of data coming into the

warehouse, including RDBMS Data and flat files. This is an Insurance Data

warehouse (IDW) providing Policy Transactions, Premium and Claims

Transactions data to the business users. Users want to measure profit over

time by coverage, coverage item type, and geographic, demographic and sales

distribution channels. The system is fully integrated, enabling the entry

and sharing of policy and/or claims data among all components of the system

and capturing data to complete policy administration, claims

administration, policy issuance, billing, reinsurance accounting, and

bureau reporting and management reports.

. Requirement analysis in support of Data Warehousing efforts.

. Created Logical and Physical models for Staging, Transition and

Production Warehouses using Erwin 4.0

. Developed mappings for policy, claims dimension tables.

. Worked on Power Center Designer client tools like Source Analyzer,

Warehouse Designer, Mapping Designer, Mapplet Designer and

Transformations Developer.

. Used Repository manager to create user groups and users, and managed

users by setting up their privileges and profile

. Creation of Transformations like Sequence generator, Lookup, Joiner

and Source qualifier transformations in Informatica Designer.

. Created Complex mappings using Connected Lookup, Sorter, Aggregate and

Router transformations for populating target table in efficient

manner

. Created Mapplet and used them in different Mappings.

. Used debugger to handle errors in the mappings.

. Written pre session and post session scripts in mappings.

. Created necessary Repositories to handle the Metadata in the ETL

process

. Developed Informatica mappings and also tuned them for better

performance

. Wrote stored procedure to check source data with Warehouse data and if

not present, wrote the records to spool table and used spool table as

Lookup in Transformation.

. Designed and developed Oracle PL/SQL Procedures.

. Designed and Developed Oracle PL/SQL, Data Import/Export, Data

Conversions and Data Cleansing.

. Involved in Unit, System, Integration testing.

. Designed and developed UNIX shell scripts.

. Created various data marts from data warehouse and generated reports

using Business Objects.

. Organized data in the BO reports by using Filters, Sorting, and

highlighted data with Alerts.

. Use of BO Designer Module to implement Universes, linkages between

tables, creating prompts and queries, parsing the Universes, applying

contexts and alias tables to remove cyclic dependencies.

. Creation of reports like Reports by Product, Reports by Customer,

Reports by Period, Demographic reports and Comparative reports.

Working with database connections, SQL joins, cardinalities, loops,

aliases, views, aggregate conditions, parsing of objects and

hierarchies.

. Generated reports using Business Objects Report Designer.

. Created various geographical and time dimension reports of Fiscal

Year, Quarter, Month, week and daily reports for all Domains and

published through Web Intelligence.

Environment: Informatica PowerCenter 6.2/5.1, Business Objects 5.0, Erwin

3.5, Oracle 9i/8i, UNIX Shell Scripting, SQL, PL/SQL, SQL * Loader, TOAD,

MS SQL Server 2000, BO Developer Suite, UNIX Sun Solaris 2.6, Windows NT

4.0

Mar'02- Jan'03 ETL Developer, Waddell & Reed Financial, Inc., KS

This company has business centers across multiple locations and opts for

standard Business Management & improvement solutions to manage these

Businesses efficiently. The Business Management solutions currently

implement reporting interfaces which provide answer to many of needs but

after a lot of repetitive calculations, Coding and effort which can avoided

by implementing this warehouse solution and also the same time quality &

time of performance is greatly improved. This solution is extensible to

migrate data from any database though it basically began with collection of

data from legacy systems, which range from Oracle, DB2, COBOL, Sybase into

our centralized data warehouse Database in Oracle8i.

. Involved in designing the Data Mart models with ERWin using Star

Schema methodology.

. Extracted data from various sources like Oracle, DB2, COBOL, flat

files and loaded into Oracle database.

. Extensively used Informatica Designer to create and manipulate source and

target definitions, mappings, mapplets, transformations, re-usable

transformations, etc.

. Worked on various transformations such as Aggregator, Normalizer,

Update strategy, Router, Sorter, Source Qualifier, Filter, Expression,

Look-up, Sequence Generator, Joiner, etc.

. Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.

. Created Mapplets for reusable business rules.

. Used Pipeline partitioning and External Loader to improve Session

performance

. Used the Debugger to run Debug sessions setting Breakpoints across

instances to verify the accuracy of data.

. Created tasks, workflows and Worklets using workflow manager

. Used the Informatica command line utility pmcmd to schedule and

control sessions and batches.

. Involved in identifying bugs in existing mappings by analyzing the

data flow, evaluating transformations and fixing bugs so that they

conform to the business needs

. Fine-tuned existing Informatica mappings for Performance Optimization

. Handled Incremental loading using persistent mapping variables

. Performed Repository Administration tasks (Creating Repositories, Users,

Assigning privileges, creating backups and recovery)

. Performed Unit Testing and validated the data.

. Wrote PL/SQL Procedures, Triggers and Packages.

. Implemented Filters, Calculations, Conditions, Graphs & Prompts in

Impromptu reports.

Environment: Informatica PowerCenter 5.x, PowerMart 5.x, oracle 8i,

PL/SQL, SQL * Loader, TOAD, DB2, COBOL, Business Objects 5.1, Windows NT,

UNIX (Sun Solaris).

Nov'01 - Jan'02 ETL Developer, Sprint Communications, Overland Park,

KS

This project involved the development and implementation of a customer

billing data mart according to defined business rules for strategic

business analysis

. Understanding business needs and implementing the same into a

functional database design.

. Interpreted the information from various Operational Data Sources and

external systems to create a road map for the Data Warehouse

designing.

. Maintained Warehouse metadata, naming standards and warehouse

standards for future application development.

. Implemented Corporate Data Mart (CDM) for Askesis Development Group

using Star Schema and loaded the Data using Informatica PowerCenter

5.1.

. Designed and developed Informatica mappings for data loads and data

cleansing.

. Extensively used almost all of the transformations of Informatica

including Stored Procedures, Lookups, and Update Strategy.

. Extensively used ERwin for Data modeling, Dimensional Data modeling

and Design Schemas.

. Created the Entity Relationship diagrams and maintaining corresponding

documentation for corporate data dictionary with all attributes, table

names and constraints.

. Involved in performance tuning of targets, sources, mappings, and

sessions

. Suggested changes to the Physical Data Warehouse Model based on the

ETL and Referential Integrity gap requirements.

. Extensively used ETL to load data from MS SQL Server 7.0, Sybase,

Oracle 8i, Flat Files and COBOL files into staging area and then to

relational database.

. Created process flow for production environment.

. Developed PL/SQL stored procedures and triggers in Oracle to achieve

the objective. The stored procedures, extract raw data from the

databases, apply numerous business rules and finally store the

processed data in DB tables.

. Developed Catalogs, Business mix Reports, Variance Reports, Ad-hoc

Reports and Exception Reports using Cognos Impromptu, Multi

dimensional Cubes, and Manual levels, Level Plans, Sub Cubes,

Alternate Drill Downs and Alternate Levels using Cognos PowerPlay and

Power Transformer.

Environment: Informatica PowerCenter 5.1 / PowerMart 5.x, PL/SQL, Oracle

8i, MS SQL Server, DB2 UDB, IBM-AIX, TOAD

Jun'00 - Oct'01 Database Developer, Probe InfoTech Ltd. Mumbai, India

This is a client/server architecture, which has different modules like

Finance, Marketing, Inventory, Payroll, Production, and Purchase, which

enable the system to give you online information located at different

geographical locations. The system goes to the life cycle right from

purchase of raw materials to the selling of the finished goods. This system

pertains to the business process, which contains of managing accounts,

stationary duties, salaries, credit & debit functions, financial ledgers,

registers, special reports balance sheets, profits and loss account

statements etc

. Installed and configured MS SQL Server 6.5

. Created several objects like tables, views and stored procedures

according to developers or front-end applications requirements.

. Transferred data objects from development server to development

server.

. Involved in performance tuning

. Created indexes for the major user tables.

. Creating and monitoring scheduled tasks.

Environment: MS SQL Server 6.5, Windows NT 4.0, Crystal Reports 7.0, SQL

Navigator

Mar'98 - Jan'00 Programmer/Analyst, L&T Cements Pvt. Ltd., Hyderabad

The project is an intranet based Organizational Chart Application, which

keeps track of hierarchical structure, department information, and also

developed the application for Instance Information Generating System (IIGS)

that allows user to add and modify details and helps in searching for

necessary reports.

. Involved in the Design and Development of user interface forms using ASP,

HTML.

. Written code for client side validations using JavaScript.

. Procedures or functions were written for constraints or validations.

. Developed Forms using Visual Basic and to integrate the application

using PL/SQL.

. Involved in creating Database triggers using PL/SQL and stored

procedures.

. Coding of exception handling routines using visual basic.

. Created the database by providing data storage and retrieval and data

validation and security system.

Environment: ASP, HTML, Java Script, SQL Server 6.0, Visual Basic, IIS 4.0,

WinRunner, Windows NT.

Contact this candidate