Sql Server Data
Resume:
Don Denton
Dallas, TX *****
********@*****.***
EDUCATION:
Texas Christian University - Fort Worth, TX
• Master of Business Administration, May 1993
• Concentration: Finance
Texas Christian University - Fort Worth, TX
• Bachelor of Science, May 1991
• Major: Economics
EMPLOYMENT HISTORY:
Enterprise Spectrum – Irving, TX 2008 - Present
Senior Manager, Decision Support
• Work with client to develop reporting requirements for new reporting and analytic needs.
• Design and develop reports for adhoc reporting and analysis.
• Develop MDX and SQL queries for adhoc report requests.
• Manage and produce reporting/analytics package weekly for client.
• Manage and produce discussion guide for weekly calls with client.
• Monitor and maintain reporting servers and portal to ensure reliable performance and user
access.
• Work with client and Database administrators to ensure accurate load of data feed.
• Work with client to ensure accurate data load into the campaign planning website.
• Create project plans and manage tasks for projects and team members.
Broadlane – Dallas, TX 2007 - 2008
Senior BI Developer/Administrator
• Provided end user support on all Cognos tools including tuning, and troubleshooting.
• Monitored and maintained Cognos servers to ensure reliable performance and user access.
• Designed, developed, and tested OLAP models using Cognos 8 Analysis Studio,
Transformer, Cognos PowerPlay/PowerPlay Web and SQL Server Analysis Services.
• Developed and maintained Cognos 8 reports used for adhoc reporting and analysis.
• Upgraded software from Cognos ReportNet to Cognos 8.3.
• Worked with data from: SQL Server.
• Performed Cognos training for internal employees.
• Worked with end users to develop requirements documents for new reporting needs.
Selkirk LLC - Richardson, TX 2004 - 2007
Senior BI Developer/Administrator
• Provided end user support on all Cognos tools including tuning, and troubleshooting.
• Designed, developed, and tested OLAP models using Cognos Transformer, and Cognos
PowerPlay/PowerPlay Web.
• Developed and maintained Cognos Impromptu reports used for adhoc reporting and
analysis for the Sales and Marketing areas.
• Developed macros to run nightly, and monthly Impromptu sales reports.
• Upgraded all Cognos software from version 6.x to Series 7.
• Performed maintenance and upgrades on PowerPlay Enterprise server and ReportNet
portal.
• Responsible for daily ETL (DecisionStream) processes and SQL Server administration.
• Worked with data from: DB2 and SQL Server.
• Performed Cognos Impromptu training for internal Selkirk employees.
• Worked with end users to develop requirements for new reporting needs.
Southwest Airlines - Dallas, TX 2000 - 2003
Systems Analyst III/OLAP Engineer
• Designed, developed, and tested OLAP models using Cognos Transformer, and Cognos
PowerPlay/PowerPlay Web and Hyperion Essbase.
• Provided end user support on all Cognos tools including tuning, and troubleshooting.
• Developed and maintained Cognos Impromptu reports used for adhoc reporting and
analysis for the Finance Department.
• Developed and maintained Cognos Impromptu catalogs for users.
• Maintained Cognos Impromptu macros for reporting of revenue and traffic data.
• Upgraded report macros from Impromptu 5.0 to Impromptu 6.0.
• Worked with data from: Oracle, Sybase, Teradata, and SQL Server.
• Performed data modeling and relational data design using ERWIN.
• Implemented Executive Information System used to deliver high-level view of Capital
project spending to management.
• Developed OLAP model used to distribute AP data to Budget managers.
• Developed strategic direction and standards for OLAP reporting groups.
• Performed Cognos Impromptu training for internal SWA employees.
The Kinetic Group (Trammell Crow Co. and Wyndham Intl. I.T. provider) - Dallas, TX1999 - 2000
DSS Developer/Data Analyst
• Developed OLAP business models and reports using Cognos Transformer and PowerPlay
Web for the Trammell Crow Property Management Data Warehouse and Wyndham
International Guest History and WynMiles programs.
• Converted and loaded Excel spreadsheet data to Oracle and SQL Server.
• Maintained Cognos Impromptu reports used for adhoc reporting and analysis.
• Developed Cognos Impromptu catalogs for users.
• Assisted users in conversion of existing reports to Cognos Impromptu.
• Monitored and maintained web and reporting servers to ensure reliable performance and
user access.
• Worked on Wyndham International conversion to SAP R/3.
• Worked with Wyndham Finance Group to develop OLAP business models using SAP
Business Information Warehouse.
Amresco, Inc. - Dallas, TX 1998 - 1999
Senior Business Analyst/DSS Developer, Data Warehouse Group
• Developed OLAP business models and reports using PowerPlay to analyze budgets and
cash flow for Asset Management group.
• Maintained Impromptu reports used for adhoc reporting and analysis.
• Developed catalogs for users.
• Worked on project team to develop data warehouse for residential mortgage division.
• Modeled business processes and developed entities and attributes using Designer 2000.
• Worked on conversion of legacy loan Securitization system to Oracle.
• Created data mappings and interfaces used in conversion.
• Performed testing to ensure data was converted properly and conversion programs were
written correctly.
• Assisted users in conversion of existing reports to Impromptu.
• Also, assisted in the design and development of new reports for analysis, and adhoc
reporting.
NationsCredit, A NationsBank Company - Dallas, TX 1997 - 1998
Essbase Administrator/Developer, Finance
• Responsible for maintaining an Essbase data warehouse containing various financial data.
• Developed data models and applications in Essbase, and reports utilizing Excel and Visual
Basic.
• Created interfaces to transfer data to Essbase NT server from mainframe.
• Automated daily download of data from AS/400 to Essbase using UNIX and FTP to ensure
timely reporting to management.
• Developed and maintained SAS programs used for analysis, and adhoc reporting.
• Created expense detail reports with SAS for reporting of expenses to consumer branches
and various cost centers.
• Assisted in the development of the company budget and financial plan.
• Developed and prepared daily reports using Essbase and Excel for management, and
district managers.
TECHNICAL SKILLS:
• Cognos 8/ReportNet, Hyperion Essbase, Transformer, PowerPlay, Impromptu, ERWIN, SQL
Server, Crystal Reports, SAS, SQL, Windows 95/98/NT/XP, UNIX, Visual Basic, Bloomberg,
Word, Excel, Access
Training:
• Cognos 8, ReportNet, PowerPlay, Transformer, Impromptu, Hyperion Essbase
(Fundamentals 1997 and Advanced 2000), Crystal Reports, SAS, Epiphany, Data Modeling
and Relational Data Design
Contact this candidate