GAURAV MISHRA

Mobile: +44-074********

Email: acqvxs@r.postjobfree.com

acqvxs@r.postjobfree.com

Career Objective:

To pursue a challenging position in an organization that utilizes and enhances my analytical skills effectively and henceforth to contribute towards organizational growth.

Professional Profile:

Technology consultant with 7 years of experience in development, consuilting and leading projects to meet specific customer needs and driving new businesses in international markets.

My technological forte includes Sybase ASE, UNIX shell scripting, Oracle 10g, PostgreSQL, PL/SQL and PERL,Python and object oriented programming methodologies in Java.

Ability to understand customer requirements, responding Request for Proposal (RFP) and Request for Information (RFI) as well as presenting justification of the technical proposal and solutions.

Experienced in handling multiple projects at a time (entire SDLC life cycle) with stringent time lines in place and successful delivery. Experience working in Agile and Scrum methodologies. Excellent debugging and issue resolving skills. Investigate, assess and resolve issues or defects in the applications quick time and perform root cause analysis and fixing.

Excellent interpersonal and communications skills; quickly build rapport with customers, colleagues, and senior management. Skilled technical contributor and leader; able to direct multiple tasks effectively.

Work Experience:

Duration

Organization

Designation

July 2013 – Till Date

JP Morgan(Database Consultant)- Vendor( Tata Consultancy Services)

Database Consultant (ITA)

Nov 2012-July 2013

EnterpriseDB

Database Solutions Consultant

July 2011-Nov 2012

BlackRock Inc.

Sr. Analyst Programmer

Apr 2010-May 2011

Headstrong

Sr. Associate

Oct 2008 Apr 2010

Cegedim Dendrite

Developer

Technical Skills:

OS

Programming

Methodologies

Tools

Databases

Windows and Sun Solaris

Linux-Fedora

Ubantu

RHEL

CentOS

OpenSUSE

Unix shell scripting(ksh, Bash)

TSQL, PL/SQL

Perl, Python and

Object oriented programming methodologies in Java

Agile, SCRUM,

Waterfall

Autosys, RCS, TOAD, SQL Developer, PL/SQL Developer, DBArtisan, Aqua Data Studio, Rapid SQL, CVS,SVN, JIRA, Putty, MS Office Products, Eclipse, Enterprise Manager, HP Quality Centre, HP ALM, Fitnesse.

Sybase ASE 12,5, 15.5, 15.7

Oracle 10g

PostgreSQL

Project Thesis

The details of the various assignments that I have handled are listed here, in chronological order.

Customer- JP Morgan, Private Bank, Glasgow, UK (Oct 2014 – Till Date)

Projects@ Tata Consultancy Services (UK):

Senior Database Consultant

Responsibilities

Handling the database related activities at JP Morgan,Glasgow for the assigned project starting from design discussion to deployment and support. The project involves development, enhancements and bug fixing efforts to the infrastructure for Developing new functionalities in the system as per the business needs. The regular project efforts includes analysis of business requirements, Coding Sybase, Perl and Java related objects, enhancing and tuning stored procedures and other database objects. Extensive work on Stored Procedures and performance tuning.

Solution Environment

Database - Sybase ASE 15.7

OS - Linux –RHEL, Windows

Code - TSQL programming, Sybase Database Objects, Perl programming, Unix korn/bash shell scripting, Python,Java

Tools

Rapid SQL, DB Artisan, Eclipse, Autosys, SVN,HP Quality Centre

Customer- Credit Suisse, Credit Risk Information System, (Aug 2013 – Aug-2014)

Projects@ Tata Consultancy Services (UK):

Senior Database Consultant

Responsibilities

Handling the database related activities at Credit Suisse, CRIS for the assigned project starting from design discussion to deployment and support. The project involves development, enhancements and bug fixing efforts to the infrastructure for Developing new functionalities in the system as per the business needs. The regular project efforts includes analysis of business requirements, Coding Sybase, Perl related objects, enhancing and tuning stored procedures and other database objects. Extensive work on Stored Procedures and performance tuning.

Solution Environment

Database - Sybase ASE 15.5, Oracle 11g

OS - Unix (Solaris), Linux, RHEL.

Code - TSQL programming, Sybase Database Objects, Python, Perl programming, Unix korn/bash shell scripting.

Tools

Rapid SQL, DB Artisan, Eclipse, Autosys, Awk and Sed, SVN,HP Quality Centre

Organization

EnterpriseDB

Solution Consultant (Techno-Sales Consulting)

Description

EnterpriseDB is the only worldwide provider of enterprise-class products and services based on PostgreSQL, the world's most advanced and independent open source database. PostgreSQL is the #1 enterprise-class open source database with a feature set comparable to the major proprietary RDBMS vendors and a customer list that spans every industry.

Working as Solution Consultant for multiple clients. The core roles and responsibilities include delivering a high quality customer and partner experience through timely and effective response and resolution to customers. Responding Request for Proposal (RFP) and Request for Information (RFI) as well as presenting justification of the technical proposal and solutions. Presenting EnterpriseDB products portfolio before the Customers, ensuring the success of the products within customers' IT operations by providing deep technical skills for proactive and reactive delivery that involve technically complex or politically sensitive situations in large, enterprise-scale environments. Providing strategic vision and guidance for successful implementation of customer solutions through developed trusted advisor relationships and successful integration of EnterpriseDB products into customer engagements. Acting as the primary technical account lead, providing customer visibility, advanced technical troubleshooting support and problem resolution for Product Support Services and corporate customers, including issues escalated to the highest levels of management. Providing technical support including product technical workshop/training onsite, as well as via telephone, and electronic media. Delivering proactive Health Checks (HC) and advisory assistance which involves sharing best practices, analyzing the customer environment and setup against the best practices.

Solution Environment

Database - PostgreSQL 9.2, Oracle 10g, MS SQL Server 2008

OS - Unix (Solaris), Linux-Fedora, RHEL, Ubantu, CentOS, OpenSUSE, Windows 7.

Code - PL/pgSQL, PL/SQL, TSQL programming, Stored Procs, Triggers, Perl & Python programming, Unix korn/bash shell scripting and DB administration activities like backup-recovery, performance tuning at DB parameter level.

Organization

BlackRock Inc.

Sr. Analyst Programmer, Core Client Processing-Aladdin & Technology

Responsibilities

Implementing and delivering the deliverables in the scheduled time and improving the performance of the existing system by implementing best practices. The project involves development, enhancements and bug fixing efforts to the infrastructure for Developing new functionalities in the system as per the business needs. The regular project efforts include developing, enhancing and tuning stored procedures and other database objects and support for the application 24/7. Coding Sybase and Perl related objects to simulate and realize the business requirements. Analysis of business requirements and development of reconciliation reports in Perl and Sybase and enhancements according to the requirements. Regular interaction with different data agencies and business vendors and doing business communication with them.

Solution Environment

Database - Sybase ASE 12.5

OS - Unix (Solaris)

Code - TSQL programming, Stored Procs, Triggers, Unix korn shell scripting and Perl programming, Nite Jobs.

Customer- Morgan Stanley

Projects@ Headstrong

Sr. Associate (Application Development)

Description

The project involves various enhancements (over 30 distinct enhancements planned) to the existing client infrastructure for storing equity data. The enhancements include creating procedures for the report generation based on symbolic data, creating re-conciliation reports for various vendor feeds using perl scripts and stored procedures, Changes in the existing perl and shell scripts for making them environment agnostic and kerberized etc. Extensively worked on the database interaction with perl, embedded perl, porting DBLib to DBI. Worked on SQL tuning to enhance the performance of the procedures. Experience in Data Analysis using SQL and creating design specification and strategies and plans based on business analysis of the requirements.

Solution Environment

Database - Sybase ASE 12.5

OS - Unix (Solaris,Linux), Windows

Code - PL/SQL programming, Stored Procs, Triggers,Unix korn shell scripting and Perl scripts and Core Java

Scheduler - Autosys

Tools

DB Artisan, Eclipse, Autosys, Awk and Sed

Customer- Otsuka America Pharmaceuticals, Schering Plough Corporations

Projects@ Cegedim Dendrite

Developer

Description

The activities involved, interacting with business users in various locations to gather the requirements and converting them into meaningful solutions. This project involves various developments and enhancements to the existing client infrastructure. The enhancements include creating database objects like procedures, triggers, functions and changes in the existing database objects. Writing shell scripts for running database objects. Creating and modifying indexes.

Solution Environment

Database - Oracle 10g, MS SQL Server 2005

OS - Unix (Linux), Windows

Code - Triggers, Procedures, Functions, Indexes and shell scripts.

Scheduler - Autosys

Educational Qualifications:

Degree and Date

Institute

Major and Specialization

Bachelor of Technology (Information Technology)

UP Technical University, Lucknow, India

Information Technology

Professional Memberships / Certifications:

Professional Society / Certification

Member Since / Date Certified

PostgreSQL Advanced Training -EnterpriseDB Software

April 2013

National Stock Exchange, India

Financial Markets-Beginners Module

Equity Derivatives-Beginners Module

September 2010

Oracle Certified Associate (OCA)

Oracle Database SQL Expert

Oracle 10g Administration-I

February 2010

Microsoft Certified Professional

Designing and implementing databases with MS SQL Server 2000

January 2008

Contact this candidate