TEJAS MAGAR

Buffalo, NY add4hg@r.postjobfree.com www.linkedin.com/in/Tejas Magar/ 716-***-****

SUMMARY

Accomplished Business Analyst with 4 years exp in Banking domain bringing exceptional abilities in competitor analysis, business intelligence development and statistical trend assessments. Achieved 20% savings in operational keying after optimizing form layout changes. Highly Proficient in SQL and Excel (Pivot tables, graphs, macros, v-lookup). EDUCATION

Master of Science, Management Information Systems June 2020 University at Buffalo, SUNY GPA – 3.9/4.0

Relevant Courses –Digital Product Management, Seminar in Healthcare, System Analysis and Design Bachelor of Engineering, Information Technology June 2015 Sardar Patel Institute of Technology, Mumbai

WORK EXPERIENCE

Associate Consultant, JP MORGAN CHASE February 2018-June 2019

• Instructed as a Business Analyst across a distributed agile team of over 50-60 size, across Chicago & Mumbai including a vendor team of 20 to complete design of US tax forms on a quarterly basis achieving efficiency by 25%.

• Evaluated risks related to requirements implementation, testing processes, project validation, communication and training saving company on average $15,000+.

• Conducted data mining (predictive analytics) by utilizing SAS miner to analyze opportunities for business growth.

• Evangelized product vision to key stakeholders using customer research, data/statistical analysis, performance changes and use cases to build consensus using SaaS models reducing cost by 15%.

• Collected and reviewed project stakeholder requirements with help of meetings, walkthroughs and interviews, produced business requirements documentation and created mock-ups each sprint.

• Analyzed product strategy/ product innovation/automation helped clients create and launch digital business models.

• Enhanced payment pages to reduced layout flow issues using A/B experiment and significance testing. Technology Business Analyst, JP MORGAN CHASE July 2015-January 2018

• Designed KPI’s and management reporting dashboards to provide strategic insights to drive growth and performance.

• Initiated quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for up to 2,000+ global users.

• Created/maintained custom queries, views, and stored procedures using T-SQL for data and driven datasets.

• Constructed Ad-hoc, Standard, Dashboards, and reports using Tableau/SQL Server Reporting Services (SSRS).

• Led Scrum Ceremonies – Daily Standup, Sprint Planning, Retrospectives, Demo, and Sprint.

• Handled SOAP & REST API services for payments domain to increase efficiency.

• Documented high level requirements and specifications and map out process flows and Root cause Analysis. ACADEMIC PROJECT & ASSISTANCE

Market Analytics for Investments (Technology: Tableau) December 2019

• The aim of the visualization is to identify potential investment areas for new investors based on various factors population of an area, revenue generated, money spent on marketing, sales region, etc. Graduate Student Assistant, Department of English, SUNY Buffalo September 2019-May 2020

• Migrated existing website to AWS cloud handling storage, security, compute and database services leading to cost savings of $4,000+ and incorporated a new editor on web server reducing author’s efforts by 40%. SKILLS

• Programming and Web Technologies: SQL, Java, Python, VBA, Bash/Shell, HTML5, CSS3, XML, JavaScript

• Project Management Tools and Techniques: ALM, JIRA, Confluence, Microsoft Project, SharePoint, Agile, SCRUM, Continuous integration, Process Flow Diagrams, Adobe Acrobat Pro, UAT, Microsoft Project, Change and Product Management, UML, Microsoft Word, Excel, PowerPoint, Access, Visio, QTP, Six Sigma/Lean, Salesforce

• Data Analytics: Tableau, Power BI, Quick Sight, SAS Enterprise Miner, Access, SSRS, ORACLE ERP

• Cloud: AWS & Azure (Storage, Security, Database, Content delivery), Serverless app development, Docker containers CERTIFICATIONS AND AWARDS

• Google Analytics, Certified Scrum Master CSM, Tableau Specialist, AWS Solution Architect, IBM Design Creator.

• Awarded as Ace Achiever in JPMC for improving project efficiency by 20% in 2018.

Contact this candidate