Conducted freelancing work for a multitude of clients, consisting of database troubleshooting and issue resolution, complex SQL code changes / performance enhancements, dynamic database maintenance plans creation and optimization, database corruption identification and resolution, complex application metrics reporting, data warehousing (design, construction, and ETL); in addition, conducted work specific to AppifySQL Software’s flagship product AppDB.Studio consisting of SQL code creation and optimization, recommendations for new product features and enhancements, suggestions to improve GUI / user experience, participated in product marketing / messaging / branding. Additional freelancing services included:Database development for new projects, enhancements, and bug fixesIn-depth system analysis and monitoring, including proactive issue detection and resolutionPerformance tuning and optimization through architectural enhancements, SQL code modifications, optimized system settings, and proper indexing strategiesCustom scripts for on-the-fly analysis and troubleshootingMentoring and knowledge sharing, including best practices and approaches to database development and design

Duties included database performance monitoring, ERP code enhancement, database configuration and optimization, custom code creation and modification, coordination and management of all development projects assigned to external contractors, routine database maintenance and integrity checks, automated system monitoring and error notification. Additional tasks / accomplishments:Identified and rewrote a multitude of suboptimal custom SQL code resulting in average performance increases and resource utilization decreases of 98%Resolved several blocking and deadlocking issues affecting both system performance and data consistency through the use of Extended Events (XEs)Transitioned unsupported legacy version of QlikView Analytics And Reporting Solution software to the most current edition, from data validation to troubleshooting, creation of scheduled jobs and alerts, as well as coordination of user acceptance testing and third-party resourcesCompiled database documentation, including Swedish to English translation mappings for all table objects and columnsAssisted IT in transitioning entire organization from solely onsite to work from home in under three daysTechnical lead in new ERP selection and vetting process to replace legacy software systemWorked in conjunction with IT to configure, evaluate, and implement ServiceDesk Plus ticketing system

Duties included complex SQL development, code optimization, high performance code design and implementation, database design, performance monitoring, administration, issue identification and resolution, database analysis for all areas of the business spanning a multitude of applications, departments, locations, clients, and platforms. Additional tasks / accomplishments:Completely reverse engineered all database elements of the Merchandising application along with its proprietary installer in order to significantly simplify the install process by moving to DACPAC deployments and transitioning source control from a homegrown application to Team Foundation Server; followed by reverse engineering eight years worth of product upgrades, allowing clients to move from any previous version to the most current while reducing the manual implementation steps from over sixty to oneCreated SQL Server Data Collection Analyzer tool to proactively identify problematic database code across all hosted environments and software platformsImplemented code changes to Enterprise Selling reducing scheduled job run times from 3 hours to 5 secondsIntroduced significant modifications to the Price Change Document Deletion process, reducing execution time from several days to five minutesAssisted in Reports Redesign project, helping to review and optimize the SQL code base and in many cases reduced execution times by 99.5%Primary contact for all database related matters concerning coding standards, methodologies, and optimizations for all application groups including Analytics, CRM, Enterprise Selling, Enterprise Order Management, Merchandising, Point Of Sale, Sales Audit, and Warehouse ManagementLead resource for all client database issues, including self-hosted, AWS, and local SaaS clientsAided IT department in monitoring and regulating over 120 separate database environments for Development, QA, Performance, and Deployment

Duties included database development for Enterprise inSight ERP software, which necessitated that all code be modular with an extremely quick execution time, avoiding high resources utilization and concurrency / contention issues, as well as needing to be generic enough to satisfy the requirements of several different client environments while avoiding custom code situations. Additional tasks / accomplishments:Created a data purging process for Virtual Planner, which required a universal design to fit each client’s customized environment while achieving the same end result. It needed to be non-intrusive, take in to account 24 / 7 database uptime, and purge an average of 1.5 million designs per day while not impacting several million active global usersApplied code and architectural changes to LiveORDER database leading to performance increases of 60-98% and resource utilization reductions of 40-96%Completed over 300 unique change / enhancement / bug fix requests within first six monthsMaintained SQL code for active and upcoming product versions, including new / enhanced functionality, backwards compatibility, and architectural changes while respecting current configurations of unknown client environments and achieving the desired application changeWorked with elaborate tree and hierarchy structures such as catalog and catalog versioning as related to product and product versioning, which in turn included features, options, and relationships to orders, shipments, manufactures, and vendorsWorked on tables, views, general database architecture and indexing strategies, stored procedures, scalar-functions, table-functions, triggers, common table expressions, as well as entry-level XML and XSD tasksPrimary contact for Virtual Planner and LiveORDER teams for all database matters, including performance, optimization, coding standards, lab analysis, indexing strategies, data modeling / architecture, and code review

Duties included complex SQL development for internal and external applications, SQL code generation to support and enhance various internal reporting tools, code construction for database access / modification, SQL code optimization, streamlining, and standardization. Additional tasks / accomplishments:Participated in full rewrite of call center Live Activity Manager application, involving several elements of complex coding, design, and intricate business rules, in under five weeksPrimary developer for American Medical Association (AMA) data integration, including schema design, data architecture, ETL process, application integration, and documentationShared responsibility for maintenance, optimization, and continued development of legacy data martLead architect in complete rebuild of current data mart environment, both structure and content, merging substantial amounts of data from several key sources and applications into a single, simplified environment, allowing for ease of use in querying, reporting, analytics, and billingSupervised and participated in structural redesign and implementation of web service audit logging processesProvided code review, optimization, and general database training to developers, analysts, and QA members

Duties included data analysis, report generation, RFM analysis, Customer Performance Metrics, Lane Cost Modeling, code construction for database access / modification, SQL code optimization / standardization spanning a multitude of data sources including two custom CRMs, internal EDI application, ACCPAC financial accounting system. Additional tasks / accomplishments:Constructed Salesperson Scorecard for use across all offices and countries, incorporating 300+ data points from internal CRM system, IIS Logs, and ACCPAC. Data included peer group performance comparisons as well as current versus previous week’s statistics. Output also contained breakdowns of budget attainment, revenue and profit analysis, shipments, customers, sales lead activity, customer concentration, invoicing statistics, and CRM utilizationMaintained same-day reporting turnaround time of approximately 97% with an average yearly request volume of 400+ reportsConstructed SQL Server Trace File Analysis reports to identify inefficient code through scoring algorithms based on select performance elements such as CPU utilization, data reads, data writes, duration, and execution frequency to allow for prioritization of deep dive code analysis and optimization, resulting in significant performance improvements system-wide with overall resource gains ranging between 80%-97%Laid out structural groundwork for phone data collection via XML extracts into a relational model, including correction of various data aggregation errors, derived data fields, and improved the overall data model from the original XLM structure resulting in less relational complexity as well as increased query performanceConducted a multitude of Dun & Bradstreet data analysis for the Over-The-Road sales division, including customer profiling, industry trends, and corporate baselinesEngaged in various levels of database design, optimization, tuning, and administrative tasks, as required

Duties included Customer Migration analysis, Customer Retention analysis, general KPI statistics, database management, data auditing and integrity assurance, code construction for database access / modification. Additional tasks / accomplishments:Increased Dun & Bradstreet data matching quality from 55% (based on US-devised logic using Harte-Hanks' Trillium software) to 79% using Transact-SQLCreated BI Data Mart, the only centralized repository for both internal and external sources of Canadian data; accessible through various reporting tools such as SAS, SPSS, SQL Server, and Microsoft AccessPromoted to team lead within first three months of employmentCanadian Dun & Bradstreet relationship managerWANTED Technologies relationship managerManagement of all team priorities and projectsQuarterly analysis and write-up of the Monster Employment Index (Canada)Advanced SQL training for teammates

Duties included team management and development, database management, data auditing and integrity assurance, Customer Life Cycle analysis, IT Expenditure modeling, North American reporting centralization, code construction for database access / modification. Additional tasks / accomplishments:Created Predictive Buying algorithms, subcategorized into simple High, Medium, and Low opportunities (with an accuracy rate of 92%, 64%, and 33%, respectively) to assist Sales and Marketing in increasing share-of-wallet and allowing for more meaningful and focused direct marketing initiatives / campaignsDirectly managed six resources (one local, five remote)Constructed full marketing activity database and tracking system to support ROI analysis, activity tracking, and marketing mix modelingDesigned data mart structure and data feed for combined reporting requirements with acquisition of Software Spectrum Inc.Implemented scoring algorithms to rank unowned accounts available for distribution to new hires and acquisition teams

Duties included database management, data auditing, current and historical client / product reporting and analysis, import and analysis of external client information, RFM analysis, Customer Life Cycle analysis, phone data compilation / analysis, code construction for database access / modification. Additional tasks / accomplishments:Created Call Manager tool for Sales to align strategic call campaigns with owned accounts. Previous campaign lists were distributed through multiple sources / formats, resulting in a 5%-30% client touch rate. The Call Manager tool compiled all campaigns into a single source and resulted in a 73%-98% client touch rate. A control group of 600 customers with an average spending of $275k in the last 12 months returned 1.1 million in revenue in the first month and 1.8 million in the second month of the Call Manager being deployedFully rewrote corporate baselines, merging 5+ years of transactional data from two transactional systems along with appended Dun & Bradstreet information in under three weeks with a full execution runtime of just over two hours, compared to previous group requiring over six months and a 36-hour full execution runtimeInitiated and created phone data reporting analysis, increasing monthly client “touches” from 23% to 88% in under 8 monthsProduced phone reporting analysis which increase monthly revenue from dormant clients by 450% within the first month, with an additional average increase of 118% each subsequent monthMaintained same-day reporting turnaround time of 98.5% for Sales Operations group while absorbing a month-over-month average reporting increase of 21%Fully trained and supervised five Database Analysts (levels I and II)