SUMMARY:

• 15 - Years IT/ETL DEVELOPER/INFORMATICA/ORACLE
• 12-Years Sales Performance Management Projects/Callidus TrueComp/TrueProducer
• Business Studies & Computing Science degrees; extensive hands-on experience in data integration requirements analysis, enterprise-wide data architecture designs, Informatica PowerCenter ETL Mapping, Sessions and Workflow, and Oracle PL/SQL Stored Procedures/Packages/Functions Development and best practices.
• Twelve years consulting experience in Sales Performance Management related projects that utilize Informatica PowerCenter and Callidus TrueComp technologies.
• Successfully implemented data integration/sales performance management projects in Life Insurance, Banking, Telecommunications, HealthCare, Cable/TV, and Pharmaceutical industries. Thorough knowledge of Pharmaceutical DDD/Xponent Data, Producer Management & Credentialing, HealthCare Plan/Product Management, Billing and Receipts, Commission Schedules, Arrangements and Billing Entity Agreements.

KEY TECHNICAL SKILLS:

• Informatica PowerCenter 9.1
• Callidus TrueComp 7.0
• Business Objects XI/R3
• Oracle RDBMS 11g R2
• WebLogic 9.3, WebSphere 7.0
• UNIX (AIX, Solaris, Linux)
• Rational Unified Process (RUP)
• Oracle 11g PL/SQL
• Callidus TrueProducer 7.0
• Actuate eReporting 9.2
• MS SQL Server RDBMS 2008
• Visual Basic .NET, Unix Shell Scripting
• Windows 2008 Enterprise Server
• Rapid Application Development (RAD)
• Sagent Design Studio 4.5
• ERWin Data Modeler 8.0
• Sybase PowerDesigner 9.0
• Oracle Designer 9i
• Oracle DataMart Builder 2.5
• IBM Rational RequisitePro
• Agile Software Development (ASD)

TECHNICAL SKILLS:

Technical Environments: Informatica PowerCenter, Callidus TrueComp, Callidus TrueProducer, Oracle PL/SQL, Business Objects, Actuate, Oracle WebLogic, IBM WebSphere, Oracle RDBMS, Microsoft SQL Server RDBMS, Oracle Solaris, IBM AIX, Red Hat Linux, Windows Enterprise Servers, ERWin Data Modeler, Sybase PowerDesigner; ETL Data Sources SAP R/3 HR/SD, Oracle CRM (Siebel), Oracle HRM (PeopleSoft), TriZetto Facets, Flat Files; ETL Target Systems TrueComp, TrueProducer, TrueComp Data Mart, Enterprise Data Warehouses, Oracle HRM (PeopleSoft), SAP R/3 HR, Oracle JD Edwards Financials, Flat Files.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Solution Architect/ETL Developer

Technical Environment: Informatica PowerCenter 9.1, Callidus TrueComp 7.0, Business Objects XI/R3, Oracle 11g, Oracle PL/SQL, MS SQL Server 2005, IBM WebSphere 7.0, Red Hat Linux 5, Windows 2003, ERWin Data Modeler 8.0, IBM Lombardi TeamWorks 6.2. ETL Data Sources: TrueComp 3.7, Siebel CRM; ETL Targets: TrueComp 7.0, TrueProducer 7.0, Oracle HRM, TrueComp Data Mart

Responsibilities:

• Leading the overall project solution design and collaborating with the client’ IT Architect and Business Intelligence Teams to ensure the proposed solution complies with the overall client design guidelines and restrictions of the leveraged environments.
• Leading the data integration functional requirements gathering and analysis tasks, and actively participating in requirements and technical design reviews with the client to ensure source and target systems are clearly identified and validating the data transformation rules that will be applied by the data integration processes.
• Callidus TrueProducer subject-matter expert with responsibility in designing data structures, configuration and integration of Producer/Broker Management and Credentialing, Sales Force Hierarchies and Territory Management within the Callidus TrueProducer Application. Providing recommendations for process and source data quality improvements where appropriate, and employing Callidus best practices in design and implementation of client compensation programs, developing prototypes of interfaces and producer demographics and credentialing attributes.
• Designing the data integration solution architectures (logical and physical design models) for staging data before loading into the TrueComp Repository and data mart dimensions and facts to capture historical sales performance data. Utilizing ERWin Data Modeler tool to design logical models (Entity Relationship Diagrams (ERDs) and Star Schemas (Dimensions and Facts)).
• Designing source to target interfaces, points for code reusability (that translate into Informatica Mapplets and Transformations and/or Oracle Stored Procedures/Packages/Functions).
• Utilizing Informatica PowerCenter data integration platform coupled with Oracle PL/SQL to develop mapping routines that extract data from source systems, transforms and load to the TrueComp Repository and downstream systems (Oracle HRM and custom Sales Performance Data Mart).
• Working with the Business Process Management team to provide expertise of Callidus Software technologies and IBM Lombardi TeamWorks integration. Developing Oracle PL/SQL packages that are utilized in the TeamWorks for workflow processes.
• Working closely with the Reporting team to design and develop Business Objects Universes, and developing custom Oracle PL/SQL packages used in the report development process. Review reporting design documents to ensure consistency with the sales performance management structures defined in the Callidus TrueComp/TrueProducer applications.
• Point of contact in resolving technical environmental issues, and escalations of some issues to software vendors where applicable.

Confidential, Pennsylvania

Team Lead/ETL Developer

Technical Environment: Informatica PowerCenter 8.6, Callidus TrueComp 6.0, Business Objects XI/R3, Oracle 11g, Oracle PL/SQL, WebLogic 9.3, Sun Solaris 10, ERWin Data Modeler 7.0, IBM Lombardi TeamWorks 6.2. ETL Data Sources: SAP R/3, flat files; ETL Target: TrueComp 6.0, SAP R/3 Payroll, Enterprise Data Warehouse, flat files

Responsibilities:

• Technical lead for ETL development team; assigning tasks and performing team member code reviews.
• Performed data analysis for both source and target system to design highly complex logical data models and applied proven data integration best practices (such as Informatica Velocity).
• Utilized the Informatica PowerCenter data integration platform coupled with Oracle PL/SQL to develop data integration solutions that address data integrity, performance, availability, as well as business functionality requirements.
• Developed shareable data integration components (Informatica PowerCenter mapplets and transformations, Oracle functions and stored procedures) that are used by the development team.
• Worked closely with the Business Process Management team to define workflow interfaces between the Lombardi TeamWorks and the TrueComp products suite. Developed Oracle PL/SQL packages that were utilized in the IBM Lombardi TeamWorks for workflow processes.

Confidential, Tennessee

Solution Architect/ETL Developer

Technical Environment: Informatica PowerCenter 8.1, Callidus TrueComp 5.4, Business Objects XI/R3, Oracle 11g, Oracle PL/SQL, IBM WebSphere 6.1, IBM AIX 5.3, ERWin Data Modeler 6.0; ETL Data Sources: TriZetto Facets 4.3, flat files, ETL Targets: TrueComp 5.4, TrueProducer 5.4, Oracle HRM/Financials, Enterprise Data Warehouse

Responsibilities:

• Performed installations and configurations of Informatica, Business Objects and TrueComp applications and integrated them with the WebSphere application server.
• Led the data integration functional requirements gathering and analysis tasks, and actively participated in requirements reviews with the client to ensure source and target systems are clearly identified and validated the data transformation rules that were applied by the data integration processes.
• Subject-matter expert in designing data structures, configuration and integration of Producer/Broker Management and Credentialing, Sales Force Hierarchies and Territory Management within the Callidus TrueComp/TrueProducer Application.
• Designed the data integration solution architectures (logical and physical design models for staging data before loading into the TrueComp Repository using ERWin Data Modeler.
• Responsible for designing source to target interfaces, points for code reusability (that translate into Informatica Mapplets and Transformations and/or Oracle Stored Procedures/Packages/Functions).
• Utilized Informatica PowerCenter data integration platform coupled with Oracle PL/SQL to develop mapping routines that extract data from source systems, transforms and load to the TrueComp Repository and downstream systems (Oracle HRM and Enterprise Data Warehouse).

Confidential, California

ETL Developer

Technical Environment: Informatica PowerCenter 8.1, Callidus TrueComp 5.4, Actuate 9.2, Oracle 11g, Oracle PL/SQL, WebLogic 9.3, Sun Solaris 10; ETL Targets: TrueComp 3.7, TrueComp Data Mart, Oracle JD Edwards Financials, Siebel CRM

Responsibilities:

• Performed installations and configurations of Informatica, Actuate eReporting and TrueComp applications and integrating them with the WebLogic application server. This was an upgrade project.
• Redesigned and implemented technical solutions that touch on database, ETL and reporting technologies to meet the technical requirements of the Callidus TrueComp 5.4 upgrade platform.
• Upgraded Informatica PowerCenter Mappings from Informatica PowerCenter 5 to Informatica 8.1 and customized these mappings to meet the data structures of the Callidus TrueComp 5.4 version.
• Upgraded the custom territory ranking interface developed using Oracle PL/SQL packages to meet the requirements of the Callidus TrueComp 5.4 version.
• Provided post-upgrade support on as needed basis.

Confidential

ETL Developer

Technical Environment: Informatica PowerCenter 8.1, Callidus TrueComp 5.3, Business Objects XI/R3, MS SQL Server 2005, IBM WebSphere 6.3, Windows 2003; ETL Data Sources: Flat files; ETL Targets: TrueComp 5.3, Analytics Data Mart

Responsibilities:

• Enhanced Informatica Mappings to meet additional business requirements for the TrueComp 5.4 system.
• Designed and modified stored procedures for migrating new data measurements and metrics to the Analytics Data Mart for reporting.
• Developed ETL and TrueComp pipeline automation scripts for nightly processes.
• Provided Informatica PowerCenter and TrueComp production support on as needed basis.

Confidential, Georgia

Team Lead/ETL Developer

Technical Environment: Informatica PowerCenter 7.1, Callidus TrueComp 3.7, Actuate eReporting 7.1, Oracle 9i, Oracle PL/SQL, Sun Solaris 9; ETL Data Sources: HR flat files; ETL Targets: TrueComp 3.7, TrueComp Data Mart

Responsibilities:

• Served as the technical expert of the Callidus TrueComp sales performance management platform and its data integration component. Provided technical leadership and work direction to a team of technical consultants.
• Led the data integration solution design and developed Informatica PowerCenter reusable components that were utilized by other project team members to ensure uniformity in the data integration complex business logic.
• Developed Informatica mapping designs, workflows and load processes, and assisted in the preparation of detailed design specifications for development, enhancements or maintenance.

Confidential, California

Solution Architect/Team Lead/ETL Developer

Technical Environment: Callidus TrueComp 3.7, Informatica PowerCenter 7.1.3, Actuate eReporting 7.1, Oracle 10g, Oracle PL/SQL, WebLogic 6.0, Sun Solaris 9, Windows 2003; ETL Data Sources: IMS Health DDD, internal CRM staging DB, Orion Chargeback System; ETL Targets: TrueComp 3.7, TrueComp Data Mart, Oracle JD Edwards Financials, Siebel CRM

Responsibilities:

• Led the development and oversight of enterprise-wide sales performance management and competitive intelligence application development projects, and serving as the technical expert for Callidus TrueComp, Informatica PowerCenter, Actuate, and Oracle technologies.
• Technical lead in the area of business requirements gathering and analysis, solution design and development activities, and managing day-to-day technical operations of the sales performance applications utilized within the company’s US and European divisions.
• Defined and implemented ETL coding standards, shared components and approaches, and participating in development code reviews. Developed/reviewed technical documents to ensure consistency, accuracy and compliance with standards and architectural directions as they relate to the sales performance analytical environment.
• Enhanced sales performance visibility by providing daily updates to senior management through web-based dashboards developed using Actuate eReporting technology.
• Provided guidance, mentoring, translating business needs into technical requirements to the less-experienced team members.
• Partnered with the sales and marketing team to find areas of improvements by identifying technology and process improvements required to extend the company’s intelligence capabilities and creating plans for resolution.
• Designed and implemented reporting data sources and complex reports using Actuate technologies.