Business Analyst, Business Intelligence Analyst
Resume:
SREYA SASWATI MOHANTY
**** ********** ***, ******* **
*****.***********@*****.*** 832-***-**** Linkedin.com/SreyaMohanty PROFESSIONAL EXPERIENCE
ACCC Insurance Company, Houston, Texas 06/2017 to Present Business Intelligence Analyst
o Partnered with Executives, Product Owners, SMEs, Developers and key stakeholders to gather requirements and to identify policy and claims teams data requirements and report layouts. o Managed and guided a team of 2 junior associates. o Developed over 10 interactive visual dashboards for business stakeholders using Tableau that drive insights and actions related to the annual and quarterly company performance. o Architected the claims metrics platform that provided a 360 degree view of the claims management work flow across various claims teams such as call center, BI, PD, Total Loss etc. o Extracted data for data integration and provide weekly reports for various vendors including Athenium, AIS, Equian, etc.
o Used data from SQL server databases to generate insights, solve problems and provide recommendations to support business growth and overall organization health. o Conceptualized, developed and maintained interactive tableau dashboards and accompanying data sources within the current BI suite for ACCC Insurance Company to track the company’s performance and customer base.
o Worked with the data warehouse team in gathering, cleaning and transforming data required to perform ad-hoc and advanced statistical analysis.
o Leveraged customer activity data to analyze and understand purchasing trends to thereby develop tailored discount programs for each customer based on their purchasing behaviors. o Prioritized epic, features, requirements, issues and groomed the BI Backlog in Microsoft TFS on a weekly basis using Agile Project Management.
o Reconciled the company’s MDR repository in Data Warehouse by implementing data dictionary and ERD schemas.
o Scripted and reviewed about 100+ queries and stored procedures using SQL to deliver ad-hoc reporting needs from business stakeholders on a daily basis. o Conducted UAT sessions with business stakeholders to ensure timely and in-budget project delivery.
o Worked directly with the Business Operations Director to prepare business proposals for vendors and collaborated with attorneys and subject matter experts to develop supporting documents and coordinated the vendor selection process.
o Supported the company homepage using Adobe Dreamweaver and agent data in Salesforce. Betsol LLC, Broomfield, CO 04/2017 to 06/2017
Business & QA Analyst
o Responsible for eliciting requirements from the client to define configuration specifications for an internal project estimation tool for the client.
o Facilitated design sessions with the implementation team to define solutions. o Constructed workflow charts and diagrams using MS Visio for the software development team. o Created presentations in concise and well-researched manner on the new tool enhancements to be presented before the client.
o Performed manual and automation testing of the tool as part of the QA team and backend testing to validate database.
SREYA SASWATI MOHANTY *****.***********@*****.*** Page 2 University of Houston Law Center, Houston, TX 01/2015 to 12/2016 Student Web Developer
o Supported the Law School website, including writing HTML documents implementing CSS and JavaScript, developing content, creating graphics, digitizing pictures and inserting audio and video using Adobe Dreamweaver.
o Developed content and layout of web pages using graphics software designed for publishing on the Web.
o Designed and developed Responsive web pages and mobile resizing. Infosys Limited, Bhubaneswar, India 12/2011 to 11/2014 Business & QA Analyst
o 3 Years of software testing and business analyst experience in working across all phases of STLC
(Software Testing Life Cycle) on multiple projects defining processes and tools best suited to each project.
o Participated in the conversion of business requirements to actionable system requirements such as functional specifications, user cases, user stories and workflow/process diagrams in conjunction with developers and system architects.
o Moved between Agile and Waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures. o Experience in SQL Server and extensively used SQL queries for data validation and backend testing. o Performed GUI, Functional, Integration, Regression, Database, Stress, Load and System testing on different web based applications and defining the tests required to verify applications based on complicated business logic.
o Worked as an offshore coordinator for the daily status and defect triage calls with technical teams. o Designed automation test scripts using HP UFT and Selenium and executed manual test cases using HP Quality Center (ALM).
EDUCATION
Masters of Science (M.S), Computer and Systems Engineering University of Houston, Houston, TX
Bachelor of Technology (B.Tech), Electronics and Communication Engineering Biju Patnaik University of Technology, Bhubaneswar, India SOFTWARE SKILLS
Application Software: MS Word, MS Excel, MS Visio, MS Powerpoint, MS Outlook, Tableau, PowerBI Testing Tools: HP Quality Center (ALM), HP QuickTest Professional (UFT), JIRA, IBM ClearCase, IBM ClearQuest, Silk Central, Java Selenium
Database: Microsoft SQL Server, MS Access
Languages: Java, SQL, PL/SQL, HTML, CSS, JavaScript, VBScript Development Tools: Adobe Dreamweaver
Contact this candidate