Experienced in data analysis, data modeling, development, testing and documentation of Projects.
Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment
Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.
Experience with DBAactivities like creating users, granting and revoking privileges on database objects and taking backups.
Experience in Installing Software's , Pro 'C,C shell, Perl Scripting, Korn Shell, SDLC and Configuring Databases.
Experience in UNIX Shell Scripting ,KSH scripting, Linux with Business Objects.
Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
Bachelor in Electronics and Communications Engineering - India.
Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges.
Maintained stored definitions, transformation rules and targets definitions using Informatica.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,
Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
Oracle PL/SQL Developer: The project involved maintaining information and ensuring efficient data retrieval as required for core decision making. Work involved writing Stored Procedures, Triggers and monitoring performance. The system will send the data in the form of files. The data from the files will be extracted and transformed using PL/SQL procedures. The Oracle database will act as target database.
Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
Manned for the efficient processing of incoming and outgoing EDI messages including customer and supplier connections.
Analyzed and fixed the data discrepancies between various systems and identified bad data
caused due the data migration from various legacy systems.
Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER
Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
Analyzed the business requirements and created technical specifications for enhancements in GPC.
Made enhancements to the file loading process in the GPC having worked on Packages, Procedures, Functions, Views, Materialized views, Synonyms, Indexes, Cursors, Triggers, DB links, Dynamic SQL, Collections and using utilities such as MERGE, External tables and UTL_FILE.
Monitoring and administered the EDI system/application.
Made changes to the scheduler packages which run through DBMS_JOBS in GPC.
Interacted with Business analyst and Project head on daily basis being an AGILE methodology project.
Co-ordinated with the Java team for frontend changes in line for the LMS application.
Was involved in handling the PL/SQL changes of backend jobs and ETL process of LMS application.
Created objects like Tables, Materialized views, Procedures, Packages, Synonyms.
Performance tuning using hints, indexes and explain plan.
Extensively used TOAD for all the development work.
Was part of analysis of the migration of GPC system from Oracle 10g to 11g.
Wrote SQL and UNIX scripts to move code base to Git version control.
Co-ordinated with the OBIEE team to cater the reporting requirements
Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, Toad 10.0, ETL, Git.
HSBC Bank, INDIAApr 2007 to Mar 2008
PL/SQL Developer Responsibilities:
Designed the tables according the requirements
Upload flat files to database using ETL tools like Informatica and SQL Loader.
Developed procedures to check validity of data according the business rules and fix them.
Write Script for data updating
Daily Report Generation of Telephone Migration Project Status
Production Support and Quality Control
Oracle objects creation scripts (DDL) for database development to Test and Production environments
Oracle PL/SQL design and tuning of stored procedures
ETL (Extraction Transformation Load) of data from Oracle tables to flat files and from flat files to Oracle tables
Prepared test environment for QA team to test the developed application from end-end