SUMMARY

• Around 8+ years of IT experience in the Architecture, design, development, analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI and Power BI.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Experience indesigning, developing and deploying Business Intelligence solutions usingSSIS,SSRS, SSAS, Power BI.
• Extensively worked on designing/developing Dataware house (DWH) using dimensions and fact.
• Expert in writing script to provide solution using Transact - SQL (DDL, DML) commands.
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Extensive experience in implementing BI solutions using SSIS, SSRS, SSAS Tabular Model, T-SQL, PowerBI, Azure Data Factory, Azure Function, Azure Blob Storage, Azure SQL Database.
• Experience in ETL design using tools Informatica, SSIS, SSAS, Azure SQL, Azure Data Factory etc.
• Very good working experience on Microsoft Cortana Analytics Suite - Azure Data Lake (ADL), Azure Datawarehouse(ADW), Azure Data Factory(ADF) and PowerBI.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Expert in creating multiple type of reports using tools like Power BI and SSRS.
• Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Designed and developedmatrix and tabular reportswithdrill down, drill throughusing SSRS.
• Experience inwriting Complex SQL Queriesinvolving multiple tablesinnerandouter joins.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP and experience inOLTP/OLAPenvironment andData Warehouse.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Proficient with automated testing tools - Selenium, HP ALM QC, Load Runner and QTP for testing Client / Server and Web based applications
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2019/2017/2016/2014/2012/2008 R2/2008, MySQL, Oracle 13c/12c/11g/10g/9i/8i & MS Access

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop, SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS), SQL Server Reporting Services, Crystal Reports, Tableau, Excel.

Operating Systems: Linux, Mac OS X, Microsoft Windows/Advanced Server, MS-DOS

Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2015/2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

Cloud Technologies: Microsoft Azure and Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential, Chesterbrook, PA

Power BI Developer

Responsibilities:

• In this project as a BI developer, I used to work on various projects for loading data from multiple sources into the application databases using SSIS packages, develop SSRS Reports and build Power BI dashboards and Azure.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Installed and configured Power BI Desktop.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2017 and Flat files.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Created PowerBI Dashboard sourcing the data from Azure Cosmos DB and to secure it with hierarchal Row Level Security for the end users to consume the interactive PowerBI Reports as well as dashboards.
• Monitoring the Power BI On-Premises Report Services, Cloud versions.
• Usage Statistics and Refresh schedule runtimes in PowerBI Folders, and Workspaces respectively.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
• Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables.
• Involved in performance tuning of Azure SQL Datawarehouse by detecting the data skew problems by creating the right distribution for each of the dimension and fact tables.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Converting existing Pivot report Mockups in to interactive PowerBI reports with all the latest PowerBI updates and Paginated reports Sourcing the data from SQl server as well as web Api's and Scheduling them for mail delivery daily Morning.
• Created SSIS packages to integrate the data coming from flat files.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Created SSIS packages for loading data from SAP BW/BI to SQL Server.
• Performed database backup and deployment to the production server.
• Involved in modifying existing DataStage Jobs for better performance.
• Created reports using stored procedure and involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2017).
• Installation and configuration of SQL Server Reporting Services (SSRS) 2017
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.
• Designed STAR, SNOWFLAKE Schemas.
• Used M language in Power Query to transform the data as per business requirement.
• Utilized R and Python for developing visualizations in Power BI.
• Created Workspaces and Apps in Power BI Service and published the reports into it to share with the users.
• Created Dynamic Row Level Security to restrict data access to specific users based on their roles in power BI.

Environment: MS SQL Server 2019/2017, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Microsoft Azure, Salesforce, Intacct, Power BI Desktop, M Language, Python, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8/10.

Confidential, Plano, TX

Data Analyst/Power BI Developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Installed and configured Power BI Desktop.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2017 and Flat files.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Created PowerBI Dashboard sourcing the data from Azure Cosmos DB and to secure it with hierarchal Row Level Security for the end users to consume the interactive PowerBI Reports as well as dashboards.
• Monitoring the Power BI On-Premises Report Services, Cloud versions.
• Usage Statistics and Refresh schedule runtimes in PowerBI Folders, and Workspaces respectively.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
• Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
• Involved in creating the external and internal tables in Azure SQL Datawarehouse and created stored procedures to move the data from external to internal tables.
• Involved in performance tuning of Azure SQL Datawarehouse by detecting the data skew problems by creating the right distribution for each of the dimension and fact tables.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Converting existing Pivot report Mockups in to interactive PowerBI reports with all the latest PowerBi updates and Paginated reports Sourcing the data from SQl server as well as web Api's and Scheduling them for mail delivery daily Morning.
• Created SSIS packages to integrate the data coming from flat files.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Created SSIS packages for loading data from SAP BW/BI to SQL Server.
• Performed database backup and deployment to the production server.
• Involved in modifying existing DataStage Jobs for better performance.
• Created reports using stored procedure and Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2017).
• Installation and configuration of SQL Server Reporting Services (SSRS) 2017
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.
• Designed STAR, SNOWFLAKE Schemas.
• Used M language in Power Query to transform the data as per business requirement.
• Utilized R and Python for developing visualizations in Power BI.
• Created Workspaces and Apps in Power BI Service and published the reports into it to share with the users.
• Created Dynamic Row Level Security to restrict data access to specific users based on their roles in power BI.

Environment: MS SQL Server 2019/2017, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Microsoft Azure, Salesforce, Intacct, Power BI Desktop, M Language, Python, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8/10.

Confidential, St. Louis, MO

Data Analyst/Power BI Developer

Responsibilities:

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Worked on writingDAXqueries and manipulating the multidimensional data inTabular Model cubes.
• Involved in identifying and creating data sources and data source views in SSAS.
• Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Developed calculated columns and measures using DAX in Power BI
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Created Power BI dashboard and generated reports.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
• Upgraded SSIS Package Wizard from SQL Server Data Tools (SSDT) from SQL Server Management Studio.
• Published Power BI Desktop to the cloud.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Experience in combining data from different sources by using of Power Query
• Performance tuned the existing stored procedures in order to reduce the existing Query times.
• Worked on fixing Bugs in the existing SSIS Packages and made improvements to get down the run time of the SSIS Package.
• Performed the Slowly Changing Dimensions Using Hash Byte Techniques for Better Performance of SSIS Packages and for parallel Loading of Data.
• Created detail Technical documentation of various staging area operations for future reference and guidance.
• Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database), Azure Blob Storage.
• Migrated data from on premises data to azure SQL Database using azure services like Azure Data Factory with copy activity.
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and API's in Azure SQL.
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Created some SSIS packages to import and export data from various data sources using SSDT.
• Created database objects liketables, users, roles, stored procedures, triggers.
• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Created few new reports for internal usage using SSRS 2012.
• Responsible for deploying the reports, cubes and packages on all environments.
• Scheduled the jobs for SSIS packages under SQL Server Agent.
• Deployed SSIS packages using Integrations Service Catalog and also through XML configurations.

Environment: MS SQL Server 2015/2012, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, M Query, XML, Microsoft Azure, MS Excel, Windows 8 and DAX Studio.

Confidential

SQL BI Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like DB2, VSAM, SQL Server 2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created a report model on SSAS cubes.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2008 R2 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules.
• Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Deployed and Tested (UAT) Reports in Multi User Environment. Created RS Config Files and Ensure Report Security with Keys.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Worked closely with QA team and helped them come up with test scenarios.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings

Environment: MS SQL 2008 R2, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server

Confidential

SQL BI Developer

Responsibilities:

• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Worked on Huge Data Transfers from & to SQL Server Database. Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed MDX queries to retrieve data from SSAS cubes.
• Designed high level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment.
• Created necessary steps to enhance user response time by improving queries and their index selections to minimize IO and eliminate table scans.
• Enhancing the SSIS Packages and deploying from development server to production server.

Environment: SQL Server 2008, Query Analyzer, SQL/SSIS/SSRS/SSAS, C#, Visual Studio.NET, ProClarity Server, TFS, XML, BizTalk, MS Excel, Oracle, Visual Source Safe.