Technology Analyst Intern Us
Education
Management Information Systems
Courses: Business Intelligence, Web Mining, Systems Analysis & Design, Business Foundations of IT, Financial Accounting
Bachelor of Engineering in Information Technology,
Skills
Business Intelligence Tools: Business Objects, MS BI Suite (SSIS, SSAS, SSRS), Tableau, DQ Analyzer, SAS
Additional Software: MS Visio, MS Project, MS Excel, Gephi, NodeXL
Programming Languages/Database: Java, SQL, C, C++, Python, HTML, CSS, PHP, SQL Server, Oracle, MySQL, Access
Work Experience
Technology Analyst Intern May 2012-Aug 2012
- Created custom Business Objects reports which led to better data analysis, increased efficiency and accuracy
- Made Business Objects reporting tutorial for employees which will help them to make their own reports
- Automated excel documents using macros saving one and a half labour hours every day
- Used Tableau and Business Objects to make dashboard for better decision making and to analyze trends
- Performed regression analysis using SAS on various bank data to help managers recognize important trends
Information Systems Analysis & Design, Teaching Assistant, Eller College of Management Jan 2012-Present
- Serve as a liaison between the instructor and the students
- Improve the effectiveness of the lecture by identifying sections requiring more emphasis
- Simplify complex topics to help students better understand course material
Department Head Assistant, Aerospace and Mechanical Engineering Dept., University of Arizona Sep 2011-Dec 2011
- Maintained and modified department website which improved overall functionality and usability
Academic Projects
Social Media Analytics: March madness Twitter Data Analysis Jan 2012-May 2012
- Extracted data from twitter to analyze trends on the basis of hash tags used by the users
- Used extracted data to prepare data warehouse, reports and dashboards for better analysis of data
- Applied bus architecture to build the data warehouse, profiled data with DQ Analyzer and used MS BI platform
ZonaZoo Jan 2012-May 2012
- Improved the traffic and awareness of the organization by using Google AdWords and Google Analytics
- Used KPI's and statistical analysis to measure performance and provided recommendation based on trends
- Increased the number of visits by 10% and increased time spent by AZ users (target audience) by 50 seconds
Sanofi-Aventis: Project Review Committee (PRC) Reporting Process Improvement Jan 2012-May 2012
- Analyzed the system, proposed alternatives to increase efficiency and productivity of the reporting process
- Suggested and documented a list of KPI's and best practices for building dashboards to improve decision making
Website Development: Chris Eldridge Group (Enterprise Data Management) Aug 2011-Nov 2011
- Developed a new website to automate process of buying & selling and was involved in all stages of SDLC
- Saved time, increased revenue and improved efficiency
- Designed ER diagram for system analysis, developed front end and backend for the client using MVC pattern
- Followed Agile model and made use of MySQL for database implementation, PHP and HTML for the client interface
AR Rahman Website Analysis and Design (Analysis & Design of Service-Oriented System) Aug 2011-Nov 2011
- Improved the website design to improve usability and marketability of AR Rahman website using Drupal
- Used OO design technique, incorporated 8 API's and used Amazon cloud to host the website
- Managed the project, prepared the technical document, analyzed the system and implemented improvements
Leadership and Extra-Curricular Activities
Co-Founder: Master's Office Training Program Jul 2012-Present
- Cofounded a training program to provide MS Word, PowerPoint, Excel, and Drupal training to individuals
- Established a training schedule, identified 12 volunteer trainers and found institutions to advertise our program
- Ensured the efficient operation of the organization and the quality of the course content
Aug 2012-Present
- Worked with other members to create a roadmap of events to be organized
- Proposed ideas to promote and advertise activities of the club to increase visibility and attract new members
Jun 2008-Jul 2011
- Initiated soccer tournament consisting of teams across Mumbai
- Increased the participants by 20% every year by using various online and offline media to advertise the event
- Delegated duties and coordinated with 25 volunteers for smooth functioning of the tournament