SUMMARY:

• Around 5 years of total IT experience in the Requirements Analysis, Data Analysis, Application Development, Implementations and Testing of Data warehousing business systems.
• Solid experience in developing Ab Initio applications for Extraction, Transformation, and Loading into Data Warehouse/Data mart. Used Ab - Initio with Very Large Database Systems (VLDB) that are Massively Parallel (MPP) by utilizing the concepts of Multifils, Partitioning and DE partitioning components and fine tune the applications for optimal performance.
• Strong skills in Oracle are PL/SQL programming and in Performance Tuning of SQL.
• Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs in Ab Initio.
• Well versed with Abinitio parallelism techniques and worked on Ab Initio Graphs using Data parallelism and Multifile System (MFS) techniques.
• Developed Abinitio graphs to fetch data from DB2, Sybase, Oracle, Teradata, Netezza, Excel, Flat Files, XML files and Mainframe. Extensive experience in Business Application Software Development using Abinitio products such as GDE (1.15), Co-Operating system (2.15), Component Library and EME.
• Good experience in various Abinitio components such as Reformat, redefine format, join, Rollup, Scan, Join with DB, Update Table, Partition by Expression/Key/Round Robin, look up file/template, Read/Write Separated Values, Batch Subscribe, Publish, Publish to Plan, Gather Logs, Handle Logs/Error, etc.
• Well versed with Ab initio parallelism techniques and worked on Ab Initio Graphs using Data parallelism and Multifile System(MFS) techniques.
• Well versed with various Abinitio Co Op's, Micrographs, parallelism techniques and implemented Abinitio Graphs using Data, Component, pipeline parallelism and Multi File System (MFS) techniques.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Ab Initio development experience with Data mapping, Transformation and Loading from source to target databases in complex, high volume environments.
• Strong in writing SQL queries and reporting the results to business team.
• Knowledge on Continuous flows and Business Rules Engine (BRE).
• Well versed with the DML manipulation and creating complex conditions
• Experienced with the generation of the UTF8 record formats.
• Worked extensively on PDL and DML Meta programming.
• Pleasant experience in using Microsoft products like MS Visio, Word, Excel etc.
• Worked in onshore and offshore model. Handled big teams in onshore.
• Handled multiple projects working in a team as well as working independently.
• Strong knowledge in Data Management, Data Quality.
• Experience working Oracle SQL and PL/SQL.
• Experience using various Ab Initio component like Transform, Datasets, Sort, Partition, De-partition, FTP and other miscellaneous component groups. Involved in Unit testing of Ab Initio code in pre-production environment.
• Worked on Ab Initio graphs for various Data warehouse and Data Mart ETL processes.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Responsible for Debugging and Troubleshooting Ab initio graphs.
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension surrogate key generation.
• Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem-solving skills.
• Has excellent communication skills, comfortable in fast paced challenging environments.

TECHNICAL SKILLS:

ETL Tools:: Abinitio GDE 1.1x, 3.0x, CO>OP 2.1x,3.0, Metadata Hub, Data profiler, Informatica, Erwin 4.1/3.7, Microsoft Visio 2007.

Tools: Maestro, Auto Sys, Tivoli Work Load Scheduler

OS: Windows 95/98/NT/ME/00/XP, UNIX, MS-DOS, Sun Solaris 5.8, Linux 8x.

Databases: Oracle 11i,10g,9i/8i/8/7.x, MS SQL Server 2008/2005/2000, Teradata v2r6.1, MS Access, IBM DB2.

Languages: C, C++, Java, XML, UNIX Shell Scripting, Visual Basic 6.0/5.0, SQL, PL/SQL, Transact-SQL and Perl.

OLAP/Tools: Cognos (Impromptu, Power Play), Business objects, Micro Strategy, Oracle Reports.

Web: HTML, DHTML, XML, ASP 2.0/3.

Packages: SQL* PLUS, Toad 7.x, SQL Loader, Erwin 4.0, MS Visio 2002.

Scripting: UNIX Shell (Ksh/Cash), JavaScript.

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

Ab Initio Developer

Duration:

• Design and deploy the Extract, Transform and Load process, using Ab Initio by studying the business requirements from the business users.
• Develop Complex Ab Initio XFRs to derive new fields and solve various business requirements.
• Develop Strategies for Data Analysis and Data Validation and Test case documents to send business analysts
• Work with various MIS analysts to understand requirements for BI dashboard and create ETL transformations to load snapshot and aggregate tables.
• Design and built custom plans using Conduct IT to integrate PSETs based graph executions, establish dependencies with various modules, implemented resource pools.
• Build Conduct IT plans to integrate graphs, common load process and implemented resource sharing for concurrent use of Teradata fast load utility and source database unloads.
• Built graph and plan to load target Teradata table sourced from excel sheets.
• PSET driven ETL load process invokes fast load or API utility based on volume of the feed.
• Built batch process to call MS share point web service, transform XML dataset and load hierarchy delegation dimension table.
• Designed fact and dimension tables for business requirements.
• Perform dollar-U scheduler change, scripts to trigger plan for ETL process.
• Defect support, lower environment scheduling, monitoring, job abend restart and root cause analysis.
• Prepare migration plan and production history load instructions.
• Provide guidance and quality assurance to all data masking activities, Profiles the source system data to identify potential data issues.
• Extract the data from Different Source systems by writing PL/SQL and T-SQL Stored Procedures, Indexes, Functions, Procedures, and Triggers and Cursors using Oracle and SQL Server.
• Work on and Supporting development across the Ab-initio Platform. Responsible to creating ETL framework.
• Provide UNIX shell scripts to handle the data load process in automation.

Job Tools: Ab Initio 3.3.1, GDE 3.3/3.2, Informatica, SQL, PL/SQL, Unix/Linux Shell Scripting, (Putty), Teradata, Oracle, MSSQL, Linux, Autosys.

Confidential, Houston, Texas

Ab Initio Developer

Duration:

• Worked closely with the Business Analysts and Application Leads for Requirement study, Analysis and design of the application.
• Created low level design documents for various application processes.
• Developed Ab Initio graphs that transfer data from flat files to oracle data warehouse
• Extensively worked on most commonly used components to complex components like Scan, Rollup, Assign Keys, Partition, Departition, Sort, Join, Reformat components etc.
• Used Ab Initio's Multifile systems for improving heavy data loads.
• Migration of Ab Initio Objects from development to QA environment and prepared appropriate documentation for code move to QA and production environment.
• Worked extensively in design, development, testing and deployment of Abinitio graphs.
• Developed several generic graphs for application using dynamic DML and XFR's.
• Created graphs using components like Input /Output File/Table, Reformat, Redefine Format, Dedup Sorted, Filter by expression, Partition components, Sort, Replicate, Join, Merge, Concatenate, Gather, Rollup, Run Program, Run SQL, Update Table.
• Lead an active role in the conversion of Data stage code to Abinitio Code and UNIX to Linux scripting for a Tier 2 application team.
• Developed the complicated graphs to connect to different environments from single environment for a copy process.
• Extensively worked on the set up of Initial Abinitio, setting up the common parameters, creating projects as per the company standards.
• Well versed in using various string functions, date functions.
• Worked on creating the standard process documents for different projects to share among the team.
• Handled different scenarios to read parameters from Linux script and pass to the Abinitio graph dynamically.
• Responsible for the development of various generic graphs for table to file load and vice versa.
• Handled Data stage run time column propagation to convert to Abinitio.
• Worked with multiple teams in projects in Production support and maintenance.
• Involved in importing Source tables from the respective databases, files and creating Abinitio graphs.
• Extensive knowledge in test case review, and Implementation and Post Implementation documents.
• Responsible for the Assembly and the Component Test plans and Test plan execution.
• Contributed the team during testing phase up till leading implementation for getting done various change requests, impact analysis for coding changes done.
• Developed sandbox comparison utility tool to validate the deployed code.
• Worked on creating build lives using Anthill Pro and Jenkins and deployed code to different code lanes using IBM Urban Code deploy(udeploy).
• Good working experience in using air commands for tagging, version check, listing the tag content etc.
• Extensively worked on creating project run directories and validating their existence.
• Responsible for execution of the module (deliverables, coding to standards/architecture, understand/adhere to change, fix defects, and co-ordinate release management (and other) processes.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Prepared Unit test plan, Unit test release for developed Graphs by using mapping documents.
• Modified Ab Initio Graphs according to the new modifications.
• Involved in end to end data validation by interacting with the business (UAT)

Environment: Abinitio Co >Op 3.3/3.2, GDE 3.3/3.2, Teradata v15, SQL Assistant, SQL, PL/SQL, Unix/Linux Shell Scripting, IBM Clear Quest, Autosys, Anthill, Jenkins, Udeploy 6.2.4

Confidential

Ab Initio Developer

Responsibilities:

• Implemented ETL Abintio designs and processes for the load of data from the sources to the target warehouse.
• Performed as active, leading role in enhancing overall ETL Abinitio architecture.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked with Abinitio Components, Parallelism concepts.
• BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensive worked on debugging and troubleshooting the Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.
• Involved in setting up the environment for the new version.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and creating unit test plans and preparing unit test cases.
• Interacting with system testing team and resolve the issue reported by the testing team.

Confidential

Sql Developer

Responsibilities:

• Wrote T-SQL code for creating cursor and handling the data validations.
• Involved in various stages like development, system Analysis and design.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Involved in project planning with project managers.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Created SSIS process design architecting the flow of data from various sources to target.
• Installed and maintained MS SQL Server 2000/2005.
• Created Database Objects - Tables, Views, User defined functions, Triggers, Stored Procedure and Roles.
• Created DTS packages to get data from various sources, consolidate and merge into one single source.
• Transformed the complex business logic and calculations into coding.
• Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor.
• Created levels of Data Flow Diagram using Microsoft Office Visio.
• Created and kept the Entity-relationship Diagram and Data Dictionary up-to-date after any alterations were made to the metadata and data in each table.