Peningo Systems, Inc.
Resume of Candidate: PEN141
Rate: email us at info@peningo.com for rate information
JDA Software Consultant
Technical Areas:
Experience Summary
Around 6.5 years of IT experience as a core Oracle DBA. An Oracle Certified DBA with experience in production support for mission critical applications,
handling large databases, performance tuning, maintenance, administrative activities and with SQL and PL/SQL development skills. Currently working in
JDA Software as a Performance Engineer since June 2008, JDA Software LTD is the best in supply chain solutions that help businesses grow revenue,
increase profits and operate in a more efficient and sustainable way. The combined heritage, technology and knowledge capital of JDA staff, solutions
and acquired brands, including market leaders such as i2 Technologies®, Manugistics®, E3®, Intactix® and Arthur®, enable companies from around the
world to transform their supply chains into a powerful competitive advantage. No other solutions provider offers the depth and breadth that JDA does.
JDA Performance engineering team is comprised of a group of senior experts in the areas of System and Database Tuning, knowledge of various
technologies, Hardware Performance Optimization and Benchmark Analysis. As a performance engineer, I was responsible to identify performance issues
of the client through system analysis & verification, come up with quality recommendations through detailed performance audit and analysis to optimize
the performance constraints based on the client's business requirements.
Experience in Implementation of various JDA Products to different clients successfully implemented, Portfolio Merchandise Management [PMM] 7.5.0,
SCPO 7.4.2, 7.5.2 and Enterprise Planning 7.5.1, 7.6.0 & 7.6.1, Size Scaling and Arthur Allocation and developed interfaces using oracle PLSQL, Shell
scripting, Uniface and IBM Datastage 8.1[ETL Tool] on different platforms as per the client requirements.
Education
Bachelor of Engineering in Electrical and Electronics Engineering from S C S V M V University, Kancheepuram, India, Hyderabad, India
Certifications
Oracle 10G Database Administrator Certified professional Hyderabad, India, Oct, 2007
Japanese Language Proficiency Test Level 4 Chennai, India, Dec, 2005
Skills Summary
Programming Languages : PL/SQL, C, C++, Unix Shell scripting, Uniface
Tools : IBM Datastage 8.1, CVS, Erwin, VSS, TOAD, Kintana, PL/SQL
PL/SQL Developer and Spotlight
Operating Systems/Environments : UNIX, IBM AIX, Redhat Linux, Windows 95 / NT / 2000 /2003,
SunSolaris.
Software : PL/SQL, C, C++
RDBMS : Oracle 8i, 9i and 10g Databases
JDA Applications : JDA Portfolio Merchandise Management [PMM] 7.5.0
JDA Supply Chain Planning and Optimization [SCPO] 7.4.2, 7.5.2
JDA Enterprise Planning 7.5.1, 7.6.0, 7.6.1 & 7.7.0
JDA Allocation 7.5.0, 7.6.0 & 7.6.1
JDA Size Scaling 7.5.0, 7.6.0 & 7.6.1
CAREER PROFILE
June 2010 – Till Date
JDA Software Technical Consultant
Wal-Mart the biggest and largest in supply chain and retail industry serves customers and members more than 200 million times per week at more than
8,650 retail units under 55 different banners in 15 countries. With fiscal year 2010 sales of $405 billion, Wal-Mart employs more than 2 million associates
worldwide.
Was responsible for Hardware and network configuration recommendations for Wal-Mart for implementation of JDA 7.5.2 SCPO suite of products
Responsible for verifying Pre-requisites and certifying Wal-Mart Servers before installing and configuring the JDA products
Responsible for successful installation and configuration of Oracle 10g and 11g R2 RDBMS Server, WebSphere Application Servers, create
WebSphere profiles, JRE , and JDA Products
Applying successfully Wal-Mart specific JDA patches as and when released
24/7 support and resolve any ad-hoc or environment related issues instantly thus avoiding any potential loss to Wal-Mart business
Create Change Control and get it approved for any application changes, Maintain patch version, release history, develop documents’ on
environments, interact with the client on the requirements and update on the environment status and maintenance
Understand client requirement, analyze on the various methods to incorporate the requirement in to JDA product, and give the best suited
method to the client and write Functional Specs and Technical Specs thus performing as a Techno-Functional
Develop the scripts according to the functional spec using Shell scripts and oracle Pl/sql and sql and perform unit testing
Design and develop the batch process flow from the Wal-Mart legacy system into JDA
Support the batch process on various stages of Test, Certify and Production servers. Resolve the batch issues on the fly and Tune the scripts by
including Oracle Hints and Indexes for optimal performance during the batch execution.
Environment:
Websphere 7.0.0.11, IBM AIX 7.1, and Oracle 11g R2
Marks Work Warehouse –Canada, March 2010 – May 2010
JDA Software, Hyderabad Performance Engineer
Mark's Work Warehouse has evolved from one small store in Calgary, Alberta to over 350 stores across Canada. Outdoor apparel for men and women,
workwear, and safety footwear. As a Uniface and plsql developer the following activities were under taken by me in this project.
Was involved in writing technical specs based on the functional specs for customizations
Developed forms using Uniface language
Understood the functional requirement of the client and modified the existing base forms as per the requirement.
Developed the PLSQL procedures as per the requirement of the forms at the backend.
Environment:
Uniface 9, IBM AIX 5.3, and Oracle RDBMS 10.2.0.4
Marks Work Warehouse –Canada, Jan 2010 – March 2010
JDA Software, Hyderabad Performance Engineer
Mark's Work Warehouse has evolved from one small store in Calgary, Alberta to over 350 stores across Canada. Outdoor apparel for men and women,
workwear, and safety footwear. As a Datastage and plsql developer the following activities were under taken by me in this project.
Was involved in writing technical specs based on the functional specs
Developed complex interfaces using SQL/PLSQL concepts
Developed interfaces using IBM Datastage 8.1 calling shell scripts and PLSQL stored Procedures from the within datastage job.
Understood the functional specification and have developed forms using Uniface language part of PMM product.
Developed shell scripts as per the requirement and for the executing the PLSQL scripts.
Environment:
IBM AIX 5.3, Oracle RDBMS 10.2.0.4, IBM Datastage 8.1 and Oracle Enterprise Manager 10g Grid
Control
Fosters Group –Australia, June 2009 – Dec 2009
JDA Software, Hyderabad Performance Engineer
Fosters Group has a portfolio of more than 200 premium brands, operations on five continents and a history stretching back over 160 years. Based in
Melbourne, Australia, and publicly listed on the Australian Stock Exchange, Foster's products are sold in over 100 countries. As a performance engineer
the following activities were the activities I was involved in.
Generated Oracle AWR reports on the client environment, analyzed top sql’s and tuned the same.
Modified the application level PLSQL code, used advanced PLSQL concepts.
Tuned the batch jobs reduced the time to load the data onto the Model Manager from 8 hours to 40Mins. This involved top sql’s tuning, Re-Orgs,
IO monitoring & tuning through OS related tools VMSTAT, database level tuning and Oracle parameter tuning
Performance tuning of the Database for Fosters
Tuned the batch job which was taking 7 hours to load data to 23 Mins, by optimizing the data load time.
Performance tuning on the FE pages in SCPO 7.4.2, using AWR reports and SQL Tuning
Performed the performance testing on the client server at OS & database levels.
Prepare quality reports post tuning engagement addressing the issues with respective remediation / recommendations
Worked on SQL’s contributing to CPU / Memory Utilization
Interface tuning to achieve optimal batch job runtime
Analyze and determine memory exhaustion for long running SQL’s
Involved in running and analyzing various test cases
Recommend Index Re-orgs, Histogram generation etc for better execution plans
IO monitoring & tuning through OS related tools like VMSTAT, SAR etc
Tuning batch jobs runs through Optimal Database Memory Parameters
Evaluate Batch Performance through system and database configuration
Improve on system availability through optimal batch window design and execution strategy
Plan internal server(s) maintenance & apply Oracle patches etc
Initiate technical discussions and conduct internal trainings through live scenarios
Wrote Internal Knowledge base documents for the team
Created Indexes Re-orgs, Histogram generation for better execution plans of the SQL’s
Environment:
IBM AIX 5.3, Oracle RDBMS 10.2.0.4, and Oracle Enterprise Manager 10g Grid Control
Carlson Hotels – Chain of hotels-USA Jan 2009 – June 2009
JDA Software, Hyderabad Performance Engineer
Carlson is one of the largest privately held companies in the United States. There brands and services operate in more than 150 countries and employ
about 160,000 people. And Carlson is on Working Mother magazine's 2001-2004 and 2006-2007 lists of "The Best Companies for Working Mothers," and
Fortune magazine's 2002 list of "The 100 Best Companies to Work For." In 2006-2008, they were named one of the "Best Places to Work for GLBT Equality"
by the Human Rights Campaign. Below are the activities that were undertaken for Carlson Hotels.
Perform System Setup & Architecture through Software Installation
Conduct overall database health checks and provide recommendations
Create and Configure database along with SCPO 7.4.2 Product Install
Suggest/Recommend hardware requirements specific to SCPO Product
Involved in writing technical specifications.
Developed application interface using PLSQL and shell scripting
Performed unit, load testing on the interface
Environment:
Sun Solaris, Oracle RDBMS 10.2.0.4, and Oracle Enterprise Manager 10g Grid Control
Gloria Jean’s – Largest Clothing Retailer – Russia June 2008 – Dec 2009
JDA Software, Hyderabad
Gloria Jeans is the largest company in Russia and in Europe, which produces fashionable clothes for young people and children. It is the company
created brands No 1 on the Russian market (as acknowledged by international Sportswear International magazine for experts of global market). Below
are the activities performed by me on this project.
Install and configure Oracle, and all the required pre-requisites for JDA Enterprise Planning 7.6.0
Generated Oracle AWR reports on the client environment, analyzed top sql’s and tuned the same
Modified the application level PLSQL code, used advanced PLSQL concepts
Tuned the batch jobs reduced the time to load the data onto the Model Manager from 8 hours to 40Mins. This involved top sql’s tuning, Re-Orgs,
IO monitoring & tuning through OS related tools VMSTAT, database level tuning and Oracle parameter tuning
Performance tuning of the Database for Fosters
Tuned the batch job which was taking 7 hours to load data to 23 Mins, by optimizing the data load time
Performed the performance testing on the client server at OS & database levels
Prepare quality reports post tuning engagement addressing the issues with respective remediation / recommendations
Optimize data load time through SQL Loader Tuning
Worked on SQL’s contributing to CPU / Memory Utilization
Interface tuning to achieve optimal batch job runtime
Analyze and determine memory exhaustion for long running SQL’s
Involved in running and analyzing various test cases
Recommend Index Re-orgs, Histogram generation etc for better execution plans
IO monitoring & tuning through OS related tools like VMSTAT, SAR etc
Tuning batch jobs runs through Optimal Database Memory Parameters
Evaluate Batch Performance through system and database configuration
Improve on system availability through optimal batch window design and execution strategy
Plan internal server(s) maintenance & apply Oracle patches etc
Initiate technical discussions and conduct internal trainings through live scenarios
Wrote Internal Knowledge base documents for the team
Created Indexes Re-orgs, Histogram generation for better execution plans of the SQL’s
Environment:
Sun Solaris, Oracle RDBMS 10.2.0.4, and Oracle Enterprise Manager 10g Grid Control
Tata Consultancy Services
GE Asset Management Aug 2007 – May 2008
Mumbai, India Oracle DBA
GE Asset Management with more than $120 Billion in assets is one of the largest
Managers of the institutional assets in the United States. Was responsible for support and maintenance for the following applications Mutual funds,GE
Funds, US Equity, International Equity, Fixed Income, and
Private Equity:
Involved in monitoring the growth of tablespaces, tables and indexes
Monitoring the health check of the database
Creation of database users and assigning various grants
Applying Oracle database patches
Responsible for taking backups using RMAN scripts
Verifying the sanctity of the database backups
Performing cloning of database from one server to another server
Worked closely with developers in implementing the physical database model
Reorganization of database objects to improve the performance
Used Oracle Enterprise Manager to monitor the database status and performance monitoring
Generate schema statistics to improve database performance
Used TKPROF to analyze the oracle generated trace files to improve the application performance.
Used STATSPACK generated reports to identify the bottlenecks and improve the overall performance of database.
Implementation of Statspack
Installing Oracle, Adjusting Memory Structures, Building Databases and Performance Tuning
Import & Export of Table Statistics to improve Performance Gains
Manage Ad-hoc database administrative tasks like Creation of Tables, Synonyms and Constraints
Quality assurance of custom code components to ensure that the custom code meets the GE standards
Environment: |
Sun Solaris 5.8, Oracle RDBMS 10G, SQL*Loader, OpenSSL, JAVA, JSP, PL/SQL, PERL, Shell
Tata Consultancy Services Sep 2006 – July 2007
GE NBC Universal Pictures Break-Fix Oracle DBA
Mumbai, India
GE NBC Universal Pictures is a worldwide leader in Media & Entertainment vertical. News, information, and entertainment across the world. Portfolio
includes network television, broadcast and production, film, cable networks, sports and theme parks. As a part of the GE-TCS DBA team
Was responsible for supporting the Mission critical applications. Below were the activities I was involved in.
Verifying the database health state
Checking the daily backup logs and creating new backup scripts
Performing database cloning from the production instance backup
Maintain the database schema objects and creating database links between the databases
Troubleshoot the table space space issues
Work closely with developers in resolving issues related to invalid objects
Interact with the Unix Administration team and co-ordinate with them relating to any database issues. Planning, Scheduling & Deployment of CPU’s
[Critical Patch Updates]
Troubleshooting Standby Databases
Supporting Ad-hoc requests like Table Creations, User Creation, Password Change
Upgraded database from 8i to 9i
Implemented Dynamic Password Administration with Encryption for Production Databases
Running Production Cycles per application requirement
Provide estimates for Enhancement requests to the reporting infrastructure
Business Requirements Analysis for the Daily Drafting Enhancements
Performed performance tuning of code developed by developers and improved the performance of the application
Performed load testing and stress testing of the application using load runner and PERL
Developed PERL scripts to perform load testing and stress testing of the database
Integrated Oracle Internet Directory services with Oracle database to store the digital certificates in the LDAP repository
Helped developers and functional staff with network and connectivity issues and tuning of PL/SQL and JAVA code
Environment:
Sun Solaris 5.8, Oracle 10G, Apache 2.0, Tomcat 4.1, OpenSSL, JAVA, JSP, PL/SQL, PERL, Shell programming, loadrunner, Oracle Internet Directory and VSS
Aditya Constructions, June 2005 – Aug 2006
Celestial Labs, Oracle DBA
Hyderabad, India
Celestial Labs Being part of the DBA team for the project Aditya Constructions performed the following activities:
Creation and maintenance of tablespaces, including Creation, Allocation of Quotas, Addition of data file and space Management using rebuild of
indexes / Import Export
User and privileges Administration including
Creation of users by specifying appropriate password mechanism/roles for development, test and production
Control usage of space by users and obtain user information
Implementing Database security through privileges and public user profile
Maintain user profiles and security management
Create database specific configurations (User ids, grants, partitions etc)
Supported user requests like
Transfer of data through Import & Export
Analysis of data in flat files (using the concept of external tables)
Performance tuning of reads from large tables by partitioning the tables
Backup and Maintenance
Participated in the Design and Implementation of backup/restore procedures & Disaster Recovery Plan and Flashback
Perform online/offline backups (Daily Backups)
Index Rebuilds
Monitoring Scripts
Develop scripts and procedures to take online/offline backups of Oracle database
Also created scripts for automation of creation of segments and Database space utilization monitoring scripts, password expiry alert etc
Created scripts to solve day-to-day database reliability and performance analysis problems, as well as to assist in the development and
maintenance of Oracle applications
Tuning related activities like SQL Query Tuning, Ad-hoc Tuning issues, Shared Pool Tuning and IO Wait analysis
Performed Oracle database software patching using OPATCH
Setting up the backup and database monitoring jobs using cron
Environment :
Sun Solaris, Oracle RDBMS 9i, and Java
Sanjivani Aug 2004 – June 2005
Celestial Labs Oracle DBA and PL/SQL Developer
Hyderabad,India
Maintenance of Oracle Database 8.1.7 on Sun Solaris
Maintenance and configuration of Netscape web server
Version control of database objects using CVS
Performed logical backup and restoration of database objects using export and import
Performed Hot and Cold backup of database
Responsible for developing the PL/SQL packages, triggers, procedures and views of the Application.
Responsible for handling database and backend operations.
Responsible for coding and maintenance of the code.
Responsible for maintaining versions and version control of source code.
Involved in manual and automated testing.
Environment:
Sun Solaris, Oracle R