Nabeel Ahmed adzce2@r.postjobfree.com 914-***-****

SUMMARY:

• Having 8+ years of IT experience as a Microsoft BI/SQL implementing SSIS, SSRS, and Power BI.

• Experience in publishing Power BI Desktop reports on dashboards in Power BI server and in designing and developing Power BI graphical and visualization solutions based on business.

• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.

• Expert in Data Modeling and Multi-Dimensional Modeling.

• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling, and data modeling for Data warehouse.

• Extensive experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform, and Load (ETL) solutions for Data warehousing applications.

• Experience in publishing Power BI reports on dashboards in the Power BI server and Power BI Mobile App.

• Proficient in creating SQL Server reports, handling sub-reports, and defining queries for generating drill-down reports using SSRS.

• Experience in developing BI applications utilizing SSRS, Power BI, Tableau

• Experience with data analysis, data modeling, and data presentation and importing data from SQL Server, Oracle DB, and API to Power BI/Tableau to generate reports.

• Expertise in Power BI, Power BI Pro, Power BI Premium, and Tableau.

• Excellent knowledge of Power Query Parameters, Query Lists, Tables, and Records and expertise in Cleansing and Transforming data with Power Query Editor.

• Experience in adjusting cross filter direction for a complex set of tables and relationships.

• Hands-on experience in utilizing DAX functions and measures and implementing several DAX functions, which include Aggregation, Counting, Logical, and date functions for efficient data visualization.

• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and power map to visualize reports.

• Strong experience in creating advanced chart types, and complex calculations to manipulate the data as per business needs through Power BI.

• Developed dashboard visualizations and complex reports, which involves custom controls and custom expressions using bars, lines and pies, maps, and scatter plots.

• Published Power BI reports from Power BI Desktop to Power BI service in the required originations and made Power BI dashboards available in web clients and scheduled automatic refresh in Power BI Service.

• Followed Power BI/Tableau best practices to improve the performance and security of enterprise-grade Power BI & Tableau implementations.

• Have good experience working on Azure services.

• Publishing Power BI Desktop reports created in Report view to the Power BI service.

• Experience in Optimizing Cubes using SQL Server Analysis Services (SSAS).

• Strong in database creation, maintenance, monitoring, backups, and recoveries using SQL Server Agent, Import/Export Wizard, and Maintenance Plans.

• Advanced reporting skills using SQL Server reporting services (SSRS). Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.

• Transform data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS), and SQL Server Integration Services (SSIS).

• Proficient in designing ETL packages using the methods for slowly changing dimensions type 1, 2.

• Strong in Designing and developing ETL and Data Quality mappings to load and transform data from source to DWH using SSIS.

• Exploring App Exchange applications and integrating them with Salesforce.

• Hands-on experience in utilizing DAX functions which include Aggregation, Counting, Logical, information, Text, and date functions.

• Proficient in gathering Business Requirements from business stakeholders, analyzing and documenting System Requirement specifications, Functional Requirements specifications, and maintaining.

• An exceptional leader with excellent interpersonal skills, communication finesse, and Team management skills with strong expertise in analyzing the requirements and preparing the specifications document based on the requirements.

EDUCATION:

Bachelors from Vasavi College of Engineering, Hyderabad, India.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET, VB.Net

BI Tools: Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Power Apps, Power Automation, Microsoft Power BI Desktop, Power BI Service, Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Reporting Services (SSRS), SQL Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio (2012/2014/2016/2017), Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2014/2012/2008/2005/2000), MS Access, MS Excel, Crystal Reports, Tableau Desktop, PowerBI

Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), and Azure SQL Data.

Version Control: Team Foundation Server, Git.

Databases: MS SQL Server 2012/2008/2005/2000, MS Access, Oracle 11g/10g/9i

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012/2016 Servers, HP-Unix, Linux, Solaris.

PROFESSIONAL EXPERIENCE:

Senior POWER BI Developer Newell Brands, NY, Remote Jan 22 to Present

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment.

• Created various dashboards in the Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, and database links and formatted the results into reports, and kept logs.

• Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.

• Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.

• Designed and developed stored procedures, queries, and views necessary to support the SSRS reports.

• Created various Drill through, Parameterized, Tabular reports and matrix reports using SSRS and created subscriptions for users.

• Designed and developed Power BI reports, self-service packages, and dashboards for a large pool of business associates.

• Designed and developed operational reports using MS Power BI Desktop for various regional managers and also created calculated measures and columns with DAX.

• Participated in the Agile methodology's daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt-down charts etc. to meet the daily deliverables and timelines.

• Used Power Apps visuals in Power BI desktop.

• Worked with canvas apps in Power App.

• Worked on all types of transformations that are available in the Power bi query editor.

• Created stored procedures and SQL queries to pull data into the power pivot model.

• Designing and Developing the Dashboard Reports in Power BI using DAX.

• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.

• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.

• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.

• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell, and Kimball Methodology.

• Created Workspace and Apps in Power BI and gave access to End-users to Apps.

• Configured Gateway in the Power BI service and Implemented Data security (Row-level security) on Dataset and Reports in Power BI. Worked on Power BI, Power Pivot, and Power View to visualize reports.

• Developed Power BI reports and dashboards for multiple data sources using data blending.

• Written calculated columns, DAX, MDX, and Measures queries in power bi desktop to show good data analysis techniques.

• Developed the reports in Power BI Desktop, publish the report, and pinned dashboards in the Power BI Service

• Created Drill Down, Drill Through, Book Marking, and Hyperlinks features in the Power BI report.

• Extensively worked in analyzing profiling and modeling data in the Power BI Desktop using Query Editor and Relationship View.

• Used Power Query to acquire data and Power BI desktop for designing rich visuals.

• Extensive Dashboard design using Power BI

• Developed Canvas Power Applications and Workflows using Power Automation.

• Publishing Power BI Desktop reports created in Report view to the Power BI service.

Environment: Microsoft Power BI, Power Query, Power BI Service, DAX, Microsoft Azure, ADF, Azure Data Factory, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob Windows server, SQL Profiler, SQL Query Analyzer, SQL Search, SQL Server 2012/2016, Oracle Exadata, SQL, PL-SQL, JavaScript, Share Point, Microsoft TFS, SSRS, T-SQL, Windows 7, MS Word, MS Excel, C#, Visio, Jira, SQL Profiler.

Power BI/Tableau Developer New York Life Insurance Company, NJ, Remote Jun 20 to Dec 21

Responsibilities:

• Gathering requirements from stakeholders and creating complex SQL queries on Impala as per business needs and developing L3 tables.

• Performed all sorts of ETL and metrics aggregations at the report level in Power BI using power query and M-code.

• Built the relationship between various data sources in Power BI and transformed the data based on requirements.

• Created new columns and DAX measures and applied business rules to color code the metrics.

• Developed rich visualizations like donut charts, pie-chart, bar graphs, staked area charts, etc.

• Written several DAX queries using inbuilt functions in Power BI like dynamic calendar and customized it.

• Created all sorts of frequency filters using DAX such as daily, weekly, monthly, and yearly.

• Published the developed reports to the Power BI report server in their designated workspaces. Enhancing the reports based on user feedback during UAT.

• Scheduled and automated the report refresh on the Power BI server and monitored them to deliver BAU reports on time to business.

• Optimized the Power BI reports and improved the performance of dashboards by finetuning the DAX.

• Implemented row-level security to restrict the data to a set of users in Power BI.

• Designed and built several dashboards involving KPIs and trend charts comparing cumulative vs actual values to depict the client’s overall business needs.

• Built the relationship between various data sources in Power BI and transformed the data based on requirements. Retrieve data from multiple data sources and build data pipelines using Teradata or Python.

• Develop operational, analytical dashboards and data visualization reports using Power BI.

• Developed rich visualizations like donut charts, pie-chart, bar graphs, stacked area charts, etc.

• Collaborate with governance teams to enable consistent and accurate reporting for the business by designing and implementing custom reporting and visualizations such as bar graphs, line graphs, pie charts, bullet graphs, whisker plots, crosstabs, waterfall charts, funnel graphs, etc.

• Generating periodic reports based on the statistical analysis of the data from various time frames and divisions using SQL Server Reporting Services (SSRS).

• Created several reports involving drill down, drill through filters, and parameterized functionalities in Power BI.

• Optimized the Power BI reports and improved the performance of dashboards by fine-tuning the DAX.

Environment: Power BI Desktop, Power BI Report Server, SQL developer, PL/SQL, T-SQL, Microsoft Excel, Python, SAS, MS Access, MS Visual Studio

POWER BI/SQL Developer Sun Country Airlines, St Paul, MN Mar 18 to May 20

Responsibilities:

• Created SSIS process design architecting the flow of data from various sources to target.

• Use DDL and DML for writing triggers, stored procedures, and data manipulation.

• Create different SSRS Reports based on the user’s requirements.

• All kinds like ad-hoc reports, Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids

using SQL Server Reporting Services (SSRS).

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

• Troubleshoot any kind of data issues or validation issues.

• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.

• Design the ETL framework for the data load into FRY Tables.

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

• Worked on the ADW Data Warehouse for Santander Bank.

• Create a Master Package to run different other ETL in one Master package. Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

• Bug fixes in SSIS, SSRS, and stored procedures as necessary.

• Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.

• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.

• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

• Used Power BI Gateways to keep the dashboards and reports up to date.

• T-SQL in constructing User Functions, CTEs, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

• Perform T-SQL tuning and optimizing queries for SSIS packages.

• Worked on Incremental Loads using concepts like Checksum and Column to Column comparison.

• Scheduling SSRS jobs and production support.

• Production support for SSIS and SSRS jobs.

• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.

• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.

Environment: MS SQL Server 2012/2014/2017, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server.

Power BI Developer Molina Healthcare, Irving, TX Nov 16 to Feb 18

Responsibilities:

• Strong experience in writing stored procedures, functions, and triggers in MS T-SQL building the packages, Testing, and implementing in the production server.

• Redesigned and tuned stored procedures, triggers, UDF, views, and indexes, and was successfully able to increase the performance of the slow-running queries.

• Experience in Developing and Publishing Reports in SQL Server 2013 using SSRS (SQL Server Reporting Services).

• Created various kinds of reports involving Drill Down, Drill through Reports, Parameterized Reports, and Ad-hoc Reports.

• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.

• Involved in designing and publishing visually rich and intuitive Power BI dashboards for executive decision-making.

• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients.

• experience in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business needs through Power BI

• Converted the SSRS reports to Power BI for Baxter’s internal project called TRA (Trending Report Application).

• Expertise in writing complex DAX functions, and queries in Power BI for visualization.

• Experience in publishing Power BI reports of dashboards in the Power BI server and scheduling the dataset to refresh for upcoming data in the power BI server.

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, and other T-SQL code to implement business rules.

• Designed and developed various SSIS packages (ETL) to extract and transform data and was involved in Scheduling SSIS Packages.

• Actively participated in Sprint planning meetings, Daily Scrum, Sprint review meetings, and Sprint retrospective meetings.

Environment: SQL Server 2014/2008R2/2008. Visual Studio (SSIS, SSRS) 2013/2008/2008 R2, 2005. Power BI, DB2, PL/SQL, Toad, Team Foundation Server (TFS), TCU, SVN, HP ALM.

SQL BI Developer Anblicks, India Jan 15 to Sep 16

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User-defined Data types, Clustered & amp; Non-clustered Indexes.

• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases.

• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views, and other T-SQL code and SQL joins for applications following SQL code standards.

• Managed indexes, statistics, and tuned queries by using an execution plan for optimizing the performance of the databases.

• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards.

• Knowledge of Database Performance monitoring tools.

• Utilized datasets in Power BI service for refreshing data and implementing gateway.

• Configuring Power BI enterprise gateway to keep the dashboards and reports up to date.

• Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.

• Contributed in building reports in Power BI from scratch.

• Worked with both direct query and import data in Power BI for creating reports.

• Developed and maintained multiple Power BI dashboards/reports and content packs.

• Responsible for building Power BI dashboards using tabular and multidimensional models.

• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.

• Created ETL SSIS packages both designed and coded to process data to target databases.

• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on a monthly and weekly basis.

• Involved and worked in designing and developing the ETL flow that will update the data structure related to Target Oracle tables using SQL Server Integration Services (SSIS).

• Designed and implemented a variety of SSRS reports on Report Server such as Parametrized, Drill-down, Ad hoc, and Sub-reports using Report Designer/Report Builder based on the requirements.

• Developed and maintained Microsoft SSAS multidimensional data cubes and MDX queries.

• Designed end-user documentation for training and reference purposes.

• Used SM Ticketing tool for all tickets and project-related activities.

Environment: Power BI Desktop, Power BI Pro, DAX, Transact-SQL, MS SQL Server 2008 R2/2012, SQL Server Management Studio (SSMS), SQL Profiler, MS-Excel

Contact this candidate