Uploaded File
add photo
Sarthak
sarthakagrawal194@gmail.com
602-831-9415
Phoenix, AZ 85051
Sr. Digital Analyst/Project Manager
9 years experience W2
0
Recommendations
Average rating
36
Profile views
Summary

EXECUTIVE SUMMARY

  • Highly experienced in Business Analysis, Quality Assurance & Project Management for enterprise-wide implementations using Agile methodologies.
  • Extensive Experience in assisting complex, large scale global projects in Enterprise Resource Planning (such as SAP & Dynamics 365), Insurance and Digital Marketing domains.
  • Proficient in Project Delivery, Quality Assurance, Product Development, and technical cross – functional projects
  • Full Life cycle experience in Project Management from getting project requirements, collaborating with teams, testing and delivery
  • Conducted Joint Application Development (JAD) sessions, Created User Stories/Use Cases and responsible for Agile Sprint releases.
  • Interacting with Business Partners on Business Objectives, KPIs, and Quality Control
  • Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision.

TECHNOLOGIES

  • Business Skills -Requirements Gathering, GAP Analysis, Impact Analysis, Feasibility Analysis, BRD, FRD, Data flow diagrams, Business Process Modeling, Big Data (Data Analytics & Data Mining)
  • Business Modeling and Mock-Up Creation Tools -Microsoft Visio, Lucid Chart, Tableau, UML
  • SDLC Methodologies -Agile, Waterfall, Scrum
  • CRM Tools & Project Management Applications - Atlassian Confluence, MS Project, MS SharePoint, JIRA, Splunk, MS Office (MS Word, MS PowerPoint, Excel, Outlook), QuickBooks, Ryver, Trello, Slack, Service Now, Remedy force/Salesforce
  • BI tools -WEBI, Xcelsius, Tableau, Crystal Reports, Power BI
  • ETL Tools- SAP BOBJ 4.2 SP6, MS Dynamics 365 F&O, Informatica
  • Documentation Tools -MS OneNote (free-form information gathering and multi-user collaboration), DocuSign (facilitates electronic exchanges of signed documents, Authentication Service, Workflow Automation), SnagIt
  • Data Extraction and Analysis Tool -Audit Command Language (ACL)
  • Working Knowledge of Web Technologies - HTML, MS Team Foundation Server (TFS), My SQL, Power BI, Aha! (Product Management tool), Web Services, CCNA, Cloud Services (IaaS, PaaS, SaaS), SnagIt, Change Management, SWOT, MOSCOW
  • Cloud Technologies Exposure -MS -Azure, AWS, Oracle Cloud
  • Operating Systems -Windows 7,8,10, XP/Vista/Mac OS X

Experience
Sr. Digital Analyst/Project Manager
Information Technology
Jul 2020 - present
Arizona, LA
  • Worked as a Scrum Program Analyst for a major Platform Consolidation project and executed the entire consolidation.
  • Implemented Kanban principles for Sprint Planning backlog refinement, sprint planning & retrospective that resulted in reduction of cycle time by 1.8% thus increasing team's throughput in less than 8 weeks.
  • Involved in the full lifecycle for the Big Data solution including requirements analysis, solution design & development with ETL concepts
  • Responsible for a complete Project development life cycle in MS Dynamics 365 (Business Process Flows, AR/AP, Supply Chain Management, Inventory Management, Project Forecast, Procure-to-Pay, SIS Project Cost Module, Production Scheduling)
  • Work closely with Project Management, Dev-Ops & testing teams to deliver the project.
  • Supported Dev-Ops & Testing teams with API management and engaged with Business Units (US) for Platform consolidation.
  • Conducted research and financial analysis on business in US market which ultimately led to the successful termination of the "At Home" direct selling business.
  • Created a comprehensive Project Plan outlining all tasks and deliverables supporting the development of an enterprise data model
  • Created a more efficient project tracking system that increased transparency of the projects by 3.8% and eliminated QA defects.
  • Collaborate with key stakeholders and delivery teams to define achievable release schedules and maintains processes for tracking, cost accounting and JIRA stories to define the direction and scope of the project.
  • Managed the transformation process of manual reward code creation by accepting recipients' data from FTP/SFTP server, analyzing it and sending reward code to recipients automatically for them to redeem it for any digital item.
  • Created and managed multi-currency digital items catalogs for recipients to timely redeem it using a reward code.
  • Analyze the legacy systems and functionality to build business processes by creating a new system aligned with AUGEO's Customer Loyalty Platforms.
  • Assisted in redesigning the whole rewards platform according to the new business needs by creating multiple web page mock-ups using Lucid Chart and Google mock up tool.
  • Coordinated all Scrum Ceremonies including Sprint Planning, Daily Standups, Sprint retrospectives, Sprint Demos, Backlog Grooming, and Release Planning with Scrum framework.
  • Data analysis of meter data in MDM and generating reports, identifying data mismatches and proposing data fix solutions
  • Accountable for completing Test Life Cycle (TLC) of multiple applications such as splunk by preparing Testing Strategy, Testing Approach, Daily Test Execution Status Report, Defect Management Process, Weekly/Monthly Project Status Reporting & collection of Quality Metrics
FTP Project Management Scrum Stakeholder Engagement
Remove Skill
Digital IT/QA Analyst- Finance ERP
Banking/Financial
Jul 2020 - present
Arizona, LA
  • Worked with business stakeholders to define and track key product performance indicators (KPIs), as well as release-specific success metrics
  • Conducted high-level requirement gathering sessions with Business Owners, risk analyst and concerned
  • Supported SAP system, which requires understanding and maintenance of Master Data for the whole City, encompasses training coordination including ECC, eProcurement and BW reporting (SAP Modules)
  • Business Reporting for Master Data, financials and budget using SAP BOBJ and works on building WEBI dashboards Prepared Analytical reports by analyzing heavy files containing 1 million+ records of data
  • Developed interactive SAP BOBJ dashboards as required using multiple reporting tools (i.e. Lumira Designer, Discover, Webi, Xcelsius, Crystal Reports, etc.)
  • Validated checks via Audit Command Language (ACL) program for warrant verification based on City Policies and Regulations.
  • Manages the feature development and defect backlog on a daily basis to ensure that priorities adhere to the strategic direction outlined by the Product Manager
  • Managed and coordinated the deployment of the SAP Validation Client and SAP GUI, for other employees in the Finance Department and helped validating 1500 failed invoices in the system
  • Key liaison between vendors, regional IT personnel and SAP core team, ensuring IT infrastructure requirements were in place, on time to deliver a successful go-live
  • Generated Dynamics-365 Financial reports (WIP Reports, Production Performance, Project Cost Analysis Reports, Forecasting Trend Analysis Reports) and complex data reports using WEBI, Power BI and Tableau to meet client requirements.
  • Managed data migration workstream within the established project budgets in D-365 with Project Manager for potential deviation
  • Worked over ETL processes Improvements
  • ETL error logging via Service Now and data purge and created training documents and supported Vendor Invoice Management (VIM) system through multiple tasks
  • Worked over incident management with RemedyForce and change management with SAP ZCHG to keep the records updated.
  • Oversaw and ensuring delivery of all aspects of data analysis, mapping and transfer and provided troubleshooting and update services for SMEs that use created simulations

Technologies: D-365 F&O, SAP-BOBJ, Business Explorer (Bex), WEBI, Tableau, Power BI, UAT, ETL, Big Data, ACL, Vendor Invoice Management (VIM), MS Visio, Lucid Chart, Salesforce, MDM

Crystal Reports ETL Quality Assurance Requirements Gathering UAT
Remove Skill
IT Analyst
Information Technology
Aug 2017 - present
  • Research the core competency of major competitors like Microsoft (MS Azure) and Dell and solution to target globally.
  • Social media management and marketing team leader including fraud/spam detection and management, leading trends, marketing.
  • Business analysis & Data mining to identify trends and opportunities in driving down spam and other nefarious behavior
  • Compared global data of various competitors with BI tools like Tableau
  • Experience in Microsoft Dynamics CRM Data integration towards import/export of data using custom application development. Experience in use of web services and interacting with MS CRM database using web service methods.
  • Conducted several JAD sessions and requirement workshops with the system architects, business users and development team to perform GAP Analysis
  • Developed timelines for project delivery, and managed projects and resources to successful completion
  • Prepare data for making regular reports data analysis, perform data analysis & data manipulation for complex data files.
  • Used advance Excel, Tableau and SQL queries for analyzing data.
Business Analysis Microsoft Excel SQL
Remove Skill
Technical IT Analyst
Information Technology
May 2017 - Aug 2017
Arizona, LA
  • Executed Value Stream Mapping process from Design specs using web-based tools (Lucid Chart, Slack, Ryver), through estimating, ordering of inventory and AR/AP Systems, saving 3 hours / project
  • Created business process workflow diagrams and Mock-Ups with the help of Lucid Chart (A Web-based Wireframes and Mock-up creating tool) adhering to UML standards
  • Identified and removed bottlenecks in storage, deliveries and departmental coordination saving the company $10,000+
  • Significantly reduced outstanding payment research by developing and implementing integrated web application for vendors.
  • Assisted with the collaboration of solutions that will streamline the data migration processes
  • Acted effectively as point-of-contact on status of EDI transactions from internal and external customers
  • Created and Managed domains and prepared disaster recovery strategies in a construction space where the database has been infected by malware and viruses and prevented it by managing User Security.
  • Assisted Technical Developers in building the Cloud and Virtualization environment and used multi-layered security approach to prevent the Client information from future Viruses
  • Executed CRM campaigns to cross-sell and up-sell new and existing products to current Rain Dance subscribers
  • Used workforce tracking tools (such as Ryver and Trello) to maintain information on employee activity and status, including scheduled assignments and absences, meetings and other schedule exceptions.
  • Leveraged requirements elicitation skills to deliver multiple Requirements Traceability Matrix's (RTM) that achieved sponsor and stakeholder acceptance sign-off that each requirement was 100% delivered
  • Suggested several process improvements within the ratings process and suggested solution options to automate manual data entry tasks performed by Data Managers

Technologies: Agile, UAT, Ryver, Trello, Lucid Chart, Cloud & Virtualization, MS Project, MS Access, MS Visio

EDI Process Improvement UML
Remove Skill
Sr. Technology Consultant/Analyst
Information Technology
Dec 2016 - May 2017
Arizona, LA
  • Develop the strategy and frequent action runs to ensure that all ASU technology is working properly
  • Perform feasibility analysis of proposed solutions, negotiated and presented analysis to business to help prioritize deliverables and negotiate practical solutions for development
  • Translate technical specifications, and/or logical and physical design into code for new or enhancement projects for internal clients
  • Support the organization's key business processes and applications
  • Prepare technical as well as university process maps, workflows,
  • Troubleshoot software programs and database management systems and MS Office etc.
  • Perform critical QA tasks like writing, reviewing, signing off and executing test cases in QA and Dev
  • Capture proceedings of meetings, JAD sessions, focus groups and published on SharePoint portal
  • Responsible for coordinating and operationalizing all grade appeals and working closely with the Chief Academic Officer, Associate Dean of MGM and MAGAM program, Associate Dean of Student Affairs to ensure resolution.
No skills were added
Remove Skill
IT Business Analyst
Information Technology
Jun 2014 - Jun 2016
  • Deployed Scrum framework within an agile development environment to improve software development processes and elevate product quality while meeting defined goals and key deadlines
  • Implemented the Agile methodology and developed product and Sprint Backlogs
  • Groomed backlog of features to ensure readiness for scrum planning sessions including documenting acceptance criteria defines As-Is and To-Be process flows to identify gaps and new requirement
  • Used JIRA to track User Stories progress and follow-up on defects with the QA and developers in different builds
  • Regularly interacted with the Testing team for executing the Test Plans, providing Test Data, creating Test Cases, and resolving issues upon detection of bugs and collecting the Test Metrics
  • Prepared project status and sprint metrics (Product Backlog, Sprint Backlog, Burn-Down Chart and Velocity Chart) reports
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
  • Developed and analyzed the Sprint/Product burn down chart in order to calculate the team's velocity and track sprint progress. This was then utilized for planning of the upcoming sprints. Used Jira to plan and track the sprints.
  • Experienced working with User Experience (UX) and User Interface (UI) teams while driving the Functional Requirements and Process Flows
  • Created Requirements Traceability Matrix (RTM) to track requirements and testing activities, as well as maintained forward and backward traceability throughout the testing and development lifecycle.
  • Played a key role in Defect Management -by identifying & delegating defects, monitoring status, ensuring timely closures, and generating performance reports, to ensure quality software
Business Analysis
Remove Skill
Jr. IT Business Analyst
Information Technology
May 2012 - May 2014
  • Created visually impactful data sets in Excel and Tableau for data reporting by using pivot tables and VLOOKUP
  • Documented epics, user stories and associated acceptance criteria
  • Performed Order Gap Analysis to develop Customer Lifetime Value Models / /Business Process Modelling and Notation (BPMN) to prevent top tier customers from churning by updating ‘As -Is’ document and brainstormed on the benchmarks to be reached in the 'To- be' application as part of initial Gap analysis.
  • Analyzed purchase patterns and attitudinal data to reveal new CRM growth opportunities to enhance consumer spending
  • New product introduction performance study for trouble tracking on products going into the marketplace. Documented process of how to use the application so any associate with little knowledge of tool could use and get required results.
Business Analysis Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information Technology
University of Cumberland's
Thunderbird School of Global Management
Bachelor's in Engineering
RGTU
Certifications
CCNA
Skills
Business Analysis
2021
6
Microsoft Excel
2021
4
SQL
2021
2
Agile Methodology
0
1
Application Development
0
1
Auditing
0
1
Big Data
0
1
BRD
0
1
Change Management
0
1
CRM
0
1
Crystal Reports
2021
1
EDI
2017
1
ETL
2021
1
FRD
0
1
FTP
2021
1
JIRA
0
1
MS Project
0
1
MS SharePoint
0
1
MS Visio
0
1
PaaS
0
1
Process Improvement
2017
1
Project Management
2021
1
Quality Assurance
2021
1
Requirements Gathering
2021
1
SAP
0
1
Scrum
2021
1
SDLC
0
1
Stakeholder Engagement
2021
1
UAT
2021
1
UML
2017
1
Waterfall
0
1