Oracle DBA consultant

Manjari Negi

Phone: +1-609-***-****

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

RESUME SYNOPSIS

Database Professional having 9.1 years of programming experience, as a Sr. Oracle SQL and PL/SQL,D2K Developer in system analysis, Design (Forms and Report) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Adept at Implementing Business Logic, Bug Fixing, Technical Support, Maintenance and Testing.

Worked on Informatica ETL tool. Developed mappings to load data into data marts.Use workflow manager, monitor the loading process.

EXPERIENCE SUMMARY

Expertise in writing simple and complex SQL Queries, PL/SQL package, function, stored procedure, triggers, cursors and performance tuning.

Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors and Dynamic SQL.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like PL/SQL Developer and Toad.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan, Query performance, Explain Plans, Indexes and HINTS.

Enforced data integrity using integrity constraint and database triggers.

Good knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.

Expertise in handling errors using Exceptions.

Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).

Experience in working high-transacted OLTP systems.

Designed and implemented forms and reports using Oracle Forms and Reports 6i/10g.

Good experience in manual ETL and designing and developing of mappings, transformations, sessions and workflows using ETL Informatica Power Center.

Developed workflow manager and workflow monitor to create, schedule and monitor the loading processes.

Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.

Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, unit testing.

Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Significant experience working with clients, technical teams for executing concurrent multi-technology projects.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Strong interpersonal and communication skills in dealing with clients.

Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS

Database Oracle 11g/10g

Languages SQL,PL/SQL, Oracle Forms and Reports 10g/6i

ETL Tool Informatica 9.5.1

Operating System Windows, Unix

Third Party Tools PL/SQL Developer, TOAD,JIRA

Development Process Agile, Waterfall

Configuration Tools CVS, VSS

Functional Areas Taxation,Insurance,Travel, Treasury.

Project Management MS Project, Excel

Knowledge only Python

Project Description – Genworth (DELL International Services) Aug 2013 – March 2016

Sr. Software Analyst

Genworth Financial is a leading financial security company started in the year 1871 with operations based out of more than 30 countries serving more than 15 million customers.

TIA (The Insurance Application) has built in modules and this modular structure is designed to support the whole policy lifecycle, including customer, policy, claims, accounts, as well as offering correspondence capabilities etc.

The business partners of Genworth (Providers/Retailers/Clients – referred to as the ‘bank’ throughout the rest of the document) like the Bank of Ireland, EBS etc. sell policies on Genworth’s behalf to millions of customers.

Responsibilities

Client interfacing and Escalation handling.

Optimized lot of SQL statements and PL/SQL blocks by analyzing the explain plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.

Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.

Implemented all modules logic by using Triggers and Integrity Constraints.

Good understanding of database objects and ability to triage issues.

Involved in PL/SQL code review and modification for the development of new requirements.

Created materialized views required for the application.

Performance tuning in the database with, explain plan, query rewrite and hints.

Design and Development of new requirements and enhancement in D2K forms and reports.

Client Interaction for new enhancements, Updating JIRA, deployment of code with DBA, Unit testing and resolution with client and support, prepare documents for release.

Creating new CRs by understanding clients’ requirements and suggesting pro-actively, designing and estimating the same.

Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.

Providing Inputs to the Logical and Physical Data Modeling.

Delegating the task to the team members and providing functional and technical knowledge.

Resolving the issues on priority basis.

Project Description – GAZEBO (Aspire e-Travel Tech, Delhi) May 2012 - Aug 2013

Sr. PL/SQL Developer

Gazebo is an application used by travel agencies private retailer or public service that provides tourism related services to the public on behalf of suppliers such as airlines, car rentals, cruise lines, hotels, railways, and package tours .

Agent: - Selling travel products and services on behalf of a supplier all over India. There are 23 travel agencies as client.

There are registered agents in India (approved by govt.) for booking the tickets, tour and related facilities ex- airlines, railway, Hotel, Transport, Passport, Visa Insurance etc.

These agents save the data and pass to accountants of agencies who use the gazebo and make their calculated sheets, balance sheet, ledger, MIS etc.

Responsibilities

Client interaction for requirement gathering, system analysis and finalization of technical/functional

Design analysis and Document Scoping

Development and testing the enhancements.

Development of reports through PL/SQL procedures, materialized views etc.

Enhancing Performance of the application by implementing various logics and techniques like performance tuning of reports in PL/SQL.

Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team

Used TOAD, PL/SQL developer tools for faster application design and developments

Developed database objects including tables, Indexes, views, materialized views, sequences, packages, triggers and procedures to troubleshoot any database problems

Created Materialized Views for performance reasons.

Understanding new requirements of users and adding new features to the system

Project Description – Directorate of Income Tax (DIT) (CMC, TCS Group) Jun 2009 - Dec 2011

Software Developer

The Directorate of Income Tax -DIT(S) is the nodal body that regulates the computerization in the Income Tax Department (ITD). It is a regulatory body under the Central Board of Direct Taxes (CBDT) of the Ministry of Finance. This centralized system processes the returns, refunds, TDS, PAN’s, TAN’s etc. of all tax-payer categories

Responsibilities

Designed, developed and customized forms by using Oracle Forms 9i and Reports 9i.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Design forms and reports in D2K.

Written Stored Procedures using PL/SQL and functions and packages.

Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.

Developed Database Triggers for audit and validation purpose.

Writing validation packages using PL/SQL package.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Designed and developed reports on ETL tool informatica using different mapping and filter/expressions.

In-depth understanding of all the mapping operators in ETL- Informatica i.e. join, filter, expression, router, update strategy, transaction control, normalizer, aggregator, look up etc.

Project Description – Madhya pradesh treasury Govt. (CMC Ltd) Aug 2006 - Jun 2009

Software Developer

State Finance Monitoring System (SFMS) of Madhya Pradesh, this involves On Line Transaction

Processing (OLTP) system and deals with 229 treasuries across the state of MP.

DTA (Directorate of Treasury and Accounts) is main server system of SFMS where whole budget

from different divisions of state collected, processed and approved .Then send at 259 treasuries

in whole state for expenditure according to the yearly work plan developed at DTA level .

Works withdrawl functionality is the application used to allot the amount to different budget control

Officers (BCO) and for there work plan preparation according to the amount allotted by finance

department of MP for particular work in particular account head as per government budget plan.

And then the BCO allot money to their drawing and disbursement officers (DDO) according to

there yearly/monthly plan.

Responsibilities

Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Written Stored Procedures using PL/SQL and functions and procedure for common utilities.

Participated in system analysis, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.

Developed Database Triggers for audit and validation purpose.

Created and manipulated stored procedures, functions, packages and triggers using Pl/SQL,TOAD developer.

ACADEMICS

2019 Master In Computer Science from Colorado Technical University, Colorado, USA

2006 MCA (Master in Computer Application) from Rajeev Gandhi Technical University, Bhopal, INDIA

2002 BSc. (Computer Sci.) from Barkatullah University, Bhopal, INDIA

Contact this candidate