SUMMARY

• 7 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 andTelecom 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 (K-Shell) 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.
• Hands on experience with IBM Optima.
• 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 experiencein 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 IncidentManagementworking through critical incidents. Manning command center and conducting Incident resolution bridge calls.
• Supported Operational databases and legacy data ware house.
• Hands on experience with Meta Data Hub.
• Hands on experience with Control M.
• Have good hands on experience with IBM ISAS Solution, DB2,SQL Server.
• Highly adaptive to a team environment and proven ability to work in a fast paced teaming environment with excellent communication skills.

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, DC

Sr Ab Initio Developer

Responsibilities:

• Analyzed the systems, met with users and business units in order to refine the requirements.
• Translated requirements into system solutions and developed implementation plan and schedule.
• Defined and documented the technical specification designs of all programming applications.
• Ensured that proper development processes and standards are followed, conducted code reviews.
• Implemented Data cleansing and created DML for the XML files to be used in Ab-Initio.
• Used various Programs, conditional components and transform functions, sub graphs, most components like datasets, filter, join, and sort, Partition etc and used lookups.
• Responsible for developing data extracts and transformation programs.
• Extensively used Ab-Initio GDE editor - Record Format editor, Key Specifier Editor, Transform Editor, Expression Editor, and Package editor.
• Extensively used Unix shell scripting, general file manipulations, ftp etc
• Took care of Performance Tuning and loading tasks.
• Created functions, procedures, packages, triggers in PL/SQL, utilized bulk load, bulk collect, dynamic SQL. Used SQL*Loader to load data from flat files. Designed small application schemas in Oracle.
• Created and configured Ab-Initio scripts and wrapper scripts as Autosys jobs. Reviewed the status of the jobs running.
• Participated in various stages of SDLC meetings on behalf of ETL, to facilitate refined definition of specs and requirements, and suggested correction spec docs etc, which many times facilitated in fruition of projects I handled.

Environment: Ab-Initio GDE 3.0, Ab-Initio Co>Operating System 3.0, Oracle 10g, SQL,PL/SQL, Oracle, AutoSys, UNIX AIX, UNIX Korn Shell.

Confidential, Woonsocket RI

Sr ETL Developer

Responsibilities:

• Communicated with business team and gathered requirements.
• Incorporated identified factors into Ab initio mappings to build Data Mart.
• Used Alphabet masking for first name, last name and Alpha numeric masking for address fields and Digit masking for phone numbers etc.
• Good Hands on experience with Ab Initio GDE, EME and Co>op etc.
• Good hands on experience with Fast load, multi load and Tpump utilities etc.
• Data extraction and data Transfer Teradata Database using utilities / tools like fast load and multi load.
• Created a parameter file for each application and incorporated database connection info inside it.
• Prepared Technical Documents related to design, development and testing as per Data Masking Project.
• Captured source/target data into an excel file and compared target data with source data to verify masking rule.
• Worked extensively on Data Migration.
• Good Hands on experience with Oracle Database.
• Hands on experience with Informatica Identity Resolution.
• Good Hands on experience with expectation logic, Error Handling and Change management process.

Environment: Ab initio GDE, EME, Co>op, Oracle11g, Teradata, SQL, PL/SQL,UNIX Shell Scripts.

Confidential, Union, 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.
• Good Hands on experience with Teradata.
• Hands on experience with UNIX commands.
• Files were loaded into Teradata database using Fast Load and Multi Load.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Generated DB configuration files for source and target tables.
• 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.
• 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.
• Good hands on experience with Data Mining, Data Base Structures and data cleaning etc.

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

Confidential, Columbus OH

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.
• Good Hands on experience with Exadata Developer.
• 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.
• Good Hands on experience with credit data repository and NUC, QAS data mart.
• Worked on Conduct Plan IT, PDL’s.
• Hands on experience with Data Mining, Data Cleaning, Database Structures.

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

Confidential, Charlotte 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, Tampa, FL

Sr 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, Plano, TX

Ab Initio Developer

Responsibilities:

• Involved in both MDM (Master Data Management) synchronous and Asynchronous interfaces.
• Created master Specs in EME for RICEFW 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.
• Good Hands on experience with Business Rule Engine (BRE).
• Good Hands on experience with SSIS

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,SSIS.