SUMMARY

• Solutions focused, meticulous and result oriented SQL Developer, Power BI Developer with 5 years of successful career in IT arena distinguished by commended performance and proven results.
• Expertise in gathering functional specification requirements for the development of dashboards and reports using Power BI and SSRS.
• Expert in using Power BI to connect, model, and explore the data with visual reports which could collaborate, publish, and share.
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Manage roles and impart Row level security to Power BI reports.
• Experience in developing reports in Power BI using Direct Query mode, Import and Live Connection mode to get data from different data sources like Azure SQL Server, SSAS Tabular, CSV and other sources.
• Used M language in the Query Editor to transform data before loading into Data Model.
• Used DAX Functions for filtering and creating calculated columns and measures in the Data View.
• Design and develop the reports in Power BI using Report View.
• Connect and query Azure SQL Server data source to shape and refine the data to build customized reports in Power BI.
• Expert in using Power BI Enterprise editions like Power BI Pro and Power BI Premium and setting up Security features using Power BI Service.
• Gather the requirement from the user and develop and deliver the project.
• Expert in developing reports Power BI Desktop, Power BI Service and share through mobile App, website, Power BI Service and Embedded.
• Expert in modeling data, creating measures, calculated columns partitions, hierarchies, and KIPs in SSAS Tabular Model to ensure the data scalability.
• Good knowledge of Power BI Service (SaaS) and the Power BI Embedded service in Azure (PaaS) have APIs for embedding dashboards and reports.
• Developed KPIs, monitor key organizational and operational measures and provide visibility of performance throughout the organization.
• Experience in gap analysis, root cause analysis to understand the service gaps to regain the service recovery and operational excellence.
• Experience in data mining techniques using Python in normalizing data, evaluating classifiers through and test data sets, implementation of kNN algorithm, Panda’s Library, 10 - fold cross-validation, Nearest Neighbor concepts understand the trends and patterns.
• Experience in data modeling for the data warehouse.
• Experience using Microsoft SQL Server to model data into datasets for consumption of various business intelligence software.
• Hands on experience in creating Indexed Views, Stored Procedures, Functions, Triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.
• Experience with data security and privacy by anonymizing datasets in Reports and Data set level.
• Excellent knowledge in SSIS, SSAS, SSRS and performance tuning and query optimization.
• Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.
• Excellent knowledge in developing various Business Intelligent Active reports
• Experienced in fast face Agile-Scrum work environments, strictly adhere to schedules and meet deadlines.
• Experience in all aspects of the project from requirements through development, planning, business analysis, execution, monitoring, scheduling, and estimation of medium to large sized projects involving complex business solutions. Excellent interpersonal, communication and organizational skills with proven abilities in team management and planning.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, Java, HTML, Python, C# and M

OS: UNIX, Linux, Windows 9x/NT/XP/2000/Vista, OS/2, DOS

Databases: MS SQL Server, MS Access, Azure, MS SQL

Tools: Power BI, SSRS, SSAS and SSIS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Create and maintain workspaces and App Spaces.
• Develop documentations for developers and self- service BI users.
• Create proof of concept in page level, and dynamic Row Level Security
• Implement incremental refresh in the reports.
• Create usage metrics report using Power BI Audit data from Power BI tenant.
• Help self-service BI users to resolve technical issues, provide guidelines.
• Gather requirements from the end user with Business Analyst.
• Work with various data sources like SQL Server, Files from SharePoint and O 365 to develop Power BI report.
• Publish developed reports in the Power BI Workspace, App, and Microsoft Teams.
• Set refresh and maintain developed Power BI report.
• Conduct /demo to the end user on Power BI.
• Gather requirements from the business user, document it to develop BI reports.
• Query the data model, create Calculated Columns and Measures by using M language and DAX Functions to in corporate logics in the Power BI data sets.
• Connect various data sources like Mongo DB, SQL Server, SAP Hana, AAS, ADW, SSAS Flat files, Excel, CSV, etc. using import, direct query or live connect mode to Power BI Desktop.
• Develop reports in the Power BI Desktop and collaborate in the My Workspace or App Workspace to share with team members.
• Develop Power BI reports using streaming data.
• Evaluated business insights predictions using R and Python in BI reports.
• Validate the reports in the Development, QA, UAT and Production environments.
• Pin dashboard and reports in the Power BI Service.
• Define Row Level Security from Power BI Desktop and publish the report to Power BI Service.
• Assign the defined security on reports, dashboards, and data sets from Power BI Service.
• Configure the data sources in the On-premises Data Gateway.
• Share the reports, dashboards, and data sets with the business user and stakeholders.
• Impose usage controls on data set and reports by using Admin Portal from Power BI Service.
• Document data model and reports for the future .
• Demonstrate the BI reports and model with business users.
• Conduct sessions to share the technical knowledge with the team members.
• Develop KPI’s, Partitions and Perspectives as per the report requirements in the SSAS/AAS Tabular model.
• Design data warehouse architecture in Azure Database to load data from various data sources, which is used for Business Intelligent (BI) reporting.
• Create a logical and physical model of the data and design relationships by creating Star, Snowflake or Hybrid schemas in the Azure Data warehouse (ADW).
• Query SQL Server database to filter and profile and data from various tables to understand the business insights and analyze and profile the data.
• Use Data Flow tasks in Azure Data Factory (ADF) to extract, transform and load data to the staging ADW.
• Migrate SQL Server Integration Services (SSIS) packages to ADF by using Lift and Shift method.
• Use SQL to analyze and collect the sample data to understand the scope of reports.
• Develop data model in SQL Server Analysis Services (SSAS) to ensure the data scalability and to optimize performance of BI reports.
• Create Azure Analysis Services (AAS) model from ADW and Data Lake to use it in the Power BI Reports.
• Implement the data security in the SSAS and AAS models.

Environment: Power BI,SQL Server 2016, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

• DevelopedPowerBImodel used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatedPowerQuery refresh usingpowershell script and windows task scheduler.
• Used various sources to pull data intoPower BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Database creation(DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively usedJoins and Sub-Queriesto simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report usingPivot/Un pivotinT-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables,Stored Procedures, Views,Indexes, User-defined Functions, andTriggersas required.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration usingSSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Creating data blending in case of merging two different datasets usingTableau
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to useClusteredandNon-Clustered Indexesfor significant performance boost using index tuning wizard.
• CreatedSSISpackages to import data fromAccess,Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data usingDerived column, Lookups, Fuzzy Lookups,Conditional split.
• DesignedSSISpackages to import and transform data between databases and external data sources using various transformations likeData conversion,File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning onSlowly running SSIS Packages.
• Configure and maintain usingReport ManagerandReport ServerforSSRS,DeployedandScheduledthe Reports inReport Manager
• Created Reports usingCharts,Gauges,Tables,matrix.
• CreatedParameterized Report,Dashboard Report,Linked reportandSub Report by Year, Quarter, Month, and Week.
• CreatedDrill Down Reports, Drill Through Reportby Region.

Environment: Power BI,SQL Server 2016, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler