SUMMARY

• Twelve years of professional experience in Software Design, Development and Maintenance including ten years of experience in Data warehouse applications .
• Involved in client meetings to discuss about teh business requirements, document and translate them to technical documents,
• Involved in database modeling and work wif dba team in teh database design.
• Designing ETL process for data cleansing, transformation and loading to database tables.
• Managing a team of four developers.
• Come up wif teh test cases for teh new builds and do teh unit testing.
• Involved in client UAT and get client sign off.
• Loading teh initial huge volume of data and automating teh ongoing loads in teh automation tool, control M and on call support for teh clients.
• Worked on large data warehouse in production environments.
• Other responsibilities includes, traveling to client locations and involved in their business review presentations.
• Mentoring junior developers and support analysts.
• Technical presentations to clients, sharing change request ideas and documentation
• Integrate teh client change requests wif existing product implementation.
• Estimating teh project cost and come up wif project deliverable dates.
• Work wif internal QA team and resolve issue
• Support teh ongoing client projects

TECHNICAL SKILLS

RDBMS: SQL Server, Oracle,

ETL Tool: Ab Initio 1.11.13,

Modeling tool : E/R Studio,

Automation : Control M,

Operating Environments: Windows NT, UNIX and Linux,

Internet Technology: Java 1.2, Servlets, JDBC, Java Script, JSP, EJB, HTML, XML,

Web Server: Apache web server, Web logic Server,

PROFESSIONAL EXPERIENCE

Tech Lead,

Confidential,

Responsibilities:

• Discover, Design, develop, test, deploy and maintain Data Marts using Oracle, Ab Initio, Shell scripts, PL/SQL procedures and Control - M job scheduler.
• Implement logical and physical database design, dimensional modeling and star schemas.
• Implement conversion process using Ab Initio to extract data from various sources and integrate into a single source using match key
• Managing a team of four developers.
• Implement ETL standards for Ab Initio graphs and environment,
• Implement name and address parsing, geocoding, and data standardization,
• Create graphs to perform NCOA, ADQ and telephone reverse append process,
• Implement matching using name, address, telephone number and email address,
• Implement customer data management (CDM) and transaction matching.
• Implement custom matching rules and use demographic data from internal data vendors.
• Performance tuning Oracle database by monitoring index usage and analyze queries run by analytical, reporting and campaign users using explain plan,
• Populate summary/aggregation tables for Cognos reports to run faster,
• Develop UAT test cases and perform unit and regression testing on initial builds to migrate projects from development to production,
• Implement change requests based on teh new business requirements and re-design an existing data model and graphs,
• Automate, running and monitoring of a weekly/daily update processes and send email messages and reports after successful completion of ODS and Mart updates,

Confidential, NY,

Responsibilities:

• Prepared teh business rules and developed source and target definitions for teh Request Sample application from teh low level design document.
• Developed graphs using Ab initio for ETL processing of Request Sample and Scoring process applications.
• Deployed teh graphs successfully and teh corresponding shell scripts are run by passing proper arguments dat is input and output sources.
• MSR process pulled teh data from various sources like RDBMS tables (Oracle), EBCDIC files (main frame) and ASCII files, first cleaned teh data tan transformed them, as per teh requirements defined by teh business rules.
• After transformation teh end data is loaded into ASCII files or to teh tables. In this application, most of teh end data goes to teh DATA MART.
• Multiple file components are used for writing to teh files as well as for reading from input files. Input and Output table components are used for loading and unloading data from tables
• Teh business rules are validated in each graph.
• Preparation of Test Plan Document and written unit test cases matching requirement specification.
• Teh Unit testing is done for both application.
• Written various shell scripts for automated testing.

Confidential, United States,

Responsibilities:

• Developed Design Documents using Rational Rose,
• Developed Test Plans,
• Involved in Coding, writing PL/SQL procedures, functions and packages for teh application as well creating stored procedures in putting business logic in teh back end.
• Involved in Testing, Used Rational Robot testing tool for testing,
• Deployed on different environments, NT, UNIX, and Linux and tested,
• Written Shell scripts for Environment set up, while deploying in Unix and Linux.
• Written various Shell scripts for other validations also.
• Involved offsite development and onsite implementation

Virtual Insurance Model,

Confidential, Japan,

Responsibilities:

• Project Lead, leading a team of 5 members,
• Gone through all PL/SQL programs and converted into equivalent Java programs, wifout changing teh functionality,
• Coding and testing,

Outsourcing Management System,

Confidential,Japan,

Responsibilities:

• Developed Architectural Design Document,
• Developed Detailed Design Document,
• Developed Unit Test Plans,
• Developed System Test Plan,
• Involved in front end Coding and also in writing PL/SQL programs and stored procedures in teh back end,
• Involved in testing of teh system,
• Software Configuration Management coordinator,
• Was leading a team of five members,

Project Administration System,

DSQ,

Responsibilities:

• Developed Design Documents,
• Developed Unit Test Plans,
• Developed System Test Plan,
• Involved in Coding, writing PL/SQL programs at SQL server and were called in front end,
• Involved in testing of teh system,

TTL,

Confidential, Japan

Responsibilities:

• Involved in design, coding and testing
• Involved in developing software in PRO*C under UNIX operating system wif ORACLE as Back End from teh Pseudo Code given by teh client.
• Responsible for finishing job in record time