SUMMARY:

• Twelve plus years of total IT and consulting experience which includes more than 5 years of workday global HCM Integration, implementation and post go live support across US and Canada.
• I am currently working as Integration lead for one of the top Confidential .
• Prior to this, I worked as integration consultant for payroll and benefits interface and compensation/advance compensation and core HCM implementation for Confidential 500 auto major, Canadian banking and telecom giants.
• Played multitude of roles such as Integration lead, Studio Developer, core HCM, compensation and advance compensations configuration, Workday report and Integration, workday security analyst.
• Having widespread experience in all aspects of workday Integration, configuration, security and application support including but not limited to Advance studio integrations, Picof and benefits integration, packaged integrations, Core connector, Confidential (inbound and outbound), Iloads, Tenant set up, business process configuration, domain security, business process security, data clean up, data validation, transformation and loading, advance reporting and integration, I am quick learner with acumen for problem solving and data analytics. looking forward to embrace all the emerging aspects of workday as an enterprise solution.

TECHNICAL SKILLS:

Workday HCM: Workday studio/advance studio, Workday advance Report Writer, RAAS, workday web service API using SOAP and REST, Confidential (inbound and outbound), Core connectors, Ilodas, packaged integration, integration with Service now, web service integration for single sign on, Work day core HCM , Compensation, advance compensation, PICOF and benefits integration, Workday data governance (Security analyst)

EDW/BI Tools: Informatica, Tableau, Advance Excel

Languages: XSLT, XML, HTML, Xpath, PL SQL, SQL, Bash scripting, JCL,COBOL,RPG, MVEL, Java

ECM tools: Confidential designer, AFP

IDE and editors: Workday studio, Eclipse, SQL developer, Oxygen

Project management and defect tracking: MS office suite, HP ALM

Design and modeling: MS Visio, MS power point, Adobe

Other Specialties: Pre - sales solution consulting and support, Client liaison, Multi-vendor/team coordination, Team lead, Project management

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Workday HCM Integration lead

Responsibilities:

• Involved as a core HCM lead right from the project kick off and helped in evaluating, Implementing and integrating Workday solutions for clients global workforce.
• Liaison with HRIS power users and other diversified teams to analyze the business process and integration requirements and devised strategy to implement them in workday
• Planned and lead the multi week joint application design sessions involving the existing HRMS SME and other stakeholder to identify the existing HCM architecture, organization structure, and Integration interface
• Worked with the SME to identify the GAPS and suggesting the alternate solutions for handling the requirement in the best feasible way
• Collaborated with the PeopleSoft technical team and the business users to understand and document the reporting and integration requirements.
• Used Confidential (Enterprise Interface Builder for bulk loading/hiring workers into the tenants. created custom reports to validate the data load inside the tenant as well as comparing with the source data outside the tenant using Excel features
• Designed build and tested core connector for worker, benefits for newly hired worker and sent the details to account provisioning systems
• Designed and developed complex studio assemblies involving multiple sources and end points related benefits providers
• Designed and developed the PICOF integration for payroll interface with ADP build the studio integration for interfacing the HCM data with SAP field glass.
• Worked as the single point of contact for issues and escalation related to implementation and support.
• Involved in tenet management and configured the domain security policies and business process security polices through workday delivered security groups and custom created security group to control and provide desired access to interested parties.
• Configured and created the supervisory organization structure and the subordinate.
• Configured the default organization assignment to the supervisory organization and configured the business process definition to control the reorganization and role assignment activities
• Identified and configured the staffing model for all supervisory organizations, configured the staffing related business process such as hire, terminate, job changes et al.
• Configured the business process for imposing the hiring restriction for both position management and job management worked extensively on job and position domain. configured and tested the business process definitions with desired steps for creating and editing the job profile and positions.
• Configured and tested the staffing related business process such as close position, manage hiring freeze .
• Configured the custom notification related to the status of the business process.
• Configured and tested all types of business process steps such as action, approvals, approval chain, TODO, checklist, consolidated approval, integration, System and review
• Provide subject matter expertise regarding key business process decisions related to industry and/or functional areas.
• Worked with Simple, Advanced Reports and matrix reports defining columns, business objects, fields, columns heading overriding, multiple sorting techniques, sorting by secondary objects.
• Configured and tested all the HCM transaction in workday such as creating position, creating pre hire, Hiring into supervisory organization with position management and job management, defaulting organization assignment, assigning roles based and user based security groups
• Configured the business process security policy related to entitlements for initiation, approvals, review, actions, cancel, rescind, delegation
• Identified and configured the domain security policies for different functional areas pertaining to protection/privacy of PII and organization data governance guidelines. This includes access of personal data as employee self service and manager .
• Worked on security of reportable items as part of identifying and scheduling the reports and also configured the securable action controlling access to tasks and activities

Confidential, Dallas, TX

Responsibilities:

• Worked as a lead to develop the compensation structure with a global foot print.
• Involved in requirement gathering and analyzing the existing compensation structure and prepared the Functional requirement document with the details of grades, plans and packages that constitute the compensation structure
• Identified the localization requirement and introduced the grade profile, plan, allowance profile and other localization techniques as needed.
• Identified the compensation elements for the enterprise and the related payroll earning and deductions. Configured the compensation elements linking them to the corresponding payroll earning and deductions.
• Worked in payroll integration to ensure proper linking of payroll earning to the desired pay group and pay period .
• Designed developed packaged benefits integration for Fidelity, Vanguard and healthcare providers.
• Developed the studio assemblies to transform, split and deliver payroll and demographic data to multiple end points
• Analyzed and configured different compensation plans needed by the organization. This included configuring salary plans, allowance plans, hourly plan..et al.
• Configured grades, grade profiles, plans and put them together creating the compensation packages and linked the compensation elements to the plan
• Identified and configured different compensation eligibility rules required for defaulting the compensation elements to worker position during staffing event such as creating position as well as hiring.
• Configured and tested the compensation eligibility rules for identifying the targeted population for the compensation event.
• Configured the default propose compensation to position event business process definition with all the sub process, actions and approvals.
• Configured the propose compensation and the related steps as the sub process of hiring event configured the compensation change business process relating to the job change
• Used and created the workday delivered compensation basis as well as configurable compensation basis to define the estimated earnings for targeted workers.
• Involved in testing the entire compensation workflow creation and troubleshoot of PICOF integrations
• After the Go live, involved in troubleshooting the day to day transaction and business process discrepancy issues and introduced hot fixes as and when needed.
• Conducted the system impact analysis for workday version upgrades and prepared the regression testing strategy and risk mitigation plans.
• Participated in defect triages related to compensation and payroll, helped in identifying the root cause and workaround for the time sensitive issues
• Involved in preparing and training material and planned training for power user as well as self service users.
• Worked in advance compensation related to merit planning. assisted higher management in merit planning by preparing ad hoc advance reports detailing the annualized compensation across organizations and geographies.
• Created the percent based merit plan and configured the eligibility rule to identify the eligible population for the merit plan.
• Executed merit plan rollout prior to the initiation of merit process and ensured all eligible employees are having the plan assigned to the package.
• Created exception rules for excluding the waiting period associates from the merit process
• Created the compensation matrix for linking the target merit increase percentage to the performance rating and compa ratio quartile.
• Created eligibility rules to introduce localization as and when needed.
• Configured the related business process steps for initiating merit process .this includes manage impacted employees, configure merit pool, distribute pool, launch employee merit et al.
• Worked on onetime payment plan using inbound Confidential . configured integration and prepared the spreadsheet template for loading the rewards as one time plan.
• Utilized advance excel features such as data validation, conditional formatting, formulas and VLookup to identify and fix data discrepancy, data validation and transformation leading to clean data load using Confidential .

Confidential Canada

Workday core HCM, workday security, Report writer

Responsibilities:

• Involved in the implementation from the scratch beginning with tenant set up and creation of supervisory organization and cost centers
• Worked as data governance lead setting up ground work for workday security
• Created user based and roles based security groups and the corresponding roles.
• Responsible for domain security involving the data items and reportable items.
• Streamlined the business process security policy as per the requirement
• Worked as a security admin and was responsible for maintaining the privacy of and integrality of workday data using the workday delivered security groups as well as custom.
• Troubleshoot the security related issues involving the access and restriction of data for different functional areas.
• Created job based and location based security groups to control access and bring localization
• Worked with reporting team to finalize the access related to the reportable items
• Extensively worked on business process definition configuration involving all different types of action and approvals, checklist.
• Created and configured the document transformation integration system for transforming the default CCW output from xml to delimited
• Working on post-implementation support and enhancements
• Participated in the design and optimization of all global HR processes. Ensured the Workday HCM system is Configured and leveraged to support HR business processes
• Developed various calculation fields on specific reports to pull the required data.
• Developed advanced reports wherein I had to use different business objects and related business objects .
• Worked on setting up scheduling of reports and understanding the required permissions for report sharing
• Configured the CCW with multiple integration services and used transaction log service to detect the change to personal data.

Confidential

Reporting, Integration, BAU support

Responsibilities:

• Analyze source systems and prepare the high level system flow, process flow and data flow diagram documents, business requirement document, functional requirement specification, data requirement document, and reporting requirement document
• Created several EIBs and Custom reports for demographic, Payroll, time and attendance data to meet the client business requirement.
• Created Integration system security user and group to get the access to the required domain and business security policy.
• Configured cloud connect for HCM (Core connector: Worker) to extract the employees demographic changed data.
• Built XSLT codes to generate output files in client-specified format.
• Built XSLT codes using XTT/ETV attributes for document transformation
• Setup compensation eligibility rules based on compensation grades and job profiles..
• Working on post-implementation support and enhancements
• Responsible for data migration from legacy systems to workday systems using Confidential
• Created workday advance workday reports with filter, prompts, sorting and group heading

Confidential

ETL/BI developer

Responsibilities:

• Documented and designed the technical specifications for interfaces/data conversion and validation Conducted gap analysis and created functional and technical specs
• Worked on integration of Application Engine Delinquency process with XML Publisher to generate Delinquency reports
• Involved in customizing the BI invoice report using XML publisher
• Generated error reports/files during data conversion as a part of the conversion process to handle the errors and send them to the users for cleaning/evaluation purposes
• Developed and modified the production control reports which help in identifying the data integrity in the PeopleSoft tables
• Created and scheduled jobs for Inbound/Outbound and Interfaces and tied them with PS delivered App Engine process to complete import, and export process as a batch.
• Created Informatica maps using mapping designer to transform the data pulled from PeopleSoft application to be loaded into EDW platform
• Worked extensively in pl SQL stored procedure for transforming the data and applying the business logic for reporting
• Worked on most of the Informatica transformation such as router, joiner, sequence generator, rank transformation, aggregator transformation
• Used tableau for generating the dashboard for higher management.

Confidential

Lawson mainframe developer

Responsibilities:

• Worked on the data migration project for migrating data to Lawson mainframe based file system and IMS data base.
• Worked as the technical lead for converting the application from home grown legacy application to Lawson enterprise solution.
• Worked as SME and identified the gaps to come up with specification document for the customization.
• Extensively worked on COBOL, JCL, VSAM and Intertest to design and develop applications for supporting the certification tracking
• Developed NDM jobs to transmit the files to interfacing application.
• Designed and developed the data records in format needed by Confidential designer
• Designed and developed the korn shell scripts to process the Confidential files using the Confidential engine to prepare the AFP file for document printing
• Prepared the reconciliation report and the companion file for running the statement composition batch application
• Designed and developed the tagged logical element to be used by CMOD for paperless processing

Confidential computer

Senior mainframe developer

Responsibilities:

• Involved in designing and implementing the rating process for auto line of business using COBOL programs and VSAM files and IMS DB DC
• Did the database design in IMS DB in order to hold the new data fields into the database and format them to the screen layout
• Worked extensively on the complex rate engine for premium computation part for auto line of business using the rate files.
• Solved the premium outage issues in reference to the policy premium processing over different transactions.
• Worked extensively on manually testing the complex rate engine for premium computation part for auto line of business using the rate files.
• Prepared and reviewed the test plan test case and technical design documents.
• Participating and conducting in weekly status and SCRUM meetings..
• Responsible for testing and implementing the large scale development and enhancement project.
• Ensured the optimal utilization of the available tools and utilities such as EXPEDITOR, QC, FILEAID for testing purpose.
• Engaged in prioritizing and planning the work execution
• Scoping - Analysis of systems and Business Processes involved based on the Business input