We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

Bolingbrook, IL

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.

Hire Now