Career Summary And Achievements

• Over nine Years of IT Experience leading strategic initiatives using 'lean-agile scrum', 'managed services' and 'onshore-offshore' development models, mentoring junior staff, planning, testing, stakeholder communication, issues resolution and documentation following SDLC 2.0.3 standards. Eight years of demonstrated experience implementing large scale ETL data warehouse applications in complex batch processing environment using AB Initio, Oracle, PL/SQL,Unix, Shell Scripting, Erwin as an AB INITIO ETL/Data Warehouse Developer and BI Application Analyst in Fortune 100 CMM Level-5 companies.
• Extensive experience in MULTI TERRABYTE Data Warehouse Environment implementing all phases of Project Life Cycle: requirements gathering, system analysis, design, development, testing and 24 7 on call production support.Industry proven analytical and logical skills analyzing and transforming mission critical business requirements into technical system implementation.Devised Collaborative SDLC Strategy improving Time-To-Market of project by 20 .Devised effective testing and integration strategies resulting in substantial savings in testing and fixing efforts.Recipient of Hot Performance

Technical Skills

• ETL TOOLS / TECHNOLOGIES
• Ab Initio v3.x , PL/SQL, Shell Scripting
• DATABASE TECHNOLOGIES
• Oracle, Query optimization
• DATABASE MODELING
• E-R Diagram ,Data Flow Diagram DFD .
• LANGUAGES
• Basic Knowledge of Java, Visual Basic 6.0
• OBJECT TECHNOLOGIES /TOOLS
• UML Use Case, Class and Sequence Diagram , Together Soft, Rational Rose.
• COMPONENT TECHNOLOGIES
• Interface And Component Specification, Interaction Diagram.
• VERSION CONTROL
• Rational Clear Case
• SCHEDULER
• AutoSys,Control-M
• OTHER APPLICATIONS
• PL/SQL developer, SQL Plus, TOAD
• OPERATING SYSTEMS
• Windows,Unix, Knowledge of Mac

Work Experience

Confidential

Sr. Application Dev Leader

• Leading the VISA Inc's multi-year strategic AB - INITIO ETL / Data Warehousing and Business Intelligence initiatives which will transform and combine VISA Inc's global data wealth to form Enterprise Business Intelligence repository which to Executive Management position VISA Inc better in the market.
• Leading and executing these projects using 'lean-agile scrum model' resulting in significant savings.

1.Enterprise Data Warehouse

2.Visa Data Manager

3.Portfolio optimization

• Advising on

1.Business Intelligence Process Management / Improvement.

2.Data Ware House / ETL performance optimization and tuning.

Confidential

Ab Initio ETL Developer/Designer

• Lead all phases of the System Development Life Cycle SDLC : Requirements gathering/analysis and collaborating with the business analysts, development teams and other stake holders to translate business/functional requirements into Technical Specification.
• Transformed Technical Specification into Ab Initio ETL jobs/graphs by developing good insight of the business.
• Designed and developed highly complex and reusable customized Ab Initio ETL applications.
• Participated and lead design, test and codes reviews to provide input on coding standard and performance goals.
• Extensive involvement in system integration, enhancement, modification and performance tuning the Data warehouse ETL applications.
• Provided 24x7 production /Integration/User Acceptance/Performance tests Support.
• Defined SDLC 2.0 documentation standards and created Technical design documents
• Defined project scope, approach and tasks prioritization.

Confidential

• AU Data WH is ongoing integration and upgrade project.The AU Data Warehousing is a 8 TERRABYTE Application and large collection of near real time ETL processes, ODS, Data Marts and a Data Ware House.
• Designed, developed and modified near real time batch Ab Initio ETL systems to process more than 500 million records store loan data in the ODS where it undergoes complex business transformation and loaded into AU Data Warehouse and Data Marts for further analytics and reporting.

Confidential

• IR2 Project Housing Affordability and Modification Program is designed to reduce mortgage payments for troubled homeowners and eventually stabilizing the housing market.
• Played a Lead role in System Test - Devised execution and subsequent validation strategy for System Test.
• Developed complex Ab Initio / ETL based utilities to modify and create hundreds of test files on the fly resulting better accuracy and reduction in testing efforts.

Confidential

• The Servicer and Investors Reporting S/IR ,a Class-one 7 Terabytes application implemented in Ab Initio employs new tools and technologies to replace legacy servicing platform and has transformed the way Fannie Mae does its core business of securitization. It is very high visibility application which has direct impact on external institutional customers and Wall Street.
• Played a key role in design and development critical Ab initio ETL modules to process several hundred million loan records of Servicer and Investors Reporting S/IR application and optimized the Ab initio application modules to meet stringent performance requirements.
• Created complex test data sets to test the application modules.
• Developed custom UNIX shell scripts and configuration scripts for handling the data and running Ab Initio jobs within it.

Confidential

• Securities Accounting Restatement Project was mission critical project to change past accounting methodologies and reflect correct historical earning. in multi TB Data WH applications.
• Designed Ab Initio / ETL Versioning Framework and ETL processes to handle 5 Terra Byte accounting corrections data for the Restatement Financial Data Warehouse RFDW , which stages the settled securities data in related fact, dimension and audit tables for downstream consumption by reporting/analytics applications.

Confidential

PL/SQL - ETL Developer Analyst.

• Implementation Of Disputes management ETL Processes
• Disputes Management Project consists of business critical modules such as disputes resolution, and reporting based on Customer Data collection and Integration.
• Participated in decomposition of the larger data warehousing ETL system into separate ETL modules for data extraction, transformation according to business rules and loading to Data warehouse.
• Developed the ETL solution by taking Reporting Facilitation perspective Implementation Of Near Real Time Business Intelligence Balance Transfer and Credit Decisioning System.
• Developed model automation logic for credit decisioning which successfully reduced the risk of defaulter collection accounts by approx 43 using PL/SQL and shell scripting.
• Developed automation/summarization shell/sql scripts for customer solicitation, balance transfer, payment data collection for hourly/daily/weekly summary, based on which BI reports for senior management are generated.
• Created a knowledge based central repository from business and technical perspective for credit pre-decisioning for customer solicitation and further system enhancement.

Confidential

Data Warehouse ETL Automation Developer-Analyst

• WebTrends Analytics Data Warehouse Automation and Enhancement.Data Warehouse Automation. Creating ETL Processes, automation scripts, stored procedures and packages using PL/SQL and shell scripting to import large volume of data from various sources and load consistently in data warehouse ,data marts and Web-Trends OLAP System.
• 24 7 on call critical production support for Webtrends warehouse systems. Troubleshooting and getting the system online. Creating and modifying scripts to minimize similar failure.

Confidential

Data Modeling, Analysis And Database Design And Implementation Oracle 9i,SQL Loader, Erwin, PL/SQL :

• Designed and implemented healthcare system database using ER.
• Defined and implemented rules for data formats, data integrity and data redundancy management. Custom Made Windows Media Player VB 6.0, ODBC,MS Access
• Developed fully functional windows media player in VB using OLE Drag Drop controls.DBMS Architecture and Implementation of Shift Scheduling Payroll System: ErWin,Oracle,Unix,Shell scripting
• Designed and implemented logical and physical data model.
• Database implementation and administration. Schema implementation, storage allocation, user creation and access security and backup and recovery. Generic Common Component Design, Development and Testing Java, UML, OOAD, Together J
• Designed generic billing system which can be switched into entirely different systems to schedule appointments and generate bills using abstract Factory pattern . Conducted system analysis, use-case identification, class and sequence diagramming, implementation and testing.

Confidential

IT-Business System Analyst

• Conducted analysis of problem domain, requirements gathering. UML diagramming, system workflow design.
• Tracking low level implementation details such as programming, component interactions.
• System integration, Unit, Integration and Regression testing.