| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Farmington Hills, MI Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLESUMMARYSeasoned 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 SKILLSData Analysis & Reporting: SQL, R, Databricks, Tableau, Power BI, Hue, Excel (Advanced functions, PivotTables), Looker, Oozie, Qlik Sense, Apache SparkDatabase Management & Warehousing: Teradata, Azure Cloud, Hadoop, AWS, IBM DataStage, Snowflake, Amazon Redshift, Oracle, Apache Spark, Hive, SAPProgramming: Python (NumPy, Pandas, Matplotlib, Seaborn, Scikit-learn), C++, ScalaSoftware & Tools: Erwin, JIRA, Cloudera, Jenkins, GitHub, Microsoft Office, R Studio, Hadoop DFS, Jupyter, SAS, Visual Studio, Eclipse, Visio, Google AnalyticsEXPERIENCETechnical Business Analyst May 2023 PresentJRD Systems (FordDirect) - Dearborn, MICrafted 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.xIdentified 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 2023Tata Consultancy Services (Sony Pictures Entertainment) - Los Angeles, CALed 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 2019Intello Group (Merck) - Kenilworth, NJPerformed 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 2016ZingClick - Mumbai, IndiaAdministered 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.EDUCATIONPace University, Seidenberg School of CSIS New York, USAMaster of Science (MS) in Information Systems GPA: 3.6 December 2018University of Pune, MET Institute of Engineering Nashik, IndiaBachelor of Engineering (BE) in Computer Science GPA: 3.7 June 2015 |
