James A. Sélep Email & Phone Number

Milwaukee, Wi, Us

§ Repair, Restore, Replace, Reclaim, Refurbish and Resolve residential & commercial property issues.§ Plumbing, Gas, Electrical, Roofing, Siding, Flooring & Tile, Drywall, Carpentry, Masonry, light-Concrete work, Appliance installation and repair, Lighting, Window Blinds, Ceiling Fans, Decking, Landscaping, Arborist, Lawn-Care, Security & Pest mitigation, etc.

§ formerly dba - Bartolotta Fireworks Company, Inc. of Genesee Depot, WI§ Setup of both electronically wired and hand ignited 3" through 6" mortars, Hand Ignition of individual mortars and flights.§ Take-down and Cleanup of Pyrotechnic Displays for various contracted events.§ Federally licensed through ATF and Homeland Security

Project @ Lands' End - Dodgeville, Wisconsin, as BI DBA / Microsoft Office SpecialistProject @ Oshkosh Corporation, as Microsoft Office Automation ProgrammerProject @ Saint Gobain Performance Plastics - Aurora, Ohio, as Data Analyst

Dodgeville, Wi, Us

§ Using AGILE methodology, Maintain and Enhance productivity and functioning of 100+ in-house developed legacy Microsoft Access databases inter-connected with Oracle & DB2 databases within Customs Compliance & Global Sourcing Logistics/Transportation Departments.§ Tracking logistics of shipments (foreign and domestic) from manufacturer to shipper (rail, truck, air and/or boat) thru customs to warehouse to store/customer. Auditing, reconciling and validating accurate invoicing, shipping charges, fees and tariffs, discounts and chargebacks.

§ served 7 years as President 2014-2018 2020-2023, 8 years as Vice-President of Executive Board 2005-2013 and previously as Borough Representative and Block Captain§ To serve as borough representative: decide, vote and disseminate information to my constituency of this 501-c3 civic organization.§ Facilitating neighborhood improvements and activities through law enforcement, city, county, state, federal agencies & public town-hall meetings to bring value, safety & enhanced quality of life to the neighborhood. § To foster better constituent communication of issues that effect / impact our lives & ensure decision-makers know our thoughts, wishes and are held accountable.§ To voice constituent opinion and desire on local building projects, development, zoning and licensing.§ Host and organize activities to improve communication, mingling and knowledge of constituents with local officials and business leaders.§ To seek out, cultivation of, apply for and steer funding to preserve and expand our influence and activities for the common good.

§ data analysis and process development for data conversion / validation / migration / reconciliation from multiple disparate data sources, (ACT!, Oracle, Siebel, Cognos, Sales WorkBench, etc.) for numerous company departments/modalities deploying to SalesForce.com CRM in AGILE environment.§ interface with internal Health Care business and process owners, IT personnel and management to collaboratively develop plans to identify, collect, cleanse and convert source system data to conform and integrate into standard and custom record types of GE's global SalesForce.com instance.

Espoo, Fi

§ Customer post production support and managerial statistical reporting development of P2P invoice automation processing ERP application solution.§ integrate/interface AnyERP with Oracle g11r2, SAP, Qad's MFG/Pro and Epicor's iScala ERP for Johnson Controls a major Milwaukee based global client.§ utilized SQL developer, MS Office 2010, XML editor, AnyERP adapter and notes++

Pittsburgh, Pennsylvania, Us

§ OCC compliance evaluation and assessment, for data integrity and security risk management regarding integrated scripts and databases with proposals for remediation and mitigation to best practical practices.§ With an elite team of Microsoft Access Database Source Material Experts, categorized and evaluated 31,000+ Access databases to identify the transactional ones for further evaluation and recommendation of security and processing improvements for remediation of OCC findings/concerns.

Hanover, Md, Us

Project @ PNC Mortgage, Miamisburg, OHMS Access SME - Core and Default Servicing, Transactional Database Risk Remediation Project 2011/04-2011/07Project @ Nationwide Children's Hospital - IT, Columbus, OHSQL Developer/Analyst 2011/1-2011/03Project @ Cardinal Health - ITAM, Dublin OHProgrammer/Analyst 2010/11-2011/03Project @ Oshkosh Corporate - IT; Oshkosh WIAccess Developer 2010/10via Accenture, Project @ MillerCoors LLC - Corporate IS Resource Planning; Milwaukee, WIResource Management Analyst 2009/02-2009/04Project @ Rockwell Automation - Global Sales & Marketing; Milwaukee, WIBusiness Analyst 2008/08-2009/01Project @ MillerCoors LLC (formerly Miller Brewing Co.) Corporate Strategy & Planning; Milwaukee, WIData Analyst / Statistician 2008/06-08Project @ Johnson Controls, Inc. – Power Solutions; Milwaukee, WIin Global Compensation/HRIS 2008/05-06Project @ Harley-Davidson Motor Company; Milwaukee, WIin Global Information Systems for National Business Planning 2007/08-2008/01Project @ Associated Banc-Corp.; Stevens Point, WI in Sales Administration for Associated Banc-Corp 2007/02-07

Columbus, Oh, Us

§ Analyze Oracle ERP & other data sources, (Ceridian, GEAC) and develop extraction methods and scripts to pull, scrub, translate and convert appropriate sensitive HR and payroll data for importation into major Lawson's Landmark GHR and S3 ERP implementation. Utilizing MS Office 2003, 2007, 2010, SQL and VBA.§ Developed data normalization and conversion process to validate, process, prep and provide data from numerous demographic, financial, payroll and human resource applications and systems to the new all-encompassing ERP system from LAWSON.

Dublin, Oh, Us

§ Provided advanced data analysis and correlation reporting expertise of disparate data sources for upper management reporting and inter-departmental consumption. MS Office 2010, Symantec's Altiris 6.1 § IT Asset Management & Service Delivery: Analyzed managerial ad-hoc requests and developed & improved methodologies to manage over 23,000 PC/server hardware assets and multitudinous software applications for aging equipment/resource replacement schedules software harvesting and upgrades and company-wide licensing risk/liability compliance. combining data with Microsoft Office 2007, Microsoft Access 2007 / Microsoft Excel 2003 and Microsoft SQL from sources like SAP, CA's UniCenter Asset Portfolio Manager (UAPM), HR & their Identity Management system (IDM) from People-Soft, WorkDay, Amdocs' Clarify, ASN, Informatica and Symantec's Altiris 6.1 system to reconcile IT inventory.§ Creating methods to map, (via Microsoft Visio 2003) and report through Microsoft SharePoint 2007 w/Nintex and track SW and HW IT assets and maintenance, licensing and support contracts from initial need, ordering and receiving through deployment, recovery, redeployment, retiring and environmental disposal.§ Data and package migrations included MS Office 2007 > Office 2010 as well as Altiris 5.0 > Altiris 6.1 with prep for Altiris 6.5

Oshkosh, Wisconsin, Us

§ Enhance and document an in-house Microsoft Access 2003 database application used for capacity & future planning, tracking and managing of Corporate and Defense project's IT staffing for Program Management Office (PMO) Managers and upper management. Planning tool - ("TRACIT", Time Recording and Capacity for IT)§ Fix, modify and babysit Microsoft Access 2003 application from final development and testing through critical initial production roll-out/release/implementation and subsequent support & enhancements.

§ reverse-engineer / retro-document an in-house application created in Microsoft Access 2007§ re-engineer and enhance an in-house Microsoft Access 2007 Database providing bid estimating and costing of large scale construction excavation projects§ developed detail bid itemization reporting module covering Equipment, Materials, Crews and Subcontractors to three sub-levels of detail depth§ Significantly enhanced the original database, allowing greater competitive edge in their market

Project @ Schneider Excavation, LLC., - Lannon, WI in Estimating and Planning as Microsoft Office 2007 ProgrammerProject as Unbeaten Path International @ International Wire Group - High Performance Conductors, Inc.(IWG-HPC) - Jewett City, CT & Littleton, NH

Solon, Oh, Us

§ At their Aurora, OH location - Provided companywide independent data analysis to validate methodology/strategy for recalculations of retro-adjustments to Kronos time-keeping data regarding a retroactive re-definition of shift-change time-punch grace periods.§ Utilized Kronos time-keeping data and Microsoft Access 2003, Microsoft Excel 2003 and Microsoft Word 2003.

Chicago, Il, Us

§ Agile SDLC, (software development life cycle), and support for Microsoft Project and Resource Request Tracking Center of ongoing and upcoming IT projects§ Improve and report efficiency metrics, targets and resource needs forecasting§ Utilizing Microsoft SharePoint, InfoPath, Microsoft Project, Portfolio Analyzer, Microsoft Visio 2003, Office 2007, Access 2003, XML, Microsoft SharePoint Designer, SQL & MOSS

Milwaukee, Wi, Us

§ Application Development and Statistical Reporting of Global Point of Sales Channel Development.§ Potential Opportunity Sales Pipeline Development. § Ad-hoc queries and reporting for upper management on privileged distributor and wholesaler customer metrics. § Utilizing IBM DB2, Microsoft Office 2002-SP3, Microsoft Access, Microsoft Excel & Microsoft Power-Point, Cognos Cubes, Oracle, SQL, and Orion as interim fix until delayed SAP implementation.

Racine, Wi, Us

§ During contentious company spin-off / divestiture / operations division of IW-Wyre Wynd from International Wire Group - High Performance Conductors, Inc, (IWG-HPC), I harvested crucial accounting and production process data from fragmented, decades old, undocumented Macola ERP. § Site visits to extract data from commingled unsupported Novell production servers located in 2 different manufacturing plants, (IWG-Wyre Wynd - Jewett City, CT & HPC-Montgomery Wire - Littleton, NH).§ Recovered bill of materials, production and process specifications, customer masters, shipping, billing and invoicing information, client and supplier lists and engineered data for conversion / importation into BPCS ERP application via Crystal reports, Microsoft Access 2003, Microsoft Excel 2003.

Chicago, Il, Us

§ Microsoft Office 2003 Application Development, statistical analysis and reconciliation / conversion of various data sets from Cognos Cubes, SQL, SAP, Microsoft Access 2003, Microsoft Excel 2003 and finance to combine, restructure and realign financial sales / marketing areas of new joint-venture company for Corporate Strategy and Planning.§ Information engineered data sources/sets from both Miller Brewing and Coors to normalize the combined data so decision-makers could analyze results and streamline marketing, advertising and logistics of these former competitors, into one cohesive umbrella partnership - eliminating the overlap, overspend and logistical redundancies.§ Utilized Microsoft SharePoint 2003, Microsoft Access 2003 and Microsoft Excel 2003

Cork, Ireland, Ie

§ Developed management workforce planning tool to report, chart and graph their current strategic human talent to forecast future human capital planning needs and statistics on EEOC compliance, Affirmative Action & diversity goals achievement. § Using Microsoft Office 2003, Microsoft Excel 2003, Microsoft Access 2003 & VBA, (Visual BASIC for Applications), to interface with JCI's LOOP system (concerning strategic talent review ratings) and with PeopleSoft in statistical data gathering, analysis and reporting.

Mclean, Virginia, Us

Project: MAXIMUS - FAST unit, (Financial Assessment Services Team) for Bureau of Milwaukee Child Welfare and WI state Dept of Health & Family Services§ I was instrumental in providing management reports and maintaining a system tracking financial eligibility of children for County foster-care program payment reimbursement by State, Federal governmental agencies and benefit programs. § I made major contributions of preparation reports and data reconciliation, (Microsoft Office 95 through Microsoft Office 97, Microsoft Office 2000, Microsoft Officer XP and XP Pro to Microsoft Office 2003, Microsoft Access, Microsoft VBA, (Visual BASIC for Applications) and Microsoft Excel), to successfully go through a Social Security, HIPAA review and crucial Federal audits.§ I employed AGILE methodology and developed from scratch a GUI multi-user Client/Server database, (Microsoft Office 95 through Microsoft Access 2003 front-end, Microsoft VBA, (Visual BASIC for Applications) - Microsoft SQL Server 2000 back-end), to aid workers in tracking and planning daily activities for maintaining eligibility requirements, productivity and management reporting. The system has since been deployed to ~60 users statewide.§ I delivered timely specialized statistical reporting for high-level Management /Government planning, (Microsoft Office and Microsoft VBA, (Visual BASIC for Applications)).§ I provided analysis, reports and spreadsheets of at risk records, Identifying reconciliation and accuracy targets and discrepancies throughout very diverse financial and governmental systems including court records, trust accounts, Social Security, Medicare, CARES, KINSHIP, AFCARS, HSRS and WiSACWIS, greatly increasing integrity of data.§ Data and package migrations include MS Office 95 > Office 97 > Office 2000 > Office XP > Office 2003 as well as SQL 95 > SQL 7 > SQL server 2000

Madison, Wi, Us

§ Utilized Microsoft Visual Studio 2005 w/ VSTS, Microsoft Office 2003, Microsoft SQL 2005, VB6 & XML on Client/Server side§ Providing Microsoft Access 2003 application support, enhancement development and incorporation services for maintaining financially critical legacy application.§ COBOL390, DB2, RDMS 6.2, Pro/JCL R260D, Princeton Softech Relational Tools 5.1, DeBug, WinSQL 6.5, File Manager z/OS v7r1, Serena ChangeMan 5.3, FileAid and JobTrac 3.5 on IMS, ISPF E(JES), MVS-5.3, TSO1 z/OS v1r8, CICS Mainframe side - IBM 2064-102

Mequon, Wi, Us

Project @ CUNA Mutual Group, Madison WIsconsinCOBOL Programmer Analyst / Billing and Collections IT support on lead up and through major IVPAr4 upgrade implementation.

Milwaukee, Wi, Us

§ Utilizing Cognos Cubes, MS Office 2003, Microsoft Access 2003 & Microsoft Excel 2003 w/ macros & VB6§ In major effort to collaboratively plan & coordinate production and business planning with projections of 680+ nationwide independent dealerships.§ Developed mechanism to securely record, validate & collect comprehensive projection detail data and comments across ‘Retail Sales Growth’ (IE… ‘New Vehicle Sales’, ‘Pre-Owned Vehicle Sales’, ‘Parts & Accessories Sales’, ’General Merchandise Sales’, ‘Service’, ‘Finance & Insurance Program Sales’), ‘Operations Management’, ‘Marketing’, ‘Customer Experience’ & ‘H-D/Dealership Business Partnership’. § Provided summary reporting for National Business Planning to promote, synergize & aid dealerships in capitalizing on available H-D events & training programs. § Provided statistical reporting for high-level management assessment of various Region, Sub-Regional, District & Market Arena geographies to strategically allocate programs & efforts for maximum utilization & mutual benefit.

Green Bay, Wisconsin, Us

§ Used Microsoft Office 2003, Microsoft Access & Microsoft Excel with macros and Microsoft VBA, (Visual BASIC for Applications) maintained sales tracking system for validating, proofing, reconciling, calculating and audit of mortgage loan closings, commissions and overrides due to corporate-wide mortgage loan officers, managers and regional directors under numerous compensation, incentive and payroll plans and agreements. Automatically disseminating reports via Adobe PDF files/snps and Microsoft Outlook.§ Provided high level management summary financial reporting and loan officer detail reports of mortgage activities and communicated to payroll earnings and changes to personnel compensation. Proactively modify and document changes to the database system loading and processing procedures as input and desired output changes across various application platforms and dissimilar input sources, (i.e. Gallagher Millennium 3.0, Fiserv, FDR and InformEnt), in preparation for Microsoft SQL server migration.§ Developed reporting and tracking of banking product cross-sell statistics for high-level management and incentive pay calculations based on cross-sell marketing target achievement.§ Research, document and reconcile data discrepancies and audit solution changes to maintain data integrity.§ Assumed duties of Senior Sales Administration Specialist / Supervisor out on family medical leave.§ Technical Environment: Microsoft XP Pro, Office Pro 2003, Adobe, Gallagher, Visual BASIC.

Zurich, Ch

Project @ JohnsonDiversey Inc.; Sturtevant, WIfor Commercialization Department Managers Project @ JohnsonDiversey Inc.; Sturtevant, WIfor Marketing Department & Production Managers

Fort Mill, South Carolina, Us

§ Oracle Optiva database processing through Microsoft Excel for commercialization project.§ Provided troubleshooting of existing application and resolved issues for Microsoft Excel application to function as desired.§ Formulaic constituent logistical coordination and production management.§ Production Efficiencies Tracking of changes requests for marketing in Microsoft Access. Microsoft Access application functionality improvements and corrections. § Managerial Reporting and Statistics

Milwaukee, Wisconsin, Us

AKA Under Various Names, Including...NRC ConsultingCarlson ConsultingPSC - Precision Software Consulting GroupProject @ MAXIMUS - FAST unit, (Financial Assessment Services Team) for the State of Wisconsin Department of Health and Family Services and the Bureau of Milwaukee Child Welfare Milwaukee, WIProject @ De La Rue, plc. - cash handling machines Watertown, WI

Basingstoke, Hampshire, Gb

§ Redesigned and automated a sales and marketing of cash handling machines application, (Microsoft Office 2000, Microsoft Excel), which would evaluate the chosen priorities of a prospective clients'; business and/or security concerns to identify, compare, contrast and suggest solution products for the client to field sales personnel.

New York City, Us

AKA Under Various Names, Including... Interim Consulting CPG Consulting &Computer Power GroupProject @ HO-CHUNK Casino & Convention Center - Baraboo, WIIS / Programmer Analyst / Business Analyst / Application DeveloperProject @ Great Lakes Higher Education Corporation - Madison, WIProgrammer Analyst / Systems DeveloperProject @ MAXIMUS - FAST unit, (Financial Assessment Services Team) for the State of Wisconsin Department of Health and Family Services and the Bureau of Milwaukee Child Welfare Milwaukee, WI Project @ Outsourcing Solutions Inc. OSi - PayCo American Corp.; New Berlin, WIProgrammer Analyst

Madison, Wi, Us

§ With a 12-member development team; I implemented business strategy documents into an IBM DB2 design. § Programmed, (COBOL II), module specification documents to validate and convert defaulted loan information from an archaic FAPS Database system to a GOALS database system, (Oracle).§ Certified Y2K analysis, validation and compliance testing.

Us

§ I designed and developed a validation process with an audit trail for contestant entry rule compliance into a promotional $1,000,000.00 giveaway, for the marketing department, (Microsoft Office 97, Microsoft Access 97, Microsoft Excel 97, Microsoft VBA, (Visual BASIC for Applications) and FoxPro).§ I developed a customized productivity analysis tool and security activity reporting system to measurably identify and direct management to areas needing customer service improvements, (Microsoft Office 97, Microsoft Access 97, Microsoft Excel 97 & FoxPro).

Us

§ Provided applications conversion and testing for dozens of client specific programs, (HP Micro Focus COBOL, VRX/E, NCR-VRX/E COBOL, ChangeMan, JOBTRAC, KORN shell), as this loan / receivables servicer underwent NCR platform changes to HP9000 UNIX environment.§ Performed client processing validation, modification, testing and data reconciliation, (UNIX, HP-UX, MUMPS, MVS/DCE, MVS/ESA, ENABLE, FileAid and JCL), as clients input formats, methods and media changed, often without notice.§ On-Call to interpret programming issues or console messages about any program with operations staff and the impact on time critical processing stream schedules.§ Maintenance and development of WIN and FACS databases.

Menomonee Falls, Wisconsin, Us

Earned several awards for productivity improvements & asset saving ideas.Systems Operator§ In nationwide central leading-edge facility, I was responsible for maintaining widely varied communications & time-sensitive critical processing streams on numerous system platforms, covering inventory levels & pricing controls, payroll, daily sales & management reporting, distribution center operations & credit card data processing. I oversaw I/O control staff.I/O Control Operator§ Charged with maintaining critical daily reporting schedules, managing & staging management reports, payroll & in-store signage for disbursement nationwide under strict processing time-lines.Desktop Support§ Performed all facets of software & hardware installation, connectivity, configuration, maintenance, repair & upgrades during major network conversion.Internal Computer Support Team member§ Installed & configured IBM 3270 devices & established connectivity to IBM ES9000 Host

§ I computerized & automated accounting operations from the previous manual clerical process – greatly increasing productivity and accuracy with near instant updates for corrections of P&L statements and financial reports, (Lotus 1-2-3, Paradox). Allowing for “What if” scenario exploration.§ Systems integration & computerization of the Customer Relations and Sales & Marketing areas dramatically contributed to increased sales volume in the first six months to more than the entire sales volume of the previous year. Sales volume continued to increase in subsequent years, (Lotus 1-2-3, Paradox & FOCUS).§ Application development in Engineering, Statistics and Laboratory Analysis lead to improvements in product quality & operations productivity, (Lotus 1-2-3 & WordPerfect).§ Systems integration & computerization of accounting, (PeachTree), purchasing, shipping-receiving and warehousing led to greater efficiencies & economies of saving in logistics, scheduling & inventory control.

§ Conducted burn-in and testing of computer equipment prior to customer site installation. Upon final installation of equipment, perform diagnostics. Assist customers in establishing and implementing their programming needs and problem resolution.§ Provided software and hardware configuration, installation, modification, upgrades and training to clientèle, (Apple, MACs, PCs and XTs).§ Provided maintenance and support for school and business computer systems by contract in New Mexico, Colorado & Arizona and conducted training seminars.§ Performed maintenance, troubleshooting, diagnosis and repair of PC hardware and components, (IBM, HP, KayPro, Apple, Franklin & Mac).

§ Developed & provided timely, accurate production tracking, computerized monitoring and statistical mine operations & productivity summary to company heads, greatly influencing preemptive responsiveness as report availability was reduced from several days manual preparation, (often with incomplete or missing data) to a complete detailed analysis within hours of shift end, (Lotus 1-2-3, IBM & HP desktops).§ Standardized & automated existing office / report applications in engineering department, reducing clerical staffing needs by over half, (ADRS, CMS, IBM-3083, HPL, WordPerfect, Lotus 1-2-3, FOCUS and Paradox).§ Employed data modeling & production optimization in computerized logistics, reserves & mine design, (FORTRAN, HP-Basic, RBase, dBase 3000 and Lotus 1-2-3).§ In maintenance department, Created & developed a mobile vehicle tracking system for part warranties, recalls, maintenance histories & repair costs, utilization efficiencies, equipment / engine operation hours.

Milwaukee, Wisconsin, Us

IT Operator - Holsum Foods; Waukesha, WIPurchasing - RTE (Cooper Power); Waukesha, WIOperations - RTE (Cooper Power); Waukesha, WIMarketing - RTE (Cooper Power); Waukesha, WIMailroom - Trent Tube; East Troy, WIMailroom - BankOne; Milwaukee, WIShipping - GE: Medical One; New Berlin, WIInventory - Harley-Davidson; Milwaukee, WIParking Attendant - SummerFest; Milwaukee, WI

Bs, Science And Environmental Change: Mathematics - Computer Science

Bs, Science And Environmental Change; Earth Science - Geology

Diploma, Computer And Science Emphasis

Science And Mathematics Emphasis