SUMMARY
Highly motivated Business Intelligence Professional using SQL Server 2008 and Microsoft Technologies. Demonstrated leadership abilities andteam work skills as well as the ability toaccomplish tasks under minimal direction and supervision. Proven ability to learn and apply new technologies and tools for new business environments and meeting project deadlines and deliverables.

CERTIFICATIONS
07/10 Business Intellegence Masters Program
05/09 Microsoft Software Specialist Certification
10/07 Medical and Insurance Billing Certification, Martinez, CA. AAPC
CSU Fullerton, CA. APICS Certification (CPIM)

TECHNICAL SKILLS
Microsoft Technologies:
SQL Server 2008 Integration Services (SSIS), SQL Server 2008 Analysis Services (SSAS), SQL Server 2008 Reporting Services (SSRS),SQL Server 2008 Management Studio (SSMS), Microsoft Office SharePoint Server 2007, Microsoft Performance Point Server, Microsoft Visio, Excel Services

Databases:
MS SQL Server 2008/Express/2005, Oracle

Software:
SQL Server Business Intelligence Development Studio, BEA Weblogic 8.1

Query Languages:
T-SQL, MDX

PROFESSIONAL EXPERIENCE

Confidential, TX 12/06 present
Consultant/Project Team Member/BA/PA

Various web projects, computer hardware and software maintenance, operating system software installations network setups, Access, Excel, PowerPoint, Accounting, Tax Preparation. User training and documentation, SQL Express, UNIX.

JR DBA/Help Desk Remote administrator support with BOMGAR, Filezilla, VNC on SQL Express. SQL Server 2008, FTPs, run update scripts, stored procedures and check the status of all system clients, file cleanups and terminal restarts.

Implemented model for a restaurant: Loaded software on their computer system for usage with security, accounting utilizing an access database with reporting capabilities for customer contacts and keeping track of sales and auditing purposes, made the company webpage, initiated the contacts info for the social networking sites. PowerPoint projects, Excel spreadsheets, Mail merge for customer mailings and viewing recipes with Word and Adobe software. Storage for company logos and menus in various file types.

Confidential, McKinney, TX
Business Intelligence Master's Program (36 weeks) 01/2010 - 07/2010

The SetFocus Business Intelligence Master's Program is an intensive, hands - on, project oriented program where participants add knowledge of and valuable experience putting the Business Intelligence skill set to use in a simulated work environment.

• Implemented a Labor Analysis Business Intelligence solution for a national construction company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• Created score cards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites.The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
• Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions. Possess solid knowledge of writing, tuning and optimizing T-SQL queries.

Confidential, Lake Katrine, NY 7/05 - 11/06

Project Manager/Project Team Member/BA/PA

• Performed analysis and requirement gathering to establish the objectives for project task definition and scheduling.(Tracer project mgmt tool).
• Analyzed existing system software to provide support, new development and maintenance programming for critical information about key processes and output.
• Identified and initiated opportunities for new job process improvements.
• Utilized system software to track PMS (Preventative Maintenance).
• Performed data migration and integration.
• Coordinated report and job testing and validation efforts to ensure changes will integrate effectively into the overall system processes.
• Make sure that claims all are adjudicated and all checks clear the system
• Documentation of business requirements for new reporting initiatives
• Preparation and implementation of system migration and software updates.
• Maintained primary support interface for communications and commitments with manager, users, clients and outside technical providers.
• Reviewed and analyzed the effectiveness and efficiency of existing systems and developed strategies for improving or further leveraging the current systems.
• Supported Claims, Membership, EDI (PPO feed/CACTUS) and Finance Departments.
• Provided documentation and training for users and system operators for all projects
• AMISYS 11.01, COBOL, Powerhouse, Suprtool. HP3000, SQL Server, IBM.

Confidential, Wilmington, DE 3/04 - 9/04
Project Manager/PA

• Prepared post migration Sales Report (HP3000 to HP9000 Oracle 11 & 11.i).
• Completed software performance analysis of QUIZ and QTP with SuprTool.
• Performed impromptu Cube build, analysis and reporting.
• Generated Excel/Powerplay reports.
• Coordinated report testing and validation to ensure changes will integrate effectively into the overall business process.
• Reviewed and analyzed the effectiveness and efficiency of existing system software to develop strategies for system software improvements.
• Completed user training and documentation.

Confidential

Pontiac, MI 10/02 -06/03 Project Team Member/PA

• Documented all system procedures and processes with VISIO.
• Coordinated project and support for the pre existing Year End team of direct employees utilizing MS Project.
• Support of all Hospital interfaces, Medical Records, Scheduling and Horizon Lab.
• Managed the Intranet website development project and maintenance, application migration, design and support utilizing Dreamweaver MX, Blue Harpoon, HTML and .ASP.
• Revamped and completed intranet project with HP3000 and SQL2000 databases, a new Access Database, Scheduling Reports, and security.
• Performed NT 4.0/SQL 2000/HP3000 security and administration.
• Maintained McKesson ALT 10 programming and new development.
• Utilized TrackIT software to log ongoing and completed support issues.
• COGNOS, COBOL and SuprTool

EDUCATION

Bachelors of Science, Major Botany, Minor Quantitative Systems