Customer Service Sql Server
Resume:
MELVIN COLINS
Harrisburg, PA 17110
******.******@*****.***
CITIZENSHIP: US Citizen
TRAVEL: willing to travel
PROFESSIONAL SUMMARY:
Business minded operationally aware technical professional possessing
strong leadership abilities and solid fundamentals honed over a variety of
career experiences. Goal oriented, focused on improving and understanding
the implementation of technology as it relates to operations and objectives
within business units. An already proven jack of all trades / go to person
with the ability to take on tasks outside the normal scope of
responsibilities, and also has the ability to come up to speed quickly to
ensure operational and business success. This professional brings over
eight years of computer and networking experience and a team-based
management style with excellent communication and interpersonal skills.
WORK EXPERIENCE:
Administrative Office of Pennsylvania Courts :Programmer Analyst
02/2013 - Present
Supplied various reports for Common Pleas Courts staff. Clients use the
.NET application to access the reports. Responsibilities included anything
from Statistical Data to Accounting to Court Letters. Tasks included
writing stored procedures and custom applications.
Optimize and improve reports when necessary.
Provide internal customer service to various departments, must be able to
translate technical information to non-technical audiences
Embarcadero Rapid SQL
T-SQL
Crystal Reports XI
Team Foundation Server
Visual Studio 2013 for Visual Basic .NET
Legislative Data Processing Center :Computer Programmer
07/2012 - 01/2013
Responsible for the creation and maintenance of Crystal Reports, scheduling
and distribution. Maintains and ensures data transition from OpenVMS host
to Microsoft SQL Server and creation/modification of user defined
functions, views and tables as needed. Design and implement cost effective,
high quality web applications to meet/exceed client needs in Cold Fusion.
Works with the rest of the Information Systems department to ensure
efficient operations of the organization.
Compile data, create reports and present information utilizing expertise
with Crystal Reports, SQL Query, MS Excel and MS Access
Generate and collect simple reports and complex data extractions including
multiple tables and ODBC connections
Interface with customer to obtain a full understanding of the project
requirements in order to recommend the appropriate technology to accomplish
requirements (Cold Fusion)
Monitor application efficiencies to identify means of enhancing performance
Ability to be self-directed, able to focus on personal assignments while
remaining part of a larger team with proven ability to multi-task
RiteAid Corporation :.Net Developer
01/2012 - 07/2012
Design, modify, develop, write and implement software programming
applications and components. Support and/or install software applications
and components. Work from written specifications and pre-established
guidelines to perform the functions of the job and maintains documentation
of process flow. Main objective was to update Phone System with new SQL
Database structure and build a release.
Utilize established development tools, guidelines and conventions including
but not limited to: Visual Studio, ASP.NET, SQL Server, and C#/VB.NET
Design, code and test new Windows applications
Enhance existing systems by analyzing business objectives, preparing an
action plan and identifying areas for modification and improvement
Maintain existing software systems by identifying and correcting software
defects
Create new and extend existing operational documentation
Consult closely with management and occasionally agency staff related to
projects and tasks
Consult colleagues concerning maintenance and performance of software
systems
Holy Spirit Health System :Network Specialist
07/2011 - 01/2012
Automated critical tasks that required hours of man power. Created WMI
application that scans all servers on network and generates detailed
specifications document. Redesigned Server Inventory application to be
faster, simpler and user-friendly. SQL and VB Scripting. Automated
spreadsheets to update active/inactive users with the click of a button.
Also preformed Print Server migration from MS Server 2003 x86 to MS Server
2008 x64.
SDLC, Microsoft Visual Studio .NET 2008, SQL Server Enterprise 2008,
Crystal Reports, C++, ASP.NET, XML, Web Services, SQL, Stored Procedures,
Functions, Microsoft EXCEL, Troubleshooting
Gather data to identify customers' needs then use the information to
identify, interpret and evaluate system and network requirement
Software design and development in Microsoft SQL Server 2008 database
environments with Microsoft Visual Studio .NET including C++, ASP.NET, and
XML web services
Strong understanding of .NET Framework
Write queries within Microsoft SQL Server
Experienced in providing production system support and solving daily
production issues
Strong analytical, troubleshooting
Evaluate efficiency of system and work to improve production and workflow
Provide technical advice as required for system planning
TransCore :Systems Administrator/Engineer
01/2011 - 06/2011
Strengthened much needed relationship between clients and Department of
Information Technology. Responsible for documenting all IT processes and
upkeep of Server/Workstation Security. Developed program to strengthen
integrity and record keeping. Worked on designing Help Desk Software.
Software design and development with use of Microsoft Visual Studio .NET
2008, Microsoft SQL Server Enterprise 2008
Expertise with full software development life cycle including software
system analysis, functional design, technical design, development, testing,
code review and production system support
Integration of Crystal Reports with Visual Studio .NET
Expertise with grouping, sub-grouping, formatting, conditional formatting,
and creating complex formulas
Test report output; export report output to Microsoft Excel format
Knowledgeable of software design and development in Microsoft SQL Server
2008 database environment
Knowledgeable of data analysis and data design
Knowledgeable of performance tuning database stored procedures and
functions
Perform regular maintenance and upkeep documents
Develop and maintain installation and configuration procedures
Debug using MS Visual Studio 2010, MS Visual SourceSafe, Business Objects
Crystal Reports
Languages: .NET, XML and Visual Basic
Maintain proper communication between IT and other departments
Worked on improving department image and social evaluation
Troubleshoot/Test Windows 7, Website, Multiple in-house software
Essintial :Training Coordinator/Escalations Agent
05/2010 - 01/2011
The primary responsibility is to raise the technical expertise of our agent
staff and contribute to overall customer satisfaction by providing timely
technical and professional mentoring in a leveraged manner. Assist in
resolving cases that exceed agents' capabilities either in technical skill
set, urgency, complexity or time to service. Partnered with the Team
Manager to improve technical and soft skill performance of the team, to
meet customer satisfaction initiatives and to meet Case Wellness goals.
Evaluate cases and partner with agents to validate proper technical action
plans
Manage escalation processes and adherence by assigned team
Manage escalated tickets and proper consult line usage
Ensure all scheduled callbacks are met
Promote greater customer satisfaction for the team/unit
Assist with special projects and other duties as assigned
Pennsylvania Department of Transportation :Lead Systems Analyst
05/2006 - 04/2009
Responsible for management and upkeep of systems state wide while providing
complete client satisfaction. Client base included everyone from a regular
end user to the Secretary of Department of Transportation. Support includes
planning, scheduling, operation, optimization, security administration,
maintenance, network management, network monitoring and administration.
Manage four Systems Analysts and ensure that their duties are performed in
accordance with the applicable Performance Work Statement guidelines.
Primary responsibility - oversight of team members.
Network services support
Third party and internal application support
Use of Customer Relationship Management (CRM) to ensure quality of client
service
Operations, planning, and management support
Systems Management Server (SMS); Active Directory; Internet Information
Services (IIS)
IT systems administration
Administrative support
Training support
Scripting with C++, Visual Basic and Batch Files
Was involved in numerous projects. For instance, Hardware Refresh, Central
Office Developer move, PEMA move, Material Testing Lab move, custom images,
CWOPA migration, etc...
Working with Central Office and District IT Staff in various issues that
arise with upgrades/changes; Service Calls; Host On Demand; IBM Rational;
Off Hour Support; Network Setup; others as needed
Experience in multiple OS platforms; Windows XP/Vista, Server 2003/2008,
Linux RedHat, Unix
Build/image workstations/servers with the help of VMWare
Create Symantec Ghost Image standards
Test software compatibility with VMWare to improve productivity and
efficiency
Retrieve back-ups from IBM Tivoli Server
Support PEMA workstations during urgent situations
Manage Dell ImageDirect
Pennsylvania Credit Union Association :Technical Consultant
08/2008 - 02/2009
Responsible for implementing, enhancing and integrating a finance database.
Consultants are usually performing their duties at the customer's site. In-
depth knowledge of the Business Processes and technologies such as
Microsoft SQL Server, the SQL language and Visual Basic development.
Operated under general supervision on mid-size projects usually involving
single products or single platforms
Full understanding of SDLC (Software Development Life Cycle) standard
processes and industry best practices
Help configure client's applications and databases
Perform business analyst services in developing functional and technical
requirements and reporting requirements
Strong documentation skills
Define, develop and test application
Resolve bugs/issues at customer's site
Develop and use quality assurance procedures to assure high quality
software
Determine database configuration needs and requirements
Guide and train new clients in setting up NT Server and SQL Server
Assist new clients in developing and implementing maintenance and
administrative procedures, including robust backup routines
Elegance With Flowers :Web Architect
07/2007 - 06/2008
Duties included everything between planning and deployment. Responsible for
maintenance. Ensured web servers, hardware and software are operating
accurately, designing the website, generating and revising web pages, and
examined traffic through the site. Embedded a flash gallery within HTML /
XML Code to enhance the appearance
Planning, Design, Specification, Architecture, Implementation, Testing,
Documentation, Deployment and Maintenance
Coded with XML, HTML and Flash Integration
JAVA Integration
Tools Used: Adobe Photoshop, Adobe Flash, Adobe Dreamweaver and Microsoft
Publisher
EDUCATIONAL BACKGROUND:
Pennsylvania State University 05/2008
Bachelors in Computer Science
Contact this candidate