SATHIYA SUBRAYAN

adkrj5@r.postjobfree.com 424-***-**** LinkedIn URL

Data Warehousing (ETL) and Database developer having more than 5 years of work experience on leading, designing, delivering robust, scalable, and highly available Data warehouse and Data Integration solutions. Mentored and co-lead teams to completion of projects. Have proven experience in Design, Development, Data Warehouse, Technical hands-on experience in development of Data warehousing solutions using Oracle SQL/PLSQL, Informatica Power Center, UNIX Shell Scripts and Tableau.

SUMMARY OF QUALIFICATIONS

Lead development including methodologies for data transformations and processes in a corporate ETL solution.

Provided technical assistance, developing and implementing tests, monitoring all ETL jobs, managing and applying various performing techniques.

Experience in developing PL/SQL objects such as Functions, Indexes, cursor, Table Partitioning, Views, materialized views, indexes, Packages, Exception handling, Dynamic SQL and Triggers and Stored Procedures.

Experience in Performance Tuning and Query Optimization.

Demonstrated expertise utilizing ETL tool like Informatica, Datastage and SSIS.

Experience in Informatica PowerCenter (9.1) in developing and administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager & Workflow Monitor.

Wrote Unix Shell Scripts for scheduling jobs and executing PL/SQL objects.

Worked on Control-M and AUTOSYS scheduler to monitor and run the ETL jobs.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS services.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Worked on all phases of data warehouse development lifecycle (SDLC), from gathering requirements, Design, Development, testing, implementation and support followed by Agile / Scrum development methodologies.

Experience in prioritizing and fixing defects, handling defect triaging from development end.

Highly motivated, hardworking, able to lead and take responsibilities, good team player and client interfacing skills always striving to achieve quality in everything.

Strong leader with experience in training developers and advising technical groups on ETL best practices to deliver best results.

EXPERIENCE

OCT 2019 – PRESENT

DATABASE/SQL SERVER DEVELOPER, CINCINNATI, OH, USA

Client: PERR&KNIGHT

Project: To build statistical reports on Premium and Losses for bureaus like ISO and NCCI from different clients (Amerisure Insurance, Amerisafe Insurance, Motorist Insurance Group, Homesite Insurance, Origami and Zurich Insurance).

Worked with installing, designing and managing MS SQL Server 2008/2010/2011.

Worked on PL/SQL objects such as tables, views, indexes, stored procedures, functions and triggers & maintaining Referential Integrity.

Loading (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle and SQL server.

ETL, data profiling, data quality and clean ups for SSIS packages.

Created SSIS packages to populate data from various data sources from Flat Files, Excel Files and OLEDB to SQL Server.

Created and configured SSIS packages for data extraction using Package configuration wizard to allow packages run on different environments.

Worked on UNIX shell scripting in automation of ETL Jobs.

Working on Agile Methodologies with daily scrum meetings and share point/Microsoft Planner to update and monitor tasks.

Worked on Agile methodology using JIRA software.

DEC 2018 – OCT 2019

PL/SQL DEVELOPER, INFOSYS Ltd - HARTFORD, CT, USA

Client: The FISERV

Project: Deals with the financial world, including banks, credit unions and securities processing organizations, insurance companies, finance companies and mortgage banks.

Developed PL/SQL packages, procedure and triggers in Oracle 11g to implement the business requirements to satisfy the reporting conditions.

Used collection, view, cursor, exception, index, partition while creating process to deal with banking transaction data.

Performed PL/SQL code optimization to handle huge volume of data (10 years) from various systems.

Developed a package in PL/SQL and implemented multiple functions to handle the data conversion and then load the converted data into new tables.

Extensively used oracle stored procedures, indexes and partitioning options to increase the performance of the database by 30%.

Creating report for all end user having detail about transaction related to credit card and other process using SQR.

Created numbers of jobs using SQR to generate LIS report and text file.

Worked in Agile methodology for multiple projects including Data Modernization.

Experience in Autosys to schedule ETL jobs daily, weekly and monthly.

Maintained Versions of Components using Subversion tool.

AUG 2011 – SEP 2014

ETL DEVELOPER, TATA CONSULTANCY SERVICES (TCS) - CHENNAI, TAMIL NADU

Client: The Hartford Financial Services Group, Inc

Project: PARIS (Premium Audit Reporting and Information System) application that helps to calculate the premium amount which has been calculated during auditing.

Strong technical experience in data model, design, development, implementation, customization, maintenance and production support of ETL migration, integration and data warehousing projects.

Created multiple procedures and packages using PL/SQL in Oracle Exadata environment for handling large volume of Quote, Policy and Financial data.

Loaded data into star schema model with Type 2 dimensions and various types of facts.

Developed complex queries for statistical analysis and reporting for various customer requirements.

Developing the packages, triggers, views, functions and indexes, stored Procedures in PL/SQL objects based on functional description to process the data.

Extensively used Joins and sub-queries for complex queries involving multiple tables.

Created UNIX shell scripts triggered by PL/SQL stored procedure.

Created job scheduler for all script mentioning dependency and order of trigger.

Understanding the issue faced by client and reply with a satisfactory explanation within the first response SLA.

Performed Query optimization and PL/SQL tuning to maximize performance.

Involved in creating Indexes, using hints, analyzing the table statistics and Table.

Project: The Integrated Homeowners Quote (IHQ)

Expertise in ETL technologies and informatica suite, informatica power center (PC), database programming, sql loader, database tuning, building complex queries.

Worked extensively on Informatica tools such as Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor.

Created complex mappings in Informatica using various transformations such as Sql transformation, Lookup, Aggregator, Expression, Joiner, Router, Filter, Update Strategy, and Sequence Generator for many applications.

Developed mappings to extract data from Operations system to staging area and loaded into facts and dimensions.

Used Workflow Monitor to monitor tasks, workflows and also to check performance.

Prepared the detailed unit test case & test log with the source and target data.

Tested the mappings for its business rule.

Tuned the mapping for its better performance by adjusting session level parameters.

Scheduled workflow jobs using Autosys Scheduler.

EDUCATION

MAY 2011

BACHELOR'S IN INFORMATION TECHNOLOGY (First Class with Distinction (8.62 CGPA))

Pondicherry Engineering College - Pondicherry Ho., Puducherry

August 2007 to May 2011

SKILLS

SQL (5 years)

Oracle (5 years)

Unix (4 years)

Data warehousing (5 years)

Business Objects (1 year)

Agile (2 year)

Autosys (4 years)

PL/SQL (5 years)

PowerCenter Informatica (3 years)

JIL (4 years)

Tableau (1 year)

Toad for Oracle (4 years)

ACTIVITIES

Oracle Certified: Oracle PL/SQL Developer Certified Associate certification (OCA)

AINS 21 Certified: Property & Liability Insurance Principles.

Loves to share knowledge with other team members and conducted many trainings sessions on application and technology.

Takes online courses to keep me updated. Currently preparing for AWS Developer certification.

Have lead team for 2+ years and successfully delivered many projects.

Contact this candidate