Sabarisaravanan Sekar
Chennai
Summary
To Seeking a challenging role as a Data engineer in an organization offering personal growth and career development. Intend to build a career with a reputed organization with committed and dedicated people, which will help me to explore myself fully and I am willing to work as a key player in a creative and challenging environment using Oracle/GCP/Snowflake/Informatica Data governance (IDMC) Technologies.
Overview
2
2
Languages
1
1
Certification
9
9
years of professional experience
Work History
Senior PL/SQL Developer
Project - Dell
Chennai
07.2022 - Current
- DELL FED is a Marketing customers Data platform, which provides a holistic view of Federal Customer and their data by creating Golden records of Contacts, Sites, Accounts, Emails and Addresses, with a clear understanding on Customer Preferences to strengthen all possible customer interactions.
- I have taken full control of the Dev work and started working closely with the QA and Onsite Dev team.
- Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
- Coordinated with the onsite team to provide them with the necessary stored procedures and the necessary insight into the data.
- Creation of database objects like Tables, Views, Sequences, Procedures.
- Experienced in ETL (Tidal) – for file processing from the source to target.
- My responsibilities include working on the reporting - Cloud migration from Oracle to Snowflake.
EI Specialist
Mastech InfoTrellis
Chennai
07.2022 - Current
- Working as an EI Specialist in Mastech InfoTrellis Chennai.
PL/SQL Developer
Project- Citi Bank (GLS)
Chennai
02.2021 - 07.2022
- Global Liquidity System is a scratch project to set limit amount transactions among the Citi Branches to Incoming/ Outgoing amount by role-based Approval and Rejections.
- Analyzed the requirements and converted them into technical specifications.
- Involved with BA/Technical Architect discussion from scratch.
- Created new Tables, procedures, functions and needed oracle objects as per the requirements.
- Coordinate with the UI team and provided Json params details to ensure with them on same page.
- Accommodate Json related params as input in oracle SP’s.
- Coordinating and working closely with the UI, DBA, QA and UAT teams during various phases of the project.
- Providing support to the users during UAT and involved in analysis and bug fixing of the issues raised.
- Deploying DDLs and application code and troubleshooting on production environment.
- Environment: Oracle 10g, Oracle 11g, Oracle 12c, Oracle 19c.
Senior Consultant
Virtusa Consulting Services Pvt Ltd
Chennai
08.2019 - 07.2022
- Worked as a Senior Consultant in Virtusa Consulting Services Pvt Ltd Chennai.
PL/SQL Developer
Project- Citi Bank (CRM)
Chennai
08.2019 - 07.2022
- The Ultimate goal of the CRM effort at Citi Transaction Services is to provide a 360-degree view of the customer to any member of the organization who touches the customer. The Siebel CRM application is widely being used by Salespeople in creating, tracking the deals and bringing them to the closure.
- Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Coordinated and worked closely with the UI, DBA, QA and UAT teams during various phases of the project.
- Creation of database objects like Tables, Views, Synonyms, Sequences, Materialized views, Procedures and Packages using oracle tools like SQL Developer and SQL
- Plus.
- Monitoring the Existing Autosys Jobs and involved job migration to Linux server.
- Providing support to the users during UAT and involved in analysis and bug fixing of the issues raised.
- Deploying DDLs and application code into the production environment during project release.
- Tracking the All-Release Requirements until Production deployment and Support for all Production Release until get Post Prod Sign off.
- Taken care of all Weekend Data Tasks from DB side as Technical Lead and Deployed into Production using Bitbucket/Udeploy/Citiversion Builder.
- Fulfilled On-demand user requests for statistics reports on usage of application by Retrieving data from the database.
- Using SQL Loader utility to load input files into the database staging tables.
- Executing data tasks using SQL scripts to fix issues in the production Database.
- Created Indexes on the tables for faster retrieval of the data to enhance database performance.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Environment: Oracle 10g, Oracle 11g, Oracle 12c, Oracle 19c.
Technology Support Specialist
INFOSYS
Mysore/Bangalore
08.2017 - 08.2019
- Worked as a Technology Support Specialist with INFOSYS Mysore/Bangalore.
PL/SQL Developer
Project-Asian Development Bank
Bangalore
08.2017 - 08.2019
- It’s a converting of Legacy system (Modern Disbursement System) to Integration Disbursement system (IDS), Provides an extensive range of functions and data access within all key investment activities such as Loan, Sub-loan, Grant, Cash Processing, Voucher Regulatory reporting and Interface & reports.
- Coordinated with the front-end design team to provide them with the necessary stored procedures and the necessary insight into the data.
- For Interface Module Creating of database objects like tables, views, procedures, Functions Collection using oracle tools like SQLDeveloper.
- For Report Module Designing Front end and Backend as well using Jasper iREPORT.
- Environment: Oracle 11g, SQL
- Plus, TOAD, SQL Developer, Jasper iReport.
Education
Bachelor of Engineer -
St Joseph college of Engineering
ChennaiSkills
- Over 8 years 11 months of Experienced in programming as Backend Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relation Database Management System (RDBMS)
- Having good knowledge of Software Development Life Cycle (SDLC)
- Experience working with Development and Production environment
- Expertise in Client-Server application development using Oracle 19c/12c/11g/10g, PL/SQL, TOAD and SQL DEVELOPER
- Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, Joins and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Sequences
- Experience with Performance Tuning for Oracle RDBMS using Explain Plan and INDEX and HINTS
- Having basic knowledge of Python programming language
- Monitoring the Existing Autosys Jobs and involved job migration to Linux server
- Experience working with Autosys, Udeploy, TFS, Version builder, Bitbucket, JIRA, ServiceNow
- Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team
- Experience working with GCP and Informatica power center
- Experience working with Snowflake
- Having basic knowledge of Power BI
- Having basic knowledge of DBT (Data Build Tool)
- PL/SQL development
- Data analysis
- Requirement gathering
- Performance optimization
- Problem solving
- SQL optimization
- Performance tuning
Certification
- Certified Azure fundamentals (AZ-900)
- Certified Snowflake SnowPro core.
- Cloud Data Governance & catalog Foundation.
Languages
English
Proficient
C2
Tamil
Proficient
C2
Custom
I hereby declare that all the above furnished details are true to the best of my knowledge and belief.
Personal Information
Father's Name: T. Sekar
Timeline
Senior PL/SQL Developer
Project - Dell
07.2022 - Current
EI Specialist
Mastech InfoTrellis
07.2022 - Current
PL/SQL Developer
Project- Citi Bank (GLS)
02.2021 - 07.2022
Senior Consultant
Virtusa Consulting Services Pvt Ltd
08.2019 - 07.2022
PL/SQL Developer
Project- Citi Bank (CRM)
08.2019 - 07.2022
Technology Support Specialist
INFOSYS
08.2017 - 08.2019
PL/SQL Developer
Project-Asian Development Bank
08.2017 - 08.2019
Bachelor of Engineer -
St Joseph college of Engineering