Over 08 years’ extensive experience in delivering highly complex and large-scale IT projects.
I am a tech-savvy professional with solid history spearheading complex system migrations and executing robust Oracle applications / database administration. I am well versed in data conversion, data migration, report generation and developing interfaces within several modules in oracle applications. Proven expertise in oracle forms and reports, procedure based forms to meet the management’s requirements. I am proficient in performance tuning SQL & procedural SQL code. I am adept at leveraging outstanding management skills to direct cross-functional team operations, carry out effective task delegation, and prepare in-depth documentation to accentuate operational success. Instrumental in tuning using various types of Hints, Partitioning, Indexes, Explain plan. Articulate communicator, with strong interpersonal skills, and the ability to easily interface with clients to identify requirements and accurately assess needs.
My key skills include Oracle Database Development • Oracle Apex Development • SQL and PLSQL Development • Performance Tuning using Advanced PLSQL • Database Management • Data Integration, Mining, & Migration • IT Management • User Training & Support • Continues Process Improvement • Training & Development
My professional background and great industrial exposure coupled with an excellent track record makes me an ideal candidate for executive roles. As such I would welcome a discussion regarding opportunities with your organization that fit my background.
Directly Working with international client as an Oracle Database Developer
Expertly applied various technologies, including Oracle, Structured Query Language, Procedural Language, Oracle Application Express, Oracle Forms (11g/12g), and Oracle Reports (11g/12g).
Utilized Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds) and various types of hints, partitioning, indexes, and explain plan to ensure tuning of application.
Debugged Oracle Back-end PL/SQL development to write packages, stored procedures, functions and triggers.
Achieved bottom line results by applying Oracle built-in packages, cursor management, and exception handling.
Experienced in tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds)
Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain plan
Ability to handle multiple tasks concurrently, and perform multiple roles to meet the deadline.
Ability to translate business requirements into technical solution.
Experienced on different projects like POWERBI, OBIEE, and DISCOVERER.
I have used the SQL and PLSQL to load the data into one source from different data sources.
Render a keen eye for details to generate and maintain database objects such as tables, views and materialized views, indexes, constraints, sequences, synonyms and database links. Create complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic. Hold full accountability for executing data migration enforcement tasks through data mapping. Apply advanced PL/SQL (analytical functions, PL/SQL tables, record type, bulk collects and binds) to develop applications. Meet assigned deadline while supervising multiple tasks and translating business requirements into technical solution.
Key Accomplishments
Expertly applied various technologies, including Oracle, Structured Query Language, Procedural Language and Structured Query Language, Oracle Application Express, Oracle Forms (11g/12g), and Oracle Reports (11g/12g).
Utilized Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds) and various types of hints, partitioning, indexes, and explain plan to ensure tuning of application.
Debugged Oracle Back-end PL/SQL development to write packages, stored procedures, functions and triggers.
Achieved bottom line results by applying Oracle built-in packages, cursor management, and exception handling.
Planned, supervised, and finalized large data migration projects according to strict guidelines while complying with budget and time constraints.