PROFESSIONAL SUMMARY:

• Over 12+ years of professional IT experience in architecting, designing, developing Business Intelligence solutions across multiple domains like Oil&Gas, Health Care, Retail, Investment Banking, Financial services and Manufacturing industries.
• Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.
• Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the difference user groups in the organization.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Good understanding of business requirements, Warehouse schemas and mapping rules for the implementation of simple to complex ETL designs.
• Expert in implementing various business rules for Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using Azure Data Factory(ADF) and SQL Server Integration Services (SSIS).
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Points, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Extensive experience in developing tabular and multidimensional SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, deploying and Processing SSAS objects.
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Dashboard, Scorecards, Drill - down and Drill-through reports, Defining Data sources and Subtotals for the reports using SSRS and integrating them with SharePoint server and native mode.
• Expert in data warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles using Normalization and De-Normalization techniques
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experienced in creating and maintaining database objects such as tables, views, indexes, integrity constraints, Stored Procedures and Triggers.
• Experienced in working with SQL Query Analyser, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Security Architecture and SQL Profiler
• Experience in supporting web based, mission critical applications including Logical and Physical Database Design, Development, Performance Tuning and Change Management
• Involved in designing and develop master data management system by removing duplicates, standardizing data and incorporating rules to eliminate incorrect data from entering the system in order to create an authoritative source of master data.
• Expertise in Proactive Caching, Degenerated Dimensions and Tabular Data Modelling for Moderate to Large Data Systems.
• Highly experienced in Data Quality Testing, data governance and Identifying and resolving Data anomalies in complex Data Integration systems.
• Team builder with strong, analytical & interpersonal skills with good knowledge in Software Development Life Cycle(SDLC) and Proficient in technical writing.
• Extensive experience in building complex dashboards/reports in tableau and admin functionalities of tableau server.
• Extensive experience in Waterfall, Agile software development and SCRUM methodology.
• Ability to work independently and as part of a team to accomplish critical business objectives as well as good decision-making skill under high pressure complex scenarios
• Involved in importing the data from various source systems and create the rich dashboards using Power BI.
• Good Understanding of Azure Big data technologies like Azure Data Lake Analytics, Azure Data Lake Store, Azure Data Factory and created POC in moving the data from flat files and SQL Server using U-SQL jobs.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003,2008 and 2012

Database Technologies: SQL Server 2008/2012/2014/2017 , Oracle, Polybase Azure SQL Database, Azure SQL Datawarehouse

Business Intelligence: Power BI, Azure Data Factory (ADF), Azure Databricks, U-SQL, Azure Analysis Services(SSAS), Azure Data Lake Analytics, Azure Data Lake Store (ADLS), Power Apps, SSRS, SSIS, Microsoft Flow, Azure Logic Apps, Log Analytics, Spark SQL, Python, Scala, MDX, DAX, XMLA, Power Query(M Language), Pentaho, Tableau, Azure Event Hubs, Azure Stream Analytics

Tools: Visual Studio 2005/2008/2010/2017.

Webserver: IIS 6.0 and IIS 7.0

Defect Tracking Tool: IBM Rational Rose Clear quest, Mercury Quality Centre

Version Control: Perforce, Visual Source Safe and Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Azure/Power BI Architect

Technologies: ADF,Databricks,Power BI,Pyspark,Scala,Spark SQL

Responsibilities:

• Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake Data Lake Store Raw Zone.
• Created data bricks notebooks using Python(PySpark),Scala and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Raw to Stage and Curated zones.
• Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.
• Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook.
• 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.

Confidential, Atlanta,

Power BI Architect

Technologies: Databricks, Power BI, AAS, Azure SQL Database, ADF, ADLA,USQL Duration:

Responsibilities:

• Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI and providing access to different user groups like sales, operations and finance team needs.
• Involved in creating the notebooks for moving data from raw to stage and then to curated zones using Azure databricks.
• Involved in Architecting, Design, developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure functions.
• 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.
• Assigning Power BI Pro licences to the users, configuring role base security by creating different roles in Azure Analysis services and providing access to app workspaces and apps.
• Design and develop the data factory pipelines to move the data from oracle database to Azure Data Lake Data Lake Store.
• 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.
• Created Azure Data Lake Analytics U-SQL jobs for transforming data in Azure Data Lake Store to move from Raw to Stage and then to Curated zones.

Confidential, Atlanta

Senior BI Consultant

Technologies: Power BI, AAS, ADF, USQL, SQL Server

Responsibilities:

• Involved in design and development of multiple Power BI Dashboards and reports.
• Architecting, Designing and developing complex SSAS databases and constantly monitoring the daily schedules and provides data to the adhoc requests from the business users.
• Managing data privacy and security in Power BI
• Extensively involved in designing and developing the power BI Data model using multiple DAX expressions to build calculated columns and calculated measures.
• Developed Azure Data factory pipelines to move the data from source systems and transform the data in azure blob storage and created ADLA USQL jobs to transform the data in Azure.
• Setting the Policies, Limits for the Azure Data Lake Analytics and provide access to the users to process USQL jobs.

Confidential

Lead Analyst

Technologies: Power BI, DAX, SSIS, SSAS, SQL Server 2014

Responsibilities:

• Involved in design and development of multiple Power BI Dashboards and involved in deploying and sharing the dashboards to the end users.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Involved in Design, develop and maintaining complex SSAS databases and constantly monitoring the daily schedules and provides data to the adhoc requests from the business users.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source systems.
• Proactively delivered all the assigned change requests/incidents with at most quality to the end users.
• Involved in writing the technical and functional specification documents and guiding the team members in all aspects.

Confidential

Lead Analyst

Technologies: SSIS, SSRS, Power BI, SSAS, SQL Server 2012 Duration:

Responsibilities:

• Involved In designing and implementing the SSAS cube using the Star Schema dimension model.
• Created multiple dimensions from the Named Queries and Various measures for calculating the Average Settled Value, Last Pending Value measures for the fact tables.
• Created SSIS Packages for moving data from Excel Files and SQL Server to datawarehouse.
• Involved in designing and creating the New Database Schema and creating the database objects like Stored Procedures and Views.
• Involving in the development and designing of SSRS Reports like Target Fund code, Fund Allocation and Fund Target Percentage from the SSAS Cube.
• Developed multiple power BI Dashboards and deploying them on the SharePoint environment.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Confidential

Principal Software Engineer

Technologies: Tableau, SSIS, SSRS, SSAS, SQL Server 2012 Duration:

Responsibilities:

• Developed dashboards, work books and data views depending upon the business requirements in Tableau Desktop and published them in Tableau Server.
• Implemented Data Blending, groups, combine fields, calculated fields, aggregated fields, sets and hierarchies and and spotlighting to compare and analyze data in different perspectives.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments and to move the data to SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modelling standards in SQL Server 2012 that maintained data.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.

Confidential

Consultant

Technologies: SSIS, SSRS, SSAS, SQL Server 2008 R2 Duration:

Responsibilities:

• Involved In designing and implementing the SSAS cube using the Star Schema dimension model.
• Involved in the analysis of the requirements and gathering requirements for closed loop project.
• Created Technical Report Requirement document for the Standard Reports.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Created an SQL Server Integration Services project for extracting the data from Excel Files, SQL server OLTP database to the data warehouse.
• Involved in designing and creating the New Operational database schema also in Creating the database objects like Stored Procedures and Views.

Confidential

Sr. Software Engineer

Technologies: SSIS, Tableau, SSRS, SSAS, Oracle Duration:

Responsibilities:

• Involved in creating reports/dashboards in Tableau using different charts such as maps, bars, lines, cross tab, donut, pie and highlight tables
• Designed SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
• Responsible for creating the Deployment scripts using XMLA and also for scheduling the cube process.
• Involved in designing and Creating the New Database Schema also in Creating the database objects like Stored Procedures and Views.
• Involving in the development and designing of SSRS Reports and Integrating with Asp.Net web application
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs