SUMMARY:

Fifteen years of experience which includes a mix of Report design and development using T - SQL/SQL Server Management Studio, integrated with large-scale web-based applications and participation in various stages of the project lifecycle. Engaged in requirements gathering, end-user support, application development, testing, troubleshooting and documentation. Additional experience in the capacity of an Operations SQL Developer/DBA, managing and maintaining development and test environments. Experience working with development teams using traditional SDLC as well as Agile/Scrum methodology. Great team mindset and attitude, plus excellent listening and communication skills; verbal and written.

TECHNICAL DOMAIN AND FUNCTIONAL EXPERTISE:

• T-SQL
• Microsoft SQL Server Administration
• PL/SQL
• SQL Server Reporting Services (SSRS)
• Tableau (introductory)
• SQL Server Integration Services (SSIS)
• Power Shell (introductory)
• Requirements and User Documentation
• Database/Environment Support
• Visual Basic.Net, VB Script, C#
• Application Development
• JavaScript, HTML, XML
• Oracle Forms
• Active Reports .Net

EXPERIENCE:

Confidential

Database Analyst

Responsibilities:

• Initial assignment to develop proficiency with Warning Calls for pending application expiration and processing expirations for DMI and SVI issues
• Automation of Warning Call manually executed script within 50 days of hire
• Within 4 months rewrote code for processing DMI expirations to facilitate prompt submission of expiration estimates to CMS
• Design includes 11 procedures, 3 functions and a new exclusion, logging and staging table
• Design eliminates code redundancy and error prone modifications tied to manual executions
• Reduces time required to provide expiration estimates from max of 8 hours to between 10 and 15 minutes
• Enables more efficient handling of various and numerous ad-hoc requests for reloading and excluding applications from expirations
• Participate in daily scrum status sessions
• Maintain accurate status of respective assigned issues via JIRA tickets
• Address and resolve data issues as assigned

Confidential

Senior SQL Developer

Responsibilities:

• Created views, stored procedures and other objects as needed to satisfy client user stories
• Troubleshot query and stored procedure performance issues as needed
• Provided corrections for critical calculations and high-profile reports and processes to resolve inaccuracies
• Collaborated with team members on design and architecture as needed
• Performed code reviews of database objects created by team members
• Participated in scrum sessions, periodic retrospectives and interact with the client regularly, given work is done at the client location
• Achieved a working understanding of the application data model as well as the procedure logic of various modules in preparation for an October 2017 go-live
• Implemented a data driven staging process to move data from sixteen ORACLE source tables via a single stored procedure with no code redundancy. This process designed in lieu of an ETL implementation via SSIS which was pending
• Establish Data Dictionaries, database diagrams and coding standards/guidelines
• Implemented and documented both, the database encryption (TDE) and recovery strategy
• Ongoing interaction with team members to address client needs for improving the UFMS (Unified Financial Management System)

Confidential

Operations SQL Developer/DBA, Internal/External Environment Support

Responsibilities:

• Primary oversight of 30 internal environments to insure availability and readiness of solution databases
• Mentored designated team members on overall processes for environment support and maintenance as well as database refreshes and backup processes
• Completed all configurations for setting up new environment database servers
• Provided a detailed step by step procedural guide for bringing newly provided database servers to a state of usability/readiness
• Scheduled and monitored environment database refreshes; resolving errors as needed
• Analyzed T-SQL and implemented enhancements in the SSIS database refresh process
• Reduced DB turnaround time from an average of ninety to thirty minutes
• Redesigned the existing database backup strategy
• Transformed it into a parameterized data driven process
• Rewrote all T-SQL backup stored procedures, resulting in more robust code
• Eliminated code redundancy, improved accuracy, scalability and visibility
• Designed supporting data model for implementing a centralized DB refresh process to achieve consistency across environments
• Analyzed existing T-SQL and rewrote all replication stored procedures for the centralized DB refresh implementation
• Assumed oversight of SSIS package revisions for database refresh activities and readiness of 6 customer-facing environments
• Provided troubleshooting and error resolution support to DBAs across environments
• Participated in daily Agile stand-up meetings and periodic retrospectives
• Acquired working understanding of and monitored the High Availability cluster on the Integration environment
• Participated in the development of Power Shell scripting for automating database processes
• Provided Power Point and/or Word documentation of major revisions and new implementations

Confidential

Report Developer

Responsibilities:

• Designed SSRS and Telerik reports for the Electronic Handbooks (EHBs) Enterprise Reporting Solution, working with complex T-SQL queries and report designs to meet client needs
• Automated the creation of SSRS report metadata using T-SQL to build the RDL's XML file which reduced development time by an average of three hours
• Implemented a second T-SQL process to capture existing report metadata for effective report cloning
• Reduced report development time by one to three hours (depending on complexity) thru the elimination of typical errors and related troubleshooting associated with manually scripting the metadata XML file
• Routinely analyzed and did troubleshooting of T-SQL views and stored procedures to correct errors in existing reports
• Led efforts to design the team’s requirements gathering document and to improve the overall quality of documentation
• Performed the first major revision of the BPHC Dashboard User’s Guide and led the development of the reporting team’s Peer-Review Guidelines document

Confidential

Report Developer

Responsibilities:

• Designed and maintained custom SSRS reports for daily business operations of associations using Confidential ’s AMS - netFORUM
• Worked routinely with complex T-SQL queries and stored procedures, developing new reports in addition to troubleshooting and resolving existing reporting issues
• Managed hot fixes, builds and service packs for baseline reports
• Served as the primary analyst for the development of all Business Publication Auditing (BPA) reports
• Provided ongoing customer support to the American Chemical Society (ACS) during development of its customized BPA reports. This support was a key factor in acquiring a contract to develop additional reports for ACS; one of the company’s largest clients
• Compiled a BPA Guidelines document to support project managers’ in acquiring familiarity with BPA reporting