Data Analyst

Jehan Joshi

add79s@r.postjobfree.com 217-***-**** linkedin.com/in/jehan-joshi-484127a7/

SUMMARY

Highly analytical and process-oriented. Skilled in research methodologies, curation, manipulation, analysis and visualization of data in a fast-paced environment. Furnishing insights through analytics to enable incremental corporate growth and “Data – Driven” decision making.

PUBLICATIONS AND CONFERENCE PRESENTATIONS

Singh, N., Kaverappa, C. B., & Joshi, J. D. (2018). "Data Mining for Prevention of Crimes". In International Conference on Human Interface and the Management of Information (pp. 705-717). Lecture Notes in Computer Science, vol 10904. Springer, Cham. (ICHIMI 2018) Dr. Neetu Singh, Chengappa Bellathanda Kaverappa, Jehan Joshi, “Data Mining for Prevention of Crimes”, Human Computer Interaction (HCI) International Conference 2018 (Accepted), Las Vegas, Nevada. Proceedings Published by Springer.

Singh, N., Agarwal, A., Kaverappa, C. B., & Joshi, J. D. (2018). "Status of HIE Adoption in US: Implementation Challenge". Decision Sciences Institute Annual Conference. (DSI 2018)

CORE QUALIFICATIONS

Programming Languages: - Python, SQL, Pyspark

Databases: - DB2, Postgres, Redshift, SQL Server, Cassandra

BI Tools: - Power BI, Tableau

Cloud Technologies: - AWS (S3, EMR, EC2, Athena, Glue Crawler)

ETL/Data Engineering: - SSIS, Apache Airflow, Data Warehouses, Data Lakes

Others: - MS Visio, Jira

PROFESSIONAL EXPERIENCE

Business Intelligence Developer SKAPS Industries, GA, USA Dec 18 - Present

Accomplishments

Data Visualization and Analysis:

Extracted machine status data from Siemens PLC’s and implemented real time machine downtime dashboards and downtime data recording using Python, Node-red and Postgres improving accurate downtime identification and analysis.

Outcomes:

Implemented Power BI dashboards to analyze transactional ERP data of over 6 million records and study customer churn and buying patterns.

Developed Power BI production dashboards for all product verticals Enhancing production planning and efficiency by 30%.

Extracted QuickBooks Enterprise data using QODBC, SSIS and Python to automate reporting key financial metrics.

Implemented and maintained analytical SQL views in IBM DB2 for data consumers to access relevant ERP data.

Leading Report Automation and Data Analysis efforts improving reporting efficiency by 50%.

Technology Specialist Goodwill Industries International, MD, USA. June 18 -Dec 18

Accomplishments

Data Visualization and Analysis:

Using Tableau Server and SQL Server to extract data and create analytical reports and dashboards utilizing complex parameters, filters and calculated fields improving data access and reporting across all member Goodwill’s.

Outcomes:

Facilitated better technology adoption strategies by developing Analytical reports/Dashboards on Tableau.

Streamlined existing projects and new projects by gathering user requirements, developing use cases, conducting JAD sessions and developing a Business Intelligence Solutions Center.

Developed and implemented SOP’s and Development guidelines for tableau development across the organization.

Developing Ad-Hoc system usage reports which helped the organization improve system usage by 40%.

Data Analyst Spotluck Inc, MD, USA. Feb 18 – June 18

Accomplishments:

Data Visualization and Analysis:

Implemented the proprietary algorithm for “Play Octopus Interactive” to calculate product usage metrics using Python influencing business strategy and product positioning.

Outcomes:

Conducting Ad-Hoc analysis for various departments by writing SQL Queries to extract data from Postgres and Redshift.

Streamlining development processes by writing clear and concise User – Stories on Jira.

Interact directly with Business process owners, Finance, and IT to design and implement data analysis solutions. Continually re-assess these solutions in efforts to make them more efficient and effective.

Developing customized interactive reports and dashboards on Tableau Server to enable automated reporting.

Created filters, complex parameters and calculated fields on worksheets in Tableau enhancing analysis.

Facilitating daily Stand-Up meetings at the organization ensuring the organization adheres to agile values.

EDUCATION

University of Illinois Springfield, IL, US Masters of Science in Management Information Systems; GPA: 3.86 December 2017

CERTIFICATIONS

Springboard Certified “Foundations in Data Science”. December 2017

Udacity Data Engineering Nano-Degree May 2020

Contact this candidate