SUMMARY

Bright candidate with experience of Oracle, Sybase, DB2 and SQL server developer and DBA in most phases seeks challenging computer position with opportunities where proven skills and talents in computer applications programming and database system development will be mutual benefit.

TECHNICAL SKILLS

• Pascal & Fortran VAX/VMS Oracle 7.3/8.0/8.16/9 i/10g
• C/C++
• SAS MS DOS Oracle Web Developer
• COBOL
• Perl Windows 2000
• XP Sybase
• PeopleSoft
• Visual Basic
• SQL UNIX Cold Fusion
• JAVA
• HTML
• XML SQL Server 20000 ERWIN
• DB2

PROFESSIONAL EXPERIENCE

Developer/DBA/ Database Administrator

Confidential, NY

Responsibilities:

• Install & configure Oracle 9i and 10G on UNIX HP and Windows platform
• Execute diagnostics periodically to guarantee database integrity
• Formulate plan for database implementation/conversion strategy
• Monitors databases on a daily basis
• Develop and design SQL, PL/SQL, designing function, stored procedure, trigger and package.
• Write PL/SQL, SQL using Toad tool.
• Provide on - call support for database.
• Perform data modeling using ERWIN.
• Supporting or deploying large scale Oracle Applications 11i environments and Global single instance experience.
• Work on Discoverer Administrator, Plus & Viewer (9i and 10g).
• Work on XML, XML Publisher.
• Use Oracle Toad, Reports & Forms, Portal.
• Take responsibility for architecting the Oracle 10g Business Intelligence platform to support reporting and analytical requirements, designing OLAP solutions, creating reports, ad hoc queries and dashboard environments.
• Create, maintain, and enhance complex Data Warehousing and OLAP reports.
• Support production database in 24 X 7 environment.
• Using snapshots to perform distributed database data replication
• Create and configure advanced replication sever. Implement data replication in high transaction environment.
• Configure Oracle Logminer and Flashback.
• Implement Oracle Data Guard, configure physical standby and logical standby.
• Using SQL loader to transform the data
• Work on Storage Area Network:( SAN) and Network Attached Storage (NAS).
• Backup, recovery and tuning oracle database
• Install, configure and use Oracle Enterprise Manager (OEM).
• Make installation and configuration Oracle Real Application Cluster (RAC) 9I and 10g
• Perform RAC administration and management
• Perform RAC troubleshooting.
• Coordinate development and installation of database technology with the Apps DBA.
• Interact with Apps DBA, Development and Infrastructure teams.
• Work as Apps DBA.
• Support user global wise

Confidential, Middle Town, NJ

Database Administrator

Responsibilities:

• Design, develop, and implement of complex physical Oracle databases across multiple platforms, technologies and computing environments.
• Take responsibility of monitoring performance, tuning for optimization, planning system capacity consulting on information architecture, implementing support and management tools and generating project status reports.
• Work as Sr. Data Architect experienced in developing data components with a strong grasp of data integration issues, treatment of reference data
• Establish technical components for an enterprise data warehouse handling large volumes of data.
• Implementing Cognos, database and web services.
• Provide solution from a performance, sizing, availability, backup/recovery, and security considerations.
• Interact with client senior systems folks and database administrators.
• Coordinate activities across data analysts, data modelers, and DBAs.
• Perform overall database design, and physical and logical data modeling in a large-scale data warehouse.
• Lead various data integration efforts and ensure compliance with overall enterprise data strategy and standards; maintaining the standards; Leading the development of Data warehouse metadata repository.
• Designing and implementing a optimized data architecture; database modeling; SQL query and store procedure development
• Write PL/SQL, SQl using Toad tool.
• Use ETL, time series data management and retention.
• Designing, developing and implementing data warehouses using Informatica PowerCenter 6.2
• Designing and coding end-to-end ETL solutions relating to data warehouse development
• Use tools such as Oracle Warehouse Builder V10.2, NSF Gateway Coalition, ERWIN, Prism, Sagent and Apertus to do data warehouse designing.
• Provide assistance to other developers in the delivery of warehouse solutions to meet the needs of multiple customer groups
• Work closely with Project & Development Managers to ensure overall project timelines are met or exceeded
• Create and contribute to project documentation and deployment activities
• Create and maintain Sybase database on Sybase system 11.9.2,12.0,12.5
• Manage Sybase database server
• Installing Sybase on UNIX and Windows NT server.
• Perform 24 x 7 support of applications/ Sybase interface and performance including pager duty
• Installation planning in conjunction with development and application administration management
• Using the Performance Options of Sybase’s ODBC Driver.
• Testing a connection through ODC to Sybase.
• Performing Sybase application partitioning.
• Installing and configuring Sybase Replication Server 11.5,12.0,12.5
• Using DBCC with Sybase SQL Server Manager.
• Write Transact-SQL programming
• Using Sybase SQL Server Manager to Create a procedure.
• Perform application partitioning.
• Using the configure Sybase servers Utility.
• Configure Sybase replication server
• Configure Veritas Clustering
• Work on AutoSys to support applications
• Create comprehensive reports using SQR, Sydperl/Report Writer.
• Write and modify Crystal Report

Developer/DBA

Confidential, New York, NY

Responsibilities:

• Act as project leader for designing application, building application, testing the application, deploying the application and maintaining the application. Coordinate With programmer and business analysts.
• Design data warehousing database create snowflake schema and star schema for data warehousing
• Develop and design SQL, PL/SQL, designing function, stored procedure, trigger and package.
• Developing PL/SQL libraries
• Write PL/SQL, SQl using Toad tool.
• Designs, develops and enhances Oracle database and applications. developer2000, PL/SQL, reports and forms designing.
• Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources
• Generates academic reports using Oracle Reports Developer 9i
• Provides guidance on creating an oracle Data Warehouse
• Use tools NSF Gateway Coalition, ERWIN, Apertus and Oracle Warehouse Builder V10.2 to do data warehouse designing
• Generates, upgrades and converts Oracle Forms 5 and Oracle Forms Developer 9i
• Work on Oracle Discover
• Design text indexing and search.
• Develop a search and retrieval application using RDBMS with text document data.
• Migrate a MS access database to an oracle database using Oracle migration tool for MS Access
• Establishes procedures and Graphical User Interface(GUI) standards to be used for Software development and testing.
• Creating and maintaining Oracle database in development, test and production environments Using Oracle 8I and 9i.
• Develop and maintain multiple Oracle database in development, test and production environments Using Oracle 8.05, Oracle 8.16 and Oracle 9i.
• Install & configure Oracle 8I and 9i on UNIX platform
• Install & configure Oracle 8i and 9I, NT /windows 2000 and Windows XP platform.
• Work on and configure Oracle9iAS: Build and deploy J2EE, web Services and internet Applications, extract Business Intelligence, Integrate Users, Applications and Business, Manage and Secure Web Infrastructure.
• Configure Oracle9iAS Reports Services, deploy reports in Oracle9iAS Reports Services.
• Configure Oracle 9i webserver.
• Install, configure and work on Oracle Designer 2000.
• Performance backup and recovery.
• Do performance tuning.
• Configure and setup standby database.
• Design a project using JAVA programming to trace the online trading of mutual fund and stock.
• Work on J developer on 9i using Oracle Portal.
• Develop EJB Session Beans.
• Creating classes and applications in JAVA.
• Design JSP application.
• Develop Applets.
• Designing project using JDBC.
• Design Real Time Stock Portfolio Tracking System., using Interface Design with AWT and Interface Design with Swing.
• Perform JAVA event handling, Perform GUIs in the Stock Portfolio Tracking project, such as stock table, stock price. etc.
• Perform JAVA project assembly and debugging.
• Using JAVA Enabled Web Server Setup.
• Using JAVA Servlet.
• Design JAVA Beans.
• Using JAVA Server Pages
• Design and develop J2EE applications.
• Write C/C++ programming.
• Using XML with SQL Server 2000.
• As part of team of Web developer, design HTML, DHTML, XML, ASP,Weblogic.
• Write JAVA Script.
• Write VB Script.
• Participate in developing a comprehensive financing software application using VB 6.0
• Design and develop an inventory control system for the company using VB 6.0
• Using RDO, ODBC and OLE technologies in window NT
• Participate in designing and developing company’s intranet using Microsoft Front Page, HTML, VB Script, ActiveX, Active Server Pages, ADO, InterDev 1.0 and SQL 6.5
• Develop and implement a customer information and invoice tracking system for the company, using visual basic 4.0 DAO and access 2.0
• Design and develop C program
• Implement and design Pro*C applications.
• Perform logical and physical table and database design
• Perform data modeling using EWRIN.
• Support production database in 24 X 7 environment.
• Design and develop Oracle financial applications using Oracle Financial 10 and 11 package.
• Install Oracle patches.
• Migration from Oracle 8i to Oracle 9i, upgrading Oracle from 8.0 to 8i.
• Oracle Web designing, using Cold Fusion software and through Oracle Web server.
• Perform problem resolution in support of customers
• Execute day to day DBA duties in multi-instance production and development environments
• Write UNIX shell scripts, including Korn shell and C shell programming.
• Write AWK, Nawk, Gwak scripting language in SVR4.
• Develop T-SQL programming
• Maintain SQL server 7.0 and SQL server 2000, backup and tuning SQL server, perform technical support.
• Install and configure PeopleSoft
• Maintain and tuning PeopleSoft, Training users to use PeopleSoft.
• Installing Perl on a Unix system.Installing Perl for windows.
• Write report using Cognos
• Using different debuggers to debug Perl.
• Using Perl modules from CPAN (Comprehensive Perl Archive Network)
• Importing Modules, symbols and Tags in Perl.
• Creating and using subroutines.
• Working with files and I/O in Perl.

Database Administrator/Developer

Confidential, New York, NY

Responsibilities:

• Installed Oracle 8.0.5 in NT and UNX platform
• Creating and designing Oracle database using Oracle 7.3 and Oracle 8.05
• Create Oracle objects such as tablespaces, tables, indexes, views and user accounts following defined standards and scripting procedures.
• Perform problem resolution in support of customers
• Installing and upgrading the Oracle 7 server and application tools.
• Installing and upgrading the RDBMS and work with Oracle networking configurations.
• Creating primary database storage structures.
• Allocating system storage and planning future storage requirements for the database system
• Modifying the database
• Using snapshots to perform distributed database data replication
• Controlling and monitoring user access to the database
• Backing up and recovering database.
• Maintaining system security
• Optimizing database performance.
• Writing UNIX scripts
• Design and maintain Sybase database, perform backup and recovery, do performance tuning
• Developed and designed JAVA program.
• Served as SQL Server 6.5 administrator.
• Installed SQL server 6.5, backup and tune the SQL sever database.
• Maintaining and tuning PeopleSoft.
• Maintained DB2 database to support COBOl programming, designed COBOL project.
• Develop Sybase applications.
• Create and maintain Sybase database
• Installing Sybase on UNIX and Windows NT server.
• Using the Performance Options of Sybase’s ODBC Driver.
• Testing a connection through ODC to sybase.
• Performing Sybase application partitioning.
• Installing Sybase Replication Server
• Using DBCC with Sybase SQL Server Manager.

Confidential, Boston, MA

Financial Analyst

Responsibilities:

• Analysis insurance, mutual fund, and a variety of investments.
• Conducted stock research and updated various transactions.
• Contacted potential clients and assisted in establishing a client base
• Implemented procedures for the organizations of the client holdings.