DEEKSHANA MANAGANI, MS

Ph: 551-***-**** E: adb3pf@r.postjobfree.com Albany, NY www.linkedin.com/in/deekshana-krishna

SUMMARY

Highly committed, self-motivated researcher and analyst with 7 years of experience in data analysis, statistics, database design, and computer programming.

Expertise in creating visualization with Tableau desktop, Tableau Server and Tableau Reader in various version of Tableau 2018.3, 10.5, 9.x and 8.x

Experience with SQL Server Management Studio (SSMS) Software Development Life Cycles (SDLC) and Business Intelligence concepts.

A passion for integrating data-driven tools and methods to develop innovative solutions for public health practice and organizational systems optimization.

Experience in data mapping, writing functional specifications, design, development, implementation, testing, quality adherence, documentation, troubleshooting and customer support.

Good understanding of Software development life cycle (SDLC) and QA Processes including requirements analysis, Testing, Defect Tracking, Test Results and Metrics Reporting.

Ability to partner with cross-functional teams to develop and execute projects plans to deliver high impact results.

Experienced in Business Blueprint, Configuration, Unit and Integration Testing, Training, Documentation and Production Support.

Keen ability to analyze and understand problems, developed action plans, and successfully completed the tasks within operating and financial guidelines.

Demonstrated ability to work both in independent and team-oriented environment.

Proven ability to communicate solution strategy and product offerings with demonstrated aptitude to analyze and translate complex business problems, design and implement innovative solutions.

Organized and detail oriented to handle complex and dynamic business environment. An effective communicator and multitasker with expertise in identifying & adopting emerging trends to achieve organizational objectives and profitability norms.

Sound competency in data visualization and reports and storytelling by dashboards design and development

Create mappings to match data to a source system and confirm correctness of data

Experienced in using database management tools, maintaining data integration and developing reporting systems.

SKILLS

Analytical and Visualization Tools R, Tableau, SAS, JMP, MS Excel, Google Analytics

Database Tools Oracle 12C, MS Access, SSRS, SSIS MS-SQL Server Database

Programming Languages VBA, HTML, ColdFusion Markup Language, PL/SQL

Information and Data Management Database management, system analysis, data analytics

Operating Systems/Computer: Windows, MS-Office- Word, Excel, PowerPoint, Outlook

PROFESSIONAL EXPERIENCE

New York State Department of Health (Albany, NY) 04/2018 to Present

Data Analyst IV/BI Analyst, Bureau of Water Supply Protection

Used R to conduct a series of nonparametric statistical tests on a sample of 50 healthcare facility water management plans. Analyzed score changes resulting from feedback provided by NYSDOH subject matter experts. Preparing presentations and publications on the benefits of feedback and templates for improving water management plans and practices in preventing waterborne infections.

Predictive Model:

Conducted in-house predictive analytics projects. The goal was to find the top characteristics (variables) of cases. Worked in the complete life cycle, right from gathering requirements, preparing dataset from various data. Sources (Rx, Dx Claims, Physician attributes, demographics), feature engineering, running various models and presentation. Created and delivered a presentation.

Experience in implementing data analytics techniques using R to analyze data - Data collection, Data pre-processing, Data Quality, Classification, Clustering and Predictive Modeling.

Analyzed facilities and cooling tower data to find the association between weather and legionellosis incidence in two New York State counties by using Tableau, Mesonet weather data and R.

Conducted data cleaning, univariate and regression analyses in SAS and R on a set of 225 completed surveys of private well users. Findings on the correlation between flood awareness and well preparedness are being prepared for publication and applied to outreach and education materials for vulnerable populations.

Collaborated on an inter-agency evaluation of the NYS Water Quality Data Analytics program to assess the prototype’s usefulness and applicability within NYSDEC and NYSDOH. Used R to analyze the geospatial distribution of annual harmful algal bloom notifications and to perform statistical regressions. Performed a series of what-if examinations in Radiant. Evaluated the code efficiency of the Shiny app syntax.

Ad-hoc Requests

Analyzed Diagnosis, Rx, Procedure claims data in R, SQL. Performed exploratory data analysis and statistical modeling techniques such as regression, decision trees, correlation analysis, ANOVA, clustering techniques.

Performed source system data analysis, data profiling, data cleansing and data validation to confirm data design solution meets business requirements.

Developed dashboards and report automation process using VBA and MS Excel to improve turnaround time and reporting capabilities.

Defined KPI’s and developed various dashboards in Tableau

Reviewed design solutions, data models, primary keys, business keys and indexes from ETL and reporting team perspective and ease of use.

Developed source to target mapping document, data flow diagram for ETL development

Lead developer in creating a novel MS Access Environmental assessment database for outbreak investigation and field staff. The tools succeeded in streamlining data entry workflows and ensuring data accuracy and integrity for future analysis

Created solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions

Published various kinds of live, interactive visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Expertise in technical requirements gathering, data extraction, programming (SAS, R, SQL, Advanced Excel/Access) and building powerful visualizations/dashboards using Tableau and Excel. Support testing, training, documentation and quality assurance of delivered reports and datasets, contributing towards agile project execution.

Ability to interpret data into layman's terms for technical or non-technical stakeholders

Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.

Manage the development of statewide tools related to 10 NYCRR Part 4, Protection Against Legionella, including the migration of the electronic cooling tower registry to a new software system and the design of an electronic reporting tool for healthcare facility environmental assessments and water management plans. Prepared system requirements specifications and interface design inputs. Coordinate with a diverse group of inter-agency stakeholders, including software developers, healthcare associations, and regulatory experts.

Provide technical assistance and mentoring to program staff, external partners and graduate students on various aspects of study design, data analysis, database design, and program evaluation.

Tools Used: SAS, R, MS Access, MS Excel, Tableau, HCS, SQL, HERDS, GitLab, CKAN, OpenRefine

State of New Jersey (Trenton, NJ) 09/2017 to 12/2017

Data Analyst/BI Analyst, New Jersey Department of Children and Families

Analyzed allegations of in-home child abuse cases across New Jersey using a dataset of 1200 case records. Used R, SQL, and Tableau to create analytical dashboards and compelling, easy to follow data visualizations for department reporting of the imminent risk to vulnerable children.

Performed data cleaning (including imputation techniques), and a range of exploratory analyses to identify trends and patterns in abuse type and frequency, and abuser and victim characteristics. Findings that abuser age, step-parent relationship, and child age are important risk factors for child abuse/violence were used to inform state legislation and child welfare agency policies to help further reduce child abuse incidence.

Developed and optimized the child abuse quarterly reporting processes by creating a VBA desktop application

Identify, analyze source data to understand business keys and relationships to datasets.

Perform data analysis, data interrogation, validation and define data pruning rules.

Discover data trends, interpret data patterns and develop data transformation rules

Developed logical and Physical Data Models, writing SQL code to access and manipulate data stored in relational databases.

Interpreting, analyzing and transform the requirements gathered from product owners, stakeholders for different reports.

Building, publishing customized interactive reports and dashboards, report scheduling using Excel using Pivot charts and Pivot tables.

Tools Used: R, SQL, Tableau, MS Excel

Star Hill Pharmacy (Bronx, NY) 05/2017 to 09/2017

Data Analyst, Reporting Department

Using R, analyzed medical claims data from 8000 patient records and developed decision tree/random forest algorithms to segment data into returning and non-returning patients, identify the most significant patient attributes, and predict churn patterns. Validated the model’s predictive accuracy in terms of sensitivity and specificity.

Performed exploratory data analysis to improve clinical decision-making based on frequency/recency of purchases and defined key performance indicators. Prepared dashboards in Tableau, incorporating pivot tables and other tools for easy end-user information manipulation of patient data. Results were used to develop outreach campaigns targeting patients at risk for low medication adherence

Proficient in reporting and data visualization tool like Tableau to present analysis.

Identify trends and patterns in complex data to derive insights in helping organizations make data-driven decisions.

Tools Used: Tableau, SQL, R, MS Excel

NTT Data (Hyderabad, India) 06/2012 to 08/2016

BI Analyst, National Life Group Insurance

Collaborated in the work estimation process and planned incremental releases of insurance products, such as indexed universal life insurance, which allow customers to take advantage of changes in the market index without the risk of stock market losses. Designed studies and engaged in program development and support of mission-critical business applications using formal software engineering and project management methodologies. Proposed an end-end conceptual architecture based on collected user stories and non-functional requirements.

Developed and modified SQL procedures to solve complex database design problems of millions of records of insurance holder’s demographic information, insurance types, retirement plans, etc. to ensure efficient data storage and accurate delivery.

Participated in the full project lifecycle (SDLC) and coordinated with all project teams. Provided post-implementation production support, conducted user acceptance testing and updated defect monitoring tools. Performed root-cause analysis of issues to provide estimates for requirements.

Created web pages for Illustration project using ColdFusion, HTML and SQL.

Extracted data from CSV, Text files in the Data preparation stage (ETL).

Created conceptual, logical and physical data models defining information requirements for management and business intelligence purposes

Analyzed existing complex systems to understand and document data elements, data flow, relationships, dependencies and related interfaces.

Competencies: Business Analytics, Database management, System Analysis, Data Analytics, Software Design, Implementation, Business Intelligence and, Technology domain.

Tools Used: SQL, ColdFusion, MS Access, MS Excel, ColdFusion, HTML, PVCS, Oracle 12C, SSIS

EDUCATION

MS Business Intelligence and Analytics, Saint Joseph’s University, Philadelphia, PA. GPA-3.8 12/2017

B Tech Electronics and Communication Engineering, CMR University - Telangana, India. GPA-3.55 05/2012

ACHIEVEMENTS AND AWARDS

Alpha Iota Delta Highest academic honour for the Decision Sciences & Information Systems

Outstanding Performance Award NTT Data

SAS Business Intelligence Certificate

NYSDOH Commissioner’s Recognition Award, Public Health Impact: Legionella

Contact this candidate