Tanya A.Swanagin
Pataskala, Oh 43062
Summary:
SR. Business Intelligence Administrator with seven years of extensive
experience in administration of Business Intelligence environment.
Product knowledge spans installation and, configuration, design
development. This includes testing, migration, and implementation using
Business Objects 5.x/6.x/XI R2/R3. I have been responsible for
installation, upgrades maintenance, troubleshooting, clustering,
technical support, optimization, auditing and administrating the complete
suite of SAP Business Objects tools in shared environment, including
Crystal Reports 2008, Web Intelligence, Desktop Intelligence, Universe
Designer and Live Office on various platforms like Linux and Windows
environments. I also have extensive knowledge of Microsoft Active
Directory and Windows 2000/2003, and computer services. Related areas of
expertise are:
. Business Intelligence XI/R2/3.1 SP2
. Business Intelligence XI 3.1 Administering Servers- Windows
. Business Intelligence XI 3.1 Administering Servers- Linux/Unix
. Business Intelligence XI 3.1 Advanced Universe Design
. Dashboards
. Data Quality
. Webi, Infoview
. Business Intelligence Security
. Strong Knowledge of project management methodology.
. Strong Knowledge Of SDLC
. Very strong experience with working with Business leaders.
. Able to develop strong working relation with Business Executives.
. Advanced skills with preparing budgets, preparing presentation and
extensive use of MS project.
. Extensive experience with handling multiple complicated BI projects.
. Crystal 2008
. PL/SQL
. Oracle 9
. Balanced Insight Consensus 4.3.2
. VMware
. IBM Websphere
. Microsoft Server Products
. Microsoft Operations Manager 2005
. Live Communication Server 2005
. Exchange Administrator 2000/2003
Cardinal Health (EIT Installation). Dublin, Oh. (2009-Present)
Sr.Business Intelligence Systems Engineer
. This Project mainly focused on Installing Busines Objects XI R3 sp2
on Windows and Linux servers.
. Implemented Single sign on using Kerberos Windows AD Authentication
for Business Objects applications.
. Prepared and documented technical requirements for reports,
universe standards an dashboards.
. Worked with IT and business users to resolve issues related to
Business Objects Environment.
. Trained the users in viewing/scheduling the reports using infoview.
. Working with database connections, SQL joins, cardinalities, loops,
aliases, views, aggregate conditions, parsing of objects and
hierarchies
. Developed and implemented Universes by defining joins, cardinality
between tables, creating prompts and queries, applying contexts and
alias tables to remove cyclic dependencies using Business objects
Designer
. Worked on setting up predefined conditions, Cascading LOV's,
Hierarchy's in the universe
. Involved in the creation of Materialized Views and created indices on
look up tables and fact tables for improving query performance
. Designed and Implemented row level security and Column level
security(restricting data) on the universe for different user groups
based on Entitlements
. Exposed various Oracle functions to Business Objects in Universe using
designer and used them in Reporting
NetJets, Inc. Columbus, Oh. (2004-Present)
Business Intelligence Systems Analyst
. Excellent knowledge in Business Objects 5.x/6.x/XI/R2/R3 and
SP2.(Supervisor/CMC, Designer, CMS,CCM,Web Intelligence, Import
Wizard Tool, Report Conversion, Performance Management, Live
Office, Crystal Reports 2008 and Xcelcius.
. Successfully converted Hyperion Reporting environment to Business
Intelligence 3.1 SP2. Extensively involved in performance tuning by
determining various bottlenecks at various points like database
querying, report level, universe level and BO SQL Queries.
. Successfully created and maintained several Universes for new Data
warehouse environment.
. Used the Import wizard extensively to import existing user accounts,
groups, categories, Webi documents, universes, connections and
universe restrictions to migrate from Business Objects R2 to R3.
. Successfully gathered business requirements, process definition and
design the business process modeling for several BI projects.
. Successfully interpreted the business rules and requirements for the
technical systems to be implemented into Business Intelligence.
. Performed the role as liaison between the business side of and the
IT sector.
. Team lead for complex data warehousing and data management team
. Successfully created, installed, and configured, development, QA and
production environments with Business Intelligence 3.1.
. Successfully designed, installed, configured Balanced Insight's
Consensus 4.3.3.2 environment which provided an efficient process in
the Business Intelligence Lifecycle.
. Created over 50 reports from Crystal and Hyperion to Webi reports.
. Developed reports, sub reports using Dynamic prompts using Crystal
2008.
. Developed various universes and reports using business objects.
. Efficiently managed the offshore team and offshore deliverables.
. As part of offshore co-ordination, made sure that offshore team has
clear and concise functional specifications. Managed development
process including standards, templates, review procedure and
proactive issue resolution.
. Conducted status review meetings with offshore team to resolve any
issues delivering the code within deadlines.
. Designed, documented and implemented Disaster Recovery Procedures
for the Business Objects Production Environment.
. Responsible for File Server Hardware and Operating System Software
Maintenance. Patch/Fix Research and Recommendations.
. Established Server-based standards, Guidelines and Policies.
Provides research and recommendation on new technologies.
. Installed, migrated and configured the migration of 250 servers
from. Physical hardware to VMWare.
. Design, installation and maintenance of Microsoft Operations
Manager 2005 for 350 Servers.
. Installed and Configured Live Communications Server 2005 for 6000
users. Provides maintenance to WebLogic and Websphere server
applications.
. Provides 3rd level support for in-house applications.
Ohio Senate, Columbus,Oh.
Sr. Network Administrator (2001 to 2004)
. Manages network design and imposes security policies.
. Implements and maintains network security via servers and
firewalls.
. Oversees helpdesk and network administration operations.
. Project manager for Senate IT projects.
. Prepares IT budget.
. Documents network infrastructure.
. Configures and supports remote access.
. Manages seven servers and 250 desktop computers and laptops.
. Designs and maintains disaster recovery plan.
. Responsible for patch management of all servers and desktops.
Network Administrator, Ohio Tuition Trust (1999 to 2001)
. Installed, configured, and supported network servers and related
peripheral devices.
. Provided microcomputer support.
. Developed help desk.
. Successfully migrated organization from Novell to Windows
operating system.
. Prepared IT budget.
. Designed disaster recovery plan.
Network Administrator, Limited Technology Services, (1998 to 1999)
. Administered file backups.
. Ensured data security and integrity.
. Performed server and desktop troubleshooting.
Information Technology Services, United States Navy (1986 to 1998)
. Designed, implemented, and supervised the operation of a worldwide
LAN/WAN.
. Successfully built network infrastructure system for various duty
stations. Provided microcomputer support.
.
Education:
. Business Objects Universe Design 3.1
. Business Objects Universe Advanced Design 3.1
. Business Objects We Intelligence 3.0 Report Design
. Business Objects Web Intelligence 3.0 Advanced Report Design.
. Business Objects Enterprise 3.0 Admin, Users & Content
. Completed VMware training.
Completed numerous training classes and seminars in order to stay current
with technology