SUMMARY:

• Fourteen years of 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.
• Also, commands a strong software development background using various languages and tools: SSMS, SSRS, Active Reports.Net, .Net/Telerik Reports, PL/SQL, T-SQL, Java Script, C#, Power Shell, Visual Basic.Net, SQL Server Data Tools as well as XML and ASP.
• Great team mindset and attitude, plus excellent communication skills; both verbal and written.

TECHNICAL DOMAIN AND FUNCTIONAL EXPERTISE:

• T-SQL
• Microsoft SQL Server Administration
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• Power Shell Scripting
• Reporting Functional Layout and Design
• Requirements Documentation
• Database Development
• .NET Application Development
• Visual Basic .Net, VB Script, C#, PL/SQL, JavaScript
• XML based Report Design
• User Documentation

EXPERIENCE:

Confidential

Operations DBA

Responsibilities:

• Completing all configurations for setting up new environment database servers and providing a step by step procedural document for the same
• Scheduling and monitoring environment database refreshes to accommodate team needs
• Coding enhancements implemented in the TXN SSIS refresh process to reduce the turnaround time from an average of ninety to thirty minutes in addition to numerous changes to improve ODS database refresh packages
• Redesigning the database backup strategy, transforming it into a parameterized data driven process. Analysis and rewriting of all backup related stored procedures thereby resolving prior logic errors.
• 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
• Analysis and rewriting all database replication stored procedures for centralized implementation
• Gradually assuming lead role for external environments database server setup, SSIS database refresh package updates and data driven backup strategy implementation
• Debugging and resolving errors and providing troubleshooting support to DBAs as needed and participating in daily Agile/Kanban status meetings
• Understanding and monitoring the High Availability implementation 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:

• Responsible for designing and developing Telerik reports, a new reporting implementation
• Led the report development process and provided coding and debugging support as needed
• Insured that requirements were properly documented, supported QA testing activities, unit testing and troubleshooting

Report Developer

Confidential

Responsibilities:

• Responsible for creating SSRS reports and/or Telerik’s XML based reports, working with complex T-SQL queries and implementing functionality per requirements
• 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
• Developed a procedure to automate the creation of report metadata scripts for new reports which reduced development time from an average of three hours to approximately forty minutes
• Developed a procedure to capture existing report metadata where report cloning was desirable
• Eliminated the typical errors and related troubleshooting associated with manual metadata scripting

Confidential

Report Developer

Responsibilities:

• Primarily responsible for maintaining and developing custom reports (SSRS) for day to day business operations of associations using Confidential ’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 Confidential during development of its customized BPA reports. This support was a key factor in the acquisition of a firm contract to develop other reports for Confidential ; one of the company’s largest clients
• Developed a in-house document to support project managers’ need of acquiring a basic familiarity with BPA reporting

Confidential

SQL Data Modeler/Programmer

Responsibilities:

• Provided critical onsite client support for a Visual Basic 6 application
• Lead role in analyzing, troubleshooting and debugging application code
• Eliminated known and potential errors in addition to making enhancements into existing functionality

Confidential

.Net Application Developer II, Airport Business Manager

Responsibilities:

• Participated in the full software development life cycle (SDLC) for an application used nationwide in airports like Confidential and O’Hare
• Responsible for scrutinizing report layouts, verifying compliance with specifications, rigorous testing, functional analysis and converting complex Access queries to SQL Server 2000 stored procedures
• Designing and coding the application UI with its corresponding report, using Visual Basic .Net and Active Reports .Net.

Confidential

VB6 Programmer

Responsibilities:

• Served as an integral part of a team responsible for the full life cycle development of a financial software application used by small lending institutions in seven states
• Responsible for developing the application’s reporting module by converting Pascal into Visual Basic 6 in addition to discovering and resolving existing application errors and writing report queries
• Other responsibilities included: maintaining documentation for views, stored procedures and application code per the established standard, unit testing and user interface functional enhancements