Data Manager

Shashi Reddy B

Mobile: 609-***-****

Email: ******.****@*****.***

Summary:

* ***** ** ** **********, around 4 years of experience in Workday involving various activities like Integrations, Reports, Functional and Requirement gathering, Analysis, Design, Development, Testing and Go-Live, Support phases.

Good knowledge of EIBs, Inbound/Outbound Integrations, Core connectors, Studio, Report Writer, and Calculated Fields.

Created Custom Reports used Calculated fields when necessary while creating reports in core HR, Benefits, Payroll, Finance.

Researched issues developed workarounds and assisted end users.

Hands on experience in creating integrations EIB (Inbound/outbound), Cloud Connectors, DT, Studio, XSLT.

Maintained studio integrations within the organization, responsible for bug fixes, debugging of the integration.

Extensive experience in designing and developing conversations, integration, interfaces, reports and online customization.

Commendable knowledge in developing applications using Programming languages like XSLT, XTT, ETV.

Proficient in understanding HR modules like Benefits, Payroll, compensation, Recruiting, staffing, Talent Management, Business process.

Mass Loading Data through EIB through Inbound Integration & Launching/ Scheduling Integration for data transfer to Third Party Vendor through Outbound Integration.

Worked as a Techno/Functional consultant in the upgrade of PeopleSoft 8,9.0,9.1 HCM.

Expertise in Resolving the issues related to HRIS and Benefits Administration.

Prepared documentation for changes functionality due to upgrade.

Very strong in Software Development Life Cycle of PeopleSoft Applications using Application Designer, Pages, Menus, People Code, SQR, Crystal, Security, Process Scheduler, People Tools, People Code/Tracing, Workflow, Integration Broker, WSDL, Component Interface, File Layout.

Participated in Project management activities - Issue resolution, Interaction with implementation team, risk management, project status reporting.

Skilled at performing GAP analysis, SWOT analysis, Cost benefits analysis and Feasibility Analysis.

A quick learner with strong Analytical & Communication skills. Excel in building Customer relationships.

ADDITIONAL INFORMATION:

Operating Systems Windows: Windows, Linux, UNIX and Mac.

Programming Languages: C, C++, SQL, HTML, JAVA, Python.

IDE: Eclipse, Workday studio.

Database: Oracle, Microsoft SQL Server and MS access.

ERP: Workday, PeopleSoft.

Reporting Tools: SQR, Crystal Reports, PS Query, XML Publisher, simple, Advance, Matrix, Composite, Trending.

Workday Integrating Tools: EIB, iLoads, Studio IDE,Web Services,Exchanger XML tool, PeopleSoft Tools, People code, SQR Package, VISIO

Office Suite: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Ms Office 365, Share point.

Professional Experience:

Role: Workday Consultant

Client: AbbVie Inc - Waukegan, IL January 2018 to present

Responsibilities:

Consulting with clients on a variety of data integrity to identify/resolve all issues that could impact project scope and/or time frame.

Conducted and Involved in business meetings for requirements gathering.

Created EIB’s, CCW, PICOF/PECI, Studio.

Responding for queries by email, phones.

Work with third party support to define issues (cases) and test fixes prior to deployment.

Analysed the functional configuration changes, reports, Core Connectors based on business requirements and helped the developers on what changes to do.

Experience in preparing Business Requirement Document (BRD) and Functional Requirement Document (FRD) for all the reports, EIB and Core Connectors.

Responsible for administration of HRIS, including but limited to mass updates, maintenance of organization structures, job codes and tables, configuration of system in line with business requirements and regular maintenance (some routine data entry).

Creates, maintains and supports a variety of standard and custom reports, queries and metrics to provide business insight into human capital data in line with reporting governance model.

Tested the reports, EIB and Integration.

Help in post Go-Live activities.

Update the FRD for reports, EIB and Core Connectors according to the changes.

Clarified QA team issues and Reviewed test plans to make sure that all requirements will be covered in scripts and tested properly.

Environment: Workday 30, Workday Report Writer, Workday Studio, EIB, and Cloud Connectors, XML/XSLT.

Role: Workday Functional Consultant

Client: AIG- Charlotte, NC March 2016 to Dec 2017

Responsibilities:

Day to day support of HCM, Security & Reporting issues.

Designed and configured BP for HCM, including Hire, Change Job, Termination.

Worked on the creation of job families, job profiles, and positions. Configured the Organizational structure by setting up organizational units, jobs, positions, assigning tasks to jobs and positions, and Reporting Structure.

Design test plans, scenarios, scripts or procedures.

Building complex reports with use of advanced calculated fields.

Experience in BP Configuration.

Experience in creating positions, Hire, Transfer, Configuring Hiring Restrictions, Termination, Compensation etc.

Created custom reports and scheduled the reports.

Monitor supervisory orgs to inactivate those no longer in use/needed.

Responsible for design Supervisory organizations, Cost Center, Cost Center Hierarchies and location hierarchy’s maintenance, and modification of Work Business Processes and definitions.

Created many reports with simple, advance, matrix and composite.

Created functional document for script development, testing execution, defect tracking.

Environment: Workday 27/28 (Core HR, Benefits, hire to retire), XML/XSLT, ETV& XTT, Workday Report Writer, Workday security, workday Benefits, Workday Studio, EIB,iLoad and Cloud Connectors.

Role: Workday Integration Consultant

Client: CDW- Vernon hills, IL May 2015 to Feb 2016

Responsibilities:

Created an integration that establishes worker records in Kronos and updates the records when changes occur.

Track worker time and attendance through the Workday integration with Kronos Workforce timekeeper.

Worked on different types of reports, EIB, CC, SI

Created Inbound/Outbound EIB's to receive/send benefits data from workday to external vendors like Wage works.

Developed Fidelity 401K Integration using Workday Studio to send Employee contributions pre-tax amount based on Payroll Schedule.

Worked on core connectors with document transformation - ETV and XTT transformations

Developed to bring in daily worker data changes to Workday by using studio.

Experience in developing studio integrations, EIB and Core connectors.

Provided Mentorship and Design documents for Reports and Integrations.

Strong knowledge of MS Office to include: advanced knowledge of Word, advanced Excel capabilities.

Environment: Workday 26/27 (Core HR, Benefits, hire to retire), XML/XSLT, ETV& XTT, Workday Report Writer, Workday Studio, EIB, iLoad and Cloud Connector.

Role: Workday Techno-functional Consultant

Client: Curvature -Santa Barbara, CA Jan 2014 to April 2015

Responsibilities:

Created and modified and launched integration systems and integrated sequence generators.

Designed both inbound and outbound EIB (Enterprise Interface Builders) integrations in various segments of workday system.

Updated employee's organizations, locations and compensation using inbound Enterprise Interface Builder (EIB).

Good knowledge of data sources, primary business objects and secondary business objects.

Converted and validated North American Payrolls for USA. Worked with different business process related to hiring and recruiting and performed root cause analysis.

Worked with team to review system features in correlation to current processes. Developed and debugged functional tests for workday applications.

Configured Cloud Connector for benifits for Delta Dental, United Concordia, and Express Scripts to send Benefits Enrolment data to Benefits Providers.

Documented workflow, configurations, business process for e Performance module using Excel, MS project and Visio.

Participated in Workday Communities to remain connected with Workday and customers.

Environment: Workday 22/23/24, EIB, Core Connector, XSLT, Data Cleansing, MS project, MS Office, Excel, Raas, SOAP, CCB.

Role: PeopleSoft Techo-funtional consultant

Client: CUNY, NY Dec 2011 to Oct 2013

Responsibilities:

Created complicated SQL’s and PS Query reports related to student admission data, student records data, student payments and student Financial Aid to assist college bursar, Registrar, Financial advisors, and campus admissions team to make informed enrolment decisions.

Created ad_hoc reports and scheduled PS Query reports in PeopleSoft HR/campus solutions module and Microsoft SQL database.

Maintain accurate entries into the applicant tracking system (ATS).

Performs onboarding and accurately records administrative actions into the ATS.

Created SQL’s and PS queries which are not available in HOBSONS RETAIN data ware-house and scheduled them for use in the Production environment.

Analysed the tables present in CCNY data ware-house identified and rectified inaccurate tables and created a query in the reporting instance and scheduled queries to update inaccurate data elements.

Helped the city college bursar department, professors, and IT members on how to use and search in the PS query viewer, PS query manager and PS query scheduler.

Closely worked with the campus functional team to resolve the defects in the CCNY data ware-house.

Created SQL’s and PS queries useful for the EAB and HOBSONS online retention systems.

Explained about design and customization of tables and panels and adding new options using People Tools.

Analysed the payments table and explained to the users how the PeopleSoft tables run and created queries.

Helped the IT department identify inaccurate student data and explained the reason for the data errors by analysing the student’s data through student summary and query manager.

Providing training for all aspects of enrolment operations at any given time.

Developing most effective coding format for translating values between CUNYfirst and external systems.

Train staff on the use of 3C’s, duplicate ID procedure and other skills for CUNYfirst application.

Knowledge of HOBSONS radius functionality for prospective student identification and retention within CUNY

Environment: PeopleSoft HCM 9, Security, ORACLE 11G/12C, Microsoft SQL database, PeopleTools 8.50/54, SQR and Windows 2003, Application Designer, Peoplecode, Application Engine

Role: PeopleSoft Technical Consultant

Client: OSI SYSTEMS -India October 2010 to September 2011

Responsibilities:

Involved in design and customization of tables and panels and adding new option using People Tools.

Generated reports using SQR and Crystal.

Responsible for Test Plan, Defect Report Status, and Knowledge Transfer Documents.

Uploading the test scripts from MS Excel to Test Director.

Developed and executed the SQL queries to fetch the data from PeopleSoft HRMS (Oracle).

The fetched data has to be analysed against the bridge database and it should be reported if there is any deviation.

Integrated third party hiring application with PeopleSoft System using Component Interface program and loaded data into PS tables

Unit tested the developed application and created test scripts and test cases for the Unit Testing and System Testing

Developed technical specifications for customization issues/resolutions and for custom reports and interfaces explaining the process flow.

Closely worked with the functional team to resolve the defects created during the UAT (User Acceptance Test)

Performed troubleshooting the problem areas in setting up HR tables that serve as the foundation of HR system and in producing HR reports.

Fine-tuned the long running batch process by efficiently tuning the SQL’s and bringing down the running time

Developed and modified several SQR

Environment: Peoplesoft HCM 9, Security, Oracle 11G, Microsoft SQL database, People tools 8.50/54, SQR and Application Designer, people code, Application Engine.

Role: Software Engineer

Client: Canara Bank-Bangalore, India Jan 2009 to Sept 2010

Responsibilities:

Performed Key role in Upgrade task.

Gathering client's business requirements

Involved in the design, development and testing of all HR, Payroll, Benefits.

Customized HR, payroll menus, enquiry pages as per the user requirement so that can view more information.

Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu, and Permission Lists.

Conducted training for functional team

Customized SQL Views, records, and People code functions like SQL Exec, Scroll Select

Used Advanced SQR techniques Arrays, Dynamic SQLs, Database links, On-Break, and Load lookups for creating the complex Multiple Reports.

Reapplying the customizations on V9.1 in terms of SQR's, components and People Code

Experience in retrofit of SQRs during upgrade from V8.9 to V9.1

Generating the new Inbound and outbound SQR Interfaces that well suited to the Business Requirements.

Prepared Unit Test Scripts for Unit Testing.

EDUCATION:

Bachelors in Electrical and Electronics Engineering from GITAM University

Contact this candidate