OBJECTIVE:

Obtain a challenging position as a SAP HR professional, where I can utilize my technical skills and expertise for the organizational growth.

SUMMARY:

• Certified SAP HR Functional Consultant. Possess master’s degree in computer applications and post - graduation diplomas in Human resources and computer programming
• 10 + years of IT experience in SAP HR implementation, ABAP Development, BW implementation and program development in VB
• 5 + years of SAP HCM and HR implementation experience with the sub modules PA, OM, PY, and Recruitment. Excellent knowledge in ESS & MSS, LSO, Travel and Compensation
• 2 + years of SAP based development including high level of ABAP development in dialog Programming, ALV Reports, SMARTFORMS, SAP Script, database design and BDC
• Strong knowledge and experience in business requirements gathering, business process analysis, conceptual design, blueprinting, configuration, testing, and production support
• Expertise in supporting PAYROLL cycles (Regular & Off-cycle), configuration, Personnel Calculation Rules, schemas, Canadian and US Tax, excellent understanding of payroll internal tables and clusters
• Participating with the design teams, business stakeholders and architecture groups to develop solution roadmaps to support Client business innovation and growth
• Handling the responsibilities such as working with the team members to develop standards and best practices for implementing and supporting new development and technologies
• Taken responsibility for developing and overseeing the development of technical solutions to meet business requirements
• Strong proficiency in modules like Personnel Administration, Organizational Management, Payroll and Time. Excellent exposure with the module Solutions Manager
• Superb skills in MS. Word, Excel, Access, Power point, Share point, and all operating systems. Very assertive, research oriented, detailed, technical, team player

SAP-HCM SKILLS:

SAP R/3 HR Functional including: Payroll, Benefits, Personnel Administration, Organizational Management, time Management

Payroll: US Taxability model, BSI, Schema & PCRs, wage type valuation and Factoring, basic pay info type configuration, pay scale structure maintenance and reclassification, maintaining processing classes and evaluation classes, wage type configuration, working with payroll schemas and sub-schemas like K000, K200, KT00, KAP0, U000, UTX0, and UT00 and payroll driver RPCALCKO and RPCALCUO

Time Management: Work Schedules, Absence / Attendance/ Substitution/ Overtime Types and Quotas, Time Evaluation Processing, Generating Time Evaluation Reports and Updating Time Management Info types

Benefits: Open enrollment, Life events, Configuration of Health, Insurance, Savings Credit Plans, Spending Accounts, Eligibility & Termination.

Organizational Management: Personnel Cost Planning (Simulations & Comparisons), Org. Structures, Reporting Structures & Relationships, Simple & Detail Maintenance

Personnel Administration: Enterprise structure, Personnel Structure, Personnel Actions and Dynamic actions

ABAP Skills: Dialog Programming, ALV Reports, Authorization Objects, Object Oriented methodology, SMARTFORMS, SAP Scripts, BDC and LSMW. Excellent knowledge of SAP development using ALE/IDOC, RFC

SAP-HCM: SAP AG (ID S 0005048485 ) - Solution Consultant 2003 - HR-Management & Administration.

PROFESSIONAL EXPERIENCE:

Confidential, Colorado

Sr. SAP HCM Functional Consultant

Responsibilities:

• Responsible for providing technical guidance concerning the business implications of applied use of SAP HR Payroll module
• Maintained SAP HR Payroll module US Gross to NET, Schema, Personnel Calculation rules, master data, Off-cycle payroll adjustments, Check printing, Payment Medium Workbench, Off-cycle workbench, process models and Posting to SAP Accounting
• Worked with BSI Tax Factory including BSI 9.0 and 10.0 including cyclic upgrades and Tubs Applications
• Enhanced, designed, configured, tested and provided documentation for the SAP HR Payroll functional requirements
• Behaved as an SAP subject matter expert and assist fellow IT staff in defining business needs, including application architecture and performs knowledge transfer as required
• Provided quality assurance review and-or new and existing product evaluation responsibilities
• Conducted research on best practices and industry functional trends as required
• Applied in-depth knowledge and proficiency of SAP and engage business partners in evaluating opportunities and identifying solutions for process integration and refinement
• Established and maintained effective working relationships with business contacts, IT departments and vendors
• Organized and facilitated meetings and workshops where business requirements and application objectives are articulated, accurately captured, maintained and distributed appropriately
• Assisted in the development of testing, development.

Confidential

SAP ABAP Developer, Payroll

Responsibilities:

• Performed analysis and designed duties as well as programming, modeling and scripting, testing, documentation and deployment preparation. Coordinated and prepared needs analysis and detailed systems design
• Worked with PAYROLL reports such as wage type summary report, Employee variance list with payments report, Employee parking expenses report, Department wise payment summary report and Plant maintenance reports for changing the system statuses
• Conducted user interviews to determine detailed systems requirements. Completed preliminary analysis, system and functional design, and work flow diagrams for quality systems development
• Designed, coded, tested, implemented and maintained enterprise systems that comply with access and privacy legislation. Coordinated and developed program specifications and documentation
• Designed and conducted all levels of testing, i.e., unit, system, integration, regression, performance, security, usability, optimization and configuration, and coordinated user acceptance testing
• Liaised and coordinated with internal and external consultants in detailed systems deliverables and technical problem resolution
• Implemented enterprise in-house, developed custom and packaged systems and systems changes. Developed systems interfaces between enterprise and divisional systems
• Conducted research, investigated and recommended best practices for information and application services. Contributed to post-implementation project reviews
• Recommended improvements to current methodologies, processes, standards, policies and guidelines.
• Contributed to the planning of future system growth and provide detailed work plans. Participate in enterprise projects.

Confidential

Sr. SAP HCM Techno Functional Consultant

Responsibilities:

• Conducted responsibilities for project implementations and support maintenance related to Workforce HR applications including Payroll, Time Management, PA & OM in SAP HCM
• Built and maintained highly effective relationships with key business and process owners throughout the company
• Provide continued support to the business in the resolution of incidents, service and change requests related to Workforce/HR systems
• Offered the provision of after-hours emergency support in the event of a critical system failure also participated in the HR Systems on-call work schedules
• Provided support to resolve Helpdesk tickets associated with HR applications
• Participated as a key player in the development, testing and implementation of future system upgrades and new modules
• US PAYROLL:
• Maintained US Tax model by developing and creating of new tax model entries, tax areas, tax classes and tax types
• Conducted unit testing for new implementation by developing and performing the test cases for all possible scenarios which can effect the business processes
• Developed functional specifications, business rule documentation, along with process flow diagrams. Developed test cases and identified test scenarios.
• Managed the SAP HR change process, maintained a master list of all SAP HR change requests for the region
• Communicated and conducted follow up with functional business requestors and coordinated with the technical development team
• Developed test scenarios by discussing with the business owners to conduct unit testing.

Confidential

Sr. SAP HCM Consultant

Responsibilities:

• Collaborated with partners in the business to determine best options for implementing required changes to existing business processes.
• Presented options based on best business practices and standard SAP functionality where possible
• Made configuration changes and developed enhancement specifications for development work to support changes to business processes
• Performed operational routine sustainment activities and system maintenance with limited supervision
• Analyzed impacts of proposed upgrades and perform regression tests. Resolved authorization issues in modules of responsibility; define new and enhanced role development
• Liaised with the business and other team members. Documented issue resolution, configuration changes, and design enhancements
• E-Recruitment:
• Created users and assigned to the relevant roles as part of e-recruiting
• Set Up Search Engine with Search and Classification (TREX) as a search engine for E-Recruiting to search candidate data, job postings by activating python extensions
• Associated in creating RFC destination between E-recruiting system and TREX Server and also checked
• Set up access to the content server service of the SAP E-Recruiting system, documents of the document area HR KW (Document Storage for HR Objects) can be accessed
• Created and maintained communication user and assigned to the content server service. And activated content server by using T.code: SICF
• Maintained the integration between ERP Central Component and E-Recruiting by setting up RFC connection P12CLNT999 in the system table T77S0
• Set up ALE Distribution for importing complete organization structure from ECC to E-Recruiting system consisting of organizational units, positions, and jobs
• Developed user interfaces in E-Recruiting with Business Server Pages (BSPs) by assigning parameters to parameter types for each scenario.

Confidential

Sr. SAP HCM Techno Functional Consultant

Responsibilities:

• Responsible for PA, TM, PY Modules, reports, enhancements, interfaces and forms of ABAP related. As a member to Knowledge Acquisition team responsible for understanding and analyzing the current configuration and make suggestions for future support as well as project enhancements
• Provided presentations about the existing system to the client in the above mentioned modules and helped the team in understanding of ABAP Coding. Involved in SAP Enhancement Pack 5 upgrade
• Analyzed HR Time interface programs, that are transforming time data from 3rd party time systems (KRONOS) to SAP Database
• Identified time data load issues and offered solutions, make sure the data is stored in the proper infotypes
• Maintained time schema, by modifying absence calculation schema for time evaluation
• Processed the transaction PT60 for time evaluation
• Documented the identified information using Microsoft office tools excel, power point and word
• Provided guide lines for the implementation of ESS and MSS applications as part of their E-Hr System
• Payroll:
• Configured and maintained wage types for recurring payment (IT0014), additional payment (IT0015).
• Configured payment models for wage types on IT0014 and for benefit plans
• Configured wage types for Info type 2010 (Employee remuneration information) and maintained valuation bases for time wage types
• Involved in modifications of the KAL9 schema to handle percentage based deductions and payment wage types defined on IT0014 & IT0015. Involved in the maintenance of salary structure for Canada
• Handled production support issues and provided end user . Modified the KBE2 benefit schema to handle maximum annual employer contribution limits of savings plans and handled integration with benefit administration
• Modified PCR KGGR to define applicable gross amount for garnishments. Maintained processing class 59 and 60 for wage types for handling garnishments
• Time Management:
• Analyzed the existing work schedules, identified the fit gaps in work schedules and configured new work schedules and maintained the documentation for new work schedules and old
• Configured and maintained the relevant time features like TMSTA, SCHKZ and QUOMO to set up the default values for working week, work schedules based on specific criteria
• Involved in modification of public holiday/factory calendar and creation of Work Schedules rules, periodic work schedules and daily work schedules according to the client requirements
• Implemented various user parameters for time managers desktop, customized time ids, entry screen, and customized reports to display time sheet data
• Defined attendance types for a personnel subarea grouping for attendance/absence types and specified the type of overtime compensation for the following infotypes 2002 and 2007 also maintained the time constraint classes
• Maintained the groupings of employee subgroups and personnel subareas for time quota types
• Defined and assigned counting rules for counting attendances and absences, also set the rules for rounding Counted Attendances
• Created counting classes for period work schedules to valuate attendances and absences
• ABAP Development:
• Verified and suggested changes where ever is necessary for the existing reports and the interfaces. Explained to the functional team about the program behavior, purpose of the program and outputs of the program
• Analyzed Batch program runs and provided the frequency of the program execution, interfaces behavior, update of the data in SAP System
• Responsible for RICEF, for code verification, checking the existing documentation, suggesting the documentation changes and maintaining the documentation directory

Confidential

SAP HCM Functional Consultant

Responsibilities:

• Gathered business requirements and designed future state business processes
• Involved in converting business process design into a SAP configuration requirement through business blueprint document
• Configured the processes in line with the process design objectives
• Developed test plan, test cases and test scripts to support in testing phase
• Carried out various testing cycles as a part of the testing phase like - Unit, integration and Parallel testing. Provided support to business during user acceptance testing by them for the user acceptance test and resolving issues/defects. Worked with service enhancement pack 4 in upgrading, system testing and integration
• Assessed skill gaps and finalized approach (i.e. course map, schedule and instructional material and user manual)
• Ensured successful cut over to the new system and provided support to business to stabilize the “live” system.
• Conducted for the end users
• Time Management:
• Made Configuration and changes to Public Holidays, Holiday calendar, Work schedules, Selection rules, Rotation shifts, Absences, Absence Quota's, Deduction Rules, Counting Rules, Automatic Accrual of Absence Quotas, Overtime and Time Evaluation
• Worked on client specific time evaluation schemas and rules for overtime, and different payment purposes.
• Resolved critical issues concerning retroactive changes which used to result in improper overtime payments
• Created functional specifications and configured new methodology for the processing of mid night crossing work hours at the end of pay period
• Configured new work schedules, period work schedules, daily work schedules, dynamic break schedules for rotating and swinging shift schedules and assigned valuation classes to the PWS
• Created new attendance/ absences codes, assigned them to quotas, with appropriate counting and deduction rules
• Involved in knowledge sharing sessions with team members and helping out in resolving issues and in addressing the complex and critical issues, which arose from the influential bargaining units.
• Maintained custom as well as client defined tables, created new time types. Carried out Unit and Integration testing, to test for the changes made in the configuration.
• Created counting classes for period work schedules to valuate attendances and absences
• Payroll
• Worked on wage type configuration/valuation (earnings, deductions, gross up, tax advance, etc.). Maintained processing, evaluation and Cumulation classes and other tables required for wage type maintenance
• Created payroll areas for the combination of period parameter and date modifier and generated payroll calendar
• Maintained tax related processing classes of wage types. Worked on Tax models. Maintained gross up wage types. Defined and assigned tax companies to personnel area
• Created process models for regular and off-cycle payroll runs
• Defined remittance rules, created HR creditors, HR accumulators and maintained wage types for third-party remittances
• Configured symbolic accounts and employee grouping/ account assignment, wage type posting attributes and created posting variants for Posting to Accounting
• Personnel Administration:
• Designed & configured elements of Enterprise Structure and Personnel Structure
• Designed Pay scale groups and levels for each combination of pay scale area, pay scale type and CAP grouping. Defaulted pay scale area/Pay scale type in feature TARIF
• Configured infotypes to facilitate entry of employee information like Personal Data, Organizational Data, and al Qualifications Etc.
• Designed and configured personal actions like hiring, change of position, change of pay
• Designed and configured user specific infotype menus as per the client’s requirement
• Created and maintained wage types and wage type catalog. Configured various payment and deduction wage types (for infotypes 0008, 0014, 0015, 2010, 0267 and 0057) and maintained various related tables.
• Configured valuation of base wage types using indirect valuation module - TARIF, PRZNT, SUMME, ANSAL for Infotypes 0008, 0014 & 0015
• Maintained number ranges and defaulted them through feature NUMKR
• Configured Administrator groups and defaulted it through feature PINCH
• Configured payroll areas; defaulted them through feature ABKRS, and created control record for payroll areas.

Confidential

SAP HR Techno Functional Consultant

Responsibilities:

• Gathered business requirements. Conducted final cross-team design validation. Developed and finalized blueprint deliverables. Created Data, Process and Structure Design document. Presented blueprints deliverables to steering committee and obtained sign-off
• Configured requirements in SAP system
• Conducted unit and integration testing. Developed test plan, test cases and test scripts to support for testing
• Developed materials
• Provided “go live” support
• Payroll
• Created payroll area, generated payroll calendar and created a control record to each payroll accounting area.
• Worked with US gross payroll and net payroll.
• Configured the payment/deduction schedule by defining Date modifier, Period parameter and Calendar types for different date types, frequency and the interval for which the total deduction amounts will be taken. Also assigned the payment/deduction schedule to the wage type
• Set the priorities for arrears processing with the priority values. Created custom wage types for arrears recovery from SAP Standard wage types. Also maintained arrears for retroactive processing
• Worked with the processing class 83 to maintain % deductions for retroactive processing
• Defined tax companies and assigned to personnel area. Also defined tax identification number and assigned the code to link the employer identification number and the tax company
• Configured wage types for gross-up for net amount for employee, net + tax amount and tax amount
• Maintained tax table entries by entering the actual states information and updated the tax authority tables with master list of all tax authorities. Involved with payroll tax configuration activities like maintaining tax-related processing classes
• Configured limits on deductions, priorities and arrears and prepaid deductions
• Designed schemas and rules for a reimbursement scenario
• Configured Balances and running totals for specific deduction
• Time Management:
• Defined attendance, absences, substitutions, overtime and availability as per the requirement. Creation of absence types such as casual/sick/annual leaves and quotas
• Defined the deduction rules, rounding rules and counting rules for the absence and attendance quota types
• Involved in creation of public holiday/factory calendar, work schedule/ planned work schedule
• Handled absence valuations, time wage type valuations, factoring and averaging issues
• Configured schemas and Personnel calculation rules as per the requirements
• Configured Work Schedules Rules according to Client requirements and maintained the feature SCHKZ
• Implemented various user parameters for Time sheet, customized data entry screen, and customized reports to display time sheet data
• Configured Absence Quotas and maintained the quota type selection group using the feature QUOMO
• Configured the Absence Quota generation through both RPTQTA00 and time evaluation schema
• Configured Cross Application Time Sheets profiles, and defined the fields for it according to the requirement
• Personnel Administration:
• Designed Enterprise Structure, Personnel Structure and Pay scale Structure
• Configured settings for maintaining different infotypes related to personal data, corporate and contractual elements, evaluation basis, and and other related infotypes
• Configured organizational key, maintained internal number ranges for different personnel areas
• Created and maintained various tables pertaining wage types
• Designed and configured info groups for different personnel actions, designed and configured infotype menus also configured Dynamic Actions
• Designed and configured payroll areas, and created control record
• Designed pay scale area, pay scale type and, revised pay scale groups and levels. Configured features like PINCH,TARIF,NUMKR, ABKRS, VDSK1 and LGMST
• Organizational Management:
• Designed Organization Structure: Created objects and maintained relationship between them (objects like organizational unit, position and jobs)
• Maintained different plan versions for different restructuring and expansion scenarios and for comparison purposes
• Designed and configured Actions like creating various object like organizational unit, positions, jobs etc.
• Involved in integration with the Personnel Administration by using the RHINTE10, RHINTE30, RHINTE20 reports
• Maintained objects in detail using infotypes in Expert mode
• Created organizational structure using Simple Maintenance as well as Organization and Staffing interface.
• Maintained and ensured correct settings in customizing for Essential relationships, Infotype per object type, Relationship characteristics and Allowed relationships
• ABAP Development:
• Extensive experience in Reports (ALV Reporting, Interactive Reporting Classical Reporting), BDC (Call Transaction and Session methods), LSMW, Script (script, new layout development and Customized Script program), Smart forms (standard smart forms, customized smart forms) and HR Forms
• Worked on Processing IDOC, Setting Partner Profiles, and setting up ALE / EDI interfaces and Creating RFC interfaces and Reduced IDOC as well as IDOC enhancements
• Worked on BDC and IDOCS (INBOUND and OUTBOUND) Process
• Extensively worked in Creation of Z Tables and creation of Customized Infotypes
• Involved in developing interfaces and Reports in HR using Infotypes, Logical databases and Clusters.
• Extensively worked in debugging of sap programs and performance
• Participated in unit testing, functional testing, system integration testing and user acceptance testing

Confidential

SAP HCM Functional Consultant

Responsibilities:

• Responsible for configuring management for portal systems to meet client business requirements
• Responsible for the implementation including requirements gathering, planning and scoping, application design, configuration, testing, deployment, and post go-live support
• Responsible for conducting knowledge transfer and of end-users, including sharing best practices
• Defined, structured and maintained the dynamic menus such as the dynamic course menu, the dynamic participation menu, the dynamic information menu, the dynamic planning menu, the dynamic tool menu, the dynamic resource menu and the master data catalog
• Set up the tab page dynamic menus with tab page filter, tab page sorting, tab page master data and tab page view for the dynamic menus as per the business requirements
• Developed course preparation by creating master data required and a course hierarchy from course groups, course types, curriculum types and resource types in customizing for the Learning Solution under Course preparation
• Set up an initial course offering by planning and creating courses through schedule pattern, building address, cost items, course location, provider, resource types and resources
• Planned courses with specific delivery methods and defined its time schedules also changed the time-dependent courses with demand determination
• Maintained the curriculum types according to the hierarchy and maintained infotypes course type info(1029) and the course info(1026)
• Created and edited course programs along with the program blocks in Management to make it available to learners in the Learning Portal for selecting and booking the desired courses with suitable course dates. Integrated course programs with the follow-up processing
• Set up the billing integration between Management and Sales and Distribution (SD) in Customizing for and Event Management and coordinated with the SD team for payment card set up
• Organizational Management:
• Designed and developed the business model by creating the objects such as organizational units, jobs, positions, work centers etc and their relationships using Simple maintenance
• Setup the number ranges for all plan versions. Integrated the Organizational management component with Personnel administration component by setting workflows
• Personnel Administration:
• Customized info type screen headers, screen elements and fields in the screen
• Created info groups and set up the actions according to business requirements and maintained the documentation
• Created payroll areas according to business requirements and defined the period parameters, date modifiers and generated the payroll periods for each payroll area
• Configured and maintained the features such as ABKRS for default payroll area, LGMST for default wage types, TARIF for default pay-scale data
• Documented the each processing step of personnel administration and developed the templates for documentation
• Generated wage types for basic pay, family related bonuses, recurring payments and deductions, additional payments etc.
• Maintained the basic settings for benefits administration by defining benefit areas, benefit providers, flexible benefits scheme attribute and assigning the currency to benefit area
• Set up the basic structure by putting all benefit plans required by organization and defined possible statuses for the plans
• Customize the features like CSTV1, CRDV1, COVGR, EECGR and ERCGR to make the default values to the info types
• Benefit Administration:
• Defined claim plans and how claim limit is allocated to different groups of employees
• Set up the claim limit variations for different employees depending on their personal data as well as the actual claim amounts for these various groups of employees
• Maintained the doctors and their details, panels and linked the doctors to panels
• Customized the info types (0022), qualifications (0024) and previous employment (0023). Also set up the communication info type (0105)
• Set up the personnel actions that are possible according to the business needs by defining info groups and maintained the characteristics of all actions
• Set up daily work schedules to represents the actual working time for a particular employee on a given day by defining the break schedules and variants
• Defined the work schedule rules to describe the work schedules that specifies the working times of a group of employees

Confidential

SAP HCM Corporate Trainer

Responsibilities:

• Provided in classroom, online and onsite. Utilized the tools Webex or Netmeeting for online meetings. Created and reviewed and user documentation activities, also the deliverables
• Developed materials such as instructor’s guide, student workbook, power point slides, exercise documents, and on-line user guides. Updated and maintained current courses
• Participated in meetings and liaised cross-functionally to gather data for the creation and production of materials and programs. Provided for all classroom courses
• Offered help test and implement new and emerging technologies for course development and delivery. Provided guidance to users on functionality and concepts
• Established and maintained a library of soft-copies curriculum resources and documentation files, power point slides and excel books with master data for the project
• Analyzed the learner characteristics, task to be learned, contexts and example exercises. Designed the learning objectives by choosing an instructional approach, assessment instruments and instructional strategy
• Communicated with Project team for technical components of . Developed materials that which are suitable for beginner class room environment
• Coordinated a variety of general administrative activities to support the program including planning, scheduling, coordinating and organizing sessions
• SAP HR Functional Consultant Amara Raja Batteries Ltd -- India
• Responsibilities:
• Involved in developing business blue prints, review documents, BPML and the configuration documents
• Responsible in implementing the PA, OM and Payroll components by following the business blue prints and developing the technical documents
• Setup and maintained organizational structure including organizational units, jobs, positions, cost center assignments etc. and involved in integration with the personnel administration
• Created Info groups, and action menus for personal actions like hiring, change of position, change of pay, also designed and configured user specific infotype menus as per the client’s requirement
• Configured wage types and wage type characteristics for various payment and deduction wage types and maintained various related tables. Set up the wage types using indirect valuation module - TARIF, PRZNT, SUMME, ANSAL for Infotypes 0008, 0014 & 0015
• Maintained number ranges and defaulted them through feature NUMKR, Configured Administrator groups and defaulted it through feature PINCH

Confidential

SAP HR Functional Consultant

Responsibilities:

• Maintained the groupings for collective agreements provision and personnel calculation rules
• Involved in creating wage type catalog, defining the wage type characteristics, and permissibility per info type and created the payroll accounting areas and control records
• Implemented Personnel Actions and modified existing Personnel Actions as per requirements
• Maintained objects in detail using infotypes in Expert mode
• Maintained and ensured correct settings in customizing for Essential relationships, Infotype per object type, Relationship characteristics and Allowed relationships
• SAP BW Consultant Coca Cola
• Designed and developed custom enhancements, interfaces, reports and transactions in accordance with technical and functional specifications to SAP modules
• Monitoring data loads, scheduling the weekly data loads, interacting with the clients from time to time to discuss the emerging technical issues
• SAP ABAP Developer, Confidential & Confidential
• Responsible for understanding of Functional specification, Preparation of Technical specification and Developing source code
• Developed BDC code and involved in the data migration
• Created ALV Reports according to the clients requirements
• Trained in ALE/IDOCS and RFC process
• Developed the front end menus, screens for data entry into the database
• Created the sales reports, stock reports, budget reports and designed the printing of reports with logos, date formats, column headings, totals, sub totals and grand totals