Project Sql Server
Resume:
Robert Brawn BSA Chronological Resume
Robert Brawn Business Systems Analyst
Email:
abphfc@r.postjobfree.com
http://Robert.Brawn.name/BSA
OBJECTIVE:
Business Systems Analyst
SUMMARY:
Innovative, customer-focused problem solver with sharp analytical
skills and outstanding communication skills. Very comfortable
bridging the traditional communication gap between the
Information Technology world and the Finance world.
SELECTED SKILLS:
Data modeling & process modeling Architecture & planning Written and verbal communication Microsoft Office, Microsoft Project
OLAP - Online analytical processing
(Applix TM1, Hyperion, SSAS) RDBMS - Relational databases
(Oracle, Informix, Ingres, SQL) 4GL GUI applications
(PeopleSoft, OracleForms) Object-oriented
(Java, C++) 3GL programming
(C, Pascal, embedded SQL) Scripting
(MDX, perl, T-SQL, PL/SQL, unix, ksh, awk, sed, grep) Web development
(arcPlan dynaSight, html, FrontPage)
PROFESSIONAL EXPERIENCE:
Jan 2008 - Mar 2008
Senior Business Performance Consultant, Bellevue, WA
Initial introduction to the Microsoft suite of BI tools including
the SQL Server stack and PerformancePoint Server.
My position was eliminated in a reorganization.
Tools:
MS Vista, SQL Server 2005, SSIS, SSAS, PerformancePoint Server 2007,
Virtual PC, Virtual Server.
Apr 2006 - Dec 2007
Senior Business Intelligence Consultant, Bellevue, WA
Developed financial reporting systems;
provided IT and financial consulting
Improved performance of ad hoc queries from 45 minutes to
less than 1 minute.
Developed flexible web-based reports for Income Statement,
Balance Sheet, variance reports, regional reports.
Created system to capture local data and create consolidated
global data for footnotes in annual report.
Tools:
Applix TM1 8 & 9, arcPlan dynaSight 4, Windows XP,
ExamDiffPro, MS Excel, MS Word, MS Project.
Founded in 1998; full-time 2003 - 2006
Co-Founder, privately held corporation
Angel Inn Capital Management, California & Nevada
Investment Manager of stock market portfolios for a small number of
select clients. Director, CFO & Treasurer.
Recommended and transacted stock & stock-option investments
for clients, based on client preferences, technical analysis of
individual investment, and fundamental analysis of general
market conditions.
Participated in corporate board-level and executive-officer-level
strategic decisions.
Feb 2000 - Jan 2003
IT Engineer, Santa Clara, CA
Developed and maintained administrative and financial software
applications supporting Human Resources.
Cut two weeks out of implementation time by including multi-functional
participation at earlier phase of vendor outsourcing process for
Agilent s employee retirement benefits.
Researched and revised the Disaster Recovery Plan (DRP) for Agilent s
stock option administration system. Uncovered incorrect procedures
which prevented restoration of the database from backup tapes.
Analyzed problem, fixed procedures, tested the revised DRP, and
restored the database. This allowed the department to pass an
internal audit as well as preparing for an actual disaster.
Maintained and enhanced Oracle data warehouse supporting Agilent s
employee stock option benefit system. Created offline databases and
scripts to extract, translate & load (ETL) data, enabling data
migration for two large corporate acquisitions and one large
divestiture. Saved $5,000 in data entry effort. Individually
responsible for data integrity.
Tools:
unix, NT, Windows, Oracle, OracleForms, SQL, SQL*Plus, PL/SQL,
ksh, perl, sed, awk, grep, regular expressions, PeopleSoft HR,
PeopleTools, Transcentive/CMS Express Options for Windows,
MS Access, MS Excel, MS Project, MS Word, MS PowerPoint,
MS Visio, PC:AnyWhere, C, C++, Java.
Nov 1997 - Feb 2000
IT Consultant, Cupertino, CA
Consolidated regional and global financial data to create
decision-support systems and reporting systems.
Cut two full days from HP Consulting s monthly financial close cycle
by creating a consolidated global financial reporting system with
regional data capture. The system greatly enhanced the level of
detail available in global financial reports by allowing analysts
and controller to drill-down from global summaries into detailed
regional data.
Closed the global financial books on time every month during phased
development of a replacement financial reporting system, while
providing 24 x 7 support of regional financial close activities.
Tools:
unix, NT, Windows, ksh, perl, ftp, grep, sed, regular
expressions, Oracle, SQL, SQL*Plus, PL/SQL, Hyperion Essbase,
Excel Add-In, Wired-for-OLAP, Constellar, MS Project,
MS Office, MS Excel, MS Word.
Feb 1994 - Nov 1997
IT Solutions Specialist, Palo Alto, CA
Developed financial reporting systems associated with global
company-wide general ledger systems.
Reduced HP s monthly financial close cycle by one full day across
the entire company, by replacing the world-wide general ledger
application. Completed replacement general ledger application
on-time and on-budget in multi-functional, geographically dispersed
implementation team.
Managed migration of general ledger data, reports, interfaces,
maintenance procedures and fiscal year-end procedures. Facilitated
on-time generation of financial statements and tax returns from new
system, while ensuring perfect data integrity with historic system.
Met or exceeded all legal and regulatory compliance requirements,
including IRS and SEC. Saved HP $300k/year by gracefully
decommissioning old general ledger system after migration.
Managed creation of a source code version control library for HP s
Corporate Financial Reporting department. Individually recognized
need, championed the idea, gained management approval, researched
tools, selected rcs, implemented library, added source code, and
trained other developers on check-out and check-in procedures.
The team had experienced a two-week delay due to version control
issues; this project eliminated subsequent delays.
Tools:
unix, MPE, DOS, Windows, NT, ksh, perl, rcs, Informix, Ingres,
SQL, Arbor Essbase, MS Office, C, C++.
Jul 1988 - Feb 1994
Senior Programmer Analyst, Palo Alto, CA
Developed administrative applications to manage all of HP s global
data and voice networks.
Realized a dramatic improvement in HP s internal network
management by creating more effective network traffic reports.
Invented and tested network congestion hypotheses together with
network engineers, determined key statistics, and designed a
system to pre-calculate and store those key statistics, which
led to a 90% reduction in the time required to produce network
traffic reports.
Created administration system for HP s employee calling cards.
Reduced department s intra-corporate billing transactions by 25%
and reduced administration effort by 50%, allowing redeployment
of two full-time positions.
Saved $40k/year by designing and implementing a batch job
monitoring system, which notified support engineers when batch
jobs had runtime errors and reduced the investigation required
when jobs failed.
Tools:
unix, MPE, DOS, Windows, bat, HP TurboImage, HP AllBase, SQL,
MS Office, Cognos, C, Pascal, Fortran.
EDUCATION:,
Systems Option and Math Minor.
GPA 3.45
Top 10% of class
(International honor society for the computing sciences)
PROFESSIONAL DEVELOPMENT::
Gold Partner, PerformancePoint Server 2007,
DeltaForce Ranger: SQL Server 2008 & BI
:
Individually Certivied Applix TM1 Partner, TM1 9.0 Development
:
dynaSight Development
:
Essbase 7.1.2 Foundation,
Essbase Development, System Administration
:
SQL, PL/SQL, Forms, Program Units, Database Administration
:
HR Module Development, PeopleTools
Richard Irwin:
Information Warehouse Best Practices,
Data Analysis Workshop
:
Business Process Analysis,
Computer Systems Design
:
Creating a Customerarchy
:
Java Programming
:
Financial Accounting
:
HP "Ace" Project Management
RELEVANT VOLUNTEER EXPERIENCE:
Consulted on architecture and data model, ran code walkthroughs,
created test plans, and performed test cases on a networked
client-server application that allowed a world-wide church
conference to carry 20,000 petitions through their legislative
process. Caught several significant issues early enough in the
design effort to allow rapid corrections. Enabled on-time delivery.
(see www.jbrawn.com/petsinfo.htm)
Prevented annual increases in dues for four consecutive years by
implementing a comprehensive investment strategy for the
reserves fund of my homeowner s association. By following the
asset allocation guidelines in my strategy, the board of
directors reduced the time spent on individual investment
decisions by 75%.
If you arrived directly at this page by using a search engine, you
are welcome to click on
Robert.Brawn.name/BSA/
for links to some additional information.
Contact this candidate