OBJECTIVE:

Challenging position in IT or Project Management that will effectively use my business (e.g., accounting/finance, banking, clinical systems, insurance, manufacturing, grocery products) and consulting skills to meet, and exceed, corporate goals.

SUMMARY:

• Strong organizational, architect - design, development, database, web development, project management, presentation, customer service, conflict management, technical, and writing skills (published writer).
• Ability to handle multiple projects, build cost-effective business solutions, and lead and motivate other staff.
• “Hands-on” Agile-SDLC (concept, requirements, design/develop, feedback/review, test/deploy, solution) skills in client-server and web (internet, intranet) environment and IT Audit-SOX, CAAP, COSO|COBIT experience.

TECHNICAL SKILLS:

Programming Languages: MS-Access 2000-2016, Visual Basic 6, ASP.NET/VB.NET, C#.NET, VBA (MS-Access, Excel Power BI, Word, Outlook, Project) and VB Script, Java Script, PHP.

Tools: Visual Studio.Net 2005-2015, DTS|SSIS, SSRS, Adobe CS6-Dreamweaver, Oracle SQL Developer, MySQL Workbench, COBOL (OS/JCL, TSO/ISPF, IBM Utilities), and DBU, SEU, CL/RPG-AS/400.

Web Development: Classic ASP and ADO, VB.NET, C#.NET, ASP.NET, AJAX, JSON, Visual Studio, SharePoint Designer 2010, VBScript, JavaScript/jQuery, Bootstrap3, CSS3, HTML5, PHP, Web Services, XML/XSLT, DOM, Kodiak PHP IDE, Adobe Photo Shop and Creative Suite 6 (with Dreamweaver), and VSS.

Analysis-Design and Project Management: MS-Agile, SDLC, UML (Use Cases, Activity Diagrams), Visio Enterprise Architect, PowerPoint, MS-Project VBA, Test Director, Business Process Maps, ERD, ETL projects, WBS, Storyboards, and data modeling.

Report Writers: MS-Access, MS-Excel, SQL Server Reporting Services (SSRS), Crystal Reports/BI, HRIS, Accpac Query, MS-Word VBA with Mail Merge with database and MS-Outlook, and AS/400 Query.

Databases: MS-Access, Web SQL, SQL Server 2012-2016, Oracle, IBM DB2, SharePoint, MySQL, and AS/400. (Studying for MCSA Certification with 2016 SQL Database Development, Exam 70-761, 70-762)

EDI Software: Sterling-Ordernet, MCS, and Magic software for use with Purchase Order, Chargeback, Invoice Transactions.

Accounting/ERP Software: SAP/ERP, ADP-HRIS, PAGUS, HR.NET, ACCPAC Corp Edition (A/R, A/P, G/L, FX, Tax, Bank Services), Hyperion, Great Plaines and MS-Dynamics AX, Quickbooks Pro, and MAPICS/DB.

PROFESSIONAL EXPERIENCE:

Business Analyst II

Confidential - Schaumburg, IL

Responsibilities:

• Design, Create MS-Access (2013) database systems (Claims-Medical/Pharmacy) with SQL, Access VBA, Excel VBA and client-vendor files and various data sources.
• Analyze and compare Confidential and vendor-client input data and create weekly/monthly data reports (ETL, statistics, summary and exception reports) to identify results, patterns, and differences.
• Create Data Warehouse with one-many, many-to-many tables and relationships for project team to help manage work. Designed and developed all tables, parent-child forms and subforms, queries, and reports.
• Perform business and data analysis with patient eligibility and claims from OptumRx AS/400 databases.
• Create PowerPoint slides-presentations and detailed, on-line and written system-user documentation and training for users.

Sr. Database Consultant

Confidential - Palatine, IL

Responsibilities:

• Design and code applications with MS-Access VBA (2010-2016), Excel VBA, and SQL Server 2012-2016 databases. Work with SQL Server 2016 Express Edition and Web development with Java Script, JQuery, HTML5, CSS3, and ASP.Net. (This is a part-time job with some of my small business clients.)
• Create Business Intelligence Excel Dashboards, User Forms with Act-X controls, integrate data with Power Pivot-Power Query and Internal Data Model, and create charts/reports with Power Pivot, SSAS, and SSRS.
• Data Analysis, Business Analysis, and Project Management for small clients in the Chicago area.
• Setup and support MSFT Office 365 Admin, Active Directory-Windows Server 2012, IP-PBX, and Konica-Minolta. Setup-configure laptop-desktop computers and networking and provide PC and MS-Office support.

Sr. Database Developer

Confidential - Franklin Park, IL

Responsibilities:

• Maintain and enhance MS-Access (2010/2016) database systems (Payroll, Call Center, Legal, Clinical Systems, Human Resources, Education, Compliance) along with SQL, Excel VBA, and SharePoint Lists.
• Create custom database reports: MS-Access, MS-Word, MS-Excel (tabular and PivotTables), RightFax.
• Create weekly/monthly data warehouse reports (ETL, statistics, summary and drill down, exception, and Ad Hoc) by company, region, store to identify results, patterns, and metrics).
• Create and modify tables, indexes, views, queries, functions, stored procedures, triggers and security with MS-Access and SQL Server 2008/2012R2.
• Design SQL Server system for combined Clinical Systems reporting (Abertsons-Safeway) and capacity planning.
• Create SQL queries for Third-Party Benefits Data Mart, ETL, and optimize edits, formats, and performance.
• Perform detailed Business Analysis, Design, Development. Migrate databases in five departments to Access 2016: Setup, migrate Windows servers, create user/systems doc, train users and perform desktop support.

Sr. Web Developer

Confidential - Oak Brook, IL

Responsibilities:

• Analyze, maintain, and document ASP.Net, VB.Net web applications for Customer Recovery and Business
• Scorecard Reviews. Maintain Excel VBA, XML, and Business Intelligence applications.
• Create and modify tables, indexes, keys, views, cursors, stored procedures, triggers and security with
• Work with internet ASP.Net web sites with HTML, DHTML, JavaScript, CSS, Ajax, and XML.
• Analyze and document existing DTS packages (with flat files, Excel, MS-Access, SQL Server, Oracle, DB2) in SQL Server and migrate to SQL Server 2008.
• Create new SSIS Packages (e.g., Data Transformations, Exec SQL Tasks, Scripts, and Backup and Maintenance Tasks) and SSRS with BIDS, Visual Studio 2008.
• Work with Oracle SQL Developer and DB2 data sources, stored procedures, configuration files, test plans.
• Create and modify SQL Agent Jobs, Steps, Schedules, Security for Scripts, SQL Tasks, SSIS Packages.

Sr. Web Developer

Confidential - Northbrook, IL

Responsibilities:

• Analyze, design, code front-end edit, validation, and reporting for Pagus|HR.Net int’l. payroll soft-ware. Create business analysis and design specs, flowcharts, and documentation for IT Manager.
• Create stored procedures, indexes, functions, views, tables, and triggers with SQL Server.
• Create VB.Net Scripts (Data Reader, Data Sets) and SSIS Packages with BIDS, Visual Studio 2008.
• Create SSRS Reporting with Visual Studio 2008.
• Create SQL Agent Jobs, Steps, Schedules, Proxy Accounts for Scripts, SQL Tasks, and SSIS Packages.
• Design and maintain MS-Access and MS-Excel VBA code and custom client reporting for domestic and international clients.

Sr. Web Developer

Confidential - Lake Forest, IL

Responsibilities:

• Create AWSTATS, Search, Crawl Diagnostics with Google Search Appliance, MS-Access databases, Excel workbooks. (Compare, analyze, and report on web site and Crawl Diagnostics for business).
• Write C#, Access 2007 VBA, SQL Server 2008, and FrontPage 2003 VBA code to perform web site (FPSE) file maintenance.
• Create C# console applications with Visual Studio.Net 2010 for web site analysis, statistics, file management.
• Include client-side JavaScript, jQuery edits and validation, HTML, DHTML, CSS, and VBScript code with Classic ASP and ASP.Net web applications and train with SharePoint Designer 2007|2010.
• Review and modify stored procedures for web apps and create statistical reports with SQL Server 2008.
• Create design documents with scope, objectives, procedures, flowcharts, test plans, and error handling.
• Design and create MS-Access 2007 tables, queries, forms, and modules and write Access VBA code.

Lead Architect

Confidential, Bloomingdale, IL

Responsibilities:

• Design, program, and maintain intranet, web portal, Retail Store, WC and Garage Claims, Loss Prevention and Reporting System. (Digital Dashboard)
• Work in MSF-Agile development environment with small development framework, working model/quick delivery, iterative/adaptable process with bi-weekly business user input from districts.
• Create ASP.NET enhancements with Visual Studio.Net 2005, ASP.NET, VB.NET, User Controls, AJAX, SQL Server 2005 (tables, views, diagrams, stored procedures, scripts), Oracle, HTML, DHTML, JavaScript, Adobe Photoshop, and CSS.
• Worked with web parts and web zones including a significant number of user (.ascx) controls in IFrames.
• Convert Classic ASP programs to ASP.NET, VB.NET and include existing web form (.aspx), User Control (.ascx), Master Pages, Third-Party Controls, MS-Outlook (COM-Interop), and company Web Services.
• Assist Project Manager, weekly Team Meetings, create WBS and detailed Test Plans ( in SharePoint).

Senior Consultant

Confidential

Responsibilities:

• Design, program, and maintain Underwriting, Proposal Tracking, Sales/Life Insurance systems with Visual Basic 6, Visual Studio 2005|BIDS, Access VBA, Excel VBA, Word VBA, SQL Server 2005 Management Studio (tables, views, stored procedures, diagrams, scripts, DTS/SSIS), VSS, WISE, and Crystal Reports/BI.
• Convert Visual Basic 6 programs to VB.Net and SQL Server 2000 database systems to SQL Server 2005.
• Research, implement, and support regionally-based Underwriting systems in a Citrix server environment.
• Assist other developers, work on defect management in Clarity, and resolve software issues reported.
• Create install packages with Install Shield, detailed test plans, and systems and program documentation.
• Support internet web portal ASP Web applications with HTML, DHTML, CSS, and JavaScript.

Senior Web Developer Consultant

Confidential, Chicago, IL

Responsibilities:

• Designed and programmed new HRIS budgeting, planned/actual cost and hours, tracking, and reporting system with ASP.Net 2.0, C#.Net, Crystal Reports/Business Objects, HTML, DHTML, JavaScript, MS-Access, MS-Excel, CSS, SSRS, SQL Server 2005.
• Imported and cleaned data, designed tables and data model, created seventy-five forms, and wrote fifty-five stored procedures, views, and triggers.
• Performed weekly walkthrough of system requirements and results with business users and management, designed business rules for critical business functions, created thirty-five reports and documentation.
• Imported and exported Excel worksheets to/from system with web forms and trained and supported users.
• Designed other systems, queries, tables, converted files for SAP Materials Management System, and upgraded MS-Access to SQL Server 2005 databases.

Web Consultant

Confidential, Northbrook, IL

Responsibilities:

• Responsible for design, specifications, modeling, program development, changes, and enhancements, of Estimation & Metrics report tool with Access VBA, Excel VBA, and SQL Server 2005 Management Studio. (Digital Dashboard)
• Responsible for creation of various complex MS-Excel User Form (multi-tab) dashboard front-ends to Access and SQL Server databases (queries, SQL, formulas, charts, pivot tables, workbooks, sub procedures-functions, modules, and reports-sub reports)
• Created SharePoint lists and libraries and interfaces with MS-Access (Importing, Exporting, Linking) and MS-Excel.

Senior Developer

Confidential

Responsibilities:

• Perform system analysis, design, modeling, database development, program changes|enhancements, and support to Finance Department to comply with DataMart-UAT requirements:
• Analyze and review of Economic Capital (Credit Risk-Basel) requirements, files, maps, system interfaces, data elements, and entity relationship diagrams for Mortgages, Installment Loans, Commercial Credit Cards.
• Design, develop, and maintain integrated Retail and Non-Retail (Commercial) MS-Access databases (tables, SQL, VBA code, forms, and reports) and associated Excel workbooks to test results of ETL, Data Mart project.
• Create systematic, efficient form-based interfaces to databases, reduce monthly processing steps and time, and increase performance through use of SQL and VBA.
• Analyze and report on software|data defects with Test Director and follow up with ETL-development team.
• Analyze, process, and report monthly results with Retail and Non-Retail UAT databases and associated Excel workbooks for each software (data mart) release and cycle.
• Write and maintain procedures (system narrative, key fields, input, processing calculations, output, and internal controls), support IT Business Analysts, and perform special projects (e.g., Experian).
• , remote scripting objects, Ajax, PivotTables, JavaScript, HTML, DHTML, CSS, VB Script, and VSS.

Excel Consultant

Confidential - Hoffman Estates, IL

Responsibilities:

• Performed new MS-Access and Excel (VBA) development and maintenance projects using five MS-Access databases and fifteenexcel workbooks (and code modules)supporting twenty managers along with needed ASP web interfaces.
• Worked with ASP-SQL Server to Oracle 9/10 and ColdFusion web migration.

Senior IT Web Consultant

Confidential - Gurnee, IL

Responsibilities:

• Identified/resolved problems with AD, IIS Dev-Prod web servers, Visual Studio 2002/2003, SQL Server and associated software for project team.
• Designed/coded in VB6, ASP, ASP-VB.NET, SQL Server, triggers, views, stored procedures, debugging, HTML, DHTML, CSS, JavaScript, XML, XSLT, WSS, Crystal Reports for windows/web forms.
• Worked on forms and sub forms, VBA code modules, SQL, views, stored procedures (with SQL Server 2000), and reporting code for MS-Access (.adp) projects.
• Wrote Visual Studio.Net Standard Operating Procedures for project team: debugging, development server, crystal reports for windows and web forms, .NET deployment, VSS, and COM.
• Worked with Accounting, identified issues with receipts, payments, and revenue calculation, and interfaces to Great Plaines. (Worked on Sarbanes-Oxley audit, SDLC, and Standard Operating Procedures).

Senior IT Consultant

Confidential - Naperville, IL

Responsibilities:

• Designed and programmed complex, integrated Corporate Tax Information System for fifty users with MS-Access 2002 and Excel Visual Basic (VBA).
• Included web navigation, user forms, ADO database access, OO, table-driven, and server-based design.
• Included large M-1 Adjustment Worksheet repository.
• Included data architecture, modeling, SDLC, and rapid application development.
• system, program, user, and technical support documentation, as well as provided programmer training, knowledge transfer, and network diagrams (Visio and PowerPoint).

Confidential

Web Developer - Oak Brook, IL

Responsibilities:

• Designed and programmed new internet-based systems (Registration, Order Entry, Claims) e-commerce systems with ASP, ASP.NET, ADO, VBScript, JavaScript, JSP, HTML, DHTML,CSS, AD, IIS, Visual Studio 2002/MS-Visual InterDev, Dreamweaver MX, MS-FrontPage, PhotoShop/ImageReady, and SQL Server.
• Responsible for SDLC. Supported accounting-systems functions with AccPac Corporate Edition 4.2 (A/R, A/P, G/L, Tax, Forex, Bank Svcs.), Accpac Query/Print Boss, SQL Server, Peachtree, Crystal Reports 7-9.
• Designed and programmed Sales-Marketing Contact Management Database and Reporting system with MS-Access VBA (Query Defs, SQL, forms-sub forms, tables, reports-reports, and VBA).
• Handled Canadian/US Tax analysis and returns based on accounting systems in conjunction with CPA firm.
• Performed audit work and associated queries with Access, SQL Server, MS-Excel, and Accpac Query for revenue, expenditure, treasury/cash, and tax systems for CPA firm.
• Designed internal controls, procedures, and interfaces for internet-based, e-commerce web site systems.