CAREER OBJECTIVE: A challenging opportunity where my experiences in database design and management, data analysis, reporting, and internet data availability would be a significant contribution.

SKILL SET:

Languages:

Oracle 9i, 10g, 11g, PL/SQL, SQL PLUS , MS SQL T-SQL , MySQL, XML 1.0, Analysis Services MDX, ASP.NET version 2005 with Visual Basic.NET, Reporting Services Expressions

Operating System:

DOS, Windows 9X, Windows NT, 2000, XP Pro, Ubuntu 9.0

Software:

Microsoft SQL Server 2000, 2005 and 2008R2 , Analysis Services 2005 and 2008 SSAS , Reporting Services SSRS 2000, 2005 and 2008 , SharePoint 2010, ProClarity, Active Directory, Microsoft Office Word, PowerPoint, Access, Excel, Visio , Visual Studio 2000, 2003, 2005, 2008 and 2010 , Microsoft Visual SourceSafe, Embarcadero ER Studio 8, XML Spy

Hardware:

IBM Compatibles, All Pentium PCs.

EXPERIENCE:

Confidential

Database Designer

• Consulted clients on proper implementation and architecture of Business Intelligence analytics and reporting systems.
• Created interim reporting system to supply immediate reporting need by usage of linked servers between SQL Server 2008 64bit Edition and Oracle 11g
• Created Analytics Services server utilizing ProClarity and SharePoint
• Architected data models for analytics cubes
• Automated reports to support subscriptions through Reporting Services
• Authored stored procedures and custom functions to support online reporting and data handling
• ETL and scripting for migration of data between various sources including Excel, CSV, XML and Oracle 11g databases

Confidential

• Upgraded legacy FoxPro reporting to Microsoft SQL Server 2008 and Reporting Services2008
• Report authoring using Visual Studio 2008 utilizing Reporting Services, T-SQL and web services
• Legacy report conversion from Crystal Reports to Reporting Services 2008
• Report query conversion from FoxPro to T-SQL
• Implementation and administration of Reporting Services website
• Created Subscriptions for automated reports
• Established user profiles for external AD account access to reports
• Published reports
• Documentation of legacy systems to assist in company wide upgrade of reporting system and websites.

Confidential

• Business Intelligence/Reporting Programmer Specializing in Microsoft SQL Server 2005, Reporting Services and Analysis Services.
• Migrated and updated reports from company in house custom reporting layer and SQL Server 2000 to the newer SQL Server 2005 platform.
• Report authoring using Visual Studio 2005 utilizing Reporting Services, Analysis Services, T-SQL and MDX.
• Data Modeler using ER Studio 8, XML Spy 2009 and SQL Server 2005 to translate XML/XSD files into an enterprise IDS database.

Confidential

• Business Intelligence/Reporting Programmer Specializing in Microsoft SQL Server 2000, 2005 and Reporting Services.
• Extensive database mapping to facilitate database merger.
• Authored Business Intelligence Reports in SQL Reporting Services 2000 and 2005 .
• Authored technical and practical documentation platform using SQL Reporting Services 2005
• Database Architect for proprietary credit card processing software
• Database programmer using T-SQL, DTS, stored procedures, functions and SQL scripts

Confidential

• Database Programmer in charge of migrating existing Informix 4gl based reporting platform to Microsoft SQL Server 2000 using multiple ETL processes.
• Authored various ETL processes to validate and clean data from Informix, MySQL, Oracle and Microsoft Access.
• Upgraded SQL Server 2000 to SQL Server 2005
• Reengineered reporting database to optimize efficiency and query speed to support web based reporting across hotel enterprise.
• Data Analyst in charge of analyzing raw data, rewriting reports resident on Informix 4gl reporting platform and authoring new reports publishable to the company intranet.
• Authored over 40 Business Intelligence reports made available on new company reporting website website included in SQL Server/Reporting Services . Such reports included automating static Informix 4gl reports, manually created Excel financial reports and custom billing reports featuring charts, graphs and trend curve illustrations.
• Administered rights and security for Reporting Manager website to ensure proper exposure of information to employees and business units.
• Developed reporting directory structure for online reports using Reporting Manager.

Confidential

• National Insurance Sales Agent specializing in Property Casualty and Life, Health, and Annuities.
• Assisted a team for proof of concept of a national insurance agency.
• Increased monthly sales by more than 100 percent from 2003 to 2004.

Confidential

• National Life Insurance Sales Agent specializing in life insurance sales.
• Worked with a team who provided life insurance consultation for Bank of America customers.

Confidential

• Sales and Customer Service of auto insurance products provided by American Horizon Auto Insurance Company.
• Promoted to Team Lead in September 1999.
• Responsible for training, coaching, and general management of a team of insurance agents.
• Responsible for providing statistical reports of insurance call center to upper management.