Rohit Shinde Email & Phone Number

Chicago, Il, Us

o I currently lead data engineering comprising of EMs, Tech Leads & Engineers focused on creating meaningful marketplace for consumers to shop for financial products across Guaranteed Rate.o Envisioned & currently leading efforts to build a scalable generic plug and play measurement analytics platform for Machine Learning model development to enable ML teams measure quality, cost, efficiency, stability, and accuracy for ML modelso Envisioned and leading efforts to develop a solution to enhance privacy of user data in data warehouse from generation/ingestion to consumption.o Direct and manage multiple teams of software engineers and managers and foster their growth to level up their careers and performance management.o Drive the product strategy and roadmap from the engineering side working with the product team.

Charlotte, Nc, Us

Charlotte, Nc, Us

Charlotte, Nc, Us

o Lead database design and development effort for enterprise marketing data solution.o Building real-time/asynchronous data ETL processes using Apache Kafka and Nifi platform.o On-board all the new acquisitions into the enterprise marketing data platform for customer 360- degree view and marketing efforts.o Support broader marketing and product initiatives across the organizationo Responsible for supporting database(s) on production environment.

Charlotte, North Carolina, Us

o Implement data warehouse solutions for specific clients, in a repeatable fashion, leveraging the Quaero platform where possible and enhancing it when necessary o Implementation focus includes but is not limited to: data model design (typically star schema approach), ETL processing, system integration, customer data matching and hygiene, data auditing and profiling, database tuning and scalability, and business intelligence reporting o Performs unit testing and assists in user testing of programming modifications o Adherence to pre-defined programming standards set by Application Architects o Provide technical estimations in level of effort for client change orders and prospect proposals o Mentor more junior data warehouse developers o Develops recommendations to refine development standards and platform architecture o Assist in the design and development of reusable assets capable of being integrated into the overall solution offering o Translates high-level requirements into well designed solutions that meet the business and technical goals defined by the requirements o Develops and maintains effective partnerships across the organization o Leads and facilitates technical design and code walk-through sessions o Working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in SAP Data Quality tool.o Managed the central and local repositories using the Management console and Repository Manager in SAP Data Quality tool.o Working with different dashboard for various client using tableau software.

Charlotte, North Carolina, Us

o Provide insights about client's customer data through data analysis and data research.o Responsible for supporting database(s) on production environment.o Lead database design and development effort for existing customer database solution.o Troubleshoot, determine root cause of data issues and bring incident/issue to closure.o Provide technical expertise and best practices for database support; including data load, performance tuning, job scheduling and monitoring.o Develop and support data validation systems, metadata, and ETL infrastructure.o Develop and support data hygiene and customer matching routines.o Work to continually improve client's database solution with a focus on process improvement and database re-architecture.o Responsible for maintaining the database integrity.o Responsible for scoping, design, and development of database enhancements.o Mentor and provide technical leadership to junior team members.o Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.o Working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US/International Data Cleansing using the First logic data quality tool.

Englewood, Colorado, Us

o Creating ETL processes from various data sources to our centralized marts, creating and modifying reports based on scope.o Used complex join conditions to retrieve data from the databaseo Optimized indexes using the Index Tuning Wizard and Rebuild indexes.o Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, and established Joins.o o Created SSIS Jobs and scheduled then for run.

New York, Ny, Us

• Create procedures, functions and triggers to enforce business rules.• Used complex join conditions to retrieve data from the database• Optimized indexes using the Index Tuning Wizard and Rebuild indexes.• Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, and established Joins.• Developed Cubes in SSAS and created Reports and Charts in Excel.• Developed different Dashboards using Tableau Software for varroius Clients.• Created Media Spend, Competitive Dashboards for different Markets.• Worked with the QA team in solving the bugs • Created SSIS Jobs and scheduled then for run.

• Perform software design and development on multiple projects• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.• Rewrote SQL queries to upgrade SQL Server performance using SQL Server/2005• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.• Writing some C# code in Script task in SSIS

Masters, Software Engineering

Masters, Software Engineering

Bs, Electrical And Electronics

Education record