EXPERIENCE SUMMARY

• Involved in client UAT and get client sign off.
• Come up with the test cases for the new builds and do the unit testing.
• Managing a team of four developers.
• Designing ETL process for data cleansing, transformation and loading to database tables.
• Involved in database modeling and work with dba team in the database design.
• Involved in client meetings to discuss about the business requirements, document and translate them to technical documents
• Twelve years of professional experience in Software Design, Development and Maintenance including ten years of experience in Data warehouse applications.
• Loading the initial huge volume of data and automating the ongoing loads in the automation tool, control M and on call support for the 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 the client change requests with existing product implementation.
• Estimating the project cost and come up with project deliverable dates.
• Work with internal QA team and resolve issue
• Support the 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

Work Experience

Confidential

Job Title Tech Lead

Environment: Linux, Oracle 10G, Trillium, Ab Initio, Shell script, BMC Control-M Scheduler, PL/SQL Developer.

Role:

• 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 the 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

Marketing System Replacement

Role

• Prepared the business rules and developed source and target definitions for the Request Sample application from the low level design document.
• Developed graphs using Ab initio for ETL processing of Request Sample and Scoring process applications.
• Deployed the graphs successfully and the corresponding shell scripts are run by passing proper arguments that is input and output sources.
• MSR process pulled the data from various sources like RDBMS tables Oracle , EBCDIC files main frame and ASCII files, first cleaned the data then transformed them, as per the requirements defined by the business rules.
• After transformation the end data is loaded into ASCII files or to the tables. In this application, most of the end data goes to the DATA MART.
• Multiple file components are used for writing to the files as well as for reading from input files. Input and Output table components are used for loading and unloading data from tables

• The business rules are validated in each graph.
• Preparation of Test Plan Document and written unit test cases matching requirement specification.
• The Unit testing is done for both application.
• Written various shell scripts for automated testing.

Confidential

Software Used : Java1.2.2, Apache Webserver, Jakarta-Tomcat, JSP,

Role

• Developed Design Documents using Rational Rose
• Developed Test Plans
• Involved in Coding, writing PL/SQL procedures, functions and packages for the application as well creating stored procedures in putting business logic in the 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

Confidential

Software Used : Java Servlets, JDBC, Java Script, HTML, IIS, Oracle 8.05, Jrun

Role

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

Confidential

Management System

Software Used : Visual Basic 5.0, Oracle 7.3

Role

• 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 the back end.
• Involved in testing of the system
• Software Configuration Management coordinator
• Was leading a team of five members

Confidential

Project Administration System

Software Used : Visual Basic 5.0, SQL Server 6.5

Role

• 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 the system

Confidential

Software Used : PRO C under UNIX operating system

Role

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