SUMMARY:

• An accomplished, well rounded Senior Application and Database Developer who possesses strong working experience in developing database applications, ETL, reporting, business intelligence and software development area. Always engaged in full software development lifecycle, including interacting with business users and other IT teams to gather and analyze requirements, design, test, performance - tune, implement, and support applications. High adaptability to the ever-changing IT industry.
• 10+ years experience in database application development: 8+ years in Oracle PL/SQL; 2 years in Microsoft SQL Server and SQL Server Integration Services (SSIS), and 1 year in MySQL.
• 10+ years experience in Enterprise Incentive Management applications: In a small team of 7, designed and developed a home-grown commission system using Visual Basic, Oracle and Viador; 7 years in Callidus TrueComp experience (3.7, 5.x) on Oracle and SQL Server platforms, with extensive knowledge in TrueComp data architecture, pipeline processing, ETL, TrueComp Datamart and reporting process in Actuate and TrueInformation
• 10+ years experience working with business intelligence tools to develop reporting and data analysis solutions for various audience: 4 years in Viador, 6 years in Actuate, and use of PL/SQL, T-SQL and SSIS to transform data to meet customers’ needs.
• Certified in Oracle PL/SQL and Performance Tuning in Oracle . Extensive knowledge in tuning Oracle queries and batch processes to run in enterprise-level database. Experience in data modeling through data integration and reporting projects

TECHNICAL SKILLS:

Lang uage / Scripting: Oracle PL/SQL, Microsoft T-SQL, Actuate Basic, Visual Basic 6 (ADO), HTML, ASP, Java, C++, Korn Shell

Application / Software: Oracle 7.3 / 8i / 9i, / 10g, Microsoft SQL Server 2000, MySQL 5.1, Microsoft SQL Server Integration Services (SSIS), Informatica PowerCenter 7.x, Actuate eRD Pro 6/8, Actuate Information Object 8, Actuate Information Object Designer 8, Callidus TrueComp 3.x/5.x, TOAD, Telelogic CM Synergy 6.4, Telelogic DOORS 7.1, HP OpenView ServiceDesk 4.5, Remedy Action Request System, Control-M Enterprise Job Scheduling, Microsoft Word, Excel, Access, Viador Space SQL, PVCS 6.5, Microsoft Team Foundation

PROFESSIONAL EXPERIENCE:

Confidential, Olathe, KS

Senior Software Engineer

Responsibilities:

• Creates and maintain data models to support new features for applications on Garmin Mobile Devices.
• Provides SQL tuning advices to software engineers on the Server Operations and Off-Board Services teams
• Support basic MySQL maintenance, monitoring and change management activities
• Works with Garmin's Business Intelligence team to extract data from GCS; Use Cognos to generate reports for a wide range of audiences

Confidential, Vernon Hills, IL

Senior Applications Developer

Environment: Callidus TrueComp 5.1.2.2, Actuate eRD Pro 8, Microsoft SQL Server 2000, Microsoft SSIS

Responsibilities:

• Architected and developed solution in SSIS and Actuate to integrate service transactions and invoices from Changepoint and Peoplesoft into Truecomp, and provide reports to the sales team
• Using Informatica PowerCenter, SSIS and SQL Server stored procedures to feed and process sales and employee data into TrueComp or generate outbound feeds Develop and maintain Actuate reports for the sales force and commissions analysts
• Provide 24x7 on-call support; monitor batch processes scheduled in Control-M and CA Workload Automation; troubleshoot any production issues from Actuate reports, ETL and Callidus Truecomp; worked directly with Callidus to obtain and apply hotfixes on the system

Confidential, Overland Park, KS

Senior Applications Developer

Environment: Callidus TrueComp 5, Actuate eRD Pro 8, Actuate Information Object Designer 8, Oracle 9i

Responsibilities:

• Participated in converting home-grown Partners Commissioning System and legacy Nextel Commissioning System (Oracle Incentive Compensation) to Callidus TrueComp 5 and Actuate 8. Designed table-driven reporting structure to reduce maintenance efforts and projects over the long term. Use of Actuate Information Object to create eQuery that enables business analysts to generate ad-hoc reports, and act as data source for Actuate Reports. Provided on-going development and production support for the reporting systems.
• Worked with Project Managers to prioritize, plan and execute reporting-related projects. Interacted with System Analysts and Business Users to ensure products were delivered with quality and on target. Provided professional guidance to local and off-shore developers.
• Created and maintained procedures and database architecture that prepare more than 10 million records calculated daily by TrueComp for reporting purposes, which enable thousands of salespeople and external sales channels to keep track of their sales . Use of dynamic SQLs and dynamic cursors to provide flexibility and minimize the need for code change.
• Analyzed, designed and implemented Oracle packages and table structure to automate the process of maintaining participants, positions and reporting hierarchy in TrueComp using snapshot from Sprint HR.
• Held sessions to provide business users an overview of TrueComp Pipeline. Assisted users in researching issues and answering TrueComp-related questions.

Environment: Visual Basic 6, Viador Space SQL 6, Oracle 7.3/8i