SUMMARY:

• Data Analyst/Developer with Web skills seeking an opportunity to use my leadership skills and advanced education, working with mainstream technologies, to experience challenge and growth with a progressive organization.
• MBA with over twenty years of IT experience. Proficient in:
• Project Management, Database Administration, Design, Analysis, Programming, Implementation, Data Integration and Migration, Systems Administration
• SQL Server / Oracle DBA, Database programming & data modeling since 1997 & MS Dynamics CRM
• Performed as Data Scientist creating complex, cohesive database solutions
• Operated as Data Architect acquiring and managing data with an end to end vision while enforcing data standards multiple platforms ranging from PC through mainframe; proficiency in .NET (C#.NET, ASP.NET, VB.NET, Visual Studio) development; Crystal Reports, Java, Dynamics, WordPress and some Android understanding project details and how they relate to the overall project or business analyzing and identifying techniques to increase efficiency and effectiveness problem solver and supporting achievement of the organization goals working with different platforms, languages and/or roles, simultaneously, in legacy and emerging technologies working independently or part of a team, building relationship with coworkers, management and customers

TECHNICAL ENVIRONMENT:

PROGRAMMING LANGUAGES: SQL Server/T - SQL/Stored Procedures/DTS/SSIS, Crystal Reports, MS DynamicsClassic ASP, C#.NET, ASP.NET, VB.NET, Visual Studio, Java, Android, PowerBuilder, XML/XSL, PHP

DATABASES: MS SQL Server thru 2014, MS Dynamics 2015, Oracle 10i, Sybase 11, SQL Anywhere, SAP, MSAccess

ROLES: Project Management, DBA, Systems Administration, Design, Analysis, Programming, Implementation

OPERATING SYSTEMS: Windows 10, Vista, XP, DOS, OS/2 v4, Linux, UNIX, Android, OS/400

PLATFORMS: Android/Mobile, Web, .NET, AS/400, PC’s, IBM Mainframes (Series 370/3090/3084 ), Client Server

OTHER SOFTWARE/ENVIRONMENTS: HTML, JavaScript, VBScript, Active Directory, DreamWeaver v3, Flash v4SourceSafe (VSS), PVCS, TSO, CICS, (BO) Business Objects Enterprise, WordPress, EPIC EMR

PROFESSIONAL EXPERIENCE:

Sr. Procurement Data Analyst

Confidential, Oak Brook, IL

Responsibilities:

• Aggrigating data from more than 10 ERP Systems based in SQL Server, SAP, Oracle, JDE & Lawson to create combined management reports
• Performing SQL Server development to replace existing Access based current process
• Utilizing SharePoint, Power BI, Office365, SAP and SAP HANA

Operations Analyst

Confidential, Oak Brook, IL

Responsibilities:

• Created complex custom queries to analyze healthcare data for a variety of stakeholders
• Utilized healthcare data from multiple insurance companies, EPIC EMR and other governmental and non-governmental healthcare entities
• Performed SSIS transfers in SQL Server to import data into a SQL Server database

Analyst/Developer

Confidential, Chicago, IL

Responsibilities:

• Technical Lead for project to transition from ERP system to MS Dynamics CRM 2013/2015 to Wordpress CMS
• Managed projects, delegated duties and worked with vendors and users. Also assisted in selection processes for platforms and software, and interviewing programming candidates.
• Performed project management, analysis, design and implementation using netForum, SQL Stored Procedures and SSIS/DTS transfers in SQL Server thru 2014 to create/modify various complex management reports, which improved reliability and performance.
• Provided database management analysis and manipulation skills to solve complex database problems and data migration/integration skills which also helped improve data integrity and reliability.
• Performed web development in ASP.NET, C#.NET, VB.NET and classic ASP providing, analysis & design skills using Visual Studio 2010 to provide additional functionality to several Internet and Intranet web sites.
• Utilized other tools such as IIS, Management Studio, AD, Crystal Reports, JavaScript, VBScript to fulfill tasks.
• Designed and created custom SQL queries to perform data integration, data migration and ad hoc reporting

Analyst/Developer

Confidential, Oak Brook, IL

Responsibilities:

• Performed project management, analysis, design and implementation using Crystal Reports and SQL Stored Procedures and DTS transfers in SQL Server 2000 & 2005 to create/modify various complex management reports, which improved reliability and performance.
• Engineered complex detailed database analysis and manipulation to detect numerous data anomalies. This involved forensically attempting to determine how the data corruption occurred and writing scripts to resolve the issues, which improved data integrity and reliability.
• Assisted in architecting, configuration and administration of a Business Objects Enterprise (BOE) Server which streamlined and increased reliability.
• Provided ASP.NET, C#.NET, VB.NET, web programming, analysis & design using Visual Studio.NET 2005 to provide additional functionality to the administrative front-end of an existing reporting tool.
• Analyzed and implemented enhancements to an Internet web site using PHP pages to increase the capabilities of the web site

Analyst/Contractor

Confidential, Downers Grove, IL

Responsibilities:

• Architected and implemented enhancements to in corporate multi-tiered support levels to a customer support web site, providing ASP programming, analysis & design using Visual Studio.NET 2003, which greatly improved the site’s capabilities
• Utilized and interfaced with Oracle 9i using SQL Plus as the back end for software application development.
• Provided report analysis, design and implementation using Crystal Reports 11 to create a series of complex reports for a group of off-site users, giving the user community access to the data that they required.
• Received instructor-let training in ASP.NET & C#.NET
• Documented Unix Cron Scripts to help the company comply with mandated documentation requirement

Software Developer, Analyst & Administrator

Confidential, Downers Grove, IL

Responsibilities:

• Acted as DBA manipulating/merging data from several sources like SQL Server & AS/400, using Enterprise Manager and Query Analyzer to design and create Data Transfer Service (DTS) packages, Stored Procedures in T-SQL, Triggers and SQL Jobs. Architected and implemented database design and data modeling solutions. This gave the company access to reports previously unobtainable, in a streamlined, highly efficient and automated process.
• Provided project management, data and report analysis, design and implementation using Crystal Reports combining data from various sources using different schemas which required intricate data manipulation to combine the data and provide numerous and varied levels of reports.
• Installed, configured and administrated Crystal enterprise Server versions 8.5 and 9 to satisfy client reporting needs
• Architected and implemented web interface to a client-server problem tracking application performing the web programming, analysis and design using MS Visual Studio/Visual InterDev v6.0

Developer

Confidential, Brookfield, IL

Responsibilities:

• Web programming, analysis, design and content development
• Using MS Visual Studio/Visual InterDev v6.0, DreamWeaver v3 and Flash v4

Web Developer

Confidential, Chicago, IL

Responsibilities:

• Analyzed, designed and programmed modifications of the companies Internet website as well as Intranet tools, to allow the company to offer improved reliability and offerings to their user community
• Provided project management, mentoring and leadership on some projects
• Used MS Visual Studio/Visual InterDev v6.0 to create Active Server Pages (ASP), SourceSafe (VSS), SQL Server 6.5 & 7, Java2, DreamWeaver 3, Flash 4 and Linux/UNIX
• Designed and implemented complex SQL Server Stored Procedures to mine data for clients, which allowed them to better target their offers, greatly improving their sales abilities.
• Performed full product cycle; from gathering user requirements through design, implementation, and support

Senior Consultant

Confidential, Naperville, IL

Responsibilities:

• Performed analysis, design and programming in Java2 using Borland Jbuilder 3 on clients real estate management software and Crystal Reports to develop new reports run from the Java application, giving them a vastly improved interface with numerous reporting options.
• Provided analysis, design, mentoring and leadership using SilverStream 3 for both Internet/Intranet applications
• Used Erwin for data modeling for an in-house project
• Used SQL Server v7, Sybase, Access 2, and had formal classroom and web training in XML and CORBA

Systems Analyst

Confidential, Argonne, IL

Responsibilities:

• Provided analysis, design and project management of in-house computer systems, through full-product life cycle
• Acted as DBA making modifications/enhancements to SQL Server databases
• Used MS Visual Studio/InterDev v6.0 to create intranet reporting and resource management web applications which gave the abilities to a large, diverse and varied group of users
• Used PowerBuilder versions 4,5, and 6 to develop budgeting applications greatly improving their planning ability.
• Also using Oracle v7.3, SQL Server 6.5, Sybase, PVCS, Access, & some VB, Visual C++ and Linux/UNIX

Consulting Programmer/Analyst

Confidential, ROSEMONT, IL

Responsibilities:

• Designed, analyzed and implemented enhancements to the tools used by agencies, with development in CSP on the mainframe, ported to the AS/400 mid-range level for analysis and testing. This gave the company’s agents a vastly improved interface with increased flexibility, allowing them to improve sales
• Worked in on-line and batch applications, in new development, debugging, maintenance and enhancements

Systems Programmer/Analyst

Confidential, Franklin Park, IL

Responsibilities:

• Architected, designed, implemented and managed project to replace existing in-house mainframe A/R system with the Lawson A/R package on the AS/400. This gave the company significantly improved accounting abilities, with improved performance, which saved the company money.
• Created programs to extract data from their existing A/R system, ported and loaded it on the AS/400 Lawson system; another to extract sales info from their mainframe, port and load it into the AS/400 Lawson system, and a third, to send the output of A/R back to the mainframe’s Confidential package.
• Utilized CL, DFU, PDM, DBU and IBM SQL Utility
• Modified COBOL sales programs and migrated COBOL development to REALIA on the PC/LAN platform.
• Mentoring and leadership role on some projects