Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Volunteer

RAMAKRISHNA BHATTIPROLU

Sacramento,CA

Summary

I have over 20 years of experience in Information Technology industry, managing projects and providing solutions in large scale ERP systems like PeopleSoft to public and private sectors organizations. With more than 10 years of IT leadership experience in local government I have led teams in deploying complex and large scale enterprise solutions and have demonstrated history of delivering results-driven, sustainable, innovative and fiscally conscious solutions. I have experience in business process re-engineering, program management, process improvements, audit compliance, deploying innovative technologies, cloud solutions, change management, project management, RFP development and vendor management.

My strengths include customer relationship management and communication skills with both executive and user level, team building and mentoring, assessment of complex business problems, and providing sustainable technological solutions.

Over the last ten years I have managed several large scale projects including implementation of PeopleSoft Supplier Contracts, eSupplier Connection, Strat Sourcing, Travel & Expense, Inventory, AP Automation, Single-signon with MFA, Absence Management, ePBCS (Oracle Hyperion), Job and Position data modernization, Fluid Open Enrollment, re-designing of Payroll and Absence Management. I have also managed multiple upgrades including deployment of PeopleSoft upgrades from 9.1 to 9.2, PUM upgrades from UI 19 to 25, 25 to 34 and 34 to 44 in both Financials and HCM and PeopleTools upgrades from 8.48 to 8.53 and later on to 8.55 and 8.59.

Over the years, I have developed and attained significant subject matter expertise in the modules of Billing, Receivables, Payables, Purchasing, e-Procurement, General Ledger, Treasury and Cash Management, Commitment Control, HR, Benefits, Time & Labor, Absence Management, Payroll and Payroll Distribution.

I have led and been part of RFP creation, bid response evaluation and vendor selection processes in projects related to both ERP as well as third party applications and Cloud systems including AP Automation project, Point of Sales implementation, Grants Management , eSupplier Connection, and Inventory Management implementations.

I have met and and worked with FBI's Cyber Security team and my organization's IT Security division to assess, review and mitigate risks involving supplier portals, implementing controls for accessing sensitive data, HIPAA compliance and vendor impersonation and payroll frauds involved in checks processing.

I have been a founding member of IT department's Diversity, Equity and Inclusion core team that put together an action plan to promote DEI initiatives.

Overview

24
24
years of professional experience

Work History

IT Supervisor - ERP Program Manager

City Of Sacramento
11.2013 - Current
  • Responsible for managing City's ERP applications that include PeopleSoft FSCM, PeopleSoft HCM, Oracle Hyperion and iNovah Point of Sales system.
  • Managed projects and personnel - manage a team of business analysts, technical developers and system administrators in PeopleSoft Financials, HR and Oracle Hyperion applications.
  • Worked closely with executive team, project sponsors business owners and customers across the organization to plan, develop, coordinate and execute technical strategies aligned to client's vision, mission and purpose.
  • Liaised regularly with Managers and Directors from departments of HR, Finance, Budget, Public Works and Utilities to promote on-going system development, reevaluation and optimization in areas of Revenue (Receivables and Billing), Accounting (GL and Commitment Control), Budgeting (EPM, Commitment Control and Hyperion), Payables (AP, Travel & Expense), Supply Chain Management (Procurement, Purchasing, Strat Sourcing, Supplier Management, Inventory), Payroll (Time & Labor, Absences, Payroll for NA), HR(Core HR, Position Management, eBenefits and Open Enrollment).
  • Worked closely with Labor Division of HR in labor negotiations process to understand and implement approved contracts in Benefits, Absences and Payroll modules.
  • Worked very closely with management and SMEs from Budget office and HR departments to assist and deploy new budgets, Capital Improvement Projects (CIP) and Position Management during Fiscal year and mid-year budget cycles.
  • Created individual and program wide short term and long-term objectives, road map for technology enhancements, and oversee projects, daily operations and manage personnel.
  • Regularly met and worked with IT leadership from other teams to assess performance, risks, and cross-application integrations across organization wide business lines.
  • Oversaw Payroll distribution (labor distribution) and interfaces to process charges back and journals into Financials (GL).
  • Oversaw garnishment payment data from Payroll and create vouchers in AP for payment processing.
  • Oversaw bi-weekly payroll for 5000 FTEs and a monthly payroll for 400 pre-CalPERS retirees
  • Oversaw procure-to pay businesses including supplier contracts, requisitioning, purchase order processing. voucher processing, commitment control, and pay-cycle processing.
  • Involved in Scope development, fit/gap analysis, business requirements gathering, and provided deliverables for functional and technical designs for internally developed projects including PeopleSoft Security automation, PAR form automation, PeopleSoft Project (CIP) request automation projects.
  • Built test cases and managed unit, integration and user acceptance tests for PeopleSoft implementations, PUM upgrades, and Peopletools upgrade projects.
  • Interviewed, hired, trained and mentored staff by providing coaching, leading performance reviews and offering constructive feedback.
  • Highly knowledgeable in both functional and technical aspects of ERP systems including PeopleSoft FSCM. HCM and Oracle Hyperion architecture and provided subject matter expertise, technical oversight and guidance to the developers, analysts and customers.
  • Knowledgeable in PeopleSoft Test Framework and underwent the initial phase of scoping the project to build PTF.
  • Interacted and negotiate with vendors and contractors to secure goods and services.
  • Managed contractors on operational and large scale project deliverables.

Recent Projects:

  • Implementation of PeopleSoft Inventory module, deploying enterprise search using Kibana analytics and dashboards.
  • Managed server procurement, conducted requirement gathering and review for the deployment of analytics and dashboards for Diversity and Demographics in HR, and Budget forecasting and "Spend tracking" in Financials - with a targeted implementation of 12/2023.

Future Projects roadmapped:

  • Day 1 On-boarding in HR / Employee Self-service and Activity Guides
  • Lease Management implementation in FSCM
  • Building PeopleSoft Test Framework to build and maintain test scripts in FSCM and HCM
  • Build budget book in ePBCS

Past accomplishments:

  • Led supplier selection process and managed successful implementations of large scale projects including PeopleSoft 9.2 implementation, eSupplier Connection implementation, AP automation, Enterprise Learning Management Solutions and SSO implementation.
  • Implemented Single sign-on and Seamless sign-on for accessing PeopleSoft applications with Multi-Factor Authentication (MFA) by using Kerberos, OKTA and Appsian products and integrating with Portal Guard.
  • Managed and successfully deployed multiple PeopleSoft Application and PUM upgrades including versions 9.1, 9.2, with currently on Image 45 and multiple PeopleTools upgrades including 8.48, 8.53 and currently on 8.59
  • Communicated with IT director and IT infrastructure teams to maximize efficiencies and resolve technology issues while virtualizing application, web and database severs, upgrading databases, and implementing F5 load balancer.
  • Managed deployment of PeopleSoft Fluid across Financials and HCM including change management.
  • Managed implementation of Hyperion on-cloud (ePBCS)
  • Involved in entire lifecycles of software development during implementations of several projects in PeopleSoft and integrating with third party applications such as K2, Adobe eSign, ServiceNow, and Salesforce CRM.
  • Managed implementations of multiple modules in PeopleSoft FSCM and HCM including eSupplier Connection, Supplier Contracts, Strat Sourcing, Travel & Expense, Fluid Open Enrollment, On-Boarding, Security Automation, PAR processing
  • Reviewed and assessed architecture design, implementation, testing and deployment needs to identify project requirements and costs.
  • Led the implementation of AP automation project that involved centralization of supplier invoice processing.
  • Directly responsible for expansion of the team by putting together 3 new position justifications and getting them routed and approved through internal (IT) and external (Budgeting and Council approval) channels.
  • Put together budget requests for multiple projects that resulted in successful approval of Capital Improvement Projects (CIPs).
  • As the City's representative and point of contact for Oracle's PeopleSoft and Hyperion accounts, I am responsible for assisting in renewal and purchase of Oracle licensing, service and Cloud licensing fees and overseeing software agreements.
  • Active member in Oracle focus group and provide feedback to PeopleSoft product development team.
  • Active member in Quest Oracle Community (PeopleSoft users group) to communicate with users from other organizations to review best practices and new features.

Principal Applications Developer - Technical Lead

City Of Sacramento
05.2011 - 11.2013
  • Supervised technical team responsible for supporting PeopleSoft and Oracle Hyperion applications for City wide Finance and Personnel applications.
  • Implemented Oracle Hyperion – and replaced PeopleSoft EPM application that was at its end of life.
  • Technical lead on PeopleSoft 8.9 to 9.1 upgrade project.
  • Re-designed and developed Time and Labor rules, based on labor contract changes.
  • Redesigned and developed processes in Absence Management in 9.1.
  • Led implementation of banking project when City changed their primary bank from Bank of America to JPMC.
  • Developed annual process for Fiscal year setup in both Finance and HR.
  • Developed process to build annual Payroll and Holiday calendars in HCM.
  • Decommissioned printed paystubs and provided customized self-service pay stub screen to employees.
  • Developed custom self-service leave balance information page to Citywide employees.
  • Provided direction to development team in technical designs and assisted on issues that required high level of technical support.
  • Planned support strategies by meeting with other teams that included server and infrastructure team, DBA’s, subject matter experts, and power users.
  • Planned and prepared technical standards document and methodology for new developments and created guidelines for development work in PeopleCode, SQR, Crystal Reports, and SQL.
  • Designed and developed tasks, methodologies, and strategies for current and future projects.

Principal Applications Developer

City Of Sacramento
06.2009 - 05.2011
  • Developed applications and supported business processes in PeopleSoft 8.9 Finance and HCM in the modules of Billing, Receivables, Payables, Purchasing, e-Procurement, General Ledger, Treasury and Cash Management, HR, Benefits, Time & Labor, Absence Management, Payroll and Payroll Distribution
  • Involved in troubleshooting daily production issues and developing bolt-on projects and customizations
  • Developed reports and queries in SAP Crystal Reports, Oracle SQL, SQR and PeopleTools 8.54
  • Developed nVision reports in Treasury and Cash Management modules to track daily cash position.
  • Developed integrations between PeopleSoft Financials and Bank of America to exchange positive pay, ACH files, and inbound "bai" files to reconcile financial statements.
  • Developed new budget load process with data from PeopleSoft EPM into PeopleSoft Financials.
  • Developed a custom position load process to load approved positions during budget approval, using data from PeopleSoft EPM and loading into PeopleSoft HCM.

Senior PeopleSoft Consultant - Technical

ERP Analysts Inc
10.2005 - 06.2009
  • As a PeopleSoft technical consultant, I implemented multiple modules in PeopleSoft FSCM, HCM and EPM at multiple private and public sector clients that included CalPERS, CarMax, City of Sacramento, and Papa John’s.
  • I worked with Cherry Road Technologies on the ERP project at the City of Sacramento to implement multiple modules in PeopleSoft FSCM, HCM, EPM and Portal.
  • Technical lead on the implementation of Phase II of ERP implementation at the City of Sacramento that included PeopleSoft EPM, Retirees’ benefits enrollment, retiree payroll, Cash Management and Treasury modules.
  • Implemented PeopleSoft Portal and along with single sign-on access to PeopleSoft Financials and HR for the employees of City of Sacramento.
  • Led the development and implementation of AR, BI, ePRO, Gl, KK and PeopleSoft Security on Phase I of ERP implementation project at the City of Sacramento.
  • At CalPERS, I developed bolt-on solutions in PeopleSoft AR to track their short term and long-term receivables and tuned the condition monitor process.
  • At CarMax, I worked on assisting in the deployment and post production support of PeopleSoft upgrade project for AR, AP, GL and AM from 8.0 to 8.9 and implementation of ePRO and PO modules.
  • At Papa John’s, as part of the ERP Analysts team, I worked on designing and developing Asset Management Conversion program to load data into Asset management Loader Tables

Graduate Assistant

Indiana State University
08.2003 - 05.2005
  • Assisted faculty members with Unix laboratory setup, proctoring and grading exams for under graduate students.
  • Directed students in performing and completing assigned tasks.
  • Tutored under graduate students in Mathematics and Computer Science and assisted with their academic projects.
  • Participated in lesson planning and curriculum implementation to promote quicker rollout and delivery.

Software Programmer

MRM Computer Services
10.1999 - 12.2002
  • Analyzed and designed three relational databases using Oracle Pl/SQL.
  • Maintained existing applications and designed and delivered new applications in PeopleSoft AR and BI.
  • Worked closely with banking clients to establish specifications and system designs.
  • Performed regression and system-level testing to verify software quality and function prior to release.

Education

Masters - Mathematics And Computer Science

Indiana State University
08.2005

Bachelors - Computer Science and Engineering

University of Madras
Chennai, India
04.1999

Skills

  • Competencies: Project Management, Change Management, Program Management, Risk Assessment, Team Management, Employee Coaching and Mentoring, Solution Design, Technical Design, Vendor Management, RFP and Contracts Management
  • SoftWare Development Methodologies: Agile, SCRUM, Kanban, Waterfall, Business Process Re-engineering, JIRA, Mondaycom
  • ERP: PeopleSoft FSCM, PeopleSoft HCM, Oracle Hyperion, Infor 7i
  • Business Process Automation: K2, Adobe eSign
  • Enterprise Content Management: MicroSoft SharePoint
  • Technical Skills: PeopleTools, People Code, Application Engine, Integration Broker, Application Messaging, Web Services, REST APIs, Oracle PL/SQL, C, C, Java

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

IT Supervisor - ERP Program Manager

City Of Sacramento
11.2013 - Current

Principal Applications Developer - Technical Lead

City Of Sacramento
05.2011 - 11.2013

Principal Applications Developer

City Of Sacramento
06.2009 - 05.2011

Senior PeopleSoft Consultant - Technical

ERP Analysts Inc
10.2005 - 06.2009

Graduate Assistant

Indiana State University
08.2003 - 05.2005

Software Programmer

MRM Computer Services
10.1999 - 12.2002

Masters - Mathematics And Computer Science

Indiana State University

Bachelors - Computer Science and Engineering

University of Madras
RAMAKRISHNA BHATTIPROLU