SUMMARY

• Proactive, performance - driven professional with 11 years of experience in IT industry in Investment Banking domain.
• Expertise and strong knowledge in Oracle PL/SQL (9i - 11g) and Sybase which includes developing PL/SQL
• Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, Power Builder, PL/SQL scripts.
• Rich experience working with Data Stage ETL tool for the extraction, transformation and loading of data among different databases. Strong knowledge of ETL processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import and UTL FILE to read and write the files.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
• Experience in writing Packages, Stored Procedures, Functions, Triggers, Materialized Views in Oracle 11g/10g /9i database.
• Worked with Collections, Records, Dynamic SQL and Exception Handling.
• Used SQL and PL/SQL performance tuning techniques which included creating indexes, partitioning tables, providing Hints, Optimizer query execution plans, SQL trace and TKPROF
• Writing Unix shell scripts for operations like loading flat-files into DB, Oracle programs execution using Sql Plus, generating and Ftp ing the output files to the file servers.
• Usage of vi editor for writing the Unix korn, bash scripts. Experience in Unix utilities like SED, AWK
• Good working experience in loading and generating XML files through Oracle DB.
• Efficient in creating Test cases and performing data validation and process testing for application moving into production.
• Worked with Third party scheduling tools like Autosys and Control-M
• Worked with different source code control tools like Microsoft Team Foundation Server and Subversion. Experience with JIRA used for Agile methodology.
• Good understanding and experience in Data modeling, ER Diagrams, Normalization and De-normalization of Tables.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts
• Proficient in advance features of Oracle for PL/SQL programming like using cursor variables, Ref cursors, Varrays, nested tables and Dynamic SQL.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Expertise extracting data according to source to target mapping and understanding and identifying details about the source and target data and what transformational logic needs to occur.
• Worked on Data warehousing EDW projects and testing data warehouse and data marts.
• Experience in Data Stage tool - Data Extraction, Data Transformation, Data Loading and Data Analysis and in writing queries in Teradata.
• Hands on experience in server setup to host files to automate the database refresh with help of Perl/cgi scripts.
• Experience in Autosys and Control-M to schedule jobs and for batch monitoring.
• Knowledge and hands on in Informatica (ETL Tool) for loading huge data files.
• Experience working in On-Shore/Off-shore Development Models.
• Strong time management skills in leading multiple projects and deadlines under minimal supervision.
• Experience in working on production and batch support processes.
• Recognized and highly appreciated for consistent success, knowledge and flexibility.

WORK EXPERIENCE

Technical Lead/Developer

Confidential, Durham, NC

Role and Responsibilities:

• Understand and analyze requirements, follow up with business analysts and subject matter expert team for any clarification, if required.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Providing resolution to the issues raised by users.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Involved in coding and designing of the Transaction Module using PL/SQL Procedure.
• Involved in coding and designing of the PL/SQL Blocks and increased performance by passing appropriate hints.
• Implemented Export/Import Oracle utilities to move data to different testing environments.
• Wrote complex SQL scripts and was responsible for Performance tuning of SQL Queries.
• Compiled, tested and debugged to implement business logic and enhance modularity, reusability and serviceability for maintenance of the application.
• Responsible for performing code reviews and written Test Plans and Involved in unit testing.
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
• Implemented various UNIX scripts to generate the data in txt format
• Co-ordinate with the Business Analysts and developers and do the Impact analysis.
• Unix scripts is used to ftp the files from vendor sites update the data files before loading the data using ETL/Informatica to process data from various vendors.
• From staging area, data is processed and modified as per the requirement and then loaded to integration area through stored procedures and ETL/ Informatica mappings.
• Used SQL*Developer/Toad for creating all types of PL/SQL objects like tables, Indexes, packages, triggers, sequences and stored procedures.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Worked on Performance tuning by using Explain plans and various hints.
• Run monthly process to correct the missing data received from different streams
• Automate the existing manual process to reduce dependency and improve flexibility
• Analyzing and fixing the failures in the daily batch and enhancing the old processes as per current requirements.
• To keep the technical support documents updated with the latest changes happening in the system and also tracking the solutions of the critical incidents in the support document
• Creation and Review of test cases based on requirements, and getting sign-off on test conditions from respective business analyst.

Technical Lead/Developer

Confidential, Durham, NC

Role and Responsibilities:

• Understand and analyze requirements, follow up with business analysts and subject matter expert team for any clarification, if required.
• Co-ordinate with the Business Analysts and developers and do the Impact analysis.
• Design/Review the Test Cases for Integration testing, System testing and User Acceptance testing (ITL /ATS).
• Unix scripts is used to ftp the files from vendor sites update the data files before loading the data using ETL/Informatica to process data from various vendors.
• Mappings are used in loading data to staging area.
• From staging area, data is processed and modified as per the requirement and then loaded to integration area through stored procedures and ETL/ Informatica mappings.
• Built an interface from Sybase to bring Futures/Options/Equities product and pricing data into Oracle on a daily basis.
• Mappings are also used in loading the target databases which is usually on different schema and the data is transformed in the process before loading to target.
• Used SQL*Developer for creating all types of PL/SQL objects like tables, Indexes, packages, triggers, sequences and stored procedures.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Applied optimizer hints to tune the queries for faster performance.
• Modified the procedures, functions and views based on the changes as per the business requirements in PL/SQL.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Migrated data from Flat Files to Oracle database using SQL*Loader.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Performed complex data manipulation using foreign functions written in C and PL/SQL language.
• Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.
• Developed an interface to connect from Sybase to LOANET system for applying the daily marks on sec Lending transactions
• Implemented Data loading process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Created Packages and Procedures for the batch load process and also real time process.
• Processing the data received from different source.
• Worked on Performance tuning by using Explain plans and various hints.
• Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on partitioned tables.
• Developed/optimized stored procedures in Sybase for fair value accounting, a feed to downstream.
• Organize and analyze the behavior of each Instrument for a certain period and provide the complete detailed analysis to investors which would help them in planning their portfolio and the investments.
• Evaluate the performance of different funds which would be ideal for long term investing which is the primary requirement of a retirement plan (401k) aimed at institutions.
• Gather requirements from clients analyze and prepare high level design documents.
• Coordinate with offshore in developing the testing the requirements.
• Run monthly process to correct the missing data received from different streams.
• Automate the existing manual process to reduce dependency and improve flexibility.
• Running production parallel testing to make sure all major fixes are tested before production deployment.
• To keep the technical support documents updated with the latest changes happening in the system and also tracking the solutions of the critical incidents in the support document.
• Creation and Review of test cases based on requirements, and getting sign-off on test conditions from respective business analyst.
• Involved in Design and Development of process to check for data validation, external price selection and calculates external market value and P&L difference and upload the changes to the GPT (runs on Sybase 15.x) and SPARTA (runs on Oracle) databases
• Preparation of test scripts for System and Integration Testing, and Traceability Matrix for the assurance of complete coverage of system requirements.
• Execution of System Test and Regression Test Scripts and validate data in database.
• Involved in test plan and test strategy creation and provided input on test effort estimation and resource compatibility.

Confidential

Technical Lead/Developer

Role and Responsibilities:

• Handling all user support requests from across the regions.
• Automating many manual works in the project.
• Automation done using shell scripting and autosys scheduler.
• Generate reports required by Japanese and US Federal Gov.
• Develop and maintained complex stored procedures (200+), functions and ad-hoc SQL scripts in a highly normalized Sybase database comprised of 180+ tables
• Helping firm to move on to new tools from existing ones with end to analysis and fixes and final implementation.
• Developed a process in Sybase to store historical data using appropriate stored procedure, triggers, tables and various shell scripts.
• Handling major UAT's independently & representing client from offshore office.
• Running production parallel testing to make sure all major fixes are tested before production deployment.
• Fixing the failures in the batch and making enhancement in processes that has deficiencies.
• To keep the technical support documents updated with the latest changes happening in the system and also tracking the solutions of the critical incidents in the support document.
• Used Aquadata studio to develop complex queries, procedures, packages and tables.
• Responsible for all Production Release across regions.
• Tested the entire application after Release for giving the final sign-off for Users to start using the system.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Code tuning or Query Optimization done using Explain Plans, Hints.
• Using utilities like BCP and Sybase Central.
• Design and implement Sybase database changes and enhancements, including schema changes
• Designing, developing, testing, troubleshooting and debugging of the application.
• Index Tuning for enhancing the performance of the database. Analyzing and monitoring system performances using DBCC Trace on commands, query plan outputs, system.
• Properly allocating task to the team members and consolidation of team work.
• Handling various enhancements to the system, this entailed writing new codes and changing some existing codes.
• Wrote new complex stored procedures in Sybase and optimized the existing code written in Sybase.
• Debugging the scripts and jobs in Production environment written in Shell and PERL.
• Handling and creating various autosys jobs in Production environment.
• Providing daily status reports to the clients.
• Provided production support and 24/7 support for resolving the critical production issues.
• Involved in the solving the tickets that are raised by the end users.
• Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.

Oracle Developer

Confidential

Role and Responsibilities:

• Managing client requests on Business as Usual and resolving the same in time
• Analysis of business/technical specifications
• Impact analysis.
• Understand and analyze requirements, follow up with business analysts and subject matter expert team for any clarification, if required.
• Creation and Review of test conditions based on requirements, and getting sign-off on test conditions from respective business analyst.
• Designed the tables, indexes, triggers, stored procedures, functions and packages to implement the requirement.
• Unix scripts is used to ftp the files from vendor sites update the data files before loading the data using ETL/Informatica to process data from various vendors.
• Mappings are uses in loading data to staging area.
• From staging area, data is processed and modified as per the requirement and then loaded to integration area through stored procedures and ETL/ Informatica mappings.
• Mappings are also used in loading the target databases which is usually on different schema and the data is transformed in the process before loading to target.
• Analysis of Source data, Oracle Source Objects and identifying the methods for loading data to target.
• Created and used External Tables for migrating flat file data into target.
• Responsible for the creation of Packages, Functions and Procedures. Performed Testing of the Packages, Procedures and Functions.
• Loaded data from different Sources into the Temp data backup environment using SQL Loader.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for the existing tables as per business logic.
• Design and implement database changes and enhancements, including schema changes in CRM application which maintains/manages the action items, call records, business at risk and pipeline details in Sybase DB 12.5.3
• Preparation of test scripts for System and Integration Testing, and Traceability Matrix for the assurance of complete coverage of system requirements.
• Execution of System Test and Regression Test Scripts and validate data in database.
• Involved in test plan and test strategy creation and provided input on test effort estimation and resource compatibility.
• Develop bug fixes and enhancements.
• Delivery & testing of code fixes.
• Develop and maintain regression test packs.
• Regression testing.
• Production support of some of the applications of the bank which includes resolving issues of the overnight batch processes and daily users' queries

TECHNICAL SKILLS

• Oracle PL/SQL (10 years)
• Informatica Power Center (6 years)
• Sybase (5 years)
• UNIX shell scripting (9 years)
• Perl (3 years)
• HTML (3 years)
• CGI (2 years)
• Autosys & Control M Scheduler (6 years)
• Reporting (6 years)
• Toad (7 years)
• JIRA (3 years)
• Clearcase (4 years)