Sridhar Munagala

404-***-****

adctp4@r.postjobfree.com

Objective

To obtain a growth oriented position in software design and development using my experience in Oracle DataBases,

Peoplesoft, Tuxedo, Weblogic, Tableau, OBIEE and ODI Administration.

Summary

Twenty three years of IT experience with over fifteen years of DBA activities involving in Install, and Upgrade Oracle Software, create, administer, maintain, backup, recovery, and tune databases. Over fifteen years of Peoplesoft DBA experience with PeopleSoft Financials, HRMS, FrontOffice(Staffing), Service Procurement, Portal modules involing in Application Engine, Portal, Security, Application Designer, Integration Broker, Peoplesoft Nodes, and App messaging. Successfully involved in upgrading Financials 7.6 to 8.4 & in upgrading HR 7.6 to 8.3 and upgrading 8.3 to 9.0.

Over twelve years of Tuxedo Administration, in creating and configuring Tuxedo domains for Peoplesoft Applications, Webserver administration using WEBLOGIC server and Apache severs.

Coded several shell scripts in scheduling batch, backups, startup, shutdown also for various database and operating system requirements.

Over twelve years of Change Mangement experience, in migrating code and projects using Visual Source Safe, PVCS, PS Tools for PeopleSoft applications, and knowledge of STAT.

Over 5 years of UNIX experience and assisted the System Administrator in day-to-day activities, which includes hands on experience in RAID and RAW device environments.

Worked in different industries including Automotive, Manufacturing, Utility, Hospitality, Financials, HR, and Staffing.

Excellent team player with good communication and documentation skills.

Experience

Systems Specialist / Architect, HR Finance and Associate Systems

Macys Systems and Technology, JohnsCreek, GA May’14 – Present

Responsible for day to day operations of HR, Finance and Associate systems involving in Peoplesoft, Kronos, and HR Analytics. Monitor, identify and resolve any peoplesoft system, application server, webserver, process scheduler, and database performance issues.

Responsibilities include routine Database administration tasks, trouble shooting & tuning inefficient SQL statements. Setup logical and physical backups for all production, training and development databases.

Duties include, migrating the applications /objects from development to Test, UAT and ProductionOracle HCM cloud environments using GIT Library.

Refresh development databases using DELPHIX, migrate peoplesoft projects, apply tax udates, install SSL certificates on F5 load balancer and proxy servers as and when necessary.

Worked as lead peoplesoft administrator in consolidating, various peoplesoft HR databases into one huge database with over 200k employees with terabyes of data.

Upgraded Peoplesoft databases to Oracle 12c/18c/19c and PeopleTools 8.49.19 to 8.54.28.

As a Lead/Architect oversee HR Analytics issues by conducting weekly meetings with HR corporate business and power users. Involved in deciding software requirements for HR Analytics. Upgraded OBIEE from 11.1.6.5 to 11.1.1.7 along with ODI 11g. Upgraded and migrated to OBI12C into development, additional responsibilities,as Tableau Admnistrator, installed and upgraded Tableau software from 8.3 to 9.0 to 10.2

Manage offshore Devops Team/peoplesoft/oracle dba resources

Environment Oracle 11gR2/12c/18c/19c, Oracle EBS 12, Exalytics, Oracle HCM Cloud, Peoplesoft HRMS 9.0, PeopleTools 8.49/8.54/8.55, Peoplesoft PUM, Tuxedo 10.3/12.1, Apache, Weblogic 9.2 mp4/ 11gR1/ 12c, Kronos 6/7, OBIEE 11g/ OBI 12c, ODI11g/12c, Tableau 8.3/9.2/10.2, DELPHIX, ServiceNow Ticketing System, GIT Lab / Jenkins /Udeploy

OS Solaris 10/11, Windows 2008/2012 Servers

Lead Oracle DBA / PeopleSoft DBA Oct ‘01 – May’ 14

Randstad USA, Atlanta, GA

Project Lead for upgrading all peoplesoft databases to Oracle 11gR2, and hardware upgrade to new AIX P7 boxes from AIX P5 boxes, as well as for Disaster Recovery methodologies. SQL Performance Analyzer (SPA), database replay were used for SQL and database behaviour, before upgrading to 11gR2 or moving to new hardware.

Typical jobs include applying oracle, peopletools, tuxedo, weblogic patches, as and when necessary.

Upgraded peoletools 8.42.14 to 8.50.08 on Peoplesoft based Datawarehouse application.

Routine peoplesoft DBA activities such as project migrations to production, applying tax updates, and installing geotax databases. Fine tuned application servers and webservers to scale the application load.

Involved in performance tuning of peoplesoft modules, HRMS (payroll), Frontoffice (batch), and FS (Billing)

Stream lined and automated cloning databases from production to development. RMAN/datapumps were used to refresh data from production to development, QA, UAT, and other Test environments.

Installed, maintained, archived the Payroll, Financial, and Staffing data using HP RIM ( OuterBay database )/ Informatica Smart Partitioning.

Environment Oracle 11gR2 (RAC, Rman, DataGuard, GoldenGate, SPA, OEM 11g ), PeopleTools 8.53/8.52/ 8.51/8.50, Tuxedo 10.3, Weblogic 10.3.1 (11gR1), Hyperion, JD Edwards, HP RIM, Informatica ILM Smart Partitioning, Informatica Data Replication, Visual Source Safe

OS AIX 5.3/6.1/7.1, Windows NT/2003/2008 Servers

Worked on PeopleSoft HRMS upgrade from 8.3 to 9.0 as well as from Peopletools 8.19.01 to 8.49.09.

Upgraded existing 9i/8i databases to Oracle 10g while migrating the databases from HP Servers to IBM Servers.

Created, and configured Integration brokers, setting up the nodes for application messaging among different modules.

Environment Oracle 10g, Oracel EnterPrise Manager, PeopleSoft HRMS 9.0, People Tools 8.49, Tuxedo 9.1, Weblogic 9.2 MP1-p2

OS AIX 5.3, Windows NT/2003 Servers

Involved with BlueSail Project in the conversion of legacy data into PeopleSoft Applications, mainly involving with Front Office, Financials, and Human Resources. BlueSail is the most visible project for the company. Randstad is a leading staffing firm, providing temporary staff to various industries.

Upgraded existing oracle 8i databases to oracle 9i and applied database patches to oracle 9i,and 9i to 10g.

As a PeopleSoft DBA, create and maintain Application Servers, Process Schedulers, Distribution Agents and WebServers. Apply patches to PeopleSoft applications, migrate projects to different environments, and use People Tools for various sysadmin tasks. Assist developers in fine tuning SQL queries.

Upgraded Front Office PeopleTools successfully from 8.14 to 8.15.08 also installed PeopleTools 8.16 using Upgrade Assistant. Upgraded tools HR 7.63 to 7.63.01.

Successfully involved in upgrading HR 7.5 application to HR 8.3, primarily using Upgrade Assistant, and in upgrading peopletools to 8.19.02.

Installed demo of peoplesoft ELM module for Randstad University.

Supported in setting up Portal project for single sign-on to enterprise wide applications such as FrontOffice, Human Resources, Financials, Intranet applications.

Instrumental in designing and setting up e-billing architecture, for load balance by configuring multiple webservers, application servers, process schedulers on RedHat Linux machines, also in setting up Clustering for failover servers. Involved in installing NT Clusters for crystal reports.

Environment Oracle 10g / 9i / 8i, PeopleSoft 8.0 ( Front Office ), PeopleSoft 8.3/7.5 ( Financials, HR ), Portal 8.45, People Tools 8.46, 8.45, 8.42/8.2/8.19,7.6, Tuxedo 6.5, 8.1, Weblogic 5.1, 6.1, 8.1, Cognos, Hyperion

OS HP-UX 11.11, Redhat EnterPrise Rel. 3, Windows NT / 2000

Oracle DBA / PeopleSoft DBA Jan ‘01 – Oct ’01

Accenture, Atlanta, GA

Involved in development, enhancement, and maintenance of Marriott Hotels PeopleSoft applications that included HR & FS Modules. Siebel was used for request tracking such as system and code changes.

Oracle DBA activities include day-to-day administration, capacity planning, schedule maintenance, tune customized SQR reports, and trouble shooting. Responsible for around twenty five development, test, and production Oracle/PeopleSoft databases, over 500 gig, instances on HP Unix.

Duties also include Peoplesoft server administration such as Application Servers, Process Schedulers, and Batch servers.

Also as a PeopleSoft DBA, applied patches to PeopleSoft applications, migrated projects to different environments, and used People tools for various sysadmin tasks.

Environment Oracle 8i, Tuxedo 6.3.4, PeopleSoft 7.5( Application Designer, Security Administrator ), Seibel, Lotus Notes, PVCS

OS HP-UX 11.0, Windows NT

Applications DBA Dec ‘98 – Dec ’00

Detroit Edison, Detroit, MI

Involved in development, implementation, and maintenance of Customer Service and Billing ( CSB ).

CSB, most visible project at Detroit Edison, is one of the largest on site projects, which runs in over 200 GIG, and multi environment databases. Assignment includes working in close liaison with DBA group in resolving any database issues, fine tuning the databases, assist developers in tuning the application code, and also taking advantage of Oracle 8i.

Monitor and Analyze database statistical growth trends, future storage requirements, initialization parameters, reorganization techniques, database configuration, and alarm situations utilizing manually created DBA tool kit.

Environment Oracle 8i, Designer 2000, Discoverer 3.0, Tuxedo 6.3.4

OS HP-UX 11.0, Windows NT

DBA Dec ‘96 – Nov ’98

Ford Motor Company, Dearborn, MI

Involved in the design, development, implement, and replicate of global corporate weldspot database information, and also integrating the database with CAD/CAM/CAE and PIM systems, to be used by Ford Manufacturing Plants worldwide.

Responsible as DBA for the databases on Sun Solaris 2.5 servers in Dearborn, Michigan, USA and Cologne, Germany. Installed Oracle 7.3.2 on Germany servers and US. Created multiple instances on the US and Germany servers for different databases. Upgraded databases from 7.3.2 to 7.3.3, and Tested migration from 7.x to 8.x. Installed different Oracle products including Developer 2000 / Designer 2000, Web Server. Created weldspot database and necessary packages, procedures, triggers on all Weldspot database instances.

Duties also included allocate and manage disk usage, Backup and Recovery, and tune Oracle databases.

Tested Oracle Replication option to simulate the data between the servers in Dearborn, Michigan, USA and Cologne, Germany for OLTP.

Environment Oracle 7.3/8.0, Uniface, Oracle Enterprise Manager 1.2, Oracle WebServer 2.0

OS Sun Solaris 2.5, IBM AIX 4.0, HP_UNIX 10.0, Windows 95 / NT

Systems Analyst Jun’94 - Dec 96

Ford Motor Company, Dearborn, MI

Responsible for the Design and Development of REDCRS ( Resident Engineers Design & Concerns Report System ) . Dataflow Modeling, Entity Relationship Modeling, Physical Database Design, Module Design, Development of user interface screens and reports generation was done using Oracle 7.1.6, PL/SQL 2.1, Designer 2000 / Developer 2000 ( Oracle*Forms 4.5, Oracle*Reports 2.5, Oracle*Graphics 2.5 ) .

Environment Oracle 7.1.6, PL/SQL 2.1, Developer 2000, Designer 2000, Sql*Forms 3.0,

Sql*Reportwriter 1.1, Sql*Menu 5.0, Sql*Loader 7.1.6, Oracle Webserver 2.0

OS HP_UNIX 9.0, Windows 3.1 / 95

Programmer/ Systems Analyst Sep ‘93 – Jun ’94

Alpha & Omega Integrated Control Systems Inc., Pittsburgh, PA

Involved in the design & development of Distribution Operations Management System ( DOMSâ). Developed various user interface screens using Sql*Forms 3.0, developed various custom reports using Sql*Reportwriter 1.1. Customized the user menu with Sql*Menu 5.0.

Environment Oracle 7.0 ( Sql*Plus, Sql*Forms 3.0, Sql*Reportwriter 1.1, Sql*Menu 5.0, Sql*Loader, Printronix )

OS HP_UNIX 9.0 & VMS 5.1

Education MS Computer and Information Sciences

Alabama A&M University, Normal, Alabama

Recognitions Oracle Certified DBA, Ford Motor Company Best Customer Support Award,

Detroit Edison Top Five Consultants Award

References Available upon request

Contact this candidate