SUMMARY

• Over 6+ years of experience working in Microsoft BI tools and designed and developed Power BI reports and dashboards from multiple data sources using data blending.
• Proficient in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2005/2008R 2/2012/2014/2016.
• Proficient in advance 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 inter active 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 wif 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 by using Row Transformations, Block and Unblock Transformations for Performance Tuning in 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 wif Data Cleansing technique in ETL procedures.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• Worked wif Microsoft Power BI, Data Zen, DAX expressions, Power View and Power Query integrated wif share point.
• 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 wif different Measures and Dimensions.

TECHNICAL SKILLS

Languages: SQL*PLUS, PL/SQL, T-SQL, HTML, JavaScript, DAX

Database: MS SQL Server, ORACLE10g/11g, SQL Server 2005/2008 R 2/2012/2014/2016/2019

Data Modeling: Star Schema, Snowflake Schema

Reporting Tools: PowerBIDesktop,PowerBIService,PowerBIGateway, andPowerBIReport Server.

Visualization: Tableau,PowerBI,PowerAPPS,PowerQuery,PowerPivot, M Query

Business Intelligence Tools (OLAP): SSRS, SSIS, SSAS.

Operating System: Windows, UNIX, Mac OS.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Power BI Developer

Responsibilities:

• Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
• Collaborate wif management, project managers, and IT to evaluate required data and reporting functionality, communicate tradeoffs and alternative solutions, and plan out, prioritize, and lead related development efforts
• Lead cross-functional project teams to in corporate new data sources into the data warehouse, expose related attributes and metrics in Micro Strategy, and utilize BI tools to develop reports, visualizations, dashboards, and other solutions that allow data to be analyzed and acted on
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• Used advanced data modeling concepts such as family of Stars, Confirmed Dimensions, and Bus Matrix in order to handle complex situations.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ER Studio.
• Continuously improve the quality and usability of corporate information assets and, champion standardization, integration, and ubiquity of BI tools and processes
• Lead cross-functional project teams to in corporate new data sources into the data warehouse, expose related attributes and metrics in Micro Strategy, and utilize BI tools to develop reports, visualizations, dashboards, and other solutions that allow data to be analyzed and acted on
• Adopt existing and establish new technical design patterns, workflows & tools to build sustainable analytics solutions that provide decision support for stakeholders
• Expertise in writing complex DAX and MOLAP functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica PowerCenter Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Used various sources to pull data into Power BI such as SQL Server 20008, 2012, MDAX, SAP BW, Oracle, SQL.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
• Created PL/SQL stored procedures, function, packages for moving the data from staging area to data mart.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks Solid understanding of Incident, Problem and Change Management ITIL services.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Generated various report using Python Report lab and sent to Business users to improve their decision making and Knowledge of R and/or Python based data programming skills
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager

Environment: MS SQL Server Management Studio 2016/2012 (SSMS), MS Visual Studio 2017, SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, SQL Server Agent, T-SQL

Confidential, Brownwood, TX

Power BI Developer

Responsibilities:

• Gatheird data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) wif the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots inPowerBI.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPowerBI.
• Used various sources to pull data intoPowerBIsuch as SQL Server, oracle.
• Developed reports to visually explore data and create an interactive reportExcel andPowerBI.
• Working wif import and direct query, creating custom table in thePowerBI.
• By usingPowerBIdesktopconnected to various data sources, working wif different visualizations.
• UtilizedPowerQueryinPowerBItoPivot and Un-pivotthe data model for data cleansing and data massaging
• CreatedPowerBIReportsusing the Tabular SSAS models as source data inPowerBIdesktop and publish reports to service.
• Worked wiftable and matrix visuals, worked wif different level of filters likereport level, visual level filters, page level filters.
• Created reports utilizingSSRS, Excel services,PowerBIand deployed them onSharePoint Serveras per business requirements.
• Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• UsingTabular modelprovided more security to data atRow level.
• MDXprogramming,DAXexpressions, analysis and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPowerBIdesktop.
• Creating reports from importing, direct query and live data from several data sources.
• Troubleshoot and support reports inPowerBIworkspaceswhenever their are issues in production.

Environment: PowerBIDesktop,PowerBIpro,PowerQuery,PowerPivot,PowerView, MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle 11G, SQL Profiler, T-SQL, Visual Studio, HTML5, Java Script.

Confidential, Columbus, IN

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 wif Share Point).
• Worked wif 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 wif 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.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked wif 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 also 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

BI Developer

Responsibilities:

• Participated in the identification, understanding, and documentation of business requirements, keeping in mind the need for the application based on the project scope and SDLC methodology.
• Communicated regularly wif both IT and non-IT teams to ensure noledge transfer between cross functional teams.
• Extensively involved in Data Extraction, Transformation, and Loading (ETL) process from source to target systems.
• Validated the data integrity of the data loads and used data modeling tools to create the reporting databases.
• Actively supported business users for change requests.
• Created and modified SQL Stored Procedures.
• Performed business analysis and wrote SQL scripts to analyze data and parse to Excel.
• Creating Excel macros and VBA code to massage data in Excel as well as link to SPs in SQL.
• Designed SSIS packages to transfer data between servers, load data into database; Scheduled the tasks to do these jobs periodically and perform data transformations.
• Designed and implemented report layouts according to reporting standards of the department.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV, and PDF.
• Responsible for making the report available for scheduling and viewing on demand.

Environment: MS Office (MS Word, MS Excel, MS Power Point), SQL 2005/2008, Microsoft PowerBI Desktop Pro, SSIS, SSRS, SSAS, ETL