SUMMARY

• 6+ years of experience working in Confidential BI tools and designed and developed Power BI reports and dashboards from multiple data sources using data blending.
• Proficient in Confidential BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2005/2008R 2/2012/2014/2016.
• Proficient in advanced features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables, and Dynamic SQL.
• Experience in Developing, Designing and Support interactive Tableau dashboards.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience in developing and debugging Stored Procedures and Triggers.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
• Excellent hands-on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Experience in using Row Transformations, Block and Unblock Transformations for Performance Tuning in SSIS packages.
• Experience in working with different types of Dirty Data from Different sources.
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union.
• Experience in working with Data Cleansing technique in ETL procedures.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Excellent hands-on experience in creating groups and measures, KPIs.
• Experienced in building Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Experience in performance tuning, processing, and deploying cubes.
• Experience in cube partitioning for better database performance.
• Strong written and communication skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MySQL, Oracle

Database Technologies/Tools: SQL Server Enterprise Manager, Confidential Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Confidential Visio, ER Studio

Databases: Azure SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014,2016, MySQL and Oracle12c.

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, Data Migration Service (DMS), Azure SQL Data.

Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Excel.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2014/2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

PROFESSIONAL EXPERIENCE

Confidential, Redmond, CA

Data Analyst (SSAS)/Power BI Developer

Responsibilities:

• Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Worked extensively on Data visualization and Data analysis using PowerBI.
• Designed and Developed Dashboard Reports in Power BI using DAX.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Worked on Cosmos big data platform tool to create different types of streams like structured streams, csv, tsv etc. with the help of scope script
• Optimized scope scripts for improved performance
• Consumed Cosmos structured streams in ADF
• ETL data driven transformation using Azure Data Factory (ADF)
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards
• Took care of scheduling pipelines with the help of triggers
• Monitored and troubleshoot ADF pipelines issues with the help of log analytics
• Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse.
• Performed database backup and deployment to the production server.
• Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Cube and Server Monitoring and handling queries
• Livesite monitoring and RCA for blockers.

Environment: MS SQL Server 2017/2018, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Visual Studio (SSDT)2019, Confidential Azure Portal, Azure Data Factory (ADF),Mist power bi

Confidential, San Diego, CA

Power BI Developer

Responsibilities:

• Extensively involved in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008 R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• Involved in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Responsible for creating reports such as Cascading, Drill down/Drill through Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Worked extensively on Data visualization and Data analyzation using PowerBI.
• Designing and Developing the Dashboard Reports in Power BI using DAX.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Developing the reports using Power BI, Power Pivot and SSRS.
• Implementing Drill Through & Hyperlinks in Power BI report.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Used Confidential PowerBIPower Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Responsible for identifying, designing, and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.
• Worked on PowerBIand prepared dashboards using Tableau to make it more attractive.
• Created Calculated Columns and Measures in PowerBIand Excel depending on the requirement using DAX queries.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Extensive experience in different types of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
• Built aTabular Modelcube from scratch data and byMDXand DAXqueries fetched data toSSRSandPower BIreports.
• WritingMDXqueries to get the data from a tabular model.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data ofTabular modelandCube data modelto prove the functionality of database.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse.
• Performed database backup and deployment to the production server.
• Extensively involved in Designing and Developing ETL Processes data from external sources like Azure blob Storage, Azure Data Lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created SSIS packages using .NET and C# as a custom code in Script task.
• Involved in unit testing against the developed packages and reports.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.

Environment: MS SQL Server 2012/2014, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012, Power BI, Power BI (Pro), Power BI Service.

Confidential, Phoenix, AZ

Power BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Transferred the data using SSIS packages.
• Extensively worked with SSIS tool suite, designed, and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• CreatedSSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Generating Ad-Hoc reports on a timely basis and to fulfill immediate requirements.
• Used star and snowflake schema in designing cubes for creating SSAS packages.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Power BI.

Confidential, Los Angeles, CA

SQL / Power BI Developer

Responsibilities:

• Design and developing the POC’S according to business users.
• Developing the best practices and driving the code to across development, test and Pre-Prod and Production environments.
• Creating the Daily jobs for data dumps for various teams.
• Responsible for Data analytics’ migration from Tableau to Power BI.
• Designed and developed the migration of Data Analytics to Power BI.
• Designed and developed the dashboards, Scorecards and KPI’s in the Power BI.
• Implemented scheduled data refreshments with on-premises data gateways as per the business requirement.
• Implemented Direct Query, Imports Data and Live Connection modes.
• The apps and workspace and share across the organization and individuals based on the requirement.
• Creating and maintaining the Power BI Content packages.
• Generating Web links or Embedded Code for publishing to web or website or portals.
• Design and develop the RLS (Row -Level-Security).
• Implemented the best practices to speed up the data refreshed or load the data model.
• Design and Developed the Data marts as per the Business requirement.
• Migrated the existing Confidential excel reports to Power BI.
• Design and developed the Test scenarios in For Data analytics.
• Design and developed the MySQL Scripts for Data Dumps.
• Extensively involved in deploying SSIS Packages, SSRS Reports and SSAS Cubes using command line utilities.
• Extensively involved in Data Warehouse Star Schema Modeling, Snow-Flake Modeling, FACT& Dimension Tables, Physical and Logical Data Modeling.

Environment: MS SQL Server 2016/2014/2008 , SSIS/SSAS/SSRS, T-SQL, Visual Studio 2014/2013/2012, C#, SQL Server Profiler, Azure Cloud, Azure SQL Database, Azure Data Lake, Azure Blob, Power BI Desktop, Power BI Service, Power Query, Power Pivot, Power Designer, Tabular Models, SQL Server Management Studio, Team Foundation Server (TFS), Business Intelligence Development Studio (BIDS), Business Objects, Jasper Soft Studio.