TECHNICAL SKILLS

• Proficient knowledge of SQL Server 2000
• SQL Server 2005
• SQL Server 2008
• Business Intelligence Development Studio
• SSRS
• SSIS
• DTS Xchange
• T - SQL
• Access
• Crystal Reports 9
• Crystal Reports 10
• Crystal Reports 11
• Excel
• Word
• PowerPoint
• Project
• Microsoft Reports
• Sharepoint
• Lotus
• Visual Studio
• Outlook
• Visual Basic
• Siebel
• Dreamweaver
• Adobe Designer
• Visio
• MapPoint
• Norwest Supreme System
• and ABS System.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQLReport Developer

Responsibilities:

• Converted 170+ customer reports from Crystal to SSRS 2008 R2.
• Wrote stored procedures for reports in SSRS instead of queries used in Crystal.
• Completed project 2 weeks ahead of schedule with little supervision.
• Converted 150+ customer reports from SSRS 2005 to SSRS 2008 R2.
• Developed 45+ new reports in SSRS 2008 R2.
• Wrote stored procedures for reporting.
• Created SSIS packages for data imports for multiple customers with multiple input requirements.
• Created PowerPoint and training materials for super-users on SSIS and SSRS.
• Created specifications forreports using SSRS 2008.
• Developed multiple subscriptions for report delivery.
• Created several technical procedures for company policies for the new reporting tool.

Confidential, Charlotte. NC

SQLConversion Specialist (Contract)

Responsibilities:

• Converted 500+ DTS packages to SSIS packages via DTS Xchange.
• Wrote processes for deployment of new packages.
• Created work plan for reporting team to convert Crystal reports to SSRS reports.
• Lead weekly and monthly meetings.
• Managed projects in MS Project.
• Created complex activeX scripts for converted packages.
• Created PowerPoint and training materials for super-users on SSIS and SSRS.
• Created specifications forreports using SSRS 2008.
• Developed multiple subscriptions for report delivery.
• Created several technical procedures for company policies for the new reporting tool.
• Managed SQL team which consists of 12 team members.
• Wrote processes for super-users. This included user guides flowcharts and presentations.
• Trained team members in SSRS for launch of new reports.
• Lead weekly and monthly meetings.
• Managed projects in MS Project.
• Created complex stored procedures for fiscal year conversion.
• Created and modified SSIS packages for fiscal year conversion.
• Created specifications forreports using SSRS 2008.
• Developed multiple subscriptions for report delivery.
• Created several technical procedures for company policies for the new reporting tool.

Confidential, Durham, NC

SQL Database Administrator (Contract)

Responsibilities:

• Administer 300 servers and 1500 databases for production support.
• Extract data from Siebel system.
• Running queries is Siebel Answers.
• Create and modify DTS packages.
• Extract data from Oracle to SQL.
• Migrate databases from SQL 2000 to SQL 2005.
• Develop maintenance plans for databases.
• Created complex stored procedures.
• Created and modified SSIS packages.
• Create reports using SSRS 2005.
• Develop multiple subscriptions for report delivery.
• Created several technical procedures for company policies.
• Develop custom reports in SQL Server Reporting Services (SSRS) 2008.
• Create various views and stored procedures for reporting purposes.
• Use SSIS to import data from nine Access databases and format to one import to the SQL Server using .Net.
• Create indexes to ensure integrity and speed of databases.
• Using Agile method to ensure delivery of this project correctly and on time.
• Set up multiple subscriptions for automated report delivery.

Confidential, Richmond,VA

Database Administrator

Responsibilities:

• Develop custom reports in SQL Server Reporting Services (SSRS)2005.
• Managed Security of SQL Server.
• Maintained Back-ups of SQL Server.
• Replicated production SQL Server for testing purposes.
• Administrator of reporting server.
• Administrator of SQL Server.
• Create various views and stored procedures for reporting purposes.
• Use SSIS for importing data from Oracle to SQL using Visual Basic.
• The System Administrator of the SQL Server for the multi-vendor division.
• Develop monthly reports using various Access databases.
• Completed various maintenance for Access databases.
• Created manual for employees for new web application.
• Develop and manage several Excel worksheets.
• The System Administrator of the technician website.
• Supply reports that are analyzed in various stages.
• Issue forecast reports for several levels of management.
• Develop PowerPoint presentations for potential customers.
• Participate in presentations for potential and current customers.
• Conduct monthly conference calls with various customers to update the customers of the division’s progressDevelop custom reports in SQL Server Reporting Services (SSRS) 2008.
• Create various views and stored procedures for reporting purposes.
• Use SSIS to import data from nine Access databases.
• Working on Six Sigma certification.

Confidential,Richmond, VA

Crystal Report (Contract)

Responsibilities:

• Managed the development of custom reports built in Crystal using data from SQL.
• Developed views and stored procedures in T-SQL.
• Designed DTS packages in SQL.
• Analyzed Access reports and converted to Crystal reports.
• Provided various daily and weekly reports for various departments.
• Tested Crystal reports by others developers for implementation.
• Developed and managed several Excel worksheets.
• Managed the development of custom software built in Access and SQL.
• The System Administrator for the Fire Records Management database.
• Designed an inventory tracking database using Access.
• Designed a database to track procedures and policies within the department.
• Developed and managed several Excel worksheets.
• Supervised the hardware technician on staff.
• Answered help desk call that dealt with software and application issues.
• Worked with other departments in Chesterfield County to “scrub” data and produce more viable information for reporting purpose.
• One project entailed working with the drug screening department to ensure current employees were being drug tested.
• Produced reports in Crystal for various divisions.
• Chair of the Information Technology Advisory committee, which was comprised of end-users and worked to make technology more uniform throughout the department.
• Selected out of 500 employees to attend Leadership Training through the County.
• HIPPA Security Advisor for EMS department.

Confidential, Roanoke, VA

Regional Planner and Database Specialist

Responsibilities:

• Recommended and implemented protocols for data retention.
• Trained staff nationwide on the RCAP database.
• Analyzed data from database to provide information for various grants.
• Produced reports in Crystal for various divisions.
• Developed multiple queries in Access for reporting purposes for the Agency.
• Developed and implemented surveys for training sessions by the staff.
• Analyzed surveys.
• Forecasted figures for a ten year plan.
• Key member of the RCAP National Database Workgroup. Responsibilities were to analyze the database for flaws and teach the importance of database management.
• Used U. S. Census data for more reliable demographics for projects.
• Designed Access database for organization, which included mailing, contributor, and volunteer lists.
• Developed coalition with the State Police and wrote a grant for this coalition.
• Designed and implemented surveys for the community.
• Coordinated and supervised volunteers on various events.
• Developed partnerships with local schools for Prom Promise.
• Conducted Victim Impact Panels for Offenders.
• Developed a program to recruit volunteers.
• Processed grants from the Department of Motor Vehicles.
• Processed Hope grant for victim services.
• Planned Law Enforcement Awards Ceremony, which honors officers from fifty departments.
• Wrote agendas for monthly meetings.
• Gathered and analyzed data for national reporting.

Confidential, Richmond, VA

Marketing Director

Responsibilities:

• Promoted and tracked insurance sales for company contest.
• Designed PowerPoint presentation for sales promotion.
• Researched prospective clients through the use of databases located on the Internet.
• Attended meetings of targeted marketing groups.
• Designed tables, queries, forms, and reports for the new system.
• Used SQL 7.0, Visual Basic 6.0 and Access 97 to develop custom software for the Commission’s new system
• Assisted other departments in developing their modules for the new system.
• Worked with management to develop new audit procedures.
• Designed spreadsheets for auditors to use when conducting an audit.
• Analyzed financial statements and inspection reports to recommend audits to the field auditors and potential investigations to the investigative unit.
• Assisted management in the development of new inspection procedures.
• Provided computer training for field staff in Access, Excel, and Word.
• Submitted weekly reports of progress of the department for the Commissioners of the Charitable Gaming Commission.