SUMMARY:

• Fifteen years of strong experience in design, development, coding, testing, implementation, maintenance and support of large multi - tier Financial, Investment Banking, Pharmaceutical, Healthcare, CRM and Logistics business processing systems using Oracle 9i,8i/8.x, PL/SQL 9i, Developer2000-Forms &
• Reports, Oracle 9iAS, Oracle Portal, SQL Server 2000, Pro*C, Unix, korn Shell scripting, Perl, JSP, Autosys, PSP, Java script, Microsoft .NET technologies using C#, ASP.NET, XML & XSL. Has experience with data modelling, writing technical specifications (HLD & LLD) from the functional specifications, managing development teams and very good analytical, problem solving and programming skills. Ability to work under pressure to meet deadlines, multitasking, a team player, effective client communication and liaison skills, Self motivated and highly professional with superior disciplined Organizational skills, efficient management of time & tasks.

TECHNICAL SKILLS:

Languages: SQL, Transact-SQL, PL/SQL, C, C++, Java, JSP, Pro*C, PSP, Perl, ASP,.NET Framework-2.0, ASP.NET, C#.NET, HTML and XML

Scripting Languages: Java Script and Unix Shell Scripting

Databases: MS Access, SQL Server 2000, Oracle-8i, 9i, 10G, Sybase, Netezza

Packages: MS Office

ERP Tools: Oracle Applications-11i (Techno-Functional) -

Distribution (Order Management, Sales Order, Purchase Order), Workflow.

Design Tools: Erwin, Visio, Oracle Designer, Developer2000

Reporting Tools: Reports9i, crystal reports-9,10

Application Servers: Oracle 9iAS, Web Logic, IIS

Operating Systems: MS-DOS, Windows 98/2000/NT/XP, UNIX, Linux

Hardware: IBM Compatibles

Others: Data Warehousing, Track wise, CVS, Toad, PL/SQL Developer, JWS, Informatica Power centre 8, Citrix, AutoCAD, Autosys, Excel-VBA, SQL Loader, Web Services, Oracle Discoverer

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Expert knowledge on end to end Investment Banking Regulatory IT reporting processes.
• Knowledge of Investment Banking business to effectively communicate with Users.
• Analysis, Design and development using oracle-11G and reports using business objects.
• Understanding issues/requirements from users and analyse, develop, Test and prioritize them until its released to production.
• Managing small team of developers in analysis and assisting in implementation of database solutions using oracle-10G/11G
• Design and Development of data load procedures from legacy and other source systems using informatica.
• Assisting RTB team in fixing issues in batch run as Development team support(Level1).
• Writing PL/SQL, Stored procedures, triggers, packages using oracle -10G,11G
• Writing high Performance queries, tuning SQL, identifying DB batch issues.
• Interaction with users to gather requirements and managing timely delivery.
• Development of reports using Business Objects-R3 and SQL adhoc requests.
• Supporting requests from Auditors and resolve queries.

Environment: Oracle 10G/11G, Informatica-9.1, Business Objects-R3, PL/SQL, TOAD-9, Windows XP/NT, Unix Shell scripting, Perl scripting

Confidential

Responsibilities:

• Analysis of user requirements and Development using Oracle PL/SQL stored procedures, functions, triggers etc.
• Database performance tuning of SQL queries, identifying performance issues in batch.
• Data movement using informatica from vendor source files and legacy databases
• Design, development and release of new functionality using oracle, Unix, informatica and autosys
• Troubleshooting database issues in UAT and Production environments
• Analysis, Design coding of enhancements and bug fixes.
• Extensive working knowledge on Netezza database
• Migration of existing application running in MS-access database into Netezza stored procedure utilizing its high efficiency and performance
• Database performance reviews and efficient query rewriting
• Development of new data feeds using informatica, performance tuning of existing mappings

Environment: Oracle 10G/11G, Netezza, Informatica-8.1.6, Sybase-7, PL/SQL, TOAD, Aginity, Windows XP/NT, Unix Shell scripting, Perl, Clearcase

Confidential

Responsibilities:

• Database performance tuning of SQL queries, database server parameters
• Troubleshooting database issues in UAT and Production environments
• Analysis, Design coding of new requirements, enhancements and bug fixes.
• Design, Development and support of daily nightly data feeds for the Confidential and maintaining data quality for downstream consumers.
• Database performance reviews and efficient query rewriting
• Development of new data feeds using informatica, performance tuning of existing mappings
• Worked on analysis, coding and testing of Fixed income Analytics.

Environment: Oracle 10G/11G, Informatica-8.1.6, Sybase-7, PL/SQL, TOAD, Windows XP/NT, Unix Shell scripting, Perl, SVN

Confidential, Boston

Responsibilities:

• Performance engineering of batch runs in UAT environments
• Monitoring, Troubleshooting of issues in oracle database, Informatica, Unix scripts.
• Supporting and troubleshooting of user reports using Business Objects.
• Enhancements in the reporting objects like adding columns, performance etc
• Designed efficient high performance ETL mappings to load data into warehouse.
• Created reports using Web Intelligence i.e. crosstab, master detail
• Universe design and database enhancements as per reporting needs.
• Created summary table in Oracle database to support Aggregate awareness functionality in the reporting.
• Writing shell scripts for efficient running of batches.
• Written database scripts for performance, partition creations and gather statistics
• Maintaining and setting up Control-M Scheduler jobs
• Development of automated batch running procedure for efficiency.
• Performance tuning of Oracle SQL’s, Informatica mappings and business objects reports.

Environment: Oracle 10G, Informatica-8.1.6, PL/SQL, PL/SQL developer, Business Objects, Windows XP/NT, Unix Shell scripting

Confidential

Responsibilities:

• Analysis, Design of Data warehousing solution to integrate the various accounting systems for the financial control team at Barclays.
• Conducted extensive requirement scoping effort for the data warehousing need.
• Talked to users to analyse and prioritize the business needs, issues and risks
• Data modelling, development, test and implement database solutions using oracle-10G
• Design and Development of data load procedures from legacy and other source systems using informatica.
• Migration of database objects from Sybase into Oracle.
• Development using efficient data load procedures and setting up Autosys Scheduler jobs
• Writing PL/SQL, Stored procedures, triggers, packages in oracle -10G
• Writing high Performance queries and data flow methodology.
• Direct Interaction with users to gather requirements and timely delivery.
• Development of reports using Business Objects-R3.

Environment: Oracle 10G, Informatica-8.1.6, Business Objects-R3, Sybase-7, Erwin-6, PL/SQL, TOAD-9, SQL Loader, Windows XP/NT, Unix Shell scripting

Confidential

Database Analyst

Responsibilities:

• Analysis, Design and setting up new research data warehouse system for storing historical and daily forex Live spot prices on all major currency pairs. This database is used mainly for research and testing purposes
• Created the logical and physical data model.
• Setup the data load architecture to stage the raw data and load into target area
• Developed the target data load process using PL/SQL, Stored procedures, packages in oracle -10G
• Developed the data loading process using Oracle’s SQL loader.
• Writing shell scripts for handling data extraction and loading.
• Performance tuning of SQL statements.
• Efficient exception handling methodologies using Oracle-10G
• Job scheduling using DBMS Scheduler in Oracle

Environment: Oracle 10G, Erwin-4.0, PL/SQL, SQL Navigator, Windows XP/NT, UNIX.

Confidential

Database Modeler

Responsibilities:

• Analysis and Design of new data warehouse for storing the Price-Yield data points for different fixed income assets from Bloomberg.
• Created the logical and physical data model.
• Created new dataflow procedures in oracle using PL/SQL, Stored procedures, packages to massage and load the actual curve points derived using a formula for all maturity periods.
• Analysis and Integration with existing centralized CORE Insurance system.
• Defining new datasets (Oracle Views) for creating reports.
• Performance tuning of slow running SQL queries.
• Coding review and advised better efficient coding practices using PL/SQL-Procedures, DB-Partitions, triggers, functions, bulk collections and shell scripts

Environment: Oracle 10G, Erwin-4.0, PL/SQL, SQL Navigator, Windows XP/NT, UNIX.

Confidential

Responsibilities:

• Providing technology development/support for legal & Compliance applications
• Significant user interaction analysis, understanding requirements and executing IT deliverables
• Handling market data feeds and loading rates data into database for fixed income products- Bonds
• Database support for ARC, APS and ARS product applications
• Migration/Conversion of Oracle objects from 9i to 10G
• Provide in-depth business and technology analysis on issues/requests and its resolution
• Proficient in Unix Shell Scripting
• Data loading using SQL Loader/Informatica-8.0, writing loader files
• Complete analysis/development of oracle reports from Initial User requirement gathering until Implementation
• Coding using PL/SQL-Procedures, triggers, functions and shell scripts
• Done Code walk-through, testing and Implementation
• Performance tuning of the SQL queries and PL/SQL code, TKPROF analysis
• Worked on Configuration management and reports services
• Worked on Setup, Configuration and tuning Oracle Application Server -10G
• Knowledge in Oracle Discoverer and support
• Worked on Oracle reports-10G for creating user reports for compliance & Legal department
• Developed, Maintained and upgraded the Forms and reports-10G reports in Oracle-9i and 10G
• Analysis, Design, Coding and Testing of Legal & Compliance reports based on User requirements
• Application level problem diagnosis, performance analysis and troubleshooting, resolution and testing
• Writing scripts for automated load/volume testing
• Troubleshooting informatica, Load Optimization and schedule jobs using Unix
• Understanding and modifying the existing mappings
• Expert and careful analysis to every detail in the requirement specification document and efficient coding
• Coding using PL/SQL-Procedures, functions, SQL scripts, Materialized views and shell scripts used for batch jobs
• Done Performance monitoring, worked with partitioned data and support of critical RDS enterprise application and writing efficient fine-tuned queries
• Worked on Oracle-10G for analysis and development of business logic for those issues reported during ARS, APS product transactions
• Data loading using SQL Loader/Informatica, writing loader files
• Understanding and modifying the existing mappings
• ETL source data from DB2, Flat files
• Source code validation and Version control using CVS
• Writing cross DB queries using Transact-SQL
• Data warehouse modelling, design, coding and support for all others related to ARC, APS & ARS
• Worked on Data Conversion, Data Mapping and Data Corrections, Error handling, BI reporting etc
• Unit/acceptance testing
• Analysis, DB Design and defining dataflow procedure/processes to handle daily market data feeds used as main source of information to internal application for further analysis
• Analysis, Design and creation of company financial reports based on new business rules
• Data loading using SQL Loader/Informatica
• Understanding and modifying the existing mappings
• Work with user’s analysis, understanding requirements and executing IT deliverables
• Coding using PL/SQL-Procedures, DB-Partitions, triggers, functions and shell scripts
• Design user reports using Reports-10 based on user requirements
• Source code validation and Version control using CVS
• Done Code walk-through, testing and Implementation
• Unit/acceptance testing
• Performance tuning of the SQL queries and PL/SQL code

Environment: Oracle 9i/10G, Oracle Designer, CVS, PL/SQL, JAVA, JSP, HTML, Informatica-8, SQL Navigator, Windows XP/NT, Unix Shell scripting, Perl, Oracle reports-10.

Confidential, NY

Responsibilities:

• Providing technology development and support for middle- and back-office applications
• Strong working knowledge on Equity/Equity derivatives business, interact with users
• Worked in Compliance feeds (Blue sheets) and Compliance Platform
• Back Office Data source provider for Compliance and other team
• Significant user interaction analysis, understanding requirements and executing IT deliverables
• Provide functional and business analysis for the development initiatives for Equity Trading/Broker-Dealer business
• Strong financial data analysis skills
• Follow the global and regional Information Technology standards, policies, procedures

Confidential

Responsibilities:

• Involved in implementation of Confidential solution for the US equity market
• Gathering functional specifications from business users
• Converting functional specifications into high-level and detailed technology design documents for development efforts
• Full understanding of the Confidential project data flow and efficient coding.
• Worked closely with business analyst to understand the Confidential requirements and efficient execution.
• Knowledge on the Confidential compliance brokerage module using case manager
• Worked as Data source provider for the US Global compliance project on Confidential .
• Working knowledge using Java SGIB Mapper tool to generate the XML extracts for sending daily position data
• Analysis, development, Coding and Testing using XML, Java, Oracle, Unix-Shell Scripts
• Thorough understanding of the underlying system and troubleshooting potential problems
• Involved as data provider, validate, analysis and support person
• Migration of entire system written in SQL server Stored procedures into Oracle
• Analysis of the old design and suggested enhancements for new design using oracle
• Identified the potential problems in the old system and Bug fixing
• Data loading using SQL Loader/Informatica, writing loader files
• Understanding and modifying the existing mappings
• Coding using PL/SQL-Procedures, triggers, functions and shell scripts
• Design user reports using Crystal reports based on user requirements
• Troubleshooting informatica, Load Optimization and schedule jobs using Unix
• Done Code walk-through, testing and Implementation
• Unit/acceptance testing
• Development, testing and Implementation of new Compliance reports using Crystal reports and oracle -10G
• ETL source data from Cobol, Flat files, XML
• Data loading using SQL Loader/Informatica, writing loader files
• Understanding and modifying the existing mappings
• Troubleshooting informatica, Load Optimization and schedule jobs using Unix
• Understanding and modifying the existing mappings
• Scheduling of the reports in PDF, Excel formats to run daily in the Data store
• Support and trouble shooting of existing reports loaded into the Data store
• Unit/acceptance Testing
• Translating functional specifications into quality products
• Participating in code and design reviews
• Creating and maintaining technical documentation
• Coding using Java, JDBC, J2EE, JSP, JavaScript, PL/SQL- Oracle Stored Procedures & functions
• Unit/acceptance Testing experience
• Application maintenance & support to users
• Migration of reports using crystal-10 from SQL server to Oracle database
• Writing cross DB queries
• Writing Unix shell scripts and PL/SQL to design and develop batch loading process for daily data procedures
• Worked on informatica to map and load the data's from the staging into target database
• Scheduling and setting up the jobs in Autosys
• Data transfer using FTP, SFTP protocols
• Technical documentation of all the tasks
• Writing Optimized SQL queries in the Database for better performance
• Query Optimization and Performance tuning of the procedures, Partitioned tables
• Worked with other tech groups to collect functional requirements
• Analyze and deliver compliance data as per the user requirements.
• Coding using Oracle Stored Procedures & functions
• Writing .ksh scripts to extract and load data from the back-office Beta system
• Daily monitoring the data load/extract jobs in Autosys, log files
• User Applications support
• IT services Process management using Track wise tool
• Attending Business user group meetings
• Writing new programs using Unix shell scripts for data loads/extracts based on user requirements
• Performance tuning of the database queries and Procedures

Environment: Oracle 9i/10G, SQL Server-2000, RAC, Erwin, PL/SQL, CVS, JAVA, JSP, HTML, .NET Framework, Informatica, TOAD-9, Windows XP/NT, Unix Shell scripting-korn, Perl, Crystal reports-10.

Confidential, San Francisco, CA

Responsibilities:

• Translating functional specifications into quality products.
• Analysis of the design and implementing solutions for Enhancements and Bugs fixing
• Creating and running SQL queries on post-data load to perform data validations
• Coding using PL/SQL-Stored Procedures, triggers, functions and shell scripts
• Modifying data loading scripts to support new file formats and data mappings
• Bug fixing both on the Product and also in the Production build.
• Executing data loads to support Business / Data Analysts at various stages of testing
• Supporting the QA/development teams in delivering actual production data for testing

Environment: Oracle 9i, PL/SQL, PL/SQL Developer, CVS, JIRA, Windows XP/NT, Unix Shell scripting.

Confidential, New York, NY

Responsibilities:

• Building environment for development and testing
• Analysis of the design and implementing solutions for Enhancements and Bugs fixing
• Application development using Java, JDBC, JSP
• Code walk-through and testing
• Coding using PL/SQL-Procedures, triggers, functions and shell scripts
• Migration of database system from SQL server into Oracle
• Worked on Collections objects, Complex joins, inline views, bulk data manipulation
• Support activities involving regular monitoring of the Production servers, interfaces and adapters across different time zones
• Source code validation and Version control using CVS
• Online Application support for users
• Data loading using SQL Loader/Informatica, writing loader files
• Troubleshooting informatica, Load Optimization and schedule jobs using Unix
• Understanding and modifying the existing mappings
• Creating test plans
• Creating scripts to run every daybatch programs, data extraction, transformation and load
• Writing UNIX shell scripts
• Job scheduling using Autosys
• Worked on OLAP systems - Data warehousing
• Handling technical exceptions in Trade Processing
• Handling any data related issues in production
• Conducting status call meetings
• Unit/acceptance testing
• Follow-ups of the issues till its resolved
• Escalating the issues to the corresponding groups
• Analysis and Design of the Database for the entire application
• Logical and physical database design-Data Modelling
• Creating the Database’s HLD and LLD Documents
• Writing Stored procedures, functions and triggers in Oracle Portal
• Implemented procedures using PL/SQL Server Pages that is supported in Oracle Portal
• Creating scripts for data load
• Developed forms and reports as per the users requirements
• Worked on Collections objects, Complex joins, inline views, bulk data manipulation
• Administration tasks on Oracle 9iAS
• Writing Java procedures in Oracle and implementing it for certain modules
• Code walk-through
• Writing Optimized SQL queries in the Database for better performance
• Query Optimization and Performance tuning of the procedures
• Unit testing of the Screens. System and integration testing
• Transferred knowledge to the users, regarding the working of the new product

Environment: Oracle9i, Oracle Portal,Developer 2000, Forms & Reports, Erwin, PL-SQL, Oracle 9iAS, Java, JSP, Windows NT, Solaris.

Confidential

Responsibilities:

• Detailed Analysis and Design of new modules in the Product
• Logical and physical database design-Data Modelling
• Time based design- Event Modelling
• Creating the Database’s HLD and LLD Documents
• Database Administration tasks
• Migration of the critical Business Logic written in Java into PL/SQL Procedures, triggers & functions in the Oracle Database
• Used informatica for ETL processes from source SAP system
• Troubleshooting informatica jobs, Load Optimization
• Understanding and modifying the existing mappings
• Creating & Modifications of the programs in PRO*C and UNIX shell scripting
• Code walk-through
• Worked on Collections objects, Complex joins, inline views, bulk data manipulation
• Unit testing of the Screens. System and integration testing
• Creating Packages, Procedures, and Functions in Oracle and also programs in JSP as according to the defined Framework
• Handling any data related issues in production
• Made structural changes in database to improve the integrity and performance of system operations
• Used Oracle’s Advanced Queuing technique to handle data
• Writing Optimized SQL queries in the Database for better performance
• Query Optimization and Performance tuning of the procedures
• Analysis, Design & Develop user interfaces using JSP, Java Scripts
• Creating setup with functional details
• Creating workflow
• Writing procedures, triggers & functions using PL / SQL
• Handling any data related issues in production
• Unit testing of the Screens. System and integration testing

Environment: Oracle-11i, Oracle 9i, Informatica-7, PL/SQL, Toad, PRO*C, Erwin, Forms & Reports, Windows NT 4.0, JAVA-JSP, UNIX (HP-UX).

Confidential

Responsibilities:

• Analysis, Design & Develop user interfaces using JSP, Java Scripts
• Writing procedures, functions, database triggers using PL / SQL
• Code walk-through
• Creating pharmaceutical regulatory reports using Oracle reports
• Unit testing of the Screens. System and integration testing

Environment: Oracle Applications 11i, PL/SQL, Erwin, Developer2000, Forms & Reports, JSP, Java Scripts, Windows NT 4.0

Confidential

Responsibilities:

• Database Migration from existing SQL Server into Oracle 9i.
• Analysis and Design for all the modules in the CRM Application.
• Analysed the user requirements and created the Data model through Visio.
• Writing Stored procedures, functions and triggers in Oracle9i for the entire application.
• Code walk-through
• Unit testing of the Screens. System and integration testing
• Worked on Collections objects, Complex joins, inline views, bulk data manipulation.
• Migrating the entire business Logic from the Application to the Database.
• Writing Optimized SQL queries in the Database for better performance
• Analysedthe client's existing database, provided suggestions to improve the database performance.
• Porting of real data from the production database into the test database for development and testing.
• Handling any data related issues in production.
• Created Materialized views from remote database servers.
• Made structural changes in database to improve the integrity and performance of system operations
• Query Optimization and Performance tuning of the procedures for generating reports on a daily basis.
• Data Extraction and Loading using Informatica, Load Optimization.
• Worked on the replication principles in Oracle for replicating the production database with the Stand-by Database used for reporting.
• Knowledge Transfer about the application to the users and handling their queries.

Environment: Oracle 9i (8.1.6), SQL Server, PL/SQL, Toad, Visio, Windows NT 4.0, Solaris.

Confidential

Responsibilities:

• Analysis and Design of the Database for the new modules.
• Writing Stored procedures, functions and triggers in Oracle Portal.
• Developed forms and reports as per the users requirements
• Writing Java procedures in Oracle.
• Analyzed and modified the existing procedures, triggers and functions to accommodate the new user requirements.
• Code walk-through.
• Unit testing of the Screens. System and integration testing.
• Transferred knowledge to the users, regarding the working of the new screens.

Environment: Oracle Portal 3.0, PL/SQL, Java, JSP, Oracle 9iAS,Erwin, Windows NT, and Solaris

Confidential

Responsibilities:

• Analysis and Design of the Database for the new modules.
• Writing Stored procedures, functions and triggers in Oracle Portal.
• Developed forms and reports as per the users requirements
• Writing Java procedures in Oracle.
• Analyzed and modified the existing procedures and functions to accommodate the new user requirements.
• Code walk-through.
• Unit testing of the Screens. System and integration testing.
• Transferred knowledge to the users, regarding the working of the new screens.

Environment: Oracle Portal 3.0, PL/SQL, Java, Developer 2000, Forms & Reports, Oracle 9iAS, Windows NT, and Solaris

Confidential

Responsibilities:

• Involved in Design and coding using Java JSP for User interface screens.
• Analysis and Design of the Database.
• Writing PL/SQL code for Packages, subprograms, and database triggers.
• Code walk-through.
• Unit testing of the Screens and the Subprograms. System and integration testing

Environment: Oracle 8i, Java, JSP, and Windows-NT

Confidential

Responsibilities:

• Involved in design and development of new user requirements using Autocad-R14.
• Customization of Autodesk's products.
• Extensive programming using Auto lisp.
• Worked on Graphic products like 3D Studio Max, MCAD, ArchT.
• Testing of the design in accordance with the requirement.
• Transferred knowledge to the users, regarding the working of the customized product.

Environment: AutoCAD, MCAD, 3D- Studio MAX, Arch-T, Auto Lisp, Windows-NT