Vikas Bhat Email & Phone Number

Pune, Maharashtra, India

- Responsible for buildout of the Enterprise Data Model for the entire DWS business.- Contribute to target data architecture and data governance initiatives.

Pune, Maharashtra, India

As an indepedent consultant I work with my clients to help them resolve technical and data challenges, provide guidance and mentorship to their technical teams or help them with strategic directions. Some of the work done include - 1. Formulated the data strategy for a bank in Jordan to help them move towards a new gendata analytics platform as part of their overall digital transformation journey.2. Fixed and scaled a multi-tenant .NET Based platform from 5 customers per instance to 20customers per instance, thereby helping the client save in costs.3. Fixed database deadlock issues on SQL-Server based application that saved the clientthousands of dollars of potential losses.4. Implemented SDLC process for the client that involved helping the team learn using GIT and creating a script drive deployment process.5. Provided guidance and support for migration of key applications to Azure and GCP.6. Worked as a Principal Developer as and when required to help solve challenges faster.

Mumbai, Maharashtra, India

1. Worked as the Database Lead and Architect for Index Distribution Services at MSCI.2. Oracle SME for the project.3. Analysis of migrating Oracle DB to Azure Cosmos DB.

Pune, Maharashtra, India

I performed 2 different roles.For the first year - 1. Worked as Oracle SME for various projects as they were being transitioned to India.2. Migrated and upgraded a .NET/Microsoft Project/SharePoint application from 2.5 to 4 in1/3rd of the time the that was estimated by an external vendor. The migration involved updating code and fixing the migration issues as well as learning about Microsoft Project and Sharepoing on the fly.In the second role I worked in the Architecture team for Finance IT and then eventually led the team of architects.1. Reduced technology footprint and operating cost by simplifying and rationalizing architectureto a standard set of tools, technologies and processes. Identified and removed redundancyacross applications and brought in synergies to reduce operating costs.2. Responsible for architecture governance of different applications within Finance IT spanning across multiple technologies including Oracle, Informatica. Java. Big Data (Spark, HIVE. Hadoop).3. Work with other architects acroos the RFT organization and develop blueprints for Strategic Data Services.4. Implement and ensure Enterprise Wide standards are adhered to and followed.5. Manage technical debt and ensure a time bound resolution of critical ones.6. Lead the Data COE with other architects by conducting trainings and workshops for theteams across the bank. Delivered a global training within Deutsche Bank on OraclePerformance Tuning that was very well received with requests for repeat sessions.

Pune, Maharashtra, India

Role was of the product architect for INBILL product and managed the product from technical perspective as well as responsible for the technical delivery.1. Led a team of 5 senior resources that involved mentoring and coaching them leading to a high performance team.2. Scaled the product from managing 200 million records/day to 800 million records/day.3. Technical Architecture and Design of core components.4. Cross team Oracle SME.

Bengaluru, Karnataka, India

Worked as Database Solutions Architect. The applications used either Oracle or MYSQL. As the sole database expert, my role involved both the DBA as well as Development activities. 1. Designed and Implemented data archival and backup strategy using RMAN. 2. Did POC on Data Encryption options and implemented Tablespace Encryption. 3. Installation, maintenance and troubleshooting of Oracle and MYSQL databases on Unix and Windows servers. 4. Architect the database components of the applications. 5. Logical and Physical Database Modelling. 6. Develop and test the database APIs to be consumed by the applications.

Bengaluru, Karnataka, India

Performed two different roles. For the first year I was doing the following -1. Enhancements and support of 5 different inhouse applications (web based and windows clients) developed in various tech stacks including SHTML, Adobe Actionscript, Javascript, C#, ASP.NET.2. Handle and drive client calls and communicate and proactively provide status reporting to senior management.3. Co-ordinate, communicate and engage with various stakeholders.In the second role -1, Led a data re-engineerig project with a team if senior resources. The project involved migration of legacy systems data to Oracle Database. Interfaces included Files, Other Database Systems and messages. Informatica was used as the ETL tool.2. Also engaged in building a Common Data Environment that aimed to build an common enterprise data model across all asset classes (FI, Equities, etc) within Fidelity.3. As Oracle SME, was involved in DB optimization beyond my project and coached and helped other teams as and when required.

Bengaluru, Karnataka, India

1. Led the Oracle Extraction and Reporting Services team from India. Team Size 7.2. Built the team from scratch while simultaneously taking handover from the counterparts in Paris.3. Delivered the migration of more than 2000 extractions and reports from Oracle 8i to 11G within 3 weeks while the estimated effort was of 6 months, by building automating using Unix Shell Scripting (learnt on the job).4. Tuned the Performance of PLSQL code as well as SQL Queries and reduced execution time almost 10x times.

Bengaluru, Karnataka, India

1. Lead an in-house payroll system that wherein delivered a complex enhancement that required rewrite if close to 8000 lines of PLSQL code and database re-design.2. Executed multiple enhancements for the project and improved overall system reliability and user confidence by solving long pending critical bugs.3. Managed a team of 2 resources and mentored them.4. Managed all the communication with internal stakeholders and senior management.

Bengaluru, Karnataka, India

Delivered features for FlexCube Banking product.

New Delhi, Delhi, India

1. Delivered core enhancements for Loans and Deposits, CASA and Regulatory Reporting modules of the FinnOne Core Banking Product.2. Delivered core functionalities of a Regulatory Reporting Project for a Japanese Bank.

Dac, Computers

Bsc, Electronics

Diploma, Application Programming, A+