SAURABH MEHTA

Gurugram, HR, India •

+** - 981-***-**** •

adb591@r.postjobfree.com

Senior Database Consultant

More than 12 years of IT experience in Applications Development & Support, Database Design and Development using Oracle RDBMS in various domains like Telecom, Banking, Auditing, Advisory, Tax, Life Sciences, Research etc.

Database Architect/Programmer with more than 9 Years of experience in the areas of designing, developing and performance tuning of OLTP applications as per business requirements, good exposure to software quality processes.

Extensive development and design experience in Oracle 9i/10g/11g Database. Hands on experience in MySQL, PostgreSQL & Microsoft SQL Server 2012, T-SQL. Extensively worked on data extraction, Transformation and loading data using ETL tools from various sources like Oracle, SQL Server and Flat files. Good experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center.

Extensive knowledge in writing complex SQL queries, joins, sub-queries, normalization. Participated in designing and development of software using Agile development practices. Substantial development experience in creating PL/SQL stored procedures, functions, packages, triggers and functions. Strong knowledge in Oracle cursor management and exception handling. Hands on experience on Siebel CRM tool, Siebel EIM jobs to load data into the Oracle database to make it available on Siebel GUI.

Hands on experience in writing SOQL queries on Salesforce workbench. Expert in understanding needs, focusing on the critical issues, translating them into technical actions and implementing a resulting database.

Good knowledge on code optimization and performance tuning features such as Explain Plan, SQL*TRACE, TKPROF.

Received appreciations from client at Director Level for the successful implementation of Data Quality Metric project.

Created shell scripts for invoking SQL Scripts and scheduled them using crontab. Excellent communication, interpersonal, problem-solving, analytical skills and strong ability to perform as a part of team.

Operating Systems: HP-UX, UNIX/LINUX, Windows 98/2000/XP/7, Windows Server 2008 Languages: PL/SQL, SQL, SOQL, Batch Script, Shell Script, T-SQL, PL/pgSQL Web Technologies: HTML, XML

Databases: Oracle 9i/10g/11g, MS SQL Server, MySQL, PostgreSQL CRM Tools: Siebel CRM, Salesforce, SugarCRM

ETL Tools: Informatica Power Center 9.1, SQL Loader Database Utilities: PL/SQL Developer, TOAD, SQL Developer, SQL* Plus, SQL Loader, MySQL Workbench, MySQL Loader, pgAdmin

Telecom Billing Tools: Kenan Arbor BP 11.7, Convergys IRB 3.0, Amdocs DDP, CSG-ACSR Ticketing Tools: BMC Remedy, ServiceNow

Professional Summary

Technical Proficiency

July 2016 - Current Senior Software Engineer

Gartner Inc.

May 2007 - June 2016 Assistant Consultant

Tata Consultancy Services Ltd.

July 2016 - Current Senior Software Engineer

Gartner Inc.

Project/Client Name: Sales & Service Delivery, Data Integration Office Location: Gurgaon, India

About Gartner:

Gartner, Inc. is the world's leading research and advisory company. The company helps business leaders across all major functions in every industry and enterprise size with the objective insights they need to make the right decisions.

Roles and Responsibilities:

Manage all aspects of the application development life cycle, including system analysis, design, development, deployment, maintenance and enhancements. Work closely with analysts, testers and business people to identify features the software needs to contain to write user stories of functionality to complete using Agile development practices.

Organizes, prioritizes, coordinates, and administers the activities and workload of the application support/development team.

Review work performed by others and provides recommendations for improvement. Data Integration from downstream applications (e.g. Order Management) to Siebel CRM. Involved in data migration from Salesforce to Siebel EIM tables (using stored procedures) and finally loading to Siebel base tables through EIM jobs by creating ifb files. Developed complex SQL queries using various joins (Sub queries and Join conditions, correlated sub queries, using aggregate functions to get aggregated data). Worked extensively on PL/SQL packages, procedures, functions, triggers, exception handling etc.

Worked extensively on creating materialized views, indexes for better performance of query. Code optimization, performance tuning of SQL queries using Explain Plan, TKPROF, SQL*Trace.

Worked extensively with SQL Loader using control files for data loading into database tables. Responsible for fixing production issues, enhancements, analyzing and implementing the Change Requests.

Responsible for requirements, design, development, data Integration, end to end testing of data from Siebel to SugarCRM (recently procured by Gartner). Data Integration from Salesforce (flat files) and SiebelCRM (Oracle DB) to SugarCRM using stored procedures, SQL Loader, Materialized views in Oracle and sending data to MySQL database using Rabbit MQ.

Organization(s)

Work History

May 2007 - June 2016 Assistant Consultant

Tata Consultancy Services Ltd

Project/Client Name: Confidential

Client Location: Noida, India

About Client:

Our client is an American global pharmaceutical company with headquarters located in Indianapolis, Indiana, in the United States. The application stores the activity data of sales representatives with doctors. Worked on two projects for this client: Enhancements cum maintenance to the A-ODS application using the Informatica Power Center.

Develop an automated system to compare and generate reports of aggregated data from various data sources using T-SQL, batch scripts and send email to stakeholders. Roles and Responsibilities:

Support problem resolution; consult and advise in application design and tuning; plan, organize and execute product benchmarks for threshold and functionality. Organizes, prioritizes, coordinates, and administers the activities and workload of the application support/development team.

Conduct employee performance appraisals, provide feedback, coaching, team building and training/education to team members.

Responsible for providing cost estimations, creating SoW for the enhancement projects to the customer.

Demonstrated the ability to interact with all levels of management. Consult with business management to identify and prioritize opportunities (projects and enhancements) to enhance the use of applications in support of their business objectives. Developed complex SQL queries using various joins (Sub queries and Join conditions, correlated sub queries, using aggregate functions to get aggregated data). Worked extensively on PL/SQL packages, procedures, functions, triggers, exception handling etc.

Extracted data from source systems to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.

Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy. Responsible for fixing production issues, enhancements, analyzing and implementing the Change Requests.

Used OPENQUERY to query data on other database products like Oracle, Netezza, Salesforce using Linked Server concept.

Written SOQL queries to retrieve data from Salesforce objects. Appreciations from the client Director on the successful implementation of the tool. Project/Client Name: Comcast Cable Communications

Client Location: West Chester PA, USA / Ahmedabad, India About Project:

Comcast Corporation is one of the world's leading media, entertainment and communications companies. This project involves the support of DOTCOM application which includes the enhancements, resolving incidents related to the applications. Roles and Responsibilities:

Worked extensively on PL/SQL packages, procedures, triggers, materialized views. Sanity checking, performing morning checks ensuring application is up and running. Developed complex SQL queries using sub queries and join conditions, correlated sub queries, analytical functions etc.

Provided on call support, solved the user issues and made necessary changes. Monitor and maintain ticketing system to ensure all new and repetitive bugs and issues are addressed, researched, fixed and closed.

Enhancements and defect fixes to the already existing code Interactions with customers and various interfacing systems and debugging issues as raised by other interfacing teams and customers.

Project/Client Name: Price Waterhouse Coopers LLC

Client Location: Bangalore, India / Tampa FL, USA

About Project:

This project involves enhancements and maintenance of various internal applications of PwC like AFS, CPA, US FY11 that supports business operations. Roles and Responsibilities:

Worked extensively on PL/SQL packages, procedures, triggers, materialized views. Developed complex SQL queries using sub queries and join conditions, correlated sub queries, analytical functions etc.

Used the advanced features of PL/SQL like dynamic SQL Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked on performance tuning using Explain Plan, TKPROF to improve the performance of the queries.

Code review of project developed in Oracle PL/SQL and making the necessary enhancements, defect fixes at the database level as per requirement of the business. Interacting with PwC Demand Managers to gather requirements, verify the business acceptance criteria and existing functionality of modified module works. Project/Client Name: Bharat Sanchar Nigam Limited

Client Location: Hyderabad, India / Gurgaon, India About Project:

The purpose of this project was to do migration of the postpaid landline customers of BSNL from their legacy MCU (Meter Call Units) system to CDR (Call Detail Record) based system. It involves the implementation of Convergys IRB 3.0 and Kenan Arbor BP 11.7 as a billing system. Roles and Responsibilities:

Developed complex SQL queries using sub queries and join conditions, correlated sub queries, analytical functions etc.

Worked extensively on PL/SQL packages, procedures, functions, triggers, materialized views. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked extensively with SQL Loader to load data into database tables. Configuration and Testing of Convergent Billing systems as per the business and integration of the application with various other applications viz CRM (SAP), OSS (Clarity) etc. Configure tariff plans and rate plans, generate bill processing and usage processing on the billing tools as per the business requirements.

Mentored the Operations and Maintenance team to run the bill processing and usage processing

2002 - 2006 Bachelors of Technology

Punjab Technical University

Electronics & Communication

Aug 2019 Oracle Certified Associate

Oracle

Feb 2019 PSM-I

Scrum

Jan 2015 ITIL v3 Foundation

APMG International

Education

Certification(s)

Powered by TCPDF (www.tcpdf.org)

Contact this candidate