Summary

• **.* years of professional experience with broad technical knowledge combined with strong

analytical skills, leadership ability, team and creative problem-solving skills.

• PMP certified professional

• Extensively worked on Informatica Power Exchange and Informatica Power Center 8.X, 9.1.0

(Repository Manager, workflow manager and workflow monitor and Designer)

• Extensive experience in developing Informatica mappings, mapplets, sessions, workflows .

• Experienced in Project Management Methodology, OLTP and OLAP modeling, Data

Warehousing and ETL methodology

• Expertise in .NET Framework 3.5/2.0/1.x and its technologies ASP.NET, C#, VB.NET, WCF,

ADO.NET, Web Services and Windows Services.

• Experienced in Design & Developing application using WinForms, WebForms and XML Web

Services and SOAP, AJAX, IIS, JavaScript, Visual Studio.NET, Visual Source Safe,

Subversion. Have knowledge of MVC design patterns.

• Proficient in RDBMS databases including DB2, Oracle, MS-SQL Server and MS-Access.

• Good Knowledge in implementing client-side JavaScript, VBScript, creating XML, XSLT pages

and SOAP.

• Experience in entire Software Development Life cycle involving Analysis, Design, Development

and deployment. Experience of Waterfall model and Agile Methodologies.

• Data processing professional with extensive experience in system planning, solution architecture,

project risk management, requirements analysis, iterative prototyping, project

scheduling/estimation, high-level/detailed design, construction, test planning, implementation,

user training, post-project feedback / lessons-learned analysis and development of best practices

• Proven track record in a broad range of endeavors, from requirement definition, effective

business / data analysis and business aligned data model, to quality assurance and effective

enterprise data integration processes

• Good industry knowledge in Retail and CPG- implemented and Pharmaceutical. Has supported

various applications under Supply chain, Logistics and Marketing systems.

• Extensive functional and technical exposure.

• Good analytical skills, presentation skills with strong communication skills and ability to work in a

team or independently

• Ability to focus and prioritize under pressure.

• Good design skills and architectural skills in the technical area and good understanding of project

management skills

Key Domain and Technical Knowledge

• Domain : Retail (Supply chain, Logistics, Marketing systems, Marketing), CPG and

Pharma

• Technical :

ETL Tools Informatica Power Center 8.x, 9.1.0, Informatica Power Exchange 8.x

Business Objects XI R2

BI Tools

. NET Framework 3.5/2.0/1.x, C#, VB.NET, ASP.NET, ADO.NET, Web

.Net Technologies

Services, WCF

C#, VB.NET, VB 6.0, C, XML, UNIX Shell Scripting

Languages

ASP.NET, ASP, JavaScript, VB Script, HTML, AJAX

Web Development

IIS 5.0/6.0/7.0, Visual Studio.Net

Web & App Servers

Visual Studio.NET 2008/2005/2003, Visual Studio 6.0, Visio, MSMQ

Design and Development

Tools

MS Access, Oracle 9i/10G, DB2, FoxPro, SQL Server 2005/2008

Databases

Toad, SQL Plus, PLSQL developer, TeraData SQL Assistant.

Database Tools

Erwin 7.1.2/7.3

Modelling Tool

Windows NT/2000/XP, DOS, OS/400,Unix

Operating Systems

Visual Source Safe (VSS), Subversion (SVN)

Version Control

Waterfall, OO Analysis and Design (OOAD), Agile

Methodologies

Operating Systems Windows 95/98/NT/2000/XP/2003

LINQ to SQL

ORM tools

WAS tool, LoadRunner9.10, Quality Center 9.2

Testing Tool

Academic Qualification

• Bachelor of Engineering in Computer Science in 2002 from RGVP University, India.

Certifications / Professional Awards:

• PMP Certified Professional

• Certified in Informatica Professional

• Certified NRF - Basics of Retailing

Total Work Experience:

Company: Infosys Limited Period: June 2003 to Till Date

Projects:

Project Title: ICC Development

Client: Neiman Marcus

Work Location: Irving, TX, USA

Duration: From Jun, 2014 to Till date

Description: Working as a Manager/Tech Arch role – involved in Development and Maintenance &

Production Support projects. As part of Incident management, was engaged in high Sev incident reviews

and identifying opportunities to reduce number of Sev3 and 4 incidents, improve MTTR for application

incidents, Improve overall e2e Application Availability to the business; As part of Problem management,

was involved in reviewing & planning corrective actions for key problem tickets, identify new initiatives for

Continuous Service Improvement Plans

Role and Responsibilities:

Managing the customer with multiple projects

Responsible for delivery of assigned module/ components /phases of a project.

Responsible for people Management, including goal setting and providing performance

feedback

Responsible for Status reporting

Responsible for guiding the development team.

Responsible for estimation, planning and execution with specific focus on requirement

analysis and design

Responsible for Knowledge transfer and arriving at SLAs for steady state

Technical problem solving skills

Proactively manage changes in project scope, identify potential crises, and devise

contingency plans.

Onsite-offshore Co-ordination

Client Interaction

Project Title: Astra Zeneca Amazon Finance Interim reporting project

Client: AstraZeneca

Work Location: Pune, India

Duration: From Oct, 2011 to Jun 2014

Description: Worked as a Manager/Tech Arch role – Was involved in Development and Maintenance &

Production Support projects. Has done effective Problem/Change Management with daily interactions

with Business and IT to prioritize & resolve tickets, supervise daily activities of production support to

ensure timely and effective reporting, tracking, follow-up and communication of problems to internal &

external stakeholders, technical resources and executives. Involved in owning incidents & problems and

work to get to detailed root cause analysis & suggest workarounds and/or solutions for recurring issues.

Work with relevant stakeholders & team to carefully plan, design & deploy with continual improvements to

service quality

Role and Responsibilities:

Managing Project (Define project scope/plans, goals and deliverables)

Schedule & Track project milestones and deliverables using MS Project.

Draft and submit budget proposals

Delegate tasks and responsibilities to resources using MS Project.

Develop and deliver progress reports, proposals, requirements documentation, and

presentations.

Determine the frequency and content of status reports from the project team, analyze

results, and troubleshoot problem areas.

Proactively manage changes in project scope, identify potential crises, and devise

contingency plans.

Mentoring the resources in Informatica 8.6.1

Onsite-offshore Co-ordination

Requirement Gathering

High level design using Erwin tool

Database design using Erwin tool

Impact analysis

Design Review

Support

Client Interaction

Project Title: JCP Markdown Optimization project

Client: JC Penney

Work Location: Plano, TX, USA

Duration: From Sep, 2010 to Oct 2011

Description: The purpose of the MDO (Markdown Optimization) project is to optimize clearance price

strategies at the store level to maximize revenue and profit. The project is going to be a partnership

between SAS and ABC to help streamline and maximize returns on markdowned merchandise in retail

and direct. This involves implementing an enterprise-wide SAS Markdown Optimization solution that

replaces current Selling Strategy functionalities and provides statistically based recommendations for

markdown pricing and timing at the location and item/color levels. Played an Onsite Lead role - Was

involved in Systems analysis; understanding and representing the various views of information; reverse-

engineering architectures from existing structures. With Hands-on technical and functional knowledge,

ensured high customer satisfaction for Infosys and JCP.

Role and Responsibilities:

Requirement Gathering

High level design using Erwin Tool

Database design using Erwin Tool

Impact analysis

Design Review

Schedule & Task tracking using MS Project

ETL Build using Informatica Power Centre, Informatica Power Exchange 8.x, DB2 and

Oracle DB

Support

Onsite offshore Co-ordination

Project Title: JCP Flow & Execution project in Supply Chain Area

Client: JC Penney

Work Location: Plano, TX, USA

Duration: From Nov, 2007 to Aug 2010

Description: The project (Door to Floor technology) involves developing RF functionality and reporting to

support Merchandise location planning for the stores. The purpose of the project is to create visibility to

orders and key information in the Supply chain and Store Network. Played an Onsite Lead role - Was

involved in Systems analysis; understanding and representing the various views of information. Door to

Floor technology was cited by InformationWeek as one of the “20 Great Ideas.” The technology enables

store management to know what merchandise will be delivered up to 48 hours in advance, allowing for

optimal planning and preparation for getting merchandise off the truck and onto the sales floor. The end

result is greater efficiency in terms of merchandise speed to floor, set execution and overall increased

productivity

Role and Responsibilities:

Impact analysis

High level design

Database design

Design Review

Schedule & Task tracking using MS Project

Programming in .NET technologies, Informatica mapping development, DB2, SQL Server

& Oracle DB

Code walk through

Unit testing

Bug Fix

Integration testing

Performance testing using Load runner tool

Support

Co-ordination

Project Title: JCP Supplier Compliance Project

Client: JC Penney

Work Location: Plano, TX, USA

Duration: From Oct, 2005 to Oct 2007

Description: The project involves transitioning some of the Info vision reports to supplier compliance

site. It also involves developing new reports and enhancing the existing supplier compliance reports. It

involves the maintenance and enhancement of the following applications:

1. Report card application

2. Scorecard application

3. DCDB Exclusion application

4. Penalty exception application

5. Highest Compliance offset application

6. Offset to Payment Application

7. CTS Reversal Application

Apart from the enhancement/maintenance support, this project will also be providing the 24x7 production

support to the above-mentioned applications for a week per month

Role and Responsibilities:

Impact analysis

High level design

Database design

Program specifications

Change specifications

Programming in .NET technologies, DB2 DB

Code walk through

Unit testing

Bug Fix

Integration testing

support

Project Title: JCP Logistics Control Systems Project

Client: JC Penney

Work Location: Chennai, India

Duration: From Nov, 2004 to Oct 2005

Description: This project deals with the core logistics of the retailed. It involves four subsystems namely

• Logistic Control System

• Warehouse Operating System

• Freight and Audit Payment system.

• Visibility

The scope of the project is maintenance of the following applications – LoCS(Logistics Control system),

WOS(Warehouse operating System), FAP(Freight Audit and Payment system) and Visibility.

Role and Responsibilities:

Impact analysis

High level design

Programming

Code walk through

Unit testing

Bug Fix

Integration testing

support

Project Title: Informatica Development for Sysco

Client: Sysco Corporation

Work Location: Chennai, India

Duration: From June, 2003 to Nov 2004

Description: This project involves in building the Data warehouse for various applications. This involves

gathering requirements from various Business Process Teams of client and Designing the Data

Warehouse, Building Informatica Scripts for Extraction, Transformation and Loading the Reports

development using Business Objects.

Role and Responsibilities:

CM (Configuration Management) – Team member

Coding using Informatica Scripts

Coding using Unix Scripts

Business objects Report Development

Writing test scenarios, Developing test cases and Test plans

Personal Information

• Gender : Male

• Marital Status : Married

• Visa Details ( If any) : H1-B

Contact this candidate