SUMMARY

• Over 14 years of IT experience in Software Development, Design and Implemention with a major focus in Datawarehousing, Business Intelligence and Database applications.
• 11 years and four months of Experience in Design and Development of Data warehouse & Business intelligence solutions using ETL tool Ab Initio.
• In - depth onshore and offshore Ab Initio technical leadership experience.
• Over 8 years of experience in Data warehousing with large database environments.
• Well versed with all the Parallelism Features of Ab Initio 3.2.7.2 including Data parallelism, Pipeline parallelism and Component parallelism.
• Extensive experience in ETL Process to Extract, Transform and Load process for ODS and DSS Database instance using Ab Initio.
• Extensive experience in Data validations, Data profiling, Data cleansing based upon the business requirements.
• Extensive experience with Teradata 13.0, Oracle (10.2) Coded well-tuned SQL, PL-SQL
• Extensive coding experience with SQL, PL/SQL, SQL *Loader, Unix Shell Script (ksh).
• Designed and deployed well-tuned Ab Initio graphs for ODS and DSS instance in both windows and Unix environments.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 3.2,7.2 Co-op 3.2.5.7, DQE, ACE, BRE, Conduct-IT, Operational Console 3.1.4, 3.1.5), Informatica 6.2/5.1, Datastage 7.x/ 8

Data Modeling: Erwin 3.5.2/4.0

Databases: Oracle 10g/9i/8i/8/7.x, MS Access, SQL server 2000, DB2, Sybase 12/11.2/10, Teradata V2R6.2, 13.0

Languages: C, C++,SQL, PL/SQL, Visual Basic 6.0/5.0, Developer 2000,Designer 2000, COBOL, Cobol/400,CL/400, RPG/400

Scripting Languages: Korn Shell Script

Web Technologies: Java 1.6.0,HTML

Batch Process Schedulers: CA-7, Crontab, Autosys, Control-M, $Universe

Operating System: Windows 95/98/2000/XP/7, UNIX (HP-UX 10.20, Sun Solaris 5.10, AIX 6.1.0,0), Linux 2.6.32

Hardware: IBM PC Compatibles, HP-UX, Solaris, AS/400

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Ab Initio Technical Lead

Responsibilities:

• Performed as a Ab Initio Technical Lead responsible for core development and team leadership in Confidential
• Coached, mentored and lead onshore and offshore Ab Initio resources with in a technical team environment
• Extensively co-ordinated with Business Analysts and data modelers for gathering of requirements & timelines and preparing the technical design documents in terms of SDLC methodlogy.
• Parllely worked as a team member for development of Ab Initio batch graphs, proc scripts and JIL scripts
• Developed various batch graphs using Ab Initio ETL process to extract the data from Teradata database and IBM Mainframe data sets.
• Extensively co-ordinated with offshore & onshore team menbers for assigning the tasks requirements and explained about the requirements.
• Extensively involved to raise access request for installation of GDE and establish the connections for various Linux & database servers.
• Extensively involved in meetings with project manager and team members for discuss of project artifacts and timelines
• Extensively worked on preparation of tech spec’s for project tasks as part of Ops Risk & Monitory process and reviewed by Business Analyst, Data Moduler & Metadata reviwer
• Developed Ab Initio batch graphs are in Conduct it > Plan with Ab Initio components like Conditional Task, Graph Task,Plan Task, Subplan,ProgramTask,Reformat,Multi-reformat, Rollup, Input file, output file,Input Table,Output Table,Run SQL,Normalize, partition-by-roundrobin, partition by expression, Broadcast, Interleave,Gather,Partition-by-key,Filter-by-expression, Sort, Dedup-sort,Lookup file,Sftp-from, Sftp-to,Fuse,Join,Run Program,Redefine Format,Handle Errors,Handle Logs,,
• As a team lead responsible for Ab Initio code review’s for the development work and guided to change the code as to meet the business scenarios for the projects.
• Parallely worked for other projects like SAR Lane migration, ITA-Universal Workstation Data Acquisition,Digital Account Opening Card Issuance and Purchase Return Auth Message.
• Responsible for creation of Ab Initio tags and created build workflow for migration of code through anthill pro
• Responsible for Ab Initio code migration from Dev environment to DEV, SIT, UAT & PROD environments through IBM Urban Code deployment tool
• Extensively coordinated with DBA for getting the stored process for load worktables, exchange the data between tables in Teradata for all projects.
• Extensively written a proc wrapper scripts for running the jobs like CT, AB, TF, EX & CV blocks for various levels of process for schedule the scripts in autosys Job schedule.
• Extensively written JIL scripts for (CMD) command level jobs & (FW) file watcher jobs for autosys jobs scheduler.
• Responsibility for create a work orders for Ab Initio code migration, Database packages and creation of global variables for Configuration manager.
• Extensively worked on preparation of test cases, production documents like Implementation plan, CAT Sign-off documents, PSO Sign-off documents
• As a team lead responsible for creation of CR’s for migration of code from UAT to PROD as part of releases and co-ordinated with releases teams for the code releases on time.

Environment: Ab Initio GDE 3.2.7.2, Co>Operating System 3.2.5.7, Teradata, Oracle 11g, Linux 2.6.32, SQL Assistance, Autosys, Crontab, Windows 10 Professional, Excel, Ms Word.

Confidential, Atlanta, GA

Ab Initio Technical Lead

Responsibilities:

• Served as a Ab Initio Technical Lead responsible for core development and team leadership in Confidential Bank
• Coached, mentored and lead onshore and offshore Ab Initio resources with in a technical team environment
• Extensively co-ordinated with Business Analysts for gathering of requirements & timelines and preparing the technical design documents in terms of SDLC methodlogy.
• Parllely worked as a Ab Initio team lead for other enhanced projects called CCA Enhancements project
• Extensively created POC’s for the design level of Ab Initio graphs and scenarios with explinations.
• Developed various batch graphs using Ab Initio is an ETL Process to extract the data from CAV,EIR,CHA & MRDM data sources for both projects.
• Extensively co-ordinated with offshore & onshore teams to raise a access requests and setup the GDE, Co-op, EME and database connections from various servers.
• Extensively co-ordinated with offshore & onshore teams for assigning the tasks requirements with guidelines of work to start
• Conducted the onsite meetings with onshore & offshore teams for daily status of the development and discussion of approaches, timelines & issues for ongoing development
• All batch Ab Initio graphs are in Conduct it > Plan with Ab Initio components like Conditional Task, Graph Task,Plan Task, Subplan,ProgramTask,Reformat,Multi-reformat, Rollup, Input file, output file,Input Table,Output Table,Run SQL,Normalize, partition-by-roundrobin, partition by expression, Broadcast, Interleave,Gather,Partition-by-key,Filter-by-expression, Sort, Dedup-sort,Lookup file,Sftp-from, Sftp-to,Fuse,Join,Run Program,Redefine Format,Handle Errors,Handle Logs,,
• All batch Ab Initio graphs has fully parameterized by creating a psets for running of jobs with various intervals of times with parallel by using the 14 way multifile system and serial wise.
• As a team lead responsible for Ab Initio code review’s for the development work and guided to change the code as to meet the business scenarios for the projects.
• Responsible for creation of work order’s to Ab Initio Infra team for migration of Ab Initio tags from DEV to QA environments.
• Written complex sql’s for creation of views in DB2
• Extensively prepared the Release notes & Instructions documents for DBA about the database packages and check-in the documents in harvest tool.
• Written a wrapper scripts for scheduling the jobs in CA-7 scheduler and co-ordinated with CA-7 team for Jobs schedule in CA-7 Scheduler for all migrations.
• Responsibility for create a work orders for Database packages for Configuration manager for install the packages in QA.
• Co-ordinated with offshore & onsite teams for preparation of test cases, TDD documents, CA-7 documents, production documents like Impl plan, ETL Single Ticket form, ALM Defect reports, CAT Sign-off documents, PSO Sign-off documents
• As a team lead responsible for creation of RFC’s for migration of code from QA to PROD as part of Monthly & Alternate releases and co-ordinated with releases teams for the code releases on time.

Environment: Ab Initio GDE 3.2.6, Co>Operating System 3.2.5.7, Oracle 11g, DB2, Teradata, Linux 2.6.32, Toad 3.5, CA-7, Crontab, AutoSys, Windows 7 Professional, Excel, Ms Word.