Business Analyst

www.linkedin.com/in/vgupta** Vasu Gupta +1-312-***-****

github.com/vgupta26 Chicago, IL ********@****.***.*** EDUCATION

Master in Information Technology & Management, Illinois Institute of Technology, Chicago, IL August 2016- May 2018 Bachelors of Technology in Information Technology, Manav Rachna University, India August 2011- May 2015 WORK EXPERIENCE

Michigan Health Information Network Shared Services, East Lansing, Michigan Jan 2018 - May 2018 Business Analyst- Intern

• Collaborated with team members & stakeholders to develop and document business deliverables for new/enhanced capabilities including business vision document, user stories, use cases, business requirement document and status reports.

• Prepared test cases and performed integration testing before build release of Oregon’s Provider Directory to lower defect count by 40%.

• Drafted strategic trend reports on survey responses of Health Directory to measure KPI’s & increased leadership focus to achieve 25% better result by Q3.

• Interfaced with business users of Michigan to handle Business Process Requirements and Software System Requirements.

• Identified the relevant data sources to generate reports including text, charts, graphs and tables using Tableau and Excel.

• Designed cloud flow diagrams of processes for the Health Directory- State of Michigan at various stages of SDLC.

• Performed ETL task for platforms like Salesforce, SQL, using Informatica Cloud & SQL Server Integration Services (SSIS) with visual studio.

• Coded the Visualforce pages and assisted in the data model design of Oregon’s Clinical Quality Metrics Registry (CQMR).

• Engaged in writing queries of procedures, functions, triggers and packages using PL/SQL in MySQL Workbench. Compunnel Software Group, Inc., Noida, India Nov 2015 - June 2016 Business Executive – IT Consulting

• Tracked Fortune 500 companies to develop new business initiatives, client acquisition, proposal development, contract negotiation & Sales Presentations.

• Negotiated rates with C Level Executives & sourcing managers who buy IT consulting services to maximize requirement opportunities.

• Handled IT Staff Augmentation, Applications Development, Applications Support/Maintenance, Data Management, & Support Services. And optimized the sales activity regarding the technical proposals (includes: RFI/RFPs & Questionnaires).

• Created sales pipelines and forecasting reports using Salesforce as database management tool.

• Planned workshops to identify, analyze & document business requirements and translated them into business plans and solutions. Prahar Equicom Pvt. Ltd., New Delhi, India August 2014 - May 2015 Business Analyst

• Partnered with Non- Profit Organizations, small-scale businesses and government programs of India to understand the business requirements & align the resource allocation. List of clients included BSNL, Ministry of Defense, Indian Airforce & Indian Navy.

• Analyzed the past data into spreadsheets to make reports and determine the gaps to reduce the costs of maintenance of inventory & delivery of products.

• Contributed in understanding and writing of tender proposals to forecast the project cost and product requirements.

• Created project and delivery charters to define the scope of the project and manage schedules. SKILLS

• Programming Language: HTML, C#, SAS, Python, Java, SQL, PL/SQL.

• Business Intelligence & Analytical Platforms: Microsoft Business Intelligence (SSIS, SSAS, SSRS), Tableau Public, Excel (VBA Macros, Pivot tables, Graphing/Charts & Advanced Functions), Access, Visio, Informatica Cloud for ETL, Power BI

• Software/ IDE: JIRA, Eclipse, MySQL Workbench, Visual Studio, Oracle SQL Developer, MS SQL Server, Android Studio

• Salesforce: CRM, Configuration, Reports & Dashboards, Data Migration. PROJECTS

• Enterprise Barcode Scanner

Profiled the requirements of the client & developed a barcode scanner application. The application updates the product details to SQLite database using RESTful webservices on server. It also generates reports to track the inventory and sales which resulted in 20% improvement in forecasting.

• M&A Report on AT&T and DirecTV

Performed comparable analysis of DirecTV and created market and risk report of the company. Recognized as the only project to estimate real purchase price of DirecTV and analyze financial synergies for AT&T.

• Multidimensional Cube

Deployed a multidimensional cube for a Retail Store, using Data Warehouse techniques in Visual Studio 2013. Created measures & facts as per the business requirements, with SQL Server database. Generated formulas using BI Wizard, to get TOP 25 records based on Products & Employees.

• Trading Activity Analysis for Harley Davidson

Identified the important key activities of the company like Stock Activity and Change in the CEO’s, using Python language. Generated the Word Cloud and perform Text Data Analysis. Identified the important Key Event Identities.

• Cicero Coffee Corner

Designed & implemented as a Database System using RDBMS in oracle. Created database tables, functions, indexes, synonyms and ER diagrams using MS Visio & SQL Developer. Executed complex analytical queries including joins, views & procedures to generate reports from a statistical stand point. CERTIFICATIONS & ACHIEVEMENTS

• Quantitative Modelling & Spreadsheets and Models, University of Pennsylvania, Aug 2017.

• Software Processes and Agile Practices, Agile Planning for Software Products, University of Alberta, Sept 2017.

• Modelling Risk and Realities, University of Pennsylvania, Sept 2017.

• Certified Scrum Master(CSM), International Scrum Institute, May 2018

• Certified Six Sigma Yellow Belt (CSSYB), International Scrum Institute, June 2018 www.linkedin.com/in/vgupta26 Vasu Gupta +1-312-***-**** github.com/vgupta26 Chicago, IL ********@****.***.***

Contact this candidate