Shikher Saxena

Phone # 732-***-**** ***** Email: acuq40@r.postjobfree.com

Profile Summary

Passionate, result oriented and collaborative individual having over 8 years of experience in software industry as Oracle Developer (application design, development, performance tuning and problem troubleshooting) in OLTP and OLAP environments with roles as Tech lead, onsite coordinator and release owner .Worked comprehensively in all phases of SDLC using WATERFALL and AGILE methodologies.

Technical Skills

Oracle PL/SQL development & concepts:

Good knowledge of RDBMS concepts OLTP & OLAP

Data Modeling.

Develop packages, procedures and functions.

Create Index, DB links, synonyms and views.

Create triggers for auditing.

Extensively used object types, oracle collections, records, cursors and ref cursors.

Utilized flashback feature.

Develop JSON and XML file using standard & 3rd party packages to integrate with Java app.

Conversion of data types using CAST and MULTISET functions.

Data migration.

Followed standardized exception handling practices using Pragma autonomous transactions.

Created partitions on tables.

ETL using Oracle utilities like SQL*Loader & EXPDP/IMPDP data pump.

Transformations using update, merge and multitable inserts.

Design and Develop OLAP queries, extensively used Analytic and aggregate functions.

Performance tuning and optimizations:

Extensively used Bulk collect, forall, Result cache features and global temporary tables.

Analyze explain plan.

Worked with DBA to generate AWR reports and analyze.

Extensively Used dbms_profiler package to identify performance bottleneck.

Find locks and waits by querying data dictionaries.

Create index and partitions.

UNIX

Maintain and enhance existing Pro*C and PERL based applications.

Developed KSH scripts for deployment.

Generate Unix job email alerts using mails command

Extensively used UNIX utilities like ssh, awk, grep, crontab.

Others

Developed ETL project in Informatica, extracting data from excel file transforming using lookup strategy and Loading the data into database table.

Created DB API integrating it with Groovy and Grails based application.

Create Implementation plans and deploy applications to QA and Production environments.

Actively interacted with product owners for requirement clarification ensuing risk mitigation.

Worked in collaboration with QA team in creating and validating the Test Cases.

Assist ADM and product owner in implementing AGILE within the team.

Tools/Utilities/Environments

Operating System:

Windows, UNIX, LINUX

Languages:

SQL, PL/SQL, UNIX Shell Programming, Pro*C, XML,HTML

RDBMS:

Oracle 9i/10g/11g/12c

Tools & Utilities:

TOAD,SQLDeveloper,Putty,FSecure,ErwinDataModeller,PVCS,GIT, Hudson,Dimensions,PULSE,MSVisio, Rally, Control-M, UFT

Professional Experience

national board of medical EXAMINERS (NBME) Philadelphia, pa Aug2015-Current Oracle Consultant - Development

NBME serves medical associates through its high quality assessments of healthcare professionals. It develops and manages Unites States Medical Licensing Examination (USMLE) .All its applications are supported by huge Oracle based OLAP & OLTP database system containing medical data.

Key Projects Accomplished:

Candidate Web Enhancement – Project to enhance the layout of the existing NBME candidate website. The new UI implementation using AngularJs and Bootstrap frameworks integrated with REST and DAO service calling the DB PL/SQL API to fetch the data.

Action List: Developed PL/SQL based algorithm to identify all the actions student is eligible and limit the number of action lists real time to be displayed during the candidate website login.

Display Exam details: Developed package to fetch information of all exams of candidate and return them to the DAO services, Developed function to create Json structure for exam data. Developed Triggers and performance tuned the code .

Registration Credit UI Enhancement - Enhanced Delphi and PL/SQL based application. Added feature to refund multiple fees to a candidate. Developed function to fetch the account information from the journal entry system and calculate the refund amount.

CIBIS Search Enhancement - Enhanced existing PL/SQL based search algorithm for identifying a candidate in database based on the search parameters passed by the candidate on the website. Created functions to add additional combination of search parameters, tables and added index for faster retrieval.

SYNAPSE GROUP (A TIME INC COMPANY), STAMFORD, CT May2012-June2015 Oracle Developer/Onsite Lead

Synapse is the subsidiary company of Time Inc. It engages more than 138 million U.S. consumers in print, online & mobile devices each month with influential brands such as Time, People, Sports Illustrated, Instyle and Real Simple, supporting applications with oracle OLTP and OLAP database.

Key Projects Accomplished:

Magazine billing process - As part of the platform revamp initiative to move from legacy XML, batch process based billing system to events based,real time billing system utilizing JSON documents and integrating database with Grails & Groovy application. Designed multi-threading supported DB process. Developed procedure to extract customer billing information as a JSON document and post to events table. Developed function to fetch encrypted credit card token via java based web service using url and http package.

Customer care apps revamp - Move from legacy VB based customer care apps into Sales force app integrated with elastic search and Java grails based applications making DB calls. Designed & developed DB data extraction process called by Grails app to upload documents into Elastic search engine. Designed & developed data fetch process called by Web service to be integrated with Salesforce service, optimized to adhere salesforce performance guidelines.

Flexible Billing process - Translated complex business billing-enhancement requirements into a

PL/SQL based application enabling business to offer flexible billing options to the customers, providing them access to new market areas. Developed procedures and functions for billing package integrating them with the Java based order entry system.

Single product combo/Bundles - Enhanced packages and integrated it with the existing Pro*C based application providing customers an optimized payment and risk free subscription experience. Extensively used CURSORS and CONNECT BY condition to fetch hierarchical data from the tables.

Deferred Income Data Warehouse - Created DWH for business reporting based on the OLTP source. Developed PL/SQL based ETL process fetching data from OLTP via remote synonyms into referential and data warehouse environments and aggregate transforming into DataMart, which is the source for reporting.

WELLPOINT INC, CT Nov2010-Apr2012 Developer

Anthem Inc. (formerly WellPoint) is one of the largest health benefits companies in the US. Through its affiliated health plans, its companies deliver a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.

Key Projects Accomplished:

Address cleansing - USPS address cleansing application provides the latest and formatted address for a given name and address .Designed and Developed data loading algorithm extracting unique name and address for new orders daily .Created procedure called by unix script extracting data and creating pipe delimited file .Utilized SQL loader utility to extract data from USPS provided response file and loading the response into database.

Order depot – Remodeled the Order entry system, developed package to accept new orders, validate and post them into transactional database. Implemented complex validation logic in the procedure taking Oracle Object TYPE as input, returning appropriate reject codes for rejected transactions, providing business insight of failed transactions and helping in make prompt resolutions.

UFT Automating test cases -Worked with QA team for testing automation project using UFT. Extensively used analytics functions such as rank, dense rank, cube, and roll up group by. Used subquery factoring- With clause.

SIM SOLUTIONS, DELHI, INDIA Jan2008-Nov2010 Developer

Sim solutions provides ecommerce and point of sale integration service with the client database through its 24seven cart, mobile commerce & analytics products and services customized with the client needs .

Responsibilities:

Developed packages based on clients design to update or fetch inventory information real time from database.

Generated reports using SQL+ for list of the vendors, their supply schedule, actual deliveries and Inventory level of raw material.

Developed tables, indexes, constraints, views and sequences.

Used Oracle 10g new feature data pump utilities (EXPDP/IMPDP) for Copying of data from development server.

Data merger - consolidate data from third parties and merge them into transactional database.

Used the Crontab in UNIX for automating jobs.

Notification to business- Created consolidated report of daily failed transactions through email, providing them in depth visibility enabling them to make prompt action.

SIM SOLUTIONS, DELHI, INDIA June 2007-Aug 2007 Trainee

Worked as trainee under DB tech lead acquiring Oracle DB concepts.

Wrote Oracle SQL queries.

Hands on writing functions, procedures and triggers.

System testing standards and debug issues.

EDUCATION AND CERTIFICATIONS

IZO-051 Oracle Database 11g : SQL Fundamentals 1

IZO-047 Program with PL/SQL

Real World Agile and Scrum certification – Agile Transformation Inc., UTAH.

Bachelors in Engineering - Electronics and Communication, Rajasthan, India.

Contact this candidate