Oracle Software
Resume:
PRAJOT BUDHBHATI
Toronto, on, M1L-1S1
Email: *******@*****.***
Objective:
An accomplished Oracle / SAS Database Administrator with SAS Application
skills and demonstrated success in designing and implementing database
solution that improve business functionality. Possess diversified technical
background with Enterprise System Solution. Proven ability to implement
technologies that decrease costs, increase performance and positively
affect the bottom line.
Education:
. Bachelor degree in Information Technology - York University TORONTO.
. Bachelor degree in Commerce (B-COM) - Osmania University, INDIA.
. Diploma in Information & System Management (DISM) - APTECH, INDIA.
. Oracle Certified Professional Oracle Database Administrator (Oracle
9i)
. Microsoft Certified Professional in Developing Applications Using
Visual Basic.
Summary of Qualifications:
. Familiarity and general knowledge of banking business process and
banking information systems.
. Knowledge of banks' Front-Office and Back-Office systems and
operations.
. Extensive experience working with all aspects of in-house developed
System.
. Polished leadership skills, with ability to motivate teams to increase
productivity.
. Expert in SAS EBI environment.
. Knowledge of AIX/WIN Operating systems.
. Documentation and communications skills.
Technical Skills
Languages: C, C++, Visual Basic, Perl, PL/SQL, COBOL, Windows NT 4.0
Server. Software: SAS 9.1 & 9.2 Intelligence
Platform, Oracle (9i), WebFocus, Unica Affenium Suite, SQL Server, Access,
Sybase and ETL tools like Informatica
Operating Systems Windows (95, 98, 2000, NT), UNIX, AIX, MS/DOS, Mac/OS.
Professional Experience:
Bank of Montreal (Bank of Canada) (Period: August-07 to till date)
Position Title: Team Lead / SAS Administrator.
. Provide strong technology leadership and create estimates and
solutions for walk-in Business Intelligence Requests from across the
enterprise (Business and Technology & Operations).
. Develop and obtain approval for detailed plans and resource estimates
for large-scale and complex technical architecture projects and/or
components of other projects with technical architecture elements.
. Reviewing and enhancing initial requirements to create estimates for
Intake Items.
. Monitor progress, resolve problems and reports regularly with
recommendations to I&IT management and clients decision makers.
. Participate in steering committees and other stakeholder forums as
needed to ensure business alignment.
. Lead and/or participate in highly sensitive technical architecture
investigations (eg. Examining hardware, software applications and data
where technical breaches require architecture review, analysis etc).
Provide professional opinions for inclusion in issues management
briefings etc.
. Validating design and communication with solution governance team to
ensure implemented solutions meet governance standards and
requirements.
. Current job duties include Installation, Configuration, Maintenance,
Technical Support and troubleshooting of SAS EBI (9.2) in a Unix
Server with windows web server for SAS Web components like Web Report
Studio, Information Delivery Portal with IBM Websphere and Xythos as
WebDAV Server.
. Working as SAS SME (Subject Matter Expert) for walk in delivery
projects established by BICoC and ensure team members adhere.
. Share my SAS expertise with my team and identify/implement and support
design framework for building technology consistent to Enterprise
Business.
. Developing Technical analysis, diagnosis and problem solving to
qualify product solution fit as per business needs.
. Giving presentations internally on SAS BI Platform. (Promoting BI
within the organization).
. Provide technical coaching to team members on SAS tools, development
process and improve team technical skills.
. Installing/Configuring/Maintenance of SAS EBI applications and
Websphere, Xythos and J2EE application servers.
. Using SAS Management Console to administer metadata.
. Creating users authentication/individual metadata identities and
groups.
. Strong Administration experience with Enterprise Guide, Enterprise
Miner, OLAP, Stored Process, Metadata Server, Web Report studio,
Information Delivery Portal, SAS/Connect, SAS Data Access, Websphere
and Xythos.
. Experience in applying upgrades, service packs, hot fixes, licenses
and performance monitor of AIX.
. Experience in providing user support and debug SAS programs.
. Experience and knowledge of AIX commands and shell scripts.
. Experience and knowledge of RDBMS ( Oracle, DB2, SQL Server )
. Developed and architect SAS and SPDS (Scalable Performance Database
Server) software, which reduced index build times by up to 90%, which
facilitated shrinkage of database maintenance windows to manageable
levels.
ING Direct (Bank of Canada) (Period: Feb-05 to July 2007)
Position Title: SAS 9.1.2 Intelligence Platform Administrator / Business
Intelligence Consultant.
. Provided logical and physical database design for SAS 9.1.3
application.
. Installing, Configuring and administered Oracle Database.
. Developed and architect SAS and SPDS (Scalable Performance Database
Server) software, which reduced index build times by up to 90%, which
facilitated shrinkage of database maintenance windows to manageable
levels.
. Performed Physical Design of Applications and Oracle/SPDS Database,
which allows stripping of a datasets over different mount points and
using multithreading technique and clustering of tables increased the
refresh of datasets speed by over 75%.
. Active member of Disaster Recovery Team. Participated in DRP test.
. Using Information Mapping tool to extract Data from Oracle 9.i tables
and export it to SAS SPDS database.
. Performed key role as technical consultant during transition from
Oracle 9i to SAS 9.1.3 Intelligence Platform. Recommended database,
development and network software that contributed to eliminating
redundant copy of database.
. Implemented design enhancements for major SPDS database and initial
release of Client Management System that substantially reduced load
times and enhanced reporting generation using applications like SAS
Enterprise Guide and Enterprise Miner.
. Performed upgrades, patches maintenance and integration with vendor
software on AIX and NT.
. Enhanced SPDS and SAS Metadata software that cut distributed
transaction processing by more than 70%, allowed Business users to
access huge volumes of datasets in a time and speed efficient manner.
. Provided on-call support for database related problems on a rotation
basis.
. Documentation of server application, database application, workstation
application and security policies in force.
. Perform code reviews to link Oracle Database with other software like
TIDAL, Service Desk and monitoring software likes Solarwinds.
Client Logic (Toronto) Period: July-00 to Jan-05.
Position Title: Oracle 9.1 Database Administrator.
. Performed code reviews to ensure for proper design, standard, content
and functionality monitoring of servers, databases and workstations to
ensure availability and efficiency database capacity and utilization
planning archiving and backup planning.
. Accomplished successful migration of Oracle8.i database to Oracle9i.
. Involved in Schema design and developing mappings designed documents
using INFORMATICA.
. Role was to EXTACT the data received in the form of flat files /tables
in oracle database, TRANSFORM the data according to the requirement
using the informatica, power center designer and to LOAD the data in
the other database with the help of running sessions and
batches.(Server Manager).
. Extensively used Informatica to load data from Oracle database and
Flat files to Oracle Database.
. Worked on Informatica tool-Power Analyzer, Data warehousing designer,
Mapping Designer Mapplet, and Transformations.
. Involved in the development of Informatica mappings and also tuned
for better performance.
Contact this candidate