Migration of on premise databases to Microsoft Azure cloud.

Conversion of PHP and Crystal Reports to Jasper Reports for the USDA Forest Service NRM modernization project. 100% remote.

At 5% of cost estimated by another team, Single handedly completed development in Python of fully automated multi-client vendor data ETL. With ease of configuration and maintenance in mind. Made vendors accountable to follow their own specifications.Completed high profile audits for regulatory compliance: transferred all member data from Oracle to Azure SQL and matched data subject to compliance and categorized by risk then reported a custom mailing message for each affected member, I used advanced dynamic SQL techniques, XML Mapping, Python and PowerShell.Report development on health insurance data using SQL Server, Oracle, Python, Tableau, Power BI and SAS (Proc SQL, Macros).Developed stored procedures, views and automation scripts.Collaborated and taught colleagues on how to automate their tasks.100% remote position. Advantasure is headquartered in Glen Allen, VA.

Report development for Telsasoft's clients using Python, SQL, PL/pgSQL and software such as Tableau, PostgreSQL and git. Reports provided QA data on cell phone tower equipment for RF engineers Built views, data sources and interactive dashboards in Tableau. Developed reports for Telsasoft's OpsAlert.

Worked closely with every department for Cordant's clients to analyze their reporting needs and facilitate access to information that helped them make fact based decisions.Administered and developed databases, forms and reports for multiple facets of the business such as the head corporate office, lab operation, quality control, R&D, financial and accounting, client service, logistics and sales.Single handedly migrated data and files from Salesforce.com to HC1.com while retaining all relationships for thousands of accounts.Conducted data analysis and mapping, as well as database normalization, performance tuning, query optimization, data extraction, transfer, and loading ETL, and clean up.Collaborated with programmers, project managers, CEO , VPs and Scientists to deliver laboratory applications that add value to customers.Installed, configured, and administered Jasper Reports Server in Linux environment. User Administration and Report scheduling. Development of Jasper Reports with iReport and later with Jaspersoft Studio Gathered requirements, created data sources, wrote advanced SQL, designed tables, crosstab, charts and reports with subreports with parameters. Designed hundreds of pages paginated reports with dynamic drill-down table of content for easy navigation when exported to PDF. Including conditional page break, Header, Footer with date and page number, Summary with aggregates. Taught users on how to use and export their Jasper reports. Development and maintenance of relational database tables, views, functions and triggers in PostgreSQL using SQL and PL/pgSQL.Development of Microsoft Access front ends with ODBC connection to database.Built file maintenance interface between our LIS and corporate billing system: Xifin.Use of code version control systems such as Git and Team Foundation. Use of languages such as Shell scripts, VBA, Perl, PHP, Groovy and Java to automate and enhance aspects of reporting workflow.

Created database application and reports for call center and business office. This solution was used to track customer appeasements per agent. Designed a Microsoft Access front end in VBA. Installed, designed and administered a PostgreSQL database backend. Trained Naive Bayes classifier to categorize customer feedback.I also investigated the possibility of categorizing clients bizrate reviews automatically by using a naive bayesian filter.

Supervised IT support team composed of developer, systems administrator and support specialist. Staff training and support on in-house laboratory software and third-party accounting and sales software (Integration of Sage MAS500 and ACT for Web).Focused on timely delivery of IT support and solutions by listening to client's needs and assigning competent resources, following the company's Lean methodology. Managed resources between help desk and long term projects. Conducted yearly employee reviews and assisted in the hiring process. Chose and purchased IT equipment and software licenses.Design and development of an automated supply shipping system for logistics to answer stocking issues.Administration of 300GB PostgreSQL DB and other MySQL DB including replication. Design of database for Object Oriented Programs Normalization, Data integrity with constraints, Audit with triggers. Backup/Restore, Index MaintenanceLinux System Administration Install, configure and maintain servers, mainly Ubuntu. Windows Server Administration.Active Directory (for company wide central authentication), IIS with ASP/.Net, Terminal server and SQL Server administration, Web application setup.Development of Web (Perl or PHP) and Access Database Applications with PostgreSQL backend Reporting with SQL and Crystal Reports Using joins, subqueries and regular expressions Plain, pivot table and chart reports with conditional formattingWindows and linux workstation maintenance. Basic Networking and Cabling. Workstation and server assembly. Security policy and IT documentation writing.Help in deployment of Cisco VPN and OpenVPN for remote staff and clients. Help in deployment of VOIP telephone system to completely replace our legacy phone system, this increased flexibility and reduced cost.