SUMMARY:

• Over 5+ Years of experience in IT with Database applications and Business Intelligence Design & development, and Data Analysis in Production, Development, Testing and Staging Environments.
• Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI,
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in Power BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS.
• Experience in designing, developing, deploying and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
• Expertise in Azure cloud data migration from various sources.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and POWER Pivot, and POWER Point
• Developing ETL packages using SSIS to extract & load from Source into Azure SQL Server.
• Experience in providing Logging, Error handling by using Event Handler.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in building pipelines, datasets and creating connections, triggers in Azure SQL Data warehouse.
• Set - up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments.
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Worked on Data Factory to load data from Data Lake to Azure SQL Data warehouse.
• Worked on Data Lake Analytics to transform the data as needed to build the tabular model in Azure Analysis Services.
• Used Azure Runbooks, Azure automation account, Azure Functions to process the tabular models in Azure Analysis Services.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016/2014.
• Expertise in defining the business process flow and gathering business requirements.
• Experience working in Agile and Waterfall methodologies in SDLC
• Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box

TECHNICAL SKILLS:

RDBMS: MSSQL Server 2008/2012/2014/2016/2019 , MS Access

T: SQL, SQL, UNIX Shell Script

BI Tools & Packages: SQL Server Management studio, ETL, Power BI Desktop, Power BI Service, Power BI Premium, MS Visual Studio 2013/2016/2019

Operating Systems: Windows Vista/XP/2003, Windows Server 2003/2007.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power BI Desktop, Power BI Pro, Power BI Premium, MS Visio.

Web Technologies: XML, XMLA, JSON.

Data Modeling: Power BI Desktop, Tableau, SSRS.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS), SharePoint portal, MS Visio.

Scripts: VBScript, HTML and XML, Power Shell.

Others: Microsoft Office, Microsoft Visio, Microsoft Visual Studio2008, SharePoint, Dream viewer, Team Foundation Server, Power BI, AWS, Azure Data Lake, Azure Data Factory.

EXPERIENCE:

Confidential, New Jersey

Power BI Developer/ SQL Server BI Developer

Responsibilities:

• Held discussions with executive and senior management to gather insights and created frameworks to define key KPIs and architect dashboard reporting in Power BI for use by the teams across the organization.
• Created reports and dashboards in Power BI by connecting to various data sources (SQL Server, XLSX, CSV, SSAS Tabular models, SharePoint).
• Expertise in creating Power BI reports and dashboards using different visuals like Slicers, Line, Pie, Histogram, Map, Scatter, Bullet, Heat Map, Tree map, etc.,
• Built a Tabular Model cube using DAX queries fetched data to using Power BI reports.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server applications.
• Good Knowledge and experience on Power BI data Gateways (Personal and Enterprise gateways). Created interactive dashboards and scorecards using Power BI. Developed reports and dashboards with Microsoft reporting services platform, Microsoft SQL, Excel, and power pivot.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Used various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Converted functional requirements into technical specifications and performed required data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
• Weekly presentation to the business users about the reports and their changes as required.
• Advanced experienced with the DAX language including the manipulation of filter context, variables, and performance techniques
• Knowledge in creating dynamic Date Table in Power Query using MQuery.
• Proficient in data transformation, consolidating data from multiple data sources, develop process workflows to help business design effective dashboard solutions.
• Good knowledge in Creating SSIS packages, SSRS reports and T-SQL queries.
• Designed SSIS packages for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, and OLEDB supported databases.
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent

Confidential, Plano, Texas

MSBI/Power BI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Developed and Published dynamic and complex Financial and Sales Reports in PowerBI.
• Used DAX to create complex measure and calculated columns.
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from different sources
• Created many calculated columns and measures using DAX in PowerBI based on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports in PowerBI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2017/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), JDE, SharePoint, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8

Confidential, Florida

SQL BI Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Used DDL and DML commands for writing triggers, stored procedures and data manipulation.
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Involved in tuning system stored procedures for better performance.
• Developed impactful reports using SSRS and MS Excel to solve the business requirements
• Involved in the Data modeling, Physical and Logical Design of Database
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed.
• Create and manage Reports subscriptions and schedules SSRS reports
• Worked with the application developers and provide necessary SQL Scripts using SQL and PLSQL.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Experience in working creating Multidimensional cubes using SSAS.

Environment: MS SQL Server 2012/2014, T-SQL, SQL Server Management Studio (SSMS), SQL ProfilerVisual Studio 2005, SSIS, SSRS, Windows XP, TFS, TW.