
Sr. Technical Consultant at Confidential
Greater St. Louis Area

Sr. Technical Consultant at Confidential
Greater St. Louis Area
Lawson Business Intelligence (LBI), Crystal Reports, Lawson data model, PL/SQL, T-SQL, SSRS, SSAS, SSIS, LBI Consultant in St. Louis, MO (Missouri), Remote, LBI Implementation certified.
(Public Company; Hospital & Health Care industry)
2009 — Present (less than a year)
(Non-Profit; Hospital & Health Care industry)
2009 — 2009 (less than a year)
Remote conversion and optimization (for performance and efficiency) of Brio reports to Crystal reports for Lawson HRIS.
(Non-Profit; Hospital & Health Care industry)
2007 — 2009 (2 years )
Development and implementation of Business Intelligence solutions for Finance and HR, including the automation of the financial reporting process, development of a data mart for HR data to simplify development of complex reports, and development of Direct Patient Care productivity metrics. Tools utilized include Lawson Business Intelligence (LBI), Crystal Reports XI, Xcelsius, and PL/SQL.
(Hospital & Health Care industry)
2008 — 2008 (less than a year)
Remote/off-hours implementation of SQL Reporting Services (SRS). Convert existing Crystal reports to SRS reports.
(Public Company; NAVI; Information Technology and Services industry)
2008 — 2008 (less than a year)
Remote/Off-hours performance tuning for Lawson Reporting Services (LRS).
(Non-Profit; Hospital & Health Care industry)
2007 — 2007 (less than a year)
Remote/Off-hours LBI installation/configuration/development.
(Partnership; Hospital & Health Care industry)
2007 — 2007 (less than a year)
Remote/Off-hours LBI installation/configuration
(Non-Profit; Hospital & Health Care industry)
2007 — 2007 (less than a year)
Remote/Off-hours Framework Services and Crystal Report development for Lawson GL reports.
(Hospital & Health Care industry)
2007 — 2007 (less than a year)
Remote/Off-hours Crystal Report development for Lawson GL reports.
(Non-Profit; Hospital & Health Care industry)
2007 — 2007 (less than a year)
Remote/Off-hours Crystal Report development for Lawson payroll reports.
(Non-Profit; Hospital & Health Care industry)
2006 — 2007 (1 year )
Provide support for the BI environment (BOXI, LBI). Recommend, design and implement architecture changes to the BI environment to improve performance and reliability. Develop customizations as needed to add to and improve functionality of the BI environment. Provide performance-tuning recommendations for BI content. Perform root cause analysis to troubleshoot environment issues.
(Hospital & Health Care industry)
2006 — 2007 (1 year )
Remote/Off-hours requirements gathering and report development of Crystal reports against a Great Plains database.
(Privately Held; FIG; Financial Services industry)
2006 — 2006 (less than a year)
Framework Services and Smart Notification development.
(Non-Profit; Non-Profit Organization Management industry)
2006 — 2006 (less than a year)
Production support and architecture/environment analysis and recommendations for the BI environment.
(Non-Profit; Hospital & Health Care industry)
2006 — 2006 (less than a year)
Remote/Off-hours Crystal Report development for Lawson payroll reports.
(Non-Profit; Hospital & Health Care industry)
2005 — 2006 (1 year )
Member of team tasked to meet Business Intelligence (BI) needs for a Lawson implementation at the second largest Catholic health system in the US. Tracks included Financial, Payroll and Supply Chain. BI needs satisfied using Crystal Reports XI, Smart Notifications and ProcessFlow.
(Non-Profit; Hospital & Health Care industry)
2004 — 2005 (1 year )
Team Lead for a group tasked to meet interface and reporting needs for a large-scale Lawson implementation (Financials, HR/Payroll, Supply Chain). Lawson reporting needs delivered using Crystal Reports 10, w/ distribution via Lawson Reporting Suite, including Reporting Services and Smart Notifications. Development process included identification and documentation of requirements. Duties included working with customers to manage expectations. Designed/implemented reporting data sources utilizing PL/SQL scripts and Materialized Views. Automated processes utilizing Unix/Linux scripts, PL/SQL scripts, and Java Stored Procedures. Project Management via MS Project. Version control via CVS.
(Privately Held; Marketing and Advertising industry)
2003 — 2004 (1 year )
Performed the system administration of all HRIS applications, including Lawson, BSI TaxFactory and FOY. Designed/implemented reporting Data Mart utilizing PL/SQL to efficiently meet reporting needs while minimizing the impact of reporting on the production databases. Implemented/administered Crystal Enterprise including security design. DBA duties included development/maintenance of Oracle Views and security permissions for data feeds. Performed administration of Lawson security (laua).
(Privately Held; Marketing and Advertising industry)
2001 — 2002 (1 year )
Led the project to convert reporting solutions from a mainframe database using FOCUS/JCL language to Oracle utilizing Crystal Reports and PL/SQL. Routinely completed database design, development/optimization of Stored Procedures and other PL/SQL scripts. Handled development, analysis, and testing of ad hoc and production reports on a daily basis.
(Telecommunications industry)
2000 — 2001 (1 year )
(Telecommunications industry)
1997 — 2000 (3 years )