Shobhit D.

Experience

• 

  Mu Sigma Inc.

  Jun 2013 - Jun 2014

  Trainee Decision Scientist

  Provided data analysis and consulting services to a Fortune 25 Company to guide them in understanding key factors driving their sales and to help them reduce their inventory costs by developing predictive models.• Generated hypothesis and created regression models using SAS and MS Excel to perform exploratory data analysis. • These models were used to improve their accuracy of sales forecast by 10% and reduce inventory costs by 20%• Developed dashboards and stories using Tableau to provide insights and strategies for efficient marketing and for better inventory planningPresented ad-hoc business analyst services to an American multinational corporation to solve a business case and help them strategize project goals in order to eliminate fatal incidences in manufacturing plants.• Developed business cases for proposed ideas by the client and designed UI for mobile applications• Demonstrated strong understanding of data models and SDLC phases in a project lifecycle• Guided IT team in performing UAT and Stress Testing for launching a new product Show less

• 

  BE Networks

  May 2015 - Dec 2015

  Software Engineer Intern

  Assisted the iPhotonix engineering team with responsibility including planning, execution and delivery of IT and business process for a data visualization project using SQL, MS Excel, d3.js, JavaScript and jQuery.• Prepared project plan by eliciting requirements from client on a weekly basis• Integrated large interrelated data sets and performed data pulling and data manipulation using SQL• Created real-time, interactive visualization using terabytes of data and developed UI for the web application using d3.js, JavaScript and Tableau Show less

• 

  Fannie Mae

  Nov 2016 - Sept 2017

  Business Analyst

  Treasury Accounting Future State (TAFS): This is a Treasury - Capital Markets project and our target is to develop a Transactional Data Source (TDS) system. This system is a central repository for Fannie Mae, which processes debt and derivatives trading and security data from our upstream systems. TDS processes, enriches and transforms this trading data and archives it using Oracle database. TDS also publishes this data in ECF format to our downstream systems intraday as well as in the form of end of day summary files. Downstream systems for TDS includes various teams within Fannie Mae like Accounting, Reporting, and Cash Management and Forecasting systems.My responsibilities during the project includes but is not limited to the following:• Facilitated Sprint Planning meetings for prioritizing Sprint backlogs• Worked with SMEs to identify, understand, and document business needs for trading data• Analyzed trading and security data for various financial instruments like Fixed Income Instruments and Derivatives • Created User Stories by brainstorming, and one to one meetings with the business users• Analyzed trading and security data for OIP (US Treasuries, Repurchase Agreements), Fixed Income Securities (Fannie Mae issued) and Derivatives (Swaps, Swaptions, Caps, Futures) to create data mapping document for development team• Facilitated walk-through sessions to help development and QA team to break down large user stories into smaller tasks• Created and regularly updated the Stakeholder Requirements Document after each sprint• Used SQL queries to retrieve, validate and test data stored in Gemfire data cache and Oracle• Acted as a Scrum Master by facilitating retrospective meetings, with project manager and development team, to identify and address the issues faced in previous phase• Assisted testing teams to build test plans, test scenarios and validate test cases for functional requirements verification Show less

• 

  The World Bank

  Jan 2018 - Jun 2019

  Business Analyst III

  Loan Funding Workflow System (LFWS): Loan Funding Workflow System is a web application used by Treasury team users to update loan rates for any type of loan issued for projects in various countries by International Finance Corporation (IFC), World Bank Group. • LFWS system was developed to streamline loan rate submission process and automate the tracking and management of forms• Gather business requirements for LFWS system and document them by creating a BRD and FRD• Supervised offshore technical team and ensured timely delivery of project deliverables which helped business stakeholders reduce errors in form tracking and management from 10% to 0.01%• Wrote test scenarios and validated test cases to perform unit and integration testing and assisted business users in performing UATFinancial Sustainability Reporting System (FSRS): FSRS is used to generate P&L statements for International Finance Corporation (IFC). This system is used for analytics and reporting by all of IFC investment operations, budget & finance network, portfolio analysts and advisory services. The project is to enhance the FSRS system to better align with evolving business needs.Responsibilities:• Interacted closely with stakeholders and clients for gathering business requirements • Analyzed P&L line item data to understand requirements for generating P&L statements and reportsTime Recording System (TRS): TRS is a corporate system providing time recording & management functionality for International Finance Corporation (IFC) staff. • Interacted closely with stakeholders, SMEs and business users for gathering business requirements• Understand and analyze project data, time reporting data and resource data to update and enhance data model and database structure and improve non-functional performance of the system Show less

• 

  City of Whitehorse

  Sept 2019 - May 2022

  1. Assist the Program Manager in projecting the annual maintenance and licensing budget for ERP project 2. Manage the support and development related issues and ensure that they are timely responded to and resolved3. Research & implement new business processes available in ERP software that were previously untapped, like Workflow Maintenance for Invoice Approval and Requisition Workflow4. Maintain efficient communication between vendors, stakeholders and business users by conducting frequent meetings5. Plan for ERP software maintenance and version upgrades in a timely manner as new releases are launched6. Implemented new projects in ERP like document management system in form of NextCloud for the city council and Dynamics GP Web Implementation to move light GP users to the web client7. Planned, managed and implemented the Virtual City Hall (VCH) project for the City of Whitehorse8. Launched VCH to the public in 2021 to provide online services to the users to pay utility bills, print property tax notices and statements, sign-up for e-billing and preauthorised paymentActing Program Manager1. As an acting Program Manager, I was selected as a member of the Capital Ranking Committee to rank the Capital Projects for Year 2022 - 2025 for the City of Whitehorse2. Prepared and evaluated purchasing documents like RFP, RFQ, Purchase Orders as per procurement management best practices for software renewal, maintenance and licensing3. Forecast and prepare the annual capital and operating budget for the following fiscal year for ongoing and new projects4. In the absence of our Manager, led & managed the Business & Technology Division during my tenure as an Acting Manager Show less 1. Plan, develop, configure, maintain and administer the City’s ERP system including software, hardware, and databases2. Analyze business processes and systems across the organization and recommend improvements including identification of business requirements and business processes in alignment with departmental and corporate needs3. Provide support for the City’s ERP system, including system hardware and software updates, assisting with year-end procedures, creating, modifying and testing reports, user support, and creation of technology system documentation4. Plan and manage business and systems analysis projects, including consultant controlled projects, and develop recommendations to improve departmental and organizational productivity in alignment with corporate goals5. Control and maintain end user ERP system account administration, including user security, roles, permissions and groups6. Establish standards, procedures, and policies for ERP technology systems, their implementation, maintenance, monitoring, technology best practices and use7. Perform database management activities including tuning and performance evaluation in conjunction with the GIS/Database Specialist8. Conducted training sessions for city staff, management and elected officials in the use of various software and hardware9. Assisted with preparation of Information Systems’ capital and operating budgets Show less

  • IT Project Coordinator

    Oct 2020 - May 2022

  • Business Analyst

    Sept 2019 - Sept 2020
• 

  G Adventures

  Jun 2022 - now

  Project Manager

  Lead & manage multiple projects in parallel, like Workday Implementation projects (Workday HCM Implementation, Workday Financial Management Implementation), UK Payroll Implementation & Data Migration Project, and the Financial & Revenue Mgmt. Reporting Project.1. Lead project kickoff meetings with project stakeholders to kick-off the project2. Develop and monitor Project Schedule using Smartsheets, and adjust milestones & deliverables when the project is delayed to ensure that the final Go Live date is not impacted3. Use project management tools like Work Breakdown Structure (WBS) to determine the project scope & schedule and estimating effort required to implement each task identified in the WBS4. Perform business analysis tasks on an ad-hoc basis like requirements gathering & documentation and test scenarios documentation & test management5. Conduct sprint planning meetings with the agile project teams at the beginning of each sprint cycle, to plan sprint tasks & monitor sprint backlog6. Conduct daily Scrum calls to monitor project progress and to identify key issues or hurdles and address them based on its criticality and impact7. Conduct sprint retrospective meetings to discuss lessons learned after each sprint8. Document RAID Logs to identify project risks, decisions and action items9. Manage the third party implementation vendors’ teams and monitor implementation of the project as per the planned schedule & budget10. Conduct periodic meetings with vendor’s Project Manager and Delivery Assurance Manager to monitor the health of the project and to discuss mitigation plans if the project shifts to a Yellow or a Red status11. Develop Unit Tests & End to End (E2E) test plans, and monitor the testing progress using ClickUp & Google Sheets12. Ensure efficient communication channels are established during the entirety of the project, from initiation to closure, using various communication tools like Slack, emails and in-person or virtual meetings Show less