Data Manager

Teja Puttamsetti

Lead Consultant - Oracle Fusion Cloud HCM

Cell: 617-***-****

Email: adlxol@r.postjobfree.com

PROFESSIONAL SUMMARY:

Experienced and Energetic professional with 6+ years of hands on in HR and HR Information Systems and implementation of Oracle Cloud HCM Fusion applications by facilitating sessions, workshops, developing and delivering end-user training, project management, and preparing and presenting project briefings to executives.

Delivered optimum benefits, with technical proficiency, to employers and clients with deep belief in their missions Expertise in Oracle Fusion Cloud HCM offerings - Workforce Deployment (Global HR, Payroll, Workforce, Time and Labor (OTL), Absence Management) and Workforce Development (Talent Review, Performance, Goal and Succession managements. Compensation Management (benefits, Incentive and Total Compensation).

Strong Experience on Taleo functionality like Import candidates (ready to hire) from Taleo Recruiting to Oracle Fusion HCM using the TCC (Taleo Connect Client) Scripting process and Import-export schedule process errors resolutions.

Expert in delivery of the Oracle HCM Cloud applications, analysis of 'as is' and 'to be' business processes and mapping those processes to Fusion HR functionalities, defining and documenting Oracle and non-Oracle standard solutions.

Strong experience in Oracle OIC (Oracle Integration Cloud). Developed outbound integrations from Oracle Cloud HCM to third party applications by creating HCM Extracts, BI Reports and transforming them in OIC.

Installed OIC Connectivity Agents and configured the DB, File Adapter, REST and SOAP connections.

Developed complex inbounds in Oracle OIC using SFTP, SOAP, REST and File Adapters. Performed complex routing and transformation logic.

Developed VBCS Applications for the end users to manage the OIC inbound and outbound related data mappings.

Developed VBCS Application to display the Taleo import errors in Oracle HCM Cloud for the business users to review and take corrective action.

Developed REST Services using Oracle JDeveloper 11g and 12c for the VBCS Applications.

Extensively worked on Implementation planning, Fit/Gap Analysis, design changes and providing alternatives to the clients on product limitations.

Worked on complete lifecycle implementations involving Data allotment, Requirements gathering, Business Process Re-engineering, Configuration, Development, Troubleshooting, Training, and production support environment.

Experience in multiple full end to end life-cycle implementation of all major cloud modules in both fresh and conversion projects from various legacy systems.

Excel in interacting with the project team members responsible for developing reports, interfaces, data conversion programs, and application extensions and able to lead discussions during business requirement meetings.

Excellent ability to learn and deliver the assignments in given time frame and ability to work on multiple projects with excellent communications skills.

Experience in configuring and working with functional set up manager and enterprise level configurations across Oracle HCM Fusion Modules.

Experienced in configuring Workflow routing rules for all Manager Self-services (MSS), Employee Self-services (ESS), approvals, security configurations, handling daily HR transactional errors and BPM error handling.

Experience in Customizing Cloud HCM Security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract roles and well versed with aggregate privileges and assigning duty roles.

Extensively involved in Enterprise level design sessions and helped in HR and Payroll one-time setups and Involved in third party integration to and from Cloud HCM.

Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing phases.

Experience in Creating custom reports and analytics using OBIEE/OTBI (Oracle Transactional Business Intelligence), and BI Publisher in various Cloud HCM subject areas and good knowledge in HCM Extracts functionality and ODI(Oracle Data Integrator) tools.

Excellent experience in Design and develop HDL scripts to load SQL stored procedure for performing complex transformation which would require data from multiple SQL tables to create the HDL to load the bulk data into Oracle cloud Applications.

Developed many HDL (HCM Data Loader) files for conversion and data fix activities by creating custom BI Publisher Reports as per the business requirement. Developed HCL Scripts for complex business objects like Worker object which has five levels in object hierarchy, ranging from worker component to assignment, salary, grade steps and assignment extra information.

Developed HDL/BI Reports for very high volume of Employee data, more than 70,000 records, did through testing and reconciliation to make sure there are no performance issues or data errors.

Assisted end users with documenting new business procedures and test scripts for CRP & UAT.

Design, develop and maintain complex and highly technical custom applications in Oracle Cloud JCS (JAVA Cloud Service Extension) environment using ADF (Application Development Framework), OWSM (Oracle Web Services Manager), SOA (Service Oriented Architecture), BPEL (Business Process Execution Language), JAVA, SOAP/REST APIs.

Worked on testing and documentation for (Core HR, Payroll, Time and Labor, Absence Management, Compensation, Benefits, Security modules).

Developed BI (Business Intelligence)/OTBI (Oracle Transactional Business Intelligence) Reports in Core HR, Payroll and Compensation modules. Develop reports to report Salary history and incentives for the past 5 years.

Developed reports to track employees’ performance and write few day-to-day business specific reports like terms, Certifications and License expiry, Visa expiry information to business to trigger users to take next steps.

TECHNICAL SKILLS:

Oracle HCM Extracts, Oracle Fast Formulas, Oracle SQL and PL/SQL, Oracle ADFdi, HDL (HCM Data Loader), BI Publisher (Business Intelligence), OTBI (Oracle Transactional Business Intelligence), Putty, SQL developer, SQL*Plus, SQL*Loader, TortoiseSVN, WinSCP, ADF Business Components, Java Server Faces (JSF), Managed Beans, Model-View-Controller, Task Flows, DBCS, Java Script, XML, XSLT, SoapUI, REST Services, WebLogic server, J2EE, ALM, SVN, Unix, Oracle Fusion Applications, Oracle Cloud HCM, JCS, ADF, JAVA, VBCS.

EDUCATION:

bachelor’s in information technology from JNTU (2012).

Master’s in Information assurance from Wilmington University (2016).

PROFESSIONAL EXPERIENCE

Employer: Advantage IT Inc

Role: Oracle Cloud HCM Techno Functional Consultant

Duration: June 2016 – Till Date

Responsibilities:

Analyze each vendor requirements, create the design document and develop the interfaces based on each vendor specifications like no of fields, employee eligibility criteria, fields and file formats, and transmission of the file to each vendor location.

Develop a separate HCM extract for each vendor based on design document.

Write the SQL Queries to build the complex queries to use in Fast formulas.

Develop Complex Fast Formulas to dynamically derive HCM Extract Parameters for calculating various HCM or payroll related attributes like Salary, Bonus, Incentives and Over Time Pay.

Develop various types of BI (Business Intelligence) Templates like e-text template, XSL (XML Style Sheet) Template and RTF Templates to produce various fixed length report layouts, Excel Reports and PDF Reports.

Create Custom Value Sets to overcome the limitation of custom SQL Functions in HCM Extracts and derive various Employees, Payroll attributes from the HCM Database as per the business requirements.

Develop the relations between each data points like Person, Assignment, Terminations, Salary and Document of records etc.

Develop SSH File Transfer Protocol (SFTP) scripts to send the secure files to above vendors.

Develop the process to schedule the interfaces based on vendor frequency specifications to move the files automatically to vendor location.

Log the interface errors, which will be used for troubleshooting in case of any issues.

Create schedulers to execute the process/services for specified intervals.

Custom Applications Development using Oracle Cloud JCS (ADF/DBCS/VBCS) environment.

Build complex transaction synchronization logic to handle large volume of transactions involving multiple servers and databases. Perform high degree of application tuning to minimize the network load, latency and significantly reduce the bandwidth and storage related costs associated with various cloud software vendors. Out of the box thinking while integrating nonflexible cloud applications with business-critical applications.

Create the REST and SOAP web services to pass the data between Oracle Applications and JCS environment.

Create objects to parse JSON, SOAP, XML, REST messages and apply message transformation to convert to XML/fixed length data.

Develop services to read input files as UTF-8 encoded, convert to xml and apply data transformations.

Oracle Bulk data loads, Custom Reports development and Oracle Compensation Technical Integration.

Caesar hires many employees at one time during World Poker Series, Las Vegas every year. This requires loading Bulk Employees and their compensation Information, which includes Personnel, Gaming Licenses, Salary, Employment and Rewards information into Oracle HCM cloud Application.

Caesars recently acquire Centaur Holding LLC, which starts the moving all Centaur employees into Caesars Oracle HCM Applications. This require creating many bulk data loads from Centaur to Oracle Caesars Cloud HCM application

HDL (HCM Data Loader) is the format that requires creating for each data load into Oracle cloud Applications. Each HDL object has different format, so understand the data and create the Oracle SQL Tables and PL/SQL packages, procedures and functions to create the HDL load files for each (Employee, Job, Salary and certificates) load.

High degree of SQL Query performance tuning by reviewing complex SQL Query execution paths, trace files and construct the best optimizer hints to ensure the best consistent performance with the applications developed.

Support Testing and Production fixes; create supporting documents required for design, development, unit testing and deployments.

Configured various levels of employee and manager portraits and dashboards. Specialised BI reports for talent management modules and helped in developing HDL’s, HCM Extracts for Global HR, Absence and Talent modules.

Worked on Integrations development Taleo HCM (Hire, Re-hire, Workforce Structures) Inbound and Outbound Integrations.

Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions.

Worked on Oracle Recruiting Cloud and Oracle Learning Implementation.

Support testing teams for the services hosted in Oracle Cloud Applications and JCS ADF Appliances.

Communicate with business/application teams to gather requirements and create a high-level design documents, mapping documents and service level design documents.

Create deployment instructions document for admin teams.

Create deployment builds for respective production releases and validate post deployment.

Support SIT/UAT/Performance testing support for the services developed for every release.

Monitor live traffic to verify response times and volume.

Support maintenance team for any issue in production and apply fixes if any by process.

Troubleshoot for any issues and apply fixes.

Developed various HCM Extracts/BI Reports for Global HR, Payroll Interface.

Generating templates for Employee, Organization and Department imports into Taleo Cloud using TCC integration.

Data Loading/Conversions using HCM Data loader (HDL) and spreadsheet loaders.

Developed custom HCM Extracts, BIP Reports, OTBI Analysis and implemented the new concept of Infolets for Dashboards.

Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions.

Developed BI publisher reports in Benefits, HR and Payroll area and developed HCM Extracts for various interfaces.

Handled complete technical team and integrations in phase-I of the project from Fusion to third party applications like Taleo and ADP Payroll.

Developed the reports using scheduling triggers to notify the Developed OTBI reports for HR users to view and validate employee data using existing subject areas. Subject areas are functionally secured using Oracle Fusion Duty Roles.

Worked on Web Services like REST/SOAP for Integrations.

Creating and modifying WSDL files.

Facilitated Workshops for Business Requirement gathering, CRP and UAT.

Assisted end users with documenting new business procedures and test scripts for CRP & UAT.

Documenting Business requirement for the new integrations from Taleo to Fusion HCM.

Expert in setting up enterprise structure, workforce structure and span business process like understanding and interpreting fast formulas, profile and workforce directory management and Security (Security Profiles, Data, Job and Duty Roles), HCM Data Loader (HDL), HCM Extracts.

Managing & creating Flex Fields like Extensible, Descriptive Flex Fields, and Values Sets.

Implemented Core HR, Benefits and Compensation modules as part of Phase-I of the Project and currently implementing: Goals, Performance, Succession Planning and Talent Review as part of Phase-II of the project.

Extensively worked on Goal Plans, Questionnaire, Performance scale, Appraisal Template and Performance Document under talent management sections.

Running workshop sessions analyzing client requirements and recommending future state process and solution design in CRP (Conference Room Pilot) Programmer.

Analyze business requirements and developing effective configuration solutions.

Responsible for business requirements gathering, process analysis and design, gap analysis, functional system design and specification, development of system tests, business process procedures and training documentation.

Lead the Conversion team for complete migration of 7 yrs. Historical core HR and Talent Data from Legacy system using: HDL and PBL.

Extensively used Security Console to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.

Developing project plan and deliver in line with Fusion Implementation Road map and Methodology.

Demonstrating the expertise in the design, execution of implementation and testing.

Person Selection Fast Formula - To run the benefit evaluation processes.

HCM Extract Rule Fast Formula - To identify the Pay group change.

Common configurations in Core HR area like DFF, EFF and lookups. Setting up the DFFs at Job and Assignment Level to capture more information.

Driving and documenting business requirements and procedures obtain sign off to ensure client alignment of proposed solution.

Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes. Provided business consulting support and facilitates discovery workshops.

Developed the Fast formulas for Applaud time entry, Accrual plans and Input validations - (Oracle Fast Formula, PL/SQL, and AOL components).

Fast Formulas for Fusion HCM Extractions.

Person Selection Fast Formula - To run the benefit evaluation processes.

HCM Extract Rule Fast Formula - To identify the Pay group change.

Configured security objects including Management Hierarchies, Regions, Locations, edited Domain and Business process security policies, Tenant setup and created reports to meet customer requirements.

Worked on requirements, process flows, and solution design of the modules for an R12

Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.

Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies. Set up and Maintained Enterprise structure and Workforce structures.

Experience in working both tier and three tier employment models with single and multiple assignments.

Worked on coexistence model integrations, HCM extracts, BI publisher OTBI/OBIEE.

Managed functional support for core HR process, Compensation, Business Process and Security Groups.

Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality. Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM).

Provided roadmap document, executive summary, and strategy for upgrade to current release for two modules, Absence Management and Time and Labour.

Expert understanding and configuring legal entities, Legal employers LDG, Business unit set assignments, job configurations, employment models and distinguish tree setups.

Worked on allocated checklists for the onboarding asset management and scheduled worker/managerial tasks. Interpreted areas of responsibility tasks in the Cloud HCM.

Worked on Absence Integrations with Payroll, OTL and Workforce scheduling.

Involved in Complete Functional Setups for SSHR, OTL and PTO modules.

Developed Functional and Technical Design document for HR, OTL, Absence Management and CWB Extensions.

Generated analyses using OTBI for Global HR, Goal and Performance Management subject areas.

Created various accrual and qualification absence plans and absence types where employees are restricted so that they can record absence only of a specific duration.

Configured medical and personal leave categories and pulled the same to the HR and Payroll reporting purposes.

Proficient in preparing E-Text template & RTF file formats for Absence, Core-HR & Talent modules.

Configuring the performance templets and making the changes into the template in multiple languages.

Implemented Performance module and integrated annual and quarterly templates for the compensation workbench.

Worked on profile rating models, review periods, questions and questioner templates also implemented annual performance process flow.

Implemented end to end performance and goal management and extensively worked on adding and editing the goals, setting the status of goals and deciding the accessibility of goals.

Configured various levels of employee and manager portraits and dashboards. Specialised BI reports for talent management modules and helped in developing HDL’s, HCM Extracts for Global HR, Absence and Talent modules.

Designed custom reporting and interfaces to meet client and audit requirements.

Supported client in Oracle Cloud UI personalization's and customizations for end users and coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import-export schedule process errors resolutions.

Streamline Recruiting & On boarding processes with Core HR applications.

Configure Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA), Configure Source Tracking, Evaluation Management, Recruiting Centre (welcome centre, Theme& Logo, Communications Channel in Taleo Recruiting.

Ensured that applications meet business requirements and systems goals, fulfil end-user requirements, and identify and resolve systems issues.

Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.

Experience with configuration, testing, cutover and production support.

Manage Enterprise HCM Information and Legal Entity HCM Information.

Set up and Maintain Enterprise structure and Workforce structures.

Work with consulting partners on the Conversion tasks, Integration tasks, Security tasks, and Reporting tasks.

Responsible for HR System maintenance including security, tax updates and patches, setup, and configuration of PeopleSoft foundation/transaction tables, including Payroll tables, Benefit tables, and Time and Attendance data.

Expertise in writing and modification of Fast formulas used in Oracle Payroll.

Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.

Involved in the complete testing of the Employee Transfers and 2-Tier and 3-Tier employment model.

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Design Interfaces for the OTL.

Implement Core HR, Employee Self Service, Manager Self Service, Payroll, iRecruitment, Performance Management, Succession Planning, Talent Management, Compensation Work Bench (CWB), Oracle Advanced Benefits, Learning Management, Oracle Time and Labor (OTL), Oracle Labor Distribution, General Ledger & OBIEE.

Worked on Design and development of integrations with Time and attendance, Recruiting & Benefits systems.

Created data pump API to import third party transactions into Labor distribution systems.

Created Web ADI Interface to import non-oracle transactions into Labor distribution systems.

Responsible for writing fast formulae and PL/SQL Functions for OTL Validations.

Worked with the business in understanding the HCM cloud features and analyse the feature that best fits the business requirements.

Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.

Develop HCM Extracts/OBI Reports for Global HR.

Involved in end-to-end test cycles and prepared the test scripts and scenarios required to test various business cases.

Involved in Regression testing of multiple offerings.

Tested all the tasks and business process flows related Payroll, Global HR, and Talent Management.

Handled regression testing and file path migrations for inbound and outbound process.

Client: Graks Info, India

Role: Oracle Apps Consultant

Duration: Jun 2012 – July 2014

Responsibilities:

Attend Business Process and Knowledge Transition Sessions with IT & Business Owners and Mapping Customers requirements into Oracle.

Involved in various Functional setups of HRMS, Payroll, Inventory, Purchasing.

Interacted with client during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Application for CANADA localization.

Documentation (BR100, Setup document), design and validation of setup. Requirements mapping, configuration, issue resolution, training, testing and support for HRMS and SCM.

Involved in resolving day-to-day issues in the support environment.

Maintaining issue tracker, took part during Go live in the Production.

Contact this candidate