Summary
Overview
Work History
Education
Skills
LANGUAGE SKILLS
Timeline
Generic
PRIYADARSHINI M

PRIYADARSHINI M

Chennai

Summary

Seasoned ETL & Oracle Database developer with a robust 9 years track record in Telecom & Retail sector. Skilled in Data warehousing with primary focus on design, development and implementation of ETL using databases like Oracle, Netezza and Linux & extensive knowledge in Dimension modeling concepts like Star Schema and Snowflake Schema, Understanding of Data warehousing concepts like Warehouse architecture, OLTP, OLAP, Data Marts, ODS, Dimension and Fact tables. An effective communicator and relationship-builder, leveraging exceptional interpersonal and organizational skills. Adept at training and development of team members, thriving in both team-driven and self-directed environments, and delivering high performance under pressure.

Overview

11
11
years of professional experience

Work History

Senior Digital Engineer

Sonata Software
Bangalore
01.2023 - Current
  • Expertise in Oracle Application 11i and Toad for Oracle
  • Developed SQL scripts, Stored Procedures and packages
  • Enhanced data types, event types in Oracle application.
  • Responsible for activities like requirements gathering, Migration and data gathering in order to create new structure of data’s for the users
  • Used Oracle SQL Database for all the data related queries from backend.
  • Developed SQL scripts in achieving the Data requirements, creating reports and migration of Data's from one Database to another and from local file to Oracle Database.
  • Worked on BMC Remedy tool in order to track customer orders with the help of oracle backend support.
  • Extended my support on Database migration activity.

Senior Associate consultant

Saksoft Limited
Chennai
03.2015 - 01.2023
  • Strong knowledge in Business Intelligence with good experience in Data modelling, ETL tools like SQL server Data tools and IBM DataStage and SSIS tools
  • Good experience in Performance Tuning, Monitoring and Supporting Production environments.
  • Took full ownership including requirements gathering, Migration and data gathering in order to create new structure of data’s for the users.
  • Created jobs to generate final output files from Netezza tables.
  • Created Sequence jobs for top level batches by using loop concept to read each file.
  • Developed SQL scripts (i.e. for achieving the data) and shell scripts (i.e., for Validating the input files and transferring files from DataStage server to Target server).
  • Have contributed individually in SAP HANA migration activity in my project.
  • Upgradation activity from Netezza Database to SAP HANA Database.
  • Trouble shooting of packages after migration and knowledge on Database maintenance during and after migration.

Education

Computer science Engineering - undefined

Anna University
05.2014

Skills

  • ETL Tools: very good knowledge: SSIS, ETL, Data Warehouse development / IBM InfoSphere Datastage
  • Programming & Scripting Language: Oracle SQLdeveloper / PL SQL / UNIX Shell / toad for oracle
  • Clouding Tool: Microsoft Azure
  • Reporting Tool: Power BI
  • Database: oracle 11g / IBM Netezza / Oracle 10g
  • Applications: Oracle 11i / BMC REMEDY

LANGUAGE SKILLS

Fluency in Tamil, English & Malayalam

Timeline

Senior Digital Engineer

Sonata Software
01.2023 - Current

Senior Associate consultant

Saksoft Limited
03.2015 - 01.2023

Computer science Engineering - undefined

Anna University

Similar Profiles

CREATE PROFILE
PRIYADARSHINI M