Data Analyst Senior

Priyanka Gandhi

Senior Data Analyst

Contact: 609-***-****

Email: ****@******************.***

PROFESSIONAL SUMMARY

Around 7+ years of experience as a Data Analyst and Data Science Capable in all periods of the Software Development Lifecycle (SDLC).

Expert involvement in Data Modeling and Data Analysis as a Proficient in social event business prerequisites and taking care of necessities the board.

Experience with Statistical Analysis, Data Mining and Machine Learning Skills using SAS, Python and SQL.

Excellent capacity to comprehend business needs and information to create start to finish business arrangements.

Professional working experience in Machine Learning algorithms such as Linear Regression, Logistic Regression, Random Forests, Decision Trees, K-Means Clustering and Association Rules.

Experienced in structuring the Conceptual, Logical and Physical information displaying utilizing Erwin r7.3, Power Designer 12.0 and ER Studio Data displaying instruments.

Good in framework investigation, ER Dimensional Modeling, Database structure and executing RDBMS explicit highlights.

Experiences in Machine learning, data mining, structured and un-structured data analysis, and image data analysis, including feature extraction, pattern recognition, algorithm development, text mining, computer simulation, data modeling, databases design, model evaluation and deployment.

Data Driven and highly analytical with working knowledge and statistical model approaches and methodologies (Clustering, Regression analysis, Hypothesis testing, Decision trees, Machine learning), rules and ever evolving regulatory environment.

Proficient in recognizing Star Schema and Snowflake Schema and ODS design for modeling Information stockroom in Relational, Dimensional and multidimensional model.

Strong Data Modeling background utilizing ER chart, Dimensional information demonstrating, Star Schema demonstrating, Snow-piece displaying utilizing apparatuses like Erwin, Visio.

Well versed in Forward and Reverse Engineering standards.

Experience with different RDBMS like Oracle 9i/10g/11g, SQL Server 2005/2008, DB2 UDB, Teradata.

Extensive involvement being developed of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business rationale execution.

Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards, Storyline on web and desktop platforms.

Develop dashboards and reports that adhere to the visualization best practices and communicate a story

Competent communicator and confident presenter to report analytics findings to members of senior management.

Assisted in requirements definition, project scoping, timeline management, and results documentation to ensure professional relationship management.

Education: Bachelors in Computer Science & Engineering, Rajiv Gandhi Technological University, India

TECHNICAL SKILLS:

Database:

MySQL, Oracle, MariaDB, Heidi SQL

Methodology:

Agile/ SCRUM framework, and Waterfall.

Analytics Technologies and Packages:

Microsoft Excel (Lookup, Pivot, macros), RDBMS, Heidi SQL, Oracle Database, SQL Server, Google Analytics, R & Python

Data Visualization:

Tableau, MS Excel

Healthcare Domain Knowledge:

Open MRS, Postman, HIPAA & HITECH rules, Medicaid and Medicare Payment Models.

Certification:

Project Management Certification Program (SDCE, Pursuing).

Statistical Skills:

Data Analysis, Business Analysis, Agile methodology, Project Management, RP Implementation, Requirement Gathering & Machine Learning, SPSS

Tools:

MS Word, MS PowerPoint, MS Project 2016, MS Visio, MS Excel, Google Analytics, Balsamiq, JIRA

Professional Experience:

Client: CVS Health, Tampa, FL Nov 2021 – Present

Role: Senior Data Analyst

Responsibilities:

Extracted, manipulated and analysed health care and retail data using Teradata from multiple sources to derive and visualize actionable insights for decision making.

Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.

Conducted analysis to measure financial and clinical impacts and outcomes of programs and interventions using descriptive statistics, correlation tests, linear/logistic regression and ANOVA

Built dynamic dashboards using Tableau to track patient adherence and other user-centered metrics.

Created forecasts using ARIMA models to track performance of the Operations team for budget forecasting/variance analysis.

Designed summary data layers by integrating and manipulating data from disparate sources to support planned analyses, using SAS and SQL.

Tailored descriptive analytic solutions to the specific client needs and formulated recommendations to operations team based on findings

Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and took part in identifying different data sources.

Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Use of statistical software such as Excel and R commander Effective Speaking Health Education Health Promotion Data storage.

Generated new data mapping documentations and redefined the proper requirements in detail.

Analyzing Medicare claims, Health facts data and visualize the findings using tableau dashboards and storyboards.

Responsible for checking member eligibility, provider enrollment & member enrollment for the Medicaid and Medicare claims.

Environment: Teradata SQL, SAS, Oracle SQL, T-SQL, Tableau, Python, Jira, Agile, TOAD, SharePoint

Client: LTI-Larsen & Toubro Infotech June 2019 to July 2021

Role: Senior Data Analyst

Responsibilities:

Worked as a Data Modeler/Analyst responsible for Conceptual, Logical and Physical model for Supply Chain Project.

Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.

Extensively used Agile methodology as the Organization Standard to implement the data Models.

Convert all SAS programs for reoccurring reports and analysis to SAS, Python and SQL using various tools like R studio.

Conducted Design reviews with the business analysts and the developers to create a proof of concept for the reports.

Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.

Worked on different data formats such as JSON, XML and performed machine learning algorithms in Python.

Created SSIS package for daily email subscriptions to alert Tableau subscription failure using the PostgreSQL database.

Analysed the data which is using the maximum number of resources and made changes in the back -end code using PL/SQL stored procedures and triggers

Connected to AWS Redshift through Tableau to extract live data for real time analysis.

Performed thorough data analysis for the purpose of overhauling the database using SQL Server.

Used Informatica & SAS to extract transform & load source data from transaction systems.

Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.

Created and maintained data model standards, including master data management (MDM)

Involved in extracting the data from various sources like Oracle, SQL, and Teradata.

Designed the data marts using the Ralph Kimball's Dimensional Data Mart modelling methodology using Erwin.

Identified and documented data sources and transformation rules required to populate and maintain data Warehouse content.

Forward engineering to create tables, views and SQL scripts and mapping documents.

Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.

Performed GAP analysis to analyze the difference between the system capabilities and business requirements.

Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.

Environment: MS Excel, SQL, MS Visio 8, MS PowerPoint, MS Office, R Programming, Python, Pyspark, SQL, PL/SQL, MDM, T-SQL, SSIS, SSRS, Power BI, Tableau

Client: Zensar Technologies, India April 2016 to May 2019

Role: Data Analyst

Responsibilities:

Performed system analysis and understand the deliverables within SDLC using Waterfall methodology.

Develop automated applications surrounding database data extracts and data cleansing routines using SSIS.

Accurately identifying, extracting, and analyzing large volumes of data.

Created reports of analysis to control drug over dosage or drug abuse such as Opioids/Narcotics in the market using R studio.

Created ETL processes utilizing SQL Server Integration Services 2005 for the import, export, and transformation of data from and to Sql server.

Published Power BI Desktop reports created in Report view to the Power BI service.

Provided oversight and or training to clinical staff involved in data collection activities to maintain data quality.

Maintained accurate medical records while ensuring confidentiality with patients' health information.

Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from the database.

Worked with all phases of research such as Data Cleaning, Data Mining, Developing tools, Validation, Visualizations and performance monitoring.

Environment: MS SQL, Teradata SQL, SAS, Oracle SQL, Python, Jira, Agile, Tableau, Power BI, Python

Client: Toshiba, India Dec 2014 to Mar 2016

Role: Data Analyst

Responsibilities:

Worked on requirement gathering and High-level design.

Used Python scripts to update content in the database and manipulate files.

Converted Visual Basic Application to Python and MSQL.

Used HTML/CSS and JavaScript for UI development.

Developed object-oriented programming to enhance company product management.

Utilized Python in the handling of all hits on Django, Redis, and other applications.

Used several Python libraries like wxPython, NumPy and matplotlib.

Was involved in environment code installation as well as the SVN implementation.

Created unit test/regression test framework for working/new code.

Responsible for debugging and troubleshooting the web application.

Build all database mapping classes using Django models.

Environment: Python, SVN, Eclipse, Java Script, XML, Linux, Bugzilla, HTML5/CSS.

Contact this candidate