We provide IT Staff Augmentation Services!

Sql Bi Developer/power Bi Developer Resume

CA

SUMMARY:

  • Over 6 years of IT experience in Power BI/SQL Development primarily using Power BI , SQL, PL/ SQL, MS SQL, SQL *FORMS, SQL Server, Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS).
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Strong experience of developing, implementing and maintaining application systems under UNIX Operating System using SQL, PL/ SQL, SQL *FORMS, SQL Server, Unix Shell Script, Oracle 10g/9i database.
  • Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.
  • Experience in using Unix for automation of SAS Programs
  • Expert in developing T - SQL (DDL, DML) statements , Data Integrity (constraints) , Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, indexes, triggers, cursors, stored procedures and functions.
  • Experience in using Microsoft .NET framework for SQL Server Integration Services (SSIS) packages for logging programmatically and managing, automating Control flow, Data flow and Events.
  • Created Customized and interactive dashboards using multiple data sources.
  • Expert on creating multiple kind of Power BI Reports and Dashboards.
  • Experience in creating ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping, data cleansing and data quality.
  • Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Expertise in Data Transformation and Data Migration.
  • Strong experience in Data warehouse concepts, ETL.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server).
  • Skilled in error and event handling : Implemented check points, break points, event handlers, troubleshooting, and error handling in SSIS packages to improve usability and liability.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, Python

Databases: MS SQL Server,2014/2012,2008R2,2008 Oracle 8i/9i,10g, Netezza, DB2, Azure

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Power BI, InformaticaPowerCenter 9.6/9.6.1/10.0 (Repository Manager, Designer, Work Flow Manager, Work Flow Monitor Visual Studio, Crystal Reports, Talend, Tableau Reporting (9.0, 9.1, 9.2,9.3,10,10.1), AZURE

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Tableau, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, CA

SQL BI Developer/Power Bi Developer

Responsibilities:

  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
  • Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
  • Involved in gathering requirements for data deliverables to ensure an understanding of their purpose and provide a technical perspective on requirements.
  • Worked on Tabular Model and imported it into Power BI.
  • Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
  • Automated the creation of Excel pivot tables from SAS data sets using SAS /Macro and VBA
  • Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
  • Developed SAS stored procedures and views to provide BI analysis and insights
  • Developed data model, SQL Coding, SQL Query tuning process and Schemas.
  • Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
  • Prepare and Distribute Financial Reports using SSRS to internal and provide recommendations for client’s strategic decision making
  • Resolve production issues related to the SSRS reports and create ad-hoc financial reports for the clients.
  • Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
  • Making data visualization in a variety of ways of multiple visualizations using Power BI.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances .
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Used Configuration Files in SSIS to ease the process of moving the packages across servers.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Developed packages in SSIS with error handling.
  • Created DAX calculated columns inpower pivot worksheets to extract, import and join data that coming from different sources.
  • Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
  • Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
  • Implemented Performance Tuning and Query Optimization .
  • Created Package Configurations to deploy packages from development to production server .
  • Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)
  • Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data.
  • Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.
  • Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.
  • Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).
  • Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Designed and developed Power BI dashboards, Reports and published it on Power BI sites.
  • Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Environment: MS SQL Server 2014/2012, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Power BI Desktop, SharePoint, TFS, Visual Studio 2015, DAX Studio, MS SQL Server Analysis Services (SSAS), C#.NET, T -SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

Confidential, San Francisco, CA

SQl BI/ Power BI developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Developed Power BI reports and dashboards from multiple data sources using data blending.
  • Optimizing the performance of queries with modifications in T- SQL queries , removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Responsible for providing SAS programming and analysis support for several studies in close collaboration with Statisticians.
  • Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites.
  • Extract data from different database platforms (DB2/Oracle/Mainframe/Excel) and prepare summaries and reports using SAS applications.
  • Developing SAS Stored Processes that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Information Delivery Portal.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI Stack with emphasis on, but not limited to SSIS, SSAS, and SSRS.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel, and created SSIS packages to load excel sheets into database.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures, and Refreshing Database on weekly basis.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
  • Used Try catch and @@error for exceptional handling.
  • Restricted access to users by creating security roles to access reports in Power BI.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client FTP servers.
  • Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
  • Used various SSIS transformations such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
  • Created packages and scheduled them in SQL Agent jobs to get data from OLTP .
  • Modifying SSIS packages for business logic enhancements. Writing/modifying VB scripts for sales file moments and data loads.
  • Involved in the continuous enhancements and fixing of production problems.
  • Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into other database.
  • Created Package Configuration files to support the SSIS packages in different environments.
  • Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012 .
  • Created, Maintained & scheduled various reports in Power BI.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS .
  • Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
  • Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
  • Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return back in to the cube.
  • Implemented Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks.
  • Created different visualization in Power BI according to the requirements.
  • Collaborated with fellow team members through Team Foundation Server (TFS) for effective project management, which includes work issues and track on the update of versions.
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Handled errors using Exception Handling extensively for the ease of debugging.

Environment: SQL Server 2012/2008R2 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, Visual Studio .NET IDE, Windows 2008 Advance Server, ASP, MS Excel, MS Access, Visual Studio 2008, TFS 2010, PL/SQL, Oracle Database11g, Shell Scripts, SQL *Developer, UNIX, Reports Builder 11g, Forms Builder 11g.

Confidential

SQL MSBI Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
  • Worked closely with Business Analysts to produce all required documentation.
  • Worked with Product Development Team to architect Database Design and strategy.
  • Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
  • Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
  • Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
  • Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
  • Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Ensures standards and best practices are established and met for consistent and accurate use of Tableau across the company.
  • Responsible for Tableau administration, including user provisioning, server management, license administration, and version upgrades.
  • Identify and raise system capacity related issues (storage, licenses, performance threshold)
  • Performance, capacity & utilization monitoring
  • Optimization and Performance tuning
  • Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Implemented & managed database clustering, failover and load balance technologies as per client requirement.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Created different visualization in Power BI according to the requirements.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Power Pivot Transformation, and Slowly Changing Dimension.
  • Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert s cripts.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, C#, .NET, Visual Basic 6.0, ASP, Tableau, Performance Point, Data Analyzer, Visual Studio 2010, VB Script, MS Access, Excel, SQL Profiler, Windows 2007.

Confidential

SQL Server Developer

Responsibilities:

  • Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Implemented Exceptional Handling
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
  • Creating and automating the regular Jobs.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000/2005, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.

Hire Now