SUMMARY OF EXPERIENCE

• Certified Oracle/ Ab Initio Architect with 13+Yrs experience in Oracle, Ab Initio in UNIX and NT environments. Energetic self - starter with excellent analytical and organizational skills. Strong leader and communication with ability to work as a team player or independent player and ability to interact with clients.
• Over 10+ years of solid experience with Ab Initio, Data Warehouse /Data mart Design, Development, OLAP Analysis, Performance and tuning.
• Very strong experience in writing SQL scripts, PL/SQL Database Procedures, Functions, Packages, Indexes and Database Triggers, SQL * Loader and Unix shell scripts
• Very strong experience in using Ab Initio for implementing complicated transforms, processing files, and sourcing data from multiple databases/flat files to Oracle.
• Worked in full SDLC (software development life cycle) for Oracle, databases involving Data modeling, Capacity Planning and Database Administration using OEM & ControlCenter.
• Expert level Data Architect with extensive database system analysis, design, implementation and Project Management experience Specialist in Data Analysis, Data Modeling, Database Design and Data Migration.
• Work with Enterprise DBA’s and Data Modeler to accomplish Design of the Enterprise Data Warehouse Model.
• Tuned Ab Initio graph using max core, phasing, multi file systems and lookup file component.
• Handled complex data formats, which included Vector type of record format coming as a source and Maps using Ab Initio Normalize and later on Denormalize component.
• Strong analytical and conceptual skills in database design and development using Oracle, Sybase, MS Access & SQL Server
• Work with business teams and obtain relevant business logic to efficiently translate business requirement into code.
• Extensive experience in UNIX (Solaris) & Windows Operating systems.
• Availability off work hours to meet project deliverables / deadlines
• Extensively involved in troubleshooting Production Critical issues.
• Provided User training and 24/7Production support.
• Strong ability to understand the business requirements and technology perspective to enable

TECHNICAL SKILLS

Databases: Oracle 7.x/8.x/9i/10g, Sybase 12.0, Teradatal, 13/2.x, SQL Server 7.0, DB2 7.1,Sybase, Ingres, and MS-Access.

ETL Tools: Ab Initio EME Release 2.10/ 2.13/2.14 GDE Release 1.10/ 1.13/1.14 & DataStage, WarehouseBuilder2.1, Hummingbird (Genio4.x)Informatica4.6, DTS (Data transformation Server).

Languages: C, PL/SQL, SQL * Plus, Pro *C, Java, C/C++, SQL, FORTRAN,UNIX shell script, SQL Loader control scripts, SQL *Loader

Data Modeling Tools: Erwin 3.5/3.5.2, Data Architect, DataStage, Designer 2000, ICL

Oracle Products: Oracle 9i/10g, OID (Oracle Internet Directory), Enterprise Manager,JDeveloper (1.5-2.0), SQL*Plus, SQL*Loader, Net8/Sql*Net, Server Manager and PL/SQL, Developer -2000/Forms 6i /9i Reports 6i/9i Visual Basic 6.0,Oracle Designer 9i, Designer 2000

Operating Systems: Sun Solaris 2.5/2.6/2.7 & 2.8, HP UX 10.3/11, IBM, AIX 5.1, Linux 7.0, Windows 95/98/2000/NT/XP, Sun Sparc Solaris 2.5,SunE3500, E250E10000, HP-Unix 11.0.1, Digital Unix4.0.6, AIX4.x, OS/2,OS/390, VMS 5.5,4.5

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Ab Initio ETL / Oracle Architect

Responsibilities:

• Converted all MS Access EUC REO production processes to Oracle.
• Developed Scripts to optimized and Tuned the REO production execution EUC process and Developed automated Wrapper Scripts to avoided manual workarounds.
• Designing and developing ETL Ab Initio extract transformation and load graphs to extract the data from Subledger Database and load into Impairments Database using Multi File systems.
• Modified the Ab initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Written PL/SQL Stored Procedures, Complex SQL queries, Metalized Views, Functions, Packages and Triggers to implement business rules into the application.
• Developed the PL/SQL procedures to Calculate unrealized loss IRR, Cash Flow, 9920 & FAS115 Impairment & accretion event amount and to identify to lot in position for the quarter end.
• Developed the ETL Ab Initio graphs to identify the security Impairment, accretion and cost recovery population and to perform validation.
• Created DML files & SQL Scripts to In Bound/ Out Bound Ab Initio Interface to obtain and use ADCO credit-adjusted cash flows and revisions to the holdback process.
• Interacting with the Business team to analyze the Business Requirements and efficiently translate business requirement into code..
• Performing SQL performance tuning and optimization at both Database and ETL level.
• Creating jil and Wrapper script templates for the Autosys job in scheduling the workflows and Autosys scripts.
• Developed Credit Ratings Normalization process Package as per the Credit Normalize mapping Rules BRD.
• Developed UNIX shell scripts to automate the lookup data load into the Impairment lookup tables.
• Deployed the PL/SQL packages, ETL Invoker, ETL Rules and Migration scripts from Development to integration work streams and cut the baselines thro FCS for all FAS115 releases
• Developed Ab Initio graphs for purging the data from used flat files in the process.
• Developed Data Correction Scripts (DCUs/DI) to correct the existing data in Subledger and Impairment Production Database and provided execution instruction to production team.
• Developed automate Java script to process the unit test results and send the status Email to Dev Team after validating the Impairment process.
• Developed DB analyzed script to analyze the FAS115 Tables.
• Developed data staging and loading scripts by using Ab Initio, UNIX Shell and Oracle SQL*Loader tools
• Troubleshooting the Critical Production issues during the Restatement Period and Supporting Monthly and Quarterly 11day Close Production execution.
• Developed High level, Detail Design DOC, Release Notes, Check list for the Release .
• Set up the E2E environment and implement the sandbox environment to run E2M Testing.
• Provided Complex SQL queries and PLSQL procedures to report team.

Environment: Ab initio, Oracle, Java, ClearCase, ClearQuest, HTML/XML, Solaris, MS access, Business Objects, Crystal Reports, Autosys .

Confidential, CA

Senior Oracle Programmer

Responsibilities:

• Data Extracted from DB2 and Generated flat files (Using shell scripts.)
• Created External tables and loaded the data into oracle TMS tables.
• Developed PL/SQL packages and Generated Complex Oracle Forms.
• Provided User training and Production support.
• Developed Unix shell scripts for checking Oracle errors in alert logs and trace files for every 15minutes.
• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application
• Developed the Termination Package and interface to load the data into Business Transaction reporting and Monitoring systems tables by using the advanced PL/SQL features viz., Dynamic SQL, Dynamic Cursors.
• Optimizing the SQL’s for optimum performance by using SQL Trace, TKPROF, EXPLAIN PLAN & TOAD
• Fixed various complex issues within packages, forms, reports and Performance issues.
• Designing Program specifications and Data Flow Charts for program development
• Interacting with Database Architect and Business Analyst regarding design and business requirements
• Developing PL/SQL interface programs for transferring Customer data from ELS to BLOC system
• Developing compatible Programs / codes for integrating the Bright Mail order processing functions into Symantec source system from BrightMail BLOC system.
• Developing Complex PL/SQL Procedures and Packages for data validation per business requirement.
• Developing control files for SQL *Loader, and loaded data into database tables from flat files.
• Developing Inbound interfaces using PL/SQL programs for data conversion packages for data validation and convert legacy data for Oracle Applications.
• Developing shell scripts to automate process, generate reports and logs.
• Developing outbound interfaces using PL/SQL procedures for data reconciliation between ERP .

Environment: Oracle, SQL, Ab Initio, PL/SQL, Windows NT 4.0, UNIX, SQL* Loader, ETL, Business Objects HP-UX, UNIX Solaris, Windows-2000

Confidential, Sandy, Utah

Senior Ab Initio ETL / Oracle developer

Responsibilities:

• Used Ab initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
• Replicate operational tables into staging tables, Transform and load data into warehouse tables using Ab Initio
• Developed detailed data architecture, process flow, and data model diagrams by conforming to database management policies and standards.
• Set up the ETL environment (implementing parallelism, administer the environment and developed the wrapper to run the application through the scheduling tool).
• Responsible for ground up physical and logical design of select Oracle Staging Data Warehouse.
• Developed Ab Initio graphs to read the transaction data files and then reformat, filter, aggregate the data before loading them into Oracle database.
• Developed, designed, tested and implemented Abinitio graphs for all fact tables.
• Involved in relational design, table design, and indexing strategy.
• Ab Initio’s Co>Operating System to extract, transform and integrate data from multiple data source and performed parallel data cleansing and validations using Ab Initio.
• Developed a Data Manager tools that read all the day to day transactions related data from different Account type files and apply the changes to the centralized database.
• Schedule different jobs in the AppWorx software that call UNIX Shell scripts run against the central database to change the supplied data, purging old data, etc.
• Involved in defining programming standards, database design, program development and finally testing and implementing the system
• Worked with business unit VP’s for development, acceptance and implementation of strategic and technical business unit for plastics and pins applications
• Designed and develop the Ab Initio graphs to standardize the data validation
• Developed standard process to extract the data from mainframe to the client server environment
• Developed High level and Detail Designs for the application
• Developed multiple graphs to load the application.
• Coordinated the Development and Implementation of Strategic Plans
• Involved in requirement study, analysis and design of the system.
• Involved in defining programming standards, database design, program development and finally testing and implementing the system
• Mentored other groups to understand the Ab Initio functionality.
• Developed the date conversion functions to use across the board.
• Compiled and wrote postmortem reports for internal and external parties for production issues and outages.
• Wrote scripts to automate data collections and analysis (for service and system monitoring), user performance metrics, production data integrity, change management, asset management, and software release management.
• Build some complex queries using SQL and wrote stored procedures using PL/SQL
• Involved in reporting team for developing ongoing /schedule reports based on one time or based on some application to schedule reports based quarterly, monthly or weekly.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages and triggers for the ETL processes.
• Developed PL/SQL Procedures for concurrent programs, which will run during the off peak period
• Designed and developed custom forms using Oracle forms and Oracle Tools including SQL * Loader, PL/SQL UNIX shell scripts and integrated with oracle Applications
• Involved in data conversion of Legacy Data using SQL * Loader by validating, using subprograms and Packages, the data was loaded into temporary tables
• Developed scripts for checking Oracle errors in alert logs and trace files for every 15minutes
• Provided User training and Production support.
• Generated Monthly quarterly weekly reports, interacting with business users, understanding the business process and Made timely changes and fixes to reported problems from the user community.

Environment: Oracle 9i, SQL, Ab Initio, PL/SQL, Tivoli, Windows NT 4.0, UNIX, SQL* Loader, ETL, Control-M, HP-UX, UNIX (IBM AIX) OS/2, OS/390, Windows-2000

Confidential, CA

Senior Oracle Developer

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Developed various Complex Forms and reports using Developer 6i
• Made timely changes and fixes to all the modules on reported problems from the user community.
• Involved in data conversion of Legacy Data using SQL * Loader by validating, using subprograms and Packages, the data was loaded into temporary tables, API’S were used to load data from temporary tables.
• Written and Tested C, Pro*C applications for loading inventory data into database tables.
• Designed and developed Oracle Forms 6i for user access, Oracle reports 6i to highlight the high inventory items and deployed in the web as HTML/JSP pages.
• Participated in the design, development and implementation of comprehensive inventory tracking custom application for the automotive client.
• Responsible for data validations, feeding of live data and user acceptance for each module.
• Written SQL scripts for implementation at the client's place and mentored the end users.
• Prepared checklist, final design documents and general instruction to follow during development.
• Designed and Developed various user interfaces screens and reports using Developer 6i.
• Developed shell scripts to have logical backup of important tables with suitable buffer size using export, import utility.

Environment: Oracle 9i, PL/SQL, SQL, SQL*Plus, SQL * Loader, Export /Import, Proc * C, Unix shell script, Sun Solaris /Windows

Confidential

Architect/Development Lead

Responsibilities:

• Developed numerous programs using Complex PL/SQL and many packages to do the validations as per requirements.
• Written a PL/SQL interface program that imported customers from a legacy system interface tables. SQL * Loader /UTL FILE was used to populate into temporary tables, from where PL/SQL program validated and loaded the data into open interface.
• User-friendly forms were developed using forms Daily weekly and Monthly details of the company were generated using Reports.
• Designed and Developed various user interfaces screens and reports using Developer 6i.
• Associated in developing Billing Module using Pro * C, by utilizing array processing power of Pro * C to run batch processing programs to validate, process update and insert into various intermitted tables of billing processing Module.
• Prepared design document, Checklist & test scripts for the applications.
• Provided user training in writing code that supports Functionality.
• Developed Control scripts and loaded existing data using SQL * Loader and Shell scripts
• Developed Forms /Reports using Forms 5.0/4.5 and Reports 3.0/2.5 and solved Numerous Problems Reports.
• Evolved good backup strategy using hot backup and Export/Import techniques.
• Developed stored procedure using PL/SQL to update payment info into Bills. Developed Database Triggers to enforce security.
• Developed Shell Scripts to automatically start tests, generate reports, day to day administration jobs, backups for production database and also pages to administrators if any abnormal conditions

Environment: Oracle 7.3.4/8.0.5 Developer 2000, SQL * Plus, SQL * Loader, Export, Import, Pro * C, Unix Shell Script, Sun Solaris 2.3/2.6,Unix/Sybase, Windows 95/98.