Power Bi/msbi Developer Resume
IllinoiS
SUMMARY
- Over 5 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, SQL SERVER, MSBI and Power BI.
- Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
- Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
- Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
- Experience inOLTP/OLAPenvironment andData Warehouse.
- Experience indesigning, developing and deployingBusiness Intelligence solutions usingSSIS,SSRS, SSAS, Power BI
- Expert in creating multiple types of reports using tools like Power BI and SSRS.
- Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
- Designed and developedmatrix and tabular reportswifdrill down, drill throughusingSSRS.
- Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
- Worked as MS SQL Server Developer on enterprise and performance critical applications.
- Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
- Involved in migration of legacy data by creating various SSIS packages
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
- Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill - down, Drill-through and Cascading reports using SSRS.
- Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
- Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
- Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQLServer Performance.
- Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
- Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages
- Experience in tuning the reports dat includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
- Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
TECHNICAL SKILLS
RDBMS/DBMS: MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97
Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio
Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.
Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7
Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts
Design Technologies/Tools: Erwin, MS Visio, Rational Rose
Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell
PROFESSIONAL EXPERIENCE
Power BI/MSBI Developer
Confidential, Illinois
Responsibilities:
- Gatheird report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
- Installed and configured Power BI Desktop.
- Created Power BI Visualizations and Dashboards as per the requirements.
- Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
- Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2012 and Flat files.
- Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
- Created SSIS packages to integrate the data coming from flat files
- Migrated SSIS Packages from during data migration.
- Optimized queries by looking at Execution Plan for better tuning of the database.
- Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
- Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
- Created SSIS packages for loading data from SAP BW/BI to SQL Server.
- Performed database backup and deployment to the production server.
- Involved in modifying existing DataStage Jobs for better performance.
- Created detail Technical documentation of various staging area operations for future reference and guidance.
- Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2012).
- Installation and configuration of SQL Server Reporting Services (SSRS) 2012
- Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2012).
- Involved in Normalization and De-Normalization of existing tables for faster query retrieval
- Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.
- Designed STAR, SNOW FLAKE Schemas.
Environment: MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.
Power BI/MSBI Developer
Confidential, Indianapolis
Responsibilities:
- Experienced in developing and deploying SSIS packages using various transformations to load and generate data to and for using various source and destinations.
- Created SSIS Packages using containers to load files all at a time and to archive to separate folders according to business requirements.
- Created multiple SSIS packages and Reports for delivering data to the end client through reports by emailing them directly the locations for the output files.
- Designed and implemented TSQL queries for reporting and complex solution development.
- Worked on SQL Server database for creating the schemas related to the physical data model of the project, creating SSIS Packages, External tables for extracting data from Azure Data Lake.
- Took the ownership of live site team when project went to live, prioritizing the customer satisfaction.
- Migration of on premise data (SQL Server) to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2), Azure Data Bricks
- Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, and Azure Analysis Service.
- Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB
- Design Setup maintain Administrator the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse
- Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
- Experience in Data Migrating /data integration, data validation and cleaning, data mapping using SSIS.
- Experience in creating SQL Jobs and backup scripts, Alerts, SQL Mail Agent, Database Mail, and Scheduled DTS and SSIS Packages based on Business or application needs.
- Utilized Power BI (Power View) to create various analytical dashboards dat depict critical KPIs along wif slicers and dicers enabling end-user to make filters.
- Developer Power BI for creating reports according to business requirements and Power Pivot to develop a data analysis prototype, for advanced visualizes reports.
- Implemented DAX functions for various fact calculations for efficient data visualization in Power BI.
- Utilized Power BI gateway to keep dashboards and reports up to date wif on premise data sources.
- Experienced working wif Team Foundation Server (TFS) for code review to check in and check out the codes
- Collaborated on all stages of system development lifecycle, from requirement gathering to production releases.
Environment: MS SQL Server 2016, Microsoft Visual Studio 2015, Azure, SQL Server Data Tools, Power BI Desktop, Excel Power Pivot, Team Foundation Server, T-SQL
SQL/BI Developer
Confidential, Boston, Massachusetts
Responsibilities:
- Understanding and experience wif the Software Development Life Cycle (SDLC)
- Design and test solutions to existing database structure, Teradata SQL queries, stored procedures, views, triggers and functions.
- Help support reporting analytics dat is being driven by business trend analysis
- Design and develop Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
- Utilize Power BI (Power View) to create various analytical dashboards dat depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
- Configure large database solutions in Azure using SQL Server or Oracle database solutions
- Experience in Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
- Create SSAS cubes wif KPIs and aggregation for the front-end analysis team.
- Implemented problem management process involving complete root-cause analysis. Coordinated and ran meetings to determine root-cause of issues by analyzing incidents and trends.
- Design SSAS Cube and developed MDX queries for Analysis.
- Translate business user concepts and ideas into comprehensive business requirements and design documents.
- Hands - on experience in Azure Cloud Services (PaaS & IaaS), Storage, Web Apps, Active Directory, Application Insights, Logic Apps, Data Factory, Service Bus, Traffic Manager, Azure Monitoring, OMS, Key Vault, Visual Studio Online (VSO), Cognitive Services (LUIS) and SQL Azure.
- Improved application performance usingAzure Searchand SQL query optimization.
- Provide support, including solution design, backup, restore, monitoring & troubleshooting
- Analyze quantitative and qualitative business data to develop a solution design capable of fulfilling the customer's related to forecasting.
- Generate ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- ImplementedAzure Application Insightsto store user activities and error logging.
- Utilize Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
- Implement several DAX functions for various fact calculations for efficient data visualization in Power BI.
- Utilize Power BI gateway to keep dashboards and reports up to-date wif on premise data sources.
- Utilize Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
- Create reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
Environment: T-SQL, Azure, Power BI, MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), ETL, XML, MS Excel, C# .NET, SharePoint, ER-Studio, TFS
SQL/BI Developer
Confidential
Responsibilities:
- Involved in Technical discussions and decisions for Business requirements, Interaction wif Business Analysts, Client team and Development team.
- Experienced in database design process and data modeling process.
- Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
- Designed SQL Server Database and Table Design wif Schemas, Constraints and Views.
- Extracted data from various sources like DB2, VSAM, SQL Server 2012/2008 R2, .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 the data into Data Warehouse.
- Created a report model on SSAS cubes.
- Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
- Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
- Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
- Gatheird Report Requirements and designed Reports, Matrix, Table Reports wif Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
- Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
- Developed reports wif consistent drill-down functionality including Drilldown report and Summary report.
- Ensured constraints and writing triggers/linked server scripts to apply the 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 Multi User Environment. Created RS Config Files and Ensure Report Security wif Keys.
- Involved in Installation, Configuration and Deployment of Reports using SSRS wif Scale-Out topology.
- Worked closely wif QA team and helped them come up wif test scenarios.
- Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings
Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server
BI Developer
Confidential
Responsibilities:
- Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation
- Translating business requirements into technical design specifications
- Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012
- Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models
- Installed and configured and maintained Power BI Report Server.
- Created reports on Power BI Desktop and published on Power BI Report Server.
- Created access for users to use the Power BI reports on the web and across mobile devices.
- Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column
- Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
- Created SQL queries and developed Dashboard style of reports as per business needs
- Created and schedules tasks for reloading and distribution of Data in Tableau
- Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.
- Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements by using SQL Server 2012 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, Power Query, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, ALM, Anaplan, Tableau, Power BI
