SUMMARY

• Having 7+ years of IT experience as MS - SQL Server/BI/Power BI Developer, involved in Design, Development and Support of MS SQL Server 2012/2014/2016/2017.
• Extensively worked ondata modeling,NormalizationandDe-Normalizationtechniques for both OLTP and OLAP.
• Excellent knowledge increating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and IndexesusingT-SQL.
• Very good knowledge in designing database objects likeTables,Views,Constraints,Indexesand defaults.
• ImplementedSQL Server Indexing,Index tuningusing Index Tuning Wizard and Tuning Advisor
• Excellent knowledge inperformance tuningandquery optimizationUsing SQL Profiler, Execution Plan, Performance Monitor.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Experience inExtracting, Transforming and Loading (ETL)datafrom Excel, Flat file, Oracle to MS SQL Server by usingBCP utility, DTS and SSIS services.
• Migrated and UpgradedDTSPackages toSSISPackages across all environments.
• Experience inExtraction&Migration of Datafromheterogeneous data sourceslike Excel, MS Access, Oracle and DB2 to MS SQL Server by usingImport Export Wizard, DTS SSIS,and BCP & Bulk Insertutilities.
• Expertise in handling Errors by usingEvent Handlerand can provide Logging, Custom Logging forSSISPackages.
• Experienced with SQLserver integration services (SSIS 2005/2008/2012 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers andETLPurposes across different servers.
• Experience inenhancing and deploying the SSIS Packagesfromdevelopment server to production server.
• Experience inDesigning and Building the Dimensionsandcubes with star schemausingSQL Server Analysis Services (SSAS)
• SQL Server 2005/2008/2012 OLAP database development including KPIs, Data mining, working with changing dimensions
• Experienced in developingreports onSSAS & SSRS on SQL Server (2000/ 2005/2008/2012 ).Sound Experience and understanding ofSSAS, OLAP cube and Architecture
• Created stored procedure for generating reports usingSQL Server Reporting Services (SSRS).
• Experience withAd hoc reporting, Parameterized, Custom Reportingusing SSRS for daily reports and SSAS projects.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts inSQL server reporting services.
• Expert on creating multiple kinds of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Utilized Power Query in Power Bi to pivot and un-pivot the data model for data cleansing and data massaging.
• Expert in developing Data Driven Subscription Reports and setting securities for reports. Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Hands on experience in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps
• Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts and Geographic Visualization.
• Experience in developing applications using power Apps
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support in Confidential .
• Experience in PowerApps application and BI development using Microsoft Power Platform.
• Involved in multiple projects of reporting and data visualization with 100% success rate. Developed customized reporting solutions in collaboration with business stakeholders.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008/2005/2000 , Oracle 8i/9i/11g, MS Access 2003/2005, Teradata, PODS, EPIC

Programming Languages: T-SQL, PL/SQL, DAX, M-QUERY

RDBMS: MS SQL Server 2014/2012/2008/2008 R2/2014, MS Access 97/2000/2003 , Oracle 8i/9i/10g,11g, MS Visual Source Safe 2005.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling Relational, Fact& Dimensions tables, Dimensional and multi dimensional modeling Physical & logical data modeling and De-normalization techniques, MS Access, Power Pivot.

Tools: And Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio.Net, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Pipeline Tools - (Route Load Express, Express Loader, Data Exchange, Risk Analysis) Facility Manager, Facility Maintenance, SQL Server Data Tools.

Operating Systems: Windows XP/ 98/2000/2003/2008/ NT/9x/Vista and MS-DOS, Red Hat Linux.

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)SQL Server Integration Services (SSIS), Business Intelligence Development studio (BIDS)Visual Studio, SQL Server Data Tools, Crystal Reports 9.0, Oracle SQL Developer, TOAD, MS Visio, MS Access, Tableau, Power Pivot, Power BI, Data Stage, Power Automate

Version Control And Configurations: Visual SourceSafe 6.0/2005, Serena PVCS, Visual Studio Team Foundation Server (VSTS), Clear Quest, Clarizen, Lotus Notes.

Packages: MS Office, MS Outlook (Microsoft Office Suite), Power Pivot, Power BI.

Portal: SharePoint Portal Server 2003/2007, Windows SharePoint Services.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Power BI

Responsibilities:

• Gather requirements, analyze the source data and do data discovery to create reports for multiple teams.
• Created reports using different sources like corporate data models, Azure databases, Azure Data Lake, On-premise databases, Share Point Lists, Rest API, Excel etc., and creating dashboards pointing to different reports.
• Create reports in Power BI desktop and publish reports to respective workspaces, apps and automated the process to show the latest data.
• Configured Power BI Gateways to schedule the Datasets.
• Created Power Automate flows to schedule the Power BI reports with out any daily refresh limitation.
• Conduct training sessions with business users on Power BI reports and Dashboards.
• Worked on Converting Spotfire reports to Power BI Reports.
• Worked on Power BI Paginated reports which provide users the capability to export in multiple formats like Microsoft Excel, Microsoft Word, Microsoft PowerPoint, PDF, CSV, XML,and MHTML.
• Created Power BI Dataflows to reuse the transformation logic by multiple teams.
• Responsible for managing Data Preparation, Data Validation, Data Warehousing, Data evaluation, Power BI reporting, Information Delivery.
• Create and implement a data management roadmap to help streamline program reporting.
• Establish and maintain performance dashboard and reporting system for all emerging Program activities.
• Responsible for timely delivery of data and analysis to key stakeholders, including internal staff and auditing services. Interact effectively across internal functional areas in ambiguous situations.
• Support existing Spotfire reports and SSAS Cubes.
• Working on Teradata database, IBM Data Stage ETL packages to Validate, Extract, Transform and Load data to Datawarehouse databases.
• Performance tuning of existing ETL Packages.
• Undertake any other reasonable task or responsibility as required by senior management in order to meet business needs.
• Experience in developing Power Apps using common data services CDS, SQL, Flow, Excel, Share Point.
• Attending daily standup meetings following SAFe Agile Framework

Environment: SQL Server 2016, Teradata, Azure SQL Databases, Azure Data Lake, DataStage, SSAS, Visual Studio, SSDT, TFS, MS Share Point, MS Visio, Spotfire, Power BI, Power BI Paginated Repot Builder, DAX, M Query, Power Automate, SAFe Agile Framework.

Confidential, NJ

Power BI Analyst

Responsibilities:

• Works closely with business users to define requirements, prioritize issues, and address production support issues.
• Gathered functional, business and technical requirements using individual and group meetings.
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Coordinates and facilitates work sessions with Operations users and IT development to define projects scope and requirements and manage project expectations.
• Acts as liaison between the users, GIS team and IT development teams to determine and deliver the most effective solution for development and implementation including preparing detailed business requirements documents.
• Performs user acceptance testing to ensure system integrity before release to production
• Created data mappings to transform the data according to business rules.
• Proficient in performing data analysis, querying data bases, and utilizing SQL query tools
• Worked on development of metrics for performance tracking.
• Developed datasets/data models for various departments like Mobile Health Project, Weather department, Dental Department etc., to develop Power BI reports.
• Developed dashboards and deployed reports to development, UAT and Production workspaces.
• Developed interactive visualizations for BIDW live stories according to requirements.
• Created multiple mashup reports for management using Weather, Mobile Health Events, Dental data using Power BI desktop, DAX and Microsoft SQL server.
• Created data models and Power BI reports with EPIC and Dentrix data.
• Worked with GIS team to implement different layers and integrate data between power bi and GIS layers data.
• Expertise in writing complex DAX functions inPower BI to generate computed tables, columns and measures.
• Published reports and dashboards to different workspaces.
• Developed Power App Models and canvas drive Apps
• Expereice with Office 365 development utilization power apps, flow, Power Bi
• Installed and configured Enterprise gateway in Power bi service.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Created Workspaces for business users to view the developed reports.
• Scheduled Automatic refresh in power bi service.
• Worked on Production support for Power BI Gateway issues.
• Experience in developing Power Apps using commen data services CDS,SQL,Flow,Excel,Share Point.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on different kinds of reports like ACS reports, Appointment statistics reports, Revenue Reports, Services reports, Eligibility Reports, Dental, weather etc. for various departments.

Environment: SQL Server 2016, Visual Studio, TFS, MS Share Point, MS Visio, Power BI, DAX, M Query, EPIC, Dentrix.

Confidential

Data Analyst/Power BI Developer

Responsibilities:

• Analyze the requirements and create packages/projects according to business requirement.
• Draft and maintain business requirements and align them with functional and technical requirements.
• Create Business Requirement Documents and Mapping documents to map data from source to destination.
• Create required staging and target tables in Azure Datawarehouse and move the data from source to ADW.
• Convert Oracle logic to T-SQL Stored Procedures for data migration.
• Move the data from data lake to Azure blob storage and blob to ADW using poly base and Azure Data Factory.
• Prepare technical documents for models, packages, reports and upload into SharePoint.
• Build tabular models using Azure Analysis Services based on business requirement and deploy the models to server.
• Analyze the source data and do the data discovery to automate the process in ADW.
• Maintain and support the existing ADF, AAS Models and Tableau reports.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Utilized tabular model in analysis services to pull and generate reports directly from in-memory from back-end relational data sources.
• Converting Dashboards from Tableau to Power BI.
• Experience in developing applications using power Apps
• Developed Power Apps Model and canvas drive Apps
• Experience in Office 365 development utilization power Apps, Flow, Power Bi
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end-user to make filters.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Create reports in Power BI desktop and publish the reports to respective workspaces and Apps.
• Create reports using different corporate data models and creating dashboards pointing to different reports.
• Created Power BI reports and automate the process to show the latest data.
• Conduct training session with business users on Power BI reports and Dashboards.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Implemented code check-in/check-out and managed multiple versions of complicated code within VSTS.
• Migrated enterprise database to Microsoft Azure with azure data factory.
• Performed Data validation tasks to track the data migration quality.
• Perform thorough unit testing on all relevant platforms to ensure proper implementation.
• Using VSTS for managing source code changes.

Environment: SQL Server 2014, Visual Studio, SSDT, Business Intelligence Development Studio (BIDS), VSTS, MS SharePoint, MS Visio, SQL Server Integration Services (SSIS), Oracle, Tableau, Power BI, DAX, M Query, Azure, ADF,AAS, SharePoint Online, Remedy.

Confidential

Sr. SQL BI Developer/Data Analyst

Responsibilities:

• Gathered requirements from Business Users for the Data migration project from ETL/Data Migration perspective.
• Worked closely with Business users to understand the Business Requirement Documents (BRD) and transform them to technical requirements.
• Participated in project planning sessions with project managers and team members to analyze business requirements and outline the proposed solution.
• Performed tuning of databases by normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Designed and MaintainedSSISPackages for Importing and Exporting Data Migration and Conversion fromLegacy Systems to Destination ERP (Dynamics AX).
• Involved in Data Migration Strategy to migrate data from Source (Legacy) to Staging (Data Scrubbing layer) to Destination ERP (Dynamics AX).
• Implemented the Extract, Transform and Load (ETL) strategy and creating a project wide Custom ETL Framework to support the Data migration.
• Created ETL Control Database and Implemented referential integrity among the SQL Server Tables to handle the ETL Framework.
• Embedded ETL Framework in the SSIS packages (ETL packages) created to migrate the data across different migration stages.
• Used various Control Flow elements like Precedence Constraints and Sequence Containers.
• Involved in designing the SSIS package Template using various control flow tasks such as Execute SQL Task, Data Flow Task, Sequence Container etc.
• Used various Data flow tasks such as OLEDB Source, Union ALL, Derived Column, Conditional Split, Look Up, Multicast and OLEDB Destination etc. in the SSIS packages.
• Used Custom C# Code in SSIS Packages by adding Script Component to standardize/validate the telephone numbers/email address using Regex.
• Standardize/validated Postal Address from US and Canada by embedding Third Party tool Melissa Data Contact Verify in SSIS Packages.
• Used Execute Package Task to run Child Packages from Parent Package and managed the Package flow using ETL Framework.
• Used Project Deployment Model to Deploy Packages to various environments.
• Debugging SSIS packages, Performance tuning onSlowly running SSIS Packages
• Migrated data from Data Scrubbing layer Dynamics AX using Data Import Export Framework (DIXF) using DMF Templates which are part of AX.
• Worked on various AX modules from data migration standpoint such as Accounts, Finance, and HR etc.
• Performed Data Quality Analysis using SQL Skills, Count Validation, Statistical Analysis and Data Quality Validation in Data Migration.
• Created SSRS reports for sorting, different parameterized reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Used Shared Datasets and Shared Data sources in various reports which point to the same objects and pulled data from OLTP Systems.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multi value, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more interactive and understandable.
• Used various sources to pull data intoPower BI such as Sql Server, Excel, CSV etc.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Created Power BI Dashboards from multiple data sources using complex SQL queries.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Designed Power BI data Visualization utilizing Pie charts, Bar graphs, Cross Tabs, Maps, Scatter Plots, Word Cloud etc.
• Weekly presentation to the business users about the reports and their changes as required.
• Scheduled Automatic refresh and scheduling refresh in power bi service

Environment: SQL Server 2012/2014, Visual Studio, SSDT, Business Intelligence Development Studio (BIDS), MS Office, MS Office SharePoint, MS Visio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Dynamics AX, DIXF, SQL Server Agent, MS Power BI