Mob No: +61-047*******

Email id: ad45oc@r.postjobfree.com

Sekar Kumarasamy

Summary

•18+ years of IT experience in ETL architecture, Development, enhancement, maintenance, production support, Data modelling, Data profiling, Reporting including Business requirement, system requirement gathering.

•Knowledge on various ETL, Reporting and Database development, specialised in Data Warehousing Tools and technologies, SQL development (MS SQL Server) and SAS Applications.

•A highly experienced Information Architect / Business Analyst with extensive skills in Business Intelligence, Business Analytics, Data Warehousing, Data Integration, Enterprise Architecture and Quality Management.

•Successfully delivered numerous projects which involved building Enterprise Data Warehouse from scratch, Integration of complex source systems, ETL Design, Data Modelling, Building Data Lakes, Data Marts and end to end data pipelines.

•Depth knowledge of Wherescape RED Data Warehousing Tool, SAS Enterprise Guide, SAS Data Integration Studio, ETL, OLAP Cubes, SSIS, SAS Visual Analytics (VA) and data warehouse management including SAS Platform Administrator

•Expertise in SQL Server and T-SQL (DDL, DML and DCL) in constructing Tables, Joins, Indexed views, Indexes, Complex Stored procedures, Triggers, and useful functions to facilitate efficient data manipulation and consistent data storage according to the business rules.

•Experience in Monitoring and Tuning SQL Server Performance.

•Mentoring others in BI and the use of Analytical tools and techniques.

•Communicating between business and IT to facilitate achieving tactical and strategic goals.

•Possess extensive knowledge and understanding of software life cycles, security strategies and restoring methodologies.

•Sound understanding of Agile Methodologies and participated in all sorts of agile ceremonies (User story grooming, sprint planning and sprint retrospectives)

•Aside from technical expertise, I have the ability to clearly communicate strategies to prepare for implementation of enterprise-wide data strategies that reflect how organisations can capture, store, manage and use their information to implement new BI initiatives.

•Have excellent skills in systems integration, data migration, business intelligence/reporting, analysis, design, and software development.

•Having work experience on various domain such as Healthcare, Banking and Insurance.

•Certified in Advance SAS programming and Data Integration Developer.

•Ability to quickly adapt to changing priorities, requests, and environments.

Educational Qualification

Bachelor of Engineering in Information Technology (BE) from Bharathiar University, India

Certifications

Certified Advanced Programmer for SASR9.

Certified SAS Certified Data Integration Developer for SASR9.

Professional experience

Working in Great Southern Bank, as Data Engineer from Jun 2021.

Worked in Heritage Bank, as Data Engineer from May2018 till Jun 2021.

Worked in Bank of Queensland, as Senior Data Analyst from Oct2017 till May2018.

Worked in Greater Bank, as BI Analyst from Aug 2016 to Sep2017.

Worked in Credit Union Australia as Senior Information Specialist from Sep 2015 to Aug 2016.

Worked in Bank of Queensland (through Rational BI), as SAS Developer from July 2014 to Sep2015.

Worked in University of Newcastle, Australia, as ETL Analyst from Apr 2014 to July 2014.

Worked at Mahindra Satyam Computer Services LTD (CMMi level 5), India, as Tech Lead, from Apr 2011 to Feb 2014.

Worked at Cognizant Technology Solutions India Private ltd (CMMi level 5), Chennai, as Associate - Projects, from Jan 2008 to Apr 2011.

From Jan 2007 to Dec 2007, with Mascon Global Limited (CMMi level 5), Chennai, as Executive - Systems.

From Apr 2005 to Jan 2007, with Kinship Technologies Private Limited, Chennai as Junior Systems Analyst.

Work experience

Organization

: Great Southern Bank Jun 2021- till date

Tools

: SAS DI, SAS EG, SSIS

Database

: SQL Server

Platforms

: Windows

Role

: Data Engineer

Responsibilities

Development or Enhancement of data pipeline for business stakeholders.

Analysis of Ad-hoc data extract and provide data to business

Development and provision data for regulatory reporting requirements (ATO, APRA).

Production support activities

Performance optimization, SQL tracing, reading the Execution plans and index tuning.

Organization

: Heritage Bank Jan2019- Jun 2021

Tools

: Wherescape Red

Database

: SQL Server

Platforms

: Windows

Role

: Data Engineer

Responsibilities

Lead the design, development, and implementation of high performance Enterprise Data Warehouse.

Responsible for the operations of the newly build data warehouse ecosystem at Heritage Bank.

Assist and up skill data engineer’s to adapt best practices and build data pipelines with a consistent framework which support enterprise architecture.

Liaising between technical teams and business.

RDBMS Design (Logical & Physical) Skills and working with Databases includes SQL, PL/SQL Concepts in MS SQL Server 2005/ 2008/2008 R2/ 2012/2014/2016.

Design and development of T-SQL Data definition language (DDL) & Data modification language (DML) objects.

Creating various T-SQL objects like stored procedures, Triggers, Cursors, CTE, Table Valued Functions, Dynamic SQL.

Performance optimization, SQL tracing, reading the Execution plans and index tuning.

Backup and recovery of SQL Server using various recovery modes.

Closely working with DBAs to implement SQL Server Security by creating new logins and access permission to the developers and restricting the users to access the database objects.

Data validation and data migration.

Writing data validation rules and mapping from legacy to new systems.

Supervising and mentoring Analysts and providing guidance to other staff on technical and business issues.

Identifying and analysing alignment issues between business strategies, business processes and IT systems.

Developing manuals and providing skills transfer.

Perform a range of systems and application performance characterization and trade-off studies through analysis and simulation.

Research improvements in coding standards to provide innovative operational solutions and best practices to the organization.

Translate strategic requirements to ensure effective solutions meet business requirements.

Review and approve specifications to ensure consistency in development / design approach.

Key Achievements:

Turned a failing Enterprise Data Warehouse project into a success through a more rigorous approach to design and development and improving communication between business and technical teams.

Enabled effective self-service reporting and analysis for Enterprise wide key stakeholders.

Implemented a platform that can provide ad-hoc access to large datasets to support analytical requirements.

Developed various database objects like stored procedures, functions, Views as per design.

Designed and implemented ETL procedures for intake of data from both internal and external sources

Ensured data is verified and quality is checked before the data is loaded to transactional databases.

Participate in Business Intelligence code and design reviews, reviewing others code and having own code reviewed.

Performed ad hoc data analysis to meet business unit reporting/data validation needs.

Resolved critical issues debugging the code on priority for a smooth performance of the business.

Wrote Unit test cases and execute them before the code is deployed to QA team for testing.

Ensured all data warehouse architecture codes are maintained in a version control system.

Organization

: Heritage Bank

May2018 – Dec2018

Tools

: SAS DI, SAS EG, SAS VA, SAS CM

Database

: SAS Datasets, SQL Server

Platforms

: Windows

Role

: Integration Developer

Responsibilities

Development / Modification of SAS coded Data Vault data warehouse solution.

BAU activities.

Production support activities.

Implementation and maintenance of SAS User Access.

Promotion of SAS jobs to different environments and scheduling the SAS jobs.

Loading and maintaining SAS VA LASR tables.

Updating and maintaining SAS Info map for SAS Campaign Studio.

Organization : Bank of Queensland Oct 2017 – May2018

Tools : SAS EG, Base SAS, UNIX Shell Scripting, Windows Batch Scripting

Database : SAS Datasets, Oracle, Flat files, SQL Server

Platforms : Windows 10 and UNIX

Role : Senior Data Analyst – Credit Risk

Responsibilities

Development / Modification of credit risk Application, Account, and Collateral data marts which feeds information to Application or Behavioural scorecards.

Identify data collection systems and develop, implement of SAS code which builds the datasets for credit risk data mart.

Production support activities for month end run.

Helping team with data governance related activities.

Build and Implementation of validation code to reconcile source data against data mart.

Ad hoc tasks as requested by the Line Manager.

Organization : Greater Bank Aug 2016 – Sep2017

Tools : SAS DI 4.9, SAS EG, Base SAS, SAS VA

Database : SAS Datasets, Oracle, Flat files, SQL Server

Platforms : Windows 10

Role : BI Analyst

Responsibilities

Interpret data, analyse results using statistical techniques and provide ongoing reports.

Works directly with business stakeholders to identify analytical requirements.

Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.

Identify, analyse, and interpret trends or patterns in complex data sets.

Filter and “clean” data, and review reports to locate and correct code problems.

Work closely with management to prioritize business and information needs.

Locate and define new process improvement opportunities.

Security Design and Implementation of SAS user access.

Ad hoc tasks as requested by the Line Manager.

Organization

: CUA

Sep 2015 – Aug 2016

Tools

: SAS DI 4.9, SAS EG, Base SAS

Database

: SAS Datasets, Oracle, Flat files, SQL Server

Platforms

: Windows 7

Role

: Senior Information Specialist

Responsibilities

Business Analysis - Liaise among stakeholders in order to elicit, analyse, communicate and validate requirements for changes to business processes, policies and information systems.

Operational Reporting – Development of processes for the operation SAS BI environment communicating with other area of IT as appropriate.

Business and IT Translation – Act as the main conduit for reporting between the Information Management team and the business by translating business needs into technical specifications and vice versa for technical questions and issues.

Reporting Solution Design – Liaise with internal stakeholders and external vendors in order to design appropriate reporting solutions and approaches that meet business requirements and comply with corporate and IT policies and strategies.

Consulting – Provide Information Management consulting and systems expertise to CUA staff as required.

Organization : BOQ (through Rational BI) Jul 2015 – Sep 2015

Project Name : RLO Interim Solution

Tools : SAS EG

Database : SAS Datasets, Oracle, Flat files

Platforms : Windows XP, UNIX

Role : SAS Developer

Description

Bank is introducing the new Retail Loan Origination (RLO) application to support simpler, faster electronic application processes. RLO interim (tactical) solution will be developed to consume data from our new loan system in order to ensure business critical or business essential reports continue to function.

Responsibilities

Identifying business essential/critical reporting which are using the application data. Analyzing and consolidating the fields are required for reporting

Define the consolidate data table(s) structure to capture the new and existing application data to support reporting.

Create solution design and detail design document.

Develop SAS code to build the consolidate data table(s) to support reporting solution Unit test the processes to meet current reporting requirement.

Organization

: BOQ (through Rational BI)

Jul 2014 – May2015

Project Name

: RBA REPO

Tools

: SAS EG

Database

: SAS Datasets, Oracle, Flat files

Platforms

: Windows XP, UNIX

Role

: SAS Consultant

Description

The Reserve Bank is introducing new reporting requirements for repo-eligible residential mortgage backed securities (RMBS) and asset-backed securities (ABS) in its operations. Issuers of RMBS and ABS will be required to provide more detailed information. The new information, which will have to be reported monthly, covers both transaction-related data as well as information on the underlying assets. These new reporting requirements are designed to promote greater standardisation of securitisation reporting and enhance information available on securitisations in the Australian market since there is currently no regulatory standard for RMBS and ABS reporting and disclosures.

Responsibilities

Create High level design document for reporting requirement.

Create Functional spec for new reporting solution

Create Detail design document for reporting requirement.

Independently design and implement the processes to produce report output based on RBA guidelines.

Unit test the processes to meet current reporting requirement.

Deploy and Scheduling of reporting programs to produce report based on RBA reporting guidelines.

Organization : University of Newcastle Apr 2014 – Jul2014

Project Name : Strategic Performance Management - Phase 2

Tools : SAS DI Studio, BASE SAS 9.3, SAS Macros

Database : SAS Datasets, Oracle, Flat files

Platforms : Windows, UNIX

Role : ETL Analyst

Description

The Strategic Performance Management (SPM) Phase 2 project aims to deliver strategic business intelligence reporting as an enabler for informed decision making, supporting the corporate planning cycle and New Directions objectives. The data integration and reporting clusters include Education, Research & Innovation.

Responsibilities

Provide conceptual and technical advice and assistance to inform decision making in relation to data management processes that support strategic planning, benchmarking and quality assurance activities relating to all business intelligence and data management operations in the data warehouse and reporting environment.

Independently design and implement Extract, Transformation and Load (ETL) processes to be used by the data warehouse team and then train and supervise the team’s use of these processes, programs and scripts using the SAS toolset and more specifically SAS Data Integration Studio (SAS D.I. Studio) on Windows.

With broad direction, independently perform system & technology evaluation, data analysis, programming, querying, reporting and ETL and job schedule configuration that contributes to and integrates with the team operations of handing the daily process of managing data used for strategic decision making and the measurement of key performance indicators across the University.

Develop technical design specifications through effective consultation with stakeholders and clients and in doing so provide expert advice to customers and developers on delivery approach, integration and schedule

Conduct root cause analysis and resolve production problems and data issues.

Contribute to designing and be responsible for components of the development and implementation of policies and systems to improve data quality

Provide professional advice and assistance to colleagues in the use of the Management Information System.

Work closely with the Data Warehouse Manager and staff to provide advice on schedule estimates, communicate project progress and give early notification of issues that may impact on projects and reporting initiatives.

Provide ongoing advice and active participation in the maintenance and support of assigned ETL applications.

Organization

: Mahindra Satyam Computer Services LTD

Apr 2012 – Feb 2014

Client Name

: Suncorp Metway - Australia

Project Name

: Legacy Simplification Program

Tools

: SAS DI Studio, BASE SAS 9.3, SAS Macros

Database

: SAS Datasets, DB2, Flat files

Platforms

: Windows XP, UNIX

Designation

: Module Lead

Team size & Role

: 4, Tech Lead

Description

The Legacy Simplification Program (LSP) is part of a Suncorp Group focus to simplify our business. The program will enable Suncorp to deliver better customer service and be a more competitive, profitable organisation by providing greater product harmony, simplified technology applications and streamlined processes. By reducing complexity and cost, the program will also provide opportunity for Suncorp to accelerate their online aspirations.

LSP will rationalise 14 General Insurance (GI) policy applications down to 3; consolidate Workers Compensation onto GuideWire PolicyCenter; and convert Life/Super portfolios from Solar onto Life400.

Responsibilities

Analyze and re-designed the source layer to extract and load the data in much simpler way with greater performance.

Designed the Base layer framework and created the design document.

Developed the Base layer actuarial jobs as per the actuarial requirement.

Re-designed and created new actuarial jobs to simplify the business.

Involved in the performance tuning to load the data in better way.

Deploying the SAS DI jobs and scheduling the daily, weekly and monthly flows by using SMC.

Developed the UNIX and windows batch scripts for Control-M schedule.

Worked with testing and business teams to obtain the UAT signoff.

Implemented the project in production.

Created the production support handover document for support handover.

Provided the support after implementing the jobs in Production.

Organization

: Mahindra Satyam Computer Services LTD

Apr 2011 – Apr 2012

Client Name

: Suncorp Metway - Australia

Project Name

: IDW Claim Centre

Tools

: SAS DI Studio, BASE SAS 9.1.3, SAS Macros

Database

: SAS Datasets, Oracle, Flat files

Platforms

: Windows XP, UNIX

Designation

: Module Lead

Team size & Role

: 4, Tech Lead

Description

SUNCORP is implementing a single claims processing system called Claim Centre. This application will replace all claims functionality within the 3 main legacy systems namely Cogen 1.5, Cogen 3 and Insure.

As a part of Building Blocks project, IDW Claim Centre project started to support the actuarial processing and reporting requirement. New claims for Sun/GIO/AAMI/APIA brands are lodged into Guide-wire Claim Centre. IDW daily processes load this data from Claim Centre to IDW source layer. Business logic and transformations are applied on the source layer data and loaded into the IDW base layer tables. Processed data in base layer tables is used further in the integration and actuarial layer.

Responsibilities

Understanding the Business requirements.

Development of ETL Specification and ETL Design Documents.

Preparation of the Functional specification Documents.

Designed the control framework to load the source layer data in much simpler way.

Designed the SAS DI actuarial jobs as per actuarial requirements.

Interacted with business users to understand the change requests and UAT signoff.

Deployment of SAS DI jobs and scheduling the deployed jobs by using SMC

Implemented the project in production.

Created the production support hand over document for support.

Provided the warranty support.

Organization

: Cognizant Technologies Solutions India Private LTD

Jan 2008 – Apr 2011

Client Name

: Lloyds Banking Group - UK

Project Name

: See Below

Tools

: BASE SAS 9.1.3, SAS DI, SAS Macros

Database

: SAS Datasets, Flat files, Oracle, DB2, Netezza

Platforms

: Windows XP, UNIX

Designation

: Associate - Projects

Team size & Role

: 8, Team Lead and SAS Developer

Project Name

: Data Conversion System

Description

This project aims to convert DCS (Data Conversion System) code to Base SAS code. DCS stands for "Data Conversion System". It is part of SunGard's iWorks suite and is designed to create model point files for Prophet.

Project Name : DW GI Migration

Description:

GI Migration forming part of the first phase of the project is basically a migration project, from the existing SAS IAB/SPDS environment to SAS DI Studio/Netezza Environment. The project aims to deliver a consolidated I&I Business Intelligence (BI) infrastructure, replacing existing disparate MI platforms and to achieve associated cost reduction in line with the Platform for Growth (PFG) Application Landscape initiative. The entire Insurance architecture prior to migration was developed using BASE SAS and IAB (Intelligent Architecture Blue Print). Going forward the Insurance architecture is being moved to Netezza Data Server a fully integrated solution, using SAS DI Studio as the ETL and rewritten Netezza Compliant Code for optimized Performance.

Responsibilities

Performed Requirement analysis.

Translation of business requirements into Functional Specification document.

Prepared the Technical specification document with High Standards.

Coordinates with clients at onsite for Business, Technical and Functional clarifications.

Provided Estimates for SAS Reporting Projects.

Proposed the SAS Technical solutions for their new requirements.

Creation or Modification of Complex SAS programs/ SAS ETL jobs as per design.

Tuned the Existing SAS processes for better performance.

Created of Test plans, Production Release Notes.

Prepared Unit Test cases and execution plan.

Support during Implementation.

Shared the SAS & Project knowledge to the offshore team.

Organization

: Mascon Global Ltd

Jan 2007 – Dec 2007

Project Name

: See below

Tools

: SAS DI Studio, SAS Macros

Database

: SAS Datasets, Oracle, Flat files

Platforms

: Windows XP, UNIX

Designation

: Executive - Systems

Role

: ETL Developer

Project Name

: Cheadle dashboard

Description:

This Project sources the data from multiple call handling systems and populate warehouse and which intern is used for reporting. This overcomes the drawback of current system where the reporting is done in different method among the call handling sites. The project will deliver 5 reporting areas:

1.Forecast Calls

Information about each version of the Forecast Calls for a Call Prefix

2.Agent Shift Adherence

This reporting area will show agents adherence from scheduled to actual shift and from actual to scheduled shift.

3.Calls By Application

Data will be held relating to call handling performance for each application.

4.Agent Activity Detail

This reporting area will show each individual Call Handling activity undertaken by an Agent whilst signed into Rockwell.

5.Agent Activity Agg (formally known as Call By Agent)

This reporting area will show aggregated information about Call Handling activity undertaken by an Agent whilst signed into Rockwell

Project Name : Customer Key Merge flows

Description:

Merging AA Mart and CM Mart using Customer Key

The design for changing the analytical mart processing from mart_key to customer_key is initially based on table listings. Detailed in this section is all tables that need to be altered, some of these tables will have underlying code in the monthly mart that will also need to be changed. SAS and Oracle tables are included in this change.

Responsibilities

Designing and developing ETL packages, Data warehouse, Data Systems, Data Marts, Data Interfaces and Business Intelligence solutions within a team environment. Development of ETL Specifications & ETL Design Documents.

Analyze existing system / database architecture and provide all necessary recommendations for improving the architecture and if required re-design them.

Maintenance of the data warehouse such as loading, reorganizing and indexing for better data retrieval needs.

Support the team members involved in the project.

SQA team member from SAS team.

Organization

: Kinship Technologies Private Limited

Aug 2005 – Jan 2007

Project Name

: See below

Tools

: Base SAS, SAS Macros

Database

: SAS Datasets, Flat files, Oracle

Platforms

: Windows

Role

: SAS Developer

Designation

: Junior Systems Analyst

Project Name

: Parallel Clinical Trial Data Analysis

Description:

This projects aims to deliver Listings, Statistical Tables & Graphs for effectiveness of drug and safety analysis of randomized, blinded or unblinded or double blinded subjects. This work involved extensive literature survey for clinical data and also deliver datasets in CDISC formats.

Responsibilities

Performed Requirement analysis.

Translation of business requirements into Functional Specification document.

Creation or Modification of SAS programs as per design.

Tuned the Existing SAS processes for better performance.

Created of Test plans, Production Release Notes.

Prepared Unit Test cases and execution plan.

Support the team members involved in the project.

Other Skills:

SAS Quality Process (Mascon Global Limited – CMMi level 5).

•Organized and helped to create the SQP for SAS team.

•Creation of PDSP document for SAS team

•Creation of common Quality Documents (SQAP, SCMP, BP, RP, Build Standards, change management)

•Creation of various Quality ensuring Checklists (Code review, test case, peer review checklist)

•Managing the configuration management tools (VSS).

Software Quality Assurance

•SQA team member from SAS team.

•Part of the Software Quality Assurance Procedure provides the management with visibility into the process being used in software development and software products.

•facilitating the Software Quality Assurance and audit processes of projects as per internal quality audit plan and verifies process adherence of various projects across divisions to CMMi level 5 processes.

Personal Details

Date of Birth : 07-Mar-1983

Languages Known : English, Tamil

Marital Status : Married

Present Address : 520 Hume Street,

Middle Ridge,

Toowoomba, QLD - 4350

Australia.

Date:

Place: Toowoomba - QLD

Sekar Kumarasamy

Contact this candidate