PROFESSIONAL SUMMARY

• Over fourteen years of experience in Information Technology out of which ten years as Oracle DBA on different flavors of Unix and Windows operating system.
• Oracle Certified Professional (OCP) DBA for Oracle database 9i / 10g
• Expertise in installation, configuration and upgrading of Oracle databases on Unix, Linux and Windows
• Experience in planning, Testing and Implementation of backup & recovery strategies using disaster recovery plan (DRA)
• Experience on Real Application Clusters (RAC) and ASM configuration and maintenance
• Experience of database and SQL performance tuning such as tuning of application, shared pool, buffer cache, I/O distribution, redo mechanisms
• Proficiency on logical database design (LDM)/Physical database design (PDM) for OLTP, ODS and Data warehousing applications.
• Experience in installation and configuration of Oracle Enterprise Manager with Grid control to Administration the Multiple databases
• Hands on experience in ETL/ Data warehousing tools like Informatica Powercenter, Cognos Powerplay, Cognos Impromptu, Cognos Reportnet, Business Objects and ER Win
• Very proficient in writing server side stored procedures/ triggers / Packages
• Excellent programming skills in PL/SQL, Forms 3.0 to 9i, Report 1.0 to 9i, Developer2000, Pro*C, Unix Shell scripting
• Extensively used ORACLE Built-in Packages, Pro*C and TEXT_IO option
• Worked on all phases of SDLC (System Development Life Cycle) and Involved in process analysis/design (for cost and cycle-time reduction)
• Have adequate function knowledge of Health care, Asset Management, Utility Services (like Energy, GAS, Electricity and others), Sales & Distribution, Manufacturing and Finance
• Experience in Project Management and Team Leadership. Good exposure on Budgeting, Resource management, estimation, scheduling and delivery to the client as per schedule
• Involve in hiring process as Technical Team member in EDS. Appreciated by Management
• Strong analytical skills and excellent communication, planning and organizational skills
• Ability to work on multiple projects with different deadlines often under pressure
• A quick, goal oriented and enthusiastic learner
• Excellent Team member as well as reliable and comfortable working independently

TECHNICAL SKILLS

Oracle DBA 11g/10g/9i/8i/7.3, SQL Server 2005, TOAD 10.0, Hummingbird Exceed, PL/SQL
CASE Tools : ERWin 7 / 7.3, Designer 2000
Operating System : Unix - Sun Solaris, IBM AIX 4.3, HP-UX 10.20, Windows 2000/NT/XP
ETL/Data Warehousing : Informatica PowerCenter 9.1, Cognos Powerplay 7.0, Cognos Reportnet and Cognos Impromptu 7.0, Business Objects 5.1
Application Development: PL/SQL, Oracle Forms, Oracle Reports, Developer2000, Pro*C, Unix Shell scripting
Middle Tier : Oracle Enterprise Manager (OEM), Oracle Application Server (OAS)
Version control : MS Team Foundation Server (TFS), PVCS Dimension and Visual Safe Source (VSS)
Products : Apsylog Asset Center, BANNER CIS, BANNER FMS

EDUCATION

Masters of Computer Applications (M.C.A.)

CERTIFICATION

• Oracle 10g Database Administration Certified Professional (OCP-DBA)
• Oracle 9i Database Administration Certified Professional (OCP-DBA)
• Brain Bench certified DBA 10g/9i/8i/8/7.3, Oracle Programmer, Oracle D2K Developer, Fundamentals of Data warehousing & Unix Shell scripting
• SCT certified BANNER CIS Professional
• Enlogix certified BANNER CIS Professional

PROFESSIONAL EXPERIENCE

Confidential, Sep-2011 to till date

Industry: State Government Projects
Position: Oracle DBA / Data warehouse Consultant
Environment: Oracle 10g/11g with RAC on Windows 2003/Linux, ER Win 7.3, Toad 10.6, Informatica 9.1 / OWB 11g

Responsibility:

• Responsible as Oracle DBA to maintenance ODS and Data warehouse databases for Department of Environment Protection (DEP) projects
• Responsible for logical data modeling, physical database design, and data dictionary maintenance
• Conduct maintenance, enhancements, and performance tuning activities for database
• Responsible as ETL Administrator/Analyst for Informatica and OWB
• Preparing Capacity plan for database growth
• Working as Support DBA for DEP Projects in size varies
• Doing Oracle Backend programming, developing stored Procedures, Functions, Packages and Triggers

Confidential,Industry: State Government Projects
Position: Sr. Oracle DBA
Environment: Oracle 10g/11g with RAC, SQL Server 2005, Windows XP/2000, ER Win 7.3, Toad 10, OpCon Batch processing, VSS, .NET 3.5 Framework, Webmethods,

Responsibility:

• Responsible as Oracle DBA to maintenance OLTP, ODS and Data warehouse databases for Department of Public Welfare (DPW) projects
• Working with stakeholder managements for reviewing & ensuring adherence to technical & coding standards.
• Preparing Quarterly Capacity plan for database growth
• Responsible for logical data modeling, physical database design, and data dictionary maintenance
• Schedules and monitors backups, generation of reports, and coordinates the migrations of database changes across environments
• Conduct maintenance, enhancements, and performance tuning activities for database
• Authors scripts to perform data fixes
• Assists application development staff as necessary
• Assist with load testing activities by setting up database counters to monitor backend performance
• Working as Support DBA for Child care Projects in size varies from 50 GB to 4.6 TB (average ~500 GB size)
• Doing Quality Assurance for PL/SQL code done by the team
• Doing Oracle Backend programming, developing stored Procedures, Functions, Packages and Triggers

Confidential, Aug-2002 to Jan-2007

Industry: Manufacturing (Asset Management) Duration: 4 year 5 months
Position : Oracle DBA/Project Lead Client: XEROX Inc. USA
Environment : Citrix Server, MS Windows XP, Sun OS 5.9
Tools : Oracle Databases 8i, 9i & 10g , Pro*C, SQL*Plus, SQL*Loader, Unix Shell scripts, PVCS Dimension, Microsoft Project, Hummingbird Exceed, TOAD

Responsibilities:

• Worked as Production Support DBA, programmer analyst and Project Coordinator for Asset Configuration Management (ACM) India team
• Responsible to implement securities, creating and maintaining privileges through roles, performance tuning, Query optimization, create/maintain plan for Back up and recovery with Disaster recovery plan
• Responsible to monitoring and taking appropriate actions for performance improvement, giving 24X7 On call Production Support
• Involving for requirement analysis, designing and development of the backend applications. Also, doing Unit testing, Integrated and system testing
• Doing Oracle Backend programming, developing stored Procedures, Functions, Packages and Triggers
• SME for Billing, Interface feeds and Ticket Management for ACM
• Doing project planning and scheduling, work allocation and resource management.
• Preparing reports and collecting matrixes for Management reports and presentation
• Doing the Internal Auditing for other projects and part of SCCB team for any release of the project.
• Adhering to CMMi Level V with respect to the project documentation and deliverables
• Projects resulted with high quality and on time delivery that benefit to client in terms of $amount, performance, accuracy, easy access and manual efforts

Industry: Asset Management Duration: 3 year and 5 months
Position : BO Administrator/ETL Developer Client: In-house EDS
Environment : Citrix Server, MS Windows XP, Sun OS 5.9
Tools : Oracle Databases 8i, 9i & 10g , Business Objects 5.1, Informatica Powercenter 6.1, SQL*Plus, SQL*Loader, Unix Shell scripts, PVCS Dimension, Microsoft Project, TOAD
Responsibilities:

• Worked in different data warehouse projects to design, develop Informatica ETL jobs and SQL*Loader control files to upload data in to different STAR and SNOWFLAKE schemas with Facts, Conformed Dimensions, and Slowly Changing Dimensions
• Designed and developed different Informatica mappings for Data Population through various sources such as Flat files, Relational tables, Excel Sheets into Oracle8i database based data warehouse Solution.
• Implemented materialized views to improve the queries performance against the aggregate data. Adhering to CMMi Level V with respect to the project documentation and deliverables
• Analyzed few Business Objects reports and Universes.
• Reverse engineered BO reports and documented them to understand the report functionalities.
• Proposed Universe and Database design changes to improve performance and quality of business objects reports
• Created Unix KORN shell programs using predefined template to automate the data loading process.
• Implemented Data Conversion strategy to convert data of 2 data marts on different datasets into a Dataset.
• Defined ETL job flows and Technical specification using Microsoft Visio and Word to ease the understanding of the data loading process
• Presented some core concepts about Data Warehouse and Business Objects to team as part of implementing in-house data warehouse project

Confidential, May-2001 to Aug-2002
Chennai, India

Industry: Utility Services (Banner CIS) Duration: 1 year and 3 months
Position : Technical Lead Client: Enlogix Inc., CANADA
Environment : Citrix, PC/LAN, MS Windows 2000, IBM AIX 4.3
Tools : Oracle8i Enterprise, Banner CIS, Oracle Forms/Reports, Pro*C, SQL*Plus, SQL*Loader, Unix Shell scripting, MS Visual Source Safe (VSS), TOAD, PuTTY

Responsibilities:

• Worked as an offshore coordinator, Technical Lead. Worked for Project Planning and Resource management
• Defined Process flow and standards for OnSite/Offshore Project with coordination of Vice president and On site Team (Toronto)
• Participated in all the phases of Development and implementation
• Configuration Controller (CC) for the Project and also participated as Functional Area Representative (FAR) during CMM assessment by KPMG. Adhering to CMM Level III with respect to the project documentation and deliverables.
• Performed requirements gathering, project estimate, resource plan, analysis, design, dimensional data modeling, development, testing and implementation of the project
• Involved extensively in Coding, Debugging and support. Developed Project Modules and maintained them. Done testing & releasing the product for production thru SCCB Board

Industry: Utility Services (Banner FMS) Duration: 6 months
Position : Technical Lead Client: Enlogix Inc. USA
Environment : Citrix, PC/LAN, MS Windows 2000, IBM AIX 4.3
Tools : Oracle8i Enterprise, Banner CIS, Oracle Forms/Reports, Pro*C, SQL*Plus, SQL*Loader, Unix Shell scripting, MS Visual Source Safe (VSS), TOAD, PuTTY

Responsibilities

• Worked as an offshore coordinator, Technical Lead. Worked for Project Planning and Resource management
• Defined Process flow and standards for Onsite/Offshore Project with coordination of Vice president and On site Team (Toronto)
• Involved extensively in Coding, Debugging and support. Developed Project Modules and maintained them. Done testing & releasing the product for production thru SCCB Board
• Projects resulted with high quality and on time delivery that benefit to client in terms of $amount, performance, accuracy, easy access and manual efforts