Oracle PL/SQL, OBIEE, Oracle forms, developer 2000/9i, UNIX, apache

Praveen Kumar Varaganti

* ****** **

Commack, NY 11725

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

mobile: 516-***-****

Professional Summary:

A Sr. Oracle database Developer, Data Analyst and production support professional with over 20 years of experience in Analysis, database design, modeling, development, data conversion, SQL loader, implementation, 24X7 Production support, system integration testing, database administration and OLTP.

Technical strengths include solid working knowledge of Unix, C, SQL server 2000/2005, Oracle 9i/10g/11g, SQL, PL/SQL, T- SQL, Developer 2000/ 6i/9i, UNIX Shell Scripting, SQL*Loader, Erwin, ASP dot Net, C#, Toad, SAS, BO Crystal Reports 7.0/8.0/9.0, Visual C++ 5.0/6.0, SQL Server BI, SSIS, SSMS, MS Access, Java /J2EE, JQuery, JavaScript, Business Objects XI, CVS, Rational Clear Case and Clear Quest.

Performance tuning, AWR report generation and analysis.

Possess government, medical, publishing, telecom, asset management, trade processing, fixed income, retail, email marketing, mortgage and financial industry experience.

Familiar with PRISM, JMS Queue, Web Services, XML, Big Data and Green Plum technologies. A team player with strong interpersonal skills, Fast learner and self-motivated, able to own the resolution of the problems from beginning to the end.

Strengths Include:

Database design, develop and automate ETL processes, SQL loading for customized data processing including Client-Server, Web technology, and CRM and ecommerce experience.

Interface with clients from different areas to understand and analyze current processes, business issues, and data and web challenges of client's organization and write functional requirements. Translate the functional requirement to technical design, code, implement, technical support and Reporting using Crystal report.

Developing, testing, deploying and supporting applications in a multi-tier environment using Cold Fusion, Java, and ASP.Net and C #.

Worked on both Agile-based methodologies (such as Extreme Programming and Scrum) and Waterfall methodologies for software development.

Application support in banking and fixed income environment.

Scheduling software such as Auto Sys, Appworx and Tivoli.

Issue tracking software such as Remedy, Daptiv solution tracker and ALM.

Work effectively with DBA teams to ensure that all approved development and deployment procedures are followed.

Provide production support from development teams for existing systems, troubleshoot data and/or system issues

Identify root causes and resolve data related issues, Review and optimize query performance.

Education:

M.S. – Computer Science, City University of New York, NY (02/1997)

B.E. – Electronics and Communication Engineering Chaitanya Bharathi Institute of Technology, OU, India (Minor: computer science)

Certification:

Learning Tree International, New York, NY

ASP.net

Visual C++

Oracle Developer 9i

Oracle 9i Application DBA

Oracle8i PL/SQL and Tuning

MS SQL Server 2005 DBA

Data warehouse Tools Informatica

Business Objects

Cognos

ASP dot net

Webfocus

Oracle 9i DBA

Java

Security Clearances:

Active Public Trust clearance for USPS client.

Secret clearance for DHS

VJ Info Tech pvt Ltd, India

DM Express

ETL tool training

Informatica

Professional Experience:

Database Designers and Systems Inc, NY 2010 - 2017

CSRA (CBP), Lorton, VA 07/16 – Present

Database Engineer/Production support

Responsibilities:

Design, develop, implement and maintain ADIS database for internal and external users/clients for customs and border protection agency using PL/SQL, Oracle 12c and UNIX. Large volumes of production data is being updated as part of development, heavy SQL*Load of large volumes of data into staging area for Data repairs.

Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.

Create Materialized Views and partitioning tables for performance reasons.

Worked on various backend Procedures and Functions using PL/SQL.

Data conversion from flat file to intermediate tables using SQL*Loader, and Data mapping

Created control files for SQL*Loader

Develop UNIX shell scripts to perform a nightly refresh of the test system from Production databases.

Create documents and implement standards and/or modeling to monitor and enhance the capacity and performance of the database. Also, develop data import and export routines to automate data loading in Agile Scrum process.

Perform analysis and review complex applications being released into production. Develop test application code in client server environments to ensure that software conforms to build management practices.

Develop back-up and recovery procedures and data archive/purge procedures.

Creates supporting technical documentation.

Provide leadership and work guidance to less experienced personnel.

Environment: Oracle 11g/12c Production version, Java /j2ee, IIS web server.

Tools: Toad, SQL developer, JIRA, UNIX, SFTP

Database Designers and Systems Inc., NY 2010 - 2016

Weight Watchers, NY 02’16 – 06’2016

Contractor, Sr. Oracle Developer Analyst

Responsibilities:

Design and develop ETL/SQL loader process for Canada to capture meeting reference and member data information for payroll process. Create staging tables; write packages using Oracle 11g and PL/SQL. Identify bad SQL and do explain plan and performance tuning.

External tables and heavy SQL loading functions using PL/SQL and shell scripts.

Architect, Configure and automate the entire batch process using sql/shell scripts and cron jobs in Linux environment. File encryption using gpg, file transfer using sftp/scp protocol. Collaborate with networking team and Canada team to fix configuration issues.

Environment: Linux, Oracle 11g Production version, ASP.Net, IIS web server.

Tools: Toad, DevOps JIRA, GIT, DevOps

Compusearch, Dullus, VA 06’15 – 01’16

Sr. Oracle Developer Analyst

Responsibilities:

Designed and developed Oracle Packages and SQL scripts for PRISM Suite in Agile environment. Prism is the contract writing system for defense, intelligence, and civilian agencies using Oracle 12c, ASP dot net and IIS web server in Agile process

Trained and certified in Prism application. Developed functionalities related to SSA Vendor management, General Page description, Audit workspace and Audit workspace Template. Unit/application tested several SCRs and found solutions to the issues

Designed and developed Oracle Packages and SQL scripts for BAM, Business acquisition management. Functionalities include Checklist, Checklist Routing, Attachment Routing, Follow, and Print Route History, Arc Market Survey/RFI and Widgets and dashboard reports using Crystal report. SQL load data for archiving data.

Database was upgraded from Oracle11g to Oracle12C, and converted BE objects in the current build using new features such as pluggable database (PDB) in a shared environment.

Environment: Oracle 11g/12c Production version, ASP.Net, ASP Classic, and IIS web server.

Tools: Visual Source safe, Toad, Foot prints issue tracking system.

Database Designers and Systems Inc, NY

CRGT End client: USPS, Chantilly, VA 09’12 – 06’15

Sr. Oracle Developer Analyst

Responsibilities:

Developed Informatica mappings to move data from stage to target tables for Accenture/USPS client during later part of my project.

As monitoring specialist, worked during second and night shifts to monitor and process production ETL Informatica work flows using power center with Admin role and as level 2 production support person.

Handled heavy volumes of data, batch jobs, cron jobs in UNIX and Oracle. Created manual procedures and provided status of daily jobs and maintained job schedules and fixed database deadlocks and improved performance as part of daily responsibilities. Created scripts for remedy tickets to reset and Kill jobs for required jobs to be completed on time.

After Deployment, Maintained schedules during Database upgrade from Oracle11g to 12c

Developed Oracle Packages and SQL scripts for incorporating rate changes for Postal One team. Made several enhancements to the system with ETRs, ECRs and Data repairs including performance and tuning of SQL. AWR report generation, read, analyzes and suggests required changes to the SQL and database.

Designed and Developed Packages for refunds of unused labels, pay transaction fees such as application and annual fees, finalize statements and send fee information via ftp/aft to government agency to fulfill SOX requirement using Java and Oracle PL/SQL.

Lead and implemented Projects for Financial Activity management and Interfaces divisions that include IME, CDM, CBCIS and RPW. Utilized SQL loader to load data from these systems, push pull methods to import and export data.

Provided financial activity management reports using Crystal report

Developed packages and scripts for incorporating rate changes for San Mateo PostalOne team for a January 2013/2014 release on srs-834/1006. Unit tested rate changes from back end. Responsible for Priority and Fist class mail form changes, Pre-D and post production scripts. Participated and contributed in design meetings and production deployment support. Utilized Oracle 11g, SQL scripts and SQL Developer.

Involved in Dashboard redesign project. Analyzed requirements, XML code, ColdFusion files, enhanced packages, created new views and suggested performance improvements and solutions to implement the dashboard redesign for future releases.

Developed packages and unit testing for supporting SRS 956 – CMAT Seamless Acceptance Enhancements. Involved in design meetings and contributed in writing Use cases for Recalculation CR. Performed development and Unit testing for recalculation of rates and total postage for First class, Standard, Periodical and Extra services.

Environment: Oracle 10g/11g Production version, Solaris 8.2, UNIX, windows 7

MBS INSIGHT/eBay, Melville, NY 12/11 – 09/12

Oracle Developer Analyst

Responsibilities:

Designed and developed Oracle packages and procedures for several clients to enhance existing functionality for direct mail and email marketing including ETL using DM Express tool, customized data processing using dynamic SQL, bulk processing, analytical functions and report build process.

Utilize Oracle 10g/11g, SQL scripts and Appworx to schedule jobs.

Handled large volumes of customer transaction data, control logic with Meta data, analytical functions and report build process. Performance issues, AWR report generation

Report generation using Crystal reports and BO.

Environment: Oracle 10g/11g Production version, Solaris 8.2, UNIX, windows 7, IIS, dot net

AVAYA, Arlington, Virginia 09’11 – 12’11

Oracle Developer Analyst

Responsibilities:

Developed interface between PostalOne! And FIWS systems which allowed PostalOne! To transmit end-to-end drop ship and origin entry content data collected from Mail.dat/Mail.XML to the FIWS system.

Utilized Oracle 10g, UNIX, SQL scripts. AWR report generation and fixed performance issues in pre-production environment.

Data is loaded using custom ETL/SQL load process. The interface between PostalOne! And FIWS was accomplished using MQ Series.

Fannie Mae, Virginia 04/10 – 08/11

Project Support/Oracle Developer Analyst

Responsibilities:

Involved in Data warehouse/ETL analysis and testing for Data quality program using Informatica developer, (IDQ) 9.0, Power Center Workflow Monitor/Manager and Repository Manager. SQL loaded data into Oracle Database.

Utilized UNIX, Perl script, SQL scripts and tested UNIT Test framework for testing data quality rules.

Coordinated with developers on code check-in and release management using Clear Case and Clear Quest. Also, work with system test personnel on defects and supported performance team on a 24X7 basis for pre-production activities as lead on duty. Utilized Remedy for issue tracking.

As a senior developer analyst, designed and developed Oracle packages and procedures for several builds for the HAMP (Home Affordable Modification Program) project including second lien cancellation and rules for unemployment program. Wrote functional specifications based on business requirement document, developed and unit tested packages for first lien, second lien (2MP), and servicer transfer rules using Oracle PL/SQL.

Created XML input files for batch processing.

Performed Unit tests, string tests and end-to-end tests for above modules using UNIX shell scripting and AutoSys.

Environment: Oracle 10g/11g Production version, SUN Solaris 8.2, UNIX, SUN Ultra Sparc – 2, Informatica Developer 9.0.1

INFOUSA - Yesmail, email marketing division, New York, NY 08’08 – 06’09

Lead Client Service Engineer/Project Lead

Responsibilities:

Tech lead for several projects for premier and select clients.

Data resource for several export/import projects for 25+ clients.

Custom ETL loading of user data into company’s database using Oracle sql scripts, shell scripts, push and pull data using UNIX and Oracle.

Created new project ID using Quick Arrow. Scoped and functional specked assigned resource to projects and managed multiple projects.

Scoped and wrote specifications for several projects related to email marketing and client business analysis and developed backend processes with SQL loader using Oracle 10g.

Tuned SQL and enhanced performance of several Oracle database clusters. File transfers from client’s ftp site to company’s internal ftp servers using UNIX Shell scripting. Provided 24X7 production supports on Oracle jobs and client ad hoc reporting requests.

Few Reports are done using Crystal report as a pilot project.

Environment: Oracle 9i/10g Production version, SQL server 2005, SUN Solaris 8.2, Windows XP, SUN Ultra Sparc - 2

Steve and Barry’s Inc, Port Washington, NY 09’07 – 07’08

Project Lead/Architect

Responsibilities:

Developed ETL Design and Package to Load the purchase order Data Mart in SQL Server 2005.

Developed data loading scripts using MS SQL server 2005 and T-SQL. Conducted performance tuning of the database and stored procedures.

Created scripts and scheduled jobs using MS SQL server 2005.

Generated ad hoc reports using Transact SQL and BO crystal Reports 8.2. Administered Business Objects.

Developed and automated ETL process using DTS and SSIS provided flat files such as master site data information for SAP BI system. Automated and scheduled several SQL jobs.

Performed as backup to SQL DBA. Performed all administrative functions including backup and restore of databases as well as development in SQL Server 2005.

Provided production support on daily and weekly SQL jobs including server maintenance.

Developed backend processes for GERS project using SQL, PL/SQL and Oracle 10G

Environment: Oracle 10G, SQL Server 2005, Windows NT 4.0 (Srv Pack 6.0), Compaq Proliant 3000 (ML530)

UBS, Stamford, CT 02’07 – 08’07

Consultant/Sr. Developer

Responsibilities:

Automated and developed process to generate US TREASURY bond and fixed income information from ETL batch.

Redesigned the search process and recommended data warehouse features of Oracle 9i. Rewrote CDR search tool process using table functions and materialized views. This process searches bond information with various search criteria using Oracle 10g /PLSQL.

Tuned several SQL queries, created and scheduled materialized views. Reviewed and certified peers work for implementation.

Brown Brothers Harriman, New York, NY 04’06 – 12’06

Consultant/Sr. Developer

Responsibilities:

Developed International portfolio loading (IPF) process using Oracle 9i, PL/SQL. Portfolios are currency stream of security purchases (inflows) and sales (outflows) that change over a period. International portfolio flows (IPFs) are streams of cross-national or cross-market purchases and sales. This project publishes PAH (Portfolio Asset Holding).

Worked with fixed income products such as Municipal bonds and corporate bonds.

Analyzed data partitioning algorithm and helped implement Oracle partitioning on Cash transaction tables. Tuned several objects and SQL and performed Partition pruning to improve SQL and database performance.

Designed and developed views in Oracle utilizing data warehouse functions to parse data from SQL server 2005 and load dimension tables.

Wider Than Americas, New York, NY 10’05 – 03’06

Consultant/Lead Developer

Responsibilities:

Developed and implemented SOA reconciliation process using Oracle PL/SQL and Shell scripting in Solaris UNIX and Oracle 8i. This process synchronizes data of five secondary servers with a primary server.

Developed routing test cases using Oracle 9i utilizing PL/SQL, packages and procedures.

Router lookup test tools can be divided into two kinds. PL/SQL and Java. PL/SQL tools test against all the interfaces router lookup packages provide. Java tests are written in JUnit test cases. There is a Java J2EE interface which calls the same router lookup procedures. JUnit tests are then built on top of that interface for regression testing.

Routing of Short Message service and routing messages from carrier to carrier. Porting telephone numbers across carriers using RTINFO tool, custom made to handle DML commands to implement in all servers.

First Data Merchant Service, Melville, NY 04’04 – 09’05

Lead Developer/Architect/Business Analyst

Responsibilities:

Developed addendum process to track and report addendum related adjustments for invoice division using Oracle Developer 9i and Oracle 8i. Provided support to business users for their monthly reporting activities and client service procedures.

Automated, scheduled and maintained several monthly recurring reports utilizing Oracle SQL and Shell scripts.

Automated Data processing system using VB 6.0. The system takes text files, parses data and loads into SQL Server 2000 database and generates reports using Crystal plug-in.

Lead Developer of metric system to keep track of data requests, prioritize requests and dashboard reporting using Visual basic for Access and Access database.

Created ad hoc reporting for internal clients like products, strategy management, CFO and handled data requests for both internal and external clients.

SYSTEMAX INC, Port Washington, NY 09’03 – 03’04

Oracle Developer

Responsibilities:

Maintained the website www.globalcomputer.com, on line catalog marketing web store for computer parts and office furniture. Production support to business users and third parties for data integration of products.

Responsible for writing PL/SQL, stored procedures, packages for order entry system. Utilized Oracle 9i as the back-end database and in Solaris UNIX environment. Filtered data for accuracy, tuned SQL and generated data feeds in text, CSV and xls format for partner sites such as Cnet.com, Nextag, Pricegrabber.com, Shopping.com, and Poin2Point.com as per their requirements. Generated Shell scripts and schedule scripts in cron and ftp for the output files to the client’s ftp sites.

Wrote stored procedures and triggers in Oracle PL/SQL, wrote shell scripts, scheduled and maintained cron jobs. Performed conversion of active contact Leads and addresses from global computer division to pcs division for email blast functionality. Created a form for data entry of contact information using VB 6.0.

VERIZON, Hempstead, NY 08’02 – 06’03

Oracle Developer/ Oracle Database Architect

Responsibilities:

Analyzed, designed, developed, implemented and tested a client-server system for the network operation system utilizing Oracle 9i, SQL scripts, Shell scripts, Oracle report writer 6i in AIX UNIX operating system.

Developed and implemented Intranet web reports utilizing Oracle * Report Writer 6i, Oracle 9i and PL/SQL in AIX UNIX and Perl. Reporting in webfocus and db2 environment.

Monitored and maintained the daily and weekly processes generated from cron.

Involved in planning decision support system, a data warehouse project from inception.

Generated a project report that consisted of recommendation for the hardware design from Developer / DBA’s perspective.

Database design for the decision support system for a half terabytes Data warehouse system. E-R diagram, Data Loading using Perl scripting and database migration from MS SQL server into Oracle 9i including stored objects. Utilized Web focus for reporting.

TD Waterhouse Data Service, Jersey City, NJ 01’02 – 06’02

Consultant /Oracle Developer

Responsibilities:

Analyzed, developed, implemented and tested a client-server system. This system identifies online customers with invalid email addresses and in turn, changes the delivery preference of confirmation of statements to a paper system.

Developed and QA tested the Revoke Consent process utilizing Oracle 8i and PL/SQL in Solaris UNIX.

Reporting packages were developed using PL/SQL, stored procedures, triggers and Crystal Reports interface.

To invoke the Revoke Consent process, scripts were developed in Unix Shell Scripting language inclusive of Korn and Bourne scripts.

Also, retrieved data from multiple databases with multi-streamed data.

Generated scripts (Oracle) for tables, packages, and triggers for implementation by the DBA. Optimized SQL queries, triggers and Oracle tuning for audit trail general system using TOAD & SQL Lab Vision.

First Data Merchant Service, Melville, NY 01’00 – 11’01

Senior Programmer

Responsibilities:

The Merchant Processing Application is written in PL/SQL stored procedures with all the business logic. Designed, developed, implemented and tested a client-server system.

Developed Logic “Site-id” for banks to achieve flexibility to the back-end system utilizing Oracle PL/SQL and enhanced Mobile Agent system-using SQL, PL/SQL stored procedures and triggers and VB 6.0, resulting in 15% increase in sales. Modified and enhanced web reports using ASP 2.0 and Java script.

Enhanced Mobile agent system using VB 6.0. The system has several handlers that parse merchant information and approval process.

Responsible for Oracle development for all projects including creation of new database instances for replicating test environment. Performed SQL tuning, server upgrade from Oracle version 7.3 to 8.0.

Wrote stored procedures and triggers using Oracle PL/SQL for $1M+ merchants.

G + J USA Publishing, New York, NY 01’98 – 11’99

Programmer Analyst

Responsibilities:

Responsible for design, development and implementation of editorial cost tracking system that kept track of the editorial Cost of a magazine in both NT and UNIX platforms.

Responsible for all aspects of project management.

Created comprehensive management reports like Aging and Write-off reports using SQL, PL/SQL and Crystal Reports 6.0 resulting in 30% savings to the company.

Project Lead for the editorial cost tracking system, front-end screen design, and code conversion from Centura SQL Gupta to Visual C++ 5.0. Managed and distributed tasks to the development team using MS Project.

Designed a relational database model for system using Oracle 7.3 database. Maintained and modified the system, resulting in a 25% savings in magazine distribution. Wrote stored procedures, packages and triggers

New York City Transit Authority Brooklyn, NY 06’94 – 12’97 and 08’96 – 12’97

Programmer/Staff Analyst II

Responsibilities:

Promoted to Staff Analyst Level-II.

Performed system-programming functions such as maintenance of system in PRO*C and Oracle and PL/SQL.

Trained Staff Analysts on ATC (Automated Traffic Clerking) system.

Developed integrated graphical user interfaces system used to generate reports and charts using Oracle Developer 2000, PL/SQL and stored procedures.

Staff Analyst I 07’95 – 08’96

Responsibilities:

Promoted to Staff Analyst Level- I.

Analyzed several surface point checks, ride checks, created and helped publish quarterly management reports in the daily newspapers. Debugged stored procedures using PL/SQL.

Staff Analyst Trainee 06’94 – 07’95

Responsibilities:

Involved in system testing of a Pro C program for measuring the surface On-time Performance and Regularity of

T.A Bus Service resulting in 50% data processing cost reduction.

Contact this candidate