SUMMARY

• 8+ years of IT experience in various industries like Retail, Confidential
• Proficiency in Data Warehouse/ Business Intelligence, database design, and development using Microsoft technologies like SQL server 2 /08 R2, Informatica, Power BI
• Participate in software solutions deployment from the beginning to the end based on Software Development Life Cycle.
• Experience with Data Analysis, Data Modelling and Data presentation and importing data from SQL Server, Oracle DB to Power BI to generate reports.
• Expertise in Power BI, Power BI Pro, Power BI Premium.
• Excellent Knowledge on Power Query Parameters, Query Lists, Tables, Records and efficient in Cleaning and Transforming data with Query Editor
• Experience in adjusting Cross Filter direction for a complex set of Tables and Relationships
• Hands on experience in utilizing DAX functions and measures and implemented several DAX functions, which includes Aggregation, Counting, Logical and date functions for efficient data visualization.
• Experience in M language
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Strong experience in creating advanced chart types, and complex calculations to manipulate the data as per business need through Power BI.
• Developed Dashboard Visualizations and complex reports, which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots.
• Published Power BI reports from Power BI desktop to Power BI service in the required originations and made Power BI Dashboards available in Web clients and Scheduled Automatic refresh in Power BI Service
• Followed Power BI best practices to improve the performance and security of enterprise - grade Power BI implementations.
• Experienced working with Denodo and creating Denodo Objects like Denodo views and API
• Experienced in working with Data Connectors like Microsoft Azure Analysis Services and Azure Data Lake.
• Experienced as user governance using office 365 and administrating user security like assigning roles and premium capacity.
• Experienced as working on Power BI Admin Portal to manage users, capacities, Audit logs and tenants.
• Expertise in installing, configuring, upgraded Enterprise gateway as well Personal gateway.
• Experience in the integration of various data sources such as SQL Server, Oracle, XML files, and various types of flat files.
• Experience with T-SQL in creating Stored Procedures, Tables, joins, Triggers, User Function, Views, with Queries using PL/SQL, T-SQL programming in Oracle and SQL Server database.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports and Dashboard requirements.
• Knowledge of R and Python language for gathering data and analyzing the data.
• Experience in Tuning SQL queries and T-SQL queries and improving the performance of the queries.
• Experience in Dimensional Data Modeling like star schema, snowflake schema, Fact and Dimension tables using ERWIN.
• Expert in Extracting, Transforming and Loading (ETL) data flows using Informatica, creating data mappings/workflows to extract data from SQL Server and other sources like Oracle to load into various Business Entities
• Excellent knowledge in RDBMS concepts and constructs, along with Database Objects creation such as Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
• Expertise in creating and managing Indexes to achieve better query performance.
• Well experienced with UNIX shell scripting.
• Experience working with SSIS, SSRS
• Knowledge of Tableau
• Good team player with excellent communication and documentation skills.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, and Power BI Report Server.

ETL Tools: Informatica Power Center 8.6, Designer, Workflow Manager, and Workflow Monitor, Repository Manager, SSIS.

Data Modeling: MS Visio, Erwin.

Denodo: Denodo Objects, View, API

Databases: Microsoft Azure, ORACLE10g/11g, SQL Server 2005/2008 R 2/2012/2014/2016/2019

Languages: Oracle PL/SQL, Shell Scripting, R Language, Python.

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

Operating System: Windows, UNIX, Mac OS.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Power BI Developer

Responsibilities:

• Coordinated with business users in analyzing business requirements and translating them to technical specifications and FSD.
• Performed data migration from on prem to Cloud.
• Used Denodo to connect and collect data in Power BI desktop, used caching techniques, deployments using Solution Manager, job scheduling using Scheduler, and setting up metadata in Data Catalog
• Experience in using Denodo as “Data as a service”.
• Performed data analysis by connecting to ADLS and Databricks.
• Connected to Azure Analysis services and made a live connection possible to work with the tabular models of Analysis services.
• Participated in using R to collect the data in Power BI Desktop.
• Used Python for detailed analysis of data that is necessary to be presented.
• Experience with performing SSIS data transformations, data flow tasks like Lookups, Merge, Merge Join, Sort, Derived Column, Union-All, Conditional Splits and Event Handlers, control Flow Task, Execute SQL Task, Script Task, Send Mail Task, File System Task.
• Used Power BI desktop to directly connect to database tables (Direct Query Mode).
• Utilized Query Editor to clean and format data and eliminate redundant information and append and merge tables from various data sources.
• Worked on all types of transformations that are available in Power BI Query editor.
• Designed Power BI reports based on business requirements and deployed the reports to workspaces to create dashboards for end user.
• Created Slicers and Filters to accurately depict information in visualizations according to the user’s needs.
• Worked on Data Modeling with DAX using various Functions like Aggregate, Logical, Counting and Time intelligence functions.
• Worked with the Database team in creating views and tables to have more optimized report.
• Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
• Developed reports by using different in-built visualizations Pie Chart, KPI, Card, Matrix Table, etc. in Power BI.
• Created different Roles for different individuals and managed their access to reports and data by implementing the Row Level Security.
• Worked in adding the data sources to the gateway and troubleshooting during the issues in Power BI service.
• Published Power BI Reports in the required originations and made Power BI Dashboards available to Web clients.
• Created hierarchies in Power BI to help end users make accurate decisions based on the visualizations.
• Experience in creating Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard.
• Implemented Row-Level Security, restricted Sharing and Publishing, restricted Export and Printing.
• Involved in developing stored procedures, Triggers and SQL Scripts for performing automation tasks.

Environment: Power BI Desktop, Power BI Pro, DAX, T-SQL, MS SQL Server 2008 R 2/2012/2014/2017/2019 , Oracle 12c/19c, SQL Server Management Studio (SSMS), SQL Profiler, Denodo, Python, MS-Excel.

Confidential, New York, NY

Power BI Developer

Responsibilities:

• Worked closely with business users to analyze business requirements and translating them to technical specifications.
• Used Power BI desktop to directly connect to database tables (Direct Query Mode).
• Performed data cleansing and eliminated duplicate information using Query Editor.
• Append and merge tables from different data sources using Query Editor.
• As per requirement, performed different types of transformations in Power BI Query Editor.
• Used Azure Analysis services and made a live connection possible to work with the tabular models of Analysis services.
• Created different reports, published it, and created dashboard for end user based on requirements from business.
• Performed Data Modeling and build reports by using different charts and visuals available in Power BI
• Developed reports and visualization using DAX like aggregation function, iteration functions.
• Implemented different Filters and Slicers to get accurate information according to the user’s requirement.
• Published Power BI Reports in the required originations and made Power BI Dashboards available to Web clients.
• Worked on creating hierarchies in Power BI which helped user for improvised and advance decision making.
• Participated in using R to collect the data in Power BI Desktop.
• Used Python for detailed analysis of data that is necessary to be presented.
• Experience with performing SSIS data transformations, control Flow Task, data flow tasks like Sort, Derived Column, Union-All, Merge, Execute SQL Task.
• Experience in creating Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard.
• Installed, configured, and implemented both Enterprise gateway and Personal gateway in POWER BI service.
• Worked on Row-Level Security, restricted Sharing and Publishing, restricted Export and Printing.
• Provisioned access to users to view the Power BI Report.
• Involved in developing stored procedures, Triggers and SQL Scripts for performing automation tasks.

Environment: Power BI Desktop, Power BI Pro, DAX, T-SQL, MS SQL Server 2008 R 2/2012/2014/2017/2019 , Oracle, SQL Server Management Studio (SSMS), SQL Profiler, Python, MS-Excel

Confidential, New York

Power BI Developer

Responsibilities:

• Used various sources to pull data into Power BI such as SQL Server, Excel, Snowflake, etc.
• Wrote complex SQL Queries, modified stored procedures, and efficiently retrieved data from the database.
• Managed Indexes and tuned queries by using an execution plan for optimizing the performance of databases.
• Customized calculated columns and measures utilizing DAX in Power BI desktop.
• Implemented transformations and blended data with options such as merge queries and append queries in Power BI Desktop.
• Created dashboards in Power BI service by adding tiles from reports, and quick insights.
• Created reports using Bar chart, Column chart, Donut chart, maps, Scatter Plot, Line chart, Card as well as Slicer and applied filters on Visuals, Page and Reports for better interaction of visuals.
• Also integrated custom visualization as per the business requirement.
• Troubleshooting and performance tuning Power BI reports for optimization
• Utilized datasets in Power BI service for refreshing data and implementing gateway.
• Configuring Power BI Enterprise Gateway to keep the dashboards and reports up to date.
• Contributed in building reports in Power BI from scratch.
• Worked with both direct query and import data in Power BI for creating reports.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Experience in developing Dashboards, Reports, Sub reports by region and service type, and Monthly claim reports
• Created Static and Dynamic Row-level Security in Power BI Desktop and assigned roles to users via service.
• Published reports to Power BI services (Pro) and schedule subscription for Dashboards in Power BI Service

Environment: - Power BI Desktop, Power BI Pro, DAX Studio, T-SQL, MS SQL Server 2008 R2/2012/2014, SQL Server Management Studio (SSMS), SQL Profiler, MS-Excel.

Confidential, Newport, New Jersey

Power BI Developer/Data Analyst

Responsibilities:

• Wrote T- SQL scripts to validate and correct inconsistent data in the staging database before loading data into the database.
• Extensively made use of the T-SQL in creating and altering Stored Procedures, tables, and views and other SQL joins, statements and also created user profiles, relational Database models, data dictionaries, and data integrity.
• Extensively used Joins and sub-queries for complex queries involving multiple tables.
• Imported and transformed the data with power Query editor by using the features like Replace, Extract, Transform, Append, Merge, remove blank rows, splitting columns, Pivot and loaded the data into the data Model.
• Created calculated columns and measures using Data Analysis Expression (DAX) language and also made use of the time intelligence functions like date, Counting, Logical and Aggregation functions.
• Used Microsoft Power BI Desktop and Power BI Pro to Build and maintain the reports and dashboards respectively.
• Designed and built Reports, Dashboards and Deployed into Power BI Service and managed access of reports and data for individual users using Roles.
• Filtered data from the source system with the help of Power BI transformations.
• Created Workspaces and content packs to share insights to business customers and partners.
• Integrated custom visualization according to the business requirements document.
• Migrated existing reports to Power BI.
• Used Bar Chart, Line chart, Area Chart, Pie, Donut, Gauge Chart and slicers and different levels of filters in Power BI reports according to business analysis.

Confidential, New York, NY

Power BI Developer

Responsibilities:

• Extensively worked with Business Analysts and Data modelers in analysis of business requirements.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure etc.
• Experience in writing complex stored procedures, functions, Indexed views and triggers and T- SQL queries for data consistency and manipulation.
• Experience in working OLTP/OLAP system study, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Worked on all kinds of Transformations available in Power BI
• Determined calculations to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas.
• Performed time series analysis using DAX expressions in Power BI.
• Created calculated columns and Measures in power BI desktop to show good data analysis techniques.
• Effectively used data filters and hierarchies feature in Power BI.
• Transformed data with hierarchies, calculated columns, measures and merge operations with Power query.
• Wrote simple custom functions in Power BI editor with M code according to business logic.
• Developed and maintained multiple Power BI dashboards/reports and content packs for the end users.
• Performed Designing and modeling of data sets with Power BI desktop based on measure and dimension requested by business and dashboard needs.
• Scheduled Automatic refreshes in power BI service.
• Created data alerts, subscriptions to receive notification based on data changes on Power BI services.
• Implemented numerous filters in Power BI such as page level, report level and drill through filters as per the requirement.
• Enhanced Power BI reports with features such as row level security, color formatting and modifying relationship.

Environment: - Power BI Desktop, Power BI Pro, DAX, T-SQL, PostgreSQL, MS SQL Server 2008 R2/2012/2014, SQL Profiler, MS Visio, SharePoint, MS-Excel.

Confidential

SQL Developer

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation,Requirementsgatheringandunderstandingthe business flow.
• Designed theFunctional Requirements andMapping Technical Specificationson the basis ofFunctional Requirements.
• CreatingIndex, Views, Complex Stored Procedures, Triggers, Cursorsand appropriateUser defined functionsto implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data fromflat files,Excel spreadsheets, and XML Sourcedata to SQL Server usingSSISand used BCP and Bulk Insert.
• Designeddashboards,including scorecards and reporting with theDashboard Designer delivered via MOSS (Confidential Office SharePoint Server).
• Involved in data modeling for the application and created ER diagram using Erwin.
• Created, Maintained & scheduled various reports inSSRSlike Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report using SQL Server Reporting Services SSIS 2005.
• Proficient on and designing Data Mart and Data Warehouse usingErwin in Star and Snowflake Schemas.
• Helped Database administrators with power shell in building robust administration scripts.
• Responsible for support of MOLAP structures using Analysis Services 2005 and reporting structures in MS EXCEL and Reporting Services 2005.
• Designed and MaintainedSSISPackages for Importing and Exporting Data Migration and Conversion fromLegacy Systems to SQL Server 2005.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Created document for Self-Service Deployment and Execution process forSSISpackages
• Interacting with the users and troubleshooting the problems involved with the development ofstored Procedures, triggersandproblemsrelated to the privileges.
• Responsible to tuneETLprocedures and schemas to optimize load and query Performance.

Environment: SQL Server 2005, MS Access, SSIS, SSRS, Query Analyzer, ERWIN, Windows server 2003, DTS, T-SQL, SQL Profiler, DTS