Umesh Shirsat

Product Engineer

Pune, Maharashtra, India25 yrs 10 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

20+ years of experience in database architecture.
Expertise in OLTP and OLAP systems.
Proven success in large-scale project implementations.

Stackforce AI infers this person is a Database Architect specializing in Retail Analytics and Data Warehousing.

Contact

umesh_s@hotmail.com LinkedIn

Skills

Core Skills

Database ArchitectureData ModelingData ArchitectureDatabase Design

Other Skills

CassandraJavaPerformance TestingMetrics DefinitionETLData WarehousingDashboard EnhancementDashboard DesignData AggregationBest Practices GuidanceTeradataEnterprise SoftwarePerformance TuningBusiness IntelligenceDimensional Modeling

About

Expertise in Database architecture, Data modeling, Application and Product development. Highly accomplished, hands on, database architect with over 20+ years track record of success in building complex OLTP applications, ER modeling in Oracle, dimension modeling for database warehousing in Teradata, business intelligence, Retails Analytics in Netezza and Cassandra, performance optimization and object oriented design. Worked extensively on large scale projects from inception to implementation. Proven ability to tackle and succeed in all endeavors from high-dollar business development to customized software development and implementation. Repeatedly successful in navigating complex technical environments. Specialties: Database Architect for OLTP and OLAP systems. Expertise in data modelling and UML modelling for implementations in Oracle, Teradata, Netezza, Cassandra, C, C++, ProC, Java on Unix Operating systems.

Experience

25 yrs 10 mos

Total Experience

5 yrs 2 mos

Average Tenure

13 yrs 10 mos

Current Experience

Ibm india private limited

2 roles

Database Architect

Oct 2016 – Present · 9 yrs 7 mos · Pune/Pimpri-Chinchwad Area

Database architect on the product team for the development of Merchandising Insights an OmniChannel product. It will crater to Online and brick & Mortar Retail Stores.
Modelled the Cassandra database to host multi-client (tenant) data.
Worked closely with On Shore (Canada) GUI team and Offering Manager to define the Sales and Product metrics, drill down capabilities.
Worked with business counterpart to capture the Orders, Shipments and Store metrics in Cassandra database. Modelled drilled down capabilities to Store level to capture metrics like capacity, sent, pending, pickup, Alerts, fulfillment rate.
During resource crunch shouldered additional responsibility of Java coding for Off-Boarding tenant feature.
Prepared large data for performance testing on Cassandra.

CassandraJavaPerformance TestingDatabase ArchitectureData Modeling

Data Architect (Shopper Insights)

Jun 2012 – Sep 2016 · 4 yrs 3 mos · Pune/Pimpri-Chinchwad Area

Database architect on the product team for the development of Shopper Insights. Shopper Insights is an analytical tool for the retail and CP (Consumer Product) industry.
Fully automated the SI ETL scripts for all data going into SI datawarehouse.
Enhanced TLog processing to handle holidays with no data.
Modified TLog datastructure and scripts to handle txn_id of 38digits for Sam's Club
Designed the Txn Return feed ETL, Table Structures and enhanced the Shopper Insights product to give Net Sales and Metrics. This was kept configurable to switch on/off based on client.
Shouldered responsibility of another colleague after he left Shopper Insight project.
Enhanced the Business layer for flexible dashboards to have Trip Level count.
On-boarded new client Coop Sweden and got them setup in 3 months which included historical data loading.
Designed and implemented a configurable sampling TLog mechanism specifically for Coop Sweden.
Tuned Affinity Flexible dashboard by 300% gains
Designed and implemented debug facility for Flexible dashboard to log the actual user input.
Helped Technical Services folks to load Targets 6 new segment types historical data

ETLData WarehousingDashboard EnhancementData ArchitectureData Modeling

Demandtec, an ibm company

Data Architect (Shopper Insights)

Jul 2010 – May 2012 · 1 yr 10 mos · San Mateo, CA

Data Architect on the product Shopper Insights, which provides key understanding of the retail consumer behavior. The product is used by retailers and CP (Consumer Product) manufacturers.
Architected the ETL infrastructure for Shopper Insights to provide the feeds for Product Hierarchy, Stores, Transaction Log, Guest Id.
Designed and coded the Affinity, Market Basket, All Commodity Volume (ACV) weekly and quarterly aggregations.
Semi-Automated the scheduling and execution of SI ETL scripts using Tidal.Provided guidance to members of other apps on infrastructure, best practices on setting up ETL processes.

ETLData AggregationBest Practices GuidanceData ArchitectureData Modeling

Netflix

Database Architect

Aug 2008 – Jun 2010 · 1 yr 10 mos · Los Gatos, CA

Database architect on the platform team for the development of NetFlix enterprise datawarehouse (Teradata V12).

Data Architecture

Paypal

Database Architect

Mar 2004 – Aug 2008 · 4 yrs 5 mos · San Jose, CA

Database Architect and analyst for the development of TREx datamart and ADM (Analytical datamart). TREx is a short term forecasting tool for Paypal(eBay).ADM is a transactional datamart which provides insight into the customer, revenue, and payment flow of paypal system

Data Architecture

Cisco systems

2 roles

Database Designer

Nov 2002 – Mar 2004 · 1 yr 4 mos

Designer and analyst for the development of project SPARX. Sparx is XML message based tool used for configuring Cisco product, before they can be placed for ordering.

Database Design

Database Designer

Mar 2000 – Oct 2002 · 2 yrs 7 mos

Module lead and analyst for the development of project Integrated Commerce solutions. ICS is a complete ordering solution catering to the top 50 business partners of Cisco.

Database Design