SUMMARY:

• A dedicated Information Technology Professional with over 20 years of Database Development and DBA experience (Oracle versions 7 to 12c).
• Proven ability to quickly learn and apply new technologies and translate client requirements into effective technical solutions.
• Full life cycle of the product development from the requirement gathering through design, development, QA to the rollout, operation, customer integration and support.
• Excellent written and verbal communications.
• Proven ability to model complex business scenarios, reorganize logical modules and synthesize solutions applicable to user environment, and comprehend abstract concepts.
• Adept at working on multiple applications and aggressive schedules/expectations with a track record of producing successful designs with on - time precise deliverables.
• High-energy, result-oriented with proven ability to manage multiple projects while generating significant system and profit improvements for clients.
• Worked with Companies in Pharmaceutical, Financial and Insurance Industries.
• Analyses and design of relational databases.
• Creation of Oracle stored procedures, triggers, function and packages.
• Implementation of Oracle database security.
• Technical project management of an Oracle database application (Front-end VB.NET).
• Extensive Data Management and ETL cross system and cross platform.
• SQL query optimization, PL/SQL and Java stored procedures.
• Expertise in replication technologies including GoldenGate, Streams, AQ and Materialized Views.
• Oracle R12 EBS Application Modules:- General Ledger (GL), Accounts Receivables (AR), Account Payables (AP), Sub-Ledger Application (SLA), Trade Management along with understanding of MOAC, Purchasing, Order Management, Inventory, Service Contracts.
• Solid experience in DW Concepts like Kimball Methodology, OLAP, OLTP, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin, MS Visio.

SOFTWARE AND APPLICATION:

Operating Systems: WinNT4.0, MSDOS, HP-UX11/10/9, Sun Solaris 9/8/7, SCO- UNIX, LINUX.

Relational DB Management Systems and Programming Languages: Oracle11g, Oracle10g, Oracle9i Rel 2 (9.2.0.1), Oracle9i (9.0.1.x), Oracle8i (8.1.7), Oracle7.x

Programming Languages: PL/SQL, SQL, Korn Shell Scripting, some Perl & Java, VB.NET, VB 6.0,Python 3.

Tools: Oracle SQL* Plus, Erwin, T.O.A.D, SQL Navigator, Pro C, D2KOracle Forms 10g, 9i, 6i, SAS v9, JDeveloper 10-11g, APEX, Oracle Designer, PL/SQL Developer, Maestro 1.4,WebFOCUS. Hive, Pig, Sqoop, OozieSpark.

Technologies: ETL architecture, Oracle Import/Export, Data Warehousing, Exadata X2, Oracle Warehouse Builder 11g (OWB), Goldengate, Informatica PowerCenter, Star Schema, Snowflake Schema, OLTP, SQL*Loader, DTS Package. Dimensional Data Modeling, Star Join Schema Modeling, FACT and Dimensions Tables. Big Data; Hadoop, Hbase MapReduce, HDFS, Cloudera.

Other: C, Awk, Sed, JavaScript, VBA, MS Access, Active X, DCOM, COM, ASP, HTML, ADO.NET, .NET Class Libraries, CVS-Version Control, JIRA, TFS, GIT.

EMPLOYMENT HISTORY:

Confidential, Jersey City, NJ

Senior Oracle Developer

Responsibilities:

• Developed complex PL/SQL stored procedures for collecting data for ratings, revenue and expense allocations from various upstream source systems and applying enrichment, deriving new attributes and aggregation and stored into target reporting database where end user consumed for various reporting methods like adhoc query, canned report, BO reporting tool and tableau tool.
• Improved performance of Complex procedures and Reporting Queries. Used partitioned tables and parallel processing for processing very large volume tables. Used various tools gather stats, Explain Plan, AWR report, SQL Plan baseline for performance tuning.
• Designed and implemented automated ETL process of FIG purged data into HAAS (Hadoop as a Service) environment in order to prevent weekly activities from being permanently deleted on current staging area. This application ships all the expired segments out of FIG and store it into HDFS.
• Developed reusable components in Unix shell scripts and Autosys for End to End workflow.
• Implemented Sqoop queries to import ABC weekly data to edge node and from there to HDFS, then after post load validation moving the final result to hive. Created the hive external tables and privacy views.
• As Oracle lead developer worked with FIG UI developers to maintain and enhance ABC system. Activity Based Costing (ABC) is the Confidential methodology for determining cost rates. The goal of the system is to assign a standard cost to each of the products and services offered by the bank. This is accomplished by creating, maintaining, and managing Cost Models.
• In Agile process, assisted as a scrum master role and conducted various Agile related meetings like product backlog, focus factor, sprint planning, capacity planning, Retrospectives and Team Working agreements.

Confidential, Princeton, NJ

Senior Oracle Specialist

Responsibilities:

• As a PoolStat database lead developer, provided application support and development to PS end users. Involved in loading the data files into the OLTP database. Working with the Data Quality group to streamline and bulletproof the SSL Rollout procedure and fleet management process. Responsible for code review, Database application performance tuning and coding standards.
• Developed and implemented project plans, roadmaps, networking, identified and defined scope, performed resourcing, business analysis, gap analysis, system analysis, database modeling. Implemented several processes for requirements gathering, testing, defect tracking, packaging and deploying. Devised standards for documentation, coding and testing.
• Implemented several data migration and consolidation projects. Managed production support while ensuring utmost uptime of the application. Automated the labor intensive process of reconciling EDI to TRAC receipt applications. Created a Data validation program to identify activity discrepancies between the received EDI advice and actual matched/posted invoice applications within the PoolStat module. Created output showing the discrepant advice lines as well as any other EDI transactions that related adjustments may have been received on.
• Performed tuning of Dashboards/Reports and made changes to PS database by implementing the materialized views, partitions, re-building of indexes.
• Designed and developed TPA (Third Party Automation process), that identifies the candidate moves and assigns corresponding accounts based on the container file loaded either through TRAC UI or EDI.
• Defined and created Oracle staging tables and created ETL data interface to import the SSL’s data into PoolStat environment. Created Oracle objects to utilize the SSL/MC billing routine to read selected/targeted container information from the staging tables and to automatically assign the billing information to the transactions in PoolStat.

Confidential, Bedminster, NJ

Data Manager

Responsibilities:

• Analyze patient longitudinal and physician sales data to provide ROI/promotional response analysis on various retail, marketing, compliance and persistence programs for chronic and seasonal therapies. Responsible for implementation and delivery of one-time and on-going client deliverables and pre-sales market analyses.
• Designed and developed ODS feeding the data warehouse. Maintained core entities framework, standards, and strategies. Responsible for designing Logical/Physical Data Models for 10 applications in the ODS and DW thru 4 major releases/2 new applications. Coordinated Business Object and Report Requirements.
• Created and maintain PL/SQL functions and procedures standalone and in packages for analysis around Managed care programs and rebate structures. Use dynamic sql, ref cursors, and bulk selects where appropriate to keep applications running efficiently.
• Created and maintain UNIX shell scripts for manipulating data, running jobs and emailing results.
• Responsible for troubleshooting and maintaining several customer applications. These run on weekly and monthly schedules. Errors need to be investigated and data and/or applications need to be fixed accordingly.
• Developed ETL Specifications. Project involvement: Requirement gathering, detailed design, validation. (MS Project, Oracle, Erwin). Designed the data stage migration methods for ETL. Defined the data standards and metadata conventions. Performed data profiling for data quality and validation.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Utilized DataStage Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Designed and developed LPD MOLAP using Oracle Warehouse Builder to populate the integrated repository with comprehensive payer claims, patient longitudinal, and prescriber level Rx data.
• Developed and Maintain PL/SQL code used to store and process SDI Longitudinal Patient-level data for Persistence and Compliance Analysis.

Confidential, Princeton, NJ

Senior Oracle Specialist

Responsibilities:

• As a Core Internal System’s database developer designed and implemented Data Transparency prototype.
• Provided drilldown capability on summaries of ARD (as-reported) data, to show breakdowns, formulas for derived values, and trace the provenance of data by opening and highlighting selections in the corporate filings. Designed and implemented auditing tools to verify data integrity.
• The project involved designing and implementing various optimizations to make the existing tools more efficient in time, memory and space.
• Built various programs using PL/SQL and KShell scripting.
• Analyzed requirements,
• Acted as interface with the client and handled all client communication activities
• Designed Security Issuance schema architecture.
• Supported and enhanced Fundamentals, Profiles and Document Management Schemas for data interchange between Confidential 's Global Data group and Equities Group.

Confidential, Titusville, NJ

Senior Oracle Specialist

Responsibilities:

• Converted NGPS profile data from logical design to physical design, defined data types, constraints, Indexes, created automated scripts, defined storage parameters for the objects in the Database.
• Analyzed IMS Data using IMS tools such as Xponent and Plantrak, regarding segmentation & profiling.
• Extensively used IMS Data components to get and send the encrypted data over the network.
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for VPIL Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Confidential, Oldwick, NJ

Senior Programmer/Analyst

Responsibilities:

• Designed and developed a Product, CR system enabling Data administration group to control and identify A.M .Best Company Numbers and the name of the entity to which they are assigned. Its purpose is to prevent the assignment of the same number to more than one entity.
• Rewrote Register Extract program using PL/SQL script. It is a subset of the fields from the CR system that is pulled nightly and deployed in a file on both the VN/CMS and MVS platforms for mainframe processing.
• As part of a team, worked with UI developers to maintain and enhance Best’s Publishing system. BPS is a system that was designed and constructed to control the content, both text and financial, of entities published in book and CD-ROM products and the web. It contains P/C, L/H, GFS and International book companies and supporting materials. System used Visual Basic, Access, oracle and Crystal Reports.
• Provided all necessary logical and physical data modeling DDL (SQL Data Definition Language) code to data architecture and database administration teams as required to develop and support the Sedgwick Retired data repository. Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers.
• Provided senior-level support to front-end VB programmers regarding all aspects of Oracle, SQL and PL/SQL. Wrote all views, PL/SQL functions, packages, triggers, procedures and anonymous blocks. Tuned inefficient report and view queries using combinations of index creation, alternate indexing strategies, join strategies, and session and query level optimization hints.
• As lead developer designed and developed an application to load the retired company data from Sedgwick files into an Oracle 9i database using PL/SQL scripts and SQL*Loader.
• As part of a team, designed and developed a Corporate Changes and Retirement application using Visual Basic .Net and Oracle 9i database. Created administrative security levels for different users, and wrote stored procedures to transform, reformat, and cleanup historical data. The application used by Rating Support Service area as a front end to manage the Corporate Changes database.
• As part of a team, redesigned and reworked the Print Preview system. This system uses a Data Extract process and is optimized for single Key ID (i.e. AMB Number/article number) processing.
• Supported and enhanced a variety of batch jobs that produce output for number of areas. The majority of the jobs including Company reports and BID Proofs were scheduled to run on a nightly basis.
• Designed financial application system to extract, format and summarize monthly and quarterly financial statements and deliver periodic data feeds to Confidential
• The Confidential feed process includes financial strength ratings(FSR),issuer credit ratings(ICR) and debt ratings that A.M.
• Best assigns to insurance organizations and their financial obligations.

Confidential, Whitehouse Station, NJ

Database Programmer-Analyst

Responsibilities:

• As a Knowledge-Repository system’s database lead developer, designed and developed a program, which loads on a daily basis a large amount of data (FTP from Ez-Buy System) into an Oracle database.
• Created a staging area to hold incoming Purchase Order data. Intricate data integration routines were written using in PL/SQL packages to trigger the integration of new data into K-R system.
• Designed and developed a PL/SQL package to generate a weekly extract of an Ez-Buy transaction records into JOTS (Job Order Tracking System).
• The program would perform filtering of data based on supplied criteria, and write an output to a flat file. This process was implemented on UNIX platform using Shell scripts scheduled by crontab.
• Oracle’s UTL FILE package was utilized to format and write the data in to a fixed length file.

Confidential, Neptune, NJ

Database Programmer-Analyst

Responsibilities:

• Designed and implemented a data migration procedure that which loaded a legacy -mainframe data to Oracle 8.0.5 database. Various business rules were applied thru VB application before loading the data into Oracle.
• Created and supported class-based project as ActiveX component to deal with Tape Exchange process. This application was used to enter and verify single premium credit s and the associated premium payments. It also verified the account master parameters and rates.
• Created various triggers using PL/SQL in order to catch account numbers with invalid data. All data manipulation was performed using Microsoft’s Active Data Objects 2.1 technology.
• Developed stored procedures to flag accounts that exceed Max benefit amount and to delete number criteria for suspense clearing.

Confidential, Newtown, PA

Programmer-Analyst

Responsibilities:

• Created and supported client-server applications. The order entry system was designed and developed using Microsoft Visual Basic 5.0 on a Windows NT platform.
• Designed a system of management reports using Visual Basic 5.0 and Crystal Reports. This system allowed for a wide range of user-defined options.
• Developed batch programs for daily and weekly purge processes using PL/SQL and Oracle Database.
• Designed and developed GUI based applications for database maintenance using stored procedures and triggers.
• Developed on-line error logging and reporting system using MS Access and Crystal Reports.
• Performed software installations and configuration of MS Windows NT 4.0 server for an in house application development. Installed and created Oracle 8.0.3 database on the above mentioned server. Implemented Oracle operating system backup on Windows NT server using Oracle backup manager.
• Created several modules, as a member of a team in a project for an in-house application.
• The modules contained batch data access applications that were designed to maintain data processing operations for the main office of the company.
• This office specialized in sales of products through a network of stores in different areas.
• The application provided an ability to enter and edit physician information and included a system to track the information about products and their types, stores and their locations, in order to get employee data, ratings and reviews .
• The project was successfully used to analyze store transactions and check them for errors and to correct the errors.