Sql Developer
Resume:
Veeranjaneyulu Daggubati
E-mail address:**************@*****.*** Mobile #: +1
SUMMARY
• Over 7+ years of experience in various phases of Software Development life cycle, including
Developing, Testing, Deploying and Troubleshooting using Oracle Technologies.
• Strong technical expertise on databases Oracle (11g/10g/9i/8i) on both Windows / UNIX
environments.
• Currently working in large Oracle database environments of approximately 1 4 Terabytes.
• Had good knowledge of migrating application code from 10 g to 11g.
• Currently working on edition enablement feature and near zero downtime.
• Experienced in working on both OLTP and OLAP environments.
• Proficient in Data warehousing technologies (ETL & Reports).
• Expertise in SQL, PL/SQL.
• Expert level skills in Oracle Development ( SQL scripts, Functions, Stored procedures,
Cursors, Triggers, Packages etc.)
• Extensively used the utilities like TOAD (9.6.1/9.1/8.5/7.4), SQL*Plus.
• Experienced in working with SQL*Loader, External Tables, Import, Export to extract and
load large volumes of data.
• Extensively involved in Performance tuning in oracle using Explain plan, SQL_Trace.
• Extensive knowledge of OBIEE, OWB
• Experienced in Extraction Transformation and Loading (ETL) processes.
• Worked on Production Support, attending production calls, troubleshooting the application
and resolving bugs.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to
interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Strong management, administrative and leadership skills to work in team.
TECHNICAL SKILLS
Databases Oracle 11g/10g/9i/8i, MS Access
Languages SQL, PL/SQL,C, JAVA
Database Utilities TOAD (9.6.1/9.1/8.5/7.4/7.1), SQL*Plus, SQL*Loader, Oracle Developer
2000(Forms, Reports)
Operating Systems Windows XP/NT/2007/2003/98/95, Linux, Unix
ETL Tools Informatica 8.1.1/7.1.,OWB
Scripting UNIX Shell Scripting, VB scripting
Version Control Tools IBM Rational Clear Case (7.x)
Reporting Tools OBIEE, BO
EDUCATION
• Master of Technology in Materials and Metallurgical Engineering, IIT Kanpur, India.
• B Tech in Metallurgical Engineering, NIT Warangal, India .
EXPERIENCE
Cisco Systems, RTP, NC Feb 2010 – Present
Cisco commerce workspace- Quoting
Sr Oracle PLSQL Developer
Description: Cisco Commerce Workspace is a web-based, streamlined qualification and
approval experience for Partner Initiated standard deals, contractual discounts, and pricing
letters. Cisco Commerce Workspace utilizes existing pricing functionality. The key business
objectives of Cisco Commerce Workspace is to improve the governance, management and
enforcement of qualification and approval experience for Partner Initiated-standard deals,
contractual discounts, and pricing letters and to increase the automation of the application of
these business rules, thus reducing operational costs and booking delays.
Responsibilities:
• Involved in interacting with the IT Analysts to gather Functional requirements.
• Define and represent Entities, Attributes as normal forms.
• Modeling the business requirements into logical and physical design of the database in
RDBMS environment.
• Generated SQL scripts to create and drop database objects including: Tables, views, Primary
Keys, Sequences and Synonyms.
• Responsible for creating Objects, enforcing the Constraints, Indexes, Triggers, Views.
• Implemented the statements to reduce the PL/SQL code using Oracle 11g/10g features.
• Create/maintain database Functions, Stored Procedures, Packages, Materialized Views,
Types etc for extracting data from different sources like SQL server, Flat files, Main Frames .
• Extensively worked on Cursors, Ref_cursors, Bulk Collects, Varrays etc.
• Ran the procedures using SQL*Loader to load data from flat files into the target database
tables.
• Responsible for performance tuning and Optimized SQL queries for better performance
using Explain Plan.
• Created Job schedulers using DBMS job schedule for generating defined intervals.
• Generated and sent the reports to business users for validation using Toad (9.6.1).
• Responsible for troubleshooting various aspects of the client/server architecture in both
UNIX and Oracle setting.
• Modified the existing reports (SQL queries/ views) to suit the new requirements.
• Part of migration the database from 10g to 11G to enables EDITION BASED.
Environment: Oracle (11g/10g), Toad 9.6.1.
Cisco Systems, Sanjose, USA
May 2009 – Jan 2010
My Bookings Reports
Oracle pl/sql developer
Description: My Bookings Reports provides the Bookings services to the field sales
organization. The E-Sales Portal Service provides “near-real-time” bookings update to the
field sales organization based on the most recent ERP activity of each individual’s customers,
territories or overlay responsibilities. Basically MyBookings is an Order Status
Reporting application providing Bookings,Non-Booked, Backlog and Revenue services to
both Direct and Overlay organization. Application also extended to provides a cockpit panel
display of his bookings, forecast, plan.The sales field user logon to the system and will look
at his daily and real-time order status.Order flows from ERP to CORE and then to CDW
where all the Bookings objects are published across Cisco. Data is then pulled into ODS
where we have all the reference data like customer, end user information. Adjustments
information is pulled from SCE, EIS into ODS, where both bookings and adjustments is
summarized and rolled up to CORP_REVENUE.Once the summarizations are completed in
ODS, data is pulled back into eSales DB for reporting for the client
.
Responsibilities:
• Define and represent Entities, Attributes and Joins between the entities.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables,
views, Primary Keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Implemented the statements to reduce the PL/SQL code using Oracle 10g features.
• Create/maintain database stored procedures, functions, packages, views, materialized
views, triggers.
• Worked with Exceptional handling, Ref_cursors, DBMS Package.
• Generate report using Toad (9.6.1) according to user requirement.
• Written PL/SQL stored procedures and functions for stored procedure transformation .
• Involved in designing of Unix Shell Scripting with the help of UNIX server.
• Created the Dollar Universe jobs for running daily population logics
• Support for the development, pre-production and the production databases.
• Responsible for performance tuning and Optimized SQL queries for better performance.
Environment: Oracle 9i/10g, Dollar Universe, SQL* plus,, SQL* loader, TOAD 9.6, Ms Access,
Excel (2003, 2007),
Cisco Systems, Sanjose, Usa Aug 2008 –May 2009
MBR Attach Rate
Oracle PL/SQL, Siebel Analytics Developer
Description:
My Business Reports (MBR) is a reporting tool used for strategic and tactical management of
CISCO's business. MBR is used by senior executives to get bookings/forecast
number from canned Siebel Reports. MBR presents critical data in a single source,
allowing senior management to track near real time performance MBR attach rate is to get the
AR in MBR portal along with bookings information which will help CA team to do
their business efficiently. This was a quick win / enhancement for My Business Reports
(MBR) application.
Responsibilities:
• Creating the Repository for Attach rate in lines with existing MBR repository
• Data Modeling for Attach rate
• Creation of new groups for Attach rate user in administrative console
• Worked in creation of new dashboards.
• Used java scripting for dynamic changes of reports according to user selection of details
• Created Dollar universe jobs for daily ETL refresh.
• Extensively used partitioning for improving performance
• Written PL/SQL stored procedures and functions for stored procedure transformation
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables,
views, Primary Keys, Indexes, Constraints, Packages, Sequences and Synonyms ..
• Performance tuning of the queries using optimizer hints and creating new indexes.
Environment: Oracle 10g/9i (SQL/PLSQL), Dollar Universe, Siebel analytics, UNIX.
Cisco Systems, Mumbai, India
Apr 2007 – Aug 2008
MBR Channels
Oracle PLSQL Developer
Description: My Business Reports (MBR) Channels is a reporting tool used for strategic and tactical
management of Cisco’s business numbers via partner’s route. MBR Channels is used by
senior executives to get bookings/forecast number of channel business from canned Siebel Reports.
MBR Channels presents critical data in a single source, allowing senior management to track near
real time performance of channel business. MBR channels provides the Channels bookings, revenue
and commit data at different hierarchies like geography, time and vertical market..
Responsibilities:
• Creating the Repository for MBR channels in lines with existing MBR repository
• Data Modeling ad defining the Business Model, Presentation layer and physical Layer
join and Mappings
• Creation of webgroups in administrative console
• Worked in creation of new dashboards.
• Used java scripting for dynamic changes of reports according to user selection of details
• Created Dollar universe jobs for daily ETL refresh.
• Extensively used partitioning for improving performance
• Written PL/SQL stored procedures and functions for stored procedure transformation
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables,
views, Primary Keys, Indexes, Constraints, Packages, Sequences and Synonyms ..
• Performance tuning of the queries using optimizer hints and creating new indexes.
Environment: Oracle 9i, Siebel analytics, Dollar universe
Cisco Systems, Mumbai, India Apr 2006 –Mar 2007
GSO Performance Dashboard Business Intelligence
OWB Developer
Description: The GSO Reporting Project is to provide the Business Reports for all the key metrics that define
the process and efficiency of Cisco Global Service Organization (GSO).The GSO reporting project includes
building a data ware house for the reporting data, extracting the data from source transaction systems,
transforming and loading the data to reporting data ware house. This also includes building the reports for
employee performance, vendor performance using Siebel Analytics reporting tool.
Responsibilities:
• Created and developed OWB Mappings and Map lets
• Created ETL source system to staging and staging to Data Mart tables.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables,
views, Primary Keys, Indexes, Constraints, Packages, Sequences and Synonyms ..
• Created the OWB Mapping Documents
• Developed and modified scripts to create tables, views and executed them using Sql*Plus.
Environment: Oracle 9i, OWB 9i, Siebel analytics, Dollar universe
Contact this candidate