OBJECTIVE

• Use my Business Intelligence skills in SSRS and T - SQL Programming in tandem to provide my employer with accurate and useful data for use in making sound business decisions.

TECHNICAL SKILLS

• SSMS
• SSRS
• SSIS
• T-SQL
• TFS
• VB.NET
• JIRA
• MS Office Suite
• SQL Server

PROFESSIONAL EXPERIENCE

Senior BI Developer

Confidential, Destin, FL

Responsibilities:

• Contributed to the enhancement of the SaaS automotive CRM through developing SSRS reports that delivered needed data to the customer.
• Lead the conversion of SaaS system generated reporting to SSRS reporting.
• Prepared and modified reporting standards
• Developed process to standardize report formatting that simplified the any changes to the format of all reports.
• Designed and developed reports to meet business customers’ needs.
• Designed and developed T-SQL objects (Procedures, Functions, and Views) to deliver data from both OLTP databases and Data Warehouses to SSRS reports.
• Created a reports’ library of Reports on Reports that presented metadata from the Report Server database.
• Developed a backup strategy for the SSRS servers.
• Participated in daily standups working a part of an agile team to deliver improvements to the data delivery of the CRM.
• Created SSIS packages and wrote T-SQL code to move data from various servers/databases to a consolidated location, a single server and into reporting and data warehouse databases.
• Tested data warehouse for data verification and quality, cross comparing production databases to data warehouse to find and correct inconsistencies.
• Designed and implemented solutions to correct data warehouse data issues.
• Wrote, maintained, modified T-SQL ETL code.
• Developed SSIS package and wrote T-SQL code to identify Deltas and new rows to move said data move data from a vendor’s database to an in-house database.

Senior SQL Developer

Confidential, Glen Allen, VA

Responsibilities:

• Contributed to the development, maintenance, and enhancement of business applications by providing technical or business knowledge to the team utilizing SQL procedures and scripts as well as other database technologies and tools. Collaborated with Business Analysts, and key stakeholders to define technical specifications and system interfaces to develop and present business solutions.
• Maintained and modified the Conformed database, which contained data from several source systems.
• Writing the T-SQL ETL code to move and manipulate the source system data and load the target database.
• Modified the database by inserting new tables, columns, and indices.
• Created and maintain appropriate documentation and recorded such in JIRA.
• Scheduled and modified SQL Server jobs to run the ETL code.
• SSIS package maintenance and modification.
• Designed and developed reports to meet business customers’ needs.
• Created and modified SSRS reports and performed Ad Hoc and monthly reporting.
• Scheduled and modified report subscriptions.

Senior SSRS Developer /T-SQL Programmer

Confidential, Glen Allen, VA

Responsibilities:

• Developed and revised SSRS reports for analyzing data related to the trans-Atlantic shipping of containerized goods using BIDS.
• Wrote T-SQL stored procedures used and functions that delivered the data to the SSRS reports.
• Modified RDLs, stored procedures and functions to correctly function as the database evolved the user interface changed and as versions 42 - 46 of Compass, the core business application, were released.
• Designed and developed VB.NET application and database for managing the SSRS reports library and their related SQL Server 2008 R-2 objects. This included creating an SSIS package to get the metadata from the report servers and then load it into the above-mentioned database.
• Migrated database with data to new server using SSIS. Moved reports and shared data sources to new server.
• Used SSIS to import data into SQL database from flat flies and Excel spreadsheets.
• Setup and managed report subscriptions.
• Migrated data from the legacy system into new database used for legacy reporting.
• Performed optimization of queries, existing and new.
• Interviewed and worked with end users.
• Defined the needs and specifications for ad hoc queries and permanent SSRS reports.
• Corrected/modified the reports to better fit their needs and to prove them out with user testing.

SSRS Developer/T-SQL Programmer

Confidential, Richmond, VA

Responsibilities:

• Developed SSRS reports for analyzing data related to a court case involving major oil spill.
• These reports were developed using BIDS and MS Report Builder 3.
• Wrote T-SQL stored procedures used that delivered the data to the SSRS reports.
• Wrote many ad-hoc queries that aided the Fraud Team find fraudulent claims.
• Designed and developed VB.NET application that converted a 30-minute query writing process into an automated process taking a few minutes.

Report Writer/ Analyst

Confidential, Richmond, VA

Responsibilities:

• Developed SSRS reports for analyzing mortgage trends.
• These reports were developed using matrix, table, chart, and gauge report objects using BIDS.
• Wrote T-SQL stored procedures, functions, and views used that delivered the data to the SSRS reports.
• Rewrote inefficient stored procedures, functions, and views
• Many of these objects contained a significant amount of redundant code.
• Rewrote objects and made them flexible by using parameters and thus only one object was necessary instead of five.
• Served on the development and specification team for the Mortgage Repurchase Early Warning project
• Defined user/system needs.
• Prepared timelines for the design and development of this project.

SSRS Report Developer/Programmer/Analyst

Confidential, Richmond, VA

Responsibilities:

• Developed an SSRS report library using matrix, table, chart and gauge report objects using BIDS and MS Report Builder.
• Served as part of the design and specification gathering team of version three of CPPI (the main corporate system).
• This was an 18-month process. My involvement included analyzing the data structure, system specifications and performance. Weekly meetings, think tanks, and detailed discussions were all within the scope of my role on this team.
• Programmed in VB.NET, VB6 and designed/developed SQL Server databases used for data analysis and ad hoc queries.
• Built an online multi-lingual application used for scheduling, record keeping and information dissemination.
• Built online application that was used as an accessory to the CPPI system and allowed users to make historical changes.
• Designed and developed database and SSRS reports that converted a 40-minute manual research process to a click and print process that took only seconds.
• Designed the database and wrote the VB6 application that provided a vehicle for expense reporting and financial analysis.
• Interviewed end users to gather specifications for reports and VB applications. Analyzed user needs and developed the technical specifications from which I built the end-product.
• Wrote T-SQL stored procedures, functions, views used for delivering report data and wrote ad hoc queries as I was asked “need-to-know-now” questions by management.