SUMMARY

• Over 6+ years of experience in the field of Data Warehousing and Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services.
• Experience in creating/deploying Data Transformation Services (DTS), Integration Services (SSIS) packages, Reporting Services (SSRS) and knowledge on Analysis Services (SSAS), Azure Databases, Power BI Desktop, Power BI Services.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Extract data from access, excel, flat file, and different data base and load in SQL data base using SSIS packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Expertise in creating Property Expressions, Script Tasks for SSIS packages.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling, error handiling, stored procedures and performing other maintenance tasks.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created Azure Data factory and pipelines to import data.
• Worked on creating the Azure Gateways, Azure Scheduler and maintaing Pipelines.
• Expert in understanding the data and designing/Implementing the enterprise platforms like Data lake
• Created multiple kind of Power BI Reports and Dashboards
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2008/2012/2014/2016/2017 , MS Access, Azure Database.

Programming Languages: T-SQL, PL/SQL, Python, C# and UNIX Shell Script.

Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio, Visual Studio 2014/2016, SQL Profiler, T-SQL, PL/SQL, OLAP, OLTP.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), PowerPivot, Power BI Desktop, Power BI Services, OLAP tools, Sharepoint, Cosmos, MS Visio, MS Excel, Visual Sudio, Crystal Reports.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Power BI Developer

Responsibilities:

• Participated in internal project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Used various sources to pull data into Power BI such as SQL Server, SQL Azure and Excel.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Created Workspaces and APPs for business users to view the developed reports.
• Expertise in writing complex DAX functions in Power BI.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Created 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.
• Created individual reports for different business areas.
• Created Reports using Charts, Gauges, Tables, matrix.
• Created visuals with drilldown capability to reach the business requiremnts.
• Worked on Bookmarks pane and used them as navigatioan pane from the landing page.
• Used and worked on custom visuals, conditional formats for KPI’s.
• Created complex reports on different functional areas.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Environment: MS SQL Server 2014/2016, Power BI, Azure SQL Database, Azure Data Factory, ETL, DTS, Data Modeling, Data Warehousing, Visual Studio 2014/2012, T-SQL, MS Visio, MS Access, Excel.

Confidential, Dallas, Texas

Power BI Developer

Responsibilities:

• Worked under Agile Methodology throughout the project, performed decisive role in developing, planning as well as coordinating with assigned sprints.
• Implemented Power BI, Power Query to extract data from Hadoop and modify the data to generate the reports.
• Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
• Worked with Power BI gateway to schedule daily job to refresh data
• Expertise in publishing Power Bi reports in Power BI services and scheduled the dataset refresh.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
• Designed, developed and tested various Power BI visualizations for dashboard and ad-hoc reporting solutions by connecting from different environments.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• QA’ed hive queries for testing and comparing hadoop and desktop loads.

Environment: Hadoop Hive, HDFS, Power BI Desktop, Power BI Services, SQL, Data Modeling, Cloudera, Tableau, Excel.

Confidential, New York, NY

SQL/AZURE/POWER BI Developer

Responsibilities:

• Participated in meetings and discussions with Client to gather Business Requirements and System Specifications from Business Users.
• Analyzed specifications provided by the client.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created Joins to get security related table.
• Created Azure Data factory and pipelines to import data from on premises SQL server to Azure DB.
• Worked on migration project which moved data from On-Premise to Azure Data warehouse.
• Worked on creating the Azure Gateways on servers suggested.
• Installed Personal gateway on the server and used to configure the refresh schedule for dashboard.
• Worked on Azure scheduler to configure the Time Slices which will ensure the Schedule to run at specific time.
• Pipelines are scheduled to load data Hourly & daily to ensure to check the scheduling works
• Scheduling and maintenance of pipelines by setting up Alerts, Database Mails which helped to react faster to fix the issues.
• To see the AML (Azure machine learning) Models and access Azure SQL DB we created SG (Security Group) and added to the Azure subscription, Azure ML workspace.
• Fetched data from multiple sources (Azure SQL, Tabular Cube) and do modeling in power BI.
• Created multiple kind of Power BI Reports and Dashboards to represent financial forecast data.
• Invovled in developing Power BI reports, datasets, dashboards and checked the data and display errors.
• Designed various visualizations to meet business requirements including table, matrix, scatter chart, line chart, stacked and clustered bar charts, pie chart, area chart, filled map, donut chart, card, slicer, KPI, and etc.
• Created page level and report level filters and adjusted page layout to make an overall improvement of the user experience through optimized dashboards.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Implement Row level security on power BI.
• Gathered requirement from client and shared with offshore team.

Environment: MS SQL Server 2014/2016, Power BI, Azure SQL Database, Azure Data Factory, ETL, DTS, Data Modeling, Data Warehousing, Visual Studio 2014/2012, T-SQL, MS Visio, MS Access, Excel.