OBJECTIVE:

Seeking a position which will continually challenge me where I can apply my knowledge and experience within a business environment that supports its employees with continued training and appreciation.

EXPERIENCE:

Confidential

Senior Data Analyst/SQL Developer

• Responsible for the analysis, design, development and deployment of ETL and reporting infrastructures utilizing SQL Server 2012 SSIS, SSRS, SSAS, BISM, Multi-dimensional modeling, SVN, and Agile development.
• Write Tune queries, format data, manage import/export processes in stored procedures and ETL process utilizing SSIS.
• Distributed systems
• REST services
• Mongo DB and Raven DB
• Assesses business needs to determine requirements and provides recommendations for appropriate solutions
• Conduct research into current and emerging business intelligence technologies and issues in support of ETL needs
• Cultivates/Maintains on-going partnership with business owners, maintaining knowledge of business operations, strategies, information requirements, and priorities.
• Kimball methodology designing and implementing warehouse architecture facts and dimensions .
• Solves complex technical problems to include performance tuning of ETL packages, stored procedures, table structure, and database structure in support of the company's BI solution.
• Capital market knowledge Securities, Fixed Income, Risk, all pulses

Confidential

Senior Business Intelligence Consultant ETL Engineer

• Responsible for the analysis, design, development and deployment of ETL and reporting infrastructures utilizing SQL Server 2012 SSIS, SSRS, SSAS, BISM, Multi-dimensional modeling, SharePoint 2013, SVN, Agile development, and Kimball methodologies to support the companies BI solution.
• Assesses business needs to determine requirements and provides recommendations for appropriate solutions
• Conduct research into current and emerging business intelligence technologies and issues in support of ETL needs
• Cultivates/Maintains on-going partnership with business owners, maintaining knowledge of business operations, strategies, information requirements, and priorities.
• Develop, package and deliver new service offerings related to Business Intelligence centered on business requirements for use in the internal development of data models and custom ETL packages used for Multi-Dimensional modeling and BISM cubes.
• Solves complex technical problems to include performance tuning of ETL packages, stored procedures, table structure, and database structure in support of the company's BI solution.
• Assist clients in the development of reports using MS BI Suite and other tools as defined
• Creates testing methodology and criteria to ensure accuracy and quality of data

Confidential

Database Warehouse/SQL Developer

• SQL Server 2012 SSAS, SSRS, SSIS
• BI Development team
• Ad-Hoc reports, dashboards, KPI's
• IBM Cognos 10
• Java Development and Google Analytics
• MDX, TSQL
• Cube development
• Database/Cube Architecture

Confidential

Software Engineer

• SQL Server 2012 SSAS, SSRS, SSIS
• SQL Server 2008 R2 SSRS, SSAS, SSIS R2
• Create reports based on internal customer requirements
• MDX, TSQL, VB.Net
• Cube admin for business analysis and reporting
• Working in the Regression Admission Management RAM application team to implement BI reporting for user interface
• Worked within the Release Management Team to create dashboards, custom reports companywide for all Caradigm management levels and project teams worldwide
• Validation of reports, query tuning and TFS Sever administration
• Develop Extraction, Transformation, and Loading ETL, SSIS packages to extract data from data sources i.e. Oracle, Flat files, other SQL Server DB's
• Automation of SSIS packages, table rebuild scripts, and other admin tasks utilizing SQL Agent
• Beginning software app development utilizing WPF, C , and .NET technologies

Confidential

Database Administrator

• SQL Server 2008 R2 SSRS, SSAS, SSIS R2

• PDM Link system administration to include Product Life Cycle Management PLM template creation, versioning schema, document management and numbering, Beta/Alpha testing of products within a product life cycle. Creating End Items to include Bill of Materials BOM for marketing purposes.
• SSRS 2008 R2 reports for inventory tracking, status, and availability
• Detailed and summarized reports regarding manufacturing, engineering, and testing of products and fail rates pressure, torque, and electrified drill pipe/specialty items
• Development of inventory tracking system for shipment purposes both in country and out of country
• Develop SOP's in accordance with business rules and keeping within ISO 9001 certification
• Quality system administrator, to include tracking of quality and Health/Safety/Environment HS E issues throughout the organization. Report generation for Oracle backend.
• SSIS packages for material certification for integration of report development and product linking. To aid in export of product to foreign countries.
• SSIS packages for data transfer from Houston servers to local production servers
• Backups, restores, performance testing, server setup and build
• Business Intelligence developer

Confidential

Database Administrator

• SQL Server 2008 R2 SSRS, SSAS, SSIS R2
• SQL Server 2005 SSRS, SSAS, SSIS

• Ensure Confidentiality, Integrity, and Accessibility of all data stored within production databases in a SQL Server 2008 R2 clustered environment.
• Develop nightly full backups and hourly differential backups of 35 databases for synchronization from SQL Server 2005 to SQL server 2008 R2 utilizing SSIS 2008 R2. Backup files moved over with scripting tasks, file tasks and restored using scripting tasks and VB.Net.
• Develop reports using SSRS 2005, SSRS 2008 R2, and BIDs utilizing T-SQL, developed tables for staging data for complex calculations, student grades, class completion percentages, and other metrics used for data driven decisions for upper management.
• Monitor performance metrics on both SQL Server 2008 R2 Clustered environments Resident Campuses and Angel, Online Learning environment .
• Develop, maintain, tune, and verify all Store Procedures before implementation to production database s .
• T-SQL development for Store Procedures, SSIS jobs, and admin automation tasks.
• Update tables, views, and objects as dictated by business requirements.
• Troubleshoot logon problems and SP errors and or assist developers with SP development and errors.
• Develop Extraction, Transformation, and Loading ETL, SSIS packages.
• Train and assist developers on SSRS T-SQL, VB.Net development and implementation.
• Continued project management and instrumental in migration from Rackspace to Tier3, an outsourced Server Company.

Confidential

Developer

• Develop cost recovery software for law firms worldwide.
• Develop dynamic database driven web based applications based on client and company specifications and standards. Web based applications are developed utilizing a variety of software technologies including, but not limited to, PHP 5, HTML, XHTML 1.0 Transitional , JavaScript validation , AJAX, and SQL Server 2000/2005 Editions Supporting Report Services, SSIS, Analysis Services , and MySQL.
• Create, implement, and administer stored procedures to run back end operations for enterprise level software applications.
• Create, edit, implement, and administer MS-SQL Server Reporting Services using Visual Basic
• Manage and administer MS-SQL Server Ad-hoc Reporting Systems for clients and current products
• Develop embedded solutions for Multi-Function Devices using C and ASP.NET 2.0 and utilizing web services for user authentication, machine utilization tracking, and data insertion and updating to SQL Server 2005 backend.
• Research and development on current applications for future enhancements to existing products and expansion of lateral market opportunities.
• Trouble shoot software bugs, update existing software with patches based on client feedback.
• Create and maintain documentation on all applications including fixes, bugs, known issues, updates, and enhancements.
• Develop user manuals and training documentation.
• Assist implementation teams with installs and troubleshooting via Remote Connections.