Business Intelligence Contractor Resume

SUMMARY:

Locally based candidate with a strong background in SQL Server
Strong experience with Visual Basic
5 years of development, support, and maintenance in the creation reports using Microsoft SQL Server SSRS applications
Microsoft Development tools including Visual Studio 2008, SQL Server Management Studio (SSMS) and Business Intelligence Development Studio (BIDS)
Proficient in writing SQL queries involved in the creation of Tables, Views, Indexes, Stored Procedures, as well as Triggers and Cursors
Experience in the creation of SSIS packages in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services
Experience in the creation of SQL Server Analytical Service (SSAS) packages used in the creation and modification of Online Analytical Processing (OLAP) solutions used to create Cubes from Data Marts/Data Warehouse for deeper and faster data analysis with hierarchies architecture associated with fact tables and dimension tables
Interact with various partners of the organization from all levels of technical and non - technical abilities to understand and resolve concerns relating to the project requirements
Completed Bachelor’s degree, Microsoft Certificate of Achievement in SSIS, SSAS and SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Contractor

Responsibilities:

Report Writer using SQL Server SSRS to create reports relating to Quality Control Audit requirements.

Confidential

Business Intelligence Contractor

Responsibilities:

Report Writer using MicroStrategy to create reports relating to our Corporate Strategy to support our customer base.

Confidential

Business Intelligence Contractor

Responsibilities:

Report Writer in Oracle Business Intelligence Enterprise Edition 11g (OBIEE) environment including interactive dashboards, ad hoc queries, notification and alerts, enterprise and financial reporting.
Convert Cognos reports to Oracle OBIEE.

Confidential

Information Technology Specialist 3

Responsibilities:

Project Programmer. Developed several Access 2007 databases with Oracle tables.
Created Queries, Forms and Reports within Access using Microsoft Visual Basic, SQL, Macros and Modules.
Created and altered Oracle tables, indexes, sequences, triggers and grants.
Maintained user IDs and created roles.

Confidential

Information Technology Specialist 3

Responsibilities:

SQL Server 2008 Application Developer using SSAS, SSIS and SSRS.
Project Lead Developer. SQL Server Business Intelligence Development Studio used to create Analysis Services, Integrated Services and Reporting Services.
Working knowledge of relational databases and table structures to create fact and dimension tables for cube creation.
Familiar with Multi Dimensional Expression (MDX) language for Report creation to deploy reports via Web (URL).
Assign Userids and roles for users.
Provide support and problem resolution for SQL Server project applications.
Monitor database activity via SQL Server Agents and Error Log files.
Technical and functional support of Oracle Financials 11i(11.5.10.2)
Worked closely with users and management to access their needs and make appropriate enhancements in a timely manner.
Provide document and training to new users.
Created stored procedures and packages to be executed by users.
Handle on-call Oracle Financials-related request from Customer Contact Center.
Responsible for System Administration and Application Development functions.
Created and altered tables, indexes, sequences, synonyms and grants.
Application Developments including creating over 100 custom reports and modified custom Forms.

Confidential

Senior Customer Programmer Analyst

Responsibilities:

Provide technical and functional support to systems using Crystal Reports, SQL Server and Visual Basic.
Proficient with Dreamweaver4 software package, used to create and maintain web pages.