Technical Lead/developer Resume
4.00/5 (Submit Your Rating)
Durham, NC
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 halp 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.
TECHNICAL SKILLS
- Oracle PL/SQL
- Informatica Power Center
- Sybase
- UNIX shell scripting
- Perl
- HTML
- CGI
- Autosys & Control M Scheduler
- Reporting
- Toad
- JIRA
- Clearcase
PROFESSIONAL EXPERIENCE
Confidential, Durham, NC
Technical Lead/Developer
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 tan 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.
Confidential, Durham, NC
Technical Lead/Developer
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 tan 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 halp 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 - NY
Technical Lead/Developer
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 dat TEMPhas 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, dis 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 dat 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.
Confidential
Oracle Developer
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 tan 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