We provide IT Staff Augmentation Services!

Sr. Workday Integration Consultant Resume

SUMMARY

  • Having over 11+ years of experience in HCM modules (Ultipro & Workday) and Data base Analyst with expertise in HCM data conversion (Ultipro to Worday), HCM integration with Internal/External vendors, Database design, Database Management, Database Tuning, converting database, modifying and repairing table corruptions, Creating and customizing SQL Stored procedures and handling Replication, Ad hoc reporting utilizing such languages/applications as SAS, Microsoft ACCESS, EXCEL, SQL.
  • Proficient in transforming the data by using XSLT. Extensive in designing and developing Integrations, Creating Reports and Calculated fields. Skilled in integrating IT/PeopleSoft applications in the process for accomplishing greater effectiveness.
  • Configuring EIB (Inbound & Outbound), Core Connector (CCW/CCB) and developing Studio integrations (Outbound & Inbound) to integrate with third party systems.
  • Worked as a Lead Data conversion & Integration admin for one of the leading US investment firm as a part of current assignment. Helping them in Data migration and setting up various integrations from Ultipro to Workday.
  • Maintaining and updating employee data, ensuring data accuracy, preparing reports and statistics, performing data analysis, and identifying data discrepancies.
  • Expertise in managing projects involving - Requirement gathering and validation, Risk assessment, defining data design approach, planning and execution.
  • Strong experience with utilizing SQL for data retrieval.
  • Strong knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
  • Experience in Oracle golden gate replication.
  • Setting up of regular backup, archival methods, and regular testing of recovery in test environment.
  • Taking Secondary Backups using Export and Loading the data back to the database using Import utility
  • Expertise in Software Development Life Cycle (SDLC), Object Oriented Analysis and Design Methodology.
  • Excellent written, communication and Interpersonal skills.
  • Expertise in coordinating multiple priorities, managing customer expectations, creating partnership with customers, and problem solving
  • Extensive experience in managing multiple projects spread across different geographical locations and in onsite - offshore working model.

TECHNICAL SKILLS

Technologies: C++, Java Programming

Database: Oracle v10i, 11g, Microsoft SQL Server 2008 to 2012

Tools: Ultipro Back office, Workday Studio & Workday Extend & EIB, Staspack, AWR, TkProof, Export and Import, Explain plan, SQL Server Agent

Data Security: Backup & Recovery using RMAN

OS: Windows, Linux & Unix.

Servers- Web servers: Web Sphere, Weblogic,Tomcat,JBoss

PROFESSIONAL EXPERIENCE

Confidential

Sr. Workday Integration Consultant

Responsibilities:

  • Configuring EIB (Inbound & Outbound), Core Connector (CCW/CCB) and developing Studio integrations (Outbound & Inbound) to integrate with third party systems.
  • Designed and developed integrations, using EIBs, core connectors and workday studio, and deployed into workday tenant.
  • Performed impact analysis and Do Not Use Fields’ analysis/fix to prepare for the Workday release twice a year.
  • Creation of Technical design documents and migration documents for the integrations developed, enhancements performed, and issues rectified.
  • Provided delivery support and assistance for custom integrations to subdivisions in Nationwide.
  • Established a custom integration which allows a Retirement Plan Sponsor to use the Workday software to transmit contributions and ACH information to Nationwide, for purposes of recordkeeping their retirement plan
  • Created a studio outbound to send location mail codes to internal business entities
  • Analyzed requirements and developed advanced reports to retrieve position data, pay groups and sup orgs, transformed to a pipe delimited file using XSLTs, associated it with an EIB to send the data to a data archival division in Nationwide for their ETL.
  • Developed integrations with third party payroll vendors like ADP, Equifax, Yello Inc Benefit vendors to send payroll & benefit data.

Confidential

Technical Data Analyst/ Integration Admin

Responsibilities:

  • Managed and maintained HRIS systems (UltiPro)/Workday for over 20,000+ employees.
  • Scheduled and performed Internal/External integrations, mass data changes and conversions.
  • Lead Data conversion from Ultipro to Workday of various HCM applications (Payroll, Compensation, Performance, Recruiting, Absence and Learning).
  • Involved in data conversion from legacy system and creation of Iload files
  • Coordinated integration activities across various external vendors (ADP, TALX, Willis towers Watson, Fidelity & RR Donley).
  • Extensive experience in implementation, development, customization, upgrading, integration & production support.
  • Strong understanding of Workday’s Web Service functionality & XML/XSLT
  • Ability to create/support complex Workday calculated fields and custom reports
  • Ability to design, build, test, and get approval for new integrations in the future
  • Understanding of Workday Core Connector/Document Transformation and Workday Cloud Connect Technology
  • Ability to read an error log and explain what they mean and have the ability to debug
  • Workday subject matter expert (SME)
  • Ability to work in a team environment as well as autonomously
  • Ability to multitask for various components of complex projects
  • Database activities on MS SQL server 2008R2. Migrating database and creating instances.
  • Create complex stored procedure, tables, view & Data types.
  • Schedule/Manage SQL Server agent jobs. Ensured that HR related data was ready for payroll processing (i.e. new hires, pay rate changes, terminations, etc.)
  • Provide a front-end BI reporting tool such as Business Objects/Crystal Reports or Cognos that allows us to write professional and polished looking reports and provides the ability to export reports into various formats such as Excel, PDF, etc
  • Allows for Scheduling/distribution of reports to end users, either via self-service access in a portal, or by automated emails.
  • Create a script to import data to SQL server database from different source of input.
  • Managing SProcs, Views and user roles.

Confidential

Data Analyst

Responsibilities:

  • Worked as a Data analyst helping client in Data design & reporting and doing capacity planning for Global Trade Repository (GTR).
  • Understand the Application functionality, architecture details and component metrics along with workload characterization.
  • Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
  • Helped design custom data models that integrated with Oracle Applications.
  • Integrate Oracle Database with reporting tools like IBM -GMS, Data stage & Autosys in order to run the EOD jobs.
  • Monitor EOD jobs and analyze the report in GreenPlum.
  • Maintaining data replication to different data centre using Oracle golden gate replication.
  • Supporting testing and development team for data issue during data replication/migration.
  • Running Jobs in VBlock environment, migrating the job's to different batch servers. Changing scripts or changing configuration according to the requirement.
  • Retrieved data from data warehouse on both Oracle 11g and SQL Server 2008-2005 database, and generated a series of meaningful business reports using SSRS and Crystal Report XI, 2008, validated and tested the reports, then published the reports to the report server
  • Successfully loaded large volume of Internet web log data into Oracle 11g database, and did data analysis, generated varieties reports using Crystal Report XI-2008 about user behavior. Used UNIX shell scripts with SQL commands embedded to create user & table and load data to the table.

Environment: QA Environment, PSE (Unix, Linux & windows)

Confidential

Data analyst

Responsibilities:

  • Worked from client site location (United Kingdom) to gather and understand the requirements of data design & reporting architecture.
  • Prepared Business flow documents for the identified business flows.
  • Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
  • Designed and implemented error checking and correction protocols and programs.
  • Built Internet access and GUI interfaces to Relational Database Management Systems (RDBMS).
  • Coded, tested, debugged, documented, and maintained programs.
  • Created detailed project outlines, application design specifications, and test plans.

Environment: QA Environment (Linux & Citrix windows)

Confidential

Oracle DBA

Responsibilities:

  • Worked as Offshore Database engineer and I was responsible for Maintenance of Oracle Databases as per the requirements
  • Working with infrastructure and development teams to setup required test environment
  • Check Alert Log errors and make necessary actions to rectify them
  • Creating and adding data files to primary database storage structures.
  • Database Objects designing and Space management
  • Creation of users, profiles and Granting specific privileges and roles to the users
  • Controlling users through Password management and resource management
  • Setting up of regular backup, archival methods, and regular testing of recovery in test environment.

Environment: QA, DEV,PSE Environment (unix & windows)

Hire Now