Sumit Aggarwal

Designed and implemented a centralized data store architecture to consolidate GL extracts from Oracle and manual mapping files. 

Developed data transformation processes to cleanse, validate, and harmonize the data from diverse sources. 

Employed appropriate data integration techniques to ensure accurate and efficient data loading into the central store. 

Collaborated with cross-functional teams to ensure data integrity and maintain data governance standards. 

Utilized PowerBI, a powerful data visualization tool, to design and develop interactive dashboards tailored to the needs of C-suite executives. Leveraged PowerBI's functionalities to create visually appealing charts, graphs, and tables that provide meaningful insights into expense reports. 

Implemented calculated fields and measures to enable comprehensive data analysis and comparison across different parameters. Ensured the dashboards were intuitive, user-friendly, and aligned with the specific reporting requirements of the C-suite.

Led agile cross-functional teams to define and execute product roadmaps by utilizing SaaS capabilities to build wide range of data products, platform capabilities and monitoring tools, supported personalized customer experience, dynamic marketing optimization and fraud prevention.

Defined the organization’s data governance strategy and led a team of analysts, engineers, and product owners to improve productivity and product quality for privacy team resulting in over 40 million of annual revenue.

Built data governance and controls around risk management, privacy, data quality, lineage, access, security, legal and retention.

Actively participate in scrum ceremonies including backlog grooming/refinement, defining acceptance criteria for stories, and working with the development teams to fully explain feature requests.

Mentorship: Actively engaged in recruiting, on-boarding, and training new talent on the team.

Leadership: Pitched new business solutions to reduce cost for routine data collection by 90% at Deloitte Virtual Vegas Global Summit 2020.

Analyzed patterns based on historical data on investments in the bonds market space.

Designed wireframes and built prototype for internal products and successfully pitched execs on launching a new division.

Developed an investment recommendation model for high-volume customers thereby improving client engagement and investment likelihood by 60%.

Product lead for blockchain and mobility service areas within firm. Developed a B2B & B2C distributed ledger solution for public transportation system.

Implemented proof-of-concept which increased profit by 45% with new investors. This was the key driver in successfully closing $5 million fundraising round.

Led the QA team of 3 and collaborated with 2 product managers and 4 business groups to develop test plans, use cases and address issues, quickly resulting in higher customer satisfaction.

Conducted Market research and Competitor analysis to narrow down the basic features and layouts that need to be implemented.

Managed CMS & ERP projects using Agile and delivered consistent business process and product improvement resulting in cost savings of over $300K.

Created the yearly project roadmap and drove consensus among the executive team.

Coordinated with cross-functional stakeholders to drive business requirements into product deliverables.

Developed CMS and ERP web applications for Hikari Tsushin’s subsidiary companies.

Designed and developed two large scale systems used by over 10,000 members sales team.

Responsible for end-to-end SDLC development, as well as maintenance of Hikari legacy projects.

Leadership: Presented insights on key product drivers at the IoT Japan 2016, Tokyo Big Sight in Tokyo.