Expert : Amit Bose

Oracle PL/SQL, DBA, Unix, Oracle APEX

Senior Oracle database architect/ Oracle DBA/ Technical Manager - Over 20 years of diverse experience in Software Development Lifecycle (SDLC). Enterprise Systems Architecture, Database Administration, Design, Architecture, Performance Tuning, Development, and Enterprise Reporting in Financial, Telecommunications and Utilities industries. Comprehensive experience as Oracle DBA; Proficient in Oracle 7/8/8i/9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i/8i/8.x/7.x on Unix and Windows NT platform, Technical Manager handling large scale development using Oracle ADF, APEX, FORMS, Java and Java Script and Oracle OBIEE 12c. • Strong skills in Oracle server side programming which includes SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Web-services, Java Stored Procedures, very good knowledge in Oracle ADF 12c, Oracle APEX 5.0 and Oracle Developer Suite modules. • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer using Oracle OBIEE 11g and 12c. • Experienced in Oracle Golden Gate Replication – Active/Passive and Active/Active with transformation and filtering. • Experienced in Web Logic 12c – Creating domain, data sources, Connection Factories, JMS Module, JMS Foreign Server, JMS Bridge, Deploying EJB, MDB, Application EAR, Troubleshooting performance issues like GC Overhead. • Strong skills in Core Java, JSP and Java Script. • Experienced in Performance Tuning, Data Partitioning. • Experienced in logical data modeling including business rules with CASE tool - Erwin 4.x in multi-user environment with Erwin Data Modeler for Normalized as well as De-Normalized data structure, both forward and reverse engineering including Normalized and Dimensional Data Modeling. • Oracle DBA – Install Oracle 12c, create database, create schema, import data dump, apply oracle patch set, routine maintenance, RAC, RMAN, ASM, Data Guard and Oracle Golden Gate. • Application and Database tuning – using Explain Plan, TKPROF, Auto trace, STATSPACK and AWR • Data mapping, Gap analysis and Data Cleansing and Data Migration. • Created Materialized views for query Optimization, data replication and Data Warehouse environment • Fully conversant with Oracle security features and performed Backup & Recovery of mission critical databases and data files using command line syntax and RMAN • Database Performance tuning and monitoring using a wide range of technologies including ADDM, AWR, Stats pack, OEM Performance Manager, and custom scripts. • Developed Complex UNIX Shell scripts for database administration automation and batch processing. • Extraction, Transformation and Loading of data using SQL*Loader and Oracle Data Warehouse Features. • Fully conversant with SDLC and CMM Level5 Quality Procedures and Project Management Practices • Performer and a team player willing to work against aggressive project time schedule. • Corporate trainer on Oracle DBA, PL/SQL, Developer Suite, Unix • Functional and technical expertise in various financial FLEXCUBE modules like Core, CASA (customer accounts & savings accounts), NR ( Nostro Reconciliation), FT (funds transfer), PC( Payments & Collections), MM( Money Market ), FX (Foreign Exchange), Loans, Trade Finance, Retail teller, SMS (security management system), ELCM and Gateway interfaces. Skill Set • Databases : Oracle 12C, Oracle 11G, Oracle 10G, SQL Server • Languages : PL/SQL, Java, J2EE, XML, XSL, Shell Script, Java Script, AJAX, HTML, DHTML, T-SQL • Data Modeling Tools : ERWin, Rational Data Architect • Development Tools : Oracle ADF 12c, Oracle Apex 5.0, Oracle Developer suite 10g & 11g, FLEXCUBE RAD Tool • IDE Tools : Toad, PLSQL Developer, SQL Navigator, SQL Developer, JDeveloper, Eclipse • Application servers : Weblogic, Oracle App Server, Tomcat • Data warehouse Tools : Informatica, ETL Scripting • Version Control Tools : SVN, IBM ClearCase & ClearQuest, VSS, CVS • Operating Systems: Windows NT/2000/XP/7/8, UNIX, LINUX, SOLARIS. • Project management. Excellent problem-solving, organization and leadership skills. Quick

Tel: +91 9686376004 (Cell) Overview Senior Oracle database architect/ Oracle DBA/ Technical Manager - Over 20 years of diverse experience in Software Development Lifecycle (SDLC). Enterprise Systems Architecture, Database Administration, Design, Architecture, Performance Tuning, Development, and Enterprise Reporting in Financial, Telecommunications and Utilities industries. Comprehensive experience as Oracle DBA; Proficient in Oracle 7/8/8i/9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i/8i/8.x/7.x on Unix and Windows NT platform, Technical Manager handling large scale development using Oracle ADF, APEX, FORMS, Java and Java Script and Oracle OBIEE 12c. • Strong skills in Oracle server side programming which includes SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Web-services, Java Stored Procedures, very good knowledge in Oracle ADF 12c, Oracle APEX 5.0 and Oracle Developer Suite modules. • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer using Oracle OBIEE 11g and 12c. • Experienced in Oracle Golden Gate Replication – Active/Passive and Active/Active with transformation and filtering. • Experienced in Web Logic 12c – Creating domain, data sources, Connection Factories, JMS Module, JMS Foreign Server, JMS Bridge, Deploying EJB, MDB, Application EAR, Troubleshooting performance issues like GC Overhead. • Strong skills in Core Java, JSP and Java Script. • Experienced in Performance Tuning, Data Partitioning. • Experienced in logical data modeling including business rules with CASE tool - Erwin 4.x in multi-user environment with Erwin Data Modeler for Normalized as well as De-Normalized data structure, both forward and reverse engineering including Normalized and Dimensional Data Modeling. • Oracle DBA – Install Oracle 12c, create database, create schema, import data dump, apply oracle patch set, routine maintenance, RAC, RMAN, ASM, Data Guard and Oracle Golden Gate. • Application and Database tuning – using Explain Plan, TKPROF, Auto trace, STATSPACK and AWR • Data mapping, Gap analysis and Data Cleansing and Data Migration. • Created Materialized views for query Optimization, data replication and Data Warehouse environment • Fully conversant with Oracle security features and performed Backup & Recovery of mission critical databases and data files using command line syntax and RMAN • Database Performance tuning and monitoring using a wide range of technologies including ADDM, AWR, Stats pack, OEM Performance Manager, and custom scripts. • Developed Complex UNIX Shell scripts for database administration automation and batch processing. • Extraction, Transformation and Loading of data using SQL*Loader and Oracle Data Warehouse Features. • Fully conversant with SDLC and CMM Level5 Quality Procedures and Project Management Practices • Performer and a team player willing to work against aggressive project time schedule. • Corporate trainer on Oracle DBA, PL/SQL, Developer Suite, Unix • Functional and technical expertise in various financial FLEXCUBE modules like Core, CASA (customer accounts & savings accounts), NR ( Nostro Reconciliation), FT (funds transfer), PC( Payments & Collections), MM( Money Market ), FX (Foreign Exchange), Loans, Trade Finance, Retail teller, SMS (security management system), ELCM and Gateway interfaces. Skill Set • Databases : Oracle 12C, Oracle 11G, Oracle 10G, SQL Server • Languages : PL/SQL, Java, J2EE, XML, XSL, Shell Script, Java Script, AJAX, HTML, DHTML, T-SQL • Data Modeling Tools : ERWin, Rational Data Architect • Development Tools : Oracle ADF 12c, Oracle Apex 5.0, Oracle Developer suite 10g & 11g, FLEXCUBE RAD Tool • IDE Tools : Toad, PLSQL Developer, SQL Navigator, SQL Developer, JDeveloper, Eclipse • Application servers : Weblogic, Oracle App Server, Tomcat • Data warehouse Tools : Informatica, ETL Scripting • Version Control Tools : SVN, IBM ClearCase & ClearQuest, VSS, CVS • Operating Systems: Windows NT/2000/XP/7/8, UNIX, LINUX, SOLARIS. • Project management. Excellent problem-solving, organization and leadership skills. Quick learner. Oracle DBA Experience • Manage and support 30+ Oracle databases. • Create or clone the Oracle Instance and Databases on ASM. • Perform database cloning and re-location activities. • Managing table spaces, data files, redo logs, tables and its segments. • Backup databases using RMAN • Configure database for high availability (Data Guard and RAC implementation) • Maintaining data integrity also managing profiles, resources and password security. • Managing Users, Privileges and Roles • Manage RAC environment for Day to Day Database administrator, Performance Tuning. • Migrate over 3 TB data from Across the Platform ( From Solaris to AIX) • Strong trouble shooting, problem solving, analytical and design skills. • Expertise in Oracle 12c/11g/10g/9i/8i Data Guard and standby databases, Snapshot maintenance and creation • Expertise in Oracle Enterprise Manager (OEM), TOAD, ERwin • Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse. • Expertise in handling Very Large Database (VLDB) and OLTP environment Oracle ADF Experience • Four Years hands on experience in Oracle ADF 12c Architecture, JDeveloper 12c, Oracle ADF Development (ADF, ADF Faces, ADF Task Flows, Business Components, ADF Rich Faces, ADF Security and deployment) with Web Services and ADF Oracle Service Bus (OSB). Oracle APEX Experience • Design different types of screens(forms) & reports • Extensive use of java script, CSS, AJAX, application process and dynamic actions • Use APEX_ITEM to create dynamic forms • Google map integration with provision of storing marker persistently in the database and ability to add, delete, move marker with mouse click • Customize apex tree to enable drag & drop feature and right click menu option • Custom authentication and authorization Oracle OBIEE Experience • Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool. • Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports. • Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables. • Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience. • Expertise in building custom BIP Reports Certification Oracle Certified Professional (OCP) Education Bachelor of Engineering, Jadavpur University, Calcutta, India, 1990, 1st Class, Honors. Career Profile Hard ware SUN under Solaris (UNIX), Hewlett-Packard under HPUX, IBM under AIX (UNIX), PC platforms NT/2000/XP/7. Business Areas • Financial Services – Banking and Online Trading of Financial Products ( Stock, Mutual fund, Annuities ) • Telecom – Application to Person and Person to Person Messaging • Insurance - Non-Life - Auto. • Utility – Power Project Details Senior Technical Architect – Flexcube Implementation., Duration June2012 to continuing As an Oracle Database Architect responsibilities included • Technical Lead/ Major contributor in design, architecture, database development and performance tuning of Oracle FLEXCUBE Product. Performance optimization in a transaction-intensive real-time data feed in VLDB environments. Extensive data mining/data cleanup. Creation/maintenance of ETL scripts to support a variety of data sources. • Provide technical support and manage implementation of Oracle Flexcube Product. The role included customization, performance tuning and application optimization, environment set up for Flexcube 12.0.2 including configuring and deploying on Web Logic server, Database configuration. • Oracle DBA – Install Oracle 12c, Create database, create schema, import data dump, apply oracle patch set, routine maintenance. • Architect and Design Oracle Golden Gate Replication – Active/Passive, Active/Active with transformation and filtering for Verizon. • Architect a solution for message publisher as Oracle AQ and subscriber Web logic JMS queue with MDB monitoring the JMS Queue and finally configure JMS Bridge to forward the message to Web Sphere MQ for Verizon.. • Design and develop PL/SQL and Java Modules and java script for customization of the Flexcube Product as per client requirement. • Design & Develop FLEXCUBE screens using Oracle ADF 12c, RAD Tool and custom JS. • Develop and Implement the business logic in Servlets/Java and using PL/SQL. • Performance tuning of FLEXCUBE Implementation by optimizing the code and server side tuning. Analyzed AWR and tkproff reports to provide tuning recommendation and tune Database code (PL/SQL). • Configure Single-Sign-On in Flexcube with Oracle Access Manager, Web Gate, OID and OHS for Wells Fargo • Implement Fine Grained Access, Data Masking in FLEXCUBE using Oracle Virtual Private Database and Oracle Redaction for Bank Of America. • Design and architect log miner based replication from hub to spoke schema for Wells Fargo. • Prepared and implemented technical roadmap for fast data load and unload from/ to Oracle database from/ to ASCII file for Bank of America. • Design and implement Pl/SQL interface to resume/pause Flexcube quartz jobs for Well Fargo • Architect and develop multi-threading of CPG payment batch using partitioning for performance enhancement for Wells Fargo. • Participated in upgrade of Flexcube Product from version 6.2.1 to 12.0 including setting up of both environment, data export and import, data enrichment, LD-CL migration and LM-ELCM migration Projects Worked On: CCD Bank Canada, Wells Fargo USA, NCDST USA, Bank of America, US Oracle Database Architect – Mobile 365 Inc., Duration October’10 to June2012 Architect and design and develop the reporting infrastructure for custom reporting ,Architect, design and implement the data encryption and archiving of the operational database, Environment – Oracle 10.2 (10g)/ 9.2.0 (9iR2) on Sun Solaris, Oracle Portal, WebDB; PL/SQL Web Toolkit PL/SQL, UNIX Shell Scripting, Sql Server 2008 Oracle Database Architect/ Data Modeler – Ricoh Share Reporting, Ricoh IBM India, Duration Dec ’07 to Oct’10 Tasked with understanding the core requirements of the Data warehouse and Reporting Data mart from Siebel (Organization, Agreement, Entitlement, Service Asset, Service Request and Activity) and Oracle application 11.5 (Order Management, AR, AP, PO, GL, Contract) data sources Environment – Oracle 10.2 (10g)/ 9.2.0 (9iR2) on AIX, PL/SQL, Unix Shell Scripting, Data Stage, Rational Data Architect, Cognos. Oracle DBA – ABN AMRO, IBM India, UK Duration Jul ’06 –Dec’07 Oracle DBA - Managing and Administering over 30 Databases hosted on different flavors of UNIX O/S like AIX, Redhat Enterprise Linux, etc; Managing ASM/RDBMS Instances, Real Application Clusters, User, Object and Database Space Management; Managing Backup and Recovery with RMAN; Working on Database Patching and Upgrade, Database refresh, Cloning of Database, Database Decomposition and finally Troubleshooting different kind of Database issues. Environment - Oracle 9.2.0 (9iR2) on Sun Solaris (5.9), PL/SQL, Unix Shell Scripting, Informatica, Autosys, Erwin, Business Objects. Corporate Trainer ,IBM, May'06 to Jul ’06 Provide technical training to the new joinees at IBM on Oracle DBA. SQL, PL/SQL, Unix and Developer Suite. Total no of participants :40 The assignment also included preparation of training material, case study, hand-on exercise and evaluation of the trainees. Oracle DBA, AXA DIRECT Japan, TCS Kolkata, Oct’04 to April’06 Oracle DBA - Provided and implement the DR solution, Used Oracle Data guard tool for creating the standby database. Automated the process of oracle backup. Maintenance of production database and development database which includes table space management, user creation, privileges, roles etc., Tracing, troubleshooting with database performance and tuning issues. Export/Import of oracle databases. Tuning SQL queries. Maintaining archive data on appropriate storage devices. Corporate Trainer, DSP, Sep'04 to Oct’04 Provide technical training to the EDP team of DSP(Durgapur Steel Plant) at client location on Oracle DBA, PL/SQL and Developer Suite. Total no of participants :15 The assignment also included preparation of training material, case study, hand-on exercise and evaluation of the trainees. Oracle DBA, AIG Sun America.( Consultant ), California, U.S., TCS Kolkata ODC, June' 00 to September’ 04 Production and Development DBA - Chiefly responsible for effective management of multi terabyte of Database, Oracle High Availability (RAC and Data Guard),, Backup and Recovery (RMAN), Disaster Recovery, Performance Tuning, Capacity planning. Environment - Oracle 8.1.7 (8i)/ 9.2.0 (9iR2), SQL Server 2000, Oracle Reports 6i, PL/SQL, Java, SQL*Loader, Perl 5, ASP .NET 2003, .NET Framework 1.1, ASP 2.0, Sun Solaris 5.8, Windows NT/ 2K, IIS 4, HTML, DHTML, XML. Senior Developer , Utility Group, TCS, Calcutta, India , Apr'99 to June'00 Design, Development and implementation of Utility Product. Environment - Developer2000, PL/ SQL, Designer 2000, VSS, Configuration Management, Lotus Screen Scan Senior Developer, Life Scan Inc., California, U.S., August'98 to April'99 Design, Development and implementation of Y2K compliance. Environment - SQL*Forms 3.0, SQL Report Writer 1.1/2.0, SQL * Menu 5.0, PL/SQL, PRO*C, SQL* PLUS, Unix Shell Scripts, ORACLE 7.x RDBMS, SUN SOLARIS O/S Developer, MBT, Pune, India, May'98 to August'98 Design, development and maintenance of database applications including Oracle Forms and Reports Environment - PL/SQL, SQL*PLUS, PRO*C, SQL*LOADER, ETI Conversion Tool, ORACLE 7.3 RDBMS, HP UNIX Developer( Consultant ), British Telecom Plc., Fleet, U.K. June'97 to May' 98 Design, development and maintenance of database applications including Oracle Forms and Reports Environment - Developer 2000, PL/SQL, PRO*C, SQL*PLUS, UNIX Shell Scripts, SQL*LOADER, SCO Unix O/S, ORACLE 7.1 RDBMS Developer, MBT, Pune, India, September'96 to June'97 Design, development and maintenance of database applications.. Environment - Developer 2000, PL/SQL, PRO*C, SQL*PLUS, UNIX Shell Scripts, SQL*LOADER, SCO Unix O/S, ORACLE 7.1 RDBMS Project Executive, CESC Ltd., Calcutta, India, August'90 to September'96 Analyze and interact with vendor for Development of the new system., Acceptance Testing., Project Planning, Interaction with Consultant/ Contractor, Control of project Progress., Contract Management, Techno - Commercial Evaluation Of tenders, Placement of Orders. Environment - Developer 2000, PL/SQL, PRO*C, SQL*PLUS, UNIX Shell Scripts, SQL*LOADER, SCO Unix O/S, ORACLE 7.1 RDBMS.