Ryan Monson
O’Fallon, IL *****
acugsm@r.postjobfree.com
Skill Set
Business Intelligence Systems Expert –15 years of Business Objects architecture, administration, installation, upgrade, working with Universe Designer, IDT, Xcelsius, Dashboards, Design Studio, Explorer, Lumira, Webi and Crystal report writing on Teradata, Oracle, DB2,UDB, Essbase and SQL Server databases.
Team Lead and Project Management Expertise - Team management of up to 10 programmers at a time working on various projects. Led the introduction of successful project management practices while managing various projects within the organization.
BI Architecture Expertise -
Data Warehouse Expertise - Strong understanding of Oracle, DB2, Teradata and SQL Server relational database systems including 13 years experience in data warehouse design, implementation, maintenance, ETL process development, data modeling, query optimization, etc.
Programming - Expert experience with Business Objects, SQL and PL/SQL. Some programming experience with Java, VBA and Korn shell scripting.
End user experience with MS Powerpoint, MS Access, Visio, MS Project,Data Junction, Object Cycle, TOAD, JIRA, DB Visualizer, Citrix, Goldmine, CodeWright, PVCS, MKS integrity, Putty, WinSCP, Tectia SSH, Hummingbird Exceed, Tortise SVN, ClearCase and ClearQuest
Industry Experience
Transportation and Logistics, Military Systems, Mortgage/Lending, Credit Card, Finance and Investments, Banking, Health Care, E-Commerce/ Internet, CRM Software, Incentive and Travel
Clearance Level
Active DoD secret clearance with NAC-LC background investigation, Treasury high clearance
Certifications
Security +
Professional Experience
May 2014 to present – Federal Reserve Bank of Kansas City
Position: BI Consultant with functional roles of BI Architect, Team Lead and Senior Developer
Architected an active-active clustered multi tiered scalable server solution for high availability and disaster recovery
Configured BO servers for high load including extensive experience with APS (Adaptive Processing Server) split-out, adjusting memory size and other setting
Conducted vulnerability assessment and resolved all issues that were found
Coordinate with other technical groups including java and ETL teams to fix outstanding issues and assure seamless integration across tools meet SOA design standard principles
Led two separate Business Objects developer teams of up to four programmers to design and build a highly complex reporting portal with dozens of Dashboards and Webi reports
Detailed a plan to establish a BICOE to coordinate BI efforts across multiple teams
Oversaw a 6 month engagement with SAP where we reviewed the current set of Dashboards in great detail to improve performance
Led a performance improvement initiative with our hosting partner resulting in an average 500% improvement of report runtime
Upgraded two separate deployments from BOXI R4.0 SP4 to 4.1 SP4 enabling an active-active cluster and creating detailed documentation for our hosting partner. One of these upgrades was Solaris to Solaris and the other was Solaris to RHEL.
Installed Design Studio, Explorer and Lumira and built a proof-of-concept dashboard for each
Optimized and created complex universes (both unv and new unx formats) building derived tables for enhanced performance
Used the agile software development method including daily standup meetings, working in defined sprints, tracking progress using JIRA and making use of team Kanban boards. Requirements were typically delivered as user stories.
2007 to May 2014 – Lockheed Martin
Position: BI Consultant with functional roles of BI Architect, Team Lead and Senior Developer
Led up to five Business Objects and Java developers to design and build a highly complex reporting portal with over 200 reports and dashboards and almost 10,000 users
Led the BI portion of major sustainment initiatives which involved coding and testing upgrades and fixes using some agile methods including working with a scrum master and having daily standup meetings for defined sprints. Processes were also optimized using the CMM (Capability Maturity Model).
Managed the relationship with Business Objects submitting multiple issues for resolution, enhancement requests, etc.
Architected and implemented complex enterprise security model for two deployments
Architected the clustered multi tiered scalable server solution for high availability and disaster recovery with a hot standby failover capability
Designed and implemented dozens of complex universes (both unv and new unx formats) against Teradata and Oracle databases
Upgraded the deployment in all environments to BOXI R3 SP2 and later 4.0 SP4 enabling an active-active cluster with a firewall between the BO servers and the Web servers
Architected underlying database solution for fast query response hitting a database with 5 years worth of data and hundreds of tables, many holding over 100M rows.
Worked with custom MDM tool to ensure data integrity and facilitate data sharing
2006 to 2007 – Cerner Corporation
Position: BI Architect and Team Lead
Led a team of BO programmers to roll out a Dashboard POC used as the new product web platform
Researched and delivered a high level plan to build a Business Intelligence Center of Excellence (BICOE) company-wide which was quickly adopted
Managed the relationship with Business Objects submitting multiple issues for resolution
Designed and implemented enterprise security model for two new deployments
Architected the disaster recovery (failover) solution
Oversaw data modeling work to assure optimal data model structure for reporting
Worked on the base set of customer reports including Webi reports, Deski reports and dashboard analytics
Designed and implemented complex universes against several Oracle databases including transactional systems, an ODS, a data warehouse and several data marts
2006 – TD Ameritrade
Position: BI consultant with functional roles of Lead Architect and Lead Programmer/Analyst
Designed and implemented enterprise security model for new BO XI R2 portal
Managed the relationship with Business Objects submitting multiple issues for resolution and working on the beta program to make sure future requirements for the OLAP Intelligence implementation would be met
Worked with OLAP Intelligence documents, implementing them as part of the corporate dashboard
Architected the disaster recovery (failover) solution
Oversaw data modeling work to assure optimal data model structure for reporting
Worked on many aspects of the corporate dashboard including development of many metrics and analytics
Did some investigation and proof-of-concept work with Crystal reports and Xcelsius
Designed and implemented complex universes against Essbase and Oracle databases
2004 to 2006 – JP Morgan Chase - RPS (Retirement Plan Services)
Position: BI consultant with functional roles of Architect and Team Lead
Architected, installed and did much of the development for the company reporting portal using BO XI R2 and Dashboard Manager XI R2. This involved a very innovative and highly customized use of the dashboard manager tool to replace InfoView as the reporting portal.
Architected the enterprise BO 6.1b platform for use with standard ad hoc reporting and large scale extremely complex production statement reporting (1 million reports of up to 30 pages each run in 5 days)
Rolled out Data Integrator 6.5, XI R1 and R2 for use as ETL tool supporting the overall BI solution, also writing ETL processes with the tool
Helped design and build an extremely complex and demanding ETL processes of almost 100 operational source tables into a reporting data mart and various other smaller projects
Designed and implemented standardized reports using Business Objects including Full Client and Web-Intelligence. These reports included extremely complex statements with very data-dependent dynamic builds.
Designed and implemented new database systems and optimized existing systems, working extensively with both test and data quality teams to ensure high data quality for the data warehouse and data mart
Designed and implemented complex universes against a DB2 database. Coded complex ad hoc SQL.
Assessed prospective use of other vendor software including Microstrategy, Cognos, Hyperion/Brio, SAP, SAS, Oracle, Information Builders and Actuate
Managed the relationship with Business Objects submitting over 100 cases with enhancement requests and error reports and interfacing with key technical personnel
Trained report developers and business super users
Developed and implemented the physical server architecture and the security architecture for the reporting portal
2005 – Wells Fargo
Position: BI Consultant
Consulted regarding the XI upgrade to the system, merging the three various business reporting units into one in a massive $12 million dollar project. Gave high level recommendations regarding architectural details including performance management rollout and merging Crystal reporting and BO reporting onto the XI platform.
Provided insight into strategic and timeline considerations regarding the deployment SDLC
Installed and configured BO training software
2003 to 2004 - GMAC - RFC (General Motors Acceptance Corp, Residential Funding Corp)
Position: BI Consultant with functional roles of BI Architect and Senior Programmer/Analyst
Managed design and implementation of standardized reports using Business Objects including Full Client, Web-Intelligence and Broadcast Agent. These reports included complex analytics, cycle time tracking, workflow process tracking, etc.
Architected and implemented new database systems and modifications to existing systems, working extensively with both test and data quality teams to ensure high data quality for the data warehouse and data mart
Working directly with key operations executives for business intelligence systems delivery role with an outstanding reputation for reliability, accuracy, timeliness and communicating well
Designed and implemented complex universes against an Oracle OLTP database, Oracle data warehouse database and a SQL server Data Mart, as well as coding in SQL, PL/SQL and query tuning with SQLab. Also occasionally using Access for reconciliations and other miscellaneous reporting
Assisted in upgrade from v. 5.1.6 to v. 6.1a, 6.1a to 6.1b and various administrative duties.
2002 to 2003 - MasterCard International
Position: BI consultant with functional roles of Technical Project Manager and Senior Programmer/Analyst
Worked as contractor at MasterCard in the data warehouse managing design and implementation of standardized reports using Business Objects Full Client and Web-Intelligence
Designed and implemented new database systems and modifications to existing systems, working extensively with both test and data quality teams to ensure high data integrity for the warehouse
Primary contact between key VP and SVP executives in NY HQ for business reporting delivery role with an outstanding reputation for reliability, accuracy, timeliness and communicating well
Designed and implemented complex universes and made dozens of business objects reports based on these universes
Coding in SQL, PL/SQL, some Java, UNIX Korn shell scripting, also occasionally using Access for reconciliations and other miscellaneous reporting
Scaling and upgrading current applications to handle increased load demands, new processes and implementation of new functionality on older platforms and systems, implemented complex data ETL processes
Utilized MDM principles to ensure data integrity and facilitate data sharing, removing redundant data
2000 to 2001 - Meridian Enterprises
Position: Technical Project Manager and SQL Developer
Worked with large corporate clients such as IBM, DuPont, HBO, etc, managing CRM programs that incented sales of about one billion dollars, with combined budgets of over one million dollars
Managed Java, Unix and Powerbuilder web development teams for website implementation and backend administration of multiple incentive programs
Coding in SQL, PL/SQL, some Java, Powerbuilder and VBA on a Solaris UNIX platform and Oracle 8i data warehouse, with an n-tier architecture
Communicated technical issues effectively and worked through difficult issues while maintaining positive relationships
Worked in specialized role as analyst of Oracle data warehouse, including writing SQL and PL/SQL primarily using TOAD as an interface to the database. Most SQL written was to produce reports, load data using customized ETL processes, and manipulate data within the data warehouse. Many of these reports and queries were used in conjunction with website design to implement OLTP for thousands of internet claims and OLAP functionality for dynamic internet management reports
Worked extensively in Access 2000 designing new databases, maintaining existing databases, using Access to design and implement complex data loads into the Oracle database
1999 to 2000 – iShopper.com
Position: Senior Project Manager
Managed programming, content, design and creative resources in order to successfully meet client needs and budgetary constraints, working on both internal corporate projects and outside business clients' websites
Managed the design and implementation of up to 5 projects and 10 developers at one time
Managed the development of E-Commerce solutions with various merchant gateways, coded in iHTML, HTML and JavaScript, run on an MS SQL Server 7 database and IIS Web Server
Screened, trained and managed other project managers and programmers, created and implemented new company policies and procedures for all project managers
Began a new division, developing business strategy, budget projections, hiring staff, etc., just before leaving
Education
University of Missouri St Louis – Senior in finance with a 3.85 GPA. Not currently attending and not yet graduated