Nisha Mishra
Fredericton,New Brunswick
Summary
Having 15+ years of experience in Data Analytics and Reporting Services in FMCG and Beverage industries. Creating tables in Teradata and execute complex queries for required data and analysis purpose, Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function Built dashboards in Power BI tool for Commercial, Financial planning and budgeting, KPI reporting, Consumer Insights, Supply Chain Analytics and other based on business requirement Good at Analytical thinking, programming, Interpersonal skills, Team (handle 9 members team) and project management and keen to learn new concepts which require deep analysis. Worked on Python and advance excel for big data analysis and performed lean projects.
Overview
18
18
years of professional experience
Work History
PMO
Fidelity Information Services
11.2021 - Current
- Create project management reports in Power BI to help Directors and CIO’s to manage all projects and achieve their goals
- Tracking all Goals status and Risk associated with that
- Conduct meeting with all Directors to help them to manage all projects
- Manage 4 members teams and leading projects as per Goals of Company
PMO
Infobahn Softworld
07.2020 - 09.2021
- Create project management reports using Qlikview and/or NPMS (In-House Tool) that help all managers to do better resource management
- Monitor NPMS for changes to Resource allocations and notify affected PM’s
- Work with PM and Functional Managers to import resource plans into NPMS
- Work with PM’s on identifying issues and recommending improvements in NPMS
- Track down required inputs from Functional Managers and PM
- Creations and updating of Resource Plans in NPMS and provide status
- Identify changes in SG dates and create analytics based on reasons for the slip, amount of each slip, etc
- Track Original Commit dates vs Current Projections for all projects and provide dashboard view
- Measure other important metrics/analytics as they become defined.
Principal Analyst (Power BI developer)
ABInBev
11.2017 - 01.2020
- Developed high level test matrix based on business requirement, functional and technical specification, and development standards for assigned projects/application in Power BI
- Created and deployed cubes in star and snowflake schema
- Performed data analysis and statistical model in Python
- Developed Power BI reports and dashboards from multiple databases sources (Teradata, SQL Server, excel, csv and pbix files)
- Performed data quality analysis using advanced SQL skill
- Performed dimensional analysis, statistical analysis, and data quality validation in data migration
- Extensive SQL querying on data warehouse and Data mart
- Used Dax language for custom calculated measures and advance visualization to build reports and deploy to clients and team
- Designed Power BI data visualization utilizing maps, scatter plots, pie, bar and density charts
- Generated ad-hoc reports in Power pivot using Power BI and shared with decision maker for strategic planning
- Utilized Power Query in Power BI to Pivot and Un-pivot data model for data cleaning and data massaging
- Automated reports fully and minimize refreshing/maintenance time by applying advance technique and data normalization
- Attending calls to understand requirement and implement in process and project
- Leading the Team for any new Project Initiative
- Transform data from on premise to Cloud platform
- Managing all tables creation, access, SQL queries in Teradata.
Business Analyst (Market Research)
TATA Consultancy Services Ltd
07.2007 - 11.2017
- Prepare reports of findings, illustrating data graphically and translating complex findings into written text
- Seek and provide information to help companies determine their position in the marketplace
- Gather data on competitors and analyse their prices, sales, and method of marketing and distribution
- Collect and analyse data on customer demographics, preferences, needs, and buying habits to identify potential markets and factors affecting product demand
- Devise and evaluate methods and procedures for collecting data, such as surveys, opinion polls, or questionnaires, or arrange to obtain existing data
- Monitor industry statistics and follow trends in trade literature
- Measure the effectiveness of marketing, advertising, and communications programs and strategies
- Forecast and track marketing and sales trends, analysing collected data
- Attend staff conferences to provide management with information and proposals concerning the promotion, distribution, design, and pricing of company products or services
- Conduct research on consumer opinions and marketing strategies, collaborating with marketing professionals, statisticians, pollsters, and other professionals
- Direct trained survey interviewers.
Analyst Eureka Operations
The Nielsen Company Limited
08.2006 - 10.2007
- Involved in various business operations of the organisation
- Responsible for generating Market Research Reports to increase the productivity of the organisation
- Successfully achieved cost-effective production using Lean methodology with increased efficiency, quality and satisfied customer service
- Handled the tasks of documenting business process by identifying the requirements of clients
- Involved in transition of database from old platform to new
- Conducted training sessions of Nitro and Excel related to business processes for fresher
- Handled the tasks of Customised Report building for business process for different clients
- Assigned the tasks of Quality Related Documents Management
- Create ideas to enhance the productivity of team
- Certified with best team award in 2007.
Education
Master of Science Applied Mathematics -
M.S. UNIVERSITY OF BARODA
Vadodara, Gujarat04.2006
Bachelor of Science Mathematics -
M.S. UNIVERSITY OF BARODA
Vadodara, Gujarat04.2004
Senior Secondary School Certificate Science Stream -
Kendriya Vidyalaya Harni
Vadodara, Gujarat05.2001
Secondary School Certificate Science Stream -
Kendriya Vidyalaya Harni
Vadodara, Gujarat04.1999
Skills
- Power BI
- Alteryx
- Base/Macro SAS
- MS Office 2013 & 2010
- Qlikview
- PPT
- SQL Server
- Teradata
- Team Management
- Scrum methodology
Languages
English
Hindi
Gujarati
Awards
- Received 2 awards from Nielsen for achieving best performance in 2007 and 2010.
- Nominated for Star Performer of the Month Award by TCS.
- Received GOLD Award in Nov-2011, for handling the big project of imp client Waitrose with good management and achieved result before timeline.
- Received Certificate of Implementation from 'Ideamax' for presenting process improvement idea.
- Received Performance Linked Award for best qualitative and quantitative performance.
Timeline
PMO
Fidelity Information Services
11.2021 - Current
PMO
Infobahn Softworld
07.2020 - 09.2021
Principal Analyst (Power BI developer)
ABInBev
11.2017 - 01.2020
Business Analyst (Market Research)
TATA Consultancy Services Ltd
07.2007 - 11.2017
Analyst Eureka Operations
The Nielsen Company Limited
08.2006 - 10.2007
Bachelor of Science Mathematics -
M.S. UNIVERSITY OF BARODA
Senior Secondary School Certificate Science Stream -
Kendriya Vidyalaya Harni
Secondary School Certificate Science Stream -
Kendriya Vidyalaya Harni
Master of Science Applied Mathematics -
M.S. UNIVERSITY OF BARODA
Similar Profiles
Mithun DasMithun Das
IT Team Lead at CMS IT Services Private Limited and CLIENT : Fidelity Information Services India Private ltdIT Team Lead at CMS IT Services Private Limited and CLIENT : Fidelity Information Services India Private ltd
Madhusudan NMadhusudan N
Senior Database Analyst at Fidelity Information ServicesSenior Database Analyst at Fidelity Information Services
Amaresh SatapathyAmaresh Satapathy
Network Analyst 3 ( Permit to Operate Projects) at Fidelity Information ServicesNetwork Analyst 3 ( Permit to Operate Projects) at Fidelity Information Services
Jagadeesh ChitragarJagadeesh Chitragar
A) Senior Business Systems Analyst at Fidelity Information Services Ind Pvt. Ltd.A) Senior Business Systems Analyst at Fidelity Information Services Ind Pvt. Ltd.
Logan MacNeilLogan MacNeil
Registration, Systems & Data Clerk at Service New BrunswickRegistration, Systems & Data Clerk at Service New Brunswick