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 knowledge 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 teh 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 teh processed data.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in teh 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 teh 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 teh architecture of Tableau security by customizing teh 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 teh data on teh fly.
• Participated in day-to-day activities like creating workbooks, dashboard, published on server.
• Created cascading filters to filter teh data within teh 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 teh 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 teh 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 teh business team for improving process.
• Collect data on keywords which influence participants to consent for teh research study to understand participants’ mindset and optimize teh recruiting process.
• Used ETL process to Extract, Transform and Load teh 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 teh 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 teh 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 teh business requirements and identified gaps in different processes and implemented process
• Generated documents supporting accounting/ financial current as per teh business requirements improvement initiatives across teh 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 teh requirements of teh 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 teh complex task of determining and gathering teh relevant data and tan cleansing teh 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 teh 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 teh calculations, parameters in teh Tableau and creating SQL datasets for Tableau and Ad-hoc reports.
• Expert on creating teh report schedules on Tableau server.
• Developed story telling boards in desktop and published into teh server which allowed users to understand teh data with teh 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 teh transactional databases and data warehouse.
• Provided production support to Tableau users and written custom SQL to support business requirements.
• Blended teh data from teh different databases in to one report by selecting teh primary keys from each database for teh data validation.
• Worked closely with data architects to improve data's performance by reducing teh 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 teh 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 teh 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 teh supplier records and teh frequency of teh 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 teh story inside teh data publishing and presenting dashboards on web and desktop platforms
• Applied linear regression analysis on teh Supplier records and visualized teh 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 teh dashboards to monitor teh statistics and application performance.
• Prepared and cleaned millions of data records which are retrieved from Oracle database and produced teh 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 teh garage mates by using teh 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 teh daily operations, including data pulls, research assignments, and file transfers, dataprocessing and data quality management.
• Managed all company social media activity, teh 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 teh 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