Arunima Mohapatra

Oracle Certified Associate (OCA).

Phone: 916-***-**** Sr. Oracle Consultant

Email :acunjw@r.postjobfree.com

Professional Experience

Over 10 years of professional IT experience Application development, System analysis, Design, Development, Testing and Implementation & Support of Oracle Servers 8i,9i,10g, 11g in Production, Staging, Development environments (UNIX and Windows) in various domains Healthcare, Finance, Retail, Telecom & Billing .

Proficient in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams. Extensively used QUEST Tools (TOAD, TOAD Data Modeler, Navigator) and SQL Developer PL/SQL Developer, Erwin Data Modeler, SQL*PLUS.

Good experience in client/server technology, Web design, RDBMS concepts

Expertise in Oracle (SQL, PL SQL), Perl, UNIX, C, ProC. Worked in Data Modeling, Database Design, SQL Performance Tuning, SQL*Plus, SQL*Loader and UNIX shell scripting. Extensively used PL/SQL (Stored procedures, triggers, packages, function), SQL* PLUS, SQL* LOADER, Explain Plan, Optimizer Hint and SQL tuning with SQL trace commands of Oracle database.

Proficient in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling, SQL tuning, and creation of Oracle Objects – Tables, Views, Materialized Views, Inline views, hints,table partitioning Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.

Proficient in Dynamic SQL, Query designing, Tuning, Optimization in Oracle 8i/9i/10g/11g environments.

Expertise in UNIX shell programming, cron scripting, AWK and Sed and developed ETL for loading data using PERL .

Worked with OLTP for current data with short database transactions where the database can be updated/ inserted or deleting the data’s through online with normalization process for high volume of data transactions.

Good knowledge in OLAP Technology for monitoring multidimensional database including cubes, AWM (Analytic Workspace Manager).

Experience in scheduling jobs using DBMS_JOBS, DBMS_SCHEDULER.

Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

Tuning and optimizing current and new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes and creation of views.

Proficient in Data modeling, Normalization and generating schema.

Exposure of real time handling of Six tier-1 Telecom Clients by many onsite/off-sites projects.

Rich experience with the Telecom, Insurance, and Banking domain end-to-end flow mostly into Billing, CRM, Payments, Rating, and Provisioning & Mediation.

Strong in Business Support & Control System (BSCS) for Multi-Market, a convergent billing system.

Have strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.

Education & Certifications:

Bachelor in Engineering in Computer Science &Engineering in 2004,Utkal University, India

Certification on Oracle Certified Associate (OCA) - 1Z0-007 & 1Z0-147

Technology Profile:

Software

Perl, Oracle 11g,10g, PL/SQL, Shell scripting, C, proC, C++, Core Java

Tools

PuTTY, Toad, PL/SQL Developer, Borland Tool, SQL Developer, Rational

ClearCase, Rational ClearQuest, Debugger Tool( Dde, Wdb, Gdb, Purify),

Borland Tool, Subversion, SOAP UI, TOAD, AWR, ADDM,

Web Application Server

Weblogic 8,Weblogic 10.3, Apache, Tomcat

Methods

Object-oriented Methodology, Structured Methodology, Agile Methodology,

Continuous Integration

Professional Experience:

Client: Healthnet, Sacramento, CA Oct 2015 to Feb 2016

Role: Sr. Tester

Project: MARS Security and Performance Enhancements

Medical Management team facing issues due to security role differences between Unity and Pega MARS . This critical project will correct those gaps and will align the security control points between the two applications. There are so many Security Gaps like No common control point for controlling access requests between Unity and Pega MARS, Pega MARS role assignments are not aligned with Unity access rights, No centralized control point for maintaining staff assignments etc. The primary purpose of Pega MARS Security Enhancements Project is to

Provide the ability for access management of new/existing Pega MARS users from Service Now

Pega MARS to host a web service for user profile updates

Delete user access from the system.

Generate SOX Audit user list and Member access report.

Robust reporting feature for ODW team with new tables.

Also, Medical team is facing slowness while accessing this. So, lots queries has been identified which are tuned to avoid slowness. Worked closely with Oracle and Pega team to solve issues.

Responsibilities:

Analyze the requirements, participate in technical design discussions and develop the solution

Involved in preparing functional specification, technical design document, schema documents, flow charts and user manual.

Analyze and fix production issues within SLA

Establish deliverables and meeting Business and SME’s by ensuring timely and efficient completion of procedures and deployment packages for reporting purpose.

Coding and Implementation of modules required for migration of data.

Extensively used Dynamic SQL, PL/SQL Packages, Procedures and Database Triggers.

Created Global Temporary Tables in procedures to temporary data store for processes that are complicated to complete in a single pass.

Created and manipulated Stored Procedures, Triggers, Views, Functions and Packages and Created utilities for error reporting by using PLSQL stored procedures.

Database performance bottlenecks, performance tuining, SQL/Query optimization and provided support to developers during development and post-implementation cycles.

Developed Complex Business Logic using procedures, packages, triggers, function for programming. Used SQL* Loader to upload huge data from CSV file and Legacy database to Oracle 11g database.

Involved in unit testing by creating test data and coordinated the Business Analyst, during their testing till the deployment.

Involved in designing database tables according to database Normalization techniques, created new tables, views, indexes for tuning.

Made use of DB LINKS for accessing data across different databases.

Writing Requirement analysis and specifications during design phase of SDLC and interacting with the client.

Participated in RCA (Root Cause Analysis) of tickets.

Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

Created the Shell and Perl Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.

Used FTP to transfer the files into different servers as per needed by the business users. Developed various programs using Native Dynamic SQL and REF CURSORS.

Worked with Oracle packages like UTL_FILE to open, read and write files to OS directories. Trouble shooting performance issues using Explain Plan and TKPROF.

Optimized and tuned PL/SQL subprograms to reduce the loading process.

Providing support Live Support to the code deliverables after Deployment in Live Environment.

Environment: Oracle 11g, PL/SQL, TOAD, Oracle Forms, Oracle Designer Tools, Java, XML, Pro*C, SQL*Plus, Unix, Shell Scripts, ETL, SSH Secure Shell, Putty, FTP, DTS package, Edit Plus, Putty, BEA Weblogic, Linux and Windows.

Client: Maximus, Sacramento, CA Oct 2012 to Feb 2014

Role: Sr. Oracle and PL/SQL Consultant

Project: Healthy Family Program Migration/ AIM Baby Program/PCIP Program

California Govt. decided to move all children in Healthy Families Program will migrate to the Low Cost Program Medi-Cal. Medi-Cal is California’s Medicaid program, paid for with federal and state taxes. It’s health insurance for low-income California residents who meet certain requirements. If your income is within the Medi-Cal limits for your family size, you will receive Medi-Cal coverage at no cost to you.

This process migration process took a year till feb 2014.

Now AIM baby program which was for California’s Insurance Program changed to MCAP (California’s Insurance Program for Mid-income Pregnant women). The State of California wants to help you get good health care during your pregnancy. Going without prenatal care can cause many problems for you and your baby. Studies show that women who do not get prenatal care often have more complicated (and expensive) births. If you don’t have insurance to cover your pregnancy and you are not receiving no-cost Medi-Cal or Medicare Part A and Part B, the Medi-Cal Access Program (MCAP) may be the helping hand you and your baby need. MCAP can also help if you have other health insurance that doesn't cover maternity services or with a maternity-only deductible or copayment greater than $500. Check with your other health insurance plan to see if your deductible or copayment is for maternity-only services.

PCIP (Pre-Existing Condition Insurance Plan): The Affordable Care Act created the Pre-Existing Condition Insurance Plan (PCIP) to make health insurance available to those that have been denied coverage by private insurance companies because of a pre-existing condition.

PCIP runs until 2014. In 2014, everyone will have access to affordable health insurance choices through a new competitive marketplace called an Exchange, which prohibits discrimination based on a pre-existing condition.

Responsibilities:

Analyze the requirements, participate in technical design discussions and develop the solution

Involved in preparing functional specification, technical design document, schema documents, flow charts and user manual.

Analyze and fix production issues within SLA

Establish deliverables and meeting Business and SME’s by ensuring timely and efficient completion of procedures and deployment packages for reporting purpose.

Coding and Implementation of modules required for migration of data.

Extensively used Dynamic SQL, PL/SQL Packages, Procedures and Database Triggers.

Created Global Temporary Tables in procedures to temporary data store for processes that are complicated to complete in a single pass.

Created and manipulated Stored Procedures, Triggers, Views, Functions and Packages and Created utilities for error reporting by using PLSQL stored procedures.

Database performance bottlenecks, performance tuining, SQL/Query optimization and provided support to developers during development and post-implementation cycles.

Developed Complex Business Logic using procedures, packages, triggers, function for programming. Used SQL* Loader to upload huge data from CSV file and Legacy database to Oracle 11g database.

Involved in unit testing by creating test data and coordinated the Business Analyst, during their testing till the deployment.

Involved in designing database tables according to database Normalization techniques, created new tables, views, indexes for tuning.

Made use of DB LINKS for accessing data across different databases.

Writing Requirement analysis and specifications during design phase of SDLC and interacting with the client.

Participated in RCA (Root Cause Analysis) of tickets.

Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

Created the Shell and Perl Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.

Used FTP to transfer the files into different servers as per needed by the business users. Developed various programs using Native Dynamic SQL and REF CURSORS.

Worked with Oracle packages like UTL_FILE to open, read and write files to OS directories. Trouble shooting performance issues using Explain Plan and TKPROF.

Optimized and tuned PL/SQL subprograms to reduce the loading process.

Providing support Live Support to the code deliverables after Deployment in Live Environment.

Environment: Oracle 11g, PL/SQL, TOAD, Oracle Forms, Oracle Designer Tools, Java, XML, Pro*C, SQL*Plus, Unix, Shell Scripts, ETL, SSH Secure Shell, Putty, FTP, DTS package, Edit Plus, Putty, BEA Weblogic, Linux and Windows.

Client: Marsh, Hoboken, NJ May 2010 to Feb 2012

Role: Sr. Oracle PL/SQL,PERL Consultant

Project: MARSH Migration

Marsh, the world's leading insurance broker and risk adviser, provides thought leadership and innovation for clients and the insurance industry. Project is a data migration project in which our team involved in migration from different source system to different destination system. This migration to different system based on various countries like USA, Europe, Hongkong etc. We have to modify the data based on the destination system’s format based on defined business logic.

Responsibilities:

Active team member in periodic providing analysis and development of the client’ Reporting requirements.

Involved in Creation of New Logical /Physical Data Model using Erwin.

Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents.

Establish deliverables and meeting Business and SME’s by ensuring timely and efficient completion of procedures and deployment packages for reporting purpose.

Coding and Implementation of modules required for migration of data.

Extensively used Dynamic SQL, PL/SQL Packages, Procedures and Database Triggers.

Created Global Temporary Tables in procedures to temporary data store for processes that are complicated to complete in a single pass.

Created and manipulated Stored Procedures, Triggers, Views, Functions and Packages and Created utilities for error reporting by using PLSQL stored procedures.

Database performance bottlenecks, performance tuining, SQL/Query optimization and provided support to developers during development and post-implementation cycles.

Developed Complex Business Logic using procedures, packages, triggers, function for programming. Used SQL* Loader to upload huge data from CSV file and Legacy database to Oracle 10g database.

Involved in designing database tables according to database Normalization techniques, created new tables, views, indexes for tuning.

Made use of DB LINKS for accessing data across different databases.

Writing Requirement analysis and specifications during design phase of SDLC and interacting with the client.

Participated in RCA (Root Cause Analysis) of tickets.

Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

Created the Shell and Perl Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.

Used FTP to transfer the files into different servers as per needed by the business users. Developed various programs using Native Dynamic SQL and REF CURSORS.

Worked with Oracle packages like UTL_FILE to open, read and write files to OS directories. Trouble shooting performance issues using Explain Plan and TKPROF.

Optimized and tuned PL/SQL subprograms to reduce the loading process.

Providing support Live Support to the code deliverables after Deployment in Live Environment.

Environment: Oracle 10g,, PERL, PL/SQL, TOAD, Java, XML, Pro*C, SQL*Plus, Shell Scripts, ETL, Toad 9.0, SSH Secure Shell, Erwin, Putty, FTP, DTS package, Edit Plus, Putty, BEA Weblogic, SCCS, Star team, Cruise Control, Linux and Windows.

BT Group plc, Belfast, Ireland, UK Jan 2009 to April 2010

Role: Sr. Oracle / PERL Principal

Project: Consumer Profile Management System

The objective of this project was maintenance and enhancement of a few databases for the BT’s broadband and BT’s openworld areas. Work on various possible performance-related issues including Database Tuning with the sole intention of achieving faster response times and better throughput. The enhancement was planned by importing a few tables from different databases (Billing & Profiles), modifying the existing table structure, creating necessary views and temporary tables and loading data in this database. Test data generation, integration testing support, project documentation, and deployment planning and deployment script creation and testing.

Responsibilities:

Analysis of Requirements, Preparation of Design Docs and Service Deployment Document.

Creation and maintenance of the application data model/ERD.

Application design, development and support for the Oracle 11g, PERL, PROC, XML and UNIX.

Application development utilized PL/SQL-External tables, Bulk Collections, Dynamic SQL, REF CURSORS, dbms_scheduler, Perl and UNIX scripts.

Used Partition Exchanging for optimizing and better performance of the stored procedures.

Actively involved in Query Level Performance Tuning by Analyzing tables, DBMS Profiler,

TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views, Dynamic

SQL, Oracle Optimizer Hints, partitioning tables and Indexes. Hints and Troubleshooting

Oracle database issues for better performance.

Handled the large amount of data with ease by using Partitions and Sub partitions.

Created Temporary Tables in procedure to achieve performance issuesUsed TOAD, PL/SQL developer tools for faster application design and developments.

Wrote complex SQL queries, Triggers, Procedures and Functions using oracle.Set up of the whole application on Test Server and Development Server after Source code validation.

Read data from flat files to oracle tables using SQL*loader.Developed Unix Shell scripts, AWK, SED.

Coding and Implementation of modules

Involved in writing Dynamic SQL, complex PLSQL procedures, database triggers and views.

Environment: Oracle 10g,, PERL, PL/SQL, TOAD, Java, XML, Pro*C, SQL*Plus, Shell Scripts, ETL, Toad 9.0, SSH Secure Shell, Erwin, Putty, FTP, DTS package, Edit Plus, Putty, BEA Weblogic, SCCS, Star team, Cruise Control, Linux and Windows.

BT Group plc, Ipswitch, UK Jan 2007 to Dec 2008

Role: Sr. Oracle / PERL Principal

Project: Billing System

BT Group plc (formerly known as British Telecom) BT Group is the largest communications service provider in the United Kingdom. BT has decided to introduce FTTC (Fiber To the cable) customer information’s in BBCR Wholesale. The scope of the this project comprises data capture from BBCR Wholesale in XML format from different wholesale reports for FTTC customer along with the existing customer .Then using ETL (Extract, Transform and Load) methodology, information being stored in database which latter used to generate Web Applications, which is extensively used by the BT’s mangers, Sales, Presales and other platforms to keep track of the all sorts customer impacts.

Responsibilities:

Analyzed business requirements to design Entity relational Diagrams (ERD) and prepared HLD and LLD documents including impact analysis, requirements traceability

matrix. Wrote DDL scripts for generating tables, views and indexes.

Developed PL/SQL procedures, functions, packages and triggers.

Prepared Unit Test Specifications and performed unit testing.

Worked on logical and physical data modeling and created Materialized views.

Implemented various query-optimization techniques - Performance tuning using indexes, explain plan, Hints).For better performance used EXPLAIN PLAN, HINTS to tune queries.

Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.

Maintenance of Scheduler and adding new jobs.

Converted Pro*C programs to PL/SQL procedures. Built packages for data storage and retrieval. Coding and Implementation of modules using Perl Scripting, PROC and PLSQL packages. Monitoring existing SQL code and performance tuning if necessary.

Created indexes for retrieving data quickly.

For better performance used EXPLAIN PLAN, HINTS to tune queries.

Created Temporary Tables in procedure to achieve performance issues.

SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.

Used TOAD, PL/SQL developer tools for faster application design and developments. Wrote complex SQL queries using joins and sub queries.

Set up of the whole application on Test Server and Development Server after Source code validation. Read data from flat files to oracle tables using SQL*loader.

Providing support Live Support to the code deliverables after Deployment in Live Environment.

Apart from this also assigning task to the team members and guiding them whenever required.

Environment: Oracle 10g database, PL/SQL, Perl, PROC, TOAD, AWR, ADDM, OLAP. OLTP, UNIX (SunOS 5.8), Edit Plus, PuTTy, BEA Web logic, SCCS, Star team, Cruise Control

ATOS ORIGIN India Ltd, Calcutta, India Aug 2004 to Dec 2006

Role: Sr. Oracle / PERL Principal

Project: Billing System

Business Configuration is the core of the BSCS, which contain all sort configurations, which are required for the BSCS Billing System. Grameen Phone, the Biggest IT Giant & the Biggest Telecom Operator of Bangladesh have taken this training for the product Business configuration for enhancement of their Performances.

The main objective is to provide quick resolutions to the problems raised by client in the baseline Software within the Service Level Agreements decide between Clients & ATOS. This resolution includes fixing of bugs, testing of changes as well as enhancement of the existing functionalities of the baseline software.

Responsibilities:

Coding and Implementation of modules by following the requirement document.

Participated in designing the Functional and System Requirements.

Created the Application Design Document.

Handled the large amount of data with ease by using Partitions and Sub partitions.

Wrote stored procedures, functions, sequences, indexes, triggers.

Used Partition Exchanging for optimizing and better performance of the stored procedures. Enhanced the performance of the procedures by creating suitable global and local indexes. Developed ETL tool using the Perl scripting and oracle.

Extract the XML files from a URL and necessary validation in XML files.

Transform the XML files into CSV files using SAX parser, TWIG parser and manually.

Loading the CSV files into database (Oracle 10g) tables using PL/SQL stored procedure and SQL*Loader. Monitoring existing SQL code and performance tuning if necessary, Created indexes for retrieving data quickly.

Written Procedures and Functions using oracle for different business logic.

Set up of the whole application on Test Server and Development Server after Source code validation.

Developed UNIX Shell scripts to schedule the Perl script and database stored procedures.

RCA, Problem Correction & Testing, review of the test cases and logs.

Release the code deliverables to e2e Support Team during Testing Phase.

Provided support Live Support to the code deliverables after Deployment in Live Environment.

Environment: Oracle 10g database, PL/SQL, Perl, PROC, TOAD, AWR, ADDM, OLAP. OLTP, UNIX (SunOS 5.8), Edit Plus, PuTTy, BEA Web logic, SCCS, Star team, Cruise Control

Contact this candidate