SUMMARY:

• 8 years of IT experience in Software /Application design, Development and implementation
• 4 years of experience in HRIS as Workday Techno Functional consultant
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of Workday and financial applications.
• Worked in Different project environments like Agile, waterfall and other methodologies
• Experienced in developing Custom Reports, Advanced Reports, Matrix reports and Calculated fields
• Creating Simple reports to Advanced Reports by using Calculated Fields, Sorting, Filtering Report Fields, providing Advanced Filtering Option, Creating Sub - Filters and by using related Business Objects.
• Good Understanding of Workday Integrations in EIB, Core connector and Workday studio including Web Services, Saas, Workday Architecture, Business Process Framework.
• Experience with Workday HCM Fundamentals, Inbound/Outbound Integrations, Business Processes, Calculated Fields, Report Writer, Configurable Workday Security, Workday Studio, EIB (Enterprise Interface Builder), Core Connector, Cloud Connector, XML, XPATH, XSLT, Workday web services, Organization Structure, Business Process, Custom Objects, compensation, Talent Management, recruiting and i Loads.
• Expertise on all kinds of Workday integrations including delivered and custom integrations.
• Experienced in Workday security related to creating and assigning Permission Lists/Users/Roles.
• Worked on Payroll Interfaces and have developed integrations in both EIB and Core Connector.
• Strong Experience in creating and designing Hyperion planning Classic and EPMA applications.
• Used various types of utilities in Hyperion planning applications for dimension building and maintenance purposes like outline load utility, import export security and cube refresh.
• Strong experience as a Hyperion Essbase Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
• Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Expertise in building Relational Databases using SQL Server and Oracle and knowledge of Essbase server upgrades across NT and UNIX platforms.
• Strong communications skills, both written and verbal
• Proficient in Microsoft Office applications including Word, Excel, Outlook and Visio
• Strong organization, customer service and time management skills
• Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Quick learner and proven ability to adapt to new technology and platforms
• Strong knowledge in creating documentation of program design, coding and other details to guide others in application development and maintenance
• Supported end user training in applications developed.

PROFESSIONAL EXPERIENCE:

Workday HCM Consultant

Confidential

Responsibilities:

• Worked on different data source in order to match requirements in Workday Reporting.
• Assisted in the development, specification and communication of the technology architecture plans
• Functioned as Analyst / Configurator in determining and executing in Talent Acquisition Team
• Develop Custom reports, Advanced Reports, Matrix Reports and Calculated fields.
• Created and used calculated fields in reporting, business processes, integrations and other areas within Workday.
• Worked on various enhancements related to EIB Integrations, Core connectors and custom reports
• Created and used EIB integrations for data load from third party vendors
• Worked with development team in fixing integration errors and trouble shooting
• Analyzed the requirements, defects and issues reported by the Business User with respective team members and identified, researched and documented the business processes

Workday HCM Consultant

Confidential, Houston, TX

Responsibilities:

• Worked with subject matter experts and business analysts to gather the business requirements during development stages and prepared necessary docs
• Worked with Business Process and configurations of the, Compensation, Payroll, Talent Management, Recruiting and Benefits
• Worked on different data source in order to match requirements in Workday Reporting.
• Develop Custom reports, Advanced Reports, Matrix Reports and Calculated fields.
• Created and used calculated fields in reporting, business processes, integrations and other areas within Workday.
• Worked on various enhancements related to EIB Integrations, Core connectors and custom reports
• Created and enhanced existing reports and worked with standard and custom reports
• Assigned security to reports, primary and related business objects
• Design, develop, implement and maintain workday integrations with third party vendors
• Worked on Document Transformations and applied XSLT transformations
• Configured PICOFs to integrate with payroll vendors.
• Extensively worked on Payroll Interfaces and have designed and developed integrations
• Good knowledge on integrations including web services, Workday Architecture, business process frameworks
• Worked on setting up scheduling of reports with the required security for report sharing
• 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.
• Worked on Document Transformations and applied XSLT transformations. Transformed fixed-width files into XML.

Confidential, Phoenix, Arizona

Workday Techno Functional Consultant

Responsibilities:

• Gather business requirements through design partner sessions with customers
• Configured Workday Modules such as Workday Talent Performance, Workday Comp & Workday Absence
• Worked on creating custom reports for Simple, Advanced reports, Matrix Reports, Composite reports,
• Worked on different data source in order to match requirements in workday reporting
• Mapped HCM data in the outbound integrations systems, to deliver to vendor via web services
• Created Core Connector integration to pull the new hire information.
• Worked with Simple and Advanced Reports, defining columns, business objects, fields, columns heading overriding, multiple sorting techniques, sorting by secondary objects.
• Worked on several calculated fields like extract single instance, extract multi instance, Arithmetic Calculation, formatting date fields, Look up related value, Evaluate Expression, True or false conditions.
• Created various security groups like User Based Security Groups, Role Based Security Groups and Job-Based Security Group
• Design custom reports to pull Benefits data into the Benefits Workbook for the client.
• Worked on Core Connector for change data to third party Vendor. Worked on Payroll and Compensation Integrations for the Vendor.
• Created Core Connector integration to pull the new hire information.
• Worked on Document Transformations and applied XSLT transformations
• Worked on post-implementation support and enhancements.
• Involved in Knowledge transfer and development transition to the other team members and to production team
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.

Confidential, Wilmington, DE

Workday Business Analyst

Responsibilities:

• Conducted interviews with the respective team members and business customers for gathering business requirements, systems requirements and testing requirements
• Analyzed the requirements, defects and issues reported by the Business User with respective team members and identified, researched and documented the business processes
• Assist with User Acceptance Testing, develop and maintain quality procedures ensuring that appropriate documentation is in place.
• Utilize detailed knowledge of application features, scope and impact of business needs throughout analysis.
• Gathered Business requirements for Integration and mapped them with Functional requirements.
• Worked as an Interface between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured the critical requirements were not missed.
• Review on Daily basis for all the new remedy tickets which are assigned level 4 & higher.
• Assist in development of training materials for functional and process improvements.
• Created the user requirement specifications, helped convert them to system functionality documents, and managed them.
• Worked with Business Process and configurations of the, Compensation, Payroll, Talent Management, Recruiting and Benefits
• Worked with Performance Management, Pre-hire, On boarding, Manager Evaluation, Succession planning report
• Identified and defined actors, made use cases and grouped them and prepared data flow diagrams, activity diagrams, sequence diagrams, state transition diagrams
• Worked closely with QA team during functionality testing and helped in the User Acceptance Testing, Query testing.
• Participated in business and technical design sessions with DBA's, developers, and QA analysts.
• Strived to consistently meet critical timelines while maintaining high quality standards
• Good exposure to company business and how hiring, payroll process is organized.
• Created custom reports and calculated fields to fetch the required data from the tenant
• Developed simple and secure integrations using Workday Enterprise Interface Builder (EIB).

Confidential, Houston, TX

Hyperion Planning Developer

Responsibilities:

• As a technical/functional consultant worked on complete life cycle of the Hyperion Planning Implementation.
• Involved in gathering requirements from business users and developing a project plan
• Worked on detail level of requirements and worked with functional team experts to create the functional design documents.
• Designed system architecture according client requirements and provided list of tools to be used to fulfill client requirement
• Worked on infrastructure supporting around 1000 users.
• Worked on multi cluster environment hosting Essbase, Foundation services on the Linux servers and the other Hyperion related services on the windows.
• Experience in writing formulas, Calc Scripts, Business rules according to business requirements
• Created various ODI interfaces to load source systems data i.e., People Soft, ADP, Strata to Hyperion applications
• Created calculation scripts and business rules required for various types of calculations.
• Created around 100 business rules related to the payroll, revenue, workforce, Capital expenditure, Balance.
• Created around 50 web forms related to the payroll, revenue, workforce, Capital expenditure, Balance which are used for day to day budgeting purposes.
• Created global variables, Sequences, projects in Hyperion business rules.
• Automated the security setup through MaxL and CSS Import Export utilities available in Hyperion.
• Automated backup and recovery process for the Essbase applications data and metadata.
• Automated services startup and shutdown process and scripted these scripts batch and shell scripts.
• Created VBA workbook to update substitution variables in the system.
• Conducted end user training sessions to train users how to use new budgeting process

Environment: Hyperion EPM 11.1.2.0, Hyperion planning 11.1.2.0, Essbase 11.1.2.0, EIS-Integration services, Essbase Studio, Hyperion Data Integration management, Hyperion smart view, Oracle Data Integrator, Oracle Applications, MS Excel Add-in.

Confidential, Chicago, IL

Hyperion Consultant

Responsibilities:

• Provided support for Hyperion Essbase, Hyperion Planning, Hyperion Reports other Hyperion Suite.
• Involved in research and resolving complex issues related to any Hyperion Suite.
• Troubleshoot and resolve complex Hyperion System related Issues.
• Setup Disaster Recovery environment for Hyperion customer of Oracle.
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging on demand Customer environments.
• Closely worked with System Administrator to resolve server related issue.
• Involved in Setting up application instances required to create all the different logical environments in the system development life cycle (DEV, TEST, UAT, and PROD) helped in assisting clients and provided remote assistance in implementation.
• Imported security profiles from Hyperion planning to Hyperion Essbase.
• Improved the Performance (Optimized the Planning, Essbase system) by changing the dimension order and working on configuration file including Cache design techniques.
• Migrated reports from development to Preproduction and then to production.
• Involved in Trouble shooting the Production issues in support to the Planning Applications and all databases (Production Support).
• Involved in Automating data load process with MaxL scripts and scheduled to run Calc scripts after every data load.
• Researched and reported the Defects and Enhancements to the Hyperion Development team and enforce standards and best practices.
• Configured the Application server software to each individual application’s requirements Performance Tuning with the Application server software for optimization of use.
• Performed recovery under various circumstances on production database.
• Successfully resolved archive log and NFS lock related issues.
• Troubleshooter connectivity issue from middle tiers to database tier.
• Synced up standby database with primary.
• Involved in the documentation of the related tasks in the project.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Financial Reporting 9.3.0.1, Web Analysis, Smart View, Workspace, Shared Services, EPM, UNIX, Linux.

Confidential, New York, NY

Hyperion Consultant

Responsibilities:

• Worked with business analysts and other team members in gathering requirements, functional specifications, testing strategies and planning the project.
• Created Cubes according to user requirement by selecting accurate metrics and fallowed all precautions for best performance of cubes.
• Created outline with excellent balance of dense/sparse dimensions
• Created Formulas and calc Scripts to implementing the business logics following optimization rules.
• Changing the outlines frequently according to the business requirement.
• Created the report scripts in administration console and query analyzer according to end user requirements.
• Extensively involved in Creating Hyperion planning templates/forms according to the user requirements.
• Extensively involved in data validation after the cube builds by validating the log file across source data system.
• Created the batch scripts to automate the cube building.
• Created the Esscmd scripts, Maxl to automate cube builds and dataload.
• Successfully led a Hyperion Interactive Reporting System 9.2 to 9.3 migration
• Promoted user self-service and led Hyperion User Group Meetings increasing utilization of the data warehouse
• Trained and coached users increasing user productivity and reducing report generation time from days to minutes
• Designed, developed, and supported Business Intelligence solutions for compliance and customer retention resulting in simplified compliance processes and increased persistency
• Involved in administrative activities such as installation and upgrade of software products including ESSBASE, setting up users, security groups and access filters to set the security policy and to ensure maximum security.
• Involved in day-to-day administrative activities such as managing users on the Essbase server, backing up cubes, identifying and resolving problems. .
• Created test scripts to validate data across servers after server migration.
• Involved in working with MS Access database to create source data for Essbase using legacy systems. used VB scripting
• Created Excel Templates using macros and extensively to create various reports according to end user requirement.
• Strong knowledge in creating documentation and end user training on Hyperion Essbase/Planning and applications developed.
• Extensively involved in performing DBA activities like performance tuning the Calc scripts, database tuning, and taking the Essbase backups.
• Maintain defect management in Clear Quest while supporting UAT sessions

Environment: Hyperion Essbase 9.3.0.1, Hyperion Planning 9.3.0.1, EIS-Integration services, Hyperion Interactive Reporting 9.3 BI+., Hyperion Web analyzer 9.3.0.1, HAL Hyperion Application Link, Hyperion Planning desktop, Hyperion smart view,SAP,AS400,ORACLE SQL,SQL Server, MS Excel Add-in, VB scripting, Informatica, SSIS, XML, XSLT, XSD, UNIX.

Confidential, Phoenix, AZ

Hyperion Essbase Developer

Responsibilities:

• Obtained a detailed knowledge of the business process being followed in the project environment
• Extracted the business requirements from the end users keeping in mind their need for the application and prepared business requirement document as per the requirements.
• Involved in the day-to-day implementation of application development with its various workflows, artifacts and activities
• Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
• Automated the backup process using Shell scripts and worked on UNIX shell wrapper scripts.
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in optimization and tuning of the Essbase application to bring down the calc time.
• Automated the monthly loading process using MaxL, Shell Scripts.
• Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
• Maintained the closing cube in parallel to Hyper Roll to ensure the data is being loaded and aggregated as per the business requirements.
• Developed reports required for the business needs using Hyperion Reports and Hyperion Analyzer (ad-hoc).
• As a part of team, involved in the installation and configuration of Hyperion Essbase (7.X) on VMware environment to test the application.
• Used Web sphere application server for installing and configuring the Planning Web applications.
• Developed Business rules to facilitate the users to aggregate data based on user inputs.
• Involved in validating the web forms for the OTC users on the consolidation cube.
• Created users, user groups for accessing the various application elements.

Environment: Hyperion Essbase 7.5.4/7.1.5/9, Hyperion Application Link (HAL), Hyperion Reports 7.0, Hyperion Analyzer 7.0, People Soft, Hyperion Essbase Spreadsheet Add-In, PL/SQL and Oracle 8i, Web Sphere 5.0, Windows 2003, Unix