NationalJobBank.com
Find Resumes
FAQs
Recruiters
RESUME TITLE: Oracle Developer with 6 years experience l...
Resume Posted: 01/28/2008
RESUME DESCRIPTION
Category Listing:
Information Technology/Systems
Salary Desired:
$100,001 - $149,999
My Location:
Metuchen, NJ USA
Contact Info:
Kumar Cheruku
Metuchen, NJ
*******@********.***
Willing to Relocate:
Yes
Resume:
Name: Kumar Cheruku Email: *******@********.*** Job Category: Information Technology/Systems Title: Oracle Developer with 6 years experience l... Salary Desired: $100,001 - $149,999 Location: NJ
Resumes Details: CORE COMPETENCIES & STRENGTHS Over 6 years of IT experience in Data Warehouse, RDBMS concepts and Application Development, Testing and Implementation using Oracle 9i/8i, SQL, PL/SQL,SQL* LOADER, Query Optimization, Performance Tuning and Trouble Shooting. Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting. Experience in OLTP System Study, Analysis and E-R modeling, understanding in developing Database Schemas like Star and Snowflake schema Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 9i/8i and also SQL queries/reports and scripts Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables). Good Knowledge of Data integration and migration using SQL * Loader Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader Worked with very large databases in terms of Terabytes Extensively used UNIX shell Scripts for automating batch programs Strong skills in writing technical and functional documents defined by the business requirements Involved in the issue resolution and Root Cause Analysis Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment Excellent logical and analytical skills to solve complex problems TECHNICAL SKILLS Languages PL/SQL, SQL, Pro *C, Shell Programming, C, C++, Java, FORTRAN Development tools Oracle Developer (Forms 4.5/5.0/6i, Reports 2.5/3.0/6i) RDBMS Oracle 8i/9i, DB2,MS Access Database tools SQL*PLUS, SQL*Loader, TOAD, DBArtisan, SQL Navigator Hardware Sun SPARC, IBM PC/AT/XT, Intel Pentium PC, DELL PC, Compaq PC Operating Systems Windows 98/95, Windows NT, HP Unix, MS-DOS Reporting tools Business Objects5.1, Siebel analytics 7.7 Web Development Tools HTML, JSP, Java Script, XML, ASP 3.0, ADO, VBScript 5.x Defect Management Tool Test Director 8.0 Version Control PVCS,SCCS
EXPERIENCE
SENIOR SOFTWARE ENGINEER/ ORACLE DEVELOPER - 2007 to PresentGE, APPLIANCE PARK, KY PROJECT: FQ (FIELD QUALITY) DESCRIPTION: The FQ system is a critical application that generates measurements on the performance of the GE Appliance business. These measurements are Service Call Rate (SCR), Current Manufacturing Index (CMI), Manufacturing Warranty Rate (MWR), Warranty Parts Rate (WPR), Warranty Part Calls (WPC), NPS-SEARS business measurement and Fault Call Rate (FCR).The measurements are absolute indices and are generated every month. FQ in it does not "own" any of the data that is used in these measurements rather it is dependent on other functions to provide the data. The system basically receives the data from other applications and applies algorithms to the data to generate the measurements on a monthly basis. ROLE & RESPONSIBILITIES Involved in the maintenance and enhancement of the application Maintained good rapport with Business Analyst & Business Users to identify information needs as per business requirements Document the business process flows Schedule meetings and present technical issues to business users and developers. Performed discussions with data modeler to update the data model for new requirements Extensively developed complex PL/SQL packages for Invoice Processing. Designed/developed tables, views, various SQL queries, stored procedures, functions. Involved in PL/SQL code review and modification for the development of new requirements. Extensively worked with Dynamic SQL,Composite data types & Global Temporary Tables Used Pl/Sql tables, array structures as a part of oracle collections. Involved in partitioning of very large tables. Used list and range partitioning. Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility Create & maintained box jobs using Shell Scripts. Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated. Communicate issues and progress to project manager. Solving day-to-day problems, giving support to the users. Involved in Production Support and troubleshooting data quality and integrity issues
ENVIRONMENT:
Oracle 9i, PL/SQL, HP Unix, Unix shell scripting, Cobol, Maestro, VB SENIOR SOFTWARE ENGINEER/ ORACLE DEVELOPER - 2006 to 2007 NIKE WHQ, PORTLAND, OR PROJECT: DEMAND PLANNING DATA MART (DPDM) DESCRIPTION: The demand planning Data Mart (DPDM) is Global Forecast Accuracy Measurement system for Apparel, Footwear and Equipment. DPDM consists primarily of data extracts from NSC's Demand Planning Repository (DPR) done twice a day Monday through Saturday. Once DPR has finished transferring files to DPDM through AutoSys FTP job, DPDM's batch is triggered to start. The Data Mart gets data feeds i.e., Partners data from USCAN, EMEA & Asia Pac and customized reports are generated using BRIO reports. It is designed to provide an integrated view of data from various data sources and to generate different types of reports. ROLE & RESPONSIBILITIES Involved in requirement gathering and analysis. Worked closely with the users to understand their requirements. Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL. Associated with DBA's in monitoring the performance related issues using Explain Plan, SQL Trace and TKPROF utility. Used AutoSys for batch scheduling. Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner. Create & maintained box jobs using Shell Scripts. Involved in the deployment of code into QA and Production environment. Involved in Code review before dropping into QA/UAT environments. Effectively resolved KITANA Tickets. Assist with Production Cutovers. Involved in the on Call Production Support. ENVIRONMENT: Oracle 9i, PL/SQL, HP Unix, Unix shell scripting, SQL Navigator, SCCS ORACLE DEVELOPER - 2005 to 2006 INGRAM MICRO, SANTA ANA, CA PROJECT: OPERATIONAL DATA STORE DESCRIPTION: Build a near-real-time operational data store (Oracle) from IMS based legacy systems. Used IBM's Event Publisher to replicate IMS data change events to an Oracle database. Oracle triggers were used to ETL the legacy data into a normalized relational structure. My participation included the development of the Oracle triggers, Stored procedures and as well as to maintain the Java programs that read the data from MQ queues and insert them into Oracle shadow tables. ODS is the primary data source for the Enterprise Business Services that is being used by e-commerce applications. ROLE & RESPONSIBILITIES Participated in all the Life Cycle phases including requirement analysis,Client Interaction Design, Coding, Testing, Support and Documentation Created Functional Specification document and High-level design document Worked under the supervision of a DBA and created database objects such as tables, views, sequences, synonyms, and table/column constraints, indexes for enhancement Written complex SQLs using joins, subqueries and correlated subqueries Developed complex PL/SQL packages for EBS Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules Worked extensively with Composite data types, Cursors and Dynamic SQL Written Row Level Triggers to replicate Legacy Systems data to Oracle Database Worked with Dynamic SQL, Global Temporary Tables Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process Import/Export utility is used for transforming data from one place to another from testing to Production. Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views Partitioned very large database tables using list partitioning to improve performance. Written UNIX scripts and run/review production jobs in the UNIX environment Communicate issues and progress to project manager Effectively resolved QA Trackers
ENVIRONMENT:
Oracle 9i, PL/SQL, HP UNIX, UNIX shell scripting, Informatica, DBArtisan, PVCS Tracker INFORMATION SYSTEM CONSULTANT - 2004 to 2005 AMERIQUEST MORTGAGE, CA PROJECT: LEASING DATA MART DESCRIPTION: The Lease Data Mart is a Global Financial Reporting system for Lease and Loans. The Data Mart gets data feeds from Intranet applications and from Extranet i.e. Partners data from EMEA & Asia Pac either in XML or excel format and gets loaded into the Data warehouse using Informatica. From ODS the data is loaded into EDW through PLSQL scripts and Customized Reports are generated using Business Objects. The Lease Data Mart is a web-based front-end reporting tool for leasing and loan business. It is designed to provide an integrated view of data from various data sources such as lease-servicing system and lease origination system and to generate different types of reports like Accounting, Collection, Invoicing, Cash, Sales and Credit Reports ROLE & RESPONSIBILITIES Involved in requirement gathering and analysis. Worked closely with the users to understand their requirements. Designed the database and schema objects. Involved in the logical and physical database design and developed the logical dimensional models using ERWIN 4.0 Developed entity and attribute descriptions and definitions for the models. Lead part in Design and Code walk through Development of the DW -Extraction of data from disparate sources and uploading the data after cleansing into the DW. Wrote SQL Loader & Pro *C scripts for Import/Export data files Developed Informatica Mappings to load data into Lease Data Mart Extensively used Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy etc Developed reusable transformations and Mapplets Extensively used mapping parameters, mapping variables and parameter files Extensively developed complex PL/SQL packages for ETL Troubleshot the existing PL/SQL procedures, functions, triggers Analyzing tables and indexes for performance tuning Seasoned in optimizing Query performance using explain plan, SQL Trace and TKPROF utility Developed scripts for checking Oracle errors in alert logs and trace files for every 15minutes Performed unit testing, system integration Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner. ENVIRONMENT: Oracle 9i, PL/SQL, Informatica 6.2, Siebel Analytics, SQL *PLUS, Toad, ERWIN, UNIX, Shell Scripts, SQL Loader, Pro *C SR. SOFTWARE DEVELOPER - 2001 to 2003 PARAMOUNT ENTERPRISES, HYDERABAD, INDIA DESCRIPTION: Paramount Enterprise is a major supplier of fasteners to all the leading vehicles and engine manufacturers in India. The company's products are exported to various quality conscious markets like USA, UK and GERMANY. The project was to group data in the financial department to generate reports for different categories ROLE & RESPONSIBILITIES& #61692; Involved in writing procedural scripts using PL/SQL& #61692; Involved in coding and testing of the system& #61692; Created GUI for end users& #61692; Stored procedures and triggers were developed for business rules& #61692; Generated various types of reports by using reports builder& #61692; Involved in implementation and documentation of the system& #61692; Generated specific reports using crystal reports
ENVIRONMENT:
Oracle, PL/SQL, Windows NT
01/01/-1 to 2000 01/01/-1 to 2000 01/01/-1 to 2000 EDUCATION Bachelor of Engineering, Mechanical Engineering Nagarjuna University, India
Addition Information: Over 6 years of IT experience in Data Warehouse, RDBMS concepts and Application Development, Testing and Implementation using Oracle 9i/8i, SQL, PL/SQL,SQL* LOADER, Query Optimization, Performance Tuning and Trouble Shooting. Extensive exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting. Experience in OLTP System Study, Analysis and E-R modeling, understanding in developing Database Schemas like Star and Snowflake schema Extensively worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle 9i/8i and also SQL queries/reports and scripts Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables). Good Knowledge of Data integration and migration using SQL * Loader Experience in using SQL TRACE and TKPROF tools for Explain Plan, SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns Extensively worked with Oracle Utilities like Imports / Exports, SQL * Loader Worked with very large databases in terms of Terabytes Extensively used UNIX shell Scripts for automating batch programs Strong skills in writing technical and functional documents defined by the business requirements Involved in the issue resolution and Root Cause Analysis Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment Excellent logical and analytical skills to solve complex problems
HOME
Register FREE!
Job Categories
My Account
HOT JOBS
HOT RESUMES
Log In
Edit Your Resume
Web Hosting
REFER A FRIEND