Erp Software Manager Resume Profile
OBJECTIVE
To be successful and maintain an expert level of technical and personal skills while leveraging many years of experience programming OLTP and OLAP business systems, having the ability to share that knowledge in the process of architecting and implementing enterprise business solutions.
GOALS
To maintain the highest level of technical competence while keeping current with the evolution of technology in the mainstream business computing market. Contributing directly to the line of business for companies using the latest Microsoft Business Solutions tools and products such as Dynamics AX, NAV, .Net, SQL Server, SharePoint Server and Biz-Talk Server.
WORK EXPERIENCE NARRATIVE
- My Information Technology career began in 1993 designing and implementing local area networks for small businesses in Portland Oregon. It became clear that Information Technology was the passion I was looking for in my career. Eventually I moved into automated software testing and the natural progression for me was towards web and windows software development, relational database management systems,ERP systems and business intelligence solutions.
- After consulting and building a broad array of experience in a variety of technical disciplines I settled in as the lead developer for Monaco Coach Corporation and was promoted to Enterprise Applications Architect shortly afterwards. I was responsible for defining the technical architecture of all corporate internal and external web and windows applications including ERP, B2B, EDI, third party applications and custom applications developed in house. My responsibilities included evaluating third partysoftware solutions, providing cost benefit analysis and verifying technical interoperability with existing systems. It was my responsibility to define projects, set timelines anticipate and assign resources as well as coordinate resources both internal and external to the organization.I was responsible for the design and architecture of enterprise applications and data interfaces between internal information systems and business partner systems through a broad spectrum of protocols and specialized technologies.
- More recently at ManageForce I've been focused on managing teams of on and off shore developers to provide service centric offerings to customers including developing custom SharePoint applications, Business Intelligence solutions using SQL Server and MicroStrategy, Web and Windows development using Entity Framework, MVC, Microsoft Visual Studio.Net. In addition to that I'm also providing ERP management services for Microsoft Dynamics Navision and AX customers.
WORK EXPERIENCE
Confidential
Information Technology Consultant
- Created sales/production analysis dashboards on the iPad using MicroStrategy for a large global manufacturing company used by members of the executive branch down to the shop floor.
- Responsible for all aspects of MicroStrategy Business Intelligence platform installation/configuration/development for ManageForce clients.
- o Architect duties included gathering user requirements, designing data flows and data structures, and developing all reporting objects to support user requirements
- o Plan and execute upgrade of MicroStrategy software.
- o Projects involved sourcing data from Dynamics AX, SAP, JD Edwards and other custom transaction schemas
- o Projects utilized the following MicroStrategy features extensively: drill templates, dashboard documents, dynamic/multi-level prompting, complex filters and metrics, custom groups, thresholds and alerts
- o Projects entailed the sourcing, dimensional modeling, ETL of sales, inventory, financial, purchasing, manufacturing and pricing data from various disparate transaction systems into enterprise data warehouse.
- Responsible for analysis and documentation of business processes, developed software development lifecycle list and document templates for SharePoint 2010.
- Created custom SharePoint 2010 applications using event receivers, web parts, timer jobs, power shell scripting, content types, external content types, InfoPath consuming WCF, REST services.
- Ported Classic ASP applications to ASP.Net MVC3 C with Entity Framework using LINK, JQuery and CSS.
- Responsible for providing Microsoft SQL Server database administration services to ManageForce clients, including troubleshooting and performance tuning, scheduled and unscheduled maintenance.
Confidential
ERP Software Manager
- Responsible for management of Microsoft Dynamics Navision ERP system, including documentation, customization, maintenance and upgrades.
- Implemented SharePoint 2007, created documentation templates and document libraries for creating and managing enterprise business process.
- Created change management process in SharePoint to document and track ERP issues from detection through to completion and implementation in the live ERP system.
- Coordinated and managed MBS vendor relationship to support enhancements and upgrades to Dynamics NAV ERP system.
Confidential
Enterprise Applications Architect
- Technical lead for Microsoft.Net based windows, web applications and distributed application framework components such as web services and IIS hosted components.
- Database administration duties include, design hardware configuration for optimum database I/O. Query profiling and tuning for optimal query execution and application performance. Creation of maintenance and disaster recovery planning for 50 SQL 2000 and 2005 database servers.
- Lead migration from SharePoint 2003 to MOSS 2007 for corporate Intranet portal. Created SOX compliant approval process workflow to automate development/documentation change control process using InfoPath and MOSS 2007.
- Implemented OO distributed application standards for enterprise business applications usingCSLA object framework and Visual Studio.NET 2003 Enterprise Architect.
- Designed and developed custom CRM using ASP.NET, VB.NET and CSLA for 250 user call center.
- Designed and developedASP.Net applications and reporting infrastructureused to manage compliance and report data for the National Highway Traffic Safety Administration's Transportation Recall Enhancement, Accountability, and Documentation Act.
- Designed and developed a mapping and routing system for finding Monaco Coach dealers and service centers using MapPoint.Net web service.
- Designed and developed an ad-hoc query designer tool for graphically creating reports using OO methodology with XML object persistence in enterprise storage systems to share reports with other users, as well as provide security mechanisms to prevent unauthorized access to sensitive data.
- Responsible for the creation of various interfaces between business partners for exchanging financial, customer and product information using standard EDI, web services, FILE, SQL, HTTP and SOAP interfaces..
- Designed and architected EDW using Star/Snowflake schema design principles for subject specific data marts including ETL processes using T-SQL, DTS and SSIS,developedincremental synchronization processes from Oracle to SQL Server.
- Lead migration of enterprise reporting infrastructure from Cognos, MS Reporting Services to MicroStrategy acted as project designer/architect role.
- Create and maintain enterprise reportsusing MS Reporting Services, designed and developed MS OLAP and Cognos analysis cubes.
- Planned and executed the migration of enterprise CrystalReportsto MS Reporting Services.
- Assisted in the definition and implementation ofstandard development processes, procedures as well asdocumented and implemented development guidelines and coding standards.
- Assisted in the implementation of PeopleSoft/JD Edwards, created enterprise application interfaces to enable interoperability between JDE and legacy ERP systems, created JDE reports, enhanced stock JDE interactiveapplications.
Confidential
Visual Basic.Net Programmer
- Developed object oriented middle tier and web based front end for commercialproperty management application using Visual Studio.Net, Visual Basic.Net, ASP.Net, C , SQL Server 2000 on Windows 2000 and Windows XP.
- Designed and administered internally developed and third party SQL Server 2000 databases.
- Designed and developed packaged Data Transformation Services in a cross platform RDBMS environment i.e. Oracle and SQL Server.
- Designed and developed high performance image processing component written in C that's used to display check images read from extremely large TIFF image librariesfor Northwest FCU.
Confidential
Visual Basic 6.0 Programmer
- Assisted in the development of Visual Basic 6.0 COM business objects to be used in the next release of ADP's Dealer Services application which runs on IIS, MTS and ASP environment.
- Responsible for writing component design specifications, modeling SQL 7.0 database schema, writing stored procedures, research and develop templates for business objects for coding business logic, writing custom methods, and enforcing transaction requirements.
Confidential
Applications Developer
- Responsiblefor development, production and maintenance of corporate Intranetapplications based onn-tier design principles using Windows NT 4.0,VB 6.0 MTS components, IIS,ASP front end, and SQL 7.0 RDMS. This configuration was used in all corporate applications. All applications were written to support both PC and MAC Internet Explorer clients. Several applications developed employed this architectureincluding an application used for managing and reporting installation schedules, hardware and software configurations, support issues and other items relating to the installation and support of the Macro System Accessorizor.
- Designed and developed a custom B2B application which allowed vendors secure access to connect to and modify catalog data via an extranet user interface. Modified catalog information is temporarily stored pending review by data technicians using a separate Intranet accessible user interface. These changes can be previewed and confirmed and once confirmed can be finally be merged into the master database.
- Designed and developed an Intranet application responsible for the production of data and images required by the Macro System Accessorizor. The application enforced image processing workflow and data integration for studio, graphics and data departments as well as provided source control, and file management for production image libraries. The components were created using Visual Basic 6.0, the data components run under MTS and are fully transactional. All data components use a standard method of passing and retrieving data and the shape of the data is generated from database schema this allows the data accessed by the middle tier to evolve with the application providing a component model that requires new versions only if business rules or other internal logic changes.
- Other components that were used in the application framework provide asynchronous file operations, messaging, exporting data to Excel, a component that generates a DHTML data grid view to navigate and perform customizable data operations, a component that generates a DHTML calendar and has customizable actions with event handlers and many other components that are used in the framework.
Confidential
Web Application Developer
- Designed and developed Microsoft Transaction Server components with Visual Basic version 5.0 for use on Intranet and Internet applications.
- Responsible for migration of public Internet applications including Offices, Quick Zip, Employment, Tracking and web based email from Unix/Oracle/PL-SQL/PERL to NT4.0/IIS 4.0/MTS/ASP.
- Maintained and upgraded corporate Intranet applications including ISO9002 tracking and reporting.
- Maintenance of Panagon Document Management system, Employee Idea Program, MAPI compliant email, and other internal and external web applications.
- Developed new and revised existing Visual Basic 5.0 components for use on corporate MTS servers. Developed web components with custom COM interfaces designed to run under MTS and interact with corporate data stores including MS SQL Server, Oracle, and legacy COM proxies.
- Developed Truck Driver/Pager tracking application with Visual Basic 5.0 that maintains and updates a static list of truck drivers and notifies users after a given interval has elapsed after paging the driver.
Confidential
Web application developer, VB 5.0 Programmer
- Completed the development of a multi-tier client/server application that using custom Visual Basic 5.0 COM components which provided transactional data access to the application layer. Used third party components such as ASP Mail for email auto-responses, Authent-X for managing and authenticating users. Application was written to support Internet Explorer and Netscape. The web application a shopping cart/mall application is data driven and uses ASP, ADO, VBScript, JavaScript, SQL and HTML to provide all of the functionality. Some of the primary features include allowing shop managers user-level access to there shop admin pages to manage product and customer databases, generate reports, view site statistics modify style sheet for shop to change the look and feel of there site. Visual InterDev was used for off-site application development the server platform was NT 4.0 Enterprise with IIS 4.0.
Confidential
Microsoft Office 97 Migration
- Contracted to Standard Insurance Company for Conversion of WordPerfect 6.1 mail merge loan documents for forty-one states to Microsoft Word 97.
- Also incorporated a single point of entry interface consisting of a table containing the states serviced with hyper-links to master documents containing a subdocument for each loan document required by that particular state. Attached to each state master document, is a state specific template that contains custom styles and macros required by that state. The design approach used here greatly increases the productivity of the user by enabling them to merge all loan documents for a specific state in a single instance. The user can also make global formatting changes to all documents contained in the state master by updating the modified style in the attached state template.
Confidential
QA Engineer
- Design write test plan's, matrices, test cases, automated scripts, for Intel's LAN Desk Personal Conference Manager, Pro Share v3.0 Video Conferencing Software using MS Visual Test 4.0 for distributed network testing and remote management of workstations.
- Administer, design, and maintain project information web site using Microsoft's Windows NT Server 4.0, Front Page 97, IIS 3.0, Active-X Control pad, dbWeb, and VB Script.
Confidential
Database Administration
- Administer 6 SQL server 6.5 databases, including backups, replication and batch processing.
- Maintain bug-tracking databases for other Intel products such as Storage Express, Net port Print Servers, Ether Express Switches, ATM and other Intel proprietary products from the Software Evaluation Team.
- Satisfy testing requirements for the Software Evaluation and Test team including the purchase and procurement of hardware and software.
Confidential
Network Administrator/Technician
Assemble, upgrade, repair, and configure X86 machines and peripheral devices for turnkey client/server solutions. Install, configure network hardware including Cisco IOS for the 2500 series Cisco Pro routers, CSU/DSU, and RAS devices, Install, configure Windows NT 3.51, 4.0. Install, configure RAS, SMTP, WWW, FTP, DNS, SQL, DHCP and other NT services. Configure NT 4.0 as a RIP router. Administer NT User/Domain accounts and inter-domain trust relationships. Install, configure Windows 95, WFW 3.11, and NT workstations to participate in and access domain resources. Install configure Microsoft and NetWare clients to access Novell resources.
Confidential
Automated Data Processing Security Officer
- Assisted in maintaining and administrating a 122 node BNC/UTP/TOKEN Novell 3.12 LAN. AT T 3B2, ACCESS 32 terminal mainframe.
- Implemented asset tracking program, maintained inventory, maintained user accounts, upgraded and repaired IS equipment.
Confidential
Aviation Structural Mechanic Second Class E5
- Duties included supervision of mid-check work center, ensuring timely completion of daily, preflight, post flight inspections, scheduled and unscheduled maintenance of all squadron aircraft which included 8 F/A-18, 2 AV-8B, 2 EA-6B, 4 A-6E 2 AH-1J.
- Quality Assurance inspector for all squadron aircraft.
SKILLS
Skill | Skill Level | Last Used/Experience |
VB.NET | Expert | Currently used/8 years |
ASP.NET | Expert | Currently used/8 years |
C | Intermediate | Currently used/6 years |
X | Intermediate | Currently used/1years |
C/SIDE NAV | Intermediate | Currently used/3 years |
Object Oriented Design | Expert | Currently used/10 years |
SharePoint 2010 | Expert | Currently used/3 years |
MOSS 2007/WSS 3.0 | Intermediate/Expert | Currently used/3 years |
Share Point Server 2003/WSS 2.0 | Expert | Currently used/5 years |
Content Management Server 2002 | Intermediate | Last Year/2 years |
DBA SQL Server 7.0/2000/2005/2008 | Expert | Currently used/12 years |
Modeling Relational/Dimensional | Expert | Currently used/12 years |
T-SQL | Expert | Currently used/12 years |
Data Integration/Migration | Expert | Currently used/8 years |
XML | Expert | Currently used/6 years |
MS Analysis Server 2000/2005 | Intermediate | Currently used/4 years |
BizTalk Server 2004/2006 | Intermediate | Currently used/3 years |
Commerce Server 2002 | Intermediate | 3 Months ago/3 years |
Active Server Pages | Expert | Last Week/9 years |
JavaScript/CSS | Expert | Currently used/9 years |
DHTML | Expert | Currently used/8 years |
VBScript | Expert | Currently used/9 years |
Visual Basic | Expert | 2 years ago/10 years |
JD Edwards Report/Application Dev. | Intermediate | Last Year/5 years |
Internet Protocols | Intermediate | Currently used/8 years |
Project Management | Intermediate | Currently used/6 years |
MicroStrategy Project Designer | Expert | Currently used/3 years |
MicroStrategy Report Developer | Expert | Currently used/3 years |
Analyze Business Requirements | Intermediate | Currently used/12 years |
Oracle PL/SQL | Intermediate | Currently used/3 years |
MS Reporting Services | Expert | Currently used/4 years |