SUMMARY

• Proactive, result driven Data Analyst with a solid track record of providing support to maintain and expand existing data collection and data delivery platforms.
• Experience with data & informatics analytics, Big Data, ETL, Cloud (AWS & Azure),Snowflake, SQL Server, Oracle, Alteryx, Elastic Search, Kibana, Tableau, Sigma BI,AWS Quick Sight and Power BI dashboard creations.
• Good experience in customer journey data analysis including Digital Marketing, Email Marketing, Campaign Analysis, Data Extraction, Data Management, and BI Solutions in Retail & Healthcare domains.
• Experience in transforming business requirements into actionable data models, working in a variety of industries such as Retail, Manufacturing, Wireless, Telecom, Banking/Financial, and Healthcare, Ecommerce, and Insurance domains.
• Hands on experience in Data Integration, Data Quality validation(iCEDQ), and Data architecture.
• Experienced in every role of IT project including Business Systems Advisor, acts as a liaison between technical personnel and business end - users, business process analysis, planning, design and architecture, development, validation, quality control, project management, and ongoing support.
• Hands-on experience designing, developing, and deploying Alteryx workflows, Alteryx Apps and working with Alteryx Gallery & Alteryx Server.
• Strong knowledge in Tableau Desktop, and Tableau Reader, Tableau server architecture.
• Experience in developing ETL code for creating Views, tables, and complex stored procedures specific to the project and maintaining meta data including data catalogs, data dictionary & repositories.
• Developed ETL using MS SQL Server, Alteryx, Oracle, Hue and Tableau Prep Builder.
• Experience including analysis, modeling, design, and development of Tableau reports,dashboard, and stories for analytics and reporting applications.
• Experience building & migrating reports and dashboards in one or more of the BI tools like Power BI, Tableau and tasks like migration analysis to move reports from legacy/ on prem platforms to newer cloud platforms.
• Used complex functions like LOD functions and migrated excel reports to Tableau.
• Created custom Visualizations above the inbuilt ones.
• Strong understanding of the right use of functions and features of tableau for best performance, interactivity, and maintenance.
• Developed & migrated reports from Chartio to Sigma BI analytics tool -built for cloud data warehouse to support day to day data feeds and insights for business team.
• Well versed in managing and tracking analytical user stories in Jira.
• Have more than 6 years of experience in Tableau against multiple database software.
• Excellent knowledge of Business Intelligence tools, data warehousing concepts like Data Modeling, Data Quality, Data Governance, Entity Relational and Dimensional Models.
• Expertise in providing details analytics reports in measuring program trend, cost spent, target audience evaluation by providing 360-degree insights view.
• Quick learner having strong business domain knowledge and can communicate the business data insights easily with technical and nontechnical clients.

TECHNICAL SKILLS

• MS Excel
• MS Access
• MS PowerPoint
• MS Word
• MS Project
• SharePoint. Alteryx
• Tableau
• Power BI
• V-LOOKUPs
• Macros
• New Relic - API analytics
• Kochava
• Sense360i-Competitor Analytics
• Sigma BI analytics Tool
• Confluence
• Aha - Product management
• Jira-Project management
• Azure
• Databricks
• Spark SQL
• Hive
• Impala
• Snowflake
• Hadoop
• Python
• Teradata
• SQL
• Kibana
• Elastic Search
• Oracle
• Salesforce
• AWS
• GIT
• Jira iCEDQ
• Data Quality
• Informatica.

PROFESSIONAL EXPERIENCE

SENIOR REPORTING ANALYST

Confidential

Responsibilities:

• Worked on a migration project to developed & migrated work flows from Informatica power center to Alteryx.
• Developed Alteryx Apps & workflows with Alteryx Gallery and focused on data pulls from multiple systems and transformation activities to combine/harmonize and reformat the data for user reports and dashboards(Tableau)
• Work with teams to review, analyze, and design processes to improve data efficiency and scalability, then develop a plan to move this new process into production while working with teams to write the business and technical specifications, write code, and ensure data quality.
• Performed Alteryx & Tableau server and site administration activities like publishing and sharing workbooks, work flows and data sources to tableau & Alteryx server, setting schedules, subscriptions, authorization, and permissions, scheduling incremental refresh extracts, and updating server data that are using extracts etc.
• Developed & migrated reports from Chartio to Tableau & Sigma BI analytics tool -built for cloud data warehouse to support day to day data feeds and insights for business team
• Identify data sources and data elements needed for new reports, and enhancements to existing reports, and appropriate data sources.
• Work independently with business SMEs to understand a prioritized need and develop Alteryx solutions to resolve it.
• Provided Tableau, Sigma & Alteryx work flows trainings to business users
• Managing user stories in jira and keeping track of analytical user stories.
• Maintaining & managing metadata of business principles & data definitions including underlying logic.
• Data quality validation using iCEDQ.
• Cleansing data as needed and maintain accuracy of critical company metrics and dashboards while migrating dashboards from Chartio to Sigma & Tableau.
• Preparing summaries, reports, and presentations for sales and marketing department leadership, senior leadership, business development, and customer executives.
• Developing & enhancing weekly, monthly and quarterly Pharmaceutical Services, Contracts management, drug distribution, Credits & Rebates, revenue and reports.
• Owning data analysis and visualization, and communicating the outcomes/insights to various business partners to aid strategic decisions for improvements in support experience for drivers and delivery.
• Performing proactive in-depth accounting analysis, measurement, reconciliations of key Revenue, Performance & sales metrics.
• Leveraging SQL(Snowflake, PostgreSQL, AWS), advanced excel, or other scripting and statistical tools to identify trends and analyze data discrepancies.
• Providing support to internal marketing and engineering stakeholders on all data related queries including data quality, isolating and diagnosing the problem and resolving the issue.

Confidential, Raleigh, NC

Responsibilities:

• Provide expert consultation to improve on data availability, data collection, reduce operational costs content and quality. Directing DAE teams and Rx IT to make the right decision on mapping, data interpretation and transformation.
• Demonstrate and maintain deep breadth of knowledge on all product types and business processes; using business knowledge to determine project requirements, resolve business issues and identify changes or barriers which affect project design.
• Work with teams to review, analyze, and design processes to improve data efficiency and scalability, then develop a plan to move this new process into production while working with teams to write the business and technical specifications, write code, and ensure data quality.
• Performing Dimensional Data Modeling, Process Modeling for Data Warehouse /Data Mart design, Identifying Facts and Dimensions, the creation of facets, cubes, Star Schema, and Snowflake Schema.
• Performed Tableau server and site administration activities like publishing and sharing workbooks and data sources to tableau server, setting schedules, subscriptions, authorization and permissions, scheduling incremental refresh extracts and updating server data that are using extracts, single/multi modes, migrating contents, upgrades etc.
• Identify data sources and data elements needed for new reports, and enhancements to existing reports, and appropriate data sources.
• Provided Tableau Dashboard trainings to business users
• Analyzing and deriving insights from Elastic search and Kibana.
• Building custom reports in Kibana to support day to day business needs and insights.
• Develop and deliver complex projects or report solutions in response to customer inquiries using database/reporting tools (Excel, Tableau, AWS Quick Sight etc.).
• Leveraging analysis from Teradata as raw source.
• Performing order analytical functions in Teradata.
• Prepare performance reports (used by the business to drive strategic decisions) book of business, client supplemental report/scorecard, prospective client reports, healthcare vendor quality reports, and utilization accreditation.
• In depthdata analysis of dental, pharmacy claims & benefits, medical claims for stoploss.
• Lead and develop new and improved reporting and metrics to provide insights into a team’s operational effectiveness and preparing detailed operational reports such as ad-hoc reporting, pilots, and tactically oriented daily-to-monthly reports.
• Work productively in a fast-paced environment that requires constant development of data-related technical skill sets across a distributed data architecture (including SQL Server, Excel, Access and other relevant software applications such as Oracle, Hadoop, AWS, Spark, Hive, impala Python, statistics and SQL).
• Managing user stories in jira and keeping track of analytical user stories.
• Maintaining & managing metadata of business principles & data definitions including underlying logic.
• Strong business acumen that can be leveraged to discuss business objectives and technology as well as underlying data required to support product needs.
• Recognizing barriers, problem solving in a complex organization, and providing strategy toward resolution.
• Advanced knowledge and hands-on experience with data mining, analysis, Informatics data processing software and languages needed to research, explore, analyze (including root cause analysis), and report on Healthcare data by writing/understanding/manipulating SQL to extract data, and understand end-to-end delivery within a reporting environment.
• Performeddata analysis in accordancewith HIPPA & HL7 compliances.
• Demonstrated leadership competencies with the ability to collaborate with others, establish working relationships, and communicate effectively across the organization at different levels.
• Strong project management skills and comfort in ability to create and achieve success by negotiating and problem-solving in complex organizations / highly matrix management environments with continuous quality improvement methods and tools (e.g., statistical process control, Six Sigma, etc.)

DATA & BI ANALYST

Confidential, Irving, TX

Responsibilities:

• Responsible for data analytics, report building and metrics reporting for the 7-11’s 7Rewards Customer Loyalty program, 7Now 7-11’s Delivery program.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Performing data cleaning, modeling, crunching, and in-depth data analysis on KPI’s
• Developing visual, interactive reports using Tableau, Power BI for effective prediction and understanding of data analysis trends, and creating automated data analysis workflows using Alteryx designer.
• Translated manual data processes into automated workflows using Alteryx.
• Assisting the Director of Business Planning Analytics through both ad-hoc and project work by analyzing sales data for new opportunities, providing customized reporting and recommendations in support to on-going business decisions and, conducting quantitative analysis including but not limited to ROI, trending, identification and assessment of opportunities and risk, forecasting, regressions, correlation, cannibalization and probability modeling.
• Using Excel advanced techniques like Pivot Table, V-Lookup &H-Lookup for mining data,performing analysis on different sources and summarizing data.
• Performing A/B testing, target vs. control analysis, profiling and market basket analysis.
• Performing customer App engagement (Mobile/Web/POS), competitor analytics, API analytics, AI Augment Reality analytics using Mix panel, Sense360, ThoughtSpot, Kochava & New relic services.
• Used Performance Recording feature in Tableau to understand the timeline, event and query aspect and optimize the dashboard hence reducing the run time.
• Experience in Waterfall as well as an agile environment, including the Scrum process.
• Familiarity with statistical programming languages and packages (Python, Spark, Databricks)
• Effective at communicating insights from data analysis and influencing change.
• Generate insights, recommendations and present these to the senior management.
• Created high level design documents and detail design documents on the data foundation and Tableau dashboards.
• Working on various reporting objects like facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, etc., in tableau.
• Performing Dimensional Data Modeling, Process Modeling for Data Warehouse /Data Mart design, Identifying Facts and Dimensions, the creation of cubes, Star Schema, and Snowflake Schema.
• Data management and analyses to enable customer support teams using Excel, Google Sheets, Tableau, Power BI and SQL.
• Performing descriptive, diagnostic, inferential, prescriptive, and predictive analysis of data.
• Extensively working on the creation of customer segmentation, profiling, and defining customer purchase patterns using existing customer demographical/transactional data.
• Verification of various offers/promotions set by the business teams with pre/post transactional data.
• Defined best practices for Tableau report development.
• Collect, aggregate, synthesize, analyze, and report on data from multiple sources and formats.
• Replaced subprogram ELT presentation deck with Power BI dashboards to monitor all levels of the business line performance. Designed, developed and maintained highly visualized comprehensive dashboards & reports using Excel, Power BI& Confluence.
• Information engineering experience related to data analysis and business intelligence.
• Elicit and manage data reporting requirements with key stakeholders.
• Extract data from various sources using APIs or DB queries.
• Design and implement dashboards based on transformed data.
• Present dashboards to key stakeholders to facilitate the decision-making process.
• Experience with data transformation techniques (knowledge of data architecture, data quality, data mapping, and data structures).
• Compiled with a wide array of data sources, including SQL Server, Excel, CSV, SharePoint, JIRA, and AHA portfolio data. Facilitated Scrum ceremonies: daily stand-ups, sprint planning/grooming, sprint reviews/demos, and retrospectives using JIRA & AHA.

SENIOR TABLEAU/DATA ANALYST

Confidential

Responsibilities:

• Analyzed Requirements and created Business Requirements Document (BRD), Functional Requirements document (FSD) and Use Case Specifications using Requisite Pro
• Completed business process design and development project, included logical data flow diagramming, research, and definition of data aggregation, validation of credit risk calculations & report format designs.
• Involved in Tableau Production deployment activities and end user training to understand the application.
• Experience in performing wireless, telecom including IBD/OBD/SMS/SQS protocols data analysis.
• Omi channel communication data analysis and reporting.
• Implementing data analytics solutions and database response for faster access to data to execute ad-hoc reports and campaigns.
• Performed pre- and post-campaign analysis of campaign to analyze campaign effectiveness by various KPI’s such as profiling, sales increment by a person, average bill value and average basket size.
• PerformedDataValidation using Dataprofiling.
• Performing log analytics through Kibana and monitoring live data feeds via graphical representation of trend as per business needs.
• Used Excel advanced techniques like Pivot Table, V-Lookup & H-Lookup for mining data and performs analysis on different sources and summarized data.
• Integrated Python, Tableau with Hadoop for advanced data visualization and performed statistical modeling.
• Worked towards Logical Data modeling, created class diagrams and ER diagrams. Used SQL queries to filter data within the Oracle database.
• Created a functional specification document that includes the data mapping &data analysis from different sources and coordinated with the development team for data conversion.
• Understanding and querying the master data tables to develop the KPI’s to measure the actual data quality to increase the efficiency of customer and vendor master data.
• Used ETL to loaddatain thedatawarehouse from various Source Systems.
• Extensively used ETL to load data from Excel spreadsheets, flat files into the target databases.
• Extensively involved in Data Governance that involved data definition, data quality, rule definition, privacy and regulatory policies, auditing, and access control.
• Involved in Business Intelligence (BI) and Data Visualization, analyzed the Transaction Processing Data (TPS) using advanced MS Excel/Macros.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the source legacy system.
• Document data flow and assist in the development of Master Data Management (MDM) data models (both conceptual and logical) and design and conduct data profiling.
• Expertise in using Data Modeling Tools for creating Logical and Physical Data Models.
• Present data profiling and subject matters to users of data.

DATA ANALYST

Confidential

Responsibilities:

• Conduct market and compliance analysis for healthcare client (Advance Data Systems)
• Acquire and organize report data using in-house client report templates.
• Responsible for generating queries, reports, and extracts of member claims, provider data, patient demographics, patient health, & risk management.
• Experienced in working with data quality control, data manipulation, and electronic health records concerning HIPAA compliance.
• Responsible for inbound healthcare and hospital data verification and validation using established ETL (Extract, Transform, Load) data warehousing procedures and processing.
• Wrote complex SQL queries to evaluate and update inbound data. Create SQL processing script templates for new datasets.
• Analyzed historical data trends, forecasting data reports.
• Worked on analyzing multiple HL7 messages from the single file.
• Worked on validating clinical data based on HL7 practices.
• Used V-Lookup, Pivot Table, H-Lookup with advanced excel functions IF, COUNT with sort & filter to look at various proportions of data to build charts & graphs.
• Authored KPI data metrics to be present in the data mapping and the metadata information associated with patient data (including the documentation of business data definitions and rules).
• Performdataintegration checks, report anomalies, and communicate with Data Architect for resolution.
• Clean and manipulate complex healthcare datasets to create the data foundation for further analytics and the development of key insights (MSSQL server, Python, Tableau, Excel)
• Develops and provides regular statistical reports and analytical dashboards as requested based on the client’s requirements/needs.
• Provided data analysis as requested by the business for business efficiencies and productivity.
• Reviews data to ensure data integrity, accuracy, and validity.
• Performed ad hoc reporting functions for special needs and requests.
• Automated the report generation process by using macros to develop the monthlyKPIreport that reduced the report.
• Performs other data reporting duties as directed by the Director and Supervisor
• Calculate and analyze claims data for provider incentive and supplemental benefit analysis using Microsoft Access and Oracle SQL.
• Lead and managed the Health Risk Assessment project that was electronically fed data files from the vendor.
• Responsible for the suggestion and development of new reporting to support/problem-solve for the business, such as sales productivity reporting, ad hoc reporting.
• Continuously provided data and analysis for multiple departments to assist in decision making.
• Created functional dashboards from multiple data outlets to synthesize market share.
• Developed or enhanced several strategic models to assist in long term planning of the patient health management system.