Madhu G. Janaki
************@*****.*** Ph:917-***-****
Summary
I have around 19+ years of experience in IT and 4+ years of experience working as a Workday Integration Developer.
Experience in all phases of the Workday implementation lifecycle namely - Requirement gathering, Analysis, Design, Development and Testing.
Strong experience of designing, developing, testing, and deploying integrations into and out of Workday, Workday Finance Modules.
Well versed with creating and modifying integrations using Workday technologies - Workday Studio, EIB’s, Core Connectors and PICOF and PECI integration; SaaS architectures.
I have experience in Regression testing of integrations during Workday system updates/upgrades, creating technical documentation.
Technical Skills
ERP: Workday
Workday Technologies - Workday Studio, EIB’s, Core Connectors and PICOF and PECI integration
Big Data: HDFS, MapReduce, HBase, Pig, Hive, Scoop, Flume, Oozie, Zookeeper
NoSQL Database: Hbase, MongoDB
Relational Database: Oracle, SQL Server, DB2, MYSQL.
Business Intelligence Tools: Axiom SL, QlikView, Pentaho BI and Tableau
Programming Languages: UNIX Shell Scripts, VB Scripts
Operating Systems Windows, UNIX/Linux, UBUNTU
Defect Management Tools: JIRA, Team Track, HP Quality Center, ALM
Tools: MS Office Suite 2000, Manual Testing, QTP, SaaS architectures
Business Skills
Designed business flow diagrams Proficient in working on Supervisory Organizations, staffing model, recruiting, Hiring process, Onboarding, Custom organization, Termination, Payroll, Benefits, Training, Performance Management, Talent Management and Financial Systems.
Hands-on Team Leader with strong focus on Documentation, Communication, Process and Constant Improvements.
Managed Offshore-Onsite model and experienced in implementing outsourced projects from planning to delivery phase.
Employment History
The Home Depot, Atlanta, GA
Senior Workday Integration Consultant
Dec 2018 – Present
Responsibilities:
Hands on experience in inbound/outbound integrations Using Core Connector, Workday Studio, managing business processes, working with EIB, Report Writer, Creating Workday Calculated Fields and Custom Reports.
Experience with XML, XPATH and XSLT.
Good Problem solving, Client Interaction, Training and Team building skills.
Created Inbound Studio integrations to update external payroll deductions data coming from external vendors.
Configuring payroll interface to send pay data to external payroll vendors like ADP
Created outbound EIBs to send data to other systems like RBC, Manulife and Merill Lynch.
Created Inbound Studio integration to update employee data into WORKDAY from Kronos, SAP and Computershare.
Good understanding of Integrations including Web Services, SaaS, Workday Architecture, Business Process Framework.
Thorough Comprehension of HR processes such as Recruiting, Hiring, Employee record maintenance, Payroll,
Benefits, Training, Pay Planning, Performance Management/Talent Management and Applicant Tracking / Onboarding.
Manager / Employee self-service etc.Good Problem solving, Client Interaction, Training and Team building skills.
Manage integrations between Workday and third party systems
Involved in Design, Development and End to End Integrations Testing.
Environment: Workday,Web Services, XSLT, SOAP, DB2, JIRA, IDB
FedEx, Memphis, TN
Lead Workday Integration Consultant
Dec 2017 – Nov 2018
Responsibilities:
Using Workday technologies - Workday Studio, EIB’s, Core Connectors and PICOF and PECI integration
Versatile team player with ability to perform under stress.
Developed and built inbound and outbound Integrations using Workday Studio, EIB, Core Connectors and Document Transformations.
Designed and Developed a set of integrations to integrate Workday HR and Recruiting System.
Created Supervisory Org, Staffing Models, Job Profiles, Position, Job requisition for Validations and good understanding on Organizational management, Position and Job Management, Staffing model, Hire.
Configured Hire Business Process following Position Management Staffing Model according to the Business
Needs
Integrated Workday with external vendor software.
Experience with Offshore-Onsite model.
Environment: HCM (Recruiting) Workday Studio, Workday Report Writer, EIB, Cloud Connectors, XML, Web Services, XSLT, Workday
ADP, Alpharetta, GA
Workday Integration Consultant
Oct 2017 – Nov 2017
The Work Opportunity Tax Credit, or WOTC ("wot-see") tab contains the integration with ADP to check employee eligibility for tax credits. Tax credits are provided to companies hiring individuals from certain target groups who have consistently faced significant barriers to employment.
When an applicant reaches this step during the application process, it will prompt the applicant for information needed to fill out the 8850 Tax credit form. The integration with ADP will then automatically determine if the employee is eligible for federal tax credits and update the employee record in Workday.
Responsibilities:
Participated in Requirement gathering, Analysis, Project planning, Cloud implementation, Test case design and execution for new Workday implementation project.
Created Supervisory Org, Staffing Models, Job Profiles, Position, Job requisition for Validations and good understanding on Organizational management, Position and Job Management, Staffing model, Hire.
Leveraged robust Workday Web Service API framework to load Assessment results into Workday via Workday Studio development
Created Integration System Security Groups, assign domain security policies and assigned to Integration System User.
Involved with all aspects of HR processes, comprising the life cycle of an employee such as recruiting, hiring.
Created new integration to pull the new hires information using Workday Studio.
Configured Hire Business Process following Position Management Staffing Model according to the Business Needs.
Environment: HCM (Recruiting) Workday Studio, Workday Report Writer, EIB, Cloud Connectors, XML, Web Services, XSLT, Workday29/30
Remedy Partners, New York
Workday Integration Consultant
Jun 2015 – Sep 2017
Remedy Partners, largest health care solutions, empower healthcare providers to develop and operate patient-centric episode of care payment programs leading to improved clinical outcomes, lower costs and increased patient satisfaction. Bundled Payments represent an important advance in the organization and financing of health care services for a patient’s episode of care. Federal and State governments, as well as HMOs and large employer groups, are using bundled payments to accelerate the shift from fee for service to value based payment programs.
Responsibilities:
Created various integrations both inbound and outbound using Workday Studio, EIB and Core connector, CCB and Custom Reports.
Created and used calculated fields in reporting, business processes, integrations and other areas within Workday.
Design and build integrations for loading Payroll, Compensation packages including but not limited to (Salary, allowance, commission, Annual Merit and Bonus using the Shared Participation Functionality) Benefits Data etc. using Workday.
Created Several Custom Reports and Exposed as Web Services for several vendor files.
Created Supervisory Organizations, Cost Centers, Location and its hierarchies.
Changing the supervisory Organizations, Inactivating an Organization and moving the workers into different Supervisory Organizations.
Assigning Organization Roles, Assigning User based Security Groups
Contracting Contingent workers, convert contingent workers into Employees.
Staffing Movements, An employee changes in position, inbound process and outbound process.
Termination Process, initiate termination process, review termination process, to do tasks
Event Management, Finding the event, Task Reassignment and Requesting the reassignment, manage delegation settings, Editing the tenant setups- Business Process and Notifications
Hire into Position management, hire into Headcount management and Job Management.
Designed and developed a set of integrations to integrate Workday Financials with Accounts Payable, Accounts
Receivable, Procurement, Banking, Credit Cart, and Tax system
Experienced in object Management Systems like Role Based Security, User Based Security, Job Based Security groups. Integrated PICOFs with payroll vendors.
Payroll Interface to manage employee changes into the third-party system
Leveraged robust workday Web Services API Framework to load payroll inputs into workday via Workday Studio Development. Worked On data transfer from tenants to SFTP, FTP
Created ad hoc reports Expertise in SQL, Eclipse, XML, XSLT and Web Services Technologies.
Environment: HCM (Compensation, Benefits, Recruiting, Talent Management, Payroll and Time Track), Workday Studio, Workday Report Writer, EIB, Cloud Connectors, XML, Web Services, XSLT, Workday 25,26,27,28
Automotive Resource International, Mount Laurel, NJ
Business Intelligence Developer
Aug 2012 – May 2015
ARI Fleet Management offers a wide range of fleet services from global consulting to risk management. ARI delivers solutions that improve their fleet customer’s business. Working closely with customers to solve complex problems with fleet vehicles, have a combined business insight and optimal lifecycle analysis, best-in-class services and high-powered technology to drive vehicle fleet efficiency up and costs down using Big Data Technology .
Responsibilities:
Developed QlikView Dashboards using various QlikView objects like Charts, List Box, multi box, Table Box, Button, text box and containers as per business needs.
Expert level skill in integrating data using QlikView.
Worked on Incremental Loading to reduce the reload time of different applications.
Solving Modelling issues like Circular loops and Synthetic keys.
Used variables, set analysis, mapping functions and custom templates for P&L statement and Balance sheet in QlikView. Worked closely with Data Modelers in designing various data warehouse schema techniques
Environment: .NET, Unix, Oracle, SQL Server, SAP HANA, Qlik View, XML, HP ALM
CITIGROUP, Newport, Jersey City, NJ
BI Developer
Jan 2009 – Jul 2012
Project: CITI Connect
CitiConnect for files - A file based high volume transaction and information delivery solution. Citi Connect for Files is a global gateway for file transmission and translation that effectively integrates payments, receivables, and information with your accounting, ERP and other financial systems. Via a single delivery channel. CitiConnect for Files is the most cost-efficient solution for transmission and receipt of files from anywhere in the world. Clients send different standard and custom file formats for processing such as IDOC, PAYMUL, CP2E, ISO XML formats, ANSI, DIRDEB etc. The core Project deals with improving end-to-end approach for secure Transaction processing, the overall customer experience and achieving the vision of satisfying all the customers’ financial needs.
Responsibilities:
Designed pilot system using Pentaho Kettle for ETL enhancements and Pentaho BI Server for publishing the Pentaho Reports on user funds transfer measures.
Used Mondrian based engine for deploying various cubes for reporting purposes in tomcat.
Used to schedule various reports in the user console. Designed and maintained a wide variety of reports.
Used Slowly Changing Dimension in different jobs for star schema dimensions.
Imported data into the database using Pentaho Data Integration.
Identified the tables for defining the queries for the reports.
Designed and produced reports in various formats such as CSV, PDF and Excel using delivery mechanisms such as e-mail, and Web.
Environment: JAVA, Oracle, Pentaho BI, UNIX, Team Track
CITIGROUP, Wall St, NYC & Newport, Jersey City, NJ
Software QA Test Lead
Dec 1999 – Dec 2008
Project: CITI File Exchange
CFX is designed to be the client file delivery backbone to cash, global payments and the collections network. The main feature of CFX is that the customer can monitor their files and transactions via a web browser enabled application with the ultimate aim to empower the client. Through the browser screens, the client is able to maintain their own system set-ups and monitor their files and transactions in order to reduce the need for internal intervention and maintenance.
Responsibilities:
Hands-on Team Leader with strong focus on Documentation, Communication, Process and Constant Improvements. Followed Agile Process (SCRUM) throughout SDLC.
Involved in implementing Global Payments like Cross border/ International Funds Transfer Domestic Funds transfers, Book transfers, ACH Payments, Check payments, SEPA Payments, CHIPS, FEDWIRE, SWIFT and CHAPS.
Subject Matter Expert in Banking messaging standard like Swift Messaging, Flat Files, CP2E, SAP IDOC, EDIFAT, ISO XML and ANSI
Environment: Oracle 10g, TIBCO, Java J2EE, Team Track, QTP (Quick TestPro) 11.0, HP Quality Center, Ms-Office,
SQL Server, ETL Tool (Ab Initio), UNIX.
Education
Degree
University
State
Bachelor of Engineering in Computer Science, 1996
Osmania University
India
Awards and Recognitions
Awarded with “CITI STAR” for being unselfish through Collaboration and Empowering Others for the year 2012