We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Alpharetta, GA

SUMMARY

  • 5+ years of Information Technology experience in all phases of Software development life cycle (SDLC) including Database administration, Data Analysis and Business Intelligence.
  • Extensive experience in advanced SQL Queries and T - SQL in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, Joins, clustering, T- SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
  • Data storage technologies such as MSSQL, MySQL, Azure Cosmos DB and Azure SQL
  • In-depth knowledge of T- SQL (DDL, DML), Designing and Normalization techniques on the database tables.
  • Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access databases like SQL Server 2008/2005/2000 , Oracle 10g/9i/8i.
  • Expertise in Creating useful indexes achieve better query performance
  • Good in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling and error handling stored procedures and performing other maintenance tasks.
  • Expertise in using SQL on Oracle, MS SQL Server and MySQL.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Sort and Derived Column
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Extract data from access, excel, flat file, and different data base and load in SQL data base using SSIS packages and ETL
  • Experience in configuration and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
  • Extensive knowledge in Tuning T-SQL queries to improve the database performance.
  • Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
  • Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS)
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
  • Applied various data transformations like slowly changing dimension, aggregate, lookup, multicasting, conditional split and derived column in SSIS.
  • Strong Communication and Management Skills with excellent role-playing capabilities

TECHNICAL SKILLS

BI Tools POWER: BI, SSIS, SSRS, SSAS

RDBMS Servers: MS SQL Server 2016/2014/2012/2005

Operating Systems: Windows, Linux

Programming Languages: PL/SQL, T-SQL, Java

Databases: Oracle, SQL Server, NoSQL, DB2, MySQL, Azure, RedHat

Office Applications: MS Outlook, MS Project, MS-Excel, MS Visio

Configuration Tools: Team Foundation Server (TFS), GitHub

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Power BI Developer

Responsibilities:

  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Created numerous efficient stored Procedures to perform data cleansing and loading task when data is loaded into staging area
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
  • Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
  • Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
  • Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes
  • Extensively worked on OLAP Cubes using SSAS
  • Created and Managed OLAP Cubes using SSAS
  • Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
  • Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
  • DevelopedDynamic Report Enginefor creating the customized reports inSSRS.
  • Involved in creatingDynamic Stored Procedures and views.
  • Involved in analyzing and gathering the requirements forRow Level SecurityandRole based security.
  • Created the technical requirementDocumentationfor Row Level Security and Role Based SecurityETL’s.
  • Implemented Row level security and Role based Security in the Standard Reports.
  • Involved in creating the tree view folder structure in the application usingC#.netto handle different reports.
  • Involved in Creating and Testing theSSISpackages developed for security.
  • Involved in creatingSSISpackages to migrate large amounts of data.
  • Involved in usingSSASdata sources inSSRSreports.
  • CreatedDatabases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures, Triggers.
  • Involved inperformance tuningof queries for query efficiency.

Environment: MS SQL Server 2016/2014 Integration/Reporting Services/ Analysis Services, (SSIS/SSRS/SSAS), XML, Visual Studio 2008, C#.net, Power BI

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

  • Involved in database development usingstored procedures, triggers, viewsandcursors.
  • Used theObject Oriented Analysis and Design Specification Unified Modeling Language (UML)for visualizing, specifying, constructing, and documenting data.
  • Followed the Agile Methodology in the SDLC.
  • Created Databases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures, Triggers.
  • Wrote efficientstored proceduresfor the optimal performance of the system
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Responsible for Creating and ModifyingT-SQLstored procedures/triggersfor validating the integrity of the data
  • Createdindexedviews, and appropriateindexesto reduce the running time for complex queries
  • Generated custom and parameterized reports usingSSRS
  • Created reports that call sub reports inSSRS
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments
  • Actively involved in developing ComplexSSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Responsible for creating datasets usingT-SQLandStored Proceduresand also involved inData visualization.
  • Created several packages inSSIS.
  • Custom components forSSIS packageswere written inVB.net.
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals
  • Used various transformation tasks to createETLpackages for data conversion.
  • ImplementedEvent HandlersandError HandlinginSSISpackages and notified process results to various user communities
  • Responsible for rebuilding the indexes and tables as part ofperformance tuning
  • UsedSQL Server Agentfor schedulingjobsandalerts
  • Active part in creatingOLAP and ROLAP cubesand usedMDXqueries to retrieve data from the cubes.
  • PerformedQuery optimization&Performance Tuning

Environment: SQL Server 2014/2012 Enterprise Edition, SSIS 2005, SSRS 2005, .NET Framework, VB.net, ASP.NET, ADO.NET, WCF, Erwin, T-SQL, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, XML, MS Excel, MS Access, Visual Studio 2005.

Confidential

SQL Developer

Responsibilities:

  • CreatedStored procedures,Triggers and functions.
  • Resolved deadlock issues of the application usingSQL Profiler.
  • Worked with developers totune the queries, run scripts and move the database production to development servers.
  • Configured and maintainedSnapshot and Transactional replicationfor 3 environments.
  • Troubleshootingreplication errors and handling logs.
  • Created logical and physical data modeling for development database usingERWINtool.
  • CreatedSSISpackages for transforming data.
  • Createdschema objects, rules and granted roles to the users.
  • Worked and coordinated with developers in writing and tuning new stored procedures.
  • Worked onDTS packagesto import the data from Oracle, Access and text files.
  • Responsible for stored proceduresoptimization, performance tuning and index tuning.
  • ConfiguredRAID (Redundant Array of Independent Disks)levels.
  • Automated processes using SQL Server Jobs.
  • Set up backups for the newly created databases.
  • Scheduled transfer of backups and log files to different servers.
  • Provided a support for data issues and given appropriate solutions.
  • Provided training to development team on performance tuning and SQL best practices for enhancing application output.
  • Created tabular and matrix Reports usingSSRS.
  • Created the documentation for SQL server and service packs installations.

Environment: MS SQL Server 2005, MS Access, Oracle, Windows 2000/2003, VB.NET, ERWIN, XML, SQL Profiler, SSIS, SSRS UNIX.

Confidential

SQL Server (SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
  • Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
  • Developed reports in SQL Server Reporting Services.
  • Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
  • 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.
  • Successfully implemented indexes on tables for optimum performance.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Created SSIS packages to import data from MS Access, Excel to SQL 2005
  • Filtered bad data from a legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
  • Successfully managed Extraction, Transformation and Loading (ETL) process by pulling the large volume of data from various data sources using BCP in staging database from MS Access, excel.
  • Developed scripts to migrate data and the database objects to/from multiple sources.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Created useful functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
  • Worked with different Control Flow elements like For Loop Container, For each Loop Container.
  • Involved in Maintenance and Deployment of SSIS Packages.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
  • Implemented data blending using various data sources and created stories usingTableau, Power BI and SSRS for better understanding of the data.
  • Configuration and Deployment of all reports across various SDLC environments.
  • Deployed the packages to production using XML package configuration.
  • Held responsibility for database maintenance plans.
  • Actively involved in gathering and analyzing stakeholder’s requirements.
  • Created alerts, notifications, and e-mails for system errors using Power BI and Tableau.
  • Created Complex Stored Procedures and automated them using SQL Server Agent.
  • Created Triggers (Instead Of and After) for Auditing Purpose.
  • Created Views and Indexed Views for the Performance Tuning.
  • Performed validations in Excel by creating pivot tables.
  • Prepared detailed documentation for the business requirements.

Environment: SQL Server 2008, DTS, SSIS, SSRS, SQL Server OLAP 2008, Reporting Services 2008, T-SQL, MS Access, Windows 2003 Server, Power BI, Tableau.

Hire Now