SUMMARY

• Around 6+ years of experience in Business Intelligence (PowerBIdesktop,PowerBIdesktop Pro,PowerBIService,PowerBIreport server), and other related IT development technologies like MSBIStack (MS SQL Server, SSIS, SSAS, SSRS), and MS Excel Power Pivot. In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting, and Analytics.
• Working with PowerBI Service for creating Dashboards and sharing them with business users.
• Creating complex Custom Views using Toad and SQL Developer to create data sets for PowerBI dashboards.
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc., and creating interactive visuals using geographic data.
• Working withPowerBIService for creating Dashboards and sharing them with business users.
• Extensive experience with different phases of the project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications).
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration
• Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS), and reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Experience in Database Administration operations like Backup, Recovery, Replication, and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Experience in creating SQL Server Reports, handling sub-reports, and writing queries to perform roll-up and drill-down operations in SSRS 2012/2008S
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SSIS, Analysis (MDS), and Reporting Services (SSRS).
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS), and SSIS.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Worked with SQL Monitoring Services and Crystal Reports to handle enterprise-wide reporting needs.
• Worked with SQL Server Analysis Services before and knows how to write queries (SSAS).
• Designed and configured Data Source Views, Dimensions, Cubes, Measures, and Partitions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Languages: MySQL, PL/SQL, PostgreSQL, DAX, MDX, SnowSQL, R

Databases: MS SQL Server, MS Access, Oracle, PostgreSQL, Snowflake

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), Visual Studio 2017/2015/2012 , Crystal Reports, Tableau 9.0/10.3, Snowflake, Power BI Desktop, Power BI Service

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema Modeling, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques, RDBMS, OLTP, OLAP

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio 2017, BIML Express, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), PostgreSQL 9.0/9.1, SQL Server Data Tools (SSDT), Crystal Reports, Power Pivot, Microsoft Office, ALM, AWS

Operating Systems: Windows, Mac OS, Linux

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Worked with business users to analyze and translate business criteria into technical specifications.
• Used SSIS to design and execute ETL processes that included data collection from SQL Server 2016 sources.
• For Power BI, use the REST API to link to Elastic Search and retrieve millions of JSON documents. Data was extracted from REST Elastic search and SQL server using Composite models in Power BI.
• Operational Data Stores (ODS), Data Marts, and Decision Support Systems experience with Multidimensional Model (Kimball and Inmon) Star and Snowflake schema architecture (DSS).
• Created reports in Power BI desktop using the SSAS Tabular Model via Analysis connector.
• Created complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Created Rest ApI or third-party drivers to access Jira info. For my directors to use in analyzing the team's performance, I created graphics.
• Assist with requirement collection, collaborate with business users, and implement logical and physical modeling using Erwin.
• Collecting business data from different OLTP systems and loading it into a data warehouse using SQL Server Integration Services (SSIS).
• Developed numerous visualizations based on the conditions using Power BI (stacked bar charts, clustered bar charts, scatter charts, pie charts, donut charts, line & clustered column charts, map, slicer, time brush, and so on).
• Searched for required data source on Kusto, completed the Encryption Report by Datacenter design spec and the first draft of the report using Power BI desktop and Kusto explorer.
• Monitoring the data clouds using Netmon and page by adding the agent node and fabric procedure and using Kusto Explorer to analyze the event logs
• Based on business requirements, SSAS MDX scripts for KPIs and measured members were developed.
• Use SSIS to create ETL packages to extract data from open hub tables in order to create a successful data warehouse based on the star and snowflake schema database, which is used as an open source to create data analysis reports.
• Based on the requirements, I built Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI.
• Generated Detail reports in Power BI Pro using Drill through filters.
• Web clients and smartphone users also have access to Power BI Pro and Power BI Dashboards, and Power BI Reports are also available in the required originations.
• Crafted SSRS reports with sub reports, sentences, and questions and created ad-hoc reports using report designers.
• Maintained several Power BI dashboards, surveys, and content packs.
• You are solely responsible for the upkeep and implementation of scheduled launches.
• To get the updated Power BI Reports, I built a dashboard and a content pack for the originations. I have included the time it takes for each dashboard tile to reset.
• Dashboards and gauges were used to enhance the user interface for enterprise customers when integrating SSRS solutions.
• Generated Stored Procedures, Views, and Complex Queries in Kusto and SQL Server.
• Using Kusto Explorer, I created Kusto queries for use in Power BI Reports.
• Utilized IMPORT and EXPORT features in MS SQL to load data onto the data warehouse.
• Created Tabular Models usingDAXqueries in analysis services and deployed it.
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Updated and on boarded the columns from Sales force to SQL Server using SSIS Integration Services.

Environment: T-SQL, MS SQL Server 2017/2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), PL/SQL, PowerBI, Power BI Pro, AWS, Cloud, SOAP, REST, API, SharePoint, Open Source, Visual Studio 2016, MSSQLAzure, TFS, Unix/Linux, DAX, OLAP, OLAP, Scrum, XLST, XPATH

Confidential, Overland Park, Ks

SQL/Power BI Developer (SSIS/SSRS)

Responsibilities:

• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List, and Report Server data sources usingPowerBIService Desktop tool.
• Involved in database development using stored procedures, triggers, views, and cursors.
• Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision-making.
• Involved in creating MDX, DAX, Cubes, and Tabular models using SQL Analysis Services (SSAS).
• Wrote efficient Stored Procedures for the Optimal Performance of the system.
• Implemented projects using Agile Methodology.
• Involved in designing and publishing visually rich and intuitivePowerBIdashboards.
• EmbeddedPowerBIreports on the SharePoint portal page and managed access of reports and data for individual users using Roles.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using the UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer, and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.
• Responsible to monitor performance and optimize SQL queries for maximizing efficiency.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment, and user training of analytical and transactional reporting systems.
• Used stored procedures, created new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance
• Generated dashboards inPOWERBIDesktop andPOWERBIService using super-fast slice and dice and modern data visualization features.
• Designed and developed a new ETL/SSIS package that loads data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Developed reports using Tableau and QlikView.
• Plan and scheduled the report to run at the desired frequency in Cognos Scheduler and scheduled the cubes to run on ETL job completion dependency using the Auto sys tool.
• The designed dimensional data model of the OLAP database using Erwin.
• AutomatedPowerQuery refresh usingpowershell script and windows task scheduler.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• UsedPowerBIDesktop to develop data analysis multiple data sources to visualize the reports.
• Responsible for creating and changing the data visualizations inPowerBIreports and Dashboards on client requests.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from the Tabular Model.

Environment: Advanced SQL, MS SQL Server 2014/2016, Notes,SSRS, SSIS, SSAS, Power BI, TFS, T-SQL, DAX, Power BI Desktop, MDX, JIRA, Tableau, Microsoft Visual Studio 2015, Excel, Azure

Confidential, Illinois, Chicago

Power BI Developer

Responsibilities:

• Gather the Business Requirements and develop the business logic to analyse the various scenarios and test results.
• Determine the severity, priority and the longevity of different test and the outcomes.
• Developed Power BI dashboards with consistent and formalized development standards by translating the business requirements into meaningful visuals.
• Interacted with business and end users to gather business requirements through MS Teams meetings.
• Implemented dashboards on top of reporting tools using Power BI to provide detailed utility usage, metrics and KPIs.
• Created DAX syntaxes to leverage the complex data needed for business and operational analysis activities.
• Optimized dashboard performance by effectively handling the data transformations in Power Query and by fine tuning the SQL queries.
• Implemented row level data security and scheduled reports based on power user request.
• Created tabular models using Azure Analysis Service and built Power BI reports on top of those models.
• Segregated report visuals based on user needs and enabled the business intelligence to make key decisions.
• Modelled visuals to present high level statistics on first layer and provided more insights through drilldown and drill through features.
• Created dashboard to eliminate the manual efforts in transforming and analysing the incident management data.
• Developed overall project technical design and built custom elements of a project.
• Integrated Power BI Visuals into Power BI Apps.
• Eliminated the workload during data refresh through optimized data transformation.
• Created SQL views/tables, functions and stored procedures across variety of data including data in EDW.
• Extracted data from SAP ISU and EDW systems for reporting.
• Have good end to end experience in both Power BI development and admin related activities.
• Managed Power BI Gateways, access controls, and capacity and tenant settings.
• Designed an interface to generate Public Safety Power Shutdown notifications for customers.
• Created Hana data models, calculation views to combine data from various source systems and generated structured flat file for third party.
• Developed Web I reporting on business requirements based on Device & Fields and Case Management transactional and master data.
• Worked in collaboration with leadership team to define project goals and establish a timeline and plan to achieve those goals.
• Collaborated with cross-functional teams to complete the project tasks in a timely and effective manner.
• Created project documentation for milestone closures and status tracking templates for various activities.
• Worked closely with business to understand the demand and priority of each key task.
• Involved with ETL team on transformation logic in the ELT (Azure) and migrating the SSIS packages to Azure Data factory (V2).

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, SQL Developer, SSMS, SQL Azure, Azure storage, and Azure Data Factory, SAP Hana, SAP BOBJ

Confidential

SQL/BI Developer

Responsibilities:

• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and to develop different SSIS packages.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Used Batch Files to Import Data from another Data Base.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created SSIS packages to retrieve data from Legacy sources and to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Integrate SQL Server 2005 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: SQLServer 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, XML, Visual Studio 2008 & 2005, MS Visio 2007.

Confidential

SQL Developer

Responsibilities:

• Extensive participation in logical and physical database design and normalizing the database to accommodate possible changes in OLTP & created data flow diagrams and enforced all referential integrity constraints.
• Created Stored Procedures and functions.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
• Created new database objects like tables, synonyms, Packages, Triggers, Indexes and Views using T-SQL in Development, Test and Production environment for SQL Server.
• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Created SSIS packages for transferring the data from different systems such as SQL/Oracle server, Flat Files, CSV Files and xml files.
• Involved in Job scheduling and alerts.

Environment: Microsoft SQL Server, Business Intelligence Development Studio (BIDS) 2008, SSIS, SSRS, Windows Server.