SUMMARY:

• Experienced business intelligence, database and senior software designer/developer with corporate reporting experience in the broadcasting, medical, commercial real estate, Confidential and government sectors seeking challenging assignments.
• Prime areas of interest: business intelligence and corporate reporting, database design and optimization, software development, project management, SQL Server trouble - shooting and database conversions.
• Loves new challenges. Strong written and verbal communication, and interpersonal relationship building skills as indicated by my roles as a software development and, previously, as a policy advisor to governments and Confidential.

TECHNICAL SKILLS:

Computing: SQL programming language (TSQL and PL/SQL)), MDX, Confidential, database design and tuning, stored procedure design, development, testing and maintenance,, Confidential SSRS, Confidential SSIS, Confidential SSAS, Confidential Team Foundation System (Server) and Agile development, Visual Studio, Crystal Reports, Confidential Access, MicroStrategy, design of corporate reporting and business intelligence systems, web-development systems (HTML, Flash, Jscript, PHP, My SQL), C+, Visual Basic, VB.net, VBScript, Excel/VBA, PowerBI, FORTRAN, Windows XP, Unix shell scripting, XML

Management: corporate reporting and analysis, project management, business strategy, managing the introduction of new software for clients, initiating and maintaining high level corporate and governmental consultations and planning sessions.

PROFESSIONAL EXPERIENCE:

SENIOR SSAS DEVELOPER

Confidential, MO

Responsibilities:

• Consulting assignment: designed and coded a multidimensional, business intelligence cube of the combined membership and claims of the health insurance programs of Confidential for federal employees now in use at Confidential .
• Using SQL databases (2014 and 2016) and SSAS (mdx) have built a 500 million row plus database containing the multiyear enrollment and claims of the membership, a user-manual for self-directed analysis of trends in data in the database using on EXCEL.
• Converted same multidimensional cube to a tabular model.
• Created reports using SSRS and PowerBI

ETL/SQL SERVER ARCHITECT/DEVELOPER

Confidential, ALISO VIEJO, CA

Responsibilities:

• Consulting assignment: worked on site and remotely with their Confidential office as database architect/developer consultant - led a work group in Confidential through the design of new database architecture, backend database procedures (SQL Server based T-SQL and SSIS) 2012 for Confidential applications including the ETL of Confidential and social security files; designed data warehouse; wrote SQL Server coding standards manual.

ETL DEVELOPER

Confidential, MO

Responsibilities:

• Consulting assignment to load proprietary commercial property databases into Confidential ’s 2012 SQL Server database; to design and coding of SSIS packages to export reports to Confidential ’s clients; archiving procedures for the database; evaluated Hadoop, MongoDB and other big data solutions as potential replacements for Confidential SQL Server.

SQL SOFTWARE DEVELOPER

Confidential, KANSAS CITY, MISSOURI

Responsibilities:

• Consulting assignment for the design and implementation of ETL and SSIS packages loading into business intelligence data bases (data cubes) of the national operations of Confidential from Confidential, Confidential, Confidential and Confidential databases located on over 15 database servers and ftp sites.
• Took the lead role in designing recipient MS SQL Server staging databases using BI data modelling techniques with employees in 8 different corporate offices, including the coding and implementing ETL downloads from SQL Server, Oracle, AS400 databases, and Excel and other files into data mart; the implementation of download logging systems; optimization and correction of SSRS reports; advised on the optimization of database design and performance for MicroStrategy cubes, dashboards and reports in line with business requirements; wrote stored procedures and optimized stored procedures and indexes on the recipient SQL Server databases, wrote ETL extract code in PL/SQL and TSQL. Coached and advised other staff on the same. Original contract was extended four times.

DATA BASE DEVELOPER

Confidential, OVERLAND PARK, KANSAS

Responsibilities:

• Consulting assignment to work unassisted to improve the database performance of SQL Server 2000 and 2008 databases used to provide medical insurance services, including fuzzy matching and data loading to and from other health care industry organizations, database tuning.
• Work involved both hardware and software optimization, and training/mentoring/assisting IT staff.

SOFTWARE DEVELOPER

Confidential, OVERLAND PARK, KANSAS

Responsibilities:

• Consulting assignment: designed and coded Confidential SQL Server system (SQL SERVER 2005) to merge employee occupational health testing records between HQ and mobile testing units.

SENIOR SOFTWARE DEVELOPER

Confidential, FLORIDA

Responsibilities:

• One of the initial developers and architects of the Confidential for marketing, scheduling and billing radio, broadcast television and cable commercials.
• The system is a single database, multiple station system (two tier client/server system with C+ front end, SQL Server back end) that is installed at over 80 broadcast companies ranging in size from single station to 65+ station enterprises.
• It operates in real-time to create broadcast logs that optimize single or multi-station revenues and can accommodate 600 or more users at a time.
• Took the lead role in architecting components for reporting in consultation with senior managers at client radio, TV and news networks.
• Advised clients on the architecture and administration for the optimum operation of the OSi software
• Took the lead role in the design, coding and support of complex SQL stored procedures for the billing, sales tracking (pacing), and reporting components (using Crystal Reports).
• Mentored junior staff, took a lead role in optimizing (tuning) complex stored procedures and database/hardware configurations across the whole exe.
• I maintained active and responsive relations with clients (both their IT and corporate management staff) to address issues with the software and to define enhancements, and produced special reporting systems for individual clients.

SOFTWARE CONSULTANT

Confidential

Responsibilities:

• design, coding and implementation of business intelligence systems using SSIS, SSRS and ETL procedures, responsible for reports tracking sales, sales pacing, claims, subscriptions utilizing Confidential and Oracle SQL, Confidential SSAS (multidimensional and tabular models), MDX and Confidential coding languages, EXCEL, Power BI, and MicroStrategy. database, data mart and table design in Confidential SQL Server for performance, including indexing of tables and views, use of temp DB and other hardware configurations, etc.; database tuning and monitoring performance of large databases installed at clients; use of ETL, SSAS, SSIS, SSRS, VB.net and other procedures for populating and exporting SQL databases, including import of data from/to Access and Excel tables, XML and AS400 databases, Oracle, MicroStrategy, and other MS SQL databases, etc. from/to banks, Confidential, Confidential, Facets and other databases of clients; working in a multi-developer, .net development environment as team leader and team member; integration of software with third party applications particularly in the areas of electronic billing and payment, the transmission and processing of medical records, and the operations of vendors in the health, broadcasting and cable industries; working in accelerated mode to address client needs for a high availability computing environment;
• Working with corporate managers to scope out the business requirements for the reporting system; using data modelling to design databases that will effectively and efficiently meet business requirements; managing and advising clients on the management/administration/upgrading of large databases, including data/warehouse cubes.