SUMMARY

• Over 10 years of professional experience with over 6 Years experience in complex CRM environments
• Previous roles include Siebel Developer, Informatica Developer, Data Anlayst, Salesforce Developer, Business Analyst, Team Lead and CRM Application Lead
• Solid technical background in Siebel CRM, Informatica 8.6.1, Salesforce, Tivoli, OBIEE 11gG
• Excellent Data Analysis, SQL, PL - SQL skills and also proficient in shell scripting, E-Script
• Design and build of complex Informatica transformations, mappings and workflows
• Ability to build Siebel Workflows, Screens, Views, Applets, Business Components and E scripting
• Salesforce experience configuring application and creating Visual Force custom reports
• Siebel experience with Universal Customer Master
• Experienced in writing Analysis and Technical/Functional Design documents and creating Test Cases, Test Scripts for Informatica, Siebel and Salesforce Implementations.
• Involved in all different phases of the SDLC from requirement gathering to change management and implementation/deployment.
• Demonstrated excellent problem solving and troubleshooting skills.
• Excellent communication skills
• Team player and fully capable of handling tasks individually.
• Excellent communication skills and fluent in English, Spanish
• Additional Hindi language
• Experienced with onshore / offshore model and can lead offshore teams

PROFESSIONAL EXPERIENCE

Confidential

Siebel Marketing Engineer

Responsibilities:

• Lead for the Siebel Marketing and OBIEE applications
• Manage application enhancment request and defect resolution
• Support all facets of Marketing Data Analysis, Reporting and Segmentation
• Design and build data Integration points and Informatica Workflows for daily batch processing of external vendor files being loaded into Siebel DB and Data warehouse
• Conifgure/Modify Applets, BCs,Views, Screen, Business Services and other Siebel repository objects using Siebel Tools
• Create multiple new Informatica workflows and also modified existing worklows using Informatica Power Center v8.6.1
• Design and created ETL data transformations for complex multi session workflows
• Create and modified Unix shell scripts used to execute the Informatica workflows
• Worked in conjunction with the Tivoli team to build jobstreams, create and define dependencies in order for the successful completion of data loads.
• Troubleshoot Siebel Marketing data related issues
• Design/configure enhancments as requested by business
• Campaign History and Campaign Response data analysis
• Proficient with Oracle Business Intelligence Enterprise Edition for segmenting populations for campaigning and also modifying RPD as necessary

Confidential

Sr Consultant

Responsibilities:

• Worked as BA and Developer for the duration of the SDLC.
• Created custom objects and relationships as well as creating SFDC custom reports
• Worked closely with client BA’s to gather requirements and create functional design documents for the project.
• Worked with the onsite team (no offshore component to this project) to develop
• Test and migrate to production, a custom built application built on SFDC’s, Force.com platform.
• Also worked with the data migration team and QA for testing the final application.
• Created multiple new Informatica workflows and also modified existing worklows using Informatica Power Center v8.6.1
• Designed and created ETL data transformations for complex multi session workflows
• Created and modified Unix shell scripts used to execute the Informatica workflows
• Worked in conjunction with the Tivoli team to build jobstreams, create and define dependencies in order for the successful completion of data loads.
• Worked with db team in expansion of data staging area
• Create, build and modify new applets, views, screens using Siebel Tools
• Create new object managers as necessary for new Siebel environments.
• Involved in analysis, design and development of Enhancement items related to Siebel Marketing application using Siebel configuration and custom coding using e script.
• Helped the team to document all the important production related activities required to effectively support Siebel Marketing application.
• Troubleshoot/Fix the ongoing production issues; monitor the daily Informatica jobs.
• Worked with the offshore team on a daily basis and lead small teams as required on small projects and enhancements
• Create complex PLSQL procedures and updatestatements to correct data related issues
• Siebe Universal Customer Master data related troubleshooting experience

Confidential

Responsibilities:

• Project was to deploy a Siebel Sales application that consolidates lead management, enterprise customer record search
• CEM 360, call logging, telephony integration, automated guest recognition and embedded Res GUI into one system
• Worked on Integration and Informatica Workflows modifying existing workflows to load leads from outside systems into Siebel and load into Data warehouse.
• Took part in the unit testing and also led meetings with QA team and technical team during UAT for the status of existing and new QC items.
• Took a lead roll in application roll out to the client at their Springfield call center.

Confidential

Responsibilities:

• Design data import from legacy systems into Siebel
• Data track project management and holding technical sessions as needed
• Requirements gathering review
• Assist in Informatica, PLSQL data extract and EIM process
• Manage offshore data track team

Confidential

Lead Systems Support

Responsibilities:

• Lead systems support analyst
• CISCO VOIP gateways, Firewall and VOIP Routers
• Wrote Cisco VOIP translations for call routing
• Manage South American offshore IT support team

Confidential

Operations Manager

Responsibilities:

• Responsible for maintaining purchasing and importing inventory from China
• Responsible implementing systems to track clients and service history
• Implemented Salesforce.com CRM solution for campaign management
• Configured SFDC application for internal use
• Managed website and content using Drupal content management site for sales and promotions
• Managed staff of 8 employees