SUMMARY:

• Over 3 years of experience in Information Technology in implementing, configuring, analyzing, customizing, reporting and administering ERP software's such as Workday HCM, and experience as individual Workday Functional consultant, ADP eTime, benefits, human resource policies, procedures, and related financial accounting information. Also over 10 plus years of rich experience in Database administration and analysis.
• Supported the implementation of new client on the workday platform by defining, documenting and testing functional business process HCM including core HR, Recruiting, Talent and Performance management and Periodic Compensation.
• Good knowledge in Workday Functional HCM with responsibilities Supervisory organizations, Staffing Models, Job and Positions, Defining Business Process and security Groups, Customized Report Generation.
• Experience in all phases of Full Project Cycle Management (PCM), Business lifecycle namely - Requirement gathering, Analysis, Design, Development and Testing.
• Proficient in Development of Advanced Matrix, Composite Custom Reports and Calculated Fields in Core HCM. Good exposure to Software development life cycle (SDLC) and project management.
• Hands on Workday HCM systems integration implementation experience and working knowledge on Workday Payroll, Inbound/Outbound Integrations, Data Migrations and Reporting.
• Created, enhanced existing reports. Worked with standard and Custom Reports, assigning security to the reports primary and related business objects.
• Experience as a Workday Integration Consultant in analyzing PeopleSoft documents, reports, queries, SQLs etc. and transforming them into Workday Technical design documents.
• Experience in performing requirement analysis, design, conversion, Migration and testing including developing functional specifications from functional requirements and customizations of projects.
• Advanced reports design and development, Configuration of Dashboards, Worklets and advanced analytics.
• Worked on field mapping of legacy data with the corresponding PeopleSoft benefits and payroll data.
• Experience with data flow and object modeling, case analysis, workflow analysis and functional decomposition, customization and data migration, testing and services.
• Experience in designing Workday Integration Implementation plan, conducting blueprinting sessions
• Good knowledge of EIB Inbound/Outbound integrations, Workday Studio, Report Writer and Calculated Fields.
• Has understanding and working experience in .Net Framework 3.5 and Visual Studio 2012.
• Worked with business process framework, well verged with multiple configuration options in staffing, compensation, benefit events, time off/leave events, Talent Management Events.
• Consistent performer with excellent communication and professional skills and experienced in understanding requirements which involved preparation of functional and non-functional specification documents.
• Experience in creating Job Profiles, Job Families and Job Family Groups, also worked with the creation and maintenance of position and job staffing models and Headcount Groups.
• Maintenance and creation of Workday Supervisory Organizations, Locations, Positions, Cost centers, and Cost Center hierarchies.
• Created and enhanced existing reports and worked with standard and Custom Reports, assigning security to reports primary and related business objects, migrating reports from implementation tenant to production tenant.
• Created Workday Report writer reports and dashboards for HR. Configured HR based on customers' requirements, also created custom objects based on the customer requirements.
• Excellent object management skills in Workday like configuring Supervisory/Matrix Organizations (Divide organizations, Inactivate Organizations, create subordinates), performance management, Time Management, and Securities like Role/User/Job Based Security groups. Extensively worked with Security Administrator to implement security in various levels.
• Experience in configuring and maintaining various Compensation Packages with multi Allowances, benefits and bonus packages, and in setting up compensation segment security features.
• Experienced in WORKDAY security related to creating and assigning Permission Lists / Users / Roles
• Maintained and support all the HR Business processes e.g. Compensation, Hiring, Performance and talent management etc. implemented in Workday.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Manage Database Backup, Restoration and Recovery and proactive administration by configuring Alerts and Event. • Expert in documentation skills knowledge of technical documentation and functional documentation. • Expert in reporting skills using SQL Queries and Excel understanding translation business requirements. Expert with SQL (Store Procedures, Sub Queries, Functions, Views etc.) • Sound knowledge of optimizing DB performance and server resources. • Good exposure to development, testing, debugging, implementation, documentation, user and production support.• Quick learner and able to work well in a high-pressure environment. • Excellent communication, report creation, presentation, organizational, trouble-shooting and interpersonal skills. • Proficient in database administration involving configuration, tuning of databases. • Specialized in designing and implementing different types of Replication Models like Snapshot, Merge and Transactional. • Expert in SQL Server 2016, 2014, 2012,2008R2, 2008, 2005, 2000 SSIS, SSRS & Expert in Database High Availability, mirroring, and Log shipping, replication, Clustering .

TECHNICAL SKILLS

Workday HCM and experience, PMP completed: RDMS and Technologies MS SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016

MS Access, Languages T: SQL, Expert ETL Tools DTS, SSIS, SSAS, SSRS Other Tools Microsoft Word/Excel/Access/PowerPoint 2010 Operating Systems Windows 2000,2003,2008, 2008R2,2012 Also have enough knowledge of OS infrastructure . Good knowledge of MS Azure . Also well versed in the infrastructure side of all the hardware like

Windows, Virtual platforms like Hyper: V, Virtual workstations. Good knowledge of Share point 2010, 2013 ( know the installation and basic development and administration) .Also know a few query languages like PHP MYSQL, and more and have built a few websites .

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Highpoint Solutions

Responsibilities:

• Involved in implementation of workday HCM for various HR modules such as Time Tracking, Benefits, Absence Management, Payroll and Compensation.
• Assisting in data migrations from PeopleSoft HCM to Workday and delivered data mapping and transformation documents.
• Analyzed complex sets of data to identify quality issues and proactively initiated steps for improvement
• Coordinated and supervised the daily activities of the Workday HR System and act as primary point of contact to monitor and triage production issues
• Analyzed client's HR/Payroll business needs through client working sessions and supported development of new business processes and a future state design.
• Served as a Workday Report Writer and created custom integrations with third party applications using Enterprise Interface Builder (EIB) and Workday Cloud Connect.
• Worked on various enhancements related to EIB Integrations, Core Connectors, CCB, and Custom Reports.
• Created new integration to pull the new hires information using Core Connector Worker and Document Transformation which uses connector integrations XML Output as its data source input.
• Integrations are developed using the web services like XSLT, SOAP, WSDL, XML on the Workday cloud platform
• Interacted and Coordinated effectively with the HR and Payroll teams to ensure curvature is leveraging the full capabilities of Workday.
• Worked on Reports to create custom reports using Workday Report Writer to meet the business needs of HR and Payroll application report consumer groups.
• Worked on setting up stock plans and launched employee stock grants.
• Created commission plans and onetime payment plans and developed compensation reports and statements.
• Developed simple and secure integrations using Workday Enterprise Interface Builder (EIB).
• Participated in the meetings with business process owners, SME (subject matter experts), and Security Audit team for requirements gathering and verification stage.
• Handled company acquisition comprising- fit-gap analysis, required configuration, testing and facilitating data load via EIB
• Experience in Data Conversion and Testing Process Meetings for both HCM and Payroll
• Created compensation eligibility rules based on management levels, job profile, and job family and create calculated fields for Custom Reports to ensure required report delivery
• Wrote reports that extract Workday data and manipulate the data in other formats for various needs.
• Configured workday system to meet client unique business requirements. Also developed test scripts for other outside systems that interface with Workday.
• Supported existing integration and building new integration based on the client requirements.
• Extracted data from legacy system performed a date transform to Workday compatible iLoad format.
• Used functions such as ETV/XTT to do XSLT file transformations for integrations on workday Cloud, proficiency in understanding SOAPUI, WSDL, XML, XSLT languages

Confidential, Heights, IL

Senior DBA

Responsibilities

• Providing on Call 24/7 Support • Data design/implementation tasks including design database naming convention and physical storage configuration perform database export and import, conversion and database performance tuning.
• Worked on creating High Availability and Clustered environments for some upgraded projects and maintaining them on regular basis .
• Troubleshoot application database issues/ maintain large database as big as 3-5 Terra bytes and about database servers . Also working with about 200 different Hospital applications .
• Also heavy exposure to other database technologies like Epic, Oracle, Mongo DB and more .
• Working with different ticket systems like Service now, Landesk and exposure to a very fast pace environment .
• Create/modify/schedule/operate tables, views, functions, stored procedures, triggers, SSIS packages, jobs, replication, logins and users. •Setup SQL Server database clusters. • Ensure performance of the database. • Develop Database Backup scripts and automated this process. • Tune the SQL queries using SQL profiler. • Performance tuning and SSIS scripting. • Involved in developing stored procedures, triggers for the application. • Setup, monitor, and modify replication of data. • Data modeling and design including good knowledge of T-SQL. •Data backup/ recovery rollback planning and implementation. • SQL server 2005\2008\2012 optimization, fine-tuning, and scalability techniques. • Ensure all changes are first tested on acceptance test servers and then applied on Production Manage Microsoft Azure and configuration in the hospital . Servers. Kept the production and acceptance environments synchronized. Ensure that all databases are secured with well-defined permissions and roles. • Database Administration of MS SQL databases for SQL version 2012, 2014 and 2016 .