Business /Data Analyst, Python,SQL, Tableau

ANUJ MATHUR

Chicago, IL, ***** +1-619-***-**** *************@*****.*** https://www.linkedin.com/in/mathur-anuj/ SUMMARY

A Critical thinker and solutions-driven professional with over 5 years of experience in Business/Process Analysis and Quality Assurance. Proficient in Client Interaction, User Requirements Analysis, Software Testing, SDLC, SCRUM, Agile, Data Analytics, and Data Visualization tools. Readily available for a Business Analyst/Intelligence, and Data Analyst roles EDUCATION

Master of Science in Information Systems, San Diego State University, CA GPA 3.53 Dec 2019 Bachelor of Technology in Electronics and Communication, Rajasthan Technical University, India May 2010 SKILLS

Languages: R, Python, SQL

Packages: Python – NumPy, Pandas, Matplotlib, R – Caret, ggplot2, Plotly, Mice, Dplyr, sqldf Project Management: Database Design, Requirements Gathering & Analysis, Agile Methodology, Scrum, SDLC, STLC, Waterfall, Use Cases, UAT, UX, Test plan, Test cases, Test strategy, Verification, Validation, Regression, Defect tracking Data Analytics: Data Pre-Processing, Feature and Model selection, Predictive Modeling, Data Visualization, Regular Expression Tools & Technologies: Tableau, MicroStrategy, JIRA, Selenium, GitHub, Power BI, AWS Office Tools: MS Visio, MS PowerPoint, MS Word, MS Outlook, MS Excel (Pivot Table, VLOOKUP) EXPERIENCE

Business Analyst, Adhrit Inc., Chicago, IL Mar 2020 - Present

Introduced JIRA to write user stories and product backlogs, and to conduct sprint planning, daily scrums, sprint reviews, and retrospectives

Used Tableau and Power BI to create storylines, visually interactive dashboards, and customized reports based on business requirements that helped the business leaders to make data-driven decisions and increase profits

Developed SQL scripts to perform data analysis and data extraction as per the business requirements

Designed document Scope of Work (SOW); praised by the client for efforts in detailing user’s specifications in the SOW Intern, Midland Credit Management, Encore Capital Group, San Diego, CA Oct 2019 - Dec 2019

Earned commendations for analyzing a challenging unorganized 376 internal controls dataset with over 50,000 data points in Excel using VLOOKUP and PivotTables, resulted in an ordered group of internal controls, and a 72% reduction in the given timeline

Completed testing of approximately 60 internal I.T. security controls, 33% above target, per Sarbanes Oxley (SOX) compliance program Intern, Model Development and Implementation, Risk Management Solutions, Inc., Newark, CA June 2018 - Aug 2018

Improved the data search process by making it more centralized and faster, and by creating a global data dictionary of the RMS’s valuable data stored in various SQL databases and binary files, using data-frames, and regular expressions in R

Analyzed the binary files per the provided schema and converted them into JSON format using Python Business Analyst / Senior Quality Analyst, Gempulse Infotech Private Limited, Jaipur, India Oct 2012 - Jul 2017

Prioritized UX and Usability in projects; led to a 45% increase in positive customer’s feedback and 10% revenue growth in 2016-2017

Diagnosed process bottlenecks by creating test-driven development (TDD) process documents like QA Standard Operating Procedures(SOP), QA Workflow, and QA Estimation and Assessment – contributed to 35% increase in code quality and productivity

Promoted to Business Analyst for exceeding expectations in process improvements and exceptional organization skills

Led a team of 7 people handling different projects and covering 4 levels of testing - Unit, Integration, System, and Acceptance testing

Introduced Automation Testing using Selenium Web driver, increased speed, efficiency, and quality while reducing testing costs ACADEMIC PROJECTS

Board Game Selection Spring 2019

Designed a Decision Support System (DSS) helping game enthusiasts to narrow down the multiple varieties of games by providing an optimized list of games. Reduced the research time by 95%, and saved a loss of $120 per customer Restaurant Review Analysis System Fall 2017

Designed a website with documents like Scope of Work (SOW), Use Cases, Dataflow Diagram (DFD), Entity Relationship Diagram (ERD), to analyze customers reviews and sentiments, and generate useful insights to help restaurants make smart customer decisions Indywood- Opening an Indian Theatre in San Diego (Marketing Project) Spring 2018 Developed a marketing plan for opening a new Indian theatre, with 20% profit per year and 70% customers retention by performing market research, trends analysis, marketing 5C’s and 4P’s, and Strength, Weakness, Opportunity, and Threat Analysis (SWOT) examination Psychometric Exam Database Design (Microsoft SQL Server 2017) Spring 2018 Developed a database to help a paper-based business go digital. Increase the business profit by 60%, eliminated 100% of paper, and improved payment process. Designed UML diagrams (using VISIO), Schema Notations, SQL queries, and, Use Cases to address the business needs Traffic Violation Analysis (R programming Language) Fall 2018 Predicted accidents that could be fatal and analyzed various traffic patterns that could help the government to improve the existing traffic rules and laws. Models used: Logistic Regression (GLM), Linear Discriminant Analysis (LDA), Decision Tree, Naive Bayes, Random Forest

Contact this candidate