SUMMARY

• Microsoft Certified Business Intelligence Developer with 8+ years of work experience in developing Business Intelligence solutions in an agile environment.
• Extensive experience in using the Microsoft BI Stack (SSRS, SSIS, SSAS, SQL, and Power BI). Worked with SQL Server 2008/2012/2014/2016.
• Experienced in Microsoft Power BI Suite (Power Query, Power Pivot, Power BI Service and Power BI Desktop), Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.
• Excellent DAX skills with the ability to create and troubleshoot complex calculations and measures.
• Excellent back - end skills in creating SQL objects such as Tables, Complex Stored Procedures, User-defined Functions, Views, Indexes, Triggers, Rules, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Experienced in creating custom visualizations and developing Power BI Dashboards in to rich look
• Experienced in creating complex SSIS packages for ETL purposes. Performed data migration from various type of sources (Excel, Flat File, CSV, XML, OLTP DB, ERP System, Access DB and Hadoop, Oracle DB, Azure SQL DB etc), with Data Conversions, Data Extraction/Transformation/Loading (ETL).
• Experienced in designing and developing a considerable number of reports and dashboards using Microsoft SQL Server Reporting Services (SSRS). Proficient in developing Drill-through and Drill-down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports
• Experienced in creating data driven subscriptions to render and share the SSRS reports in different format automatically.
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery, and Report security.
• Good understanding of Data warehouse, Dimensional modelling, Data marts, Operational Data Store (ODS), OLAP, Star Schema, Snowflake Schema and Fact and Dimension tables concepts.
• Exposure to other Business Intelligence tools like Qlik Sense, Tableau and IBM Cognos.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets
• Experienced working with data architects, data analysts, data scientists and a variety of end users to ensure technical compatibility and user satisfaction.
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.

TECHNICAL SKILLS

Programming: SQL, R, Python, DAX, Hive, JavaScript, VB, C#

Databases: SQL Server, Oracle, Hadoop HDFS, Azure Synapse Analytics, Azure Cosmos DB, Amazon Redshift (AWS)

Reporting Tools: Power BI, SSRS, SSAS, Tableau, Cognos 8/10, Qlik Sense, Excel

ETL Tools: SSIS, Informatica, Data Factory

Tools: /Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall, Data Transformation services

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

MSBI/Power BI Developer

Responsibilities:

• Worked on supporting and maintaining risk score BI application by coordinating, mentoring, analysing and loading data, scheduling and publishing reports in SSRS and SharePoint.
• Designed, developed and deployed SSRS reports that included Parameterized reports, Snapshot reports, Cached reports, Drill-down reports, Drill-through reports, Linked reports, Click-through reports, and Sub reports.
• Created complex Stored Procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Rendered reports in different formats like PDF, Excel, etc. to be executed automatically on a weekly or monthly basis and managed subscriptions.
• Created Power BI interactive reports using visualizations such as score cards, area charts, maps, and scatter plots to generate insights
• Involved in the creation of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculation and transformations using Query Editor and Power Query Formula Language (M).
• Developed calculated measures for the KPI report object visuals.
• Implemented Power BI interactive dashboards-style reports utilizing slicer filters, Drill-down hierarchies, and images.
• Conducted Training sessions for Power BI users and created the documents for end user support.
• Developed and maintained complex SQL queries using joins, sub queries and correlated sub queries. Developed complex Stored Procedures and user-defined functions.
• Published reports and dashboards using Power BI.
• Analysing reports from different technologies and preparing document to track information about implementation feasibility of reports.
• Exposure to Business Analyst activities: Involved in the requirements gathering planning and implementation process of small to medium projects. Participated in the creation and review of the Business Requirements Document.

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

Confidential, Fort worth, TX

BUSINESS INTELLIGENCE DEVELOPER

Responsibilities:

• Worked in writing complex SQL Queries to extract data from the different sources for reports.
• Worked on creating ad hoc reports requested by different departments of the City.
• Worked on creating SSRS reports from Buy Speed application
• Worked on creating near real-time dashboard reports for CFO using SQL Server Report Server (SSRS), to show the status of purchase orders, opening, closing and depending with the drill down features of all the department of Confidential .
• Worked creating user guide documents for the reports and provided overview training of report and the process.
• Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse and Data mart databases.
• Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Worked on migration process from IBM Mars system application to PeopleSoft ERP System.
• Worked upgrading SQL Server Reporting services .
• Involved in data analysis, comparison and validation.
• Worked with stake holders and internal business users, to prioritize and finalize requirements.

Environment: MS SQL Server 2008, SSAS 2008, SSRS 2008, SSIS 2008, T-SQL, Visual studio 2008, DTS, Data Analyser, MS Access, Word, Excel, SQL Profiler, Windows XP, Erwin v4.2, Version One

Confidential, Dallas, TX

SQL SERVER/ MSBI DEVELOPER

Responsibilities:

• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports
• Created SQL Server SSIS Packages to extract data from various data sources from excel spreadsheet, and flat files into SQL Server.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Created Drill down and drill through reports in SSRS.
• Created Data flow process and created Data dictionary document with source, staging and destination columns mapping in Excel, interacting with DBAs, and database owners.
• Created SSIS packages to import data from MS Access, Excel to SQL 2008R2
• Developed and created the new database objects including tables, views, indexes, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer
• Worked on complex data loading (implemented the batch data cleansing and data loading

Environment: Ms SQL Server, SSAS, SSIS, SSRS 2005/2008,, Oracle 9i, ETL, DTS, Data Modelling, Visual Studio 2008 & 2005, SQL, T-SQL, Ms Excel, XML

Confidential, Fort Worth, TX

SQL SERVER/ MSBI DEVELOPER

Responsibilities:

• Used Ad-Hoc queries to generate Reports using SSRS to meet ad-hoc requests from different client’s needs.
• Wrote complex T-SQL queries/Views to match data which came from different sources.
• Implemented complex business logics to fulfill the reporting requirements of the business using complex T-SQL stored procedures and Views.
• Scheduled a job to run the whole process of getting the zipped files from the FTP site and then unzipping, staging, transforming and finally inserting into to the reporting DW tables.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Reduced the T-SQL overhead successfully by avoiding unnecessary joins, wildcard syntax, to optimize the query performance.
• Used SSIS script task to look for the .done files in the FTP site and to start the job to load the data in the cloud.

Environment: Ms SQL Server, SSAS, SSIS, SSRS 2005/2008,, Oracle 9i, ETL, DTS, Data Modelling, Visual Studio 2008 & 2005, SQL, T-SQL, Ms Excel, XML