• Provide technical solutions and support to project teams, facilitating project progress through the development of technical solutions for long-term projects using a full understanding of the system development life cycle to design and develop technology specifications and solutions presented as part of the project team.• Provide all QA/QC on all works produced to assure compliance, functionality and accuracy of client/company requirements. • Deployment of all application and database builds to staging and production environments.• Hired and sustained positive working relationships with a staff of six outsourced personnel, coordinating project requirements and resources to align with project scope and specifications while reducing costs associated with hiring full-time staff while maintaining a history of delivering projects ahead of schedule.• Develop database solutions and business processes used throughout the project life cycle, providing data storage to meet the continuous increase in storage needs, task automation, and process streamlining.• Develop and maintain SSIS, SSAS and actionable SSRS solutions to identify components of organizational processes which could use improvement based on performance data. • Accountable for the documentation of technical specifications for process, proposal, and project development, maintaining a streamlined managed solution for outsourced development efforts, vendor sourcing and validation, and technical solutions development.• Leverage subject matter and technical expertise to evaluate and improve internal processes, production, cost control, and quality assurance.

•Handle deployments of stored procedures, views and synonyms followed by comparison and QA testing.•Analyze code for optimal performance and assure adherence to company standards and practices. •Perform load testing on existing and stored procedures to identify and resolve problematic code.•Create new and modify existing stored procedures in SQL Server 2008, which allows for custom reports to be delivered to clients based on needs.•Design new and modify existing XML files for use in ColdFusion, which work in tandem with created stored procedures to provide reporting forms and data formatting.•Provide Q/A testing on all completed assignments to assure completeness and accuracy.•Compile proper technical and user documentation for existing and newly created systems.•Manage all assignments via internal ticket tracking system.•Notify management of all updates and works in progress on a daily basis. •Participate in team meetings while providing useful ideas to further streamline internal team communications and implementation of effective change control management.•Produce innovative ideas that lead to open ended development based on client requests.•Designed internal reports to allow easy identification of corrupt data and display panels for information related to databases, avoiding a manual process.

•Resolved all internal and external issues. Documented and tracked all requests using “issue tracking” system.•Established and maintained solid working relationships with clients and project developers. •Enforced preventive measures to monitor & maintain 511NY/511PA/511TN system performance.•Incorporated effective logging and troubleshooting techniques for incoming system related issues.•Created ad hoc web and system based tools for system specific monitoring using SQL, ASP.NET 2.0, C# and batch files.•Provided application support directly to clients through use of proprietary software NY511, PA511, TN511 & SmartNET; Explored and applied all possible solutions prior to manager escalation. •Traced data through all system components to identify the root cause of issues and points of system failures.•Deployed and validated web and database builds in pre-prod and production environments.•Queried and manipulated data in SQL Server 2005 to identify, eliminate & repair data anomalies.•Developed ad-hoc queries in SQL Server 2005 for reporting and troubleshooting.•Implemented maintenance plan schedules in SQL Server 2005 during off peak hours.•Produced complex stored procedures in SQL Server 2005 for importing data in accordance to business rules.•Assisted in identifying database locks in SQL server to reduce and eliminate connection issues and in the development of new and effective strategies for system specific monitoring, O&M support. •Effectively created system backup and recovery plans. Generated weekly and monthly system performance reports for management and clients. •Trained personnel for all states listed. Gained skills on 511 Traveler System, a proprietary system. Learned database skills such as querying data, crating stored procedures, analysis of data and finding source of corrupt data.•Authored monitoring tools to allow team to focus more time on providing solutions to detected issues, automating the scanning process.

•Establish customer relations with a keen sense of urgency•Resolve client issues in a timely manner•Provide alternate problem solving methods using out-of-the-box thinking•Ensure customer safety using all safety measures and commanding compliance

•Increased company profits from 30% to 75% within the first quarter•Improved customer satisfaction•Managed clientele issues with a strong sense of urgency•Organized record keeping and created a solid work structure•Computer hardware/software installations, upgrades, troubleshooting, and repairs