Sreedevi Yellamraju

214-***-**** x *** acui9e@r.postjobfree.com /acui9e@r.postjobfree.com

Senior Ab Initio Developer/Technical Lead

Austin, TX

Overall 11+ years of IT experience working in Data Warehouse/Data Mart design, development, UNIX/SQL, Data Analysis and documentation, Report writing & ETL designing.

About 8 years of working experience in Ab Initio ETL Development/Testing in High volume environment.

Experience in interaction with the Business Analysts, identifying the needs & the requirements of the system and involving in requirement study of the system.

Expertise in Use Cases, Software Development Life Cycle (SDLC) processes and Object Oriented Design Technologies.

Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

Expert in using AB Initio ETL tool for implementing extensive transformations and conditions.

Extensive knowledge in EME, check-ins, checkouts, command line interface, air commands.

Hands on experience in development of Data Warehouses/Data Marts using AB Initio Co>OP, GDE, Component Library, Oracle and UNIX for mainly Banking/Financial industries.

Experience in Data Warehousing concepts like Dimensional Modeling, Star Schema.

Experience in migrating applications from one EME Data store to another.

Experienced in interacting with EME Data store with several air commands.

Well versed with various Ab Initio parallelism techniques and implemented number of AB Initio Graphs using Data parallelism and Multi File System (MFS) techniques

Experience in integration of various data sources such as flat files, ASCII, DB tables, UNIX shell and wrapper scripts.

Reasonable knowledge in Stored Procedures, Indexes using SQL and PL/SQL.

Designed, created, implemented several projects, Jobs, Work Flows, Scripts, Data Flows, Data stores, Transformations, Functions, Scheduling Jobs, Validations and Tracing debugging.

Migrated the code between repositories across different environments [DEV/IT/UAT/Prod].

Optimized performance issues for the reporting after the migration.

Well-Organized, Quick learner, Self-motivated and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design and Coding.

Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements).

Scheduled ETL jobs using Control M.

Excellent analytical, programming, written and verbal communication skills.

Technical Skills

TOOLS: Ab Initio Co>Ops 3.0.2, GDE 3.0.2, GDE 1.15.13, GDE 1.13.1, Ab Initio Co>Ops 2.15, EME, DataStage, Microsoft office Visio 2003

DATABASE: DB2, Teradata

O/S: UNIX, AIX, Windows NT 4.0

Languages: SQL and PL/SQL, J2EE, Struts, HTML, JavaScript, Cognos

Work Experience

Dell Inc.

Senior Ab Initio Developer/Technical Lead – Austin, TX

13 Apr 2015 to Present

Description: EBI Engineering – EBI is primarily responsible for creating manufacturing and services reports for Business solutions. Team is working with Teradata to store all the related information related to manufacture and services for all the regions.

Responsibilities:

Good Understanding of business requirements, data requirements, data mappings, data validations, source application, scope items and implementation procedures.

Analysis and documenting the business, system requirements, designed and developed by SDLC process methodology for customized reports.

Good understanding about release management cycles, work orders, incidents tracking, creating RFCs and rollout procedures

Defined and documented the technical specification designs of all programming applications.

Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc., and used lookups.

Analysis of shell scripting created for end-to-end process.

Execution of E2E scripts to ensure the process is loading data appropriately.

Analysis of graphs and wrapper scripts for upgradation.

Created test approach, test plan and test case documents and involved in multiple phases of testing.

American Express

Senior Ab Initio Developer/Technical Lead – Phoenix, AZ

2006 to 10 Apr 2015

Description: GCST Corporate Cards - GCST is primarily responsible for creating, deploying, and operating Business-to-Business (B2B) solutions for the Global Commercial Card (GCC) and Global Business Travel (GBT) organization’s client base. The team also supports Global Network Services and Global Merchant Services to promote the B2B goals.

Responsibilities:

Worked on business requirements with extensive interaction with Business analysts, customers and reporting teams, and assisted in developing the low level design documents.

The aim of the projects is to collect the required data from various sources to an operational data store from OLTP which would help in more efficient reporting and analysis purposes.

Good Understanding of business requirements, data requirements, data mappings, data validations, source application, scope items and implementation procedures.

Act as a lead developer and worked in all the phases like analysis, design, development, unit testing, supporting QMS team and production rollout.

Thorough understanding the source system, creating psets, XFRs, merge/load statements and wrappers.

Create various Ab Initio graphs to utilizing the Multi File System’s (MFS) to run them in parallel.

Created multiple p-sets to run multiple instances with different parameter.

Good experience using the joins, dedup sorts, denormalize, normalize, Rollup, Read/Write filescomponents.

Monitor production jobs, resolving ETL issues, coordinating the implementation of production changes (developing, upgrading, testing, implement and document software changes) and provide recommendations for resolving the issues as well as optimization processes.

Use Ab Initio generic graphs for extraction of source data from DB2, transformation of business rules and loading into database.

Performed all code Check-in and Check- out operations with EME.

Incorporated Error handling component, force_error function and grouped error messages.

Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.

Debugged the failures from the log files and reran the jobs, by analyzing the checkpoints within the graphs.

Create UNIX wrapper scripts for Control M scheduler.

Creation of Release documents and Implementation plans

Senior Ab Initio Developer – Salt Lake City, UT

Description: SVDW Prepaid & Gift Cards - SVDW is a module that is the heart of Gift Card Applications. SVDW is a Data ware housing module used for Financial, Compliance and Regulatory Reporting. It helps Amex Business to do Sales Forecasting & analytics for Stored Value Cards (Gift Cards, Prepaid Cards – Blue Bird, Membership and Reloadable Travel Cards). This application collects heterogeneous data from multiple systems like FIS, Serve and Legacy etc. and creates a homogenous database.

Responsibilities:

Analyzed and documented the business, system requirements, designed and developed by SDLC process methodology for customized reports.

Analyzed source data and converted the business requirements into various Ab Initio graphs.

Good understanding about release management cycles, work orders, incidents tracking, creating RFCs and rollout procedures

Developed extensively easy to understand tech-spec to make it easy for coding by the offshore team.

Developed process for efficiently testing changes to the current production systems.

Involved in decreasing application run times significantly by using performance tuning.

Assigned phases and set up checkpoints to complex graphs having large number of components to protect against failure, avoid dead lock and easy recovery of failed graphs.

Migrated and validate tags from development to QA to Production environments.

Worked on STAR SCHEMA data ware house model.

Performed design and code reviews to enforce ETL standards and guidelines.

Participated in project definition phase with Business users and functional owners.

Processed several complex datasets in file formats such as ASCII, delimiter, text and CSV.

Expert in defining the Meta data format DMLs for Ab Initio.

Involved in performing UAT with the user to ensure that the code meets their expectations

Data Cleansing using Ab Initio components like filter by expression, reformat, rollup and join components, data validation, flow watchers and sampling components.

Implemented Data cleansing and created DML for the XML files to be used in AB Initio.

Responsible for the overall quality and timeliness of the deliverables.

Created test cases for various scenarios for unit testing

Ab Initio Developer

Description: GPP Traveler’s Checks & Gift Cards - GPP is a module that is the heart of Gift Card Applications. GPP is a Data ware housing module used for Financial, Compliance and Regulatory Reporting. It helps Amex Business to do Sales Forecasting & analytics for Stored Value Cards (Traveler’s Checks & Gift Cards). This application collects heterogeneous data from multiple systems like AS400 and creates a homogenous database.

Responsibilities

Developed Ab Initio graphs for data validation using validation components and Sample Component.

Metadata mapping from legacy source system to target database fields and created Ab Initio DMLs.

Worked on improving the performance of Ab Initio graphs by using Various Ab Initio performance tuning techniques like using looks instead of Joins etc.

Implemented lookups, lookup local, In-Memory Joins and rollups to speed up various Ab Initio graphs.

Prepared analysis documents with high and low level business requirements.

Defined and documented the technical specification designs of all programming applications.

Ensured that proper development processes and standards are followed, conducted code reviews.

Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc., and used lookups

Created test approach, test plan and test case documents and involved in multiple phases of testing.

Good understanding of the existing system architecture.

Finding the new solutions for improve the performance.

Identify the new system architecture to replace the existing system.

Responsible of business requirement and analysis from business users.

Defects were traced, reviewed, analyzed and compared using Quality Center.

Attended defect resolution calls, created test reports and presented progress updates to launch managers.

Involved in tuning the queries to deploy in the program so that the Cost time is reduced.

Written various shell wrappers to incorporate Ab Initio graphs.

Design, Development, and Enhancement of new functionalities

Defined production support methodologies and strategies.

Logging in the different issues related to the development phase.

JP Morgan Chase

Software Developer – Chicago, IL

2004 to 2006

JPMorgan PM - JP Morgan is a Leading global financial services firm dealing with assets and involved in operation in more than 50 countries. They provide advice on corporate strategy and structure, sophisticated risk management in cash securities and derivative instruments around the world. They also participate in proprietary investing and trading.

The project (PM system) mainly caters to the measurement of the performance of the various categories of deployed funds and the associated fund managers for the global clients of JP Morgan Chase Investor Services in USA, UK and Australia. The Performance of these are measured and reported in multiple views and categories to facilitate the decision making process of fund managers, clients and investors.

Roles and Responsibilities

Development of Impromptu and ad hoc reports using Cognos.

Prepared design documents.

Prepared mapping documents.

Developed source target mappings.

Actively participated in UAT & gathered gaps identified in UAT.

Preparation of high level and low level Design Documents.

Test scenario preparation.

Test case preparation and uploaded to Quality Center.

Contact this candidate