SUMMARY:

• Business Analyst, Lawson Application Analyst with a verifiable track record of more than 7+ years of strong Experience in Business Analysis, User Requirement Gathering, User requirement Analysis, Gap Analysis, Source Systems Analysis and Reporting Analysis.
• Adept in working with Lawson HR/Payroll and Lawson Security.
• Experienced in Lawson Human Resource Modules: GHR/LTM, Personnel, Payroll, Benefits, ESS, MSS, General Ledger, Accounts Payable, Asset Management, Purchasing, Time Accrual, Lawson CASE/4GL and Absence Management for versions 9 and 10.
• Proficient in conceptualizing business requirements and models, performing gap analysis between goals and technical solution benchmarks, and designing process and system improvements to increase productivity while reducing operational costs.
• Proficient in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases. 
• Participated in the complete life cycle of the Project and the application code was developed in C#. NET. 
• Adept in analyzing projects and programs through the System Development Life Cycle (SDLC) processes employing Agile and Waterfall Project Management methodologies, and assessing electronic business solutions to achieved prescribed business objectives.
• Focused innovative professional, savvy in guiding diverse groups of stakeholders and leading cross - functional teams maximizing productivity.

WORK EXPERIENCE:

Lawson Application Analyst

Confidential, Atlanta, GA

Responsibilities:

• Worked closely with HR, Finance and Payroll in providing support on all modules of Lawson LBI Dashboards.
• Created Interfaces (Employee Demographics, Census, Accruals, Labour levels and Time Detail) with Lawson HR/Payroll and epic clinical systems and Configuration, maintenance and troubleshooting pay rule functionality.
• Create numerous third party vendor extract programs using Lawson Micro Focus Cobol and Lawson APIs formatting data to their record specifications (fixed or csv).
• Managed project including upgrading to Infor/Lawson v9 to v10, GHR and API.
• Responsible to include a system change from Lawson v9 to Lawson v10.
• Developed and maintained SSIS packages to extract transform and load (ELT) data to SQL Server.
• Successfully upgraded Lawson from v9 to v10 and became senior member of team and trained all new employees.
• Designed, programmed, tested, and debugged application programs for the Payroll and Accounting Departments. 
• Validated and performed acceptance for all Interfaces for HR, Payroll, and Benefits Modules. 
• Performed analysis and developed Lawson ERP system solutions - gather user requirements, assess business processes, develop and maintain finance module program/job setup, and document system setup and functionality.
• Designed and build new Oracle PL/SQL packages as required from the technical specifications documents gathered by the Business Analysts. 
• Responsible for functional and technical exposure of Lawson modules like HR, Payroll, Benefits, Cash management, Employee Self Service (ESS) and Manager Self Service (MSS).
• Involved in all stages of the SDLC using Agile, Waterfall and scrum methodologies. 
• Scheduling of Lawson HR & Payroll, Benefits, Lawson AP, Lawson Work Flow, Lawson system shutdown/ startup process.
• Created security profiles for new users and also Assigned Lawson Security Roles and groups to users.
• Improved existing reports and wrote new reports by designing Oracle PL/SQL procedures.
• Involved in the SDLC phase of requirement analysis, design, and development of the web based intranet application tool using ASP.NET and C#. 
• Involved in creating UAT Test plan, Test strategy documents and prepared UAT Test Incident Report, Test Metrics Report, RTM and other SDLC Deliverables.
• Lead and provide classroom style and one-on-one training to team members in Lawson Software System using S3 LBI, Smart Notification, and Scorecard.
• Implemented Infor Process Automation (IPA) and designing process flows for different Lawson Clients.
• Developed scorecard analysis and Metrics for HR Leadership and Executive. 
• Worked with Microsoft SQL server transactions (SSIS - SQL Server Integration Services) that interacted with FTP on a daily basis. 

Lawson application analyst

Confidential, Dublin, OH

Responsibilities:

• Supported Client HRIS Reporting System that utilizes Infor/Lawson release 9.0.1 HCM Applications during transition period for migration from Lawson GHR to SAP Success Factors.
• Planned and performed the Upgrade strategy from 8.0.3 to 9.0.1 Lawson applications. 
• Owned the entire migration of crystal reports to Lawson Business Intelligence.
• Responsible for maintaining the development, debugging, testing, and support of the Micro Focus Cobol and Oracle programs.
• Maintained SSIS packages and processes for server monitoring and notifications.
• Centralized Dependent Benefits and managed project to move dependent benefits from 3rd party into Lawson and interface with Health Provider.
• Created on-request Micro Focus Cobol and Oracle Reports for standard ad hoc requests. 
• Conducted Integration and regression testing and coordinated UAT with business users.
• Facilitated daily scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues that the Scrum Development team faced. 
• Improved the performance of the application by rewriting the SQL queries. 
• Provided Lawson Smart Office training to HR/PR team. 
• Involved in the complete life cycle of the Project and the application code was developed in C#. NET. 
• Worked with consultants for our current V9 to V10 upgrade and handling day-to-day production issues.
• Conducted workshop on how to effectively use Lawson Smart Office (LSO) to improve quality of work.
• Based on analysis, redesigned Payroll, HRIS and HR process for improved efficiencies and to ensure better data integrity.
• Developed PL/SQL Packages and Procedures accordance with Business Requirements and also to extract the data from different sources and load it into data warehouse. 
• Involved in scheduling of Lawson HR & Payroll, Benefits, Lawson AP, Lawson Work Flow, Lawson system shutdown/ startup process. 
• Conducted an analysis of client requirements for interfacing information between the two systems. 

LAWSON Business Analyst

Confidential, Trenton, NJ

Responsibilities:

• Resolved Unit Acceptance Test issues for Asset Management, Accounts Payable, General Ledger (GL), Process Flow and Inventory Control modules.
• Provide back-up support to S3 Security Analyst and Lawson System Admin as well as after go-live support to end users through the Remedy ticketing system.
• Responsible for conversion and implementation of Lawson applications including customize modules to meet client's business processes.
• Wrote SQL programs collecting Lawson data for research and testing, responsible for performing recoveries.
• Worked on the entire migration of crystal reports to Lawson Business Intelligence (LBI).
• Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing.
• Consulted, implemented, and upgraded projects in the Lawson Application Suites of Financials and Human Resources including technical knowledge including Lawson installations, upgrade software.
• Involved in installations, Lawson cyclical installations, and "hand-applied" patches.
• Designed, developed, tested, and implemented interfaces to and from Lawson Systems for Assets and Budgeting.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds. 
• Involved in design and development of user interface for public web application and intranet application using Visual Studio, C #. NET.
• Involved in requirement scoping, documenting and analyzing high priority requirement for implementation; created BRD, FRD and use case documents using Waterfall methodology and used SQL queries to extract information from database. 
• Worked with staff from the surgical system vendor on a Lawson to SIS HL7 item feed and a SIS to Lawson item usage interface.
• Created custom load, monitoring, error checking and database change applications to improve the client's ability to maintain the Lawson database, including the development of custom tables in the Lawson database.
• Implemented report bursting for corporate and field users utilizing Lawson Reporting Services, Crystal Reports XI and Back Office Reports.
• Performed all Transact SQL queries for historical data.
• Identified and corrected data integrity errors within the Lawson HRIS system.
• Conduct project meetings, JAD sessions, and status update meetings. Coordinate and manage in-team and cross-team communication.

Payroll/ HRIS Analyst

Confidential, Atlanta, GA

Responsibilities:

• Wrote Unix shell scripts to automate MHC Laser Check process with Lawson's AP/PO/BL module.
• Maintained all functional documentation for Lawson HRIS system including user guides and training manuals.
• JAD and configure Landmark Security application for Sourcing, Contract and Travel Expense Management.
• Ensure completeness of requirement gathering, that all the steps of SDLC are addressed, and traceable.
• Provided technical and operational support for Lawson ERP System, including HR, payroll, purchasing, materials management, and finance.
• Completed many ad-hoc reports using temperate SQL queries and PL/SQL to create procedures, functions at Oracle production environment.
• Integrated Lawson E-Procurement/PO with FaxServer; Requisitioning Self-Service and EDI processing of orders.
• Participated in system wide test planning and wrote application specific test plans and documented test scripts and consucted UAT along with business users and coordinated UAT as UAT Lead.
• Supporting Lawson GHR-Payroll, 401K, Benefit, Time Accrual, Year-end processing.
• Performs systems development and maintenance of the Lawson System.
• Managed and prepared monthly dashboard reports of Supply Chain.
• Developed and maintained data warehousing and access via Crystal Reports, MS Access, MS SharePoint, and Lawson Business Intelligence (LBI).
• Worked on multiple Lawson upgrades, implementations, and conversions.
• Responsible for managing, planning, processing and performing all jobs in an efficient manner for Lawson and API.
• Familiar with Data Transformation Services (DTS) in SQL server 2000. SSIS in SQL Server 2005, 2008 and have taken advanced classes in SSIS.
• Provide ongoing support and evaluation of projects within Account Payable and Finance, Payroll, GL departments (100% completed implementation of Lawson EDI.
• Coordinated Joint Application Development (JAD) session with system analysts, development team, project manager for application development and Pre-validation specifications.