Project Management

Sana Manghnani

Email: ***************@*****.***, Phone: 1-571-***-****

Experience Summary

A result-oriented Analyst Programmer associated with Tata Consultancy

Services for around 5 years, with a lust for excellence. Strong Java

programming skills & working efficiently with teams have been my key

strengths. I have a track record of executing assignments from inception

through delivery. I am a technology enthusiast who is technical enough to

develop complex software solutions and personal enough to help customers

put their ideas into action. I have an avid interest in employing the

newest technologies to produce the best possible product.

Career Profile

Dates Organization Role

Sep 2006 - TATA Consultancy Services Analyst Programmer

To-date

Technology

Below is a list of important hardware, software products, tools and methods

that I have worked with.

Hardware/OS Software Products/ Programming Tools

Languages

Redhat 3.x, Primary - Java, J2EE, JSP, Servlets, CVS, MS-VSS, SVN,

Windows Hibernate, Oracle 9i/10g, MySQL 5, MS Excel Macros,

XP/2003 Apache Tomcat, WebSphere, Weblogic, TOAD, PL/SQL Dev

Struts

Other - Ab Initio 2.13/2.14, Crystal

Reports

Role History

Role Client Duration

Java/J2EE ABN - Amro July 2009 - June 2011

Developer

Backup Project 20th Television FOX Nov 2008 - May 2009

Lead

Module Lead 20th Television FOX Jan 2008 - May 2009

Java/J2EE 20th Television FOX Aug 2007 - May 2009

Developer

Dev/SOX Motorola Jan 2007 - July 2007

Auditor

Web Developer TCS Innova Labs (TCS Dec 2006

Internal)

Associate TCS (Initial Learning Sep 2006 - Nov 2006

Trainee Programme)

Qualifications

Degree and Date Institute Major and

Specialization

Bachelor of Thadomal Shahani Engineering Computer

Engineering College, Mumbai - India. Engineering

(2003-2006)

Diploma in Computer Institute of Technology, Computer

Technology Mumbai - India. Technology

(2000-2003)

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date

Certified

Introduction to SQL (IZ0-007) - Oracle Aug 2007

OCA/OCP

Sun/Oracle Certified Java Programmer 6 Jan 2011

Projects / Assignments

The details of the various assignments that I have handled are listed here,

in reverse chronological order.

Project BCDB/ITA Enhancement and Maintenance

Customer ABN Amro

Period 15th July, 2009 to June 2011

Domain Banking & Finance

Descripti Project involves Incident Management and Problem

on Management for the BCDB domain of ABN-AMRO bank.

Production / Test environment issues (termed incidents)

are raised & assigned to its application owner

Issues are related to any job abend, request from

Business for updating Production database, any other

issues faced in the front end

Application owner analyzes and suggests permanent

solution to recurring incidents (termed as Problems)

involving a major bug fix in an existing module.

The Smile ticketing tool is used to keep track of

incidents, problems and the communication history

thereby.

Role Problem Management

Application ownership for identification of bugs in the

below:

Individual Tariffing Application

Business Contact Database (BCDB)

Incident Management

Incident management & resolution

Problem management & proposing new solutions

Impact analysis of updates to be done

Resolving database related queries from business users

Handling cross domain issues

Root Cause Analysis & Reporting

Discussion in RCA meetings which involved all the

Vendors (TCS, IBM, Business Owners)

Analysis of modules and proposing solution

Discussion of solution with Business

Bug fixes in existing modules

Change documentation and testing of the modules

involving rework

Implementation to production

Root Cause Analysis Preparation

Solution J2EE, JSP, WebSphere 5.1.2, Eclipse, Struts Framework

Env

Tools Smile (Prisma) for incident/problem tracking &

management

Project Utopia Enhancement & Maintenance

Customer 20th Television FOX

Period Aug 2007 to May 2009

Domain Media & Entertainment

Descripti Details of Client business: Utopia is a software

on application which manages the Syndication Business for

20th Century FOX TTV Group. The TTV Group in 20th

Century FOX manages Sales, Distribution & Accounting of

products in US Domestic Market for broadcast syndication

& Basic Cable.

Scope: Application Support Services: TCS shall resolve

all the priority production support issues and

incidents, including without limitation, bug tracking,

analysis and fixes based on prioritization determined by

FOX.

Enhancements: TCS shall implement the development and

testing of all the enhancements requested and approved

by 20th century FOX. Testing involved Unit Testing,

Integration Testing, System Testing, Functional Testing,

Static Testing, Dynamic Testing, Regression Testing.

Role Developer, Module Lead, Backup Project Lead

Solution J2EE, JSP, Hibernate, Weblogic 9.1, Oracle 10g, Tuscany

Env framework, Junit Framework

Tools TOAD for Oracle, Crystal Reports 10, Eclipse

Project SOx (Sarbanes-Oxley Act)

Customer Motorola

Period Jan 2007 to July 2007

Domain Telecom

Descripti Scope

on The leading US telecom manufacturer is in the process of

complying with the Sarbanes-Oxley Act. TCS team plays a

major role in assisting the client in achieving the

compliance of the SOX Act. It covers testing the design

and operational effectiveness of the identified controls

for the 23 Level 1 applications which are spread across

4 regions viz. USA, Latin America, Europe and Asia.

Objective of the Project

23 Level-1 applications identified for SOX Compliance

Conducting Roll-forward test of Operating Effectiveness.

Testing and Documentation of Results

Project Management

Project Execution

Execution from 4 regions including NA, LA, EMEA, Asia,

and Offshore

Onsite / Offshore Model

Coordination with different vendors, who look after the

system maintenance, network etc and working with quite a

few clients' teams.

Project team from security practice and part of BCDB TCS

team participated in year SOX 2004 Program

Application enhancement & support being TCS's primary

responsibility

Role Team Member, Auditor

Solution Oracle

Env

Tools Kintana Ticketing tool, TOAD for Oracle

Training / Continuing Education Summary

Program or Coverage Dates

Course

Enterprise Enterprise Java Beans concepts and JUNE,

JAVA Beans implementation hands on case studies. 2008

Project Conflict management, Leading an MAY, 2008

Leader Onsite/Offshore model engagement,

ORACLE Oracle data dictionary tables, PL/SQL NOV, 2007

PL/SQL - II Architecture, PL/SQL variables & PL/SQL

Blocks, SQL in PLSQL, Collections,

Transaction, Cursors, Error Handling,

Procedures, Functions, Packages, Dynamic

SQL, Objects, Commonly used built-in

packages.

ORACLE Sub-Queries, Hierarchical Queries, Group by SEP, 2007

PL/SQL - I clause, Built in functions, Indexes,

Sequences.

Language Email Etiquettes, Video Conferencing Tips. JUN, 2007

Tips for

Writing

Right

Programming Recognize examples of strategies and tasks OCT, 2006

Techniques for minimizing software complexity.

and Identify the characteristics of egoless

Strategies programming. Recognize the software quality

attributes for a given software

application.

Agile Agile Vs Traditional Life Cycle, Agile OCT, 2008

Methodology Values and principles, SCRUM, Planning and

estimation in Agile, Test Strategies in

Agile, QC in Agile, Common pitfalls

JSP/Servlets Form Data, Request Headers/Code, Response DEC,

Code/Headers, Cookies, Session Tracking. 2009

JSP Scripting Elements: Expressions,

Scriptlets & Declarations, JSP Directives,

Predefined variables, JSP Actions, Creating

Custom JSP Tag Libraries

Initial Corporate Performance Management, BPM, SEP, 2006

Learning Knowledge Management, J2EE Basics (JSP,

Programme Servlets, etc.),Software Engineering

(ILP) Concepts, C, C++, MainFrames, Java, Data

Structures, Analysis of Algorithms

Personal Details

Date of Birth Marital National Passport/Wor

Status ity k permit

24th March, Married Indian Valid

1985

Contact this candidate