SUMMARY

• 11+ years of IT experience out of which 8+ years on Teradata and 4+ years on Ab Initio.
• Proven experience related to ETL development using database programming in writing Stored Procedures, Macros, Views in Teradata & using Ab Initio tools Data Load/Export utilities like FastLoad, MultiLoad, TPump, FastExport & Complex transformations and Teradata SQL Assistant.
• Developed complexAbInitiographs using variousAbInitioparallelism techniques, Multi file systems, dynamic lookups and ACE/BRE.
• Good skills in Performance Tuning of complex Ab Initio graphs and Database SQL efficient and complex queries on huge volumes of data.
• Have Experience in Leading a Team in development as well as production support.
• Extensive experience in the Data Warehousing concepts, Extract Transform Load (ETL), data quality, reporting tools, metadata management and Enterprise Data Warehouse (EDW).
• Extensively worked in monitoring Teradata jobs in UNIX environment and specializing in Autosys jobs.
• Good knowledge on Agile Methodology and the scrum process
• Involved in preparing the estimations and delivery plans for projects of varying complexity
• Involved in promotions and deployment of Ab Initio graphs in Dev., UAT and production environments.
• Worked closely with Teradata Development, Testing, Pre - Production and Production teams to align project deliverables within due dates and reporting issues.
• Involved in production support activities during on call and resolved database issues.
• Very good experience in customer facing skills and release and change management.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
• Well Experienced in Incident, Problem, Knowledge and Report Management process in Service Now Tool. Performed lead role to manage the support teams and also as Problem Manager, Knowledge and Report Manager as well as Major Incident Escalation Manager (Branch Lead) role in the support group.

TECHNICAL SKILLS

Operating Systems: Windows 8.1/7/XP/NT/2000, Unix, Linux.

Databases: Teradata 15.10.1.3/14/13.10/13/12/ V2R6.2/V2R5.1/V2R5,SQL Server 2008 R2, Oracle 8i, 9i.

Tools: Ab Initio Coop: 3.2.2/3.1.5.5/3.1.5.3/3.1.3.2/3.0.6.6 , ACE/BRE 3.0.6/3.1.2 , Teradata Tools (TPump, FastLoad, MultiLoad, FastExport, Stored Procedures, Macros and Teradata SQL Assistance), Microsoft BI SQL Server 2008, SSIS/SSAS/SSRS, SAP BI, Oracle 9i, Oracle 8i, SQL *Plus, PL/SQL, Toad 8.5

Scheduling Tools: Autosys, Crontab and UC4

SCM Tools: Microsoft VSS/TFS, EME, GitHub

Reporting Tools: Microstrategy, BusinessObjects, SSRS, Forms 6i and Reports 6i, PL/SQL Web Toolkit (PL/SQL Cartridges).

Languages: SQL, PL/SQL, C, HTML, VBScript, JavaScript

Oracle Application: Oracle Applications 11i (11.5.9) AOL & System Administration

Domain: Finance, Sales and Marketing, Supply Chain

Others: Solman, MS Outlook, Word, Excel, Power Point and Visio.

Ticketing Tools: Service Now.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Teradata Developer

Responsibilities:

• Involved as developer in requirements gathering, design and development of the user requirements.
• Performed Data analysis and prepared the physical database based on the requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Teradata utilities.
• Build the graphs to in corporate the transformation logic as per the business requirements.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in bug fixesand optimization of ETL processing.
• Involved in solving user issues
• Involved in the code reviews prepared by the teams.
• Prepared production support documents and provided training to the support teams.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: /Tools: Teradata 14/15, VB, MS Excel, Python.

Confidential, Folsom, CA

Ab Initio/Teradata Lead & Developer

Responsibilities:

• Involved as developer in requirements gathering, design and development of the user requirements.
• Created tables, views in Teradata, according to the requirements
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Ab Initio and Teradata Stored Procedures.
• Build the graphs to in corporate the transformation logic as per the business requirements.
• DevelopedAb Initiographs to fetch data from SAP OHD & Teradata.
• Involved in the development/updating of Ab Initio graphs, UNIX/JIL (Autosys) scripts.
• Extensively usedAbInitioEME data store/sandbox for version control, code promotion, and impact analysis.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in bug fixesand optimization of ETL processing.
• Involved in solving user issues
• Involved in the code reviews prepared by the teams.
• Prepared production support documents and provided training to the support teams.
• Worked efficiently with cross-functional and partner teams and also all levels of management.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: /Tools: Ab Initio 3.1.5.3/3.1.5.5 , Teradata 14, SAP-BI, SAP-BOBJ, Autosys.

Confidential, Folsom, CA.

Ab Initio/Teradata Lead & Developer / Production Support

Responsibilities:

• In this capacity I acted as lead to the production support teams in India (IT BI DWR & SupplyNet Production Services/KTBE Support team).
• Worked as Problem, Knowledge & Report Manager role in Service now tool and also act as Major Incident Escalation Manager in the support team.
• Involved in many applications maintenance out of which critical applications like Channel Management, Order Management and Supply Chain Management applications.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Ab Initio and Teradata Stored Procedures.
• Solid experience in developingAbInitioapplications for Extraction, Transformation, Cleansing and Loading into Data Warehouse.
• DevelopedAb Initiographs to fetch data from SAP OHD, Oracle, Teradata, SQL Server, Excel, flat files and XML Files.
• Involved in the development/updating of Ab Initio graphs, UNIX/JIL (Autosys) scripts.
• Extensively usedAbInitioEME data store/sandbox for version control, code promotion, and impact analysis.
• Implemented Join conditions, group by functions, correlated sub queries, nested queries.
• Responsible for performing code reviews.
• Worked efficiently with cross-functional and partner teams and also all levels of management.
• Involved in stakeholder and management meets to present the ticket metrics in the support activity.
• Created several automated non-compliance reports in Service now tool and sends data through email to the stockholders and management which will help them to correct the system.
• Reduces the user/job failure issues by providing the permanent solutions to the code and streamlining the system.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved bug fixesand optimization of ETL processing.
• Involved in solving user issues.

Environment: /Tools: Ab Initio 3.1.3.2/3.1.5.3 , Teradata 14, Microstrategy, SAP-BI, SSIS, Autosys, Service Management Tool.

Confidential

Ab Initio/Teradata Lead & Developer

Responsibilities:

• Involved as Tech Lead & developer in requirements gathering, design and development of the user stories by following the agile methodology.
• Manage a team, with day to day activities of involving active development, mentor team, also support and enhancements of the system.
• Interacted with the Client technical team to analyze the business process and gathered the requirements.
• Developed number of Ab Initio Generic Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Merge etc.,
• Developed the custom Graphs and make it as Generic
• Used 4 Way Multi Files for processing Millions of records and used MFS and serial lookup files for lookup.
• Extensively used Ab Initio as ETL to load data from .csv files into staging area and then to Data warehouse by applied business transformations in another layer.
• Created the write back solution as per user requirement through ACE.
• Configured the App Config through ACE and Worked closely with business forAbInitioGDE,ACE/BRE (Business Rules Engine) setup.
• Created load ready files and sending output files to downstream applications.
• Prepared the Validation between source and target and enrichment app configuration in ACE
• Created Unix scripts to file validation and sent automatic email for any rejects occurred while sending files to partner systems
• Involved bug fixesand optimization of ETL processing.
• Extensively usedAbInitioEME data store/sandbox for version control, code promotion, and impact analysis.
• Involved in solving user issues
• Involved in the code reviews prepared by the teams.
• Prepared production support documents and provided training to the support teams.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: /Tools: Ab Initio 3.0.6.6/3.1.3.2 , ACE/BRE 3.0.6/3.1.2 , Teradata 13, Autosys, Solman.

Confidential, Folsom, CA

Lead & Developer

Responsibilities:

• Involved as Tech Lead & developer in requirements gathering, design and development by following the agile methodology.
• Interacted with the Client technical team to analyze the business process and gathered the requirements.
• Created tables, views in SQL Server, according to the requirements
• Responsible for developing SSIS packages, SSAS cube and SSRS reports and support & maintenance of the entire application.

Environment: /Tools: Microsoft BI SQL Server 2008, SSIS/SSAS/SSRS, Autosys.

Confidential, Hillsboro, OR

Ab Initio/Teradata Developer / Production Support

Responsibilities:

• Involved in understanding the business and data needs and analyzed the data sources, developed solutions by creating new stored procedure to load data in fact and dimensional table for reporting or providing data files to the downstream applications to meet business requirements.
• Worked as 24/7 on call Production Support for CFR/SMCOST/NGCR EDW (Close Forecast and Reporting/ System Manufacturing Cost/ Next Generation Capital Reporting) team for ETL Process design and development in Teradata.
• Involved in designing Parallel PartitionAb InitioGraph for a high volume data on data warehouse.
• DevelopedAb Initiographs to process .dat files from SAP-BI and load data into Teradata database tables.
• Resolve major Performance Issues in production by tuning the stored procedures, by changing the loading job dependences or run times to balance the Teradata system to meet SLA.
• Performed root cause analysis on the report queries for the customer to solve the Data missing/wrong data issues to backtrack and find out where the data is missing/wrong.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes.
• Involved in the code reviews prepared by the teams.
• Analyzing production support documents and finding the feasible time to run their jobs.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: /Tools: Teradata 13, Microstrategy, SAP-BI, Ab Initio, Autosys, Solman.

Confidential, New Brunswick, NJ

Associate Technical Consultant

Responsibilities:

• (PL/SQL) Stored Procedures, Self Service Applications, and Developing PL/SQL Web Applications using PL/SQL Web Toolkit (PL/SQL Cartridges) in Oracle Applications 11i.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
• Implemented quick fix and suggested a Permanent fix to the other Teams as per the Business need.
• Implemented Data fix on database as per the User Request for the Business.
• Involved in peer to peer reviews.
• Involved in System Maintenance /Database upgrade/ patch Upgrades - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
• Used TOAD for database designing and business process flow.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• UsedODBCto connect to the target Oracle database.
• Used Java Script functions to data validation of the fields in the forms at the front end which are not allowed at the Oracle database and format validation fields like email id, Zip code etc.

Environment: /Tools: Oracle Application 11i (11.5.9), Oracle 9i, PL/SQL, PL/SQL Web Toolkit (PL/SQL Cartridges), and Java Script, PL/SQL Self Service Application and AOL.

Confidential

Oracle Developer

Responsibilities:

• (PL/SQL-Coding) Writing Triggers, Packages, developed custom Forms, Reports and / Web Reports on Oracle Applications 11i.
• Involved in Testing and validation of data before the code moves to QA.
• Testing the code in the staging area before it moves to Production.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures
• Used composite data types like %ROWTYPE and %TYPE
• Extensively used Cursors and Ref Cursors in order to generate various reports.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, nested queries, views for the business application development.
• Used TOAD for database designing and business process flow.
• Written database triggers for automatic insertion of tables on different schema
• Developed screens and reports using Oracle Forms/Reports 6i.

Environment: /Tools: Oracle 9i / Forms 6i / Reports 6i, PL/SQL and Oracle Application 11i.