SUMMARY

• Having 6+ years of experience as a Data Analyst with solid understanding of Data Acquisition, Storage, Machine Learning, Predictive Analysis, Statistical Analysis, Business Intelligence, Data Visualization, and Interactive Dashboards.

TECHNICAL SKILLS

Languages: Python 3.x, R, SQL, T - SQL, UNIX Shell Scripting

Data base: MS SQL Server 2005/2008/2012, MS Access

Methodologies: Agile, Scrum and Waterfall

Libraries: Scikit-Learns, Keras, Tensor flow, NumPy, Pandas, Matplotlib, Seaborn

Statistical Methods: Hypothetical Testing, ANOVA, Time Series, Confidence Intervals, Bayes Law, Principal Component Analysis (PCA), Dimensionality Reduction, Cross-Validation

Machine Learning: Regression analysis, Bayesian Method, Decision Tree, Random Forests, Support Vector Machine, Neural Network, K-Means Clustering, KNN and Ensemble Method, Natural Language Processing

Reporting Tools: Tableau 10.x, 9.x, 8.x which includes Desktop, Server and Online, Microsoft Power BI.

Data Visualization: Tableau, Matplotlib, Sea-born, Microsoft Power BI

Machine Learning: Regression, clustering, SVM, Decision trees, Classification, Recommendation systems etc.

Big data Framework: Amazon EC2, S3 and EMR

ETL/Data Warehouse Tools: Web Intelligence, Talend, Informatica, Tableau, Data Modeling Star-Schema Modeling, Snowflake-Schema Modeling, and FACT and dimension tables, Pivot Tables

PROFESSIONAL EXPERIENCE

Confidential, Bolingbrook, IL

Sr. Data Analyst

Responsibilities:

• Utilizing advanced statistical methodologies and machine learning models like linear, multiple & logistic regression, decision trees, Bayesian inference to solve complex business problems.
• Performed Data profiling, preliminary data analysis and handle anomalies such as missing, duplicates, outliers, and imputed irrelevant data.
• Work extensively with advanced analytical action utilizing various filters, sets, groups, LOD, parameters, hierarchy, calculated fields, table calculations on Tableau reports and workbooks
• Strong hands on experience with creating dashboards, data visualizations and analytics using Tableau Desktop
• Handling large sets of data using Python and Tableau.
• Analyzing large data sets and conducting regression analysis and understanding Gaussian distribution
• Methodically writing complex queries for joining, filtering and analyzing data using SQL Server 2014
• Create data stories and visualizations using Tableau and Power BI.
• Automate different workflows, which are initiated manually with Python scripts and Unix Shell Scripting.
• Integrated data from various Data sources like Oracle, MSSQL Server, IBMDB2, Teradata using Informatica to perform Extraction, Transformation, loading (ETL processes)
• Prepared data quality criteria and governance for Data Warehousing Application.
• Loaded Flat File Data into Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Successfully completed the Proof of Concept in a Data Analyst role using Alteryx a Data analysis, BI software with SQL Server.
• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Humana Enterprise data warehouse EDW.
• , ELB, security groups
• Creating a high availability and scalable AWS stacks using EC2 auto scaling functionality
• Worked on Cloud automation using AWS Cloud Formation templates

Environment: Tableau Desktop 10.x,9.x, SQL Server 2014, Python 3.x, power BI, R, SSAS, AWS, ETL, Oracle, Alteryx, Informatica, Teradata, MS Excel, Origin, Agile Scrum

Confidential, New York

Sr. Data Analyst

Responsibilities:

• Design and develop analytics, machine learning models, and visualizations that drive performance and provide insights, from prototyping to production deployment and product recommendation and allocation planning.
• Perform independent analysis on complex data sets using JMP, MS Excel, and Tableau
• Worked on upgrading Tableau Dashboards to newer version 10.3 to take advantage of new features as well as other improvements and enhancements
• Worked on predictive analytics use - cases using Python language.
• Generating various capacity-planning reports (graphical) using Python packages like Numpy, matplotlib.
• Integrating individual data marts into Enterprise level Data Warehouse using conformed Dimensions and Conformed Facts.
• Develops, maintains, and supports complex enterprise data warehouse systems and corresponding data marts.
• Creating data base objects like tables, temp tables, views, stored procedures, functions, indexes, triggers, PIVOT in SQL Server 2008, 2012
• Developed UNIX shell scripts for data manipulation.
• Used data sources from SQL, Oracle, SSAS cubes and files to generate reports in Tableau.
• Hand on experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from different sources
• Supporting clients as a Subject Matter Expert (SME) through trouble shooting, preparing ad-hoc reports and presentations
• Established and documented Standard Operating Protocols (SOPs) for each stages of the product development through documentation
• Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data warehouse repository of Teradata
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Utilized critical path method to effectively complete projects within project timeline and budget
• Worked with cross functional team to identify risk, plan risk response, risk mitigation and developed risk resolution
• Coordinated with external team & consultants for successful implementation of knowledge transfer through “Technology Transfer”

Environment: SQL MS 2008, Python 3.x, Tableau 9.x, 8.x, Power BI, MS Excel, Oracle, Informatica, ETL, Data warehouse, Teradata, SSAS, Agile Scrum.

Confidential, New York, NY

Data Analyst

Responsibilities:

• Collaborating with data engineers and operation team to implement ETL process, wrote and optimized SQL queries to perform data extraction to fit the analytical requirements
• Writing simple and advanced SQL queries and scripts to create standard and ad-hoc reports for senior managers
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MSSQL Server) from various heterogeneous data sources
• Applied various data mining techniques: Linear Regression & Logistic Regression, classification, clustering
• Used Tableau for reporting the business performance (KPI’s and metrics)
• Responsible for different Data mapping activities from Source systems to Teradata.
• Expert inTableau Desktop 9.x/8.x, Tableau Reader and Tableau Server and Experienced in analysis, modeling, design, and development of Tableau reports and dashboards for analytics
• Presented discovered trends and analysis, forecast data, recommendations and risks identified to the higher management
• Used the Waterfall methodology to build the different phases of Software development life cycle
• Performed in depth statistical analysis on collected data and prepared presentation & peer reviewed publications

Environment: SQL MS 2008, Microsoft Power BI, Python 3.x, Tableau Desktop 9.x/8.x, SAS, MySQL, ETL, Oracle, Waterfall.