Sr Business Analyst/ Web Developer

Summary of Qualifications

• Oracle/ SQL DBA & Business Objects Specialist offering 8+ years of progressive IT experience.

• Consistently promoted to positions of greater authority and responsibility.

• Professional Business Intelligence Analyst with excellent analytical skills and a thorough knowledge of Data warehousing tools, Reporting tools and ETL tools

• Substantial knowledge in Business Objects suite.

• Professional Programmer/Analyst with excellent programming skills and a thorough knowledge of relational database design, SQL, stored procedures, utilizing UML and Object-Oriented Programming.

• Extensive formal training that contained excellent hands-on practical instruction combined with over 8 years of real world programming experience using C++, Visual Basic, Oracle, SQL Server, MS Access, and web-based applications utilizing ASP, HTML, JavaScript, and Dreamweaver.

• Substantial experience in analyzing system requirements, data modeling, systems design, testing and implementation, and full-lifecycle development across a wide range of technologies.

• Strong planning skills, and a demonstrated ability to effectively handle multiple tasks simultaneously, set priorities, make decisions, and work independently to achieve organizational objectives.

Programming and Computer Skills

• Extensive relational database experience in analysis, design, and implementation.

• In depth knowledge and understanding of Oracle structures, theories, principles, and practices

Applications Database: Oracle:

• Business Objects XI R2/ R3 • SQL Server 2000/05/08R2 • Oracle 8/8i/9i/10g

• XCelsius 2008 • SQL, T-SQL, PL SQL • Oracle Backup & Recovery

• Data Services/Integrator • ADO, COM, XML • Oracle Developer / Designer

• Crystal Reports XI/ XIR2/2008 • Toad for SQL Serve/Oracle r • Oracle Financial Applications

Education and Certifications

• Computer Information Systems, San Antonio College, TX May 2001

Double Major: Computer Programming and Database Specialist

o Presidential Honors List with a 4.0 Average at San Antonio College; 2000 - 2002

o GPA 3.8 on a 4.0 scale (overall and in computer courses);

o Oracle Certification; May 2001

o Computer Database Specialist Certification; 1999 - 2002

o Computer Programming Specialist Certification. 2000 - 2002

• Baccalaureate in Sciences; La Providence, France 1988 - 1989

• Baccalaureate in Economy; Hattemer, France 1989 – 1990

Professional Development

• @Risk Training 2011

• Tableau Training 2011

• Business Objects /Personify Dashboarding training 2010

• Business Objects - Universe Design 2009

• Data Warehousing 2008

• Oracle Boot Camp 2007

• Oracle Backup and Recovery class 2003

• Raiser's Edge Advanced 2005

• IBM WebSphere Portal STEW 2005

• Merge Efilm (PAX system) Administration Class 2004

• Oracle Workshop I (10g) 2004

• Oracle Backup and Recovery class 2003

Professional Experience

Healthcare Information Management and System Society (HIMSS)

Chicago, Illinois 60611 Feb. 08-Present

As the Business Intelligence Analyst for HIMSS's, I am responsible for creating and refining up to the minute reporting information for senior management as well as creating and utilizing the data warehouse to allow in-depth analytical reporting.

I am also responsible for setting up and administering SAP Business Objects suite (Crystal Reports, XCelsius, BO XI R2, R3, and Edge)

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

• Created and implemented Data Warehouse to integrate all systems of the society (BO enterprise XI R2 /R3and BO Edge XI R3, SSIS).

• Designed Universes for Membership and Financial Billing system.

• Created the ETL workflow to gather the data from the source databases to the Dimensions and facts (Data Integrator)

• Developed the universe with Data Service Designers to allow users to run drag and drop reports and create simple dashboards.

• Built the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

• Used Derived tables to create the universe for best performance, and used context and alias tables to solve the loops in Universe.

• Prepare Dashboards for CEO and CFO / Performance Manager for membership, revenue, rate of return and to allow them to project revenue and membership for the following years.

• Create complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.

• Export the Universes to the Repository to make resources available to the users for ad-hoc report needs.

• Create reports containing all the information regarding the publishers, distributors and retailers using Crystal Reports XI R2 /2008.

• Generate reports using the Universe as the main data provider and personal data files provided by users.

• Develop critical reports like drill down, slice and dice, master/detail for analysis of benefits and revenue.

• Create complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution of news papers to different locations

• Create complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.

• Implement Security Features of Business Objects like row level, object level and report level to make the data secure.

• Provide the security access management by creating users/groups and folders.

• Implement the ETL process and business logic by using TSQL.

• Develop universe user documentation guide for the end users reference.

• Developed very complexes dashboards with Dashboard Manager (Infoview) that utilizes Crystal Reports 2008, Tableau, SSRS, Xcelsius and Excel.

• Developed training manuals and organized classes on how to use Infoview

• Set up security access to the universes

As the SQL Database Administrator for HIMSS, I am responsible for the well being of my databases.

• I developed a backup plans and I test restores once a month.

• Perform database monitoring and tuning as well as capacity planning, manage allocated disk space usage and memory allocations for SQL Server database management systems.

• I developed some maintenance plans that monitors fragmentation, Indexing, and space on a daily basis

• Developed Membership Cost Models with @Risk that allowed the company to increase fees

Environment: Windows Server 2003, SQL Server 2000/2005/2008, SAP Business Objects XI R2 / XI R3 and EDGE, Xcelsius 2008, Data Services/Integrator, Crystal Reports 8.5/9.0/10/XI R2/2008/2011, SSRS2005, SSIS, @Risk, Tableau, TIMSS 6.4.2, Personify

Database Consultant; Healthcare Information Management and System Society (HIMSS)

Chicago, Illinois 60611 May 07-Feb. 08

Contracted to upgrade HIMSS's TIMSS Database Application System and related reports from version 6.1.8b to 6.4.2 and to migrate their MS SQL Server 2000 database to SQL Server 2005. The TIMSS system was comprised of .Net dll's, Crystal reports, desktop application/clients, and an eCommerce website.

• Installed SQL database on IBM blade server technology.

• Modified and tested SQL database/Configured and tested software.

• Customized ad hoc queries/reports and custom fields pushed to upgraded database and then later migrated to Crystal Reports Version 11.

Manager, Database Administration; Cancer Therapy & Research Center

7979 Wurzbach Road San Antonio, TX Apr 06- Feb. 08

Manager with a wide range of responsibilities ranging from maintaining the Oracle and SQL Server databases, supporting Oracle Financial Applications and programming custom desktop and Web applications.

• Worked closely with senior management to determine system requirements, design functionality, and prepare database documentation (schema, data dictionary, table definitions).

• Provided leadership and mentoring to internal and external team members on database architecture, design and management.

• Oversaw complex problems/projects that required an in-depth evaluation of multiple factors.

• Recommended, established, and implemented, Oracle and SQL database policies to ensure the integrity, recoverability, and availability of the Company's data controlled by the Oracle databases.

• Managed IMPAC database:

o Designed and developed custom reports to help users gather data from IMPAC.

o PAC Administrator

• Upgraded our IMPAC application to MOSAIQ

o Took a pervasive 200i database and upgraded it to a SQL server 2000 database

o Ported over 72 + custom crystal reports 8.5 to crystal reports 11

o Developed SLA

• Designed backend database to deliver data to web applications.

• Worked with the application development staff to establish Oracle coding, testing policies, and standards.

• Managed 4D database for laboratory systems

• Raiser’s Edge (Grant management Application) Administrator.

o Upgraded from version 6.0 to 7.7

• Developed a SQL server farm replicated to another site.

• Developed custom application to allow two applications to communicate in VB.net.

• Developed custom application in VB.net to allow users to generate crystal reports from their desktop without having to install the software.

• Upgraded our SQL server 2000 farm to SQL server 2005.

Senior Database Administrator/Project Manager; Cancer Therapy & Research Center

7979 Wurzbach Road, San Antonio, TX May 03-Apr 06

Senior Oracle/SQL Server Database Administrator with a wide range of responsibilities ranging from maintaining the Oracle and SQL Server databases, supporting Oracle Financial Applications to programming custom desktop and Web applications.

Project Manager of an $180,000 Portal Project. In charge of 5 person team: 2 Java programmers, 2 WCM persons, and a software architect.

• Handled customer requests including new database configurations, installations and upgrade requests, database space requests, and database tuning requests.

• Responsible for the Oracle database backups in the enterprise environment and maintained stand-bys for mission critical Oracle databases.

• Performed database monitoring and tuning as well as capacity planning, manage allocated disk space usage and memory allocations for Oracle and SQL Server database management systems.

• Developed and refined standard operating procedures to reduce failures and recovery time.

• Coordinated and implemented changes (to development, testing, and production environments).

• Lead small projects or multiple small projects with medium-sized groups performing similar tasks.

• Designed and developed custom reports using Crystal Reports 8.5/9.0/10 to gather data from the IMPAC database and to interact with the Oracle Financials application.

• Performed major upgrades to the Oracle Database.

o Upgraded main Financial database from 8 to 8i

o Migrated legacy Oracle Database to 10g to help comply with HIPAA regulations

• Performed major upgrade in the Oracle Applications: went from 11.3 to 11.7

o Implementation of purchasing module on top of GL and AP

• Install, maintain, monitor, and optimize databases and applications on a variety of systems that include Oracle Applications 11i, Oracle 10g, and MS SQL Server 2000 database management systems.

• Managed schema changes and implementation,

• Administered Oracle and SQL Server security; performed housekeeping on defunct user accounts and historical data.

• Installed and maintained Oracle and SQL Server database products (patch application and upgrade of the environments).

• Coordinated with Oracle technical support, developed and executed back-up and recovery procedures.

• Performed periodic testing of the database back-up and recovery plan.

• Extensive Backup and Recovery experience

o Set up backup plan that allows minimum data loss as well as minimum down time.

o Test backup’s everyday.

Environment: Windows 2000/XP, Windows Server 2000/2003, UNIX, ASP, Oracle 8/8i, Oracle 10g, Oracle Financial Applications 11i, Access, SQL Server 2000/2005, Crystal Reports 8.5/9.0/10/11, VB6, Dreamweaver, SAN system., IMPAC, MERGE eFilm, ORCHARD, IBM WebSphere, VB.Net, Quest products (Toad for Oracle and Toad for SQL).

Programmer/Developer; Carlson Wagonlit Govt. Travel Div

San Antonio, TX May 01-May 03

In house programmer with a wide range of responsibilities ranging from SQL Server database administration to programming applications in C++, Visual Basic, and the Sabre reservation system.

• Worked closely with senior management to determine system requirements, design functionality, and prepare database documentation (schema, data dictionary, table definitions).

• Designed and coded a SQL Server 2000 database application that would reconcile all US Navy civilian travel invoices. It incorporated mainframe data from Bank of America and the Sabre reservation systems and generated custom reporting using Crystal Reports 8.5

• Designed and coded a SQL Server 2000 database that would keep track of all the contract’s details that the company has with the DOD. It incorporated mainframe data from the branch in Minneapolis, compiled monthly reports and incorporated a feature to be able to send reports via email. Using triggers and procedures in SQL, created alerts that queried the database and notified management when they were required to close certain offices.

• Designed and implemented a travel reconciliation application for the US Army (VB6.0 front-end / Microsoft Access 97 back-end) with custom reporting using Crystal Reports 8.5.

• Created a VB6.0 GUI interface to be used with the Sabre and SDS reservation systems using Sabre specific API commands to parse out Sabre text displays.

• Created forms and reports in with Oracle Forms and Reports, using Oracle 9i for an interactive trip booking application.

• Created a formless VB6.0 application to allow Sabre programmers to append text scripts.

• Relational database analysis/programming against Access and SQL Server databases

• Prepared technical and support document detailing the custom components developed.

Environment: Windows NT/2000, Oracle 8i, MS SQL Server 2000, Crystal Reports 8.5, VB6.

Database Developer; RGS 4x4 Off-Road Centre

Sarajevo, Bosnia and Herzegovina; Dec.98 - May 99

Hired by local Land Rover dealership to design and implement a dual language workshop/inventory management program that would integrate customer information, parts inventory, and labor descriptions with business analysis reporting modules and e-mail ordering capabilities.

• Created a bi-lingual (Serbo/Croat, English) client-server ODBC Access database application with workshop, parts inventory, purchase order, receptionist, and business analysis modules.

• The Purchase Order module allowed automated re-ordering of parts via Outlook email integration.

• Developed a company web site as a Coldfusion data driven web presence using Dreamweaver and JavaScript client-side automation to connect to an Access database and output HTML documents.

• Wrote user manuals, created integrated help system and performed user education.

Environment: Windows 98, Microsoft Access, Microsoft Office Professional, VB 6.0

PERSONAL SKILLS and ACCOMPLISHMENTS

• Foreign Languages

o Fluent (written and spoken): English, French, and Spanish

o Conversational: Serbo/Croat and Russian

• Phi Theta Kappa Academic Honor Society

• San Antonio College Honors List – every semester

• San Antonio College Presidential Honors List with a 4.0 Average – 4 out of 5 semesters

• Represented San Antonio College in two national collegiate programming competitions

(Visual Basic and C++)

• Avid paraglide and horse riding enthusiast.

COMPUTER COURSES COMPLETED

• Unix Operating System I

• Introduction to Object-Oriented Analysis and Design

• Introduction to Database Programming Using Oracle

• Advanced Database Programming using Oracle Developer

• Oracle Database Administration I

• Oracle Database Administration II

• System Design Using Oracle Tools using Oracle Designer

• Oracle Web DB

• Oracle Financial Applications 11i

• Introduction to Computer Programming

• Program Logic and Design

• Introduction to C++ Programming

• Intermediate C++ Programming

• Advanced C++ Programming

• Special Topics in Computer Programming: CORBA

• Beginning Visual Basic 6.0

• Introduction to Visual Basic 6

• Programming with Visual Basic 6

• Intermediate Visual Basic 6.0

• Advanced Visual Basic 6 Programming

• Special Topics in Computer Programming: COM/DCOM

• Special Topics in Computer Programming: VBA

• Special Topics in Computer Programming: Oracle Database Administration (Backup & Recovery)

• Special Topics in Computer Programming: SQL Server 2000 Programming

• Introduction to JavaScript

• HTML 4.0 and WEB Page Design I and II

• Visual Basic.net

• Web programming with Macromedia Dreamweaver.

Contact this candidate