PROFESSIONAL SUMMARY:

• Over all 8+ Years of IT experience working in MS Business Intelligence products, SQL Server, Microsoft
• Good experience in developing solutions using Microsoft BI technologies like SSAS, Azure Analysis Services, SSRS, SSIS, Power BI Cloud and Power BI report Server. Expertise in creating visualizations and reports using Power BI.
• Expertise in creating multiple kinds of Power BI Reports and Dashboards.
• Involved in the analysis, design, development, and testing phases of software development life cycle (SDLC).
• Used analytical thinking to translate data into informative visuals and reports, dashboards, and KPI scorecards.
• Connected to data sources, importing data, and transforming data for business reporting.
• Building interactive dashboards to help the key stakeholders self - serve and introduce advanced analytics.
• Proficiency with SQL and M language.
• Making complex DAX queries in Power BI desktop.
• Power BI Service - workspaces, apps, security.
• Coordinated with Business Analysts and customers to develop business requirements and specifications documents.
• Developed standard reports and functional dashboards based on business requirements.
• Maintained business intelligence models to design, develop, and generate standard and ad-hoc reports.
• Generated reports for internal and external customers for business performance monitoring and business decision-making.
• Experience in Designing Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries following Star and Snowflake schema) using SQL Server Analysis Services (SSAS).
• Experience in designing tabular models (Measures, DAX Queries, 1200, 1400 and 1500 compatibility levels) using Azure Analysis Services and SQL Server Analysis Services Tabular mode.
• Have a very good understanding of Multi-Dimensional and Tabular architecture and Internals of formulae and storage engines.
• Have administrative experiencing in configuring scale-out environments, deployments, capacity planning and troubleshooting complex performance issues.
• Experience in designing paginated reports and Power BI reports using Reporting Services and Power BI Report Server.
• Have very good understanding on Reporting Services Architecture and working experience in Report Scheduling, Schedule refreshes, programmatic access of reporting services web service.
• Experience in developing Power BI Datasets and Reports (Import mode and Direct Query mode) using Power BI Desktop and managing schedule refreshes for Import mode reports).
• Experience in developing SSIS packages and have a very good understanding of different control flow tasks and data flow transformations.
• Good understanding of working with Power Query inside the Power BI Desktop when it comes to transforming the data retrieved from multiple data sources.

TECHNICAL SKILLS:

Reporting Services: Excel, Power BI, Business Objects, Crystal Reports, Quick view

Languages: T-SQL, PL/SQL, SQL, HTML, XML, Java Script

Development Tools: Microsoft Visio, UML, Miro, Eclipse, Visual studio code

Scripting Languages: Java Script, HTML, CSS, Angular JS

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

MSBI Developer

Responsibilities:

• Collaborate with senior management, subject matter experts, and IT teams to define reporting requirements.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Involve in data mapping sessions to identify data sources and created source codes in SQL server to feed the data visualizations in Power BI.
• Analyze business data in databases to identify patterns and correlation among various data points by writing extensive SQL queries and facilitated in creating data models.
• Automating the database maintenance tasks by creating Jobs through SQL server agent.
• Utilize Power BI to create various analytical dashboards that depict critical internal KPIs such as billing accounts receivable and payable, customer retention and, vouchering with slicers and dicers enabling end-user to make filters for sales, marketing, finance including top executives.
• Expertise in writing complex DAX functions, measures, calculated columns, aggregations in Power BI
• Scheduling tasks on windows task scheduler to run the Python scripts to generate reports for a frequent interval of times and send email alerts.
• Work on various IDEs (Integrated Development Environments) like VS Code and Eclipse.
• Implement CRUD (Create Read Update Delete) operations for the applications using the MVT (Model View Template) architecture of the Django framework.
• Design, developed, and Implemented code in Python to retrieve and manipulate data.
• Create Workspace and content packs for business users of a cross-functional team to view reports and scheduled automatic refresh to show up-to-date data.
• Design complex data-intensive reports in Power BI utilizing various graph features such as gauge, funnel, line & bar graphs.
• Create Row-level security so based on role, the end-user can view the data. Analyzing reporting requirements and developing various Dashboards, using trend lines and lines

Environment: SQL Server 2016, SQL Server Management Studio, MS Excel, T-SQL, Microsoft Visual Studio, SQL Server Agent, SQL profiler, Tabular modeling, Cubes

Confidential, Chevy Chase, MD

Power BI Developer

Responsibilities:

• Involve in creating an infographic (roadmap) report in Power BI.
• Involve in preparing and cleansing the data.
• Creating wireframes and sharing them with the business for approval.
• Creating the Calculated columns and measures with the use of DAX Expressions.
• Interacting with Client to get requirements.
• Involve in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plots, Mapping Visualization, etc. with Power BI
• Access and used various Custom Visuals available in Power BI
• Sharing of Power BI reports
• Access various data sources to pull data for reporting and analysis
• Involve in developing dashboards that are used by the HR analytics team to analyze various metrics related to the HR domain.

Environment: Microsoft SQL Server 2017, Microsoft Excel, Microsoft Office, MS Visual Studio 2017, Power BI

Confidential

MSBI / Power BI Developer

Responsibilities:

• Import data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Create DAX Queries to generate Calculated columns & measures in Power BI.
• Generate Calculated tables in Power BI by using DAX.
• Create Azure Blog Storage for Import/Export data to/from .CSV File.
• Use Power BI Power Pivot to develop data analysis proto type, and used Power View and Power Map to visualize reports.
• Publish Power BI Reports in the required work spaces and made Power BI Dash boards available in Web clients and Power BI Apps.
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Use Power BI Gate ways to keep the dash boards and reports up to date.
• Install and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Publish reports and dashboards using Power BI.
• Assists in the development of the IT Department’s policies and procedures and recommends to management suggestions for improvement
• Work with developers to get projects developed and implemented
• Assist with activities of system design, implementation, administration and network management.

Environment: ASP.NET, SharePoint 2010, C#, XSL, jQuery, SQL Server 2008, IIS 7.0 and Windows Server 2008.

Confidential

MSBI / Power BI Developer

Responsibilities:

• Experience in working on version control systems like Subversion, and GIT.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Use Power Query to acquire data and Power BI desktop for designing rich visuals.
• Extract, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks, and transformations provided by SSIS.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• AutomatePowerQuery refresh usingpowershell script and windows task scheduler.
• Install and configured Enterprise gateway and Personal gateway in Power bi service.
• Schedule Automatic refresh and scheduling refresh in power bi service.
• Utilize Power BI (Power View) to create various analytical dashboards that depict critical KPIs such as legal case matter, billing hours, and case proceedings along with slicers and dicers enabling end-user to make filters.
• Utilize Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implement several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilize Power BI gateway to keep dashboards and reports up-to-date with on-premise data sources.
• Create, Maintained & scheduled various reports in Power BI
• Monitor scheduled jobs to ensure process stability. Creating Dashboards reports.
• Identify different types of relevant data to improve business performance.
• Use data to create charts and reports highlighting different findings. Compiled and sorted information to prepare source data for computer entry.
• Leverage data to recommend business process improvements and methods for increasing profitability.
• Create new report types to more quickly identify important issues, trends, and business opportunities.
• Create customized data reporting templates based on specific customer needs, incorporating optional variables to expand re-usability potential.
• Leverage information from industry reports, public databases, and other sources to understand and evaluate trends.
• Apply analytical tools and methods to inform business decision-making processes. Collected and analyzed information from multiple sources for company financial performance, customer insights, competitor profiling, potential product expansion, and industry trends.
• Coordinate and controlled the flow of business intelligence data between sources and end-users.
• Use Python scripts to update content in the database and manipulate files.
• Design technical documentation to guide the accurate development of new intelligence gathering and reporting solutions.

Environment: Microsoft SQL Server 2017, Microsoft Excel, Microsoft Office, MS Visual Studio 2017, Power BI

Confidential

SQL / MSBI Developer

Responsibilities:

• Interact with the technical team and business users to perform analysis of business requirements and transformed them into technical requirements for ETL and reporting needs.
• Formulate and documented ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.
• Integrate data coming from multiple sources into Power Pivot and create calculated fields. Developed a large information dataset by leveraging data science methodologies, which were directly used by the company to complete property acquisitions.
• Create a multiple date model which was used as a common data source for the reporting purpose.
• Publish Power BI Reports in the required originations and created Power BI dashboards available to web clients.
• Use DAX functions such as FILTER, ALL, VALUES, DISTINCT to source data. Created row-level security based on role, so end-user can view the data. Produced various views, calculated tables, columns, and measures.

Environment: Microsoft SQL Server 2017, Microsoft Excel, Microsoft Office, MS Visual Studio 2017, Power BI

Confidential

SQL / MSBI Developer

Responsibilities:

• Extract data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Design ETL packages for different data sources (Excel, SQL Server, and Flat Files). Created indexes for the fast retrieval of data from the database.
• Design and developed SSIS packages, stored procedures, configuration files, tables, views, functions and implement best practices to maintain optimal performance.
• Create logical multi-dimensional models and studied relationships among the logical objects moving between Development, Staging, Pre-Production and Production.
• Objects moving between Development, Staging, Pre-Production and Production.
• Enforce referential integrity via creation of constraints on database objects.
• Populated user databases in SQL Server via DTS utility.
• Work on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Maintain SQL Script for creation of Database Objects.
• Monitor, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Use SQL Server Profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script. Used SQL Profiler for tracking execution tie of T-SQL Statements.

Environment: Microsoft SQL Server 2012, Microsoft Excel, Microsoft Office, MS Visual Studio 2012, TFS.