Alpansh Banerjee
317-***-**** **********@*******.*** https://www.linkedin.com/in/alpansh-banerjee PROFESSIONAL SUMMARY
Highly motivated MBA student intending to explore opportunities in Business Analysis, Project Management, Health Analytics and Business Development area. With a strong background in IT Management and Data Analysis I wish to gain comprehensive insights of a reputed organization and the experience in the relevant field.
EDUCATION
Suffolk University Boston,MA
Master of Business Administration in Business intelligence (GPA- 3.89/4.00) May 2017 Indiana University Purdue University Indianapolis,IN Masters of Science in Music Technology (GPA - 3.91/4.0) Aug 2015 Devi Ahilya Vishwavidyalaya Indore, India
Bachelor of Science in Electronic media (GPA - 3.80/4.0) Jun 2014 WORK EXPERIENCE
Graduate Research Assistant Suffolk University: Information Systems Department Sep 16 - Present
Extracted information and developed evaluations on a research project ‘Correlation of Data Modeling methods & Data Context’.
Interpreted and analyzed quantitative and qualitative results on various Business Intelligence tools like SAS, TIBCO Spotfire, Power BI to design a coursework for future Graduate Business Intelligence classes. Student IT Services Assistant Suffolk University: Sawyer Library Sep 15 - Present
Assisted with scanning and organizing licenses and invoices, handled various data analysis projects and testing database on bi-monthly basis. Worked on Inventory Management, Material Processing, Quality Assurance of data and web designing.
Spearheaded the Yearly Statistics Data Analysis project benchmarking with 5000 resources based on data of past 5 years. Communications and Analytics Intern Northeast Energy Efficiency Partnerships Jun 16 – Aug 16
Worked closely with external clients and internal teams to provide efficient solutions to meet business needs and Collaborated with executives in creating, executing ad-hoc reports in Excel and Salesforce CRM to gain business insights.
Acted as IT project coordinator for System Analysis project which included tracking of project milestones, maintenance of proper SDLC documentation, and providing recommendation for system implementation. Social Media and IT Intern Percussive Arts Society Jun 15 – Aug 15
Monitored multiple databases to keep track of social media presence of the percussive companies of USA. Organized and designed E-mail Newsletters for the company.
Planned and executed quality assurance for the company's website and assisted with the Online-marketing plan using tools like Google AdWords.
PROFESSIONAL SKILLS
Skills: Strategic Management, Project Management, Business Systems Analysis, Business Intelligence, ETL Processes & Database Management, Use cases, UML Diagrams, Market Research, Investment Analysis, Big Data Analytics for Health etc.
Programming Languages: R programming, PL/SQL, HTML, ASP.VBSCRIPT, C, CSS, XML, XSL, PHP, vbscript, Web Audio API, Microsoft MDX (basics).
Reporting Tools: Tableau 9.0, SAP Predictive Analytics and Lumira, IBM Watson Analytics, Pentaho BA, QlikView, Talend, IBM SPSS Statistics
Other Tools & Framework: MS Office Suite, MySQL Workbench, Visio, SharePoint, SAP ERP 6.0, Odoo ERP system, Jira, Photoshop, Prezi, MS Projects, Dreamweaver, premiere pro, Corel Draw, Keynote, Pages, Mailchimp, Surveymonkey etc.
Databases: Oracle, MySql, SQL Server, MS Access.
Operating Systems: Mac, Windows, Ubuntu
PROJECTS
Business Intelligence and Data Analytics Project: Predictive Analysis on crimes committed in various educational institutions.
Strategic Management Project: Developed growth strategy for Public (Acuity Brands, Accenture) & Private Companies (Deezer, Brown brothers Harriman) using various analytical tools like Porter 5 forces, DuPont, VRINE, GE-McKinsey 9 Box Matrix etc.
Big Data & Data Management Project: Prepared, Analyzed and Explored a Financial Dataset using various ETL Tools to gain insights on the root causes of declining profits.
CERTIFICATIONS
Lynda.com: Project Management Fundamentals, SQL essential training, International marketing fundamentals.
University of Melbourne: The Language and Tools of Financial Analysis
Erasmus University Rotterdam: Econometrics – Methods and Applications
Institute for Healthcare Improvement (IHI) : Certified Professionals in Healthcare Quality (20 credits) VOLUNTEER WORK
Worked as a Regional Manager in Social media management and public relations for Hits Record Worldwide, music based in Tampa, Florida for 8 months. This was an online Voluntary internship.
Freelance Musician for 10 years, performed at more than 300 charitable programs worldwide and acquainted with Guitar, Vocals, Melodica and Piano. Also, proficient with Film, Sound & Video production.
Served as Vice President (Student Engagement) of Suffolk University Graduate Business Association and National Association of Womens’ MBA Suffolk University Chapter, Secretary of Graduate Student Association of Suffolk University & a member of IHI Suffolk university chapter.