SUMMARY

• 10 years of programming experience as an Oracle PL/SQL Developer & Support Analyst in Analysis, Design, Data Modeling, and Development of client/server applications and Data warehouse environments using the Oracle Relational Database Management System(RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux.
• 10 years of Oracle PL/SQL expertise in all phases of Software Development Life Cycle (SDLC), which involves design, development, testing, implementation and supporting phases.
• Expertise in identifying and analyzing the business needs of the end users and build a project plan to translate the functional requirements into technical tasks that guide the execution of the project.
• Proficient in PL/SQL programming - Worked extensively on Stored Procedures, Functions, Packages, Cursors, Triggers, creation of Oracle Objects like Tables, Views, Materialized Views, Sequences, Synonyms, Indexes, Constraints, Database Links, and User Defined Data Types
• Expertise in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Varrays, Records, Types and Dynamic SQL for better performance
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning
• Experience with Performance tuning of SQL Queries & PL/SQL tuning and knowledge of using Oracle tuning tools AUTO TRACE, EXPLAIN PLAN & SQL TRACE
• Experience in developing Web GUI using Web Toolkit, PSP server pages
• Knowledge in Object Oriented programming.
• Proficient working experience in Oracle utilities such as SQL*Loader, Data Pump, Export/Import and UTL FILE.
• Expertise in Unix/Linux, having knowledge on Shell & Perl scripts
• Experience in creating SQL* loader scripts to load data from flat files into the database and also creating external tables to manage data which is stored at the OS level
• Experience inData warehouse concepts, Dimensional Modelling, ETL & trained on SAP BI/BW & BO.
• Extensively used DBA Utilities, Oracle Enterprise Manager, and Export/Import, Performance Monitoring, Physical/Logical Backups & Recover.
• Have working knowledge of Oracle, MS-SQL Server, DB2, TERADATA, SYBASE & NETEZZA
• Experience in HTML, XML, Java Script, VB Script.
• Very good knowledge of ITILV3 & Project Management Professional (PMP) concepts
• Extensively interacted & worked closely with client managers, technical & operational teams to resolve ongoing Production issues, Development & enhancement of new features.
• Exposure to various functional domains such as Treasury, Finance, Insurance, Banking, Manufacturing
• Experienced working in software lifecycle development using both waterfall and agile methodologies
• Excellent team player and ability to work collaboratively or independently as & when required
• Possess analytical, troubleshooting, organizational, communication, problem solving and leadership skills with ability to create and sustain high work tempo.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Sun Solaris, Windows

Languages: SQL, PL/SQL, Web Toolkit, JAVA, C, C++, Object Oriented Concepts

Databases: Oracle 11g/10g/9i, 8i, MS SQL server, TERADATA, DB2, SYBASE

Job /Ticketing Tools: JIRA, AUTOSYS, CONTROL-M, TIDAL, ITRS Active Console, CRONTAB, GIMS, FALCON, MAXIMO,BMC REMEDY

Web Servers: Apache Tomcat, Oracle WebLogic & IBM WebSphere

ETL/BI Tools: SAP BW/BI, Business Objects

Tools: /Utilities: Toad, SQL Navigator, DB Artisan, Rapid SQL, SQL * Loader, Export, Import, SQL *Plus, Oracle SQL developer, OEM, VSS, SVN

PROFESSIONAL EXPERIENCE

Technical Consultant

Confidential, San Diego, CA

Responsibilities:

• Involved in full cycle Design and implementation of the project and post implementation support.
• Also worked in monitoring the process, handling/fixing critical issues, coordinating with application users, various external upstream & downstream teams
• Analyzing, Developing, troubleshooting & providing solutions for all Production & Dev issues on a daily basis and handling the work requests from the users as well as business operations
• Developed the programs and scheduled the jobs to post the incoming Bank statements and Auto Sweeping of RAS Account to Master accounts and RAS interest calculation.
• Involved in creation of tables, views, Joins, correlated sub queries, nested queries, Sequences, Synonyms and other relevant objects for the business application development.
• Developed SQL queries & PL/SQL subprograms for Change Requests to accommodate the required changes
• Experience in Data Warehousing and Business Intelligence - Design and Implementation using sophisticated BI, ETL and metadata tools like OBIEE 11g
• Developed BI reports using OBIEE.
• Worked on Production support issues raised by client, working on the root cause investigation & providing timely resolution and timeframe to fix the defects
• Creation, tracking & maintenance of Incident/Problem/Change management tickets logged on JIRA and SLA Management, Ticket Monitoring and Status Reporting in start of day with Business Units
• Monitoring automated jobs, fixing the failures and feeds arrival from various source systems
• Optimization of batch runs by analyzing historical data and proposing a suitable solution to fix the issues
• Performed reviews on Technical Specification documents, code reviews, peer reviews and performance optimization of Team deliverables
• Prepared test plans/cases and Involved in Unit testing, Integration testing and User Acceptance testing.
• Cross functional/Technical trainings offered periodically to understand the application on new changes that are implemented
• Experienced in gathering project data, performance analysis and providing presentations to the client
• Documenting wiki page & SharePoint with the all possible information about the project, writing solutions and latest details about the project

Environment: Oracle 11g (SQL, PL/SQL), Web Toolkit, UNIX, SHELL Scripting, Windows Servers, TOAD, Rapid SQL, JIRA

Senior Programmer Analyst

Confidential, Los Angeles, CA

Responsibilities:

• Participated in analysis, design, coding, testing, implementation and documentation of the development and the change requests
• Developed various crystal reports for dunning, premium dues etc.
• Developed & enhanced PL/SQL Stored Procedures & Functions to upload the XML files policy data from upstream system
• Involved in redesign of the Application according to the new business requirements by creating the Partitioned tables and indexes for better performance of application.
• Responsible for resolving all production issues on a daily basis and handling the work requests from the users as well as business operations
• Analyzing & troubleshooting the production issues by documenting the RCA for these issues
• Interacting with cross functional teams to fix the top day issues & documenting solutions
• Worked on cursor datasets to produce reports for higher management
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases
• Project reviews & status meetings held to provide the work status on a weekly basis
• Incident Logging and Tracking incidents through Falcon & JIRA
• Documentation of fix logs for known issues to be uploaded in Knowledge Repository
• Conducted cross functional KT’s on critical areas of an application to various teams, business users such that they are knowledgeable on application & related issues

Environment: Oracle 10g (SQL, PL/SQL), DB2, UNIX, Mainframe, DB Artisan, Crontab, SVN, GIMS & JIRA

Senior Programmer Analyst

Confidential

Responsibilities:

• Extensively involved in requirements gathering with the onsite clients and prepared functional specifications and technical specifications and system integration test plans
• Involved in Development, database design, Unit testing, system integration testing and also supported by resolving the issues raised in User Acceptance Testing.
• Worked on Change Requests raised through JIRA and develop SQL queries & PL/SQL blocks
• Developed Pro*C programs for PAYMUL, MT940, MT100 payment file generation and scheduled them as jobs to transfer the Payment interface files to the gateway servers of the banks Confidential, HSBC and CITBANK.
• Developed the ETL code in PL/SQL Packages to extract the data from OLTP database to OLAP
• Performed troubleshooting, debugging ETL issues and providing permanent resolutions
• Created database instances for new clients, managing Tablespaces, users and monitoring ETL scripts
• Monitoring scheduled ETL jobs, OLAP Tablespaces and Oracle Sessions
• Performing logical & physical backups and handling DB upgrades
• Gathering Table/Schema level statistics for better performance of the system
• Performance tuning of SQL queries using EXPLAIN PLAN,SQL TRACE & AUTOTRACE
• Creating indexes and using hints to enhance SQL query performance while running user reports
• Interacting with the client to collect the requirements for new deployments & OLAP Database latest build upgrades
• Monitoring the Process, System logs Files, I/O Status and CPU Utilization on LINUX
• Replicating data loads & analyzing possible causes if any error occurs for the UAT clients before rolling to production. Monitoring all UAT jobs scheduled in the UAT server
• Involved in Disaster Recovery database setup operations testing activities
• Handling MEDISPAN & FDB data loading through SQL*LOADER which comes from SAP BI system as flat files in to their respective Database.

Environment: Oracle 10g (SQL, PL/SQL), LINUX, JAVA, TIDAL Scheduler, TOAD, SQL Navigator, Crontab, JIRA & VSS

Programmer Analyst

Confidential

Responsibilities:

• Participated in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts
• Also worked in monitoring the batch jobs at regular intervals and fixed file transfer issues.
• Developed Procedures and Packages for the new feeds to accommodate new business entities
• Interacted with clients in remote locations to verify customer requirements and coordinated with the junior team members
• Performed activities like Incident logging and tracking incidents as well as change requests (CR) through eProTrackPlus tool.
• Created Tables, Views, Constraints, Synonyms, Materialized Views, Triggers, Sequences, Collections
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms
• Involved in creation and updates of several SQL packages and Procedures
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Adhered to the coding standards and documentation requirements.
• Used Dynamic SQL using execute immediate, Bulk Load, VARRAYS and Object types
• Used SQL*Loader to perform data loading.
• Involved in taking regular database backups using Export/ Import utility
• Analyzing, tuning SQL queries using HINTS, INDEXES & EXPLAIN PLAN
• Generated reports by running the existing sub-programs.
• Worked on troubleshooting the production issues and provided solutions on time to meet the SLA.
• Responsible for resolving all raised user/system issues on a daily basis and handling the new work requests from the users
• Scheduling & monitoring Control-M jobs

Environment: Oracle 9i (SQL, PL/SQL), UNIX, JAVA, J2EE, Control-M, TOAD, GIMS, Remedy & VSS