EXPERIENCE SUMMARY:

• I am Trained, certified and experienced with SQL Server on premise and Cloud environment. Having 12+ years of experience in Microsoft SQL Server Business Intelligence Tools (MSBI) and Azure technologies (ADF, ADL, ADW), Designing & Implementing Solutions on different database servers; ranging from GBs to TBs in size.
• Microsoft Azure Cloud Services
• Subscribe SQL Server Azure Cloud Services.
• Create Database(s) on SQL Azure
• Setting up SQL Azure Firewall
• Create and manage Microsoft Azure Data Lake
• Migration from On - Premise to cloud platform
• Designing and implementing Azure and related technologies like DW, ML and HDInsight etc.
• Create, manage SQL Server Azure Data Warehouse (DW) Databases
• Setting up Connection Strings and connecting SQL Server Azure Databases from locally
• Develop the Power BI desktop services and publish on PBI service (cloud)
• Create gateways, data sources and user admin on cloud services for Power BI
• Create external tables and load the data in Azure SQL DW tables using Polybase.
• Analysis Services / Data warehouse Management (SSAS)
• Excellent hands on experience deploying SSAS Objects using deployment wizard or using Synchronize database wizard.
• Experience in Data Marts, Data warehousing, OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, FACT and Dimension Tables using MS Analysis Services (SSAS).
• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Excellent hand on experience in creating report model on SSAS cubes, as well as changing default configuration on existing cubes.
• Good experience in Designing Aggregations and pre-calculating in SSAS 2008 and 20012.
• Experience in writing MDX Scripting and MDX Queries. Experience in Building Cubes and Dimensions.
• Integration Services / Data warehouse Management (SSIS)
• Extensively involved in data extraction and loading using .dtsx in MS SQL Server 2005 using SSIS in MS SQL Server 2005/2008/2012.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Strong experience in database Backup, Restore and Recovery procedures using SSIS Packages.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions, Performance Tuning and Query Optimization.
• Reporting Services / Data warehouse Management (SSRS)
• Created SSRS Reports to meet Ad hoc and operational business requirement
• Publishing / Deploying Report on multiple Report Servers
• Managing Shared Data sources and permissions
• Configured Reports Snapshots, Report Caching for reporting performance
• Assigning report level permissions to Secure business information
• Created Data Driven Subscription for Reports

TECHNICAL SKILLS:

Technologies: Microsoft Business Intelligence Tools (SSIS, SSAS, SSRS)

Operating Systems: Windows 2003 / NT / XP

Languages: C, C++, Java, VB 6.0, T - SQL, Python, U-SQL

Statistical Tools: Machine Learning with R (CRAN)

OLAP Tools: SQL Server Analysis Services

Databases: Greenplum, Oracle 9i, SQL Server 2005 / 2008 R2 / 2012 / 2016

Packages: MS Office 2010, MS Visio, Visual studio, MOSS 2012

Reporting Tools: SQL Server 2012 Reporting Services, Qlikview, Tableau, Power BI

Big Data Tools: Hive, HBase, Sqoop, Pig, Spark with Python.

Cloud Platform: Microsoft Azure ADF, ADL, ADW, HDInsight and Storage etc..

EMPLOYMENT DETAILS:

Confidential, Sunrise, FL

Data Analyst

Responsibilities:

• Responsible for ensuring project estimates and schedules are created.
• Providing project status reports to RM and stakeholders.
• Create Database(s) on SQL Azure platform.
• Create and manage Microsoft Azure Storage.
• Migration from On-Premise to cloud platform for Data Lake database like ADL, SQL DW
• Designed and developed Azure Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Develop the Power BI desktop services and Manage, Publish on PBI service (cloud) using Direct Query, Import and Live Connection methods.
• Create gateways, licensing, setup data sources and user admin on cloud services for Power BI

Environment: SSDT 2016, ADF, ADL, Azure Synapse Analytics (formerly SQL DW) and Power BI service.

Confidential, Boca Raton, FL

Power BI Developer

Responsibilities:

• Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS tools and technologies.
• Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.
• Designed and developed Tabular Analysis Services (SSAS) databases and OLAP cubes used in automated reporting.
• Develop the Power BI desktop services and Manage, Publish the PBI service (cloud)
• Create gateways, data sources and user admin on cloud services for Power BI.
• Provided training to end users and co developers.

Environment: SSIS 2012, SSAS 2012, SSRS 2016, ADF, Azure SQL server and Power BI service.

Confidential, FL

SOLUTION ARCHITECT

Responsibilities:

• Managing the team with onsite/client communication, technical practices, ensuring tasks/sprints are completed on time and removing impediments and attend team meetings with Customers and Co-Ordination with different vendors.
• Responsible for ensuring project estimates and schedules are created.
• Providing project status reports to RM and stakeholders.
• Create Database(s) on SQL Azure platform.
• Create and manage Microsoft Azure Storage.
• Migration from On-Premise to cloud platform for Data Lake database like SQL DW and HBase to HDInsight
• Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Successfully implemented Data Integrate POC’s between Data Lake tables to BI Layers.
• Develop the Power BI desktop services and Manage, Publish on PBI service (cloud)
• Create gateways, licensing, setup data sources and user admin on cloud services for Power BI
• Create external tables and load the data in Azure SQL DW tables using SSIS.
• Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and Azure tools and technologies.
• Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.

Environment: Azure cloud (Azure DW, ADF, ADL), A-SSAS, SSRS 2016 and Power BI service.

Confidential, FL

BI ARCHITECT

Responsibilities:

• Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and Azure tools and technologies.
• Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.
• Managing the team with onsite/client communication, technical practices, ensuring tasks/sprints are completed on time and removing impediments and attend team meetings with Customers and Co-Ordination with Offshore.
• Responsible for ensuring project estimates and schedules are created.
• Providing project status reports to RM and stakeholders.
• Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Successfully implemented Data Integrate POC’s between Data Lake tables to BI Layers.
• Develop the Power BI desktop services and Manage, Publish the PBI service (cloud)
• Create gateways, data sources and user admin on cloud services for Power BI
• Create external tables and load the data in Azure SQL DW tables using Polybase.

Environment: Azure cloud, SSIS 2012, SSAS 2012, SSRS 2016 and Power BI service.

Confidential, FL

BI ARCHITECT

Responsibilities:

• Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and SQL server tools and technologies.
• Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible
• Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
• Identifying the technologies to employ based on price, performance, service agreements and organization constraints
• Designs, implements and supports data warehousing and also building Data marts for each department.
• Pull the Data through ETL process from multiple systems like Oracle ERP, PeopleSoft, Work Brain and Footprints into Data ware house.
• Dimensional Data Modelling using Star and Snow Flake Schemas.
• Developed complex store procedures for business requirements.
• Developed SSAS cubes for each department like Finance, accounts, HR, PeopleSoft and Service desk.
• Designed very complicated Security setup using MDX So that when user’s login they will see only their divisions data.
• Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Good Understanding on SSAS cube MOLAP, ROLAP, HOLAP storage modes.
• Designed and developed dynamic partitions in SSAS (Multi-Dimensional) cubes.
• Designed and developed Multi-Dimensional Analysis Services cube XMLA scripts for dynamic cube processing and Backup/Restore.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Developing multiple SSRS reports like parameterized, sub report, cascading and dynamic.
• End to End testing on all development activities to retain data accuracy and performance related issues.
• Managing Off shore team of 10 resources and providing production support to developed marts.

Environment: SQL Server 2012, SSIS 2012, SSAS 2012, SSRS 2012, Qlikview and Tableau SQL Server 2008 R2, SSIS 2008 R2, SSAS 2008 R2 and SSRS 2008 R2.

Confidential

BI ARCHITECT

Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design.
• Responsible for data warehouse modeling, ETL design and development, and performance tuning.
• Designed and implemented the ETL architecture for the whole project using SSIS.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Effectively solved ongoing issues in the Test, QA Environment.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on T-SQL / ETL.

Environment: SQL Server 2008 R2, SSIS, SSRS, MOSS.

Confidential

ETL ARCHITECT

Responsibilities:

• Designed and implemented the ETL architecture for the whole project using SSIS.
• Designed and developed multi-dimensional Cube databases using SSAS.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Performing Health checks for Sql Servers and performing Warehouse keeping activities.
• Responsible to monitor all support activities, tickets tracking, providing necessary support to associates Etc.
• Effectively solved ongoing issues in the production Environment.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on Reports and ETL.

Environment: SQL Server 2008, SSIS, SSAS and SSRS.

Confidential

BI PROJECT LEAD

Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design.
• Responsible for data warehouse modeling, ETL design and development, and performance tuning.
• Designed and implemented the ETL architecture for the whole project using SSIS.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on Reports and ETL.
• Ensure smooth deployment on all development and testing environments.
• Co - ordinate with production team for issue analysis and resolution.

Environment: Oracle, Netezza, SSIS, SSRS, UNIX