Dba - Developer Manager - Front End Developer - Onbase Api Developer Resume
Cook County, IL
SUMMARY:
- Highly Experienced in SQL Server, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, Power BI, Team Foundation Server 2015, Sharepoint, C#, ASPX Web sites, ERP Applications & Onbase/Adobe API Development, Excellent Project & Team Leadership
- Comprehensive background in data analysis and software development with particular expertise in application integration, ERP development, and user - friendly website applications. Excellent verbal and written communicator. Strong track record of working with, teaching and leading cross-functional teams.
CORE COMPETENCIES:
Software Development Management Data Analysis (MS SQL Server, SQL, T-SQL) Visual Studio 2015 Team Foundation Ms Visio UML Backend SQL Server Administration Frontend C# ASPx web pages Aspx DevExpress Components WCF Services Vb.Script Javascript SSRS SSIS Packages Stored Procedures Adobe API Hyland-Onbase API Document Management API Adobe Javascript Oracle Sybase JavaScript VB MS Access Microsoft Office Ms Project Ms OneNote Microsoft VBA Class Objects, Modules & Custom Functions
PROFESSIONAL EXPERIENCE:
Confidential, Cook County, IL
DBA - Developer Manager - FRONT End Developer - Onbase API Developer
Responsibilities:
- Setup Document Management Application (Onbase) in SQL Server with Stored Procedures and SSIS.
- Developed application identifying client coupon use, saving county $100,000 in costs.
- Custom developed employees’ daily memo application, recording efficiency and benchmark deviation and data using intranet developed in C# .Net, SSRS, VB.Script code, Stored Procedures, SQL Jobs.
- Developed custom script in SQL Server syncing 3 SQL Databases with LAN Active Directory.
- Enhanced index and defragment on Query speed for all property taxes queries, driving efficiency.
- Mapped and upgrade with external tools all SQL Servers, Databases and SQL Jobs for easier ongoing maintenance.
- Repaired and maintained SQL Server clusters across organization
- Installed and configured new applications and updates, improving efficiency and team knowledge.
- Developed application that daily notifies the managers of any unclosed cashier system.
Confidential
Health Data Analyst
Responsibilities:
- Reduced data gathering time and created applications providing more functional data comparisons and the ability to compare more complex reports.
- Developed applications to reduce calculation time of payments, issuing checks, communication with suppliers, and payroll calculations.
- Automated all payments and notifications to customers by creating procedures, classes and custom functions in web sites, Access, Excel, SQL Strings - Queries and code.
- Successfully implemented ICD 9 for hospital as prototype, evaluating and monitoring results.
- Provided website administration support for HTML code, access, MS Access, SQL Server/Oracle/Sybase databases and connections.
- Prepared VBA Code to retrieve hardware serial numbers and personalized application per user.
Confidential
IT Developer / Data Analyst
Responsibilities:
- Developed an application in VB.Net, Vb.Script and VBA and SQL Server Database to replace book keeping candidate records
- Reorganized cost estimation by codification and data entry as data analyst.
- Upgraded software Apotheke, introducing drugstore application supported by PostgreSQL Database to speed up product search procedure and add user friendly functionality .
- Developed application related to composition and production of raw material and calculation of losses during the manufacturing process to improve cost estimation .
- Created external application using VBA programming language, for compilation of reports and offers enhanced by photos and cost estimates