User:Jam96
From Wikipedia, the free encyclopedia
Joseph A. Montione 211 Maple Street East Aurora, New York 14052 716.652.8315 (HM) 716.867.7335 (M) jam96@att.net
PROFESSIONAL INDUSTRY EXPERIENCE Staff Managed: Analyst I Level (Direct), Administrative Hourly staff(Direct), Senior Analyst IV Level (Indirect), and General Administrative Staff (Indirect) Areas Supported: Audit, Employee Relations, Banking Services, Benefits, Branch Banking, Business Banking, Central Operations, Central Technology, Commercial Marketing, Communications, Compensation, Consumer Lending, Corporate Services, Employment, External Requests, Finance, HR Executive, HR Regional, HR Training & Development, HRIS, Information Security, Information Technology, Investment Group, Legal, Mortgage, Network Computing Systems, Organizational Development, Payroll, Telephone Banking, Purchasing, Middle Market, Retail Marketing and Support, Cash Management, Merchant Services, Credit, Capital Markets Management Responsibilities: 2004 Salary Plan, Allfirst Data, Allfirst Reporting, Benefits Data Maintenance, Contingency Planning, EEO Reporting, Felix System, Government Reporting, HRIS Intranet, HRIS Data Maintenance, HRIS Data Request, HRIS Policies & Procedures, HRIS Scheduled Reporting, Payroll Data Maintenance, Security, Termination System, Turnover Reporting, HRIS Technical Support, Restrac, HR Move Management, HRIS Administration, Affirmative Action Reporting, Alfe Conversion, Allfirst Eliminations, Allfirst Staffing, Awareness Training, Branch Locations, Branch Names, Budget 2003, Census, COBRA, Company Maintenance, Compensation System, Computer Software Development, Cost Center Maintenance, Cost Center Managers, Cost Center Reporting, Cost Center Translation, Current Employees, Data Research / Question, Database Issues, DDA Import, Development, Direct Deposit, Discount Terminations, Employee, Employee Budgeting, Employee Commission, Employee Handbook, Employee Headcount, Employee Roster, Employee Survey, ESP - Business Case, Exit Interview Activity, External Communication, GENESYS Hardware, Hardware Purchase, Headcount, Historical DB and Interface, HR Budget, HR Staffing, Installation, Integration, Internal Communications, Intranet Administration, Layoffs, LOA - Leave Of Absence, Locations, Login Issues, Logs & Letters, M&T Locations File, March Report, Merit Increases, Minorities and Women, Municipality Reporting, Network Maintenance, New Hire Functions, Notifications, Observer, Observer Mailing, Old Hardware Removal, Org Chart, Overtime, Overtime Reports, Overtime Upload, Permission Modification, Phone Message Change, PORG Edit, Price Waterhouse Coopers, Projected Vacation Payout, Reconciliation, Regional, Regions, Regions Directory, Requirements Gathering, Restrac Reporting, Rochester View, Roster Reporting, Rosters, Salary Plan 2003, Salary Report, Security, Service Year Awards, Severance & , Retention, Severance Audit, Severance Sheets, Software Upgrade, SSR Audit, SSR Projects, Staff Reporting, Staffing Reporting, SYBASE ODBC XP, System Administration, Tax Credits, Technical Support, Technical Support, Teller Disability, Term & New Hire, Term Reporting, Terminations, Time or Task Reporting, Turnover, United Way, Unum, Vacation Policy, Virtual Mall, Wilmer's Report
Summary As an executive professional manager, an experienced vendor contract negotiator, manager, 4GL solutions provider code writer and e-Solutions Architect, with eleven years of Computer Consulting Systems Engineering experience. Seventeen years of customer service made me responsible for all phases of project completion in the system life cycle www.eds.com -Data Conversion and Migration Specialist - Will translate any computer solution to any technology including Microsoft technologies -Excellent communication skills - Experienced international meeting facilitator www.xerox.com Canada -Technical Project / Program Manager as well as contract programming manager www.cendant.com -A leader in technical aptitude - Can sell, manage, code, and implement solutions www.tpi-sourcing.com -Data Modeling and Systems Methodology specialist digesting strategic business objectives aligning corporate expansion with computer systems sales and development. -A Professional Manager experienced having sixteen years in the service industry, three of which were directing, scheduling, and coordinating over 65 employees; with over three years managing IT banking departments, and projects at www.mandtbank.com –Managed Yearly budget, FTE, growth, and department development scope in a planning role.
Skills Areas of Expertise - Financial Income Statement Reporting, Financial Product Reporting, Banking Consulting Data Modeling, Database tuning, Database administration, Data conversion and migration (Enterprise level database conversions- DataEase to SQL Server, DOS conversions for Y2K, Access to SQL Server) Project Management, EIS Design and architecture, Financial EIS Reporting, Wireless application design and development Novell Network Scheduling, Planning methodology (Business Direction and Operations) as well as the SLC Definition Analysis, Business Design and an Implementation Planning Phase, Software Upgrades, Order Entry, Customer Pricing Network Auto-Load, XP Program Upgrade and platform testing, Software Developer, SOX Tracking Documentation / Procedures Symbol PPT2800 wireless PDA integration, Barcode Integration Databases - SQL Server 6.5-7,2000,2005 - Present, SSIS, SMS, DTS, Analysis Services, MS Access 1 to Present, Dbase, DataEase, TM1 Perspectives OLAP, MDD, mySQL, ORACLE, dbXtra, Sybase, mySQL, SQL Server ActiveX Scripting, ASCII ETL Languages - Visual Basic 1 to Present, VB.NET, ASP, C++, C, ActiveX, Hypertext System Programming, SQL, ASPX, MASP HTML, UML, XML, Visual Basic for Applications (VBA), Assembler, Pascal, Embedded Visual Basic Script PDA, OLAP MDX, Stored Procedures Application Development– SyteLine ERP, Sales Configuration, Visual Studio all versions, Visual Inter Dev, Visual Studio.NET 2003-2005, DCOM / COM, ADO, DAO, RDO, ODBC, WISE, True Grid Pro, Sheridan Data Widgets, ProNexus, Terminal I/O, Dynamic Link Lists, Structures/Unions, API, COM+, MS Office Integration Programming Crystal Reports since conception, Install Manager, Structure Charts, and Pseudo Code EIS Design and architecture, Wireless application design and development, RISE, JAD SLC Project Methodology, Sales support - RFP creation, Data Modeling, DBA and database tuning Web Development - Web Architecture, Web Page Design Visual Studio 2003-05, ASPX, ASP.NET Mobile ASP.NET, ASP, HTML, DHTML, VB Script, Visual Inter Dev, ACORD message format, XML Mainframe - MVS, COBOL2, TSO, JCL, DOS, NDM, CHAMP, IPC, Micro Focus COBOL, Telnet, VSAM, AS/400, 1. EBCDIC (WINS) GENESYS, PORG Software Packages - MS Office All versions, WISE, Lotus 123, Chameleon TCIP, Branch Source Centrus Geocode, Clipper Ship, TracerX, BranchSource, GIS Mapping, MS Project, OLAP Cube Browser ProClarity OLAP, Crystal Reports, IBM Content Manager, Lotus Notes – Domino, Ascent Capture KOFAX.com, RightFax Operating Systems- Windows 3.11wkg-95-98-NT-2000-XP-XP Professional, Windows Server Products UNIX, X.24, DOS, Windows CE, Pocket PC, Palm PC platforms Networking- Divisional XP Migration, Novell, Cameleon TCPIP, X.24, HTTP, HTTPS, LAN/WAN Architecture Corporate Network Architecture, Wireless, Microsoft, profiles, login scripts, network mapping drive mapping, space management, server upgrade/ patching, Citrix MetaFrame – Program Neighborhood – v 9
Objective Secure a position as a direct hire with a company that can benefit from my extensive experience as a successful business owner with deep vertical market financial IT projects background. My skill set is diverse, in that I can sell architect, implement, manage, code and maintain the solutions, which I create. I want to be a permanent employee, utilizing my diverse skill set to manage technical consultants and project implementations for a large to medium size company
Education Embry - Riddle Aeronautical University B.S., Management Science-Summa Cum Laude A.S., Business Administration-Summa Cum Laude GPA: 3.5 Honors, Deans List, National Leadership Honors Society Nomination
PROFESSIONAL EXPERIENCE / CORPORATE HISTORY / CONTRACT HISTORY
12/1998 - Present - GTOpenDatabase L.L.C. – Software Solutions
Technology Partners International, Houston, TX; TPI–MPACT v2.1 – BI Solutions Provider
As an architect, programmer, and database designer of a financial modeling tool currently in production as version 2.1, translated complex business processes into concrete computer database and GUI systems. Database design, efficiency, and compartmentalization were this applications strong point. TPI is the largest financial outsourcing-consulting firm. -Migrated complex EXCEL financial algorithms into Visual Basic Code for data delivery in .xls format -Where two other firms tried and failed, I used precise data modeling methodologies to complete this project under budget and ahead of schedule. They are currently my longest and best customer relationship. Environment: Microsoft Windows 95-98-NT-2000-XP/Office XP, Visual Basic 6, MS Access 2000, Sheridan Data Widgets
3.11, Excel 2000, InstallManager 1.5
10/2006 – Present – Derrick Equipment Corporation Contract Consulting
Accounting - Enterprise Resource Planning (ERP) \ Sales Configurator Programming \ Process Improvement
The major goal of this project was to implement the SyteLine 7.4 ERP Sales configurator, automated sales quote generating functionality in the Oil & Gas and Industrial Product lines. Maintained production testing and development environmental database of product configurator models, including version tracking, backup, and production tracking. Responsible for the Excel.xls pricing worksheets used to produce database flat files. These files are used to drive pricing, options, and products available in the ERP estimate items master. Using Trillog’s PowerPack configurator created and compiled models that specified all parts and products in a product line, showing which parts could be used in each product, and the relationship between parts, in a pricing finance environment. Programmed / designed / maintained the interface between the SyteLine ERP system items and orders with the Configuration User Interface. Engineered custom user interfaces utilized in the selection of product sales orders. Generated custom VBA MS Word sales estimate documents resulting from the sales estimate configuration. The resulting estimates integrated pictures, sales text, weights and dimensions, and pricing from centralized sources. Acted as the DBA for multiple SQL Server 2000 data servers, monitoring space, indexes, tables, TSQL and overall day-to-day server health. Managed multiple IIS web sites/ servers with ASPX and HTML screen programming to SQL Server.
Other Projects: -ASPX Web Bill of Lading - Created a Visual Studio 2005 web ASPX application to generate bill of lading documents for shipment transportation, with label printing and shipment tag functionality, interacting with a MS SQL Server 2000 database and IIS 6.0. Administered web site and SQL Server permissions groups and files. -VB.NET Executive BI Tool - While learning their ERP database structures, developed a Visual Studio 2005 VB.NET custom graphic drill-down interface allowing for reporting on Sales Estimate volume, Order Entry metrics, and WHSE transfer volumes. Total dollar value drill-down into products, items, and line item detail. The presentation layer is Office Web Graph Component with click and drill interactions with live graph data. Full export capability to excel via custom VBA.NET interop procedures included data, graph, and format end products. -Cognos Business Intelligence Administration - the creation of data Cubes, reports, and queries based on SyteLine 7 ERP source data. Utilized Impromptu administrator to connect to multiple data sources. Isolated BI testing environment, as to not slow down production while in development mode. Documented existing BI reports, data, users, objects, and data delivery methods with a goal of developing a Data Delivery Methodology and Approach. -ASPX Web Shipping Summary and Inventory WHSE Reporting / Process Improvement – ETL’d disparate data from multiple scattered business processes into clear reportable Internet BI reporting, using TSQL in SSIS, SMS, and Transact SQL custom programming. Delivered the data to the user via ASP.NET custom web interface executing TSQL programming to deliver Crystal Reports in a Web IIS IE presentation layer, as output to Portable Document Format (PDF). Environment: COGNOS Impromptu – Administrator v7.1.339.0, PowerPlay – v7.1.341.2, PowerPlay Transformer v7.1
PowerPlay Connect – v27.20.1142.1, ERP SyteLine:SyteLine 7.04.02 Enterprise Resource Planning System
VBA – Microsoft Corporation – Visual Basic 6.3, Business Intelligence, MAPICS Business Intelligence v7.03
Product Configurator: SyteLine Config Manager v3.1, SyteLine Order Configuration, Selling Chain 3.1
PowerPack (Trilogy’s Power Pack), ModelManager – Frontstep, Inc. v4.1, Data Source Manager – v4.1.1.0
SC Config Manager, SC Config PowerPack Manager, SC Config UI Manager,
Connectivity:
Citrix MetaFrame – Program Neighborhood – Version 9.150.39151 (128-bit SSL)
Database: Microsoft SQL Server 2000 06/2006 – 9/2006 – Wells Fargo RFP Telephone Banking – Computer Task Group
Wells Fargo RFP - Pre Sales Technical Consultant - Internet Knowledge Base Business Process Improvement
Web Desing Search Engine Tuning – Pre-Sales Technical consulting Sales team conference calls with CTG and Wells Fargo. Talking points: -Calculate a price for the initial two week analysis on creating more robust metadata, for budgetary and timing purposes -Tune the search on specific content – Interview Wells Fargo stakeholders -Best practices - business taxonomy -Architecture and business process improvement phase. 05/2006 – 7/2006 – Merchants Mutual Insurance Group(MMIG) – Computer Task Group
Project Manager / Senior Software Technical Consultant – Reporting Self-Service Crystal.NET ETL Application
CTG sub-contracted Joe for a 2-3 week engagement scoped to create Crystal Report. Value added enhancements to the project utilize Microsoft Visual Studio 2003’s Visual Basic .NET programming environment to perform two independent programming tasks. The first is an Interactive Reporting Facility. This is a self-service model following the Service Oriented Architecture (SOA) design methodology, allowing for the end user to relieve Information Technology Group (ITG) resources from running requested reports. Exposed to a report library, the end-user can execute the program, pick a report, enter parameters, and generate the report. The document then can be sent via email, fax, or exported to the disk file system as any type of document supported in their environment, PDF being the document of choice. Other projects include a console application, scheduling and automating the creation, export, and electronic distribution of reporting documents in PDF format via email integration with the Lotus Notes Domino products suite. This scheduled functionality channeled reports into the existing Lotus report receiving hierarchy automatically generating Portable Document Format (PDF) documents, emailed to the recipient. With a VB.NET Graphic User Interface (GUI) the users could generate ‘on-demand’ reporting interacting with scan-store-retrieve work basket aging, Claims data, and underwriting information ETL’d to a Crystal.Net reporting tool. I conducted all phases of the Software Systems Life Cycle (SLC), meeting with Division VP to Analyst level resources in the requirements and definition phase. This assignment delivered complete Network Computing Installation documentation, facilitating a smooth transition to the production support team, including web setup and deployment packages. This application utilized XML configuration files specifying report distribution and email attributes.
Other projects included an RFP (Request For Proposal) intended to give an estimate of the time and materials needed to convert an Electronic Data Interchange (EDI) script application, written in KeyLink (BWC Systems) into a SQL Server X (any version) Data Transformation Service (DTS) enterprise solution. The SQL Server DTS environment will bring an automated centralized, easy to maintain solution, having the ability to be easily expanded to include any Agency Management System (AMS) and any ACORD message format. All program/script logic was to be upgraded to SQL ActiveX Scripting Language. Future enhancements/ upgrades can include the ability to create XML files and message transactions for every aspect of Merchant’s Business, from Property and Casualty to transmitting first notice of loss to an insurer.
Environment: IBM Content Manager, AS/400 (810 Server), Microsoft XP/Visual Studio 2003, VB.NET, Rumba, Novell, Crystal Reports 8.5-10, Crystal Interop .NET Framework Components, CrystalDecisions.Windows.Forms, ODBC 32 -DSN
5/2003 – 4/2006 –M & T Bank N.A. www.mandtbank.com –
Manager HRIS - Project Manager \ HRIS Manager \ Banking Officer \ Divisional Technology Queue Manager
Responsible for Human Resources Information Systems, managed the HRIS team responsible for Department architecture changes, Queue Management, and Production Reporting. While managing the implementation of an enterprise wide Applicant Tracking System RecruitMax (Vurv), negotiated the source OLAP database definition for a Cognos Reportnet reporting BI tool. Used in generating all data delivery needs from the system. Tested all application functionality, export, and import capability in Cognos Reportnet. Designed reporting library and intranet reporting through the Cognos Reportnet Tool. Architected the department and it’s technology into a Call Center/ Service Center model. I interacted with the major departments, implementing and facilitating all major projects, web electronic pay stubs from home, most recently. Upgraded Sybase 11.5 databases to SQL Server 2000 technologies with a database architect/ production maintenance scope. Maintained reporting in design, test, and production server isolated environment. Re-invented the HRIS product, changing my staff’s methodology toward tracking requests and developing systems to meet the technology needs of the HR division. As HRIS manager, responsible for upgrading old VB 6.0 and Sybase Database technology and databases to new Microsoft VB.NET GUI and SQL 2000 Database technology, implementing the XP migration for the Division, across the entire 14 state footprint of the bank. Management style was a Call Center / Service Center model, centralizing all major requests and tasks to my point staff or administrative staff. Departmental administrator kept meeting minutes, completed all meeting scheduling, and Technology Queue Tracking databases. Technical liaison to many major departments at the bank, including Corporate Services, Business Banking, Retail, Investment Banking, Trust, and Information Technology, to name a few. Technology spending and budgeting is an area, which I excel and enjoy. I train my junior level staff to provide a more technical role, allowing me to concentrate on the management issues, ‘the forest view’.
Environment: Microsoft XP/Office 2000/ Office 2003, Visual Basic DOT.NET, MS SQL 2000 Analysis Services, DTS, Novell, GroupWise, Peruses marketing survey software, GIS Mapping, VS Dot.Net 2003, 2005,Sybase 3/2003 – 5/2003 - GTOpenDatabase L.L.C. - Contract
Project Manager / Senior Principal Consultant/Architect- M&T Bank
After the Allfirst merger, M&T bank hired me as a project manager / solutions provider to fill a business need for a call tracking application. This application was to facilitate all inbound calls for the Human Resource Division. I managed and developed a project plan to upgrade an existing Oracle ASP solution to Visual Basic .Net Programming and Sybase database. My major tasks included engaging in Vice President level communication of software needs and functionality, communication of technical requirements to the Central Technology Division, and interacting with Database Services to stabilize the database environment. Later in my permanent career with the bank, I would be given the entire staff and department to manage. I completed this project in 30 days, under budget and ahead of schedule. Then added functionality and implemented the system and database on M&T's secure network, as a contract employee. Environment: Microsoft NT/Office 95/ MS Access 95, Visual Basic 7 DOT.NET, Sybase 11.5, Novell, Groupwise
01/2002 – 01/2003- GTOpenDatabase L.L.C.
Cendant Corporation – 9 West 57the St. NYC, NY –BI EIS OLAP Solutions Provider - Contract
Responsible for all phases of this BI project, architected the final OLAP drill-down solution for www.cendant.com . The team managed met with the CFO of Cendant IT, reviewing data delivery ETL needs and system feed negotiations. As a project manager responsible for building the initial team, including contracting outsourcing negotiations with the head of Microsoft consulting in NYC. Boutique services were sold to Cendant to track the financials of a computer-outsourcing contract. In EIS format, stop lighting presentation was used to deliver the overall health of Cendant’s business units in the Drill-Down Graph Interface. Vendor shopping and negotiations led to the initiation of engagements with 3 of the top companies in OLAP technologies, Cognos, ProClarity, TM1, Seagate Crystal, and Microsoft. As an MDX programmer coded EIS software in .NET. Designed and developed SQL 2000 Analysis services Cubes, dimensions, Cube Roles, and SQL 2000 databases. Coordinated the structure and design of the data feeds (DTS - ETL) from payroll, accounting, business lines, and finance.
- Designed and developed VB6 EIS and SQL 2000 Analysis services Cubes and SQL 2000 databases - Met with CFO /CEO level officials conducting rapid iterative design requirements gathering. Environment: Microsoft XP/Office XP, Visual Basic 6, MS SQL 2000 Analysis Services, DTS, Web Office Components
4/2001 – 6/2001 – Matrix Imaging Solutions, Inc. – 6341 Inducon Drive East, Sanborn NY 14132
Microsoft PDA Symbol PPT 2700 Imbedded Visual Basic 3.0 Programmer / PDA Inventory Software Demo
The logical principals of the Matrix Imaging -Inventory Picture System (MI-IPS) business model are simple. Combine a modular, scalable, and compact architecture with a short time to market and a low cost of entry. This corporate goal will be facilitated down to the programming of the functional business principles built into the Graphic User Interface (GUI). Most Inventory driven applications have one great deficiency, the user cannot see the item, which they are ordering or physically counting. Our Dynamic GUI (D-GUI) will overcome this obstacle allowing the customer to program the database with the categories, which divide the order entry items into logical divisions. The more categories the customer has, the more buttons show up on the screen. In most applications the screen must be programmed every time the customer changes the menu or any of its' structures. A scroll bar or keys are used to reach the buttons which might not be as popular and are ordered as such to display out of sight! This was all delivered to the SYMBOL PPT 2700 series hand held barcode device in real time over TCPIP wireless network protocols.
10/2000 – 1/2001 GTOpenDatabase L.L.C. – 90 Day Contract
DIEBOLD - Verdi & Company – Delivery Network & Distribution Planning
-Project Manager / SQL SERVER 7 Database Architect / Senior Banking Computer Consultant
I was a senior principal consultant, receiving Millions of records being prepared for house-holding geo-coding and geographic mapping with ARC view, responsible for reengineering and developing a SQL 2000 databases. Taking advantage of SQL SERVER 2000's strengths, I present high-level schematics and data flow diagrams to the CEO level executives of the company. This analysis was used to develop a growth and expansion plan for the company's database computer department. Our department was primarily responsible for creating and formatting data to present the information we process in GIS format, mapping the expansion and contraction of the accounts of large banking and financial institutions. Engaged in conducting quantitative analysis of expansion opportunities with in branch trade area networks. Most of our large clients are fortune 500 companies. Environment: Visual Basic 6.0, SQL SERVER 7.0, Centrus, ARC View Data Support, DCOM, VB6.0, ACCESS 2000 – Windows 95, Windows NT, GIS Mapping.
7/1999 – 1/2000 – rTheory.com Internet Startup Company – 370 Franklin St., Buffalo NY 14202
Microsoft Consultant Account Manager / Interactive Voice Response Programmer/ VB 5 Programmer
Help start-up a .com as the Microsoft resource in a UNIX / PERL programming environment. We created Visual Basic programs for a date matching service in VB. Developed a method of collecting information, allowing the complex algorithms to calculate the best match in a date matching service. Conducted training session events across the US and Canada.
Other projects included the creation of an Interactive Voice Response (IVR) System, receiving, routing, and matching phone connections in the scope of one-on-one chat sessions. Utilized PRONEXUS hardware MSI 240 Global (24 port) Switching & Conferencing Hardware, Dialogic Voice Cards, and Brooktrout Caller ID and T1 interface hardware, interlaced with Visual Basic Active X components from PRONEXUS development SDK.
10/1997 – 06/1999 - AJILON Systems
Project Manager / SQL SERVER 6.5 Architect - Outbound Shipping Consolidation and Receiving
I created a 58,000 line Graphic User Interface, interacting with a 80+ table SQL SERVER 6.5 master data warehouse. This was the solution to the Year 2000 problem for this company, migrating an old DOS program to 4GL programming languages and SQL SERVER 6.5. I wrote complex data base Stored Procedures to facilitate business process layers and business rules. My role remained that of project manager, as well as, software developer, network designer and SQL SERVER 6.5 DBA. -Shipping, Receiving, Distribution, Consolidation, Warehouse Inventory, and Billing functionality database DBA and developer -Complete database of tens of thousands of customer profiles centering on master index functionality and business rules -Automatic database interaction of many third party software packages, interlacing accounting, shipping, pricing, data storage -Database Architect realizing the CEO’s life long dream of how the data structures of his company should be normalized Environment: Visual Basic 6.0, SQL SERVER 6.5, Crystal Reports, and WISE – Windows 95, Windows NT
06/1997 – 10/1997– AJILON Systems – Project Manager / Data Migration Architect -Getinge / Castle Sales Order Entry; CPAS OE, Customer Pricing Agreement Software The application is a three module, multi-user order entry interface with nightly NOVEL network auto-load capability and administrator maintenance functions. Programming breakdown on the three modules is as follows: Consumer Pricing Agreement Software CPAS – (Administrator Module) 4,590 Lines of VB4.0 code, 438 Objects, 14 Screens Order Entry Module (CPAS OE) – 1,836 Lines of VB4.0 code, 102 Objects, 2 screens Network Auto-load Application – 378 Lines of VB4.0 code, 8 Objects, 1 screen Database Statistics – 21 Tables, 66 Queries, 264 Lines of SQL, 126,936 Records (rows)
Base Data Elements = total record count x the number of fields in the respective tables 2,786,850
This project was taken over from another firm that worked on it for one year and six months. It was completed in less than 60 business days, under budget and ahead of schedule. Environment: Visual Basic 4.0-5.0, MS ACCESS 7.0, Crystal Reports, and WISE - Windows 95, Novell Network.
03/1997 – 06/1997 – AJILON Systems
Project Manager / Dbase data-code Migration specialist - Work-In-Process Inventory Control Getinge / Castle
As a project manager / data-code conversion specialist, I translated a Dbase DOS system into Visual Basic 4.0, MSACCESS 7.0, and Crystal Reports. This project was challenging in that the physical inventory had to occur on a specific date. Completed within very aggressive time parameters, a fully functioning system was delivered ahead of time and under budget. Environment: Visual Basic 4.0-5.0, MS ACCESS 7.0, Crystal Reports, and WISE - Windows 95, Novell Network.
08/1996 – 03/1997– AJILON Systems
Blue Cross and Blue Shield; Finger Lakes Long Term Care - Project Leader / DataEase data migration specialist I coordinated the research for a proposal to convert an existing outdated 1.6 Million base data element DataEase system to Visual Basic 4.0, MSACCESS 2.0, and Crystal Reports. Completed all phases of the Systems Life Cycle: wrote, coded, tested, and have copies of this latest application in production in IA, MD, and NJ. Solely responsible for all executive level meetings and customer interaction, we used Rapid Iterative Systems Engineering (RISE) and Joint Application Development (JAD) methodologies, tracking the projects progression and managed over 15 direct BCBS - FLLTC customers. As a technical specialist, headed a team to various BCBS -FLLTC customer sights in the US installing the application and promoting customer relations.
Environment: Visual Basic 4.0, MS ACCESS 2.0, Crystal Reports, and WISE - Windows 3.11wkg, Win 95.
01/1996 – 08/1996– AJILON Systems
Xerox Corporation - ONCAT Sales/Marketing Computer Consultant / Software Developer
Held customer meetings, gathered requirements, and developed a task tracking system for ONCAT software. Raised this software to a release level of acceptance by repairing incomplete algorithms and equations, adding screen functionality, and fixing system crashes for this third party software. This stand alone windows application tracks printer sales and marketing statistics used for the Customer Engagement & Needs Analysis in the Sales Cycle. ONCAT is a complex statistical analysis, process flow, and reporting graph package. Environment: VB 3.0, 4.0 conversion, MS ACCESS 2.0, and Visual Basic for Applications (VBA) Windows 3.11wkg.
Xerox Corporation - Wireless Parts Locator; Computer Consultant / Software Developer
As a computer consultant; Systems Engineer/ Developer wrote, coded, and tested client software for a wireless remote inventory tracking system with Xerox network mobile mainframe screen scrape connectivity. All phases of the Software Systems Life Cycle were completed from requirements to testing. I facilitated meetings with clients demonstrating software capabilities. Wrote the entire C/S Client application in use today by Xerox Technical Representatives to receive mainframe date on their local PC. Finished the SLC by completing application development environment turnover to Xerox IMS production support personnel. Environment: Visual Basic 4.0, MS ACCESS 2.0, Crystal Reports, DOS 6.0, Chameleon TCPIP, and Windows 3.11wkg.
8/1994 – 1/1996 - EDS; Global Telecommunications Division AT&T Headquarters
AT&T Headquarters, Basking Ridge, NJ; Integrated Financial Tool - Team Leader / SE
As team leader was responsible for the product team at AT&T Headquarters financial division of IFT. Held meetings with several department heads and product managers daily to solve development and production issues. Coded, developed, tested, and implemented a C\S multidimensional reporting solution creating over 10,000-income statement reports. Negotiated multiple feeds from BUFR (Business Unit Financial Reporting) mainframe IMS and various supplier sources via LAN/WAN. Established and configured the servers to allow network connectivity that spanned over 20 states to access the reporting system via existing X.24, satellite, and LAN/WAN connectivity. Coded an income statement mapping procedure, compiling keys from raw data. Developed the interface to the reporting facility, EIS, and eight dimensional table and reports, in TM1 Perspectives, an OLAP/MDD analytical database engine that runs as an add on to Excel. Environment: VB 4.0, MS ACCESS 2.0, OLAP MDD, VBA, Hypertext, DOS 6.0, Chameleon TCPIP, and Windows 3.11wkg
9/1995 - Special Assignment- EDS; Global Telecommunications Division
AT&T Residence Interface Processing Systems Proposal; - Technical Report Writer
Conducted executive division level meetings to write a request for proposal for the Residence Interface Processing System (RIPS). Researched statistical information and compiled technical documentation projecting labor costs by geographical location. Attended redline meetings with the top executives responsible for the implementation of the final project and contract finalization.
7/1995 - Special Assignment - EDS; Global Telecommunications Division
Business Network Sales, Integrated Sales Tool - Technical Report Writer
Wrote the business design of a laptop based PC tool. Completed the proposal portions of the EDS Consulting Business Information Planning methodology (Business Direction and Operations) as well as the SLC Definition, Analysis, Business Design and an Implementation Planning Phase.
05/1994 – 08/1994
EDS Procedural Approach Using C Technical Client/Server Training;
Southfield, MI - Technical Associate
500 hours of Client/Server UNIX Training: RISE/JAD GUI Dynamic Memory Allocation Human Computer Interaction Concepts SQL Using Sybase File I/O Logical Tables SLC Definition and Analysis Deliverables C Programming dbXtra Advanced Pointers Hypermedia Approach and Future Trends Data Models Visual Basic Multimedia Approach Software Design for Applications Structures/Unions Terminal I/O Interactive Programming Advanced Structure Charts/Pseudo Code Link List Programming Embedding SQL Dynamic Link Lists (DLL) HMO Referral System Development and Implementation Simulation - Visual Basic RISE & JAD Environment: C, Visual Basic 3.0, Sybase, UNIX, and SCO
05/1994 - Special Assignment - EDS; Global Telecommunications Division AT&T / McCaw Law Research Tracking - Database Designer Using Microsoft Access 1.0 developed and maintained a database of AT&T and McCaw executives to store information for use by the legal departments in the merger transaction proposals.
08/1993 – 05/1994 - EDS; Global Telecommunications Division AT&T Business Carrier Selection Management (BCSM) - Production Management Support Coordinator Scheduling a team of four BA's for RJE duty, worked in MVS/COBOL shop supporting a team of six SE's on an account with 90 personnel responsible for the entire database of AT&T Business Telephone Numbers for the USA and surrounding territories. Responsible for tracking NDM data for all Local Exchange Carriers (LECs) in the USA and territories directly related to AT&T revenue via LAN/WAN connection to CHIPC1B by TSO. Heavy system change negotiations (CHAMP) and requirements based telephone correspondence. I was responsible for AT&T national contacts Call Tracking Form (CTF) Routing & Address File Updates for the US and Puerto Rico. Designed and implemented print cost savings programs to reduce printer volume and eliminate waste. Pic Processing - Results Tracking - Marketing Support - Release Coordination - Cycle Monitor Environment: MVS COBOL2, UNIX, DOS, IPC, NDM, CHAMP, Micro Focus COBOL, Structure Charts, and Pseudo Code
04/1993 – 08/1993 - EDS; Global Telecommunications Division EDS - Analysis Support Coordinator Administrator for the PC based Analysis Database and the Analysis Actuals vs Estimates Database. Responsible for the maintenance of the time tracking and reporting systems, created reports and graphics for project managers by time tracking actual vs estimated hours based efficiency. Environment: MVS COBOL2, TSO, UNIX, DOS, IPC, NDM, CHAMP, Micro Focus COBOL, Structure Charts, and Pseudo Code
