Nikhil Kulkarni

Domain: Insurance

Description:

• Acquire data from Credit Unions and migrate it to Snowflake for refining, cleansing, translation, validation, and processing for further analysis by the business team and feeding it to multiple downstream by Data Sharing to help them use it to serve CUs.
• Designed and developed data warehouse dimensional model using snowflake schema and defined all the databases, schemas, tables, and attributes to be implemented in Snowflake DW. Setup Role Based Access for Account Admins, Developers, Analysts, Business Users and System users for their usage of Snowflake.
• Designed and implemented Data Sharing of dimensional information between accounts in the organization for collaborative and secure sharing of data among them.
• Designed and built continuous data migration pipeline from on prem data storage to cloud Snowflake DW using AZCopy, Azure Storage Container as Staging Integrations and Snowpipes.
• Designed and built data staging tables in Snowflake for ingestion of data and perform refining, cleansing, validation, and pre-processing on data as defined by the business using Snowflake SQL, Stored Procedures, Tasks and Streams.
• Written time travel queries for restoration of the data as backup plans for the changes done in production environment to make sure no data loss due to changes made.
• Built zero-copy clones of databases, schemas and tables for developers and analysts to work with them without impacting the production data and minimizing cost to business.
• Implemented Virtual Warehouses for different users based on their consumption of compute resources for optimized usage of credits.
• Designed and built dashboard in PowerBI for showing usage of Account resources in Snowflake for monitoring resource and credit consumption in Snowflake, helping business with decision makings to control cost incurred.
• Designing and developing process for data ingestion from different Credit Unions having heterogenous data storage systems.
• Worked closely with application teams to integrate Snowflake as backend in their application using JDBC and ODBC drivers and help them setting up their resources for optimal utilization, controlling cost to business.
• Working alongside business analysts and product owner to formulate acceptance criteria and decide priority of work and build work breakdown and resource breakdown based on requirements gathered.
• Preparing and presenting WSR, MSR and QSR reporting to management for their insight of progress of the project.
• Partnered with project team members to identify and quickly address problems.
• Developed and trained junior team members by leveraging industry experience to achieve optimal project strategy.
• Set up and managed team meetings.
• Adjusted project plans to account for dynamic targets, staffing changes, and operational specifications.

Domain: Insurance

The objective of the project is to divide the input file initiative wise so that the files can be processed by respective departments

Description:

• We follow Agile methodology for code development
• As a part of the DEP team, it’s my responsibility to deliver the files to the client in the best acceptable manner
• We get Prod defects as well
• We have to resolve them in the immediate sprint and then promote the code till Prod at the earliest
• We have Sprint calls on daily basis along with frequent Sprint planning as well as Sprint
• Retrospective calls for all the teams across geographies.

The objective of this project is to migrate the Application data from APAC Region (Hong Kong and Singapore) to Zurich.

Domain: Investment Banking

Description:

• We have data related to 30+ applications to be migrated from HK and SG Booking centres to the Head Quarter Zurich
• Delivering correct data to the client along with proper data checks
• Working on various code design tasks involving creating and testing the code with creating unit test cases
• Worked on automation tasks ensuring better performance and minimum manual intervention
• Fixing the bugs and looking into the failures and fixing them
• Creating and maintaining the documents on various applications on the project for better understanding of the team
• Frequent client and Onsite interactions through calls and emails for requirement gatherings, work assignment and presentation
• Development and deployment of various changes in the code per the client requirements.

The objective of the project is to acquire client data and convert it into the in-house Property management data specifications.

Domain: Property Management

Description:

• MRI to Voyager Conversion of JPM database includes migration of more than 900 MRI tables to SQL
• Server 2012 in three phases having business critical data on a new platform of in-house built product “Voyager”
• Worked directly with client representatives to prepare project plan
• Developed Informatica workflows to use in migration of schema and data to SQL Server 2012
• Worked with DBAs to tune performance of the migrated Database.

The objective of this project is to deliver the correct data to the client on daily basis meeting the SLA and fix the problems that occur during the process, inline to this there were Issue Analysis, enhancement, automation, up gradations, documentations and defect fixing involved

Domain: Insurance

Description:

• Delivering correct data to the client on a daily basis making proper data checks
• Working on various enhancement tasks involving creating and testing the code with creating unit test cases
• Worked on automation tasks ensuring better performance and minimum manual intervention
• Fixing the bugs and looking into the failures and working on them
• Creating and maintaining the documents on various applications on the project for better understanding of the team
• Frequent client and Onsite interactions through calls and emails for requirement gatherings, work assignment and presentation
• Development and deployment various changes in the code per the client requirements
• Maintaining historical trends of the changes and enhancements documents and the release versions
• Performing Analysis and work on the further changes required with other teams
• Analyzing the code and detecting the bottle necks for performance tuning of the code
• Taking Cross KT of various applications in the project
• Working on tickets created for the data or the by the users
• Participating in Migration and Up gradation Activities
• Co-ordinating with other teams like Autosys, Database, Unix, Axway and other teams in regards to the issues and ensuring the resolutions as per the SLA of the client
• Interacting with the clients and assisting them troubleshoot the Informatica errors and helping them understand the functioning of the code and their features.