SUMMARY:

• 17 years of experience in Software Design & Development.
• 8 years on ETL Architecture, Design & Development.
• Experienced on Leading team of more than 10 resources in an onsite/offshore model.
• Experienced on Ab Initio, IBM Datastage and Trained on Informatica.
• Experienced on Data Analysis, Data Profiling, Data Quality Tools.
• Experienced on Datawarehousing and Data Migration Projects, Billing Systems, GIS.
• Interpersonal and Team leading Skills.

TECHNICAL SKILLS:

Architectures: ETL, DW, OSS, Client/Server

Business Systems: Banking, Marketing Research Information, Insurance, Billing Applications, Quadrant Risk Management Model, Telecom Applications

Databases: Oracle, DB2, HP Neoview, Netezza

Hardware: HP, Mainframe, Intel Processors

Languages: C, Shell Scripts, SQL, PL/SQL

Methodologies: Object Oriented Design, Structured Design, Dimension Modeling, ETL Design

Operating Systems: IBM AIX 5.3, Unix(SCO/SUN/HP), Red Hat Linux, MVS, WINDOWS 98/NT/2000/XP

ETL Tools: Ab Initio, IBM Datastage 8.1, Informatica Powercenter (Trained)

PROFESSIONAL EXPERIENCE:

Confidential

Team Lead /Principal ETL Engineer/Project Manager.

Responsibilities:

• Project Management for BI Delivery Organization
• Architect for ETL Processes
• Lead for Design and Development for the ETL Process for Loading the ODS
• Co - ordinate Deployments and Data Loads to Test, QA and Production
• Project Planning Tasks
• Performance Measurement for ODS Load process
• Co-ordinate with Offshore team for completing development and testing tasks
• Lead Design and Code Reviews with Onshore and Offshore Teams
• Owner for Preparing HLD,LLD and Data Model Documents
• Performance Tuning for ETL Jobs
• Creating Process Flow, Job Flow Documents for TIBCO

Technologies Used: IBM Datastage 8.1, SQL, Netezza, Oracle 10g, TIBCO, ERWin, UNIX, SVN

Confidential

Technology Consultant

Responsibilities:

• Analyze the requirements for the new Data Warehouse ETL Development
• Prepare Technical Design Documents
• Prepare Project Plan with Timelines for Delivery
• Create Technical Approach/Functional Approach document preparation task for ETL Architecture sections
• Conduct Technical Specification Review sessions
• Responsible for the High Level and Low level Design for Ab Initio ETL Jobs for implementing complex business rules for various pricing methods for the Regulatory Reporting Data Warehouse
• Design Reusable code in Ab Initio /Datastage
• Execute Performance Test and periodically compile the performance report for decision making for ETL design activities
• Co-ordinate with offshore development team for Development Tasks, Code reviews and code promotion
• ETL Analysis, Design and Development activities for Datastage Jobs

Technologies Used: Ab Initio 2.16.1, IBM Datastage ( 8.1 and 7.5), SQL, Sybase, Oracle, Unix, Kornshell, Autosys, ERWin, IBM AIX 5.3, Tivoli scheduler, Harvest Code Promotion Tool, DBVisualizer, DB2,Quadrant Risk Management Model, Clearcase & Clearquest

Confidential

Ab Initio Consultant

Responsibilities:

• Develop Ab Initio graphs to support the MIS Re-architecture Programme
• Design and Develop Ab Initio graphs and Korn Shell Scripts to support the Archiving and Mop-up
• Working with Senior Design Authority to resolve design issues
• Implement and Test Design changes as required.
• Making use of EME for version control and Code Migration
• Perform Unit Tests and End-to-End Testing

Technologies Used: Ab Initio, HI Quality Product Suite, Unix, Korn Shell

Confidential

Responsibilities:

• Preparation of Data Transformation Project Plan, Validation and Transformation
• Specifications
• Pre-processing of extracted source data for transformation using Ab Initio
• Data Analysis for Data Migration using Discovery Avellino
• Mapping of the Logical and Physical Network Data to the Target Network Model (Cramer)
• Developing Ab Initio Graphs with Parallelism
• Preparing presentations about various Network Equipment Models
• Preparing Technical Specification for incorporating API calls and Constraint checks done by the Cramer data Load Tool within the Data Transformation

Technologies Used: Ab Initio, Cramer, Oracle, SQL, Discovery Avellino, Unix, Shell Scripts

Confidential

Senior Technical Associate

Responsibilities:

• Designing and Developing the new Customer bill format in Amdocs FBF
• Technical Support for resolving issues related to BT's Telephone Bill Format
• Developing code for Normalization of Call Details for Inter Operator Tariff Check(
• IOT-Check) for MACH( Multinational Automated Clearing House)
• Writing programs to populate the global data structures used by the Rating Engine in Pro* C.
• Designing software for creation of TAP files using Call Data Records (CDR) from a MobileSwitches.
• Centralizing GE-Smallworld's GIS application PRM on the Sun Solaris Server( E10K) for
• British Telecom
• Administration of the PRM Intranet Database and Webserver
• Designing Multilingual support for Willet's Common Ink Jet Printers
• System Level Programming for developing new features

Technologies Used: Unix, Amdocs FBF, IBM MVS, Connect:Direct, GIS GE-Smallworld, Sun Solaris, Shell Scripts, C, C++, Oracle, Pro C, Linux

Confidential

R&D Engineer

Responsibilities:

• Interfacing the Operator Console with the Switching Software of the EPABX
• Designing and developing Call Handling features
• Upgrading the PC based Operator Console.
• Testing the Hardware Signals and Software Interrupts using Aztec Emulator
• Troubleshooting the switching software for EPABX system.
• Developing a GUI in C++

Technologies Used: C, C++, Unix, Emulator, Windows