| Roles and Responsibilities | Proven track record in Oracle PL/SQL Lead Developer/Scrum Master, Reporting and Dashboarding, Design, Development, Testing, and implementation of Business Applications using Relational database Management Systems (RDBMS)- Oracle Certified associate for Oracle 8i/9i/10g/11g/12c Databases with experience and skills in data collection, analysis, and management.
- SnowPro Advanced Data Engineer/Analyst Certification with skills to apply comprehensive data engineering principles using Snowflake.
- Experience in design, analysis, development, and implementation of various application environments using BI Tools.
- Works well under pressure and consistently meets data management and application reporting deadlines and targets while delivering high-quality work.
- Excellent technical and Analytical skills with a clear understanding of product design goals using Tables, Functions, Indexes, Analytical Functions, Materialized Views, and Table Partitioning.
- Good understanding of database architecture, data warehousing, data modeling, and ETL to develop complex database objects like Stored Procedures, Functions, Packages, and Triggers.
- Strong hands-on experience implementing dashboarding, data visualizations, and analytics using Tableau Desktop and Server.
- Produce attractive visuals/dashboards to convey the story inside the data and worked on Test plans, Test Strategies, Debugging, Object testing, and Functional Testing.
- Extensive knowledge of manual code formatting, Performance testing, Integration Testing, and User Acceptance Testing (UAT).
- Developed, enhanced, and implemented standard UNIX Shell scripts, and Windows batch/FTP scripts for database monitoring, exports, and transfers.
- Created shell scripts for invoking SQL scripts and scheduled them using cronjob and worked on transforming complex datasets to integrate with end reports and dashboards.
- Expertise in Dynamic SQL, Collections, and Exception Handling. Experience in SQL Performance tuning.
- Worked with customers and product data experts to prioritize and validate requirements.
- Maintained and implemented physical data model for DDWA report metadata.
- Created JSON NOSQL schema logical models based on legacy CRD applications.
- Architected, developed, and maintained zero downtime, non-DMS configuration.
|