Data Analyst Iii resume example

Implementing creative solutions in IT innovation center to improve various business KPIs using Agile methodology

• Worked with users across the enterprise to clearly define challenges and their scope
• Identified and established data collection methods based on the scope, time and resource availability.
• Performed data preprocessing and EDA using various tools such as BigQuery, Azure Advanced SQL, Python, R and Tableau
• Applied various machine learning models such as Linear Regression, KNN, and CatBoost to predict and classify cases as well as identify potentials for business KPI improvements.
• Analyzed model performance and results and fine-tuned models via methods such as grid search and PCA.

Ensuring enterprise compliance with CCPA and other consumer data rights using BigID and OneTrust technologies

• Worked with the product owner to identify PI data across multiple functions such legal and marketing
• Worked with solution designers to connect BigID with structured and unstructured PI data sources such as Oracle RDB, MySQL, Workday, Box, and Sharepoint through APIs.
• Defined correlation sets required by BigID to scan data sources and discover linked personal data across all of them
• Analyzed BigID PI profile scan results and compared them with 1k+ datasource objects to validate and fine-tune discovered PI correlations by BigID
• Performed unit tests to ensure consumers and employees can submit DSAR requests through OneTrust and receive accurate reports of their PI data in systems connected to BigID.
• BigID implementation has empowered enterprise users to save ~ 90% on time and effort via automation of discovering correlations of PI data scattered across various silo data sources.

Integrating different data domains and source systems to create robust enterprise data solutions and reports

• Documented and created user stories for business requirements and processes across multiple domains such as sales, marketing, ecommerce, and HR.
• Analyzed, profiled and modeled data available in various internal and external sources such as SAP R/3 and BW on HANA, IBM Silverpop, Workday, IRI and Nielsen, Google DCM, Oracle Bluekai, MOAT, and Salesforce
• Worked with data engineers and created database objects and stored procedures in Big Query and Azure SQL to host in GCP and Azure data lakes.
• Rewrote BeX queries in SQL and recreated BW LSA transformations in Azure and Oracle SQL to enable consolidation of enterprise KPIs and BI reports across multiple sources.
• Evaluated and tested data quality and flow among various source systems using SQL, Python, R, and SAP BW Workbench.
• Identified and resolved various data quality issues existing among integrated systems such as OBIEE, Oracle SQL DB, and SAP BW.

Managing and mentoring interns

• Managed and trained an intern during summer 2020 to use different data sources and systems such as SAP BW and Oracle SQL.
• Mentored three summer interns and helped them to acquire and improve their technical knowledge and soft skills. All three received full time offers from IT department.