Saurabh Srivastava

act6s1@r.postjobfree.com 747-***-****

CAREER SUMMARY

11+ years of IT experience in database development and design using Oracle 11g, 10g and 9i

Specialized in managing large database objects, PL/SQL Packages/Procedures, functions, triggers, views, materialized views and used table functions, collections, PL/SQL tables, Bulk Collect, Autonomous Transactions, Flashback queries, Returning bulk collect into etc.

Expertise in SQL performance tuning and optimization using execution plans, Autotrace, TKProf, PL/SQL profiler, HProf. Expertise in debugging PL/SQL codes and SQL scripts

Extensive domain experience in healthcare and telecom

Extensive experience in data warehousing, data modeling and OLTP / OLAP models

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery

Strong experience in using tools like SQL*Plus, TOAD, SQL Developer, SQL*Loader, OEM, TKProf, Unix, MS Projects, Visual Source Safe 6.0, Crystal Reports, SVN etc.

Committed team player with positive attitude and strong prioritization skills

Well versed in requirements analysis, design, development, and providing maintenance/support

Excellent design, development, analytical, logical, debugging and programming skills

EDUCATION and CERTIFICATIONS

Masters in Information Technology (M.Sc IT), Sikkim Manipal University, India.

Graduation in Science stream (B.Sc), V. B. S. Purvanchal University, India.

CIC (Certificate in computing) from Indira Gandhi National Open University (IGNOU), India.

‘O’ Level Certificate from Department of Electronics and Accreditation of Computer Classes

(DOEACC), an autonomous scientific society under the Indian Ministry of Communications and Information Technology

TECHNICAL SKILLS

Programming Language : Oracle PL/SQL, UNIX Shell Scripting

DBMS & RDBMS : Oracle 12C, 11g, 10g, 9i

TOOLS : TOAD, PL/SQL developer, SQL*Loader, Erwin, TKProf, MS Projects

Data Models : OLTP

Operating Systems : Windows, Unix, XP, NT

Source Control : ClearCase, Tortoise SVN, Visual Source Safe 6.0

Others : Crystal Reports, XML

PROFESSIONAL EXPERIENCE

Company: Assigncorp, Glendale, CA.

Client: Multiplan Inc., Rockville, MD

Consultant, Sep, 2015 till Date

Working with leading healthcare cost management solutions organization with the role of database designer.

Responsibilities:

Design and implement transformation code, and relational database tables in the VLDB environment using Oracle 12C

Provide day to day support and solution to the client for technical and functional issues.

Created complex Stored Procedures, Functions, User Defined Data-Types, used complex queries. Performed SQL tuning using Explain Plan, Hints and indexes.

Optimizing Stored Procedure to improve performance, preserve referential integrity and provide application functionality using best practices of Oracle 12C.

Worked with business analysts in aggregating the business requirements, planning and designing phases of the project.

Provide Database maintenance and reviews to the clients.

Developed multiplex DB components using Agile methodology for application for customized MIS reports for different clients.

Created data mapping and transformation document, used to develop the code, Develop and maintain complex stored procedures and complex queries for the Dashboard and Reports.

Design and develop other database objects to meet business requirement for the project.

Company: Assigncorp, Glendale, CA.

Client: Xerox Corporation, Germantown, MD

END Client: DMV (Department of motor vehicle), US federal project

Consultant, January, 2015 till September, 2015

Working on Government Toll Authority project (Associated with DMV) for toll collection agencies for CA, MD, NY states for automating the tolling system.

Responsibilities:

Creating and maintaining Stored Procedures, Functions and Cursors.

Taking care of SQL tuning & performance activities and implementations of SQL and PL/ SQL code.

Testing of Code as per the business requirement.

Creating migration scripts for the new enhanced features.

Creation and maintenance of databases for Dev and QA teams.

Created data mapping and transformation document, used to develop the code. Developed complex Drill-through and Drill-down reports and other reports using Crystal Reports.

Company: Cognizant Technology Solutions, India / Xerox Corporation, India.

Clients: Sandisk, Adobe, Kelly Services, Level3, Banner, EQT, Verizon, Kraft Goods

System Development Senior Specialist. May 2012 – January 2015

Worked on ADVANTAGE and IO applications designed for HR and benefits field for clients like Sandisk, Adobe, Kelly Services, Level3 and many more. IO tool takes care of defining and customizing the health and medical insurance of each employee in the registered organization of them and their family, keeps track of any alterations and records monetary account for each individual. Advantage project is the Master Application for MIS purposes and works on data warehousing for health and welfare database. It extracts the data from different sources, processes and finally dumps the data in the Oracle tables to be able to generate the reports for management to keep track of business changes.

Responsibilities:

Database designing and development for IO tool in OLTP model along with Database components development for Advantage tool like stored procedures, functions, packages, triggers etc.

Used Oracle, PL/SQL, Toad, SQL Developer, Unix, Oracle Dynamic SQL, Records Collections and PL/SQL Tables, Connect By, Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE extensively for different deliverables to the client following Agile methodology.

Done database modelling for ADVANTAGE project using Erwin tool in OLAP model.

Done Performance tuning for IO Tool and Advantage tool by refactoring the SQLs, Indexes, IOTs and using other tools / methods as Explain Plan, Autotrace, TKProf, Collections, PL/SQL profiler and Hints for various database objects.

Used Bulk Collections and FORALL for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Developed materialized views for data replication in distributed environments

Created automated ETL process to migrate user’s data from XML to the database by parsing the XML in Oracle 11g. Worked extensively on processing the data from and to XML format.

Day to day interaction with international clients for requirement gathering, analysis & technical discussion and status updates.

Provided mentorship to the team mates in terms of domain and technical aspects.

Environment: Oracle 11g, Oracle 10g, SQL*Plus, TOAD, UNIX, SVN

Company: Assign Infotech Pvt. Ltd., Noida, India.

Client: Kaiser Permanente, Oakland, California

Senior Associate- Oracle PL/SQL. March 2011– May 2012

Worked on various applications for Kaiser Permanente, a non-profit and the largest managed care organization in United States.

Drug Forecasting: Every year a fixed KP drug purchase budget needs to be sanctioned for all drugs purchased. To determine what budget is required, a group of forecasters forecast costs for drugs for the coming year, across two six-month cycles, for Rate Making and Operating Budget. Based on this forecasting, reports are generated and forwarded to the finance department to help them take the decisions related to budgets.

Operations and SMT Dashboard: This dashboard consists of information relevant to the SMT and Operations group. The main feature of this dashboard is its dynamic reports. In addition, the managers can view the reports based on custom provided rich search criteria. This enables them to track and manage the projects with a better level of control.

eTSub (Electronic Therapeutic Substitution): This is a web application for creating initiatives for drug substitution. Purpose of this application is to discarding the harmful drugs or taking approval from doctors to convert a branded drug to a generic drug based on individual patient feedback. It has reports with provides facility to Drug education coordinator to see all types of approval status.

Responsibilities:

Worked on multiple projects simultaneously for database activities. As a lead engineer, was involved in code review of all the team members. Responsible for any database deliverables to the clients.

Completed database designing and development of DB components for Drug Forecasting Tool for granular level of forecasting the consumption of drugs.

Designed and developed complex APIs for application and reporting purposes to enables users to forecast the consumption of different medicines considering their annual uses.

Fine-tuned multiple stored procedures and achieved the desired execution time.

Developed APIs for customizing the application interface for Executive Dashboard for gathering of data, performance analysis, draw conclusions and presents findings for all the doctors across Kaiser Permanente.

Used ERWIN tool to forward engineer database design to code.

Created database components for ETSub application. Automated patient track records, medical history, GPI items, medicine compositions etc.

Environment: Oracle 10g, SQL Developer, TOAD, Enterprise Manager, SQL*Loader, Erwin tool

Company: R Systems International Limited (A PCMMI Level 5 Company), Noida, India.

Client: Intercall, Dell, Panasonic, RainDance

Project Leader, Feb 2008 - Mar 2011

Intercall is the largest conference and collaborations service provider in the world, and a leading provider of global cloud-based unified communications services. Developed and managed a high technology application for telecom domain that enables users to set up billing, invoicing, bill formatting, monetary transaction record keeping, charges and facilities etc. for their multiple end customers. Also worked for international clients like DELL and Panasonic for database development activities and support & maintenance.

Responsibilities:

Database development and design for Intercall team.

Developed multiplex DB components using Agile methodology for Intercall application in Telecom domain for customized billing format for over 2700 end clients.

Interacted with international clients for requirement analysis, development status.

Wrote complex queries and stored procedures using PL/SQL for reporting and data analysis using Windows & Unix platforms. Involved in analysis, coding and code review of team members.

Performance tuning of slow running stored procedures and bring down the execution time for application to run fast using TKProf, Pl/SQL profiling, hints, Bulk collect etc.

Database modelling for DELL project using Erwin tool. Wrote Custom stored procedures to extract and stage Business partners, Items and Order related data for DELL.

Developed database APIs that are capable of generating usage, taxes, memos, credit / debit for thousands of number of customers of Raindance.

Designed and generated multiple standard, crosstab, drilldown, subreports and chart representation of reports for multiple clients.

Environment: Oracle 11g, TOAD, SQL Developer, Erwin Tool, Crystal reports, Unix

Company: March Infotech Pvt. Ltd.

Client: OKS Span Tech Pvt. Ltd., New Delhi)

Team Leader, Feb 2007 to Feb 2008

Created PL/SQL stored procedures, functions and packages, scripts to create new components and queries for new enhancement in the application using TOAD.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package

Managed a team of 5 members. Involved in code review for the team members.

Extensively involved in environment setup at offshore at the time of acquiring a new project from another vendor.

Coordinated with the front end design team to provide them with the necessary stored procedures and packages.

Involved in knowledge sharing with client and external vendor to understand the process flow of the application.

Involved in project planning, organizing, monitoring, and controlling projects using appropriate tools and techniques.

Coordinated with the front end design team to provide them with the necessary stored procedures and packages.

Environment: Oracle 10g, SQL Developer, TOAD, Crystal reports, SVN,

Company: Think Computers Pvt. Ltd.

Project Leader Feb 2005 to Jan 2007.

Was involved in the design, development and maintenance of the applications.

Promoted to Project leader for the excellent work performed in development activities and team handling.

Was involved into development & maintenance of database components e.g. stored procedures, functions and packages.

Provided database support to testing team, .Net Development Team.

Worked with Analysts to give them data in Report formats.

Environment: Oracle 9i, SQL Developer, TOAD, Crystal reports, SVN

Contact this candidate