SUMMARY

• Overall 9 years of IT Industry experience as Software professional in designing, implementing and supporting Workday and Database\BI systems, 4+ years as a Workday Consultant in developing Integration and Reports using Workday Tools. Supported the implementation on the Workday platform by defining, documenting and testing functional business processes for Workday HCM including Core HR, Recruiting, Talent, Performance Management and Periodic Compensation.
• 5 years as a SQL BI Developer with expertise in analyzing, designing, tuning,data modelling and actively involved in development of BI components and enhancement of new business processes.
• 5 years of Extensive experience as a Workday Integration Consultant in analyzing PeopleSoft documents, reports, queries, SQLs etc. and transforming them into Workday Technical design documents.
• Proficient in agile scrum methodologies and experienced with SDLC using Waterfall, Agile and Software Testing Life Cycle (STLC)
• Workday Integrations experience with Core Connectors, Studio, Web Services, BIRT.
• Experience in Workday Reporting including calculated fields.
• Detail oriented professional with hands on experience on application development process from requirement elicitation, analysis, designing, development, testing, deployment, and post - production support
• Expertise in T-SQL Programming.
• Designing ETL solutions using Microsoft Business Intelligence tools.
• Administration and Development of Packages (SSIS), Reports (SSRS).
• Experience in query optimization & performance tuning.
• Data Migration from legacy to New system.
• Experience in using DMV and dynamic management functions.
• Troubleshoot performance problems, fine-tuning of databases and index analysis.
• Experienced in Creation and Maintain of Documents (Tech Specs, Functional Specs and Release documents)
• Strong troubleshooting skills and experience resolving first level issues.
• Excellent planning, organization and prioritization skills to meet ever changing demand & Support capability
• Working Experience in Analytics using Power BI.

PROFESSIONAL EXPERIENCE

Confidential

Workday Report and Integration Consultant

Responsibilities:

• Provided support for Workday inbound and outbound integration issues, changes to existing integrations and develop new integrations.
• Worked on integrating the time and expense file from SAP CONCUR into Workday Payroll.
• Developed many outbound integration for different Benefit vendor like Metlife, BCBS,Aetna and PayFlex using cloud connector and pre-built vendor Integration template.
• Built integration to link Workday HR system with Confidential Middleware application to feed data to multiple downstream systems like S4, APTOS POS etc.
• Built inbound/outbound integration with Learning Management system DOCEBO using API call.
• Provided post production hyper care support for Workday Implementation.
• Involved in developing of Payroll integration with Payflex using template “Payflex FSA, HSA, Commuter (Payroll)” .
• Developed Benefit Integration using HIPAA-834 Integration Template for Aetna.
• Developed several reports using Workday Report Writer like Salary Changes, Severance, Payroll Earnings, Medical Enrollments, Vision, Salary plan etc. reports as part of Implementation.
• Worked on Workday Data Migration through iLoad and spreadsheets
• Created custom reports and modify/troubleshoot existing custom reports.
• Write, maintain, and support a variety of reports and queries - both standard and custom
• Worked on Calculated Fields to create Report level and Global calc Fields.
• Worked on Workday delivered Configurable Integration like vendor specific connectors. Worked on Core connectors by using Generic templates.
• Good experience with Core Connector worker to work on employee demographics and build Benefit integration.
• Involved in sending data to IT Operation teams to give access to new hires and remove access from closing accounts for workers on downstream services.
• Created complex Inbound/Outbound integration using workday core/cloud connectors, using EIB's, document transformation process.
• Configured Workday benefits including groups, plans, coverage types, event types, and eligibility rules.
• Created External payroll organization and assigned roles and created pay groups for third-party payroll.
• Designed regression testing scenarios for the integration during upgrades.Leveraged robust workday web service API framework to load data inputs into workday via EIB Inbound Integration development.
• Worked on Agile methodology as a Software development life cycle for collaborating with the Cross- functional teams and end user.Involved in unit test on Integration, UAT support and end user training.

Confidential

Lead Report Developer

Responsibilities:

• Responsible for loading Newly Merged Employee Data, Compensation Data, Commissions Data to Workday using different EIB's.
• Import SQL Server data to Workday using SSIS.
• Worked on Workday conversion processes and tools like iTool, EBI, Workday Studio etc
• Worked alongside the integration team to configure and test integrations between the Workday solution and the client's selected payroll and benefits providers
• Create EBI with workers data.For this I wrote SQL queries to extract data from database and extract it to EIB.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Utilized Microsoft TFS in order to share the code with other programmers and as a source control.
• Created change controlled documents which help us keep track of all the changes and in the final deployment
• Also got some hands on experience in developing PowerBI dashboard.