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
Back to Peningo Sample Resumes
Back to the Peningo JDA Consultants / Manugistic Consultants Page
If your organizations has an IT Staffing or
Consulting need for a JDA Resource, please
email us at
sales@peningo.com . If you wish to
speak with someone from Peningo Systems,

please click here to contact Peningo.