We provide IT Staff Augmentation Services!

Senior Data Analyst Resume

Decatur, IL

SUMMARY

  • Highly analytical and process - oriented Data analyst around 8+ years of experience in financial data and supply chain data, performing ETL Development/testing, Exploratory and Statistical Data Analysis, Predictive Modeling, and Data Visualization of large datasets.
  • Excellent team player with good communication and inter-personal skills, and proven ability to work efficiently in both independent and teamwork environments.
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Veri cation and Identifying data mismatch.
  • Extensive experience in Data Visualization including producing Tables, Graphs, Listings using various procedures and tools such as Tableau.
  • Proficient inPython 3.x., R and worked in stats function with NumPy, Visualization using Matplotlib/Seaborn, Tableau and Pandas for organizing data.
  • Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration and Snowflake.
  • Created and Configured Data Source and Data Source Views, Dimensions, Cubes, Measures, Partitions and MDX Queries using SQL Server Analysis Services.
  • Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS
  • Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, and User Defined Functions.
  • Experience in creating reports in Power BI, MicroStrategy, Informatica and Tableau.
  • Experienced in Designing Data Mart and Data Warehousing using Star Schema and Snowflake Schema in implementing Decision Support Systems.
  • Understanding KPIs (Keep performance indicators) and Master data.
  • Well-versed with all stages of software Development life cycle (SDLC), Software testing life cycle (STLC) and Defect Life Cycle (DLC).
  • Strong knowledge in OLAP Systems, OLTP Systems Dimensional modeling using Star schema and Snow ake schema
  • Proficient in Designing and Developing ETL objects using Informatica PowerCenter with Various transformations such as Joiner, Aggregate, Expression, SQL, Lookup, Filter, etc.
  • Hands on experience with creating solution driven Dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Line Charts, Scatter Plots and Histograms in Tableau Desktop.
  • Excellent knowledge in preparing required project documentation, tracking, and reporting regularly on the status of projects to all project stakeholders.
  • Strong business sense and abilities to communicate data insights to both technical and nontechnical clients.
  • Extensive experience in Data Visualization including producing Tables, Graphs, Listings using various procedures and tools such as Tableau.
  • Extensive knowledge and experience in the financial data domain worked on BPC (SAP Business planning and consolidation) and BW4/HANA.

TECHNICAL SKILLS

Languages: Python 3.x, R, SQL, T-SQL

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

Big data Framework: Amazon EC2, S3 and EMR, Hadoop

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, Decatur, IL

Senior Data Analyst

Responsibilities:

  • Experience with Teradata, created Tables, Macros and Stored Procedures. Sub-query correlated sub-query, complex Stored Procedures and ad-hoc TSQL statements. Created Views to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
  • Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Formats and Data Definitions.
  • Implemented advanced analytical functions Lead/Lag, Over, Partition By, Dense Rank, N-Tile, Row Number, Windowing Aggregate Function, Inverse Percentile, First/Last Functions.
  • Ensuring the data quality by re-defining ETL process validation, metadata maintenance, data integrity validation process, quality standards, monitoring standard, and audit and reconciliation processes.
  • Creating multiple Workspaces, and Published Apps for different environments, managing Gateway connections, scheduled refreshes for multiple models and managed access for user group for these reports.
  • Generated Goals vs Actuals reports for multiple metrics by displaying KPI visuals and charts comparing Goals and Actual values for monthly, quarterly, and yearly in Power BI.
  • Create parameters in reports and data model, develop parameterized reports, send commands to paginated reports in Power BI by adding a parameter to a URL, customize how Power BI processes the report by embedding parameters for rendering formats.
  • Hands on Experience in creating Data flows transformations including derived-column, Script, Pivot, Unpivoting, Loop up, Merge, Append, Data Conversion, Conditional-Split, Union All etc.
  • Worked as a Power BI work-stream lead, leading daily standup calls, and discussions on ongoing release activities, accomplishments and Identifying impediments with the offshore team and the business.
  • Utilized Power Query in Power BI to pivot and un-pivot the data models for data cleansing.
  • Involved in Power BI Administration practices like scheduling the refresh, creating workspaces for each environment, creating Apps for each workspace, granting permissions to the reports in the organization.
  • Actively participated in interacting with the DBA’s and technical manager to know about the Business requirements, understand the function workflow of information, and meet their needs.
  • Worked with Dynamics CRM, exacted data and manipulated data in CRM using SSIS packages.
  • Created Visual Charts, Graphs, Maps, Area Maps, Dashboards and Storytelling using Tableau and Power BI.
  • Developed and published daily trend analysis on retail metrics especially relating to sales, revenue, customer retention and business development team’s productivity.

Environment: SQL, Python, Tableau, Power BI, SSIS, Teradata, MS Excel.

Confidential, Phoenix, AZ

Data Analyst

Responsibilities:

  • Actively participated in interacting with the Application developers and Product owners to know about the Business requirements, understand the function workflow of information, and meet their needs.
  • Played a key role as a developer in the Data Services team in migrating data into a new application.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions, and Queries with the best execution plan.
  • Experience in Report Writing, Developed Power BI solutions and published in QA and PROD environments, managed the access permissions, Gateway connections, and refresh schedules for these Models.
  • Create and maintain documentation of data interface specifications, data mappings, transformation rules, business decisions and migration processes to be available to business/Product owners and IT teams.
  • Deploy migration processes in Test, development, and stage environments.
  • Implement ETL processes necessary to extract data from various data sources using SQL Server Integration Services (SSIS)
  • Developed Power BI dashboards and reports based on clients transfer pricing output reports to compare against prior period data by extracting data from AWS Redshift and S3 buckets.
  • Worked on data visualization using Power BI by creating various reports and dashboards to track the metrics of the Registrations.
  • Created multiple measures to create Key Performance Indicators (KPI) visuals to display the Exam Registrations.
  • Ensure data quality by re-defining ETL process validation, metadata maintenance, data integrity validation process, quality standards, monitoring standard, and audit and reconciliation processes.
  • Support product issue resolution teams with engineering support to determine root cause and corrective action concerning to fix the data.
  • Data Cleaning, Data analysis and Data Validations to maintain data consistency across all the applications.
  • Use sound software engineering principles to ensure that developed ETL code is modifiable, efficient, reliable, understandable, and fault tolerant.
  • Manipulating and Cleaning datausing missing value treatment in Pandas and performed standardization in python.
  • Migrate existing data into the Power BI.
  • Defining data warehouse from star and snowflake schema, fact table, tabular cubes, dimensions, measures using SQL Server Analysis Services.
  • Assist data model in designing of dimensional model for Star schema.
  • Developed Power Maps using Excel for Reporting.

Environment: T-SQL, Stored Procedure, Triggers, Function, Power BI, ETL, Tableau.

Confidential

Data Analyst

Responsibilities:

  • Used analysis and visualization tools such as EXCEL, TABLEAU, SQL to analyze data and draw accurate and reliable conclusion to provide insights to upper management and financial team.
  • Used advanced excel to create pivot tables, charts & pivot reporting, as well as used aggregate functions to analyze data.
  • With the help of tableau desktop created worksheets to show comparison between dashboards also used filtering, sets, parameters, sorting, story boards to show data visualization.
  • Created interactive reports & published them in tableau server for the users so that they can access easily on the server.
  • Used stored procedure, triggers & views to provide structured data to business units by combining millions of rows of data from data sources.
  • 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.
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Worked on CSV files while trying to get input from the MySQL database
  • Created functions, triggers, views, and stored procedures using MySQL.
  • Extensive experience in creating, maintaining, and tuning views, user defined functions and system functions
  • Using SQL Server Experience in working with live data, structured and unstructured data from multiple data sources and translate complex data into user-friendly versions

Confidential

Data Analyst

Responsibilities:

  • Designed and tuned complex SQL queries and tested packages, stored procedures, triggers, views of databases, which increased computing speed and reducing the processing time by 30%.
  • Utilized Python and SQL for examining large data sets of current and historical sales to predict markets, identify 90% of market trends, and translate data into insights to provide meaningful analysis to the team.
  • Worked on ETL project, used batch processing to improve the performance. Experience in writing ETL script in SQL/PySpark to populate a data warehouse.
  • Configuration and maintenance of the Hadoop ecosystem over the AWS platform for data analysis.
  • Contributed data analysis support, such as summarizing A/B test result, visualizing B2B sales lead and opportunity, and preparing a dashboard for the management team.
  • Reduced query retrieval time by automating manual tasks using stored procedures, functions, and PL/SQL scripts.
  • Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
  • Improved efficiency of the sales team by optimizing time and performance matrices monthly sales report presentation, by executing a customized sales dashboard system to and record a 15% growth in sales.
  • Translated Business Requirements from Stakeholders into Technical Requirements for the development team.
  • Performed data exploration on source data using Business Intelligence and Statistical analysis tools.

Hire Now