Summary

• 13 years of IT experience with exposure to various BI reporting tools, ETL, data modeling, scheduling, and transfer of reports.
• Designed and implemented object-based and data-level securities in Power BI and OBIEE dashboards for business users.
• Designed various pictorial representations of reports in Power BI, OBIEE Answers and BI Publisher.
• Integrated Snowflake data warehouse with Power BI to create interactive and visually appealing dashboards, enabling stakeholders to gain actionable insights from complex datasets.
• Integrated the data warehouse with business intelligence (BI) tools such as Power BI, Tableau, and OBIEE enabling users to derive insights and generate reports from centralized, curated data.
• In-depth understanding and experience with Microsoft BI stack such as Power Pivot, SSIS, SSRS, and SSAS.
• Proficient in SQL, SAS, and Python for data manipulation and analysis.
• Worked in different data sources like Snowflake, Oracle DaaS, and SQL Server.
• Hands-on experience in delivering Data Governance and Data Quality Management concepts and practices within the financial services industry.
• Strategized in different SDLC and Agile phases, involved in requirement gathering, analyzing, and documenting business and technical requirements, development, testing, implementation, and L3 support.
• Worked in agile model deliverables and participated in all phases of Agile meetings, used Scrum / Kanban board.
• Closely worked with SIT, UAT, and PSS teams for successful module releases.
• Expertise in job scheduler tools like Control-M and Windows Task Scheduler to automate and schedule batch jobs as per the requirements.
• Efficiently implemented File Transfer Protocols such as SFTP, and CFT (Axway Cross File Transfer) to securely transfer the files/reports from one server to another.
• Hands-on knowledge in version control tools like Git Bash / Jenkins and DevOps
• Good knowledge of AWS Analytics Services and Database Services.
• Hands-on experience in Production Change Management process.

Technological Skillset

Reporting Tools: Power BI, OBIEE, BI Publisher, SAP BO Crystal Reports, Basic SAS

ETL Tool: Talend Open Studio

Database: Oracle 11g

Query interfaces: Oracle PL/SQL Developer, SQL Developer

Other Software: Control-M, MS Visual Studio, Putty, Git Bash, DevOps, MS PowerPoint, MS Word, MS Excel

Operating Systems: Linux, Windows

Methodologies: Agile and Waterfall model.

Certifications:

• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Azure Fundamentals
• Oracle Database SQL Certified Associate Certification.

Core Expertise:

Power BI | OBIEE | Crystal Reports | SQL | PL SQL Stored Procedures | Talend ETL | SFTP | JIRA | DevOps Tools – Bitbucket, Jenkins, Git Bash, Artifactory, Auto Deployment | Control-M | Axway Cross File Transfer (CFT) | Windows Batch Scripting | Windows Task Scheduler | Visual Studio | Disaster Recovery Planning | AZURE Fundamentals and Cloud Concepts | Base SAS | JCL | Mainframe | DB2

Work Experience:

Senior Data Analyst

Virtuous Tech, Frisco (TX, USA) Oct 2023 – Present

Client: Fannie Mae

Project: Enterprise Application Renewal (EAR)

Responsibilities:

• Created Power BI Sample Report to demonstrate Outline Solution for Business Team.
• Imported Data into Power BI using Direct/ Live Query based on Table size and created lookup tables to maintain

Relationship.

• Developed and implemented SSIS packages to extract, transform, and load (ETL) data from heterogeneous sources

into the Power BI data model, ensuring data consistency and integrity.

• Installed and configured Enterprise gateway in Power bi service.
• Used Power Query for Data transformations and M-query language in Power Query.
• Worked on all types of transformations that are available in Power bi query editor.
• Formulated DAX Expressions create Date to yearly columns, implemented partitions in Tabular Models for Power BI.
• Wrote Time Intelligence DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and

dashboards.

• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, and Logical, information, Text,

and date functions in source data.

• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize

Reports.

• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and

tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.

• Developed SQL scripts to test the report output against DB results.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available to Web clients.

Environment/Tools: Windows 11, Power BI Desktop, Power BI Online, ORACLE 19c, Microsoft SQL DB

Lead Consultant

Virtusa, Kuala Lumpur (Malaysia) Dec 2018 – May 2022

Client: Standard Chartered Bank

Project: Documentary Trade Port – Report Generation (DTP RG)

Responsibilities:

• Developed and deployed SSAS tabular or multidimensional models to provide a semantic layer for Power BI, enabling

users to perform complex analytical queries and calculations.

• Created data models as per the report requirement which involves analyzing the set of tables from SQL Server, Oracle

and Snowflake tables in identifying the keys and relationship for report development.

• Evaluate Power BI features for business requirements and proposed report designs in Power BI to Business users.
• Implemented row-level security within Power BI to restrict access to sensitive data based on user roles and

permissions defined in Snowflake.

• Developed ETL processes using tools like Informatica, Talend, or custom scripts, ensuring accurate and timely data

integration from heterogeneous sources into the data warehouse.

• Generated Dashboards from Power BI service and provided business user access at workspace level.
• Demonstrated expertise in leveraging DAX functions to perform complex calculations, such as SUMX, CALCULATE,

AVERAGE, and RELATED, for data analysis and modeling purposes.

• Developed DAX measures and calculated columns to derive insights and KPIs (Key Performance Indicators) from raw

data, driving informed decision-making for stakeholders.

• Developed and designed paginated reports in Power BI Report Builder/SSRS reports to meet specific business

requirements, including pixel-perfect layouts and complex data visualizations.

• Published Power BI dashboards into Power BI service and implemented RLS.
• Implemented data visualization best practices in Power BI, including proper use of chart types, color schemes, and

labeling to enhance the clarity and readability of reports.

• Worked directly with business users and business analysts to prepare SQL scripts for ad-hoc reporting requirements.

Environment/Tools: Linux, Windows 2010/2007, ORACLE 11g, Power BI, OBIEE, SQL, SAP BO CMC, VB, Windows Batch script, Linux shell script, DevOps – GIT Bash, Jenkins, SFTP, CFT

Consultant

Capgemini, Selangor (Malaysia) Sep 2015 – Jul 2017

Client: Standard Chartered Bank

Project: COCOA Trade Reporting

Responsibilities:

• Analyzed the data and developed a logical star schema model with consultation from Data modelers and business

analysts.

• Developed ETL processes using tools like Informatica, Talend, or custom scripts, ensuring accurate and timely data

integration from heterogeneous sources into the data warehouse.

• Developed metadata repository using OBIEE Administration Tool in Physical, Business Model and Mapping, and

Presentation Layer.

• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer

as per business requirements.

• Developed Time series objects using Ago and To Date functions for time series comparisons.
• Designed and developed various interactive dashboards and reports with drilldowns, guided navigations, filters, and

prompts.

• Worked towards performance tuning of dashboards and reports with Business Analysts and DBAs. Integrated BI

Publisher with OBIEE to build reports in Word and doc format.

• Utilized DAX to create hierarchies, time intelligence functions, and custom aggregations to enhance data visualization

and analysis capabilities for Power BI reports.

• Ensured consistency in visualization design across reports and dashboards, maintaining brand standards and user

expectations for visual presentation.

Environment/Tools: Linux, Windows 2010/2007, ORACLE 11g, OBIEE, SQL, Oracle PL/SQL

Associate

Cognizant, Chennai (India) Nov 2013 – Jul 2015

Client: Landmark, Agilent Technologies

Project: OBIEE Upgrade from 11.1.1.6.0 to 11.1.1.7.1 and OBIEE migration from 10g to 11g

Responsibilities:

• Worked during the whole life cycle of the project from requirement gathering to deployment.
• Analyzed the data and developed a logical star schema model with consultation from Data modelers and business

analysts.

• Developed metadata repository using OBIEE Administration Tool in Physical, Business Model and Mapping, and

Presentation Layer.

• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer

as per business requirements.

• Developed Time series objects using Ago and To Date functions for time series comparisons.
• Designed and developed various interactive dashboards and reports with drilldowns, guided navigations, filters, and

prompts.

• Worked towards performance tuning of dashboards and reports with Business Analysts and DBAs.
• Integrated BI Publisher with OBIEE to build reports in Word and doc format.
• As a key member of this project, involved in end-to-end project activities like installation, Configuration,

Administration, and Defect fixes during SIT & UAT. Worked closely with ORACLE on the SRs which were part of

product/upgrade issues.

Environment/Tools: AIX, Windows 2007, Linux, Windows XP, ORACLE 11g, OBIEE 11g, SQL

IT Analyst

Tata Consultancy Services, Chennai (India) May 2011 – Nov 2013

Client: Standard Chartered Bank

Project: Securities Target Operating Model (STORM II Reporting)

Responsibilities:

• Worked during the whole life cycle of the project from requirement gathering to deployment.
• Analyzed the data and developed a logical star schema model with consultation from Data modelers and BA.
• Developed metadata repository using OBIEE Administration Tool in Physical, Business Model and Mapping, and

Presentation Layer.

• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer

as per business requirements.

• Developed Time series objects using Ago and To Date functions for time series comparisons.
• Designed and developed various interactive dashboards/reports with drilldowns, guided navigations, filters, prompts.
• Worked towards performance tuning of dashboards and reports with Business Analysts and DBAs.
• Integrated BI Publisher with OBIEE to build reports in Word and doc format.
• As a key member of this project, involved in end-to-end project activities like installation, Configuration,

Administration, and Defect fixes during SIT & UAT. Worked closely with ORACLE on the SRs which were part of

product/upgrade issues.

Environment/Tools: Linux, Windows XP, ORACLE 11g, OBIEE 11g, BI Publisher, PL/SQL

Sr. Programmer Analyst

AON-Hewitt, Chennai (India) Sep 2008 – Apr 2011

Client: YSA Clients from North America

Project: Yours Spending Account (YSA)

Responsibilities:

• Client data received via EFT (Electronic File Transfer) in the Mainframe generational datasets. SAS programs will

be written to reformat these data as required. Created Analysis along with some CODE SNIPPETS to aid in the

programmer.

• Depending on the plans that the clients have enrolled in we distinguish the participant data via SAS programs that

involves querying DB2 data as well via SQL queries. Some of the plans that include are Wired Commute plan for

Transportation and Parking reimbursements, Tuition and Adoption Plans, Contribution plans for Health and

dependent care that are most familiar with US citizens.

Environment/Tools: Mainframe, DB2, JCL, SAS, and SQL

Education

Degree / Specialization – Bachelor of Engineering / Electronics and Communication Engineering

University – Anna University

Year – 2007

Saranya.docx