Pradeep Balan

• Executed ETL development with Talent 7.2/8.0, streamlining data integration processes.
• Configured ESB jobs for efficient message consumption from RabbitMQ to SAP HANA DB.
• Designed ETL processes optimising workflows for extraction, transformation, and loading.
• Transferred data from various sources including DYNAMODB ,Oracle OCI to SAP HANA DB.
• Implemented bulk loading procedures from SAP HANA to SYBASE via Talend.
• Developed Python scripts for message replay to RabbitMQ and system adaptability.
• Enhanced data security using advanced encryption techniques and strict access controls.
• Migrated existing Talend jobs to Databricks, improving scalability and efficiency.

• Developed innovative software solutions, enhancing system performance and user experience.
• Led migration of legacy systems to modern platforms, enhancing operational efficiency.
• Populated data warehouse using PL/SQL scripts, facilitating accurate reporting.
• Transferred historic data from legacy systems to Retail Analytics.
• Converted Oracle reports into BI Publisher formats, improving report accessibility and user engagement.
• Developed detailed packages and procedures for generating BI Publisher reports.
• Designed subject areas for comprehensive report generation.
• Administered version control procedures, safeguarding code integrity and preventing data loss.

• Analyze requirements and translate business needs into technical solutions
• Defect fixes in ETL in UAT using ODI
• Creating merchandising reports in Oracle BI Publisher Reports.
• Bursting of reports using BI Publisher reports
• Configuration for Bursting reports based on store number and delivering the same to the respective store
• Architected and Implemented Physical and Logical Data Models based on Functional and Technical Requirements.

software Designer

• Translate the logical data model to physical data model, and decide the optimal partitioning.
• Design the Fact / Dimension tables (Star Schema) for Data warehouse
• Design aggregate tables and Materialized views for Data Marts BI Reports
• indexing strategy for warehouse and mart tables

• Developed mapping for Data Warehouse population using Oracle BI tools to support data integration efforts.
• Benchmarking and tuning ETL processes with Oracle 10g, SQL Trace, TKPROF, and AWR.
• Generated dashboards and reports using OBIEE Answers.
• Created design documents and physical models for comprehensive data mapping.
• Maintained technical documentation to facilitate future project reference and enhance team collaboration.
• Resolved complex programming issues to ensure uninterrupted system functionality.
• Established user authentication protocols via external tables to enhance security.
• Engaged with clients to gather requirements, estimate tasks, and ensure project deadlines were met.