Mohit Sharma
Greater Noida
Summary
Focused Project Manager adept at planning, directing and maintaining continuous operations in various departments. Experienced in directing manufacturing employees and keeping efficient production in accordance with quality standards. Applying creative and analytical approach to operations for continuous process improvement. Skilled at identifying or anticipating problems and providing solutions. Excels through mentoring, training and empowering team to excel in performance.
Overview
13
13
years of professional experience
1
1
Certificate
Work History
Project Manager
Microland Pvt Ltd, Ernst & Young Global Limited
08.2018 - Current
- Plan and manage multimillion-dollar projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.
- Leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
- Lead scrum team in using Agile methodology and scrum practices.
- Facilitate and lead all scrum ceremonies: Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective, Backlog Grooming and Sprint Demo.
- Known for ability to produce high-quality deliverables that meet or exceed timeline and budgetary targets.
- Led teams across broad technical, financial and business disciplines.
- Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with desired results.
- Worked on Power BI in implementing Calculations, Perspective, and Key Performance Indicators KPI, also providing cube solution in Excel file for slicing and dicing data and analyze KPIs across various dimensions.
- Experienced in creating Automated dashboards using Excel VBA.
- Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis.
- Experience in Debugging, Error handling of sources, targets, Jobs.
- Experience in writing database objects like Stored Procedures, Triggers SQL server databases and good knowledge in MySQL, hands on experience in writing medium level SQL queries.
- Strong Experience with VBA scripting, understanding of approaches for business intelligence, data warehouse.
- Experience in leading mid-size team and offshore-onsite team coordinator.
- Able to handle different projects concurrently and Lead experience.
- Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
- Self-Motivated, energetic, self-starter with excellent analytical, organizational, and creative skills., in GLMS migration and O365 migration Project.
- Validating all GLMS Static and Dynamic groups and plan Validation in coming weeks.
- Advised Client on project tasks, sequences, and estimated time to completion to assist with project planning.
- Work with scrum team to remove conflicts and negotiates well to arrive at consensus for continuous delivery progress.
- Having daily conversation with Customer and update them Migration status.
- Help product owner and development team to achieve customer satisfaction.
- Guides and coaches Scrum team on how to use Agile practices and principles to deliver high quality products and services to our customers.
- Validating Group criteria and results count after migration is done from GLMS to Oneaccess.
- Responsible for ensuring Scrum is understood and team adheres to Scrum theory, practice, and guidelines.
- Coaches Scrum team in self-organization, cross-functional skillset, domain knowledge and communicates effectively, both internally and externally working within Scrum team.
- Plan and Lead Program Increment (PI) Planning meetings.
- Validating Groups (Static and Dynamic) Which got migrated from GLMS to Oneaccess.
- Validating Group criteria and results count after migration is done from GLMS to Oneaccess.
- Working on Missing Attributes project to add attributes in IAMDW database so can extract them.
- Working with TDDH and IAMDw team to finish missing attributes project on time.
- Reporting bugs in DevOps and assigning it to respective team while doing validation of migrated groups.
- Daily importing and exporting country-based data from Flex Manage Database.
- Coordinating with client and deciding which Service line mailboxes (Advisory, CBS etc.) we must migrate
- Analyzing and managing data to create batches as per service line
- Coordination with Ops team and send batches for Pre- migration checks and Pre-flight checks
- Working with Ops team regarding errors during Pre- migration checks and Pre-flight checks
- Working with MS team to upload Replication and Cutover files on Fast Track Portal.
- Working with EUC team to create dashboards and making enhancements in existing dashboards.
- Maintaining Migration tracker to analyze each replication and cutover batches for each country.
- Maintaining SL tracker to record that how many mailboxes got migrated in each SL.
- Identified plans and resources required to meet project goals and objectives.
- Achieved project deadlines by coordinating with contractors to manage performance.
Lead
Synechron Technologies, Wells Fargo
04.2016 - 05.2018
- Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports and Sub reports in Power BI Desktop
- Managed projects from procurement to commission.
- Developed and initiated projects, managed costs, and monitored performance.
- Orchestrated projects within strict timeframes and budget constraints by solving complex problems and working closely with senior leaders.
- Oversaw high profile projects for by planning, designing, and scheduling phases.
- Drove team success through shared vision and recognition of quality performance.
- Eliminated discrepancies in progress by reviewing performance, spend and timeline.
- Acquire and interpret business requirements, create technical artifacts, and determine most efficient/appropriate solution design, thinking from enterprise-wide view
- Trained new team members by relaying information on company procedures and safety requirements.
- Worked different stations to provide optimal coverage and meet production goals.
- Evaluated employee skills and knowledge regularly, training and mentoring individuals with lagging skills.
- Worked in Data Integration Team to perform data and application integration with goal of moving more data more effectively, efficiently and with high performance to assist in business-critical projects coming up with huge data extraction
- Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis
- Working with EUC team to create dashboards and making enhancements in existing dashboards
- Extracted data from flat files/ databases applied business logic to load them in staging database as well as flat files.
- Coached team members in techniques necessary to complete job tasks.
- Identified plans and resources required to meet project goals and objectives.
Senior VBA Analyst
Moneyman, BNP Paribas India Solutions Pvt. Ltd
10.2015 - 02.2016
- Worked in Lean Team for Development and installation of VBA programs for various clients around state.
- Designed, developed, modified and debugged programs.
- Maintained existing applications and designed and delivered new applications.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.
- Coordinated deployments of new software, feature updates and fixes.
- Created KPI, CIO dashboards in Tableau by connecting various data sources
- Data updating on SharePoint site of LEAN Transformation with data procured for different LEAN Architects
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
- Maintain/Upgrade code for LEAN Project plan and other automated dashboards using Tableau Desktop
- Designed client specific modules for automatic reconciliation and tracking database modifications
- Developed utility module for data conversion and exporting to Excel workbooks and VBA programs simultaneously
- Managing and monitoring SharePoint.
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
- Carried out day-day-day duties accurately and efficiently.
- Designed and developed forward-thinking systems that meet user needs and improve productivity.
- Estimated work hours and tracked progress using Scrum methodology.
- Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
Senior Business Analyst
Enlightiks Business Solutions Pvt. Ltd
09.2014 - 05.2015
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Directed business analysts in executing and delivering various tactical and strategic plans.
- Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
- Involved in developing monthly Profitability dashboards using tableau desktop
- Created sites, Document Libraries and managed permissions as requested from users in Microsoft SharePoint 2010
- Managed team performance by implementing measurable metrics to track delivery of supporting requirement artifacts.
- Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.
- Develop site in SharePoint Developer 2010 for users and Creating and managing web parts, page layout and customization of sites
- Worked as Admin of SharePoint 2010 (access rights, uploading videos, adding web parts, document library, lists etc.)
- Automation in excel VBA for CDM-Marketing Project to maintain data as per wise
- Streamlined techniques to support agile methodology implementations.
- Administrating SharePoint
- Managing, creating libraries, profiles in SharePoint.
- Evaluated trends to understand competitive environments and assess current strategies.
- Executed analysis of risks and identified risk mitigation strategies.
Senior Analyst
On Demand Agility Software Pvt. Ltd, Credit Suisse
08.2013 - 05.2014
- Maintain all data structures and data models with help of data profiling tools and techniques
- Coordinated statistical data analysis, design and information flow.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Developed tables, views and materialized views using SQL.
- Transformed project data requirements into project data models.
- Involved in developing reports and dashboards through excel VBA programming
- Provided project-level analysis incorporating proposals, sequence diagrams, and scope matrixes.
- Creating data models and SQL procedures according to client requirement
- Creating VBA application for Data analysis of system during data migration
- Automation testing of applications with help of developer team
- I use my skills to communicate directly with client and gather details of requirement
- Maintaining data of projects according to our client requirements
- Creating monthly report which mentions status of all running projects
- Helping supervisor for creating monthly and all yearly reports regarding projects.
- Investigated and addressed system issues to enhance usability and improve functionality.
- Trained employees on software to improve data management, monitored use and suggested improvements.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
Senior Data Analyst
Helios and Matheson Information LTD, Bank of America
07.2012 - 07.2013
- Responsible for coding in VBA and MS Access, creating tool in MS-Excel according to client requirement on live projects
- Developed, implemented and optimized stored procedures and functions using T-SQL.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Improved application performance by determining root cause of issues and resolving.
- Documented and analyzed business reports for prompt communication, follow-up and ongoing support.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Drove data analysis, resolving complex business issues and proposing long-term system solutions.
- Data analysis using VBA and MS Access
- Preparing Monthly Dashboard for onshore & offshore teams
- Created Signatures and Software using MS Access
- Fetching data from different regions and maintaining using db2 client and also Make report
- Enhancing timely communication of all reports
- Designing templates for On-shore clients and offshore team.
- Ensures that Project Management Office process and processes are kept up to date
- Prepares status reports and updates same to Management team.
Analyst
WNS Global Services
06.2011 - 04.2012
- Worked in developing Reports according to Business Requirements
- Work with clients to understand business issues and data challenges and design, develop, and implement solutions to these problems
- Experience in Requirements Gathering & writing Report Specification documents
- Working on Segmentation and Targeting project to identify key customers in Europe
- Creating and maintaining VBA based excel tools
- Conducted data analysis using MS Access database, Excel Macros, pivot table and VBA programming
- Created automated management reports with help of VBA coding in excel
- Update credit report of customers through different applications
- Working, maintaining and updating MS Access database.
Research Analyst
TCS, Tata Consultancy Services
06.2009 - 06.2011
- Worked on reporting requirements, processes and procedures for capturing, maintaining, and reporting accurate data to client
- Generated Tableau reports on demand for providers
- Working, maintaining and updating MS Access database with client information
- Automation of reports by creating VBA macros and query writing for ad-hoc requests
- Creating maintaining reports and validating data in excel
- Providing post-implementation maintenance support to client for application
- Automation testing of applications with help of developer team
- Maintained traceability matrix in order to keep track of all business requirements
- Plan and design Microsoft SharePoint environments
- Configuring of Microsoft Office SharePoint.
Data Analyst (Trainee)
American Express Technology
01.2008 - 01.2009
- Have worked in EPIC Tool (Enterprise Portfolio Information and Control) which is powerful intranet tool, used to maintain and report information regarding management performance and full life cycle of project management
- Worked in reports with help of VBA coding in excel
- Updated MS Access database with new records of clients
- Got hands on experience on Manage Now Tool, which is Web product designed to help companies manage complex relationships among user's problems, network events, corporate assets, and changes to Information Technology (IT) infrastructure.
- Used Microsoft Word and other software tools to create documents and other communications
- Developed team communications and information for meetings
- Maintained excellent attendance record, consistently arriving to work on time
- Participated in team-building activities to enhance working relationships
Education
PGDIT - Information Technology
Symbiosis Centre For Distance Learning
Pune09.2011
GNIIT - Information Technology
NIIT
New Delhi10.2009
B.Com - Financial Accounting
CCS University
Meerut07.2006
Skills
- Project Development
- Managing Revenue Projections
- Timely Project Completion
- Budgeting and Forecasting
- Business Analysis
- Microsoft SQL Server 2016
- VBA programming in Excel, Access
- Advanced Analytics
- Tableau 90, Power BI
- Databases: Microsoft SQL Server 2016, MS Access Oracle, MongoDB
- MS Office
- Project Team Coordination
Accomplishments
- Completed the [GLMS Migration] Project on time and $[Amount] under budget.
- Presented with the [Award Name] Award for spurring more than [Number]% growth for [Number] consecutive months.
- Improved customer satisfaction ratings by [Number]% by [Action taken].
- Supervised team of [Number] staff members.
- Collaborated with team of [Number] in the development of [Project name].
- Process Improvement - Achieved revenue objective by implementing cost-cutting measures.
Certification
- IAPM - Certified Junior Project Manager
- Certified [Job Title], [Company Name] - [Timeframe]
Languages
Hindi
Bilingual or Proficient (C2)
English
Advanced (C1)
Timeline
Project Manager
Microland Pvt Ltd, Ernst & Young Global Limited
08.2018 - Current
Lead
Synechron Technologies, Wells Fargo
04.2016 - 05.2018
Senior VBA Analyst
Moneyman, BNP Paribas India Solutions Pvt. Ltd
10.2015 - 02.2016
Senior Business Analyst
Enlightiks Business Solutions Pvt. Ltd
09.2014 - 05.2015
Senior Analyst
On Demand Agility Software Pvt. Ltd, Credit Suisse
08.2013 - 05.2014
Senior Data Analyst
Helios and Matheson Information LTD, Bank of America
07.2012 - 07.2013
Analyst
WNS Global Services
06.2011 - 04.2012
Research Analyst
TCS, Tata Consultancy Services
06.2009 - 06.2011
Data Analyst (Trainee)
American Express Technology
01.2008 - 01.2009
PGDIT - Information Technology
Symbiosis Centre For Distance Learning
GNIIT - Information Technology
NIIT
B.Com - Financial Accounting
CCS University
- IAPM - Certified Junior Project Manager
- Certified [Job Title], [Company Name] - [Timeframe]
Similar Profiles
Rohini SundarRohini Sundar
Business analyst at Ernst & Young Global LimitedBusiness analyst at Ernst & Young Global Limited
Chrystalla SavvaChrystalla Savva
Internal Audit Assistant at Ernst&Young Global LimitedInternal Audit Assistant at Ernst&Young Global Limited
Ashutosh MishraAshutosh Mishra
Senior Consultant at Ernst & Young Global Consulting Private LimitedSenior Consultant at Ernst & Young Global Consulting Private Limited