Tanya A.Swanagin

614-***-****

Summary:

SR. Business Analyst with seven years of extensive experience in administration and

Business Systems Analyst. Extensive experience of performing role of Business Systems

Analyst. Product knowledge spans installation and, configuration, design development and

project management. This includes implementing and supporting BDW data warehouse,

maintaining and overseeing multiple related projects directed toward strategic business and

organizational objectives. This also 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. Related areas

of expertise are:

1. Business Intelligence XI/R2/3.1 SP2

2. Business Objects 3.0

3. Hyperion Reporting

4. PL/SQL

5. Data Quality

6. Webi, Infoview

7. Business Intelligence Security

8. Strong Knowledge of project management methodology.

9. Define and initiate projects, and assign resources to manage cost, schedules and

budgets.

10. Strong Knowledge Of SDLC

11. Very strong experience with working with Business leaders.

12. Demonstrated experience inn documenting requirements.

13. Analyzes business problems to identify automated solutions

14. Advanced skills with requirements gathering and delivering final product to Business

users.

15. Advanced Experience with creating use cases.

16. Demonstrated experience in facilitating JAD sessions.

17. Advanced skills with preparing budgets, preparing presentation and extensive use of

MS project.

18. Extensive experience with handling multiple complicated BI projects.

19. Crystal 2008

20. Oracle 9

21. VMware

22. IBM Websphere

23. Perl Shell Scripting

24. SSL deployment

25. Microsoft Server Products

Citi, Columbus, Oh (April 2011-Present),

Sr. Business Systems Analyst/Engineer

• Act as business expert for the team. Review requirements with the business and

author functional requirements documentation.

• Participated in data analysis and profiling.

• Verify functional and data integrity of the application.

• Analyzes business problems to identify automated solutions.

• Document functional and system requirements for a new web-based reporting

system.

• Create activity diagrams and system process flows.

• Document change requests and assist with disposition of change items.

• Trace functional requirements through traceability requirements.

• Perform functional and system testing.

• Establish and Support User Acceptance Testing.

• Analyzing requirements and design documents to create test plans, test cases, and

test scripts.

• Trouble-shooting and documenting defects in a defect tracking tool (HP Quality

Center)

• Manage changes to scope effectively and impact on overall project plans.

• Lead and participate in peer reviews to ensure excellence.

• Managed issues list and meeting minutes to ensure transparency and consistency.

• Provide input to the business on guidelines and processes.

• Create process flow diagrams, and data mapping documents.

• Oversee use of design tools to create mock screens and prototypes.

• Drive use of advanced analytic capabilities.

• Managed budget an project management activities.

Scotts Miracle Grow Company, Maryville, Oh (Dec 2010-April 2011)

Sr. Business Intelligence Systems Analyst/Engineer

• This project mainly focused on Migrating from Business Objects XIR2 environment

to Business Objects XI R3.

• Worked with the IT business users to implement SAP single sign on for Business

Objects applications.

• Prepared and documented technical requirements for architecture structure, reports

and universe standards.

• Worked with IT and business users to resolve issues related to Business Objects,

Crystal and Webi reporting.

• Trained user in scheduling crystal reports.

• Setup 350 reports in XIR3 and 120 users.

Cardinal Health (EIT Installation). Dublin, Oh. (2009- Nov 2010)

Sr.Business Intelligence Systems Analyst/Engineer

• Worked with IT and business users to resolve issues related to Business Objects

Environment.

• Performed the role of Business Analyst during migration process to communicate

the needs of the business and create solution within the IT environment.

• Gathered business and user requirements for report development within Business

Objects.

• Created Business Objects Webi and Crystal reports based on user specifications.

• Served as mediator and provided bridge between the business users and the

technical team.

• Assisted in Integration and Acceptance testing of newly created Crystal and Webi

reports.

• Provided post implementation support.

• Created documentation of the systems that were created.

• 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-2009)

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.

• Performed the role of Business Analyst during migration process to communicate

the needs of the business and create solution within the IT environment.

• Assisted in Integration and Acceptance testing of newly created Crystal and Webi

reports.

• Provided post implementation support.

• Created documentation of the systems that were created.

• Created over 150 reports from Crystal and Hyperion to Webi reports based on user

requirements.

• 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.

• Implemented SSL security for Business objects 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

Contact this candidate