SUMMARY:

• Fourteen years of Report Development experience which includes the design and development of large - scale web-based applications, participation in various stages of the project lifecycle such as requirements gathering, user interface design, application coding, testing, troubleshooting, documentation, and end-user support.
• Additional experience as Operations DBA maintaining development and test environments.
• Also, commands a strong developer background using various languages and tools. Great team mindset and attitude, plus excellent communication skills; verbal and written.

TECHNICAL SKILLS:

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

PROFESSIONAL EXPERIENCE:

Operations DBA

Confidential

Responsibilities:

• Primary oversight of 30 internal environments to insure availability and readiness
• Mentoring designated team members on overall processes for environment support and maintenance
• Completing all configurations for setting up new environment database servers
• Providing a detailed step by step procedural guide for new database server configuration and setup
• Scheduling and monitoring environment database refreshes; resolving errors as needed
• Analyzing code and implementing enhancements in the DB SSIS refresh process
• Reduced the turnaround time from an average of ninety to thirty minutes
• Analyzing and redesigning the database backup strategy
• Transformed it into a parameterized data driven process
• Rewrote all stored procedures, resulting in more robust code
• Eliminated code redundancy, improved accuracy, scalability and visibility
• Designing a data model to support implementing a centralized DB refresh process to achieve consistency across environments
• Analyzing and rewriting all replication stored procedures for centralized DB refresh implementation
• Assuming lead role monitoring refresh activity and readiness of 6 customer-facing environments
• Troubleshooting and error resolution support to DBAs across environments as needed
• Participating in daily Agile stand-up meetings and periodic retrospectives
• Understanding and monitoring the High Availability cluster on the Integration environment
• Participating in the development of Power Shell automation processes
• Providing Power Point and/or Word documentation of major revisions and new implementations

Report Developer

Confidential

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 report metadata scripts, reducing development time by an average of three hours
• Implemented a second process to capture existing report metadata for effective report cloning
• Again, reduced development time by hours thru the elimination of typical errors and related troubleshooting associated with manual metadata scripting
• Routine analysis and troubleshooting of T-SQL code to correct errors in existing reports
• Led efforts to design the team’s requirements gathering document and to improve the overall quality of documentation
• Lead responsibility for the first major revision of the BPHC Dashboard User’s Guide as well as the development of the reporting team’s Peer-Review Guidelines document

Report Developer

Confidential

Responsibilities:

• Designed and maintained custom SSRS reports for daily business operations of associations using Avectra’s AMS - netFORUM
• 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 the acquisition of a firm 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

SQL Data Modeler/Programmer

Confidential

Responsibilities:

• Provided critical onsite client support for a Visual Basic 6 application
• Lead role in analyzing, troubleshooting and debugging application code
• Resolved numerous application errors and blockers
• Proactively addressed potentially faulty code logic/best practices and implemented enhancements to functionality

.Net Application Developer II

Confidential

Responsibilities:

• Participated in the full software development life cycle (SDLC) for an application used nationwide in airports like BWI and O’Hare
• Detailed analysis of report layouts to verify compliance with specifications
• Converted complex Access queries and reports to Visual Basic .Net application
• Designing and coding the application UI with its corresponding report, using Visual Basic .Net and Active Reports .Net.

VB6 Programmer

Confidential

Responsibilities:

• Served as an integral part of a team involved in the full life cycle development of a financial software application used by small lending institutions in seven states
• Designed and managed the application’s reporting module converting Pascal to Visual Basic 6
• Developed and maintained T-SQL views, stored procedures and application code per the established standard, in addition to unit testing and user interface functional enhancements