SUMMARY

• Over 7 plus years of IT experience in teh Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications.
• Over 6 plus years of solid experience in Extraction, Transformation and Loading (ETL) mechanism using Ab Initio. Knowledge of full life cycle development for building a data warehouse.
• Experience with Ab Initio Co>Operating System, application tuning and debugging strategies Proficient with various AB INITIO Parallelism and Multi File System technique
• Designed Parallel Partition Ab Initio Graphs for a high volume data warehouse
• Implemented teh Parallel application by replicating teh components and processing modules into number of partitions
• Involved in Ab Initio Graph Design and Performance tuning to Load graph process
• Experience in creating custom schema from Ab Initio EME base schema and creating EME custom views.
• Developed and automated control validations for teh ETL process to appropriately tie teh source and target data.
• Developing and testing wrapper scripts for jobs on PERL based automation system, Autosys.
• Tuned teh Graphs by removing unnecessary Sorts, used Lookup files, to enhance teh performance
• Experience in designing and implementing Ab Initio EME Metadata projects
• Responsible for writing shell scripts (wrapper) to schedule teh jobs in teh development environment
• Responsible for fully understanding teh source systems, documenting issues, following up on issues and seeking resolutions
• Strong noledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing using Ab Initio.
• Experience in UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server, and MS Access.
• Experienced in writing SQL query and PL/SQL Procedures, Triggers, and Functions necessary for maintenance of teh databases in teh data warehouse development lifecycle.
• Good exposure to SQL, PL/SQL stored procedures, Triggers and Packages.
• Good Understanding of DDL, DML and ILM concepts
• Good Knowledge on different kinds of data bases (DB2, Oracle, IMS, TeraData, MS SQL)
• Working noledge of multiple databases and test data management solutions likeIBMOPTIM, etc.,
• Experience in installing IBM InfoSphere Discovery 4.6 & Optim 11.3 Tool and Optim TDM, Optim Designer.
• Exposure and involvement in execution of end - to end data archival/masking projects.
• Experience in masking of data in DB2, VSAM, Oracle, SQL etc. using InfoSphere Optim
• Experience in handling masking of flat files
• Extract teh data using Test Data Management component and perform teh data obfuscation
• Assist in design and development of InfoSphere Discovery & InfoSphere Optim solution design.
• Knowledge of writing Optim exits
• Expertise in TDM concepts including Data sub-setting, Data Masking and Data profiling.
• Ability to co-ordinate effectively with development team, business partners, end users and management
• Deep understanding and capability in troubleshooting of teh common issues faced during teh development lifecycle including coding, debugging, testing and final roll-out
• Set up development, QA & Production environments
• Expert in problem solving skills with teh ability to think creatively and strategically about alternative solutions and opportunities.
• Experience in working on multiple Projects at one time
• Vast experience in work environment with a mix of onsite-offshore Global Delivery model.
• Experience in reviewing and monitoring project progress, planning & managing dependencies and risks, Resource Planning, Project Budget Tracking and Forecasting.
• Self motivated, excellent written and oral communication skills
• Strong analytical & problem solving skills.

SKILLS/TOOLS

ETL Tools: Ab Initio GDE 3.1.3.2, CO>OP 3.1.5, Informatica Powercenter, Powermart, IBM Optim 11.3/13, IBM InfoSphere Discovery 4.6.

Tools: AutoSys, Tivoli, SQL Loader, WinSQL 5.0, TOAD, Siebel Tools 7.5, Erwin 4.1/3.7, Microsoft Visio 2000

OS: UNIX AIX 5.3, OS/390 z/OS 1.6, Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x

Databases: Oracle 11g, MS SQL Server 2008, Teradata V13.10, DB2 UDB (8.0)

Languages: Visual Basic 6.0/5.0, SQL, PL/SQL, and Transact-SQL

Packages: SQL* PLUS, Toad 7.x, SQL Loader

Scripting: UNIX Shell (Ksh/Csh), JavaScript.

Web: HTML, DHTML, XML, ASP 2.0/3.0

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Ab Initio Technical Lead

Responsibilities:

• Met with business/user groups to understand teh business process and gather requirements.
• Extracted and analyzed teh sample data from operational systems (OLTP system) to validate teh user requirements and Created high level design documents.
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Prepared High Level Design of Source Data Analysis, ETL Process flow, Error Handling Re-startability and Extendibility.
• Work with other developers/BA to create a Best in class ETL solution
• Work with teh source system team (product processors) to understand/Standardize teh data layout.
• Developed highly generic graphs to serve teh instant requests from teh business
• Worked with Infrastructure team to write some custom shell scripts to serve teh daily needs like collecting logs and cleaning up data
• Involved in writing wrapper scripts to run teh graphs, to load into Data Warehouse and to verify teh counts while loading
• Gathering teh noledge of existing operational sources for future enhancements and performance optimization of graphs
• Worked on documenting and creating Visio diagrams for teh legacy systems for which documents did not exist.

Environment: Ab Initio GDE 3.1.3, Oracle 11g, EME, Unix AIX, Linux, Teradata, MS Visio.

Confidential, Plano, TX

Technical Lead, TDM

Responsibilities:

• Worked in teh Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing and Data Validation.
• Has In-depth understanding and hands-on experience onIBM OPTIM
• Worked on installing and configuring Optim and IBM Infosphere Discovery.
• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users
• Responsible for teh detailed design and documentation.
• Designed, developed and unit tested Optim Services for teh CO Auto Finance project
• Improved performance of Extract, Convert Services by using various Optim performance techniques like relationships.
• Worked on defining convert process in Infosphere Optim
• Involved in execution of data archival and masking tasks
• Worked on Data Subsetting, Data Profiling and Data Masking
• Used teh extract, convert and load services to scrub/mask teh Production NPI data and load teh scrubbed data into non-prod environment.
• Worked on setting up teh DB Aliases for different environments for Optim usage.
• Participated Agile Iterative sessions to develop Extended Logical Models and Physical Models
• Created mapping document and ETL design document
• Carried teh performance tuning on teh Optim Services to reduce teh process time.
• Worked in Scrum & Agile Methodology Environment

Environment: IBM Optim, Ab Initio GDE 3.1.3, Oracle 11g, EME, Unix AIX, Linux, Tivoli, SQL Server 2008.

Confidential, Dallas, TX

Ab Initio Technical Lead/Developer

Responsibilities:

• Created Ab Initio graphs dat transfer data from various sources like Oracle, flat files and CSV files to teh Teradata database and flat files.
• Worked on Multi file systems with extensive parallel processing.
• Implemented Lookups instead of joins, in-memory sorts to minimize teh execution times while dealing with huge volumes of data.
• Extensively used Partitioning Components: Broad Cast, partition by key, partition by Range, partition by round robin and De-partition components like Concatenate, Gather and Merge in Ab Initio.
• Implemented Transform Components such as Aggregate, Dedup Sorted, Filter by Expression, Join, Normalize, Reformat, Rollup and Scan Components and created appropriate XFRs and DMLs.
• Used Lookup Transformation in validating teh warehouse customer data.
• Performed bulk data load from multiple data source (ORACLE 10g, legacy systems) to Teradata RDBMS.
• Used Teradata SQL Assistant front-end tool to issue SQL commands matching teh business requirements to Teradata RDBMS
• Coded and Unit tested Ab Initio graphs to extract teh data from Oracle tables and MVS files.
• Produced mapping document and ETL design document.
• Worked closely with teh end users in writing teh functional specifications based on teh business needs.
• Participated in project review meetings.
• Provided maintenance and support to most of teh applications.

Environment: Ab Initio GDE 3.1.1, Oracle 11g, EME, Solaris, Unix AIX, Linux, Tivoli, Teradata 13.1, BMC Remedy.

Confidential, Lincolnshire, IL

Ab Initio Lead

Responsibilities:

• Involved in creating teh high level and low level technical design documents
• Developed complex Ab Initio graphs applying various business rules and requirements from teh Users
• Responsible for giving Production support, working in flexible timings.
• Worked on fine-tuning teh existing Ab Initio graphs in order to has optimum performance.
• Created perl scripts in order to execute teh jobs through driver
• Involved in working and analyzing on complex database structure
• Closely worked with teh client and teh users in order to meet teh requirements
• Worked closely with teh database admin team in order to come up with an optimum solution for critical business requirements
• Responsible for creating test cases to test teh production ready graph for integrability, operability.

Environment: Ab Initio GDE 3.0.2, Oracle 10g, EME, Solaris, Unix AIX

Confidential, Irving, TX

Ab Initio Tech Lead

Responsibilities:

• Involved in gathering teh requirements and creating teh high level and technical design document.
• Developed complex Ab Initio graphs applying various business rules on teh data and loading teh data into teh ODS tables
• Worked with teh Business Users during teh entire project in order to make sure dat teh expectations of teh business is met
• Worked with teh Users during teh User Acceptance Testing Phase and made sure their queries are answered and teh business requirements are met
• Coordinated with teh Production support team, transferring teh required noledge to them in order to handle well when teh project went live.
• Created all teh supportive documents and followed teh SDLC to give out a proper end product.

Environment: Ab Initio GDE 3.0.5, TeraData 13.10, EME, Linux

Confidential, Lincolnshire, IL

Ab Initio Developer

Responsibilities:

• Involved in teh design and development of many complex graphs for teh LP application
• Responsible for Development of Graphs and Unit Testing
• Responsible for designing and implementing data mobilization job streams dat incorporate data hygiene, merge/purge, and transformation processes
• Had supported implementation of business intelligence and marketing automation solutions
• Responsible for creating test cases to test teh production ready graph for integrability, operability, and to make sure teh data originating from source is making into target properly in teh right format
• Responsible for interpreting teh transformation rules for all target data objects and develop teh software components to support teh transformation. Coded and tested complex Ab Initio ETL routines
• Had participated in software development projects to develop logical and physical data models and to capture application specific ETL metadata and work flows
• Used most of teh Ab Initio Components.
• Developed shell scripts to customize teh ETL Ab Initio Graphs at runtime.
• Used Check in/Check out for teh CVS version control system.
• Extensively used Partition and Departition components on multi file system.
• Extensively used Sort and Transform components such as Join, Filter by Expression, Dedup Sorted, and Re format within teh graph for business query.
• Developing Shell Scripts to automate file manipulation and data loading procedures
• Performed complex queries involving large data volumes
• Validating teh output data of teh graph with various Validate components such as Compute Checksum, Validate Records.
• Responsible for teh automation of Ab Initio Graphs using Korn shell scripts
• Creating summary reports of teh output of graphs using Aggregate, Rollup, Scan components.
• Developed Graphs common data validation for teh different sources.
• Had Prepared/implemented data verification and testing methods for teh Data Warehouse.
• Had done performance and tuning of Ab Initio ETL graphs, processes and load routines and provided mentoring in Ab Initio
• Analyzed and reviewed teh Detailed Design schema with teh Designers so as to has proper understanding of teh requirements
• Responsible for interacting with teh business analyst and client representatives to develop technical specifications dat meet documented business requirements
• Responsible for providing requirements to improve re-usability of components and development of cutting edge coding standards and provide feedback related to product integration, internally developed infrastructure components, and application templates based on project experience

Environment: Ab Initio 2.14/3.0.2, GDE 1.15/3.0.2, Oracle 10g, PL/SQL, SQL Developer, Solaris 9

Confidential, NE

Sr Ab Initio Developer

Responsibilities:

• Designed and developed various Ab Initio graphs based on teh business requirements
• Developed generic graphs to extend a single functionality to many processes and reduce redundant graphs
• Reponsible for modifying teh dml’s and xfr’s as per teh business requirements and hence enhancing teh Ab Initio graphs
• Used Sort and Transform components such as Join, Filter by Expression, Dedup Sorted, and Re format within teh graph for business query
• Responsible for creating test cases to test teh production ready graph for integrability, operability, and to make sure teh data originating from source is making into target properly in teh right format
• Responsible for giving Production support, working in flexible timings and coordinating with teh offshore team
• Worked on exception handling by gathering all teh rejected records to flat files
• Worked on teh mainframe to extract teh source file, when it is not triggered automatically
• Responsible for coordinating with teh source teams to fix various production issues.
• Responsible for maintaining user security table theirby giving data accessing permissions to only teh required users
• Worked on enhancement of different graphs theirby enhancing teh processing time of huge data volume
• Performed data cleansing operations on teh data using transformation functions like is valid, is defined, is null, string trim etc
• Providing full support and representing teh team when their are database upgrades or enhancements during teh weekends
• Created complex Ab Initio graphs and extensively used Partition and Departition components to process huge volume of records quickly, thus decreasing teh execution time
• Used inbuilt emergency library (emerlib) to check-in and check-out graphs in order to perform necessary modifications

Environment: Ab Initio 2.15, GDE 1.15, IBM DB2, PL/SQL, UNIX AIX, CA7, Mainframes

Confidential

Ab Initio Developer

Responsibilities:

• Involved in Full Life Cycle of teh Project and used most of teh Ab Initio Components
• Involved in all phases of teh ETL process, which includes requirement analysis, Source-Target Mapping document and ETL process design.
• Transformed data using complex business process rules.
• Extensively used Partition by Key & Sort, Partition by Expression/ Round Robin, Filter by Expression, Sort, Reformat, Gather, Redefine, Replicate, Scan, Denormalize, Sorted and Normalize components to develop teh ETL transformation logic.
• Designed and Developed Ab Initio Graphs based on teh Business Requirements.
• Developed Complex Ab Initio XFR s to derive new fields and solves rigorous business requirements.
• Generated DB configuration files (.dml, .cfg) for source and target tables using db config and modified them according to teh requirements.
• Responsible for teh Validation of teh different sources by using Ab Initio Functions.
• Replicate operational tables into staging tables, Transform and load data into warehouse tables using Ab Initio GDE and responsible for automating teh ETL process through scheduling and exception-handling routines.
• Worked with Ab Initio components to create Summary tables using Rollup and Scan components.
• Designed and developed teh graphs using teh GDE, with, rollup, sort, scan, dedup sorted, reformat, read excel, write excel, join, merge, gather, and concatenate components..
• Developed generic graphs to extend a single functionality to many processes and reduce redundant graphs
• Created complex Ab Initio graphs and extensively used Partition and Departition components to process huge volume of records quickly, thus decreasing teh execution time
• Worked on improving teh performance of Ab Initio graphs by employing Ab Initio performance components like Lookups (instead of joins), In-Memory Joins, Rollup and Scan components to speed up execution of teh graphs
• Check in/Check Out existing applications Using EME in order to perform teh necessary modifications
• Performed data cleansing operations on teh data using transformation functions like is valid, is defined, is null, is error, string trim etc.
• Used Ab Initio to create Summary tables using Rollup and Aggregate components
• Responsible for creating test cases to test teh production ready graph for integrability, operability, and to make sure teh data originating from source is making into target properly in teh right format
• Written user defined functions for business process to improve teh performance of teh application.

Environment: Ab Initio 2.13.1.17, GDE 1.15.1, Quest DB2, PL/SQL, Erwin, UNIX TOAD 7.5, SunOS 5.8 and Quality Center.

Confidential, Northbrook, IL

Ab Initio Developer

Responsibilities:

• Define & build teh data transmission mechanism for receiving and sending data into/from teh repository.
• Extensively used various Ab Initio components like Reformat, Join, Sort, Normalize, Input Table, Output Table, Load DB Table, Update DB, Gather Logs and RunDBSql for developing graphs
• Developed Ab Initio graphs dat reads teh excel files and converts into ASCII format.
• Worked extensively on Join, Sort and Reformat Components.
• Design and development of ETL process using Ab Initio as teh tool.
• Worked on multifile system to improve teh performance and to reduce teh response time
• Developed graphs based on concatenation of all teh customers and generating a single file
• Define reporting needs to verify teh correctness of teh data and for Management reporting.
• Created Ab Initio graphs to build business logic to extract data from different external systems, validate, transform and load data to Oracle.
• Establish process to consolidate data received from different external systems into teh repository.
• Data verification and validation processes.
• Developed Unix shell scripts for executing teh graphs/jobs.
• Design and development for process scheduling using Autosys

Environment: Ab Initio 1.14.2.1, UNIX and ORACLE 10g

Confidential

PL/SQL Developer

Responsibilities:

• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc based on technical and functional specification documents
• Developed / modified scripts to create tables, views and executed them using SQL Plus
• Developed / modified scripts to rectify data errors and executed them using SQL Plus
• Ran batch jobs for loading database tables from flat files using SQL Loader
• Writing Sql server stored procedures to build teh Macros.
• Created Stored Procedures and Functions using Query Analyzer Editor.
• Created/updated TSQL stored procedures and UDFs to support efficient data storage, manipulation and enhancement.
• Responsible for user management and object security maintenance
• Fine tuned teh application queries.
• Used Data Transformation Services an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations.

Environment: Oracle 8i, PL / SQL, TOAD, Windows 2000, Visual SourceSafe, SQL Loader.