NEHA KALRA

SUMMARY

Over *+ years of experience in analysis, design, development, and testing of business applications in OLTP and OLAP

Strong Knowledge on oracle architecture and database design.

Strong expertise in Oracle 9i/10g/11g/12c PL/SQL.

Extensive experience in database programming using SQL and PL/SQL following industry best practices.

Expertise in creating stored procedures, functions packages, collections and bulk collections using PL/SQL.

Expertise in loading data from legacy systems using SQL*Loader.

Worked with various performance tuning techniques using tools provided by Oracle like

EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, DBMS_PROFILER etc.

Experience in Database modeling and database object definitions

Strong knowledge of Extraction Transformation and Loading (ETL) processes using SQL, PL/SQL and SQL Loader.

Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader, using SQL, PL/SQL and UNIX Shell Scripting.

Solid experience in ETL

Supported integration and end user testing with efficient defect management process.

Strong Analytical, Problem solving and communication skills.

Strong communication and inter-personal skills at the technical and user level.

Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

Ability to learn new tools, concepts and environments.

Good team player, Self-motivated, quick learner.

Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS:

Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus

Database tools:

PL/SQL Developer, TOAD, TOAD Data Modeler, SQL Developer

Operating systems:

UNIX, Windows XP/7/10

Languages:

SQL, PL/SQL, UNIX Shell Scripting, C, C++

WORK EXPERIENCE:

Metropolitan Transportation Authority (MTA), NYC Aug 2016 – Present

PL/SQL/ ETL Developer

Environment: Oracle 11G, SQL, PL/SQL, TOAD, TOAD Data Modeler, Windows 10

The Metropolitan Transportation Authority (often abbreviated as MTA) is a public benefit corporation responsible for public transportation in the state of New York, serving 12 counties in southeastern New York, along with two counties in southwestern Connecticut under contract to the Connecticut Department of Transportation.

Developed an application named electronic hours of Service for different types of employees in different agencies of MTA, which calculates and tracks the number of hours worked by an employee who is responsible for the movement of trains. This application also calculates the previous day rest of the employee before returning to the duty, so that management can ask them to take proper rest before joining the next day duty, this is to avoid the risk involved in the movement of trains.

Responsibilities:

Analyze the requirements and create physical design of the application.

Working on creating the backend of the application using Oracle PL/SQL.

Involved in writing DDL scripts to create various objects like Tables, Views, Types etc.

Involved in enforcing data integrity using integrity constraints like Primary Key, Foreign Key,

Unique, Not Null and others.

Wrote various sub programs like stored procedures, functions and packages to fulfill the business

requirements.

Wrote SQL scripts and debugged several during ETL process.

Extensively used Cursors, Analytical functions and conditional statements.

Works on various pre-defined and user-defined exceptions to handle different types of errors.

Worked with different teams to build the interfaces to get data into our application.

Write various jobs to load data from various interfaces as per the requirement.

Write complex scripts to generate various reports for the management.

Implemented the ETL process and business logic by using SQL

Run batch jobs to update the database on hourly and daily basis.

Perform Unit testing to deliver bug free code to QA.

Worked with testing team to resolve the issues and bugs found while performing the testing of the application.

Touro College and University System, NYC Oct 2015 – May 2016

PL/SQL/ ETL Developer

Environment: Oracle 11G, SQL, PL/SQL, SQL Developer, SQL Plus, Windows 7, Banner ERP

Touro College is a sponsored independent institution of higher and professional education. The project is to automate the student database system to improve Registration process, Financial Aid and Financial System. To manage the Graduation related information i.e. Graduation dates, Graduation Fees and Records of Graduated Students.

Responsibilities:

Gather and analyze the Business Requirements of the project.

Work extensively on SQL, PL/SQL to implement the Business Logic.

Wrote various DDL scripts to create various database objects like tables, views, sequences and synonyms.

Created various stored programs like Procedures, Functions and Packages to fulfil the business requirement.

Extensively used Cursors, Collections and triggers.

Extensively developed complex PL/SQL packages for ETL.

Involved in writing technical documents to help other team members and for future reference.

Involved in performing Unit testing and writing test plans.

Wrote SQL scripts and debugged several during ETL process.

Created various job to update the student’s database on daily basis.

Worked on Performance Tuning using Explain Plan, SQL_Trace.

Run Batch jobs to load tables from flat files into database using SQL Loader.

Web4Bharat, Gurgaon INDIA Aug 2011 – Sept 2014

University Management System

Description:

Worked on University Management System (UMS) as Junior Programmer and QA. UMS is a huge database system which can be used to manage, and store your day to day activity in the university campus. UMS consist of fully independent functional modules each designed to increase the efficiency of the departments in a university and to provide online information.

Responsibilities:

Wrote SQL scripts to generate reports and load data into database.

Implemented the ETL process and business logic by using SQL.

Involved in writing various stored procedures and functions as per the requirement.

Perform manual testing as per test case documentation to identify bugs in the system.

Wrote test case document and update it with comments after performing testing.

Resolved the issue and bugs found in the testing phase.

EDUCATION:

Master’s in Computer Application under Kurukshetra University, Kurukshetra, INDIA.

Contact this candidate