SUMMARY

• Around 8+ years of experience in Software Design, Database Design, Development, Integration Implementation, and Maintenance of Business Intelligence and the related Database Platforms.
• As a Data Analyst responsible for Data Modeling, Enterprise Data Management, Data Presentation, Visualization, Optimization, Risk assessment, predictive analysis, advanced Data Analysis, Business Research, and Quantitative Analysis.
• Experience in SQL 2017/ 2016/2 R2 with an emphasis on design, development, automation, tuning, optimization, Performance, and Security.
• Experience in analyzing business user requirements, analyzing data, and designing software solutions in Tableau Desktop based on the requirements.
• Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Expertise in Microsoft Integration Services like SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Proficient in SQL Server Integration Services like Package creation, Check Points Implementation, Dynamic Configuring of the package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, and Package encryption.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Expertise in creating reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Optimal Performance.
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Extensive experience in SQL Server 2016/2012/2008 Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Experience working on Tableau (Desktop, Server, Reader), creating various Reports and Dashboards using different functionalities.
• Experience in Tableau Desktop, Power BI for data visualization, Reporting, and Analysis; Cross tab, Scatter Plots, Geographic maps, Pie Charts and Bar Charts, Page Trails, and Density charts.
• Extensive experience in creating complex SSIS packages, creating jobs, Alerts, scheduling SSIS Packages using SQL Agent and migrating the data from different legacy systems to SQL using SSIS.
• Proficient in the Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Handled various types of encryption and decryptions in SQL as per client requirements to secure data.
• Experienced in migrating Data from Excel, Flat file, and Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring, and Fine-tuning ETL workflows in SSIS.
• Hands-on in Designing, maintaining, and building Cubes, Dimensions, and Data source views, data mining Models, Deployment, and Processing using SSAS.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), and Crystal Reports.
• Good command in generating on-demand and scheduled reports for business Analysis and Management decisions using SSRS 2016/2012/2008.
• Well-versed in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Developed Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Developed Python script for processing large data sets and also to extract data from different files.
• Built Python Modules to deliver specific formats of data.
• Designed and developed OLAP Cubes with star schema and Dimensions using SSAS.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX, and MDX (SSAS).
• Expertise in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models, and Deploying and processing SSAS objects.
• Extensively used performance monitor/SQL profiler to solve deadlocks/long-running queries.
• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming, and Retrospective.
• Acquisition and mastering new technologies and delivering outputs within short deadlines in a fast-paced environment with problem-solving and organizational abilities.
• A polished communicator, with good analytical and inter-personnel skills and a versatile team player.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2017/ 2016/2 R2, Oracle 13c/12c/11g/10g/9i/8i, TOAD 7.5, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database.

Operating Systems: MS-DOS, Windows Server 2012/2008/2003/ XP/NT 4.0/98, UNIX, Linux.

BI Tools: Power BI Desktop, Einstein Analytics, SAP Business Objects, Tableau Desktop (2018.1.x/10.x/9.x/8.x), Tableau server (10.x/9.x/8.x), Workday, Reader, Online, Crystal reports, MS Excel, SSRS and Excel Power View

SQL Server Tools: SQL server management Studio, BIDS, SQL server profiler, FTP, TOAD.

Programming languages: Python, R, SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA, T-SQL, PL/SQL, C/C++, XML, HTML, CSS, VisualBasic6, VBScript, Java script, C#, PHP, .NET, VB.NET, ASP.NET.

Methodologies: Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/ Physical/ Dimensional, MS Project, SQL Profiler, Toad, and TFS.

Cloud Services: Microsoft Azure, Confidential Web Services (AWS), and Oracle Enterprise Manager Cloud.

PROFESSIONAL EXPERIENCE

Confidential, Georgia, Atlanta

Data Analyst/ Power BI Developer

Responsibilities:

• Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives within M & SC (Manufacturing and Supply Chain), including the interfaces between applications, databases, and platforms.
• Created a Datawarehouse and Integrated different systems data into the Warehouse (Salesforce and SAP). Worked with multiple teams for combining the different Databases into a single Universe.
• Made Power BI reports more interactive and active by using storytelling features such as bookmarks, selection panes, and drilling through filters also created custom visualizations using R-Programming Language.
• Used Machine learning using Python-Programming Language for converting different language text to English for analysis.
• Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data
• Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, and maintained the apps and workbooks.
• Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.
• Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of the business.
• Collected the Plants Data in Excel sheets from different Regions around the World and combined them in Power BI to know the Loss and Profit of the Product.
• Performed COPQ and DPPM analysis in Power BI and helped Global Quality Leaders to take Business-driven decisions.
• Translated data requirements to produce comprehensive, detailed data maps and canonicals.
• Identified supply chain problem areas and opportunities to improve service, reduce cost, and increase inventory turns
• Performed ETL on multiple platforms such as SAP HANA and Teradata, familiarized with Confidential Legacy, SAP, and other backend environments to pull the Data-to-Data Wearhouse
• Created and maintained Apps and Reports in Salesforce for Customer Issue Resolution and maintained different Processes of CRM.
• Used SQL queries to create an interactive Dashboard in Salesforce Einstein Analytics Studio and analyzed CRM data.
• Created and maintained SharePoint page for Lean Six Sigma using Power Queries for Plant Data and Audited the different projects in the company for Discrepancies.
• Used BOXI (Business Objects) for creating reports for Legacy Systems.
• Mapped the data in different systems and Documented them, IBM Lotus Notes is mostly used for mapping the Legacy Systems and Customer Feedback Resolution.
• Performed Queries, maintained and extracted Data from Teradata, cleaning and maintaining the Production Environment in Teradata for performance.

Environment: Power BI Desktop, Power BI Service Pro, Teradata, Salesforce, Einstein Analytics Studio, Business Objects, SharePoint, SAP HANA, SAP Logon, QlikView, IBM Lotus Notes, SQL, SQL Server, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel)

Confidential, Hoboken, NJ

Data Analyst/Power BI Developer

Responsibilities:

• Participated in daily scrum meetings with the team to discuss the challenges and development of the project
• Involved in requirement gathering from business users and IT teams to understand and express the business process and business logic
• Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.
• Extracted data from data warehouse server by developing complex SQL statements using stored procedures and common table expressions (CTEs) to support report building
• Implemented Tableau for visualizations and views including scatter plots, box plots, Heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.
• Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.
• Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions
• Published Tableau workbook on Tableau Server and set report refresh
• Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and the Tabular Models.
• Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint and deploy models into SQL Server SSAS instance.
• Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
• Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
• Made Power BI reports more interactive and active by using storytelling features such as bookmarks, selection panes, drill-through filters, etc.
• Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace
• Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data
• Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports
• Created SSIS packages for ETL processes by using control flow and data flow components
• Maintained and tuned performance for slowly running SSIS packages
• Responsible for accurately reporting on the financial aspect of the company's operations by rendering reports on a daily/weekly / monthly base
• Evaluated returns and risks for various types of investments including stocks, fixed-income assets, hedge funds, real estate, and commodities, and evaluated risk tolerance for customers
• Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for the income statement, cash flow by requests from business units
• Implemented report integration among Power BI, Tableau, SSRS, and Python reports.

Environment: Power BI Desktop, Power BI Service, Project Online, SQL Server 2016/2017, SSRS, SSIS, SSAS, DAX, Tableau, Microsoft Azure, Python, SharePoint, Visual Studio, Scrum/Agile, BI Development Studio (BIDS), MDX, XML, SQL Profiler, TFS, MS Office, Windows 10/7, Data Analyzer

Confidential, Detroit, MI

Power BI/MSBI (SSIS, SSAS, SSRS) Developer

Responsibilities:

• Worked with different team’s clients, analytics, data sources, QA, and visualization.
• Worked in the agile process having expertise in the life cycle of a project from start to end.
• Created data warehouse and data marts from scratch based on data structures and reporting needs.
• Worked on writing ad hoc SQL scripts which are required for reporting purposes.
• Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
• Worked on user management for power bi. Sharing the dashboard access for power bi online.
• Worked on Power BI dashboards and ad hoc DAX queries for power bi.
• Extensive back-end support for many various reports on Tableau and Power BI.
• Created store procedures, functions, triggers, indexes, and views based on data processing and data cleansing.
• Created various SSIS packages for data movements and transformations.
• Worked on Python code to load data from Google buckets to big query tables, using data flow for ELT (Extract Load Transform) in Big Query.
• Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
• Hands-on experience in working with Applications Migration and App Development in AZURE.
• Worked on Web jobs, AZURE data factory, and Logic Apps for application and project development in Azure.
• Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.
• Worked on deploying websites in Azure and used MVC framework on the backend.
• Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts, and Database Triggers to populate the data by applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g.
• Create and review SSAS tabular cubes for consumption as a data source for reports, Dashboards, and Pivot tables.
• Worked on creating multiple databases from scratch.
• Worked on Azure SQL data warehouse and database development.
• Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures, and functions and worked on ad hoc change tickets.

Environment: Power BI, SQL Server 2012/2016, AZURE, Google Big Query, Tableau, Excel, MS SQL Server 2016/2014/2012 , Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS) and Oracle 11g.

Confidential

Associate Data Analyst

Responsibilities:

• Created SSIS packages development, Unit testing, and deployment in Dev and QA Environment.
• Interacted with the technical team and Business users to performance analysis of business requirements and transformed them into technical requirements for ETL
• Used advanced features of T-SQL to design and tune T-SQL to interface in the azure cloud and other applications in the most efficient manner
• Collaborate with Software engineering resources to deliver high-quality deployments that meet department and customer expectations for quality and schedule.
• Created Packages, Jobs, and Sending Alerts using SQL Mail, database Backup, Recovery, and Disaster Recovery procedures.
• Planned the complete Backup of various Databases for Disaster recovery scenarios in Production
• Adheres to the organization’s established policies and procedures and assists in enhancing the deployment procedures. Adhere to all ETL standards and architecture
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Work with business teams to understand current business processes for onboarding acquired bulk claims data
• Evaluate legacy solutions and technology to understand the viability of leveraging these to match requirements for a new application.
• Evaluate database structures to further understand the processing of claims data
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Storage Explorer
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS, PowerShell
• Help develop evaluation findings results and assist the development of recommended solution architecture
• Used advanced features of T-SQL to design and tune T-SQL to interface in Azure cloud and other applications in the most efficient manner
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing
• Create and review SSAS tabular cubes for consumption as a data source for reports, Dashboards, and Pivot tables.
• Expert in creating Star schema cubes using SSAS
• Good experience with MDX query and DAX
• Developed Power BI reports using Power Query from SharePoint & different Data sources
• Embedded Power BI reports on the SharePoint portal page and managed access to reports and data for individual users using roles.
• Designed and created data extracts, supporting SSRS, Power BI visualization reporting applications

Environment: Microsoft Visual Studio2016, SQL Server, Azure, Power BI, Power Pivot, SAS EG, Teradata SQL assistant.