Professional Objective: Strengthen a highly capable team that focuses on developing cutting edge technical solutions to streamline and automate core business functions of an organization.

Proficiencies

Languages

• DTS/SSIS
• SSRS
• Java
• C .net
• VBA
• HTML
• XML
• SQL/T-SQL
• SSH
• VBscript
• Batch Script
• Operating Systems
• MS Server 2003
• MS Windows 3.1, 98, 2000, XP, Vista
• RDBMS
• SQL Server 2008
• SQL Server 2005
• SQL Server 2000
• MS Access 2003
• MS Access 2007
• Software
• SC Connect Direct
• Team Foundation Server
• Subversion
• CVS
• Putty/Telnet/Tunnelier
• MS Visio
• Visual Studio
• NetBeans
• Management Studio
• Enterprise Manager
• SQL Profiler
• DB Engine Tuning Advisor
• Oxygen XML
• Examdiff/Tortoisediff
• TortoiseSVN
• PGP/GPG
• Open DBDiff
• Red Gate SQL Compare
• Idera SQL DM
• Kronos TimeKeeper
• Kronos Connect
• Navision Report, Form, Object Builder
• MS Office Suite

Experience

Confidential

• Implemented database source control by creating database projects for 60 existing databases, designing the physical layout in Team Foundation Server, and creating a release process to support best practices.

• Coded a new project to notify Volkswagen when ASNs were running late to avoid part shortages and plant shutdowns. This project was dynamic where end users set all aspects of who is notified, when and what the message should include.

• Performed all day to day database administration functions including performance monitoring, query optimization, new index recommendations, and maintenance.

• Performed peer review and mentoring to the front end team for all things database related. This would include the need to follow the standards that were set by the database team, the importance of indexes, primary keys, and normalization where appropriate .

• Maintained EDI 830, 856, 862 projects as enhancements and changes were required across all accounts Ryder Logistics LMS supported. These ETL processes heavily involved SSIS and stored procedures to facilitate millions of transactions being sent weekly.

Confidential

• Led the group of SQL developers by example. There is nothing that I ask of them that I haven't done myself and continue to do on a day to day basis

• Defined priorities for team of highly skilled developers by reviewing items in queue and aligning their efforts to meet business objectives

• Met with team members to discuss priorities

• Reviewed ticket queues and closed/pushed back on unneeded items
• Distributed tickets and assignments to developers to balance the work load

• Created synergies within the group by having team member collaborate on projects where there were technical and functional overlapHad team members work together and share knowledge to crack a problem that our software vendor had challenges with example being Cogent task pop ups for auto-proceedings and Send-Suite automation

• Had member of transaction system team that was knowledgeable in the payment plan area work with BI team member while designing payment plan data mart

• Reviewed code for team members and mentored them on a better way to do things and often challenge them to go one step further to incorporate excellence in the processes they're creatingWill approve/reject code based on if it is written in an appropriate manner and to our standards. If rejected, I give feedback and send the code back to be revised

• Review timings of processes and ask them to challenge themselves to make it faster and more efficient

• Asked how they could make the process more flexible and user friendly and get them engaged in thinking on how to make things better

• Conduct open brainstorming sessions where input is given by all participants and built upon by the group. Ideas are challenges and a stronger product is the result

• Collected a list of value-add initiatives that would streamline and automate existing processes as well as create new processes that add value back to the business. I have encouraged all team members to participate in adding to this list as they observe areas to improve upon

Confidential

• Performed DBA functions for very large database 8 tb including development of maintenance plans, physical and logical design, managing security and capacity planning

• Provided troubleshooting of performance issue at all system layers client, web tier, and database for application and infrastructure deficiencies

• Performed duties as the lead SQL developer on a conversion of our main collection systems to a SQL Server 2005 based platformManaged the timeline and deliverables of the data conversion process

• Coordinated the conversion process with developers from our new vendor
• Divided and assigned tasks to members of my team
• Wrote main java program to extract data from our legacy system that was built on a Cache database
• Wrote scripts to transform the data so it can be used in the new system's database schema
• Developed reconciliation methods and check points throughout process to ensure quality

• Designed, built and maintained an automated solution to electronically handle credit reporting disputes using EDI with e-OscarAutomated solution performs the work of twenty employees working for one full day within one minute

• Gathered requirements and developed Java program to read in dispute data, find corresponding account information from main collection system, write both set of data up to a relational database SQL 2005
• Designed and create relational database to house dispute, collection system, and response data
• Designed and create stored procedures and functions to provide for accurate response generation
• Implemented a database maintenance plan to ensure reliability and to meet SLAs
• Designed and create a front end for end user to pull up disputes, the historical data from the collection system, and response data for use in legal challenges

• Designed, built and maintained a system to process purchased data into a standardized file to be imported into our collection systemFront end built in C .net to allow users to import, translate, and export a standardized file

• Multiple complex stored procedures required to perform the sophisticated cleaning and calculations required by the process
• Database was designed using third normal form normalization

• Supported SQL Based Business ApplicationsProvided day to day support for the Kronos time keeping application, MS SQL 2000 environment

• Developed maintenance plans to ensure the system would perform and be reliable
• Provided day to day support for Navision our general ledger and accounts payable system, MS SQL 2000 environment
• Managed the change control process for migrating code to the different environments of the application

• Provide daily database importing and exporting duties ranging from the simple to complex SSIS packages

Confidential

• Supported and maintained existing MS Access white sheet and clients databases including creating .net archive solution, reports, forms and table support.

• Worked with head member of infrastructure to develop and maintain a uniform solution for remote access into all contracted agencies' system for auditing purposes

• Automated scanning and filing system with an electronic process.

Confidential

• Cultivate positive relationship between Hewlett Packard and technical stores, primarily Microcenter in Madison Heights, Mi
• Perform trainings of sales employees at Microcenter to keep them on the cutting edge of Hewlett Packard products and support
• Worked directly with customers to enhance Hewlett Packard's reputation and increase their overall sales
• Advance my own knowledge of current technical breakthroughs by attending technical trainings from Hewlett Packard
• Maintain and setup store display units and perform general merchandising duties
• Acted as a direct liaison between Hewlett Packard and Microcenter

Confidential

• Responsible for all aspects of data recovery, including performing backups of servers and end user's machines and restoring data as needed
• Providing all levels of technical support to end users for both hardware and software
• Granted network security access for individual users and groups
• Acted as a general repair person of items around the office desks, chairs, televisions, etc.

Confidential

• Provided internet access technical support to end users by phone
• Generated sales through enhancing users' accounts by adding anti-virus and internet acceleration services
• Provided telephony support to end users and properly escalated issues to dispatchers who would in turn alert ground crew members to act

Confidential

• Provided first level support of hardware and software
• Maximized end users' efficiency by performing upgrades and reallocating hardware