We provide IT Staff Augmentation Services!

Sqlreport Developer Resume

Boston, MA

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.

Hire Now