Rodney Patterson Email & Phone Number

Virginia Beach, Virginia, United States

Application solution delivery, conversion, configuration and success.

Virginia Beach, Virginia, United States

Virginia Beach, Virginia, United States

Property Tax and Appraisal system development, implementation and SQL data conversion for county government clients.

Norfolk, Virginia

Data is one of any enterprise’s key strategic assets. Effective data governance, strategy, design, solution delivery, reporting and analysis to support business execution and decision making is a challenge all industries face.Conviso Information & Data Management Practice provides pragmatic solutions and specific consulting expertise delivered through the application of best practices and methodologies.

Virginia Beach, Virginia

• Tool design, programming, mapping, testing and leadership for conversion ETL and implementation of the Thomson Reuters Property Tax and Valuation (ProVal, Custom CAMA and others) systems for City and County governments.• SQL (T-SQL) programming and tuning on Microsoft SQL Server databases.• Project planning and project architectural design and budgeting.• System and conversion balancing. Worked with customers and technical staff to define plans that leverage legacy trusted reports and new system reporting to verify ETL and system conversion activities. Created processes and tools to independently verify system installations, interfaces and ETL. Apply accounting principles to technical activities small and large.• Conversion and Interface product management, design, estimation, sales support, coding and lifecycle support.• Workflow, reporting, and tax calculation product management, implementation, and support. Led teams in a hands-on manner to adopt and implement new technologies to satisfy complex customer requirements.• System administration, planning and leadership of technical staff.• Technical consultation for Project Managers and senior leadership, scope management, and sales support.

• Database administration, installation and conversion ETL programming in support of the development and installation of city and county tax programs.• Responsible for performing customer support, coordination of application and Oracle version upgrades and patches.• Management of application database build and release process using the Rational Unified Process toolset and related troubleshooting.• Coding with Microsoft DTS, VB Script, PL/SQL, SQL*Loader, Unix shell, and awk. SQL query, application, database and system tuning for a three-tier solution.• Installation, support and tuning of Sybase EAServer application server on Unix and Windows 2000. Native, ODBC and JDBC connectivity configuration and troubleshooting.• Software and database installation of SQL Server 2000 and Oracle9i on Windows 2000. Software and database installation of Oracle8i and 9i on Sun Solaris.

• Business Intelligence database and reporting writing tools sales, support and delivery.• Worked heavily with general ledger and banking systems application reporting, integration and support.• Performed database administration and programming for Oracle, SQL Server, Mumps and PC databases on Unix and Windows NT systems.• Remote transmission, scripting and printer support.• Upgraded Oracle databases from RBDMS 6 to 7 to 8 on Unix and 7 to 8 on NT.• Rewrote Unix multi-process Oracle load system increasing performance and later ported this solution to Peri on Windows NT for another host application system.• SQL Server and Oracle software installation, configuration, and performance tuning.• Logical and physical database design including automated metadata transfer.• Built database connected web pages to control systems using ASP and JavaScript on a Microsoft Internet Information Server (IIS) connected to SQL Server 7 and Oracle databases.• Designed, programmed and sold custom Access database applications.• Programmed multi-process system control and utilities in Peri and Delphi.• Wrote Windows FTP file delivery application and managed the system rollout.• Designed and coded an extract system to pull data from an M hierarchical Unix database host application program.• Participated in disaster recovery planning and testing.• Unix Shell, SQL and PC programming.