Post Job Free

Resume

Sign in

Sql Server Software Engineering

Location:
Timonium, MD
Posted:
December 26, 2023

Contact this candidate

Resume:

EDUCATION:

DSc. Applied Information Technology

Towson University, Towson, Maryland

Research areas: Enterprise Architecture, Bioinformatics

MS Computer Science, Software Engineering Track

Towson University, Towson, Maryland - December 2007

Bachelor of Science in Computer Science with an interdisciplinary emphasis in Biology

University of Central Arkansas, Conway, Arkansas – May 2005

TECHNICAL SKILLS:

Programming: Visual Basic.Net, C++, C#, Oracle, SQL, PL/SQL, HTML, CSS, JavaScript, Assembly Language, OpenGl, Action script, ADO.Net, PHP, ASP.NET, XML, SQL Server Reporting Services (SSRS), SQL Server Integration Service (SSIS), Bootstrap

Platforms: Windows XP, Windows NT 2000, Windows 98, Window 95, UNIX

Software: Word, PowerPoint, Outlook, CorelDraw, WordPerfect, Dreamweaver, Flash, FrontPage, Access, Excel, Photoshop, ERwin, Informatica, Visio

Relevant Courses: Database Management, Data Structures, Parallel Programming, Networking, Operating Systems, Software Engineering, Computer Graphics, File Structures, Expert Systems, Data Mining, Project Management, Object Oriented Methodology

Methodologies: OOP/D, UML, Design Patterns

Tools: Visual Studio, Microsoft SQL Server Management Studio, CodeWarrior, Visual C++, SQL.net, TOAD

Networking: TCP/IP, UDP, Routing

Databases: Oracle 10g/11i, SQL Server 2008/2012/2015/2017/2019, PL/SQL, mySql, Access,

Mongo DB

PROFESSIONAL EXPERIENCE:

Broadcast Sports International, Hanover, MD July 2018 to Present

Senior Software Developer Analyst

Broadcast Sports International (BSI), is the leading edge of turnkey custom broadcast solutions. BSI produces live large sporting matchups to history-making live events through cutting-edge camera, wireless transmission, and microphone technology.

Lead a team of three (3) developers and a tester to design, build and maintain all business applications.

Interact with stakeholders to gather requirements and required solutions.

Act as scrum master for all ongoing web development projects

Re-designed and implemented legacy VB 6 applications to ASP.net web applications.

Involved in the development of Travel Portal where crew can view their schedule, travel dates and hotel information.

In charge of all internal web applications

Train stakeholders on developed software use.

Worked on adding new functionalities to Event and Inventory management application a ASP.NET Core Web API, React, SQL Server.

Designed and developed cable assembling tool with React, ASP.NET Core, SQL Server

Administrator for SAGE 100 and R2 Applications

Environment: MS Projects, MS Visio, VB.NET, C#, CSS, HTML, JAVASCRIPT, REACT, NODE JS, ASP.NET, ASP.NET CORE, MVC, SQL server 2005/2008/2012/2015/2017 SSIS, SSRS, change Control Management, VS 2013/2017/2019, Azure DevOps, R2

UnitedHealth Group, Baltimore MD December 2011 to July 2018

Senior Programmer Analyst

XLHEALTH, now UnitedHealth Group is a leading provider of disease management and support programs to chronically ill patients, physicians, health plans and employers.

Designed, built, and maintained the Member Portal application. The Member Portal Application is used by members to track claims and place member requests. The portal is developed in ASP.NET, MS Visual Studio.net, C#, XML, HTML, DHTML and JavaScript. Followed n-tier application module with UI, Business, Service and Data Access Layer using C#.net.

Involved in the development of Provider Portal where providers can view the status of their claim, dispute a claim, view their EOP and check member eligibility etc. The portal is developed using Facets sql database to display claims, remittance, and provider information.

In charge of all internal Unified Letters web applications

Designed, Developed and Maintained Claims Web application using ASP.net and SQL 2008, SQL 2012

Designed, Developed and Maintained Appeals and Grievance web application using ASP.net and SQL 2012

Designed, Developed and Maintained Enrollment letters web application using ASP.net and SQL 2012

Involved in entire SDLC.

Redesign report to track and resolve issues with missing member cards and letters.

Created store procedures to track and load images in OnBase document management system.

Technical lead for Cosmos project. The Cosmos project is a report generation platform for different business branches.

Worked on adding new functionalities to Task Tracker an ASP.NET MVC with a SQL Server backend.

Environment: MS Projects, MS Visio, VB.NET, C#.NET, CSS, HTML, JAVASCRIPT, ASP.NET, MVC, Windows 8, SQL server 2005/2008/2012 SSIS, SSRS, change Control Management, VS 2005/2008/2010/2013, Facets 4.21, 5.01 and EAM

Camden County Police Department, Camden NJ July 2015 – December 2015

Data Warehouse Architect (Freelance)

Camden County Police department is developing a new tool to help with their day-to-day police work. They have over 10 years of data that will not be part of the new tool hence they need a data warehouse to help with analysis, forecasting and reporting.

Responsible for auditing existing reports to help gather requirements for the new data warehouse.

Met with all stakeholders to gather necessary requirements and possible new functions.

Created requirement document for sign off from stakeholders.

Responsible for design and development of the end-to-end ETL process

Responsible for Extracting, Scrubbing, and transforming data from flat files and other sources, and then loading into Sql server database using SSIS

Designed and developed prototype of data warehouse.

Environment: MS Projects, MS Visio, C#.NET, CSS, HTML, JAVASCRIPT, ASP.NET, SQL server 2008/2012 SSIS, SSRS, change Control Management, Tableau, Informatica, VS 2013

MedStar Health Research July 2011 to December 2011

Application Developer

Maintained and developed large enterprise web-based business applications utilizing Microsoft ASP.NET development.

Developed and maintained MS SQL Server databases for all ongoing research.

Worked within the existing applications satisfying cases/changes in the enterprise IT applications written in web based ASP.Net.

Developed and maintained websites for all researchers and board members.

Environment: ASP.NET, C#.NET, CSS, HTML, JAVASCRIPT, SQL server 2005/2008/2012 SSIS, SSRS, change Control Management, and VS 2005/2008/2010/2013

Nationwide Better Health October 2010 to June 2011

IT Application Developer/ SQL Server Developer

Create stored procedure to support business rules for delivering Incentives to NBH clients.

Involved designing and coding the automation of Incentives processes using ASP.NET and C#.

Involved in daily/weekly meetings to discuss client requirements, and technical specifications.

Create SSIS packages to automate import job (Importing data from Oracle to SQL server).

Create Performance Reports to compare the Import times.

Create detailed technical specifications for Incentives projects.

Create function Triggers.

Create Data dictionary, ERD and other UML diagrams.

Use of UML in technical design and documentations

Lead a team of 4 developers to design and develop the Incentive Processing Information System’s Web Application Project

Environment: MS Projects, MS Visio, VB.NET, C#.NET, ASP.NET, Windows XP, SQL server 2005/2008 SSIS, SSRS, change Control Management, and VS 2005/2008/2010

Zimmerman & Associates September 2009 to October 2010

Applications Developer / Configuration Management Lead

Involved in project planning and development.

Leading a team of 15 developers for Web and Data Services projects

Responsible for gathering requirements and writing SRS and SDD

Responsible for writing project configuration management plan

Responsible for Web and Data Services projects Configuration and Change Management using CMMI practices.

Involved in designing, coding, and testing.

Involved in development Web and Data Services web application using C# ASP.NET

Involved in debugging, changing, and adding new functionalities to existing C#, ASP.NET code

Handle queries regarding XML and troubleshoot the complex technical XML problems

Environment: MS Projects, MS Visio, VB.NET, C#.NET, ASP.NET, Oracle 10g, SQL Server, SharePoint 2007

Global Payments, Inc. October 2008 to May 2009

Application Developer

Designed and developed internal software programs to facilitate both manual and automated processing of credit card chargeback cases. System was responsible for processing 10,000 cases per day. Software developed in C++/C# with backing data persisted to an Oracle database.

Involved in gathering of requirements

Responsible for analyzing requirements.

Involved in adding additional functions to existing application

Involved in changing VB ASP.net applications to C# ASP.net applications

Involved in designing, coding, and testing

Involved in problem determination and solving

Involved in analyzing and tuning of code to enhance performance

Environment: HTML, CSS, C++, VB.net, C#, ASP.net, SQL, Toad, Visual Studio.Net, Oracle 10g

DeJarnette Research Systems, Inc. February 2007 to September 2008

Oracle PL/SQL Developer/Development Engineer

Responsible for analyzing requirements.

Involved in Design and development of databases.

Involved in designing and coding of SQL queries and PL/SQL procedures.

Responsible for documenting test cases and testing SQL and PL/SQL code.

Involved in analyzing and tuning of SQL and PL/SQL code based on performance.

Involved in the installation and tuning of oracle software/databases

Modify, enhance and add new functionalities to existing C#, ASP.NET code

Environment: C#, C++, Oracle, SQLplus, VisualStudio.NET, Oracle10g, 9i

Thomas & Associate October 2005 to December 2005

Entry Level System Engineer/ Programmer

Involved in Design and development of end-to-end ETL process using Informatica Power Center.

Extracting, Scrubbing, and transforming data from flat files, and then loading into oracle database using SQL* Loader.

Used various stored procedures in the mappings.

Involved in the design of the overall database using Entity Relationship diagrams.

Performed Unit and Integration testing of Mappings.

Involved in full Software Development Life Cycle (SDLC).

Involved in developing Navy ship fire drill training software using C#, ASP.NET

Involved in full software development lifecycle (SDLC).

eTeam Inc. February 2005 to October 2005

Data Warehouse Consultant Trainee

Involved in Design and development of end-to-end ETL process using informatica Power Center.

Involved in using data modeling tools like ERwin and ER diagrams with Model mart exposure.

Extracting, Scrubbing, and transforming data from flat files, and then loading into oracle database using SQL* Loader.

Used various stored procedures in the mappings.

Involved in the design of the overall database using Entity Relationship diagrams.

Performed Unit and Integration testing of Mappings.

Involved in full Software Development Life Cycle (SDLC).



Contact this candidate