BI Consultant, BI & Reporting Lead-Analyst, Lead Consultant- Technology

Project: 8
Project Name : Customer Bank Analytics (CBA)
Client : National City Bank (UK)
Role : MSBI and BI Developer
Duration : Jan -2014 to Dec-2018
Team Size :4
Environment : WinXP, Win 7, MSBI (SSRS, SSIS,SSAS,MDX) Sqlserver-2008/12,Power BI,Spotfire,Qlikview
Description:
The Business domain in these projects is banking which deals with Giving the loans and auto
Finance. Any Bank before giving the loan needs the information about the customer or business
organization to which it is giving the loan. This bank deals with two kinds of customers-individual
customers and business customers. For individual customers it needs the customer's name, its DOB,
address details, contact details etc. For business customers it needs the organization name, address
details, contact details etc. There can be many address types like legal addresses, trading
addresses and mailing addresses. Also there can be many contact types like home phone, work phone,
email addresses.
we need to store the different address and contact types. The Bank also needs the suppression
details like types of suppression, which customer has what suppression etc. It has also needs to
history of data and history of changes made to the data. The present system does not provide the
functionality to duplicates and the groups associated with the customers, does not maintain the diff
types of address and contact information and do not reduce customer, eliminates the duplicates,
maintains the different types of customer addresses and contact information, reduces the maintenance
cost and stores the historical information.
Responsibilities:
Creating packages using SQL Server Integration Services.
Used transformations like Slowly Changing Dimension, derived column, conditional split, aggregate,
lookup, sort, merge join, union all, merge, data conversion to load data into data marts.
Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Involving creation of Cubes and Dimensions, Data Modeling
Involving defining, modifying and editing the relationships between the dimensions and fact tables.
Involving in the SSAS storage types and partitions, calculated member, calculated measures by using
MDX, developing reports using MDX and SQL.
Writing MDX Queries on Analysis Information to generate the reports.
Generating reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services
Database (OLAP) and included various reporting features such as group by, drilldowns, drill through,
sub-reports, navigation reports etc.
Adding parameters and filters while building advanced reports.
Deployed and generated reports on to the server using the Reporting Services Report Manager.
As per the requirements, rendering the reports in the form of PDF, XML,CSV Diff formats..

Project: 6
Title : PNL

Client : BOS NAM, North America
Role : MSBI And Power BI Developer
Duration : 08-Jan-2015 To 10-Dec-2018
Team Size : 1

Environment : Win 7,Sqlserver12/14, ETL TOOL,MSBI(SSRS,SSIS,SSAS) ,BI Reporting, Power BI,
Data Modeling

Description
This project provides ability to BOS NAM management to analyses Profit and Loss information
across different dimensions of the SBU like Profit Center, Cost Center, WBS, Vendor, Vendor PO
and Headcount related information by Cost Center. The overall effort of this project is to
replace the manual entries and adjustments to calculate different type of costs and revenue
across different dimensions and to replace the traditional reporting from files to reporting
analytics using a single data warehouse. The manual adjustments have been replaced with
automation through coding and user input forms to update the PNL data

Responsibilities:
* Used transformations like derived column, conditional split, aggregate, lookup, sort, merge
join, union all, merge, data conversion to load data into data marts.
Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server
reporting features such as drilldowns, drill through, sub-reports, navigation
reports,(Hyperlink),Spotfire,Qlikview, Power BI reporting and data visualization using Dax functions
.
* Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential
Container, Execute SQL Task, and Data Flow Task

Project: 7
Title : BUSINESS OPERATIONS REPORTING

Client : BOS NAM, North America
Role : T-sql/ETL& SSRS Reports developer and Power BI,Data Modeling
Duration : Nov-2013 To 10-Dec-2018
Team Size : 8

Environment : Win 7,Sqlserver12/14, ETL TOOL,MSBI(SSRS,SSIS)

Description
The Design Report Specification (DRS) is used for defining the requirements for a of Atos' Service
from an external point of view. It describes, based on the defined requirements delivery and the
provision of reports via the defined and agreed interfaces. Based on the selected data, the point of
view could be service-specific, product-specific or cross-service.
This project provides the complete information Bos NAM of incidents, changes and problems etc.,
opened daily in multiple ticketing systems SDM12, USD6, Clarify and PPM. Provides the flexibility to
tower heads, to analyse the number of incidents and changes opened against customers and analyst
group managers, to monitor and alert the group mangers to get resolve the tickets created in the
systems within SLA.
The Raw data for this report is being captured from multiple ticketing systems SDM12, USD6, Clarify
and PPM. The information of table names is described in chapter 4 Data Sources and logic to extract,
transform and load is described in Database.
Responsibilities:
* Used transformations like derived column, conditional split, aggregate, lookup, sort, merge
join, union all, merge, data conversion to load data into data marts, Data Modeling
* Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL
Server reporting features such as drilldowns, drill through, sub-reports, navigation reports
(Hyperlink) and same ssrs report Automation into ASP net ,Spotfire,Qlikview, Tableau reporting
data visualization
* Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential
Container, Execute SQL Task, and Data Flow Task.

Project: 9

Title : Insurance Tracker.

Client : Hanover Insurance Group, USA.
Role : BI developer
Duration : Dec 2014 To Jun-2017.
Team Size : 2
Environment : Win XP&Win 7,Sqlserver2005/2008/,2012,ETL TOOL,MSBI(SSRS,SSIS,SSAS)

Description:
The Hanover Insurance Group, Inc. headquartered in Worcester, USA is the holding company for a group
of insurers that includes Worcester's Citizens Insurance Company of America, based in Howell,
Michigan, Chaucer Holdings plc, London and their affiliates. The main aim of the project is to track
various business patterns can be analyzed using the different business dimensions like Date, Time,
Provider, encounter, Diagnosis, procedure, Medication and Order results and to find Various
Premiums, Claim paid to the policyholder, Commission paid to the Agents and premium received from
the policyholder.
The entire system is divided into four modules as Chairman, Branch Manager, Agent and Customer.
Chairman defines policies and Manager calculates policy amounts. Agent registers the policies and
there by transformation process has been successful and we look forward to future opportunities to
deliver similar state of the art projects within the insurance sector.
Responsibilities:
Used transformations like Slowly Changing Dimension, derived column, conditional split, aggregate,
lookup, sort, merge join, union all, merge, data conversion to load data into data marts.
Extensively involved in the SSAS storage and partitions, and Action,calculation of queries with MDX,
developing reports using MDX and SQL.
Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server
Analysis Services Database (OLAP) and included various reporting features such as drilldowns, drill
through, sub-reports, navigation reports (Hyperlink) etc.
Based on user requirement generate the SSRS and Power BI reports, dashboad and visualizations format
its place into handing Power BI server and SSRS reporting server
Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container,
Execute SQL Task, and Data Flow Task.