Developer Sql
Resume:
SACHIN VERMA
Mobile: 224-***-**** E-mail: *************@*****.***
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