Project Management

Amruta S. Deshmukh

Mobile No. +91-950******* Email: ********.*******@*****.***

OBJECTIVE

To associate with an organization that provides an opportunity to show techno-proficient skills, to improve knowledge with the latest trends and to be a part of the team that works dynamically towards the growth of the organization.

SUMMARY

A Professional, with 2 years and 3 months of experience in the field of development in java (jsp) and in Telecommunications (i.e. Voice transmission)

Presently part of TATA COMMUNICATIONS Pvt. Ltd. (On Contract)

DBA Training completed in FOCUS PVT.LTD. And also worked on live DBA projects for FOCUS PVT.LTD.

WORK SYNOPSYS

Responsibilities of automation and voice transmission.

In automation, I have developed some tools using Java (JSP) as frontend and MySQL as backend.

QUALIFICATION

Earned MCA, from Saint Gadge Baba University, Amravati, Maharashtra in year 2014 with 72 %.

Earned BSC, from Saint Gadge Baba University, Amravati, Maharashtra in year 2011 with 59%.

Earned HSC from Maharashtra State Board in year 2007 with 50%.

Earned SSC from Maharashtra State Board in year 2004 with 52%.

TECHINICAL SKILLS

Programming Languages : C, C++, Core java and J2EE (JSP)

GUI : HTML 5, CSS 3

RDBMS : MySQL and Oracle 11g Database management and architecture,RMAN.

Web/Application Servers : Apache Tomcat

Tools/Others : NetBeans

ORACLE PROJECTS

1.Created a database named fdb with the following details.

A) System tablespace - Size 300M - Autoextend should be turned off 2. sysaux tablespace - Size 100M 3. temp tabespaace - 20M 4. undo - 50M (name of the undo tablespace must be fdbundo) 5. Follow the OFA standards for location of pfile, oradata 6. SGA size must be 250M expandable to 500M 7. Configure your undo management in such a way that no one will overwrite your undo segment for more than 300 seconds after committing the data 8. There should be 4 redo groups and 2 members in each group. Size of each member should be 10M 9. Database must have 3 control files 10. Default block size of the datbase must be 2K 11. All check points should be logged to the alert log file. 12. Database must be in the archive log mode. Archive log files should get generated in the flash recovery area. The size of FRA shoould be 1 g.

2. Database Cloning

A.) Clone your existing database with a new name "clonedb1" on the same machine. make sure that the files of the cloned database are kept on separate directories so as not to clash with the original database.

Do not shut down the original database during the cloning process. Treat the original database as 24 x 7 x 365.

All transactions in the original database in the current redo files must be migrated to the clone database.

Do not use RMAN to perform this cloning

All schemas, tables, tablespaces that are in the original database must be available with same userID/password and grants in the clone database. Cloned database should not be in archiving mode.uld be 1G.

B.) Startup and Shutdown Make sure that the cloned database starts automatically when the machine is rebooted.

Configure the cloned database in such a way that it automatically shuts down when the machine is shutdown. (it should not perform automatic instance recovery on next startup.)

3.) Clone prod database (with RMAN)

A.) Create a duplicate database with RMAN. The duplicate database(dupdb2) should be identical to the target database (prod).

The target site and the duplicate site should be on separate hosts/Machines. The IP address of the new machine is 172.24.11.2 (Login: oracle, Password: oracle) You need to run the DUPLICATE command with a recovery catalog. You have to exclude all the readonly tablespaces.

EMPLOYMENT HISTORY (2 years 3 months)

1.TATA COMMUNICATIONS (From 31st March 2016 to Present)

Division: GVS (Global Voice Services).

Team: Voice Engineering.(Voice Capacity Management)

Description: Responsible to create medium & long-term optimal, cost effective & scalable network capacity plans both at Transmission & Service layers and provide innovative solutions for managing capacity requirements. Manage Global Transmission/Service layer network capacities by establishing processes and review mechanism for bandwidth inventory, utilization reports, periodic audits & optimizations to ensure efficiency and accuracy. Identify future backbone network requirements basis traffic forecasts, past trends and utilization reports to meet requirements for all line of businesses and recommend on-net upgrade (capex)/ offnet (opex) leasing models in transmission core network for cost-effective & timely fulfillment. Engage with LOB for Network strategy & development discussions, finalization of plans & budgets. Negotiation & Procurement of offnet backbone BW based on forecast & Engineering/LOB requirements & manage external supplier relationships. Manage Backbone Opex budget efficiently against AOP plan with alignment to revenue plans & continuous improvement in offnet BW economics. Collaborates with internal & external stakeholders for continuous improvements in working processes for enhanced productivity with the objective to ensure timely availability of network capacity for meeting customer's & network requirements in most optimized manner, and meeting business demands seamlessly with compliance to processes and guidelines.

Work: I am doing work on Automations for team. I am developing software tools, which helps to reduce manual work .and they are also cost effective. Till now, I have developed two software tools for team. Trend Report Tool and Capacity Management Tool. Both tools are using for capacity management.

I am also working on Capacity Mangement.I raise network capacity plans both at Transmission & Service layers and provide innovative solutions for managing capacity requirements.

Role: Associate

PROJECTS DEPLOYED for TATA COMMUNICATIONS

1.Project Title: Trend Report

We developed tool, which shows trend (graph) of utilization reports. Based on this tool our team decides network capacity plans .this tool shows voice traffic trend of all locations (Both National and International).this tool also maintains database of utilization of traffic reports.

Responsibilities:

Actively involved in Design, Development and Maintenance phase.

Coordinating work with the other team members to complete the allocated tasks on time with quality.

Technologies:

JSP, HTML 5, CSS 3, My SQL, Apache Tomcat.

2.Project Title: Capacity Management Tool

This tool helps to create templates (Excel sheet) of network capacity plans. There are four types of plans they are Augmentation plan, DPC Migration Plan, SWITCH Migration plan, Reconfiguration plan, Decommissioning plan. And Inters witches plans. This tool also maintains multiple databases. It allows making modifications in databases like bulk insertion, updation, and deletion. This tool also shows reports of utilization. Before this tool team have to raise plan manually. Team have to update three databases concurrently. It was very time consuming process. After this tool team do not need to update databases.it will updated automatically. We have to select data through drop down boxes. Then table will be display with checkboxes for selection of rows. Just select rows and insert some details. And submit it.this process will create template i.e. excel sheet which shows all required information in tabular format to raise network plans.

This project maintains all main inventories and dashboards of Voice Engineering team.

Responsibilities:

Actively involved in Design, Development and Maintenance phase.

Coordinating work with the other team members to complete the allocated tasks on time with quality.

Technologies:

JSP, HTML 5, CSS 3, My SQL, Apache Tomcat.

PROJECTS DEPLOYED FOR FOCUS PVT.LTD.

1.Project Title: Create database with given specification.

2.Project Title: Use RMAN(Recovery Management),Cloning, Automatic Memory Management, Partitioning.

ACADEMIC PROJECTS

1.Project Title: Online Event Management System

This project contains Website of Event Management Company. It gives users to make online registration for organize or plan the events like birthday party, reception, and corporate meetings. This website provides users to choose cuisines, facilities, area like open (garden) or close (halls) which they want.

Completed For:

Bizwin Softmass Pvt. Ltd. Pune (MCA 6th semester Project)

Responsibilities:

Actively involved in Design, Development and Maintenance phase.

Coordinating work with the other team members to complete the allocated tasks on time with quality.

Technologies:

JSP, HTML 5, CSS 3, My SQL, Apache Tomcat.

2.Project Title: Campus Placement for IT Solutions Pvt. Ltd

This project contains Website of Software Development Company. It provides online registration and takes online exam for job placement in company. And issue interview call letter of selected candidate. The main objective of on-line exam is to efficiently evaluate the candidate thoroughly through a fully automated system that not only saves lot of time but also gives fast results.

Completed For:

MCA 5th semester Project

Responsibilities:

Coordinating work with the other team members and division of work into various modules.

Involved in Requirement gathering phase.

Participated in Design and development phase and also performed Unit Testing for development.

Technologies:

JSP, HTML 5, CSS 3, My SQL, Apache Tomcat.

3.Project Title: Library Management System

This project contains whole management of library .In this project users i.e. students can issue and return books. admin i.e. librarian can maintain records of books, issued books, new stock of books (which contains all information about books like author, publication, no. of copies).New admin and new user can make registration.

Admin also maintains all information about student who issued or return book & due dates. He can see registered students, available books and all information about them. This project can be use in any school or college.

Completed For:

MCA 2th semester Project

Responsibilities:

Coordinating work with the other team members and division of work into various modules.

Involved in Requirement gathering phase.

Participated in Design and development phase and performed Unit Testing for development.

Technologies:

VB.Net, MS Access.

PERSONAL DETAILS

Date of Birth : 16th Aug 1988

Nationality : Indian

Gender : Female

Languages Known : English, Hindi and Marathi

Marital Status : Single

Local Address : C/O. Shri. Pramod More,

Bhakti Apartments, Flat No. 6, Hinjewadi road,

Vishal Nagar, near Jagtap Dairy,Wakad

Pune, 411 027

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility of correctness of the above-mentioned particulars.

Date:

Place: Pune (Amruta S. Deshmukh)

Contact this candidate