PROFESSIONAL SUMMARY:

• 6+ years of professional IT experience in developing and designing Business Intelligence solutions utilizing Power BI and SQL Server.
• Extensive experience inPowerBIon 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 inPowerBIdesktop
• Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.
• Experience in implementing physical data model (Databases, Schema Tables, Views & Virtual Data Warehouse)
• Experience in relational database design, SQL queries likeJoins, stored procedures,views.
• Experience in Creating, Maintaining & scheduling various reports inPowerBIlike Tabular Reports.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI andSSRS
• Experience in Publishing Power BI reports from Power BI desktop to Power BI service.
• Created different visualizations in Power BI according to teh requirements.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data splitting.
• Expertise in DAX queries to get and better way to analyzing teh data.
• Complete understanding in all facets of Software Development Life Cycle (SDLC).
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Temporary Tables, Constraints and Indexes using various DDL and DML commands.
• Skilled in creating and developing BI Dashboards into rich look for better understanding.
• Experienced to generate underlying data for teh reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CSV files to teh data warehouse.
• Good logical, analytical, interpersonal skills and commitment to perform quality work as well as an excellent team player.
• Expert in creating different visualizations using Slicers, Lines, Pies, Maps, Scatter, Bullets, Treemaps, etc. using Power BI.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Having teh ability to work closely with teh team to ensure teh timely delivery of business requirements.

TECHNICAL SKILLS:

Reporting Package: Power BI( Desktop, Server, Pro), MS ( SSAS, SSRS), QMF

Integration Tools (ETL/ELT): Microsoft SSIS, Informatica10x/9x, IBM Datasatage, Alteryx

Data Modelling: Star and Snowflake with Erwin, Visio, SQL Architect etc

Cloud reporting services: Azure

Database tools: Microsoft SQL Server Management Studio, SQL developer, Toad

MS Office: MS-Excel, MS-Access, MS- Power Point, Office 365, Sharepoint

Databases: Oracle, SQL Server, DB2, Teradata, MySQL, XML

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL, T-SQL, Transact SQL, Python, R, PHP

PROFESSIONAL EXPERIENCE:

Confidential

Power BI Developer

Responsibilities:

• Deployed thePowerBIreports toPowerBIservices and pinned visuals to make dashboards out of it.
• Shared dashboards and reports with user groups by usingPowerBIApp and content packs
• Created a multitude of reports and dashboards with SSRS andPowerBI
• Analysed business requirements, facilitating planning and implementation phases of teh OLAP model in JRD meetings
• Participated in JAD meetings to ensure a common understanding with business, development, and test teams.
• Created dashboards in line with teh analytical uniformity using teh advanced analysis features ofPowerBIDesktop.
• Collected, stored, and retrieved business data for analysis and reporting purposes.
• Proactively monitored, determined and solved issues at SQL/database/server levels.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity
• Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure
• Implemented several DAX functions for various fact calculations for efficientdata visualizationinPowerBI.
• Building maps and partitioned SQL queries inInformaticatool to support teh large volume objects data migration.
• Structured and prepared teh data by creating fact and dimension tables in teh query editor.
• Involved in development of Incremental Load processes using SSIS Packages and various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Enhance and modifyPowerBIdashboardto make it understandable for different audience
• Contributed in creating Tabular Models and assisted in building ad-hoc reports.
• Involved in generating and maintainingSQLscripts
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Created reports inPowerBIpreview portal utilizing teh SSAS Tabular via Analysis connector.
• Generated ad-hoc reports in ExcelPowerPivot and sheared them usingPowerBIto teh decision makers for strategic planning.
• Deployed thePowerBIreports toPowerBIservices and pinned visuals to improve visualizations and presentations.
• Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report usingPowerBI.
• Participated in teh configuration of on-premisesPowerBIgateway to refresh datasets ofPowerBIreports and dashboards.
• Created a multitude of reports and dashboards withPowerBI
• Formatted reports with parameters and embedded functions with expressions.
• InPowerBIdeveloped reports by different time intelligence like year to data (YTD), Month to date(MTD), same period last year

Environment: Power BI, SQL Server 2012, Snowflake SSMS, SSIS, SSRS, SSAS, T-SQL, Power BI, Windows 7, MS Word, MS Excel, Visio, Share Point Jira, SQL Profiler

Confidential, Bentonville, Arkansas

Power BI Developer

Responsibilities:

• Designing, Development and implementation at all levels. (Application frontend and backend as well). Pick huge amount data from client applications through Middleware language (XML) and loaded into current Application.
• Replicated Excel reports in Power BI and Developed
• Multiple Power BI Dashboards/Reports.
• Assisted in Production OLAP, wrote queries to produce reports using SQL Server 2019, Reporting Service (SSRS)
• Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure, Excel, and SAP HANA.
• Created Workspace and Apps in Power BI and giving access to End-users to Apps.
• Configured Gateway in teh Power BI service and Implemented Data security (Row-level security) on Dataset and Reports in Power BI. Worked onPower BI, Power Pivot and Power Viewto visualize reports.
• Developed Power BI reports and dashboards for multiple data sources using data blending.
• Performed data quality analysis using advanced SQL skills. Performed Count Validation, Dimensional Analysis, statistical Analysis and data quality validation and data migration. Extensive SQL querying on staging, Data warehouse and Data Mart.
• Explored data in a variety of ways and across multiple visualization using Power BI.
• Responsible for Scheduling jobs for Weekly, Daily data refresh on different Power BI reports.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on teh business requirements. GeneratedMonthly, Yearly, Quarterly and Daily reportsinPower BI.
• Created Measures in Power BI depending on teh requirement using DAX queries.
• Created complicated DAX measures in teh Power BI reports as per teh requirements of teh Business Users. Generated Monthly, Yearly, Quarterly and Daily reports in Power BI.
• Worked on Power BI, Power Pivot and Power View to visualize reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts. Created Measures in Power BI depending on teh requirement using DAX queries

Environment: SQL Server Management Studio, T-SQL, MySQL, MS Access, Windows, Unix, Microsoft Power Bi, SSRS, SSIS, Zira, Tableau

Confidential

MSBI/Power BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from teh customer for developing reports. Worked in Building Tabular Models using SSAS. 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 Tableau server.
• Involved in creating dynamic well-organized, accurate and insightfulPowerBIreports/dashboards to support strategic decisions. Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, sorting columns and writing expressions according to teh business requirements. Transferred teh data using SSIS packages.
• Worked on Views, cursors, CTE’s, schemas, permissions, and performance issues with client/server database design.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup. Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS 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.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Generating Ad-Hoc reports on a timely basis and also to fulfil immediate requirements.
• Responsible for scheduling teh subscription reports with teh subscription report wizard. Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Used star and snowflake schema in designing cubes for creating SSAS packages.
• Created a cube using multiple dimensions and modified teh Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.

Environment: MS SQL Server 2008/2012 Enterprise Edition,MS SQL Server Reporting Services 2012,Pervasive, Windows Server 2007SSIS, SSRS, SSAS, TERADATA SQL, BTEQ.

Confidential

MSBI (SSIS & SSRS) Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed teh Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like Teradata, Facets, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading teh data into Data Warehouse.
• Created a report model on SSAS cubes.
• Designed teh Data Model based on Star Schema and created teh Tables and Indexes and developed teh scripts to load teh Datamart Tables.
• Identified teh issues and developed a procedure for correcting teh problem which resulted in teh improved quality of critical Tables by eliminating teh possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, Tested and Deployed SSIS packages using SQL Server 2014 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Also involved in migrating old SSRS reports to interactive dashboards in Power BI to deploy in Power BI service.
• Expert in creating Custom columns, Inserted Merged columns, filtering rows using Power BI.
• Used different kinds of visualizations like Line charts, Bar graphs, Scatter chart, Matrix table, Map, Card, Slicers.
• Also wrote DAX queries in power BI for performing calculations like Aggregations.
• Created detail reports using Drill through filters.
• Created Custom visualizations for business users to see their data in a way dat best fits for their business.
• Strong noledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Ensured constraints and writing triggers/linked server scripts to apply teh business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Deployed and Tested (UAT) Reports in Multiuser Environment.
• Part of teh Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: T-SQL, MS SQL Server 2014, MS SQL Server Reporting Services 2015, MS SQL Server Integration Services 2015, SVN, TFS, Octopus, Power BI

Confidential

SQL/BI Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined teh report layout in SSRS.Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load teh Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load teh data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix teh error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get teh new and updated records and tan used conditional split to select dat new records before inserting into teh database.
• Created Dimensions with teh cube wizard and T-SQL programming. Refreshing teh cube to get teh latest information updated for OLAP databases. Deployment of Cubes to teh production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for teh managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes TEMPeffectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on teh required reports, identified various data sources and established teh connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Involved in extracting teh data using SSIS from OLTP to OLAP.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web-based resource areas in collaboration with IT guidelines.

Environment: SQL Server 2008R2, SQL Services Integration Services 2008R2, T-SQL, XML, MS SQL Reporting Services 2008R2, SQL Profiler, MS Office, DB2, Windows Server 2008.

Confidential

 MSBIDeveloper

Responsibilities:

• Worked on T-SQL programming, stored procedures, user defined functions, cursors, views, and management of linked servers to non-SQL server database.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data from SQL to MS SQL as well as Created interface stored procedures used in SSIS to load/transform data to teh database.
• CreatedseveralSchemas,Tables,Cursers,TriggersandIndexes,IdentityColumn,IdentitySeeding, Calculated Columns as per teh requirement.
• Worked in troubleshooting and debuggingstoredprocedures, upgrading existing ones according to new requirements.
• Developed packages using various transformations likeMulticast,Conditional split,OLEDB Command,Script ComponentandLookupwhile loading teh data into Destination.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Usedagile methodologyfor teh development.
• Used SSIS jobs forimporting datafrom teh flat files dat brings teh data to teh application tables.
• Extensively usedJoinsto simplify complex queries/sub queries involving multiple tables and also optimized teh procedures and Indexes, Cursers and triggers.
• Created reports by dragging data from cube and wroteMDX scripts in SSRS.
• GeneratedKPIfor customer satisfaction survey results.
• Createdcomplex stored proceduresanduser defined functions, created manycascaded parametersin teh reports using MDX and SQL queries.
• DesignedETLpackages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded teh data into target data sources by performing different kinds of transformations usingSSIS.
• UsedTeam Foundation Server (TFS)for source control, and data collection.
• Createdparameterized Reportsusing Charts, Cross-Tab and Sub-report types.
• Worked onSQL *Loaderto load data from flat files obtained from various facilities every day.
• Createdusergroupsand accounts for users who could access teh reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.