Data Analyst

Sourabh Ramakant Dharurkar

*****************@*****.*** +1-714-***-**** www.linkedin.com/in/sourabh-dharurkar EDUCATION

California State University, Fullerton Master of Science in Information Systems (GPA: 3.73) May 20 Savitribai Phule University, India Bachelor of Engineering, Computer Science May 14 SKILLS

Functional: Data Analytics, Data Mining, Business Intelligence, Data Visualization, Data Modeling, Troubleshooting, Agile/Scrum Development, Documentation, Leadership, Excellent Communication Skills Technical Skills: SQL, T-SQL, PL/SQL, Hadoop, R, Python, Pandas, NumPy, JD Edwards, UML, DB2/400 Application/Tools: Google Analytics, Adobe Analytics, SAS, SSIS, SSRS, MySQL Pivot Tables, Tableau, Power BI, Qlik View, PostgreSQL, MS Excel (Pivot Tables, VLOOKUP, VBA, Macros), Microsoft Office CloudServices: AWS (EC2/S3), Google Cloud Services, BigQuery, Salesforce, SAP PROFESSIONAL EXPERIENCE

AB Tech. Pvt. Ltd. (Thermo Fisher Scientific) Business Intelligence Analyst May 17-July 18

• Conducted statistical data modeling working sessions to gather requirements, validate data sources, identify data rules and drive consensus on customer and product subject areas

• Developed complex relational databases objects like stored procedures, functions, triggers using SQL and Oracle PL/SQL queries for data retrieval and data processing which resulted in enhanced efficiency of data collection procedure by 6%

• Acted as a subject matter expert (SME) in data subject areas such as sales, inventory, network operation, and finance ShareChat (Mohalla Tech. Pvt. Ltd.) Product Analyst June 16-April 17

• Performed multiple A/B testing and user acceptance testing on the product and reported errors with root cause analysis the developers for resolution before product launch; improved sign up funnel by 10%

• Defined social key performance indicators (KPI), business metrics to support editorial content strategy and business marketing; curated and segmented editorial content to increase engagement and channel growth for better ROI

• Observed Client activity and demographics using Google Analytics to evaluate trends and determine the target audience

• Designed presentations, and peer-mentoring programs for the new employees; reduced onboarding time by 50% AB Tech. Pvt. Ltd. (Johnson Matthey) Business Analyst July 14-May 16

• Created functional design specifications and implemented SDLC project methodologies in designing, documenting, and developing interactive ERP applications based on business requirements of business stakeholders

• Managed cross-functional team of 12 in 4 locations (London, California, Pune, Beijing), ranging from technical teams to directors and collaborated with business development, data solutions, operations and performance

• Used Microsoft Excel to create a pivot table and pivot reporting, as well as VLOOKUP function for improving data quality and easily accessible insight for quick decision making RELEVANT PROJECTS

Diabetes Analysis and Prediction Data Scientist Spring 20

• Utilized Python to perform feature engineering and execute supervised machine learning techniques on healthcare dataset

• Generated a visualization dashboard and conducted data analysis with analytical software tools, Tableau and Power BI

• Used Gradient Boosted model and achieved 65% accuracy in determining the top metrics related to patient readmission Analysis and Prediction of Bank Marketing Dataset Data Analyst Fall 19

• Examined a banking sector large dataset with 45000 records to understand and find quantifiable correlations and KPIs’

• Computed machine learning algorithms and data science techniques like k-NN, CART, and Logistic regression using R

• Presented the findings and used confusion matrix on validation data to determine the accuracy and provide the best model Stock Market Analysis Data warehouse and ETL Engineer Spring 18

• Extracted live data of the stock market using PostgreSQL server to calculate returns and perform portfolio optimization

• Transformed obtained data in RStudio by connecting it to the DB server and used PIVOT function for statistical analysis

• Used performance analytics on historical data to successfully forecast the future prices of stocks with an accuracy of 84% Car Dealership Sales Management System Analyst Fall 18

• Planned, designed, and developed the entire custom-built system holding historical data of a car dealership company

• Created modules like inventory management, sales management based on functional and non-functional requirements

• Constructed flow charts, use-cases, workflows, and ER models with MS-Visio to depict all the organizational entities

Contact this candidate