James Ronan
Reporting and Visualization Designer at Systems Plus, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Experience
-
Systems Plus, Inc.
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Reporting and Visualization Designer
-
Jul 2021 - Present
Reporting development using Crystal Reports, BIRT and Business Objects. Visualization design and development using Power BI. Current investigating Service Now reporting features. Reporting development using Crystal Reports, BIRT and Business Objects. Visualization design and development using Power BI. Current investigating Service Now reporting features.
-
-
-
Zantech
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Crystal Report Developer
-
Apr 2017 - Jul 2021
-
-
-
CGI
-
Canada
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior Consultant
-
Jan 2015 - Aug 2016
Momentum Client Releases (MCR) GroupBusiness Analytics reporting and Momentum Data Warehouse (MDW) applications for Federal Communications Commission (FCC). - Production support of FCC data loading process using Data Services Designer to correct and restart batch ETL procedures.- Completed upgrade to Business Objects 4.1 at FCC with related Momentum 7.0.3 enhancements in multiple environments, following retirement BO 3.x by SAP.- Improved performance of 20 Business Objects reports through analysis of underlying SQL and universes. Provided indexes, universe joins, BO administration changes and removed Cartesian products to meet client response time expectations.- Utilized Business Objects Query Builder and log files to investigate and resolve data issues in BO to re-establish BO Instance Manager task scheduler. Upgraded Business Analytics reporting for Nuclear Regulatory Commission (NRC). Production support of report runtime improvements.- Installed Business Objects 4.0 software upgrades related to NRC’s Momentum upgrade.- Migrated client data, universe definitions, reports and security profiles to upgraded environment via Upgrade Management tool, with no loss of data.- Improved report runtimes by completing technical analysis of reporting requirements, modifications to Universe definitions and report and graph creation. - Resolved BO configuration issues via Central Management Console and BI Launch Pad features.- Created stored procedures and ad-Tempus batch procedures to improve BO Oracle performance. Show less
-
-
Senior Consultant
-
Feb 2007 - Mar 2015
Developed detailed invoice and billing reports for services purchased through CGI Federal’s IaaS Cloud Computing Offering, allowing CGI to bill services to appropriate Federal Civilian clients. - Created requirements and technical designs based on Oracle table definitions and processing definitions of source systems. - Led 2-developer team in completing software using Crystal Reports.- Developed 4 of the invoice reports to provide detail and summary level views.- Performed monthly operations tasks to execute and deliver invoices to appropriate client manager.Provided Tier 1 and Tier 2 issue resolution across 12 departments and agencies.- Technical analysis, creation, and modification of over 200 reports and batch procedures. - Tasks included new legislation requirements, business rule modifications, layout and parameter changes. - Contributed to successful contract captures for CGI Federal Momentum Financials by developing reports and universe enhancements for CGI Federal’s Pentaho MDW product offering, including metadata changes and custom reports for product demonstrations.- Provided technical analysis and software for FFS to Momentum Financials conversions. Show less
-
-
Senior Consultant
-
Jan 2003 - Jan 2007
US Department of StateSoftware delivery manager and technical expert consultant for Centralized Financial Management System (CFMS), State’s custom FFS version. Responsible for all software deliveries and customer issue resolution.- Completed technical analysis and cost estimates for proposed enhancements. - Provided subject matter expert cycle support for production simulation environments and technical support for several development and test environments. - Developed technical analysis and design of journal conversion, budget remediation, and data reconciliation for CFMS to GFMS Migration using SAS and SQR. - Completed migration of International Boundary and Water Commission (IBWC) to GFMS system. Show less
-
-
Technical Manager
-
Jan 2002 - Dec 2002
FFS Baseline Team Technical manager for baseline version of CGI’s proprietary Federal Financial System and team responsible for product. Responsible for technical phases of the project including software development and testing, product documentation, release packaging and delivery to multiple clients.- Delivered release software and technical assistance to all FFS Clients. - Completed Joint Financial Management Improvement Program (JFMIP) Certification of FFS and companion FACTS II Supplemental Certification sponsored by Program Management Office of OMB. Show less
-
-
Technical Manager
-
Jan 2000 - Dec 2002
US Department of InteriorTechnical manager for DOI version of FFS. - Technical supervisor and assignment manger for team of 5 software developers. - Responsible for additional features and capabilities required by US House of Representatives.- Provided enhancement development and release delivery of all software and related documentation, including successful delivery of Custom Release 5.1.7.- Developed DOI Reporting Database Project, enabling ad-hoc query capability in an Oracle based mainframe application. Show less
-
-
-
CGI Federical Inc.
-
Fairfax, Va.
-
Technical Expert Consultant
-
Jan 2002 - Dec 2003
US Department of Housing and Urban Development Technical expert consultant for Housing and Urban Development Central Accounting and Program System (HUDCAPS), HUD’s custom version of FFS. Responsible for technical analysis and design of customer enhancements for CORE Foundation Software Upgrade. - Prepared software deliveries and Tier 3 customer issue resolution for DB2 database elements. - Provided SME cycle support for production environment and DB2 database administration and technical support in multiple client environments. Show less
-
-
-
CGI Fereral Inc.
-
Faixfax, Va.
-
Consultant
-
Jul 1998 - Dec 1999
USDA Farm Service Agency Delivered FFS technical support, including software modifications and technical support. • Resolved response time and capacity issues, improving system. • Developed environmental documentation for use by CGI and client team members. Office of Personnel Management Customized and installed FFS Nightly and Monthly Batch Maintenance and Reporting cycles. • Coordinated installation of production system with client organization and provided technical support for first months of operation. • Customized FFS Reporting software, including the SF133, SF224, and OPM System Assurance reports, meeting specific environment requirements by modifying baseline product. US Department of Agriculture Developed client specific training materials for CGI’s FFS and CORE application products. Provided training presentations to New Orleans USDA Staff. US Department of Housing and Urban Development Designed, developed and tested new Document Processor simplifying Public Housing Operating Fund Business Process by combining reservation and obligation of funding into single function. US Department of Interior Provided technical support to Project Team and client personnel. Responsible for issue resolution for DOI cross-serviced agency clients, including Bureaus of Indian Affairs, Land Management and Reclamation. Show less
-
-
Education
-
The College of New Jersey
Bachelor of Arts Mathematics, Mathematics and Computer Science