SUMMARY

• Having total 8+ years of IT experience, highly professional and well - versed MS POWER BI and SQL Developer with over all 7+ years of experience in designing and developing with strong background in Data warehousing and ETL. 1 years of experience in Quality Analyst
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis and Reporting Services(SSRS).
• Experience in design and development of Power BI graphical and visualization reports as per business requirement documents (BRD).
• Extensive knowledge in creating and developing power BI dashboards and reports using table, matrix etc visualizations by developing pipelines using power BI desktop as well as premium.
• Experience developing and supporting Microsoft BI and reporting capabilities (Power Pivot, Power BI, Power View) and implementing enterprise software solutions.
• Developed pipelines to move the data from Azure blob storage/fileshare to Azure sql Datawarehouse and blob.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions
• Expert in creating different visualizations using Slicers, Lines, Pies, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Expertise in developing SSRS reports using various type of metrics for scorecards.
• Created pipelines for entire SDLC life cycle for development, test and production using power BI premium service.
• Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud.
• Building pipelines to copy the data from source to destination in Azure data factory.
• Created Dax Queries to generated computed columns in Power BI.
• Applied transform rules data Conversion, data cleansing, data aggregations, data Merging and created new measures and new calculated columns for reports and dashboard analysis.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL processes across different servers.
• Utilized various Azure Data Factory tasks to implement a pipelines.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail, and schedule SSIS Packages based on Business or Application needs.
• Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Managed indexes, statistics, and tuned queries by using execution plan for optimizing the performance of the databases.
• Experience in working in agile scrum development methodology as well as Azure Dev ops.
• Knowledge of Azure Data Bricks while migrating On premise to Azure .
• Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments.
• Flexible and versatile to adapt to new- environment and technologies.

TECHNICAL SKILLS

Business Intelligence Tools: Microsoft Power BI Desktop

Database: SQL SERVER, MS AZURE SQL DB

Skills: MS Excel, PowerPoint, Word

Operating System: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr Power Bi Developer

Responsibilities:

• Imported data from amazon redshift ODBC driver to Power BI to generate reports
• Created Stored procedures scripts using CTE’s, tables, and as per the business requirement and views to maintain the metrics.
• Developed scorecards using SSRS for both the Tales as well failure to load reports that can aid to create the metrics.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Experience in web development using HTML5, CSS3, JavaScript, jQuery, React, and Angular
• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards
• Migrated Crystal report to Power BI Report Builder in Microsoft Power BI Report Builder.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS.
• Optimized PowerBi Reports performance using Dax Studio and Query Editing & Execution.
• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
• Developed SSIS packages to populate the load from Legacy systems to Trust systems.
• Used Execute package utility in ADF to modify the existing SSIS packages to create an ADF pipeline and migrate it to Azure Synapse
• Responsible for creating the metrics tree and populating the Fact and Dimension tables that the helps to transform/load data.
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse
• Have extracted loaded and transformed data to copy the data from source to destination using Azure data factory.
• Have scheduled and created various dependencies of activities in ADF.
• Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
• Was responsible to for releasing the scorecards to QA and production with zero erros.
• Ensuring the mock for each and every scheduled month as per the jobs in SQL Agent scheduler.
• Experience Strong PL/SQL development
• Created Parameterized Reports and Linked Reports and thorough knowledge of Power BI report server architecture using SSRS
• Created Stored procedures scripts using CTE’s, tables, and as per the business requirement and views to maintain the metrics.
• We follow agile scrum development methodology as well as Azure Dev ops for enhanced performance in the project.
• Upgrading the current reports to cloud using power bi desktop, by transforming the existing reports in trust .
• Transform, define, and navigate the data from the data source and perform the merge and append queries using Power Query.
• Strong experience in designing and development of visualization reports using Power BI and Tableau using various relational databases including Azure SQL DB.
• Have used Azure BLOB storage for saving the input flat files excel file.
• Azure Data Factory for implementing the pipelines and flow to prepare for ETL migration.

Environment: Azure, Azure ADF, Power BI Desktop, DAX, Share point, SQL Server, T-SQL, Team forge, SSRS, SSIS, Visual Studio etc

Confidential, TX

Power BI Developer

Responsibilities:

• Used various sources to pull data into Power BI such as SQL Server, Excel etc to use self-service BI tools.
• Prepared BI inventory with respect to job plans, migration and list of all reports.
• Have maintained and logged all work items into Azure Devops.
• Have provided an approach to migrate the existing SSRS as well as power BI reports to Azure Synapse using various tools.
• Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE
• Leveraged GitHub project and Repository to manage code base and file for project
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Performance optimization using Dax Studio and Power BI Desktop Performance Analyzer
• Used Power BI, and Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Hands on designing and deploying excellent graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau
• Created Azure synapse scripts and have involved in tables creation and data migration from on premise SQL to Azure Synapse
• Used Execute package utility in ADF to modify the existing SSIS packages to create an ADF pipeline and migrate it to Azure Synapse.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, and Matrix reports using Power BI Report Builder.
• Experience in Business Intelligence and Analytics, Data Warehousing, Data Integration and Dash Board Reporting experience.
• Involved in Conceptual and Logical data modeling, user database schema design documentation and modification of triggers, scripts, stored procedures in database servers
• Cleaning the data by using some transformations like remove columns, Split, Group by, Merging, and Appending tables in Power Query Editor
• Involved in analyzing the data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSIS) and Power BI.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse
• Assist in Report Power BI Server administration, including maintaining the library of reports, security access to the reports, and offer training and consultation in report development.
• Created Parameterized Reports and Linked Reports through knowledge of Power BI report server architecture using SSRS.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Developed SSIS packages to populate the load from Legacy systems to Trust systems.
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
• Migrate data from traditional database systems to Azure SQL databases
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment. experience in DWH/BI project implementation using Azure DF

Environment: Azure Synapse, Azure ADF, Power BI Desktop, DAX, SSRS, SSIS, Share point etc.

Confidential, TX

Power BI Developer

Responsibilities:

• Worked closely and interacted with product owners to gather the requirements.
• Responsible to gather the calculation requirements for various business units from data analysts and business owners.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements.
• Creating different reports like Dynamic, Static, ad-hoc and compliance reports with SSRS, Power pivot and Power BI
• Responsible for providing full Power BI service administration - user management, workspace management, gateway administration, data source creation, monitoring, and troubleshooting.
• Performed data migration from Excel, Sybase and Oracle to MS SQL Server using SSIS
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse.
• Wrote MDX queries and expressions for use in Front End BI Applications and created SSRS reports.
• Business Intelligence (BI) experience with Tableau, Tableau Server and MS Power BI
• Used Power Bi External Tools: DAX Studio, Tabular Editor and ALM Toolki
• Launching the report builder for adhoc reports.
• Experienced in configuration of Power BI report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Developed SSIS packages to populate the load from Legacy systems to Trust systems.
• Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters for weekly finance metrics application.
• Responsible for writing various DAX expressions like SUM, DIVIDE, etc.
• Created various calculated columns and values for retrieving the data.
• Retrieved Data from Azure BLOB storage and developers Power BI reports.
• Created reports utilizing Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Developed Power BI reports using Power Query from SharePoint & different Data sources.
• Created the KPI to show the difference between actual and forecast data.
• By using Power BI desktop connected to various data sources, working with different visualizations.
• Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
• Published Power BI reports and made them available for required users and business owners.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory.
• Developed pipelines for development, Test and Production environments using power BI premium.
• Environment: Azure BLOB storage, Azure storage explorer, Power BI Desktop, SSRS, SSIS, Share point etc.

Confidential, TX

Power BI developer

Responsibilities:

• Worked closely with business and involved in gathering the user requirements.
• Responsible for writing and modifying stored procedures, functions, packages for data conversions to create database objects dynamically.
• Created indexes, tables, and sequences as per the business requirement and views to maintain data privacy.
• Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions
• Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Used SQL profiler to identify slow running queries.
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse.
• Experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools
• Analysed the requirements and framed the business logic for the ETL process.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed data migration from Excel, Sybase and Oracle to MS SQL Server using SSIS.
• Created package to transfer data between OLTP and OLAP databases.
• Designed Cubes with star schema using SSAS. Created hierarchies and partitions for improving SSAS cube performance.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
• Deployed and uploaded the SSRS reports to Report Manager and called reports through a URL from .Net API for the end users and involved in enhancements and modifications.
• Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters
• Used Agile Development Methodology.
• Point of contact for all the production issues.

Environment: T-SQL, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI

Confidential, NC

Test Engineer

Responsibilities:

• Requirement understanding.
• Raising question to get clarity on requirements in time.
• Test Cases Development and review.
• Gather data and report progress through standardized Automation reports
• Execute Test cases
• Report and regress bugs
• Pro-active knowledge share with peers.