Database Developer Resume
Las Vegas, NevadA
OBJECTIVE:
I am a highly motivated IT developer with many years’ experience in the Microsoft SQL Stack / Teradata environments and I am perusing a full - time, permanent position in data Analysis, Reporting and Planning. I will only consider direct hire, permanent positions in the Houston, Texas area.
SUMMARY:
- Developing Microsoft Business Intelligence (BI) reports to provide mission-critical metrics and statistics
- (SSRS) creating stored procedures, triggers, and functions.
- Integration Services (SSIS) generating code to extract, transform and load (ETL) data in support of new data warehousing initiatives.
- Critical day-to-day application support with SOP writing,, testing, and data management.
- Applications planning, development and testing in an Agile/Scrum Project Development environment, working closely with .NET developers.
- QA Analysis including function, regression, and unit testing.
- Data warehouse Analysis Services
- Dashboard development, business forecasting.
SKILL:
Databases: SQL Server Management Studio 2005/2008R 2/ 2012/2014/2016 , Teradata TTU 16.20, Microsoft Visual Studio 2017, Microsoft SQL Server Data Tools, Microsoft SQL Server Management Studio, Teradata SQL Assistant, BTEQ, Microsoft Power BI, Microsoft Office 365, Automic Integration Service automation, Microsoft Visio, Oracle SQL Developer, Python 3.7, Notepad++, AMISYS Claims Database Management
Operating systems: Microsoft, UNIX
Excel Tools: PowerPivot
Excel: Create and edit connections to external data sources
Data visualization: Power BI, Sisense for OLAP cube creation against a data warehouse
Medical Claims Submission System: Pulse8, TriZetto QNXT
Source Control: Serena Dimensions, Microsoft Team Foundation (TFS); Borland StarTeam
Portal Technology: Microsoft SharePoint 2010
Software Development Management: Symantec Altiris
Accounting Software: Microsoft Dynamics Great Plains Solid verbal and written communication skills
PROFESSIONAL EXPERIENCE:
Confidential, Las Vegas, Nevada
Database Developer
Responsibilities:
- Building procedures to analyze all aspect this massive hospitality provider’s customer activity.
Confidential, Houston, TX
SQL / ETL Developer
Responsibilities:
- Develop patient matching software with associated automated processes for both internal and external clients.
- Create an initial proof of concept code for an HL7 standard electronic data transfer protocol.
- Assist in the development and performance of SSIS data maintenance procedures.
Confidential, Nashville, Tennessee
SQL Developer
Responsibilities:
- Develop SQL SSIS packages to assist RAPS claims submission
- Troubleshoot existing code when errors generated
- Create new procedures to accommodate changing CMS requirements.
Confidential, Dallas, Texas
SQL Developer
Responsibilities:
- Maintain SQL Code Library
- Unit testing for code modification
- Process documentation
Confidential, Fort Worth, Texas
Senior Business Intelligence Developer
Responsibilities:
- T-SQL programming for the creation of stored procedures, triggers, functions, table creation, data insetions and deletions.
- SSRS Business Intelligence: Medicare Risk Adjustment SQL report development for for metrics and productivity
- SSIS programming data integration
- Sisense for data ware house visualization and cube creation
- Business analysis: including analysis of trends for Confidential -based risk adjustment factors, analysis of RAPS return files, submission QA, RAF projections, demographics studies
- Work closely with DBA for database management, implementation of SQL procedures and jobs; creating and maintaining a data warehouse
- Play key roles in the design of specialty software with testing and deployment
- Supporting company Business Intelligence (BI) initiatives (client mission critical metrics and statistics) Excel-based dashboards, BIDS dashboard, BI Reports generation utilizing BI tools (SSRS) that involved the creation and deployment of complex T-SQL stored procedures into BIDS as well as report implementation in a Microsoft SharePoint portal environment
- Development of Integration Services (ETL) packages in support of warehousing initiatives (SSIS)
- Data modeling, database creation and implementation to develop and design database objects, such as tables, indexes, constraints. Microsoft Team Foundation Source Control. Altiris Software Management
- Improved quality of software updates through functional testing of new software products Inventory Control, LIMS Stats, IQAS Quality Assurance Program using the Agile Software
- Creating UI test strategies/test plans; developing test cases; developing and executing case test scripts, regression, requirements testing and performance testing in a time-demanding fashion
- Supporting proprietary Laboratory Information Management System with SOP writing,, testing, and data management