SUMMARY

• Over 8 years of professional experience in IT Industry involving in various phases of Software development including system analysis, design, development, testing, implementation and production support
• More than five years of experience in all the phases of the Datawarehouse life cycle involving Design, Development, Analysis and testing in the various areas of Datawarehousing, ETL working with Ab - Initio.
• Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on UNIX environment, Proficient with various AbInitio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
• Worked in Defects & Enhancement team, involved in Design, Development, Testing and Production Support for Various applications.
• Extensive hands on experience on Oracle Stored procedures. Worked on database tools such as TOAD and SQL Loader.
• Excellent analytical, oral, written, communication, and trouble shooting skills
• Has flair to adapt to new software applications and products, self-starter, has good communication and understanding of business workflow.
• Effective team player with excellent problem solving abilities, a willing and quick learner with strong technical and communication skills.

TECHNICAL SKILLS

ETL Tools: AbInitio GDE 1.13, 1.14, 1.15, 3.1.4 Co-Operating system 2.13, 2.14, 2.15, Abinitio

Databases: Oracle 10g/9i/8i, SQL Server 7.0, DB2, and MS-Access.

Data modeling: Erwin 4.1 and Visio.

Operating Systems: Sun Solaris, HP-UX, UNIX, and Windows 9X/2000/NT/XP.

Languages: C, C++, COBOL, JAVA.

Web Design Tools: HTML, DHTML, XML, JAVA SCRIPT, VB SCRIPT, JSP and Apache

Server’s: Java Web server, Web Logic, Web Sphere.

SQL Interfaces: TOAD, SQLPLUS and Teradata SQL Assistance

Job Schedulers: Autosys, control - M, CA-7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Abinitio Tech Lead

Responsibilities:

• Worked as the onshore Tech Lead developer on SDP2 project.
• Involved in analysis of DIME 1 and DIME2 projects before starting migration.
• Implemented plans and psets as per DIME3 standards for old version code in DIME1/DIME2.
• Involved in refactoring the graphs by implementing resource pool changes and by using variousperformancetechniques.
• ImplementedMulti-File Systemto store the data in multiple files in multiple storage locations to improve the performance
• Enhancements tothe existing DMLs by adding new fields
• Involved in Data Validation, Data Conversion and Data Reconciliation TestingusingSQL's
• Designed and developedUNIX shell scriptsas part of the ETL process and wrote wrapper scripts.
• Involved in code review, QA turnover and bug fixes.
• Implementing the production, production parallel runs and cutover of lower DIME’s.

Environment: AbInitio GDE 3.1.4.1, AbInitio co>operating system 2.15, DB2, Toad, shell scripts (K-Shell), Oracle 10g,CA-7.

Confidential, Billerica MA

Sr Abinitio Developer

Responsibilities:

• Designed data flows for staging and distribution process to load customer and account related information in Operational Data store.
• Customer load process goes thru a trillium process which identifies the Customer and loads it onto Database.
• Trillium Custom components are used in the Abinitio graph to parse these records
• We support the system end to end. Complete Production support is taken care.
• Implemented ETL staging (Serial and multi) and loading applications using Abinitio.
• Scheduling of the jobs is done with the help of Control M. Created many Control M Jobs to meet the requirements
• Accommodated Error Handling of rejected data by making provision for capturing and analyzing the message and data separately.
• Loaded operational data into Staging Tables, warehouse tables using Abinitio GDE and responsible for automating the ETL process through scheduling.
• Analyzed the data flow and run statistics from Web EME.
• Created wrapper scripts to execute the graphs. Incorporated features for restart ability and rollback in case of a failure.
• Involved in unit testing, System Testing and UAT for the Abinitio applications.
• Drafted detailed design document, coded and tested Data flows.
• Implemented Rollouts for Production Releases.

Environment: AbInitio GDE 1.15, AbInitio co>operating system 2.15, PL/SQL, Toad, shell scripts (K-Shell), Oracle 10g

Confidential, Memphis TN

Abinitio developer

Responsibilities:

• Involved in building AbInitio graphs using Graphical Development Environment
• Designed, developed and unit tested AbInitio graphs for Extraction, Transformation and Loading of data from source to target
• Migrated the data from Teradata EDW environment to Oracle
• Worked on AbInitio multifile system and used partition components for better performance and when dealing with large volumes of data.
• Used AbInitio Components like Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, dedup, runsql etc
• Involved in creating the Generic graph for pulling the Data from the Teradata edw tables and load into oracle tables
• Modified the AbInitio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times
• Converted all SAS scripts to UNIX shell scripts
• Developed UNIX shell scripts and scheduled the jobs using
• Worked on creating PL/SQL queries to obtain data from the database for AbInitio graphs
• Designed, developed and deployed necessary stored procedures, Functions in Oracle using TOAD and in Teradata using teradata sql assistant
• Involved in unit testing, integration testing and creating test case document

Environment: AbInitio GDE 1.15, AbInitio co>operating system 2.15, PL/SQL, Toad, shell scripts (K-Shell), Oracle 10g, Teradata Sql assistant

Confidential, Charlotte, NC

AbInitio Developer

Responsibilities:

• Involved in development of AbInitio graphs for loading and extracting data from various schemas relating to Oracle databases.
• Involved in creating sandbox in ab-inito through GDE and as well running the shell script.
• Involved in developing complex graphs based on the business requirement and writing wrapper scripts for the deployed scripts of those graphs.
• Monitor the daily/weekly/monthly jobs.
• Responsible for creating a 12 way multi file system that is composed of individual files on that are partitioned and stored in distributed directories
• Code migration from development to QA, QA to production environment using change man procedures.
• Writing the UNIX scripts, awk programming to deploy the AbInitio graphs thru wrapper scripts.
• Fixing the Performance issues for the AbInitio graphs
• Review the test results and get UAT sign off before promoting the code to production environment.
• Setup all ETL jobs thru OPC scheduler.

Environment: AbInitio (GDE 1.12.1, Co>Op System 2.15.8), Oracle 9i, UNIX, OPC scheduler.

Confidential, Seattle, WA

AbInitio Developer / Offshore Co-ordinate

Responsibilities:

• Involved in creating Macro and Micro Level design documents.
• Involved in design reviews of All ETL Modules for Business Planning project.
• Involved in Design and Development reviews and provided Tuning Techniques on AbInitio Graphs
• Involved in creating the documents like Operation Instructions Document, Load Approach Process for Abinitio Application Support.
• Used Reformat, Partition by key, Sort and Join Components extensively in AbInitio graphs.
• Implemented MFS file system that is composed of individual files on different nodes that are partitioned and stored in distributed directories.
• Loading the Data by Using the AbInitio tool. Used 4 ways, 8 way parallelism for processing the AbInitio components.
• Involved in Scheduling, Creating and running the Jobs with Autosys.
• Build shell scripts to clean up the files and other functions.
• Wrote procedures, triggers etc to enhance the performance by using PL/SQL.
• Worked extensively in UNIX environment by accessing the files, changing permissions to them and building scripts.
• Involved in writing the Unit Test Cases for the applications.
• Created Various Best Practices Documents for Development and Support Activities.
• Closely Interacted with SIT Team to perform various data validation, system test, Stress test or regression test process.

Environment: AbInitio GDE 1.13, AbInitio co>operating system 2.13, PL/SQL, SQL*Plus, Sun Solaris 8 UNIX, shell scripts (K-Shell), Oracle 9.2.

Confidential, Chicago, IL

J2EE Developer

Responsibilities:

• Developed the web application using Struts Framework.
• Developed entire application based on STRUTS framework and configured struts - config.xml, web.xml
• Implemented validation framework for creation of validation.xml and used validation-rules.xml.
• Developed Classes in Eclipse for Java, using the Class Specification provided in Rational Rose.
• Developed Java code for the Swing user interface down through calling of stored procedures
• Designed, developed and deployed necessary stored procedures, Functions, views in Oracle using TOAD.
• Developed Session Fa ade with Stateless Session Beans for coarse-grained functionality.
• Developed Stateless Session beans, and Entity beans.
• Actively involved in deploying and performance tuning the application on web logic 8.1 Application servers.
• Developed test scripts for Integration testing, User case testing.
• Developed JUnit test cases for EJB services.

Environment: Java 1.5, J2EE, Struts, Swing, UML/Rational Rose 2000, Web services (SOAP, WSDL, UDDI)Web Logic, Eclipse, JSP, JMS, XML, XSL, Ant, JNDI, EJB, Servlets, Oracle 8.1, Toad.