Senior Data Analyst
Resume:
Feng Feng
Senior Data Analyst
*********@*****.***
https://www.linkedin.com/in/feng-feng-68b22975/
Gainesville, FL, 32608, United States
Summary
Highly accomplished Senior Data Analyst driving efficiency, growth, and data integrity. Accelerated migrations, boosted web conversion, and prevented KPI loss. Expertise in Python, R, SQL, Tableau, Snowflake, and Alation for impactful analytics.
Technical Skills
●Databases: MS SQL Server, Oracle, MySQL, Snowflake, Google BigQuery
●Reporting & BI Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI, QlikView, JMP, Excel
●Programming & Scripting: T-SQL, ColdFusion, HTML, CSS, JavaScript, Python, R
●Database Management & Governance: SSMS, ETL (DTS), Data Warehousing (star schemas, snowflakes), Alation, Performance Tuning, Data Conversion, Normalization, Data Modeling, Database Design
●CRM/Healthcare Systems: Salesforce, AllScript, JourneyBook, Epic
●Analytics Systems: Invoca, Google Analytics 4, Google Analytics 360, Google Tag Manager
Work Experience
Report Automation Writer Feb 2023 - Present
City of Hope Remote
●Supported the EHR and Data Warehouse Migration Project, facilitating the transition from AllScript to Epic and SQL Server to Snowflake. Innovated month-end close processes by integrating Epic metrics and eliminating manual Excel inputs, accelerating the process by 25%.
●Achieved a 10% increase in web conversion rate through comprehensive analysis of landing page performance and impressions, utilizing Google BigQuery and Tableau.
●Proactively identified and remediated critical data gaps, leading the effort to discover and import missing KPIs from Snowflake revenue reports. This action successfully avoided a 15% KPI loss, ensuring the completeness and reliability of key performance indicators.
●Drove a 15% increase in data platform performance by leading data governance initiatives utilizing Alation for Google BigQuery, Salesforce, and Snowflake environments. Ensured data quality and consistency across disparate systems.
●Developed a predictive model using Python, achieving a high degree of accuracy with results consistently within 2.5% difference to actual metrics.
●Spearheaded a Regional KPI Optimization Project, utilizing R for in-depth data analysis to identify performance drivers. This initiative led to a 10% increase in regional KPI achievement.
Report Writer Aug 2018 - Feb 2023
Cancer Treatment Centers of America Boca Raton, FL
●Optimized marketing budget by 25% and boosted revenue by 30% through cluster analysis of Designated Marketing Areas (DMAs) using JMP for strategic prioritization.
●Successfully transitioned reporting from ColdFusion web reports to Tableau Server, completing the BI Modernization Project 5 days ahead of goal.
●Successfully transitioned CRM operations from JourneyBook to Salesforce, completing the CRM System Upgrade Project 7 days ahead of goal.
●Acted as a consultative partner to educate key stakeholders on the effective use of Tableau web reports, leading to a 25% improvement in reporting efficiency.
●Established a new Customer Access Channel Project, creating Brand Equity & Marketing and Sales Program categories with Workday Equivalent business patterns. This initiative optimized the budget and revenue cycle, directly leading to a 15% increase in revenue.
●Drove a 25% efficiency increase by collaborating cross-functionally with the Strategy (using QlikView) and Finance (using Power BI) teams to establish an integrated reporting system.
●Accelerated the Month-End Close Process by 25% through the development and optimization of a key Tableau dashboard.
Data Analyst May 2015 - Aug 2018
First Tek, Inc. Boca Raton, FL
●Leveraged Google Analytics 4, Google Analytics 360 and Google Tag Manager to perform in-depth web analysis, uncovering key user behavior patterns and optimizing digital campaign performance by 25%.
●Utilized SEO best practices and conducted A/B tests to optimize web content and drive 30% improvements in search rankings, user engagement, and conversion rates.
●Transformed media effectiveness through a Media Spend Optimization Project, analyzing TV and SEM data using SQL, Excel and ColdFusion web reports to inform strategic decision-making. This initiative successfully delivered a 20% reduction in budget and a concurrent 25% uplift in revenue.
●Designed and implemented call tracking solutions for marketing campaigns, provisioning toll-free and local telephone numbers within Invoca. Established rigorous test plans to confirm tracking accuracy, boosting overall measurement efficiency by 30%.
●Drove 40% improvements in media tracking capabilities by maintaining a proprietary online tracking tag and collaborating with a team of JavaScript experts to implement advanced tag tracking enhancements on the website. This ensured robust data collection for marketing campaigns.
●Achieved a 30% increase in efficiency by leading month-end close activities, optimizing workflows and reporting procedures through cross-functional collaboration with Marketing Analytics, Hospital Report Administration, CRM, and Data Warehouse teams.
●Designed and implemented call tracking solutions for marketing campaigns, provisioning toll-free and local telephone numbers within Invoca. Established rigorous test plans to confirm tracking accuracy, boosting overall measurement efficiency by 30%.
SQL Developer Mar 2014 - Apr 2015
Cloudeeva Schaumburg, IL
●Drove operational excellence during month-end close by ensuring 100% accurate financial and operational data. This involved precise compilation and validation across Excel, JourneyBook, AllScript, and SQL Server databases.
●Solved critical inefficiencies in reporting by leading the transition from Excel to ColdFusion web reports. Developed a suite of dynamic web reports using ColdFusion and SQL in Dreamweaver CS5, which ultimately boosted reporting efficiency by 50%.
●Provided user training on newly implemented ColdFusion web reports to key stakeholders, fostering data literacy and driving a 25% increase in reporting efficiency.
●Led a Database Performance Optimization Project by designing, reviewing, and creating primary SQL objects (Views, Indexes, Stored Procedures, Functions, Triggers) based on logical design models and user requirements. This initiative significantly boosted database performance by 30%.
●Spearheaded the Marketing Funnel Optimization Project, building and implementing a proprietary marketing funnel with comprehensive ETL processes directly within the SQL Server database to enable data-driven decision-making, which resulted in a 50% revenue increase in the current year.
Collaborated with Data Warehouse teams to define and document reporting requirements, then rigorously tested changes to CRM and Data Warehouse platforms. This ensured 100% accurate reporting information capture and improved database performance by 25%.
Education
Illinois Institute of Technology Jan 2012 - Dec 2013
Master of Computer Science
Henan University Sep 2007 - Jun 2011
Bachelor of Computer Science
Contact this candidate