SUMMARY

• 6 years of IT experience and Certifiedas Microsoft in Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms across Manufacturing and Retail domains.
• Over 3 years of Tableau Experience in enterprise environment including report / dashboard design, development, maintenance and support using various versions (10.x/9.x/8.x) of Tableau Desktop and Tableau Server.
• Strong experience in System and data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Experienced in Data warehouses and Data marts for business intelligence reporting and Data mining along with developing and documenting process flows for business processes.
• Excellent industry knowledge on Membership, Claims processing, Provider, Prescription Benefits Management, Clinical Data, LAB Data Value Based Care, Wellness Content Management, Medical Management and Medicare, HEDIS, EDI and Standard Medical code set (CPT, ICD9/ICD10, LAB etc).
• Extensive Knowledge of HealthCare Data including claims, Pharmacy, Lab, Member, Providers, HEDIS Measures Knowledge, CMS and NCQA knowledge domain.
• Experienced in all phases of the Software Development Life Cycle (SDLC), Rational unified process (RUP), agile methodology.
• Experienced in Business Process Reengineering and Gap analysis to check the compatibility of existing system infrastructure with new business requirements. End to end experience in designing and deploying Data visualizations using Tableau.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyser and SQL Navigator.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large enterprise Data warehouse systems. Expertise in MS Access & Excel, Macros, Pivot Tables, and VBA
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Excellent presentation skills, and interpersonal; expert at managing multiple projects simultaneously. Experience in working well independently as well as part of a team. Experience working with business users as well as senior management.
• Excellent oral and written communication skills with ability to communicate with all levels of management and team members. Expertise on onshore - offshore model in IT and business environment.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Configuration Management.
• Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration.
• Proficient knowledge and can work with any visualization tool such as TIBCO Spotfire and Power BI.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Highly Proficient in Agile, Iterative, and Waterfall and Scaled Agile Framework (SAFe) software development life cycles.
• Worked in Formal Systems analysis design, implementation of Operational/Database systems utilizing Microsoft SQL RDBMS Methodologies.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps as per the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations, etc.
• Expertise in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Power Bi,, MicroStrategy, Tableau and Database technologies.
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Adept in analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and assisted in Post-Production support.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Hands on experience in Integrating SAP R3 with Enterprise management systems.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCES:

Sr. Data Analyst

Confidential, Bentonville, AR

Responsibilities:

• As a senior business systems analyst, performed extensive data analysis on a very large Teradata data warehouse
• Responsible for performing Machine-learning techniques regression/classification to predict the outcomes.
• Performed Ad-hoc reporting/customer profiling, segmentation using R/Python.
• Tracked various campaigns, generating customer profiling analysis and data manipulation.
• Provided R/SQL programming, with detailed direction, in the execution of data analysis that contributed to the final project deliverables. Responsible for data mining.
• Utilized Label Encoders in Python to convert non-numerical significant variables to numerical significant variables to identify their impact on pre-acquisition and post acquisitions by using 2 sample paired t test.
• Worked with ETL SQL Server Integration Services (SSIS) for data investigation and mapping to extract data and applied fast parsing and enhanced efficiency by 17%.
• Developed Data Science content involving Data Manipulation and Visualization, Web Scraping, Machine Learning, Python programming, SQL, GIT and ETL for Data Extraction.
• Designing suite of Interactive dashboards, which provided an opportunity to scale and measure the statistics of the HR department which was not possible earlier and schedule and publish reports.
• Provided and created data presentation to reduce biases and telling true story of people by pulling millions of rows of data using SQL and performed Exploratory Data Analysis.
• Applied breadth of knowledge in programming (Python, R), Descriptive, Inferential, and Experimental Design statistics, advanced mathematics, and database functionality (SQL, Hadoop)
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS)
• Involved in defining the Source To business rules, Target data mappings, and datadefinitions.
• Performing Data Validation / Data Reconciliation between disparate source and target systems for various projects.
• Utilized a diverse array of technologies and tools as needed, to deliver insights such as R, SAS, Tableau and more.
• Performed in-depth data analysis using Teradata SQL and SAS.
• Built Regression model to understand order fulfillment time lag issue using Scikit-learn in Python.
• Used T-SQL queries to pull the data from disparate systems and Data warehouse in different environments.
• Used BTEQ utility and wrote T-SQL queries in Teradata for generating reports for end users.
• Developed commands in MongoDB for data extraction and other business activities.
• Worked closely with the Data Governance Office team in assessing the source systems for project deliverables.
• Extracting data from different databases as per the business requirements using SQL Server Management Studio.
• Interacting with the ETL, BI teams to understand / support on various ongoing projects.
• Extensively using MS Excel for data validation.
• Involved in data analysis with using different analytic techniques and modeling techniques.

Environment: Data Governance, SQL Server, Python, ETL, MS Office Suite - Excel (Pivot, VLOOKUP), DB2, R, Visio, HP ALM, Agile, Azure, MDM, Share point, Data Quality, Tableau and Reference Data Management.

Data Analyst

Confidential

Responsibilities:

• Gathered and analyzed the business requirements and then translate them to technical specifications and performed impact analysis.
• Analyze the data from different data sources and develop Tableau and Spotfire Reports.
• Created various workflows in Alteryx to manipulate the raw data.
• Participated in the architecture and design of features associated with Collaboration and Scaling of Alteryx across the business.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Extensively worked on performance tuning of mappings, sessions and various ETL Processes.
• Worked on Tableau desktop for some of the reports replicating the SSRS reports.
• Creation of dashboards with Combination Charts, Custom Charts based on the customer requirement.
• Designed and developed various analytical reports from multiple data sources by blending data on a single Worksheet in Tableau Desktop.
• Created various reports in TIBCO Spotfire using data functions and information links.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.
• Used serval components in pipeline pilot to manipulate the data and to extract the data into Tableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and Server.
• Trained the business users on Tableau's self-service model of Creating and Publishing the Reports.
• Provided resolution to performance problems of dashboards deployed on Tableau server using out of the box performance analyzer tool of Tableau desktop and Tableau server.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Supporting Statistical programming team with programming activities.
• Provided post implementation production support.

Environment: Tableau Desktop 10.x, Tableau Server 9.2, TIBCO Spotfire, Oracle, MySQL, MS SQL Server 2017, Excel, TSQL, UNIX, HP Quality Center.

Data Analyst

Confidential

Responsibilities:

• Analyzed the requirements and segregated them into high level and low-level Use Cases, activity diagrams, using MS VISIO according to UML methodology thus defining the Data Process Models.
• Monitored and analyzed the historical data, productivity and current trends to identify opportunities using Tableau. Worked on creating Dashboards and Reports using Tableau as per the business needs. Developed executive KPI reports using Power BI.
• Designed, developed and managed performance metrics, reports, analysis, dashboards; drove key business decisions to managers and participated in writing Data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements and assisted the QA team in preparing Test Plan, Test Cases and in User Acceptance Testing (UAT) and acted as a liaison between technical staff and lead users. Created UI designs, UI mockups and write business rules based on that for IT and QA Team
• Integrated Custom visualizations based on business requirements using Power BI to tell stories with Data. Prioritized backlog through constant A/B testing and user feedback.
• Gathered and managed Business (BRD)/Stakeholder/Functional requirements through the complete SDLC, using waterfall/SDLC methodology and used SQL Queries to validate Data back end to ensure that all the claims related Data has been loaded to the appropriate Data sets.
• Analyzed purchase patterns and attitudinal Data to reveal new CRM growth opportunities to enhance consumer spending and provided timely and accurate productivity reports and analysis with MS Excel, including the creation and maintenance of regular and ad hoc reporting and the development of improved reporting processes.
• Documented the as-is processes/ systems and analyzed the as-is and the to-be systems for accurate file/ Data transfer utilities/ protocols and documented the agreed upon requirements as Business requirements and functional requirements for the to-be system. Developed and implemented ERP customizations.
• Managed direct reports in 4 functional departments of supply chain management: demand planning, materials management, warehousing/transportation, and customer service.

Environment: Data mapping, Data migration, Data cleansing, VB Macros, Pivot tables, Vlookup, MS Excel, MS Access, ERWIN, Tableau.