SUMMARY

• 8+ years of IT experience in Administration, Analysis, Design, Development, Testing and Implementation of various data warehouse applications using Ab initio 3.0.2, EME Technical Repository, Teradata 12 & 14, Datastage 8.X, UNIX.
• Extensively worked in creating Data marts using Ab Initio GDE 3.2.3/ CO>OP 3.2.2.3, Express>It 3.3.2.0 ETL Functions. Designed and built logical and physical models into catalogues and universes for end - user and management reporting needs.
• Experience in the different Source/ Target Systems like Flat files, Multi-file systems (MFS), Multiple files (Batch of files), Ab initio queues (Continuous flow Graphs), and Relational Database systems (RDBMS) - Oracle, Teradata.
• Extensive experience in conducting Data Analyses, Data Mapping, Gap Analyses, Risk Identification, Risks Analyses, and Risk management.
• Skilled in the use of computer languages including JavaScript and SQL.
• Capable of using talent with databases and operating systems to improve environments solve issues and prevent future problems.
• Experience in AGILE development methodologies.
• Hands on experience in creatingContinuous and Batch graphs.
• Have worked on XML processing with Ab Initio, where XML files come to Ab Initio through Java UI.
• Implemented Plans (Conduct>It), component folding and Micrographs.
• Proficient in Developing dynamic lookups and dynamic DML.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition the data from serial file.
• Well versed with various Ab initio parallelism techniques, Multi file systems and implemented number of graphs using data parallelism.
• Sound experience in Shell scripting.
• Have good exposure in Performance tuning and troubleshooting methods.
• Have good knowledge of Data Warehousing Concepts.
• Having good exposure toAB INITIO (ETL), UNIX, Oracle 10g and MS SQL Server 2005.
• Involved in Developing Ab Initio Graphs in a MPP (Massively Parallel Processors) Environment for the ETL process jobs in a High Volume and dynamically growing environments.
• Tuned the Graphs by removing unnecessary components to enhance the performance.
• Exposure to Conduct It, BRE, Data profiler products.
• Dexterous in handling Oracle and Teradata Databases.
• Having working experience in creating different korn shell scripts and handling graphs and plans at backend.
• Extensive experience in writing and tuning complex SQL queries, Sub-queries.
• Hands on experience on version control system (EME).
• Well versed in EME administration, Code migration and environment check out.
• Working knowledge of QC and ALM tools for bug tracking.
• Prepared Technical Specification Document (TSD), having details about pricing process.
• Worked with Wrapper scripting with UNIX Shell programming, Scheduling of Ab initio jobs with Auto Sys.
• Exposure of Data Profiling and Metadata hub.
• Good experience in development of PL/SQL stored procedures, functions and packages.
• Good experience in development of various types of reports using Actuate. Report Designer Professional.
• Strong communication and inter personal skills with ability to work in a team environment or individually.
• Excellent communication skills, good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS

ETL Tools: AbInitio GDE 1.1x, 3.0x, CO>OP 2.1x,3.0, Metada Hub, Data profilerInformatica,Erwin 4.1/3.7, Microsoft Visio 2007

Tools: Maestro, Auto Sys, Tivoli Work Load Scheduler

OS: UNIX, Windows 95/98/NT/ME/00/XP, MS-DOS, Linux 8x

Databases: Oracle 11i,10g,9i/8i/8/7.x, MS SQL Server 2008/2005/2000 , Teradata v2r6.1MS Access, IBM DB2.

Languages: UNIX Shell Scripting, SQL, PL/SQL, T-SQL, C, C++, JCL, Perl.

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

Web: HTML, DHTML, XML, ASP 2.0/3.

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Ab Initio Developer

Responsibilities:

• Developed and Implemented extraction, transformation and loading the data from the legacy systems using Ab Initio
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs and written complex XFRs for implementing the business logic transformation.
• Implemented various levels of parameter definition like project parameters and graph parameters instead of start and end scripts.
• Extensively Used Transform Components Aggregator, Match sorted, Join, Denormalize sorted, Reformat, Rollup and Scan Components
• Involved in Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Crontab, Job Scheduler, Database Load Interface, and Denormalization using Ab Initio.
• Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects across the organization.
• Developed Ab Initio scripts for data conditioning, transformation, validation and loading.
• Gathering the knowledge of existing operational sources for future enhancements and performance optimization of graphs.
• Assisted in developing various reports using PL/SQL Stored Procedures.
• Involved in writing wrapper scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading.
• Experience in Ab Initio parallel and serial flow batch graphs, conditional components, other components like Transform, Read and Write XML, Read and Write Multiple files, Partition graphs.
• Worked in Mainframe by creating OUTPUTA of good records which will be used in downstream processing.
• Used Parallelism techniques to partition and process large data simultaneously
• Created Auto Sys job stream to schedule jobs by creating box jobs and jil templates.
• Developed shell scripts to automate file manipulation and data loading.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.

Environment: AbInitio GDE1.13, Co-Op2.13, UNIX, Oracle 9i, SQLServer Navigator 5.0,SQL Server2000, Cygwin, AMS Software,Maestro, DB2, Teradata, Windows2000, Crystal Reports 9.0

Confidential, Wilmington, DE

Ab Initio Developer

Responsibilities:

• Understood the business requirements with extensive interaction with users and reporting teams and assisted in developing the low-level design documents.
• Worked with product vendor to identify the bugs in latest version while updating the GDE, Express>It with latest save files to fix them.
• Monitored Teradata systems effectively using Viewpoint port lets and alerts
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Extensively used the Teradata EXPLAIN facility to describe how the database will perform the query.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like checkin and checkout were used for this purpose.
• Maintained locks on objects while working in the sandbox to maintain the privacy
• Built various utilities on Unix shell scripting to automate various phases of Unit test the developed code.
• Used Auto Sys for Scheduling the Jobs and setting up the Jobs for execution.
• Used Anthill and udeploy to deploy and maintain various versions on different environments.
• Worked on Teradata Upgrade from Version 14 to 15.10
• Worked on Teradata Installation of servers like Viewpoint, PDCR & TARA GUI.
• Worked on Query optimization/Collect stats etc.
• Supported Teradata servers like Nodes, Viewpoint, PDCR, TARA GUI, Net Backup for Prod & Non-Prod servers.
• Worked on Monitoring & Trouble shooting of Backup, Restore & Copy of Teradata Objects.
• Developed Complex XFRs to derive new fields and solve various business requirements.
• Developed appconfs based on previously developed graphs.
• Maintained end to end lineage by using components like documentation in scenarios where lineage cannot be maintained.
• Set and managed development activities and project calendar
• Worked with team of developers and other professionals throughout project lifecycle
• Generated and reported on DWH applications and its volume

Environment: Ab Initio GDE 1.15.7, Co>operating system 2.15, Teradata, Unix, Db2, Sql Assistant, Putty, SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Shell Scripts, XML, XSD, Maestro 8.5.

Confidential, Richmond, VA

Ab initio Developer

Responsibilities:

• Developed and supported in extraction, transformation and load process (ETL) for a Data Warehouse from legacy systems using Ab Initio and provided technical support.
• Interpret transformation rules for all target data objects and developed Ab Initio graphs to support the transformation.
• Created Database Configuration files (.dbc) and involved in creating SQL statements with sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table.
• Developed UNIX shell scripts using SQL programs for daily and weekly data loads.
• Developed Data transformation, loading, scrubbing and extraction programs using Ab Initio ETL tool.
• Used various Ab Initio components of Partition, De-partition, Database, Datasets, Transform, FTP and Sort to build Graphs in GDE.
• Created XFRs during the data transformation phase prior to creating load ready files.
• Implemented Partition techniques using Multi file system.
• Involved in creation of proper test data to satisfy all required test cases and performed unit testing on all deliverables also was part of the code review team
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process.
• Documentation of complete graphs and its components.
• Used Autosys 4.5 as job scheduler, worked also as a production support, solved issues like missing files, storage and loading issues.

Environment: AbInitio GDE1.12,Co-Op2.12, UNIX, Oracle 9i, SQLServer Navigator 5.0, DB2, Teradata, Windows2000

Confidential

Ab Initio Developer

Responsibilities:

• Involved in project from scratch and participated in design and development.
• Gathering the requirements, analyzing the requirements and document (Business understanding Document/ Harmonization Document) them accordingly. Preparing the design documents (HDD, TDD, and LDD).
• Involved in designing and development of different continuous and non-continuous services using Ab Initio.
• Developed the calculation logic of products for the different services in the project.
• Involved in designing and development of Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques.
• Implemented Star Schema models for the above data warehouses by creating facts and dimensions.
• Extracted and loaded data from various data sources like Oracle/Teradata databases, Flat Files and XMLs.
• Involved in development of UNIX shell scripting and handled the project from back-end.
• Carried the performance tuning on the Ab Initio graphs to reduce the process time.
• Extensively used the Teradata and Oracle SQL queries.

Environment: Ab Initio GDE1.12, Co-Op 2.12, UNIX, PL/SQL, Oracle 9i, SQL Server7.0, Windowing