SUMMARY

• Over 10+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Worked on domains Supply Chain Management, Investment Banking, Manufacturing and Healthcare.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, PLSQL Developer and SQL*LOADER.
• Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions. Adept at working on multiple projects simultaneously.
• Programming Experience in SAP HANA Database, SAP Data Services (BODS) and SAP HANA Studio tools.
• Working with an Agile, Sprints, Scrum methodologies to ensure delivery of high quality work with every monthly iteration.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center 9.5.0.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Have experience in creation of Workflows, Transformations, Projects, Jobs and Datastores in SAP HANA BODS tool.
• Expertise in working with Trading Applications Goose Exotics, Imagine, Geneos, GooseFlow, Wpro, Reuters, Bloomberg, Xavier Online (XOL).
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Worked on Global Markets and Equity Trading Applications on Confidential Trading floor in Wall Street.
• Have Experience in creating mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables, Collections and Exception handling.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan, HINTS and Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SAP HANA and MS Access.

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, C

Operating Systems: UNIX(Sun Solaris, LINUX), Cygwin, Windows NT/98/95/2000 & Windows XP

Tools: & Utilities: SAP HANA Studio, ECLIPSE, SAP Data Services (BODS), TOAD, GECS, SQL*PLUS, Control - M, SQL Navigator, WebLogic, Eagle Star, Imagine, GENEOS, ORACLE APEX, SAP Cronacle

ETL Tool: Informatica Power Center 9.5.0

Reporting Tools: Oracle Forms and Reports

Version Control Tool: Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Analyze current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs.
• Developed Triggers, Stored Procedures, Packages, Scripts, Profiles, Concurrent Programs to customize the application based on the requirements.
• Involved in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Ensuring all acceptance criteria of the customer has been met and making changes to rectify errors, if any. Getting the final sign-off on Demand Planning and Integration workflows.
• Involved in Data Modeling using normalizing Techniques.
• Reporting the project status to responsible managers on a daily and weekly basis. Daily tasks included attending meeting with other team managers.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions.
• Documenting the Demand manager workflow and the entire integration workflow with stress on field level details for data migration.
• Close interaction with business users, understanding requirements, discussion of in-progress projects deliverables and coordination between onsite/offshore teams.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and validation of output files generation before loading them into the base tables.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Creation of Workflows, Transformations, Projects, Jobs and Datastores in SAP HANA BODS tool.
• Identifying the set of features and functionalities available in i2 Demand Manager to meet the requirement of the client.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• ETL development using PL/SQL, analysis of the existing database, BULK loading, Data Partitioning to load the data in Oracle Database.
• Development of custom Reports in XML format for Excel (spreadsheets with format) directly from Oracle Applications
• Be the single point of contact to the users to fix all issues coordinating with other teams to resolve issues out of our hands.
• Partitioned the tables and materialized views to enhance the performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.

Environment: Oracle 11g, SAP HANA, PLSQL Developer, HANA Studio, XML, Erwin, SQL*Loader, Informatica Power Center 9.5.0, UNIX, SAP Data Services (BODS), Windows XP, i2 SCM Products (SCP, Demand Manager)

Confidential, Milpitas, CA

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and Modified SAP HANA Procedures, Functions, Tables and Synonyms.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in the continuous enhancements and fixing of production problems.
• Involved in Data Modeling using normalizing Techniques.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Worked with i2 Supply chain management(SCM) products SCP (Supply Chain Planner), FP (Factory Planner) and IO (Inventory Optimizer)
• Coded application components using a test-driven approach.Maintained project schedules and tasks.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use.
• Close interaction with business users, understanding requirements, discussion of in-progress projects deliverables and coordination between onsite/offshore teams.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and validation of output files generation before loading them into the base tables.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Creation of Workflows, Transformations, Projects, Jobs and Datastores in SAP HANA BODS tool.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Working with Cygwin tool to create unix Shell scripts, sql scripts.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Creation, Scheduling, updating and monitoring Jobs/Batches using job scheduling tool GECS.
• Partitioned the tables and materialized views to enhance the performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Worked with SAP job scheduler tool Cronacle for scheduling, monitoring writeback jobs to write data from i2 to SAP systems.

Environment: Oracle 11g, SAP HANA, PLSQL Developer, HANA Studio, TOAD, Erwin, SQL*Loader, Informatica Power Center 9.5.0, UNIX, SAP Data Services (BODS), Windows XP, Cygwin,i2 SCM Products(SCP,FP,IO)

Confidential, Wall Street, New York

Oracle PL/SQL Developer

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using PLSQL Developer. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Supporting trading applications used by Traders for Trading on Confidential Trading floor in Wall Street .
• Experience in Database Application Development, Query Optimization, Performance Tuning and implementation experience in complete System Development Life Cycle.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Working and maintaining centralized traders database application IMAGINE which store all securities information for traders. Make sure Imagine always available to traders and never goes down.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Working with the Client on performance improvement of trading applications so it will help Traders for trading without any issues or show stopper events as it directly results in huge monitory loss to Bank.
• Attending Change Management calls. This involves majority approving development tickets raised against production environment. I go through the ticket and check for anomalies against the functionality of the system. See through that testing is conducted by right set of Business users. Make sure that one change to server is not affecting other apps residing on the same server. Ensuring scheduled processes are not affected due to downtime incurred while changes are being deployed.
• Constantly interacting with Bloomberg and Reuters to get real time data about all securities and make sure there are no connection issues or slippage with trading system with them for traders.
• Monitoring all the trading applications during Trading hours, keeping close eye on health of all applications using Geneos System.
• Monitoring trader chat and providing on-call support to traders, sales teams and front/middle/back office and controlling teams on all trades or application related issues and queries without failure.

Environment: Oracle 11g, PLSQL Developer, TOAD, SQL*Loader, UNIX, Windows XP, Goose Exotics, Imagine, Geneos, GooseFlow, Wpro, Reuters, Bloomberg, Xavier Online (XOL).

Confidential, Jersey City, New Jersey

Oracle PL/SQL Developer

Responsibilities:

• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Involved in Logical & Physical Database Layout Design.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Performance tuning of Oracle Databases and User applications.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Creating and Testing golden gate and shell scripts in Production, UAT and Integration Environments.
• Work with Release Management or application configurations changes.
• Monitoring User support tool (DVSM), resolving the issues on functional and technical level on priority basis and On-call support.

Environment: Oracle 9i, SQL, PL/SQL, Golden Gate, UNIX, TOAD, SQL*Loader, Windows XP, Composite Information Server, Tomcat, Tibco Enterprise Messaging Service.