R Mourya Email and Phone Number

• Experience on Microsoft Power BI (Desktop, Service, Mobile) • Database performance tuning Built and published customized interactive dashboards utilizing Power BI.• Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.• Experience with power BI as an administrator including providing installation, administration, configuration, maintenance, scheduling, performance tuning and upgrade• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Automated Power Query refresh using power shell script and windows task scheduler. • Developed UNIX Shell scripts to automate table creation, execute procedures.• Configured Capacity settings to assign users as Capacity Admins per capacity during initial setup of the capacity and later via User Permissions within the Premium settings.• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data massaging.• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave Roles, user access with respect to security in report manager• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.• Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle.• Migration of Cognos objects from one version to other. Versions worked on: Cognos 10, Cognos 11.• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations and Process data from data mart using SSAS.• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.• Involved in building the dimensions, cubes with star schema and snowflake schema using SSAS.

• Designed and developed stored procedures, queries and views as necessary. Extensively use joints and sub-queries for complex queries which were involving multiple tables from different databases. • Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop • Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolve issues in a timely manner. • 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.• Expertise in writing complex DAX functions in Power BI and Power Pivot. • Scheduled Automatic refresh and scheduling refresh in Power BI service. • Used Framework Manager to build models, packages and publish packages to Cognos Connection.• Created Credit Risk Financial Models. • Installed and configured the Oracle Data Integrator ODI software tool in a three-tier environment and performed periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.• Worked on analysing Charge Backs to decrease costs and increase efficiency using Power BI. • Migrated existing self-service reports and ad-hoc reports to Power BI.• Used Unix for automation of SAS Programs.• Created sub-reports, drill down reports, summary reports, parameterized reports, and ad-hoc reports using SSRS. • Wrote Calculated Columns, Measures, and Queries in Power BI desktop to show good data analysis techniques • Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization.

Explore data in a variety of ways and across multiple visualizations using Power BI. Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging, and Data split. Created new measures and new calculated columns for reports and dashboard analysis. Created DAX functions for various fact calculations for efficient data visualization in Power BI.Used different types of visualization Like (Stacked bar Charts, Clustered Bar Charts, Scatter charts, Pie charts, DonutChart, Line &, Clustered Column Charts, Map, Slicer, etc.) In Power BI according to the requirementsPublished reports and dashboards to the Power BI service through the Office 365 integration. Shared the dashboards among multiple users in the group. Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways). Used agile development Methodology. Implemented dashboards and scorecards with power pivot for executive management for data insights as perBusiness requirements. Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Involved in Planning, Defining, and Designing data, based on business requirements, and provided documentation. Worked with Business Analysts in gathering requirements and translating them to technical specifications. Developed Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and indexed views. Increased the performance necessary for statistical reporting after performance monitoring, tuning, and optimizing indexes. Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration Services (SSIS) Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension, and more. Performed ETL mappings using MS SQL Server Integration Services. Created SSIS packages for Uploading different formats of files (Excel, Access, dbf) and databases (SQL Server, Flat files) into the SQL Server data warehouse using SSIS. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure. Developed SSAS OLAP Cubes and Partitioning Cubes. Wrote DAX queries to retrieve data from OLAP (SSAS) cubes. Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources. Created jobs for automatically running Stored Procedures for day-end operations using SQL Server agents such as index rebuild, data loads, and summary reports.

Troubleshoot and diagnose customer issues, documenting recreation steps.Troubleshooting issues related to SQL, SSIS, and SSRS.Managing customer issues in On-Time, customer issue status communications.Worked with Crystal reports. X1R2.Designed and developed various reports such as Tabular, Matrix, Drilldown, Drill Through, and Parameterized Reports using SSRS 2008.Generated Reports using Global Variables, Expressions, and Functions for the reports.Designed and developed monthly, quarterly, and yearly reports at branch and company levels.Created SSIS Package for uploads and schedule them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.Handled Initial and Delta loads and used Error Handling, Logging, and Checkpoints and made use of Configuration files.Used SSIS transformations for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.