| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateDatabase Specialist with 10+ years of experience in design, architecture, data modeling, development, and deployment. Analytical thinker who quickly and effectively identifies and resolves technical problems. Team player who succeeds in working with various colleagues by maintaining communication. Skilled in understanding business problems to develop systems that improve functionality. Self-motivated and striving for continual improvement.SkillsDatabase SkillsDevelopment ToolsApplicationsEssentialsDesign and DevelopmentSSMSMicrosoft Office ApplicationsAdaptability and FlexibilityETLSSISVBA MacrosRoot-cause AnalysisData MigrationVisual StudioConfluenceCritical ThinkingIntegrationScriptingSharePointExcellent CommunicatorWork HistoryJan 2024 Jun 2024 Database Documentation Specialist (contractor)TRINITY LIFE SCIENCES, Waltham, MAThoroughly documented the SQL database structures for pharmaceutical clients, including tables, relationships, stored procedures, views, and functions.Implemented cutting-edge software tools like Microsoft Azure AI to revolutionize our workflows.Improved productivity and accuracy by simplifying processes and introducing time-saving strategies.Gathered, organized, and recorded documents and other important information into Confluence for seamless collaboration and access.Jan 2023 Oct 2023 Performance Data AnalystLEHIGH VALLEY HEALTH NETWORK, Allentown, PAAnalyzed and communicated sensitive healthcare productivity and performance-based data for over 2000 clinical employees for high-level hospital executive management and colleagues in Lehigh Valley Physician Group.Automated routine tasks using scripting languages, allowing more time for advanced analyses.Developed custom dashboards and visualizations for easy data interpretation and analysis.May 2019 Nov 2022 Business AnalystDRAEGER MEDICAL INC., Telford, PAUtilized Microsoft SQL, CRM, SAP, and Robotic Process Automation (RPA) to maintain databases, reports, and dashboards to provide essential data for analyzing business performance and trending information to drive operational success.Developed applications that integrated Excel front ends with T-SQL back ends to maintain reports, dashboards, and end-user portals. These tools measured and analyzed the effectiveness of Service Operations, driving operating efficiencies and customer satisfaction. Additionally, implemented change management and change control processes to ensure smooth transitions and minimize disruptions during application updates and enhancements.Conducted interviews with management and key users to design databases using T-SQL backend and MS Access frontend, including data migration, to facilitate tracking of customer service contracts for hundreds of clients.Nov 2017 Mar 2019 Database Developer (Contractor)FEDCHEM, Bethlehem, PAUtilized project leadership skills to develop and improve an MS Access database, facilitating comprehensive tracking and reporting of chemical production operations, including managing various aspects such as raw materials sourcing and acquisition, along with product manufacturing, testing, and approval processes.FEDCHEM (continued)Presented automated raw materials receipts, batch records, government regulatory filings, and certificates of analysis reports through a user-friendly GUI front end using SQL queries, stored procedures, and functions.Nov 2014 Feb 2017 Application Developer (Contractor)MERCK, Upper Gwynedd, PAEmployed high-level mathematics and statistics in Excel with VBA while partnering with senior management on a cost evaluation data assessment project. Architected and deployed an application to produce reports that modeled and evaluated risk reduction, life expectancy, and cost for various drugs.Utilized data generated in the project mentioned above to evaluate the cost-effectiveness of multiple drugs and wrote reports to be utilized by various regulatory agencies worldwide.Nov 2013 Apr 2014 Database Analyst (Contractor)JOHNSON AND JOHNSON, Raritan, NJOrganized and spearheaded timely production of top-quality deliverables for healthcare transparency compliance initiative.Liaised with corporate stakeholders to gain insight into database development and enhancement project success.Customized and migrated compliance application from Access to MS SQL Server back end customized with VBA front-end code, rewrote functions to integrate with MS SQL, and rewrote VBA to SQL stored procedures.Facilitated data accuracy and integrity with MS Access VBA-enabled, data-quality application that identified and quarantined data errors and downloaded Excel spreadsheets.Jun 2013 Aug 2013 Database Developer (Contractor)PPL ENERGY-PLUS, Allentown, PAConferred with the accounting team to plan project details and gain an understanding of requirements. Coded, conducted user testing, deployed, troubleshot, and verified acceptance to ensure stakeholder satisfaction.Tailored tables, forms, and reports for internal customers in energy trading using MS Access databases featuring Visio diagrams and pulling data from multiple back-end Oracle databases.Streamlined the accounting department's periodic close process by upgrading and implementing Access databases. These databases integrated with the SunGard Aligne system using ODBC connections to an Oracle backend, while employing an MS Access frontend, all in compliance with departmental change control standards.Sep 2012 Jun 2013 Database Developer (Contractor)THE GUARDIAN LIFE INSURANCE COMPANY, Allentown, PAWorked closely with corporate stakeholders and management team to gather project requirements, design specifications, user testing, and user acceptance to upgrade, document, track, and deploy a database application.Developed an Oracle back end using ETL in PL/SQL packages (procedures and functions) in collaboration with the .Net front-end team to replace an obsolete application.Successfully completed database and data migration for a customer service application, transitioning from an Access backend to an MS SQL Server backend. Customized with VBA frontend code, Rewrote functionality to optimize performance with the MS SQL backend, essentially eliminating hour-long bottlenecks.EducationMORAVIAN UNIVERSITY, Bethlehem, PABachelor of Science in Chemistry, Mathematics MinorContinuing education in Computer Science.THE CHUBB INSTITUTE, Parsippany, NJVocational Diploma in Computer ProgrammingCertificationCertified RPA Associate UI Path |
