SUMMARY:

• I am a successful, seasoned professional with extensive experience.
• Specializing in data - mining: finding, evaluating, scrubbing/verifying, and manipulating data for reporting, transmission, research, documentation, and data quality.
• Excelling in data-mining in un-documented databases and datasets.
• Highly experienced Microsoft Access developer, including VBA (versions v2 through 2016).
• Highly experienced, though not recently, in mainframe programming using COBOL/JCL/VSAM.
• Experienced in building code and data structures on micro, server, and mainframe computers.
• Recognized for focusing on streamlining user processes through simplifying and clarifying reports, updating and scrubbing/verifying data, problem/error detection and repair, and data automation.

TECHNICAL SKILLS:

SKILLS: Data Mining / Analysis Un - Documented Data DiscoveryMicrosoft SQL Server / SSRSMicrosoft Access / VBASQL-Server Automated ProcessingData ReportingCOBOL / JCL/ VSAM / CICSRPG-II Strong Microsoft Access skills using versions v2 through 2016, extensive SQL Server data background data use, and extensive VBA script usage, also some non-recent Toolbar skills. Strong SQL Server usage for data analysis, documentation, ad-hoc querying, and Ad-hoc reporting SQL Server stored-procedure and DTS package usage for hands-off and fully-automated mass data processing and reporting SQL Server data structure design and implementation Conversant with Microsoft Office, versions v2 through 2016 Strong mainframe background using COBOL/JCL/CICS/VSAM, batch and online processing. Recent exposure and in Alteryx and CloverETL, though with little usage

PROFESSIONAL EXPERIENCE:

Confidential, Allentown, PA

Data Analyst/Report Developer

Responsibilities:

• Management support using data-analysis and data-mining during conversion
• Supported Finance and Operations departments in a conversion of the primary business system of application/loan software, including data conversion. Following that was an in-depth examination of current reporting and real reporting needs.
• Supported Finance and Operations in creating import/export of vendor data, including data conversion and verification, using Microsoft Access2016/VBA
• Data discovery and mining in undocumented data structures, both pre-conversion and post.
• Using Microsoft SQL Reporting (SSRS), built an extensive group of reports for business monitoring, volume tracking, data verification, client billing, and tax reporting
• Post-conversion data scrubbing, repair, and verification
• Numerous ad-hoc extracts and reports created from both new and old databases, separately and mixed

Confidential, Newark, NJ

Applications Developer

Responsibilities:

• Report development and data transfer between Microsoft SQL 2008 and Microsoft Access 2012/2016 with data verification and cleansing (including transformation) for external vendors and government agencies. This included Toolbar maintenance in 2016.

Confidential, Madison, NJ

Senior Applications Developer

Responsibilities:

• Primary support for maintenance and conversion of the Stock Options and A/P-G/L systems from mainframe (COBOL/JCL/RPG-II) to vendor-supplied SQL-based applications. Support including data analysis, data conversion, customized processes and reporting, and conversion validity assurance.
• Solved Compliance’s needs for required equity ownership by building a user-friendly application for collating and managing Executive Compensation, using Microsoft Access and Microsoft SQL Server. This required collecting and auto-updating data from other systems.
• Developed data-mining procedures for the Accounting, Treasury, and Legal departments for IRS audits in both the mainframe COBOL/JCL and client-server SQL Server systems.
• Streamlined the daily procedures of the Stock Options Equity system to enact a daily processing of employee updates, allowing them hands-off automated handling of several thousand updates and cancellations per month. Was done by creating maintenance procedures that crossed source and destination systems including external vendors. This started with convincing users to accept a major process change. This allowed my users efficient event handling of half a million s for 70,000 employees. These updates also enabled Accounting/Tax to more accurately manage corporate tax consequences and Human Resources to not be forced into repetitive inter-departmental notifications.
• Invited by, and participated in, the vendor ComputerShare to participate in their Strategic Council, a nationwide industry-spanning advisory group for their stock options software vendor. The invitation by the vendor to be a part of the twelve-member end-user product advisory council was targeted for technical/programming aspects.
• Designed and developed the divestiture of $830 million in equity compensation affecting over 18,000 employees during a corporate acquisition, including human resources updates and data transfers to international and domestic payrolls, with zero major defects and enabling the compensation board to close all payments ahead of schedule with virtually no external budget cost.
• Compiled a comprehensive set of daily/monthly/annual detail and summary reports that enabled users to report current Stock Options Equity system transactions, totals and values to Human Resources, Tax and Accounting departments, using Microsoft SQL Server.
• Designed and built a Cash system that was offered in lieu of stock-based compensation during the year of the corporate acquisition. The project involved designing and creating the data storage structure as well as the processes for historical data control, automated data maintenance, payments and reporting. Authored a user-friendly Microsoft Access front-end to allow users direct and immediate control of updates and reporting. Bi-directional automated data interfaces were created for Human Resources and Payroll feeds, using Microsoft SQL Server.