Experience Summary

• Over 8 years of Experience in data warehouse, OLAP and OLTP systems, Maintenance and Support which uses ORACLE 9i/10g/11g Databases, MySQL, SQL, PL/SQL, SQL Loader, Cognos10.
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star snowflake schemas in Cognos Framework Manager.
• Expertise in Tuning of Procedures, Packages, SQL.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors, Dynamic SQL, Oracle Analytical Functions, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Experience in document process and training team members by creating and maintaining technical documentation, deployment diagrams and checklists.
• Expert in Unit Testing, Integration testing and Performance Testing.
• Experience in Analysis, Design, Development, Customization and Implementation of Business Intelligence Projects.
• Extensive hands on experience in developing Business Intelligence applications usingCognos10.2andCognos 8 BI Tools.
• Working knowledge with Framework Manager, Transformer, Query Studio, Report Studio, Analysis Studio,Event Studio, Business Insight and Business Insight Advanced, Go DashboardofCognos 10 and Cognos 8.
• Proficient in RDBMS Concepts with good programming experience in SQL Server 2008and Oracle server, Teradata.
• Good Technical and analytical skills with clear understanding in design goals.
• Very good experience in handling production support projects.
• Strong Experience in Unit testing, User acceptance testing, version control, change management and on-site/off-shore coordination.
• Good knowledge in Dimensional modeling.
• Have good experience in working on Dimensionally Modeled Relational DMR Modeling.
• Strong team player, team leader and commitment towards learning with good communication and interpersonal skills.

SKILL

Professional Summary:

Confidential

Sr.Oracle Developer

Responsibilities:

• Interacting with the business users to understand the functionality and their requirements.
• Designed and Developed custom packages, procedures, Triggers using PL/SQL.
• Loaded data into Oracle using PL/SQL, Dynamic SQL UTL FILE, SQL Loader and extensive use of External Tables
• Designed the packages and procedures for getting the data from Source DB2 systems to ESA Enterprise Staging Area and from ESA to EDW Enterprise Data Warehouse
• Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.
• Performed unit test on the developed code to ensure that its bug free.
• Handled Production issues and manage the same in issue log.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries
• using SQL and wrote stored procedures using PL/SQL.
• Involved in the database design for better understanding the relations, associations and dependencies within the database.
• Designed Technical design document based on the business requirements.
• Worked on SQL Loader to perform bulk data loads into database tables from external data files.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Created Materialized Views for extracting the data from remote database.
• Preparation of wrapper scripts for all the database processes and data quality checks using Unix Shell scripting.
• Wrote complex SQL queries to extract data from various source tables of data warehouse.
• Created various Function Based Indexes to significantly improve performance.
• Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve the performance and UTL FILE to read and write operating system text files.
• Extensively used Bulk Collections to insert and update huge amount of data into target databases.
• Extensively used advanced features of PL/SQL like Ref Cursors, Collections Nested table and Varray and Dynamic SQL.
• Optimized SQL to improve query performance using SQL Navigator and PL/SQL Developer.
• Developed Scripts to perform Oracle Database Administration activities such as creation and maintenance of Table spaces, Users and Oracle Objects.
• Understanding the requirements and preparing the business requirement and functional specification document.
• Analyzing the reports requirement and designing the Dimensional model.
• Creating and publishing relational package using Framework manager.
• Created various kinds of reports like list, cross tab, charts in Report Studio and Dashboards using Business Insight.
• Created drill through reports, Active reports and Report pages.
• User training to create adhoc reports in Query studio.
• Scheduled reports from Cognos connection.
• Performance tuning of the reports Delivery of the reports to the users and providing support post production migration

Environment:Oracle 9i/10g/11g, SQL Plus, TOAD, PL/SQL Developer, SQL Developer, Erwin, Cognos 10.2 Report studio, Query studio, Framework Manager, Transformer.

Confidential

Sr.Oracle Developer

Responsibilities:

• Created complex queries using SQL and PL/SQL to summarize data which are used as views on which reports are based.
• Designed Entity-Relationship models using ERWIN and other design features.
• Interacted with Business Analyst and client Representatives and understood the requirements using the functional documents and the client specified documents.
• Used SQL Loader to load data into Oracle database.
• Developed control scripts for the data loads using the SQL loader, to move data from external files into Database.
• Communicate and discuss with client and support team in order to research and resolve a perceived issue or problem.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits rollbacks to maintain transactional consistency database integrity.
• Maintained and Updated existing applications of CognosReports based on regular basis.
• Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.
• Created database Triggers for data security and used SQL Loader for bulk data load.
• Created Cognos Reports with Master-Detail, Drill through and report styles.

Environment:Oracle 10g, SQL,PL/SQL,Cognos10.1., Unix, Autosys, Shell scripting

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created and maintained PL/SQL scripts and stored procedures.
• Coded many generic routines as functions , which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Created user defined Exceptions while handling exceptions.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Conducted training sessions for the end-users.
• Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
• Identified and implemented programming enhancements

Environment:Oracle 9i, SQL Plus, Windows 2000.