MSBI, SQL, SSIS, SSRS, Power BI
Resume:
Professional Summary:
Over all ** years of experience in developing with 10 years of relevant experience on MSBI (SQL Server, SSRS, SSIS and SSAS 2005/2008 R2/2012/2016) in banking domain and Microsoft certified professional.
Experience in database programming and development using Microsoft SQL SERVER.
Expert in converting business requirements into real time project execution plan and provide a solution to achieve the goal.
Experience in analyzing the data and provide better insights to visualize the data.
Extensively worked on SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and T-SQL.
SQL Server Integration Services
Used the SSIS for extracting, transforming, and loading data into data warehouse/data mart.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS services.
Created SSIS Packages using Control flow and Data flow items according to business.
Expert in pulling data from multiple SOR and load them into staging area.
Transform the data by using derived column, data conversion, conditional split, merge, union.
Archive source files into destination shared folder for audit purpose by using file system task.
Experience in deploying SSIS packages into msbd and file system.
Experience in Schedule the SSIS Packages.
SQL Server Reporting Services
Involved in creating the Reports like Table, Matrix, Chart, Sub reports, Parameterized, Drill Down and Drill through Reports based on client requirement.
Experience in deploying reports into report manager and share point depending on the business need.
SQL Server Developer
Expert in writing stored procedures, views.
Experience in query optimization and performance improvement.
Experience in Data Modeling techniques.
Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
Created joins and sub-queries for complex queries involving multiple tables
Experience in Database designing using Microsoft SQL Server.
Expert in creating Jobs and scheduling in Microsoft SQL Server Agent.
Expert in Troubleshooting and Support SQL Server objects.
Experience in designing databases, and writing queries using constraints like PRIMARY KEY, FOREIGN KEY, DEFAULT, UNIQUE.
Experience in data warehousing technology such as Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, OLTP and OLAP system.
Implemented SSAS (Tabular Model)
Good knowledge on writing MDX query.
Experience in Power BI visualization with DAX code
Well versed with Agile methodology
Provide data to third party application for the integration.
Expert in people management skill.
Experience in Problem Solving, Analytical Skills, Interpersonal, Presentation skills and good written and oral communication skills.
Having good experience in developing solution using Software Development Life Cycle (SDLC).
Can quickly adapt to new skills and willingness to learn.
Technical Skills:
Technologies : Microsoft Business Intelligence Tools (MSBI)
Operating Systems : Windows
Database : Microsoft SQL Server 2005/2008 R2/2012/2016, TERADATA, DB2
ETL Tool : SQL Server Integration Services (SSIS)
Reporting Tool : SQL Server Reporting Services (SSRS)
Analysis Tool : SQL Server Analytics Services (SSAS)
Visualization Tool : Power BI
Development Tools : BIDS, SQL Server Management Studio (SSMS), TERADATA SQL Assistance, Embarcadero
Language : T-SQL
Source Control : Team Foundation Server (TFS)
Education:
MCA from Trident Academy of Creative Technology, BPUT.
Certification:
Querying Microsoft SQL Server 2012/2014
Professional Experience:
Title : SDA – Bankruptcy January 2018 to till date
Client : Wells Fargo, USA
Role : Team Lead/MSBI Developer
Team Size : 6
Description : Bankruptcy is a legal status of a person or other entity that cannot repay the debts it owes to creditors. In most jurisdictions, bankruptcy is imposed by a court order, often initiated by the debtor.
Responsibilities:
Coordinate with the US partners/Analytic Consultants to gather the requirements.
Provide better solution to user to achieve their target state.
Manage the team by work allocation and provide technical help to them.
Create/modify complex SSIS packages to pull data from multiple sources such as flat files, excel and other oledb sources and load data into destinations data mart.
Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)
Direct and document the architectural design and development of the enterprise data warehouse (EDW) and data marts.
Create multiple parameterized, graphs and Tablix SSRS report as per business requirements.
Provide drill down option to populate the hierarchical data and drill through reports to see detail level data.
Designed and implemented Parameterized and cascading parameterized reports using SSRS
Designed and formatted SSRS Reports using Parameters and Expressions for the Reports
Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions
Build different types of chart reports using SSRS like column chart and Pie charts
Created sub reports and pass through parameters from main report to the sub reports
Created visualization in Power BI for senior executives for summarized insight
Used DAX expression while creating Power BI visuals.
Implemented SSAS (tabular modelling) to be used by report developers.
Provide data to third party for further integration.
Deploying and Scheduling Reports
Provide email notifications for job failure and success.
Troubleshooting the failed jobs.
Write stored procedures, views, T-SQL as per business requirement.
Manage the project estimation and coordinate with team to deliver the project within SLA.
Deploy database objects into production environment.
Schedule the daily and monthly jobs and monitor them to finish data loading within SLA.
Tools Used: MS SQL Server 2012/2016, SSIS, SSRS, SSAS and Power BI.
Title : Client Consolidation September 2014 to December 2017
Client : Wells Fargo, USA
Role : Team Lead/MSBI Developer
Team Size : 5
Description : The Wells Fargo Client Consolidation project, currently underway between WFHM and BKFS, will merge our four smallest MSP clients—106, 472, 591, and 685—into client 708. All loans converted to client 708 from clients 106, 472, 592, and 685 will be renumbered. Following conversion there will only be two active client numbers in MSP BI and SSDM: 708 and 936. Client consolidation will reduce complexity and streamline business and reporting processes. The BICD team’s objective is to provide our end users with as seamless of a reporting experience as possible during and after the conversion events.
Responsibilities:
Coordinate with the US partners to gather the requirements.
Identify the source system information, get the Metadata and define a destination system to stage the data for further use.
Provide technical solution to the requirement and best practices to improve the performance.
Setup a team to execute the project and accountable to review all the task assigned to team members.
Created many database objects like tables, views, indexes, functions and advanced queries for database in both development and production environments using SQL Server Management Studio’s Database engine
Create the SSIS packages to load data from sources to destinations based on defined mapping document.
Check the data load process to make sure the accuracy of data load.
Export the data into excel report and provide to end users as per defined format and standard.
Designed, developed, tested, and maintained SSRS functional reports based on user requirements.
Designed and implemented Parameterized and cascading parameterized reports using SSRS
Designed and formatted SSRS Reports using Parameters and Expressions for the Reports
Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions
Build different types of chart reports using SSRS like column chart and Pie charts
Created sub reports and pass through parameters from main report to the sub reports
Provide data to third party for further integration.
Deploying and Scheduling Reports
Write stored procedures, views, T-SQL as per business requirement.
Manage the project estimation and coordinate with team to deliver the project within SLA.
Deploy database objects into production environment.
Schedule the daily and monthly jobs and monitor them to finish data loading within SLA.
Tools Used: MS SQL Server, SSIS 2008 R2, SSRS and Excel.
Title : SDA – CAMO July 2012 to August 2014
Client : Wells Fargo, USA
Role : Senior Technology Specialist/MSBI Developer
Team Size : 5
Description : Servicing Data and Analytics is a department responsible for managing mortgage servicing and default servicing and support the business to provide reporting solution.
Responsibilities:
Coordinate with the US partners/Analytic Consultants to gather the requirements.
Analyze the data and provide an insight for data visualization for better decisions.
Create/modify complex SSIS packages to pull data from multiple sources such as flat files, excel and other oledb sources and load data into destinations data mart.
Create Stored Procedures to load data for reports.
Monitored performance and optimized SQL queries for maximum efficiency.
Responsible for Creating and Modifying T-SQL stored procedures for validating the integrity of the data.
Created indexed views and appropriate indexes to reduce the running time for complex queries.
Extensively use multiple joins to fetch data from tables to provide the desired output
Create tabular, matrix, chart, and cascading parameter SSRS reports to meet the business requirements.
Created dashboard reports for the user and option to navigate to various sub-reports using expressions.
Convert SAS code to SQL code,
Creating Mapping Docs for the reports.
Creating jobs to load required data.
Write stored procedures, views, T-SQL as per business requirement.
Getting the jobs scheduled through SQL Job Scheduling.
Troubleshooting the failed jobs.
Tools Used: MS SQL Server, SSRS and SSIS 2008 R2.
Title : HEQ Sales and Fulfillment April 2010 to June 2012
Client : Wells Fargo, USA
Role : Technology Specialist/MSBI Developer
Team Size : 4
Description : HEQ Origination deals with the process which involves steps before an application or loan is funded/boarded (passed on to be supported by the Loan Servicing team). First customer goes to sales and applies for HE product/loan or one of the 4 Sales Channels has gotten all the information from the customer, then it goes to the Customer Credit Group (CCG)/ Fulfillment for underwriting and processing (which we call Processing). Once the customer signs the loan paperwork and it books (BK activity code) then it goes to NLO (is a subset of and last workflow point within Fulfillment). NLO audits and reviews to ensure that all the documentation is in place before the loan (or line) is passed on to be supported by the Loan Servicing team.
Responsibilities:
Coordinate with the US partners to gather the requirements.
Create/modify the SSIS packages to load/transform data from various sources into destinations data mart.
Implemented different kind of destination to load data faster.
Experience in optimizing SSIS packages with many best practices such as using parallel execution, appropriate use of buffer, appropriate transformation.
Creating Stored Procedures to load data for reports.
Creating different kind of reports including Crosstab, Conditional, drill down, drill through, custom, cascading and parameterized SSRS reports to meet the business requirements.
Created reports that call sub reports in SSRS
Experience in migrating objects and data from one environment to different environment.
Creating jobs to load required data.
Getting the jobs scheduled through Autosys/ SQL Job Scheduling.
Troubleshooting the failed jobs.
Tools Used: MS SQL Server, SSRS and SSIS 2005.
Title : PMA/AUM January 2009 to March 2010
Client : Franklin Templeton
Role : Software Developer
Team Size : 5
Description : Performance Measurement Application/Assets Under Management is a data-mart with custom-built web application that is used for sourcing, storing, calculating, distributing, and reporting data related to fund performances (ROR/IRR/Holdings/AUM etc.). Worked on various enhancements to application like,
PERAscope Replacement – performance reports
Custom Segment Selection
Custom Period Selection
Responsibilities:
Involved in Technical Design sessions
Created and enhanced various stored procedures, functions, packages
Created performance reports using Crystal Reports (BO).
Supported system testing and UAT.
Resolved the issues during UAT
Supported post-production issues
Tools Used: Crystal Report (BO), Oracle 10g
Title : KNOWLAGENT April 2007 to December 2008
Client : Knowlagent, USA
Role : Software Developer
Team Size : 4
Description : Knowlagent offers various software solutions to hire, train, coach, and track the performance of the call center employees, supervisors and executives. Using the application employees’ training/performance will be tracked and performance will be measured using various KPM s. The enhancement carries modifications to coaching product and to build various performance reports to calculate and show the KPMs of the coaching.
Responsibilities
Executing scripts for tables and stored procedures.
Importing data to tables by using stored procedure and import/export wizard.
Columns mapping between report and table.
Created Stored Procedures for the reports.
Involved in creating reports (.rdl files) using SSRS 2005.
Generated custom and parameterized reports using SSRS.
Created reports that hyperlinks other report using SSRS tool.
Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Involved in bug fixing.
Tools Used: MS SQL Server, SSRS 2005.
Title : RCM Reports January 2006 to March 2007
Client : Radiant, USA
Role : Software Developer
Team Size : 4
Description : Radiant Concessions Management is an end-to-end solution that allows theatre circuits to centrally manage all of their concession pricing, inventory and sales activities. Concession Management allows you to manage concession prices and inventory, maintain recipes and raw materials for multiple theatres at a centralized location, centralized reporting tools to track sales mix trends, per cap figures and over utilization trends, advanced food cost management that assists in pinpointing food cost issues by tracking reports and usage trends.
Responsibilities:
Executing scripts for tables and stored procedures.
Importing data to tables by using stored procedure and import/export wizard.
Columns mapping between report and table.
Created Stored Procedures for the reports.
Involved in creating reports (.rdl files) using SSRS 2005.
Generated custom and parameterized reports using SSRS.
Created reports that hyperlinks other report using SSRS tool.
Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
Involved in bug fixing.
Tools Used: MS SQL Server, SSRS 2005.
Contact this candidate