Wrote new T-SQL and maintained existing stored procedures and functions that delivered data to the SSIS packages and reports.Maintained existing ETL packages and wrote new ETL packages in SSIS (Visual Studio) to process tax and parcel data. Worked with BA’s to refine specifications and technical documentation for various projects in order to gain an understanding of project requirements and goals and with this knowledge, develop the required deliverables.Used SSIS to extract certain information from unstructured data.developed a database and its objects (schemas, tables, stored procedures, functions, etc.) for managing, transforming, and delivering data related to a lawsuit filed against the county.Created new SSRS (Visual Studio) reports and maintained existing ones.Participated in daily meetings to discuss progress of deliverables, and to plan for the next set of deliverables.Participated in conference calls with business users and stakeholders.Insured adherence to technical standards.Imported and exported Treasurer and property data from/to disparate data sources.Used Git as code repository.Used C# for SSIS Script Tasks.All work was performed remotely from my home office.

Worked with business users to refine project requirements.Wrote T-SQL stored procedures and functions that delivered the data to the reports.Maintained existing stored procedures used and functions.All work was performed remotely from my home office.

Supported analytical tools that utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisitionWorked with stakeholders including data, design, product and executive teams and assisting them with data-related technical issuesWorked with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issuesPerformed root cause analysis on external and internal processes and data to identify opportunities for improvementBuilt processes that support data transformation, workload management, data structures, dependency and metadata

Imported and exported pharmaceutical data from a variety of disparate data sources.Wrote new ETL packages in SSIS to process pharmaceutical data. Maintained existing ETL packages in SSIS to process pharmaceutical data.Wrote T-SQL stored procedures used and functions that delivered the data to the SSIS packages.Worked with business users to refine project requirements.All work was performed remotely from my home office.

Lead a team of 3-6 BI developers.Contributed to the enhancement of the SaaS automotive CRM through developing SSRS reports that delivered needed data to the customer. Prepared and modified reporting standardsDeveloped 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.Participated in daily standups working a part of an agile team to deliver improvements to the data delivery of the CRM.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.

Compiled detailed complex business reports using data reporting tools such as SSRS. ETL development, data integration and wrote SSIS and advanced queries and stored procedures.Performed database development, management, performance, normalization, and data security.Analyzed and documented complex data systems, data flow, relationships, and dependencies.Work with the IT team to build data transactional warehousing systems.Developed database objects and structures for data storage, retrieval and reporting- Implement and test database design and functionality and tuning for performance.Designed and develop back-end database interfaces to web applications.

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 standardsDeveloped 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 writing T-SQL code to move data from various servers/databases to a consolidated location/database production servers to 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.Writing, maintaining, modifying T-SQL ETL code.Developing SSIS package and writing T-SQL code to identify Deltas and new rows in order to move said data move data from a vendor’s database to an in-house database.

Contributed to the development t, 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. Under the guidance of a Team Lead, collaborated with Business Analysts, key stakeholders, and other IT professionals to define technical specifications (based on business requirements) 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.Designed and developed reports to meet business customers’ needs.• Created and modified SSRS reports.• Scheduled and modified report subscriptions.• Performed Ad Hoc and monthly reporting.

Developed and revised SSRS reports for analyzing data related to the trans-Atlantic shipping of containerized goods.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.Migrated database with data to new server using SSIS. Moved reports and shared data sources to new server. Setup and managed report subscriptions.Designed and developed ETL for reporting database using SSIS.Migrated data from the legacy system into new database used for legacy reporting.Performed optimization of queries, existing and new.

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 applications that converted a 30-minute query writing process into an automated process taking a few minutes.

Developed SSRS reports for analyzing repurchase 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.

Developed an SSRS report library using matrix, table, chart and gauge report.At the beginning of this development process, there were no SSRS reports or developers. I was assigned the responsibility of learning SSRS and creating a report library, now used organization-wide. The library includes the 5-Year Side-by-Side report reflecting mission critical data for the current year as well as for the previous four years. There are drilldown reports that give both a summary view and, for those who want to see the details, they may go deeper at the click of a button. Additionally, there are graphical reports using charts, graphs and gauges. And, for those who “just want the data,” there are table/excel style reports. All reports are parameterized to deliver only the data the user wants and include security that only delivers the data permitted for view by the user.Served as part of the design and specification gathering team of version three of CPPI (the main corporate system).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 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.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.