SUMMARY

• An Senior Consultant with 10 plus years of IT Experience in Workday Reporting, IBM InfoSphere DataStage, IBM AS400, Data Warehousing, Data integration, Conversion processes, Design, Development and Testing.
• Experience with Workday integrations, core HCM platform and extensive familiarity with the Workday integration architecture.
• High - performing, strategic thinking professional with experience in Workday HCM Module.
• Experience in all phases of the Software Development Life Cycle (SDLC), Workday implementation lifecycle and support of a post implementation projects.
• Extensive experience working as a Workday HCM Report Writer, which includes one full life cycle project implementation
• Extensive knowledge of SQL.
• Experience in integration of various data sources (Oracle 8i/9i/, DB2, SQL Server and various File systems).
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.

TECHNICAL SKILLS

ERP: Workday

Data Warehousing Tools: IBM InfoSphere Information Server 8.x, 9.1.

Languages: RPG/400, RPG IV, RPGLE, SQLRPGLE, CL/400, CLLESQL/400, C, Java 2, SQL and PL/SQL.

Operating Systems: UNIX, Linux, Windows NT/95/98/2000/XP and OS/400.

Relational Database: Oracle 8i/9i/10g, SQL Server, DB2/400 & DB2/UDB.

Client Tools: DataStage Designer, Director, Administrator.

Other Tools: Workday Studio, Unix Shell Scripting, Edit plus, AS400 Utilities, Emulation Software.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

Workday Reporting Consultant

Responsibilities:

• Worked on several modules on workday reporting includes HCM, Benefits and compensation reporting.
• Worked on creating custom reports for Simple, Advanced reports, Matrix Reports, Composite reports, etc.
• Have complete knowledge on all calculated fields which gives the ability to build any kind of complex reports.
• Strong knowledge of EIB, Core Connector, Document Transformation and Workday Studio.
• Performed simple integrations using EIBs and Complex integrations using Workday Studio.
• Designed and built outbound studio integrations with RaaS reports.
• Created calculated fields, Dashboards for the HR, Benefits, and Compensation modules.
• Responsible for user requirements gathering and provided workday tutoring.
• Based on client requirements, created design documents for workday reporting and created Dashboard which gives all the information regarding those reports.
• Worked on setting up scheduling of reports and understanding the required permissions for security report sharing, performing specific authentications on reports.
• Developed advanced reports for compensation team using data sources and on understanding the data behaviors using the data sources developed the reports.
• Inactivating Supervisory Organizations, Changing the Organizations and moving the workers into other Supervisory Organizations
• Resolved issues occurred during regular testing and UAT Testing
• Involved in creating the Applicants, Hiring applicants into supervisory Organizations.
• Configured Workday compensation packages which include employee's salary, Compensation Grades, Allowances, Bonus, Merits based on their profile.
• Implementation of Salary Structures for different grade profile employees.
• Configured the processes like change job, compensation grades, mass hire, mass promotions.
• Help the team with Manual testing and verification scenarios.

Confidential, San Francisco,CA

Workday Report Writer

Responsibilities:

• Responsible for full development of Advanced Custom Reports and calculated fields manipulating data for the Staffing, Benefits, Compensation.
• Created Custom Advanced and Matrix reports for Upper Management Dashboards.
• Created and design Matrix reports that provide analytics for: Recruiting Activity, Trending data, Key Transactions, Compensation data, New Hires, Terminations, extensive calculated fields.
• Finished On job training for Workday.
• Designed and developed ETL processes as per High Level Business Requirement document.
• Documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart.
• Helped redefine existing practices for ETL DataStage jobs.
• Optimization/Tuning of DataStage jobs to improve performance.
• Identifying and Addressing data quality Issues.
• Developed UNIX scripts for project.
• Fine Tune SQL queries for Extracting Data and for System test cases
• Implemented a Combination of Star Schema and Snow Flake Schema.

Confidential, TN

Senior Software Consultant

Responsibilities:

• Designed and Developed Datastage jobs for Initial and Incremental loads for Data warehouse.
• Responsible for analyzing Technical specifications, creating test plans, designing test cases and executing the test cases.
• Fine Tune SQL queries for Extracting Data and for System test cases.
• Supported the extraction of data, from heterogeneous source systems involving AS/400, Oracle database, SQL Server, XML file, CSV file, flat files and fixed length file.
• Developed transformations based on the requirements and loaded the transformed data into the target tables using DataStage.
• Technical support to other teams member of ETL and as well as trouble shooting issues with tool.
• Involved in job design, development and Implementation and testing of Star Schema for Transportation module.
• Involved in defining standards and best practices for ETL Datastage jobs.
• Implemented Type 2 Slowly Changing Dimension using DataStage.
• Review, Optimization/Tuning of DataStage jobs to improve performance.
• Developed UNIX scripts for project.
• Identify issues on complex testing projects and recommend solutions based on data gathered.

Confidential, Alpharetta, GA

Senior Software Consultant

Responsibilities:

• Understanding the specifications for Data warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Designing and Developing DataStage jobs for Initial and Incremental loads for Data warehouse.
• Implemented Type 2 SCD for Dimension tables and Hierarchies in Data warehouse using DataStage.
• Involved in System Testing and Performance Testing for Enterprise Data warehouse.
• Used DataStage Built in Functions and Transformer stage to enrich and transform the data.
• Technical support to other ETL development teams as well as trouble shooting issues.
• Supported the extraction of data, from heterogeneous source systems involving Oracle database, DB2,XML file, CSV file, flat files and fixed length file. Developed transformations based on the requirements and loaded the formatted data into the target tables using DataStage.
• Resolved issues occurred during regular testing and UAT Testing.
• Experience with testing the DataStage jobs as per the standards and loading the unit test results in the test director.
• Developed Unit Test\System Test plans for the modules designed and developed.