HCM/Financials Data and Reporting LeadWorkday Certifications:HCMReporting(Advanced and Composite)Sierra-Cedar delivers consulting, technical, and managed services for the deployment, management, and optimization of next-generation ERP applications & technology. The Company partners with Oracle, Workday, Amazon Web Services (AWS), MuleSoft, Salesforce, and Splunk.Sierra-Cedar was founded in 1995 and is part of The Sierra-Cedar Group, Inc., one of the largest independent North American IT services companies. In the US, the Company is a leading provider of ERP services for Oracle PeopleSoft, Oracle Cloud ERP and Workday applications and serves three distinct client verticals: Higher Education, Public Sector excluding Federal, and Commercial. Together with its Canadian affiliate, Sierra Systems Group Inc., it has approximately 2,000 professionals focused on the US and Canadian markets with global delivery capabilities in both countries and Hyderabad, India.To learn more about Sierra-Cedar, please visit www.sierra-cedar.com

Architect responsible for creation of sophisticated end to end BI/DW solution, turning disparate ERP system data into information that can be readily consumed by any level of audience.Responsible for design and development of- Extraction scripts from variety of ERP solutions including Oracle EBS and PeopleSoft for all major modules- Transformation and load utilities using Pentaho Kettle product- Business-centric, public sector/higher ed specific data marts for Financials, HCM, Procurement and Projects and Grants- Over 60 custom reports and analyzers, providing eye-opening insight into all aspects of data warehouse. This includes creation of Mondrian schemas and aggregate tables to support every aspect of analytics.Developed strategic planning solution using enterprise level open source tool allowing the creation, tracking, maintenance and reporting of strategic plans for all levels of municipalities.

Manager of all workforce systems and coordination, including human resources, payroll, benefits and recruitment. Manage US and India-based team and onsite consultants with regard to scheduling and activitiesManage and evaluate technical estimates of project work for and related to HR, AP, AR, PO, GL, PA being performed US and India teamsManage all HRMS projects from definition through migration, including technical and functional resourcesCreate and maintain all AIM documentation for projects and technical developmentDesign and build interfaces to third party providers using PL/SQL and System ExtractCreate and maintain management reporting on production support and project statusCreate and edit reports using EiS reporting tool (transactional datawarehouse)Work with end users to establish project definition and user requirements for all technical developmentCollaborate with DBA team in migrations from Test to QA to Production using ITSM change management system.Applications Used:HRMS - including HR, Payroll, Benefits, RecruitmentPAPOAPGLFAiExpense

Served as lead development and support analyst providing direction and management of all HCM related projects. Managed technical projects as well as hands on involvement in developmentCreated and implemented concise development standards and methodology for entire Oracle development team of 6 Oracle analystsTechnical Manager for implementation of Microsoft Dynamics AX Financials, HR and Projects fresh install for EuropeDesigned and built reports and interfaces using concurrent manager and system extractImplemented Self Service HR 5.0 for Manager and EmployeeDesigned and led training on AME and System Extract for end users and developersApplications Used:HRMS - including HR, Payroll, Benefits, Recruitment,PO,AP,AR,OM,iProcurement,iExpense

Technical and functional lead in support of Oracle Applications Managed 2 employees and up to 4 contractors in both direct and matrix environmentCoordinated contracts for on and off site development resourcesDesigned and implemented technical department procedures and employee on-boardingManaged all integrations of HRMS data through 5+ acquisitions of increasingly larger companiesFormed and led team to implement Oracle Interconnect(now known as BPEL) for all web order processing including orders, customer data and invoices processed through Oracle API’s and interface tables using SOA methodologyManaged all aspects of Saba Learning system from project management to hands on developmentProject manager and technical resource for implementation of OSB and Compensation WorkbenchCreated and maintained Discoverer reports for all applications and a vital member of team to implement Oracle DBI (precursor to OBIEE). Also designed and led training for end users on Discoverer use and featuresResponsible for implementation of Business Objects to satisfy data warehouse needs for all Oracle applications, including defining ETL needs as well as report definitions. This involved requirements gathering from user community and involvement in contract decision for purchase of data warehouse solutionKey member and technical lead for reimplementation of full Oracle suite of applications when moving to version 11i. This included AP,AR,GL,PO,PA, HRMS,CRMApplications Used:HRMS - including HR, Payroll, Benefits, RecruitmentPO, GL, AR,PA, OTL,AP, iExpense,FA,CRM,OM, Inventory

Technical consultant for multiple on site client engagements. Clients included: City of Chicago, Wake County Public Schools, Gaylord Entertainment, Char-BroilDesigned reports using Oracle Reports and DiscovererDesigned and implemented data conversions from legacy systems using Oracle API’s, including large legacy conversion of City of ChicagoDesign and build custom interfaces to and from Oracle using PL/SQL and UNIX scriptingCreation of Visual Basic macros for use in automatic work structure loading using ODBC technologyApplications Used:HRMS - including HR, Payroll, Benefits, Recruitment