Summary:

• 7 Years of Oracle DBA experience in Database Administration, Installation, Upgrade Migration, RMAN Backup and Recovery, Performance Tuning, Advanced Replication, Distributed Database, Database Security, Development and Production support in Oracle in local and remote environments on Operating Systems viz. LINUX, Sun Solaris, HP-UX, IBM AIX and Windows 2000/NT Server in 24x7 basis.
• High availability OLTP, Data warehouse OLAP , DSS, and SAN environment. BMC tools including Patrol forOracle, Web DBA, and SQL Explorer. SQL Server including 2005
• Capacity Planning, Space Management and disaster recovery strategies.
• Installation and administration of Oracle Real application cluster RAC with shared storage ASM, network file system NFS .
• Good Knowledge of Oracle E-business suite OEB 11i, Oracle APEX.
• Hands on experience in Oracle Cluster ware. Experienced with Database Vault, Audit Vault, Data Masking, also Database security products.
• Installation of Oracle 10g Grid control to monitor various databases and servers.
• Oracle 10g FLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
• Enterprise Resource Planning ERP -Supply Chain Management SCM ,Customer Relationship Management, CRM , Front Office, Back Office, Collaborative Commerce
• Oracle utility OPatch application - apply patches on Oracle database servers.
• Proficient with Oracle Recovery manager 9i, 10g, 11g.
• Good knowledge of asset and change management software BMC remedy.
• Oracle 11g enhanced features such as Flashback Data Archive, RMAN Data Recovery Advisor, and 11g DATAPUMP.
• Oracle 11g Real Application testing solution such as Database Replay, SQL Performance Analyzer SPA .
• Proficient with Oracle Streams and Replication 10g/11g
• Oracle 10g AWR, ADDM, ASH in collecting and maintaining performance statistics for problem-detection and self-tuning purposes.
• Database upgrade 8i, 9i, 10g, and 11g using Database Upgrade Assistant DBUA and manual upgrade method.
• Performance tuning of database, instance, SGA, I/O, using Enterprise Manager OEM , TOAD.
• UNIX shell scripting, Window batch programming, Perl scripting, SSH, SCP.
• Configured and maintain physical standby database using Data Guard for High availability configuration.
• Tested and implemented different physical and logical backup, and recovery methods like point in time PITR , media recovery, full / partial backup, Export/Import and DATA PUMP.
• Backup and recovery using RMAN and user managed backup.
• Data Modeling tool Erwin, ER/Studio for forward and reverse engineering, and maintaining the database in sync with the data model.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power center.
• Experience with dimensional modelling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in Business Requirements analysis and design, prepared and technical design documents.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable components such as Mapplets, Reusable transformations and sessions etc.
• Involved in loading the data from Source Tables to ODS Operational Data Source Tables using Transformation and Cleansing Logic using Informatica.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router
• Developed mapplets and worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Implemented partitioning and bulk loads for loading large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Involved in performance tuning of mappings, transformations and workflow sessions to optimize session performance.
• Created Materialized views for summary tables for better query performance.
• Implemented weekly error tracking and correction process using Informatica.
• Developed Documentation for all the routines Mappings, Sessions and Workflows
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power Center 8.6/9.0.1, Oracle 10g, DB2 9.0, UNIX AIX , WINSQL, Windows 7, Business Objects XI 3.1, PL/SQL, Flat files, MS SQL Server 2008, MS-Access, Autosys, Subversion, C .net, Ultra Edit.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Design, Development and Documentation of the ETL Extract, Transformation Load strategy to integrate different interfaces with Exigen.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Based on the logic, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, XML Generator, XML source qualifier, input, output transformation in the mapping.
• Created different source definitions to extract data from XML, flat files and relational tables using Informatica PowerCenter.
• Used XML editor to create personalized views and validated them.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Oracle Stored Procedure to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used various Oracle Index techniques like B tree, bitmap index to improve the query performance and created scripts to update the table statistics for better explain plan.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality. Extensively used HP Quality Center for bug fixing.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the process.
• Created UNIX shell scripts and called as pre session and post session commands. Used WinSCP for FTP purpose for Windows.

Environment: Informatica PowerCenter 8.6.1, Power Exchange, Oracle 10g, PL/SQL, Mainframe DB2, SQL Developer , Toad, Cobol, Quest Central for DB2, ERWIN Data Modeling tool, EASparx, WinSCP, HP Quality Center, Windows 2000, Autosys, UNIX AIX 5.1

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Gathering the requirement changes from the functional team and incorporates them in Informatica.
• Designed the ETL processes using Informatica tool to load data from Oracle, flat files, Teradata into the target Oracle database.
• Followed Implemented Standards for BI DW at various levels of the SDLC.
• Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup connected and unconnected , Aggregator, Update Strategy, Filter, Router, SQL transformation etc.
• Used Autosys to create, schedule, monitor and send the messages in case of process failures.
• Designed and modified PL/SQL Stored Procedures to modify data flow.
• Tuning and performance improvement of the jobs in Informatica. Translated business requirements to Informatica Mappings. Involved in Unit testing of mappings.
• Delegating and Tracking the change requests in Informatica.
• Worked closely with the end users and Business Analysts to understand the business and develop the transformation logic to be used in Informatica.
• Created the transformation routines to transform and load the data. Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Worked on Dataflux tool which is used a data cleansing for address fields.

Environment: Informatica8.6.1/9.1, TOAD, Oracle, Teradata, Autosys, PL/SQL, Unix/Shell Scripting, Dataflux

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Responsible for requirement gatherings and make necessary changes to the test design documents
• Oracle UI testing and custom ETL processing and Oracle BI reports' testing. High data volume with complex and extensive reporting, Charged with design and development for projects, automations and refactoring.
• Analyzed and tuned SQL and PL/SQL for performance.
• After completion of reports worked on validating the data as a part of unit testing.
• Creating and Generating System test scripts for different test scenarios covering all aspects of project functionality.
• Performing various types of testing, such as Integration, Functional, Regression, UAT, Negative, Load, Memory testing.
• Verified business requirements and functional specifications.
• Developed and updated Test plans, Test Matrixes, Test Scenarios, Test Cases and prepared test data.
• Checked the data flow through the front and backend and extensively used SQL queries to extract the data from the database.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Customized the scripts according to the requirements by inserting conditional statements.
• Executed Queries in test database using SQL queries.
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries left outer Joins, sub queries etc.
• Involved in the weekly status Report update with the Manager.
• Involved in the Weekly Bug's Status Meetings along with QA team and Development team.
• Generate Test data for positive and negative test scenarios.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Service Ticket handing and production support with fixing of raised issues and enhancement in product functionality with customization.

Environment: Oracle 11g/10g/9i, SQL, Windows, PL/SQL, Oracle Forms/Reports 9i/11g, Oracle Applications R12

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Performed specification documentation for each SSIS process based on client's requirements.
• Developed various transformations, mappings and sessions in Informatica to load data from source to target database.
• Extensively used Transformations like Aggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformations
• Tested all the mappings developed and checked the data transformations.
• Used Quality Center to track the defects.
• Performed error checking and testing of SSIS procedures and programs in dataflow task.
• Constantly worked on performance tuning of mappings and sessions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Updated the SDS documents with the respective changes.

Environment: SSIS, SQL Server 2008 Oracle 10g, SQL, PL/SQL, Quality Center, IDQ, Windows 2003.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Responsible for providing requirements, functional knowledge and design documents to ETL team for development.
• Responsible for converting requirements into comprehensive detail design specifications Integration, databases, data flows, transformations, interfaces etc. for solutions.
• Responsible of creating project plan and working with customer on regular basis to show the progress at each stage.
• Responsible for all ETL deliverables in SDLC methodology such as integrated functional specification, source to target mapping sheet, design, coding, unit testing and deployments.
• Responsible for interacting with different teams involved to build MCC DDW.
• Have extensively used Teradata utilities Multiload, FASTLOAD, BTEQ and TPT to load the data into Teradata Data warehouse.
• Created UNIX shell scripts to run the Informatica workflows, Dynamic parameter files creation, indirect file creation, file watcher and email notification etc
• Responsible code reviews and data validations.
• Responsible for driving the team to meet the objective of the project by proactively taking decisions.
• Responsible for proactively identifying risks, assumptions, issues and providing solutions suggestions on time.
• Responsible for preparing migration plan and coordinating with respective teams.

Environment: Informatica Power Center 9.1, Teradata, Unix Shell Scripting, Sources SAP BW, Share Point List, MS SQL Server, Flat files Oracle , Teradata SQL Assistant , Putty, Autosys Soap UI