Summary
Overview
Work History
Education
Skills
Timeline
BusinessAnalyst

Maneesh Jain

Naperville,United States (+1)

Summary

A result-oriented Senior Business Analyst/project manager having twenty plus years of experience and extensive knowledge across the project life cycle in Systems Development Life Cycle (SDLC) including Waterfall, Agile application development. An expert in the fields of Data Warehousing, Business Intelligence, Data Integration, Databases and SQL.

Overview

26
26
years of professional experience

Work History

Senior Business Analyst

McDonald's
Chicago, IL
05.2017 - Current
  • Work as liaison between business and development teams.
  • Lead offshore development/support teams.
  • Partner with Product team, SMEs, and stakeholders to map the current state systems and processes
  • Assist with project management tasks including meeting preparation, notes, and follow ups
  • Assist with project status reports/dashboards and communicates updates to stakeholders at a regular cadence
  • Participate in appropriate Agile practices to maximize team collaboration and delivery of value to stakeholders: sprint planning, backlog grooming, retrospectives, daily stand-ups, and task board utilization.
  • Work as technical expert (Data Warehousing, Database, SQL)
  • Meet with clients; gather requirements, timelines, and documents.
  • Perform gap analysis to identify different systems involved in project and discuss options with clients.
  • Document the use cases/user stories and functional requirements from project business requirements and as-is system behavior.
  • Document system impacts, data flows and exchange between systems
  • Work with technology team to refine project requirements and review designs and test plan results to confirm that line of business goals is met.
  • Some of the major projects in the current role:
  • Integrating Cash and Inventory and Scheduling applications with Oracle GL to transfer journal entries as part of the legacy application retirement
  • Integrating Oracle HCM with McDonald's labor scheduling application to extract employee data
  • Worked as technical architect/lead analyst for People Data Warehouse application for HR reporting on AWS cloud. Created data mappings with various data sources.
  • Worked as lead analyst in the Facebook Workplace global implementation.
  • Worked with McDonald’s ID Management teams to design/implement an improved Global user ID management system
  • Worked as Project Manager/Lead on several releases of the DSPT application, a shift positioning tool for restaurant managers.
  • Worked with management and stakeholders to evaluate and select alternative HR Reporting solutions

Senior Data Warehouse Analyst

McDonald's
Chicago, IL
12.2010 - 05.2017
  • Worked as ETL lead during Oracle OBIEE implementation for Financial BI Reporting.
  • Led team of offshore developers (contractors).
  • Designed and developed complex ETLs, SQLs and PL/SQL scripts.
  • Designed and developed Micro ETL (using synonym swap) for real time GL data load during month end.
  • Designed/implemented integrations between Sales/Real Estate/Quality Control/MDM/DRM/Hyperion applications with Oracle Financial Data Warehouse
  • Worked with DBA for performance tuning of ETLs and SQLs to improve daily incremental load timings by 40%
  • Met with clients; gather requirements, timelines, and documents.
    Perform gap analysis to identify different systems involved in project and discuss options with clients.
  • Documented use cases/user stories and functional requirements from project business requirements and as-is system behavior.

Data Warehousing Consultant

Toyota Financials
Chicago, IL
05.2009 - 12.2010
  • Worked as technical lead to integrate Oracle BI with various applications (Oracle, SQL Server, Flat files) to create Delinquency Movement Matrix in BI data warehouse resulting in improvement of 40% from old system.
  • Gathered requirement, created functional/technical specifications.
  • Designed new star schema.
  • Created ETL mappings and guided junior team members with ETL creation and BI report design and development.
  • Worked with QA team to complete integration testing and bug fixing.
  • Worked with DBA team during deployment.

Senior Technical Consultant

SE Technologies
Stamford, CT
08.1996 - 05.2009
  • Worked as Senior Technical Consultant, worked on several Baan ERP implementations.
  • Provided after go-live support to several ERP clients.
  • Worked closely as senior analyst/technical consultant in several upgrade/enhancement projects.

Education

Master of Science - Computer Science And Math

Guru Nanak Dev University
India
07.1989

Skills

  • Business Analysis
  • Requirements gathering
  • Project Management
  • Data Warehousing
  • ETL tools (Informatica, ODI)
  • Oracle SQL/MySQL/T-SQL
  • Data Integration
  • UAT/ Software Testing
  • Unix Shell Scripting
  • ERP
  • JIRA
  • Agile
  • SharePoint
  • Microsoft Office suite

Timeline

Senior Business Analyst

McDonald's
05.2017 - Current

Senior Data Warehouse Analyst

McDonald's
12.2010 - 05.2017

Data Warehousing Consultant

Toyota Financials
05.2009 - 12.2010

Senior Technical Consultant

SE Technologies
08.1996 - 05.2009

Master of Science - Computer Science And Math

Guru Nanak Dev University

Similar Profiles

CREATE PROFILE
Maneesh Jain