SUMMARY

• 8 years of IT experience as a BI developer working with Microsoft BI Tools Power BI/SSIS/SSRS/SSAS and T - SQL using SQL Server 2005/2008R2/2012 in Telecom industry.
• Experience in creating Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Excellent experience in writing T-SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Good Experience in using Microsoft BI studio for implementation of ETL methodology.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Proficient in building dashboards, drill through, drilldown, Graph, Chart, cascading parameterized, and matrix reports for analytical and transactional data using SSRS2005,2008,2008R2,2012.
• Wrote parameterized queries for generating reports in SSRS 2012/2008.
• Excellent knowledge on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent
• Excellent Experience in installing, upgrading and configuring Microsoft SQL Server 2012/2008R2/2008/2005 and with 24/7 standby troubleshooting support.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2012/2014.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS

Reporting Tools: Power BI, SSRS

Programming: T-SQL

Operating Systems: Windows 7/Vista/XP/2008/2003, UNIX

Application Packages: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Power BI Developer/ Analyst

Responsibilities:

• Design, implement, deploy and maintain the ETL process and data flow, including data quality and unit testing.
• Imported data from SQL Server DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Responsible for building reports in Power BI from the Scratch.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Perform thorough unit testing on all relevant platforms to ensure proper implementation.

Environment: Power BI, Power BI Pro, Power BI Desktop, Power BI Gateway, SQL SERVER 2014/2017, SSMS, SSDT, SSIS, SharePoint, Microsoft Office, Visio, Outlook, Skype for Business.

Confidential, Jefferson Valley, NY

Power BI Consultant

Responsibilities:

• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Developed Power BI reports using query logic based on business rules, and visuals selected by Clients.
• Used R language in the Power BI Desktop Query Editor to perform data cleansing and data shaping.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Built Ad-Hoc reports in Power BI depending on business requirements was one of the major responsibilities.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Provided maintenance and development of bug fixes for the existing and new Power BI Reports.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Worked with DAX queries in building expressions for various business calculations.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.

Environment: Power BI, Power BI (Pro), Power BI Service, MS SQL Server 2012/2014, Management Studio (SSMS), T-SQL, Oracle, MS SQL Server Reporting Services 2012(SSRS), Excel 2012.

Confidential, Bowie, MD

Power BI Developer

Responsibilities:

• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, CSV.
• Developed Power BI reports using query logic based on business rules, and visuals selected by Clients.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Provided maintenance and development of bug fixes for the existing and new Power BI Reports.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Write complex T-SQL code and stored procedures to be utilized by applications, ETL and reports.
• Administer production databases and processes including maintenance related tasks and activities.
• Troubleshoot existing BI solutions including ETL, cube processing and reporting errors.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Design SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Environment: Power BI, Power BI (Pro), Power BI Service, Power BI Apps, MS SQL Server 2012, Management Studio (SSMS), T-SQL, Oracle, MS SQL Server Reporting Services 2012(SSRS), Excel 2012.

Confidential

MSBI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Transferred the data using SSIS packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Environment: MS SQL Server 2008/2012 Enterprise Edition, Business Intelligence Development Studio (BIDS), MS SQL Server Integration Services, MS SQL Server Reporting Services.

Confidential

SQL Developer

Responsibilities:

• Successfully installed and configured MS SQL Server 2005 on the production server.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2000, and SQL 2005).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Used Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all in transformation of SSIS Packages.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Responsible for transferring the data using SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using control flow tools and dataflow tools and then verify it.
• Developed, monitored and deployed SSIS packages.
• Monitored scheduled jobs and alerts.
• Created SQL Server Reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.
• Designed drilldown, drill through, and parameterized report using SSRS.

Environment: MS SQL Server 2005/2008, Business Intelligence Development Studio (BIDS), MS SQL Server Integration Services, MS SQL Server Reporting Services.