Jim Gruler Email & Phone Number

Phoenix, Az, Us

Phoenix, Arizona

Tempe, Az

• Leads a team of 7 developers, gave direction on projects, provided knowledge about the business and • Lead on high profile Oracle/Informatica ETL project for US Airways/AA integration• Excels in logical reasoning, problem solving and analytic skills• Works closely with the business to ensure requirements and business needs are met• Tasked with helping performance tune Oracle user and project queries• Worked on numerous Passenger and Ticket data warehouse projects working closely with the business • Worked on several Operations related projects working closely with the business • Performed many small project designs and sizing of the work effort• Assisted in the Informatica upgrade to 9.0• Served as first responder providing 24/7-support for the data warehouse production systems; analyzed and resolved production, data and software issues.• Performs data manipulation, data/production maintenance, production support and new development; • Implementation of projects for multiple data warehouse applications• Worked on cleanup of old Passenger data• Modified existing and developed new Informatica workflows.• Worked with DBA’s to tracking down users for a business need• Was responsible for implementing TFS source control solution for development team

Phoenix

• Direct, maintain and operate large database (VLDB) with more than 8 billion rows in an OLAP environment• Maintained and updated complex database Oracle procedures and packages.• Serve as first responder providing 24/7-support for the company’s critical production system and vital business processes; analyze and resolve production, data and software issues.• Perform data manipulation, data/production maintenance, production support and new development; load and transform pharmaceutical prescriptions and medical health claims.• Support business teams in project management and issue resolution; meet weekly to discuss progress, business requirements and future plans; modify code to meet new requirements.• Partner with management to create strategic technical direction; provide recommendations to help influence decisions.• Prepare status reports, process documentation and business rules.• Supervise outsourced consultants in daily work and train outsourced consulting company.• Implemented new patient studies project within a team; designed complex database that produced different results based on parameters entered through a website.• Migrated billions of rows of data from Oracle to Netezza using a custom built ETL tool; collaborated with a team.• Spearheaded custom built ETL tool and modified design of patient process using SQL, PL/SQL and Unix shell scripting to load and process prescriptions and medical health claims.• Identified and resolved data and performance issues while leading the quality control process.• Launched and created new business rules and new patient process providing better quality data

Worked on Oracle Financials and Oracle Business Objects helping to create new business views and fixed non working processes.

Worked on large retail application project. Position included developing an automated and intelligent inventory restocking system. Position included a large development team working together on many aspects of the application. Development was performed in Oracle and Unix as well as worked with .Net front-end developers to ensure the client facing websites performed well.

Bsba, Business Administration And Management, General

Education record