Sql/power Bi Developer Resume
4.00/5 (Submit Your Rating)
Columbus, OhiO
PROFESSIONAL SUMMARY:
- A Microsoft SQL, SSIS,SSRS and POWER BI Developer and Analyst with 7+ years IT experience: As a professional Database and BI developer and Analyst, I have implemented supported both OLTP and OLAP applications, created different database and database objects using SQL Server, created application integration and data transformation using SSIS packages and developed reports using SSRS, TABLEAU and POWER BI. Hands - on experience in Power BI platforms: Power bi desktop, Power Bi Service, power bi mobile app, power Bi report builder. Specializing in Data Warehouse, Power BI Reporting Service, SQL Server, Azure Cloud Computing, ADF (Azure Data Factory), Database and BI developer with SQL Server, Developing Complex SQL query SSMS and Data Modeling. I specialize in Microsoft Power BI to create a report using datasets and Power Bi desktop tools to understand the data in depth.
- Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.
- Possess strong communication and problem-solving skills developed through a variety of projects. Offer proven ability in team work and proactive system support.
- Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
- Experience supporting Data Flow transformations: Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
- Expertise in enhancing and deploying SSIS packages from development server to production server.
- Keen understanding of dimensional Star Schema and Snowflakes Schema.
- Experienced in Microsoft Power BI Premium, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.
- Design and develop Power Bi report and dataset gathering, manipulating, and loading data.
- Play a variety of roles with a high degree of proficiency throughout a BI/DW project lifecycle: Solution Architect, Power Query Data Prep and Modeling, Report Developer, Power BI Administration, DeploymentPipelines,Workspace and App Administration, DAX, etc.
- Adhere to compliance procedure and internal/operational risk controls in accordance with all applicable regulatory standards and policies .
- Perform data analysis, including data profiling, to obtain a good understanding of data availability, relationships and nuances for consideration of BI solution design and DAX.
- Conducted advanced econometric modeling using Cross-sectional data (Data gathered across various entities at a point in time), Time series data (Data gathered for the same entity over time), and Panel data (Data gathered across entities over time).
- Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
- Good experience in configuring and working the SQL Server in Azure and AWS Cloud Environments.
TECHNICAL SKILLS:
RDBMS: SQL Server 2019/2016/2014/2012/2008, oracle, azure, snowflake
Languages\Tools: Visual Basic, PowerShell, Power Automate, C#, T-SQL, Java, python, .Net.
Modeling Tools: MS Visio and Oracle SQL Server Data Modeler.
Visualization: Power BI Desktop, SSRS, Tableau, Report Builder, Visual Studio
Analysis Tools: SQL Server Analysis Server (Tabular and Multi-Dimensional)
WORK EXPERIENCE:
Confidential, Columbus, Ohio
SQL/Power Bi Developer
Responsibilities:
- Worked closely with Business Analyst and all team within the organization to understand business processes.
- Developed complex SQL queries, stored procedures and views to be used in Power BI reports as well as for ETL workflows and performed optimization of databases and tuning of long running SQL Queries by using SQL Server Profiler and SQL Tuning Advisor.
- Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
- Used the tabular model cubes as the source in Power BI to visualize the data.
- Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
- Created interactive reports customized for the business using Power BI Desktop.
- Installed and configured and maintained Power BI Report Server.
- Worked on a project in the migration of Tableau reports to Power Bi report server.
- Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.
- Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
- Cleaning up datasets using marge queries, append queries, and sort data column to properly fit our reports.
- Created Dax Queries to generated computed columns in Power BI, also applied DAX calculated measures and columns.
- Generated computed tables in Power BI by using Dax.
- Involved in creating new stored procedures and optimizing existing queries and stored procedures.
- Created Azure Blob Storage for Import/Export data to/from .CSV File, also assess and analyze dataset and KPI’s to create reports.
- Used Power BI to created visualization tools intended for diverse users.
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
- Explore data in a variety of ways and across multiple visualizations using Power BI.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
- Published reports and dashboards using Power BI.
- Play a variety of roles with a high degree of proficiency throughout a BI/DW project lifecycle: Solution Architect, Power Query Data Prep and Modeling, Report Developer, Power BI Administration, DeploymentPipelines,Workspace and App Administration, DAX, etc.
Confidential, Pittsburg, PA
SQL/ETL/Power BI Developer
Responsibilities:
- Worked closely with SME’s end users/internal customers to understand project/requirement scope
- Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes
- Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (Used CTE, temporary tables, user defined table types in codes developed)
- Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2014/2017.
- Experience in Power BI and with different BI component like (Oracle, SQL, SSIS, SSRS, SSAS).
- Manage, monitor, and improve Power BI environment including ongoing changes and active product backlog.
- Experience in automating tasks and work flows between applications and services using Microsoft Power Automate tool.
- Imported data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports.
- Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
- Load data into dimensions and fact tables using slowly changing dimension using SSIS.
- Worked on SSIS logging, Error Handling and Package configurations.
- Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.
- Created Azure Blob Storage for Import/Export data to/from .CSV File, also assess and analyze dataset and KPI’s to create reports.
- Used Power BI to create visualization tools intended for diverse users.
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
Confidential, San Francisco CA
Business Intelligence Developer (SQL/SSIS/SSRS/SSAS)
Responsibilities:
- Worked closely with internal and external users to understanding and gathering business requirements.
- Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.
- Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraint.
- Perform data analysis, including data profiling, to obtain a good understanding of data availability, relationships and nuances for consideration of BI solution design and DAX.
- Validated existing system for data analysis and design of new system which accommodates diverse sources of data;Requirements collection, elicitation and database design;
- Conducted advanced econometric modeling using Cross-sectional data (Data gathered across various entities at a point in time), Time series data (Data gathered for the same entity over time), and Panel data (Data gathered across entities over time).
- Analyzed structured and unstructured large amounts of data.
- Regularly monitored SQL server, analyzing the logs, troubleshooting SQL Server problems such as Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.
- Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
- Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.
- Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.
- Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher periodically.
- Log shipping database for reporting server within the firms’ latency objective.
- Mirrored one of our critical databases with zero latency/synchronized- with witness/for critical Database on SQL 2008.
- Part of the team which configured AlwaysOn with availability group for one of our critical servers on SQL 2012 that was installed via nodes on WSFC (Window Server Failover cluster).
- Performed full, differential and transaction log backups.
- Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.
- Used the SQL Server profiler to capture and store the execution plan.
- Provided weekly, monthly, yearly quality control reports for work orders, service requests.
- Represent reports in different forms using graphs, charts, tabular, area and pie charts as required.
- Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
- Worked with XML configuration files and variables for deploying SSIS packages into various environment.