Manogna

acqjy4@r.postjobfree.com

OBJECTIVE

Looking for a challenging opportunity where I can utilize my technical and managerial skills

SUMMARY

•Around 07 years of experience in IT Industry involving in full life cycle development including requirement gathering, analysis, design, development, testing, implementation, maintenance and documentation of Data warehousing models using ETL tools

•More than 8 years of hands-on experience on Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume of data processing applications and over 1 years of experience on Informatica Power center

•Having extensive programming skills in Ab Initio ETL tool, PDL, BRE, Plan IT, Profiler, DB2, Oracle, Data Profiler, and UNIX shell scripting.

•Worked closely with the business analysts and solution architects in finalizing the technical design of new applications for development / enhancements / production fixes

•Extensive experience in ETL process for OLTP and Data warehouse environments

•Experience working with multiple ETL tools like AbInitio, Informatica and Ascential data stage

•Expertise in Design, Configuring and Developing and maintenance of Ab Initio Graphs

•Experience working with Ab Initio’s multifile system using most of the partitioning and de-partitioning components.

•Good working experience with all components of Ab Initio such as Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup etc

•Extensively involved in reading the data directly form database tables and files and computes field and dataset level statistics using Ab Initio Data Profiler

•Strong UNIX shell scripting experience to automate the batch application

•Experience using scheduling tools like Trivoli, Autosys and Control-M

•Strong Knowledge on data warehousing concepts

•Experience on working with Mainframe environment

•Experience working Oracle sql and pl/sql

•Experience in managing the WSR meetings with business users, development team to support project activities

•Ability to Implement solutions with quantitative, analytical, diagnostic, debugging, and problem solving skills in all phases of SDLC

•Coordinated with offshore team on development and maintenance projects

•Substantial experience in Health Insurance, Financial, Retail and Telecom service industry business processes

•Proven track record of delivering optimal problem solving and decision making technical solutions in fast track development environment within timeframe.

TECHNICAL SKILLS

ETL Tools

:

Ab Initio CO>OP 3.0/2.15/2.14/ 2.11, GDE 3.0/1.15/1.14/ 1.11, Ab Initio data Profiler, Informatica 7.1/8.1, IBM Ascential Data Stage Client 7.5, BODI,SSIS

Programming Skills

:

SQL, PL/SQL, Unix Shell Script, C, C++, knowledge of Hadoop,SSMS

Databases

:

Teradata V6/V8, DB2 UDB 7/8.1/8.2.1, Oracle 8i/10g, SQL server 2005/2008, Microsoft VB 2009

Data Modeling Tools

:

ERWIN, UML Diagrams, ER diagrams

Packages

:

MS Office (Word, Excel, PowerPoint, Visio)

Operating Systems

:

Windows NT/9X/2000/XP, UNIX (Sun Solaris), LINUX, MS-DOS

Oracle Tools

:

PL/SQL Developer, SQL*PLUS

OLAP Tool

:

Knowledge on Cognos Report Net

PROFESSIONAL EXPERIENCE

Project # 1

Client: NYC DOE, NYC, NY Jan 2014 –Till date

Sr. ETL/Abinitio Developer

Responsibilities:

•Worked on moving the data from OLTP to ODS and loading the data on to client DB using CDC and ETL packages.

•Worked on Query Optimization, Testing and implementation on pre-production SQL server DB environment.

•Worked assisting offshore development team in requirement understanding, development and code reviewing for each release of SSIS project.

•

•Worked extensively as data analyst in fast changing production environment to troubleshoot and provide fix on daily production issues

Environment: Microsoft SQL Server Integrated services 2008, SSMS, MKS

Project # 2

Client: Wells Fargo, Sanfransisco, CA Aug 2012 – June 2013

Sr. Programmer Analyst Professional/Sr. Ab Initio Developer

Responsibilities:

•Involved in analysis of functional requirements and specifications.

•Worked extensively in creating mapping, technical detail design, Unit Test cases, and Implementation and Post Implementation documents.

•Worked assisting development team in requirement understanding, development and code reviewing for each release of project.

•Developed several generic graphs for application using dynamic dml and xfrs.

•Worked on all phases of SDLC of AbInitio project for several releases.

•Worked extensively in design, development, testing and deployment of Ab Initio graphs.

•Strong experience in extracting data from Mainframe to perform Historical and Incremental loads to Oracle Database.

•Also worked on creating the standard process documents for different projects to share among the team

•Worked on implementing enhancements in sql and mainframe projects.

•Worked with multiple teams in different projects in Production support and maintenance for several Projects.

•Responsible for troubleshooting and providing fix on daily bases to production Support team.

•Release specialist for several releases to Implement, validate and post implementation of project.

Environment: AB Initio GDE 1.14.136/1.15/3.0, Co>Op 2.17/3.0, IBM AIX Version 5, Oracle 10g, sql developer, IBM Trivoli (TWS),Unix Scripting

Project # 3

Client: Home Depot, CA Oct 2011 –July 2012

Project Lead

The Home Depot is the world's largest home improvement specialty retailer with more than 2,200 retail stores in the US, Canada and Mexico. "Buy Online Pickup In Store" or BOPIS project aims at less shopping time as the customer orders the product or service online and picks it up at the store.

Responsibilities:

•Worked in analyzing and understanding the functional requirements with the end users to provide technical implementation requirements

•Worked extensively in design, development and testing of Abinitio graphs using components like Normalize, Scan, Reformat,Rollup, Sort, MQ Subscriber and MQ Publish

•Extensive working experience in QA and production code migration

•Worked as Onsite Coordinator with offshore team in multiple projects

•Extensive worked in UNIX and shell scripting to increase the performance of the process

•Worked on creating RFC for production deployment

Environment: Ab Initio GDE 1.15, Co>op sys 2.15, GNU Linux, DB2 v8, Teradata V8, Unix Scripting

Kaiser Permanente, Silver Spring, MD, USA Dec 2009 to Aug 2011

Project Name: MLO TMS, AGEIN and LISO

Program Analyst/Sr. Ab Initio Developer

Kaiser is an integrated healthcare organization. It is a group of three distinct entities: Kaiser Foundation Health Plans/Care Delivery, Kaiser Foundation Hospitals, and Permanente Medical Groups. Worked on multiple projects like MLO TMS, AGEIN and LISO

Responsibilities:

•Involved in analysis of functional requirements, created mapping documents, assisted in code debugging and documentation.

•Worked extensively on design, development and testing of graphs for different projects including Teradata to Oracle Migration Projects.

•Worked extensively in Coding, testing, debugging, documentation and implementation of several releases.

•Worked extensively on MLO design and development of several graphs.

•Developed generic graphs and implemented successfully.

•Worked extensively in coding and fine tuning SQL scripts, PL/SQL Stored Procedures

•Extensive working knowledge in UNIX and shell scripting.

•

Environment: AB Initio GDE 1.14.136, Co>Op 2.14, IBM AIX 5, Oracle 10g, Teradata V6

Level3 Communications, Broomfield, CO, USA Sep 2009 to Dec 2009

Project Name: Order Mart

Sr. Ab Initio Developer/Lead

Level 3 is one of the largest providers of wholesale dial-up service to ISPs in North America and is the primary provider of Internet connectivity for millions of broadband subscribers through its cable and DSL partners. It uses the Order Mart data warehouse which is implemented at the enterprise level to keep track of customer purchases.

Responsibilities:

•Understanding existing business model and analyzing customer data across multiple business processes.

•Involved in writing wrapper scripts in UNIX shell Programming.

•Responsible for Extracting, Transforming and Loading data to operational database store in Ab Initio.

•Understanding the client requirements and design, development and testing of Ab Initio Graphs.

•Involved in designing and deploying Informatica Workflows.

•Experience working with Ab Initio multifile system using most of the partitioning and de-partitioning components.

•Involved in coding SQL scripts, PL/SQL Stored Procedures and Cursors.

•Design, Development and Maintenance of the graphs for the client requirement changes.

•Managing and Educating the development changes to the offshore team.

Environment: AB Initio GDE 1.14, Co>Op 2.14, Sun Solaris, Oracle 10g

VISA, Austin, TX, USA & Bangalore Jan 2008 to Jul 2009

Project Name: Inovant

Ab Initio Developer

Visa U.S.A. is the nation’s leading payment brand, backed by the world’s most reliable, secure and scalable payments network. Offering a diversified portfolio of payment products and services, Visa links more than 13,000 financial institutions, 6.3 million merchant acceptance locations and 500 million cards. Worked extensively on different modules like Commercial Card Data Repository Integrated (CCDRi), Accounts payable (AP) and 90 days Improvement plan.

Responsibilities:

•Responsible for Extracting, Transforming and Loading data to operational database store

•Understanding the client requirements

•Designing, development and testing of Ab Initio Graphs

•Configuration the metadata for the new graphs designed

•Designing, Development and Maintenance of the graphs for the client requirement changes

•Worked on Japanese multibyte data to load and extract the data to ODS.

•Managing and Educating the development changes as a Subject Matter Expert (SME) to different teams

•Worked on SQL/PL-SQL and wrapper scripts to automate the system

•Unit testing of the graphs and adding test cases to perform stage testing

•Post production support of the newly deployed codes

•Involved in modeling a data warehouse using Ab Initio data profiler for POC

•Involved in computing field and dataset level statistics completely characterizing the dataset by running profiler job using Ab Initio Data Profiler

•Involved in defining Physical Element values and characteristics, create a Validation as per Specification to help refine record formats and use profile results in GDE

•Designed Dimensional Data Model using Star Schema to make the profiler results available to OLAP

•Involved in the performance tuning of graphs

•Documenting the changes of the development for L3 support

Contact this candidate