PROFESSIONAL SUMMARY

• Well Experienced senior Application DBA / Data Architect/ Data Modeler having more than 15 years of experience in IT and more than 10 years in Data Modeling, Database Development, Performance tuning, analysis, ETL, Data Migration and Database Administration activities in high transaction volume databases in OLTP/OLAP environments.
• Extensive experience in Conceptual/ Dimensional / Physical/Logical database design, database application interface, performance tuning of database, PL/SQL, SQL, ETL and planning and implementing suitable database Security / Maintenance Strategies.
• Extensive experience and knowledge in the Architecture Administration of the prevalent databases like Oracle, Sql Server, DB2 UDB Sybase.
• Has a thorough understanding relational database models techniques, memory structures, excellent organizational, problem solving and communication skills both technical non- technical and a track record of working productively with technical staff, users, senior Management and people from different cultural backgrounds.
• Knowledge of Unix administration shell scripting K-shell including Perl.
• Proven expertise in all phases of Software Development Life Cycle SDLC of various projects
• Got many performance awards and appreciation letters from the clients. She is well conversant with Six Sigma ISO 9001 quality procedures, while executing her projects.
• Experience working in different domains like utilities, insurance, consumer finance and financial industry.
• More than 8 years experience in Wall street.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Consultant

Responsibility :

• Identifying and Understanding the business requirements for small group portal from different stakeholders/ user departments and effectively transforming it into a conceptual/ logical/ physical database model which meets the operational reporting objectives.
• Writing database packages, Stored procedures, database triggers, creating Database Tables, indexes, views etc for the small group portal.
• Doing performance tuning of the database query tuning, indexing, object level tuning etc for existing applications to improve the user experience for the portals.
• Giving technical help to the application developers.

Environment

Oracle 11g, Sun Solaris, Visual Studio.

Confidential

Senior Database Architect

Responsibility

• Data modeling and design of the application data and reports structure, storage and integration
• Database analysis, design and build for data remediation, reporting and stabilization to meet the long term business objectives.
• Ensure the database designs fulfill the requirements, including data volume, frequency needs and long-term data growth
• Development of cross-application data and distribution strategies
• Work with the technical architects and application designers to develop the data conversion procedures and applications

Environment

Oracle 10g, ERWIN, DBArtisan, Power Designer, Sun Solaris, SVN

Confidential

Technical Manager/ Database Architect

Responsibility

• Designing and normalizing/ denormalizing the database for enhancements and new applications belonging to GCH group.
• Maintaining the Conceptual, Logical and Physical Model for all databases collateral Management Security Master belonging to the group.
• Understand business requirements from business analysts and act as database expert to the development team during the design, development and testing phase for enhancements/bug fixes in the applications.
• Analyzing the causes for performance problems in the databases related to all applications belonging to Brokerage Securities Group and tuning the application queries, database memory allocations, parameters, object level tuning etc.

• Managing team of 5 at onsite and interacting guiding a team of 10 at offshore responsible for doing the production support for applications belonging to the Global Collateral Hub including Security Master in the WSS group in JP Morgan.
• Providing inputs, clarifications for any work to be undertaken by the project team at onsite/offshore.

• Planning, coordinating and monitoring the project as per the schedules reporting to higher management.

• Creation Monitoring of DB Loading jobs for the Global Collateral Hub Securities Group.
• Lead effort for writing stored procedures, database triggers, creating Database Tables, indexes, views, Snapshots, setting up autosys jobs.

Environment

Oracle 10g, ERWIN, TOAD, Autosys, Oracle Developer, Sun Solaris, Peregrine, SVN

Confidential

Database Architect Application DBA

Responsibility

• Responsible for all activities related to the logical architecture of data, metadata and its lifecycle from data entry into the group, usage, persistence, and exit from the group.
• Identifying and Understanding the business data requirements from different stakeholders/ user departments and effectively transforming it into a conceptual/ logical/ physical database model which meets the operational reporting objectives.
• Normalization / de-normalization of the Database design to bring about a best possible design for the application.
• Construct relational databases, optimize database performance, resource use, and address database integration issues for new existing applications , database migrations involving different databases MS-Access, Oracle, Sql Server, Sybase ,Db2 UDB etc , database integration, maintenance, conversion and capacity planning issues.
• Analyzing the causes for performance problems in the databases size more than 1 Terrabytes related to all applications belonging to Systems Management group and tuning the application queries , database memory allocations, resizing storage parameters, object level tuning etc.
• Monitoring the performance of the database using IWATCH, TOAD, Sql Server Management Studio, DB Artisan OEM and collecting statistical information about the performance of the database and doing proactive performance enhancement.
• Writing Stored procedures, database triggers, creating Database Tables, indexes, views, Snapshots, setting up data loading jobs, monitoring jobs in Oracle, Sql Server UDB databases.
• Use SQL Loader, DTS, SSIS Informatica ETL for loading and transforming data between databases in Oracle, SQL Server, and DB2.
• Giving technical support and guidance to the development team in all phases of SDLC.

Environment

Oracle 9 i / 10g, Sql Server 2003/2005, DB2 UDB 8.1, Linux, Sun Solaris 2.8, Clear case ,SVN, IWATCH 5.0,Power Designer 9.5,DBartisan, RapidSql, Toad, Informatica, DTS, SSIS, Power Center, Windows NT

Confidential

Coordinator cum Applications DBA

Responsibility

• Maintaining the Database Design using ERWIN.
• Ensure availability, confidentiality integrity of databases through security practices multiple access schemes, and facilitate sharing of common data across applications.
• Monitoring the performance of the database using DBArtisan Toad and taking preventive proactive measures to keep the performance within the prescribed standards.
• Understanding the business requirements for enhancements and transforming them to database solutions to meet the operational reporting needs.
• Address application database interactions issues and get them resolved.
• Coordinating with the offshore team for resolving maintenance requests for existing applications.
• Acting as a technical guide to developers for effective query writing.
• Providing inputs, clarifications for any work to be undertaken by the project team at offshore.
• Planning, coordinating and monitoring the project as per the schedules reporting to higher management

Environment

Oracle 8 i /9 i on Sun Solaris 2.8, PVCS, DBArtisan, Toad, Developer 2000, PL-SQL

Confidential

Lead Database Architect

Responsibility

• Leading the team of Database Architects and guiding the team in understanding the business requirements functional requirements in order to create the conceptual/logical/physical model of the database.
• Creation of the Logical physical model for different modules of the project using ERWIN.
• Normalization / de-normalization of the Database design to bring about a best possible design for the application.
• Giving technical support to the development team in application query tuning to bring out the best performance.
• Creation of storage objects sizing them based on estimated growth of each database element.
• Monitoring the performance of the database and tuning of queries, stored procedures, initialization parameters of the database etc.
• Loading data using SQL loader.

Environment Oracle 8 i on Sun Solaris 2.8, ERWIN 4.1 with Model Mart, MKS 8.1

Confidential

Application DBA

Responsibility

• Creation of users, table spaces, rollback segments, data files and their administration Loading of data
• Technical support to the development team in tuning the queries for report development to get the best performance.
• Installing and configuring the PeopleSoft HRMS client application on the client machines.

Environment Oracle 8 i on Sun Solaris 2.8, PeopleSoft 8.0 on Windows NT

Confidential

Consultant Database Architect / Applications DBA

Responsibility

• Understanding the business requirements from the client and effectively transforming it into a database solution, which meets the operational, transactional reporting objectives.
• Creation of logical physical database design using ERWIN.
• Creation of users, table spaces, rollback segments data files granting/ monitoring access control of the database objects.
• Tuning the application for performance.
• Ensuring compliance of the database with the GEFA standards
• Deployment of the database and implementation of the IAS connection pooling for all the applications
• Overall maintenance/support for all the databases involved including monitoring of various data loads from the businesses to the different databases.
• Got awarded by GEFA for excellent performance

Environment

Oracle 8.0 8 i on Sun Solaris 2.8, IAS iPLANET Web server