Sammy

Responsibilities include: Manage over the reporting and data visualization efforts for our healthcare client, using Power BI to create over 10 dashboards for two different data products and working with existing data over a 10 year period (10TB) to leverage KPIs and create new KPIs; Represent company in client meetings in front of executive team for discussions on building reports; Mentored a team of Data Analyst for reporting and KPI creation best practices; Created structured databases and schemas in Snowflake using SQL to be directly queried to Power BI using both live connection and views; Created architectural relationship diagrams in Power Query to understand optimal data relationships; Created mock ups and sample visualizations for client to be able to choose optimal KPIs and design; Map out all needed data from legacy systems in SSMS and Oracle, logic and attributes, to be migrated and recreated more efficiently in Snowflake using SQL. Including transformations, Joins, rules and procedures; and Understanding of DAX Queries and implementation of new measures to meet needs of client

Manage over the data operations for media buy data in the markets of UK, AU, IN, IT, MX. Owning the lifecycle of a data source from scheduling data to be received raw to staged, transformed and harmonized to new aliases building accuracy within our internal AI; Promoted after the end of year after successfully leading the harmonization of data sources in the markets of US & CA. Enabled 3 teams to work within our process – Data Operations, Data Q/A and Harmonization; Agile work environment with daily stand ups, team meetings and weekly 1 on 1s; Use AWS tools such as S3, Glue, and Athena to preprocess, validate and Q/A data to create job runs to be harmonized by teams working internationally. Work in both production and testing roles; Automate stages of our process using SQL queries, improving efficiency of managing data sources; Work with project management and key stakeholders to increase efficiency and accuracy of AI helping provide insight into new features as well as initiative to clean incorrectly harmonized data
within Data lake; Fix various errors occurring during the life cycle of a job run. Work with team to create long term strategy to increase success rates of data processing; and Create data dictionary for clients and partners

Analyze IT data: Incidents, Service Requests, and CSATs, for Coach, Kate Spade, Stuart Weitzman and Tapestry; Worked closely with Project Management (PM) to create and maintain projects as both a liaison between executives and team. Providing reporting for the COO; Created new IT performance dashboard and Health monthly analysis changing the reporting and presentation style while providing talking points on key KPI metrics and benchmarks; Researched various statistical tools and metrics to add to overall analysis process in place; Updated Customer Satisfaction Survey questions to better represent data being presented and fix
multicollinearity – effectively displaying areas within the company that could use support; Taught and enabled team mates to use various functions in Tableau and preprocess data; Created predictive models to represent the relationship between Customer Satisfaction and various IT metrics used within the industry. Ran trend analysis to find patterns within incidents; and Automate the data processing and Dashboards in Tableau – saved time on data cleaning, dashboard creation, graphic creation

Data mining and modeling: performing in-depth analysis of structured and unstructured data (e.g. transactional/ demographic, web scraping); conducting predictive analytics through statistical modeling; Aggregated and preprocessed market data using R and MySQL; Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications; Product analytics: managing BI platform SmartDash, collecting user requirements and translating
them into features, performing A/B tests, crafting iterative roadmaps based on quantitative and qualitative feedback, optimizing existing features to achieve KPI improvement, monitoring product performance and driving adoption; Research and strategy: designing research and test methodologies, market research and competitive analysis, interpreting test results, and developing recommendations for marketing campaigns and initiatives; Developing visual context for presentations and present research findings to clients and stakeholders. Created interactive data visualization dashboards to support and monitor our analytic
processes using Tableau. Prepared quarterly reports (Line/Pie/Bar charts, Pivot Tables, Vlookup, Solver), Access, Python and produce modeling dashboards/data models; and Validate and Q/A data in SQL

Analyze health professional’s annual certification exam data and create reports demonstrating ways to increase education and help healthcare professionals perform better in their practice; Preparation of compelling interpretation of outcome results including clean, transform and migrate data. Develop multi-faceted data analysis solutions based on predictive, educational, or behavioral factors via relevant modeling techniques (i.e., SPSS, STATA). Work with data extraction tools such as IBM Cognos & Radmin, and manage data using SQL server; Evolve data platform and tools, from data collection to data processing, exploration, visualization, and modeling; Develop research-oriented publications, review exams pre-launch to be consistent in language and meeting educational requirements; Developed Tableau visualizations and dashboards using Tableau Desktop.; Created tables in database using DDL scripts and ran SQL queries in Oracle database to analyze and manipulate data; Used SQL on a daily basis. Conducted ad-hoc analysis to answer business questions. Queried the database and provided client-friendly reports to internal and external partners. Made updates to client data to address data discrepancies found in file testing; and Worked in Waterfall software development methodology