SUMMARY

• Highly analytical and process - oriented data analyst with 7 years of experience in data analysis and data management has proven ability to work efficiently in both independent and teamwork environments.
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• An excellent understanding of both traditional statistical modeling and Machine Learning techniques and algorithms like Regression, clustering, ensembling (random forest, gradient boosting), deep learning (neural networks), etc.
• Expertise and Vast knowledge of Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT), and Business Intelligence.
• Experience in Documentation tools like MS Visio, MS Project, and MS Office to create reports required for the projects and client submissions.
• Expert in python libraries such as NumPy, SciPy for mathematical calculations, Pandas for data pre-processing/wrangling, Mat plot, Seaborn for data visualization, Sklearn for machine learning, Theano, Tensor Flow, Keras for Deep learning, and NLTK for NLP.
• Proficient in writing queries and sub queries to retrieve the data using SQL from various servers including Microsoft SQL, Oracle, and MySQL.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
• Experience in Normalization and De-Normalization techniques for OLTP and OLAP systems in creating Database Objects like Tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Experience in statistical parametric analysis methods such as Correlation, Regression, Analysis of Variance, and General Linear Models
• Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine and analyze financial data.
• Published the workbooks and data sources to the tableau server for further review as well enable users to do slicing and dicing on the data to derive more insights. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets. Executed and tested required queries and reports before publishing.
• Responsibilities include experience with python production quality scripting, data wrangling, data visualization, and showcasing results to the business strategy team.
• Experienced in handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Expertise in using Linear& Logistic Regression and Classification Modeling, Decision-trees, Principal Component Analysis (PCA), Cluster and Segmentation analyses, and have authored and co-authored several scholarly articles applying these techniques.

TECHNICAL SKILLS

ETL Tools / Tracking tool: SSIS, SSAS, SSRS / JIRA

Database Development: T-SQL and PL/SQL, Oracle 12c, MySQL, SQL Server

Visualization: Power BI, Tableau

Tools: Anaconda, PyCharm, GitHub, Foursquare API, Power BI

Machine Learning: Classification, Regression, Decision Trees, Random Forest, SVM, k-nearest Neighborhood, k-means Clustering, Hierarchical Clustering, Logistic Regression, Tensor Flow, Keras.

Programming Skills: Python, R, R-Studio, SAS E-miner.

BI & Reporting Tools: Business Objects, SSRS, Tableau, Tableau Server, Power BI, QlikView.

Known Concepts/ Technologies: phpMyAdmin, Grafana, Kibana, JMP-SAS, GitHub, Word Press, Aperture, Google Analytics, Slack, SAP (SD), Google Ad Words, Google Tag Manager, MS Visio, MS Visual Studio, Microsoft Office, MS Excel, Salesforce CRM, MS Office, SharePoint.

Databases: Teradata, MS SQL Server

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Memphis, TN

Responsibilities:

• Created Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using Erwin.
• Assist team in developing quantitative analysis of budgets, sales performance, revenues, and margins and in support of sales or solutions strategies that can create value for Confidential .
• Analyzed customer data to predict future sales and renewed 87 existing contracts.
• Perform ad hoc analysis for management supporting $653,286,520 business in Confidential to drive key business decisions.
• Illustrated YoY trends using Power BI to customers to pitch in more business growth.
• Identified a potential risk of a customer being charged more than the actual agreement and managed error variance less than 1%.
• Collaborated with pricing team to implement GRI program on 121 Private Equities under Confidential pricing system.
• Proactively took lead on rectifying incorrect discounts generated by a tool for a pricing group which could have led to customers rated at lesser price.
• Pulled data using SAP Business Objects and SQL for multiple ad hoc requests.
• Elaborate understanding of contractual terms in software agreements and comfortable reading legal contract language.
• Assisted to create an algorithm to detect anomaly/outlier detection on abnormal events for the month-to-month sales of medical devices to distributors.
• Connect the MySQL dataset into R and Python, create a business dashboard to present the initial analysis using RShiny. Used Hadoop, Hive, Pig, and Spark to manage data processing and storage for big data applications running in the clustered system.
• Clean data and process third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy, SciPy, and Matplotlib.
• Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.
• Updated/Managed data and queries using PLSQL and retrieve data related to equipment's performance and quality reports.
• Worked extensively on trials to analyze the sales data production for predictive models using Machine Learning techniques like KNN and distance algorithms.
• Worked with Database Administrators, Business Analysts, and Content Developers to conduct design reviews and validate the developed models.
• Performed data analysis and data profiling using complex SQL on various source systems and answered complex business questions by providing data to business users.
• Generated ad-hoc SQL Queries using joins, database connections, and transformation rules to fetch data from legacyDB2 and SQL Server database systems.
• Developed Data Mapping, Data Governance, Transformation, and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS, and OLAP.
• Use NumPy and Pandas on Python to find the missing values and duplicate values on the datasets, use Sea born for data visualization and EDA (exploratory data analysis).
• Also, compute the EDA process on R with a smart EDA package, integrate the outcomes into the dashboard created before.
• Integrate the EDA outcome of R and Python into Power BI and R connection, build a business report on Tableau for data visualization.
• Gathered requirements from internal stakeholders to define and develop accurate KPIs around user acquisition and user engagement.
• Created daily/ weekly/ monthly reports in Power BI that interpret the campaign’s success and user trends.
• Worked with development teams to address critical data quality issues, build database architecture, and propose changes in data management infrastructure
• Gathered business requirements, working closely with business users, project leaders, and developers. Analyzed the business requirements and designed Conceptual and Logical Data Models.
• Implemented Normalization Techniques and build the tables as per the requirements are given by the business users.
• Extensively worked on early-stage business projects, discovery efforts, and engagements initiated by Business Relationship Managers to provide appropriate architecture deliverables, such as stakeholder analyses, capability analyses, risk/value analyses, or technical analyses.
• Worked with Database Administrators, Business Analysts, and Content Developers to conduct design reviews and validate the developed models.
• Performed data analysis and data profiling using complex SQL on various source systems and answered complex business questions by providing data to business users.

Data Analyst

Confidential, Wilmington, Delaware

Responsibilities:

• Responsible for checking the daily inbound, outbound data activities, and updating appropriate EMR data in the back end of the production server.
• Developed business process models in Waterfall to document existing and future business processes.
• Imported the claims data into Python using Pandas libraries and performed various data analyses.
• Programmed a utility in Python that used multiple packages like NumPy, and pandas.
• Perform troubleshooting, fixed, and deployed many Python bug fixes of the two main applications that were the main source of data for both customers and the internal customer service team.
• Responsible to design, develop, and test the software to maintain the data marts (Load data, analyzed using OLAP tools).
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Worked in importing and cleansing of data from various sources like Teradata, SQL Server with high volume data.
• Assess and implement advanced web analytics tracking, monitor KPI's using Google analytics, create Google analytics reports and dashboards
• Involved in creating database objects such as tables, views, procedures, triggers, functions using PL/SQL to provide definition, structure, and maintain data efficiently.
• Supported and worked closely with the Data Engineering team using Azure Data Factory creating pipelines and following ETL processes during migration to the cloud
• Extensively worked on the MS SQL server to retrieve, validate, and generate clinical data using SQL queries.
• Worked with senior programmers and QA personnel in performing unit and user acceptance tests to ensure best performance and compatibility of MS Access database or applications on various platforms as well as providing regular system updates as required
• Arranged various guiding sessions for Programmers, Engineers, System Analysts, and others for clarification of performance requirements, interfaces project capabilities and limitations.
• Created conceptual, logical, and physical data models, data dictionaries, DDL, and DML to deploy and load database table structures in support of system requirements.
• Developed and maintained the data dictionaries, Naming Conventions, Standards, and Class Words Standards Document.
• Reviewed different codes and designs to ensure no ERRORS in the systems and to recommend the required update if needed.
• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.
• Utilize SQL, Excel, and several Marketing/Web Analytics tools (Google Analytics, Bing Ads, Ad Words, Ad Sense, Criteo, Smartly, Survey Monkey, and Mailchimp) to complete business & marketing analysis and assessment.
• Updated Python scripts to match training data with our database stored in AWS Cloud Search, so that we would be able to assign each document a response label for further classification.

Data Analyst

Confidential, New Haven, CT

Responsibilities:

• Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
• Utilized SAS and SQL to extract data from state-wide databases for analysis.
• Acquired data from primary or secondary data sources and maintain databases/data systems.
• Performed Data Analysis using visualization tools such as Tableau, Spotfire, and SharePoint to provide insights into the data.
• Configured Azure platform offerings for web applications, business intelligence using Power BI, Azure Data Factory, etc.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Assisted in mining data from the SQL database that was used in several significant presentations.
• Involved in SSIS packages to extract data from different sources like SQL Server, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon the requirement,
• The published Data model in the model mart created Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design, and implementing RDBMS-specific features.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Manage and complete ad-hoc requests for data reports.
• Worked with Data Analysis Tools (SAS Enterprise Miner, SAS Enterprise Guide, Tableau 9 and above) to analyze and visualize data to solve data Analysis Problems.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and developed ad-hoc reports using SAS Enterprise Guide.

Application Developer Analyst

Confidential

Responsibilities:

• Created the Technical Specification document for the reports developed as part of the project life cycle and Followed the SDLC using Waterfall.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Programmed a utility in Python and R that used multiple packages (ggplot2, NumPy, Pandas, Matplotlib, and SciPy).
• Involved in extracting, transforming, and loading data from sources into QlikView/Qlik Sense applications
• Worked on the deployment of Qlik sense/QlikView dashboards from Dev to UAT and UAT to PROD
• Developed Dashboards using different QlikView Objects Line Chart, Bar Chart, Gauge Chart, Pie Chart, List box, Multi-box, Table Box, Container, etc.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Teradata that can be used for the development of various Tableau reports/ dashboards.
• Generated MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers, and Indexes.
• Developed complex reporting tools in MS Access which compiled data into a single location.