Senior Oracle Analyst

Ujjwala Amalanathan

078********

adbyhw@r.postjobfree.com

Objective:

Seeking an interesting and challenging role in the field of database development/ system analyst, blending my technical expertise and offering a constant scope for learning by which I can articulate my new creative thoughts.

Summary:

• 11 years of experience in Database Development and as System Analyst using Oracle based applications.

SME in Oracle ERP - Finance module

Expertise in providing permanent solutions for replicating issues.

Managing and reviewing the code of peer groups.

Handled the delivery of the project on time.

Extensive work experience in Oracle 10g, Oracle 9i, Oracle 8i databases.

• Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers, Exception Handling, Constraints, Triggers, Index, Views and Inline views.

• Involved in Development of the applications through Oracle using PL/SQL created Tables, cursors and SQL Queries.

• Well acquainted with Oracle base technologies like SQL, PL/SQL

• Good knowledge of Software Development Life Cycle (SDLC)

• Good in Understanding of Business logic and ability to work well as a part of a team and as an individual

• Ability to work in 24x7 environments, preparing root cause analysis and ensuring the action points

• Strong in Database Architecture, Database Development, and Data Modeling

• Solid experience and knowledge in Data warehousing concepts

• Experienced in Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)

• Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, Index Organized Tables, external tables etc.

• Thorough knowledge and experience in using analytical functions, hierarchical queries.

• Experienced in Shell UNIX shell programming using ProC.

• Experienced in Database Optimization by making use of various Performance Tuning techniques.

• Experienced in Partitioning Administration. Creating Managing Partitioned Tables and Indexes.

• Experienced in Normalized Database Design and Modeling (Logical and Physical design of database)

• Experience with data flow diagrams, data dictionary techniques, and Entity relation modeling and design techniques, database normalization theory.

• Experience in physical and logical data modeling.

• Extensively worked in Oracle Forms, Reports.

• Very good working knowledge in TOAD

• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.

• Experienced to translate reporting and analytical needs into technical solutions

• Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and plans.

Technical Expertise:

Programming : Oracle SQL, PL/SQL, ProC, Shell Scripting, C, JAVA, Visual Basics,

Data warehouse

Tools : Developer 2000 (Forms and Reports 6I, 10g), TOAD, SQL developer,

SQL*PLUS, Putty, Export/Import

Operating system : Windows, Unix, Linux

Database : Oracle 10g, Oracle 9i

Professional Experiences:

CGG, Crawley, United Kingdom Oct 2018-Till date

Senior Database Developer – Team Size : 7

CGG provides geological, geophysical and reservoir capabilities to customers primarily from the global oil and gas industry. It has three complementary businesses: Equipment, Acquisition, and Geology, Geophysics & Reservoir (GGR).

Roles and responsibilities:

Enhancement of the Pl/SQL code

Implementing the new functionality according to the business requirement

Writing adhoc queries for the users

Application support for running jobs in UNIX box

Coordinating with the other teams to get more clarification to the user with regards to the data in the application.

Performance tuning

Involved in level 3 support

Environment: TOAD, Perforce, Putty, SQL plus, PL/SQL coding, UNIX

JP Morgan, Glasgow, United Kingdom Feb2016-June 2017

Senior Associate – Tech Lead, Team Size : 8

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.6 trillion and operations worldwide. The Firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands.

Roles and responsibilities:

Working in Agile environment.

Complete maintenance of JIRA Board

Involved in migration of source code from SVN subversion to GIT for security purpose.

I have been a Tech Lead working from Glasgow, UK Office, managing developers working from NewYork and consultants working from Costarica

Worked extensively with the clients during the migration of an legacy application from JAVA to Angular JS platform, to ensure the expected functionality

Capturing business requirements and designing solutions

Involved in data migration project, secluded automated jobs in Pentahol

Providing supporting Documentation

Enhancing the performance tuning in SQL queries

Involved in test driven and behavior driven development

Building and tuning workflows in PL/SQL queries

Some exposure to JAVA code

Involved in level 3 support

Environment: Oracle Apps, SQL Developer, WinSCP, Oracle 10g, Putty, Tortoise SVN, SQL plus, UNIX, Sybase, Jenkins

Almac Group, Craigavon, Northern Ireland May2014-Jan2016

Senior Application Developer, Team Size: 8 +

Almac is a contract research organization based in the United Kingdom. The company provides integrated drug development services, research, manufacturing, to about 600 clients. Almac's research targets five main branches: diagnostics, sciences, clinical services, clinical technologies and pharmaceutical services. Almac is involved in joint efforts with a couple of companies. It formed a deal with Hewlett-Packard (HP), investing in the company's test applications software, which will help shorten the time that a drug spends in clinical trials.

Roles and responsibilities:

Maintenance of COSMOS application which is an Oracle ERP application.

Subject Matter Expert in Finance Module

Worked actively and provided permanent solutions for issues.

Taken responsibility of monthly release documentation.

Managed a team of 5 developers working in India, few in Northern Ireland and a few in US

Involved in the Automated Storage billing (ASB), which is one of the core billing process.

Involved in the JITM process, to manufacture the drug just in time with a fast pace.

Enhanced and created PL/SQL procedures and functions to implement business requirements.

Writing the technical documents, updating the WIKI documents for knowledge transfer.

Debugging the scripts and changing it according to the business.

Written PL/SQL scripts which runs on monthly basis to generate the journal reports.

Created new report for the business when required.

Environment: Oracle Apps, SQL Developer, Forms & Reports 10g, WinSCP, Oracle 10g, Putty, Tortoise SVN, SQL plus, UNIX, Jenkins

Forestry Commission, Edinburgh, United Kingdom May2013-Dec2013

Senior Oracle Developer, Contract, Trained end users of the SRP – an Oracle ERP application

The forestry commission manages sustainable woodlands requires a long-term commitment. England’s woodlands form a vital component of our landscapes and environment. They improve our quality of life, protect and enhance our environment and contribute towards a sustainable economy. To promote the role of woodlands and to reconnect people with woodlands in order to ensure that they are valued and managed for hundreds of years to come. Wood processing and paper industries, along with recreational visits to forests and woodlands contribute £4.7 billion to the English economy. This enables landowners, businesses, civil society, local communities and individuals to determine and deliver on the sustainable benefits that they need from England’s woodlands.

Protecting, improving and expanding our woodlands will ensure that they can flourish in the face of climate change, pests and diseases, and that we can maximize their potential to support biodiversity, to provide other ecosystem services and to contribute to jobs and the economy.

Roles and responsibilities:

Enhanced and created PL/SQL procedures and functions to implement business requirements.

Writing the technical documents.

Debugging the scripts and changing it according to the business.

Enhancement of forms and reports according to the business requirement.

Debugging of procedures, packages and functions using SQL Developer

Creating triggers.

Written PL/SQL scripts which runs on monthly basis to generate the journal reports.

Created new report for the business when required.

Environment: SQL Developer, Forms & Reports 10g, WinSCP, Oracle 10g, Putty, Oracle designer.

Western Power Distribution, Plymouth, United Kingdom Oct2012-April2013

Senior Oracle Developer, Contract, trained End user of the CROWN – an ERP application

Western Power Distribution distributes power to homes and businesses across the Midlands, South Wales and the South West around-the-clock. Electricity is transported across the country through the National Grid at 275,000 or 400,000 volts. It is reduced to 132,000 volts for regional distribution at substations known as Grid Supply Points. From there it is distributed to further substations via overhead lines or underground cables at 132,000 volts. This distribution network then carries electricity to individual towns and villages throughout the Midlands, the South West and South Wales where distribution substations transform the voltage to 230 volts.

Roles and responsibilities:

Enhanced and created PL/SQL procedures and functions to implement business requirements.

SQL plus & SQL developer is used for coding.

Active client interaction on a daily basis to analyze the non technical requirement and convert in to technical specification

Running scripts on monthly basis to refresh the database.

Enhancement of forms and reports according to the business requirement.

Debugging of procedures, packages and functions using SQL Developer

Creating triggers to automate the process using the application.

Written PL/SQL scripts which runs at night to update the production database.

Created Web focus report for the business when required.

Environment: SQL Developer, TOAD, SQL*PLUS, Forms & Reports 10g, WinSCP, Oracle 10g.

ATOS, Banglore, India Oct2011 – June2012

System Analyst – mentoring team members

MARC Warehouse Management System, PHILIPS Netherlands,

MARC (Material and Resource Control) system is used for warehouse maintenance

PHILIPS is the client, which uses the MARC application for creation of Purchase order (PO) and Sales order (SO). This application is mainly used to Generate Reports for Business Users (using PL/SQL /Oracle).

Configuring Warehouse management system as per the client’s requirement, Maintenance of various areas and locations inside the warehouse, configuration of various policies such as receiving, putaway, shipping, picking and replenishment.

Roles and responsibilities:

Enhanced and created PL/SQL procedures and functions to implement business requirements.

Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query

Performance

TOAD and SQL developer were used for coding.

Given technical training to developers to fix basic technical issues in the application

Analytical functions and hierarchical queries are used extensively.

Parameterized cursors are used in PL/SQL packages.

Maintained and created UNIX shell scripts.

Monitored the MARC Application.

Extensively involved in the enhancement of the process flow in MARC system.

Involved in the creation of Purchase order (PO) and sales order (SO).

Involved in the process flow for creation of PO and SO.

Interacted with the business regarding abnormal data reflection in the MARC Application.

Involved in the sign-off of the projects and modules.

Environment: MARC Application, SQL Developer, TOAD, SQL*PLUS, Forms & Reports 10g, PUTTY, Oracle 10g

Accenture Services Pvt. Ltd., Banglore, India Sep2009 – Oct2011

Analyst Programmer

Retail Information System, Bank of Montreal Canada,

The Bank of Montreal (BMO) is the fourth largest bank in Canada by deposits. The primary objective of the Data Acquisition - NCCS, MTG project is to obtain credit card and other lending data managed by NCCS, as well as mortgages and make it available in the EDW platform for

Future user consumption

BMO comes under Finance domain and the application uses forms and reports as front-end tool.

Involved in enhancement of forms and reports according to the client requirement also involved in upgrading database from Oracle 9i to Oracle 11g.

Roles and responsibilities:

PL/SQL Development process.

Extensive Performance Tuning(SQL Tuning, PL/SQL Tuning)

Involved in Database Development using native Oracle tools(SQL*LOADER)

Involved in the creation of Partitioned Tables and Indexes

Data Migration using PL/SQL stored Procedures.

Modified PL/SQL packages and procedures to implement business requirements.

Used SQL to create business required reports.

Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.

TOAD and SQL PLUS were used for PL/SQL Development.

Ref cursors are used in PL/SQL packages.

Involved in the migration of oracle database from 9I to 10g.

Modified the code in forms and reports post migration of database.

Prepared document related to changes made in forms and reports for performance tuning.

Given presentation to the business about the advantages of data migrations.

Written UNIX shell scripts using ProC (embedded PL/SQL)

Implemented UNIX shell script, for report generation.

Involved in understanding Requirements from the client by going through the High Level and

Detail Level requirements, in providing Inputs to the Test Lead for preparing test Plan. Further

Prepared and reviewed Test Scenarios and Cases.

Involved in reviewing the Technical Specification Document prepared by the development

team.

Maintained and created UNIX shell scripts

Environment: SQL Developer, TOAD, SQL*PLUS, Forms & Reports 10g, PUTTY, Oracle 10g, PVCS

Flextronics Pvt. Ltd., Chennai, India Aug2008 – July2009

Associate Consultant

MARC Warehouse Management System, Flextronics UK,

The main functionality of Marc WMS is Warehouse maintenance. There are 4 sites, which use this application, namely Singapore, Austin, Toronto and Louisville. This application is mainly used to Generate Reports for Business Users (using PL/SQL /Oracle). Customize the product as per Business Requirement. Understanding the business requirements of the client and mapping their business processes with the existing system functionality.

Configuring Warehouse management system as per the client’s requirement,

Maintenance of various areas and locations inside the warehouse

Configuration of various policies such as receiving, putaway, shipping, picking and replenishment

Successful placation of article master, supplier master and to have track on incoming of purchase order from D2K Host System to the Marc Warehouse management system with successful post goods issue.

Reconciliation of inventory between D2K and Marc Warehouse to make the inventory match in both systems

Roles and responsibilities:

Created PL/SQL packages and procedures to implement business requirements.

Used SQL to create cross tab reports.

Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.

TOAD and SQL PLUS were used for PL/SQL Development.

Provided technical support to developers 24X7

Analytical functions and hierarchical queries are used extensively.

Ref cursors are used in PL/SQL packages.

Created data dictionary in html format using the UTL_FILE and data dictionary tables.

Used SQL LOADER to load data from csv files into Oracle tables.

Created database links to access data from remote databases.

Maintained and created UNIX shell scripts.

Worked 24X7 Support

Environment: MARC Application, PL/SQL Developer, TOAD, SQL*PLUS, Forms & Reports 10g, PUTTY, Oracle 9i

SQL Star International, Hyderabad, India ) July2007 – July2008

Software Developer

Project 1# Jamai Millai Islamia (JMI) July2007 – Nov2007

Jamai Millai Islamia (JMI) is an Academic university in New Delhi, The volume

Of working JMI has increased considerably in recent times due to academic

Autonomy, multiplicity of various projects, schemes and a number of new Courses

This has necessitated introduction of MIS for proper record keeping and maintenance’s of database that can effectively bring about an improvement in quality and accessibility of information for monitoring and control in addition to transparency of work

The various Modules are Faculty Information Module, Accounts Module, Student Information Module.

Roles and responsibilities:

Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, ER Diagrams, Dependency documents.

Worked with very large tables and databases, which are sized in Terabytes.

Used SQL LOADER to load data from csv files into Oracle tables

Created database links to access data from remote databases.

Enhanced PL/SQL packages and procedures to implement business requirements.

TOAD and SQL PLUS were used for PL/SQL Enhancement.

Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).

Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.

Involved in performance tuning using HINTS, EXPLAIN PLAN.

Implemented pivot queries using MODEL CLAUSE.

PL/SQL Collections were extensively used for high performance of stored procedures.

Made use of DML triggers for updating sequences.

Involved in Index Monitoring for identifying the Unused Indexes

Environment: SQL Developer, TOAD, SQL*PLUS, Forms & Reports 10g, PUTTY, Oracle 9i.

Project 2 # Calypso, ITC-PSPD Ltd., Bhadrachalam Nov2007 – July2008

The main functionality of ITC-PSPD is manufacturing papers and boards and it has grown over the last few years not only in terms of capacity but also in terms of number of units and locations. As the business is expanding new equipment’s/machines are being commissioned at Bhadrachalam unit new machine PM6 is getting ready. To meet the demand for power and steam, new TG and CFB are getting added. It has different modules like Utilities, CLAB, Pulp mill, RMS, Stock Preparation, CCK.

Utilities: It is one department in ITC Ltd. – PSPD. The main functionality of utility department is supplying Water, Steam and Power To the entire Bhadrachalam unit like paper machines, colony and etc.

Process: It is one department in ITC Ltd. – PSPD. The main functionality of this module is capturing all the details of paper preparation from stock preparation and coating chemical kitchen departments.

Roles and responsibilities:

Enhanced PL/SQL packages and procedures to implement business requirements.

Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.

TOAD and SQL PLUS were used for PL/SQL Development.

Analytical functions and hierarchical queries are used extensively.

Enhanced all the forms and reports in the application.

Enhanced the reports in the application.

Environment: TOAD, SQL*PLUS, Forms & Reports 10g, PUTTY, Oracle 10g

Electronics Corporation India Ltd., Hyderabad, India Oct2005 – July2007

Software Engineer, Mentoring Junior Developers, Team Size : 6

Human Resource Management Information System

ECIL is a public sector undertaking employing more than 5000 employees. The corporation is organized into 10 Strategic Business Units (SBU) and each SBU has Divisions carrying out various functions like Marketing, Production, Servicing etc.

The Human Resources management function is looked after by individual SBU’s under the supervision and control of corporate personal group headed by Director (Personal Group). Presently each SBU maintains the personal details of their employees in dissimilar ways and the corporate personal group is unable to extract relevant information when needed.

HRMIS package developed to enforce a common structure for Information gathering, Storage and Analysis. The system was developed using 3-Tier Architecture with a Centralized Database and PC-nodes at the various Divisions of the SBU’s. The data is captured at the point of origin and the management will be able to get all its information needs for timely analysis and decision-making.

The various modules are: Personal information system – Module, Recruitment Module, Transaction Module, and Training Module

Roles and responsibilities:

Extensively involved in Application Development, PL/SQL Development and Implementation.

Developed ER diagram and data dictionary of tables in the production environment.

Gathered requirements through detailed discussions.

Involved in installing and configuring Forms and Reports, Oracle Database, Jinitiator.

Installed Oracle Environment.

Created User Classes and Users in Database.

Created User Groups, Roles to implement the security in HRMIS Application.

Created several Forms and reports for HRMIS application using D2K developer (Forms and Reports 6I).

Created Data entry forms to insert the data into the database from the written records of the organization.

Report development using Report Builder and SQL.

Worked extensively on reports to create list reports, inline prompts and Drill-Through Reports based on the user specifications.

Enhanced reports by using a series of features like, highlighting report values using conditional style.

Created standard and Adhoc reports using Query in SQL*PLUS

Created PL/SQL packages and procedures to implement business requirements.

Used SQL to create cross tab reports using Report Builder

SQL*PLUS were used for PL/SQL Development.

Analytical functions and hierarchical queries are used extensively.

Ref cursors are used in PL/SQL packages.

Created Namespaces, Query Subjects, Calculated Fields, Filters, Joins and Packages in HRMIS Application.

Monitored UNIX shell scripts.

Have been involved in training junior developers.

Training the end user about the usage of the application.

Environment: SQL*PLUS, Forms & Reports 6I, Oracle 9I, UNIX

Education:

• Bachelors Degree in Computer Science, India. (B.Tech).

• Oracle Certified Associate (OCA). (PL/SQL Developer)

• Data Warehouse Management trained by Red Prarie, Venray, Netherlands.

Personal Details:

Gender: Female

Language Known: English, Tamil, Hindi and Telugu

Declaration: I hereby declare that all the details furnished above are true to the best

Contact this candidate