Anusha Kalyanaraman

Senior BI & Data Warehouse Professional

Bangalore, India 10+ yrs exp 90 · Outstanding

About

Results-driven Senior BI & Data Warehouse Professional with 10+ years of experience delivering enterprise-scale Business Intelligence, Data Warehousing, ETL, and Analytics solutions within the Banking and Financial Services domain. Experienced in developing ETL processes, BI reporting, data validation, production support, and enterprise reporting solutions using Base SAS, Advanced SAS, IBM Cognos, Oracle, DB2, Teradata, and DataStage. Proven ability to design and maintain scalable BI applications while collaborating with cross-functional business and technology teams.

Skills & Expertise (18)

Base SAS Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Warehousing Advanced

8.0/10

Years Exp

Business Intelligence Advanced

8.0/10

Years Exp

ETL Advanced

8.0/10

Years Exp

Data Marts Advanced

8.0/10

Years Exp

Star Schema Advanced

8.0/10

Years Exp

Data Quality Advanced

8.0/10

Years Exp

DB2 Advanced

7.5/10

Years Exp

Production support Advanced

7.5/10

Years Exp

Microsoft Office Advanced

7.0/10

Years Exp

Teradata Advanced

7.0/10

Years Exp

Microsoft Power BI Intermediate

6.5/10

Years Exp

Sql Server 2000 Intermediate

6.0/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Oracle 9i Intermediate

6.0/10

Years Exp

Retail Banking Intermediate

6.0/10

Years Exp

Toad Intermediate

5.0/10

Years Exp

Work Experience

Project Manager / Data Analytics

CITI BANK

Feb 2012 - Aug 2015

Developed Base SAS and Advanced SAS programs to extract, transform, and analyse enterprise datasets for Fraud Analytics. Built analytical datasets from multiple enterprise data marts to support reporting and business analysis. Performed ETL activities involving data extraction, transformation, loading, validation, and reporting. Automated recurring reporting processes to improve operational efficiency. Conducted data quality checks and validation to ensure reporting accuracy. Collaborated with business stakeholders to deliver analytical reports supporting fraud investigation and business decision-making.

Advisory System Analyst

IBM INDIA PVT. LTD.

Sep 2011 - Jan 2012

Supported enterprise Business Intelligence applications using IBM Cognos. Developed and maintained reporting solutions for business users. Worked with backend databases to support reporting requirements. Assisted with production support and issue resolution.

Senior Software Engineer / Module Lead

HSBC INDIA PVT. LTD.

Jun 2008 - Aug 2011

Developed DB2 SQL scripts implementing complex business logic for Retail and Commercial Banking applications. Designed BI reports using IBM Cognos Report Studio and Framework Manager. Developed ETL processes using DB2 SQL scripts and IBM DataStage. Migrated DB2 scripts to Teradata and validated migrated datasets. Redesigned production scheduling processes following migration activities. Supported UAT, production deployments, BAU support, and post-production issue resolution. Maintained Quality Assurance standards and software configuration metrics. Participated in project estimation, planning, and resource coordination.

Associate – Projects / Offshore Team Lead

COGNIZANT TECHNOLOGY SOLUTIONS

Mar 2005 - Jun 2008

Designed and developed ETL workflows using IBM DataStage and MS DTS. Developed Oracle PL/SQL stored procedures and database functions. Developed Cognos ReportNet reports and metadata models. Developed OLAP cubes using Cognos PowerPlay. Supported scheduled ETL processes for enterprise data marts. Implemented Cognos security and user access management. Provided production support and resolved client issues. Conducted knowledge transfer sessions and mentored team members.