We provide IT Staff Augmentation Services!

Database Designer Resume Profile

PA

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.

Hire Now