We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

New York, NY

SUMMARY

  • Business - minded Data scientist/Data Analyst with a strong math background and 7+ years of experience using Data modeling, A/B Testing, processing and mining to solve challenging business problems.
  • Able to leverage noledge of Applied statistics with visualization and a healthy sense of exploration. Demonstrated skills in large scale data manipulation, machine learning and Data mining.
  • Expertise in Tableau desktop versions 8.1/9.x/10, Tableau Server, Tableau Online, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting.
  • Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across the client servers.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Expertise in Requirements gathering/analysis, Data Mining, Design, Development, Testing and Production rollover of Reporting and Business Intelligence Analysis projects.
  • Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
  • Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.
  • Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in the organization.
  • Creating SAS datasets, reports, tables, listings, summaries and graphs according to specifications.
  • Generating tables employing various SAS data steps and procedures with Statistical SAS procedures, graphs and plots.
  • Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Used Tableau Versions for flexible data sharing and analytics firepower with enhanced statistical, parameter capabilities.
  • Experienced in developing applications using Agile Methodologies and Scrum stories in a python-based environment.
  • Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.
  • Extensive experience in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
  • Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS).
  • Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
  • Used SSRS to create and manage a wide variety of different types of report and deliver them in a range of formats.
  • Extensive usage of AWS for connecting to data sources on cloud using Amazon Redshift.
  • Experience in Designing and deploying AWS solutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.
  • Used SSRS to create basic reports containing tables and graphs and more complex data visualizations, using charts, maps and spark lines.
  • Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
  • Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application, folder and user levels.
  • Worked on connecting tableau to various other data sources like Hive, Redshift AWS, Teradata, Oracle and experience in establishing respective driver connections.
  • Performed maintenance activities like Backing up, cleaning logs and archiving log files in prescribed intervals.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
  • Improved Reports performance in tableau using extracts and context filters.
  • Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
  • Created calculated fields to interact with parameters dynamically to visualize the data on the fly.
  • Participated in day-to-day activities like creating workbooks, dashboard, published on server.
  • Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.

TECHNICAL SKILLS

Data modeling: MS Visio, Power Designer, Data Visualization, Business Intelligence BI, Software Management, And DataCollection.

Microsoft Tools: MS Word, Excel, PowerPoint, Access, Project, Outlook, SharePoint, SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Databases: MS SQL Server, Oracle, Teradata, Impala, Hive

Programming language: SQL, PL/SQL, T-SQL, C, Python, R, HTML, XML, XSL

Business Intelligence: SAS JMP, Tableau 9.x/10, Power BI, Micro Strategy, SSRS, Alteryx

PROFESSIONAL EXPERIENCE

Confidential | New York, NY

Sr. Data Analyst

Responsibilities:

  • Create and implement complex SQL queries for retrieving and updating data on backend Oracle database.
  • Assist cross-functional engineering, product management, and various data teams to create test cases as per business requirements and best practices protocols.
  • Build scalable analytical frameworks to monitor data quality supporting product analytics.
  • Administer requirement gathering and create business requirement documents, functional specification documents and use cases.
  • Designed and created requirement traceability matrix to map the requirements for test cases to ensure that expected results are achieved.
  • Triage user-submitted tickets on Incident Monitor, which acts as a defect-tracking system.
  • Create use case diagrams, dataflow diagrams, and business process flow diagrams using MS VISIO to elicit requirements.
  • Review project change requests and obtain approvals from the appropriate stakeholders.
  • Perform analysis & extraction on data to group participants for research using Python.
  • Develop dashboards with key performance indicators (KPIs) using Tableau according to ad-hoc requests from the business team for improving process.
  • Collect data on keywords which influence participants to consent for the research study to understand participants’ mindset and optimize the recruiting process.
  • Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Maintained and Installed Tableau Server in all the environments.
  • Created incremental refreshes for data sources on Tableau server.
  • Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
  • Used various ETL tools to extract data into Tableau Desktop and data wrangling using Alteryx in data preparation phase. Performing end to end Data validation.
  • Created many calculated columns and measure using DAX in Power BI based on report requirements.Extensivelyused visual filters, page filters, report filters and drill through filters inPower BI reports
  • Translated business needs into Data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Analyzing and developing business critical dashboards for BCBSM and delivered reports and dashboards as per Business User Requirements by using Tableau.
  • Developed T-SQL queries and used Oracle tools in extracting data from large data repositories such as Data Warehouse and ODS.
  • Developed daily, weekly and monthly reports with consistent drill-down functionality including Drilldown reports, summary reports, cross-tab reports, parameterized reports and Master Detail reports including Ad-hoc reports for management.
  • Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snowflake Schema.
  • Utilizing Jira, Confluence to implement Agile best practices for defect tracking, project tracking and accountability of deliverables.

Environment: Tableau Desktop, Tableau Server, Tableau Online, Oracle 11g, PLSQL, SQL SERVER 2016, Oracle TOAD, UNIX, Power BI, Excel, Jira, Confluence, SharePoint, ETL, SSIS, SSRS, SSAS

Confidential | New York, NY

Business Data Analyst

Responsibilities:

  • Understand the business requirements and identified gaps in different processes and implemented process
  • Generated documents supporting accounting/ financial current as per the business requirements improvement initiatives across the business improvement model
  • Provided analytical support using MATLAB for methodology-related projects; conducted monthly reviews on multiple public sectors.
  • Designed, developed, maintained Tableau functional reports based on the requirements of the user.
  • Experience in design and development of Tableau visualization solutions.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server
  • Applied advanced sampling & data analytic techniques to halp with strategic initiatives, roadmaps & process
  • Analyzed quantitative and qualitative business data to develop a solution design capable of fulfilling internal and external client needs
  • Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
  • Used Alteryx Analytics to simplify the complex task of determining and gathering the relevant data and tan cleansing the data for consumption.
  • Used Alteryx to enable integration with virtually any data source from any location and enrich them with third-party spatial, location-based, and demographic data to get the richest set of data available for analysis in Tableau.
  • Designed, developed and tested various Tableau/Tableau visualization for dashboard and ad-hoc reporting solutions.
  • Preparing Dashboards using the calculations, parameters in the Tableau and creating SQL datasets for Tableau and Ad-hoc reports.
  • Expert on creating the report schedules on Tableau server.
  • Developed story telling boards in desktop and published into the server which allowed users to understand the data with the filters when they needed certain information.
  • Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
  • Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Proficient in developing Entity- relationship diagrams, star/snowflake schema designs and expert in modelling the transactional databases and data warehouse.
  • Provided production support to Tableau users and written custom SQL to support business requirements.
  • Blended the data from the different databases in to one report by selecting the primary keys from each database for the data validation.
  • Worked closely with data architects to improve data's performance by reducing the number of calculated fields and thus optimizing performance.
  • Managing timely and accurate delivery of information to various cross-functional teams.
  • Expert in data preparation with experience in blending multiple data sources, and creating multiple joins within the same data source.
  • Assisted Quality Assurance, Software Developers, Security, and Business Partners with UAT with new functions in SQL and MATLAB
  • Designed interactive dashboard with drill down capability, roll back capability, customizations by using both live and extract data connections.
  • Used filters, parameters, sets, groups, hierarchies (Customer and default), calculated fields and table calculations to create interactive, user friendly and creative dashboards.
  • Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, grant charts, trend lines, waterfall charts, statistical models, heatmaps, geo-maps allowing end users to utilize full functionality of the dashboard.
  • Aligned with Quality Assurance, Software Developers, Security, and Business Partners to follow standards and methodologies.

Environment: Tableau Desktop, Tableau Server, Tableau Online, Oracle PLSQL, SQL SERVER 2014, T-SQL, MATLAB

Confidential | Princeton, NJ

Data Analyst

Responsibilities:

  • Conducted statistical analysis on automotive data and forecasted the supplier records and the frequency of the reports by using Python and R.
  • Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data
  • Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports using Tableau
  • Experience in configuring reports from different data sources using data blending
  • Experience on working different types of projects like migration projects, new projects, Ad-hoc reporting and exploratory research to guide predictive modelling.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems
  • Creating SAS datasets, reports, tables, listings, summaries and graphs according to specifications.
  • Generating tables employing various SAS data steps and procedures with Statistical SAS procedures, graphs and plots.
  • Produced attractive visuals/dashboards to convey the story inside the data publishing and presenting dashboards on web and desktop platforms
  • Applied linear regression analysis on the Supplier records and visualized the depth by using ggplot2 and dplyr.
  • Analyzed and identified big data and implemented predictive analysis trends by utilizing Excel, Tableau, R, and Python (pandas, NumPy, scikit-learn, seaborn).
  • Integrated business data from IHS Markit applications and created the dashboards to monitor the statistics and application performance.
  • Prepared and cleaned millions of data records which are retrieved from Oracle database and produced the visualizations using Tableau.
  • Utilized Data Science programming languages such as Python, R, SQL etc. to mine and analyze data from enterprise data sources.
  • Generated reports and created a dashboard using advanced SQL.
  • Worked on an Apache Hive environment for predicting/forecasting the garage mates by using the automotive data.

Environment: Tableau Desktop, Tableau Server, Oracle 11g, PLSQL, SQL SERVER 2016, Oracle TOAD, SAS, SAS JMP, RapidMiner,Python, Anaconda, R, Python libraries, R libraries, UNIX, Power BI, Excel

Confidential | New York, NY

Business Data Analyst

Responsibilities:

  • Spearhead company communications initiatives, launching first company newsletter and overseeing contentdevelopment
  • Provided oversight to the daily operations, including data pulls, research assignments, and file transfers, dataprocessing and data quality management.
  • Managed all company social media activity, the media management system (MMS), and contributed content to thecompany website using WordPress
  • Promoted to Project Manager after 6 months by assuming leadership roles and working proactively with clients
  • Organized bootstrap marketing to increase funding
  • Assists department management in developing, monitoring, and reporting on departmental level initiatives, goals, and objectives
  • Manage process for transferring funds between projects or requests for new funding, including documentation, entry into the corporate budget system, and confirmation
  • Used pivot tables and vLookups to halp small entrepreneurial ventures organize data
  • Wrote automated SQL to pull in data from various sources
  • Perform all financial transactions such as check requests, purchase orders, journal transfers, hiring Independent Contractors, vendor adds, deposits, fellowship payments, and travel reimbursements for all staff
  • Developed business plans, media campaign plans, project management plans, and retail and web analytics reportsand presentations for both internal and external stakeholders
  • Identified, analyzed, measured, and managed project risks; kept expenditure, accounting, costing, and billingrecords using CRM
Environment: Microsoft Excel, Oracle PLSQL, SQL SERVER 2014, T-SQL

Hire Now