ROHIT SHARMA

Boston adg5oi@r.postjobfree.com Ph: +(1-617-***-**** https://www.linkedin.com/in/rohit-sharma-899b60129/ PROFESSIONAL SUMMARY

• Almost 4 years of experience as Data Analyst designing with Conceptual, Logical and Physical Modeling

• Experience in analyzing, manipulating large set of data and presenting it to internal/external clients.

• Technical expertise in Business Intelligence Tools, ETL tools, Data Integration, Data profiling, Data Cleansing, and Data Integrity.

• Interacting with stakeholders, gathering requirements and assigning priorities to each task.

• Experience in creating reports from raw data to readable format for higher management, internal and external clients.

• Experience in querying data using Python, R, SQL, and Tableau.

• Proficient in Microsoft applications: Word, Excel (Pivot tables, v-look up, graphs), PowerPoint, Access, Visio and Outlook.

• Excellent facilitation skills and adept at managing the interaction between end-users and management.

• Developed complex SQL scripts on SQL server to and improved the Tableau performance by 80X.

• Exceptional problem solving and sound-decision making capabilities.

• Excellent documentation, communication, interpersonal and customer service skills. ACADEMIC QUALIFICATION

NORTHEASTERN UNIVERSITY, Boston, USA - Master’s in Analytics Sept 2018 - May 2020 UNIVERSITY OF MUMBAI, INDIA - Bachelor of Engineering – Electronics Sept 2011 - May 2015 PROFESSIONAL EXPERIENCE

Akili Interactive, Boston, MA Aug 2019 – Till Date Role: Data Analyst

Description: Identify, analyze, and interpret trends or patterns in complex data sets, filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems. Work with management to prioritize business and information needs. Responsibilities:

• Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems.

• Mining data from primary and secondary sources, then reorganizing said data in a format that can be easily read by either human or machine.

• Using statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.

• Collaborating with programmers, engineers, and organizational leaders to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance.

• Design reports and presentations as needed for Manager, SMEs and Management briefing using excel functions (pivot table, v-look up, if statements) for data driven results. Tata communication Tata Transformation service LTD, Pune Jul 2015- Jul 2016 Role: Data Analyst

Description: Interpret data, analyze results using statistical techniques and provide ongoing reports Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality. Acquire data from primary or secondary data sources and maintain databases/data systems. Key responsibilities

• Collect, extract, compile and analyze data in support of assigned projects and resolve discrepancies

• Provide analysis of extracted and compiled data to support assigned projects as applicable

• Coordinated with stakeholders to gather user requirements using elicitation techniques

• Demonstrating the significance of their work in the context of local, national, and global trends that impact both their organization and industry.

• Preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data. Himalaya Battery service center, Mumbai Aug 2016 -Aug 2018 Role: Data Analyst

Description: Identify and solve business problems, like optimizing profits, minimize turnovers and streamline logistics processes. Key responsibilities

• Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions

• Leading ongoing reviews of business processes and developing optimization strategies

• Managing projects, developing project plans, and monitoring performance

• Data cleaning, Data Visualization, Detection of missing data, correlation analysis, and principal component analysis and model development were performed on the data.

TECHNICAL SKILLS

Analytical Skills: Predictive modelling, data mining and visualization tools, SQL query interpretations, data & quantitative analysis, predictive modelling, machine learning algorithm. Operating system: Windows, Android, Linux, MAC iOS. Tools : Good knowledge of MS Word, MS Office, MS Power point, MS Excel, Tableau, Power BI Languages: C and C++programming, Java, R programming, python, SQL. Big Data Ecosystem: Hadoop, HBase, Hive, HDFS, Sqoop, Spark, Hue. MASTER’S PROJECT

New York Taxi ride analysis

• To predict the duration of taxi rides in NYC based on features like trip coordinates or pickup date and time

• A regression model is trained on these features along with data on the pick-up time and the month the trip took place in. The time series analysis deduces the trend in the trip frequency and pick time over the timeline Vertex Pharmaceuticals

• Visualized and modelled Audit process of Vertex for both GXP and CSQA audits. visualizations which depicts their location of audit process and predicts the future status and approach towards the audit process

• The objective of analyzing and modelling this data is to understand the data pattern and focus on data points to achieve maximum efficiency and optimization in scheduling and resource allocation