DHILEBA SEKAR
Summary
Around 9 years’ Professional IT Experience in Software Analysis, Design and Development using various applications tools to provide Business Intelligence Solutions in Data Warehousing.
Experience in working for developing applications using PowerApps, canvas, model driven app.
Identify product data mapping and write complex ETL & model building using SQL/SSAS/SSIS.
Proficient in PL/SQL and creation/modification of database objects like Tables, Packages, Procedures Functions, Exception Handling, Constraints, Index, and Triggers.
Worked on debugging/rectification of issues in production environment.
Currently working under agile methodology.
Experience in performance tuning.
Experience in writing DDL, DML, and complex queries in Oracle SQL.
Good in Understanding of Business logic and ability to work well as a part of a team and as an individual.
Overview
12
12
years of professional experience
Work History
Technical Lead
Infosys Ltd.
- Analyzed existing SAP DS Screenshots, dataflows, and transformation logic.
- Designed equivalent SSIS packages using Control Flow, Data Flow, and Script Tasks.
- Validated data accuracy through parallel run comparisons and reconciliation reports.
- Deployed and scheduled SSIS packages via SSISDB and SQL Server Agent.
- Collaborated with teams to align data pipelines with business needs.
- Provided knowledge transfer and documentation for long-term maintainability.
- Created and triggered the files from SSIS to GCP console.
Technical Lead
Infosys Ltd.
07.2022 - Current
- Creating SSIS packages as per the requirement.
- Writing Stored procedures in SQL Server for Various Power BI Reports and Dashboards.
- Package deployment using Integration Service Catalogs and Job creation and scheduling using SQL Server Agent.
- Identify product data mapping and write complex ETL & model building using SQL/SSSIS.
- Involved in requirement gathering and analysis with client on a daily basis.
- Modification of existing SSIS Packages, Stored Procedures, and existing tables as per business requirement.
Senior Developer
Prism Enterprise Solutions
12.2020 - 05.2022
- Developed canvas and model driven applications in PowerApps using CDS, Flow, Excel, Forms and SharePoint online.
- Involved in manual testing of the application.
- Enhanced and developed reports based on new requirements.
- Created reports and dashboards using Power BI.
- Prepared root cause analysis for problems occurred.
- Allocated daily jobs and workloads to the team.
- Trained new team members and reported to senior managers.
Developer
Standard Chartered Global Business Service Private Ltd.
06.2016 - 02.2020
- Involved in development and application support.
- Enhanced and developed reports based on new requirements.
- Programmed functions and queries.
- Used batch tuning and performance enhancements.
- Conducted unit and system testing.
- Prepared root cause analysis and provided production support.
Software Engineer
Dowell Technologies (Ramco Systems)
05.2015 - 06.2016
- Implemented incremental logic for efficient data extraction.
- Developed automation logic for report generation.
- Involved in ETL works and automation using Informatica.
- Created stored procedures, functions, views, synonyms using PL/SQL.
- Generated ER reports using RDW tool.
Oracle Trainer
Times Technologies
Chennai
01.2014 - 12.2014
Education
B.Tech - Information Technology
Anjalai Ammal Mahalingam Engineering College
01.2013
HSC - undefined
Savitri Vidhya Sala Girls Higher Secondary School
01.2009
SSLC - undefined
St. Isabel’s Girls Higher Secondary School
01.2007
Skills
- Oracle 10g
- Oracle 11g
- MS_SQLSERVER
- Windows
- SQL
- PL/SQL
- POWERAPPS
- SSMS
- SSDT
- SQL Developer
- Visual Studio
- JIRA
- SVN
Languages
Tamil
English
Personal Information
- Father's Name: R. Sekar
- Date of Birth: 24-06-1992
- Gender: Female
- Nationality: Indian
Disclaimer
I hereby declare that the information published above is correct according to my knowledge and conscience. I can be held responsible for any discrepancies in the above-mentioned facts.
Timeline
Technical Lead
Infosys Ltd.
07.2022 - Current
Senior Developer
Prism Enterprise Solutions
12.2020 - 05.2022
Developer
Standard Chartered Global Business Service Private Ltd.
06.2016 - 02.2020
Software Engineer
Dowell Technologies (Ramco Systems)
05.2015 - 06.2016
Oracle Trainer
Times Technologies
01.2014 - 12.2014
Technical Lead
Infosys Ltd.
B.Tech - Information Technology
Anjalai Ammal Mahalingam Engineering College
HSC - undefined
Savitri Vidhya Sala Girls Higher Secondary School
SSLC - undefined
St. Isabel’s Girls Higher Secondary School