SUMMARY

• 9+ years of Experience in IT, having primarily worked on Banking and Retail Domain. Strong experience in implementing Banking Products for various banks across the globe. Strong experience in Data Warehouse tools like AB - Initio.
• Specialized in ETL methodology for supporting data analysis in a corporate-wide-ETL solution using Ab Initio. Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies. Acted as Senior Level Ab Initio Developer on a number of projects
• Over Five years of solid experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio
• Highly experienced in ETL tool Ab Initio in using GDE Designer. Very good working experience with all the Ab Initio components.
• Expertise and well versed with various Ab Initio Transform, Partition, De partition, Dataset and Database components. Extensively worked on Abinitio Tool using various components like rollup, join reformat and techniques like parallel processing, component folding etc.
• Working with EBCIDIC, XML, Flat Unix files processing
• Strong working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Star Schema/Snowflake Schema
• Worked on all the phases of SDLC from requirement gathering to production support.
• Very good experience with SQL Server & Oracle Databases. Worked on Databases like Oracle, SQL Server, DB2 and Teradata.
• Expert in writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts. Worked on Solaris, AIX, Unix Flavors.
• Team of 16 member Onsite team (SBI) which won the Unit level Quarterly GEM Award for “external customer Delight”.
• Winner of Oracle Query Challenge contest as part of Oracle, PL/SQL Workshop.
• Sound knowledge of Banking, Financial and Retail Domain.
• Excellent analytical & problem solving and business interaction skills; written and verbal communication skills

TECHNICAL SKILLS

ETL and Reporting Tools: Ab Initio (GDE 3.0.4/3.0.2/1.15/1.14 , Co>Operating System 3.1.1/3.0.5/2.15/2.14 )

Operating Systems: Sun OS, AIX, Linux, Microsoft Windows XP, Windows 2003, Windows 2008, Windows 7

Languages: UNIX shell scripting, C, HTML, Java Script, MS SQL Server 7.0, PL/SQL, JSP

Tools: Finacle Scripting

Middleware Tools: Ab Initio Co-Op 3.2.1.6. Ab Initio EME 3.2.1. Influx - Work flow Creation Tool

Database: Oracle, DB2 and Teradata

Database Tools: Oracle 10g, MS-Access, DbVisualizer 4.0.4, Oracle SQL Developer, Oracle TOAD 7.6.10.11

PROFESSIONAL EXPERIENCE

Confidential, Foster City, California

Senior Developer

Responsibilities:

• Developing Of Ab-initio Batch/Continuous graphs to process Interface data files.
• Tested and developed the graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool
• Generating the DML for XML data file using xml-dml utility making use of XSD document
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse.
• Queried test database results using a variety of internal tools, SQL statements, and Quest's Toad database UI product to verify back-end results
• Involved in writing test scripts and functions in Test Script Language using Conduct->It for automated testing.
• Used SQL Plus tool to write SQL commands in Oracle database
• Designing SQL queries while performing database testing
• Responsible for different Data mapping activities from Source systems to Teradata
• Queried Teradata Database and validated the data using SQL Assistant
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Resolving the Issued raised by OAT and Teat Team.
• Defined data requirements and elements used in XML transactions
• Experience in SDLC and Agile methodologies such as SCRUM
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center
• Involved in extensive DATA validation using SQL queries and back-end testing
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.
• Testing - unit testing & integration testing. Ticket Resolution using JIRA

Environment: Sun Solaris Unix, Windows XP, Ab-Initio GDE - 3.2.3., Ab Initio Co-op - 3.2.1.6, EME - 3.2.1, Jenkins, DB2 database, Control-M (for job automation)The Home DepotChennai, India 6/2010 to 10/2013

Confidential

Senior Developer

Responsibilities:

• Prepared High Level Design of Source Data Analysis, ETL Process flow, Error Handling, Re-startability and Extendibility
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts DBC files for connectivity, create Package and exports
• Helped ETL team to develop complex Ab-Initio graphs using Ab-Initio Parallelism techniques, Data Parallelism and MFS Techniques with the Conditional Components and Conditional DML for the data load from Legacy System to new Target System
• Creation of wrapper scripts. Validate the work products created by other team members
• Interaction with the Business teams and Database Administrators
• QA Support, Code Fixes, Unit testing, QA migration and support.
• Development of Ab-initio Batch graphs for the one time history load and further periodic incremental loads to move the data in Oracle Confidential tables to Teradata staging tables.
• Creation of the production support document for hand off to the support team.

Confidential

Senior Developer

Responsibilities:

• Development of Ab-initio Batch graphs for the one time history load and further periodic incremental loads to move the data in DB2 Confidential tables to Teradata staging tables.
• Improved performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups in memory joins and rollups to speed up various Ab Initio graphs.
• Extensively used the Teradata utilities like Fastload, Multiload, TPump, DDL Commands and DML Commands (SQL).
• Developed number of Ab Initio 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 Ab-Initio graphs to fetch data from DB2, Oracle, Teradata, Excel, flat files, and XML Files
• Handled and Supported Continuous flow Component.
• Developed UNIX shell scripts for Archiving, Data Loading procedures and Validation.
• Tested and tuned the Ab Initio graphs and Teradata SQL’s for better performance
• Identification of table issues between the databases.Performed unit testing and written test cases for every object.Used phases, check points to an effective and watchers and debugging mode while debugging the graphs

Confidential

Senior Developer

Responsibilities:

• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs. Work Delegation and review of the work products
• Development of Ab-Initio Batch/Continuous graphs for the one time history load and further periodic incremental loads to move the data in DB2 Confidential tables to Teradata staging tables.
• Application of complex business rules into Abinitio using components like rollup, join, reformat etc.
• Creating shell script to validate the files coming in from MAPS system.
• Performance enhancing the existing/new features of application using techniques like parallel processing and batch optimization
• Performed unit testing and written test cases for every object. Extensively used Data base components such as Run-Sql, Multi Update table, update table and join with DB
• Implemented business validation rules in staging area by using Ab initio inbuilt functions such as is valild, is null, is defined, is error,is blank etc.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, Partition-by-Round Robin to partition the data from serial file
• Worked with Departition Components like Concatenate, Gather, Interleave and Merge in order to departition and repartition data from Multifiles accordingly
• Creation of Automation jobs using HDDTM (Home Depot Dynamic Task Manager)

Confidential

Senior Developer

Responsibilities:

• Creation Abinitio graphs to read EBCDIC data and convert into ASCII.Implemented History preservative methods SCD2 and SCD3 for individual applications using Ab initio
• Performed potential transformations at the staging area, such as cleansing the data (dealing with missing elements, parsing into standard formats) combining data from multiple sources, de-duping the data and assigning surrogate keys
• Development of Ab-Initio Batch graphs for the one time history load and further periodic incremental loads to move the data in DB2 Confidential tables to Teradata staging tables.
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs. Involved in estimation activity for development efforts. Involved in Establish and/or continuously improve upon development guidelines, standards and procedures
• Developed and Troubleshooted Data load for TeraData using FAST Load, Multi Load, T Pump Techniques
• Documenting of complete Ab Initio Graphs/Worked Ab Initio Multi File System (MFS) and Multifiles to make use of Data parallelism and to achieve better performance
• Developed Data Validation Controls and Exceptions processes per business requirements to validate transformations in Ab Initio Graphs and report exceptions
• Prepared the Detailed Design Document for the all the modules required for development
• Confirm the field mapping to the new data warehouse from the old data warehouse is identified for which the one-to-many and many to one fields are properly matched and resolved
• Process and Transform delta feeds of customer data, which comes in daily

Confidential

Senior Developer

Responsibilities:

• Unit testing of Batch graphs, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates
• Migrated scripts from DEV to SIT and UAT environment to test & validate data.
• Worked with project team in optimizing and tuning of SQL statements, used phases/checkpoints.
• Extensively involved in Ab Initio Graph Design, development and Performance tuning
• Used UNIX environment variables in All the Ab Initio Graphs, which comprises of specified locations of the files to be used as source and target
• Extensively worked under the Unix Environment using Shell Scripts and Wrapper Scripts.
• Documented the source to staging and staging to Target graph level detail design
• Effectively used DB2 UDB utility like control center in data analysis and understanding the access path of commonly used queries for performance tuning
• Prepared business, detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process

Confidential

Senior Developer

Responsibilities:

• Communicating with QA team from Confidential for test file and sending back results.Created UNIX scripts to generate dmls for database files from tables DDL, DML using m db gendml utility
• Executing the Job in developement Environment, monitoring it and sending the status to DEV team if it failed.
• Test Case Execution and Adhoc testing. Performed Integration, End-to-End, system testing
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results. Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase. Developed UNIX scripts to validate the flat files and to automate the manual test cases
• Involving in Functional Testing & Regression Testing. Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes