Looking for a job

Shilpa Lomate

@shilpalomate

I build utility analytics, data warehouses, and AI-powered BI products using Oracle and Power BI.

I've built and implemented BI products and data lake platforms for more than 22 years, including Impresa Insights for utilities companies. I led its solution architecture and feature delivery for energy-theft identification, appliance-level energy disaggregation, and analytical reporting using machine learning models.

Across Oracle, Abjayon Consultancy, Tata Consultancy Services, and Cambridge Technology, I've designed data warehouses, ETL pipelines, star schemas, and reporting solutions for utilities, telecom, research, finance, and travel organizations. I work across Oracle Data Integrator, Oracle Analytics, Power BI, SQL, PL/SQL, GoldenGate, Kafka, PySpark, and data visualization tools.

Experience

Work history, roles, and key accomplishments

Testing Lead

Robinhood

Apr 2026 - Jul 2026 (3 months)

Coordinated with business and development teams on changes, updated test scenarios, led the team, resolved defects, and documented enhancements and cutover tasks.

FCCS Anaplan Test Management Documentation

Data Architect

DTCC

Nov 2025 - Apr 2026 (5 months)

Designed and developed ODI mappings and packages to load data into Oracle Autonomous Data Warehouse, extracted data from Apptio API, leveraged ODI audit tables for metadata management, and automated ticket creation on failures.

PPM Apptio Oracle Data Warehouse Automation

Power BI Developer

Carnival Cruise Line

Mar 2025 - Aug 2025 (5 months)

Designed and developed end-to-end reports from Essbase cube to Power BI, extracted and transformed data, configured parameters for reporting, and documented design and data mapping.

Essbase ExoInsight Power BI data transformation

Solution Architect

Abjayon Consultancy Pvt. Ltd.

Jan 2022 - Jul 2024 (2 years 6 months)

Served as Solution Architect and Development Manager for Impresa Insights, an AI/ML-based analytical solution for utilities, overseeing feature development and reporting with Power BI, Oracle Data Visualization, and Kibana.

Linux StarRocks PySpark Kafka Power BI ML models Deep Learning NILM Solutions Architect Development Management

BI Architect

Abjayon Consultancy Pvt. Ltd.

Apr 2020 - Mar 2022 (1 year 11 months)

Designed and implemented custom star schemas in the Oracle Utilities Analytics product for Dicle Elektrik Dagitim, a Turkish electric utility, and documented design and data mapping.

Linux Oracle 12C Star Schemas

BI Architect

Oracle India Pvt. Ltd.

Jul 2012 - Apr 2020 (7 years 9 months)

As BI Architect, designed and implemented enhancements and releases for Oracle Utilities Analytics, migrated ETL tools to Golden Gate and ODI, and developed POCs using AI for Next Best Action.

Linux Windows

BI Developer

Cambridge Technologies Enterprises Ltd

Jun 2008 - Jul 2012 (4 years 1 month)

Designed and implemented a data warehouse solution for tracking research and development of dog and cat feeds, integrated SAP, and upgraded the system to Oracle 11g stack.

Data Warehouse SAP Integration

Developer

Cambridge Technologies Enterprises Ltd

Jun 2008 - Apr 2010 (1 year 10 months)

Developed the PAWS solution to track research and development of dog and cat feeds, and maintained data load flows.

Oracle 10g

Technical Analyst

Tata Consultancy Service Ltd.

Apr 2007 - May 2008 (1 year 1 month)

Worked as Technical Analyst and Developer on the XPRO data warehouse solution for Xerox, documenting low-level design and developing POCs on dimensional load in OWB 11g.

Oracle 10g OWB Workflow Data Warehouse

Technical Analyst

Tata Teleservices Limited

Nov 2004 - Oct 2006 (1 year 11 months)

Worked as Technical Analyst and Developer on the TTSL Data Warehouse solution, designed BI star schema, and developed reports in Discoverer and Cognos.

Cognos Data Warehouse Star Schemas