Madhura P

Phone: +1-469-***-****)

Email: adrprw@r.postjobfree.com

Professional Summary

Over 8+ years of experience in supporting business solution software and analyzing business operations. Expert interpersonal communicator with solid education and experience in data integration, data mining, predictive modeling, Statistical analytics, data visualization with large data sets of structured and unstructured data, and client relationship management to support organizational objectives.

Extensive experience in developing predictive systems and implementing efficient algorithms to improve data quality; identifying, evaluating, designing, and performing statistical analyses of gathered data to create analytic metrics and tools.

Skilled in designing, building, and deploying data analysis systems for large data sets; implementing algorithms to extract information from large data sets; establishing efficient, automated processes for model development, validation,and large-scale data analysis.

Experience in selecting features, building and optimizing regressors/classifiers using machine learning techniques.

Strong problem-solving skills with an emphasis on product development; experience working with and creating data architectures; knowledge of a variety of machine learning techniques and algorithms (Logistic Regression, Clustering, Decision tree learning, support vector machines, K-Nearest Neighbors,etc.) and their real-world advantages/drawbacks.

Strong understanding of Data Science Research Methodologies, statistical concepts, data mining techniques and multivariate data visualizations.

Experience working with Python to automate the operations that are used in data cleaning, data ingestion using Pandas framework. (Numpy, SciPy, Pandas, Matplotlib, Scikit-learn)

Experience working with R packages, libraries and lexicons for sentiment analysis of text data.

Experience of defining key facts and dimensions necessary to support the business requirements along with Data Modeler.

Ability to educe, define, and document business user requirements. Managing, analyzing and translating requirements and objectives into business/technical requirements based on project scope parameters.

Strong experience in Requirements elicitation techniques - conducting user interviews, survey creation and Focus Groups, document analysis, JAD sessions and managing the requirements. Expert in user interface designing and creating wire frames, and expert in using tools like MS Project, MS Visio, draw.io, Balsamiq mockup and photoshop.

Working experience of advanced Microsoft Excel functions, ETL (Extract, Transform and Load) of data into a data mart and Business Intelligence (BI) tools like Microsoft Power BI and Tableau (Data visualization and Analytics).

Hands on experience in writing queries in SQL to extract, transform and load (ETL) data from large data warehouse systems.

Extensive experience in diverse and home-grown methodologies such as Agile System Development Life Cycle process, implementing the Rational Unified Process (RUP) in all different phases of SDLC.

Efficient in MS Project/MS Excel for planning/status reporting/writing test scenarios.

Built strong relationships with clients and demonstrated commitment to delivery

Strong communication, business understanding, critical thinking and analytical skills

Technical Skills

Data Modeling Tools

MS Visio, Lucidcharts, Draw.io

Reqs. Management

Rational RequisitePro, JIRA

Project Management Tools

MS Project, Asana

Analysis/Modeling/Visualization Tools

IBMSPSSStatistics24, Tableau 10.5, RStudio, Jupyter Notebook,PowerBI, NodeXL

Operating Systems

MS Windows NT/98/95/2000, UNIX

Languages

SQL,R, Python

ML

K-Nearest Neighbors, Naïve Bayes, Decision Trees, Regression models, random forests, K-means clustering, Time-series and support vector machines.

Big Data frameworks

Apache Hadoop, Hive and Spark

Database

MySQL 8.0, MS Access

Web services

Amazon EC2

Utility

MS Office Suite, Adobe Photoshop CC 2018, Balsamiq Mockup, Qualtrics Survey

Professional Experience

Client: Verizon, Dallas, TX Jan2022–Till Now Role: Data Analyst

Responsibilities:

Responsible for data and business system analysis of customizing the SAS collaboration product with involvement through the whole SDLC.

Responsible for data and business system analysis of customizing the SAS collaboration product with involvement through the whole SDLC.

Modernize data streamlining processes, resulting in a 25% redundancy reduction

Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security

Acted as liaison between development team,and Business SMEs to gather data for the standardization of Functional requirements documents and Use cases.

Conducted data regression analyses of the relationship between product’s module

Used SPSS to mine, alter, code and retrieve data from a variety of sources and perform statistical analysis on them.

Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts based on client needs for dynamic interactions with the data produced.

Utilized web scraping techniques to extract and organize competitor data.

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Analyzed data points and trend and generated reports for each business region.

Analyzed and tested interfaces for different modules within the product such as applicant tracker, vendor management, project management, IT asset management etc. Created User Interface mockups

Made list of Entity and built the data base Schema.

Designed and implemented basic SQL queries for testing and report/data validation

Researching media coverage and industry trends

Performed sentiment analysis on unstructured text data gathered from social media platforms (Twitter, Consumer reviews from G2 Crowd, TrustRadius, GetApp etc.) using R packages, libraries and lexicons for garnering competitive business intelligence.

Mined huge amount of cases from legacy systems to make prediction and pattern recognition using statistical analysis using regression/classification and clustering techniques in Python.

Clint: Southwest airlines, Dallas, TX Dec2019–oct2021

Role: Data Analyst

Responsibilities:

Responsible for data and business system analysis of customizing the SAS collaboration product with involvement through the whole SDLC.

Applied various machine learning algorithms and statistical modeling like decision trees, regression models, neural networks, SVM, clustering to identify Volume using scikit-learn package in python.

Conducted data regression analyses of the relationship between product’s module prices and industry trends, achieving a 15% more accurate prediction of product pricing.

Utilized web scraping techniques to extract and organize competitor data.

Modernize data streamlining processes, resulting in a 25% redundancy reduction.

Improved data mining processes, resulting in a 20% decrease in time needed to infer insights from customer data used to develop marketing strategies.

Used predictive analytics such as machine learning and data mining techniques to forecast company sales of new product offerings with a 95% accuracy rate.

Used Python and SPSS to build models to identify definite patterns and suggest business with possible problems and feasible solutions. Provided feedback on the quality of data including identification of patterns and outliers.

Mined huge amount of cases from legacy systems to make prediction and pattern recognition using statistical analysis using regression/classification and clustering techniques in Python.

Used pandas, numpy, seaborn, scipy, matplotlib, scikit-learn, NLTK in Python for implementing various machine learning algorithms.

Identified dependent and independent variables in customer survey data to perform regression analysis for examining relationship between them that generates actionable business insights.

Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.

Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts based on client needs for dynamic interactions with the data produced.

Performed sentiment analysis on unstructured text data gathered from social media platforms (Twitter, Consumer reviews from G2 Crowd, TrustRadius, GetApp etc.) using R packages, libraries and lexicons for garnering competitive business intelligence.

Extracted data from various sources like Oracle, XML, Excel and COBOL Flat Files.

Merged, Cleansed and processed collected data using Excel and Pandas framework.

Designed, developed and implemented databases running on MySQL 8.0 database server using ‘phpMyAdmin’ web-based client to assist with applicant tracking, inventory, vendor tracking and various other data control needs.

Designed and implemented basic SQL queries for testing and report/data validation.

Launched, configured and connected to AWS remote instance (Virtual Machine containing Apache Hadoop framework) on Amazon EC2 to map query performance on large datasets using HiveQL and SparkSQL.

Gathered the data and the objective of database as per the business requirement.

Made list of Entity and built the data base Schema.

Identified the different type of keys such as Primary Key, Foreign Key etc. that are useful in building relations between the tables.

Created Entity relationship diagrams using Draw.io, MS Visio, Lucid charts and data dictionary in Excel and MS Word templates.

Created Relationships among tables that might be of different type such as one-one relation, one-many relation, many-one relation, many-many relations.

Normalized the data with certain rules like obtaining first normal form, second normal form, third normal form.

Defined and represented Entities, Attributes, various Keys and Joins between the entities using SQL.

Created design documents like data flow diagrams, process flow charts using MS VISIO and UML.

Used Excel and PowerPoint on various projects as needed for presentations or summarization of data to provide insight on key business decisions.

Extracted, discussed, and refined business requirements from business users and SME’s.

Analyzed and tested interfaces for different modules within the product such as applicant tracker, vendor management, project management, IT asset management etc. Created User Interface mockups.

Acted as liaison between development team, and Business SMEs to gather data for the standardization of Functional requirements documents and Use cases.

Clint: Honeywell, INDIA May2016–Oct2018

Role: Data Analyst

Responsibilities:

Collected, cleansed and providedanalyses of structured and unstructured data for major business initiatives. (R, Python)

Manipulated and processed large data using Excel, Access and SQL.

Responsible for loading, extracting and validation of client data.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Participated in requirements definition, analysis and the design of logical and physical data models.

Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Used Pandas DataFrame for structuring, cleansing and manipulation of data.

Published Tableau Workbooks by creating user filters so that only appropriate teams can view it

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop and created Tree Map, Heat maps and background maps.

Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging various sources.

Conducted workflow, process diagram, and gap analysis to derive requirements for existing systems enhancements. Responsible for developing monthly reports using Tableau.

Conducted key analytics (data sourcing, analysis, testing) required to inform strategic recommendations (e.g., competitor benchmarking, market assessment and financial modeling.

Performed data mining on the client data through various clustering techniques using SPSS with an intention to identify structures within the data or homogeneous groups of data based on variable types.

Analyzed data points and trend and generated reports for each business region.

Segmented this clustered data and built a predictive model for forecasting region’s performance and potential markets for revenue generation and investment.

Developed visualizations of the forecasted trend for profiling of data through R and Tableau.

Used SPSS to mine, alter, code and retrieve data from a variety of sources and perform statistical analysis on them.

Coordinatedwith customers, support, sales and development teams, resolved issues.

Organized and facilitated sprint planning, daily stand-up meetings, Sprint review, Sprint retrospectives, and other Scrum-related meetings. Ensured high quality data collection maintaining the integrity of the data.

Clint: GE Capital Services India Limited Oct 2015-Mar2016

Role: Data Analyst

Responsibilities:

Experienced in developing ELT for supporting Extraction, Loading and Transformation using ODI 11g/12c.

Performed root cause analysis on ETL packages to identify data integrity and pipeline flows.

Created Master and Work Repositories for Productive/Non-Productive environment.

Set up the Topology including physical architecture, logical architecture and context. Optimizing performance tuning at source, target, mapping and session level.

Created new models for the data sources - flat files, Oracle. Used data table properties, property controls, filters, joins and custom functions.

Participated in weekly status meetings and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Created new database objects like Stored Procedures, Functions, Triggers, Indexes and Views in Development and Production environment for SQL Server.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Prepared daily and weekly status reports and collaborated with other team members.

Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, triggers and maintained referential integrity.

Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

Responsible for Cleansing up database for Maintenance of the database.

Developed new mappings using transformations like Look Up, Aggregation, Derived Column, Data Conversion etc. transformations in SSIS to match the needs of the business case.

Clint: Indus Infotech, India May 2012 – Sep 2015

Role: Software Engineer

Responsibilities:

Involved in test processes, methodologies and follow standards best practices for testing purpose.

Reviewed the functional, use cases and user interface specifications for the different modules in the Consult-IV application.

Involved in writing test requirements, test plans and test scenarios.

Performed testing on applications manually and automated with Test Complete & QTP

Performed manual and automated testing and maintain test results for GUI, regression, integration and system testing.

Involved in Developing an end to end application by using the Spring framework like Spring Boot

Developed testing frameworks using java

Performed System, Integration, Smoke and Sanity testing using testing methodologies.

Proficient in Testing Composite, Entity services, Service calling service using CRUD

Communicated inconsistencies between system specifications and test results to development and analyst team.

Involved in testing of different interfaces in the application.

Contact this candidate