TECHNICAL SKILLS:

• Qlikview
• Tableau
• E1
• EDW IBM Cognos
• Alteryx
• Power BI
• SQL scripting
• Adobe Analytics
• Adobe Social and distribution of dashboards - reports.MS Project
• Visio
• Access
• Excel
• Power point
• R Statistical software
• PHP (basic understanding)
• sharepoint and Outlook.Ultra-runner
• tennis
• golf

PROFESSIONAL EXPERIENCE:

Confidential, CA

Manager Marketing Analytics 

• Manage analytics and reporting for biosciences division. Use of multiple tools and data sources to build insightful and easy to interpret visualizations using SQL, Adobe, Google A, IBM Cognos, and Tableau/Power BI: Built from scratch MS SQL database as a repository for all data collected from multiple systems and sources.
• Blended data to provide most granular level breakdown and roll up to supply reports from Business Unit partners to C - Level executives as well as channel managers.
• Used various tools and reporting suites like Adobe Site Catalyst, combined with data techniques and modeling to supply reports and analysis along with recommendations. Develop workflows using Alteryx to clean data and load into database. Build insightful visualization and dashboards in Tableau.
• Use advanced techniques including Ranks and LOD calculations, advanced filters and actions.
• Identify and build business relationship across organization to promote and support data governance initiatives. Define standards and align data across departments to resolve disparate data: Maintain, de-duplicate and align product hierarchy to financial data and marketing campaign structure to facilitate reporting trends and comparison of data period over period. Incorporate data from different departments to validate trends and evaluate efficacy of marketing spend through ROI analysis.
• Change tracking code of marketing tactics to trace lagging indicators through various systems (e-Commerce revenue and CRM leads and opportunities revenue).
• Build professional relationship with a network of people across a matrix structure to share best practices, data governance, promote scalability through standardization while supporting recommendations with data, to impact change.
• Align, maintain, support other groups and scale back-end processes: Product classifications, attributions and parameter expiration alignment. Develop and implement structures, support development of tools and processes that improve reliability, accessibility and data automation.

Confidential, CA

Market Research Analyst

• Design architecture for full funnel database and dashboard to report key performance indicators to support Marketing leadership and Marketing Business Units (BU) Leaders by integrating: Product hierarchy (E1) alignment to marketing structure in conjunction with marketing metrics (Multiple Sources), cost and revenue (EDW IBM Cognos), into MS SQL to ensure stability, safety, flow, and distribution through aggregator tool (Tableau).
• Collaborate with cross functional departments to gather requirements and validate the accuracy of data. Ensure relevance of metrics reported to audience. Work with business units and leadership to ensure reporting relevance and analysis to facilitate business decisions.
• Demo and facilitate communication through strategic partnership and collaboration with key subject matter experts to ensure reliability of implementation of software application systems and fulfilment of business requirements by technical counterparts.
• Build up support from team members to implement changes to structure, standards and procedures.
• Adopt design processes envisioning scalability of reporting and automation to accommodate to integration requirements.

Confidential, CA

Financial Analyst

• Turn raw data from multiple platforms including SQL servers, DTS packages, Access, Excel into user friendly business objects dashboards using Qlickview and full cycle reports to include: marginal cost, marginal revenue, claims, estimation of claims reserves requirements (IBNR), and capitation at membership, line of business and aggregate levels.
• Liaison between executives, IT and finance to determine information requirements, format and bench marks for the development of financial reports. Business processes improvement and revenue recognition through processes mapping and re-engineering.
• Mentor analysts on use of SQL and access to augment processes reduce redundancy and increase productivity. Update complex query scripts, explain and write advanced excel formulas for the use of Decision support department members and reports. Solve and improve chart design problems of excel presentations. Support other members of the organization with excel, access and SQL issues.
• Create SQL scripts and stored procedure to create, update, delete, append, join tables, and create databases. Query metadata for tables and data normalization, create bridge tables, indexes, and design cubes for analysis and reporting.
• Set up data connections between SQL server, Access and Excel. Create databases in access, tables, queries, forms and reports for management using calculated fields, forms, lists and combo boxes.
• Prepare recurrent and ad-hoc reports: Medical Management reports, score cards, bed-days per thousand, pay for performance, trend recognition and outlier analysis. Present variance analysis and summarize large data sets of joined tables on common records onto excel pivot tables and charts.

Confidential,Irvine, CA

Web Statistical Analyst

• Perform testing of Yieldex system for forecasting online traffic, impressions, click through rates and monetization. Analyzed reporting capabilities and accuracy, to include: Statistical analysis measure confidence level of forecast, z- test statistics and ANOVA, ability to predict seasonality and adaptability to predict new product behavior.
• Carry out Revenue and Monetization analysis; CPC, CPM(at various levels) Pacing of booking, ad revenue realized, sell-through rate, ad traffic measurements and monetization compared to Google Analytics and Omniture readings, over-delivery/under-delivery of guaranteed impressions. Identify and quantify available impressions and revenue opportunities.
• Tested Reporting capabilities, determine requirements to create ad hoc reports for sales, operations, analytics, and finance departments. Set up user permissions and distribution schedules. ETL, and validate data flow and quality.
• Evaluate “What if scenarios” to allocate guaranteed under delivered sold ads to estimate impact on financials. Summarize analysis results and create presentations and dashboards to Senior Management.

Confidential, Ca

Project Data Analyst

• Examine, Financial Statements, indices, ratings and employee knowledge, to determine cost savings and revenue opportunities; to include: Profit and loss statements, Balance sheets, cash flow statements, insurance policy premiums and modification factors, payroll (labor hours), industry standard KPIs.
• Communicate with all departments, and key members of the organization to qualify and quantify data and map data processes. Analyze department and process performance. Assign costs to processes.
• Select appropriate statistical, accounting, financial, mathematical method to compare cross-functional data. Compare key performance indicators of industry standards to variances, indices and modification factors.
• Identify areas of improvement, goals and scope of analysis with owners and department managers. Draw inferences regarding cost-benefit ratios of implementation.
• Identify inefficiencies and quantify correlation to cost based on exception alerts.
• Calculate impact Profit & Loss statement and present to stakeholders.
• Recommend implementation and cross-functional training on new processes and equipment.