Summary
Overview
Work History
Education
Skills
Timeline
Generic

JUNE PANDEY

Charleston,IL

Summary

Highly motivated Product Manager/Business/System/Data Analyst with 9 years of experience in Information technology industry. Strong knowledge of all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment. Experience in Performance Management to support strategic planning, goal setting, strengthening accountability, and enhancing decision-making to improve client satisfaction. Comfortable and productive working individually or as part of a team with excellent written and verbal communication skills. Strong determination to gain formal and hands- on training in new technologies as well as SDLC methodologies to stay current and fluid in ever expanding technology industry.

Overview

10
10
years of professional experience
3
3
years of post-secondary education

Work History

Business Systems Analyst

Humana
03.2023 - Current
  • Defined and prioritized product backlogs, ensuring alignment with strategis objectives and stakeholders need.
  • Created road map and project plan to launch new products.
  • Directly involved in creating and maintaining various dashboard that gives both clinical, membership and productivity insight of Medicaid market.
  • Created requirements for reports, projections, model and to support medicaid business.
  • Subject matter expert in vastly used Medicaid enterprise data within organizations and vendor domain.
  • Developed style guide, test plan and test cases to perform QA and UAT testing.
  • Worked as liaison between IT and business to minimize the gap of understanding and expectations.
  • Provided data and visualization in various RFP support for new and existing market/state contractual agreement.
  • Successfully Launched consolidated Medicaid Membership Intelligence Dashboard and worked on various other Medicaid analytical solutions.
  • Collaboration with both internal and external team to understand Medicaid data flow and process in data warehouse and beyond.
  • Worked in multiple project which includes but not limited to new market launch in existing dashboards, state RFP support, new product launch, adhoc reporting, utilization, data visualization, data maintenance etc.
  • Facilitated sprint planning , daily stand-ups and retrospective to enhance team productivity.

Technical Product Manager/ Business Analyst

Moreable LLC
06.2020 - 01.2023
  • Worked closely with both internal and external Business stakeholders to help define product strategy to meet their needs while achieving reliability, scalability, performance, and resource costs
  • Acted as liaison between Business and IT team to implement projects to understand both their needs and requirement for smooth transition of projects
  • Lead Agile Product manager of highly functional ERP system (AIOBO) built in-house to facilitate business partners to achieve their goals
  • Extensive knowledge of inventory, accounting, human resources, store, and sales management that was implemented in ERP system
  • Lead support and software product management for both business and IT department to resolve defects and facilitate development as per stakeholder’s requirement which included but not limited to self-serve sales management, commission bases setting, multiple store enhancement etc
  • Created Product roadmap and backlog while assisting whole project team with both business/system requirement and other technical documents
  • Created and executed test cases for multiple products and coordinated in User acceptance training schedules
  • Analyzed both current business and data process to enhance system and fix defects when needed
  • Created dashboards to monitor and track key performance indicators.
  • Generated standard and custom reports to provide insights into business performance.


Project Manager/ Business System Analyst

Army and Air force Exchange Service
04.2018 - 01.2020
  • Interacted with users (both onsite and offsite), gathered requirements, documented and presented briefings
  • Worked on major project to decommission major Mainframe legacy system to web based platform that heavily impacted both Front and Back End
  • Analyzed and documented every step-in detail while migrating these legacy systems to web based platform
  • Created realistic Road map and Product log documents to meet the requirement goal to drive the team in right direction
  • Assisted whole project team with both business/system requirement and technical document to fulfill both business and technical needs of the project.
  • Analyzed the GAP Analysis to understand the key findings, the short term and long-term considerations and its benefits
  • Analyzed both current business and data process to replicate it as much as possible to minimize end user and other system impact
  • Hands on experience with reporting tools such as SSRS and Power BI to fulfill the projects reporting needs and data visualization
  • Acted as User Acceptance Testing coordinator, monitored business testing, and interacted with the development t and QA team regarding defect status and fixes on a weekly basis
  • Involved in implementation phase and helped in production of required documentation for user reference as well as in-house reference using Confluence and JIRA.

Business System Analyst

AT&T Inc
06.2016 - 03.2018
  • Involved in requirement gathering, analysis of the requirements from the business owners and users
  • Actively involved in JAD sessions to identify system requirement and analyze what is the scope of business requirement
  • Worked in various projects that included third party product owner and installation vendor
  • Involved in major migration projects from one system to another
  • System analysis especially with schema and API's (application programming interface) to identify how they impact the application development cycle, business process and GUI
  • Performed Analysis on delivered and proposed Business Interlinks (API's) to determine if Component Interfaces were necessary
  • Performed gap analysis between the AS-IS process & TO-BE process
  • Created API mapping document which is most essential in determining the request and response of API’s for any business rule requirements or changes to fulfill the scope of a project
  • Actively involved in preparing Functional/System Requirement Document and user stories using Rally or TDP
  • Documented each and every step and process flow in Confluence for future reference
  • Handed off the requirements to the ETL (extraction, transformation, & loading) developers, & worked with them on any questions during the process
  • Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
  • Created and maintained various process flow documentation with data flow diagrams using Excel and MS Visio
  • Actively involved with DEV and QA team throughout the application development cycle.

Data Analyst/ Business Analyst

AT&T Inc
01.2015 - 05.2016
  • Involved in requirements gathering and gap analysis between current state and future state of the applications
  • Acted as liaison between managers, stakeholders and Architecture, Design and Development teams
  • Developed and clarified functional specifications, Business Use cases to meet business requirements and design specifications
  • Involved in creating Business Requirement Document, Functional and Technical Design
  • Documents
  • Developed Visio flow charts to depict the conceptual process flows and business process flows
  • Performed Source data analysis and created target mapping documents to meet the business requirements
  • Catalog data development using ATG Merchandising tool for both Dev and Production environment
  • Developed complex SQL queries to analyze the data and develop Mapping Specifications for
  • Data Integrations
  • Used Excel and Tableau reporting for data visualization
  • Worked in major UI optimization project which had major impact on both front and back end
  • Performed feasibility, adaptability study and risk analysis to identify the business-critical areas from the user perspective
  • Extensively interacted with ETL teams and developed data mapping documents to facilitate data loads from flat files
  • Suggested and Implemented performance improvements by tweaking complex SQL queries
  • Organized and code migration across different environments such as QA, Performance and UAT

Education

Master of Science - Human Relations and Business

Amberton University
Garland, TX
06.2017 - 12.2018

Master of Business Administration -

Oklahoma Christian University
Edmond, OK
01.2013 - 08.2014

Skills

    SDLC Methodologies: Agile, Waterfall, Iterative, Lean, Spiral

Databases Oracle: 9i/10g/11g, Microsoft SQL Server, GREENPLUM

Database Tools/ Reporting Tools: TOAD, Oracle SQL Developer, PostgreSQL, ATG, Workbench, Merchandising (catalog), Tableau, Power BI, SSRS

Operating System Windows: Unix, Mainframe

Documentation Business/Functional/System requirement Document: User stories, UML Diagrams, Data Mapping Document, Product roadmap and Backlog Document, Data Dictionary, User specification document, Technical Specification Document, Process Documents etc

Defect/Test/Tracking/Documentation/Management Tool: HP ALM, JIRA, Confluence TDP, Rally, ASANA, Clickup, Azure Dev ops

Microsoft Tools : Microsoft Office Visio, Microsoft Office Suite Office

Other Application: Altova (XMLspy), Oracle JDeveloper

MBA: Agile Project Management, Managerial Communications, Organizational Behavior, Project Initiating and Planning

Product Management certification eCornell University

Timeline

Business Systems Analyst

Humana
03.2023 - Current

Technical Product Manager/ Business Analyst

Moreable LLC
06.2020 - 01.2023

Project Manager/ Business System Analyst

Army and Air force Exchange Service
04.2018 - 01.2020

Master of Science - Human Relations and Business

Amberton University
06.2017 - 12.2018

Business System Analyst

AT&T Inc
06.2016 - 03.2018

Data Analyst/ Business Analyst

AT&T Inc
01.2015 - 05.2016

Master of Business Administration -

Oklahoma Christian University
01.2013 - 08.2014

Similar Profiles

CREATE PROFILE
JUNE PANDEY