We provide IT Staff Augmentation Services!

Sr. Sql Bi /power Bi Developer Resume

3.00/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • Around 7 years of professional experience in SQL Server database development, extensively worked in Production, Test, Development and Replication & Cluster Server Environments & development databases as a Developer/ Analyst.
  • Strong Knowledge in all phases of (SDLC) Software Development Lifecycle and design through programming, documentation, project management, configuration management, installation and implementation.
  • Worked on Azure platform with data storage in Azure tables.
  • Worked on various data transformations to import data in to SQL Azure using SSIS.
  • Hands on experience in importing SQL Azure database to SQL On - premise server and vice versa.
  • Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
  • Extensive experience in writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Joins, heavy stored procedures, Batch Scripts, Triggers, Functions, and Views using SQL.
  • Efficient in creating joins and sub-queries for complex queries involving multiple tables.
  • Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
  • Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/ 2008/2012/2014 .
  • Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Experience in data manipulation using SQL, COSMOS and Scope.
  • Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
  • Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
  • Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database.
  • Experience in building tabular models using visual studio and implementing DAX expressions with in tabular model to create measures and calculated fields.
  • Experience in creating Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
  • Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server.
  • Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/ 2008/2012/2014 ) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
  • Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • Developed cubes using Partitions, KPI’s, and Perspectives, slowly changing dimensions etc. and created various user roles.
  • Expertise in development ofWeb FormsusingC#andVB.Net.
  • Creating and Managing users, roles and assigning necessary permissions.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
  • Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014, 2012, 2008R2, 2005, Oracle 11g/10g

Database Tools: SQL Server Entreprise Manager, SQL Server Intégration Services (SSIS), SSAS, Confidential Management Console, SQL, T-SQL, Data Transformation Services (DTS), DTSX, IBM DataStage 11.3/9.1, Team Foundation Server (TFS), MS SQL Server Business Intelligence Development Studio (BIDS), MS SQL Server Management studio(SSMS).

Reporting Tools: Confidential SQL Server Reporting Services (SSRS), Crystal Reports.

Operating Systems: Windows 7, Windows XP, 2000, Windows 2003 server, Windows 98.

Programming Languages: SQL,T-SQL,PL/SQL,XML,HTML,VisualBasic6,VBScript, C#,.NET,VB.NET,ASP.NET,ADO.NET.

Design Tools: Erwin 7/4, MS Visio 2007/2010

BI Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS).

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Sr. SQL BI /Power BI Developer

Responsibilities:

  • Created SSIS packages to load the required target tables from various databases that are used in the tabular model.
  • Developed a Power BI dashboard from multiple existing reports.
  • Used Power Queries in Excel to extract and consolidate data from SQL Server tables.
  • Used Power Pivot to create tabular cubes and deployed them in Analysis Services.
  • Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
  • Created different tabular reports using Power BI features and enhanced them based on user requirements.
  • Made changes to the existing Power Bi Dashboard on a regular basis as per requests from Business.
  • Developed and maintained multiple Power Bi dashboards/reports and content packs.
  • Created measures and calculated columns in the tabular models using DAX queries.
  • Involved in monthly activities to run certain processes to load high level SSRS reports which require manual effort.
  • Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
  • Developed SSRS Drill down and Drill through reports with giving users ability to select multiple parameters.
  • Involved in training and providing KT to the offshore team on Power BI and Tabular model concepts.

Environment: T-SQL, Windows 10/8.1, SQL Server 2014, SQL Server Reporting Services (SSIS), SQL Server Integration services (SSIS),SSAS Tabular, DAX, Power BI, Power Pivot, SQL Server Management Studio (SSMS), MS Access, Visual Studio 2015/2013, and MS Excel.

Confidential, Redmond WA

Sr. SQL BI Developer/Analyst

Responsibilities:

  • Handled the integration project to integrate new MSX system to client application Compass.
  • As part of this integration, involved in requirements gathering and discussions with relevant people in the team to get the mappings done.
  • Designed ETL packages and loaded the data into target Azure Database by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created new SQL Azure databases on the server using SSMS and created SSIS packages to load the tables in these SQL Azure tables.
  • Created data sync jobs from On-premise to Azure servers.
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using SSDT BI based on the design data models.
  • Enhanced the already existing C# code to match the new requirements and deployed the job to Production to update the SharePoint List.
  • Enhanced various Scope Scripts in COSMOS to fetch data from structured streams and log files.
  • Scheduled Automated jobs using SQL Server Agent.
  • Monitored and deployed SSIS packages and involved in notification services.
  • Documented the whole integration project and handed off the documentation. provided support for the frontend users of the application and to resolve the issues.

Environment: T-SQL, Windows 10/8.1, SQL Server 2014/2012, Windows 2012 SQL Server, SQL Server Reporting Services (SSIS), SQL Server Integration services (SSIS), COSMOS, Power BI, Power Pivot, SQL Server Management Studio (SSMS), MS Access, Visual Studio 2013/2012, and MS Excel.

Confidential, Nashville, TN

SR. SQL BI Developer / Analyst

Responsibilities:

  • Worked directly with customers, analysts, business stakeholders, vendors, application developers, productionteams and across functional units to identify business needs and discuss solution options.
  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
  • Worked on setting up connection string and connecting SQL Azure databases from local installed SSMS.
  • Worked on SSRS to generate hierarchical reports, drill down and drill through reports and tested using Management Studio in SQL server 2012/2014.
  • Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, functions).
  • Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
  • Created Tables, Cluster/Non-Cluster Index and Constraints.
  • Extracted data from various sources like SQL server 2008/2012, CSV, Excel and text file from various systems and through FTP.
  • Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases using SSIS.
  • Scheduling and Maintaining SSIS Packages and batch jobs through SQL Server Agent and using Shell Scripts, VB Script and batch (.bat) files on a day to day basis.
  • Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Created reports in Power BI Desktop and published to portal utilizing the SSAS Tabular via Analysis connector.
  • Created SSAS Tabular models and SSAS Cubes using data from database and tables created by myself.
  • Worked on Key performance Indicators (KPIs), design of Star schema and Snowflake schema in Analysis Services (SSAS)
  • Design Master Page to improve the Look and Feel of the site and used the Cascading Style Sheets (CSS) to enhance the user interface.
  • Published reports on to the SharePoint and created Web parts in SharePoint to show various reports generated from Excel and SSRS in one web part page.
  • Created SharePoint forms to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.
  • Worked on Performance tuning, and optimization of procedures and queries.
  • Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
  • Created email subscriptions for data driven reports by using Report Manager.
  • Designed different Web Services and Modules using C# as Business Components to implement business needs.
  • Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: T-SQL, Query Analyzer, SQL Profiler, SQL Azure, Power BI, MS SQL Server 2008R2/2012/2014, SSIS 2008/2012/2014 , SSRS 2008/2012/2014 , BIDS 2008/2012/2014 , MS Project, C#, Visual Studio 2010/2012/2014 , MS Visual Source Safe, Windows Platform, MS Excel 2013.

Confidential, Detroit, MI

SR. SQL BI Developer / Analyst

Responsibilities:

  • Worked with business owners and analysts to define and implement new requirements for a more scalable and stable data processing application.
  • Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
  • Migrated Databases from SQL Server 2008 to SQL Server 2012.
  • Built and deployed new cubes based on requirement to help users slice and dice data in MS Excel.
  • Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
  • Experience in performance tuning and query optimization to increase the performance in SQL server.
  • Wrote optimizedT-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.
  • Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
  • Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
  • Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
  • Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
  • Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
  • Created Content Pages, User Controls, Web Forms and HTML Pages for different banking services and modules using ASP.NET 2.0, XHTML and C#.
  • Worked with QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components.

Environment: MS SQL Server 2008 R2/2012/2014, SSIS, SSRS, XML, BIDS, MS Project, Windows-8 Platform, MS SharePoint 2010, XML, C#, ASP.NET, Visual Studio, POWER BI.

Confidential, Mattawa, IL

MS SQL/BI DEVELOPER

Responsibilities:

  • Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
  • Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
  • Responsible for gathering/refining requirements from the customer for developing reports.
  • Developed physical data models and create DDL scripts to create database schema and database objects.
  • Created SQL Server Reports using SSRS 2012 and developed Queries for generating drill down and drill through reports.
  • Uploaded reports on to the report manager and organized them in folders.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
  • Created SSIS process design architecting the flow of data from various sources to target.
  • Configured SSIS packages using Package configuration wizard to allow package run on different environments.
  • Efficiently implemented Error handling in SSIS.
  • Created SSIS packages to load data from various data sources Oracle, DB2 and Flat files.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SSAS.
  • Involved in writing MDX queries.
  • Responsible for maintaining cubes using SSAS and populate the cubes with the data.
  • Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.
  • Provided day-to-day administration tasks like space and log management.
  • Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
  • Configured Snapshot replication for reporting, user acceptance test and development servers.

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), ETL, MS Excel, Team Foundation Server, Windows Server 2003/2008, Oracle9i, VBScript.

Confidential, Houston, TX

MS SQL/BI (SSIS/SSRS/SSAS) DEVELOPER

Responsibilities:

  • Designed and developedSSIS Packages (.dtsx files)to import and export data fromMS Excel, SQL Server 2005 and Flat files.
  • Involved in installing and migrating legacy databases to SQL Server 2008.
  • Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
  • Installation and configuration of SQL Server Reporting Services (SSRS) 2005/2008
  • Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
  • Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2005/2008).
  • Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
  • Involved in testing, bug fixing and documentation for the project.

Environment: MS SQL Server 2005, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005/2008), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Data Transformation services (DTS), ETL, MDX, Confidential Office SharePoint Server (MOSS) 2007, Crystal Reports, Performance Point Server 2007, ProClarity.

Confidential

MS SQL DEVELOPER

Responsibilities:

  • Create User Defined Functions, Stored Procedures, and Triggers.
  • Performed data conversions from Flat files into a normalized database structure.
  • Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
  • Created triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Managed upgradation of DTS packages to SSIS packages.
  • Identified and worked with Parameters for parameterized reports in SSRS.
  • Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels.
  • Configured Server for sending automatic mails to the respective people when a DTS process fails or succeeds.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: MS SQL Server 2000/2005, Query Analyzer, MS Access, DTS, BCP, SQL Profiler, Windows 2000 Server, Import & Export Data.

We'd love your feedback!