ALLENE L. WIESE
SKILLS
APPLICATIONS TECHNICAL BUSINESS
Business Objects SQL Report Development
6.5/XIR2
Microsoft SSRS SQL Server 2005/2008 Customer Support
Crystal Reports Oracle 9/10/11 Data Analysis
8.5/9/XIR2
WebFocus TOAD Project Management
Tableau T-SQL Technical Specifications
Microsoft Office MDX Quality Assurance
SUMMARY
o Experience and technical proficiency in the data analysis teamed with
business analysis, Report Development, Quality Testing and
Documentation.
o Experience in data integration using Business Objects Universe using
Designer, CMC Repository Manager, and Supervisor.
o Requirement gathering with the business users and business analysts
o Production support working directly with business users and other IT
teams
o Extensive Functional and Technical Lead experience in Report
Development using Business Objects Desktop Intelligence, Web
Intelligence, Crystal Reports, Business Views, Meta Data modeling
using Toad and Business Objects Designer, Dash boards, Metrics, Ad-hoc
and advanced Reports Generation.
o Well versed in analysis, design and development and implementation of
various applications writing SQL stored procedures.
o Databases: DB2/Informix, Oracle 9/9i, Oracle 10g, SQL Server
2000/2005/2008
o Tools: TOAD, Query Analyzer, PL/SQL
o Demonstrated experience in New Development, Enhancements of existing
applications, Conversions/Migrations, Debugging, Troubleshooting data
errors, Bug fixing and resolution of help desk tickets.
EXPERIENCE
Report Developer/Consultant, Robert Half Technology -Nashville, TN
June 2010-June 2010
o Developed report applications using T-SQL 2005 and Crystal XI for The
Little Clinic, a rapid-growth contender in the convenient health care
services industry
o Gathering requirements and translating to technical specifications
Client Technology/Consultant, Asurion/IDR -Nashville, TN
October 2009-December 2009
o Gathering requirements and translating to technical specifications
including mockups for documentation.
o Designed, specifications, and managed implementation, and maintenance
of automated systems
o Interpreting business requirements impacts to the data and translates
those to functional requirements for multiple departments
o Designing and building data aggregations, stored procedures, views,
and functions for ongoing data analysis and reporting as well as
utilizing data analysis techniques and queries to provide ad-hoc
reports, analysis, and datasets based on business needs.
o Troubleshooting data issues, validate result sets, and recommending
and implementing process improvements.
o Communicating with business/end users to understand business rules and
interpret data.
o Maintaining an ongoing knowledge of both the technical data model and
the business' strategic needs.
Business Intelligence Analyst, Simplex Healthcare -Brentwood, TN
June 2009-October 2009
o Responsible data management, data quality and data reporting and
testing using SQL Server 2005/2008 and Reporting Services through
writing advanced T-SQL queries, stored procedures and views and
functions.
o Analyzes, designs and implemented stored procedures that included
queries for financial reporting for Healthcare/Revenue departments
o Managing day-to-day task/priorities using TFS/SCRUM Methodology.
o Designed, specifications, and managed implementation, and maintenance
of automated systems
o Interpreting business requirements impacts to the data and translates
those to functional requirements for multiple departments
o Designing and building data aggregations, stored procedures, views,
and functions for ongoing data analysis and reporting as well as
utilizing data analysis techniques and queries to provide ad-hoc
reports, analysis, and datasets based on business needs.
o Troubleshooting data issues, validate result sets, and recommending
and implementing process improvements.
o Communicating with business/end users to understand business rules and
interpret data.
o Maintaining an ongoing knowledge of both the technical data model and
the business' strategic needs.
o Gathering requirements and translating to technical specifications
including mockups for documentation.
o Developing in-house expertise on key business operating metrics and
producing dashboard metrics that include SLA requirements.
Systems Developer, Fresenius Medical Care North America -Nashville, TN
August 2006 - June 2009
o Development of data management reporting, deploying user security,
data analysis, serving as a subject matter expert on legacy based
reporting, as well as creating reports from specifications using
Business Objects 6.5/XIR2 and Crystal Reports XI in a SDLC
environment.
o Documentation included revising manuals, design of forms and computer
output, and documenting user procedures.
o Recommending Process Improvement through data management and reporting
o Providing project management through gathering user requirements as
well as creating functional and technical specifications documents as
well as business process documents using Microsoft Office including
Microsoft Project and Visio and Excel.
o Served as key point of contact for report and query related
information
o Scheduled data files for FTP transfer to external customers
o Providing training to team members on best practices regarding
Business Objects Web Intelligence, and Crystal Reports XI
o Extensive data analysis utilizing TOAD/Oracle PL/SQL and Microsoft
Excel
o Providing support to business users through resolution of production
issues using Remedy
Reports & Compliance Analyst, PassAlong Networks - Franklin, TN
December 2005 - August 2006
o Responsible for development of online reporting environment as well as
custom/on-demand reports using Information Builders WebFocus software
which included building procedures, formatting reports, creating HTML
pages, building and deploying report portal and managing user id and
passwords
o Gathering user/business requirements and creating specification documents
o Managed and documented data migration and conversion projects from SQL
Server Reports to Information Builders WebFocus environment
Crystal Application Developer, Comdata Corporation - Brentwood, TN
September 2003 - December 2005
o Responsible for data analysis including data mapping, development of
online as well as custom/adhoc reports using Crystal Reports 8.5 and
Business Objects 6.5 as well as implementation of stored procedures in a
SQL Server and DB2 in a main frame environment
o Providing user support through resolution of production issues
o Gathering of user and system requirements for creating functional
specification design documents
Technical Consultant, Contractor - Nashville, TN
December 2002 - September 2003
Responsible for design and implementation of custom reports and data
analysis using Crystal Reports 9 and Cognos Impromptu for various
clients.
Provided quality assurance through analysis and evaluation of business
systems as well as functional specification documents and process
improvement projects.
Gathering user needs for development of Crystal Reports
Supported operational needs through online reporting
Project management using Microsoft Project
Technical Specialist, AutoZone, Inc. - Memphis, TN
February 2000 - November 2002
o Provided data analysis through daily development of reports and metrics
utilizing Microsoft Excel, Access and VBA, SQL, OLAP, Crystal Reports and
Cognos Impromptu
o Measured asset and production information for senior management,
information technology, and retail operations
o Authored, published, and updated web-based online solutions.
o Automated scripts through VBA that improved report production 75%
EDUCATION & PROFESSIONAL DEVELOPMENT
Current- Member, Midsouth Business Objects User Group
2007-Business Objects XIR2Web Intelligence Training
1994-Associates Degree, P.T.C. Career Institute
References available upon request