Bill Ritchie

Background

About Bill Ritchie

ORACLE / Informatica ETL professional with the following: • 15 yrs - Oracle Databases • 3 + yrs Informatica experience which includes:> 9.5/10.1 Power Center - Designer,Repository,Workflow,Monitor > Informatica Administration • 4+ rs experience with CA Workload Automation applications: design,development and deployment • Advanced ability to design,develop and deploy Informatica workflows - with use of mappings,parameter files, joiners,filters,expressions,lookups,sorters and routers. • Advanced ability to create/update ORACLE packages, procedures, functions, triggers and indexes. • Advanced ability to create complex ORACLE queries, joining multiple tables with millions of rows of data. • Advanced ability to tune PL/SQL code for performance using EXPLAIN plans, TKPROF and trace files. • Built PL/SQL-driven processes as small as back-end code for.NET websites and as large as, multi-tier, high-volume applications. • Intermediate ability in Data Modelling, Data Mining and Entity Relationship Diagrams(ERD). • Intermediate ability in creating/modifying Oracle tables and views. • Proven success in solving complex problems and developing unique, cost effective solutions. •Proven success for innovation and delivering quality software. • Beginner ability in SQL Server, C++, C#.NET and SharePoint. Seeking new software development opportunities that match my skills and abilities. Specialties: Languages: PL/SQL, Transact SQL, JavaScript, HTML, C#, C++, UNIX C-Shell and Korn Shell, Informatica Mappings and Workflows, Linux bash, CA Workload Automation job flows,**ORACLE** Packages, Procedures, Functions, Views, Complex Queries, SQL-Loader, Data-Mining, PL-SQL Developer/TOAD, Data Models/ERD SQL Server : 2005 / 2008: Complex Queries, Stored Procedures, Enterprise Manager, Management Studio Web Site: Visual Studio 2005/2008, ASP.NET, ADO.NET, SharePoint 2007 Version Control: PVCS, Tortoise SVN High Achiever, Self-Starter, Creative, Analytical