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.
• Performing high performance data extraction, transformation, loading ETL using SQL Loader, OWB Oracle warehouse Builder , IBM DataStage
• SQL, PL/SQL, Query Optimization using optimizer hints, Explain plan, SQL trace, Auto trace, TKPROF, SQL Analyzer.
• Partitioning and sub-partitioning Range, Hash, List, Composite of tables in Data Warehouse, OLTP environment.
• Oracle Advanced Queuing
• Replication of data using snapshot, M-view, Oracle Replication Manager.
• Creating and managing database object like tables, views, sequences, synonym, index, DB link and Materialize view.
• Proficient with Oracle GoldenGate Hands on experience at setting up CRS, TAF, VIP's and other latest Oracle Databases technologies setups like ASM and OCFS.
• Managing security through grants, roles, privileges, and profile.
• Advanced security using Database trigger, Auditing, Tablespace Encryption, TDE Transparent Data Encryption .
• Oracle supplied utility DBMS package, v views, DBA views, DBA HIST tables.
• Writing SQL, PL/SQL queries, Stored Procedure, package, Function, Trigger to implement business logic.
• Tools like Oracle Enterprise Manager OEM , TOAD for database performance monitoring, tuning of SQL / memory and maintaining backups.
• Monitoring, Tuning and Backup/Recovery using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Supporting IBM DB2 mainframe, MySQL database.
• Programming and debugging skills in PL/SQL, SQL, T-SQL.
• Delivering database design phase of Software Development Life Cycle SDLC to higher level management.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Created technical specification documents like system design and detail design documents for the development of Informatica Extraction, Transformation and Loading ETL mappings to load data into various tables.
• Designed and developed ETL process using Informatica tool to load data from wide range of sources such as Sql Server 2005, AS400 DB2 , Flat files and Oracle etc.
• Responsible for migrating the folders, mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Based on the Business logic, Developed various mappings mapplets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Developed PL/SQL Stored Procedures, Views and Triggers to implement complex business logics to extract, cleanse the data, transform and load the data in to the Oracle database.
• Used Partitions in Sessions to improve the performance of the database load time.
• Registration and Extraction Oracle CDC tables using Power exchange navigator.
• Imported Power exchange Register tables to Implement CDC on Informatica.
• Created sessions and used pre and post session properties to execute scripts and to handle errors.
• Running Informatica MDM Batch Group jobs and doing analysis on Rejects records.
• Created UNIX scripts to Schedule Informatica Workflows through PMCMD command.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Used Email task, Control task, Link and command tasks in Informatica Workflows.
• Created Informatica Mappings and Workflows to Run Informatica MDM stage, Base Objects and Match Merge Jobs.

Environment:Informatica9.5.1/9.1 PowerCenter, Designer, Workflow Manager, Repository Manager, Monitor , Power Exchange, Oracle11g, AS400 DB2 , Flat files, PL/SQL, SQL Loader, TOAD, SQL Developer, Power exchange, UNIX Sun Solaris, Informatica MDM, informatica Scheduler

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Discuss with the Business Analyst to understand the feasibility of the requirements.
• Prepare the Technical Design document with all the details including the Data flow, upstream system details.
• Preparing FSD Feed Specification Documents .
• Architecture and development with high volume transaction systems.
• Coordinated with off shore team for delivering the best solution to the client
• Used ETL to load data from different sources like Oracle, Sybase, Flat files and Swift files into the staging table and load the data into the Target database.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Wrote PL/SQL stored procedures, functions. Extensive hands on experience in PL/SQL.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Extensively used Router, Lookup, Aggregator, Expression, Sequence Generator, Update Strategy Transformations, Filter and Joiner
• Created workflows and worklets using Informatica workflow manager and used mapping/session parameters and variables.
• Developed re-usable components in Informatica, Oracle and UNIX.
• Detected bottlenecks of target, source, mapping and session
• Done performance tuning at mapping and session levels.
• Developed UNIX Shell scripts for validating and zipping the flat files, running Informatica workflows.
• Scheduling the jobs using Autosys jobs.
• Migration of code from Development to UAT environment
• Prepare the documentation necessary to onboard a new Reconciliation into Production and get approval from all the stakeholders by setting up meetings and following them up with required additional information.
• Production release activities and post production support of issues and enhancements.

Environment: Informatica 9.5.1 on UNIX, Sybase, Oracle, Autosys, flat files, swift

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Perform requirement analysis and gap analysis
• Prepare Technical Specifications document and implement changes
• Design data entry and process flow screens
• Creation of back end triggers for faster and integral data
• Writing Custom Packages to implement various functional areas
• Loading Data from legacy system via SQL loader.
• Schedule jobs via oracle jobs using DBMS JOB.
• Use of various DBMS packages to reuse code and automate scripts
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Extensive use of Oracle 9i features
• Design and customized business reports as per client requirements
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Extensive use of PL/SQL Collections and Records
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Use of Sequences to automate number generation
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Customization of the support screens
• Use of Bit map and Function based indexes to improve performance of queries

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Oracle D2K Forms and Reports, Windows NT, VCS

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Setup Oracle 9i instances to support chemistry data cartridges technology like the reaction cartridge and molecule cartridge that constituted the core of company's business.
• Designed and implemented hybrid replication between master production server running Oracle 9i and snapshot/master sites running Oracle 8i in a heterogeneous configuration.
• Enabled Veritas Quick I/O on database filesystems for improving throughput and response times.
• Recommended, designed and implemented Oracle RMAN solution for backing up enterprise databases, from the traditional OS based backup procedures in place.
• Automated several procedures to create and rebuild extensible indexes, collect extended CBO statistics, and export/import industry standard SDFiles RDFiles.
• Performed software builds on different platforms for supporting new releases of application software.
• Installed Linux software and setup Apache web servers that provided the launch platform for QA team and developers.

Environment: Oracle 9i 8i, Solaris 2.8, Sun Fire 4800 Server, Windows 2000 Server

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Intrinsic Cleansing Basic Data Cleansing, Removal of Duplicate Items in Master Data, New Items Appending, Inactive Item Exclusions, Vendor Name Standardization .
• Data Enrichment Item Details Enrichment, Modular Item Descriptions, Item Attributes, Vendor Information Update Vendor Parent/Child Hierarchy through PL/SQL stored Procedures, functions, packages, and triggers.
• Generation of Price Parity Reports for the Hospitals and writing stored Procedures, functions for the same according to the Client requirement.

• Worked on intermediate and oracle text, calling external Procedures.
• Creation of Database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Creating users, roles, profiles, assigning roles and profiles to users. Creating table spaces, Data files, Log files and control files.
• Used direct path loading via SQL Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, table spaces, parallelized SQL statement execution where appropriate tables.
• Create queries and other SQL scripts for test execution and execute them against SQL Server databases
• Involved in ETL process and evaluated different strategies and approaches for optimal performance of the process. Automated ETL loads, Back-up, Recovery
• Involved in development, enhancement and maintenance of PL/SQL interfaces.
• Have knowledge in supply chain management.
• Provided complete operations services for Supply chain application management, custom development, and business process outsourcing for clients.
• Performed SQL and Procedures tuning to maximize performance
• Prepared test data, test cases. Developed and executed test cases using SQL queries.
• Expertise in deriving test requirements from UML analysis such as use cases.
• Have performance testing experience and be able to devise strategies for test automation.
• Designed and created appropriate Indexes on tables and materialized views.
• Involved and interacted with clients for requirements gathering, tracking requirement changes and building functional test scenarios.

Environment: Oracle 9i, SQL Plus, Golden, HTML, Windows XP, Benthic Software, SQL Query Analyzer, SQL Loader, Microsoft Excel, J2EE, Java, JavaScript, Manual test process.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Created technical specification documents like system design and detail design documents for the development of Informatica Extraction, Transformation and Loading ETL mappings to load data into various tables.
• Designed and developed ETL process using Informatica tool to load data from wide range of sources such as Flat Files and Oracle Database.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Based on the Business logic, Developed various mappings applets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalize, Aggregator, Joiner, SQL transformations, XML Transformation in the mapping.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Extract files and manually transferred to Informatica server using FTP scripts developed using Python.
• Used PowerCenter jobs to read Mainframe files using a source plug-in called Power Exchange and write them to Oracle Staging Database.
• Parsed records by Power Exchange using data maps that are created using COBOL layouts based on segment names.
• Used Power Center and UNIX scripts to determine the number of thread and the sequence. We call it as program director listing of batches and jobs .
• Created the Program Directory is the listing the informatica jobs along with parameters such as folder name, source file name etc.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Used Partitions in Sessions to improve the performance of the database load time.
• Tested the existing mappings and redesigned the mappings to improve the performance and the efficiency of the design logic.
• Created sessions and used pre and post session properties to execute scripts and to handle errors.

Environment:Informatica9.1/8.6 PowerCenter, Designer, Workflow Manager, Repository Manager, Monitor , Power Exchange, Oracle11g, MainfrmaeFiles Coalfields , Flat files, PL/SQL, SQL Loader, TOAD, SQL Developer, UNIX Sun Solaris, ERWIN Data Modeling tool.