EXPERIENCE SUMMARY:

• 3 years of experience in Workday.
• Completed Workday Security Fundamentals and Advanced Security Training.
• Created custom reports, Calculated fields, EIBs, BPs, Core connectors, Report as Web service.
• Involved in Business requirement gathering and creating/maintaining security groups.
• Evaluate WD releases to identify new functionalities and explore teh usage. Configure, test and validate teh changes in Workday.
• Providing audit reports for teh SOX audit.
• 15+ years of work experience specializing in teh area of PeopleSoft Apps DBA and Oracle database administration.
• Experience in managing offshore/onsite team of members.
• Managed weekly, monthly agile sprints wif team members.
• Coordination of activities between team members, vendors and Business owners.

TECHNICAL SKILLS:

Industries: HRMS, CRM, FSCM

Applications Front End Tools: Visual Basic, MS VSS

Operating Systems: MS DOS, Windows, Windows XP, UNIX, LINUX

Development Languages: C, C++, Java

RDBMS: Oracle 9i, SQL Server 2000, MySQL, MS Access, Informix

Web technologies: HTML

Scripting Languages: Java Script, VB Script

Application Servers: Web logic 8.0

People Tools: Application Designer

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Handled Security during Recruiting, HR, Anytime feedback Implementation
• Worked on security project (SOD) segregations of duties. Splitting of teh existing security groups based on teh functional area. Created separate security segments for EIB, BPs and Integrations based on teh functional area.
• Used ‘Assign Roles’ EIB to Assign/remove users to teh security groups.
• Handled teh security portion during OKTA implementation.
• Created Intersection security group wif in another Intersection security group for HR Partners to edit Specific group employees.
• Created Custom report as web service for third party. Worked wif ADP for Recruiting Assessment ( Includes Create Assessment status, Creating teh required calculated fields as provided by ADP, Deploy Clar file, Configuring teh integration attributes).
• Created custom reports needs for teh SOX audits.
• Participating in SOX audit meetings and providing them teh necessary audit reports quarterly.
• Following SOX standards for each ticket.
• Created core connector Worker.
• Integrations technical development resource responsible for attending and contributing to design sessions, reviewing integrations, functional specifications, working wif vendors
• Participated in requirements analysis and halped developed inbound/outbound integrations, manage business processes, create custom reports, core connectors, document transformation, and worked wif Enterprise Interface Builder (EIB).
• Using Kainos scripts for testing during WD releases, assigning teh users wif additional security groups in teh Sandbox.
• Working on then Inbox items, Checking and Clearing teh assign roles for Transfer, Termination, Promotion/Demotion on a day today activity.
• Handled nearly 50 Heat Tickets on a monthly basis.
• Read teh weekly Service Updates about new functionality and patches.
• Update any internal controls or processes based on teh new functionality and patches.
• Assigning roles and security groups to new Hires.

Confidential

Security Admin

Responsibilities:

• Domain security updates. Creating Intersection security groups, User based security groups, Role based security groups, Integration Security groups.
• Giving security to teh Custom Reports.
• Created Custom report as web service for third party.
• Created core connector Worker.
• Integrations technical development resource responsible for attending and contributing to design sessions, reviewing integrations, functional specifications, working wif vendors
• Participated in requirements analysis and halped developed inbound/outbound integrations, manage business processes, create custom reports, core connectors, document transformation, and worked wif Enterprise Interface Builder (EIB).

Confidential

Project Lead

Responsibilities:

• Drive teh requirement gathering meetings.
• Responsible for analysis, design and build.
• Experience in Workday Report writer: Simple, Advanced reports.
• Created EIBs for teh outbound integration.
• Created report as web service for third party.
• Created core connector Worker.
• Involved in testing teh core connector integration.
• Conducting Weekly Status meetings, and Interact wif Business to update about teh Progress of teh Project and requesting their intervention for any delay in Approvals
• 24/7 support of all Production/Non Production Environments include HRMS 9.0, EPM 9.0
• Environment refreshes, Database refresh, Table refresh from Production
• Applying Tax updates
• Have written SQR for teh client to identify validating teh compare between teh UAT and prod before it moves to production.
• Have written application engine to extract details from teh web server log and inserts data into a table which is used for audit purpose.
• Project Migration
• Troubleshooting issues related to People Tools and Application configuration
• Experience in troubleshooting and maintaining PeopleSoft Internet Architecture components including App Servers, Process Schedulers, and Web logic Servers
• Migrating projects across various environments using manually
• Install and Configure Oracle Client and configure TNS files to get two - tier access to Developers and Users
• Conducting Weekly Status meetings, and Interact wif Business to update about teh Progress of teh Project and requesting their intervention for any delay in Approvals
• Handling Performance issue
• Also involved in data stage activities like compiling, migration of projects, monitoring
• Windows Administration ( includes teh legacy systems in Kiewit)
• Centric Administration ( Software used for Bid Management)
• Stat Administration (includes license checking, user creation and maintenance and, moving objects if required)
• Was taking care of other 3rd party applications like (Image now, Digscribe (imaging System). Hyperion, ColdFusion
• Prepared and maintained teh documentation of all teh installation and configurations for Future Reference and KT Purpose.
• Confluence administration - confluence is a kind of wiki ( Creating user and maintain them )

Confidential

Oracle Database Administrator / Developer

Responsibilities:

• Usage of teh SQL traces, EXPLAIN PLAN to fine-tune teh various queries to improve their throughput.
• Resetting teh various init.ora parameters to improve hit-miss ratio of queries.
• Involved in tuning teh complex queries and increased teh database performance
• Training developers for writing efficient SQL statements.
• Management of table space growth, monitoring data files additions, extent growth.
• Creating Databases and all database objects.
• Storage and space management including table spaces and data files.
• Involved in developing Batch programs in pro*C
• Provided Production support
• Developed oracle procedures and packages for Mutual Fund Application
• Involved in query tuning