Sql Oracle

RITIKA MALIK

• SENIOR ORACLE INFORMATICA DEVELOPER

•

Summary:

Result oriented professional offering 6+ Years of experience in Application and Decision Support

•

Systems Analysis, Design, Development, Enhancement, Production Support, Testing and

Implementation using Oracle and Powercenter.

Excellent knowledge of Oracle Database Architecture, physical logical data structures, SGA, PGA,

•

redo log files, background process etc.

Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, joins and

•

hash indexes in databases.

• Hands on experience on writing Oracle scripts using TOAD.

• Extensively worked with Informatica to export and load data to/from different source systems

including flat files.

Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, SQL Server.

•

Good exposure in functionalities like Tables, cursors, Stored Procedures, Functions, Packages,

•

triggers, Indexes, Materialized views and advanced PL/SQL constructs like Oracle supplied

packages, Nested tables, Records, Types, Dynamic SQL and Analytical Functions.

Proficient in performance analysis, monitoring and SQL query tuning, reduction of response time,

•

while designing scalable applications from scratch using EXPLAIN PLAN, Collect Statistics, Hints

and SQL Trace in Oracle.

Worked with tools like TKPROF, Trace and spool file in Oracle.

•

• Good experience in ETL Tools like Informatica on implementing mappings and workflows and Data

Validation option

• Very good knowledge in Unix Shell scripting using awk,sed,grep etc

• Well versed with all stages of Software Development Life Cycle (SDLC) and Agile methodology i.e.

Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing and Informatica

ILM

Provided user training and interacted with Clients to understand the business flow.

•

Involved in creating Unit test and high/low level documents like design and functional specifications.

•

An Experienced team player/leader who can excel under pressure in deadline driven environment.

•

Very good in Fast learning, Analytical thinking, decision making and problem solving skills.

•

Technical Skills:

Languages : SQL, PL/SQL, SQL Server

Database : Oracle 9i, Oracle 10g, Oracle 11g, DB2, SQL Server 2008

Operating System : Windows XP/2000/NT, UNIX, Sun Solaris, MAC

Tools :Toad, PL/SQL Developer, SQL Developer, SQL Plus, Performance Tuning,Dyanamic

SQL,SQL Server, SQL Loader, TKPROOF, Informatica 7, 8.6, 9, CVS, SVN, Lotus

Notes, Microsoft Office, Microsoft Access, Perl, KSH,C,C++, Ultra Edit, Text Edit,

Text pad, SQL Loader, JIRA bug reporting, Secure Shell (SSH Shell) for Unix,

Putty

Other skills : Crontab, Perl, DBI/DBD, CGI, DB2, HTML, iReport version. 3.7.0,

JSPOOL, SQL*Plus, CVS, XML, CSS, EclipseWTW, SDLC

Qualification : Rochester Institute of Technology (RIT), Rochester, New York

Master of Science in Telecommunications Engineering May 2010

B.Tech in Electronics & Communication, May 2004, PTU, India

PROFESSIONAL EXPERIENCE

SWISS RE, Armonk, NY May 2013 – Current

Oracle Developer

Claims DI Migration

This project is to facilitate the conversion of Bulk Claims System DI Claims data into Claims Manager

Claims. Claims data will be obtained from the claims files, crosswalk tables and supplementary feeds

provided by business. Life index, policy and treaty cross walk will be required for Claims conversion.

Claims Manager Migration aims at migrating the Claims part of BoF into the new Claims Manager

system.

Responsibilities

Involved in technical documentation,analysis,design and development for the migration

Responsible for creating and maintaining test scripts, test cases in Oracle

Involved in the project development using agile development methodology in migration

Worked on creating several technical documents specifying the test approach to be followed

throughout the migration project

Provided weekly,bi weekly and monthly status reports to the off shore team members on a

regular basis

Responsible for providing training and holding sessions for the onsite and off shore team

members

Responsible for developing, testing and maintaining test scripts across different environments

using Oracle

Responsible for Link Testing and UAT in the database schemas for the migration

Worked on fine tuning the test scripts for the BOF to CLA project using optimizer hints taking into

account the elapsed time

Responsible for executing the test scripts in various environments and fixing the issues

encountered

Involved in reconciliation to ensure that the financial data items remain the same

Responsible for carrying out unit testing, system testing and UAT across different environments

Environment Oracle 10g, Oracle 11g,UNIX, PL/SQL, SQL, Informatica, SQL*Plus, SQL*Loader, UAT

:

testing

SWISS RE, Armonk, NY

Oracle Informatica Developer August 2012 – April 2013

RM(Risk Management) – FRP(Financial Risk Platform)

The RM FRP (Financial Risk platform) project is to implement an integrated market and credit risk

solution for the Swiss Re users. FRP replaces the core Market Risk functionality of the existing system

(RDB) with advancement on the current framework.

Responsibilities

Involved in requirement gathering, analysis, design and development

Worked with SQL Server for creating tables, views as per the requirement

Worked on Informatica and carried out several Powercenter jobs

Responsible for creating and maintaining procedures, packages, functions, triggers in Oracle

Worked largely with Informatica to create mappings, workflows using ETL

Responsible for running the batch on a daily basis and diagnosing and/or correcting the errors

Worked on creating several user defined functions in Informatica

Worked on loading XML files into database tables as per the requirements

Worked on fine tuning the various workflows using partitions in Informatica

Worked on creating XML files and loading them with Flat File

Involved in developing code, testing and deploying in different environments

Responsible for Link Testing and UAT in the database schemas

Environment TOAD,Oracle 10g,Oracle 11g,PL/SQL, SQL, SQL Server,

:

Powercenter Informatica, XML, SQL*Plus, SQL*Loader, UAT testing, Batch processing, UNIX

SWISS RE, Armonk, NY Feb 2012 – Aug 2012

Oracle PL/SQL Developer

L&H FiRe BoF to CLA

This was part of the Swiss Re Finance Re engineering (FiRe) projects to extract relevant data from Swiss

Re Life & Health (L&H) reinsurance platforms (BoF) and make it available to CLA. CLA is the common

landing area for all Swiss Re source systems to load their financials and contract data for downstream

strategic data warehouses (Legal Financial Data – LFD and Client Markets – CMP). The initiative was

driven in phases for the L&H UK, US and Canada region.

Responsibilities

Involved in analysis, design and development activities

Worked with Oracle for creating procedures, packages, functions, triggers

Responsible for writing PL/SQL queries to analyze the data

Involved in design documentation and creating various documents like test cases, Solution

Approach Documents, BOF to CLA design document and Application Support Group (ASG)

troubleshooting guide

Optimized performance tuning on Oracle PL/SQL for web application database

Worked on fine tuning the test scripts for the BOF to CLA project using optimizer hints taking into

account the elapsed time

Responsible for executing the test scripts in various environments and fixing the issues

encountered

Worked on the BOF to CLA application involving various schemas for replicating the databases

Worked with CVS using it as a code repository

Responsible for testing the CLA replica job as part of the removal of Oracle Replication Process

Worked on different CLA views and made changes as per the new Business Requests

Involved in developing code and testing the same in different environments

Responsible for Link Testing, System Testing and UAT in the database schemas

Worked on data integrity to make sure the data passed onto the downstream systems CMP and

LFD is legitimate

Worked on Informatica and carried out several Powercenter jobs and analyzed/ fixed the errors in

various domains

Created several mappings and transformations in Informatica depending upon the business logic

Environment Oracle, UNIX, PL/SQL, SQL, SQL*Plus, SQL*Loader, UAT, Informatica, SQL Server,KSH

:

Morgan Stanley, New York, NY Apr 2011 – Oct 2011

Programmer Analyst

Enterprise Handover Tool

The core functionality of this tool is the reporting module that provides reports for all the existing teams

including Unixops, Enterprise Infrastructure and Interfaces teams. Generating Perl/CGI reports based on

the requirements is the major task carried out by this module. System generated reports as well as

reports generated by the user can be accessed. The user can generate reports based on if it is a

weekday or weekend report, frequency of running the report, handed over or escalated reports, the

number of transfers etc. The report is saved in pdf file format and usually, there is a web based program

that generates reports in either html or comma separated format.

Responsibilities

Responsible for primary database creation writing indexing and triggers on Oracle database

Scripted in PL/SQL and Oracle SQL to migrate and manage databases

Responsible for requirement gathering from the Unixops team and the portal users

Created, developed applications using Oracle as back end with expertise in designing Oracle

PL/SQL packages and procedures

Involved in requirement analysis, design and design documentation

Responsible for writing Oracle PL/SQL queries to analyze data integrity

Analyzed various Unix work flows in the EC service catalog and then automated them via Perl or

a Run Book Automation tool (BMC Orchestra)

Used SQL*Plus for interactive user interface to Oracle database

Worked closely with the Unixops team and the ECPortal (web user request tool) team

Participated in the backup and recovery of Oracle database

Programmed CGI scripts in Perl to process client requests on the server

Developed packages using Oracle PL/SQL to access data from the database and write into and

extract from flat files using SQL* LOADER utility

Provided Performance Tuning in production environment

Supported and deployed application in test and production environments

Provided technical support on issues arise after deployment to Production

Environment Oracle, Perl, UNIX, PL/SQL, SQL, KSH, CGI,SQL*Plus, SQL*Loader, UAT, Production

:

Commerce Insurance, Webster, MA Oct 2010 – March 2011

Oracle PL/SQL Developer

TronWeb Insurance System

This project is designed for use by the MAPFRE agents in over 16 countries with the base TronWeb

system designed and managed by MAPFRE Soft in Madrid. TronWeb is Mapfre's core insurance

processing system, which enhances the insurance processing by leveraging technology through a single

enterprise wide system solution, supporting consistent quoting, binding, payment, claims and processing

quality. The initial system release which happened in Nov 2010 was for the agents in California and

additional state roll outs are scheduled for future releases. The new agent front end system is designed to

move agents quickly through the policy quote and bind process and provide policy, claims and billing

inquiry capability.

Responsibilities:

Reviewed requirements as provided by business analysts and determined database requirements

based on data needed

Designed, developed database intensive rule based applications using Oracle PL/SQL

Wrote Oracle PL/SQL queries to analyze data integrity

Wrote Unix shell scripts to automate manual processes

Assisted in recording batch job information for ROBOT scheduler setup

Wrote feed handlers using Perl DBI to update an Oracle database

Worked on Performance tuning of SQL using Joins and data distribution

Worked on Oracle for data collection and document storage and retrieval

Developed, tested and optimized Oracle queries and PL/SQL code for the migration of large

datasets

Worked on the development set up process in the TronWeb Database and created a suite of

source members

Used Oracle PL/SQL dynamic procedures during package creation

Developed PL/SQL Performance Tuning by implementing Table Partition and Creating

appropriate indexes

Oracle PL/SQL queries and stored procedures for inserting and retrieving data

Used SQL*Loader can be loaded from any text file and inserted into the database

Created PL/SQL scripts for data updates within Oracle databases

Responsible for promoting SQL scripts via CVS for installation into Integrated environment

Used advanced Oracle PL/SQL techniques like cursors for data retrieval

Used PL/SQL and SQL*Plus programming to write stored procedures, queries, triggers, objects,

and views on normalized database tables

Responsible for performance tuned in Oracle SQL queries using the parallel query feature,

indexes, and processor hints

Worked with JSPOOL the front end interface for the TronWeb application

Environment: Oracle, PL/SQL, iReport version. 3.7.0, Perl, JSPOOL, SQL*Plus, CVS, XML,

EclipseWTW, SQL*Loader, UAT, ROBOT scheduler

Shen Milsom Wilke, New York, NY Aug 2009 – Mar 2010

Associate Consultant

Project Management Tool

This is web based tool for managing projects by maintaining different activities, resources and their

scheduled start and end times, related to the project. This tool was used for audit purposes to track the

time and money on each project in the firm. This tool can also export the information on a project in the

form of excel sheet used by the managers to schedule a deadline for the project development.

Responsibilities:

Provided Oracle PL/SQL script support for production database upgrade/change

Developed SQL Scripts and stored procedures to manipulate and query data

Programmed stored Oracle PL/SQL procedures for processing and analyzing raw data

Involved in creating new databases, performance tuning and partitioning tables on multiple

versions of Oracle

Produced detailed budgets for all elements of project building and backend for the various

ongoing projects

Involved in detailed study of various projects to assure a quality product pertaining to budget and

technology

Optimized the SQL components to meet the increasing data volume

Actively involved in Systems coordination, specification writing, CAD/drafting and field work

related to Orange Regional Medical Center.

Reviewed submittals and co ordinated with colleagues for multidiscipline projects such as the

Joint Operations Centre (JOC).

Designed and developed database intensive, rule based applications using Oracle PL/SQL

Used SQL*Loader program to move data from external files into tables

Designed and coded Oracle PL/SQL stored procedures and functions to handle business logic

Used SQL queries to test the migrated database for back end testing

Used SQL*Plus to execute PL/SQL programs, procedures and packages

Involved in database changes and coding in Oracle PL/SQL

Responsible for performance tuning activities in Oracle

Worked extensively on the Oracle for data collection and document storage and retrieval

Ensured effective and timely resolution and communications to the user during the production

support

Environment: Oracle, PL/SQL, Perl, UNIX, SQL*Loader, Korn, SQL, Cron tab, SQL*Plus, CAD

Department of Environmental Services, Rochester, NY July 2008–July 2009

Seasonal Engineering Aide

Securities Services System

Investor related branch operations and services functions are handled by this application. Customer

service, account services, investor purchasing, funds transfer and payment operations are some of the

services handled by this application.

Responsibilities:

Performed requirement collection, analysis and design documentation

Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables

Developed mappings for batch job processing

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

requirements

Developed Unix shell scripts to perform a variety of application related tasks

Developed SQL and PL/SQL scripts to retrieval data from Oracle database

Created flat files with SQL*Plus from Oracle tables in Unix environment

Developed and performance tuning Oracle PL/SQL, packages, procedures, functions, and

triggers

Developed SQL*Loader scripts, Oracle triggers and stored procedures

Designed, implemented and managed Oracle databases

Used Oracle PL/SQL for generating database objects especially database Triggers, Stored

Procedures and Functions

Developed, implemented and performance tuning to Oracle applications

Developed numerous scripts to test different functional aspects of SQL

Used Oracle PL/SQL and the Oracle web application server platform

Supported the application during production hours

Implemented supporting documentation of new products and services delivered to our internal

customers

Environment Oracle, SQL, SQL*Plus, UNIX, SQL*Loader, PL/SQL, Crontab, SQL Server, Informatica

:

Educational Technology Centre (ETC) RIT, Rochester,NY Mar 2008 Jun 2008

Intern Developer

University Management System

This project is responsible for providing Multimedia presentations, captioning, streaming video, website

updates and managing university database management system

Assisted in studio and remote productions, analog and digital media (CD/DVD) duplication,

satellite downlinks, RIT cable system.

Provided assistance in computer interfacing, system calibration, video/audio signal evaluation.

Reviewed the requirements as provided by the analyst and determined database requirements

based on data needed

Created PL/SQL scripts for data updates within Oracle databases

Involved in source code version control and committing objects using CVS.

Involved in testing and troubleshooting the defects

Assisted in studio and remote productions, analog and digital media (CD/DVD)

duplication, satellite downlinks, RIT cable system.

Environment Oracle, SQL, SQL*Plus, UNIX,SQL*Loader, PL/SQL, Crontab, SQL Server

:

Bharti Airtel Ltd, New Delhi, India Oct 2005 Aug 2006

Network Analyst

Network Operations Centre System

NOCs are implemented by business organizations, public utilities, universities, and government

agencies that oversee complex networking environments that require little to no downtime. NOC

personnel are responsible for monitoring one or many networks for certain conditions that may require

special attention to avoid degraded service. Organizations may operate more than one NOC, either to

manage different networks or to provide geographic redundancy in the event of one site becoming

unavailable.

In addition to monitoring internal and external networks of related infrastructure, NOCs can monitor social

networks to get a head start on disruptive events

Responsibilities:

Managed Solaris based Juniper servers including ERX, SDX, RADIUS and LDAP.

Ensured that the performance of various ADSL routers was adequate.

Monitored the various sites and areas using the Airtel broadband connection.

Prepared SOPs for NOC activities for use by the higher management as reference manuals.

Involved in dimensioning and optimization of trunks and links based on traffic analysis

Monitoring internal and external networks of related infrastructure

Analyzing problems, performing troubleshooting, communicating with site technicians and other

NOCs, and tracking problems through resolution

O&M provisioning of DNS and RADIUS

Supported the system during off hours

Fixed bugs and supported the application during production

Involved with network monitoring, incident response, communications management and reporting

Escalated the issues in a hierarchic manner to tier 3 and tier 4 personnel for timely resolution

Environment: Networking, UNIX, IP Protocols, Crontab, TCP/IP, LDAP, DNS

HCL BPO Technologies, Noida, India May 2004 to Oct 2005

Technical Support Officer

Provided technical support over the phone to the DSL customers of SBC Yahoo

Supervised quality control and trained the call center operators and audited their calls

Diagnosed fault related cases by effectively utilizing software diagnostics

Co ordinated with the necessary Equant departments thereby achieving fault resolution

Fixed bugs and supported the application during production

Provided IPVPN service support all around the globe on 24*7 basis

Contact this candidate