SUMMARY

Highly motivated SQL Developer/DBA with experience using SQL Server Management Studio and Visual Studio 2008. Five plus years invested in the IT industry, with experience ranging from small internal databases/software to external facing databases/software with over 3 TB of data in a wide variety of environments. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. TECHNICAL SKILLS Programming Languages: Transact SQL, XML, C, C , HTML, JAVA, JavaScript, JCL, JES2, MVS, TSO/ISPF, VB, VTAM, Korn shell scripting Microsoft Technologies: SQL Server 2008 Reporting Services SSRS , SQL Server 2008 Integration Services SSIS Databases: Microsoft SQL Server 2000 / 2005 / 2008, Microsoft Access, Oracle Querying PL/SQL Operating Systems: Windows 98/2000/XP, Windows Server 2003, UNIX Software: SQL Server Management Studio, Microsoft Visio, Microsoft Office, Database Engine Tuning Advisor, SQL Server Profiler, HP Wintel Servers, Mercury BAC, SDLC, MSSQL Server Query Analyzer 2000, MSSQL Server Enterprise Manager 2000, MS Office, OVIS, CICS PROFESSIONAL EXPERIENCE

Confidential

IT Specialist

Create and edit SSIS packages. Utilized command files to run packages. Participated in SDLC and Agile projects. Completed adhoc requests from the Chief of Database Management Office.

Confidential

• SSIS/ETL Data Developer SRRS Solutions Developer Database Developer Develop SSIS ETL packages. Develop SSIS 2008/2012 ETL packages and stored procedure code based on business requirements and mapping documents. Contribute to logical and physical data models and meta data systems. Data profiling, data regression testing and develop T-SQL scripts as needed. Trace and debug data logic related to business requirements. Development of custom data solutions as needed. Interact with technical and business users.
• Create and modify SSRS reports. Create tabular reports using text boxes, tablices and graphs. Created data sources shared and hidden, data sets using T-Sql queries, and parameters. Deployed reports via the CRM toll that automatically pushes to the SSRS server. Confidential
• SQL Database Developer
• SSIS: create and revise packages, assist with company-wide database organization, assist with migration from: Mainframe, AS400, flat files and SQL Server 2000/2005 to SQL Server 2008 R2 2012.

Confidential

Data Management Specialist

Daily processing of internal and external customer data management services for a mobile occupational health testing company. Including but not limited to: data cleaning/scrubbing , importing large amounts of data for historical purposes, updating employee information in each individual clients' database, merging duplicate employees based upon demographic information and audiometric threshold similarities, moving data from one company to another due to acquisition, converting sensitive data such as ssn's into unique identifiers, utilizing and creating stored procedures for ssn conversion purposes, creating SSIS packages for automatic processing of large client files, soliciting for and receiving waivers to request historical data from other vendors on behalf of the client. Utilized Access and SQL to process HIPAA protected data.

Confidential

Associate Solutions Developer/Associate Database Administrator

• Determined project specifications, work plans, quality assurance plans, and timelines for client projects. Programmed and performed program maintenance according to project specification. Tested, debugged, repaired, and retested programs. Managed own schedule according to project timelines. Utilized SSMS 2005/2008 to create stored procedures, views, tables, indexes, constraints and a myriad of other objects that ran the client websites on the back-end. Created and posted splash pages, and managed access utilizing tools. Maintained work schedule according to project timelines as well as handling ad-hoc requests at any given moment.
• Confidential Applications Systems Analyst I Reviewed, analyzed and modified applications systems which included encoding, testing, debugging and installing to support ScriptPro's applications and systems. Consulted with users to help identify current operating procedures and to clarify pharmacy objectives. Created documentation describing ScriptPro applications, pharmacy practices, and processes. Created installation and operating procedures. Utilized relational database and client-server knowledge to troubleshoot and resolve pharmacy customer issues. Utilized SQL Server 2008, Database Administrator, Networking and other technologies/concepts/knowledge while performing duties such as hardware swaps, client swaps, proprietary software modifications, and system configuration changes. Confidential IT Specialist Customer Service Oversaw service-wide computers, telephones, printers, and fax machines. Ensured that office automation was in place by creating procedures spreadsheets, simplifying routine tasks, and ensuring all workstations were in order documented assigned and operational . Reset accounts for software such as LAN, tax processing system, accounting system, etc, voicemail. Assisted employees with IT-related issues such as account lockouts, new software access, new workstations, VPN, and blackberry support. IT Functional Coordinator I was promoted to the position of IT Funco but there wasn't a pay grade increase due to departmental budgetary issues. Oversaw and managed 50 computers, telephones as well as 13 printers and 6 fax machines. Ensured office automation was in place by creating procedures spreadsheets, simplifying routine tasks, and ensuring all workstations are in order documented assigned and operational . Assisted employees with a myriad of IT-related issues as the FUNCO . As the Funco handled IT issues as the first line of service before Modern Information Technology Service MITS escalation. Worked closely with both the Taxpayer Advocate Service TAS office and MITS in order to resolve key issues such as slow workstations, telephonic issues, fax and printer issues and created work-around's until a technology fix could be installed. Had proxy authority for the LTA Local Taxpayer Advocate which was used to open up 5081's for employees software access requests . Opened 5081's and OS GetServices tickets for new office employees as well as recently promoted employees, in order to prepare the employee and their respective workstations. Opened tickets for office safety issues and any other issues that may come up. Created documentation that detailed asset assignment and location as well as software images which assisted in campus-wide refreshes. Resolved an on-going 3 year issue with in-house web-based applications. Per the previous FUNCO this issue was on-going for 3 years and that neither himself nor the MIT employees could figure out what the issue was. Previously when a web-based application was open and an employee attempted to open up another web-based application, the new application would open up in the existing window. Created a work-around to this by having the employees add their necessary web-based applications to their favorites as opposed to using shortcuts. While they were using the work-around I was able to determine that the reason why this was happening was due to an option that the employees needed to un-check within Internet Explorer Reuse windows for launching shortcuts . Confidential Data Integrity Tester/SQL Database Tester/Jr Database Administrator I participated in the Software Development Life Cycle SDLC in the planning and implementation stages, submitted testing plans including data, database, and product the testing would effect, analyze and assure utmost quality was maintained. I was responsible for creating queries in Transact-Structured Query Language T-SQL and running said queries in order to collect and analyze data in order to ensure quality was maintained whether in the form of an update to a product, problem resolution and/or new products for our customers. I served as a data expert on underlying business and data rules to negotiate possible resolutions that supported and enforced data quality standards, validated data transformation logic, and certified data resolutions. Data Research Analyst/Tier 2 Support: I analyzed and assessed product and data integrity issues. I had working knowledge of real estate and real property data, procedures and terminology, and a solid understanding of the company's data. I investigated and documented technical and non-technical data quality issues reported by internal and external customers. Upon initiation of investigation of an issue, I verified and cross-referenced in house data with vendors' and assessors' data. I interacted with vendor tools to initiate research on the vendor's end, which may have required a fix file from them, which was in turn processed in the production warehouse.

Jr Database Administrator:

• As a junior database administrator I was responsible for maintaining the development and testing environments. This included setting up daily, weekly, monthly backups. Restoring live backups into the development and testing environments for refreshing of the data. Confidential Computer Operations Analyst III I supported Microsoft Windows Server and Microsoft SQL. I assisted Senior Systems Engineers with deployment, installation, and connectivity of HP Wintel Servers, including tape management and hot-swapping drives as needed. Performed change management requests deployments and Quality Assurance QA testing of test, staging and production data and sites. Confidential Client Services Specialist III I was responsible for monitoring several different environments including databases and web sites, troubleshooting issues and escalating to appropriate personnel as well as notifying executive level personnel about severe outages and business impact. I screened, referred and diagnosed internal inquiries and work requests relating to maintenance of mainframe and open systems applications. I monitored and acknowledged Enterprise service alarms from an array of numerous disciplines including remote mainframe consoles, OVIS, Mercury BAC, and Big Brother. I followed defined processes to resolution, and supported a high level of customer service. I worked in a highly technical environment with other highly skilled technical professionals. I possessed the ability to communicate effectively in both an oral and written manner, strong analytical, troubleshooting, and problem solving skills. I demonstrated analytical and problem solving skills in complex environments while exercising these skills to make accurate and timely decisions for business critical outages. I utilized JES, MCS and VTAM commands on a daily basis. I monitored mainframe devices, platforms, IMS, resources, started tasks, connect-direct, tape processes, transactions, and programs, databases, online batch processing and MainView for outstanding messages. I performed IPL's during weekly maintenance windows.
• Confidential Operations Technician II I was responsible for monitoring consoles, logs and specialized systems troubleshooting and resolving issues and problems, and providing customer service and support. I have the ability to independently perform identification, evaluation, prioritization, and resolution of computer related technologies which included: Rumba for the CA7 job scheduler and batch/mainframe environments, the AutoSys application for the UNIX environment, TNG Unicenter and EM Console for monitoring of: Windows, UNIX, mainframe and other environments. I performed change management requests by promoting M204 procedures into production, performing SCLM promotes, and modifying JCL when needed. I performed weekly backups of AS400's, reboots of the systems to bring in changes, and re-configured the system when necessary. I bridged the gap between business needs and IT support structure and related technical issues in appropriate business terms. I handled high severity issues ensuring appropriate and timely notification to customers and support personnel to help minimize financial impact to the company. I logged and tracked user's requests for assistance and also logged and tracked system issues in the Peregrine Service Center system as well as maintained an ongoing history and related problem documentation for the knowledge base. I reviewed problem documentation and made recommendations for improvement. Confidential Lead Data Systems Operator/Associate Database Administrator I managed 6 to 8 computer operators across three shifts at any given time. I created schedules for bi-annual shift change and alternative work schedule opportunities. I was solely in charge of recruiting and interviewing potential candidates for hire. I was responsible for counseling operators as well as training new hires and re-training employees as needed. I created, updated and debugged several scripts to assist in production reporting and system maintenance. I took the initiative numerous times to update and create procedures. I constantly set the example by following procedures and handling each situation accurately. I consistently showed attention to detail while ensuring that the Unix Operations team and more specifically the Operators team were represented well. I created and maintained the on-call website HTML which created a month by month view of on-call personnel for multiple groups. I created and maintained Problem Description website HTML containing Problem Description Reports outage and system issues that were reviewed for accuracy and grammar and then disseminated to appropriate personnel. I created and distributed the Weekly Status report for the Operations team. I created the Operations Executive Summary report, which was then disseminated to upper-level executive management. I implemented and/or assisted with key items such as: on-call calendar which helped the Operators team escalate to the appropriate on-call personnel, Problem Description Report and Problem Management functionality within Altiris, finalization and testing of Disaster Recovery Plan for the Unix Operations team, and entered items into Problem Tracker which assisted with troubleshooting and helped to maintain a knowledge base. I did all the above while still doing the following activities monitoring production system and peripheral equipment, updating/annotating log entries in order to track system performance, competent in several phases of operation, assisted in carrying out various duties associated with the operation of the production system and peripheral equipment including record keeping regarding output units, storage and supplies, and performed basic to intermediate UNIX administration functions. I was responsible for bringing the Oracle database back up along with all the services required in order for the database to work properly. Confidential