Dilli Babu Sekar
Pittsburgh
Summary
- Over 18 years of programming experience as an Oracle PL/SQL Developer, specializing in the analysis, design, and implementation of business applications using Oracle Relational Database Management System (RDBMS). Involved in all phases of the Software Development Life Cycle (SDLC), including analysis, design, development, testing, implementation, and maintenance, with a focus on timely delivery against tight deadlines.
- Expertise in client-server application development using Oracle database, PL/SQL, SQLPLUS, TOAD, and SQLLOADER. Utilized table functions, indexes, table partitioning, collections, analytical functions, materialized views, query rewriting, and transportable tablespaces effectively.
- Strong experience in data warehouse concepts and ETL processes. Knowledgeable in logical and physical data modeling using normalization techniques. Created tables, views, constraints, and various types of indexes (B-tree, bitmap, and function-based).
- Developed complex database objects, including stored procedures, functions, packages, and triggers using SQL and PL/SQL. Created materialized views for data replication in distributed environments.
- Experienced with Oracle-supplied packages, dynamic SQL, records, and PL/SQL tables. Partitioned large tables using range partitioning techniques. Familiar with Oracle-supplied packages such as DBMS_SQL, DBMS_JOB, and UTL_FILE. Worked extensively with ref cursors, external tables, and collections. Expertise in dynamic SQL, collections, and exception handling.
- Experienced in SQL performance tuning using cost-based optimization (CBO). Knowledgeable about key Oracle performance features, including the query optimizer, execution plans, and indexes. Conducted performance tuning for Oracle RDBMS using explain plans and hints. Created shell scripts to invoke SQL scripts and scheduled them using crontab.
- Used Databricks to process and analyze historical data. Proficient with tools such as Automic/UC4 scheduler, Harvest, SQL Developer, TOAD, PL/SQL Developer, Tortoise-SVN, TFS, and HP Quality Centre (QC).
- Excellent communication, interpersonal, and analytical skills, with a strong ability to work effectively in a team.
- Results-driven management professional with proven ability to lead teams to success. Strong focus on team collaboration, operational efficiency, and achieving measurable outcomes. Adept at strategic planning, process improvement, and fostering culture of accountability and excellence. Known for adaptability and consistently meeting changing organizational needs.
- Experienced with team leadership, strategic planning, and operational management. Utilizes effective communication and organizational skills to drive project success. Track record of fostering productive work environments and achieving set goals.
- Knowledgeable [Desired Position] with solid history of managing teams and driving operational success. Skilled in implementing strategic initiatives that enhance productivity and efficiency. Demonstrated ability in problem-solving and decision-making.
Overview
18
18
years of professional experience
Work History
Manager, Master Data Management
Giant Eagle
07.2024 - Current
- Giant Eagle Advantage Card is an electronic loyalty card discount system that allows customers to earn and redeem perks for maximum savings
- In late 2021, Giant Eagle introduced myPerks and myPerks Pro
- The perks chargeback application tracks earnings, redemptions, and expirations
- Collaborate with stakeholders from Finance, Accounting, and Operations to gather and analyze requirements related to loyalty chargeback rules, policies, and business logic
- Identify and document all source systems that supply data to the chargeback platform
- Define and implement business rules for loyalty perks, cost allocation, rate structures, and chargeback formulas
- Map out the end-to-end Automic process flow (UC4), from TLOG data ingestion through chargeback generation and approval
- Design robust data models to support the management of POS transactions, usage tracking, cost allocations, and financial adjustments
- Define the system architecture for seamless integration with Oracle Financials, enabling accurate journal postings
- Implement chargeback calculation logic and support various tiered customer data structures
- Develop scalable data pipelines using PL/SQL to ingest and transform usage data from multiple internal and external systems
- Integrate the chargeback application with financial systems to support general ledger postings and automated invoice generation
- Conduct comprehensive system integration testing (SIT) and user acceptance testing (UAT) to ensure end-to-end functionality
- Validate financial outputs for accuracy and ensure alignment with audit and compliance standards
- Develop dynamic dashboards and reporting tools to present chargeback summaries
- Enable detailed drill-down reports segmented by Earn vs
- Redeem Stores, vendor-funded promotions, pharmacy promotions, and internally funded promotions
- Continuously monitor the system for job failures, calculation discrepancies, and data inconsistencies to ensure data integrity
- Manage and implement change requests related to new chargeback rules, updated pricing models, and additional service offerings
- Assign, prioritize, and track tasks related to chargeback application maintenance and enhancements
- Ensure the team understands deliverables, deadlines, and expectations while adhering to best practices, compliance standards, and internal procedures
- Create PL/SQL stored procedures, functions, packages, and SSIS jobs to transfer data from the staging area to the data mart
- Apply dimensional and relational concepts, including Star Schema Modeling, Snowflake Schema Modeling and Fact and Dimension tables
- Ingest data using PL/SQL and SQL
- Loader, and call UNIX scripts to download and manipulate files
- Use Azure Databricks SQL to process and analyze historical data
- Implement Slowly Changing Dimensions - Type I & II in dimension tables as needed
- Handle production support tickets during business and off hours
- Environment: Oracle PL/SQL, SSIS, shell scripting, Toad, SQL Developer, SVN, Automic/UC4 scheduler, Sales force, Astea, iTop, Exadata, Windows7 and Oracle 11g Database
Senior Software Engineer
Giant Eagle
11.2015 - 07.2024
- Working in Enterprise Data warehouse platform to provide wide spectrum of Business Intelligence tasks ranging from predictive analysis to near real-time strategic and tactical decision support throughout the organization
- Worked toward the continued development and improvement of running Data Warehouse on Oracle Exadata platform
- Coordinated with the BI reporting team to provide them with the necessary stored procedures and packages and the essential insight into the data
- Created PL/SQL stored procedures, functions, packages and SSIS jobs for moving the data from staging area to data mart
- Involved in data loading using PL/SQL and SQL
- Loader calling UNIX scripts to download and manipulate files
- Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE and SSIS package
- Used Dimensional & Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling and Fact & Dimension tables
- Utilized Databricks SQL to process and explore historical data
- Experience in process improvement, normalization/de-normalization, data extraction, data cleansing, and data manipulation
- Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements
- Executed data migration in coordination with business and technical service team
- Managed development and support efforts for the Data Integration
- Involved in internal QA and code review activities
- Created design, understanding and deployment documents for the deliverables
- Handle production support tickets during business and off hours
- Environment: Oracle PL/SQL, SSIS, shell scripting, Toad, SQL Developer, SVN, Automic/UC4 scheduler, Sales force, Astea, iTop, Exadata, Windows7 and Oracle 11g Database
PL/SQL Developer
Tata Consultancy Services
03.2014 - 11.2015
- Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
- Created PL/SQL stored procedures, functions, and packages to transfer data from the staging area to the data mart
- Loaded data using PL/SQL and SQL
- Loader, invoking UNIX scripts to download and manipulate files
- Developed PL/SQL scripts to extract data from the operational database into flat text files using the UTL_FILE package
- Created, executed, and documented test plans for unit and system integration testing
- Managed development and support for data integration
- Participated in internal QA and code review activities
- Handled production support tickets during business hours and after hours
- Environment: Oracle PL/SQL, shell scripting, Toad, SQL Developer, SVN, Automic scheduler, Sales force, Exadata, Windows7 and Oracle 11g Database
ODI Developer, Tech Lead and Production support executive
The Nielsen Company. Inc.
06.2011 - 12.2013
- OGRDS is a strategic program currently in development, aimed at unifying various subsystems across countries into a single application with a consistent platform and technology
- Nielsen's Products & Brands business focuses on standardizing the storage of item details sold through retailers, ensuring that the data is uniform and accessible for their clients, such as Coca Cola and P&G
- The database will hold item information that will be utilized by downstream systems, which are not part of OGRDS, to provide necessary insights to clients
- Item data is created, stored, and maintained based on information sourced from retailers, clients, and manufacturers
- Estimate and prepare the project design
- Understand business functionality, design solutions, and document them
- Clarify design concerns with the Business Analyst
- Develop or modify PL/SQL program units, including packages, procedures, and functions, to meet business requirements
- Schedule PL/SQL programs in the QUARTZ scheduler to automate execution
- Develop or modify ODI ETL mapping programs, including Knowledge Modules, interfaces, and packages
- Use the ODI Database Warehousing tool to create Massive Data Load (MDL) and Bulk Publication components
- MDL loads data from the legacy system to OGRDS, while Bulk Publication loads data from OGRDS to downstream systems
- Develop shell scripts to invoke ODI package scenarios and schedule them in the QUARTZ scheduler
- Create normalized logical and physical database models
- Interact with clients for requirements and queries
- Perform quality reviews and verify coding standards
- Validate code movements in testing environments and confirm readiness for implementation
- Optimize SQL queries and tune performance using Offloading and Smart Scan options available in Exadata
- Handle production support tickets
- Environment: Oracle PL/SQL, ODI, shell scripting, SQL Developer, ER-Studio OEM, SVN, QUARTZ scheduler, HP Service Desk, Exadata, Windows7 and Oracle 11g Database
PL/SQL Developer
Apple INC
04.2010 - 05.2011
- ECost is a cost information system for projecting and tacking of parts, component, sub-assembly and product cost
- Involved in requirement gathering and analysis, Design, Developing/Modifying PL/SQL and Unit testing
- Involved in implementation and primary production support
- Scheduling the developed PL/SQL programs in Autosys scheduler for automatic PL/SQL programs executions
- Involved in Maintenance & Enhancements Activities
- Interaction with clients for requirements and queries
- Handling SQL performance related support tickets
- Environment: AIX, Mac OS X 10.6 Snow Leopard and Oracle 11g Database Oracle PL/SQL , SQL Developer, SVN, Radar, Espresso and Autosys scheduler
Developer
Dangote Cement
02.2009 - 04.2010
- Matrix – In the Inventory ready for use and service materials are Maintained and Catalogued in Matrix Software Tool
- It serves Centralized Item Master data for the Entire organization consisting of multiple Manufacture units
- By standard interface, Matrix Item master data are sent to Netsuite ERP system
- Involved in requirement gathering and analysis, Design, Developing/Modifying Oracle Forms & Reports / PL/SQL program and Unit testing
- Involved in Maintenance & Enhancements Activities
- Interacting with Clients for Business Rules
- Provided post production support
- Environment: Windows server 2003 , Windows XP and Oracle 10g Database Oracle PL/SQL , SQL Developer, Oracle Forms and Report 10g
Developer
Tamilnadu Petroproducts Ltd (TPL)
03.2008 - 02.2009
- IAS application determines how much inventory should an organization hold and when should place an inventory orders
- It also provides necessary information to keep inventory level as efficient as possible, thereby maintaining adequate safety stock
- It helps to identifies criticality for equipment’s and spares using Bill of Materials (BOM) available
- Min, Max, Re-order, Non-Moving levels, overstock and under stock items in inventory are also identified in Inventory analysis system
- Involved in requirement gathering and analysis, Design, Self-coding and Unit testing
- Involved in development, implementation and primary production support
- Involved in Maintenance & Enhancements Activities
- Interaction with clients for requirements and queries
- Environment: Windows server 2003 , Windows XP and Oracle 10g Database, Oracle PL/SQL , SQL Developer, Oracle Forms and Report 10g
Developer
Southern Auto Castings Pvt. Ltd
03.2007 - 03.2008
- Activity Based Costing (ABC) is a method for developing cost estimates, ABCOS systems calculate the costs of individual activities and assign costs to cost objects such as products and services on the basis of the activities undertaken to produce each product or services
- Its improves the business efficiency by determining the true cost of a product or service
- Involved in requirement gathering and analysis, Design, Self-coding and Unit testing
- Involved in development, implementation and primary production support
- Involved in Maintenance & Enhancements Activities
- Interaction with clients for requirements and queries
- Environment: Windows server 2003 , Windows XP and Oracle 10g Database, Oracle PL/SQL , SQL Developer, Oracle Forms and Report 10g
Education
Bachelor of Engineering - Computer Science Engineering
Aalim Muhammed Salegh College of Engineering
Chennai06-2006
Skills
- Languages : Oracle SQL, PL/SQL and Unix Shell script
- Technologies : Oracle SQL, PL/SQL, Oracle Data Integrator, Azure Data factory and Databricks
- Warehousing Tool : Oracle Data Integrator (ODI) and Sql Server Integrator Services (SSIS)
- Software Products : Oracle Forms, Oracle Reports, Oracle 11g, Oracle 10g
- Databases : Oracle 10G, 11G and 12C
- Operating Systems : Windows and Macintosh
- Database Servers : Exadata, AIX and Windows Server
- Data Modeling Tools : ER Studio V801
- Utilities/Tools : Automic/UC4 scheduler, Astea Incident Management, iTOP, Harvest, SQL Developer, TOAD, PL/Sql Developer, Tortoise-SVN, TFS and HP Quality (QC), SQL Tools, Oracle enterprise manager (OEM) Jira, Tempo, Lucidchart
Timeline
Manager, Master Data Management
Giant Eagle
07.2024 - Current
Senior Software Engineer
Giant Eagle
11.2015 - 07.2024
PL/SQL Developer
Tata Consultancy Services
03.2014 - 11.2015
ODI Developer, Tech Lead and Production support executive
The Nielsen Company. Inc.
06.2011 - 12.2013
PL/SQL Developer
Apple INC
04.2010 - 05.2011
Developer
Dangote Cement
02.2009 - 04.2010
Developer
Tamilnadu Petroproducts Ltd (TPL)
03.2008 - 02.2009
Developer
Southern Auto Castings Pvt. Ltd
03.2007 - 03.2008
Bachelor of Engineering - Computer Science Engineering
Aalim Muhammed Salegh College of Engineering
Similar Profiles
Lucas DaughertyLucas Daugherty
Cashier at Giant EagleCashier at Giant Eagle
Derek StempienDerek Stempien
Curbside Lead at Giant EagleCurbside Lead at Giant Eagle
Tonya DillardTonya Dillard
Senior Customer Service Advocate at Giant Eagle InSenior Customer Service Advocate at Giant Eagle In