We provide IT Staff Augmentation Services!

Power Bi/ Msbi Developer Resume

ColoradO

PROFESSIONAL SUMMARY:

  • Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains.
  • Experienced in Repository Configuration/using Transformations, creating Informatica Mappings , Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets. 
  • Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
  • Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization .
  • Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL) .
  • Experienced in redesigining and successfully migrating applications to new platforms.
  • Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
  • Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
  • Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
  • Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
  • Created and scheduled subscriptions for the reports using SSRS 2008/2012 .
  • Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access , Excel , CSV , flat files using connectors , tasks and transformations provided by SSIS .
  • Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
  • Integrated Custom Visuals based on business requirements using Power BI desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
  • Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
  • Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
  • Conversant with all phase of Software Development Life Cycle (SDLC).
  • Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS:

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports, Power BI, Tableau

Relational Databases: SQL Server 2016/2014/2012/2008 R2/2005, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), Informatica, SQL Server DTS.

Other Tools: Microsoft Office 2003/2007/2010 and 2013, Power pivot.

Data Modeling Tools: Microsoft Visio 2003/2007/2010 , Erwin and Power Builder.

SQL Server Tools: SQL server Management Studio, Microsoft Visual Studio 2010/2013/2015

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers.

PROFESSIONAL EXPERIENCE:

Confidential, COLORADO

Power BI/ MSBI DEVELOPER

Responsibilities:

  • Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
  • Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
  • Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
  • Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts .
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Directly involved into requirement gathering and understanding business functions with the end users.
  • Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
  • Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
  • Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
  • Integrated Custom Visuals based on business requirements using Power BI desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Developed complex calculated measures using Data Analysis Expression language (DAX).
  • Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
  • Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
  • Provided 24X7 production support to ensure timely and error free delivery of reports.
  • Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
  • Extensively worked on enhancements and performance issues of the existing data import processes.
  • Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
  • Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
  • Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations .

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio, DTS, Windows 7,MS Office 2010/2013,Windows Server 2008 and Windows Server 2008 R2,Visio 2010/2013,Power BI Desktop, Power BI Service.

Confidential, INDIANA.

Sr.SQL DEVELOPER

Responsibilities:
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
  • Performed tuning of Informatica (sources, mappings, targets and sessions) and tuning the  SQL  queries. 
  • Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2012
  • Installed and configured SQL Server 2008R2/2012 in Test environment with latest service packs and migrated few databases
  • Created indexes, Constraints and rules on database objects
  • Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
  • Developed physical data models and create DDL scripts to create database schema and database objects
  • Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
  • Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database
  • Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application
  • Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
  • Created Customized and interactive dashboards using multiple data sources
  • In depth knowledge in Tableau Advance Analysis features like Actions, Calculations, forecasting, Parameters and Trend lines
  • Worked on Dual Axis concept while working with reports with Tableau
  • Created conditional filters and Action links to filter the data on dashboard with Tableau.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
  • Created Cubes using different types of OLAP methods like Multidimensional OLAP ( MOLAP ), Relational OLAP ( ROLAP ).
  • Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Informatica, SQL Server Analysis Services (SSAS), Tableau, Visual Studio 2010, MS Excel, Windows XP, Tableau desktop 7.0/8.1/8.2/9.0 .

Confidential, New Jersey

MSBI DEVELOPER

Responsibilities:
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
  • Planned, designed, and implemented processes to receive, transform and load valuable data from external sources into local databases.
  • Designed SSIS Packages to load data from different sources like excel, flat file, csv etc.
  • Designed Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, mail task, Derived Column, and For Each Loop, Data Conversion etc.
  • Provided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
  • Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
  • Experience in creating Filters, quick filters, table calculations, calculated measures and parameters
  • Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
  • Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes
  • Developed perspectives to simplify the process of browsing the cubes
  • Used Lookups Transformation to get the data from reference data sets

Environment: SQL Server 2008R2/2012 Enterprise Edition, Business Intelligence, SSIS, T-SQL, MDM, SSRS, Windows Server 2008, Oracle 9i, MS excel 2008, Microsoft Visual Studio 2008.

Confidential

SQL/ BI DEVELOPER

Responsibilities:
  • Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing
  • Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
  • Designed the Data warehouse and done the mappings from Source to the Target tables
  • Worked extensively on SSIS packages to implement the data load strategy
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
  • Created 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
  • Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility
  • Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services
  • Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2
  • Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus making them user friendly
  • Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS
  • Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS
  • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs

EnvironmentMS SQL Server 2008R2, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SSDT, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential

SQL SERVER DEVELOPER

Responsibilities:
  • Involved in Planning, Defining and Designing data based on business requirement and provided documentation
  • Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source database and loading on to the target database
  • Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting
  • Designed ETL strategies using Visio showing Data Flow to peer developers and Lead
  • Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently
  • Scheduled the SSIS packages to run as jobs on periodic basis according to the requirement using SQL Server Agent
  • Configured SSIS packages to move the same between different Environments and for optimal performance. 
  • Designed error tolerant SSIS packages and logged the execution details
  • Work directly with users and business partners to gather reporting requirements and provide solutions
  • Prepared documents to show the details of packages and Reports created for future reference 
  • Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them 
  • Implemented the core business process using T-SQL, Stored Procedures and Functions 
  • Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues 
  • Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2005/ 2008

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.

Hire Now