Mehnaaz Sharma

As a Program Manager on Marketing Data Engineering (MDE) team, I lead key initiatives & drive growth across various Business Units collaborating within MDE teams, Finance, Analytics, Commerce at EG. I am responsible for end to end delivery of projects for critical enterprise data products that drive business performance and Trading decisions for Marketing channels and Finance. I've managed and executed 100+ initiatives with 95% of them meeting defined scope and timelines through lean management & efficient project deliverability. I've boosted cross-functional team efficiency through efficient project tracking, effective risk management & communication. I've started Leading MLS and advanced analytics programs earlier this year that are crucial to drive business insights. I've adopted innovative project tracking, decision driving, collaboration boosting techniques that have remarkably increased project execution efficiency.

As a consultant worked at Following corporations in Retail, Banking, Travel & Technology domains in different capacities.

• Analyzed data to solve business problems using complex SQL queries. Validated data using reports and dashboards in PowerBI.
• Based on month end labor consumption numbers, suggested product type recommendations including renewal types to existing and new customers.
• Comprehended complex business pricing logic based on consumption data of a customer.

• As Product Manager on Egencia Global Alliance (EGA) team, led the project to acquire, integrate global partner travel data through a combination of powerful online reporting services and offline reporting to provide deeper insight and cost control opportunities.
• Created project scope, roadmap and user stories, acceptance criteria for engineering team.
• Owned partner relationship, communication, acquisition of new partners (local travel agencies) in new countries. Came up with specific measures for specific partner data demands/capabilities such as language limitations, local market offerings, technical limitations etc.
• Updated data specification, project requirements to travel industry standard through market research and comparing competitor offerings.
• Came up with ideas for Product feature development and visualization for score carding and showcasing quality metrics.
• Retained key client business by resolving long drawn issues by chalking out resolution path and managing end to end delivery.

• Based on analysis of customer portfolio data to discover patterns, trends and understanding background of the tool via sessions with business SMEs, came up with recommendations, for marketing team to target right set of customers for product marketing emails to revive the product.
• Performed Data analysis, problem solving by writing complex SQL -queries in Teradata using analytic/aggregate functions, table joins and sub-queries.
• Created reports with key metrics and data in Tableau to understand overall business and trends.
• Performed resource and project planning and managed overall project delivery and status reporting.

• Performed detailed Data Analysis on Customer insurance data such as spend over various years, multiple policies bought to solve data problems.
• Wrote Source to Target mapping and technical design documents for data acquisition from new sources. Finalized requirements and created Business and Technical Requirement Specification Documents to define scope of work.

• Streamlined acquisition of reporting requirements and specifications to disseminate across multiple business lines and IT support teams.
• Solved analytical Product related problems using detailed data analysis through SQL.
• Produced Adhoc reporting and visualization using Cognos reports.
• Analyzed and synthesized business requirements, including conceptualizing processes and recognizing patterns.

• Gathered requirements, finalized features for Essbase upgrade project.
• Streamlined operational efficiencies, gathering requirements to facilitate on-time, under-budget corporate transitions.
• Managed projects and served as primary liaison between client and multiple internal groups to clarify goals and meet standards and deadlines.

• As part the Evaluation team, recommended Planning tool for Finance team to help plan their expenses and analyze cost saving opportunities for their 500M retail operation cost. Researched and analyzed operations to ascertain detailed client needs such as functional/technical requirements and end user expectations.
• Prepared Request for information (RFI) and vendor response templates with functional, Technical, support and Implementation info from participating vendors. Rate vendor and recommend tool based on analysis and scoring after presentation and demos.

• Spearheaded Version upgrade of Essbase suite of applications to enable better functionalities and maintenance of application by working with vendor, collaborating and managing infrastructure and IT teams involved, performing sanity checks and user acceptance.
• Ingested data from SQL 2005 to Essbase cube via EIS Essbase Integration services. Performed Design/Modification of Essbase Cubes through Essbase Application Manager. Created and modified Hyperion Financial Reporting using key finance KPIs.