Sales Sql
Resume:
PROFESSIONAL SUMMARY:
Satish Konda is a talented Developer with over 6 years of experience in
analysis, design, Application Development and production support using
Oracle SQL, PL/SQL, and Developer Forms and Reports.
. 6 years experience with PL/SQL Developing with Oracle Performance Tuning
on a daily basis.
. Strong working knowledge of Oracle SQL, PL/SQL, .net and Java.
. Proficient in writing Packages, Stored Procedures, Cursors, Functions,
Views and Database Triggers using SQL and PL/SQL in Oracle.
. Designed front end for a web based application using Java, JSP.
. Created XML pages that allowed for selections of dynamically created
checkboxes separately, as a group, or within subgroup.
. Good understanding of applications based on java and .net.
TECHNICAL SKILLS:
Languages: SQL, PL/SQL, C, Java, ASP, JavaScript, JSP, XML, HTML
Databases: Oracle 9i/10g, DB2, MS SQL Server 20005/2000
Operating Systems: Windows 98/2000/XP, UNIX
Packages: MS Office (Word, Excel, Access, PowerPoint, Visio), Erwin
Reporting Tools: Business Objects, Crystal Reports, Oracle Reports
6i/9i
GUI: Developer 2000, Forms 6i/9i
Other Tools: SQL*Loader, SQL*PLUS
EDUCATION:
Bachelors in Computer Science O.U (India)
PROFESSIONAL EXPERIENCE:
HealthPort, GA
1/2009-
Current
Oracle PL/SQL Developer
. Coordinate with the front end design team to provide them with the
necessary stored procedures and packages and the necessary insight
into the data
. Successfully manipulated Stored Procedures, Functions and Packages
using TOAD.
. Involved in the creation of database objects like tables, views,
stored procedures, functions, packages, DB triggers, Indexes and
Collections.
. Created and used Table Partitions to further improve the performance
while using tables containing large number of columns and rows.
. Involved in formulating general methodologies, naming conventions and
coding standards for various procedures and packages.
. Involved in the Modifications and development of databases and tables
to support
New inventory changes.
. Attended Sales meetings to brain storm report ideas to help push
sales.
. Created indexes on tables and Optimizing Stored Procedure queries.
. Designed reports that had complex SQL, PL/SQL code and stored the
procedures.
. Worked on Oracle Portal to develop reports as per the requirement.
. Created forms based on procedure in oracle application server portal
. Worked on UNIX shell scripts to handle the files.
. Interacting with applications running on Java and utilizing Java and
JSP.
Environment: Oracle 10g, UNIX, Developer Suite (Forms 10g, Reports 10g),
PL/SQL, UNIX Shell Scripting
Zebra Technologies, Chicago, IL
3/2008- 12/2008
Oracle PL/SQL Developer
. Expanded the complexity of Packages and Stored Procedures; sometimes
having to be writing these Packages.
. Skilled in understanding the Business Rules and effectively
implementing them into Business Process flow.
. Analyzed Oracle data using SQL scripts.
. Support the Business team to resolve the data issues and business
clarifications.
. Converting business requirements into technical specifications, and
detailed mapping documents.
. Created PL/SQL procedures as of the requirements.
. Developed several back-end Packages, Procedures, Functions and
Triggers to use in multiple Forms and series of other backend programs
using PL/SQL.
. Programmed Shell Scripts to retrieve third party data into stage
tables for insertion into our databases.
. Involved in the Design and Development of Sales Reports using
Reports9i
. Developed Reports that would produce ratios for sold items in
different categories for each store location and individual employee.
. Developed and scheduled Perl scripts.
. Worked on UNIX shell scripts to handle the files.
. Trouble shooting Problems by using SQL server profiler.
. Created scripts to migrate the data from Sybase to Oracle database.
. Created Staging table scripts, SQL Loader control files.
Environment: ORACLE 10g, SQL*Plus, PL/SQL, SQL*Loader, Oracle 10g Forms &
Reports, DB2, Export/Import, TOAD, SQL Navigator, ERWIN, Oracle Web
Application Server, Web Services, UNIX Shell Scripting, ASP.Net, Toad
Gerdau Ameri Steel, Tampa
6/2007- 2/2008
Oracle PL/SQL Developer
. Define project plans and involved in analyzing, designing, reviewing,
testing and integration.
. Worked in coordination with business team for creating Business Use
Cases.
. Tuned performance of SQL Queries, Sources, Targets and Sessions using
TOAD.
. Involved in performance fine-tuning of the queries/reports in various
schemas across the database using, Oracle Hints, Explain Plan and
Trace sessions.
. Involved in the Design and Development of Sales Reports using
Reports9i.
. Loaded data into tables using SQL*Loader.
. Other responsibilities included: Creating Queries for Business Objects
to produce reports, Generating XML flat files from select queries,
developing SQL*Loader scripts to load data into tables, and working
with the Production Support team to fix many high priority bugs.
. Designed model for daily transaction for the application in Erwin.
. Created UNIX Shell Scripts for automating the execution process.
. Created Triggers to apply business rules to the inventory count forms.
. Data Load from flat files into Oracle tables using SQL*Loader, and
PL/SQL procedures
. Fine tuned SQL Statements to improve the performance of batch modules
using Explain Plan, Tkprof.
Environment: ORACLE 10g, SQL*Plus, PL/SQL, SQL*Loader, Oracle 10g Forms &
Reports, DB2, Export/Import, AIX,TOAD, JDBC, SQL Navigator, ERWIN, Oracle
Web Application Server, UNIX Shell Scripting PRO*C, ASP.Net, Toad.
Bayer, Pittsburgh, PA
1/2006 - 5/2007
Oracle PL/SQL Developer
. Involved in the Modifications and development of databases and tables
to support the new inventory changes.
. Involved in the Design and Development stages of data entry Forms
using Forms 4.5 which were also used for weekly and monthly inventory
counts for different store locations.
. Involved in the Design and Development of Sales Reports using Reports
4.5.
. Attended Sales meetings to brain storm report ideas to help push
sales.
. Scripted end-of-night batches that would accept sales totals and the
end of each night for each store location.
. Created Functions to compute sales calculations and sales predictions
based on past sales totals.
. Designed and developed Forms for the HR department.
. Programmed Procedures to give new employees commission status after
certain specified time and changing employee salaries after receiving
certifications.
. Developed, modified, and optimized complex queries for data retrieval
and modification.
. Involved in monitoring of data warehouse.
Environment: Oracle 8i, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus, UNIX,
PRO*C, Windows NT 4.0/2000/XP Windows2000, Linux.
Western Bank, MN
1/2004 - 12/2005
Oracle PL/SQL Developer
. Prepared program Specification for the development of PL/SQL
procedures and functions.
. Created Custom Staging Tables to handle import data.
. Developed SQL* loader scripts to load data in the custom tables.
. Run Batch files for loading database tables from flat files using
SQL*loader.
. Created UNIX Shell Scripts for automating the execution process.
. Developed PL /SQL code for updating payment terms.
. Created indexes on tables and Optimizing Stored Procedure queries.
. Modified existing codes and developed PL/SQL packages to perform
Certain Specialized functions / enhancement on oracle application.
. Created Indexes and partitioned the tables to improve the performance
of the query.
. Involved in preparing documentation and user support documents.
. Involved in preparing test plans, unit testing, System integration
testing, implementation and maintenance.
. Modified existing forms & reports as per client requirements and also
developed custom forms and reports for additional functionality in
different modules.
Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, SQL Navigator, SQL*Plus,
UNIX, Windows NT 4.0/2000/XP Windows2000, Forms 6i, Visual Studio.
Contact this candidate