SUMMARY

• Strong skills in Data Modelling, Database Design and SQL Development, Great expertise in processing data and flowcharting techniques, Excellent understanding of database structures, principles, theories and practices. Conversant with T - SQL coding including Stored Procedures, Functions, Views and Joins.
• Query Tuning and Query Analysing Skills, Excellent on Data Auditting Techniques including Triggers and Memory Tables. Excellent on SQL Server Join Options and Query Tuning
• Excellent on Indexes and Index Architecture, Excellent on SQL Server Architecture and DB Design Architecture, Excellent on Cursors, Dynamic SQL Programs and Loops with Procedures. Excellent on Remote Queries, Joins and Cursors
• Strong skills in Data Modelling, Report Design and Visualizations, Excellent on Power BI Visuals including TreeMap, Funnel, Line Chart, Excellent working with Map Reports and Stacked Reports, Excellent working with Divergent & Sentiment Properties
• Excellent on Power Query (M Language) Functions, Excellent on Power Query Parameters and Variables, Excellent on Power Query Lists, Tables and Records
• Excellent on DAX Functions and Usage, Excellent on DAX Measures and Calculations, Excellent on BI Enhancements using DAX
• Excellent on Power BI Cloud and App Creation, Publishing, Dashboarding and Dataset Refresh using Gateways (Personal), Excellent using Content Packs and Card Level Alerts, Created Scorecards, Bookmarks and QR Codes for Reports, Excellent on Power BI Licenses and Gateway Types
• Excellent on Azure and On-premise Database Report Visualizations, Experienced to design complex queries for Power BI Report Visualizations
• Experienced to manage all the stages of software development, Experienced to develop applications in a detail oriented environment

TECHNICAL SKILLS

MSBI tools: Power BI, SSIS, SSRS, SSAS

Languages: T-SQL, VB Script

Databases / RDBMS: SQL Server 2005/2008/2008 r 2/2 MS Access.

Other Packages / Tools: MS Visio, Visual Source Safe. Visual Studio 2008, 2012, SSIS (ETL), SSRS

PROFESSIONAL EXPERIENCE

Confidential

Power BI /SQL BI Developer

Responsibilities:

• Used various sources to pull data intoPower BI such as Sql Server, 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.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• Recreating existing application logic and functionality in the Azure Data Lake, Azure Data Factory, SQL Database and SQL data warehouse environment
• Wrote calculated columns, Measures query’s 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.
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Developed Excel Power View, Power Query and Power Pivot dashboards for data analysis
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Designed 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, CDC, Script Component, Script Task, Send Email Task, SQL Execute Task,
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.
• Migrated customer data which is currently stored in SQL table to dynamics Financials customer object using SSIS custom

Environment: SQL Server 2005,2008, 2016 T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SAP databases, SQL profiler, SSIS Data Profiling

Confidential

Program Analyst/SQL BI Developer

Responsibilities:

• Worked on extracting the data from Client Legacy Data and performed Staging the data to SQL Server Source Database and converted the data using source to inter mapping rules and loaded the data from Source to Intermediate Database and Loading the data from Intermediate to CSES Application and Intermediate to FCCMS Application
• Developed Complex SSIS Parent-Child Packages for different Counties with Common Source to Intermediate rules, Worked on creating Common Child packages for all the parent package, Modification or fixes in the child package will reflect all the parent packages.
• Worked on various data transformations such as Aggregate Transformation, Aggregate Conditional Split, Data Conversion, Derived Column, Multi-Cast, Script Component, Lookup, Execute SQL Task, etc.
• Initiated and participated in Workshops and JAD sessions with teams from various countries to identify the areas which have scope for improvement and proposed solutions.
• Worked on SSIS design pattern using parent-child package structure.
• Identifying the bottlenecks, reasons of resource contention and heavy objects and preventing them from becoming the showstopper in the data-warehouse.
• Requirement gathering & designing for new initiatives/enhancement requests.

Environment: SQL Server 2005,2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SAP databases, SQL profiler, SSIS Data Profiling, Visual Studio 2008.