SUMMARY

• Proactive, performance - driven professional with 10.5+ 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 Procedures, Packages, Triggers, Bulk collections, Cursors, Views, Objects and Performance Tuning of Data Warehouse environment.
• Proficient in UNIX shell scripting in automation of various processes.
• Hands on experience in server setup to host files to automate the database refresh with help of Perl/cgi scripts.
• Developing web page applications using HTML5, CSS3 and Javascript for form validations. And using Ajax and PHP scripting to get back data from Oracle DB.
• 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:

• Providing resolution to the issues raised by users.
• Monitoring and providing batch support for the daily and monthly batches.
• Conduct regular meetings to check for weekly and monthly install.
• Provide month end batch support and provide on-call support.
• Enhancement of the existing application to provide more functionality.
• Identify long running process and tune the same.
• 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.
• Used SQL*Developer/Toad for creating all types of PL/SQL objects like tables, Indexes, packages, triggers, sequences and stored procedures.
• Optimized the existing long running processes to run faster with usage of Bulk Loader, Hints and limits on bulk loader
• Used Explain Plans to analyze long running queries and degree of Parallel to make queries run faster.
• Create new web applications from HTML5 and CSS3. Use Javascript for form validation
• Host the web applications on windows server 2012 R2 machine
• Used PHP as the server side language to psftp the files from user’s machine.
• Call oracle client functions ODBC to connect to db and get back the results on HTML forms.

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
• Involved in test plan and test strategy creation and provided input on test effort estimation and resource compatibility.
• 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 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.
• 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.
• Organize and analyze the behavior of each Investment Instrument like Stocks, Bonds etc 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.
• Coordinate with offshore in developing the testing the requirements.
• Run monthly process to correct the missing data received from different streams.
• 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.
• Preparation of test scripts for System and Integration Testing, and Traceability Matrix for the assurance of complete coverage of system requirements.

Technical Lead/Developer

Confidential

Role and Responsibilities:

• Handling all user support requests from across the regions.
• Handling all the batch failures that arises in the application he is handling.
• Automating many manual works in the project.
• Automation done using shell scripting and autosys scheduler.
• Generate reports required by Japanese and US Federal Gov.
• Helping firm to move on to new tools from existing ones with end to analysis and fixes and final implementation.
• 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.
• 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.
• 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