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.• Setup Role based Access Control to ensure Data security between Multiple Stakeholders and restricting unauthorized Access to Sensitive information.• Leveraged snowflake Enabled Multi-Cluster virtual warehouses for different workloads along with Auto-Suspension & Resumption and economically utilize the Warehouse Usage. • Implemented performance and cost optimization techniques for multiple Data flows hence reducing load time. • Created Multiple Stored Procedures to process Transaction, Dim and Fact Data to cater for User data Reporting and Financial Reports.• Worked on Power Query to Test Snowflake Data Quality against existing Hana Data.• Performed Data Quality Checks, Cleansed the incoming data feeds as and profiled the source systems data as per business requirement.

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, Formats in Snowflake to ensure Smooth error-free data flow from multiple Sources.4. Created 50+ Workflows for Curating Data from Stage Via Snowflake Procedures and Functions to Address to Business Logics and Calculations before reaching the Final data Warehousing layer.5. Creating Automated Mechanisms to generate 100+ Views in 3 different layers individually in one Click to Ensure Business Continuity and Data Availability.6. Developed Summary, Cost to Company Dashboards and other insights for better visualization and decision making using Snowsight.7. Responsible for defining architectural plan along with strong technical design which is scalable and flexible enough to incorporate future enhancements and requirements8. Responsible for the development of O2C solution and mapping the business requirements to systems and technical requirements to ensure they are in line with the enterprise architectural plan.9. Design Key mechanisms, such as data access error handling, logging, and reporting for O2C.10. Review O2C documentation as requested to ensure it meets the standard is horizontally integrated and fulfills the process strategy of JADE. 11. Performing POC for new integration such as NetSuite, Coupa, Billing Platform etc. for Next Phase Development and providing evidence for Successful Test run.12. Worked on exploring new areas/Technology Stack to further Enhance the model.

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 Process to move the changes to Prod.5. Using Matillion Git process to Check in Developed /Production Put Source Code.6. Implemented SNS topics for Multiple Sources to Notify Stakeholders for the Data Ingestion Results.7. Experienced Tableau Admin, Have performed TSM licensing, backgrounder issue Fixing, Server issues, Logs Tracking and Coordinating with Tableau Support team for Major issues.8. Implemented Dependency Check Shared Job in Matillion for which double checks Matillion tasks and an internal log table created and Lets/Stops job from running in case of Case condition met.9. Suggesting and help Best practices implemented to Client team to use Warehouse ,Clustering , scaling , Time travel. 10. Adopted Agile methodology for the project and Following best practices including Deployment Process, Alerts , Logging Tickets etc.

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 Offshore and Nearshore and helping Transition of information from Clients to Team effectively.5. Involved in Multiple Client calls being in Nearshore EST time zone , thereby Providing utmost Support to Client requirements.6, Participated , organized and Guided in Code Reviews and Code Demo Calls for the team.7. Collaborated with Cloud technology providers (Snowflake and Microsoft) to do POC to analyze performance and cost for migrating data to Cloud.8. Loaded Data in AWS S3 Bucket from the files extracted from the SQL Server DataBase and then Staging them to Snowflake using Python Coding.9. Creating Snow Pipes for Continues Data Ingestion.10. Implementing Snowflake Time Travel ,Fail-safe and secured Data Sharing Along with Exploring Multiple Compute methods to increase Performance and Experience.

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 Microsoft SSIS.4. Understanding the pinpoints in the Migration ad Building the way out of it.5. Maintaining the Strategy and Tasks in JIRA and logging Hours to track the flow of Process.

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 MatchCode Tool. 6. Stored Procedure, Functions, Views Creation for Data Loading and Viewing in SQL Server 2012.7. Client Reporting for the anomalies and data Discrepancies.

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