Project Manager Sql Server
Resume:
***.**.******@*****.***
Business Analyst and Project Manager with over 18 years experience leading strategic initiatives that integrate data analytics and software applications to optimize workflow, sales, marketing and business productivity.
Working with clients/stakeholders to identify key business problems and workflow issues to determine the data requirements for developing a system architect that is efficient and achieves business goals.
Lead successful new application development projects with over 99% up-time on the final product.
The creative ability to suggest solutions and achieve customer collaboration on the product functionality and workflow processes to build their acceptance and involvement in the final product.
Exceptional assessment background in the analysis of business processes, potential functionality and the data integration necessary to achieve their goals. This resulted in a high level of user acceptance.
The technical skill to design and enhance applications that integrate existing data systems and legacy applications with enhanced user functionality, optimization and technology.
Process detail orientation to prioritize; set task schedules; work through problems, negotiate potential solutions, adjust workflow processes; test releases and bring the product online and on time.
Communication skills to work with cross-functional teams from management to end-users, and from Marketing to IT to promote the project success.
Lexnet Consulting, Inc. - Louisville, CO 1992 – April 2012
President
Lexnet designed, planned, coded and implemented customer-specific software enhancements to existing programs, business processes and legacy applications using VB.Net, MS Office, Visio and SQL Server. The company also developed new web-based, SaaS and intranet software applications. Lexnet managed projects including data architecture, project tasks, workflow processes, revisions, documentation, definition of challenges and solution options for problem resolution. Lexnet’s client verticals include Higher Education, Finance, Insurance and Automation.
Partial Project List
University of Colorado Denver
Web-based Early Alert System for Student Retention, 2005-present
Project Manager: Design and development of a web-based application project for University employees to increase student persistence and retention. Tasks included business development, application development, departmental client meetings, design documents, FERPA security analysis, testing, implementation and support. SQL Server Reporting system; Data analytics and performance metrics.
Managed delivery of new releases with enhanced functionality to add roles and capabilities for second-tier student support offices.
Forrest T. Jones Insurance Company - Kansas City, MO 1994-present
Developed an Expense Allocation System for multiple companies and business units. Improved payment processing by integrating client-defined requirements into existing processing application. Scope included application design, development, testing, revisions, implementation and support. The application forms integrate with multiple SQL/Oracle databases and views. The system integration included the following:
Validate and manage controls (10 levels) on funds per business unit Electronic General Ledger interface and update
Designed and built a reporting system with filtering
Cash Disbursement System – Designed and managed the development of an intranet application to interface with multiple insurance systems on the AS/400; Genelco- IBM Mainframe and network. The application encompassed checks for explanation of benefit claims, statement of benefits, annuity, pre-treatment and refund products. Managed programming team (SQL Server; Visual Studio; T-SQL) and system integration including:
The system has both demand checks and batch file capabilities
Automated General Ledger interface to update GL accounts for multiple companies
Manual data entry screens; Reporting System on all disbursements, users and logging
Check Printing - Project to process data and convert from centralized Xerox (LCDS) lasers to network lasers. Design and implementation of electronic forms with variable data; Option for electronic bank interface (positive pay)
University of Colorado Boulder 2007-2008
Colorado State Residency Application (in-state tuition qualification) Migrate paper application to web-application; design, code and build an online petition and petition management system. The system has online modules for students and parents; validation and verification of state requirements; Managed the project, programming team, testing and implementation. Reporting system for staff. Audit and appeals; Secure Online Document submittal for applicant. Option to save and return to application.
Express Scripts, Inc. - St. Louis Mo, / Philadelphia, PA 2008-2009
High volume, automated prescription filling production line automation for 5 mail order pharmacies. Designed and jointly developed dynamic, in-line high volume data integration with company systems; implemented application integration and communication system with production automation equipment.
Automated Literature integration with variable data– Invoices, Prescription precautions, refill/renewal labels, claimant information.
Morris County, Morristown, NJ 2005, 2009-2010
Accounting system migration
Check Printing – built AS/400 to network interface to pre-process accounts payable and payroll check for Genesys and Lawson system for all county agencies; Electronic forms, union payroll, security controls for signatures, funds and checks. (similar experience-dozens of companies)
Align Technology (Invisalign)/ Maverick enterprises – San Jose, CA 2008-2009
High Volume Product production line automation - Managed and designed the integration of SQL server data integration (embedded) of transactional data with factory floor production equipment, bag/barcode printers and laser printers. Designed and coded dynamic ZPL Bag printing system with user controlled application system to manage formatting and control automated literature integration.
Built the database requests and integration of variable data for a dynamic factory product labels, packaging, shipping
Coordinated with the marketing department to translate corporate branding to integrate with automation equipment
Express Scripts, Inc. - Phoenix, AZ 2004 -2010
Mail Order Pharmacy Automation - Implementation, document design and printing for a high volume automation project of prescription print packets and labels. Managed a project to convert from a centralized print operation to an in-line, fully redundant, factory floor production model. Built the database requests and integration of variable data for invoices, NDC, claimant information, reorders.
State of Colorado – Denver Co 2005-2006
Unemployment, Tax and Benefit system
Designed and managed the electronic form/data integration for Electronic Benefit and Tax Documents based on user requirements and government needs. Built application and database to pull field data and format structure per form. Tested the data integration with state benefit system.
Design a user interface to define document formats, variable data and database integration from benefits system; System print automation
Pepperdine University, Malibu, CA - Master of Business Administration
Edinboro University of Pennsylvania, Edinboro, PA – Bachelor of Fine Arts
Proficiency: MS Office, MS Project, MS Visio, MS-SQL queries, budgeting, marketing, sales, Software Development Lifecycle (SDLC) methodology
Familiarity: Genesys, Genelco, Lawson, Great Plains, Kronos, Xerox LCDS, Agile techniques, ZPL, JIRA, FERPA, HIPAA, SQL Server; C#; SQL Scripting, Visual SourceSafe, SGHE Banner, ISIS, Campus Solutions & Colleague (Datatel) Student information systems.
Contact this candidate