Resume

Sign in

Data Management

Location:
Mumbai, Maharashtra, India
Posted:
October 27, 2018

Contact this candidate

Resume:

Vinayak Jadhav

Malad, Mumbai, India ******

Cell: +91-992******* / 908-***-****

Email: ac7iqn@r.postjobfree.com

Senior Database Analyst

Worked in IT domain for 8+ years serving across different systems and environment. Hands on experience in developing various maintenance activities for systems scheduling, reporting and housekeeping for maximum uptime of the system. Excelled in database development and complex systems management. Self motivated individual believing in getting to the crux of the matter to resolve complex issues at hand.

Areas of Expertise:

Database Design and Maintenance

Batch Processing, Scheduling

Root Cause Analysis

Change Management practices

Operating System and environment housekeeping

Incident Request Management (ITIL)

Domain Expertise:

Investment Bank trading platforms, Hedge Funds and Deal Cycle.

Market Research and Analysis.

Technical Proficiencies:

Platforms: UNIX (Sun Solaris, Ksh), Windows NT, 9x, Citrix.

Network: TCP/IP, Novell, VPN,

Language: UNIX Shell Scripting, C, HTML, XML, T-SQL

Database: Sybase ASE 12.5, Sybase IQ 12.0, MS- SQL 2008, My Sql 6.0

Tools: Incident Management Request (IMR), HP-Oview, Autosys 6.0,

Service now, JIRA 4.5, CVS, and MS-Office 2013, Microsoft Visio 2010

Systems: Kondor 3.0, 2.5, Murex Back office, Plato.

Professional Experience

Greenfield Research Limited Dubai-Mumbai, January 2015- May 2018

Recruited at Greenfield market Research as consultant for maintaining the activities of data design, processing for their client’s research and data analysis team.

Key Achievements

Handling the process of new data structure design and updating in database remotely from Mumbai office.

Scheduling Batch process for data extraction loading and maintenance.

Developing and maintaining procedures, complex queries in Ms-Sql 2008.

Housekeeping of systems data dump used for future revival purpose

Change management activities and deploying new process in the system.

Instrumental in creating data view for data mining as and when required by the data users.

HCL Singapore PTE (on contract) September 2011 - December 2011

Worked third party consultant for OCBC bank from September 2011 to December 2011 as it was a contractual position on behalf of HCL Singapore PTE ltd

Key achievement

Involved in change management and patch upgrade from UAT to production environment as the system was migrating from kondor to murex.

Monitored the uptime of the applications within the system using third party applications like autosys, Hp-Oview.

Created SSIS packages for loading, extracting data into tables.

Deployed packages for new batch updates.

Maintenance of scripts in Unix Korne shell for data transfer to external (client) servers as required.

Managed batch process from SOD to EOD.

November 2010 - February 2011: Nomura India Solutions Pvt Ltd.(on contract)

Recruited to Nomura India solution on contract from November 2010 to February 2011. Worked for E-businessware Solutions.

Key Achievements:

Monitored the uptime of the application process of the system using third party applications like Autosys.

Initiating and managing the Batch process executed for risk reports and calculating risk metrics post end of day till completion through autosys scheduler application.

Managed Change management activities for risk system up gradation through script processing and data loading activities.

Updated the current status of critical activities within the systems daily operations to management and downstream system.

Developing stored procedures and maintaining old procedures within the system.

Updated the scripts in UNIX korne shell which were executed for risk reports by level1.

Updating the downstream system about any discrepancies in systems day-to day operations and maintaining the same from the upstream system.

Handling client users, end users requests or queries through email, IRM tool, and phone in context to day-to-day activities.

Documentation of the systems key aspects and critical activities.

BNP PARIBAS India Solutions Pvt Ltd January 2008 -October 2010.

Worked as 2nd level Support Analyst for BNP PARIBAS India Solutions Pvt Lt for the middle office and back office operations of Equity and derivatives and P&L department. Supported the development administration and testing department in their respective processes.

Key Achievements

Managed the Change management activity for systems version upgrade as per request by the testing team through change management server.

Maintained linearity across UAT, Dev and Production environment at System as well as Data base level.

Travelled to Paris and London office for period of 3 months for knowledge transfer and understanding work around.

Development and testing of critical changes and operations.

Written procedures in Sybase for Executing Data dumps on Ad-hoc basis for development team.

Analyzed discrepancies in the report and escalated it to the development team critical to business as well as functional user

Remotely Monitored the Daily Batch process and end of Day activity for cash flows, transactions, and deal books executed on Paris and London servers.

Maintained the housekeeping function on the Sun Solaris Unix platforms for data space optimization on the servers.

Setting up and implemented new application process for the new clients.

Documented the system architecture and process flow.

Globe op Financial Services Pvt Ltd December 2006 - November 2007

Worked as Support Associate for the Globeop Financial Service Pvt Ltd, Mumbai for their clients across the world. Assisted the Kondor and Trade access application development, administration and testing department in their respective processes. Supported the end users with their issues encountered while work around on the system.

Key Achievements

Monitored the uptime of the applications within the system using third party applications like through Perl, shell scripts.

Fine tuning critical procedures, queries in system database.

Configured system for new clients. Setting up the client data.

Modified and Executed the Perl scripts on UNIX environment for data transfer to external (client) servers as per the client request through JIRA.

Developing stored procedures, queries in the systems as per changes requested by business users and clients.

Initiating, Updating batch process and keeping users posted of end of day.

Version control for reports and scripts for different clients on production using CVS.

Escalating and assigning Incident logged on JIRA to different teams as per ITIL standards.

Zenta Financial Services June 2006- December 2006:

Worked as Senior MIS Analyst for Management Information Systems Department for a contact centre based BPO named as Zenta Financial Services.

Implemented the ETL process for the report generation and data filtering using DTS services.

Developed queries, maintaining old procedures in the system database as per business rules.

Deployed SSIS packages and performed execution of the same on database for changes in database structure.

Maintained and generated daily, monthly quarterly reports in MS-Excel for the client users.

Resolved client users, end users requests or queries in context to day-to-day activities through root cause analysis (RCA)

Documented the systems key aspects and critical activities.

Reliance Industries Ltd- Reliance Petroleum: February 2005 – May 2006

Worked on contract through team lease Pvt Ltd as Level 1 support analyst for Reliance Industries Ltd for SAP applications for Supply Chain Management at the remote fuel station of reliance retail industries through SAP application like Ross, Retalix, HP open view

Key Achievements:

Remotely supported the end users using VPN to connect their systems and logged their request using IRM tool.

Monitored the uptime of the applications within the system using Hp-Oview, Escalating Incident through Incident management system to upstream and downstream team as per ITIL standards.

Updated the current status of critical activities within the systems daily operations to relay team about the remote Point of sales at the petrol pump outlet.

Developed executed ad-hoc queries for client user POS reconciliation.

Executed shell scripts as per instructions from the development team.

Documented and updated the processes and business flow as per the business users needs.

Adhered to the change management activities carried out as per business rules.

Executed checklist on the newly implemented retail petrol pump as a mock drill.

Educational Proficiencies:

Masters in Enterprise systems Sheffield Hallanm University United Kingdom 2012 – June 2014 (left due to financial concerns)

Bachelor of Engineering in Information Technology from Walchand Institute of Technology, Solapur: 2001-2004

Diploma in Computer Technology from Bombay Institute of Technology, Mumbai 1998-2001.

High School uptill grade Xth, I.E.S Matunga Mumbai: 1985-1998

Professional Certifications:

ITIL v3

Oracle Certified Associate

Microsoft SQL Database Developer



Contact this candidate