Customer Project

Neha Arora

Oracle PL/SQL(OCA) Microsoft SQL SERVER Shell Scripting Cassandra Agile Waterfall Cloud Computing Project Management Scrum (CSM)

Piscataway, New Jersey

Summary

13+ Years of Professional IT experience in PL/SQL, Cassandra, Agile and Waterfall methodologies, ITIL, SQL Server, Cloud Computing, Project Management, Scrum and Shell Scripting in Telecom, Retirement and Pension, Market Research and MIS Domains.

Experience

Career break for maternity leave.

June 2019 – Present

Tech Mahindra

Client: - AT&T

10 years 8 months

Technical Specialist

September 2012 – May 2019

Multiple Locations (Piscataway, New Jersey and Toronto, Canada)

1)Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

2)Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

3)Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

4)Designed/Developed/Modified database objects like Tables, Indexes, Views, MViews, Stored Procedures, Functions, Packages, and Triggers. Inserted hints and rewrote code as required using pl/sql and

5)Comfortable working with RDBMS Databases like Oracle and MS SqlServer.

6)Involved in performance tuning and maintenance of Oracle, Sql Server and Cassandra Dbs.

7)Responsible for managing day to day production/project activities, responding to escalations, performance/merit evaluations and providing mentor-ship to team members dispersed geographically at multiple countries sites.

8)Knowledge in Cassandra read and write paths and internal architecture, including SSTables, MemTables and Commitlog.

Good conceptual understanding and experience in cloud computing tools using Oracle Cloud and AWS.

10) Knowledge in Installing and configuring extract, pump, replicate, manager parameter file of Golden Gate.

11) Good knowledge of Linux and Unix shell scripting. Using shell scripts created HTML report for DB monitoring, Client Data analysis and Audit reports.

12)Excellent experience in Agile, Waterfall methodologies.

13)Familiarity with the use of Agile tools e.g. Rally, JIRA, AgileCraft, TDP and HP Quality Center.

14)Experience in working with version control systems like GIT and SVN and used Source code management client tools like GitHub, Tortoise SVN and GIT.

15)Part of sprint reviews and daily scrum meetings to touch base with whole team and Create Product Backlog, Sprint Backlog and manage User stories and transform complex business requirements into simple acceptance criteria and User stories.

16)Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.

Consultant-Tech

December 2008 - September 2012 (4 years 3 months) Multiple Locations (New Delhi, Alpharetta and San Ramon)

1)Administration and Maintenance of PL/SQL and Microsoft SQL Server Instances.

2)Create Users and assign permissions based on the level of database access the user would need.

3)Designed/Developed/Modified database objects like Tables, Indexes, Views, Materialized Views, Stored Procedures, Functions, Packages, and Triggers. Inserted hints and rewrote code as required using pl/sql and comfortable working with databases like SQL SERVER.

4)Monitoring DB Error Logs and troubleshooting various problems that arise in day-to-day administration.

5)Monitoring and Performance Tuning at; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)

6)Involved in managing releases of product from development to QA to Pre- production and Production.

7)Supporting 24x7 data center consisting of over 20 SRS and Informiam Production Applications across 26 servers.

8)Coordinating with customers and other teams, thus building up a very strong customer support and communication structure.

9)Designed and Implemented ITIL processes for service delivery.

10)Acted as the single point of contact for AT&T for TechM engagements, covering but not limited to following activities: Telcom domain testing areas, Requirements discussions, Solution Conceptualization, Proof of Concept demos, software usability, escalation handling, customer experience enhancement, plan large scale test execution and people management activities.

11)Working with delivery teams to ensure customer requirements are being met. Identifying and fixing any communication gaps between what the

12)customer has requested, what the customer needs and what the customer is receiving

13)Anticipating customer’s future needs and help them convert to workable requirements. Working with the customer to help them achieve their visions.

Saber Corp

Associate Consultant-Database

March 2008 - December 2008 (10 months) Chandigarh Area, India

1)Designed and Implemented ITIL processes for service delivery

2)Analysis of Space Availability, Backups (transaction log, complete) and Scheduled Jobs.

3)Performance Tuning – Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

4)Create and re-evaluate Indexes and made needed modifications for better performance and Creating stored procedures, Functions, Triggers as and when required in the project.

Toluna Corporate

Database Executive

September 2006 - March 2008 (1 year 7 months) Gurgaon, India

1) Maintenance of application related jobs and troubleshooting.

2)Provide support to Application teams in designing applications (solutions based on the functionality of the application)

3)Managing security (users/database access) based on the requirement of application team.

4)Monitoring and troubleshooting performance issues.

5)Writing Queries, Stored Procedures, Trigger, Constraints.

6)Create and deployment of reports.

IBM Global Services

Technical Specialist

November 2005 - September 2006 (11 months) Gurgaon, India

1)Troubleshooting of HP computers both hardware and software for US customers.

2)Provide training on sales at the point of support.

3)To send weekly & monthly reports about Task, Resource and Project based activity.

Education

Uttar Pradesh Technical University

B.Tech, EI · (2001 –2005)

Contact this candidate