Shridhar Bichchal

Total 19+ years IT experience having roles Data Architect , Data Modeler, Tech Lead with :
Oracle RDBMS
- Developed advance and complex Database Objects like PL/SQL Packages, Procedures, Functions , Triggers & using collections, ref cursors and written Complex SQL Queries using Analytical functions.
- Expertise in SQL Performance advance tuning by using CBO Method and analyzing Explain Plan Result, gathering stats.
- Comprehensive experience and knowledge of key Oracle Performance related features such as Query Optimizer Hints, Execution Plans and Physical / Virtual Indexes.
- Experience in Oracle supplied packages like dbms_xplan, dbms_lob, dbms_xmldom, dbms_xmlparser, dbms_xmlschema , util_file
- Implemented Range Partitions on Tables and Indexes, Oracle parallel execution for DML, DDL.
- ETL Techniques developed by using SQL Loader and Oracle PL/SQL Packages.
- Defined Complex Workflow Jobs of data extraction, data cleansing, data Manipulation in Control M Tool.
- Oracle Database Creation includes User, Roles , Privileges , Space Management by creating/altering Tablespaces and data files.
- Oracle Database Backup by using Export and Restoring using Import.

Data Modeling
- Good experience in Data Modeling for Data Warehouse/Data Mart development, Data Analysis for OLTP and OLAP BI Applications.
- Expert knowledge of Data Modeling ER designs for OLTP and Dimension Modeling techniques (Star/Snowflake Schema) and SCD Types 1,2,3 for OLAP (data warehousing) using CA ER Win Tool.
- Extensive experience on logical and physical Data Modeling using normalizing/de-normalizing Techniques, forward and reverse engineering.