Sumedha Singh Email and Phone Number

As a result BIE- Data, Reporting & Analytics for Intersys Consulting I am responsible for recommending and delivering effective, advanced and scalable solutions to the clients. My expertise lies in Advanced Data Analytics, Business Intelligence, and Data warehousing domains. Predictive Analytics:This project involved an in-depth analysis of the impact of a new billing plan on Revenue and customer behavior. The project also aimed at conducting an evaluation of the Azure ML as a technology for enabling and accelerating analytics.• Pre-processed more than 20 million records in SQL Server and Microsoft Excel and utilized customer segmentation techniques to create feature files.• Predicted customer churn rate and revenue with 89% accuracy using Azure ML Studio, Jupyter notebooks and R scripts Agile Project Management: The project involved creating a Master Data Management Solution based on Azure, Microsoft SQL Server (MS SQL Server), and Microsoft SQL Server Integration Services (SSIS). The objective is to maintain a single view of data across the whole organization thereby improving the data quality and data reporting capabilities to help the business and IT to run in unison.• Collaborated with the client to gather the requirements, analyze the user needs and translate them into technical specification • Created and prioritized the project backlog based on business needs, project objectives, timelines and resources available• Followed Agile methodology and Scrum framework, conducted daily Scrum meetings, created weekly project progress reports for the business• Responsible for status reporting, problem identification & resolution, risk mitigation, change managementETL/ Data warehousing/ BI:• Redesigned data warehouse model using SSAS Tabular, scripted optimized DAX measures for efficient business reporting in Power BI • Migrated 400+ SQL Server databases and SSIS ETL packages from 2005 to 2016 while analyzing SAP BO reports ensuring data consistency

• Collaborated across cross functional teams and upper management to assess user needs and formulate automation strategies • Optimized inter-team collaboration within CAID industries through automation leading to significant improvement in management statistics • Identified growth opportunities and strategic enhancements in crucial processes and recommended technical solutions • Analyzed the complete Document Control Process and conceptualized end to end data flow with an entity relationship diagram • Implemented a relational database management system in MS SQL for better, faster and accurate report generation • Scripted various reusable queries, procedures and triggers to optimize the process flow • Created prototype user interface based off different frameworks- WebUI, Microsoft Excel, and Google Sheets • Created live database connections with Microsoft Excel for run time data updates and report generation •Scripted procedures to track the project status, budget spending and inventory resource tracking at run time to be utilized by the inventory management, project management and accounting teams

Team Lead | Strategy and Marketing Consultant | Go-to-Market Strategy for SaaS | Client: Claimsparency Project Description: • Phase 1: Go-to-market Strategy Formulation for client's Restoration Construction Management SaaS tool to achieve operational effectiveness, user experience optimization and unique market positioning in the restoration construction industry. • Phase 2: Pitch Deck Creation for a partnership proposal to the leading supplier in the construction industry considering an immediate opportunity seeking expansion of the current customer baseWith a limited time span of 12 weeks, the project entailed organization and prioritization of requirements, expansive collaboration with stakeholders, creation of detailed execution and estimation plans while ensuring high quality and valuable deliverables. Responsibilities: • Led a team of 4 through extensive research involving detailed analysis of user experience and behaviors, market ecosystem and strategies, investigative questionnaires, surveys and customer interviews • Liaised with key business partners for requirements gathering, project scope definition, creation of execution plans, overall project management • Managed the team through scope change, task prioritization, effort estimation, risks identification and mitigation • Single point of contact between the client, faculty advisor and the student team; facilitated weekly conference calls with the client to communicate project status, next steps, potential risks and mitigation plans • Formulated a robust go-to-market strategy replicable in accordance with future product lines and changes in target customer segment • Delivered a full stack pitch deck framework utilizing channel partnership marketing strategy, prototype marketing material along with a series of recommendations for user experience enrichment, customer base expansion, product feature optimization

• Anticipated and transformed user expectation of the system into business requirements through comparative analysis • Documented, reviewed and executed test cases for 9+ functionalities to be executed by the Software Quality Assurance team utilizing TestComplete• Validated data for 5 + modules to ensure accurate cross-platform data migration and data consistency

• Managed resources and delegated tasks for the development of a portal used for automating project management activities• Supervised development and testing of 7 modules ensuring end to end delivery to production with none or minimal defects• Gathered and analyzed requirements through multiple client interactions, while collaborating across cross functional teams• Documented guides for SDLC activities used for coaching the newcomers, thus reducing the onboarding time by 40%

• Simplified data retrieval for other team members by creating 20+ reusable queries using SQL in SSMS• Optimized stored procedure to reduce run time by 95% using cursor and triggers in T-SQL • Liaised with the client over daily Scrum calls for requirement analysis and Status Update• Leveraged time to assist other team members by completing assigned tasks ahead of time• Collaborated with the testing team to resolve several issues and develop defect-free solutions