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, advance Data Analysis, Business Research and Quantitative Analysis.
• Experience in SQL 2017/ 2016/2014/2012 /2008 R2with an emphasis on design, development, automation, tuning, optimization, Performance and Security.
• Experience in analyzing business user requirements, analyzed data and designed 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 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 Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Extensive experience in creating complex SSIS packages, creating jobs, Alerts and schedule SSIS Packages using SQL Agent, migrating the data from different legacy system to SQL using SSIS.
• Proficient in 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, 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), 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 to 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 dead locks/long running queries.
• Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burn down Charts, Backlog Grooming and Retrospective.
• Acquisition and master new technologies and to deliver outputs in short deadlines in a fast- paced environment with problem- solving and organizational abilities.
• A polished communicator, with good analytical and inter-personnel skills and versatile team player.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2017/ 2016/2014/2012 /2008 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

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 Wearhouse (Salesforce and SAP). Worked with multiple teams for combining the different Databases to a single Universe.
• Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill 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 helps business users to get quick insight of the data
• Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, 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 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 the 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 Process of CRM.
• Used SQL queries to create 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 the 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, Memphis, TN

Data Analyst/Power BI Developer

Responsibilities:

• Participated in daily scrum meeting with team to discuss on the challenges and development of the project
• Involved in requirement gathering from business users and IT teams to understand and express 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 for 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 interact and activate 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 helps business users to get quick insight of 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 daily / weekly / monthly base
• Evaluated returns and risks for various types of investments including stocks, fixed-income assets, hedge fund, real estate and commodities and evaluated risk tolerance for customers
• Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for 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, Philadelphia, PA

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

Responsibilities:

• Worked with different team's client, analytics, data sources, QA and visualization.
• Worked in agile process having expertise in 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 dash boards 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, 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, used 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, 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 web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g.
• Create and review SSAS tabular cubes for consuming as a data source for reports, Dashboards, Pivot table.
• 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, 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

Business Intelligence/ MSBI (SSIS, SSAS, SSRS) Developer

Responsibilities:

• Created SSIS packages development, Unit testing and deployment in Dev and QA Environment.
• Interacted with technical team and Business users to performance analysis of business requirement and transformed them into technical requirement for ETL
• Used advanced features of T-SQL in order to design and tune T-SQL to interface in azure cloud and other applications in 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 Back-up of various Databases for Disaster recovery scenarios in Production
• Adheres to the organization's established policies and procedures and assist 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 solution and technology to understand viability of leveraging these to match requirements for new application.
• Evaluate database structures to further understand 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, and Azure Data Factory, SSIS, PowerShell
• Help develop evaluation findings results and assist development of recommended solution architecture
• Used advanced features of T-SQL in order to design and tune T-SQL to interface in Azure cloud and other applications in 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 consuming as a data source for reports, Dashboards, Pivot table.
• Expert in creating Star schema cubes using SSAS
• Good experience on MDX query and DAX
• Developed Power BI reports using Power Query from SharePoint & different Data sources
• Embedded Power BI reports on SharePoint portal page and managed access of 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.

Confidential

MSBI (SSIS, SSAS, SSRS)/BI Engineer

Responsibilities:

• Proficient involvement in design of Data migration project in end to end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.
• Following agile pattern, and communicating with functional and technical team on the requirements for migrating data from legacy heirloom systems to Hybris
• Creating staging DB, move all the business scope data to the staging database and migrate to Hybris using SSIS
• Developed interfaces to process the SAP Sales Orders, SAP Accounts, Shipping acknowledgements and ASN confirmation.
• Worked on dimensional modeling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the member fact tables.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources based on design data models.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, for loop and For Each Loop Container, Execute-SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Row Count, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Involved in Functional testing, cut over plans to discuss on the technical status of the launches
• Performed End-End testing includes various phases like SIT (System Integrations) Soft Launch, Preproduction Launch, Going live and phased migrations.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the SSAS Tabular Models.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources based on design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task, conditional Split, Script Component, Merge and Lookup while loading the data into Destination.
• Loading flat files every day and storing them in Archive by renaming the files with current date.

Environment: Microsoft SQL Server 2012/2014, visual studio, SSRS, SAP -Hybris, MuleSoft. .Net, GIT, Jira and Tableau.