SUMMARY:

• Motivated and seasoned systems analyst/programmer with Lawson Business Intelligence, Business Objects, Crystal Reports and Database development experience
• Extensive experience with a variety of technical environments and industries including telecommunications, state and local government, school districts, mining and energy, healthcare, professional services and IT
• Experience developing SQL query scripts and application procedural activities
• Experienced in writing specifications and report charter documents as part of project deliverables to a client

TECHNICAL SKILLS:

Application Development Tools: Oracle 7.3, 8, 8 I, 9 I, 10g & 11g (Toad, SQL Developer), MS SQL Server 2000, 2005 & 2008, (Enterprise DTS Scripts, Stored Procs T - SQL), Seagate Crystal Reports Version 5, 6, 7, 8, 8.5, 9, 10, XI,R2,2008, 2011 Seagate Crystal Info Desktop, Business Objects XI R2/R3(Crystal Rpts, WebI, Universes), Business Objects XI R2/R3 (Business Views, Crystal Reports Server), Business Objects 3.1 (DESKI, WEBI, Universe), Crystal Server 2008/2011, Microsoft Project 98 - 2000, UNIX (Sun & HP & AIX Scripts), Lawson (Business Intelligence) for Payroll/HR/Financials/Supply Chain LBI, Microsoft Products, Visio, Microsoft Access, Microsoft Excel, PowerPoint, Microsoft Project

Version Control Tools: PVCS, StarTeam, Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential,Charleston, SC

LBI/Crystal/IBI Developer

Responsibilities:

• Assisting in a Go-Live situation with Roper St Francis Confidential, developing new reports for BI consumption for Global HR, Payroll.
• LBI/IBI administration.
• Create reporting views for users use in Crystal Reports.
• System and Business Analysis around the Lawson data for users to understand their reporting needs.
• Assist with interface creations to other systems from GHR/Payroll, sql development.
• Create Report, Interface and LBI/IBI specifications documentation.
• Hold management/user meetings to assist in understanding their reporting needs.

Confidential,Bonita Springs, FL

Report Developer

Responsibilities:

• Assisting in a Go-Live situation with Herc Equipment Confidential, developing new reports for BI consumption for Global HR, Payroll.
• Analysis of Lawson’s large Data Repository, which includes 100’s of tables for developing complex SQL Server views, stored procedures and testing sql queries.
• Built and configured and administered the Business Objects 4.2 server for report distribution.
• Built and wrote Interface flat files for external systems from GHR.
• Understands and tought business and other contractors the relationships between the various ERD’s for developing accurate data reports between the GHR and Payroll.
• Created complex command level sqls.
• Create Demo sessions to show the user audience functionalities of Business Objects, BI Launchpad.
• Work with the business and IT administration on the groups and roles to in corporate security and bursting of reports and dashboard accessibility.
• Built 1 universe for ondemand report querying using Business Objects.
• Fixed and streamlined Compensation Bonus Reports using Access databases and Crystal Reports.
• HR Talent - HR Foundations, S3 Payroll
• Developed, Implemented and Trained HR/Payroll employees on their Business Intelligence reporting.

Confidential,Chicago, IL

LBI Developer

Responsibilities:

• Developing complex supply chain reports, charts, smartnotes and dashboards for data within their Lawson ERP system.
• Analysis of Lawson’s large Data Repository, which includes 100’s of tables for developing complex oracle views, stored procedures and testing sql queries.
• Understands and tought business and other contractors the relationships between the various ERD’s for developing accurate data reports between the Grants, Finance, Payroll and Supply Chain.
• Created complex command level sqls.
• Created dashboards for users to run their reports.
• Work with support to configure LBI server(s)
• Create Demo sessions to show the user audience functionalities of LBI.
• Work with the business and IT administration on the groups and roles to in corporate security and bursting of reports and dashboard accessibility.

Confidential,Cedar Rapids, IA

Lawson Technical Analyst/LBI Developer

Responsibilities:

• Assisting in a Go-Live situation with UnityPoint, correcting and developing new reports for BI consumption for Finance, Payroll and Supply Chain.
• Analysis of Lawson’s large Data Repository, which includes 100’s of tables for developing complex SQL Server views, stored procedures and testing sql queries.
• Understands and tought business and other contractors the relationships between the various ERD’s for developing accurate data reports between the Grants, Finance, Payroll and Supply Chain.
• Created complex command level sqls.
• Work with support to configure LBI server(s)
• Create Demo sessions to show the user audience functionalities of LBI.
• Work with the business and IT administration on the groups and roles to in corporate security and bursting of reports and dashboard accessibility.
• HR Talent - HR Foundations, IPA, LTM

Confidential,Chicago, IL

LBI Developer

Responsibilities:

• Grants Management Crystal Developer. Developing complex supply chain reports, charts, smartnotes and dashboards for data within their Lawson ERP system.
• Analysis of Lawson’s large Data Repository, which includes 100’s of tables for developing complex oracle views, stored procedures and testing sql queries.
• Understands and tought business and other contractors the relationships between the various ERD’s for developing accurate data reports between the Grants, Finance, Payroll and Supply Chain.
• Created complex command level sqls.
• Created dashboards for users to run their reports.
• Work with support to configure LBI server(s)
• Create Demo sessions to show the user audience functionalities of LBI.
• Work with the business and IT administration on the groups and roles to in corporate security and bursting of reports and dashboard accessibility.

Confidential,Boise, ID

LBI Developer

Responsibilities:

• Supply Chain Management Crystal Developer. Developing complex supply chain reports, charts, smartnotes and dashboards for data within their Lawson ERP system.
• Analysis of Lawson’s large Data Repository, which includes 100’s of tables for developing complex oracle views, stored procedures and testing sql queries.
• Understands and tought business and other contractors the relationships between the various ERD’s for developing accurate data reports between the Finance, Payroll and Supply Chain.
• Created complex oracle views and command level sqls.
• Created dashboards for supply chain users to run their reports.
• Created documentation for requirements and approvals on design specs.

Confidential

Responsibilities:

• Enterprise Intelligence Developer/Administrator. Architecting and correcting security in existing Business Objects Environments for the Clinical Services group. Over 2000 users utilizing Xcelsius Dashboards, Web Intelligence and Crystal Reports.
• Upgraded and Installed virtual servers with Business Objects 4.0 and 4.1 software.
• Corrected non-working universe/business view layers for Risk Management and Physician Management Groups.
• Developed new WebI and Crystal Reports.
• Utilized various universes to obtain reports for various for Risk Management and Physician Management Groups.
• Learned Business Objects 4.1 - Explorer to help cross-train other developers the functionality.

Confidential

BI Developer

Responsibilities:

• Crystal Reports Developer for a purchased third party system called FlowCal. The system captures meter readings, liftings and financials for the Gas and Liquids transport of MarkWest.
• Develop Oracle queries to extract data from the Gas and Liquids modules of FlowCal.
• Develop Simple to Complex Crystal Reports using Crystal 2008 SP3 & Crystal 2011.
• Unit test interface and reports via sql - and system regression.
• Consult and demo Business Objects administrators of MarkWest the capabilities of Business Objects.
• Set up a brand new Reporting Portal for new Liquids system. Including security, Active Directory, and data level security.
• Solely Installed and Configured Business Objects 4.0 with Kerberos Windows AD Authentication.
• Administered the system appropriate security model for users in Finance, Marketing and Measurement Departments of MarkWest.
• Trained users on the use of the BI Launchpad.
• Trained IT in the administration of the Bus Objects. 4.0 environment. Tomcat Apache Server, Business Objects CMS Repository which includes the Windows Server 2008.

Confidential

BI Developer

Responsibilities:

• Business Objects developer for the Claims Department of Confidential . Developed Universes, Webi and Deski reports for executives and management personnel to help stabilize this very complex and large system implementation.
• The Department underwent a installation of a new Claims System last quarter of 2011.
• Developed complex Oracle queries for the Financials, Planning and Claims data reporting.
• Assisted the Business Objects Architect in developing and maintaining universes.
• Created schedules with Business Objects.
• Created exports utilizing Microsoft Access from Business Objects to Microsoft Access. Wrote an export component to run automatically for the Collections Department that used Claims data.

Confidential

Independent Contractor

Responsibilities:

• Returned for a second contract to complete and assist in HR / Payroll Reports efforts
• Create Complex SQL via SQL Server 2008 / SQL Server 2005
• Develop complex and highly efficient reports using Crystal Reports for front-end reporting of a Datawarehouse database
• Stabilized Lawson’s BI tool for performance and security
• Developed new logic for their new Lawson Payroll/HR System’s datawarehouse
• Datamart architecture and development
• Created complex SQL to correct an application error that Lawson provided which erroneously updated the General Ledger tables
• Analyzed across ERP subsystems to ensure data accuracy was completed Confidential all levels and was the technical lead on this huge endeavor which was corrected for user reporting & State Auditing purposes
• Developed transcript reports for Confidential Creek School District transcript system. Report was not working with an upgraded version of a third party system. Re-wrote a complex report using SQL and Crystal in a week’s time, the district paid a previous contractor 6 months of time to develop the same report which was broken after the upgrade
• Created Complex Power School Reports using Business Objects Queries to help stabilize the new system
• Utilized various universes to obtain reports for various groups of staff; managers, contractors and End-Users
• Utilized manual Oracle SQL scripts to override Universe generated SQL to manipulate data for metrics, system stabilization and various other reporting needs

Confidential

Independent Contractor

Responsibilities:

• Created Complex SQL via SQL Server 2008 / Oracle 10g
• Performed and developed test scripts against Confidential ’s Datawarehouse ETL processes
• Performed testing against a Cognos BI tool for the end user reporting and their .NET developed end user reporting tool
• Wrote technical Testing documents for Management and Compliancy purposes
• Met with users to ensure requirements were met

Confidential

Contractor

Responsibilities:

• Created Complex GL, HR, Payroll Crystal Reports using SQL via SQL Server 2008 / Lawson 9.1
• Created views, stored procedures and command level SQLS for data extraction and report development
• Consulted users and administrators on maintenance and development using Lawson’s LBI Dashboard tool
• Designed and installed Financial, Human Resource and Supply Chain Dashboards for the Confidential Creek School District website using Lawson’s LBI Dashboard product
• Administered Roles and Security for the Lawson Business Intelligence components
• Consulted on various levels of accuracy through the Lawson modules
• Re-Designed and developed in SQL l and Crystal, one of the most complex reports that Lawson created in COBOL. Developed in 1 month, code, uat and implemented to production with data security tied to it using data security rights structures that I initially designed and developed
• Performed report testing using various SQL testing scripts

Confidential

BI Developer

Responsibilities:

• Crystal Reports 2008 development for a reselling Kidney Dialysis Physician/Nurse application
• Created SQL command level queries using Oracle 10g & Oracle 11
• Administered Business Objects servers, migrated reports thru development, test and production servers
• Added User logins and passwords in Business Objects
• Customized front-end login screen, utilizing .NET
• Maintained a trusted, reliable resource amongst the teams Confidential Davita
• Was a leader in development of reports for the new Davita Kidney Dialysis Physician/Nurse application, facilitate understanding of what functionality the business needs in reporting
• Assigned to create 50 extremely complicated reports; this position had to be occupied by a very senior level Crystal Reports developer. The knowledge of building custom functions within Crystal’s repository and command level SQL querying was widely used on all reports
• Created test plans and scripts for SQL testing and Crystal Reports testing
• Documented and included test procedures

Confidential

BI Developer

Responsibilities:

• Asked to come back and work on expanding the Crystal Server Set-up that I designed and developed earlier in the year
• Assisted in the design of a Global DataWarehouse for their call centers in the US including India
• Worked on creating stored procedures and reports for their Global Client Reporting
• Served as the “expert” in Business Objects set-up, administration and development as before
• Built Business Views and Crystal Reports to integrate to the Crystal Server scheduling setup
• Developed documentation for training, business analysis, design, test plans and data and reporting specifications

Confidential

BI Developer

Responsibilities:

• Analyzed and designed a full data reporting mart for one of Confidential ’s Global Information Security suites
• Analyzed existing reporting venues that the GIS group of Confidential ’s Security department
• Took on the role of Business Analyst, designer, expert and developer of the consolidation of an online web-reporting suite
• Designed a consolidated reporting extract, ETL and data warehouse environment so that their reporting needs could be centralized and web accessible
• Demo’d the utilization of comparisons between WEBI, DESKI, Crystal Reports - reasons as to why Universes, Business ViewManager - Semantic Layers are beneficial for row level security, scheduling and data integrity for reporting needs
• Demo’d Business Objects Security Models. Open vs Close
• Developed universes using tables, derived tables and view
• Served as the “expert” in Business Objects set-up, administration and development
• Developed Demos for Business Objects XI upgrade from Business Objects 6.5., including a new universe, WebI suite of reports as well as migration demos from Crystal Enterprise to BO XI

Confidential

BI Developer

Responsibilities:

• Installed and Set up Crystal Reports Server for new Client Reporting project. In regards to setting up all Network capabilities for SMTP, unmanaged disk, FTP functionality, administration
• Set up Business View semantic layer for row level security access and schedules
• Created, maintained and distributed design, specifications and training documentation
• Assisted Manager with project plan for their Crystal migration of over 300 reports from Microstrategy
• Assisted in migrating MicroStrategy schedules for migrating to new Crystal Reports Server setup
• Served as the “expert” in Business Objects set-up, administration and development

Confidential

BI Developer

Responsibilities:

• Release Analyst/Developer for all Confidential ’s Business Objects XI R2 servers
• Set up users, administered the servers in DEV, TEST AND PROD environments; these environments have platforms on both .NET and Java
• Universe development using Business Objects XI R2 for Human Resource and Supply Chain data marts
• Developed security models for Confidential ’s Human Resource and Supply Chain data universes; Involves developing user, row level data security and general Business Objects access rights
• Set-up on all servers the auditing program that enables auditing for security, report scheduling and system problems. This involves knowledge with Universe development and developing Web Intelligence reports
• Redesigned Supply Chain reports using Crystal XI and SQL Server. This involves indepth knowledge of Crystal Reports and the architecture of Crystal components
• Consulted on the Business View layer that is currently being used on a purchased product to distribute Supply Chain reports
• Consulted on Business Objects components to all levels of management and other consultants
• Document reporting standards, test plans, development templates, specifications and procedures
• Created complex SQL views, stored procedures and functions for the Supply Chain datawarehouse BI project
• Wrote recommendations for redesigning, enabling and development Business Objects components
• Was extended another 6 months to managing the Human Resource report development along with my other duties w/Supply Chain
• Was the single Confidential for the corporate office for both Human Resource and Supply Chain

Confidential

BI Developer

Responsibilities:

• Developed complex Oracle stored procedures and views to build Crystal 10.0 then integrated them to the Lawson Financials application
• Developed and maintained complex financial reports using Crystal 10.0
• Analyzed Lawson data tables and relationships to create financial reports
• Consulted other Crystal users on “how to” use complex SQL statements
• Wrote requirement documentation for users using Lawson Reporting
• Worked with different levels of management to gather requirements
• Developed and enhanced Crystal Reports for the Call Center of Catholic Confidential Initiatives using a Remedy database
• Worked with the director of the Call Center to fix numerous reports that were not developed correctly by another consulting firm
• Troubleshot all Lawson modules particularly the Finance module
• Worked on Crystal XI and Lawson’s Business Intelligence tool called LBI 9.0
• Administered and learned dashboards, reports, security layers, roles and user accessibility

Confidential

BI Developer

Responsibilities:

• Programmed very complex Oracle stored procedures and views to build Crystal 9.0 reports for the Society
• Developed and maintained complex financial, statistical and critical reports for the fundraising departments and executive staff of NMSS.
• Consulted other Crystal users on “how to” build Crystal reports
• Wrote requirement and training documentation for the Society
• Worked with different levels of management to gather requirements
• Hired an additional programmer for Oracle data warehouse
• Developed presentational video conferences to demonstrate new reports to Society offices across the United States

Confidential

BI Developer

Responsibilities:

• Extracted data from an Oracle database using complex SQL queries, stored procedures and views.
• Developed and re-designed existing reports and new reports for the Dept of Human Services user population for the Confidential
• Worked with 6 business analysts to perform report specification documents and QA testing on all reports for the department
• Worked with front-end programmers to ensure integration of reports into the production environment
• Upgraded over 300 Crystal 7.0 reports to Crystal 10.0. And assisted with the administration of Crystal Enterprise version 10.0

Confidential

BI Developer

Responsibilities:

• Provided technical expertise in database management and support for the Navigant Litigation team on a short-termed contract.
• Extract data using complex T-SQL queries, Stored Procedures and Data Transformation Services using MS SQL Server 2000.
• Provided data support for 5 litigation counselors.
• Provided data analysis and data reports for the Sr. Consulting Staff of Navigant.
• Provided reports using Crystal.
• Perform DBA administration procedures to enhance query efficiencies and performance tuning.

Confidential

BI Developer

Responsibilities:

• Developed complex dynamic stored procedures for an internal web reporting system for the Confidential Communications call centers
• Wrote system documentation using Visio and Word
• Shared DBA responsibilities with other members of the team
• Gathered requirements from new customers throughout the Confidential business
• Taught other contractors SQL Server 2000 programming and administration tasks
• Optimized queries for efficiency with the web front-end performance
• Created DSN’s for linked servers, views, functions, scripts, DTS packages all using MS SQL Server 2000

Confidential

BI Developer

Responsibilities:

• Maintained and developed complex Crystal Reports for county courthouses in the state of California
• Traveled to various county seats in Northern California to assist in providing support for 50 - 100 pre-developed Crystal reports for each client
• Met with senior staff of each courthouse for requirements gathering and developed specifications for Crystal and legal documents and notifications that were generated through the Justice Edition application. This involved a very high degree of complex procedures and methods for the legal system workflow of the courthouse
• Provided development and configuration fixes to the Crystal reports so that they can be used through the Justice Edition application that Confidential Technologies sold and installed in various California state courthouses
• Wrote documentation for the Justice Edition system in regards to configuration, end-user support and report functionality

Confidential

BI Developer

Responsibilities:

• Provided technical expertise in database management and support for the Business Markets Group on a short-termed contract
• Extracted data using complex T-SQL queries, Stored Procedures and Data Transformation Services using MS SQL Server 2000
• Provided data support for ten Regional Business Managers
• Provided data analysis and data reports for the Sr. Staff of the Business Markets Group including the CEO
• Provided data extractions and reports using Actuate
• Performed DBA administration procedures to enhance query efficiencies and performance tuning
• Maintained application code on a Sales Quota Tool using Visual Basic 5.0

Confidential

Developer

Responsibilities:

• Provided technical expertise in database and Crystal Reports and Crystal Enterprise development for a web reports application used by internal staff of Confidential Glo International
• Developed on-line database connectivity drivers for establishing connections to various SQL Server databases
• Developed scheduled DTS scripts using the SQL Servers Database Transformation Services and Job schedulers. This included writing stored procedures and various sql statements to provide daily, weekly and monthly auto updates of the reports database
• Developed complex Crystal reports to provide report and chart displays for the website that would allow the user to select parameters for report manipulations Confidential anytime
• Provided consultation in database integrity and efficiencies in both SQL Server and MS Access
• Developed a reports mart for the sales staff to pull reports from the web
• Installed and maintained Crystal Enterprise and administered the technical customization of the website on the production servers
• Developed Functions, Stored Procedures, Views, DTS Packages, Job Schedules on SQL Server 2000. Recovered lost databases, troubleshot Database table relationship problems and fixed them
• Data Analysis for the JDEdwards ERP system, to fix front-end processes so data is consistent and dependable for reporting
• Maintained the Crystal Enterprise web pages for customization. This involves knowing html, vbscript and javascript

Confidential

Developer

Responsibilities:

• Provided technical expertise for an Access Control system written by Casi-Rusco
• Utilized Unix commands and wrote Unix scripts to troubleshoot existing problems in configuration and programming issues on an IBM RS/6000 server
• Assisted and re-trained the existing staff to help in organization, methods and procedures and stabilization in the Access Control technical user difficulties
• Wrote an analysis document of the existing program so an upgrade of newer technology can be installed
• Installed new external workstations off-site to access the application via Secure Area Manager client-side
• Re-wrote an access application for inventory on equipment

Confidential

BI Developer

Responsibilities:

• Provided Crystal Reports 8.5, Seagate Info, Crystal Enterprise and SQL Server consultation and training
• Demonstrated Crystal tools to the reports developers of Broadband Services to help them understand the ease and benefits of the product
• Wrote training material and conducted a series of training sessions in both Crystal and Crystal Enterprise solutions. The approval was made but then funding was cut during the contract

Confidential

Developer

Responsibilities:

• Provided technical expertise in database and web development for a web reports application used by internal staff of the Help Desk Centers for Confidential worldwide
• Developed on-line database connectivity drivers for establishing connections to various Siemens ACD system Informix databases.
• Developed automatically scheduled DTS scripts using the SQL Servers Database Transformation Services and Job schedulers. This included writing stored procedures and various T-SQL statements to provide hourly, daily, weekly and monthly auto updates of the reports database
• Developed .NET / ASP web pages using html, vbscript and javascript to provide user friendly report generation on the web
• Developed complex Crystal reports to provide report and chart displays for the website that would allow the user to select parameters for report manipulations Confidential anytime
• Troubleshot IIS server problems such as internal server application errors. Re-configured dll’s for proper IIS server use
• Developed Excel Pivot Tables and imported various types of raw data for analysis using Excel and Access
• Found and hired a Visual Basic Com programmer to work with me to build a COM layer for the website. Assisted in building classes, methods and functions for various data displays to the website
• Troubleshot development errors and corrected them
• Wrote system documentation including requirements and specifications for analysis and design
• Provided consultation in database integrity and efficiencies in both SQL Server and MS Access
• Provided Classroom Training and Demonstrations on the completed product to various users from around the world