Data Warehouse, Tableau, SSIS/SSAS/SSRS, SQL, Database Management

ARJUN MAHANT

Irving, TX www.linkedin.com/in/arjun-mahant

312-***-**** ************@*****.***

SUMMARY

Versatile business intelligence analyst with the experience of SSIS, SSAS and SSRS. Result oriented financial background with fine engaging deliverables. Seeking a full-time opportunity as a Business Intelligence Analyst. WORK EXPERIENCE

Lockheed Martin - Market Research Intern (Commerce, TX) Jan 19 – May 19

• Partnered with Senior BI Analyst to analyze client requirements for Intellectual Property Management App

• Researched on scholarly articles on IP Management App for contemporary IT tools to manage IP life cycle

• Tracked several tools to generate IP value chain matrix

• Added value by giving insights on Information governance decisions for best tools in software inventory Shrey Hospitals Pvt Ltd. - Healthcare Business Analyst (Ahmedabad, IN) Jun 18 – Aug 18

• Deployed medical articles publishing strategy for better keyword search

• Analyzed healthcare industrial documents to gain insights on market ’keyword’ trends

• Parsed, explored, cleansed and nested data to gain reporting data to create ‘Word Cloud’ visualization

• As a result, understanding the keywords helped improve the marketing of the company product Kairos Technologies, Inc. - Data Analyst Intern (Irving, TX) Aug 17 – Dec 17

• Gathered business customers requirements using SQL skills to join and clean datasets from multiple sources

• Identified and interpreted trends and patterns in datasets to predict outcome

• Independently drove a task to completion, understood the data, end goals and provided insights beyond customer’s expectations

EDUCATION

Texas A&M University – Commerce (Commerce, TX) Jan 17 - Dec 19 M.S. in Business Analytics

Coursework: Database Management, Data Warehousing and Statistical methods M.S. in Finance Jan 16 - May 19

Coursework: Financial Management, Investments, Derivatives, Financial Statements and Valuation DePaul University (Chicago, IL) Sep 10 - Nov 14

B.S. in Business Administration

SKILLS

Technical Tools: MS Excel (Lookups, Pivot Tables), MS SQL Server, My SQL, PostgreSQL, Python Microsoft Visual Studio, ETL (SSIS, SSAS, SSRS), Tableau Soft Skills: Problem solving, Storytelling and Troubleshooting skills ACADEMIC PROJECTS

International Institute of Business Analysis – VP of Programs (Commerce, TX) Aug 18 – May 19

• Booked speakers to present topics beneficial to the organization to ensure proper promotion of the event

• Worked with Board to develop programs that addresses professional development needs of the members School DW, ETL and Data Warehousing Project Aug 18 – Dec 18

• Solved data warehousing issues using tools to extract predictive analytics and patterns from data

• Constructed a multi-dimensional data warehouse using OLAP and OLTP

• Used a data warehouse to provide a solution to a business problem by utilizing SSIS, SSAS and SSRS for ETL Used Car Dealership, Database Management Jan 17 – May 17

• Dealt with database system and foundation for design, implementation and management in MySQL

• Rectified design and implementation issues with an emphasis on database management issues in MySQL

• Performed joins and cleansed data to support informed decision making

Contact this candidate