Oracle Data

Srinivas

Phone: 678-***-**** *****@************.***

SUMMARY:

Over 12 years of wide ranging in requirement study, system analysis, software development including design, development, testing, implementation, maintenance and user training.

Strong ORACLE back end programming experience using Oracle11g, 10g, PL/SQL, Analytic Functions

Expert in Developer DBA experience, thorough understanding of AWR Reports and ASH Reports, tuning SQL queries using Hints, Cost Based Optimizer and Oracle application tuning using Explain Plan etc.

Worked in Pharma, telecom, financial services, production domain projects

Extensively worked on Oracle Virtual private Database

Worked on OLTP and Datawarehouse projects.

Worked with Oracle Dataguard for Physical and logical replication

AWS Certified Solutions Architect -- Associate

Worked from past 9 months on AWS Environment, creating and maintaining RDS Instances, S3 Buckets, EC2 Instances, backup and restoration of Database hosted on Cloud

Extensive Experience in Oracle Developer 6i (Forms 6i, Reports 6i, Graphics 6i), PL/SQL, Developer/2000 (Forms 4.5, Reports 2.5, Graphs 2.5)

Extensive experience in the customization and implementation of the AP module of Oracle Financials 10.7. Developed and integrated a custom module using Developer/2000 per Oracle Financials design standards and integrated the legacy system (AS/400) with Oracle Financials

Developed UNIX Shell scripts for automating backup and restoration, batch processing. Scheduled Cron jobs

Good knowledge of Oracle Architecture including SGA, various Oracle process, physical and logical structure of database, control files, user administration, roles, system and object privileges, tablespace creation, etc.

TECHNICAL SKILLS:

Software: Oracle 11g,10g, 9i, PL/SQL, AWS, PostgreSQL 9.5, Oracle Financials, XML, Pro*C, Developer Rel.6i (Forms6i, Reports6i, Graphics 6i), UNIX Shell scripts, Java Stored Procedures, EJB, OC4J, XML, XSL, UNIX Shell programming.

OS/Hardware: UNIX System V Release 4 on ICL DRS-6000, AIX, Sun Solaris, Windows.

PROFESSIONAL EXPERIENCE:

CBRE, Dallas, TX Jan 2018 - till date

Senior Data Engineer

Worked on Enterprise Data Platform. Information regarding various commercial properties (locations, rentable space, leases, property management, agents, landlords etc) is captured from various sources and processed in various stages like unified (combined from various sources(unified), trusted stage(golden source) and consumed by various applications and Datawarehouse. Created Data Models.

Responsibilities:

Developed stored procedures, complex SQL’s to extract data from Oracle source into staging, unified

and trusted layers.

Expert with advanced PL/SQL, using table functions, collections, global temporary tables

Used advanced SQL, analytic functions and subquery, collections, table functions, CTE (with clause)

Expert in Oracle database performance tuning using Explain Plan, identifying bottlenecks using the AWR and ASH Reports

Used Enterprise Manager to monitor and troubleshoot Database.

create and maintain PostgreSQL 9.5 database (RDS on AWS CLI)

RDS Database maintenance like adding space, changing computing capacity, download log files, create backup from EC2 instance.

creating data models for Applications

Monitor scripts for long running Queries on Database

Partition large tables

Version control using GIT

CICD process using TFS

Environment: Oracle 11g, PL/SQL, PostgreSQL 9.5, PL/pgSQL, linux.

Capital One, Dallas, TX Sep 2017 – Jan 2018

Principal Applications, Database

Worked on mortgage Originating Division. This project captures and process data right from user filling application, uploading required documents to funding the Loan. Database is hosted on AWS using RDS postgreSQL database.

Responsibilities:

Build PostgreSQL Database (AWS RDS service) for HE Pricing

Monitor PostgreSQL database using PGAdmin

Build PostgreSQL in Custom VPC and EC2 Instance, security groups and IAM roles and User groups

Creating S3 Buckets, providing access to move data in and out of S3 buckets

Create and Configure IAM roles to access S3 bucket to move DB backups

Used Github for version control

Build and support deployment packages for deployment using Jenkins

Environment: PostgreSQL 9.5, AWS, Linux

ADP, Parsippany, NJ Dec 2013 – Sep 2018

Principal Applications

Worked in WFN PayExpert Dev DBA Team from past 3.5 years. Worked with Oracle Database Application performance tuning of SQL’s/stored procedures for various Payroll screens and processing screens queried by end user. Designed and Developed business logic for Talent Performance module. Worked on Data Extraction Application related to Insurance ad Benefits data extraction for various vendors using generic templates. Worked on VPD databases building complex policies. Also worked with resolving production performance issues with benefits month end batch process, analyzing the problem, analyzing the data and provide solution to remove bottlenecks. Worked with monitoring and fine tuning of WFN6 and WFN7 connections jobs for large clients

Responsibilities:

Worked with Complex VPD Database

Identify and tune long running oracle database queries using AWR and Oracle Enterprise Manager in RAC Environment.

Partition large tables

query v$views to identify locks, killing contending sessions

Expert with advanced PL/SQL, using table functions, collections, global temporary tables

Used advanced SQL, analytic functions and subquery factoring for tuning Complex SQL’s

Used Native Dynamic SQL to build flexible to build conditional and variable SQL

Technical Documentation.

Collect and Interpret AWR Statistics

Debug Issues using ASH Reports

Worked with deployment team for releases and fixing production issues

Worked with testing team to resolve data issues and defects

Environment: Oracle 11g, 10g Rel 2, PL/SQL, SQL * Plus, Linix)

CitiGroup, Warren, NJ Mar 2013 – Nov 2013

Sr Oracle Consultant

Worked on Derived Elements Project and Genesis Finance Back Bone project.

Derived elements Project involves deriving attributes based on business logic based on available input values from Datamart and persisting them for further consumption by Universal Access Layer. Derived Attributes are calculated for Deposits, Loans and Derivatives.

Genesis Finance Back Bone project is a new system to retire legacy system. Involved in designing of ledger tables, EOD, weekly, summary ledger and designing schemas and privileges to hold the replicated data from source General ledger system (PeopleSoft). This replicated data is consumed by BO reports

Responsibilities:

Worked with very large Oracle data Applications, 30 million transactions per day per table

Identify and tune long running oracle database queries

Dataconversion of Subpartitions.

query v$views to identify locks, killing contending sessions

maintain application table privileges

Expert with advanced PL/SQL, using table functions, collections, global temporary tables

Worked extensively with PLSQL oracle packages and procedures to implement business logic

Used advanced SQL, analytic functions for calculating monghly averages, subquer factoring

Modeling and design of Tables for BO reporting from source system.

Used Native Dynamic SQL to build flexible to build conditional and variable SQL

Worked with SVN ( Source control software)

Deployed code to SIT, UAT and Production

Provided production support for derived elements project

Worked with deployment team for releases and fixing production issues

Worked with testing team to resolve data issues and defects

Environment: Oracle 11g, 10g Rel 2, PL/SQL, SQL * Plus, UNIX (sun solaris 9)

Albridge Solutions, an affiliate of Pershing Lawrenceville, NJ Mar 2011 – Feb 2013

Sr Oracle Developer

Worked on Albridge Wealth Reporting system, account holdings and portfolio reports, This application is a Web-based application that allows advisors, OSJs/managers and Broker Dealer home office personnel to view and report on clients' investment accounts that have been consolidated from among a number of different sources; such as brokerage accounts, mutual fund accounts, life insurance and annuity product companies. Worked recently on packaging and batch delivery of Performance Reports to End Clients JPMorgan, CitiBank, Schwab in various Formats including PDF and CSV

Responsibilities:

Worked with Business Analysts to understand business requirements

Created technical documentation, HLD and LLD documents with process flow and data flow diagrams.

Extensively used oracle packages and procedures to for processing and providing data to account holdings and portfolio reports

Used Native Dynamic SQL to build flexible to build conditional and variable SQL statements in common error/exception re-processing package

Used oracle table functions, collections, global temporary tables

Worked with SVN ( Source control software)

Worked with deployment team for releases and fixing production issues

Worked with Mercury bug tracking system

Coordination with testing team to resolve issue and fix bugs

Expert with oracle backend programming, written complex SQL's and analytic functions

Environment: Oracle 11g, 10g Rel 2, PL/SQL, SQL * Plus, UNIX (sun solaris 9)

JPMorgan Chase and Co, Whippany, NJ Jun 2010 – Mar 2011

Sr Oracle Developer

Worked in Operation Control workstation, this Application facilitates users to view and correct various Exceptions that are encountered during the feed processing into Geneva (new portfolio accounting system). After every daily feed reconciliation is made by comparing the extract from legacy portfolio accounting with extract from Geneva (new portfolio accounting system) to figure out any discrepancies. After correction of data, this application also allows for re-run of reconciliation process. In addition it also initiates Account conversion from legacy to Geneva system. In addition I am also involved in feature to show the detailed transaction that make up the totals for each accounts

Responsibilities:

Developed oracle packages and procedures to implement business logic

Used oracle varray's and nested, types, records

Used Oracle Dynamic SQL to start/suspend/monitor various batch process to allow end users to initiate re-processing after resolving data errors

Worked with Clearcase ( version control software)

Coordination with deployment team for smooth release of new features and production bugs

Created technical design documents and handed over DLD to offshore developers.

Worked with Mercury bug tracking system

Performed production support to analyze production issues.

Troubleshoot and provide solution Application SQL and Database performance Isues

Developed unix shell scripts to process data files and load into tables using sql*loader

Worked as Application DBA to track and resolve performance issues

Environment: Oracle 10g Rel 2, PL/SQL, SQL * Plus, UNIX (sun solaris 9)

Merrill Lynch, Pennington, NJ Feb 2010 – Jun 2010

Sr Oracle Developer

Working for Award Choice project in Retirement Group Technology. It's an Employee Equity compensation module, worked on new feature proration on termination and modification of transferability. Rule engine is setup for proration like rounding of shares, proration base line from (options grant date, last vest date, vest from date) etc, monthly, daily etc and the programs are developed to prorate shares and dividends for all grants for the optionee as per termination rule setup. Transferability are additional delivery options on top of vesting schedule. Transferability rules are set up like (staggered percentage of shares to be delivered on different tranches, special rules like lump sum shares upon termination etc)

Responsibilities:

Worked with Business Analysts to understand business requirements

Developed oracle packages and procedures to implement business logic

Used oracle collections

Worked with testing team to resolve issue and fix bugs

Very strong in SQL, used analytic functions

Environment: Oracle 10g Rel 2, PL/SQL, SQL * Plus, UNIX (sun solaris 9)

Novartis Pharmaceuticals, East Hanover, NJ Oct 2006 – Feb 2010

Systems Analyst and Project Lead

Integrated Relationship Marketing Application IRMA is a CRM application that helps to design, execute and evaluate performance of marketing campaigns for various prescription drugs made by Novartis. FDA approved production information and promotional offerings are advertised in print media and digital media. IRMA provides interfaces to acquire customers and execute the fulfillments via various vendors. The BI part evaluates performance of campaigns, the CRM part allows tracking of customer fulfillment as well as opt-out.

Responsibilities:

Worked with Business Analysts to understand business requirements

Covert Business requirements them into Technical specifications documents.

Developed database design for IRMA Database

Technical and user Documentation.

Database Physical and logical modelling using Erwin

Build QA and Development databases from production backups

creating tablespaces, adding datafiles, develop and maintain database backup and restore

Production monitoring free space table space and moving tables across tablespaces

creating roles and privilege management

Performed role of Application DBA, tuning and monitoring database

Developed Complex PLSQL packages and Procedures to load and process daily consumer enrollments, fulfillment and acknowledgement Feed

Refresh periodic QA and development database from production environment.

Performed Production support involving investigating and analyzing production issues and correct program and data.

Designed and developed common Error re-processing program

Used Oracle collections (nested tables) to return multiple records from functions to java clients

Designed and developed campaign Opt-out reconciliation scripts to consolidate opts between IRMA and fulfillment vendors

Used SQL*Loader to load Data in Text files send by external vendors

Expert in Performance tuning, tuned SQL statements in the PL/SQL scripts using Explain Plan. tkprof and hints

Used Unix Shell scripts to schedule batch Jobs for feed processing from external Vendors and dbms_jobs

Support QA to resolve development issues and adhere to Standards

Very strong in SQL, used analytic functions

Performed Producion deployments

Extensively used TOAD to debug and develop procedures, packages, functions

Environment: Oracle 10g Rel 2, PL/SQL, SQL * Plus, UNIX (sun solaris 9)

AT&T Middletown, NJ Jan, 2004 – Oct, 2006

Senior Data Analyst

Worked for Design and Development of Order Tracking System. Worked for both OLTP and Data Warehouse project. Extensively used PL/SQL for Extraction, Transportation and Loading of Data from External Systems to Data Warehouse

Responsibilities:

Worked on requirement gathering from Systems Engineering

Identifying data sources and data mapping for conversion from external system

Application Performance Tuning

Interact with functional experts to gather requirements for ongoing modification of the systems

Used Erwin to design logical and physical model and generate table ddls

Analyze and capture detailed specifications and requirements

Developed Star Schema's for Data Warehouse, worked with fact and dimension tables

Developed Flat File Loading Programs using PL/QL Programs and SQL Loader

Developed Database triggers, Packages, Procedures for Data Validation and Application Logic

Developed batch loading Programs using for bulk binding, bulk collect

Worked with Collections (nested tables, arrays) bulk collect and advanced features of PL/SQL DBMS_JOBS, Advanced Queues

Used Oracle table Partitions for large tables, Data exchange with exchange partitions

Built summary tables using asynchronous replication Oracle Advanced Queues

Created Materialized Views for data replication mechanism

Developed Shell scripts, and Cron Jobs in Unix for scheduling Jobs

Performed production code releases

Managed Oracle 9i Development and System test Database (adding datafiles, tablespace management, database cloning, granting privileges, roles, table, index creation, Database links etc)

Application DBA activities Complex query tuning (using explain plan, tkprof, enterprise manager), used hints for specifying Join Orders, access paths, Analyzing Tables

Performed requirement review with System Engineers

Environment: Oracle 9i Rel 2.0, PL/SQL, Toad, Oracle SQL * Plus, UNIX Shell Scripting.

Grey Advertising, NYC Apr 2003 Dec 2003

Senior Developer

Involved in the Development of Financial Management System for Grey Advertising. Developed PL/SQL packages, procedures, Database triggers for Backend Development. Also involved in developing Java Stored Procedures using Oracle 9i Release 2.0.

Responsibilities:

PL/SQL Programs were developed using parallel query, partitioned tables, Analytic

Functions. Queries were developed & Optimized using the TOAD.

Used External Tables for Data Loading

Used Global Temporary Tables.

Worked extensively on SQL Tuning and Reports Tuning. The SQL Tuning were done by analyzing the PLAN_TABLE Statistics from the EXPLAIN PLAN Utility. Used various Optimizer Hints to improve the SQL performance.

Deploying and Configuring EJB,s Servlets on Oracle 9ias( OC4J) Application Server

Developed various Complex Summary, master Detail Reports using Reports 6i.

Developed Java Stored Procedures.

Developed Test Pages using Java Server Pages

Developed Session EJB's for implanting Business Logic

Environment: Oracle 9i Rel 2.0, PL/SQL, Oracle Reports 6i, Oracle Report Server 6i, Toad, Java Stored Procedures, Java Server Pages, Oracle SQL * Plus, UNIX Shell Scripting.), Oracle 9ias (OC4J), EJB, Java Server Pages, Struts 1.1

UBS Paine Webber, NJ Oct 2002 – Mar 2003

Sr. Oracle Developer

An upgrade of the Oracle Data Warehouse for the Legal and Compliance Division of UBSPW was needed as well as migration of their reports to web-based Reports6i and development of new reports for their International Division. PL/SQL programs were developed to create dynamic query tables using the latest Oracle 8i features e.g., Parallel Query, Partitioned Tables and Analytic Functions. Queries were developed and optimized using dbArtisan 5.1 and performance Tuning

Responsibilities:

Used Global Temporary Tables to pass data for generating reports

Written several Procedures, Functions and Packages, database triggers using PL/SQL

Developed Unix Shell Scripts for batch processing and loading of data into Tables, Scheduled to run Weekly, Monthly or Bi-Monthly.

Report Triggers were extensively used for creating dynamic tables and dynamic queries using PL/SQL.

Interacted with the DBA in creation of Indexes for Query improvement.

Developed ad-hoc queries and reports using Oracle Discoverer 4.1 as a OLAP tool.

Reports were upgraded with different dynamic layouts suiting their Domestic and International divisions.

Utilized the latest features of Oracle 8i like the Parallel Query, Partitioned tables for

faster access of data from the Oracle Database.

Designed and developed reports using Oracle Reports6i from an Oracle Data warehouse. The reports were deployed in an Oracle Reports Server 6i under UNIX.

Interacted with the User for the Business requirements and designed the layout for the reports.

Setup and maintain Oracle Database Replication using Oracle dataguard.

Performance evaluation/diagnosis using AWR reports and production monitoring using OEM

Worked on VPD database design and implementation

Environment: Oracle 8.1.7 (8i), PL/SQL, Oracle Reports 6i, Oracle Report Server 6i, DBArtisan, Oracle Discoverer 4.01, Oracle SQL * Plus, UNIX Shell Scripting.)

Kinexus Inc., NYC Mar 2001 – Sep 2002

Senior Analyst/Developer

Project: Total Wealth Intelligence

Founded in 1994 as The Witan Group, Kinexus is the premier wealth information management services company that enables financial institutions to provide wealthy clients with a complete, consolidated picture of their net worth through a variety of new media channels. Kinexus' technology platform also links client financial data with a range of value-added decision-support and reporting capabilities, enabling clients to analyze and act on their information as never before, and giving our financial institution partners the very best tools to service premium customers

This client is a financial data processing organization. Kinexus takes raw data from financial institutions (Wachovia Bank & Merrill Lynch) and publishes it on the Internet. The process involves data extraction and transportation, report generation and loading to reports and respective websites. Reports are of two types, static html reports generated and loaded to a web site and dynamic reports that are interactive reports and can be drilled down

Responsibilities:

Developed Complex PL/SQL Scripts for loading data into reporting data mart using bulk Loads

Tuned SQL statements in the PL/SQL scripts using Explain Plan and Hints

Ensured that version control procedures were in place and maintained for all report changes

Scheduled Cron jobs to run batch process at scheduled times

Developed Packages, Procedures, functions for building business Logic and calculations

Used Invoker Rights feature to centralize the business logic and update various databases

Developed UNIX Shell scripts to run reports for batch processing, string manipulation etc.

Coordinated all modifications between Business Analysts and report developers

Monitored, prioritized and assigned QA report issues to the developers

Requested new report requirements and ensured that all information (report specifications) was being provided for developmentd

Defined the report specification process for changes/updates to all reports

Developed Java Servlets, XSLT scripts and XML files for an Internet based application

Used Reports 6i for conversion of HTML output reports to PDF output reports

Environment: Oracle 8.1.6.0, PL/SQL, Oracle Forms 6i, Reports, Pro*C, TOAD, Java, XML, Front End on Windows NT Workstation, UNIX, WINDOWS 2000

EDUCATION:

Contact this candidate