Resume

Sign in

BO/BI Architect

Location:
O'Fallon, IL
Posted:
April 22, 2016

Contact this candidate

Resume:

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



Contact this candidate