Miss.Mandakini Mehta

EXPERIENCE SUMMARY

I have CANADA ICT VISA

Possesses around Twenty Two years of experience in various stages of the software development lifecycle comprising of Requirement Analysis, Solution Design and Implementation of various projects using Oracle Database Administration, Oracle Tools and Technologies in Telecom and Other domains. Passed AZ-900 (AZURE Cloud).

AZURE Cloud migration project – For AT&T and Microsoft working Migrated 5 Oracle Database and 2 MSSQL Database for last 6 month.

Worked in the role of the Senior Database Administrator Manager /Data Analyst for EDD Development Project for AT&T USA managing and maintaining the Oracle database for 11 years.

Played the key role of the Database Replication for Enterprise Delivery Document (EDD) application developed for AT&T Telecom (US).

Possesses Oracle Database 10g Administration Certification in the Database Track.

Possesses Project Management Professional Certificate (PMP).

Possesses Prince2 Certification.

In addition possesses an extensive knowledge of Oracle 12c, 13c, 11g RAC, 10g and 9i Enterprise Database Server. Have done an exhaustive amount of programming in PL/SQL and Oracle Database Management and UNIX shell scripting. Working as Oracle DBA/Data Analyst for AT&T US.

Have played a key role as PERFORMANCE TUNNING for BT (UK) Client.

Have worked for Air Canada client for setting up Payroll and Human Resource application E2E application Access for Hewitt Associates (India) to set up their call center Environment.

Have worked for Bank of Montreal, Canada – Migration of Data and E2E testing of application.

Worked 2 years in Qatar for Madina Group WLL - Managed DATABASE from installation to migration and designing and sizing Database and provided E2E solution.

Have also worked on a Oracle Developer 2000 and developed application for Financial Enterprise. In Qatar and India. Also worked for Insurance application for US client.

Have worked in a variety of functional domains such as Telecom, HealthCare Insurance, Finance, Information Security Management, Personnel Information System Management, Payroll Processing Systems and ERP related functionalities.

Expertise in ORACLE architecture and Oracle development framework.

Have worked on DATABASE hardening for Motorola US.

Thorough experience in a variety of UNIX environments.

Experience in Installation & Configuration of Oracle Database Server.

Thorough knowledge of Entity Relationship Diagrams and Data Flow Diagrams and Object Oriented Analysis & Design

Design documentation, User demonstration and preparation of training & presentation materials.

ACADEMICS

B. A from Utkal University (1980)

Diploma in Computer Studies from National Computing Centre (NCC), U.K. (Aptech Ltd.) (1988)

Oracle Certified Professional (OCP) In 2009 – DBA track.

Project Management Professional (PMP) – 2008

JOB HISTORY

Duration

Organization

Designation

April 2 2007 to Feb-2021

Tech Mahindra Inc.

Sr. Manager DBA

Feb 14 2005 – March 30 2007

Hewitt Associates

Software Test Lead

April 1 2002 – October 3 2004

Madina Group W.L.L

System Analyst/Team Leader

January 01 1992 – April 01 2002

Hexaware Technology

Technical Architect

March 26 1988 – Jan 01 1992

Apple Industries

Programmer

TECHNICAL SUMMARY

SKILLS

TOOLS

EXPERIENCE LEVEL

AZURE CLOUD

2

RDBMS

Oracle8i, Oracle9i, Oracle 10g,Oracle 11g,Oracle RAC, Oracle 12c,Oracle 13c

SQL Server,

Sybase

4

4

4

3

Design Tools

Microsoft Visio 2003,ERWIN

4

4

Development Tools

Oracle Reports 6i,

Oracle Forms

SQL*Forms 3.0,

SQL*Forms 4.5,

Developer 2000,

Pro*c,

SQL*Loader

4

4

4

4

4

4

4

4

Languages

P L/SQL

SQL

UNIX Shell Scripts,

COBOL

4

4

4

4

Operating Systems

Sun Solaris,

Citrix

Linux,

DOS,

Windows 95/98/NT/2000/XP

4

4

4

4

4

Hardware Platform

Sun Fire v480,

RS6000,

NCR

IBM e series servers

3

3

3

3

Database Tools

OEM

4

Internet Technologies

HTML, XML,

4

Oracle Application

Oracle Financials

People soft HRMS

PAYROLL

4

4

4

WORK EXPERIENCE

Organization: Tech Mahindra Inc

1. Project: AZURE Cloud Migration

Client: AT&T

Period: Aug-2020 – Till Date. (USA)-Currently In India

Working as DBA role for AZURE Cloud Migration Project. For Oracle database 5 application Migrated. MS SQL 2application migrated. Passed AZ-900 Exam and Preparing for AZ-104 exam.

.

2. Project: Enterprise Delivery Document (EDD)

Client: AT&T

Period: APR-2014 – Aug-2020. (USA)

OCT-2009 - APR 2014 (INDIA)

Location: USA

Description: EDD Development Project for AT&T - Managing Production /Development and QC Database.

Closely work with release management team to move the code in production environment.

Maintenance Activity of Database. Backup/Recovery.

Perform Database tuning and performance monitoring

Monitor application related jobs and data replication activities

Assist developers with database activities

Migration Activity.

Analysis of AWR and ADDM Report.

Tune database queries

Setup and maintain documentation and standards

Plan growth and changes (capacity planning)

Work as part of a team and provide 7x24 support

Perform general technical trouble shooting and give consultation to development teams

Interface with Oracle Corporation for technical support.

Software and Platform - Oracle 11g RAC

Roles I am working as the Sr.Database Administrator Manager

Team Size: Around 5 members are working in this project across different locations.

2. Project: British Telecom (BT) - AGORA MDM Performance Tuning

Client: British Telecom (BT) .

Period: – April 2008 – OCT 2009 (1.6 year)

Location: Mumbai, India.

Description:

I was involved in Performance Tuning of BT - Agora Project. Agora Process was developed in Oracle PL/SQL and it was running as batch process. The process was taking more than 8 hrs. As per business requirements it has to complete in 8 hrs.I did the analysis of the code and created the explain plan and used the oracle 10g AWR Reports and fine tune the Process. Suggested changes to the code which was causing performance Problems. Developed the required Tuning scripts.

I supported Application database Production Releases and change management activity.

Software and Platform ORACLE 10G Database, PL/SQL, SQL

Roles DBA (Performance Tuning)

Performance Tunning of Query and Application

Provided Performance Plan and cost of the query to application team

Generate AWR and ADDM Reports.

Suggest changes to the Developers

Memory and Database tuning

Team Size: Around 4 members are working in this project across different locations.

3.Project: Motorola Database security

Client: - Motorola

Period: Jan 2008 – Mar 2008

Location: Mumbai,India

Description:

Identify Database Vulnerabilities and Threats

Create a documentation/presentation outlining the Techniques used by hackers to exploit database flaws and vulnerabilities for customer presentations.

Build/identify database assessment and database penetration toolkit

Create Database Hardening process for Commonly used databases

Software and Platform Oracle 10g Database

Roles I am working as a Database Security in this project carrying responsibilities such as Prepared Database security Documentation.

Team Size: 2 members are working in this project across different locations

4.Project: Mahindra & Mahindra - Oracle Identity Management

Client: - Mahindra & Mahindra

Period: Jun 2007 – Dec 2007

Location: Mumbai,India.

Description:

Prof of concept development of Oracle Identity Management which includes Provisioning, De provisioning, Self Service, Password Reset, Delegated Administration. Business Requirement Gathering, Analysis, Developing Use Cases, Product Configuration & Demonstrations

Software and Platform Oracle 10g Database, Oracle Identity and Access Management

Roles I am working as a Project Manager in this project carrying responsibilities such as E2E Solution. For Identity and Access Management

Team Size: 4 members are working in this project across different locations

Organization: Hewitt

5.Project: HRMS (People Soft) - Bank of Montreal

Client: Bank of Montreal,

Period: Feb 2006 – Mar-2007

Location: Mumbai, India.

Description:

Interaction with onsite Test coordinator, Developer coordinator

Involved in BAU setting up Environment

Involved in writing the automated scripts for the PeopleSoft database to Compensation Advisor for the Outbound and Inbound Interface.

Involved in Joint SIT and UAT for Bank Of Montreal.

Data Migration – prepared automated database scripts.

Software and Platform People Soft, Web Based My HR

Roles I am working as a Test Manager.. E2E Testing of Application. Database migration testing.

Team Size: Around Twenty five people are working in this project.

6.Project: HRMS (People Soft) - Air Canada

Client: Air Canada

Period: Mar 2005 – Dec -2005

Location: Mumbai, India.

Description:

Interaction with onsite Test coordinator, Developer coordinator

Involved in BAU setting up Environment

Involved in writing the automated scripts for the PeopleSoft database to Compensation Advisor for the Outbound and Inbound Interface.

Involved in Joint SIT and UAT for Bank Of Montreal.

Data Migration – prepared automated database scripts.

Software and Platform People Soft, Web Based My HR

Roles I am working as a Test Manager.. E2E Testing of Application. Database migration testing.

Team Size: Around 10 people are working in this project.

Organization: Madina Group W.L.L

7. Project: Financial Accounting, Material Management, Payroll & Personnel, Projects, Contract, Quality Control, Time keeping, Asset Mgmt.

Client: Madina Group W.L.L

Period: Apr 2002 – Oct-2004

Location: Doha,Qatar, Mumbai India

Description:

I worked as System Analyst and Team Lead. E2E solution provided. I. Prepared system design documents. On approval of document did development work and data migration form existing PARADOX database.

Software and Platform Oracle 9i, Oracle Developer 2000

Roles I am working as a System Analyst.. E2E Solution Design.

Team Size: Around five people are working in this project.

Organization: Hexaware

8. Project: Medical Reporting System

Client: Tan Tock Hospital (Singapore)

Period: Jan 2002 – Mar -2002

Location: Mumbai India

Description:

I was involved in installation of ORACLE 9i.Database Design & Maintenance of Database

Software and Platform Oracle 9i, Oracle Developer 2000,Java

Roles DBA

Team Size: Around 10 people are working in this project.

9. Project: Agency Compensation System

Client: Equitable USA

Period: Feb 2001 – Dec -2001

Location: Mumbai India

Description:

Involved in preparing the high-level design.

Database Design using ER Win and Rational Rose

Writing Oracle Stored Procedure in PL/SQL and SQL for transferring data into Mainframe and from Mainframe to Oracle

Responsible for converting Cobol flat files.

Involved in converting flat file data into Oracle data using SQL*LoaderSoftware and Platform Oracle 9i, Oracle Developer 2000,Java

Software and Platform Oracle 9i, Oracle Developer 2000,JAVA

Roles Project Leader

Team Size: Around 15 people are working in this project.

10.Project: Payroll System

Client: Colgate Palmolive, India.

Period: May 2000 – Jul -2000

Location: Mumbai India

Description:

I was involved in converting VB code to SQL/PLSQL for better performance. E2E testing of the code. Query tuning. After change of cod in sql/pl sql the process which was running for more than 8 hrs reduce to 4 hrs.

Roles DBA, Performance Tuning

Team Size: Around 3 people are working in this project.

11. Project: ORACLE PROJECT

Client: Hexaware Technologies Ltd, India

Period: Apr 1999 – Dec - 1999

Location: Mumbai India

Description:

Responsible in Mapping the functionality

As a user implemented the System

Trained By Oracle Corporation

Oracle 9i, Oracle Developer 2000

Software and Platform – Oracle Financials /Oracle Project

Roles USER

Team Size: Around 20 people are working in this project.

12. Project: Trading and Management Information System (TRAMIS)

Client: Almana & Partners (Qatar)

Period: Apr 1996 – Dec - 1998

Location: Mumbai India, Doha Qatar

Description:

Involved in implementation of system at on-site (QATAR)

Co-coordinating with client and users

Involved in preparing the high-level design.

Involved in preparing the programming specifications using the high-level design inputs.

Writing Oracle Stored Procedure in PL/SQL,Forms,Report

Responsible for writing Cobol programs for converting flat file and transferring the data into ORACLE data using SQL*Loader.

Software & Platform – Oracle 8i, Forms & Report

Roles Project Manager

Team Size: Around 20 people are working in this project.

Jan 94 to Dec 94

Project

Order Processing, Inventory, Invoicing System

Client

Arabian Bulk Trade (Saudi Arabia)

Environment

Sybase 10,Watcom, PowerBuilder 4.0,UNIX,ERWIN/ERX, RS 6000

Position

Module Leader

12. Project: Order Processing, Inventory, Invoicing System

Client: Arabian Bulk Trade (Saudi Arabia)

Period: Jan- 1994 - Dec - 1995

Location: Mumbai,India

Description:

I was involved in preparing E2E solution for the Order Processing and Inventory system. Client visited to India for helping us in providing requirements. System was developed in bi language in Arabic and English. Data migration was done from existing cobol system.

Software and Platform: Sybase, Power Builder

Roles I was involved in preparing E2E solution for the Order Processing and Inventory system. Client visited to India for helping us in providing requirements. System was developed in bi language in Arabic and English. Data migration was done from existing cobol system

Team Size: Total 10 people have worked on this project. 4 team member gone for implementation to Saudi Arebia

13. Project: Consumer Finance and Financial Accounting System, Fixed Deposit

Client: Apple Finance & Leasing

Period: Jan- 1992 - Dec - 1993

Location: Mumbai, India

Description:

Involved in preparing the high-level design.

Writing Stored Procedure in PL/SQL, forms, Reports, Pro*c.

Writing Cobol programs

Software and Platform: COBOL, Oracle 8.

Roles Programmer

Team Size: Total 8 people have worked on this project

Organization: Apple Industries

I Worked for Apple Industries Ltd. from Jan 1987 to Mar 1991 as initially as Faculty and Lab Assistance than worked for EDP Department.

Contact this candidate