Arsha Haridas

Farmington Hills, MI ***** 551-***-**** ad24wd@r.postjobfree.com www.linkedin.com/in/arshaharidas

SUMMARY

Seasoned Data Analyst with more than 5 years of expertise in the media & automobile sector. Proficient in SQL, Python, R, and data visualization tools such as Tableau. Skilled in analyzing customer behavior, optimizing product performance, and providing strategic insights to drive growth. Experienced in conducting statistical analyses and developing predictive models to support informed decision-making. Strong communication skills with a history of collaborating across departments to deliver valuable business solutions.

TECHNICAL SKILLS

Data Analysis & Reporting: SQL, R, Databricks, Tableau, Power BI, Hue, Excel (Advanced functions, PivotTables), Looker, Oozie, Qlik Sense, Apache Spark

Database Management & Warehousing: Teradata, Azure Cloud, Hadoop, AWS, IBM DataStage, Snowflake, Amazon Redshift, Oracle, Apache Spark, Hive, SAP

Programming: Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn), C++, Scala

Software & Tools: Erwin, JIRA, Cloudera, Jenkins, GitHub, Microsoft Office, R Studio, Hadoop DFS, Jupyter, SAS, Visual Studio, Eclipse, Visio, Google Analytics

EXPERIENCE

Technical Business Analyst May 2023 – Present

JRD Systems (FordDirect) - Dearborn, MI

Crafted comprehensive Business Requirement Documents for diverse projects encompassing transition from on premise Hadoop system to Azure environment. Contributions through BRDs led to a 15% increase in operational efficiency.

Reduced resolution time by an impressive 30% by swiftly addressing critical business inquiries at FordDirect through advanced ad hoc analysis and leveraging Hadoop User Experience for actionable insights.

Enhanced process efficiency by 20% and reduced implementation time by generating detailed data processing diagrams in Visio, mapping end-to-end workflows to minimize potential data conflicts.

Reviewed and assessed SOC2 compliance requirements frequently, ensuring adherence to industry standards & regulatory guidelines.x

Identified and proposed process improvements to optimize data processing and analysis workflows, resulting in increased efficiency and cost savings by 2% for FordDirect.

Data Analyst September 2019 – March 2023

Tata Consultancy Services (Sony Pictures Entertainment) - Los Angeles, CA

Led the transition from IBM DataStage to python for ETL processes, enabling direct data capture from third party social media metric APIs, reducing load time by 60% and resulting in 100% automation of the ETL Process.

Analysed using Python packages, the data provided by 50+ customers for Subscription Video on Demand and Ad-based Video on Demand and designed an integrated data model to accommodate data from all customers.

Designed and maintained Oozie workflows and coordinators to automate data processing pipelines, scheduling, and orchestrating Hadoop jobs for efficient data processing and ETL workflows.

Utilized SAP BI modules to conduct in-depth analysis of media consumption patterns, generating actionable insights to inform strategic content creation and distribution.

Built data visualizations using Tableau for business KPIs that reduced manual reporting by 4 hours weekly.

Spearheaded data flow improvement of the existing ETL processes in DataStage by incorporating reusable ETL components for reconciliation framework ; reduced design time by 10%.

Data Analyst Intern March 2019 – September 2019

Intello Group (Merck) - Kenilworth, NJ

Performed statistical analysis on pricing strategies to generate improved forecast models for products.

Developed 5 custom Power BI dashboards, visualizations, and interfaces with Microsoft SRSS after conducting market research and competitor analysis to identify opportunities for business growth and improvement.

Maintained documentation of data analysis processes, data sources, methodologies, and assumptions, to ensure transparency and reproducibility of findings.

Application Developer June 2015 - January 2016

ZingClick - Mumbai, India

Administered and maintained a data warehouse for domestic clients, ensuring data quality in the back-end system; error reduction by 20%.

Developed user interfaces using PHP and Python to enhance operational ease for sales employees, leading to a 30% increase in efficiency.

Enhanced the security of applications by implementing appropriate authentication and encryption measures.

EDUCATION

Pace University, Seidenberg School of CSIS New York, USA

Master of Science (MS) in Information Systems GPA: 3.6 December 2018

University of Pune, MET Institute of Engineering Nashik, India

Bachelor of Engineering (BE) in Computer Science GPA: 3.7 June 2015

Contact this candidate