Sql Server Vb .Net

MARCELLOUS ROWE

Houston, Texas *****

Cell 281-***-****

ad2k7m@r.postjobfree.com

SUMMARY OF QUALIFICATIONS:

Fourteen plus years in Installation, Configuration and Daily operation of Windows SQL 2000/2008/2016 Servers.

Expertise in database design and/or SQL indexing, SQL Server tools and SQL performance.

Highly skilled in SSIS, SSRS, Analysis Services and Power BI to include writing views, procedures and complex SQL queries.

Responsible for developing and maintaining web applications with VB.NET, ASP.NET, JavaScript, PHP and Django.

Work interdepartmentally to deliver technical concepts for Ticketing, Invoicing, Marketing and QuickBooks communication.

Proven ability to work creatively and analytically in a problem-solving environment

TECHNICAL SKILLS:

Software:

MSSQL, MySQL, SQLite, Postgres, Visual Basic, VB.NET, ASP.NET, PHP, AJAX, HTML, Python, Django, FileMaker 8, ORACLE, JAVA, Access, Fortran, VBA

Operating Systems:

Windows 2020, Ubuntu, Linux, IBM (360, 370), MVS, VM

EMPLOYMENT HISTORY:

SQL Server DBA, Additech, Inc./Houston TX 01/2006 to Present

DBA (Support 24/7) of SQL Servers with huge volume of data.

Support for all SQL infrastructures and database security.

Develop and manage 80 reports using Reporting Services (SSRS) and Power BI.

Determine end-user requirements to generate ad-hoc queries for accurate and timely information for company needs.

Create and update SSIS packages for sales data retrieval from multiple platforms.

Utilize SSIS packages to transfer data between SQL, MySQL, Postgres, Unix and QuickBooks.

Build (SSAS) OLAP Data ware house Cubes for end-users for quick access to information.

Design VB.net applications based on customer specification to track revenue sales and customer transactions.

Utilize ASP, PHP, JavaScript, Django and Perl for internal Web applications with SQL and MySQL on the back end.

Collaborate interdepartmentally to resolve system problems.

Software Engineer, PPOCHECK/Houston TX 02/2005 to 01/2006

Provide software development using SQL, FileMaker Pro 8, Access, Excel and VB.net to process hospital billing.

Develop the PPO Information data base on a SQL Server 2000.

Provide data structure and integrity for tables related to hospital claims, contracts, payers and networks.

Utilize VB.net and VB6.0 to map data from clients ASCII text data files into SQL

Generate reports using Access and Crystal for Finance and Accounting.

Perform all Microsoft software installs, upgrades and provide all maintenance.

Provide in house desktop, customer service and technical support.

Maintenance of all databases SQL, Access and FileMaker Pro

Address groups as well as establishing rapport one-on-one with all levels of the company.

Software Engineer, Dynamic Resource Management (DRM), 03/2004 to 02/2005

Build and support the VB 6.0 base DRM system of programs that is used to perform audits on hospital claims.

Communicate with staff to develop requirements, design, development and implementation of the system.

Quickly implement and troubleshoot incidents related to new code and existing issues with production code.

Develop codes based upon managed care contracts used for billing and payments.

Data Environment Designer, Transact-SQL and Stored Procedures are used to query a SQL 7.0 Server database.

Maintain the 3270 Emulation Server. This automated process will access remote patient account information, retrieve and post payments.

Provide Crystal Reports training and user support to meet specific needs.

Develop Excel speed streets for DRM clients.

Provide software installation and Desk Top support.

Software Engineer, HMO Blue Texas/ NYLCARE, 10/95 to 04/02

Support person, responsible for understanding and maintaining the data structure in a large Health-Care system.

Assist in all Health-Care departments with designs, enhancements and producing the report formats supporting the operational reporting needs.

Provide each department with Crystal Reports populated SQL 7.0 lookups as needed.

Use of COGNOS report writer to establish joints between multiple tables to generate reports for Finance, Enrollment, Marketing, and Accounting.

Develop Health-Care applications using Access. This included;

Database Design, Reports, Multi-user environment, ODBC Connections,

DAO and user Support.

EDUCATION:

B.S. Degree, Mathematics, West Virginia State College, 1980

REFERENCES: Available upon request.

Contact this candidate