| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Pfafftown, NCPHONE NUMBER AVAILABLEEMAIL AVAILABLEJanuary Street Address - March 2022Data Analyst SQL ProgrammingExtensive experience ensuring business solutions are delivered in compliance with client requirements and quality standards. Proficient at testing source code, Data Modeling, Data Visualizations and Dashboard development. SQL Programming, Query Optimization, Database Administration.Code Writing Database Administration Program Testing Data Analytics Power AppsEXPERIENCEPGT Solutions March 2022-PresentWork on government contract with the Veterans Health Administration as a SQL DBA and Power Apps Developer. Developed canvas applications in Power Apps that supported administrative functions within the VA by creating workflows for process modelers to track their work within their teams. Also developed applications to track change requests and developed a Data Dictionary app to keep up with changes to the database for business units to record what changes were made and provide detailed information on the purpose of all the tables in the SQL Database. Assisted with Power BI reports and integration between Power Apps and Power BI.Digital Risk, Orlando Florida September 2021 December 2021Provided Data Analysis and data cleaning for Mortgage loan applications. Duties includedData CleaningData AnalysisDocumenting Process flowsLowe's Home Improvement, Mooresville NC March 2015 - December 2020Software Engineer, SQL Server AdminProvided maintenance on .NET application used to track all financial transactions that are processed in the stores, and for Trade Payable and Capital Expense invoices.Maintained backend SQL Server DB by writing Stored Procedures, DB optimization, Manage DB backups.Wrote C# scripts to apply bug fixes and enhancements to the Financial Application.Create PowerBI dashboards to track Financial StatisticsSQL Stored Procedure DevelopmentAsurion, Sterling VA January 2014 March 2015Data AnalystDuties included data mining, data cleaning, creating excel financial reports to provide to Management * SQL, Excel, MS Access, VBAHewlett Packard, Winston Salem NC November 2001 - January 2014.NET Application Developer SQL Administrator Project Manager IT Support ManagerDeveloped front web applications to track Hardware, Support tickets, and Inventory management.Maintained backend SQL Server DB by writing Stored Procedures, DB optimization,Managed DB backups.Wrote C# scripts to apply bug fixes and enhancementsAmerican Airlines, Winston Salem NC August 1986 - November 2001.NET Application Developer SQL Administrator Project Manager IT Support ManagerDeveloped front web applications to track Hardware, Support tickets, and Inventory management.Maintained backend SQL Server DB by writing Stored ProceduresManaged DB backups.SQL ProgrammerETL Data WarehousingEDUCATION/CertificationsAssociates Degree IT, Florida Technical College Orlando FLGoogle Data Analyst CertificationTECHNICAL SKILLSProgramming Languages:C# .NET, ASP.NET, Visual Basic, VBA, JavaScript, JSON, SQL, TSQL, MS OFFICE automation, HTML, Python, RDatabase Experience:MS SQL ServerIBM DB2OracleETL Database WarehousingSoftware Applications:Excel, Word, PowerPoint, MS AccessVisual Studio IDEVisual Studio CodeR StudioPowerBI,TableauJupyter NotebooksJIRA |