Richard (Ricky) Wenz Jr work email
- Valid
Richard (Ricky) Wenz Jr personal email
- Valid
SQL, ETL and BizTalk DeveloperSolution-oriented developer with notable achievements in a wide range of corporate efforts• 12+ years of experience in professional database development with T-SQL.• 5+ years of ETL development experience with DTS• 5+ years of ETL development experience with SSIS 2005.• 2 years ETL development experience with SSIS 2008• 1.5 years of experience developing system integration solutions with BizTalk 2009/2010.• Able to utilize technical skills to develop solutions that meet end-user needs.• Effective communicator exhibited in working closely with customers to identify and address problems• 7+ years of experience in developing reports in multiple reporting tools such as SSRS 2005/2008, Crystal 8.5/9 and Business Objects 5/XITechnical SkillsLanguages: C#, VB, VBAWeb Services: XML, XML Schema, WSDL, XSLTRDBMS: SQL Server 2000/2005/2008, Oracle 8i/9i, Sybase 11, MS AccessTools: Visual Studio, Team Foundation Server, Visio, Merant Version Manager, TOAD, PL/SQL Developer, ERWIN 4, SSMS Rational Requisite Pro, MS Office suite, PeopleTools 8.49, BizTalk Server 2009/2010, MS DTS, MS SSIS 2005/2008, Informatica PowerCenter 7.1/8.1/8.5, MS ProjectPlatforms: Windows Server 2003/2008, Windows 7/Visa/XPERP Systems: SmartStream Finanicials, Oracle Financials, PeopleSoft Finanicals 9.0Reporting: MS SSRS, Business Objects 5/XI, Crystal 8.5/9, PS/nVisionEmail Clients: Lotus Notes, MS OutlookTechnical ExpertiseDevelopment: Systems Analysis, Data Analysis, Data Modeling, Data Integrity, ETL, Systems Integration, Data Profiling, Data Cleansing, Requirements Management, Data Migration, Database Administration, trouble-shooting, and performance tuning.Specialties: • Self-taught MS SSIS 2005 during beta release with little or no technical document.• Self-taught BizTalk Server 2009 to successfully complete 4 critical system integrations in 30 days.• Managed a 5 person database development team.• Couched, mentored, and crossed trained fellow employees• Personal subscription to Pluralsight for continuing personal technical development training.• Primary developer on several key data migration efforts
-
Sr. Software EngineerUniversal Technical Institute Jan 2010 - Jun 2011Primary Duties:• Developed and maintained custom financial reports using Crystal 8.5 and PS/nVision tools• Trouble shoot problems with integrations to the financial systems using C#.• Cross Train with PeopleSoft System Administrator to provide a back up functional role.• Developed and maintained Integrations between the HRIS system and RMS using SSIS 2008 & BizTalk Server 2009.• Refactored custom C# integrations to the Finanical System in BizTalk Server 2009.• Created and maintained HRIS system integrations to the Interal Employee Learning Management System using SSIS 2008 and BizTalk Server 2009• Upgraded all Financial and HRIS BizTalk Server integrations to 2010.Additional Duties:• Mentor report developers in T-SQL query writing.• Performance tune queries, stored procedure for other teams.• Peer reviewed teammates code.• Assisted other development teams to completed high priority work efforts to meet compliance and regulatory deadlines.• Self-taught BizTalk 2009 in order to successfully complete 4 HRIS system integrations for a critical project with a compress time frame.• Worked with the SQL DBA to kick off the SQL server upgrade from 2005 to 2008.• Created automated processes to perform Financial System user access reviews for a bi-annual basis the results were presented in SSRS 2008. -
Database ManagerPrudential Financial Jan 2008 - Jan 2010Scottsdale, Az• Supervised and mentored five direct reports.• Administrated development and QA database environments.• Established and proven backup and recovery methods.• Created and maintained data scrambling routines of sensitive data for non-production environments.• Responsible to ensure all code is compliant with standards. • Create and maintain database standards• Responsible for the configuration and maintain all development MS SQL database servers 2000 & 2005.• Conduct peer audit review to ensure code meets technical requirements.• Mentor junior team members.• Create and maintain database models.• Responsible for generating database builds and change control documentation for environment promotion.• Development of ETL processes in SSIS 2005; for Data warehouse and other legacy systems.• Collaboratively worked with all database developers to establish and maintain database standards.• Utilized technical and problem-solving skills to identify glitches and quickly implement solutions. • Performed SQL Server 2000 & 2005 database migrations from retiring hardware to new hardware.• Rewrote the Real Estate data warehouse ETL from Informatica Power Center 8.5 into SSIS 2005 and stored procedures.• Brought all SQL database servers into corporate compliance for the first time, by consistently following the database and security standards that were set in place.• Created Business Objects XI report to assist the BI reporting team in order to meet project deadlines -
Sr. Database DeveloperPrudential Financial Feb 2004 - Jan 2008Scottsdale, Az• Collaboratively worked with team members to create and maintain database standards • Configurated and maintain all development MS SQL database servers. • Conducted peer audit review to ensure code meets technical requirements. • Mentored junior team members. • Created and maintain database models • Generated database builds and change control documentation for environment promotion. • Development of ETL processes in SSIS 2005 and Informatica Power Center; for Data warehouse and other legacy systems. • Collaboratively work with all database developers to establish and maintain database standards. • Utilize technical and problem-solving skills to identify glitches and quickly implement solutions. • Was the sole developer to successfully ETL legacy financial data from SmartStream Finanicals to the dataware house using DTS and SSIS• Rewrote the Real Estate financial feed from a nightly batch process to a real time transaction validation process by creating a transaction data store in SQL server 2005 and using SQL Stored procedure and SSIS 2005 to interact with a custom rule engine database. Only a small nightly batch process remained, in order ETL validated transactions to the financial system to be processed and create receivable documents.• Created and maintained a custom SQL Server 2005 database which contained common components in an effort to consolidate databases which supported multiple web site portals between the Real Estate and Relocation industry.• Created a proof of concept to create warehousing reports in SSRS 2005 which was self-taught.
-
Financial Systems DeveloperPrudential Financial Sep 2001 - Feb 2004Scottsdale, Az• Development of ETL processes from Service Delivery system to the financial systems SQL Server 2000 and MS DTS. • Created custom billing solution modules within the financial systems using SQL Server 2000 and Business Objects 5. • Create and Maintain documentation of business and system requirements for financial systems and reports.• Development and maintenance of the financial reporting environment using SQL Server 2000. • Development of financial reports using Business Objects 5. • Development of Data migration processes from SmartStream Financials to Oracle Financials using MS DTS to interactive with Oracle API's.• Won an award for the creation of the custom billing solution of the financial system.• Was the sole developer on the projects accounting module data migraton effort from SmartStream to Oracle Finanicals. 100% of all data was successfully migration with no exceptions, due to custom data validations and data cleansing routines that were established before the actual data migration effort, these routines developed in Sybase 11 by stored procedure and nightly batch jobs. Business Objects 5 was used to report daily exceptions to Business users to correct the data.
-
Business Systems AnalystPrudential Financial Sep 1998 - Sep 2001Valhalla, Ny• Created unit test cases for technical financial system solutions. • Performed unit testing of solutions• Collaborated with end-users and system developers to effectively and efficiently document business and systems requirements. • Trained end-users in the utilization of financial systems solutions. • Self-taught T-SQL in Sybase in order to create independent queries for validation of uniting code.• Self-taught Business Objects 5 which some cross training with 2 report developers, in order to assist the development effort of the re-write of 125 reports that where being replaced from a mainframe system.
-
Billing SpecialistPrudential Financial Dec 1996 - Sep 1998Valhalla, Ny• Worked in the Finance and Accounting field.
Richard (Ricky) Wenz Jr Education Details
-
Marlboro Central High ScoolHigh School Graduate
Frequently Asked Questions about Richard (Ricky) Wenz Jr
What is Richard (Ricky) Wenz Jr's role at the current company?
Richard (Ricky) Wenz Jr's current role is Sr. Software Engineer at Universal Technical Institute.
What is Richard (Ricky) Wenz Jr's email address?
Richard (Ricky) Wenz Jr's email address is rw****@****hoo.com
What schools did Richard (Ricky) Wenz Jr attend?
Richard (Ricky) Wenz Jr attended Marlboro Central High Scool.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial