SUMMARY

• 15+ years of experience in IT industry and having experience in OFSAAI Configuration/Installation, database administration, Pl/Sql coding, performance tuning, backup and recovery, migration, database security.
• 15 years of professional IT experience in all aspects of Software Development Life Cycle (SDLC).
• 5 years of experience in OFSAAI Installation / Development. 10 years of experience in database administration.
• Strong knowledge in OFSAA Data model and Data Modeling using Erwin data Modeler, compatible tools in OFSAAI.
• Strong knowledge of OFSAAI Infrastructure & OFSAAI solutions installation and troubleshooting.
• Extensive experience in OFSAA Batch Execution Engine (Run/Rule Framework).
• Expertise database performance Tuning and Capacity Planning.
• Implemented Virtual Private Database policy On Production/QA database to control database access
• Worked on partial & full cloning for OFSAA 8.0.1 and created & shared cloning document with Oracle for review.
• Strong exposure in translating high level business requirements to low level technical requirements for development team.
• Good expertise in configuring DQ rules, building T2T (Table to Table) transformations in OFSAA.
• Expertise in troubleshooting and resolving OFSAAI platform issues and configuration changes.
• Installs, configures and troubleshoots OFSAA installations. Participates in upgrades.
• Leads the migration of applications to production according to the SDLC model.
• Development of triggers, procedures, functions, packages in the area of development & data migration by maintaining data integrity with constraints and triggers.
• Expertise in Application Lifecycle Management concepts and worked in HP ALM tool.
• Analyzes and troubleshoots various Oracle performance issues (for both batch processing as well as end - user interaction) in the datamart.
• Partitioning of large tables for better performance and manageability.
• Exposure to ETL concepts and Data Architecture.
• Strong experience in Shell scripting with development of monitoring scripts.
• Experience working with Financial Industries. Worked with Confidential, Confidential, Confidential

TECHNICAL SKILLS

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting, Perl scripting

Database: Oracle 11g /10g/9i/8.x, MS Access, SQL Server, My SQL

Operating System: UNIX, Solaris, AIX, HP-Unix, Linux, Windows 2005/2003/XP/2000/NT

Tools: SQL*PLUS, SQL Developer, TOAD, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp Data pump, VNC Server, ERWIN, Service now, ALM

Other Technologies: ODBC, Crystal Reports, MS Office, Erwin 4.0/4.2/7.6, Relational Database Design., AUTOSYS, Antrhill

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Tools: /Utilities: RMAN, ASM, Grid Control, EXP, IMP, CA7

PROFESSIONAL EXPERIENCE

Confidential

OFSAA Developer

Responsibilities:

• Designed system flow for Events/ Instruments in DQ Layer and Adjustment Layer with AUTOSYS jobs
• Configured and tested DQ Rules to meet Data Governance guidelines
• Configured F2T, T2T, DT for transformation .
• Worked on metadata migration activities between environments.
• Troubleshoot batch processing and batch scheduling issues.
• Tuned complex queries with EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM Reports.

Confidential

OFSAA Developer/Support

Responsibilities:

• Provides enterprise-level technology recommendations and solutions in support of customer requirements
• Responsible for promoting RWA/Credit/Operational Risk code set in dev/test/QA and Production environments.
• Implemented Virtual Private Database policy On Production/QA database to control database access
• Customizing Data model Design and implementation as per customer requirements by using Erwin using OFSAA framework.
• Installed the OFSAAI versions OFSAA 7.X & OFSAAI 8.X
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues.
• Developed DEFI screen, T2Ts, DT, DQ, Dimensions & Run Rules .
• Developed Shell scripts to schedule database reports.
• Communicating with oracle support for any issues through Service Requests and track it till closure.
• Planned, documented, and executed change control procedures to accomplish project goals in the production environment.
• Administrator for OFSAA platform such as new user and group creation there group mapping, new batch creation, configuring new Information domain, and segment.

Environment: Solaris. Exadata,, Oracle 10g/11g, SQL*Plus, PL/SQL, SQL*Loader,, Toad and SQL Developer, VNC server, OEM 11g,, RMAN, Data Guard, Export/Import (Expdp/Impdp), Harvest, Erwin, Endevor, CA7 . ALM

Confidential

Oracle Database Administrator

Responsibilities:

• Primary Database administrator for several retail application customers.
• Worked as team member to provide 24/7 on call production database support.
• Installation, Configuration and Administration of Oracle 9i and Oracle 10g
• Implementation of High Availability solutions with Oracle 10g Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management

Environment: Red Hat Linux 5.6, Oracle 10g, 11g, SQL*Plus, PL/SQL, SQL*Loader,, Toad and SQL Developer, VNC server, RMAN and Data Guard.

Confidential

Oracle Database Administrator

Responsibilities:

• Migration of all Oracle 9i databases/clients to 10g.
• Applying Quarterly patches and Version change patch bundles.
• Implemented backup and recovery procedures using RMAN & Import/Export.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM reports.
• Installation and supporting RAC.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Building and Configuring RMAN with Netback up, Legato Backup & HP Data Protector.
• Successfully providing 24x7support for production, development, and test database.
• As part of a pilot project to transfer the database administrative activity to overseas, I have documented and coordinated with the people overseas
• Created users, roles and granted privileges according to the business requirements.
• Provided 24x7support for Production, Development, and test database.
• Setting up new environments (Development, Production).

Environment: Oracle 9i/10g/11g, SQL Server, OEM, RMAN, DBCA, TOAD, Erwin, UNIX, Sun Solaris, Red Hat Linux, AIX, Windows XP, RMAN Backup .