SUMMARY:

• Oracle Certified Professional with 11+ years of extensive hands on experienced Database Architect in Design, Development and Performance Tuning of various applications for Banking, Asset and Wealth Management systems and complex messaging systems.
• As Onsite Database Architect responsible for identifying data requirements, analyze impact on existing data warehouse and other applications, data model and data replication changes required to integrate with BO and Tableau reporting application and few third party user systems.
• Expert understanding of Oracle Architecture, involved in assessment of several Oracle Applications, conducted class room as well as hands - on trainings for Development, DBA teams. Defined best practices framework for Design, Development and Testing for Database Development Projects.
• Proposed solutions for data security and access controls, in-memory database storage of critical data, backup and restore, load balancing, high availability, and detailed sizing/storage data.
• Experience in all phases of projects including Business Case Evaluation, Requirement Gathering, Analysis, Designing, Development, Testing, Packaging and Deployment, Post Delivery Support using best of the project management processes. Also experienced in outsourcing strategies and onsite-offshore coordination.
• Expertise in Data modeling, creating Conceptual and Logical Models, analyzing and gathering reporting requirements, also good understanding of Reporting systems and Data Warehousing concepts & tools (Informatica, Business Objects).
• Proven performance engineering expertise, as ‘DB Architect - Performance Specialist’ various clients, supported Oracle 10g to 11g upgrade related critical performance improvement projects. Assess, Troubleshoot, Analyze performance issues on OLTP, Reporting/DW Databases during nightly batch processes, work with DBA and development teams to resolve the issues. Responsible for database, instance, application, SQL, PLSQL, code optimization, methods to control SQL plan volatility, define SOP for using SPM, real time SQL monitoring using DBMS SQLTUNE and approach to manage Oracle Statistics.
• Expertise in Design database objects including tables, indexes, views, materialized views, sequences and referential integrity and Very good hands on Develop and maintain database programs including packages, procedures, functions and triggers using PL/SQL.

TECHNICAL SKILLS:

Databases & Tools: Oracle 9i, Oracle 10G, Oracle 11 G, SQL server 2000, MS access

Operating System: Windows 95/98/2000/2003/ XP

Programming Languages: C, C++, ASP, C#, SQL, PL/SQL

Other Utilities: TOAD, PL SQL Developer, ERWIN, MS Visio, Visual Studio, SSIS, Enterprise manager

Version Control: VSS, SharePoint, SVN, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior Database Architect and Team Lead

Responsibilities:

• As a Senior Database ArchitectData Modeling (logical, dimensional and physical) for various projects, work with application teams to analyze data requirements, review data model and address the functional and nonfunctional requirements (performance, geographical separation, auditing, archiving)
• As a core member of architecture team, analyze requirements for various programs such as Balance sheet of Funding and Liquidity Attribution, GBB, MBS conceptualize possible solutions and client presentation
• Core member of the solution team responsible for proposing architecture, high level design for InvestorTax platform for multiple geographies (US, Singapore and India)
• Define best practices for data modelling and database development
• Conducted classroom trainings on SQL, PLSQL Performance best practices
• Assist various development teams with Database, Application Performance Enhancements, PLSQL optimizations, SQL Tuning. AWR, ASH report analysis, identify areas of improvements and implementation
• Define methodology for migration for various system applications for 10G to 11 G.
• Design database objects including tables, indexes, views, materialized views, sequences and referential integrity.
• Develop and maintain database programs including packages, procedures, functions and triggers using PL/SQL.

Tools: Oracle 10g, 11g database, PL/SQL Developer, TOAD, Oracle SQL Developer, Oracle DatabaseModeler,Informatica,Erwin.

Confidential, Boston

Database Architect/Developer

Responsibilities:

• As a Database Architect for a leading US based investment management firm.
• Offshore lead responsible for Security Reference Data application
• Understand technical architecture of the application, plan knowledge transfer activities for offshore team
• Work with application teams to re-engineer the applications to support new functional and auditing requirements. Logical and physical data modeling.
• Assessment of the entire application portfolio to identify the shortcomings in the application infrastructure, propose changes to address the shortcomings and identify value-adds
• Help the team members with code reviews, impact analysis and design of change requests, optimizing PLSQL program units, address performance issues.
• Assess, Troubleshoot, Analyze performance issues during 9i to 11g migration, nightly batch processes and advise solutions.
• SQL tuning, 10053 trace analysis, responsible for improving PLSQL refactoring, improving performance from hours to minutes, optimize distributed processing, reduce database resource usage - logical IOs, temporary table space usages, CPU consumption,CBC latch contention etc. Played crucial role in go-live of the 11g Upgrade project.
• Develop utility to analyze performance issue - changes in execution plan - bind history - statistics status - unindexed foreign keys etc.
• Design database objects including tables, indexes, views, materialized views, sequences and referential integrity for a reporting data warehouse.
• Develop and maintain database programs including packages, procedures, functions and triggers.

Tools: Oracle 10g, 11g database, PL/SQL Developer, TOAD, Oracle SQL Developer, Erwin.

Confidential

Database Developer and Data Modeler

Responsibilities:

• Understand existing functionality of third party options trading application and current trading platform, knowledge transition to off shore team
• Capture and analyze detailed data requirements, identify data sources, extraction mechanisms, data quality checks, data transformation required and changes required to existing datawarehouse to support the flexible options data
• Detailed design for database changes, application changes
• Review deliverables to ensure functional and quality compliance
• Help other application teams on PLSQL application optimization for performance enhancements.
• As onsite lead responsible for project kick off activities, environment setups, iteration planning, client presentations and reviews and coordinating offshore team.
• Get the application developed from the team of 6-8 people as team lead and technical architect for the project.
• Set coding guidelines and development workflows for the development.
• Understand the business case and finalize the feasible requirements and estimate the duration and cost for the same.
• Design database objects including tables, indexes, views, materialized views, sequences and referential integrity.
• Develop and maintain database programs including packages, procedures, functions and triggers using PL/SQL.
• Develop and support the Oracle PL/SQL code that performs the calculations for the all fulfillment marketing programs.
• As requested, support/fulfill requests for information and troubleshoot code
• Develop and maintain code to support Excel workbooks for program reporting. Develop and maintain reports for fulfillment programs.
• Create and maintain technical documentation, process flows, etc.
• Train other team members as needed.
• Participate in weekly team meetings and conference calls.
• Track and enter time in time management tool.

Tools: Oracle 11g database, PL/SQL Developer, TOAD, Oracle SQL Developer.