SAUMYA SHARMA

Jersey City, New Jersey ***** 551-***-**** ac74fj@r.postjobfree.com

SUMMARY

Data driven, analytical, and detail-oriented individual and an Information systems graduate with over 2+ years’ professional experience and expertise in the field of analytics. I have displayed relevant product-oriented quantitative analytical skills working with large data sets delivering business solutions for complex problems. Also, I am a self- motivated adaptable & results-oriented professional with strong work ethics, critical thinking and organizational skills. EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York, NY Master of Science (MS) in Information System GPA – 3.57 Dec 2017 Rajiv Gandhi Technical University Bhopal, India

Bachelor of Engineering (B.E.) in Computer Science GPA – 3.7 June 2016 TECHNICAL SKILLS

Programming: SQL,R, SAS, HTML

Certifications : Google Analytics, Data Driven Decision Making - PwC, Visualization with Tableau - UCDAVIS Microsoft Office : Word, Visio, Advanced Excel ( Pivot, VLOOKUP, Macros, VBA), PowerPoint, Outlook Tools : Tableau, PowerBI, PosGreSQL,Informatica ETL, SAP MDM, MySQL Workbench, Salesforce Key Skills : SDLC, Business Analysis, Agile and Waterfall Methodologies, Business Process Modelling Workflow Analysis, Data Analysis, Data Visualization and Warehousing, Google Analytics Marketing Analytics, BRD/FRD, Ad-hoc Analysis, Performance Analysis RELEVANT EXPERIENCE

Boehringer Ingelheim, Commercial Excellence US Atlanta, Georgia Business Analyst July 2018- Present

Conducted and Facilitated Requirements Gathering Sessions with Stakeholders.

Built data visualizations and cross-functional reporting that conveys key performance metrics, significant trends, across multiple data sources using SQL, Advanced Excel and SAP Crystal reports.

Defined, Analyzed, and performed Data Analysis on complex Data sets for the successful execution of innovative operations to support business objectives that included Engage CRM, Sales Targets, EDI transactions.

Worked on SAP,Salesforce and SQL to extract data and to approve Data Change Requests in Veeva CRM.

Prepared and reviewed daily, weekly, monthly sales report and provided insights and analysis of data by creating dashboards on Tableau.

Used standard analysis techniques such as data flow modeling, use-case analysis, workflow analysis, ad hoc analysis to improve the efficiency of various business models.

Designed and created intuitive yet scalable reports, dashboards and presentations that business owners can rely on to drive business processes using MS EXCEL, MS PowerPoint and TABLEAU.

Supported complete project execution by coordinating activities through study planning, research, data collection, analysis and reporting under the supervision of Senior Project Manager.

Generated Use Case diagrams, Activity diagrams, Business Object to depict process flows and PowerPoint presentations.

Performed User Acceptance Testing (UAT) and End-to-End testing for various web based and database related applications.

GENPACT, Insights and Analytics team Atlanta, Georgia Data Analyst (Client – Cox Communications) May 2018- July 2018

Conducted GAP Analysis by performing as-is and to-be analysis to understand new business model and additional functionalities to be incorporated in the project.

Used internal and external analytics tools, SQL, to access and analyze data Interface with engineering and business units to drive key operational metrics and KPI/s.

Extracted 1000 gigabytes of data and analyzed 5000 missing and redundant files, generating reports for the client using ETL processes that increased efficiency by 15%.

Consolidated information and produced reports and dashboards using Tableau and PowerBI to identify trends, risks and action for management based on different SLAs priority and status.

Performed statistical analyses to explain trends and support accompanying market figures by using MS Excel and database programs to manipulate large amounts of data.

Developed and assessed key performance indicators for each departmental units to help guide fast-paced decision-making.

NYC Department of Finance (Human Resources) New York, USA Data Analyst Intern June 2017- Dec 2017

Performed Data consolidation for operational weekly and monthly business reports, that helped in effective and efficient solutions to deal with large Data sets.

Performed in depth analysis of data and conducted research and prepare daily reports by using SQL, MS Excel, MS PowerPoint and share point.

Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data .

Prepared high level analysis reports and presentations with Excel, Tableau and Powerpoint that provided feedback on the quality of Data including identification of revenue patterns and outliers.

Used Advanced Microsoft Excel techniques such as Pivot tables, VLOOKUP to create intuitive dashboards for different work units using TABLEAU.

Improved Data quality using Macros, Advanced Excel functions, pivot tables & VLOOKUP to identify missing data by 35%.

IBM ACE Indore, India

IT Business Analyst Intern May 2014-May 2015

Executed Advanced SQL Database Queries on Complex Data sets.

Prepared reports for management and research projects using Microsoft Excel, Visio and Crystal reports.

Responsible for collection, organization, analysis interpretation of different types of data through client interaction and delivered recommendation reports and business plans.

Provided creative alternatives and recommendations to reduce costs and improve financial performance of the tracking system.

Provide accurate translation of business requirements into functional requirements.

Analyzed business requirements and perform current/target/gap/impact analyses.

Gathered critical information from meetings with various stakeholders and produced useful reports.

Worked closely with Operations, IT, Management, Accounting teams .