SUMMARY

• Overall 2+ years of Industry experience as a Data Analyst with good understanding of data modeling, evaluating data sources and knowledge in Data Analysis, Design and Development of business reporting projects using Tableau, PowerBI, Smartsheet and also knowledge on complex datasets that are using databases, analytical and BI tools.
• Having good knowledge on SQL/PLSQL, Python and R statistical programming languages as well as Data Visualization tools (Tableau, Smartsheet, MS Excel and Power BI).
• Knowledge of sophisticated business applications and relational databases (MS SQL Server, Amazon Redshift DWH, Oracle, MySQL, Microsoft Access and PostgreSQL)
• Experience in design, development and deploying business reports & dashboards with drill - down capabilities using Tableau Desktop, Tableau Server and Tableau Online
• Knowledge of using Confluence, SharePoint, and Box tools for maintaining, sharing and publishing the development details of Business Report / Dashboard(s).
• Hands on experience in developing Machine Learning (ML) models using R, Anaconda Jupyter Notebook, SPSS modeler, SPSS statistics
• Strong knowledge on Microsoft Office tools such as Excel, Add-In Excel tools, Excel Solver, Pivot tables/charts, Data Analysis, Lookup Functions, MS word, Power Point, SharePoint, Risk Analysis, Simulation using Palisades Decision tools, outlook and Google docs, sheets etc.
• Having good knowledge onSmartsheet (SaaS)tomanage project details as well as design and build Business Reports/dashboards.
• Hands on experience of Data Science & Statistical libraries in Python and R such as Pandas, NumPy, SciPy, Matplotlib, Scikit-learn, Plotly, SpaCy, Dplyr, Ggplot2, Shiny, Mlr, tidyr, plotly
• Experience in design & developing SQL queries for Business reports using AWS Data Lake.
• Deeper understanding of descriptive, predictive, and prescriptive analytics as the key concepts like statistical language, data mining and data visualization.
• Involved in Unit Testing, System Integration, Performance & Regression Testing of the Business Applications.
• Experience in different software development methodologies Waterfall and Agile Methodology using Rally, JIRA, MS Project & Smartsheet.
• Experience in resolving on-going maintenance issues, performance tuning and bug fixes in Business application & reports.
• Have domain experience on Financial, Energy Service, Manufacture & Health care domains.
• Major strengths are familiarity with multiple software systems, ability to learn quickly new technologies, adapt to new environments, self-motivated, team player, focused adaptive and quick learner with excellent interpersonal, technical, and good communication skills with strong ability to interact with end-users, customers and team members.
• Experience in working with multivendor team in an onsite-offshore model and multi-site development.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, R and Python

ETL Tools: SSIS, Azure Data Factory (ADF)

BI / Reporting Tool: Tableau (Desktop, server and online), PowerBI, Smartsheet, MS Excel

Databases (RDBMS): MS SQL Server, Amazon Redshift DWH, PostgreSQL, MySQL, Microsoft Access, Oracle, MS Azure SQL Database (PaaS)

Design & Development Tools: Visual Studio, Visual Studio Code, MS SQL Server Management Studio Azure Data Studio, SQL Developer, GIT, R Studio, Anaconda, Jupyter Notebook & PyCharm IDE, Spyder & Dbeaver IDE

Statistical Packages & Data mining Algorithms: SPSS Modeler & Statistics, KNN, Regression Analysis, Time series forecasting, C&R Tree, Decision Tree, K-Means, Neural nets, Cluster analysis and Association rules.

Machine Learning tools & Libraries: Pandas, NumPy, SciPy, Matplotlib, Scikit-learn, Plotly, SpaCy, Dplyr, Ggplot2, Shiny, Mlr, tidyr, plotly

Bigdata Platform: Azure Data Factory (ADF)

Operating systems: Windows, MS-DOS, UNIX and Linux

Cloud Technologies: Amazon Web Services (AWS) Cloud, Azure Cloud

Microsoft Office Tools: MS Excel, MS Word, MS Teams, SharePoint, PowerPoint, MS SQL server export and import wizard & Outlook

Other Packages & Tools: Citrix, Confluence, ServiceNow, Jira, Rally, Smartsheet API, Box/Box Drive, Google docs, sheets & Notepad++

PROFESSIONAL EXPERIENCE

Confidential, Schenectady, NY

Data Analyst

Responsibilities:

• Analyze business user requirements and then translated the requirements into technical specifications to build the analytical reports.
• Applies data analysis and data modeling techniques to design and develop reports/dashboards using Tableau and Smartsheet tools
• Involved in creating a high-level design document to identify the join conditions between fact and dimension tables in the AWS data lake environment.
• Working on generating various Tableau dashboards using multiple data source like AWS Redshift data warehouse (DWH), Smartsheet via web data connector, Oracle DB, text files & Excel files.
• Experience in creating calculated measures, dimensions, groups, hierarchies, sets, parameters to manipulate data using Tableau desktop.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gant Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Level of Details and Aggregate measures.
• Creating new reports/dashboards, integrating/enhancing the existing dashboards, working on change requests projects, Adhoc analysis and reporting for business needs.
• Performing data analysis, Unit Testing, Integrating testing, performance testing, User Acceptance Testing (UAT) of business reports/Dashboards in QA, Dev and Production environments.
• Working on reports migration, Incident tickets, change requests using ServiceNow.
• Involved in Production support, Incident tickets, analyzing issues, reports migration, change request using service Now.
• Designed several dashboards to help with daily management by promoting productivity, helping proof future features of digital tools and seeing overall site health through a Genba Dashboard for region wise.
• Built different tableau and Smartsheet reports/Dashboards for executive level review of different key business drivers including Variable Cost Productivity, Operational KPIs, Operational Planning for labor and country warehouse usage
• Involved in calculating and publishing new work standards for unplanned repairs, part replacement and major operations
• Developed dashboard to show compliance metrics to promote safety protocols and ensure proper installation of key components
• Designed and developed Tableau report/dashboard based on Fieldwork App that useful to technicians to know about Turbines historic and current performance tracking and as well as parts usage information
• Involved in develop and build KPI metrics for business needs.
• Maintaining and publishing business reports/dashboards standardization information on Confluence, SharePoint and Box
• Involved in Agile Scrum meetings with Product owner and another scrum team members
• Worked in Onsite/offshore as well multi-site development model and managed offshore team, organizing and conducting meetings with the Offshore/Client at onshore for project requirements and status discussions

Environment: AWS Cloud, Amazon Redshift data warehouse, Oracle Database, PostgreSQL, SQL, SCADA/Machine Data, Tableau Desktop, Tableau Server, Windows OS, Smartsheet, Python, Anaconda Jupyter Notebook, Pandas, NumPy, SciPy, Matplotlib, Scikit-learn, Plotly, SpaCy, Dbeaver IDE, MS Excel, Power Point, MS Word, OneDrive, SharePoint, Box/Box Drive, Confluence, ServiceNow and Rally.

Confidential, Milwaukie, WI

Associate Analyst-Data Science

Responsibilities:

• Gathered business requirements and transform them into a technical insight as per business needs
• Used Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Developed Power BI reports and dashboards by connecting different data sources like Azure Databricks, Oracle General ledger, SQL Server, Excel and Text format files.
• Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
• Experience in using DAX (Data Analysis Expressions) functions for various fact calculations for efficient data visualization in Power BI
• Developed various dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, CircleViews, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed Python scripts to connect SQL Server & SSAS cubes for processing large data sets, data analysis and extract data for data visualization.
• Involved in developing Dashboard, Parameterized reports, linked reports, sub reports by Region, Country, Year, Quarter, Month, WoW and YoY
• Involved in migrating “HVAC Equipment” portfolio reports from legacy systems (MicroStrategy, SSRS & SSAS) to Azure cloud environment using Power BI Desktop and Azure Databricks.
• Worked in publishing Power BI Desktop reports created in Report view to the Power BI service.

Environment: Microsoft Azure Cloud, Azure Data Factory, Azure Databricks, MS SQL Server, Oracle Database, PostgreSQL, SQL, PowerBI, Windows OS, Python, Anaconda Jupyter Notebook, Pandas, NumPy, SciPy, Matplotlib, Scikit-learn, Plotly, SpaCy, MS Excel, Power Point, MS Word, OneDrive, SharePoint, Box/Box Drive, Confluence, ServiceNow

Confidential, Phoenix, AZ

Analyst

Responsibilities:

• Collaborated with stakeholders to comprehend company objectives, metrics, processes, and requirements.
• Created of comprehensive solution(s) to meet business requirements utilizing.
• To design/develop an efficient overall technological solution, identify and resolve conflicts across numerous use cases.
• Reviewed of new releases to determine their impact and potential for technological and business process enhancements.
• Involved in requirements gathering, documentation, and solution design standards and best practices.
• Participated in the facilitation, definition, and recording of requirements, as well as the analysis of work/data flow, acceptance criteria, and test preparation.
• Estimated and assisted with application configuration and testing on a hands-on basis.
• To developed, built, and delivered a solution, collaborate with other technical and non-technical team members as well as vendors in a technology-neutral language.
• Understand the business requirements and create problem statement, gather data, analyzing and validate the data using Excel and creating repots and dashboards in Excel and Tableau

Environment: MS SQL Server, Oracle Database, SQL, Tableau, Windows OS, MS Excel, Power Point, MS Word, OneDrive, SharePoint, Box/Box Drive, Confluence, ServiceNow