PAVEL (PAUL) DEMYANCHUK

Email: acxhdd@r.postjobfree.com

Cell: 904-***-****

SUMMARY AND OBJECTIVES

Passionate IT Professional with SQL development and Manual QA background, avid networker, and enthusiastic team player seeking for SQL Developer and SQL Server Developer opportunities. Excellent written and oral communication skills, outgoing personality, and impeccable attention to detail. I would eagerly join agile development team, share my expertise and keenly learn from peers to deliver value. ACHIEVEMENTS AND QUALIFICATIONS

Technical Expertise: VBA, VB, SQL Server 2012, MySQL, Redgate SQL Compare

BI: MS SSMS 2005 - Developing, Debugging, Deploying, and Configuring DTS Packages

TEK Systems C# 3.0 Test Proficiency Level: Proficient (June 2011)

U.S. Government Security Clearance (Secret)

U.S. Navy/Marine Corps Achievement Medal

MILITARY SERVICE

OPERATIONS SPECIALIST SECOND CLASS (E-5), US NAVY June 2005 – June 2009 Deployments: Iraqi Freedom 2006, Global War on Terrorism Expedition 2008

Developed SIPRNet proficiencies: CIA Wire, DIA.sgov.gov, SPHINX II

Prepared and delivered daily Operations-Intelligence briefs to upper Chain of Command

Team leader of six sailors at Combat Information Center Surface Warfare

Operated and monitored naval operations communications, detection, and weapons systems

Interpreted tactical scenarios and provided recommendations to superiors TECHNICAL EXPERIENCE

Quality Assurance Analyst III February 2016 – Current Geographic Solutions Inc. Tampa, FL

Leaded QA team support for New Mexico Career Solutions Portal project www.nmcareersolutions.com (live June 2016). The project was delivered to client on time, on budget

Designing T-SQL queries to extract data needed for testing and to create test data to execute manual test scripts as necessary to fulfill specific scenarios

Testing REST Web Services utilizing ARC Chrome, conducting data analysis to build Jason files payloads

Reviewing functional requirements and using business and technical knowledge to analyze and develop manual regression testing scripts for new modules to ensure sufficient test coverage

Working closely with Business Analysts to determine priorities and facilitate decisions regarding quality

Formally and informally provide guidance, technical training (T-SQL, REST services) and mentoring to less experienced Software Quality Assurance associates on applications specific functionality, tool usage, business interaction, and good practices

Conducting peer reviews of test plans and cases to ensure consistency, adequate coverage, and risk mitigation

Testing SQL database modifications

Labor Market Information module subject matter expert, training lead

Initiated, designed, co-developed QA Department internal training program (T-SQL) PAVEL (PAUL) DEMYANCHUK

Email: acxhdd@r.postjobfree.com

Cell: 904-***-****

QA Department SharePoint development: designed sites and custom pages for Workforce, Unemployment Insurance Manual QA, and QA Automation teams utilizing SharePoint 2013

Initiated Automation process for Master Data validation and developed stored procedures for its back end logic (T-SQL development)

Front and back end validation for Individuals, Employers, Staff, Education Providers, Labor Exchange, Service Tracking, WIOA, Wagner Peyser, Trade Act Program, Fund Tracking, California CASH Request, Historical Labor Market Analysis, California Employer Training Program modules APPLICATIONS DEVELOPER January 2012 – February 2016 JPMorgan Chase Tampa, FL

Data Warehouse Development

Lead for six major software release cycles, facilitated joint requirements sessions, developed Technical Design Documentation, conducted software Build and Unit Test, supported QA and UAT teams, managed Production Implementation utilizing VBA, SQL Server Development

Implemented key functionalities, Transformer and Report, for AutoETL – in house Java-based tool for mainframe extracts loads into SQL Server, independently of SSIS or DTS packages

Initiated, Designed, Implemented AutoCheck – Excel-based tool for automated validation of ETL quality. Estimated cost saving for applications developers team is $7,670 annually

Achieved zero QA, UAT defects during Enterprise Global Cycle release for eight custom reports Organizational Experience

Initiated, co-designed, and built single, modular, systematically organized applications information repository to share Subject Matter Expertise within Billing group, to ensure software knowledge continuity, to facilitate new members training, to assist Production Support group

Organized application functionality, interfaces, and libraries of four core data warehouse applications

Managed Phase I Executive Overview of Architecture documentation for six mainframe and eight distributed applications

Developed training materials and presented in multiple regions about CIB Billing Applications Knowledge Repository to AD Teams in Florida, Delaware, Mumbai Mainframe Experience

Performed batch design, development, unit testing for IBM mainframe

Co-founder and project manager for JPMC IBM Rational Developer zOS (RDz) Knowledge Forum and RDz Subject Matter Experts group to promote RDz best practices

Developed and delivered four RDz related presentations to multiple AD groups in Florida and Delaware: OSGi, XSDBind in RDz, Developing Database Applications in RDz, SSL connections for RDz and HOST Emulator

Organized and hosted two IBM zUnit presentations for over sixty Applications Developers in NY, Florida, Delaware, Pennsylvania

APPLICATIONS DEVELOPER April 2015 – February 2016

www.PlayCelebration.com Tampa, FL

Database development - MySQL

BI DATA WAREHOUSE DEVELOPER – INTERN August 2010 – April 2011 Enterprise Systems at University of Florida Gainesville, FL

Created table definitions in Application Designer to define target tables PAVEL (PAUL) DEMYANCHUK

Email: acxhdd@r.postjobfree.com

Cell: 904-***-****

IBM Cognos BI ETL packages development and debugging for the University of Florida Financial System upgrade

BI DATA WAREHOUSE DEVELOPER – INTERN June – August 2010 Winn Dixie Stores, Inc. Data Warehouse Division Jacksonville, FL

Developed ten functional features of a Retail Demand Forecasting web application that generated over $134 million annual sales increase and provided over $14 million in additional labor savings

Implemented Presentation Layer to create user interface

Coded thirty static methods in Data Access Layer to automate enterprise data warehouse updates

Delivered final presentation to Bennett Nussbaum, Chief Financial Officer OTHER EXPERIENCE

ESTIMATOR September 2003 – June 2005

John Grando, Inc. New York City, NY

Analyzed blue prints and specifications to manage budget and cost estimation of construction projects, including a $2 million renovation at The Metropolitan Museum of Art in New York City

Increased sales through contract negotiations and change orders with general and mechanical contractors

PROJECT MANAGER December 1999 – September 2003

Remi, Inc. Long Island City, NY

Supervised 5 union construction crews and general contractors in Tri-State area

Completed two $500,000 projects at Brooklyn Historical Society and Air Train (monorail) construction at JFK Airport

VOLUNTEERING EXPERIENCE

VICE PRESIDENT OF MEMBERSHIP August 2015 – August 2016 Toastmasters International -Grey Matters Tampa Bay Club Tampa, FL SPECIAL EVENTS VOLUNTEER AND SMALL GROUP CO-LEAD August 2015 – Present RadiantTampa.org Tampa, FL

EDUCATION

UNIVERSITY OF FLORIDA Gainesville, FL

Master of Science in Information Systems and Operations Management September 2009 – May 2011 ST. PETERSBURG STATE TECHNICAL UNIVERSITY St. Petersburg, RU Master of Science Degree in Physics September 1997 – June 1999 Business Management Graduate Study September 1997 – June 1999 Bachelor of Science Degree in Physics September 1993 – June 1997 Microsoft Virtual Academy https://mva.microsoft.com Querying Microsoft SQL Server 2012 Database Completed, July 2016 Boost Your T-SQL with the APPLY Operator Completed, July 2016 PAVEL (PAUL) DEMYANCHUK

Email: acxhdd@r.postjobfree.com

Cell: 904-***-****

Developing Microsoft SQL Server Databases Completed, August 2016 Querying with Transact-SQL Completed, September 2016

Contact this candidate