Available for contract work, mostly remote with some on-site.Services:Database Engineering and Data warehousingPerformance tuning and DBA functionsCustom IntegrationData Analytics and ReportingBusiness analysis and project managementWeb development and UI designSolution architectureSkills and Technologies- Python, JavaScript, Node.js, C#, VB.Net, PHP, HTML, CSS, WordPress, RabbitMQ- SQL Server, SSIS, SSRS, PostgreSQL, MariaDB, MongoDB- ETL, stored procedures, triggers, user-defined functions, data warehousing- Performance tuning and query optimization - Data modeling, database design and architecture- DBA responsibilities - SQL Server install, backup, replication, security, sys admin related tasksPublicly available work sample:https://econtour.org/https://2ndopinion.global/

- Left position because employer went out of business- Sole in-house developer and handled all back-end development, integration, and DBA functionality- Refactored all ETL processed for the data-warehouse to increase performance and provide more up to data analytics- Liaised with Business Intelligence and outside contractors to development solutions to meet business needs- Installed and Configured new SSRS server to move reports from Excel ODBC to cloud environment with appropriate security - Setup transactional replication across multiple environments and implemented back-up strategy for redundancy and disaster recovery

- Lead all development efforts to architect, program, and implement a database solution to meet the requirements for the Affordable Care Act's employer mandate- Worked with Business Analysts and SME to define the system requirements and develop a solution for our clients- Created all tables, indexes, views and stored procedures for the application and performance tuned the code for scalability- Wrote the most complex business logic in my career to date for what has been described by experienced tax professionals as the most complex and difficult reporting regulations they have ever seen from the IRS- Built reports in SSRS to print system data on standard IRS forms for mailing to the employees by the IRS deadline- Created XML for submitting to the IRS using XPATH in SQL Server and C# in SSIS- Developed summary reports in SSRS for clients representing their compliance and penalty calculations

Senior Database Developer in the corporate office for the manufacturer of the Magic Bullet and NutriBullet brand products developing business logic and systems to meet the operational needs and integrating our system with factories in China, warehouses and retailers in the US, and various e-Commerce platforms- Designed and built an application in VB.Net and SQL to integrate our Amazon Marketplace store with our in-house ERP system allowing end users to handle all aspects of an order and manage inventory directly from our ERP system ($7.5 million in annual sales)- Built ETL to automatically update the inventory in our ERP system real-time as shipping containers are received at our 3PL partner warehouses- Built ETL to pull all e-Commerce and telemarketer orders from APIs and SFTP servers, decrypt the files, transform the different file types, and load the normalized data into our database - Integrated with Fresh Address API to validate and correct email addresses received on our websites and from telemarketers while importing orders into our ERP system- Developed the integration with Chase Paymentech’s Orbital gateway to process credit cards for all direct to consumer orders ($5 million in monthly processing)- Implemented an integration using Chase Safetech's API to reduce fraud and flag fraudulent orders for review in our ERP system- Collaborated with our application team to develop an inventory projection system to forecast demand and make sure our factories kept our warehouses supplied

- Lead the SDLC including defining the project scope, developing requirements from all stakeholders, writing technical specs, creating a project plan and timeline, planning system architecture, developing the database design and writing scripts to build the database and migrate data- Coordinate development efforts between in-house staff and external consultants as well as hardware support from our hosted solution provider- Provide software demo and presentations to outside parties interested in interfacing with our system- Build and maintain indexes, tune queries, and perform routine database maintenance- Create SSIS jobs to synchronize data cross-platform in different DBMS, manage backups , and replicate files across multiple servers both in-house and hosted- Change management of multiple databases on Development, QA, and Production servers- Build, schedule, and maintain batch queries in a Production environment- Maintain data integrity and implement solutions to automate and improve the accuracy of the company’s data- Manage uptime and configuration of our SFTP server that our external customers rely on for daily file transfers- Write ad hoc queries, scripts and reports to supplement system functionality on a daily basis

- Served as a project manager and business analyst for a 2 year software development and implementation - Met with users and managers on the accounting team to understand their business needs- Defined the current business processes, standardized them, and created the design specifications for the development team to build a workflow system for the accounting department that interfaced with other production applications in use- Translated and mapped the business flow identifying user and system triggers for moving purchase orders through the system in an automated fashion- Defined project scope, ROI calculations, project timeline and managed resource allocation- Designed user interfaces balancing user needs with the ability of the developers to deliver on time and budget- Developed test cases, UAT plan, system load tests, training materials and worked directly with the users during the implementation of the software system- Wrote queries for auditing data integrity and reconciling Accounts Payable/Receivable with the expected outcome- Met with members of the Executive Team to provide project updates on a regular basis- Delivered the project within the agreed upon time and budget