SUMMARY

• Ability to enhance an organizations success by using technical knowledge and expertise to ensure customer satisfaction and overall growth and development.
• Highly motivated Business Intelligence Professional using SQL Server 2008 and Microsoft Technologies.
• Experience manipulating various data sources to support Senior Management decisions.
• 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.

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

Relational 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, McKinney, TX

Consultant/Project Team Member/BA/PA/DBA

Responsibilities:

• SQL Express, UNIX, DBA/Help Desk Remote administrator support with BOMGAR, Filezilla, VNC on SQL Express databases to do FTPs, run update scripts and check the status of all system clients, file cleanups and terminal restarts
• Design and support client websites
• Computer hardware and software maintenance
• Updates to operating system software installations network setups
• Access Database projects, create db and reports
• Excel Spreadsheet projects
• Accounting and Tax Preparation
• User training and documentation
• 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

Project Manager/Project Team Member/BA/PA

Responsibilities:

• 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.
• 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 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, Carrollton, TX

Consultant/Project Manager/Project Team Member/BA/PA

Responsibilities:

• 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 analysis.
• 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

Project Team Member/PA

Responsibilities:

• 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