Power Bi Developer/ Bi Developer/ Database Engineer Resume
SUMMARY
- Business Intelligence with experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R 2/2012/2014/2016/2017 , SSIS, SSAS, SSRS, and Power BI
- Experience in creating Tables, Constraints, Indexes, Joins, Cursors, Views, Complex Stored Procedures, Functions, Triggers, reports, and data validation
- Experience in writing complex T - SQL, with features like CTE, Ranking Functions, TOP(n), PIVOT, database design, and performance tuning .
- Experience in understanding client business requirements
- Experienced in working with various Software Development Life Cycle (SDLC) including Analysis, Design, Development, Testing, and maintenance
- Comprehensive technical knowledge with analytical skills to analyze complex business requirements, develop and deploy solutions with enhanced productivity and efficiency.
- Experience in SQL Data Development. ETL development using SSIS, Business Intelligence delivery using SSAS and Reporting solutions using SSRS.
- Expert in ETL (Extraction, Transformation, and Loading) tools using SQL Server Integration Services (SSIS) Data Transformation Services (DTS), Data Flow Task, Bulk Copy Program (BCP), Bulk Insert, and Error Handling in SSIS.
- Expertise in designing SSIS packages to import, extract, transform, clean data from databases and external data sources using various transformations.
- Expert at using SQL Server Analysis Services (SSAS) to develop Multi-dimensional Objects (Cubes, Dimensions)
- Experience in Cube design and developments using SSAS.
- Experience in building measures in SSAS Tabular model using DAX queries
- Extensive use of DAX expressions in tabular models as per business requirements
- Expert at creating and deploying SSAS cubes using Star Schemas and Snowflake Schema.
- Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed, and Scheduled the Reports in Report Manager.
- Highly Proficient in creating SQL Server Reports, handling sub-reports, and writing queries to perform Drill through and drill down operations in SSRS.
- Experience in Database Installation, Maintenance, Configuration, Monitoring, Backup, and Disaster Recovery procedure, and Replication.
- Expert in Power BI, Power BI Mobile, Power BI Pro.
- Experience in creating and developing Power BI Dashboards into a rich look
- Highly analytical with problem-solving skills, well-organized, and a strong ability to prioritize multiple tasks.
- Goal-oriented, excellent communication skills, proactive, diligent, effective team member, and the ability to take on new roles.
TECHNICAL SKILLS
Applications / BI Tools: SSIS, SSRS, SSAS, Microsoft Data Transformation Services (DTS), MS Access, SQL SERVER, MS Visio, SQL Server Business Intelligence Development Studio (BIDS, MS Visio, SQL Profiler, Query Optimizer, DTS Designer, SQL Server Agent, MS Excel, Power
Development skills: Power BI, T-SQL, PL/SQL, SSIS/SSAS/SSRS
Languages: SQL, T-SQL, PL/SQL, DAX, MDX, Visual Basic
ETL Tools: DTS, SSIS (SQL Server Integration Services), Database Migration Assistant (DMA), SQL Server Migration Assistant (SSMA)
Reporting Packages: Power BI, SQL Server Reporting Service (SSRS), MS Excel.
Operating Systems: Windows XP, Window 7, Window 8, Window 10, MS SQL Server 2019/2017/2014/2012/2008 R2/2008, Oracle, MS Access
Data Warehousing & BI: Star Schema, Snowflake schema, Facts, and Dimensions Tables
Workflow Tools: GIT, Subversion, MS Visio Visual Source Safe (VSS), Team Foundation Server 2010 (TFS).
Others: Visible Analysis and Troubleshooting, WinMerge, DbForge, RedGate, Jenkins, Notepad++
PROFESSIONAL EXPERIENCE
Confidential
Power BI Developer/ BI Developer/ Database Engineer
Responsibilities:
- Database Migration: Used SSIS tools to create ETL packages that validate, extract, transform, and load data from Oracle, and different other sources to SQL server
- Performed the extraction, presentation, and analysis to develop new solutions that support business needs.
- Configured SSIS packages with checkpoints, logging, error logging, and event handling to redirect error rows and fix the errors in SSIS.
- Used merge statements to modify data in a target table based on data in a source table.
- Configured SSIS packages with checkpoints, logging, error logging, and event handling to redirect error rows and fix the errors in SSIS.
- Worked in Building Tabular Models using SSAS
- Built Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
- Built Measures in tabular model using DAX queries and created partitions in tabular model.
- Used Analysis services as data source for Power BI reports
- Used DAX functions in Power BI
- Used various sources to pull data into Power BI such as SQL Server, Oracle, Excel, JSON, PDF, XML, Text/CSV, etc.
- Installed and configured Enterprise gateway and Personal gateway in Power bi service
- Created Workspace and content packs for business users to view the developed reports.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
- Worked on all types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model.
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
- Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
- Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, ADO NET Source, ADO NET Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task
- Created data visualization solutions and report dashboards using different visualization such as gauge, Charts, Tables, matrix, funnel chart, stacked column chart, stacked bar chart, slicer, pie chart, doughnut, etc.
- Created Drill Down Reports, Drill Through Report
- Manage SQL Database Servers for various environments with best practices (Dev / QA / LOAD / UAT / Prod)
- Configure & Secure databases and User Privileges to avoid unauthorize access
- Troubleshoot issues related to SQL database reported by users and app team
- Index Maintenance - Reviewing un-used indexes and review the index statistics usage and take necessary actions required if any.
- Support Deployments & Change requests to databases
- Review slow queries and queries not using indexes regularly and suggest ways to improve the query performances based on the usage pattern.
- Develop / Review stored procedures to support manual data corrections based on the request from App team.
- Work with LOAD Team in monitoring the database servers during the load tests.
- Performance tuning and code review
- Proficient understanding of code versioning tools such as GIT and Subversion
- Proficiency in data archiving
Confidential
Power BI Developer/SQL Server BI/SSIS/SSAS/SSRS
Responsibilities:
- Used SSIS tools to create ETL packages to validate, extract, transform, and load data to data warehouse databases.
- Analyzed business requirements and created business/process flow charts, database flow charts, and reporting tool database for Research Revenue Management track.
- Used SSIS tools (Derived Columns, Condition Split, Data Conversion, Aggregations, Multicasting, etc.) for data transformation based on the ETL Documents.
- Created enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes, which make use of multiple value sections in parameters pick list, cascading, and dynamics reports.
- Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency, and accuracy in reporting and data analysis.
- Enhanced query performance activity using optimization techniques-normalization and indexing.
- Created SSAS Tabular Models off the data warehouse with different measures.
- Involved in creating complex measures by DAX in SSAS Tabular model according to business requirements.
- Created data visualization solutions and report dashboards using Power BI.
- Performed Queries tuning and Stored Procedures as well as ETL packages.
- Created and developed Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts, Graphs, drill down reports, Drill through reports, Drill Sub-Reports, and Parameterized reports using SSRS.
- Designed, developed, and implemented test plans, user documentation, and completing projects on schedule.
- Designed, developed, and implemented Power BI Dashboards, Custom Reports, Scorecards, and KPI Reports using data from different sources like SQL Server, Excel, CSV, Share point.
- Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
- Used DAX functions in Power BI and Power Pivot.
- Installed and configured Enterprise gateway and Personal gateway in Power bi service.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Designed and created data extracts, supporting SSRS, and Power BI visualization reporting applications.
- Exported reports in different formats like pdf, excel, etc. to be executed automatically on a weekly or monthly basis and manage subscriptions.
- Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
- Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
- Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
- Built interactive reports, dashboards, integrating modeling results, and strong Data Visualization design and analytic background using Power BI.
Environment: SQL Server 2008 R2/2012, SQL Server 2017, SSDT, MS Excel, Visual Basic, Power BI.
Confidential
SSIS/SSRS/Power BI Developer
Responsibilities:
- Database development utilizing Microsoft SQL Server OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation, and Loading). Database Administration including backups, recovery, database maintenance.
- Handled development for reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
- Performed the extraction, presentation, and analysis to develop new solutions that support business needs.
- Created Tabular, Matrix reports (crosstab or pivot), Charts, and graphs as per customer requirements Using SSRS.
- Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery, and Report security.
- Worked on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
- Created SSIS packages to validate, extract, transform, and load data to data warehouse databases.
- Configured SSIS packages with checkpoints, logging, error logging, and event handling to redirect error rows and fix the errors in SSIS.
- Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
- Build the SSIS packages to load Data from OLTP into Staging, ODS, and dimensional model.
- Used merge statements to modify data in a target table based on data in a source table.
- Performed efficient SQL queries tuning for data load/ Usage of stored procedures for performance
- Created XML schemas to update user tables and system objects for company data dictionary
- Generated reports in Table and Matrix format using Reporting Services (SSRS) and Power BI to display in a customized form as per business requirements
- Served as a team member in Project Management and Software Development Life Cycle (SDLC), including analysis of business function, testing, and documentation, and planning for redesign or transition to another platform.
- Applied security to reports on item and folder level.
- Created and executed SQL statements in both SQL production and development environments.
Environment: SQL Server 2008 R2/2012, Visual studio 2008/2012, Microsoft Access, Power BI, BIDS
Confidential
SQL Server Developer/SSIS/SSRS/SSAS
Responsibilities:
- Created and deployed SSAS cubes using Star Schemas and Snowflake Schema.
- Worked on all activities related to the development, implementation, administration, and support of ETL processes
- Designed and developed a data warehouse, data marts, and business intelligence using multi-dimensional models - star schema.
- Created SSIS packages to validate, extract, transform, and load data to data warehouse databases from various sources like Text Files, Excel, and SQL Database.
- Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Look Up, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination, etc.
- Design, Implement and maintain Database Schema, Entity-relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults, and complex SQL statement.
- Created trace in SQL Profiler and used Database engine tuning advisor for Performance tuning on stored procedures and Scripts.
- Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill-down reports, drill through reports, linked reports, click-through reports, Sub Reports, Gauges, Pie Chart, Bar Chart
- Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
- Scheduled the reports to run on a daily and weekly basis in the report manager and email them to managers and analysts to review in an excel spreadsheet.
Environment: Window Server 2003, MS SQL Server 2012, SSAS 2008, SSRS 2008, SSIS 2008, T-SQL, Visual Studio 2008, DTS, Data Analyzer, MS Access, Word, Excel, SQL Profiler, Window XP, Notepad++, XML