SUMMARY

• 8 years of IT experience in Software Development Life Cycle: Analysis, Design, Development, Testing, Evaluation and Implementation with extensive exposure in Database, Data warehouse and ETL process technology.
• Extensive experience in utilizing ETL Process for designing and building very large - scale data OLAP and OLTP instance using ETL tools Ab-Initio.
• Responsible for creating logical and physical data models then transforming the logical into physical according to the model supplied by the reporting team.
• Provided second tier production support for Data Warehouse for internal and external data flows to Oracle DBMS from ETL servers via remote servers, Ab Initio remote access loading tables with a mix of Ab Initio graphs.
• Worked with the Databases such as SQL Server, Oracle, Teradata and DB2. With VLDB instance for both OLTP and OLAP environment.
• Worked closely with testing team and done AI testing including unit testing and system testing in both testing and pre-prod environment.
• Hands on experience in System Testing, Unit testing and Integration testing.
• Hands on experience in diverse fields like Financial, Retail and Telecom relational Databases with an extensive use of ETL techniques, Dimensional Modeling Design techniques, Data Management, Data Integration Techniques, Data Architect, Database Applications, Data warehouse, and Business Intelligence solutions.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Effectively Tuned and Monitored RDBMS at both application and database level for better performance.
• Hands on experience in end-to-end Data warehousing ETL routines, which include writing custom scripts, stress testing, data mining and data quality processes.
• Extensive experience in writing efficient and well tuned SQL Queries and UNIX (Kshell) Scripts to provide reporting, process and validate data on Teradata, SQL Server and Oracle.
• Code production changes, write monitoring, data recovery and repair routines. Write Support Documents and Clarify solutions.
• Created requirement specification documents and mapping documents and participated in JAD discussions.
• Strong experience in implementing Data Warehouse applications.
• Created Ab initio best practices and standards documents to the different clients.
• Developed UNIX scripts for alarm point alerts for the various batch processes in case of failure.
• In-depth experience in troubleshooting and problem resolution for batch related issues.
• Involved in providing 24/7 pager production support.
• Coordinating with various teams in the migration/deployment process for performing application migration/deployment to a higher environment. Enhancement and Defect Management.
• Involved in scheduled changes, configure for automate batch processing and rollouts to technology operations.
• Strong consultation and interaction skills with enterprise wide business partners.
• Excellent Project Managing skills along with Data warehousing technical skill set.
• Expert in Incident Management working through critical incidents. Manning command center and conducting Incident resolution bridge calls.
• Supported Operational databases and legacy data ware house.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.
• Good Hands on experience in PDL.

TECHNICAL SKILLS

Data Warehousing: Ab Initio (GDE 2.14 to 3.0), Co>Operating System 2.14 to 3.0), EME

RDBMS: Teradata V2R5, Oracle 9i/8i, MS SQL Server 6.5/7.0/2000 DB2, Sybase, MS Access 7.0

Tools: SQL Assistant, MS Access Reports, TOAD,ACE, Autosys, Clear Case,Op Console

Programming: SQL,UNIX Shell Scripting, Korn Shell, SQL*Plus, PL/SQL

Operating Systems: Windows 95/98/NT, DOS, Solaris, Red Hat Linux, HP-UX

PROFESSIONAL EXPERIENCE

Confidential, Edison, NJ

Sr Ab Initio Developer

Responsibilities:

• Designed and deployed the Extract, Transform and Load process, using Ab Initio by studying the business requirements from the business users.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Generated DB configuration files for source and target tables.
• Worked with VSAM files and generated dml’s using Abinitio utilities.
• Good Hands On Experience with SQL scripts and Autosys
• Used Ab Initio functions for improving performance of Ab Initio graphs.
• Used Debuggers and Watchers to test and examine the behavior of the components.
• Involved in code review and performance tuning of ETL graphs.
• Extensively worked with the XML components.
• Involved in Data profiling that helps in redesigning the database.
• Execution on the graphs on the Unix Environment.
• Tested Ab Initio graphs in development and QA environments using test data, fine tuned the graphs for better performance and migrated graphs to the production environment.

Environment: Ab Initio Co-Op 3.0, Ab Initio GDE 3.0, EME, UNIX, SQL Server 2000.

Confidential, OH/NJ

Sr Ab Initio Developer

Responsibilities:

• Worked in the Enterprise System Team on Data Extraction, Data Cleansing, and Data Validation.
• Involved in writing complex SQL scripts and Store Procedures.
• Involved in all the stages of SDLC during the projects.
• Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO.
• Worked to support daily/monthly cycle execution from data prospects.
• Responsible for requirement gathering and development of Expiration Date Fictionalization project.
• Responsible for analysis and development for data synchronization.
• Co-ordinate with different testing groups to accommodate their testing data requirements and translate them to data selection criteria in Ab-Initio format.
• Document ways to automate manual processes.
• Maintaining sandbox by storing all the work in a sequential order.
• Maintained and did trouble shooting for batch processes for overnight operations.
• Involved in documentation of the entire project.
• Quick reports generated for the users and data analysis on Test Beds on numerous occasions.
• Co-ordinate with development for future changes in the file or table structures to accommodate future testing requirements.
• Managed a combination of project, technical and managerial skills with proven abilities in solving complex problems, while exceeding performance expectations.
• Also cooperated and communicated among architects and business groups to achieve common business goals.
• Designed/Developed OIR application in Re-engineering Project.
• Worked on Scheduler tools like Autosys, Op Console etc.
• Validated & generated the reports for RTAM source skinny file.
• Supported web sphere, web logic services, JBoss Application Server, Apache web server.
• Good Hands on experience with credit data repository and NUC, QAS data mart.
• Worked on Conduct Plan IT, PDL’s.

Environment: Abinitio GDE 3.0, Co>Operating System 3.0, UNIX, TSO Mainframe, COBOL, Autosys,Op console, SQL and Windows 2003, Windows 2008 server platforms.

Confidential, NC

Sr Ab Initio Developer

Responsibilities:

• Participated in all phases of the System Development Life Cycle (SDLC), including working closely with the business analysts and software development teams to ensure a clear understanding of the ETL requirements.
• Worked closely with customers to gather requirements for the Charger Project and was responsible for creating the source requirement specification
• Technical design document and mapping document.
• Responsible for design and developing Ab initio graphs based on the given business rules and mapping documents.
• Had utilized various MFS techniques to achieve different types of parallelism
• Data parallelism and Pipeline parallelism features were used in graphs to enable faster processing and lesser ETL response time.
• Had deployed graphs on to test & staging environments and scheduled batch-jobs.
• Used Ab initio components like Reformat, Join, Redefine Format, Sort, Rollup, Run SQL, Read XML, and Filter by Expression.
• Worked closely with DA's and DBAs reviewing the data models and DDLs for the new Teradata tables. Also created Teradata tables in User space for any testing purpose.
• Worked with various types of data file system like XML, XLS, and CSV files load them to the Teradata tables.
• Worked on EME, to check in and check out the existing graphs, modify them and the check in back with changes saved. Also used the EME to save the project related documents.
• Developed unit test cases for the developed Ab initio graphs and done unit and system level testing.
• Experience in using UNIX shell scripting (K-shell) to customize the Ab initio graphs with start and end scripts. Also used to schedule the jobs.

Environment: Ab Initio Co-Op 3.0, Ab Initio GDE 3.0, EME, UNIX, Teradata, Oracle, Autosys scheduler, Clear case.

Confidential, FL

Ab Initio Developer

Responsibilities:

• Worked to support daily/monthly cycle execution from data prospects.
• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing, and Data Validation.
• Involved in all the stages of SDLC during the projects.
• Analyzed, designed and tested the new system for performance, efficiency and maintainability using ETL tool AB INITIO
• Responsible for requirement gathering and development of Expiration Date Fictionalization project.
• Responsible for analysis and development for data synchronization.
• Co-ordinate with different testing groups to accommodate their testing data requirements and translate them to data selection criteria in Ab-Initio format.
• Batch processing for data downsizing.
• Document ways to automate manual processes.
• Maintaining sandbox by storing all the work in a sequential order.
• Developed UNIX shell scripts for the purpose of parsing and processing data files. Maintained and did trouble shooting for batch processes for overnight operations.
• Involved in documentation of the entire project. Mentored other team members.
• Quick reports generated for the users and data analysis on Test Beds on numerous occasions.
• Co-ordinate with development for future changes in the file or table structures to accommodate future testing requirements.
• Managed a combination of project, technical and managerial skills with proven abilities in solving complex problems, while exceeding performance expectations.
• Also cooperated and communicated among architects and business groups to achieve common business goals.
• Worked on Conduct Plan IT & PDL’s.

Environment: AbinitioGDE 1.15.9/3.0.3 , Co>Operating System 2.15/3.0,UNIX, Sybase IQ 15.1, Oracle 15.4.

Confidential, TX

Sr Ab Initio Developer

Responsibilities:

• Involved in both MDM (Master Data Management) synchronous and Asynchronous interfaces.
• Created master Specs in EME for RICEFW s on different subject areas (customers, locations, items, pricing, promotions and Authorization
• Extensively worked on Abinitio - ACE (Application Configuration Environment)
• Validation, transformation, filtering and XREF rules are done in ACE.
• Worked on different interfaces involving Mainframes (COBOL copy books), XML (XSD), Web Services, SAP (Idocs) under different subject areas.
• Involved in developing RPC-to-RPC template and Configured RPC-to-RPC templates by creating PSET files
• Involved in migration on code between different environments by generating save files from manifest files integrated from Master specs generated from ACE.
• Created implementation plan documents, design documents for all the master specs developed for R7 release at different instances.
• Hands on experience working on XML, DML, XSD, WSDL’S, IDOCS
• Worked with different teams across the Project to get the clarification on Business requirements if needed as part of the data migration from legacy to SAP.
• Gathered requirements, created FMD (Field mapping document), Solution Integration Design Documents and mapped the data transformations in ACE
• Involved in different stages of developing the code which includes developing, perform code walk-through, unit testing and supported regression, Assembly and system testing and migration.
• Created UNIX shell scripts for FTP, merge and send success/failure mails and to automate stop/start of information servers.
• Created and used UNIX Wrapper scripts, in the pre/post session Ab Initio process to create/drop index and collect statistics of the warehouse tables.
• Supported and involved in comprehensive end-to-end testing
• Extensively used Ab Initio built in string, math, and date functions.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Worked on JAVA, JMS Queues, and J2EE application services.
• Supported JBoss Application server and Apache Web Server.
• Good Hands on experience with Business Rule Engine (BRE).

Environment: Ab Initio, GDE 3.0.2, ACE,BRE, SAP BRM, EJB, CIS, LMS, CRS, ECC, Oracle 11g, XML, AIX UNIX, Solaris and Windows 2003 and Windows 2008.

Confidential

Abinitio Developer

Responsibilities:

• Developed and implemented processes that apply business rules to the customer and revenue data.
• Worked with different Sources such as Oracle, SQL Server, Excel and Flat files.
• The data that was obtained from various sources were fed into the staging area in Teradata.
• Enterprise wide templates were created for handling SCD, Error handling etc.
• Sometimes to prepare Design document gathering requirements from the clients.
• Worked in resolving production issues to correct the code or data or to enhance the performance.
• Customized Multi load scripts in Teradata to load data into Teradata tables as part of the Ab Initio post session task.
• Extensively used Ab Initio built in string, math, and date functions.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Generated DML files, XFR files specifies the Record format, which are used in components for building graphs in Ab Initio.
• Used Enterprise Meta Environment (EME) for version control.
• Designed and developed complex Aggregate, Join, Look up and Update strategy transformation based on the business rules.
• Created Dynamic lookup transformation to increase the session performance.
• Responsible for migrating the folders or mappings and sessions from development to production environment.
• Involved in resolving the loops, cardinalities, contexts and check the integrity of the universes
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality
• Created UNIX shell script to automate the stop/start the information servers.
• Created and used UNIX shell script in the pre/post session Ab Initio process to create/drop index and collect statistics of the warehouse tables.
• Created UNIX shell scripts for FTP, merge and send success/failure mails
• Created different types of reports, such as Master/Detail, Cross Tab and Chart.
• Used various Teradata Index techniques to improve the query performance
• Responsible for loading data into warehouse from different sources using Multiload and Fast load to load millions of records.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.

Environment: Ab Initio, Oracle 8i, SQL Server 2000, Teradata V2R4, BTEQ, Tpump, Fast Load, MultiLoad.

Confidential

SQL, PL/SQL Developer

Responsibilities:

• Designed and developed the applications using pro*c, Oracle, PL/SQL with UNIX as the OS Preparation of program specification, designing major screens of the project
• Developing the core module, testing, implementation and providing post implementation support Studied existing systems and modified the existing systems to improve performance
• Extensively used SQL*Loader to load data into Oracle database from external files.
• Written and modified existing PL/SQL procedures, functions, packages and triggers Tuned application by tuning SQL statements and fixing proper indexes
• Written UNIX Shell scripts for processing of data and handling large volume of data.

Environment: Oracle 8i, SQL, PL/SQL, SQL*Loader and UNIX.