SUMMARY

• Proactive, performance - driven professional with 11 years of experience in IT industry in Investment Banking domain.
• Expertise and strong noledge in Oracle PL/SQL (9i - 11g) and Sybase which includes developing PL/SQL
• Have in-depth noledge 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 teh extraction, transformation and loading of data among different databases. Strong noledge 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 teh 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 teh output files to teh file servers.
• Usage of vi editor for writing teh 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 teh 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 noledge 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 teh source and target data and wat 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 teh 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, noledge 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 teh performance and to make teh database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve teh performance and make teh application to run faster.
• Providing resolution to teh issues raised by users.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Involved in coding and designing of teh Transaction Module using PL/SQL Procedure.
• Involved in coding and designing of teh 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 teh 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 teh performance and to make teh database objects more manageable
• Used Bulk collect and Forall in stored procedures to improve teh performance and make teh 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 teh application on teh client side.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures/Functions/Packages
• Implemented various UNIX scripts to generate teh data in txt format
• Co-ordinate with teh Business Analysts and developers and do teh Impact analysis.
• Unix scripts is used to ftp teh files from vendor sites update teh data files before loading teh data using ETL/Informatica to process data from various vendors.
• From staging area, data is processed and modified as per teh 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 teh missing data received from different streams
• Automate teh existing manual process to reduce dependency and improve flexibility
• Analyzing and fixing teh failures in teh daily batch and enhancing teh old processes as per current requirements.
• To keep teh technical support documents updated with teh latest changes happening in teh system and also tracking teh solutions of teh critical incidents in teh 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 teh Business Analysts and developers and do teh Impact analysis.
• Design/Review teh Test Cases for Integration testing, System testing and User Acceptance testing (ITL /ATS).
• Unix scripts is used to ftp teh files from vendor sites update teh data files before loading teh 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 teh 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 teh target databases which is usually on different schema and teh data is transformed in teh 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 teh queries for faster performance.
• Modified teh procedures, functions and views based on teh changes as per teh 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 teh 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 teh batch load process and also real time process.
• Processing teh 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 teh behavior of each Instrument for a certain period and provide teh complete detailed analysis to investors which would help them in planning their portfolio and teh investments.
• Evaluate teh performance of different funds which would be ideal for long term investing which is teh 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 teh testing teh requirements.
• Run monthly process to correct teh missing data received from different streams.
• Automate teh 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 teh technical support documents updated with teh latest changes happening in teh system and also tracking teh solutions of teh critical incidents in teh 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 teh changes to teh 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 teh 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 teh regions.
• Automating many manual works in teh 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 teh failures in teh batch and making enhancement in processes that has deficiencies.
• To keep teh technical support documents updated with teh latest changes happening in teh system and also tracking teh solutions of teh critical incidents in teh support document.
• Used Aquadata studio to develop complex queries, procedures, packages and tables.
• Responsible for all Production Release across regions.
• Tested teh entire application after Release for giving teh final sign-off for Users to start using teh 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 teh application.
• Index Tuning for enhancing teh performance of teh database. Analyzing and monitoring system performances using DBCC Trace on commands, query plan outputs, system.
• Properly allocating task to teh team members and consolidation of team work.
• Handling various enhancements to teh system, dis entailed writing new codes and changing some existing codes.
• Wrote new complex stored procedures in Sybase and optimized teh existing code written in Sybase.
• Debugging teh 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 teh clients.
• Provided production support and 24/7 support for resolving teh critical production issues.
• Involved in teh solving teh tickets that are raised by teh end users.
• Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
• Prepared UNIX shell script for teh transfer of files from FTP to SFTP.

Confidential 

Oracle Developer

Responsibilities:

• Managing client requests on Business as Usual and resolving teh 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 teh tables, indexes, triggers, stored procedures, functions and packages to implement teh requirement.
• Unix scripts is used to ftp teh files from vendor sites update teh data files before loading teh 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 teh requirement and tan loaded to integration area through stored procedures and ETL/ Informatica mappings.
• Mappings are also used in loading teh target databases which is usually on different schema and teh data is transformed in teh process before loading to target.
• Analysis of Source data, Oracle Source Objects and identifying teh methods for loading data to target.
• Created and used External Tables for migrating flat file data into target.
• Responsible for teh creation of Packages, Functions and Procedures. Performed Testing of teh Packages, Procedures and Functions.
• Loaded data from different Sources into teh Temp data backup environment using SQL Loader.
• Wrote scripts for creating tables, Indexes, Grants and Synonyms in different schemas and made modifications for teh existing tables as per business logic.
• Design and implement database changes and enhancements, including schema changes in CRM application which maintains/manages teh 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 teh 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 teh applications of teh bank which includes resolving issues of teh overnight batch processes and daily users' queries