CAREER OBJECTIVE:

• Having 8 plus years of experience in Software application development and different phases of SDLC.
• Well experienced in System/Business Analysis of ecommerce applications in Telecom domain and developing applications using DataStage, ETL and Oracle/PLSQL in Insurance, Banking domain

WORKING EXPERIENCE:

Company : Cognizant Technology Solutions,
Designation : Senior Associate
Duration : Nov 2004 to till date

Company : Kumaran Systems, Chennai
Designation : Programmer
Duration : August 2003 to Oct 2004

SKILL SET:

Operating System:

Windows 98, 2000, XP, UNIX and LINUX.

Programming Languages

Oracle – PL/SQL, SQL

Database

Oracle Database

Tools & Packages

Data Stage - ETL, Unica – Affinium Campaign Management Tool, TOAD, SQL Loader, MS Visio, VSS, Tivoli, Quality Center, PVCS

Domain Knowledge

Telecommunications, Insurance, Banking & Financial Services

Training Attended

Six Sigma , Unix Shell Scripting.

PROJECT PROFILE

PROJECT: AT&T - eCare Support Application

• Project Title

eCare Support and Maintenance

• Duration
• Feb 2010 – Till date
• Operating Systems
• Windows XP, UNIX
• Technologies used
• Oracle, Visio, ATG
• Role
• System Analyst
• Client
• Confidential,Richardson, TX

PROJECT DESCRIPTION:

AT&T is the largest communications holding company in the world by revenue. Operating globally under the AT&T brand, it is nation\'s fastest 3G network serving 78.2 million customers. This project is for maintenance of eSupport pages of AT&T website. eSupport pages are effectively used by customers when they need information or help on the product.

The eSupport includes Wireless, Internet, AT&T U-verse, Digital TV, Home Phone, Billing & Account, Additional Services, and Forums.

This project is to develop new enhancements and previously de-scoped features in order to improve customer usability and stabilize the eSupport platform in AT&T website. Migration of Mobility online support to eSupport platform on att.com/esupport.

• Increase online self-help channel share through an improved user experience.
• Enable sales and marketing components to allow intelligent up- and cross-sales through online support.
• Improve 22-state and 50-state online support customer satisfaction

ROLES AND RESPONSIBILITIES IN THE PROJECT:

As System Analyst on the eCare Support and maintenance project, I hold the following responsibilities.

• My responsibility starts from Planning, design phase of the SDLC cycle and ends till the QA phase as an SME for given application/system.
• Responsibility to prepare System Requirement Specification document used by Project stakeholders to understand functional, UI and System requirements needed to be developed
• Prepare use cases and Process flow diagrams.
• Review document with all the project stakeholders
• Interact with Business analyst and Business team to get Business requirements and clarifications.
• Imparting domain knowledge to the development team and also Testing team
• Sing point of contact where business users can call and define / discuss the current state of the project with respect to System specifications.
• Maintaining documentations of the different processes carried out with the help of Microsoft Office.

DURATION IN MONTHS:

Feb 2010 – Till date

PROJECT – Sales and Marketing Operation Data Source (SAMDB)

• Project Title

Sales And Marketing Operational Data Base (SAMDB)

• Duration
• March 01, 2009 – Feb 2010
• Operating Systems
• Windows XP, UNIX
• Technologies used
• Accentual Data Stage – ETL tool, Abinitio,
• Sql Server,Oracle – PL/SQL, SQL
• Role
• Project Lead/Senior Developer
• Client
• Confidential,Hartford, CT

PROJECT DESCRIPTION:

This is a development/ maintenance project to support various applications in Distribution & Shared Business Systems. Sales And Marketing Operational Data Base (SAMDB) is a warehouse for all the agency contact information. Currently all the contact information and the associated dimensions are stored in different platforms and different servers. Essence of this project is to have a centralized repository for various applications such as Lync, Internal Structure, and Affinium Campaign applications.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

As Onsite lead on the SAMDB – enhancement project, I hold the following responsibilities.

• Responsibility and Lead the Team in development by using Data Stage, PL/SQL
• Interact with Business customers to get the Business requirements and clarifications
• Designed the database and helped the architect / development team to understand the existing database – MODS.
• Developed ETL programs to migrate the data from various sources such as – Mainframe, TeraData to the new oracle database – SAMDB (Sales And Marketing operational Database)
• Lead the offshore team and helped them in understanding the requirements.
• Effectively Participated in Integration, Unit testing.
• Imparting domain and technical knowledge to the new entry level trainees and also fellow team members
• Maintaining documentations of the different processes carried out with the help of Microsoft Office.

DURATION IN MONTHS:

March 2009 – Feb 2010

PROJECT – SAMDB – IMS Cut Over

• Project Title

IMS Cut Over – Interactive Marketing System cut over

• Duration
• May 2009 – Nov 2009
• Operating Systems
• Windows XP, UNIX
• Technologies used
• Accentual Data Stage – ETL tool, Sql Server,
• Oracle – PL/SQL, SQL
• Role
• Senior Developer
• Client
• Confidential,Hartford, CT

PROJECT DESCRIPTION:

This project is developed by using Data stage – ETL tool for IMS application. IMS cut over is a warehouse for all the agency contact information that will be used in Campaign Application. Currently all the contact information and the associated dimensions are stored in SAMDB/MODS database. This project transforms the data between MODS, SAMDB databases for Affinium- Cognos reports.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

As Onsite lead on the SAMDB-IMS Cut over project, I hold the following responsibilities.

• Responsibility and Lead the Team in development by using Data Stage, PL/SQL
• Understand the existing IMS system which was in system called – Affinium Database.
• Developed complex stored PLSQL procedures, ETL Data stage programs to load the data from various environments such as – Mainframe, Affinium data base and MODS.
• Wrote Automated batch programs, by using UNIX shell scripts, PLSQL procedures to fetch the daily updates from existing database to the new environment during IMS Cut over process.
• Deployed the code into production. Provided post production support.

DURATION IN MONTHS:

May 2009 – Nov 2009

PROJECT – Marketing Operational Data Source (MODS)

• Project Title

Marketing Operation Data Source (MODS)

• Duration
• March 01, 2008 – March 2009
• Operating Systems
• Windows XP, UNIX
• Technologies used
• Accential Data Stage – ETL tool, Sql Server,
• Oracle – PL/SQL, SQL
• Role
• Senior Developer
• Client
• Confidential,Hartford, CT

PROJECT DESCRIPTION:

Marketing Operational Data Store (MODS) is a warehouse for all the agency contact information. Essence of this project is to set up Linux environment to support Data stage ETL – 7.5.2 version.
This project took care of migration of ETL units from 7.5.1 to 7.5.2 version and also some more new development/enhancement of MODS.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

As Onsite lead on the MODS project, I hold the following responsibilities.

• Responsibility and Lead the Team in development by using Data Stage, PL/SQL
• Interact with BA to get the Business requirements clarifications and prepare detailed design document.
• Participated in development, Unit Testing, Integrated Testing, UAT.
• Coordinated/ lead the 9 member offshore team in understanding the requirement and getting the work done.
• Help the Deployment team in code deployment and provide production support.
• I am the one point contact where business users can call and define / discuss the current state of the project as well as the new requirements.