Sign in

Data Analyst

Philadelphia, Pennsylvania, United States
January 15, 2017

Contact this candidate


Philadelphia, PA E Mail: Contact No: +1 857 *** **** GPA: 3.94 EDUCATION

Saint Joseph’s University, Philadelphia, PA Dec 2016 Haub School of Business (Masters in Business Intelligence & Analytics) Courses: Predictive Analytics (SAS E MINER), Critical Performance Mgmt.(Tableau), Enterprise Data (Oracle 12c), Web Analytics, Business Analytics(JMP), Database Mgmt., Data Mining, Supply Chain Mgmt., Six Sigma(MINITAB) SIES College of Management Studies, Mumbai June 2014 MBA / Post Graduate Diploma in Pharmaceutical Management (Marketing Specialization) University of Mumbai July 2011

Bachelor of Pharmacy


Microsoft Essentials MS Office (Word, Excel, PowerPoint, Outlook, Access), Advanced Excel, Visio Data Mining / Predictive Analytics R, JMP PRO, SAS E miner, SAS BASE, MINITAB, Basics of Python and Hadoop Web Analytics – Google Analytics

Database Tools– Oracle 11g and 12c, PL/SQL Developer, Access Dashboard/ Visualization Tools – Tableau (!/ ) BUSINESS INTELLIGENCE AND ANALYTICS EXPERIENCE:

Saint Joseph’s University, Philadelphia (Erivan K. Haub School of Business) August 2015 to Dec 2016

• Predicting campaign effectiveness for a new product on a marketing dataset, in SAS E miner by applying various modelling techniques like multiple regression, Decision tree and Neural Networks

• Database Designing for airline ticket reservations and status updates applying SQL DDL, DML, Views, Triggers and Procedures in Oracle 11g

• Six Sigma Project – Applying DMAIC & DMADV concepts (FMEA, QFD, CTQ, Takt time, Value Stream Maps etc.) to increase product availability and reduce cycle time for a high demand product in a supermarket.

• Built a travel website to track different metrics like visitor behavior, page views, page depth, bounce rate, web traffic using Google Analytics and Tableau.

• Create performance dashboards and story telling using Tableau

• To create a centralized database for a superstore chain Created database using star schema modelling, ran queries to test the database using Oracle 12c and Hadoop.

• Data Mining – Analyzed survey data provided by Bolivian government applying statistical methods like regression, Factorial Analysis, Cluster Analysis, ANOVA to identify 3 5 children requiring financial support. PROFESSIONAL EXPERIENCE

LexisNexis Risk Solutions (Health Market Science Division) King of Prussia, PA June 2016 – August 2016 Summer Intern – Data Engineering (Product Market View) Market View delivers claims based intelligence to pharmaceutical clients and healthcare systems

• Analyzed Medicare and Medicaid data (AllScripts, CMS, Emdeon, Symphony, State data) from the claims data warehouse to identify high impact practitioners and facilities.

• Analyzed claims data to understand physician referral network (Product – Influence Network Analysis)

• Study insurance forms (UB 04, CMS 1500), understand and build ER models to develop procedures and functions using PL/SQL developer

• Developed packages using Oracle PL/SQL which helped in pulling data by using ICD 9, ICD 10, CPT and HCPCS codes as input

• Developed procedures to standardize Insurance payer names using PL/SQL that helped in eliminating redundancy and maintain data integrity

• Conduct ETL (Extract, Transform, Load) to load data into warehouse AIOCD Pharmasoftech Awacs Mumbai, India July 2014 March 2015 AIOCD is a pharmaceutical market research company that provides pharma market intelligence to help clients grow by providing fast and accurate information and win over competition. Business Development Manager and Client Servicing

• Product OPTISTOX: Turnkey project to help companies identify over stocking, under stocking and give visibility on their inventory which helped them in planning and forecasting

• Analyzed sales data using Excel for Pharmaceutical clients like GSK, Sanofi India, Cipla, Zydus Cadila and thereby assisted in achieving excellence in Supply chain

• Resolving data queries from clients and salesforce

• Managed e ordering website, upgraded as per client requirement and on boarded new clients

• Designed training material which helped sales executives in training different stakeholders Glaxo Smith Kline Mumbai, India February 2014 – July 2014 Medical Business Associate

• Promoted higher injectable antibiotics and other products in portfolio to Healthcare Professionals (General Surgeons, Orthopedics, Gynecologists, Intensivist) resulting in increased sales in my territory

• Performed Sales Analysis and Competitor Analysis for my territory to plan and target HCP’s

• Market Research for New brands through Retail Chemist Prescription Audit

• Conducting CME’s (Continuous Medical Education) with HCP’s Vilberry Healthcare Mumbai, India May 2013 – June 2013 Internship, Management Intern

• Recommended brand plan for a new product, performed market research to segment competitor products and profile healthcare professionals

• Designed and conducted survey with HCP’s to evaluate factors while prescribing products/brands. PROFESSIONAL ACHIEVEMENT

2014: Winner for best learner at Glaxo Smith Kline training in Feb 2014 NOTE:

Work Authorization: Approved to work for any employer in USA. (STEM based EAD OPT)

Contact this candidate