SUMMARY

A highly resourceful, flexible, innovative, and enthusiastic individual who has a solid history of delivering highly successful technology solutions. A quick learner who loves to constantly expand technical knowledge and skills. Naturally has a synthesizing mindset , able to see all facets of a problem and break it down logically. Enjoys participating fully in all phases of the project, from initial problem definition and analysis, through design and coding, all the way to deployment and user training.

WORK EXPERIENCE

• Achieved what was said couldn't be done within the organization. For the first time figured out a way to link before and after survey questions linked learning to enable reporting of statistically significant learning results. This opened up an entirely new product line which earned an additional 10 million in its first year and 60 million by its third. Automation of the client reporting products saved hundreds of man-hours and paved the way for more and more processes to be brought in-house saving hundreds of thousands of dollars.
• Conceived, designed and created entirely new system to import and parse website traffic data to create client-ready, statistically-rich reports for learning assessment in online education activities resulting in additional 10 million revenue in its first year
• Designed, coded and automated high-quality, versatile outputs using MS-Access, Outlook, Word, Powerpoint, Excel, XML, HTML, XPS, Sharepoint and other formats saving hundreds of man-hours
• Analyzed, developed and managed project start-to-finish-to-support. Worked closely with all stakeholders, used creativity to design and automate entirely new processes, trained all end-users
• Designed and built project tracking databases for Education and Promotional departments to organize thousands of internal projects including project templates, resource and time management, and budgeting modules
• For Strategic Marketing department replaced cumbersome Excel-based traffic data analysis spreadsheets with flexible and easy-to-use database solution
• Conceived and created proof-of-concept system to organize entire database of website content history into a searchable library schema paving the way for internal users to have direct access to content and traffic summation data without having to go through BI department
• Performed system demonstrations, installed and trained all end-users, and continually available for any troubleshooting including data analysis and writing workarounds for non-compliant data
• Independent Business Analyst/Consultant/Developer Confidential
• Using SQL relational database tools, analyzed business needs, lead clients though project lifecycle developing highly successful solutions. One client recommended me to the next. Clients/Projects included:

Confidential

• Designed and built complete departmental database systems for the following departments: Registration, Bursars, Alumni, Housing, and Continuing Medical Education all systems using rapid application development met and exceeded user expectations one department recommended me to the next
• For the first time integrated previously separate functions of course registration, course preparation, course attendance and course financials into one seamless system
• Assisted with web interface for first online student registration capability including automatic email confirmations
• Created ancillary systems to monitor jointly sponsored programs, in-house and correspondent physician educational programs including all financials, participation and credits issued ensuring that all data points are inter-compatible and AACME compliant
• Met with all stakeholders, gathered system requirements and established ongoing communication channels to encourage individual participation and trust in the creative development process
• Available as needed for ongoing maintenance, upgrades, or any additional desired capabilities

Confidential

• Developed complete SQL Server/MS-Access reporting system for busy importer/distributor millions of records with automatic emailing, printing, and user interface
• Developed data extraction, analysis and SQL Server relationship model out of hundreds of legacy Foxpro data files
• Monthly inventory pricing and publishing module for 11 states

Confidential

• Served as team lead on a five-module global Y2K project for corporate HQ on Wall Street.
• Oversaw security, data mapping, and rollout for European, Asian, and domestic user training and product assessment demonstrations
• Trained staff in MS Access and served as technical expert on all in-house Access projects

Confidential

• Designed, developed, and maintained a five-module budget/planning system for the North American Region
• Created query and reporting system interface for GL data dump to Sybase

Confidential

• Served as senior consultant to optimize and redesign an existing, cumbersome structure
• Changed thinking of senior management including the originator of original system to apply new technology. Resulted in successful data optimization from 200 tables to 50 tables

Confidential

• Brought order to the process of licensing of agents. Analyzed existing processes and identified gaps where legal compliance issues may occur. Designed and developed entirely new system which automated and greatly simplified keeping agents' licenses up-to-date. Solved in just 3 months what had been a vexing and expensive liability problem for the company
• Responsible for improving the process tracking of licensing of agents and compliance to State licensing requirements
• Analyzed existing processes and data flows to identify bottlenecks and inefficiencies
• Created consolidated database system and improved processes for busy Sales Operations Department

Confidential

• Discovered talents for database design when developed automated tool for billing of clients in technology product based on utility usage. Promoted to 3-member team that built from scratch new global billing system for portfolio clients. Filled the gap as needed between heads-down coder and business analyst, including:
• System look and feel front-end and output design
• Data analysis, mapping, cleansing, and transfer
• System demonstrations and end-user trainings