SUMMARY

• Around 7 years of experience as Oracle Software development consultant with expertise in working with database development projects.
• 1 year of experience in development, testing, implementation of ODI, OBIA and 3 years of experience in developing OBIEE Reports. (Migrated Excel reports to OBIEE).
• 3 years of experience in running data loads for Hyperion Load Process on a daily basis and supporting Hyperion Essbase w.r.t different databases and maintenance of it on a regular basis as per the changes.
• Used Informatica as ETL tool to load data to Hyperion database.
• Development of database design - tables, sequences, synonyms, index, packages, procedures, functions, triggers based on project modules requirements.
• Prepared technical documents and writing Unit Test Cases.
• Reviewed Business requirements, Technical specification and preparing Test Plans and Test Strategies.
• Effort Estimation & Prepare high level design doc of new client requirement.
• Developed back end code to generate reports as per client requirements.
• Worked to resolve the implementation performance issues which has helped improve the performance of reports.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Extensively worked on Database Conversion, Archiving, ETL and Data warehousing projects.
• Expert in writing SQL queries, developing PL/SQL stored procedures, functions and packages.
• Expert in developing reports, exports, imports and interfaces using Oracle PL/SQL.
• Expert in designing and deploying partitioned tables and indexes to improve data retrieval performance.
• Used DBMS MVIEW, DBMS JOBS, DBMS SCHEDULER, DBMS DDL, and UTL FILE Oracle Server supplied packages in PL/SQL blocks.
• Good knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Extensively used QUEST Tools (TOAD) and PLSQL Developer.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Excellent planning, analytical, written Communication and Interpersonal skills.
• Involved in Development, Testing, Implementation, Migration & Support projects in Oracle BI.
• Hands on Experience knowledge modules like RKM LKM, IKM, CKM, JKM.
• Good understanding of ODI studio components like Designer, Topology, Operator and Security Navigators.
• Experience in developing ODI interfaces/Mappings, packages, procedures, sequences and scenarios, Load Plans.
• Creating and customizing OBIEE reports and developing dashboards, promps, filters, variables.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

TECHNICAL SKILLS

DBMS: Oracle 12c, 11g, 10g, SQL Server

Database Tools: TOAD, PL/SQL developer, SQL developer

Languages: SQL, PL/SQL.

Reporting Tools: OBIEE11g

Operating Systems: Windows, Linux.

ETL Tools: ODI 11g, Informatica.

OBIA: BI Apps 11.1.1.9.1 , BI Apps 11.1.1.10.1

PROFESSIONAL EXPERIENCE

Senior Developer

Confidential

Responsibilities:

• Handled MDU Conversion Project and interacted with SQA team from offshore on R6 Conversion project.
• Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
• Worked on TDP and SDR tickets and interacted with DBA team until the issue is resolved.
• Worked on file validations and reported data issues to SQA team to resolve the data issues.
• Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that run Oracle PL/SQL.
• Worked on JIL files for deployment and running ETL jobs of all shell scripts in Autosys and interacting with Performance Testing team.
• Involved in coding, debugging and testing as well as performance tuning of SQL Queries.
• Worked on Database Links to Access data from remote Database.
• Worked Closely with DBA team and Performance Testing during Database and Performance issues
• Worked on Release implementation plan and post implementation validation for database and unix objects to check if all the objects are deployed in the SQA environment.

Technical Consultant

Confidential

Responsibilities:

• Analyze the Service Center and AskIT tickets raised by business and implement the best suitable solution.
• Convert mindjogger reports developed in perl into PL/SQL and schedule them using dbms scheduler.
• Employ UTL SMTP Oracle utility to send out emails with attachments.
• Improve performance of Advisory workbench reports by evaluating the best possible alternative sql suggestions from SQL Optimizer.
• Perform periodic Password Rotation activity on Oracle Applications 11i.
• Review daily Database Health Check reports to look for any impending issues, errors in the alert log and implement the necessary corrective action.
• Responsible for preparing technical design documents.
• Create and schedule jobs and chain jobs using DBMS SCHEDULER oracle supplied package.
• Writing complex reporting queries in Oracle SQL.
• Coding Oracle stored subprograms like Views,functions, procedures, packages, triggers.
• Coding PL/SQL subprograms to develop exports, imports, batches and reports.
• Employ DBMS MVIEW in order to create and manage materialized views, DBMS JOBS to create and manage oracle jobs, DBMS SCHEDULER to schedule jobs at various timings, DBMS DDL to work on database objects definitions and UTL FILE (convert data from database into flat files) Oracle Server supplied packages.
• Using SQL*Loader to move data from flat files into database and sql copy to move data from one database to another. Employ UTL FILE utilities to write data from database into flat files.
• Developing new code components for new implementations.
• Bug fix as part of maintenance releases.
• Involved in interaction with the End Users and implemented reviews of the application.
• Involved in PL/SQL coding, Designing and Deployment of Reports.
• Involved in the creation and testing of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes, and Collections.
• Developed Functions & Procedures for Extracting data from different tables using Joins and inserted them into a Table.
• Involved in coding, debugging and testing as well as performance tuning of SQL Queries.
• Running data loads for Hyperion Load Process on a daily basis and supporting Hyperion Essbase w.r.t different databases and maintenance of it on a regular basis as per the changes.
• Took Level0 backup of the data and updated sub-variables in essbase on monthly and quarterly basis.
• Used Informatica as ETL tool to load data to Hyperion database and experience in checking the error logs of all the workflows and running the workflows accordingly.
• Updated Calculation scripts,and modifying informatica workflows and formulas of members as per the requirement.
• Hands on Experience knowledge modules like RKM LKM, IKM, CKM, JKM.
• Good understanding of ODI studio components like Designer, Topology, Operator and Security Navigators.
• Good understanding of the architecture of ODI and running ODI in different environments.
• Created several reverse engineering models as per the requirement.
• Experience in developing ODI interfaces/Mappings, packages, procedures, sequences and scenarios, Load Plans.
• Strong Knowledge in debugging the ODI interfaces/Mappings.
• Developed several Interfaces/Mappings with transformation logics like, filters, joins, lookups,Oracle functions etc.
• Developed Interfaces/Mappings to union multiple tables of the same structure using data sets.
• Developed Customized knowledge modules as per requirements.
• Developed interfaces for incremental update and full load loading.
• Created and customized OBIEE reports,dashboard pages.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.