SUMMARY

• 7+years of diversified IT experience in Consumer Goods, HR analytics, Services Industries, financial Domain.
• Certified Implementation Specialist ofOracleBusiness Intelligence Application 7 for ERP andOracleGlobal Human ResourcesCloud2017 Certified Implementation Specialist.
• Data Loading/Conversions usingHCMData loader (HDL), PBL and Spreadsheet Loader which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Strong Experience on Taleo functionality like Import candidates (ready to hire) from Taleo Recruiting toOracleFusionHCMusing the TCC (Taleo Connect Client) Scripting process and Import - export schedule process errors resolutions.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• OracleFusionHCMCloud- building reports, analytics and dashboards using theOracleBusiness Intelligence Publisher reporting tool.
• Experience in developing custom reports using BI Publisher and Fusion Benefit, Compensation, Absence Fast Formula and Knowledge inHCMextract,
• Data Conversions usingHCMData Loader (HDL) tool.
• OracleTaleoCloudCustom Integrations between FusionHCMand Taleo recruiting and onboarding.
• Developed Taleo OTBI reports and Dashboard.
• Involved in development of Interfaces, Reports, Fast formulas, Scripts, data migration for various clients and assisted them in enhancing their business processes.
• Experience with all components within Oracle's BI Applications (OBIEE) including configuring RPD, creating and managing OBIEE Dashboards, OBIEE Answers, Agents/ iBots, Presentation Services, BI Server and BI Publisher, DAC and Extraction Transformation and Loading using Informatica.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions
• Experience in creating and building ElastiCubes and Dashboards using Sisense BI Tool.
• Experience inOracleBI Apps (OBIA) and strong Working knowledge withOracleEBS modules of HR Analytics.
• Integrated OBIEE with EBS for Single Sign On (SSO) for Users.
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Expertise inOracleDAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Conducted design sessions with data owners toward capturing business requirement for an analytics environment.
• Working closely with end user community to enhance and improve the user experience architecture look and feel
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE,OracleBI Apps, Informatica Power Center.
• Experienced in troubleshooting production issues and production support for projects.
• Unique combination of personal, analytical,technicaland communication skills

PROFESSIONAL EXPERIENCE

Sr Oracle HCM Cloud Technical Consultant

Confidential, Houston Tx

Responsibilities:

• Data Loading/Conversions usingHCMData loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Data Loading/Conversions usingHCMData loader (HDL) and spreadsheet loaders.
• TaleoConnectClient(TCC) integration file configuration and data mapping
• GeneratedTaleoConnectClient(TCC ) scripts to import data intoTaleoas well as exporting data fromTaleo.
• DataExtractionfor HR Fusion implementation project.
• Trained onOracleFusion Financials,PrimaveraP6and Hyperion Reporting. Certified inOracleFusion Financials
• Worked on projects which involved designing and developing interfaces for complete Back-to-Back modules of Order Management,OraclePricing, and Shipping,inventory, Receiving, and purchasing modules.
• Launched the first virtual event over multiple time zones in the US, EMEA and Asia, "OracleEPPMVirtual Summit", for the Construction and Engineering Business Unit with over 2,500 live attendees, virtual library, virtual Connect Zone, exhibit booths and presentations, generated close to $3 million in sales pipeline.
• Developing Informatica mappings/ Mapplets using various Transformations forExtraction, Transformation and Loading ofdatafrom multiple sources ofdatawarehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Ensured reporting and appropriate project documentation are properly completed, manage RAID logs and reporting the project status inEPPM.
• Performed functions related to the set-up, documentation, business process design, implementation and support ofOracleApplications EBS (12.1.3) financial modules and Supply Chain (OM/Inventory/Purchasing/AR/AP/GL).
• Performed drop ship set-ups. Setting-up Drop ship warehouse, created external items forInventory, and developing programs to automate receiving through ASNs and closing the Sales orders.
• Developed SQL Loader control files and PL/SQL Programs for loading data into interface tables from data files for all the financial modules. Defining Concurrent Program Reports Using SQL Loader.
• ImplementedOracleEBS 12.2.4 for its business. This project was to design, develop and implement enhancements to the application and to provide bug fixes.
• Worked as a senior resource to co-ordinate withOraclefor Fusion Cloud R12 and R13 upgrades to make sure all security and existing functionality should be as is and actively involved in Pre-upgrade and post upgrade activities.
• Worked on SetupOracleAdvance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in OAB and modified the Configurations at different levels to followOraclerules and hierarchy of Eligibility and Electability rules.
• Lead Design sessions with Business Stakeholders to gain insights into customer needs. This includes understanding of the business objectives / problems, brainstorming ideas and solutions, creating high level user stories and wireframes of the application, collecting direct feedback on these user stories and wireframes on-the-go and constantly refining them during the session and finally conceptualize and record the important points discussed and agreed upon.
• Built Custom Security for FusionHCMwhich includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Developed programs to automate requisition process by doinginventoryanalysis such as min-max analysis, supply lead-time, ABC analysis, and reorder points.
• Imported candidates (ready to hire) from Taleo recruiting to Cloud (Fusion)HCMusing ImportOracleTaleo recruiting Cloud Service Data Process.
• Managed configurations, process mapping, and issue remediation for Core HR, Employee/Manager Self Service, and Absence Management in an implementation and provided functional design for all Absence Management Fast Formulas.
• Created the user-defined criteria using the Manage User-Defined Criteria task in the Plan Configuration work area. Added the user-defined criteria to an eligibility profile using the Manage Eligibility Profile task.
• Implementing Workforce Deployment, Talent Management (Goal management, Performance management, Talent Review and Succession) and Security.
• Build resources and Cost loaded Projects schedules usingPrimaveraP6andMicrosoft Project.
• Developed Custom BI / XML Publisher reports for On-Hand-Quantity available for all the items in every Sub-Inventorywhich belonged to a particular Organization in theInventorymodule.
• Creating baseline Project Schedules usingPrimaveraP6and Microsoft Project.
• BeingOracleFusion expert provided best-practice guidance onHCMbusiness processes.
• Ad-hoc reporting as per client's requirement and developed Concurrent Programs and Executables for the SQL Loader, Package and Report and run them as a request set. Demonstrating the expertise in the design, execution of implementation and testing.
• Responsible for successful testing of developed solution including User Acceptance Testing and working with the users to validate the solution.
• Created the criteria values to use the eligibility profile and Associate eligibility profile with the relevant benefits or compensation object.
• Designing and - Salary/Merit Increase, Bonus /incentive Plans; and HR/SSHR/ Recruitment Workflow Approval for the hierarchy's approval, Payroll Human Resources, OTL, Hire to Retire
• Coordinating withOraclefor SRs, new product releases, upgrades/patches/fixes. Developing project plan and deliver in line with Fusion Implementation Road map and Methodology.

Oracle HCM Cloud Technical Consultant

Confidential, Des Moines, IA

Responsibilities:

• Worked asOraclefunctional consultant/Analyst as part ofOracleFusion implementation for Core HR Performance and Compensation Modules. Also, Worked asOraclefunctional consultant as part ofOracleHRMS implementation forOracleCore HR and Absence Management.
• Data Loading/Conversions usingHCMData loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Deploy OraclePrimaveraP6for Improved project efficiency and reduced risk.
• Created and analyzed scheduling, EVM, and risk withPrimaveraP6and Crows Nest ERP System.
• Provided technical support onOraclePayables,OracleReceivables, Purchasing Procure to pay andOracleInventorymodules.
• Expert in designing and developing interfaces to external 3rd party systems such as SAP, PeopleSoft, Maximos, Kofax, Lucernex from all Financial andManufacturingmodules using SOA suite, Rest APIs, web services, flat files, and SQL Loaders,EDIs.
• Facilitated monthly financial status meetings with team lead to review current spend vs forecast, conducting variance analysis (when required), and producing program financial status report. Also, responsible for tracking actuals inEPPM.
• Loaded Core HR data, Payroll data usingHDL, PBL and SSL from source system to target system.
• Data Loading/Conversions usingHCMData loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Worked on successful implementation and integration ofTaleoRecruiting and Tress via TCC (TaleoConnectClient).
• Provided support forTaleoconnectclientTCC scripts
• Provide ongoing troubleshooting and internal support forTaleoapplications (Recruiting/ Onboarding) includingTaleoConnectClient(TCC) and all associated scripts
• Import candidates (ready to hire) fromTaleoto Fusion CloudHCMusing the ImportOracleTaleoRecruiting Cloud Service Data process.
• OracleApplication Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters are extensively used in the process of development.
• Import candidates (ready to hire) fromTaleoRecruiting to FusionHCMusing the ImportOracleTaleoRecruiting Cloud Service Data process and Import-export schedule process errors resolutions.
• Worked on buildingHCMintegrations with various third-party applications includingOracleTaleoand health care companies
• Developed complex person security profiles, organization security profiles to support the complex custom criteria while configuring the job and data roles.
• Work with Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures. Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Worked with business users to gather requirements for CoreHCM/Payroll/AM to prepare designs for HDL Conversion, Integrations and BI Reports inHCMcloud.
• Involved inOracleTaleo Cloud Custom Integrations between FusionHCMand Taleo recruiting and onboarding.
• Involved in requirement gathering, analysis, and design for global Implementation & Support and performed gap analysis between business requirements and Fusion modules- Global HR and Compensation.
• Involved in migration project from Peoplesoft HRMS toOracleHCMas well as participated in end to end implementation project ofOracleFusion Cloud.
• Assisted client in extracting data fromOracleHCMby providing table mapping between PeopleSoftHCMandOracleHCMCloud.
• Performed payroll workshops demonstratingOraclepayroll functionality and processes. Gathered requirements related to payroll configuration inOracle.
• Built an Outbound interface fromOracleHRMS to theOracleTaleo. The interface primary handles all candidate data who are hired with different nationality.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.

Oracle HCM Cloud Technical Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Developed interfaces Built and used API's inOracleE-Business suite (EBS) Financials and HR Modules. Worked on Creating Discoverer andOracleDBI (Daily Business Intelligence) Dashboards.
• Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them toOracleHCMCloud functionality.
• Ability to create manage and disbursing project status reports and entering status appropriately in the enterprise project management reporting tool (EPPM).
• Built the Timecard Approvals using the workflow system.
• Automated Email Notification using the OAF, and Workflow Builder Tools.
• Customized Requisition Form using Forms Personalization /OAF. Set up and troubleshot OAFPersonalization when moved from one environment to another.
• Coordinated instance strategy and served as liaison between functional and technical teams.
• Gather Core HR (Enterprise), Compensation, Absence business requirements and map them toOracleHCMCloud functionality.
• Involved in the Integration & support to ADP applications used by client withOracle(11i and R12).
• Configurations related to Absence Management and Talent Management.
• Identified business requirements for CoreHCM, Absence, compensation, Performance and map them toOracleHCMCloud Application functionality.
• Developed BI Reports/OTBI inOracleFusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
• Prepared several OTBI reports including customized reports for mostHCMmodules and Involved in raising SR withoracle& interacting withoracleteam to solve SR related issues.
• UseOracleFusion Functional Setup Manager (FSM) to implement enhancements.
• Build Custom Security to FusionHCMwhich includes Create/Modify Data roles and its SecurityProfiles, Job Roles, Application Roles and Duty Roles at APM, OIM and Security Console.
• Excel inOracleHuman Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.

OracleHCMAnalyst

Confidential, Irvine, CA

Responsibilities:

• Worked for Demantra project. Modified the custom hooks program to meet the client business requirement. Confidential has been using Symphony for their demand management. This application has been the primary demand management engine.
• Custom hook procedure was modified to bring in the additional attributes at item and location level hierarchy. Standard integration between oracle planning and Demantra do not populate additional levels as per the business requirement.
• Following are the business requirements for item level hierarchy: 1. Display business unit name for the item, 2. Display parent item, 3. Derive item life cycle, Following are the business requirements for location level hierarchy Display Theater, region and country for the location hierarchy.
• Developed the code to create the items in Demantra that does not exist in E-Business. Developed code to insert the data in BIIO tables as per the business requirements.

Oracle Apps Consultant

Confidential, Clara, CA

Responsibilities:

• Drafted and maintained business requirements and align them with functional and technical requirements.
• Supported the Development ofOracleextensions and support skills
• Provided input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Delivering business process and user requirements documentation to my seniors in the company.
• Involved in the requirements gathering and analysis, design, development, testing and debugging of analytical, optimization and decision support systems.
• Work closely with stakeholders within each customer account to identify their work flow processes and business challenges to create a Business Requirements document and project plan in regards to the successful implementation.
• Worked closely with the Leadership team, on regular customer updates, with potential risk and up sell opportunity.
• Assisted in Implementation,, show case demos till the product is well stabilized at the User end. Insights and metrics driven reports for clients.
• Performing business analyses of possibility to add additional modules to existing system and updating existing modules to add additional functionality.
• Assisted campaign management, event analysis along with the digital Marketing teams and Performed GAP analysis.