Name: Saranya Durairaj

Email: ad0w91@r.postjobfree.com

Mobile: +1-940-***-****

LinkedIn ID: www.linkedin.com/in/saranya-durairaj

Summary

** ***** ** ** ********** with exposure to various BI reporting tools, including ETL, data modeling, scheduling, and transfer of reports.

Skilled in various reporting tools like Power BI, SAP BO CMC, Crystal Reports, Talend Open Studio, OBIEE, BI Publisher, and BASE SAS in Linux / Windows environments.

Have good knowledge in the Banking domain and worked in various Banking Finance products such as Finance – Documentary Trade Port (DTP), Commodities Control Application (COCOA), TCS BaNCS

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 on migration projects that involved backend DB migration for SAP BO CMC Crystal Reports from SQL to ORACLE 11g, Out-of-place upgrade from OBIEE 11.1.1.6.0 to 11.1.1.7.1, OBIEE 10g to 11g.

Designed and implemented object-based and data-level securities in the OBIEE dashboard for business users.

Designed various pictorial representations of reports in the form of Pie Charts, Bar Charts, and Line Charts in OBIEE Answers and BI Publisher.

Fair knowledge of fine-tuning the queries for optimum performance.

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

Basic understanding of Cloud concepts and certified with Azure Fundamentals.

Technological Skillset

Reporting Tools: Power BI, SAP BO Crystal Reports, OBIEE, BI Publisher, 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:

Edureka Certified: Business Analyst using Power BI

Microsoft Certified: Azure Fundamentals

Microsoft Certified Technology Specialist: .NET Framework 2.0 Windows Applications

Microsoft Certified Technology Specialist: .NET Framework 2.0 Web Applications

Oracle Database SQL Certified Associate Certification.

Core Expertise:

Power BI SAP BO CMC SAP BO Web Intelligence Crystal Reports SQL PL SQL Stored Procedures SQL Performance Tuning Talend ETL OBIEE 11g Repository Data Modeling OBIEE 11g Dashboard Designing and Securities Implementation Oracle 11g DB 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:

Projects Handled in VIRTUSA and CAPGEMINI

Project Title

Documentary Trade Port – Report Generation (DTP RG) – Crystal Reports

COCOA Trade Reporting - OBIEE

Client

Standard Chartered Bank GBS – Malaysia

Duration

Sep 8, 2015 – Oct 7, 2023

Description

The DTP RG project involves report design and development for trade operations users in 44 countries. Application data is received from the mainframe system as flat files and uploaded to Oracle DAAS DB tables which act as a reporting source.

The COCOA Trade Reporting project involves reports & dashboard development for COCOA

banking applications to keep track of client data & bank performance in the Trading finance sector.

Role

Lead Consultant

Requirement gathering from BA or Country trade ops user directly.

Development of ETL (Talend), Reports, Scheduling Reports, and File transfer scripts.

End to End implementation from Requirement gathering, Development, Unit Testing, SIT, UAT,

Regression testing support, Production Implementation support, and User verification

Testing support.

Developed POC project in Power BI to evaluate the business requirements to replace existing trade

reports from SAP Crystal reports to Power BI as business plans to migrate from on-perm to Azure

cloud.

Implemented DAX functions for various fact calculations for efficient data visualization in Power BI.

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.

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

Power Map to visualize reports.

Installed and configured Enterprise gateway in Power BI Service.

Highlights

Supporting end-to-end throughout the project life cycle thereby gaining complete knowledge

of the project.

Supporting multiple projects from different trade applications.

Operating System

Linux, Windows 2010, Windows 2007

Database

ORACLE 11g

Language & Tools

Power BI / Crystal Reports, SQL, SAP BO CMC, VB, Windows Batch script, Linux shell script, DevOps – GIT Bash, Jenkins, SFTP, CFT, OBIEE 11g

Location

SCB Global Business Solutions (GBS), Malaysia

Projects Handled in COGNIZANT

Project Title

Landmark Retail Application – OBIEE Upgrade from 11.1.1.6.0 to 11.1.1.7.1

Agilent BI Divestiture – OBIEE migration from 10g to 11g

Client

Landmark Group, Dubai

Agilent Technologies, USA

Duration

Nov 20, 2013 – Jul 17,2015

Description

Landmark Retail Application project involved out-of-place upgrade of their existing OBIEE

11.1.1.6.0 to 11.1.1.7.1.

Agilent BI Divestiture project involved the migration of OBIEE applications from 10g to 11g along

with backend data split, the company is being split into 2 different entities: Agilent and Keysight.

Role

Associate

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.

Highlights

Installation and configuration were challenging parts as it was in AIX OS where

software-only installation was carried out.

The major challenge faced in this project was renaming the USER folders in the catalog as

we changed the LDAP which was used in 10g. The way users log into the 11g application

was different from the 10g application which was the reason for renaming USER folders.

Operating System

AIX, Windows 2007

Linux, Windows XP

Database

ORACLE 11g

Language & Tools

OBIEE 11g, SQL

Location

Cognizant Technology Solutions, Chennai

Projects Handled in TCS

Project Title

Securities Target Operating Model (STORM II Reporting) – OBIEE 11g Reporting

Client

Standard Chartered Bank, Singapore

Duration

May 04, 2011 – Nov 15, 2013

Description

TCS-owned custodian services tool NCS was migrated to BaNCS which is the source for the

STORM II Reporting application using OBIEE 11g

STORM II reporting application acted as a near real-time system for most of the modules and

PL/SQL procedures have been used as an ETL for a couple of modules.

Role

IT Analyst

Requirement analysis, Design, and development of the RPD/report/Dashboards/BI Publisher.

Supported SIT/UAT/UVT support during go-live for various countries that have gone LIVE.

Performance Tuning for long-running report queries.

Highlights

Explored BI Publisher and created a few complex reports like Invoice Printing.

Received client appreciation award for completing some complex reports in BI Publisher.

Operating System

Linux, Windows XP

Database

ORACLE 11g

Language & Tools

OBIEE 11g, BI Publisher, PL/SQL

Location

Tata Consultancy Services, Chennai

Projects Handled in AON-Hewitt

Project Title

Implementation of a brand-new plan called Health Saving Account – SAS

Client

YSA Clients from North America

Duration

Sep 24, 2008 – Apr 27, 2011

Description

SAS programs will read the incoming mainframe datasets from the client and transform them to DB2

tables where we maintain the numbers in the client’s accounts (most likely a debit card account)

Role

Sr. Programmer Analyst

Analyze/Coding/Testing/Deployment/Scheduling of jobs in Control-M and ensure the job is set up as

per the client requirements.

Highlights

Started as a fresher and was able to lead a small team of 4 members for the YSA account.

Operating System

Mainframes

Database

DB2

Language & Tools

JCL, SAS, and SQL

Location

AON-Hewitt Associates India Pvt. Ltd., Chennai

Education

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

University - Anna University

Year – 2007

Contact this candidate