Data analyst

BINDI

Data Analyst

Contact: 469-***-****

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 R, 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

Creative in putting together projections for a variety of scenarios to assist departmental experts in making future decisions regarding the organization’s growth.

Education Details: Master’s Long Island University Brooklyn, New York City, New York

Bachelors of Science, Dharmsinh Desai University, Gujarat, India

TECHNICAL SKILLS:

Database: MySQL, Oracle, MariaDB, HeidiSQL

Methodology: Agile/ SCRUM framework, and Waterfall.

Analytics Technologies and Packages: Microsoft Excel (Lookup, Pivot, macros), RDBMS, HeidiSQL, 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: Syneos Health, NEW JERSEY Jan 2021 – Present

Role: Data Analyst

Description: Syneos Health is the only company in the biopharmaceutical services industry purpose-built to create greater success for our customers. At Syneos Health, clinical and commercial live under the same roof and constantly share real world knowledge and insights that lead to getting the job done better, smarter and faster. We call this new way of collaborative working the Biopharmaceutical Acceleration Model or BAM.

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.

Participate in an Agile ceremonies, conducting backlog grooming sessions for story estimates and iteration reviews.

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

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

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

Assist team members with in planning, designing and performing data and pattern analysis of specific health care activities and projects.

Working with HIPAA Team implementation of ANS Companion guides for Pharmacy and Dental claims.

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, Teradata SQL, SAS, Oracle SQL, T-SQL, Tableau, Power BI, Python, Jira, Agile, TOAD, SharePoint

Client: Dignity Health Aug 2019 to Dec 2020

Role: Data Analyst

Description: Dignity Health is making health care more accessible by bringing resources closer to where people live and work. In urban and rural communities alike, residents of all ages and backgrounds have access to primary care, preventive treatment, clinical support, chronic disease management, trauma services, and a host of medical and therapeutic specializations. With several different ways to activate your search, let us help you to quickly and easily find an affordable, quality medical facility located close to where you need it, when you need it.

Responsibilities:

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

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.

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

Performing the role of Tableau site admin for 3 of our sites.

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

Client: Lambda Technologies Jan 2016 to Dec 2017

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.

Used various packages in R and Python such as ggplot2, NumPy, Pandas, Matplotlib and SciPy.

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: Indus Infotech, India Jun 2013 to Dec 2015

Role: Data Analyst

Description: Indus Infotech have strong domain experience across several diverse verticals including FMCG, Retail, E-commerce, Pharma and Life Sciences, Insurance, Banking and Financial Services, Manufacturing, Aerospace, and Automobile.

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