SUMMARY

• Seasoned IT professional with over 12 years of IT experience in implementing Business Intelligence Solutions, Data Warehousing and Data Visualizations using Azure Cloud, Confidential BI Stack, Power BI Services with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation of client server applications in various industries.
• Hands - on experience in Azure Cloud Services (PaaS & IaaS,SAAS), Storage, Web Apps, Active Directory, Application Insights, Logic Apps, Data Factory, Service Bus, Traffic Manager, Azure Monitoring, Visual Studio Online (VSO), Azure DataBricks.
• Extensive Experience in T-SQL designing Databases & DB Objects Tables, Stored Procedures, Views, Triggers,UserDefinedfunctions.
• Excellent Knowledge in RDMS Concepts and Experience in Normalization of tables up to Third Normalization Form.
• Expertise in end to end development of Reporting Technologies Like Power BI, SSRS
• Highly proficient in writing Transact-sql & MDX queries, DAX queries, Performance Tuning and analyzing query execution plans and extensive knowledge of transactions, Error Handling in ETL & T-Sql.
• Extensive experience in creating ETL packages using SQL server Integration Services (SSIS), Cubes using SQL Server Analysis Services (SSAS) & Tabular Model.
• Experience in Administration and providing support of Power BI system within large enterprise level tenant
• 4+ years of experience with Azure Cloud Services such as Azure Data Factory, Azure SQL databases, Azure Synapse, Azure Analysis Services (AAS), SSAS Tabular, Azure Blob Storage and Data Lake Storage, Azure DevOps etc.
• 5+ year of experience in working with Confidential SQL Server database programming and as ETL Developer using SSIS, SSRS, SSAS
• 2+ years’ experience in developing apps using PowerApps and Confidential Flow (Power Automate) and Power BI Embedded, Power BI REST API, LogicApps and PowerShell for automation.
• Experience in defining calculated members, named sets in SSAS & by using MDX queries.
• Experience in Power Pivot, Building pivot Tables, Power query.
• Extensive experience on complete Reporting Life Cycle on Authoring, Management & Delivery. Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005/2008R 2/2012/2014/2016 Reporting Services (SSRS).
• Experience in migrating EDW with Azure Sql Data Warehouse.

TECHNICAL SKILLS

Databases: MS-SQL Server, SQL Azure Databases, Teradata, DB2, Oracle 9i/8i, DB2, MS Access, Confidential Dynamics CRM Databases.

Programming Languages: SQL, TSQL, SCOPE, C#, XML, C, C++, HTML, DHTML,PowerShell, R

Operating Systems: Windows 10,8&7, Windows Vista Business Edition, Windows Server 2008,Windows Server2003,Windows Enterprise Server, Windows NT 4.0, Windows XP Professional/Standard

Web Servers: IIS 5.0, IIS 6.0, IIS 7.0

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Custom Data Acquisition Framework, Informatica.

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), Tableau, Web Focus, Excel,Cognos.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, Front page, Excel VBA.

Protocols: TCP/IP, FTP, HTTP, SMTP, SOAP, REST

PROFESSIONAL EXPERIENCE

Confidential, Arkansas

Power BI Developer/ Administrator

Responsibilities:

• End to end implementation including Planning, Developing, administering within Power BI environment with Confidential recommended best practices
• Development and Administration within Power BI system across organization, support large volume of users, reports, workspaces, and work with multiple business units.
• Work with stakeholders and business end users to understand requirements and translate functional requirements to technical documentation
• Develop high level and interactive user interface within Power BI reports that halp users navigate and analyze teh data efficiently
• Build efficient data models, datasets and data flows for transforming data and create custom Measures using DAX
• Power BI reports are built and automated with best practices showing Inventory, Sales Transactions, Revenue Amount, Shipping details for multiple business owners and stakeholders
• Power BI Report Builder is used to create paginated, parameterized reports for users to be able to navigate and print multiple page reports
• Built Power BI reports from Azure SQL databases, AWS Redshift, AWS RDS, on prem Databases, AAS Tabular, SAP Hana, Active Directory, Salesforce CRM data,MS Excel, Snowflake databases, Web API’s as data sources for Power BI Data Models
• Built AAS models for handling large volumes of datasets and built Power BI reports on top of it
• Existing Reports were migrated to Power BI from Cognos, MicroStrategy by reverse engineering and Comparing report functionality, rewriting source queries within Power BI models
• User Security is implemented across reports, datasets, data sources, apps, workspaces within Power BI
• Row level security is implemented for specific reports
• Wrote complex DAX expressions to create measures and optimize report performance with best practices
• Written stored procedures, ETL logic, PowerShell scripts to automate data load process
• Transformed data in Power Query, data flows and used DAX for custom columns and Measures
• Developed Azure Data Factory pipelines, data flows for ETL purposes
• Performance monitoring of power bi reports, data set refresh within premium capacity and troubleshot teh same
• Created Power BI environment and Set up Premium Capacities as per enterprise requirements.
• Worked on making enhancements for existing reports and apps
• Designed data ingestion strategies using Azure Data Factory, Azure Blob storage, Azure SQL databases and data lakes
• Developed Azure Data Factory pipelines, data flows for ETL purposes
• User Security is implemented across reports, datasets, data sources, apps, workspaces within Power BI
• Row level security is implemented for specific reports
• Written T-SQL queries, stored procedures, ETL logic, PowerShell scripts to automate data load process
• Worked with Power BI Embedded and Premium, Azure App Registration for publishing reports in Azure
• Installed and maintain On-premises gateways to connect to multiple on prem data sources and to set up Scheduled refresh
• Troubleshoot gateway, firewall, dataset refresh and data source connection issues
• Capacity workloads are monitored and optimized dataset refresh and query times
• Used Azure DevOps as part of agile scrum to create tasks and user stories

Confidential, Grand Rapids, MI

Sr. Power BI Developer

Responsibilities:

• Designed and implemented BI solutions using Power BI
• Responsible for Power BI tenant administration and monitoring user activity
• Power Bi Capacity planning, installing gateways, troubleshooting Power Bi datasets
• Administration within Power BI system, gateway, tenant settings and user support
• Support Tabular models in Azure and performance monitoring
• Work directly with Business Users and Supervisors representing multiple program offices across teh agency to gather requirements
• Designed and implemented BI solutions using Power BI for Grants Management system, Schools and Student management system within Department of Education
• Responsible for Power BI tenant administration and monitoring user activity
• Power Bi Capacity planning, installing gateways, troubleshooting Power Bi datasets
• Administration within Power BI system, gateway, tenant settings and user support
• Support Tabular models in Azure and performance monitoring
• Analyze existing database systems to write complex queries to be used in reports
• Migrated existing MicroStrategy reports to Power BIreports and dashboards
• Design, enhance and maintain teh reporting metadata layers, reports, report definitions and dashboards in Power BI Desktop and Tableau
• Created pipelines, data flows in Azure Data Factory for data loading and transformation.
• Used Azure Blob storage, Azure databases and data warehouse as source for Power BI
• Used Power Query for teh ETL process and to import data into Power BI data model
• Created calculated columns and measures using DAX expressions to use in KPI’s
• Develop statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and TEMPeffective visualizations
• Write complex SQL queries, Materialized Views and used them as data source for reports
• Implemented Row Level Security in Power BI to manage data privacy across user levels
• Product Key Life Cycle analysis Project and published to powerBIService.
• Develop and maintained partner onboarding web Application using C# and .net framework libraries.
• Use Git repository and Azure devops for deploying pipelines across multi environments
• Created interactive Dashboards using Power BI for analytics Team.

Environment: SQL Server 2017/2016/2014 , Visual-Studio, T-SQL, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell,TFS, Machine Learning, SQL Azure,ADW,AzureDataLake,ADF,R scripting, MS PowerBI, Power Apps,, HDInsight.

Confidential, Seattle, WA

Sr. SQL Server BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed Stored Procedures for combining Relational & Multi-Dimensional data into one query result set and created SSRS Reports on top of it.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Created SSIS packages with which data sources such as XML,JSON,Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS2012)
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on teh OLAP reporting needs
• Used Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels & Measures, and Measure Groups.
• Built Cube Partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
• Built MDX queries for Analysis Services & Reporting Services.
• Defined Attribute, Dimension, Cube level properties using Analysis Services.
• Created KPIs, calculated members, Named Sets by using SSAS.
• Used MDX queries to Defined sets, member sets & creating calculated members, Named sets in Analysis Services.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Formatted reports using Global Variables & Expressions.
• Created Data Models in Power Pivot for end user reporting purpose.
• Created Drill down & Drill Through reports using SSRS.
• Created Dashboards using Power BI for core business decisions.
• Designed Highly Parameter driven reports using SSRS.
• Migrated SSRS Reports & SSIS Packages from SQL2005 to SQL2012
• Used SQL Server Profiler to trace out stored procedure calls of slow running SSRS reports and do Performance tuning.
• Supported users to fix issues related to reports &cubes.
• Actively involved in daily scrum meeting for status updates.

Environment: SQL Server 2014/20112/2008 R2, T-SQL, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell.

Confidential, Jacksonville, FL

Sr. SQL Server BI Developer

Responsibilities:

• Involved in logical and physical data modeling, database design, star schema, data analysis.
• Analyzed teh specifications provided by teh client and gathered teh requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Developed logic for Incremental Loads ( new rows and modified rows )
• Migrated old data from legacy system into SQL Server 2008 using SSIS Packages
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
• Wrote lot of Stored Procedures and developed lot of SSIS Packages in DW environment. Responsible for ETL jobs scheduled to run and daily DW load
• Created and configured various SSIS packages for optimal performance by studying teh parallelism, buffer sizing and design approaches.
• Created partitions and aggregated cube for better performance.
• Processed cube to perform incremental updates.
• Created Data Models in Power Pivot for end user reporting purpose.
• Built MDX queries for Analysis Services (SSAS) & Reporting Services (SSRS).
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to teh Document Library of SharePoint
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Created complex SSAS cubes with multiple fact measures groups, multiple dimension hierarchies and defined attribute relations based on teh OLAP reporting needs
• Built cube partitions using MOLAP, HOLAP,ROLAP methods for faster query performance and processing speed
• Designed reports using SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports

Environment: MS SQL Server 2008R2, Erwin, SSIS, SSRS, SSAS, Oracle 10g, SharePoint 2007, T-SQL, PL/SQL, MDX, Toad, Teradata, Informatica

Confidential, Bellevue, WA

SQL Server BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Analyzed client specifications and gathered requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Involved in performing database code and design reviews and worked with application code teams in developing, delivering and modifying database objects as per project requirements
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Designed and maintained complex stored Procedures using Joins and Sub queries and to retrieve data from multiple tables
• Designed and configured SSIS packages to migrate teh Customer Information, Contracts Information and other important data from teh Excel, Oracle, legacy System using various transformations.
• Created customized SSIS Packages using C# and VB Scripting.
• Scheduled and monitored teh SQL Server Agent jobs to run teh SSIS packages and stored procedures
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated reports using SQL Server Reporting Services 2005/2008R2 from OLTP and OLAP data sources.
• Prepared teh Layouts by placing teh fields to teh appropriate place according to teh requirement of teh final Report.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploy and schedule Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created reports by extracting data from cube.
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions.
• Created report snapshots and cache for better performance.
• Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers...
• Backup and Restore databases.
• Undergo unit testing and integration testing.
• Report bugs, fix assigned bugs and propose possible fixes through Visual Studio.
• Deploy databases to local and to other servers using Visual Studio 2010.
• Use 2010Team Foundation Server for project update and for status update.
• Used Codelook for code review and code update.
• Use ErWin to design schema, forward engineer to create and update scripts and make required changes
• Active participation in agile environment especially SCRUMS.

Environment: SQL Server 2005/2008/2008 R2, T-SQL, Windows server 2008, Octopus, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, PowerShell,Octopus.

Confidential, Redmond, WA

SQL Server BI Developer

Responsibilities:

• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and considers teh implications of business solutions to teh current and future environment.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using teh execution package
• Conducted data migration processes in teh SQL Server environment using SQL Server Integration Services
• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS2008)
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into teh Multi-dimensional data warehouse
• Developed adhoc reports without formal specifications often.
• Created and developed teh stored procedures, triggers, views, and user-defined functions to support application development, handle complex business rules, history data and audit analysis.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Created SQL Agent jobs to automate and schedule ETL Scripts & SSIS Packages.
• Cube designing using SSAS and creating ad-hoc reports.
• Worked closely with IT project managers, programmers, and testers in agile environment.
• Developed Custom ad-hoc, Tabular, Drill Down, and Parameterized, cascaded and sub-reports using SSRS 2008.

Environment: SQL Server 2005/2008/2008 R2, T-SQL, Windows 2003, Oracle, .net, VB, ASP, SQL Server Integration Services, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, Cosmos.

Confidential, Los Angeles, CA

BI Developer

Responsibilities:

• Develop, maintain, monitor, and performance tuning of teh data mart databases and SSAS OLAP cube(s)
• Created Star and Snow Flake Schemas of Data Marts.
• Developed a multi-dimensional database and OLAP cube using SQL server 2008.
• Designed fact and dimension tables, Created multi-dimensional OLAP Cubes.
• Build SSIS Master and child packages for initial load of data and incremental (monthly) loads of data for EDW.
• Manage teh ETL function and use of staging tables.
• Proactively diagnose, research, monitor for and resolves SQL and database-related faults and performance problems
• Develop and maintain appropriate repositories of data model and dataflow diagrams relating to teh data warehouse.
• Ensures that data projects follow prescribed agile development life cycle and meet quality standards
• Function as a technical expert in teh design, development, modification and debugging of data OLAP cubes and databases, etc.
• Develop ETL specifications, source to target mapping and other documentation required for ETL development.
• Ensure appropriate documentation is completed and stored in teh repository database.
• Built MDX queries for Analysis Services & Reporting Services.
• Intensively used SQL Server Integration Services to create teh extraction and loading process.
• Built Reports in SSRS for errors generated in SSIS Packages.
• Involved in teh development of custom stored procedures, functions, triggers, SQL, T-SQL.

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, SQL Profiler, Erwin, SQL Server Reporting services, TFS (Team Foundation Server), SQL Server Analysis Services, SAP BW, Visio, Share-Point.