Pratik Gala

 Conducted audits of published Tableau reports by collaborating with Sr. Analysts.  Created a Tableau dashboard for analysis of usage and categorization of content on the platform.  Brainstormed ideas with the team on the model discussion for use in 2019 for “best customer” and “best activity” segmentation and modeling.

• Formulated a metric for computing the normalized activation score of several drugs on the liver and other tissues in python and visualizing using Tableau by designing an interactive dashboard to determine whether the drug is suitable for market use • Showcased the Tableau dashboard and discussed the comparisons and results with the director of EBTC and stream leaders.

• Conducting weekly office hours to provide tutoring, guidance, and assistance with assignments for students in need. • Held lectures for teaching gradient descent algorithm and predictive modeling for graduate students.

• Conducted data mining, statistical analysis, and data modeling on the company’s data to help reduce the transportation cost. • Created dashboards in Tableau to represent data that helped the company make important business decisions. • Built a Web crawler in python to fetch data from multiple websites to expand the company’s business.

• Analyzing the demographic data in R and Python to create a strategy for determining potential revenue generated by Viacom for their new advertising product incorporating demographic targeting. • Performed data modeling in python on Facebook data to predict the number of impressions and created map in Tableau to visualize the dispersion of users based on factors like age, gender, locale, and city.

• Proficient in Business Intelligence: SAP Business Objects 4.0 SP05 with Info view, Web Intelligence, Webi Rich Client, Crystal reports, BI launchpad, Xcelsius dashboards, Central Management Console (CMC), Universe design tool and IDT • Collaborated with the Data Warehouse and Database Management team to design Universes on Business Objects designer • Analyzing the financial data related to Gas and Water work orders to gather insights and designing reports by extracting, cleaning and merging data from various tables in the relational database using SQL for Ervia business users • Implemented complex SQL query to modify data at report level to avoid complexity at Data Warehouse level. • Managed, updated and manipulated report structures and alignment with the utilization of advanced Excel functions including Pivot Tables, VBA and V-Lookups. • Utilized techniques like contexts, filters, sectioning, ranking and incorporated sound business logic to develop BO reports. • Accelerated team’s performance and resolution time by implementing a report to automate the manual process of tracking incidents. • Worked on change requests (CR's) as per user requirements. • Provided on-call support for the production system to resolve issues. Business Development • Responsible for collecting information by coordinating with clients and stakeholders, interpreting gathered information, and documenting data specifications, functional and business requirements • Accelerated team’s performance and resolution time by formulating a report to automate manual process of tracking incidents • Trained and supervised juniors by delegating operational tasks and organized knowledge transfer sessions