SUMMARY

• 5+ years of experience as a Data Analyst in the domains of the Finance (mainly Insurance) industry.
• Analyzed complex, high - volume, high-dimensionality data from multiple sources using different data analysis techniques and/or tools to formulate recommendations, learning, and test plans.
• Defined key metrics to assess overall business performance; delivered an in-depth analysis and recommend creative solutions.
• Built/designed story-telling visualizations and dashboards from different databases and monitored workflows for managers at different departments using MS Excel, Tableau, and Power BI.
• Created statistical and predictive models for detail analysis and utilized SQL queries to track progress metrics and performed data analysis with R and Matlab to produce meaningful status reports.
• Compared data across two systems to correct data discrepancies to meet data integrity. Reviewed daily reports for necessary corrections to meet data integrity and made necessary data updates and/or sent notifications to the appropriate departments.
• Ensure compliance with regulatory and company standards for data retention and quality control.
• Monitored and analyzed Daily/Monthly/Yearly sales data to grasp product and market trends.
• Provided data-driven insights to enable decision-making for product and market development.
• Created TEMPeffective marketing strategies and promotion plan to retain existing high-value customers.
• Excavated and attracted new customers through analyzing market trends and consumer preferences.
• Describe the nature of the data needed for each respective application to ensure all in-scope data is documented.
• Collaborates with relevant departments to establish dashboard and KPIs. Creates appropriate analysis reports and MS PowerPoint meeting materials for management.
• Experienced in insurance products pricing phases: Gathering, cleaning, and analyzing multiple sources datasets, predicting profits and loss, design the insurance products, and generating detailed reports.
• Implemented SQL to gather, clean, analyze and summarize large data sets and derive insights from large amounts of diverse customer datasets.
• Assist internal and external stakeholders with the data requests, data reporting, and data validation. Worked closely with the clients to understand business requirements and transfer them from high-level requirements to business requirements with strong story-telling and communication skills.
• Utilized Business Intelligence tools to include OLAP (Online Analytical Processing), Data warehousing, Reporting, Querying tools, and MS Excel.
• Experienced in collecting customer journey datasets from websites, implemented A|B test to analyze differences in customer behaviors between groups.
• Experienced in designing Questionnaires to collect customer data and analyze datasets with Python.
• Experience in ETL techniques with enormous amounts of data from multiple data sources like Oracle, MS SQL, and DB2 databases.

TECHNICAL SKILLS

Operating systems: Windows, macOS, Linux

Databases: Oracle, MySQL, MongoDB, Neo4j

Programming Language: Unix/Linux, SQL, Java, Python

Statistics: R, Matlab, SAS, SPSS

Business Intelligence Tools: Tableau, Power BI, Excel

Big data: Hadoop, Spark, Cassandra, AWS

Web Design: HTML, CSS, JavaScript, Vue, Angular, Flask

PROFESSIONAL EXPERIENCE

Confidential | Pittsburgh, PA

Data Analyst

Responsibilities:

• Performs provider data analysis and reporting in response to external requests from providers and/or regulatory agencies.
• Serves as a technical data expert and liaison between the provider database organization, and other functional areas to support data requests and ensure uniform and consistent data and data flow.
• Acted as a liaison with the assigned analyst completing the report and the requesting department and/or provider, clarifies the report to ensure dat it meets client needs, and halps to clarify additional required information or data needs.
• Generates provider data reports and analyses to support internal client needs including network management, sales, account management, and other key functions.
• Consulted on check on standardization with managers and finance departments to understand metrics and data analysis for health insurance plans.
• Analyzed customer datasets with SQL from the previous year’s sources using different data analysis technologies to calculate the structure of customer compositions and features correlated to insurance loss.
• Implemented MS Excel and Tableau to generate detailed dashboards from different complicated databases for the profit and potential loss for the project.
• Participated in requirement analysis with the pricing for health insurance plans, provided detailed explanations and communications to stakeholders.
• Analyzed previous years’ databases of different health insurance plans from multiple complicated databases use different data analysis technologies to create statistical and predictive models for detail analysis.
• Worked with technology teams to test the database structure of online health insurance plans query system websites.
• Analyzed the customer journey dataset on websites collected for e-commerce, implement the A|B test to analyze the difference in customer behaviors between groups of different checkout page layouts.
• Work with technical teams and business departments on improving layouts of checkout pages with the reports of the A|B test.

Confidential | Pittsburgh, PA

Data Analyst

Responsibilities:

• Analyzed massive medical data from multiple sources, consulted on checking on standardization with product departments and analytic teams to discuss the metrics for gathering data and the database structures.
• Communicated with medical departments on the features and dimensions of the data needed, and worked with technological teams for solutions to improve internal data gathering systems and databases.
• Master new computer software programs and upgrades, as applicable.
• Responsible for compiling, analyzing, and reporting pharmaceutical market data to provide valuable feedback and actionable insights.
• Ensure reporting logic is accurate and sound by comparing the analytical output to data within the source systems, as well as through cross-validation to base reports under the direction.
• Worked extensively with MS Excel (Macros, vlookups, and Pivot Tables), R Studio, and Python scripting to code predictive models and data wrangling.
• Implemented Tableau and Power BI to generate daily, weekly and monthly dashboards from different complicated medical databases to monitor routine operations of medical departments and discuss the solutions for different practical tasks and problems. Articulate business problems and shape analytic results into compelling stories.
• Update product portfolio forecast model and project sales trends.
• Analyze data to evaluate sales performance and provide recommendations to grow market share and revenue.
• Align supply chain team to goals and needs of the commercial drug product strategy.
• Performed Ad-hoc data extraction, data analysis, and reporting through queries in SQL Server, MS Excel, Power BI, Tableau report, or PDF.

Confidential

Data Analyst

Responsibilities:

• Analyzed multiple databases for special models of cars and the quarterly insurance loss from multiple complicated databases use different data analysis technologies to create statistical and predictive models for detail analysis.
• Applying principled methods to quantitative insurance challenges in areas such as risk scoring, pricing, reserving, and estimating customer lifetime value.
• Consulted on check on standardization with managers and finance departments to understand data analysis and the budgets for the car insurance and the market share for this insurance product.
• TEMPEffectively communicating insights with car insurance departments for complex analyses.
• Communicated with branchesand financial systems to correct data discrepancies to ensure data integrity and daily reports precisely.
• Implemented MS Excel, Tableau, and Power BI to generate detailed dashboards for reports on the advised pricing for high risks vehicle insurance to stakeholders.

Confidential

Business Analyst

Responsibilities:

• Gathered massive customer data from complicated sources with SQL, cleaned, aggregated, and analyzed the customer dataset with financial departments and business departments.
• Implemented visualization tools to generate daily, weekly and monthly dashboards from different complicated databases to monitor key features of data.
• Analyzed quarterly and yearly data to generate detailed reports and explain to finance departments and shareholders. Communicated with investors using detailed reports to explain potential profits and losses.
• Optimized reporting processes by reducing manually intensive tasks using tools like SAS Enterprise Guide and TIBCO Spotfire.
• Reduce the time to create a digital performance report for clients from one week to a hour.
• Help digital optimizers and planners to deliver higher quality analysis and optimizations to their marketing campaigns, resulting in greater value to clients.
• Developed highly interactive reporting dashboards in Spotfire dat consistently earned high praise from clients for their ease of use and their straightforward insight.