## BIO
SUMMARY OF QUALIFICATIONS Solution oriented Programmer Analyst with notable success in developing custom software solutions for a broad range of corporate initiatives while participating in all phases of the product development lifecycle in direct support of business objects. Ø Track record of increasing responsibility in software design, systems analysis/development and full lifecycle project management. Ø Demonstrated capacity to implement innovative, dynamic software solutions that meet all functionality requirements as identified during the requirements phase of the development process. Ø Adept at developing effective, dynamic solutions that meets the current budget and technical limitations; but designed in such a way that provides the means of easy transition to other technologies. Ø Hands-on experience leading all phases of software development efforts, including requirements, definition, design, development, testing and implementation. CORE COMPENTENCIES • Data Warehousing • Data Cleansing • Software Analysis & Design • Project Management • Database Design & Development • Process Automation • Dynamic Solution Design • Problem Resolution • Prototyping • Software Development Lifecycle • Administrative Support • User/Technical Documentation TECHNICAL SUMMARY Platforms: Windows 95/98/NT/2000/XP, MS DOS, Novell Languages: Visual Basic 6, Visual Basic for Applications, SQL, HTML, Active Server Pages, VBScript, Javascript, XML, ActiveX, COM, COBOL, JCL, Easytrieve, DB2, CICS Databases: MS Access, Oracle, SQL Server, Informix Hardware: IBM PC and Compatibles, IBM Mainframe Software: MS Office Suite, MS Visual Studio, Crystal Reports, SourceSafe, Procomm Plus, Enterprise Manager, Query Analyzer, MS Frontpage 2000, Dreamweaver, Elite Enterprise PROFESSIONAL EXPERIENCE 3/2003 – Present Senior Programmer Analyst Recruited to design and develop dynamic software solutions that focus on effective resource utilization and profitability. Manage the requirements phase of the product lifecycle to ensure all functionality requirements are incorporated into solution design and development. Perform analysis on existing software applications to identify areas for increased functionality and marketability. Technologies: Visual Basic 6, Crystal Reports, SQL Server 2000, Informix, MS Access, Excel VBA, MS Visual Studio, SQL, Stored Procedures, HTML, ASP, XML, ActiveX Key Contributions: * Developed highly effective data warehouse and reporting engine application for timekeeper Productivity. * Instrumental in developing and implementing software solution for managing the allocation of firm income and the requested drawings and charges for amounts paid on the behalf of individual Partners. * Increased the flexibility and stability of 4 software solutions by replacing processes originally included in the application source code with stored procedures and triggers; decreased the required processing time by approximately 15%. * Designed and created template designer and loader application for defining the layout of files in any format and dynamically loading the files into a data warehouse. * Provided clients with user and technical documentation and conducted onsite software training. * Exceeded monthly billing goals by an average of 15%. 11/2002 – 3/2003 Consultant Provided Visual Basic for Applications solutions within the SAP environment. Provided expertise on the capabilities and limitations associated with automation utilizing existing technologies. Technologies: Visual Basic 6, SQL Server 2000, MS Access, Excel VBA, MS Visual Studio, SQL Key Contributions: * Developed dynamic user front-end data retrieval and reporting. * Developed SEM-BPS planning layouts and functional templates with Excel VBA and Access. * Increased productivity by 40% by automating several manual processes. 8/2002 – 10/2002 Consultant Designed custom software solution that provided financial analysts with the ability to generate reports using various parameter levels, including any combination of line of business, sub-line of business or unit, selected by the user. Technologies: MS Access, Excel VBA, Crystal Reports, SQL Key Contributions: * Provided the financial analysts with the ability to make further parameter adjustments on an individual employee basis after the reports have been generated. * Fully functional software solution designed and developed 20% below allocated budget. 6/2001 – 7/2002 Consultant Designed and developed custom software solution for processing weekly, monthly and quarterly pharmaceutical data. Replaced existing Excel-macro driven application with a multi-user, network supported Visual Basic alternative that dynamically built MS Access databases during program execution. Technologies: Visual Basic 6, MS Access, Excel VBA, SQL, ActiveX Key Contributions: * Increased data accuracy by 50% to 75% by providing robust data integrity checking. * Automated software to load over one million records each month requiring no human intervention. * Facilitated initial requirements meetings with several clients to ensure all functionality and system requirements were identified and incorporated into design specifications.. 3/2000 - 6/2001 Senior Application Developer Promoted to lead small development groups and mentor junior programmers. Supervised release testing for all software applications, providing final approval for bug-free, fully functional department-level software solutions. Participated in staff recruitment, resource allocation and employee assessment functions. Created development plans, project documentation and test cases. Managed all phases of product lifecycle development. Technologies: Visual Basic 6, SQL Server, MS Access, Crystal Reports, Excel VBA, SQL, ActiveX Key Contributions: * Reduced the amount of repeated debugging and testing by 15% by creating policies and procedures for functionality and usability testing. * Replaced ad-hoc reporting practices with a centralized reporting engine consisting of over 50 daily, weekly and monthly department-level reports. * Designed a forecasting and analysis call center solution that provided management with a tool for forecasting call volume, FTE requirements and costs. * Performed analysis of 10 MS Access databases and identified numerous data abnormalities; Designed multi-user data warehouse application to replace existing applications to ensure better consistency and data integrity. 8/1998 - 3/2000 Application Developer Promoted to design and develop software solutions in a Windows environment. Managed communication efforts between mainframe programmers and IT department for software conversions involving the replication of mainframe applications into a Windows-based environment. Technologies: Visual Basic 6, SQL Serv