SUMMARY

• 7+ years of professional knowledge in Business Process Reengineering in Healthcare and Banking Sector with prime focus on claims adjudication, masking confidential and sensitive customer information, migration, provider, eligibility and prior authorization for Medicaid and Medicare programs and involving in various phases of Software development, Data Analysis, Business analysis, Design, Testing, Production Support, Implementation of SFDC and Debugging Testing and Implementation of software applications as a Data Analyst.
• Outstanding preeminence in Data extraction, Data cleaning, Data loading, Statistical data analysis, Exploratory data analysis, Data wrangling, Predictive modeling using R, Python and visualization using Tableau and R plots.
• Documented Non - functional requirement documents, Business Requirement Document BRD and Functional Requirement Document FRD.
• Comprehensive experience in different SDLC methodologies: Waterfall, Agile and Rational Unified Process.
• Interacted with the Stakeholders, End Users to understand and gather stakeholder requirements and create the Business Requirements Document BRD and Functional Requirement Document FRD and communicating it to the entire team involved
• Expertise in performing GAP analysis and Impact analysis driving internal and external requirements.
• Test case writing manual/automated and conducting different tests Integration and regression testing, UAT User Acceptance Testing.
• Knowledge of Analysis Design Use Case, Sequence and Activity diagrams using Unified Modeling Language.
• Writing Manuals System guides, training material for business users and Deployment guides.
• Good knowledge in Python, R, RDBMS, Oracle, SQL along with MS SQL administration, SQL Enterprise Manager, Data analysis and reporting using Tableau.
• Experienced in converting Business and Data requirements into Functional, Business and technical specification. Formulating Design Plans, ER Diagrams, Data Flow Diagrams and Designing Databases based on the User Requirement Documents.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail etc.
• Good experience as a liaison between the business staff and information systems staff. Worked on Functional analysis/Requirements mapping by understanding the business process.
• Extensive knowledge and experience with network architecture and with Microsoft and Oracle database platform.
• Understand business requirements and define the technical capabilities necessary to support and satisfy business needs. Knowledge in data warehouse and data modeling.
• In-depth theoretical understanding and practical expertise with regards to structured system development methodologies. Years of business analysis experience and hands-on data profiling, data modeling expertise for relational databases - both for logical and physical data models - including detailed knowledge of normalization techniques.
• Experience in Oracle database development and SQL/PL SQL DML statements (select, insert, update, delete).
• Complex queries, DTS packages, SSRS, Stored Procedures, Triggers, SQL * Loader.
• Excellent communication skills, good interpersonal skills, self-motivated, quick-learner and a team player.

TECHNICAL SKILLS

Programming Languages: Python, R, SQL, MySQL, PLSQL, PostgreSQL

Software: Tableau, Data bricks, AWS S3, Snowflake, SAS, Excel, Microsoft SQL server

Methodologies: Waterfall Methodology, Agile Methodology, RUP Rational Unified Process

Certifications: SAS Certified Programmer

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential - Richmond, VA

Responsibilities:

• Automate weekly output emails across teams while running the reports using Data bricks interacting with multiple input files like Onelake, Snowflake and flat files from local machines.
• Committed to understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions.
• Experienced working on data with billions of records, coming from disparate source engines, namely - AWS S3, Onelake, and Snowflake.
• Efficient analysis that provides meaningful insights on business strategies.
• Engaged in identifying the fields in legacy Tera data databases and crosswalk mapped fields which are migrated into cloud, stored in onelake-S3.
• Masking the customer's personal information like credit card and other private demographics while transferring the data in Nebula to respective Onelake and Snowflake tables.
• Used Open Source/Digital technologies to mine complex, voluminous, and different varieties of data sources and platforms.
• Compiled ETL and report testing using Data warehouse tool Data bricks and Dashboards in Quicksight.

Data Analyst

Confidential - Winston-Salem, NC

Responsibilities:

• Analyze data using Microsoft Office and Excel, Structured Query Language (SQL) and Python alongside data visualization and data manipulation techniques.
• Collect, Analyze, and evaluate various types of data to make recommendations, while following the established processes and procedures to analyze data.
• Review the raw requirements to understand the key outcomes expected by the client.
• Converting the business requirement into data mapping document from source to target data.
• Review logic that needs to be incorporated in the architecture to ensure the data meets the requirements.
• Analyze and validate data to identify the known and unknown data relationships and patterns.
• Provide subject - matter expertise in the management of risk associated with data management activities including data quality.

Data Analyst

Confidential - Foster City, CA

Responsibilities:

• Develop Python and SQL query to generate reports increasing the Data quality by analyzing Gilead s Clinical and Pharmaceutical data.
• Collect multi - sourced data, query, standardize, and cleanse structured, and unstructured data used and Leverage Tableau Desktop to perform data analysis to identify and deliver actionable insights to relevant decision-makers increasing the data accuracy by following internal guidelines.
• Cleanse, manipulate, and visualize data using Python, SQL, Microsoft Excel, and Tableau.
• Collaborated with stakeholders and architects while designing and developing the ER diagrams of the business data using data modeling tools like Erwin.
• Analyzed sales data with standard statistical methods to explain the reasons for declining or increasing using Python queries and pivot tables and v-lookup with Excel by comparing total sales.

Data Analyst

Confidential - Baton Rouge, LA

Responsibilities:

• Teamed up with Data architects as a part of our all - hands meet to create the Data models using Erwin.
• Analyzed millions of rows of end-users data and predict models to increase the company's revenue by studying customer demographics and call patterns. Cleanse, manipulate, and visualize data using R, Python, SAS, and Tableau.
• Developed algorithms to predict customer churn probability, created models using Visio, and analyzed feature importance to prioritize top factors that influenced the results based on labeled data with SAS.
• Performed descriptive and exploratory in-depth statistical and inferential data mining techniques using R to recommend actions to solve customer retention problems.
• Designed Tableau reports denoting statistically significant differences between quarters at 90% confidence level highlighting the performance satisfaction and % likelihood to switch carriers for the top 4 mobile network providers on 105 sub-national markets in the US and also dashboard to track KPIs.

Data Analyst

Confidential - Baton Rouge, LA

Responsibilities:

• Developed a calculative statistical regression model to improve the efficiency of the product s life cycle to assess manufacturing and inventory requirements.
• Analyze success patterns to find a product with a decent life cycle and can generate good revenue for the company using SAS for data aggregation, R and Python for Data wrangling, cleansing, and R(ggplot2) for visualizations.
• Exploratory data analysis and evaluation of KPIs to conduct data analysis, create best - practice reports, and find business insights using regression techniques R which increased sales by 15%.
• Implemented SAS programs to perform data pre-processing techniques like imputation of missing values, identifying, and removing outliers, handling categorical data, splitting the dataset into training and testing datasets, and feature scaling.
• Triggered a 10% increase in profit by designing 200+ business reports on over 150 product categories and by identifying key factors and profitable products using Tableau (Bar charts, Line charts, Geographical map, Trend forecast plots).
• Engendered a 20% improvement in inventory holding levels for various products as part of Inventory Replenishment analysis by statistical modeling through Logistic Regression using SAS.
• Performed flat-file data extraction and validation using R and Python for sales and finance data to generate insights to stakeholders.

Research Analyst

Confidential, Baton Rouge, LA

Responsibilities:

• Create, modify, and analyze international students' geo - spatial data maps alongside documentation and online ArcGIS presentations.
• Analyze errors in the vicinity of international student housing to identify risk patterns using Python, SAS, and Excel.
• Analyzed process changes and provided recommendations for improvements by exceptional analytical skills and statistics knowledge.
• As a part of process improvement, I studied overall data flow and identified internal data entry flaws such as duplication and data degradation to improve data quality.

Data Analyst

Confidential

Responsibilities:

• Data acquisition, preparation, analysis, and visualization activities to develop new data visualizations, dashboards, and other analytical tools to understand their data and make better business decisions.
• Design data visualizations using Tableau.
• Create complex SQL queries and perform ad - hoc and exploratory data analysis.
• Investigate data anomalies and perform Root Cause Analysis (RCA)
• Work with business units using Exploratory Data Analysis (EDA) to establish KPIs and methodology, and then create the appropriate reports and analysis.

Data Analyst

Confidential

Responsibilities:

• End to end schema generation for Confidential, a UK based electricity and gas company using MySQL, and Hive to aggregate data and generate visualization reports using Tableau for client s use.
• Consolidate and analyze data to create a monthly report using Microsoft Excel.
• Predicted KPIs like average profit margin for product lines and product categories which helps in budget planning.
• Developed dynamic and interactive dashboards in Tableau to provide tracking of key financial performance indicators.