Manager Project

Sapna Dua Email: *****.***@*****.***

Associate Consultant / Mobile: +91-971*******

Implementation Manager /

Environment Manager

Tata Consultancy Services

** ***** ** ********** ****** varied roles in the Retail Banking /

Transportation / Insurance / Life Sciences & Healthcare domains with an

emphasis on the "Design Stream".

I've been involved in several projects, in a techno-functional capacity as

a Technical Lead/ Infrastructure Lead and have worked in different stages -

problem definition, solution design, development, deployment & maintenance,

Infrastructure setup.

PROFESSIONAL PROFILE

. 12 years of total IT experience out of which 5 years leading/managing

team's up to 20 resources.

. Currently working as an Associate Consultant with TCS, India.

. Started my IT career with Tata Consultancy Services and served there for

around 7 years. During my tenure with TCS, I have been involved in all

the phases / stages of life cycle of a project like Requirements

Analysis, Design Phase, Application Development and Support, Functional

Testing, Test Process Consulting and Management Areas.

. Post TCS, I joined Royal Bank of Scotland and served the organisation

for 3.5 years. During my tenure with RBS, I had been handling the

Environments Build Team for the Mortgages Platform.

. Technical expertise in Oracle and Unix with exposure to technologies

like Datapower, web services, WAS 5.1, WAS 7.

. PRINCE2 Certified Project Management Professional with 2 years of

project planning, execution and delivery skills experience.

. ITIL Intermediate in OSA (Operational Support Analysis) with 6 months of

experience on various processes within same.

. Proven and well appreciated track record of delivery excellence well

appreciated by clients and peers alike.

. Seasoned professional, with resource balancing skills and ability to

support multiple projects simultaneously, ability to communicate with

stakeholders effectively and efficiently.

. Experienced in coordinating, negotiating, motivating and mentoring

onsite and offshore resources in support of time line and project

deliverables.

. Highly skilled listener and communicator, able to assess client

requirement and convey necessary information with clarity and

enthusiasm.

. Strong process orientation, Project planning, and monitoring of the

Deliverables / milestone under cost, quality and schedule constraints.

TECHNICAL PROFILE

Database Operating Systems & Language Special Software

Solution Environment

Oracle 11g, 9i Windows NT, UNIX, SQL, Oracle Forms,

Citrix, Spine,N3 PL/SQL, Microsoft Office

Network, WAS 7, IIS & Pro*C. Tools, Remedy

IHS web servers, User, Designer 6i

Datapower, AIX build

PROFESSIONAI EXPERIENCE

Tata Consultancy Services, Gurgaon, Haryana, Oct'2013 - till date

Associate Consultant / Implementation Manager for client (Royal Bank of

Scotand)

. Responsible for Implementation stream for CSR upgrade project on

Mortgages platform. Instrumental in guiding, designing and framing the

Implementation strategy, Implementation plan & Sequence of Events for

implementation. This CSR Upgrade project is a complete Mortgage

platform transformation which involves multiple stakeholders.

Technical stack for project includes Oracle 11g, Oracle forms, Unix,

WAS 5.1, WAS 7, Datapower.

. Responsible for liasing with various stakeholders and collate the

implementation specific activities from their respective technical

stream.

. Responsible for giving inputs for the Application design and

Production Infrastructure build of the project which will migrate

database from Oracle 9i to Oracle 11g.

. Working as SME for the Mortgages platform guiding team in resolving

technical as well as functional defects in various testing cycles.

. Handling project implementation and managing multi vendor teams -

environment team, Inftrastructure teams & Design teams.

. Managing a team (third party) who will be servicing the day to day

running of a test environment. Identifying strengths and weaknesses in

this team and providing technical assistance to maintain a high level

of service across all environments.

. Experience in the training of third party resources in test support.

. Relationship management with projects testing in test environments.

This should include build delivery / execution timelines and

capability / project conflicts (resulting from shared environments).

. Awareness on associated Managed Testing processes

. Strong Issue management processes and experience in incident

management calls based around test issues.

. Work on a Programme level environment build where in testing for

different project work streams can progress.

. Data Extraction and ring fencing of data / sanitization used by

testing teams.

. Ensure smooth functioning of Test environment through governance

processes like Incident Management / Configuration Management and get

the resolution of showstopper issues.

. Stakeholder management (business / technology, local / other

geographies)

. People Management, resulting in high employee satisfaction

. Environment planning and estimation.

. Financial Management

. Recruiting (internally and externally - where necessary)

Royal Bank of Scotland, Gurgaon, Haryana, Mar'2010 - Oct'2013

Infrastructure Manager / Environment Manager - (Jan '2013 - till date)

. Responsible for design of CSR upgrade project on Mortgages platform.

Instrumental in guiding, designing and deploying the upgraded

application in staggered delivery approach. Technical stack includes

Oracle 11g, Oracle forms, Unix, WAS 5.1, WAS 7, Datapower.

. Responsible for Application design, Production Infrastructure build

and performance tuning of the project which will migrate database from

Oracle 9i to Oracle 11g.

. Responsible for MTP Fees pre-production build which includes

procurement of assets, configuring them into production data centres,

getting application build on servers.

Technical Lead / Infrastructure Lead - ( Mar'2010 - Dec'2012)

. Worked as Infrastructure lead for MTP Fees project, wherein I was

responsible for infrastructure build of project's test environments

and production build.

. Major responsibilities being asset management, cabling, database

build, hardware procurement etc. Technical stack include Oracle 9i,

Power builder, Datapower, WAS5.1.

. Worked as Transition Lead for Mortgages platform wherein I was

involved in planning, scope, budget & schedule for the transition

project and was responsible for on-time quality transition plan.

. Responsible for creating and managing Knowledge Repository for

transitioned mortgage applications,

Tata Consultancy Services Ltd., Noida, Jan'2003 - Mar'2010 (7 yrs)

Technical Specialist & Resource Manager - (Oct'2008 - Feb'2010)

. Responsible for Plan compass project's Technical Database design for

''HUMANA Inc'' - a fortune 500 company that markets and administers

health benefit consumer services in Louisville, Kentucky.

Instrumental in guiding, designing and deploying the enterprise data

warehouse along with OBIEE reporting tool. Technical stack includes

Informatica 8.6, Oracle 11g, UNIX.

. Worked as Technical SME for performance tuning of the database.

. Also played stretch role of Resource Manager wherein I used to

Coordinate with client on resourcing needs and tracking their

fulfillment through either internally from TCS Pool or recruitment.

This gave me a flavour of Stakeholder management & communication

management

Technical Lead / Functional Analyst (Jan'2006 - Oct'2008)

. Worked as Technical Design Lead for "Fujitsu Alliance NHS" in UK.

Fujitsu Services implemented an IT solution ''Millennium'' for NHS UK

wherein the whole objective was to deliver integrated clinical

information across all health and social care settings across the

geographies and NHS Trusts. I was responsible for detailed design/

build of the application database. Technologies worked on are Citrix,

Web Sphere, Active Directory, Spine, N3 Network, Oracle 9i database.

. Worked as Development Lead for MICS COE - ADMINLIMS & EUROLIMS project

for ''Leading US Pharma (Confidential)'' client. Was involved in

design, development & deployment to existing LIMS application. Also

handled one complete end to end project which automated the failure

reporting and restarting of interface between LIMS & SAP system.

Team Lead - Technical Stream (Oct' 2002 - Dec '2005)

. Worked as a Team Lead (Team Size = 10) for Shipping Management System

of "P&O Nedlloyd" and was responsible for analysis and design for all

projects in the costing module.

. Designed, Developed, Re-engineered and deployed major projects like

Full Focus 4, Focus 3 etc. Technologies worked on are Pro* C, Oracle

9i - PL-SQL & UNIX.

Full Focus 4- application handles all operations involved in the door-

to-door movement of containers from consignor to consignee, including

the cost of movement of empty containers, also including costing

module which interfaces Purchase Orders for matching and payment

purposed with People Soft.

Focus3-Operational Costing Component for same application which covers

all operational cost involved in the door-to-door movement of

containers from consignor to consignee, including the cost of movement

of empty containers, which include Interfacing of Purchase Orders for

matching and payment purposed with People Soft.

. Involved in Analysis & debugging of problems related to different

modules of application like Costing, Sea Movements for containers and

feeder related aspects. Was also involved in performance tuning of

complex SQL queries.

. Also visited PONL, London as Design Lead to capture the requirements.

EDUCATION

. MCA from Banasthali Vidyapith, Jaipur (2002) - (78%).

. Bachelor of Sciences (Computer Sc.), Delhi University (1999) - (79%).

. HSC, CRPF Public School, CBSE, Delhi (1996) - (80%)

. SSC, DAV Public School, CBSE, Delhi (1994) - (81%)

PERSONAL INFORMATION

Date of Birth: 15-Oct-1978

Marital Status: Married

Nationality: Indian

Permanent Address: B-86, Oriental Apartments, Sector - 9, Rohini,

Delhi - 110085

Passport No. H9338322

Passport: Valid Up to 17-Feb-2020

Current Location: Delhi, India

Mobile: +919*********

Email: *****.***@*****.***

Contact this candidate