Senior Database Lead & DWH Consultant-Oracle Technologies

Personal summary

★★★★ More than 15 years of experience in database programming and ETL solutions ➤ Database Programming Skills: ✔ Strong experience in writing SQL,PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle. ✔ Hands on experience in MySQL and T-SQL Programming. ✔ Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views. ✔ Knowledge of JSON and PostgreSQL support for JSON. ✔ Good working experience in WorkBench,Toad and SQL Developer. ➤ ETL Skills: ✔ Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures. ✔ Developed and delivered ETL scenarios in the context of Services Oriented Architecture SOA Using Data Warehousing DWH tools ODI 11g and ODI 12c. ✔ Extensive experience in developing the load plans, packages and job scheduling. ✔ Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle 11g/12c on platforms like UNIX, Linux and windows servers. ➤ Domain expertise's includes Utility Billing System,Healthcare and ERP. ➤ Developing application within a disciplined development methodology using SDLC to deliver high quality products and solutions which are within scope and on time. ➤ Work on Agile Development Methodologies. ➤ Worked on multi-platforms like Windows, UNIX, Linux and DOS. ➤ Highly experienced in IT industries includes System Studies, Estimation, Project Coordination (Client, Onsite-Offshore), Leadership, Lead Programmer Analyst,Functional and Technical specification writing, Peer reviews, Coding, Unit /Integration / User Acceptance Testing, Test Driven Development (TDD). ➤ Excellent Analytical Skill and Out of box thinking capabilities to solve complex business problems.

Skills

Oracle PL/SQL15 Oracle Database (RDBMS)15 mySQL10 PostgreSQL2 Python1