Sofia Khaja

Irvine, CA 657-***-**** adjpfa@r.postjobfree.com www.linkedin.com/in/sofiakhaja

EDUCATION

CALIFORNIA STATE UNIVERSITY, Fullerton, USA May 2020

Master of Science in Information Systems, Business Analytics

GMR INSTITUTE OF TECHNOLOGY, Razam, INDIA May 2018

Bachelor of Technology in Information Technology

STRENGTHS AND EXPERTISE

Software/Apps: Tableau, MS SQL, Python, R, PostgreSQL, Google Analytics, MS Excel (Pivot tables, VLOOKUPs, Chart functions) Power BI, SharePoint, MS Office Suite (Word, PowerPoint, Outlook, Visio and Project), Access, Qlik Sense

Core Skills: Data Analysis, Reporting & Data Visualization, Data Transformation, Excellent Communication and Presentation Skills, Project Management, Advanced Excel, Regression analysis, Ad-hoc Reporting

PROFESSIONAL EXPERIENCE

Johnson & Johnson (Biosense Webster, Inc.) Oct 2020 - Present

Sr. Business Analyst, Customer Support Irvine, CA, USA

Executed order management process with Johnson & Johnson Healthcare Systems (JJHCS) business partners to ensure order entry accuracy in support of all capital equipment Hardware, Software, Service, third party equipment and relevant disposables

Maintained SharePoint database for use by field sales associates, posting and updating tools and pricing matrices for new product offerings. Executed related tasks as need arises using Oracle JDE for data retrieval, order tracking & order management

Delivered customer and field support to Biosense Webster and collaborated with the Commercial teams (Marketing, Contracts, Technical Services, Finance, Supply Chain) in the development and execution of BWI commercial programs by drafting fixed letters for catheter sales, processing advantage service agreements, standard service agreements and fixed catheter deals

Utilized monthly trackers and prepared monthly reports in QlikView for Sales Analytics - Ultrasound systems, NTS (Finance report), OCE (Marketing data via Salesforce) and Trade-in systems for the Marketing team using pivot tables in Excel

SHA Associates April 2016 – May 2018

Business Analyst Intern Visakhapatnam, INDIA

Performed exploratory data analysis using Python by integrating survey data from disparate sources like Excel, Salesforce CRM and determined target market segmentation and customer demographics

Designed and implemented Ad-hoc reports and tracked key performance metrics using Tableau and DOMO to support the daily operations and departmental reporting needs resulting in approx. 20% improvement in productivity

Increased user traffic up to 14% by applying A/B testing and measuring results using Google Analytics by analyzing click-through rates from market and customers and gain insights to support client performance

Generated Excel pivot tables, created bullet graphs using MS EXCEL VLOOKUP, performed spreadsheet-based analytics and produced automated reports to maximize deliverables to improve daily sales operation by approx. 30%

HCL CDC April 2015 – August 2015

Business Analyst Intern Hyderabad, INDIA

Developed and automated interactive Qlik Sense dashboard with excellent analytical skills that highlighted the gaps and data inefficiencies in the system which helped the managers and business stakeholders to make business decisions thereby increasing customer retention by increasing the client rate by 25%

ACADEMIC PROJECTS

Cancer Prediction Model Python May 2020

Performed data preprocessing (handling missing data, combining and reducing categories) to create a base dataset

Conducted text mining using NLP methods in python to interpret research text evidences for cancer classifications

Designed a prediction model using Python to detect cancer in patients with approx. 70% accuracy

Industry Insights - Business Intelligence Analysis Tableau November 2019

Extracted and transformed relevant data from data source to uncover opportunities in various industry sectors and location

Used reporting tool – Tableau for analysis and manipulation of this dataset for data driven decision making and provided recommendations where a new business would be most profitable

Contact this candidate