Business Intelligence Developer Resume
Houston, TX
SUMMARY:
I am a Software Developer with 11 years of experience with Microsoft .NET technologies. My primary custom development experience is with ASP.NET and C# solutions. In addition to web and windows based applications, I have skills and experience with Microsoft SQL Server, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). My most recent experience is with schema design and authoring stored procedures to be used by custom applications, SSIS packages, and SSRS reports.
TECHNICAL SKILLS:
- Visual Studio 2000 - 2015
- ASP.NET 1.0 - 4.5
- Silverlight 4
- C#, Visual Basic
- .NET Framework 1.1 4.5
- SQL Server 2000 2016
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- SQL Server Master Data Management
- WCF, Web Services, RESTful Services
- ASP.NET MVC Web API 2
- Excel, Power BI
- Word, Visio, Access
- Agile Software Development
- Scrum Software Development
- Team Based Development
- OOP
- Client/server development
- Relational Database Design
- Telerik, Infragistics
- TFS, Subversion, MKS, Serena
- Oracle
- TOAD
- SQL
- Java
- JavaScript jQuery jQuery UI
- HTML
- XML
- JSON
- UML
- MVC
- MVVM
- SQL Developer
RELEVANT EXPERIENCE:
Confidential
Business Intelligence Developer, Houston, TX
Responsibilities:
- As a Report Developer, created Power BI proof of concept using mastered data, financial data, and data from other internal systems.
- As a Report Developer, created Power BI report for data quality.
- As a Service Developer, started development for an ASP.NET MVC Web API for mastered data.
- As an ETL Developer, maintained ETL processes for mastering data and maintained SSIS packages for financial data.
Technologies used: ASP MVC Web API 2, WCF, RESTful Services, XML, JSON, SQL Server 2016, SSIS, MDM, SQL Server Stored Procedures, and modified existing data model.
Confidential
ASP.NET Developer, Houston, TX
Responsibilities:
- Created a WCF RESTful Service to encapsulate existing functionality for searching for medical providers, medical facilities, and pharmacies. This web service was designed to expose this business functionality to websites and mobile applications.
- Upgraded a Classic ASP web page to an ASP.NET 4.0 page. This page enabled medical providers to request a specialist through the provider portal.
Technologies used: ASP.NET 4.5, Classic ASP, Visual Basic, javascript, SMTP, Telerik Controls, WCF, RESTful Services, XML, SQL Server Stored Procedures, and modified existing data model.
Confidential
Senior Programmer/ Researcher, Houston, TX
Responsibilities:
- As a SQL Developer, created and maintained two Extract, Transform, and Load (ETL) processes for loading VA Medical Patient Data into the Confidential ERP System. The ETL processes also extracted completed exam results and any other information back to the VA.
- As a SQL Developer, created automated SQL jobs to advance the exam schedule status and to send medical providers their daily schedules.
- As a SQL Developer and as part of a development team, created the component to load Exam Requests based on one of my decommissioned processes for loading VHA Exam Request Data.
- As an ASP.NET and Web Service Developer, added components for doctors to maintain exam schedule, to request x-rays, and to approve or cancel exam diagnostics.
- As an ASP.NET Developer, added validation and other business rules to VA Disability Benefits Questionnaires. Also maintained the portal for general bug fixes.
- As an ASP.NET developer, created a framework for providers to endorse documents from the ASP.NET 3.5 web portal.
Confidential
ASP.NET Developer, Houston, TX
Responsibilities:
- As part of a development team, assisted in completing two ASP.NET 4.0 solutions used by Pointsmith’s clients to purchase goods and merchandise. The applications were multi-tiered and utilized SQL Server 2008 as their data store. These applications also communicated with the company’s legacy SQL Server 2000 databases for reporting needs.
- Technologies used: ASP.NET 4.0, C#, jQuery, Telerik Controls, WCF, RESTful Services, and SQL Server Stored Procedures.
Confidential
ASP.NET Developer, Houston, TX
Responsibilities:
- Assisted in completing an ASP.NET solution for account management. Helped with completing missing requirements before the final release of the application. This application had many layers of code and had to be careful where to make modifications. Technologies used: ASP.NET, WCF, C#, SQL Reports, and SQL Server Stored Procedures.
- Assisted in developing an ASP.NET solution for Work Force task management.
Technologies used: ASP.NET, WCF, and SQL Server.
Confidential
ASP.NET Developer, Houston, TX
Responsibilities:
- Assisted in completing a Silverlight/ASP.NET application. The purpose of the web application was to help managers create and maintain their work force plans and improve their ability to forecast employee headcount and cost of their workforce. This project exposed me to Silverlight 4.0. I helped develop the Silverlight user controls, the WCF Service, and any SQL development. I also designed and developed the ASP.NET pages and Reporting features of the application.
Confidential
Senior Software Engineer/Consultant, Houston, TX
Responsibilities:
- For a government funded insurance group, designed and developed a SSRS Demo for SQL Server 2008 R2. I designed the demo database, wrote the SQL Stored procedures, and dashboard reports that contained Map/GIS integration, along with traditional dashboard gauges, dials, and charts.
- For a chemical company, served in a Staff Augment position as a Report/Web developer. I created and maintained SSRS Reports, ASP.NET 2.0 and ASP.NET 3.5 Dashboards and Scorecards, SQL Server Stored Procedures, two small SSIS packages, and some data modeling.
- The reports and websites were for their HR Dashboards, IT Dashboards, and Customer Service Dashboards. This project exposed me to the Dundas UI Controls for ASP.NET and SSRS reports.
- For a leading oil company, created ETL SSIS packages for loading oil production data into a Data Mart that would be used by a the company’s web portal for reporting and managing oil production and related assets. I developed SSIS packages based on the oil company’s ETL framework.
- For a major electric power company, created ETL SSIS Packages to load critical financial data from several Oracle data sources to a SQL Server Data Warehouse that would be used as a data source for financial reporting. I developed SSIS packages based on Confidential ’s ETL framework.
- For a leading oil company, participated on a team that performed an assessment and evaluation to quantify the migration effort of an existing 40 year old legacy system using PC-Nomad and Confidential technologies to a .NET solution.
Confidential
Application Developer, Hattiesburg, MS
Responsibilities:
- Designed and developed a project cost tracking system using ASP.NET 2.0 and C#. It replaced an existing Microsoft Access application. The system is comprised of Microsoft SQL Server 2005 and utilized SSRS to produce classified and unclassified reports.
- Developed a Windows C#.NET 2.0 application for project managers to control and manage the finances of their projects.
- Designed and developed employee auditing software using ASP.NET 1.1 and C#. This software tracked the project milestones, employee assignment to projects, and employee’s timesheet, which detailed how the employee’s time was allocated to projects.
- Key skills used include team based development, OOP methodologies, client/server development, Relational Database design and development, and reporting services.