Right now I am available every day including weekends on prior schedules and priority and also ready to accept offers during US hours.
I always try to work within your budget irrespective of my profile billing rate. You can always get in touch with me on your required billing rate. We can work on it.
Experience Summary:
• 14 Years of IT experience in Design and Development as an Oracle (SQL & PL/SQL) Developer with over 2 years into SAP BODS Development and 1 Year in Cognos (L3 Support experience).
o PL/SQL –
Created database objects like tables, external tables, Global Temp tables, views, sequences, synonyms, indexes, database links and partitions using Oracle tools like Toad, PL/SQL Developer, and SQL Developer.
Enforced data integrity using integrity constraint and table level triggers.
Expert in writing/modifying PL/SQL package, function, stored procedure, triggers, and cursors & ref cursors.
Proficient in features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Dynamic SQL.
Experience in SQL and PL/SQL tuning
Good knowledge in Oracle utilities like Export/Import and data pump utilities like EXPDP/IMPDP.
Extensively used package like DBMS_PARALLEL_EXECUTE, DBMS_STATS, UTL_FILE, and DBMS_SCHEDULER.
Expertise in handling errors using Exceptions.
Implemented Oracle’s Parallel execution mechanism for procedures to reduce the ETL processing timelines.
Ensured code reusability, modularity.
o SAP BODS
Analysis on the source system to prepare the mapping document to sync with the target database.
Data Validation before designing the ETL jobs to meet the business requirement
Design of ETL process to ensure the sequential and parallel loading of the objects.
Develop new mappings for the ETL process.
Integrating with other dependent work/data flows.
Ensure the reusability of mappings and avoid duplicate coding.
o Cognos
Experience in Maintenance/Enhancement Projects.
Build the Framework for new reports
Developed the new reports to automate the manual tasks.
Upon receiving the incidents, performed the analysis and Bug fixing
Added report level security to limit the user access to the reports.
Performed core admin tasks like user creation, removal and modifying his roles & responsibilities.
No feedback given
5No feedback given
5