SACHIN VERMA

Mobile: 224-***-**** E-mail: ac5opu@r.postjobfree.com

SDLC Planning & Coordination Project Execution

Multi-faceted professional with 13+ years of experience.

Completed B.Tech CSE from University of Kurukshetra.

Oracle SME with expertise areas as Performance Tuning, Oracle DB Administration, PL/SQL .

Conversant with development and maintenance and providing quick work-around to clients and users.

An energetic, self-motivated individual with abilities to grasp new technical concepts and utilize them in a productive manner.

AREAS OF EXPERTISE

SDLC Planning & Co-ordination

Involving in high-level design and software development.

Handling testing, system integration, debugging and troubleshooting of the application.

Co-ordinating for smooth implementation of the project. Extending post-implementation, application maintenance and technical support to the client.

Team Management

Creating an environment that sustains & encourages high performance.

Motivating teams in optimising their contribution levels.

ACHIEVEMENTS

Best team member award from Eastern Software Systems.

Service & Commitment Award from TCS

Pace Setter Award from Oracle India Pvt. Ltd.

Extra Mile Award from Ameriprise Financials.

Manager’s Choice Award from IBM India Pvt. Ltd.

EXPERIENCE

Sep’17 – Till date

Apex Systems, Chicago

Title : Bank Of America

Environment : Database 11g, Linux

Tools : PL/SQL Developer (for query builder), TOAD, SVN (For Configuration management),

SQLPLUS

Role : Performance Tuning Expert & Oracle SME

Responsibilities :

Proactive database tuning which includes SQL Tuning, Database Architecture Tuning, DB Parameters Tuning etc.

Working extensively in PL/SQL Packages, Procedures.

Using application development tools like Pl/SQL Developer, cursors, Inbuilt PL/SQL function, PL/SQL Tables.

Analysis of Business relationship document and understand the requirement.

Providing best solution by designing/developing of various Host-End applications using Oracle PL / SQL.

Administration and maintenance of Exadata Database servers.

Hands on Experience on Exadata.

Configuring databases for high availability using RAC, Standby database technologies.

Monitoring Database Performance and Tuning instances and databases.

Performance tuning of existing code.

March’15 – Sep’17

IBM

Title : Vodafone India

Environment : Database 11g, IBM AIX

Tools : PL/SQL Developer (for query builder), TOAD, MS Visual SourceSafe (For

Configuration management), SQLPLUS

Role : Performance Tuning Expert & Oracle SME

Responsibilities :

Proactive database tuning which includes SQL Tuning, Database Architecture Tuning, DB Parameters Tuning etc.

Expertise in using database tools like AWR, ADDM, ASH, TKPROF, Grid, OEM etc and OS tools like TOP, SAR, VMSTAT etc.

Installing, configuring and maintaining oracle enterprise server 10g, 11g, and 12c, RAC and ASM.

Administration and maintenance of Exadata Database servers.

Configuring databases for high availability using RAC, Standby database technologies.

Hands on Experience on Exadata.

Configuring databases for high availability using RAC, Standby database technologies.

Configuring, scheduling & performing consistent, logical backups, rman backups / Restoration; ensuring scheduled/unscheduled Backups are as per backup plan and performing the recovery when needed.

Database upgrades and migrations.

Database refresh and cloning.

Monitoring Database Performance and Tuning instances and databases.

Applying CPU and other patches using opatch utility.

Performance tuning of existing code.

Feb’14 – March’15

American Express Financial Advisors (Ameriprise Financial)

Team Lead (Technology)

Title : Security Master ( Asset Management)

Environment : Database 11g, Linux, SQL SERVER

Tools : PL/SQL Developer (for query builder), TOAD, MS Visual SourceSafe (For

Configuration management), SQLPLUS

Responsibilities

Designing reports using SSRS & SQL Server

Working extensively in PL/SQL Packages, Procedures.

Using application development tools like Pl/SQL Developer, cursors, Inbuilt PL/SQL function, PL/SQL Tables, Triggers while developing Payroll Interface system using Exception Handling features extensively.

Overseeing used views and materialized views while application development.

Analysis of Business relationship document and understand the requirement.

Providing best solution by designing/developing of various Host-End applications using Oracle PL / SQL.

Performance tuning of existing code.

April’11 – Jan’14

Oracle India Pvt. Ltd

Senior Consultant

Title : Central Board For Excise & Customs (CBEC) & Income Tax

Environment : Windows NT 4.0, Windows 2000, Oracle PL/SQL, Forms 10g, Reports 10g

Database 10g, Database 11g, UNIX, HP UX

Tools : PL/SQL Developer (for query builder), TOAD, MS Visual SourceSafe (For

Configuration management), SQLPLUS

Responsibilities :

Analysis of Business relationship document and understand the requirement.

Providing best solution by designing/developing of various Host-End applications using Oracle PL / SQL.

Performance tuning of existing code.

Troubleshooting problems related to connectivity to the databases, database job failures, and Backup failures.

Troubleshooting connectivity issues in RAC databases.

Troubleshooting for issues in RAC instances.

Handling incidents relating to space issues on various filesystems, tablespaces, and archive destinations.

Handling various technical issues related to Databases and assisting users with the sql tuning for bad sql codes.

Dec’06 – April’11

Tata Consultancy Services

IT Analyst

Title : Income Tax Authority of India

Company : Tata Consultancy Services Ltd.

Duration : Dec’06 till date

Environment : Windows NT 4.0, Windows 2000, Oracle PL/SQL, Forms 9i/10g, Reports 9i/10g

Database, UNIX, IBM AIX

Tools : PL/SQL Developer (for query builder), TOAD, MS Visual SourceSafe (For

Configuration management), SQLPLUS

Responsibilities:

Working extensively in PL/SQL Packages, Procedures.

Using application development tools like Pl/SQL Developer, cursors, Inbuilt PL/SQL function, PL/SQL Tables, Triggers while developing Payroll Interface system using Exception Handling features extensively.

Overseeing used views and materialized views while application development.

Analysis of Business relationship document and understand the requirement.

Analysis of TDS, Challan data to check for mismatch.

Performing business and technical analysis performing feasibility analysis.

Providing best solution by designing/developing of various Host-End applications using Oracle PL / SQL.

Performing Unit Testing for various developments / enhancements / fixes for various version releases.

Commissioning various Policy rollouts and code changes.

Performance tuning of existing and new codes.

Freezing of financial data, diagnose the issues, preparing fixes to resolve problem related to financial (Pan/Return) data in database, test fixes on testing environment and then implement fixes on Production servers.

July’06 – Nov’06

Interglobe Technologies Ltd

Software Engineer

Major Projects

Title : Travel Agent Professional (TAPRO) Maintenance

Company : Interglobe Technologies Ltd.

Duration : July’06 - Nov’06

Environment : Windows 2000, Oracle PL/SQL, Oracle 9i/10g

Database, Linux Suse

Tools : PL/SQL Developer (for query builder), TOAD, SQLPLUS

Responsibilities :

Working extensively in PL/SQL Packages, Procedures.

Using application development tools like Pl/SQL Developer, cursors, Inbuilt PL/SQL function, PL/SQL Tables, Triggers while developing Payroll Interface system using Exception Handling features extensively.

Solution of Problem Request & Testing (Regression, System).

Solution of Change Request & Testing (Regression, System).

Creation of new Forms & Reports.

Feb’05-May’06

Eastern Software Systems Pvt. Ltd

Software Engineer

Title : Ebizframe Maintenance

Company : Eastern Software Systems Pvt. Ltd

Duration : Feb’05 – May’06

Environment : Windows 2000, Oracle 9i/10g, PL/SQL, Forms 6i/9i, Reports 6i/9i

Tools : PL/SQL Developer (for query builder), TOAD, SQLPLUS

Version : Visual Source Safe (VSS) 6.0

Control

Responsibilities :

Working extensively in PL/SQL Packages, Procedures.

Using application development tools like Pl/SQL Developer, cursors, Inbuilt PL/SQL function, PL/SQL Tables, Triggers while developing Payroll Interface system using Exception Handling features extensively.

Responsible to get the implementation and customization of ERP done as per the Company’s requirements and defining the workflow for the same. I am also responsible for the gap analysis between the company’s workflow and ebizframe’s workflow and for the maintenance of ERP.

Developed data-entry forms for master tables. Module level testing and writing PL/SQL code for triggers and stored procedures.

Generated customized reports that will help Management take decisions regarding Business promotional process improvement and product.

ACADEMIA

B.Tech Computer Science, Kurukshetra University, Kurukshetra, India, 2004 Securing 68%

AISSCE, CBSE Board, India, 2000 securing 62%

AISSE, CBSE Board, India, 1998 securing 70%

PERSONAL DOSSIER

Address : 9273 Fairway Drive Des Plaines IL 60016

Date of Birth : February 11,1983

Visa Details : L2 Visa with EAD (Authorize to work as per USCIS)

Sex : Male

Contact this candidate