PROFESSIONAL SUMMARY:

• Brings in 8 years of experience in various roles in IT services.
• Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, and support.
• Involved in various full development cycle projects in the Data Warehousing & Data Migration areas Proficient in Business Intelligence, Data Integration & Information Management tools & technologies
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, including Abinitio and ETL package design, and RDBM systems like TERADATA, SQL Servers, Oracle, and DB2
• Experience in Ab Initio parallelism techniques and implemented Ab Initio graphs using Data parallelism and Multi File System (MFS) techniques.
• Experience in developing and deploying Ab Initio graphs, coordinating testing, trouble shooting and performance enhancement.
• Have extensive programming skills in Ab Initio, SQL, PL/SQL and UNIX shell scripting.
• Tuned AB INITIO graph using maxcore, phasing and lookup file component
• Expertise in various Ab Initio components and implementing the business logic using graphs
• Strong leader with experience training developers and advising technical groups on ETL best practices
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Team player with excellent communication and problem solving skills
• Expertise in writing Stored Procedure, Functions, Triggers, Advanced SQL queries in Oracle9i and TERADATA.
• Have used advanced features of Oracle8i like Nested table, Global temporary table, Autonomous Transaction etc.
• Tuning of database, SQL Queries & Stored Procedure, functions, Optimizer hints & Index.
• Toad, SQL Developer, SQL Assistant, BTEQ, Oracle Reports
• Worked on ABINITIO tool extensively against TERADATA, Oracle, SQL Server and DB2 (UDB) databases.
• Self - starter, motivated to learn, takes initiative and has experience working on complex projects and strict deadlines.
• Abinitio ETL Development Informatica ETL Development SQL Developer Data Modeling PL/SQL Crystal Reports Oracle Reports TERADATA Database Oracle Database SQL Server DB2 Database ER Modeling Unix Scripting Business Requirement Document (BRD) Design Document Requirement Gathering Performance Tuning AGILE RDBMS Physical Modeling Logical Modeling Source to Target mapping Stored Procedure Factions Triggers Advanced SQL queries Nested table, Global temporary table, Autonomous Transaction TOAD SQL Developer tool SQL Assistant BTEQ Data Warehousing Business Intelligence Data Migration Data Integration Information Management SDLC Gathering, Analyzing, Specifying, Validating, and Tracking requirements Production Support Conducting and Facilitating meeting High level and low level design (HLD, LLD) Status Reporting Incident Management Defect Management Test Strategy and Test Cases Management System, Performance and User Acceptance Testing (UAT) Iterative Development Tagging and Tracing Data Mapping Team Building

TECHNOLOGY PORTFOLIO:

Platforms: Abinitio, Informatica, SQL, PL/SQL, UNIX SCRIPTING

Databases: TERADATA, Oracle, SQL Server, MS Access, DB2, Data Warehouse, Informatica

Methodologies: Agile, SDLC

Tools: Toad, SQL Developer, Toad, SQL Assistant, Abinitio GDE, Crystal Reports, Oracle Reports

PROFESSIONAL EXPERIENCE:

Confidential

Senior Technical Analyst

Responsibilities:

• Designed and deployed the Extract, Transform and Load process, using Ab Initio by studying the business requirements from the business users.
• Involved in setting up of sandboxes and maintaining sandbox parameters.
• Generated DB configuration files for source and target tables.
• Most of the transformation components like the Aggregators, Denormalize, Rollup, Join and Dedup were used.
• Written complex SQL joins, Sub Queries and Correlated sub queries.
• Worked with VSAM files and generated dml’s using Abinitio utilities.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
• Used Debuggers and Watchers to test and examine the behavior of the components.
• Involved in code review and performance tuning of ETL graphs.
• Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects across the organization.
• Involved in Data profiling that helps in redesigning the database
• Change management standards were strictly followed during various phases of environment i.e. development, testing and production environments.
• 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.
• Have demonstrated the ability to transfer knowledge to junior team members and advise other developers on tuning and performance techniques and demonstrated excellent leadership skills.
• Worked with ETL framework to implement the various Ab Initio Projects provided the best practice approach to deploy and tune the ETL process.

Confidential

Technical Analyst

Responsibilities:

• Developed AbInitio Graphs with complex transformation rules through GDE.
• Developed Complex Ab Initio XFRs to derive new fields and solve various business requirements.
• Extensively used Ab Initio Components like Join, Rollup, Reformat etc as well as Partition and De partition extensively and functions like is valid, is error, is defined, sting substring, srting concat and other string functions etc.
• Used Common components in various transformation stages.
• Implemented Lookups, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Used Ab Initio functions for improving performance of Ab Initio graphs.
• Developed parameterized Ab Initio graphs for increasing the performance of the Project.
• Extensively used the Ab Initio tool’s feature of Component, Data and Pipeline parallelism.
• Developed UNIX Korn Shell scripts to run various Ab Initio generated scripts
• Extensively used TERADATA utilities (FAST LOAD, MULTI LOAD, and TPUMP) to load data into target database.
• Used JTNM for job scheduling and monitoring.
• Performed Unit testing, System testing and debugging.
• Resolved issues of various severities during testing and production phases on time.
• Testing - unit testing & integration testing
• Improve the performance of Ab Initio graphs by using various Ab Initio performance techniques
• Involved in Deep Dive Sessions and Code reviews.

Confidential

Technical Analyst

Responsibilities:

• Used AbInitio as ETL tool to extract data from source systems, cleanse, transform, and load data into databases.
• Developed AbInitio Graphs with complex transformation rules using Graphical Development Environment (GDE) to read the data files and then reformat, filter, rollup the data before loading them into Oracle database.
• Developed, designed, tested and implemented AbInitio graphs for all fact tables.
• Used AbInitio to extract, transform and integrate data from multiple data sources and performed parallel data cleansing and validations.
• Most of the transformation components like the Aggregators, denormalize, Rollup, Join and Dedup were used.
• Extracted data from multiple sources like DB2, Oracle and Flat files.
• Used Ab initio to create Summary tables using Rollup and Aggregate components.
• Worked on Multi file systems with extensive parallel processing.
• Created AbInitio multi file systems on different nodes, which can process multiple partitions of data at the same time using AbInitio Partition and Departition Components.
• Replicate operational tables into staging tables, Transform and load data into warehouse tables using AbInitio GDE and responsible for automating the ETL process through scheduling and exception-handling routines.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Performed Integrity checks on various universes to check the errors and divergences.
• Created Aliases and Contexts for resolving loops in the universe.
• Imposed joins, matching Cardinalities, Aggregate Awareness as a part of universe design.
• Provided On Call Support to the system.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Process historical data and load the data into production table and send focus related data to the extreme team in flat files

Confidential

Technical Leader

Responsibilities:

• Leads the support team and was responsible for various tasks including ticket assignment to the team members and supporting/tracking the same to closure within the prescribed SLA’s
• Responsible for transition & understanding the application at the beginning of the project, documentation, designing and providing solutions in Ab Initio, TERADATA utilities and UNIX for the enhancements or change requests and managing delivery of enhancement requests, code migration & other BAU support activities.
• Responsible for DMZ Process Management and Operations for the new Applications introduced into the line of business.
• Setting up Knowledge Transition meetings and sessions between Development and Support team to provide knowledge of the particular application to the Support Team.
• Ensuring DMZ Checklist was fulfilled before Acceptance of the application.
• Assigning resources for the KT Meetings and Sessions as well as DMZ Testing of the application.
• Thorough testing of the application in the DMZ Environment by executing the Ab Initio Batch processes.
• Setting up Stabilization Period Meetings after DMZ Environment testing concluded successfully. Determining the date of start of Stabilization Period.
• Setting up and Driving Final Acceptance Meetings to add the application under current Support Team’s inventory and support area after the Acceptance Checklist is fulfilled.

Confidential

Senior Developer

Responsibilities:

• Analyze and Understanding the new requirement
• Preparation of High Level design documents
• Preparing mapping documents
• Development of Ab Initio graphs to load data from sources involving Oracle.
• Flat-files, etc. to TERADATA database.
• Involved in Unit testing and peer to peer testing the graphs
• Scripts were run through UNIX shell programs in Control-M Scheduler
• Interaction with client on daily basis for requirement gathering and status update

Confidential

Senior Developer

Responsibilities:

• Analyze requirements from the client, translated the business details into technical design
• Develop and managed the database, used technical documents to design database tables
• Development of PLSQL schedulers for migration of Customer and Product data to MIP application
• Development of database triggers for data security, created stored procedures and functions called by J2EE front-end.
• Design and developed the reports by using Crystal Reports
• Used the functional document to design application logic and physical design using PL/SQL and Java J2EE, prepared user manual and technical support manual & version control using VSS.

Confidential

Business Analyst

Responsibilities:

• Development of Packages to be called by Form Builder Modules
• Development of database triggers for data security
• Development of Stored Procedures and Functions
• Coding using PL/SQL.
• Preparing Implementation Documentation and user support documents
• Test Program units based on test plans providing by UTC, ATC document (Just-In-Time) Technique to make Supply Chain efficient across the enterprise.

Confidential

Programmer Analyst

Responsibilities:

• Created Packages to be called by Form Builder Modules
• Created database triggers for data security.
• Created Stored Procedures and Functions.
• Coding using PL/SQL. .
• Preparing Implementation Documentation and user support documents
• Test Program units based on test plans providing by UTC, ATC documents