Data Analyst Sr

Jay / Jaya Kumar

Sr Data Analyst/ Sr Data Engineer

PERSONAL STATEMENT

A dynamic professional with 18 years of overall experience in Information Technology.

Expertise with 8 years of experience in the development and maintenance of Power BI dashboards/Reports. Power Platform development and Python programming.

2 Years of experience in Azure Databricks and Azure Data Factory

Expertise with 7 years of experience in the area of Business Intelligence (BI) using MS SQL Server, Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

1 year of experience in Cloud migration (On-premise servers to Cloud servers).

Expertise in domain areas that include Finance, Insurance, Banking, Retail, and Transportation.

Strong in-work skills on designing Relational and Dimensional Models. Hands-on skills in Relational and Dimensional Data Modeling for creating Logical and Physical Design of Database and ER Diagrams.

Experience with extensive business analysis, process analysis, interviewing end-users, gathering and refining requirements, developing and defining business rules.

CURRENT EMPLOYER

Beyond Career LLC (Texas - USA)

PREVIOUS EMPLOYERS

Unity Infotech

EPIQ Systems Pvt Ltd

KGISL

Accenture

Capgemini

IBM

WORK EXPERIENCE

Sr Data Analyst - Project Lead

Ahli United Bank - Dec 2021 – Nov 2024

Ahli United Bank - Bahrain: Ahli United Bank, the largest publicly traded commercial lender in Bahrain, was incorporated as a private company in May 2000. AUB's ordinary shares are listed on Bahrain Stock Exchange since August 2000, and the Kuwait Stock Exchange since June 2006.

Ahli United Bank is geared towards growth through the development of a larger client base in the Gulf states. The evolution of future mergers and acquisitions in the Gulf region remains central to the bank's expansion strategy.

AUB is a fully-fledged commercial institution and investment bank providing wealth management, retail, corporate, treasury, offshore and private banking.

Recent implementation – high appreciation from Users:

1.Margin Summary dashboard (across the entities)

a)Combining Balance sheet & PNL products (Data Modelling)

b)Net Interest Margin across Entities/Line of Business/Industry/Products

c)Net Interest Margin over a period (Trend)

d)Net Interest Income across Entities/Line of Business/Industry/Products

vs Budget

e)NIM %, COF %, Yield % calculation across Entities/Line of

Business/Products

f)Period Ends Loans / Period End Deposits vs Budget

g)ROC % & RAROC % calculation at Customer level

h)Top 100 /Bottom 100 profitable customers

i)Drill Down and Drill Up features implementation

j)Drill through to Customer Level and Account Level

k)RM level security implementation

2.Retail Deposits dashboard

3.Conversion dashboard (Conventional to Islamic)

Responsibilities: (Data Analytics Lead in AUB Bank)

Collecting the requirements from Users

Understanding the requirements. Interact with business users to understand key challenges and articulate unstructured business concerns

Analyze data sources, requirements, and business rules to perform new Logical and Physical Data modeling.

Identifying dimensions, facts, and various other concepts of dimensional modeling, which are used for data warehousing projects or reporting purpose

Design high level conceptual business/data models, relational and dimensional logical data models, and detailed physical database design models.

Divided data model in number of sub models for the ease of understanding and comprehension.

Creating Power BI Reports/ Data flows/Power Automate.

Creating DAX queries to generated computed columns in Power BI.

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.

Used Power BI Gateways to keep the dashboards and reports up to date.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Provided better data visualization and analytics practices to enable effective decision making.

Build and maintain clean data sets and historical analysis ensuring data integrity and security for analytics.

Presenting dashboards to end-users

Supporting team with technical and performance issues.

Project Lead

EPIQ Systems Pvt Ltd - Sep 2021 – Nov 2021

Epiq Bankruptcy is the largest purchaser of U.S. bankruptcy court data and provider of bankruptcy technology and services. We use this data to automate bankruptcy case servicing operations, as well as trustee and corporate restructuring case management.

The largest provider of bankruptcy data, technology and services, and a trusted partner to companies operating in the business of bankruptcy

Transforming the business of bankruptcy through advanced technology, superior data and exceptional service

Epiq Bankruptcy Analytics

Unlimited access to filing information, updated daily across 93 U.S. bankruptcy courts back to 2007, with user-defined trends and comparisons by geography, time periods and other key factors

Responsibilities:

Analyzed data sources, requirements, and business rules to perform new Logical and Physical Data modeling.

Worked on identifying dimensions, facts, and various other concepts of dimensional modeling, which are used for data warehousing projects.

Creating Power BI Reports/ Data flows/Power Automate.

Created DAX Queries to generated computed columns in Power BI.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

Used Power BI Gateways to keep the dashboards and reports up to date.

Scheduled Automatic refresh and scheduling refresh in power bi service.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Published reports and dashboards using Power BI. Automated processes

Provided better data visualization and analytics practices to enable effective decision making.

Build and maintain clean data sets and historical analysis ensuring data integrity and security for analytics.

Interact with business users to understand key challenges and articulate unstructured business concerns

Project Lead

KG Information Systems - Jan 2018 – Aug 2021

Responsibilities:

Responsibilities Interacted with business users to consolidate and analyze the requirements.

Worked with the business users to identify the requisitions of a project.

Analyzed and interpreted data from various sources organized and summarized data for analysis.

Translated the business requirements into data need and developed ER

Diagrams and Dimensional Models.

Reverse engineered reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for enhancements of reports.

Analyzed data files coming from different cities for claims data.

Designed the Conceptual Model, Logical Model, and Physical Model with emphasis on Insurance (life and health) by using the CA Erwin according to business requirements.

Project Lead

Accenture Services Pvt Ltd - Sep 2012 – Jan 2018

Responsibilities:

Create functional specifications for few for the requirements based on the requirement document.

Preparing design and technical specification.

Preparing operational guide and source to target mapping documents.

Designed SSIS Packages to extract and load the data into data warehouse.

SSIS packages include Control Flow Tasks Like For Each Loop Container, Sequential Container, Execute SQL Task, data flow task, Analysis services task etc.,

Created a Cube with MS Analysis Services 2012. This include creating Dimensions, Measures, Named queries, Named calculations, Calculated measures, Partitions etc.

Implemented SQL agent jobs for executing the SSIS packages and processing the Cube.

Senior Consultant

Capgemini Pvt Ltd - July 2010 – May 2012

Responsibilities:

Designed and implemented Databases using SQL SERVER 2008.

Designed Packages Using Control Flow Tasks Like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and data flow task.

Analyzing the Existing System and Understanding the business requirement.

Designed and Developed SSIS packages using SQL SERVER 2008 R2 Integration Services.

Developed SSIS Packages using xml, OLEDB, file system task in SQL SERVER Integration Services to upload and download the ETL DATA.

Creating Reports with MS Reporting Services 2008 R2. Importing data for Data Warehouse and Reports with Integration Services using SQL SERVER 2008 Integration Services.

Creating Cubes with MS Analysis Services 2008R2. Importing data for Data Warehouse and Cubes with Integration Services using SQL SERVER 2008 Integration Services.

Consultant

IBM Pvt Ltd - Jan 2006 – July 2010

Responsibilities:

Designed normalized database schemas for document repository project. Coordinated with business unit and development staff to design most efficient schema

Maintained the table performance by following the tuning tips like normalization, creating indexes and updating statistics.

Created queries for generating drill down reports in SSRS, the reports thus developed were more interactive.

Maintained change control and release management process for all database objects like tables, views, procedures and triggers using Team Foundation Server.

Wrote T-SQL Procedures to generate DML scripts that modified database objects dynamically based on user inputs

Data Extracted, Transformed and Loaded (ETL) from different Servers like MS Access, Flat Files and Oracle Source using SSIS.

Performed migration of DTS packages to SSIS. Created detailed mapping and design documents

Education

Bachelor of Technology, from JNTU University (Campus).

Discipline: Electronics & Communications Engineering

Contact this candidate