SUMMARY

• Around 6+ years of Professional experience as a Power BI Developer working on SQL server and Tableau (Desktop, Server), Business Intelligence tools, Database Design, Data Modeling and Data warehousing projects.
• Worked extensively on SQL server management studio, SQL server 2017/ 2016/2014/2012/2008 R2 and BI tools such as SSIS, SSRS, SSAS, Power BI and tabular data modeling including MS solutions like MS EXCEL, DB2, and MS Access Database.
• Have good experience working on Azure services.
• Proficient in designing ETL package using the methods for slowly changing dimensions type 1, 2.
• Strong in Design and develop ETL and Data Quality mappings to load and transform data from source to DWH using SSIS.
• Knowledge in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.
• Validated the results in Tableau by running SQL queries in Oracle SQL developer.
• Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
• Worked on all aspects of the ETL pipeline, as well as aggregated and reported on operational system metrics, using Microsoft BI stack like SQL Server, SSIS, SSRS and SSAS.
• Expertise in building complex ETL packages using varied and complex data sources and merging them into a single data model.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Extensive Dashboard design using Power BI.
• Developed a Canvas Power Applications and Workflows using Power Automation.
• Complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• PublishingPowerBIDesktop reports created in Report view to thePowerBIservice.
• Experience in Optimizing Cubes using SQL Server Analysis Services (SSAS).
• Strong in database creation, maintenance, monitoring, backups and recoveries usingSQLServer Agent, Import/Export Wizard and Maintenance Plans.
• Advanced reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross - Tab, 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 gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining.
• Exceptional leader with excellent interpersonal skill, communication finesse and Team 0management skill with strong expertise in analyzing the requirements and preparing the specifications document based on the requirements.

TECHNICAL SKILLS

RDBM/Databases: MSSQL Server 2016/2014/2012/2008 R2, Oracle 12c, MS Access, Microsoft Azure

Programming Languages: T-SQL, SQL, C, DAX, Python

Data Modeling: FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques

BI Tools: Visual Studio (SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Power Apps, Power Automation

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS),Microsoft Azure, Azure Data Factory, Azure Databricks, Azure Data Lake.

Version Control: Team Foundation Server, Git.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS)

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Power BI Developer

Responsibilities:

• Gather Requirement, Data Warehouse Design, and Semantic Layer (Tabular model) Design based on Requirement.
• Designed and documented the entire Architecture of Power bi Poc.
• Created various dashboards in PowerBI desktop using table, matrix, bar, card, gauge, and slicer visualizations. Worked on DAX expressions like filter, aggregate, mathematical functions etc.
• Created hierarchies and attributes as part of dimensional modeling.
• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS.
• Created SSIS packages to Extract-Transform-Load (ETL) from transactional system (OLTP) to analytical system (OLAP).
• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS.
• Installation on Azure Data Factory gateway, Microsoft Power BI gateway, Power BI desktop.
• 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.
• Worked as Power BI Service Administrator.
• As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings.
• 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 Power bi query editor.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Changed DB SQL server to snowflake cloud and migrated reports to snowflake.
• Deploy and Configure Power BI dataset for Sales and Finance team, implement incremental refresh on Power BI dataset
• Written calculated columns, DAX, MDX, Measures query’s in power bi desktop to show good data analysis techniques.,
• Converting the existing Report from SQL Server to Snowflake DB.

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

Confidential, Toms River, NJ

Tableau Developer

Responsibilities:

• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Designed and developed SSIS Packages to import and export data from MS Excel, Teradata SQL Assistance, SQL Server and Flat files.
• Scheduled SQL Jobs and SSIS packages to run at regular intervals to automate processes and maintain data consistency and to achieve incremental updates of target data keeping in mind SLA's, data integrity and security.
• Analyzed existing OLTP databases and created ETL packages in SSIS to export historical usage data-to-data warehouses, after validating for market specific business rules.
• Developed the application using ASP.NET MVC 4.0 and implemented application logic using C# and jQuery.
• Worked on converting the Asp.net Web Forms Application to Asp.net MVC.
• Reviewed & Tested packages, fixing bugs (if any) using SQL Business Intelligence Development Studio.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required and promoted the changes in requested environment.
• Developed stored procedures for the application using SSMS2014. Created packages for moving data from the Teradata Enterprise Data Warehouse to SQL Server production database.
• Experience with data analysis using OLAP and OLTP systems including fact tables, dimensions and measures, schemas like star schema, snowflake schema and extended star schema.
• Designed and developed multidimensional OLAP cube using SSAS. Created custom calculated members using MDX queries.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS) and created Databases to be used for reporting using SSRS.
• Created ad-hoc reports to users in Tableau by connecting various data sources. Analyzed the existing business requirements in Tableau.
• Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
• Maintained build and code versions using Team foundation Server (TFS)

Environment: Operating System Windows 7 Enterprise Languages T SQL, PL SQL, Teradata SQL Assistant, Teradata, SQL Server 2014, SSRS, SSIS, SSAS, OLAP, ASP.NET MVC 4.0, Team Foundation Server (TFS), Excel Power Pivot, Special Software Visual Studio 2015, Team Foundation Server, SQL Server Management Studio, SQL Profiler, Teradata SQL Assistant

Confidential

ETL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes & Views using T-SQL in Development and Production environment for SQL Server 2008R2.
• Developed Database Triggers to enforce Data integrity and Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined relationship between tables and enforced referential integrity.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc
• Established connectivity to database and monitored systems performances.
• Performance tuning and monitored both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• 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.

Environment: SQL Server 2008R2, SSIS, Windows server, SQL Profiler, SQL Query Analyzer, T-SQL