SUMMARY:

Broad knowledge and success in software development environments. Proficient in quality, integration, and development of software / database systems. Able to direct multiple tasks effectively and readily master innovation software and tools

AREAS OF EXPERTISE:

• SQL DBMS Development
• Programming experience using JavaScript, VB.Net, C#, HTML/CSS, Visual FoxPro, and Python
• Data Analysis and Reporting
• Design, Implement, and Maintenance of new and existing database objects
• SSIS (ETL) Package Development & Deployment
• SSRS (RDL) Report Development & Deployment
• Requirements Gathering / Business Analysis

TECHNICAL PROFICIENCIES:

Platforms: Windows

Tools: Microsoft SQL Server Management Studio (SSMS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft Business Intelligence Platform (BI Cubes), VB Script, Java/JavaScript, HTML, C#, XML, Visual FoxPro, Eclipse, Python 3.6.6, Power BI

Software: Visual Studio (.Net), SQL Server Management (SSMS), SQL Server Integration Services (SSIS), SQL Report Service (SSRS), Image Right Document Management System, Atlassian Jira Change Management, Power BI, Target Process

PROFESSIONAL EXPERIENCE:

Confidential

SSRS Analyst

Technical Scope: SQL Server Database, Analyzing Information, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals, Agile environment with focus on customer reporting

Responsibilities:

• Create and maintain customer reports for client base while apply consistent framework for development and deployment for standard reports.
• Utilize SSIS and ETL (integration) techniques to enhance data integration and data warehousing capabilities.
• Monitor data for consistency.
• Perform queries to analyze and troubleshoot customer issues.
• Import export data in a variety of file formats using various database applications (primarily Microsoft Visual Studio, SSMS, and SQL Server Data Tools for Visual Studio).
• Deploy solutions to SSRS server via Team Foundation.

Confidential

Consultant / SQL Developer

Technical Scope: SQL Server Database, Analyzing Information, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals, Software Documentation, Software Testing, Software Requirements, Agile environment with focus in Business Intelligence reporting

Responsibilities:

• Generate ad hoc queries and custom reports utilizing SQL Server Management tools.
• Produce queries and reports to align business unit needs and specifications by ensuring effective communication and successful implementation of requirements and objectives.
• Translate and analyze requirements from business users.
• Utilized Power BI and Python data science tools to streamline upward reporting.
• Used skills and knowledge to lead effort for automating manual reports / processes
• Worked closely with business unit to create / modify existing queries and reporting processes for optimal use
• Led efforts to leverage Power BI and Python data science tools to improve reporting function to upper management

Confidential

Programmer Analyst

Technical Scope: SQL Server Reporting Services (SSRS) & SQL Server Integration Services (ETL & SSIS), Analyzing Information, Database Administration and Development, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals, Software Documentation, Software Testing, Software Requirements

Responsibilities:

• Utilized JavaScript/VB.Net/C# and Microsoft Visual Studio for development of custom workflows and SSIS integration.
• Architected, designed, and developed intranet applications using HTML/CSS.
• Implemented UI design using HTML and CSS.
• Developed, deployed, and maintained ETL packages using stored procedures, functions, and scripts in the Microsoft SQL Server environment.
• This also includes troubleshooting T - SQL and SSIS processes.
• Using specified change management protocols to design, implement, and maintain database objects including tables, views, and stored procedures using Microsoft SQL Server technologies. Generate ad hoc queries and custom reports utilizing SQL Server Reporting Services (SSRS).
• Propose data integration and data transformation solutions using SQL Server Integration Services.
• Arrange databases and products to align with end users’ needs and specifications by ensuring effective communication and successful implementation of requirements and objectives.
• Translate and analyze requirements using various programming languages.
• Supported the implementation of lockbox process for accounts receivable and audit services. This process relied heavily on ETL packages, SQL stored procedures and functions
• Participated in end user consultation to enhance effort in delivering technical content and discussions.

Confidential

Software Quality Analyst

Technical Scope: SQL Server Management Studio: Collecting, analyzing, and summarizing information

Responsibilities:

• Reviewed functional and design specifications to ensure full understanding of individual deliverables.
• Operated backend database testing in Microsoft SQL environment including validating stored procs, jobs, and triggers.
• Identified test requirements from specifications, map test case requirements, and design test coverage plan.
• Developed, documented, and maintained functional test cases and other test artifacts, including test data, data validation, harness scripts, and automated scripts.
• Performed automated testing services in collaboration with engineering team.
• Targeted potential quality issues per defined process and escalated potential quality issues immediately to management.
• Inspected validated deliverables to ensure functional and design specifications and requirements.
• Explored report defects and verified defect fixes by isolation and replication processes.
• Successfully created, edited, and verified quality standards and test procedures for program design and production evaluation to ascertain quality of software.
• Provided detailed documentation to corporate resulting in reduction resolution time.

Confidential

Treasury Services/Accounts Payable Specialist

Responsibilities:

• Reconciled processed work by verifying entries and comparing system reports to balances.
• Charged expenses to accounts and cost centers by analyzing invoice/expense reports; recording entries.
• Paid vendors by monitoring discount opportunities.
• Verified Federal ID numbers scheduled and prepared checks, resolved purchase orders, contracts, invoices, and payment discrepancies.
• Prepared documentation and insured credit is received for outstanding memos.
• Issued stop-payments or purchase order amendments.
• Received and verified employee timecards, expense reports, and accounting ledgers.
• Disbursed checks and petty cash by recording entries and verifying documentation.
• Reconciled monthly statements related to transactions.
• Supported launch and maintenance of document management software to scan financial documents / payments for electronic remittance