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)