Project Oracle
Resume:
BHANU THIRUMURTHY
*****.***********@*****.***
SUMMARY
. Around 12 years of IT experience in full project life cycle,
requirement study, Analysis, Design, Review, Development,
Implementation of various applications and also Database Design,
Development and Administration across different platforms.
. Oracle consultant with extensive PL/SQL development experience with
Database Management, Data Warehousing and Data Modeling knowledge.
. Strong leadership abilities with good technical and management skills
. Fast adaptation to the new technologies and environments, strong
analytical and problem solving skills
. Exposure to ETL/OLAP Tools and a few other Microsoft Development
Products.
STRENGTHS:
. Proven experience with DB Management/PL/SQL/ Data Modeling/Entity
Relationship Modeling/Data Warehousing and Design
. Proven experience developing PL/SQL for large scale software
applications
. Ability to process complex business requirements and develop a stable,
scalable, and efficient architecture to support those requirements
. Strong written and oral communication skills.
. A thorough understanding of system development life cycle processes
. Strong analytical and problem solving skills.
. Experience with data warehouse projects.
. Ability to plan and manage in a rapidly changing environment.
. A self-starter who can take ownership and lead projects
. Team player with high energy-can do attitude
. Strong focus on results and quality. Consistent delivery and
responsiveness
Career aspiration(s)/goal(s):
. Work in more challenging Technical lead/Managerial roles.
. Develop & Enhance project management skills.
. Working on Project Management Certification. ( soon to be PMP
certified)
TECHNICAL SKILLS
Oracle Database Management, Forms, Reports and Database Customization,
Installation, Applications Integration, Software installation and upgrade,
Database Design and Build, User Documentation, Technical Architecture,
Entity Relation Modeling, Project management, Data Warehousing, Oracle
performance tuning proficiency, Backup and Restore of Database, Writing SQL
& PL/SQL scripts, User maintenance and security.
Databases: Oracle Database, SQL Server 2000, MS-Access
Oracle Products: Oracle Forms, Report, SQL*Plus, PL/SQL, SQL*Loader, Oracle
Enterprise Manager, Oracle Migration Workbench, RMAN,
tkprof, DBverify, Logminer, Export / Import, Direct-Load
Insert (SQL), SQL Developer
SQL Products: SQL Enterprise Manager, SQL Query Analyzer
ETL/Reporting Tools Oracle Warehouse Builder, Oracle Discoverer, BO,
Informatica,
Crystal Reports, Datastage
Languages: SQL, PL/SQL, Java, C/C++
Operating Systems: MS-DOS, Windows, Linux
Others: Visual Basic, ASP, (D) HTML, VBScript, JScript,
DreamWeaver, Visio, TOAD, SQL Navigator, Win CVS, SVN,
Mercury Quality center, Unicenter
WORK EXPERIENCE
Client: Barclaycard US, Wilmington, DE
Mar '08 - till date
Role : Sr. Oracle Consultant
Barclaycard is a division of Barclays PLC, a major global financial service
provider engaged in retail and commercial banking, credit cards, investment
banking, wealth management and investment management services. Barclaycard
US creates customized co-branded credit card programs for some of the
country's most successful travel, entertainment, retail and financial
institutions
Primary role and responsibilities:
. Perform analysis, SQL scripting, tuning and optimization (schema and
SQL) on large databases and addressing data quality issues.
. Develop data access and data load processes for storing and retrieving
data from relational databases and other file systems.
. Responsible for Oracle PL/SQL development, develop PL/SQL scripts for
complex business requirements by participating in the full systems
development life cycle and is responsible for designing, coding,
testing, implementing, documentation, release co-ordination
maintaining and supporting applications software.
. Assist the development staff with complex SQL. Database programming
using PL/SQL and standard built-in Oracle Packages including
collections. Development of PL/SQL Stored Procedures, Functions,
Triggers and Packages
. Built/developed various modularized Oracle APIs that serve as tools to
manage Privileges and Security, Data Purging and Partition management
in the organization
. Perform Modeling/Schema design. Participate in establishing standards
and methods for all Data Warehouse coding. Support Data Warehouse
systems as well as design them
. Create SQL scripts to repair client data and/or fulfill client data
modification requests
. Job Scheduling using Oracle DB console.
. Participate in creating and enforcing Database Development Standards,
Architectural Standards and Processes (Coding, Naming, Data Access,
Security and Documentation) and in defining Data Archive/Purge
Standards.
. Involved in documentation of various aspects (Technical, Component.
Reference and User guides)
. Provide a specialist skill or support role to investigate incidents
received from help desk and coordinate resolution and recovery actions
for assigned incidents
. Actively participated as Implementation, Change and Release
coordinator.
. Ensure compliance with Information Security requirements.
Environment: Oracle Database 10g, Windows XP/Unix, TOAD, SQL Navigator,
WinCVS ( version control system), ERWIN, Mercury Quality Center, Datastage,
Visio, Control-M job scheduler, Unicenter
Client: Albridge Solutions, Lawrenceville, NJ
Jul'07- Jan '08
Role : Sr. Oracle Consultant
This is a leading provider of enterprise data management (EDM) and web-
based portfolio accounting and performance reporting solutions to the
financial services industry.
Albridge consolidates client account data from hundreds of disparate
sources - proprietary, banking, brokerage, insurance, retirement,
alternatives, trusts, etc. - making it the industry's most scalable and
reliable enterprise wealth management solution
Responsibilities:
. To design & develop database scripts and stored procedures for Core
pricing and Fixed Income assets of Wealth Reporting System.
. Writing database procedures, functions, packages and triggers.
. Create/modify /debug PL/SQL stored procedures
. Involved in deployment and build process of Oracle scripts (DDL, DML,
Packages etc)
in various environments ( Integration, Test and Production).
. PL/SQL performance tuning
. Do unit testing of stored procedures developed
. Co-ordinate with front end and QA teams
Environment: Oracle database 10g, Windows XP/Unix, TOAD, SVN Tortoise
Client: NYPA, Whiteplains, NY
Dec'06 - May'07
Role : Project Lead
The New York Power Authority is the nation's largest state-owned power
organization and one of New York's leading electricity suppliers.
The Short Term Load Forecasting System(STLF) was developed to produce a
statistically based short-term (10 day) load forecast to predict customer
loads which is forwarded to the NYISO. It does this by developing account
level bottom-up forecasts built from models based on electronic billing
data, interval meter data and weather data. The goal of the system is to
reduce forecast error and minimize financial exposure in the real time
energy market.
The software which performs these operations is called Energy Vision
Enterprise
(EVE). The reports themselves are written in the Hyperion Brio reporting
tool and access Oracle tables. The Authority wanted these 24 reports to be
rewritten in the Crystal reporting tool.
Responsibilities:
. Assist in requirement gathering and analysis.
. Provide support in off-site environment set up.
. Visit client on-site for meetings, requirement gatherings, project
concerns and keep the PM and the team posted with the proceedings.
. Lead and co-ordinate development and QA teams.
. Document all development work done.
. Escalate any issues or any other development that hampers project work
to Project Manager without delay and with as much details as possible.
. Co-ordinate between client and the team.
. Analyze the existing Brio reports and the SQL queries/stored
procedures in the reports.
. Compose requirement docs and design docs to the team.
. Provide Oracle Queries, stored procedures and database support.
. Integration and implementation of the project on Test and Prod
systems.
Environment: Windows XP, Oracle 10g Database, .NET, Hyperion Brio, Crystal
Reports, TOAD.
Alliance Global Consulting
Role: Sr. Consultant
Client: Dun and Bradstreet, Short Hills, NJ
Jun'06 - - Nov'06
World's leading provider of business information, enabling business-to-
business commerce for over 160 years. Project involves complete migration
of existing ASP web application to JAVA e-commerce platform.
Responsibilities:
. Lead and manage technical team for the strategic development and
implementation of Oracle systems.
. Installation, Configuration & Management of Oracle Server, clients and
customizing the database to meet the requirements of the customers.
. Installation & Upgrading of the Oracle Server Software on various
platforms
. Creation and Maintenance of Oracle Instances, Databases, Schema and
Objects across Development.
. Map Data Structures in the source and destination Databases.
. Generate Design Document for Data Migration between different data
sources.
. Responsible for analyzing, designing and developing ETL strategies and
processes
. Writing ETL specifications for developer, ETL development,
administration and mentoring.
. Design and development of ETL process load data from SQL Server into
the target Oracle database.
. Writing SQL & PL/SQL scripts.
. Writing database procedures and functions to use for Reports.
. Controlling & monitoring user access to the database.
. Migration of Database from MS SQL Server 2000 to Oracle.
. Creation, Maintenance and Run Oracle Scripts.
. Participated in developing client outreach strategies and their
implementation.
. Preparation of all technical documents as per client requirements like
SRS.
. Monitoring the progress of the project & ensure adherence to SRS &
stated schedules.
. Ensure successful delivery of products to agreed scope, quality &
budget.
. Required to articulate the technical direction & educate the team.
. Performed reviews of intermediate and final products, including
reports, databases, information materials, and other related.
. Entity Relation Data Model diagrams.
. Technical Documentation.
Environment: Windows XP, RH Linux, Java, J2EE, WebSphere Commerce Server,
Oracle 10g Database, TOAD, SQL Developer.
Client: Shawmudge & Company (SMCO), Shelton, CT -
Feb'06 - May'06
SMCO is the manufacturer and distributor of soap and candle wax
fragrances. The Enterprise manages its complete resources through Oracle
Applications. This Project involves providing Database Support for PROD
and TEST instances and building Reports to support their business needs.
Responsibilities:
. -Review Performance and Health of the system,
. -Review disk space logs, instance health etc.
. -Restart any services etc as necessary.
. -Monitor table space.
. -Backup and Restore of Database
. -Verify that the refresh happened successfully and that the instance
is up and running
. -Rebuild indexes occasionally
. -Database performance tuning - analysis and execution
. -Design and development of Reports for the same (Materials, Orders,
Invoices, Shopping)
. -Fixes or changes or investigation of data for Oracle Reports built
by Fusion.
. -Review patches from Oracle and the schedule updates of emergency
patches (every 6 months or so)
Environment: Windows 2000 Server, Oracle Apps 11.5.8, PL/SQL, SQL*Plus,
Oracle Reports Builder, TOAD 7.6
Client: Fatwire, Mineola, NJ.
Nov'05 - Jan'06
Fatwire Software is a leading provider of dynamic content management and
dynamic Web application assembly software. FatWire is recognized as one
of the most innovative, visionary and fastest growing software companies
in the United States.
Responsibilities:
. Installation and configuration of Oracle Database on different
platforms.
Creation and Maintenance of Oracle Instances, Databases, Schema and
Objects across Development.
. Responsible for Performance tuning of Database.
. Analyze and troubleshoot Database issues.
. Import and export Database.
. Create/modify /debug PL/SQL procedures
. Writing database procedures, functions, packages and triggers.
. Help developers with database related queries, user creation,
maintenance and security.
Environment: Oracle database 9i/10g, Windows 2000 server/Windows XP/Linux,
TOAD
Client: Thomson, Scottsdale, AZ -
Aug'05 - Oct'05
A leading global provider of integrated information-based solutions to
business and professional customers. Project involves development of
reports to their client Financial Campus, which is the leading provider
of online continuing education and firm element training to the financial
services industry.
Responsibilities:
. Analysis & Spec gathering to develop reports.
. Develop reports using Jasper soft product.
. Design custom reports that populate data from multiple data sources
(Oracle and SQL Server databases)
. Deliver reports as .xml files that may be used on their existing
portals. They also use them as templates in their data migration
process across multiple Databases.
Enviroment: Oracle DB, MS-SQL DB, Jasper Decisions, Tomcat 5,Jasper
Reports, iReports,
Client: SCVB, Syracuse, NY
Mar'05 - Jul'05
SCVB (Syracuse Convention and Visitors Bureau) aims to strengthen the
positive awareness of the City of Syracuse and Onondaga County as a
convention and visitor destination, to increase revenues and stimulate
economic development and growth for the community. Project involves
development, enhancement and maintenance of their official website.
www.visitsyracuse.org
Responsibilities:
Debug code in the ASP pages, write functions in VB scripts and Java scripts
to incorporate validations on the web pages, troubleshoot Database issues,
create or update Stored Procedures in the Database, create new database
instances or move data from old instances to new.
Environment: SQL Server 2000,SQLEM, SQLQA, ASP, (D)HTML, Dream weaver,
Globescape CuteFTP, ASP Enterprise Manager.
Anthesis Technologies Pvt. Ltd. (Sr. Software Engineer)
Aug'02-Jan'05
Client: AnB Naturals, Bangalore, India
The client is a major food, beverage and packing company maintaining a
Sales and Marketing Data Mart. The scope of this project is to capture
sales and marketing process and data in the warehouse to generate reports.
Responsibilities:
. Designing of Database based on System requirement.
. Design and develop necessary DB objects to meet the requirement of
the system with increased efficiency.
. Create different type of reports including: Cross-tab, Conditional,
Drill-down, Top N, Summary, Form, OLAP and sub-reports
. Create reports include formatting options such as Charting,
Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-
down, Parameter prompts.
. Oracle Backend programming (PL*SQL, SQL) to create views and stored
procedures to be used in the reports.
. Provided User support and training to others users to design
reports.
. Data transferring/ Loading
. Back-end programming using SQL and PL/SQL including Tuning
Environment: Windows 2k, Oracle9i, PL/SQL, SQL*Plus, TOAD. Oracle
Discoverer
WebYoga Inc., Dayton, OH (Software Engineer)
Sep'00 -Jul'01
Client: Cole Layer Trumble, Dayton, OH, US
This is a Dayton-based provider of appraisal software and service to
governments, now acquired by Tyler Technologies Inc.
Integrated Assessment System (IAS), provides an on-line, real-time system
using relational database technology and 4GL reporting capabilities. IAS
integrates computer-assisted mass appraisal, real estate assessment
administration, basic assessment administration, soil management, homestead
exemption information, special assessments, tax calculation, tax billing
and collection, tax settlement and distribution, estate taxes, and
delinquent tax management.
A futuristic approach to a modern-day dilemma that is the Company has
designed with the Integrated Assessment System (IAS). IAS was designed for
producing real property values, tax rolls/statements and related reports
required to administer the assessment and collection processes.
Responsibilities:
. Involved in debugging & development of various stored procedures.
. Involved in code reviews along with other programmers.
. Interact with the clients and work with their applications using PC-
Anywhere and resolve application bugs and performance issues, if any
. Enhancements to Front-end screens.
. Design & development of new user interface screens (forms) & reports
(oracle reports & SQL reports).
. Involved in testing and debugging of certain modules.
. Involved in the maintenance of the project.
Environment : Windows NT 4.0, Oracle8i, PLSQL, SQL*Plus, Developer 2000.
ZANTEL, Zanzibar, Tanzania, E. Africa (Sr. Programmer/Analyst)
Jul'99 - Jun'00
ZANTEL, Zanzibar Telecom Pvt Ltd
A Telecom company developed a financial integration product for in-house
implementation. The product comprised of various modules like Fixed Asset
system, Store Inventory, Purchases, Payroll and Customer Management System.
Responsibilities:
. Requirements gathering and documentation.
. Analysis of the project specifications & business workflow.
. Prototype development.
. Develop programming standards & documentation standards.
. Designing and developing interactive automated front-end screens.
. Designing and programming appication modules.
. Error handling with user friendly alerts and error messages.
. Development and debugging of various stored procedures & functions.
. Do code reviews along with other programmers.
. Involved in testing and debugging of the project.
. Designing up-graded screens to suffice on-line Inquiries by the higher
Management.
. Develop complex trend reports (screen reports with SQL, report
builder, graphs & comparison charts).
. Provided reports, custom modifications, data import and export &
troubleshooting.
. Training the users with various aspects & easy handling of the
project.
. Involved in maintenance of the project.
. User-acceptance testing.
. Training users with various aspects of the project.
. User education and support.
Environment: Windows NT 4.0. Oracle8.0.4, PLSQL 8.0.4, SQL*Plus,
Developer 2000
A & T InfoTech Pvt. Ltd., Hyderabad, India (Programmer)
Sembawang Resources, Singapore
Sep'98 - Mar'99
The project was developed to fob watch at the performance of a drilling
machine. System provides the online output of the depth covered, fuel
effectiveness, Land resistance etc. Input values are taken from a
mechanical device to generate graphs. Attributes for a particular concept
are recorded and displayed online to support the mechanical functioning.
Responsibilities:
. Design and develop application user interface.
. Designing, development & coding of various modules.
. Developing user interactive messages, alerts and error trapping.
. Designing necessary graphs for graphical data representation and also
generating current-to-date reports using Crystal reports.
. Handled testing & debugging of the project.
. Maintenance of the project.
Environment: Windows NT 4.0, Oracle 7.3, Visual Basic 5.0, Crystal Reports.
Sugar Plant Management Oct'97 -
Aug'98
This project was developed for a co-operative sugar factory. The system
caters to the needs of Prediction, monitoring, farmer credit management and
accounting. Also manages to maintain the forecast for buying raw materials.
Byproduct management is also maintained.
Responsibilities:
. Design and develop application user interface.
. Designing, development & coding of various modules.
. Testing & debugging.
. Maintenance of the project.
. Documentation.
Environment: Windows NT 4.0, Oracle 7.3, Visual Basic 5.0.
EDUCATION
. Master of Science, Osmania University, India.
. Master's Diploma in Computer Applications.
CERTIFICATION
. Certified Lotus Specialist (Lotus Notes).
. Certificate Course in ASP 3.0.
TRAINING
Oracle Database Management and Data Warehousing.
Contact this candidate