EDWARD IGLEWSKI

CONTACT INFORMATION: ad1rwz@r.postjobfree.com / 201-***-****

TECHNICAL SUMMARY

APPLICATIONS: Project Management, Data Requirements Gathering, Systems Analysis Documentation, MS Access (database creation, automation of processes using macros and VBA code), MS Excel VBA (developing dynamic applications and tools), MS Excel (pivot tables, advanced formula usage, VLOOKUP’s, GetPivotdata, Nested Ifs etc.), Large Scale data extraction and validation, SharePoint, MS Word, MS PowerPoint, MS Visio.

PROFESSIONAL EXPERIENCE

CR Bard / Becton Dickinson – Franklin Lakes, N.J. May 2017 – May 2023

Hired by CR Bard as a contractor / consultant to automate and design the Internal Audit team process tools. This system consisted of VBA / Excel based tools used by the audit team and the auditee throughout the whole auditing process. Multiple user interfaces were designed and implemented for end-to-end data capture and auditee data entry and progress tracking. An automated system was implemented to capture all data, create and update master tables of data, and create and update weekly / monthly reporting on audit status and any deficiencies found at the sites. Maintained all related data tables, troubleshooting all user issues of both auditors and auditees, training of new users, and creation of all user documentation. The audience for these applications was world-wide, so interfacing with many different parts of the world was a daily occurrence. Created all test scripts and supervised all testing of application updates, creation of all protocol documentation, and responsible for all related documentation to reside in company master control documentation system.

Created a user survey related to the audit team performance and auditing system. A VBA user application was created with a backend automation process developed to extract data into a running master table used for analysis and reporting metrics related to all aspects of the process.

Creation of the Internal Audit data process. This process consisted of over 140+ MS Excel /VBA child applications residing on a SharePoint site. These applications were updated monthly by the manufacturing sites all over the world. An automated process was devised to scrape all the monthly data into a master table which was then used to create monthly reporting Metrics. The data and tracking for these sites did not exist prior to this process so the metrics and reporting filled a very large void. This process also brought about the needed updating of all sites world-wide, and the identity of the quality management team personnel at these newly identified sites.

Created and automated FDA Auditor Profile report. This report was used to create a profile of the FDA auditor for use by BD site team. CSV files were extracted from an outside vendor database into an automated process which created a comprehensive profile report. This was a time sensitive, on demand report. From the time of requesting, it had to be a very quick turnaround, usually a couple of hours at most.

Created user attendance certificate processing for the yearly Quality Team division meeting. Over 300+

certificates were created by an automated process. This process included identifying the classes attended, the calculation of amount of total hours to receive credit for, and the automatic email distribution of all certificates to attendees.

Maintained user base for the Quality Team SharePoint sites. This included granting permission for access, uploading any files or reporting metrics, and creating new folders.

Worked with development team on the creation and roll out of the new audit data entry / tracking system. Initial model loosely based on the Excel / VBA audit process developed and used for almost 5 years. An Excel / VBA data loader was developed for use by contractors hired for any company audits. Created all user manuals, test scripts, supervised testing, and the company specification protocol documents pertaining to this data loader. This would be used to upload any data into the new system by a contractor.

Worked with developers on creating Power BI dashboards for Corporate and Internal data metrics. This included furnishing of all calculations of metrics, visual representations of metrics, testing and validation of metrics, and company specification / protocol documentation. Data feeds were created from master tables of data from audit processes and uploaded each month.

Handled all ad hoc data requests for all audit data – Internal, External, and Corporate audits. SME and owner of all the mentioned data sources.

Worked in tandem with IT on standardizing company site name lists, country code lists, and various other tables across all audit types for implementation into newly developed company system.

Part of group who won the prestigious CEO Excellence Award in fiscal year 2020. CR Bard was acquired by Becton Dickenson on or about 2017. Our group was one of the main drivers for overhauling the way audits were tracked and the reporting of all metrics with relation to all flavors of audits I n Becton Dickenson. A major overhaul was done with our corporate audit processing and reporting used as the model.

SPS Services Group – Parsippany, NJ May 2015 – May 2017

Team lead and project manager for newly implemented account executive commissions system. Worked with the external vendor on all phases of the implementation of the new system. Systems and data analysis for daily feed automation, gathering of requirements from business and IT developers, Setting data structures and file format feeds from a very wide and diverse set of data. Set up automation in MS Excel using Vba and database connections for data integrity checking. Working with commissions systems users on a daily basis for adhoc data and general system functionality.

Built and automated MS Excel data import tools and account and sales rep price quoting tools.

Worked with a diverse group of users within the company gathering price quoting system MS Excel outputs. Consolidated output files, which were in many different Excel layout formats through VBA automation. These files were then processed through a VBA based tool which massaged the data (matching against external files and tables) and created a final file output which was then uploaded to a CRM system. This import tool contains a user interface which enables the user to pick / trigger many different processing paths.

Created complex price quoting tools used by AE and SE community. Gathered all specifications / rules etc. that had to be in place for proper price quoting. These tools used extensive VBA processing and user interface forms to create the final output. These outputs are then feed into an importer tool (same type application) as mentioned above. These tools are VBA based but also included complex spreadsheet formulas and formatting.

Cleaned up existing code in some pre-existing tools. Created code comments and notes within processes to help with any debugging or troubleshooting.

Created clear and concise documentation for all the processes I created or were pre-existing.

Worked with SQL Server and MS Access to clean / massage / correct existing tables and data. Customer Account tables were in need of updating and cleaning out of bad / extraneous data. Created and MS Access process to aid in this process.

Federal Reserve Bank, Rutherford NJ August 2014 – April 2015

Reporting Development and Automation / Business Process Re-Engineering and Documentation

Hired as consultant to provide automated reporting systems solutions and business tool troubleshooting and documentation.

Provided production support and Ms Access VBA code support with audit tool functionality and delivery of time sensitive company asset audits. Investigated and trouble shot a very complex VBA MS Access audit tool which enabled 30+ company asset audits to be delivered on time. Due to changes in source data and other factors the audit tool needed adjusting throughout the entire process. Since no documentation was available a deep investigation was required into data inputs, VBA code, and user required interaction. This tool required a complete re-engineering of the daily data extraction and validation due to a very large system upgrade.

Automated Audit process customer input worksheet processing. Re-engineered MS Excel customer input workbook using VBA to streamline and simplify the process. This redesign simplified the amount of customer input required, automated the population of metrics, automated the formatting and population of graphs, and streamlined the process that uses this customer sheet further upstream. This redesign consisted of the implementation of a good amount of VBA coding and complex formula creation. Process utilized extensive use of Pivot tables which were created and filtered through the use of VBA coding.

Audit process and tool documentation. An impending substantial upgrade to all the audit process data inputs required investigation and impact analysis. No existing documentation necessitated a total end to end analysis and documentation of the existing tool and process. This investigation included learning the business rules, examining and deciphering a very large and complex amount of MS Access VBA code, and determining the status of the tool output data. A very in depth and user-friendly document was created so future users and maintainers have a detailed view of the inner workings of the tool and the entire process.

Completed adhoc requests for dataset matching and analysis and future metric reporting automation. This included data validation and cleansing of many large input data set extractions, complex matching and mapping between many datasets and sources, MS Access database and macro creation, and MS Excel VBA tool creation.

Involved in system upgrade timeline and impacts. An impending Remedy system upgrade has created the need to understand the impact on the Audit and other tools used by the group. Through the documentation created issues such as data structure changes, table and field name changes, and availability of new data sources was assessed and addressed with team members.

Verizon, Basking Ridge, NJ January 2012 - July 2014

Reporting Development and Automation / Business Intelligence Support

Hired as consultant to provide automated reporting systems solutions and support to the churn metrics team.

Worked on the FIOS platform reporting on disconnects and cancels. Provided insight for product and marketing tracking the effectiveness of any campaigns designed for customer retention. This insight was derived for data extraction from VZAI and other data warehouses within the company.

Engineered daily, weekly, and monthly reporting systems across all Verizon product platforms – TV, Internet, and Voice. This required gaining an understanding of all the data and tools available for extracting the raw unprocessed data from IT systems.

Automated daily extractions of data in multiple formats and created MS Access databases for storage and initial massaging of data. These databases are the engines that drive MS Excel VBA reports / applications as well as having a readily available data store for immediate use. This automation had extensive use of advanced query creation, creating macros which were triggered by an MS excel front end, and VBA code. There were 10 of these processes developed and maintained.

Created a large suite of MS Excel reports / applications that are updated weekly and monthly for the presentation and analysis of customer disconnect and churn metrics. These report metrics also feed multiple scorecard reports that are viewed at the executive level. All reports are very timing sensitive – there are a large amount of users using these reports to support a wide variety of needs. The suite of reports are VBA driven and contain complex calculations for customer churn available through a front end driven user GUI that offers very detailed views but in a simple easy to use format.

Automated daily scorecard processes for team members using MS Excel VBA data massaging and formatting processes resulting in time savings each day.

Worked as a member of the team that re-engineered and redefined disconnects codes for main IT systems. This has a very large impact on systems downstream and all executive level reporting.

Handled daily adhoc reporting requests from marketing team for things such as quick report creation, data explanations, and analysis and input on trends.

Created PowerPoint presentations for all types and levels of scorecard reporting and presentations.

ADP, Roseland, NJ March 2011 – November 2011

Systems Analysis / Business Requirements Documentation

Hired as consultant to provide requirements documentation of a re-engineering of a supplier management application.

Development of MS Access / MS Excel VBA tri-weekly reporting application for procurement team. Created and automated a reporting system tracking various metrics from large .txt files extracted from the Ariba tracking system.

Development and analysis of procurement analytics in MS Excel / MS Excel VBA with the purpose of closing a large time lag with system updates in Oracle.

Development of an application to facilitate the loading of data into the Ariba system. Created a user-friendly front end using MS Excel VBA with an under the covers process to format all data entries and pertinent additional data for uploading.

Created and maintained an MS Excel VBA project planning application. Intended for users who do not have access to MS Project, mimicking the look and functionality of that application.

Unilever, Englewood Cliffs, NJ April 2010 – November 2010

Excel VBA / Access Application Programmer / Data Analyst

Hired as consultant to provide data collection / programming and analysis for supply chain group.

Dropped in to a ‘hit the ground running’ situation due to a business decision / need to move deadline from end of year to Sept ’10.

Extensive data analysis (statistical and modeling techniques) of many divergent sources – SAP, MS SQL Server, Neilson etc.

Responsible for extraction of all data from SAP and SQL in .txt and .xls formats.

Validation of all table data against business intelligence rules and values.

Data cleansing and repair according to all implemented business rules – heavy interaction with IT department documenting known data ‘flaws’ and action taken to correct them.

Automated various data feeds using MS Excel VBA / MS Access Macros (SAP, MS SQL, MS Access, MS Excel) to populate master files for input into business intelligence cube process.

Process included files to determine if products were in the scope of process and a large amount of logic based programming to populate various fields in files.

Worked with IT department to help automate process on server level so future running of the cube process would have most automation built in.

Created a large amount of adhoc reports / charts / business intelligence in short periods of time since deadlines were extremely tight.

AT&T, Morristown, NJ July 2006 - March 2009

Excel VBA / Access Application Programmer / Data Analyst

Provide programming and intelligence support for a MS Excel pricing – costing application.

Analysis and collection of pricing / discounting data from various sources and systems to determine data integrity and quality.

Extensive data validation of discount rate tables required on daily basis to ensure correct pricing structure for AT&T enterprise customers.

Extensive data validation of currency rate tables and proper mapping within tool process.

In charge of new development project for IBM Europe entailing mining of large amount of data and creating datasets with new mappings and correct data validation rules.

Heavy development and modification of Excel VBA and advanced Excel formulas.

Heavy interaction with user community concerning testing plans and documentation, as well as live demonstrations and documentation of all changes to application.

Troubleshoot advanced helpdesk issues submitted by user community.

IBM, Piscataway, NJ October 2005 - July 2006

Excel VBA / Access Application Programmer / Data Analyst

Provided MS Excel reporting application / automation development. Developed MS Access databases to gather / massage large sets of data from many varied sources.

Created MS Excel GUI front end for the purpose of creating / automating bi-weekly report generating system. Extensive use of Excel VBA to import Access data outputs, final fine-tuning of data, creation of dynamic pivot tables, creation of dynamic charts and all report formatting and print functions.

System was created for generating reports and analysis for HR group.

A second similar application was developed entirely in MS Excel VBA, which completely automated a reporting process from loading of text file datasets to creating all reports and analysis.

Worked as helpdesk resource to aid in any reporting issues.

AT&T Labs, Edison, NJ June 2002 - July 2005

Programmer / Data Analyst

Hired as consultant for AT&T Labs to provide project programming and analysis support.

Duties include extracting Corporate Calling Card usage and provisioning data from ABS data warehouse Teradata database and numerous mainframe sources, the design and maintaince of multiple MS SQL 2000 and Access databases, usage and revenue tracking and reporting information delivery to client using MS Excel VBA and PowerPoint, website design and maintance using ColdFusion and HTML.

Involved in all data design and program coding, as well as heavy client interaction to insure all needs are satisfied.

Responsible for timely delivery of monthly production reports and any ad hoc requests that maybe required by the client. Backend reporting consisted of a high volume of MS Excel spreadsheets / applications derived from MS Access & SQL 2000 databases.

A large part of client support included the development and maintenance of interactive client tools developed in MS Excel VBA. Reporting systems, pricing structures and tables, fraud analysis, and general revenue reporting were all developed and put into production using MS Excel VBA applications with GUI front ends.

A thorough knowledge required in the workings of all products supported and data systems within the AT&T business environment.

Client reports and analysis concern sensitive issues such as price planning, product manager commission payments, and usage tracking for high level budget planning.

Global Technology Consulting Group, Middlesex, NJ July 2001 - February 2002

Programmer/ Data Analyst

Hired as all around consultant to support various projects with programming and analysis support for various clients.

Duties included extracting data from mainframe sources using COBOL and JCL, the design and maintaince of Microsoft SQL 2000, MS Access and FoxPro databases, and the creation of reports using MS Excel VBA and PowerPoint.

Day to day duties also included website design using ColdFusion, ASP, HTML, Active X, MS Frontpage, and Javascript. Client interaction and a complete understanding of data layouts and definitions also were a critical part of position.

AT&T, Middlesex, NJ July 1998 - July 2001

Programmer/ Data Analyst

At AT&T Labs (Business and Product Analysis) provided project programming and analysis support.

Duties include design and maintaince of SQL 7, Sybase, and MS Access databases, mainframe data extraction using Syncsort and FTP, and quality control of all data sources once received.

Develop and maintain monthly reporting using tools such as MS Excel VBA and MS PowerPoint. Create, design, and maintain websites using ColdFusion, MS FrontPage, JavaScript, and other web-based technologies.

Position required a through knowledge of AT&T product mechanics, as well as, heavy client interaction to provide client with appropriate support and data analysis.

Given Lead Analyst / Developer position in Corporate Calling Card usage reporting and website implementation project.

Project entailed all phases of development and design from inception through monthly reporting and maintaince. Specific development included locating and combining many different data sources, RDBM design, web-enabled reporting and database interaction, and monthly Excel applications and reports. Reports and information derived from this development were used for price planning, product usage tracking, and yearly budget planning.

Major role in development, support, and analysis of AT&T Military Calling Card Market project.

Similar technologies to CCCGE were used to provide client with reporting and web-based access to data.

AT&T BUSINESS OPERATIONS ANALYSIS, Somerset, NJ March 1995 - June 1998

Programmer/ Data Analyst

Hired as consultant through Regal Data Systems to aid in production, programming and report and creation for software Network client.

Responsibilities included tracking down data from a number of internal and external sources, modifying and creating Cobol and Focus code on IBM, troubleshooting production runs.

Manipulating data within MS Excel, and assuring the timeliness of delivery to the client.

Expanded responsibilities included client interaction, redesigning reporting system, and contract negotiating.

Assumed total responsibility for project, January 1996, when supervisor left position.

Created many new processes to enable reports to be transmitted and modified at PC processing level.

At termination of project archived all data and processes for further use in the future.

Brought on as Analyst/Programmer on Prepaid Calling Card Project. Designed and programmed database systems on PC processing level using MS Access and MS FoxPro. Responsible for implementing and producing reports using MS Excel on a weekly and monthly basis. Designed a “consumption model” to aid client’s need of understanding usage patterns of cards.

Designed and maintained Strategic Information Analysis Website, as well as division Recruiting Website. Used tools such as HTML, JavaScript, Corel Photopaint, and Photoshop to enable the site to be fully functional to client’s needs as well as be visually appealing.

Education:

Seton Hall Prep School – 1974 through 1979 – High school diploma

Rutgers University – Newark – 1980 through 1981 – Various classes working toward Business degree.

Chubb Computer Institute – Jersey City – completed 1.5-year intensive computer programming training in mainframe and pc programming. Received certification / diploma.

Various training in Microsoft accredited classes in MS Access, MS Excel, MS Excel VBA, and SQL Server disciplines.

Contact this candidate