Ramchandra Kulkarni Email & Phone Number

Philadelphia, PA, US

• Data Architect responsible for design & Implementation of SAP Hana to Snowflake Migration Project.
• Designed Conceptual, Logical and Physical Data models closely aligning with Universal data model Methodology.
• Engaged in Technical discussion with Client stakeholders to understand the requirement and align them with technical implementation.
• Configured & Managed Snowflake Account enabled with Multi-factor Authentication for Environments (Dev/QA/Prod) to ensure SOX Compliance.
• Physical design Of Enterprise Data Warehouse (EDW) leveraging Snowflake Schema, Including Type 2 Dimensions, Facts and Transactions.
• Designed & developed Multi-layered Automated Process to ensure Business Continuity and Data availability for Ad-hoc Reporting and Custom Visualization.

Pune, Maharashtra, India

1. Engineered module design,Planning and development for Phase1 O2C Solution. Leaded the feature development and testing of Various Modules with help of development team. 2. Configured multiple API Connections by leveraging BOOMI to Stage Data in Snowflake and Testing Staged Entities to Verify the End Product.. 3. Configuring FIVETRAN and Setting up roles.

India

1. Loading Source Data Via Matillion APi Connection in Snowflake and applying Masking on the Data.2. Implemented Roles, Hierarchy in Snowflake to ensure Data Security for Multiple Team members.3. Backfilling and Eliminating dups in Staged Records before we move to Step 2 i.e designing data Warehouse.4. Fixing Prod Matillion issues and using the change JIRA.

Montevideo, Uruguay

1. ETL developer for migration of Customer Data of Well known Media Platform Client VIACOMCBS.2. ETL Design and Implementation of migration of data from SQL Server ON Premise Data warehouse to Snowflake.3. Using the Snowflake experience of Compute, Enhancing the Estimated Time of UP Time for Production loads.4. Coordinating and Mentoring the team of 10.

India

1. Working with a team of 5 to Understand and implement Viacom Data warehousing Strategy Data Using SSIS.2. Working on creating multiple Stored procs and functions on SQL Server 2015 to Load the data and perform Manipulation on Data.3. Working on migrating an Old ETL Process Staging data in Oracle from Multiple Source to Microsoft SQL Sever 2015 using.

Ahmedabad

1. Development and Unit Testing of ETL using MICROSOFT SSIS 2015 Tool for UK's Customer RANK.2. Worked on creation of Single Customer view for the data received from Varied Source System using Profisee Maestro Tool(MASTER DATA MANAGEMENT).3. Development for Reports using SSRS.4. Agile methodology learning and adoption.5. Address Standardization using PAF.

India

1. Supporting Web application. 2. Patch deployments on Prod and Non-Prod environment.3. Maintenance of Servers4. Monitoring of Alerts for Websites.5. Managed Tickets in Service Now