Chayan Gupta

Roles and Activities :

Project Manager :-

• Led the creation of end-to-end project plans, encompassing blueprint, backlog grooming, design, build, and testing phases, ensuring alignment with project objectives and successful delivery of Sprint/projects.
• Managed project timelines, resources, and budgets, tracking progress against milestones and proactively addressing any deviations or roadblocks.
• Implemented a robust tracking system to monitor the progress of user stories through all phases: grooming, build, and testing.
• Regularly reported on project progress to stakeholders, highlighting key metrics such as the number of user stories completed, bug rates, and sprint velocity. Provided insights and recommendations for course correction when necessary.
• Led daily stand-up meetings to track the progress of user stories and identify any roadblocks.
• Proactively followed up with team members to ensure timely completion of assigned actions, escalating any roadblocks or delays to the appropriate stakeholders.
• Identified and resolved bottlenecks in the workflow between BA, Dev, and QA teams, streamlining the process for completing pending actions and improving overall team efficiency.
• Monitoring of demands and keep track of critical deliverables
• Provide weekly/monthly updates to Management,Client and stakeholders.

Change Request (CRs):-

• Prepared Impact Assessments (IAs) and Work Breakdown Structures (WBS) for Change Requests, ensuring accurate evaluation of impact and detailed task breakdown
• Facilitated communication and collaboration between internal management and client teams to ensure a smooth and efficient CR approval process.

Budget Planning :

• Tracked and monitored budgets for multiple GP codes, to record expenditures, analyze variances, and generate weekly reports.
• Developed and maintained LOE forecasting models, providing accurate projections of future LOE consumption
• Prepared and delivered weekly LOE reports to stakeholders, summarizing key financial metrics, highlighting variances, and providing insights into budget performance.

Resource Planning :-

• Prepared and monitored capacity plans for BA, QA, Dev, and IT teams, optimizing resource allocation and ensuring project demands were met.
• Adjusted capacity plans as needed to accommodate changing project priorities and resource availability.
• Administered resource plans within ERP, creating resource assignments, allocating work hours, processing extensions, and submitting open position demands.

MIS :

• Developed, maintained, and generated dashboard reports providing a 360-degree view of project performance for project directors and management.
• Weekly approval of TER and preparing Plan Vs Actual report for TER Discrepancy.
• Managed the weekly approval process for Timesheet Report (TERs) and prepared Plan vs. Actual reports to analyze TER discrepancies.
• Enabled accurate project tracking by maintaining up-to-date schedules, status reports, and budgets in project management software.
• Prepared detailed Level of Effort (LOE) reports for accurate resource planning and project forecasting
• Developed and maintained MIS reports for tracking and analyzing expenses, shifts, bonuses, and overtime

Travel and Expense management :

• VISA Plan Management (who should get visa/due date/visa expiration) and Travel plan management (travel requests/ticket, trips prolongation/ email approval requests) and preparation of MIS of same.
• Review and approve travel expense reports as per agreed project travel policy

Invoicing and Contracts :

• Working with project documentation, contracts, tracking customer's payment schedule, communicating with customer on payment issues and agreeing on the signing of contracts
• Working with invoicing team to prepare, validate and sent customer invoices on approval from PM/PD..

Jira:

• Create Customized reports and Dashboards in Jira for different teams to track hours, Status and key Metrics.
• Created Different set of filters by using JQL query.
• Creating and tracking Bugs and Issues raise by Customer.

Administrative :

• Providing Approval of access to project BASS, TMS, SPS3 space, Teams, JIRA.
• Preparation of Shift , Bonuses and Overtime in ERP.

Project Management (Planning,Coordination,Monitoring ):-

• Plan, Monitor and Coordinate all aspects of projects from initiation to closing i.e during Project life cycle.
• Assisting in gathering information from users ,defining issues,creating problem tickets and follow up with different squad to provide structural solution.
• Participate in project planning, daily stand up meeting ,demos,retrospective and release planning and other related activities.
• Preparation & Monitoring of Project Plan using Ms- Project (MSP).
• Resource estimation and planning.
• Defining road map and prioritizing backlog of work to meet vision in a timely manner.
• Planning & Monitoring AOP and Business Plan for all Clusters, provide regular updates to the MDs office via weekly and Monthly MIS- Plan vs actual.
• Preparation of Budget for the project and monitoring the same in SAP.
• Project Coordination with Stakeholder in order to support , meet deadline and maintain project schedules.
• Tracking Task lists, milestones as per AOP with cluster planners, highlighting deviations, delays etc. and suggest corrective measures.
• Guide cluster planners towards smooth Functioning from Program Management perspective.
• Strategic planning with other HODs to foresee deviation from Programs/ AOPs and make recovery Programs.
• Facilitating periodic review mechanism from MD's office and maintaining same
• Guide and monitor cluster planners for change management- Schedule and Budget.
• Track important business milestones Plan vs actuals (Revenue, Activities, Scope).
• Collaborate with Clusters and Departmental functions at CO for Quarterly review by top management.
• Proactively identify opportunities for improvement, risks, anomalies and growth
• Continuous endeavors towards innovation and optimization of process to increase organizational efficiency.
• Communicate effectively with all levels of individuals.

MIS and Data Analytics (Power BI & Advance Excel)

Reports :-

• Prepared single sheet dashboard for decision for decision maker depicting details for Project Milestone ,Project Progress ,Project issue ,Charts of all ongoing project.
• Lead/take complete ownership of assigned data visualization and dashboard efforts across subject areas within Construction domain.
• Weekly Review with Project Team Using Pivot (Table ,Slicer ,Timelines) .
• Prepare Top management (Financial report ) on Monthly basis adhering to AOP targets as per business plan .
• Plan Vs Actual Reports to measure deviation or Variation .
• Preparation of Tender Reports for Management to mitigate risk.

Responsibilities:

• Ability to work directly with Stakeholders to understand requirements and provide recommendations on how best to display data in report or visual dashboard.
• Participated in Project Planning session with Director ,Project Manager, Business Analyst and team members to analyses business requirement and outline proposed solution.
• Strong analytical skills with ability to collect, organize, analyses, and disseminate significant amounts of information with attention to detail and accuracy.
• Data Modelling ,Preparation & Visualization.
• Regular MIS and Dashboards using and Business analytics tool .All clusters all Departments. Collate, processes, and analyses MIS data to provide insights to top management on critical action items.
• Experience on understanding DAX Functions in Power BI and created calculated columns and measures using DAX. .
• Experience Data preparation such as shaping data in Edit Query like add columns, split column, pivot column, unpivot column, changing data type and managing columns. Combined tables and columns by append queries and merge queries in Power BI .

Secured 8.35 CPI in PGP

Secured 7.00 CGPA