Candidates About

 

 Ranjith Kudumula

SUMMARY:

·         Senior Oracle Developer with a strong technical background in Oracle (10g, 11g & 12c), Sybase, PLSQL, Data Warehousing (Informatica, ODI), Oracle Fusion Middleware and reporting (Crystal, BI Publisher, OBIEE, Tableau) technologies.

·         11 Years of IT experience in Core Banking, HealthCare & Equity Capital Market Domain. The role involves Business Analysis, implementation, design & development of applications.

·         Worked as Senior Oracle Developer in Oracle Financial Services and contributed to implementing Oracle Core Banking (Flexcube) for banks across the world viz., Lloyds Bank (USA), Swed Bank(USA), Silicon Valley Bank (USA), PNC Bank (USA), First Global Bank (Jamaica) and FHL Bank (USA).

·         Proficient in Oracle 10g, 11g and 12c Database Administration 

·         Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, SQL Trace, profiler, TK PROF, AWR, ADDM report and Collect Statistics in Teradata.

·         Proficient in Enterprise Manager, RMAN, Backup and Recovery, Database Migration, Upgrade and Patch Application, Performance Tuning & Data Guard Administration 

·         Responsible for preparing the Gap Analysis, Bank account reconciliations & Managing Business Requirements for Oracle Flexcube implementation at various banks.

·         Conversant with software development life cycle (SDLC) methodologies (Waterfall & Agile).

·         Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships(ER). Designed Logical and Physical data models for new developments using Erwin and SQL developer

·         Extensive Experience in database design, creation and debugging of stored procedures and triggers, Cursors, indexes, PL/SQL Blocks, queries, views, timed as implemented using Oracle 10,11 & 12c.

·         Have experience in complex query techniques by using Sub-queries, Joins, collections, Bulk Bind/Collect, Native Dynamic SQL, and Partitioned Tables etc.

·         Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views. 

·         Experience in optimization and performance tuning of SQL queries using hints, EXPLAIN PLAN. 

·         Strong experience in Logical Database Modeling and Database design (Start Schema). 

·         Experienced in integration of various data sources (PL/SQL, Oracle, Teradata & XML) into data staging area.

·         Followed all the Quality Related Activities and Involved in supporting various QA teams.

·         Strong experience with Forms 10g and Reports 9i. 

·         Understanding of Oracle security, synonyms, permissions and grants.

·         Strong Performance tuning and optimization experience with SQL and stored procedures (PL/SQL).  

·         Experience in Business Process and Data Flow Modeling, Work Flow & Use Case Analysis, Activity Diagrams.

·         Experience in data manipulation into and out from Oracle tables, including import to, export from diverse external structures, creation and support of interfaces with both Oracle and non-Oracle databases.

·         Functional & Technical expertise in various Core Banking(Flexcube) modules like CASA (Current & Savings accounts), SMS(securitymanagement), FX (ForeignExchange), FT (FundsTransfer), PC (Payment&Collections), InternetBanking, Loans&Deposits, Lending, IC (Interest&Charges), ELCM (Limits), LC (LettersofCredit).

·         Worked as Onsite coordinator for Implementation of Oracle Core Banking (Flexcube) at various Banks.

·         Good understanding of health care domain and standards like HIPAA. Experience in Out Patient, In Patient, Pharmacy, Blood bank, Purchase modules. Experience in integrating applications with diagnostics machines and third party applications.

·         Expertise in WebLogic (11g/12c) and websphere Server Installations, Infrastructure setup & Configurations.

·         Knowledge of Database Architecture for OLAP and OLTP Applications, Database designing, Data Migration, Data Warehousing Concepts with emphasis on ETL.

·         Experience in Oracle Business Intelligence Enterprise Edition 12c/11g, Administration and performance tuning of OBIEE 12c/11g.

·         Have experience in creating Informatica mappings, sessions and work flows.

·         Expertise with all ODI tools (Topology, Security Manager, Designer, and Operator). 

·         Developed new interfaces of E-LT in Oracle Data Integrator (ODI).

 

TECHNICAL SKILLS:

Languages: SQL, Oracle PL/SQL, VB6, Java

Application Servers: Web Logic, IBM Web Sphere

Databases: Oracle (10g,11g & 12c), Sybase, Teradata, My SQL, MS Access     

Tools: SQL*Plus, PLSQL Developer, WinSCP, TOAD, Putty, TKPROF, Eclipse, SQL Trace, Oracle JDeveloper, Oracle Flexcube RAD Tool, JIRA, SQL Developer, Rapid SQL, Autosys.

Scripting Languages: Java script, VB Script, Shell script

Version Control Tool: Clear case, Visual Source Safe, SVN.
Operating Systems: Unix, Redhat Linux, Solaris, Windows, AIX.

ETL tools: Informatica power center, Oracle data integrator.

Reporting Tools: Crystal reports, Business objects 11X, OBIEE and Oracle BI Publisher, Tableau.

Applications: Oracle Flexcube, ACBS, Actimize, KYC.

 

 

PROFESSIONAL EXPERIENCE:

 

Lloyds Bank, New York, USA                                                                                                                             March 2016 – Present

Senior Oracle Developer

·         Development & Implementation of Oracle FLEXCUBE 12.1.x

·         Onsite coordinator & Technical Lead for the application Development team.

·         Conducted Business Requirements Gathering & Gap analysis sessions (SDLC) in the form of questionnaires and business scenarios with the end users.

·         Analyzed and documented the business requirements, meeting minutes, responses to questionnaires and got the approval of the documents from the client in the form of sign off.

·         Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.

·         WebLogic 12c server configuration & Web Services deployment.

·         Expertise in the creation of databases, tablespaces, tables, indexes & database objects.  

·         Responsible for Database Backup and recovery/Restoration, Scheduling Jobs. 

·         Created Logins, Users and Roles in the context of SQL Server security. 

·         Developed brand new PL/SQL code to archive, restore, purge data from source to target using database links w.r.t stand-alone and master/detail tables as well.

·         Created PL/SQL programs for BATCH processing.

·         Experience in end to end knowledge of the project, starts with Unix process and do business logic and again calls shell script in NOHUP mode, which in turn calls PLSQL program to complete the business requirements etc. 

·         Involved in migration from various Oracle systems to SQL Server data warehouse. 

·         Oracle database performance monitoring and maintenance,

·         Perform bulk load into the database using SQL Loader.

·         Perform standard and fine grain database auditing. 

·         Regular Monitoring Alert Log Files and trace files on Day to Day Basis. 

·         Extensively used the advanced features of PL/SQL like Varrays, Records, Nested Tables, Bulk collect and Dynamic SQL for high performance of stored procedures. 

·         Responsible for optimizing SQL queries and tuning the long running queries as a part of performance improvisation. 

·         Tuning performance of the database using tools like STATSPACK, EXPLAIN PLAN, TKPROF, SQL TRACE, AWR and ADDM reports. 

·         Built and managed ODI repositories. Created models and projects in ODI designer.

·         Used Smart export and import for finding dependencies to perform export/ import of ODI objects. 

·         Used Informatica as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.

·         Created Informatica ETL mappings by using the transformations such as Source qualifier, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner etc.

·         Worked on Informatica Workflow manager to create tasks for the mappings.

·         Create mapping to load data from Flexcube application to Actimize application to comply with AML.

·         Deployed various WAR, JAR, EAR and J2EE applications on managed servers and in clustered environment using Console or auto deployment scripts in stage and production.

·         Developed various use cases, workflow, screen mock-ups, and conversion requirements

·         Unix shell scripting for Batch Jobs. 

·         Develop/Customize OBIEE RPD Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.

·         Customize/Configure OBIEE RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.

·         Worked on Financial Analytics, Subject Areas, Account Receivables, Accounts Payables and GL Subject Areas and corresponding dashboards as per user requirements

·         Customized Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards as per client requirements.

·         Implemented OBIEE object level security for dashboards through client specific Application Roles/WEBGROUPS.

 

Environment/Technologies: JDeveloper 10.x, AE (AutoSys Edition), Oracle WebLogic, PLSQL, TOAD, JavaScript, SQL Server, EJB2.0, JDBC, Web Services, Oracle 12c, Oracle BI publisher, OBIEE, ODI, Informatica, XML, WSDL, XSD.

 

Swed Bank – New York, USA                                                                                                                    September 2015 – March 2016

Senior Oracle Developer

·         Implementation & Customization of Oracle FLEXCUBE12.1

·         Responsible for installing Oracle Database, setup Instance Creation, Database Space Management.

·         Installed patches and upgrades for various bugs.

·         Implemented traditional Hot and Cold Backups & Recovery.  

·         Configured and administered JDBC Connection pools and JMS Connection Factories and implemented other services like JNDI.

·         Developing Oracle PL/SQL procedures, functions, and packages. Worked on advanced features such as bulk collect, hints subqueries, Joins, collections etc. Experience in Joins, Views, indexes etc.

·         Database installation and instance creation. 

·         Analyzing the Tables and Indexes on performance base regularly.

·         Monitoring Table spaces and Data files utilization. 

·         Managing Undo Table spaces, Redo Logs, Control files and Archive logs. 

·         Implemented multiplexing control files and redo log files.

·         Configuring various RMAN parameters as per the requirement. 

·         Configured the WebLogic 10.3.6 Application server.

·         Creation of RCU schemas with RCU utility.

·         Worked on data migration using ODI. 

·         Experience in performance tuning, application monitoring, and support of production applications.

·         Performing Unit Testing. As part of this, preparing UTP (Unit Test Plan) documents. Preparing PCR document in case of DB objects change. 

·         Used Oracle provided packages DBMS_OUTPUT, DBMS_JOBS, DBMS_SCHEDULER, DBMS_SQL and UTL_FILE in different requirements. 

·         Optimized daily database jobs running by generating statistics, creating indexes, SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, TKPROF.

·         Handled exception Handled exception in PL/SQL using Pragma Exception_init, Raise_Application_Error and error trapping functions. 

·         Analyze and fix Production fallouts when the same comes under the scope of development activities. 

·         Created Oracle Multiple Oracle Forms 10g and Reports 10g and deployed. 

·         Designed staging and Error handling tables keeping in view the overall ETL strategy.

·         Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Remove Duplicates, Copy, Modify, Filter & Change Data Capture.

·         Money market, Foreign exchange, Generic Interface, Core, Fixed asset module configuration in Flexcube.

·         Involved in requirement analysis gathering, preparation of functional specification documents.

·         Process management includes Preparation of MPP (Microsoft Project Plan), PMP (Project Management Plan) and estimation using OUM (Oracle unified methodology).

·         Followed all the QA (Quality and Process) related Activities.

·         Preparing Use Cases and Assisting QA team for User Acceptance testing (UAT).

·         Assisting front end developers with development and maintenance.

·         Responsible for oracle job scheduling, integration testing & support to ETL processes.

·         Oracle Flexcube Webservices integration with an external system to handoff the Customer Account details.

Environment/Technologies: JDeveloper 10.x, AE (AutoSys Edition), RAD tool, WebLogic, PLSQL, TOAD, Javascript, Teradata, XML spy, Linux, Putty, EJB2.0, MDB, Oracle 12c, XML, WSDL, XSLT, Perl, XSD.

 

First Global Bank – Kingston, Jamaica & Bangalore, India                                                           January 2012 – August 2015

Senior Oracle Developer

·         Analysis of reports requirement, Implementation, Development & Migration to FLEXCUBE.

·         Performed the Data Conversion from existing legacy banking product to Oracle Flexcube during product implementation at the bank.

·         Installed, configured and managed Oracle 11g, 12c, Progress OpenEdge 11.3 databases. 

·         Impact analysis and development of new requirements.

·         Responsible for troubleshooting ORA-messages tapped by the databases in the alert logs. 

·         Crystal report designing and managing environment and assisting client in identifying FLEXCUBE tables and data.

·         Created OBIEE reports, updated repository and Unit Testing.

·         Created various environment setups for implementation of FLEXCUBE and reports.

·         Created SQL queries and stored procedures. Have done tuning using explain plan and TKProf.

·         Designed, developed and implemented Oracle PL/SQL applications.

·         Created UNIX Shell Scripts for invoking SQL scripts and logging.

·         Developed PL/SQL packages, procedures, triggers, functions to implement business logic using Oracle tools like PL/SQL Developer and SQL* plus.

·         Developed PL/SQL packages to archive data from one database to other and for purging data.

·         Used Dynamic SQL and Collections in PL/SQL scripts.

·         Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

·         Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

·         Involved in PWT analysis sessions at the client site for the Flexcube interfaces, Web Services, Switch (ATM-POS), ISO8583, Gateway architecture, EMS, SWIFT & Generic Interfaces.

 

Environment/Technologies: Oracle WebLogic, PLSQL developer, OBIEE, Crystal reports, XML spy, Putty, WinScp, Toad, RAD tool, Oracle 12c, Webservices, JMS, XML, WSDL, XSLT & XSD

 

Silicon Valley Bank – Bangalore, India                                                                                                      July 2011 – January 2012

Senior Oracle Developer

·         Analysis of requirements and identifying/providing the best possible approach to fit the requirement in FLEXCUBE.

·         Preparation of Functional specifications, program specification and Design documents.

·         Created Database design and converting them into database objects.

·         Code development, Review and Unit Testing.

·         Created multiple environments for development and testing.

·         Performed SQL query and stored procedure tuning using explain plan, TKProf and dbms_profiler.

·         Involved in Database Design, Analysis, Performance Tuning and Monitoring.

·         Design and Developed data validation, load processing using PL/SQL, Stored Procedures, Functions and Triggers using Oracle 10g.

·         Created database objects Tables, Views, Indexes, Synonyms and sequences.

·         Involved in Code Standardization and Documentation.

·         Involved in Logical and Physical Database design and Star Schema design

·         Assisting front end developers with development and maintenance.

·         Participated in unit testing, system testing and fixed defects in PL/SQL packages and Procedures.

·         Coordinated between management, users and technical teams for Requirement Gathering.

·         Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

·         Involved in developing and testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source systems (flat files and databases) feeds using ODI and PL/SQL.

·         Involved in database designing based on Star Schema.

Environment/Technologies: JDeveloper 10.x, RAD tool, Oracle WebLogic 10.x, PLSQL developer, Putty, WinScp, Oracle Database 11g

    

Fidelity Investments – Bangalore, India                                                                                               Jun 2010 – May 2011

Oracle Developer

·         Collected User Requirements by participating in meetings and studying existing System. 

·         Analysis of functional requirements and specifications.

·         Created database objects like Tables, Views, Sequences, Synonyms, Material Views, stored Procedures, Function, and Packages, Cursor, Ref Cursor and Triggers.

·         Involved in analysis, design, coding and Testing.

·         Involved in modifying various existing packages, procedures, functions and triggers as per the new business needs.

·         Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

·         Used Explain Plan and TKProf for query optimization.

·         Created Database design and converting them into database objects.

·         Wrote test cases and performed Unit testing using UT/PLSQL.

·         Involved in writing Technical Specification Documentation. 

·         Creating Informatica/Autosys loaders to load the data from OLTP to Warehouse database.

·         Creating jobs required to load the data from one database/table to another with some specific calculations and conditions

Environment/Technologies: PLSQL, Putty, WinScp, Oracle Database 10g, Autosys, Informatica.

 

 

Krishna Institute of Medical Sciences – Hyderabad, India                                                                                 November 2006 – June 2010

Software Developer

·         Collected User Requirements by participating in meetings and studying existing System.

·         Application coding in VB for desktop based application.

·         Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation to partitioning of the database.

·         Granted roles and privileges to the application users to access the database objects.

·         Involved in partitioning the tables, indexes and management of the schema objects.

·         Involved in writing Highly Optimized SQL, and extensively used BULK BINDING techniques.

·         Involved in writing complex queries to generate ad-hoc reports as per user request.

·         Involved in developing and testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source systems (flat files and databases) feeds using OWB and PL/SQL.

·         Developed staging jobs where in using data from different sources (both from database and flat files) to cleansed, summarized and aggregate and transform data in to data warehouse.

·         Designed the high-level Entities and then complete Dimensional Data Model based on Star Schema.

·         Developed mappings using filter, splitter, de-duplicator, lookup, sequence, constant operators.

·         Responsible for creating process flow to execute mappings with the dependencies.

·         Responsible for writing scripts to control the execution of process flows.

·         Responsible for writing unit and integration test cases.

·         Created end-to-end process flows for the ETL.

·         Created DB triggers, procedures for automating the application flow & to enforce the business rules.

·         Involved in SQL tuning using Stats packs, tkprof, explain plan.

·         Provided the data purging functionality for purging the archived data.

Environment/Technologies: Oracle Database 10g, PLSQL, Putty, WinSCP, VB6.

 

EDUCATION/CERTIFICATIONS:

·         Bachelor of Engineering

·         Oracle Certified Associate (OCA)