SUMMARY:

To gain a responsible career position where I can fully utilize my professional experience as SQL Database Administrator /Business Intelligence Developer while making a significant contribution to the success of my employer.

TECHNICAL SKILLS:

Communication Skills: Excellent communication, organizational, and analytical skills. Highly self motivated and self - disciplined thorough and precise in attention to details. Able to assume responsibility, identify and resolve problems and complete complex assignments on time ... eager, Quick learner ... multi-faceted, capable of moving up in any organization ... dependable and diligent.

Computer Language Skills: Confidential Visual Studio/.NET / crystal reports, Confidential SQL Server v2016, v2014, v2012, v 2008 R2 v2008, v2005, v2000, v7.0, v6.5 (Transact), SAP/3 ABAP/4, SAS, & Visual Interdev ASP, XML, Vbscript, and Java script with HTML code for Internet Web page support. Developing on Sybase, Oracle, MS Access, DBase IV, (RDMS) languages to retrieve, create, and insert into databases. COBOL, FORTRAN, Extend BASIC and Assembler for company custom design software. IBM AS/400 RPG/400 that supports System/III & System/II subsets, Santa Cruz Operation SCO Unix/ Xenix

PROFESSIONAL EXPERIENCE:

SQL Database Administrator /Business Intelligence Developer

Confidential, Rockwall, Texas

Responsibilities:

• The goal of this project was to remove SQL Server 2005 from the development, testing and production network.
• Successfully migration of applications and databases to the newest version of SQL S erver 2016 SP1 to VMware cloud storage and virtualization software from over 50 SQL Server instances .
• Applications were updated using SQL Server 2016 Integration Services, Reporting Services and Business Intelligence Development Studio. Created new SSIS scheduled agent packages to exact, transport and load data from SAP Business Warehouse and Oracle database server platforms.
• SharePoint Database administration Confidential SharePoint 2007 / 2010 (Configuration, Development, Data Migration) SharePoint administration concepts including upgrade methodologies like database attach and in - place upgrade and alternate access mappings including SQL Server alias naming.
• Using Commvault software m anaged backups, and recovery processes to ensure recovery timelines w ere met.

SQL Server Support Engineer

Confidential, Dallas, Texas

Responsibilities:

• Provided solutions for the top database administrator staff for the Confidential 500 technology companies around the world during their worst critical situation.
• When the database server has problems, they cannot resolve on their own.
• Handled most difficult customer support cases that were Confidential SQL Server call center premier support contracts that were escalated to highest priority.
• Classroom education from Confidential Software Corporation Escalation Engineer insider SQL Server support using their own Confidential s Best Practices on providing world class enterprise solution provider.
• Serve as an expert related to issues internal to Azure SQL Database (including customer databases on Premium SKU). This includes query performance, TSQL syntax, query performance, throttling, Management Portal, Management Studio, administration, data loss, failover and customers using the Import/Export service plus BACPAC errors.
• Resolve SQL Server issues related to TSQL programming, data integrity/corruption, backup/restore, setup/upgrade and add/remove components, Database mirroring, Cluster failover analysis, hangs or unresponsive servers, SQL Server administration tools, auditing issues, database maintenance plans and exceptions related to SQL Server for SQL On - Premise and in Windows Azure Virtual Machine (IaaS) environments.

SQL Database Administrator /Business Intelligence Developer

Confidential, Dallas, Texas

Responsibilities:

• Confidential SQL Server 2008 R2 baseline best practices was implemented - Using Confidential Baseline Configuration Analyzer 2.0 and Confidential Baseline Security Analyzer 2.3 that provided a high level plan to update all the development and production SQL Server 2008 R2 to bring the instances up to Service Pack 3 preparation for migration to Confidential SQL 2012 clustered Windows Cloud servers.
• Providing architecture, development and maintenance of data-warehousing and OLTP relational databases.
• Created automation SSIS maintenance plan packages of action to improve existing conditions and processes.
• Provided analysis, recommendations, consultation and advice on the Database Engine, Analysis Services, Integration Services, Reporting Services and Business Intelligence Development Studio for business rules.

SQL Database Administrator /Business Intelligence Developer

Confidential, Texas

Responsibilities:

• DBA finished the first implementation of a data warehouse with SQL NServer 2014 Business Intelligence Edition as a team member on the DW/BI team.
• Administrator and architect of Master Data Services (MDS) and Data Quality Services that addressed incompleteness, non-conformity, inconsistency, inaccuracy, invalidity, and data duplication in the data warehouse.
• Help in the adoption and successfully implemented agile practices into reporting development lifecycle.
• Gain deeper insights into the processes, challenges, critical success factors and benefits of Service Operation within the ITIL framework.

Senior SQL Database Administrator/ Developer

Confidential, Fort Worth, Texas

Responsibilities:

• Had both DBA production and development responsibilities for over 20 MS SQL Server 2012, 2008 R2 servers across the United States and Mexico.
• Helped reduce service requests backlog by 50 percent with the implementation of the scrum methodology and other agile methodologies, this highly productive approach helped the development team collaboration and reduced the software development time .
• Created automation SSIS maintenance plan packages of action to improve existing conditions and processes; identifying improvement opportunities, generating ideas, and implementing solutions.
• Team commitment by adhering to the team's expectations and guidelines; fulfilling team responsibilities; and demonstrating personal commitment to the team by being cooperative, collaborative, and flexible at all times.
• Always maintained effectiveness when experiencing significant changes in work responsibilities or environment; adjusting effectively to work within new work structures, processes, and requirements.

Senior SQL Database Administrator/ Developer

Confidential, Plano, Texas

Responsibilities:

• Confidential SQL Server 2008 R2 Setup - System Configuration Check Reports. Provided a high-level plan to update all the development and production SQL Server 2008 R2 to bring the instances either up to CU 6 or Service Pack 2 on over thirty Confidential clustered windows servers.
• Senior level of expertise with relational database structures, data security, storage solutions, database virtualization, replication, and clustering as well as used other complex technical tools and SQL Sentry solutions.
• Demonstrated senior level understanding of the interrelationship of hardware, OS, and SQL DBMS for the ongoing performance tuning and optimization of all the databases.

Senior SQL Database Administrator/ Developer

Confidential, Irving, Texas

Responsibilities:

• Performed proof - of-concept of requirements development strategy with implementation of SSRS 2008 R2 that uses multiple data sources and multiple data sets that had stop the team to meet clinical and business requirements. Break through solutions that team was unable to solve for months.
• Have the ability to bridge the gap between technical and clinical non-technical staff with over ten years of working with the frontline health care administration staff members.
• Project had more than 1000 operational reports that need to be rewritten in SSRS, SSIS 2008 R2 from Crystal Reporting v10 as a result of the clinical rewrite and data repository.
• Initially trained Crystal Reporting developers the skills to conduct rewrite with o n-the job training/mentoring of six junior developers as their instructor SSRS expression programming class.

Senior SQL Database Administrator/ Developer

Confidential, Fort Worth, Texas

Responsibilities:

• Aggregate Spend project for governmental entities reporting platform to bring transparency to the influence a manufacturer may have over a specific medical professional or healthcare industry through manufacturer spending allowances or manufacturer sampling giveaways.
• The replacement of extensive legacy reporting and exhaustive manual process of gathering data from both automated and manual business processes across the organization. Then, manually compiling and validating the data. The repeated manual processing of data may have opened Confidential to errors in reporting thereby potentially making them out of compliance with one, or more regulatory bodies.
• SQL development for SSIS packages that populate the staging area of the Aggregate Spend project using a series of pre - built Extract-Transform-Load (ETL) processes. Once the data has been moved from files into the staging area, additional ETL processes performed any necessary lookups, aggregations, and relations and populated the Aggregate Spend project star schemas.
• Provide ASP database design and Confidential 's Business Intelligence Development Studio (BIDS) using SQL Server 2008 SSMS, SSIS, and SSRS to appropriately capture and accurately report Confidential data to the various State and Federal agencies that have legislative requirements on manufacturer spending reimbursements or manufacturer sampling giveaways.

Senior SQL Database Administrator/ Developer

Confidential, Plano, Texas

Responsibilities:

• Disposition data mart project where I developed the Data Mart (OLAP) schema design layout and construction "As - Is" vs. "To Be" the software modeling and Meta-modeling.
• Conceptual data models, Logical data models (LDMs), and Physical data models (PDMs) diagrams for the project using Erwin 4, Confidential Professional Visio 2010, and DBVisualizer, IBM's iseries AS400 navigator for Admin.
• Using data modeling techniques as Entity-Relationship (ER) modeling, Dimensional modeling, Dimensions, Facts, Factless Facts, Conformed Dimensions, Slow changing.
• Development on MS SQL Server 2008, 2005 SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Business Intelligence Tools, Transact SQL, and Visual Studio (ASP.NET).
• SharePoint site Administrator for the project performed all the change control management for all shared documentation and project management like the master data file listing.
• Accomplished; home loans has a very high volume of data and when they write an aggregation production query on their legacy transaction system would take many hours to return the values. After our team's Disposition data mart was built the same result set is now taking only minutes.

Senior SQL Database Administrator/ Developer

Confidential, Carrollton, Texas

Responsibilities:

• Project Senior DBA that lead and advise the Management Report Analysis team members on complex reporting manager configuration, report designer issues with ad hoc SQL programming with SQL Server 2005 and 2008 Reporting Services platforms development.
• Assist development staff with the debugging and optimization of SQL queries and stored procedures migrated from Access's Visual Basic for Applications (VBA) code.
• Programming with Visual Basic.Net 2008 as front - end design report forms that was migration from IBM DB2 databases, Sybase databases and Confidential Access databases.
• MS Business Intelligence Development Studio (BIDS) and Visual Studio.NET solutions
• Developing reporting criteria and creating metrics, understanding the reporting platform being implemented and developing training program for the unit management staff.
• Serve as liaison with internal customers, and management report analysis team members to strategize and align their processes to sell real estate (REO) and reduce Confidential 's credit losses and exposure to losses.
• Coordinate strategy execution for day-to-day reporting operations and distribution reports for the team members engaged in reducing potential losses or foreclosure on delinquent loan. Articulate their goals and expectations working with limited allocated resources and management of limited time project workflow.

Senior SQL Database Administrator/ Developer

Confidential, Plano, Texas

Responsibilities:

• Project Senior DBA creating the process of employee's performance matrix scorecards and dashboard reporting on the customer accounts master database.
• Working with Visual Basic for Applications (VBA) as a front - end design for SAP/6 ABAP/4, Confidential 's SQL Server, FoxPro, and Confidential 's Access databases.
• Proactively evaluate physical and logical design of the databases for the internal coding system and the user interface repository databases.
• Created the data schema and data dictionary for the project databases.
• Performing needs assessment and defining configuration and user requirements. Developing Data-Warehouse User Interface working with programmers, developers and analysts to resolve technical issues. The database creator and developer of all users stored procedures and SQL queries to insert, update, and deletion of data on all the tables.

Senior SQL Database Administrator/ Developer

Confidential, Midland, Texas

Responsibilities:

• Primary Responsibilities Include: SQL Server 2008 and 2005 database servers' developer and administrator.
• Development on MS SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Business Intelligence Tools, Transact SQL, and Visual Studio (ASP.NET).
• Experience with agile development methodologies, test driven development and spreadsheet application development. Experience working with financial applications and all types of property management.
• Providing architecture, development and maintenance of data - warehousing and OLTP relational databases.
• Provided analysis, recommendations, consultation and advice on the Database Engine, Analysis Services, Integration Services, Reporting Services and Business Intelligence Development Studio for business rules.

Database Administrator/ Developer/Programmer

Confidential, Plano\Fort Worth, Texas

Responsibilities:

• Primary Responsibilities Include: SQL Server 2005 and 2000 database servers' developer and administrator.
• Providing architecture, development and maintenance of OLAP data - warehousing and OLTP relational databases.
• Provide analysis, recommendations, consultation and advice on the Database Engine, SSAS Analysis Services, SSIS Integration Services, SSRS Reporting Services and BIDS Business Intelligence Development Studio.
• Documenting technical architecture, system use and system maintenance. Prototyping solutions, preparing test scripts and conducting tests on data replication, extraction, loading, cleansing and modeling related to all aspects of SQL Server Management Studio.
• Performing needs assessment and defining configuration and user requirements. Developing Data-Warehouse User Interface working with Architects, Developers and Analysts to resolve technical issues.
• Designing components and performing complex coding/programming, de-bugging and testing within a OLAP data-warehouse and OLTP relational systems. Defining unit-testing "best practices" and performing system-Integration testing.
• Performing research and analysis of data-warehouse-related software and vendors-including new software releases, features and capabilities. Coordinating and conducting Requests-for-Proposal (RFPs) and Proof-of-Concept (POC) engagements.
• Assisting with Data Maintenance-including data-source gathering, data integrity, data extraction and transactional loading. Providing estimates for the completion time of assigned tasks and assisting in the review of others' time estimates for project management.