Mohit Arora Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, Ca, Us

Boston, Massachusetts, Us

Boston, Massachusetts, Us

Boston, Massachusetts, Us

Played several key roles for various client engagements. Some of the most recent roles played include:• Delivery lead for an enterprise data management program for a large integrated energy company, and managed delivery for an analytics platform to support informed decision making for the business• Data Architect for one of the largest and most complex data migration and reference data management for a Trading Platform implementation program, designed the migration process, reference data, contracts and positions data management strategy • BI design lead on an analytics program for a large Canadian Investment bank that let the business get a consolidated view of the cash flows from all the derivatives traded in the various regions of the bank

San Mateo, California, Us

Business Intelligence (BI)/Enterprise-Warehouse projects at the client have historically been expensive and time-consuming. To improve time-to-market and enhance the business user experience, client needed to evolve towards a holistic BI and analytics-oriented capability while adopting agile methods– aligning to enterprise strategies where it makes sense. Client partnered with Sapient to assess the current Business Intelligence (BI) technical architecture and produce a set of recommendations and actionable roadmap with next steps.Responsibilities:• Lead workshops with various stakeholders and users of the BI platform to assess the current state• Define a reference architecture to determine areas of improvement• Create a target state architecture and recommendations for process improvements to make the BI platform more efficient• Create a roadmap for the client to follow to move to the proposed target state in a gradual progression• Advise senior leadership at the client organization on industry trends and the applicability of the next generation evolution in the BI space

San Ramon, Ca, Us

Worked as delivery lead for multiple data management initiatives for the midstream business of the client. Key data management initiatives rolled out to the organization include defining an enterprise data governance and data quality management strategy, building a data quality monitoring platform, creating an analytics strategy and roadmap for the organization, building a business analytics repository and rolling out data governance to the organization. Technical environment –Sql Server, IBM Datastage, SSIS, Biztalk, Tibco Spotfire, SSRS Responsibilities:• Lead delivery for various enterprise wide data management initiatives for the Pipeline business of the client• Manage delivery teams across multiple geographies to deliver an analytics platform to support informed decision making for the business• Design a Data Quality Management Platform that is leveraged by multiple business units in the organization to assess the quality of data• Develop a data governance charter for the organization and lead the effort to rollout the charter to the organization• Define an analytics strategy for the organization and create a roadmap to realize the strategy and the vision

San Ramon, Ca, Us

Data Architect for a large Openlink Right Angle implementation to lead the migration of Client’s North American Physical Trading business. The implementation included defining all trading scenarios and re-modeling trades in the new trading platform, setting up the reference data in the new system and validating the realized and un-realized PnL after the migration.Responsibilities:• Lead the Data Management tracks for a major Openlink Right Angle implementation program to migrate their trading organization’s NA Physical business to Right Angle• Design a strategy for Reference Data Management, Contracts, positions and Transportation Schedules to be migrated to Openlink Rightangle from their legacy systems and spread sheets• Lead the overall delivery for the migration tracks and define the strategy to validate the business migration using a robust framework built to validate PnL and Risk valuations for the trades and positions migrated• Define the cutover strategy spanning multiple weekends to ensure there is no disruption to the business

Toronto, Ontario, Ca

Solution Architect for a Cashflow Analytics platform for the Valuations group in the bank. The repository was built to server as a single store for all the future cash flows (fixed and floating side) for all the derivative products traded in the bank. The repository is a part of the shared services to which any of the downstream systems can subscribe and request for data. Technical environment –Oracle 10g, IBM Datastage, OBIEEResponsibilities:• Lead the design to create a trade data repository to store all the cash flow information from various trade systems used by traders in different geographies• Solution Architecture for the Cashflow Analytics platform and the Data Repository• Data Modeling, Process workflow and BI design• Effort estimation and planning for the design and delivery

Toronto, Ontario, Ca

BI lead for an Analytics Program to develop a real-time analytics program for a large back office accounting and P&L reporting repository setup for the bank. The program is designed to allow business users to report real-time on all the trade accounting and P&L information as it arrives in the front office systems.Technical environment –Oracle, Real-time BI (Active Pivot), UNIXResponsibilities:• Lead the design for an in-memory analytics engine to give the business the ability to link trades with their corresponding hedges and to get a view of their consolidated exposure, updated real-time, as new trades are captured in the different trading systems• Research on in-memory BI Engines, Pivot table solutions• Data Modeling, Process workflow, Cube Design

Zurich, Ch

Technical lead on an analytics program focused to gain more insight into Institutional Clients and Funds. The federated Data warehouse built extends its reach to around 2000 people across multiple geographies, enabling analytical reporting using Business Objects and interfacing with an in-house CRM application via J2EE web services. The BI repository built was used to analyze various instruments and their market movements, create customer segments and analyze their portfolios to compare against industry benchmarks. The project delivery team was split between UK and India. Technical environment – Informatica, Business Objects XIR2, Oracle, PL/Sql, UNIX, Autosys Responsibilities:• Lead the development of a business intelligence program for the equities research division of the investment bank. • Data Modeling, Process workflow, Data Marts Design.• Liaising with the Business Analysts to run requirement gathering workshops.• Requirements Analysis and Business Design.

Barcelona, Es

Developed, and led a data warehouse design for a Pan-European travel portal offering access to over 500 airlines, 45,000 hotel properties and more than 7000 car rental locations worldwide. The Analytics Platform built on the data warehouse was used to analyze the bookings data, user behavior, product trends and flag potential fraudulent bookings. Technical environment – Informatica, Business Objects XIR2, Oracle, PL/Sql, UNIXResponsibilities: • Development, Support Lead, Team Lead for a development tracks• ETL Development using Informatica• Reports Development on Business Objects

Executive Mba, Class Of 2024

Bs, Computer Science