SUMMARY

• Around 8 years of professional Software/IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing Projects.
• 6+ years of experience in Ab Initio, DWH and Oracle.
• Hands on experience in Ab Initio tool and Oracle database and Loading in a complex, high - volume environment. Having extensive programming skills in Ab Initio ETL tool.
• Excellent understanding of teh System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Along wif developing batch graphs, have worked on advanced concepts like Continuous flows and optimization. Also implemented concepts like Component Folding and Dynamic script generation which has brought extreme delight to client
• Worked wif Conduct>IT and plans, EME and BRE.
• Coded and well-versed wif UNIX shell scripting. Coded well-tuned Oracle and UNIX Shell (ksh, csh) scripts for OLTP warehouse instance.
• Thorough understanding of Data Warehouse Schemas.
• Thorough understanding of teh issues involved in development and integration of a software product.
• Have worked on XML processing wif Ab Initio.
• Worked on HP Quality Center to track SIT bugs in development project.
• Worked in Agile methodology and successfully completed 5 iterations/phases.
• Experience in adherence to ITIL best practices and to align wif teh needs of business.
• Provided 24x7 Production support for daily, weekly and monthly incremental and complete refresh warehouse environment using Maestro and Autosys as teh scheduler.
• Experience in requirement analysis, client interaction, system design, development testing, security, documentation and implementation wif extensive coding standards and state of teh art technology.
• Well acquainted wif analytical and nice Communication Skills, Ability to work independently and good team player.
• Experience in designing, developing and testing large scaled applications as per functional requirements using Ab-Initio, UNIX, Unix Shell scripting and PL/SQL.
• Good exposure to SQL, PL/SQL stored procedures, Views, Triggers and Packages.
• Experience wif Ab Initio Co>Operating System, application tuning and debugging strategies Proficient wif various AB INITIO Parallelism and Multi File System technique
• Expert in coding SQL, PL/SQL stored procedures, Triggers and Packages.
• Provided teh 24x7 support for production and testing daily, monthly and weekly data refresh and worked wif fixing complex/critical production problem.
• Knowledge of Version Control tool Clear Case and defect tracking tools like Clarify and Clear Quest.
• Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server, SQL*Loader, Teradata SQL Assistant.

TECHNICAL SKILLS

Primary Skill category: DW - ETL, Oracle SQL, Unix shell scripting.

Secondary Skill category 1: DW - Abinitio

Secondary Skill category 2: UNIX, SQL, C/C++, MS Office Tools

Secondary Skill category 3: ITIL Framework (Problem, Change and incident Mgt)

Project Acquired skills: XML, HP Quality Center, Maestro, Agile Methodology, Production Support

Tools: CITRIX, SQL Developer, SSH Tectia client, HP SiteScope

Primary Domain Skill: Banking

Sub Domain: Commercial banking

Trained Skills: Data Warehouse schemas and Business Intelligence, OLTP systems, Data Stage, HP SiteScope, Oracle SQL, Agile Methodology, ITIL Framework

PROFESSIONAL EXPERIENCE

Confidential - Baltimore, MD

Senior Ab Initio Developer

Responsibilities:

• Worked on advanced concepts like Continuous flows and developed many important services teh project using Ab Initio as a tool, and did many optimizations in existing graphs.
• Implemented concepts like Component Folding and Dynamic script generation.
• Worked Conduct>IT and plans and converted an important control script to plan.
• Developed few UNIX wrapper korn shell scripts.
• Promotion of project from Development to SIT and UAT to Production.
• Involved in Load testing in different environments and System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Coordinating wif different teams like User Interface (UI), Data Analyst (DA) and Load Testing team by arranging meeting and discussions.

Environment: Ab Initio GDE 3.0.2, Co > Operating System 3.0.1, AIX UNIX 5.2, Oracle 10g/9i, Autosys

Confidential

Responsibilities:

• Coordinating wif business clients and onsite teams to gather teh requirement.
• Worked on development of Ab Initio batch graphs and giving proper phasing to teh graphs based on teh requirements.
• Enhancement of teh already developed graphs and fine tuning teh efficiency by making vectors through rollup components and making a single record in place of a group of records.
• Query Optimization and working towards increasing teh efficiency by fine tuning teh SQL queries.
• Developing new wrapper korn shell scripts and fixing bugs in old scripts, if any.
• Promotion of project from Development to SIT and UAT to Production.
• Involved in Load testing in different environments and System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Coordinating wif different teams like Data Analyst (DA) and Load Testing team by arranging meeting and discussions

Environment: Ab Initio GDE 3.0, Co > Operating System 3.0.1 AIX UNIX 5.2, Oracle 10g/9i, Maestro 8.

Confidential

Responsibilities:

• Leading a small team to accomplish teh task.
• Determining and designing teh flow of teh data coming from different sources.
• Implementing teh design in graphs and testing teh graph in all environments.
• Developing teh control script in UNIX shell script.
• Maintaining Coordination wif my team and reporting team.

Environment: Ab Initio GDE 1.16, Co > Operating System 2.16, AIX UNIX 5.2, Oracle 10g/9i, Maestro 8.

Confidential

Ab Initio Developer

Responsibilities:

• Design and development of ETL process using Ab Initio as teh tool.
• Developed new processes in Ab Initio for teh project to improve performance by replacing teh Trigger Logic of Southwest Airlines co. wif new graphs.
• Involved in installations and supporting new environments, upgrading versions, Data Profiler, Co> Op, ODBC setups, EME Desktop Portals, EME Management Portals and web interface.
• Created Ab Initio graphs to build business rules to extract data from Oracle, Mainframe, and Flat File and validate, transform and load data to Oracle DB or Flat File.
• Created graphs for reconciliation procedures wif teh source system before calling teh web service call and uploading data to Sales Force.
• Created graphs using Read/write xml, XML split, read separated, read tagged, leading records, buffer, http components to load data through web service
• Define & build teh data transmission mechanism for receiving and sending data into/from teh Repository.
• Establish process to consolidate data received from different external systems into teh repository.
• Data verification and validation processes.
• Ensure proper financial review and reconciliation procedures are in place prior to sending teh target record to teh STAR repository.
• Automation and scheduling of UNIX shell scripts and Ab Initio sessions and batches using Autosys.
• Designed and created Database objects: Indexes, Views, Procedures, Packages and Triggers.
• Had participated in software development projects to develop logical and physical data models and to capture application specific ETL metadata and workflows.
• Possess a solid understanding of parallel processing methodologies, scalable architecture, appropriate use of Multi - File Systems, Ab Initio environment administration and performance efficiency techniques.
• Designed, created and maintained all Interfaces schedulers Using Autosys.
• Created Ab Initio graphs to build business logic to extract data from different external systems, validate, transform and load data to Oracle.
• Performance tuning for Data warehouse and Data warehouse operations Involved in Ab Initio Graph Design and Performance tuning to Load graph process.
• Implemented a multi-file system dat is composed of individual files on different nodes dat are
• Partitioned and stored in distributed directories.
• Used Ab Initio BRE (Business Rule Engine) for teh design and development and also to evaluate and execute teh system test plans.
• Performance and Tuning and Recovery issues wif Oracle Database.
• Design and development for process scheduling using Autosys and Conduct It.
• Unit testing and updating currently implemented graphs, logic, and scripts.
• Developed UNIX shell scripts for executing teh graphs/jobs.
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Involved in data migration from Oracle to Teradata
• Designed and developed graphs wif web service components
• Worked wif providing teh 24x7 supports on production, development and testing environments.
• Effective team player and excellent team leading capabilities, strong in decision making, working through challenges.

Environment: UNIX, Windows XP, Ab Initio GDE1.x, Co>Operating System 2.x, Ab Initio 1.x, Co>OP 2.xOracle, Teradata.

Confidential

Oracle Developer

Responsibilities:

• Analysed, designed, modelled, and implemented new database schemas
• Monitoring Fragmentation, Row Chaining and High water marks.
• Writing SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.
• Using oracle 8i/9i analytical function to optimize teh large OLAP Queries used for generating Reports.
• Scripted in PL/SQL and SQL to migrate and manage databases
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Good knowledge on joins, which are inner join, Left outer join and Hash join, Semi join.
• Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it wif creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Implemented various UNIX scripts to generate teh data in CSV format.
• Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.
• Involved in teh support, maintenance and development of critical systems.
• Responsible for database design and development and Application Tuning.
• Producing and updating relevant documentation.

Environment: Oracle 10g, SQL Plus, PL/SQL and Windows XP, TOAD, UNIX, HTML, Windows XP, Oracle SQL Developer, Putty, MS Access