EXPERIENCE SUMMARY:

• 11+ years of software development experience using client server architecture.
• Expert in designing and building Database applications in Windows and UNIX environments.
• Well versed with all the phases of Software Development Life Cycle (SDLC & Agile) including requirements gathering, DB application design, development, testing and support.
• Extensive experience on SQL and PL/SQL code development using advance features.
• Experience in project execution process, coding standards & best practices.
• Excellent leadership and negotiating skills on various development and enhancement projects.
• Proficient in understanding business processes / requirements and translating them in to technical requirements and preparing high level estimation.
• Experienced in Data Modeling, Database schema designing, preparing of Entity Relation Diagrams (ERD), Data Flow diagrams (DFD) and preparing high-level design documents.
• Experience in working in Large Databases environment using ORACLE 10g/9i, SQL, PL/SQL.
• Expertise in writing SQL (complex queries), PL/SQL (stored procedures, functions, packages, database triggers, Collection, Materialized views, autonomous transactions and shell/perl scripting in Solaris environment.
• Experience in Version Control management using Visual Source Safe and dealt with multiple version code development environment.
• Experience in performance tuning using SQL Trace, explain Plan, TKPROF and DBMS_ADVISOR.
• Extensive use of DDL (Create, Alter, Drop, Truncate, Rename), DML (Select, Insert, Update, Delete, Merge), DCL(Grant, Revoke) and TCL(Commit, Savepoint, Rollback) statements.
• Experience in using effective use of tools like SQL*Plus, SQL*loader, SQL Developer, TOAD.
• Experience in DBA related work like creating database schema, tables, views, Indexes, Synonyms (Private, Public), roles and DB-Link etc.
• Expertise in accomplishing ETL Task. Developed and implemented the ETL approach from staging to target using Informetica and PL/SQL.
• Data processing using UTL_FILE, processing XML file, validating XSLT, creating HTML/XML file SQL.
• Experience in data-warehousing, designing Star schema and Snowflake schema, Master data Management MDM, Metadata Repository implementation, Object to Relational Data Mapping, Fact/Dimension table, universe and data mart creation.
• Strong skills in critical thinking and analysis, verbal and written communications, and interpersonal interactions.
• Ability to work independently as well as in a team under challenging conditions.

BUSINESS DOMAIN:

• Financial Services.
• Defined Benefits (Pension Administration and Calculation)
• Stock Exchange (Capital market,derivatives, custodian operation and Online Trading)
• Mortgage (knowledge of property and causality)

EDUCATION:

Master in Computer Applications (M.C.A ). Bachelor in Science. (Mathematics). CERTIFICATION:

• Oracle certified Associate (OCA PL/SQL developer).
• Oracle certified Associate (DBA).
• Brainbench Master Oracle PL/SQL Fundamental.
• Agile software development methodology.

TECHNICAL SKILLS:

Operating Systems:- Windows NT, XP, 9x, UNIX, DOS, Linux, Sun Solaris. Databases:- ORACLE 10g, 9.x, 8.x, 7.x. Programming Languages:- PL/SQL , Centura 1.5, Visual Basic, C, C++, COBOL, Java (Basic), Java Scripts, HTML, XML, UNIX/Perl scripts. Tools and Utilities:- SQL*Plus, TOAD, SQL Developer, PVCS, VISIO. ETL/Data warehouse tools:- Informetica.

PROFESSIONAL EXPERIENCE

Client: Confidential, NJ Aug 2010 - Till date Project Name: - EXSOP - Employee Stock Option Plan Role: Sr. Developer and Data Base Tech Lead Technology Used: - Oracle 10g, UNIX, PL/SQL, TOAD

Project description: Bank Of America/Merrill Lynch is one of the world's largest investment management companies. It offers various kinds of financial services including sock option plan administration. EXSOP system caters the funtionalitis needed for administering emplyee stock options plan and employee sock purchase plan.

• Responsibilities:
• Leading a development team for stock purchase plan module.
• Designing and developing Schemas, Preparing Entity Relationships Diagram(ERD), Normalizing the new tables, creating Tables, Views, Indexes and Sequences.
• Modeling DB tables for tax projects, logical and physical modeling using ERWIN.
• XML file and CSV file processing and loading them to the staging tables for further application processing.
• Creating XML/HTML file using SQL and UTL_FILE package.
• Tuning SQL queries and PLSQL code for better performance.
• Data analysis, correction and transformation for implementation.
• Design and review of DB architecture for scalability and performance.
• Writing complex SQL queries, Sub Queries, Nested Queries and correlated sub query, hierarchical query.
• Writing Cursors, stored procedures, functions, packages, Types, database triggers and exception handlers.
• Assisting in high level and low level document designing.
• Writing UNIX/Perl shell scripts for batch jobs in Solaris environment.
• Created excel file using plsql code.
• Reviewing co-worker's code to comply with coding standard and best practices.
• Supporting production system in warranty period.

Achievements:

• Got recognition from business and client for ESPP , Mobility and Transferability Modules for its quality and timely completion.

Client: Confidential, Valley Forge, PA Aug 2008 - Aug-2010 Project Name: - VPAS - Defined Benefits Role: Sr. Developer and Data Base Tech Lead Technology Used: - Oracle 10g, UNIX, PL/SQL, SQLDEVELOPER

Project description: Vanguard is one of the world's largest investment management companies. It offers various kinds of financial services including pension administration service. Vanguard Pension Administration Service system handles all aspects of administering a defined benefit plan.

• Responsibilities:
• Leading a development team for pension plan configuration work.
• Designing and developing Schemas, Preparing Entity Relationships Diagram(ERD), Normalizing the new tables, creating Tables, Views, Indexes and Sequences.
• Data analysis, correction and transformation for implementation.
• Logical and physical data modeling for DB consolidation and integration
• Design and review of DB architecture for scalability and performance.
• Configuring pension plan using CPAS application.
• Writing complex SQL queries, Sub Queries, Nested Queries and correlated sub query, hierarchical query.
• Writing Cursors, stored procedures, functions, packages, Types, database triggers and exception handlers.
• Tuning custom code from base packages when the performance issue is found.
• Storing huge expose custom code in CLOB column and elevating it through standard CPAS scripting mechanism.
• Debugging existing code using Autonomous Transaction debugger procedure.
• Preparing high level and low level design document for configuration.
• Writing UNIX shell scripts for few batch jobs in Solaris environment.
• Reviewing co-worker's code to comply coding standard and best practices.
• Oracle DBA support forQA/development environment and production system in warranty period.

Achievements:

• Got star award from business for Saudi Aramco pension plan conversion project for its quality and timely completion.

Client: Confidential, New York, NY Mar 2008 - Aug 2008 Project Name: - IT_PTS Role: - Production Application Support/ Sr. Database developer Technology Used: - Oracle 10g, PL/SQL

Project description: Multiplan is the nation's oldest and largest supplier of independent, network-based cost management solutions to healthcare insurance company and providers. Its primary PPO and the PHCS Network, is the only national independent PPO to be recognized by two leading accreditation organizations.

• Responsibilities:
• Understanding the Production tickets with minimal help from seniors
• Escalating the problem to development team if needs more efforts.
• Simulating the scenario in Development or SQA environment to fix production tickets.
• Analyzing the script impacts before sending the DML script to DBA.
• Writing PL/SQL procedures, triggers, functions for various jobs, SQL Tuning for performance
• Adhoc query for Finance and Business development department using Toad
• Analysis, diagnosis and performance tuning for many searchreports.
• Tuned batch jobs with DBAs and analyzed the root cause by spooling UNIX log files, trace files from solaris.
• Re-designed doctor search engine with a new paging concept and made the search faster.
• Reviewing coworker's code to make sure code is optimized in all respect.
• Oracle DBA support for production/staging/QC/development environment

Achievements:

• Got appreciation from Director for my new design and performance tuning work for facilities and practitioners search engine.

Client: Confidential, Charlotte, NC Oct 2003 - Mar 2008 Project Name: - LoanQuest Role: - Tech Lead/Onsite-offshore Coordinator. Technology Used: - Oracle 9i/10g, PL/SQL, Centura 3.0, C++.

Project : LoanQuest enhancement and Loan Archival Project description: LoanQuest is a true client server vendor application developed by MortgageFlexSystems.Inc, USA. It caters all functions inherent to a loan origination/ decisions engine/underwriting system. LoanQuest Archival project was to boost production environment performance. This project provides a scalable business data driven Archival routine. Apart from providing performance benefit, it also results in cost savings & increase in productivity of end user.

• Responsibilities:
• Leading a nine member team that works for HSBC account for their Mortgage application.
• Estimating the enhancement work and assessing the project development effort.
• Data analysis, correction and transformation for implementation.
• Designing Data Flow Diagram (DFD) for the new business requirements.
• Preparing Entity relation Diagram and map logical data model to physical data model.
• Design and review of DB architecture for scalability and performance
• Writing complex SQL queries, Sub Queries, Nested Queries and correlated sub query, hierarchical query.
• Developing complex PL/SQL subroutines using Dynamic SQL, Collections, RefCursor, Pipeline Function, Package, Procedures and Triggers.
• Data loading from standard CSV file using External Table/ SQL*Loader.
• Application performance tuning using Indexing Approach, Bulk Binding, HINTS and Analytical functions.
• Reviewing team member's code and design documents.
• Conducting root cause analysis with team and educating them best practices and standard.
• Understanding third party database code and preparing process flow document for future enhancement and maintenance.
• Working with interface team to analyze the gaps between C++ application and mortgage application.
• Monitoring team work and assigning appropriate task to respective team members.
• Doing risk analysis and preparing mitigation strategies.
• Reporting the project status to management in timely fashion.

Achievements:

• Got appreciation from client and had the project nominated as Star Project of the year.
• Got appreciation from DBA for DB design and high performance quality code.

Client: Confidential, Mumbai, India Dec 2000 - Oct-2003 Project Name: - CIPS (Custody Information Processing System Role: - Sr.Developer/Onsite coordinator Technology Used: - Oracle 8i, PL/SQL, Centura 1.5

Project description: CIPS is a custodial back office application that provides functions and tools required for back office operations of safe custody and depository requests. Combined with graphical applications and specialized tools provided online, It caters to custodian operations, portfolio management & MIS for Fund managers covering both primary & secondary markets for debt & equity instruments.

• Responsibilities:
• Understanding client business scenarios and capturing requirement at client site.
• System change impact analysis and documenting those for offshore development team.
• Debugging application when bug reported for quick fixes.
• Developed many GUI and Centura/Crystal reports for urgent requirements.
• Writing PL/SQL codes for urgent release at client site.
• Writing test cases for business scenarios which was used by development team and for post implementation test.
• Preparing Metadata of the Database pertaining to the CIPS application.
• Preparing user manual when new module is released.
• Developed Data scrambling procedure to refresh Development DB from QA DB for real time test data scenarios.
• Prepared the ER diagram of the DB after gaining enough knowledge on the entire system.

Achievements:

• I was awarded by the company for a clearing houses (National Stock Exchange of India) Trade settlement automation work, which was developed solely by me at client side.