SUMMARY

• Architected fully functional, highly available, and load balanced Oracle CRM - Business Intelligence solutions for public & private sector organizations.
• Managed installation, upgrade, configuration, customization, and administration of entire Siebel Enterprise Suite (Siebel Application\Database\Web Servers) on AIX, Solaris, HP, & Windows platforms.
• Provided technical/business leadership to Business Analysts, Systems Analysts, Programmer Analysts, Application Analysts and Database Analysts.
• Led a team of developers in implementing Siebel quarterly maintenance releases for one the largest Siebel projects in Canada.
• Designed, Developed, & Deployed end-to-end an Enterprise Content Management solution for Ministry of Transportation.
• Worked collaboratively with other architects, technical leads, coordinated development activities to achieve overall release goals.
• Lead Functional Qualification Testing (FQT) (development testing) via design, development, execution, and documentation of tests.
• Prioritized correction of defects, working closely with System Integration Testing; and coordinated development activities with other development leads to produce a coherent development baseline.
• Maintained traceability of design documents from requirements to implementation.
• Developed estimates, and allocated work in support of overall release delivery goals and project timeline
• Developed & delivered Siebel Training programs for major pharmaceutical and company.
• Acted as liaison between Siebel Database Team and IBM DB2 Team to certify fix-packs/patches; expertly resolved DB2 and Siebel application performance issues.
• Conducted database event/snapshot monitoring, query analysis, index tuning, import/export, load/unload, backup/recover, and tune applications for optimal performance.
• Customized a variety of Siebel applications including e-Communications, e-Sales, e-Service, e-Pharma, e-Finance, Field Service, Call Center, Marketing, and Public Sector.
• Developed new Siebel screens, views, applets for various Siebel applications.
• Integrated Siebel applications with Oracle Data Quality, Oracle Enterprise Manager, Oracle Identity Manager, Oracle Internet directory, Oracle Business Intelligence Enterprise Suite, Active directory, Adobe Life Cycle, & CTI telephony servers.
• Streamlined and simplified Siebel business processes for the world's largest pharmaceutical company.
• Managed Siebel 2000 and Siebel 7.5.3 call center for 200+ telecommunication customers worldwide.
• Designed & build Siebel real time integration using EAI, custom business services, workflows.
• Configured Siebel 7.8.3 application for the largest telephone directory publishing company of North America.
• Upgraded an entire Siebel production enterprise from Siebel 7.0 to Siebel 8.0 version.
• Leveraged and implemented business and functional requirements leveraging best practices of the latest Siebel Open UI technology and framework.
• Engaged various application key stakeholders and defined Open UI implementation strategy keeping in mind the end user satisfaction, cost effectiveness and efficiency.
• Worked closely with Business Clients, CRM Architects, Solution Designers and Technical Leads to define end to end solution with Open UI for Siebel Public Sector application.

TECHNICAL SKILLS

Operating Systems: IBM AIX 7.1, IBM AIX 6.1, Sun Solaris 9, HP-UX 11i, Microsoft Windows Server 2012- 2000 - 2008 - 2003 / Windows NT/Windows XP

Web Servers: IBM HTTP Server v7.0.0.39 & v8.5.5.0, Oracle HTTP Server v11.1.1.6 & v11.1.9.0, Apache version 4.1, Sun ONE Web Server 4.0/5.0, HP Apache Web Server 2.0, Microsoft IIS 5.0/6.0/7.0/8.0

Application Servers: Apache Tomcat 6, IBM WebSphere Application Server 8.5.5.0, IBM WebSphere- Business Process Manager 8.5.5.0, Oracle Web-Logic Application server 10.3.6

Languages and APIs: C, C++, Java, JavaScript, HTML 5.0, CSS, JQUERY,VB, VBS, ASP,JSP, COM, J2EE, C#, .NET, MFC, COM, DCOM, OOA/OOD, XML,HTML SOAP UI, UDDI, WSDL Web Services, PL-SQL, JCL, Load-Runner API, Win32 API, ODBC API, ActiveX, Assembly, Fortran, Client/Server Programming,, REST API, J-Developer

Software Applications: Quantify, Glow Code, Mercury Load Runner, Test Director, Win-Runner, Quick Test Professional, Visio, Mercury Vision, Bounds Checker, Rational Purify, DB2 Control Center, Oracle Enterprise Manager, MS-SQL Enterprise Manager, PERL, AWK, SED, C & KORN shell scripting, INFORMATICA Server/Client, BNC, Exceed/ X-Term, Samba, X-Windows, Quest Suite, COGNOS Reports, Crystal Reports, Business Objects, SAS, MATHLAB, MQ-Series, MS-Office, MS Project, MS-Exchange Server, PVCS, Source Safe, Clear-Case, Net-Cool, VM-Ware, Lotus Notes, Open SSL, Beyond Compare, Fiddler, Win-SCP, X-windows, X-MING.

RDBMS and Database Tools: IBM DB2 UDB 7.2, IBM DB2 for z/OS and OS/390, Oracle 8i/9i/11i/12G, MS-SQL Server 7.0/2000/2005 , Sybase SQL Server 10/11, Sybase Adaptive Server Anywhere 8.1, DB2Cli, DB2Cmd, DB2CCA, SQL-Plus, TOAD, SQL Net Easy, SQL Advantage, WISQL, DS-Edit, OLAP/OLTP setup, MS-Query, MTS, MS-DTC, MS-DTS, MS-Access, JDBC, ODBC

Network: FTP, SFTP, SMTP, TCP/IP, HP Open-View, Forward proxy, Reverse proxy, SSL, SSH/Tunneling, SUDO rules, group/user permissions.

Document Management/Knowledge Management: Open Text content Server v10, Open Text Archive Server v10, Open Text Enterprise Library Services v10, Brava Enterprise Edition v7

LDAP: Active Directory, Open-LDAP, Sun-one Directory Server, IBM Directory Server

PROFESSIONAL EXPERIENCE

Confidential

Application Architect

Responsibilities:

• Responsible for design, development, testing, deployment and maintenance for entire Siebel-CRM project on a large-scale COTS Software system implementation.
• Worked in collaboration with 3rd Party offshore vendor; provided leadership on technical solutions to meet Siebel Public Sector & Oracle Customer Hub (OCH) business requirements.
• Performed functional and technical code reviews for all Siebel requirements, & worked closely with onshore/offshore development teams.
• Analyzed & implemented various Oracle software application products including Oracle Retail Point of Service, Oracle E-Business, Oracle Policy Automation, Oracle Enterprise Data Quality, Siebel Public Sector, & Oracle Customer Hub.
• Designed end-to-end Oracle Retail Point of Sales (ORPOS) solution in a complex application and technology environment.
• Resolved system problems either independently or by coordinating resolution with software vendors, hardware manufacturers and/or appropriate in-house experts.
• Reviewed application and technical infrastructure design to ensure adherence to standards; recommended various performance improvement techniques.
• Provided technical mentoring/guidelines, and framework to different teams on the project. This included producing detailed technical specifications.
• Devised implementation, migration and interface strategies to facilitate conformance to the architectures for assigned technologies.
• Planned and managed business requirements effort required on projects to support business needs. This included change management of business requirements and estimating the business requirements effort.
• Lead projects and initiatives within the team and with other IT business partners.
• Evaluated and recommended appropriate hardware platforms, utility software, workstations, and networking solutions required to support work processes and information flow.
• Resolved system problems either independently or by coordinating resolution with software vendors, hardware manufacturers and/or appropriate in-house experts.
• Assisted solution vendors and/or development groups to ensure solutions conform to architecture standards and practices.
• Provided support to application and/or technical support teams in the proper application of existing infrastructure
• Provided internal consulting services in assigned technology area(s) as it relates to technical design/implementation issues.
• Developed technical architectural documentation that included diagrams & blueprints.
• Presented technical architecture to client, architecture review board, project managers, & directors.
• Contributed to the definition/execution of the architecture checkpoint review process; provided guidance and technical insight to initiatives throughout the architecture review process.
• Assisted in defining, maintaining & enforcing organization wide Enterprise Architecture practices/standards to ensure that solution architectures:
• Took part in strategic and tactical decisions relating to application architecture; Contributed to the evolution of the MTO's middleware application deployment blueprint.
• Worked with other domain Architects/Technical leads in defining privacy, security and policy areas for application deployment.
• Provided advanced expertise in complex technologies/diverse technical processes and technical infrastructure/architecture.
• Partnered with business and technology areas to ensure the technology and process solutions delivered/supported meet the needs of the business partners and the appropriate level of quality based on risk

Confidential

OBIEE Consultant

Responsibilities:

• Designed, Developed, & implemented an end-to-end multilingual solution for Siebel customer web portal to handle all ingoing/outgoing client web transactions.
• Documented all necessary steps to upgrade current Oracle Business Intelligence version 10G to BIP publisher 11g; presented a detail plan of action for upgrade to the upper management.
• Responsible for providing technical/functional expertise relating to Siebel CRM & Oracle BI-Publisher applications to development teams.
• Develop enhancements using Siebel configuration; maintain & enhance existing BI Publisher Reports.
• Provide guidance and advice to other team members on methods for implementation of new requirements within Siebel, & BI Publisher applications.
• Support testing and implementation of Siebel updates and patches; Review and provide suggestions to improve response times to clients for urgent system issues requiring patches, code updates or data fixes.
• Participate in release planning; provide subject matter expertise on solutions to minimize customization; mentor and coach to increase product knowledge of staff with associated learning plans; Provide leadership and direction to development staff.
• Work with Family Responsibility Office and CYSCC ministry to produce documentation on business and systems requirements for Siebel and related subsystems of various applications.
• Assist other development staff, business clients, and team members according to work plans and resolve issues.
• Review and update documents and work plans related to Siebel changes and communicate to affected groups and individuals.
• Collaborate with Test Leads to define test strategies and review System Test plans for Oracle Siebel, Siebel Web Portal, BI Publisher Letters and Reports and other related FCMS components.
• Prepare documentation including detailed functional and technical design documents required for knowledge transfer including development and delivery of knowledge transfer sessions for any defect fixes / completed enhancements.

Confidential

Siebel Consultant

Responsibilities:

• Participated in project implementation including design, configuration, development, testing, documentation and deployments.
• Migrated system enhancements/application fixes; administered Siebel call center application including proposing hardware sizing, system architecture, software installation, patch updates and systems upgrade planning/execution; Provided advanced level support for Siebel applications and other software applications; Monitored Siebel system and proactively resolves system issues.
• Transferred Siebel knowledge to Confidential staff; created knowledge base documentation to assist in training.

Confidential

Siebel Technical Lead

Responsibilities:

• Responsible for Implementing, designing, developing, testing & deploying Oracle Business Intelligence applications.
• Responsible for Designing and implementing a complete COTS Siebel UCM - Oracle Data Quality solution for cleansing of Customer - Master Financial data.

Confidential

Siebel Middleware Consultant

Responsibilities:

• Setup and demonstrated Siebel 8.2 Case Management application functionality to various MTO departments on an AIX/Oracle platform as a part of proof of concept for entire carrier modernization project.
• Installed & configured latest Oracle EBS, Oracle Policy Automation, and Oracle Business Intelligence applications on Unix platforms.
• Deployed IBM Http server, IBM Web-sphere & Apache Tomcat applications server 7 integrated with Enterprise applications on AIX platform.
• Provided expert advice on Oracle Siebel development, configuration and customization utilizing COTS best practices.
• Architected & deployed Open Text ECM system to support content/document management activities throughout Ministry of Transportation.
• Worked with clients, business leads, business analysts, operational support, operational build teams, and other key stakeholders to determine technical requirements for developing infrastructure architectures to support numerous applications within Ministry of transportation departments.
• Planned, managed, and coordinated effective translation of client business requirements into systems models.
• Contributed to the definition and execution of the architecture checkpoint review process, balancing architecture with project needs and timelines.
• Assisted Chief Architect and project managers in planning work effort estimates as required.
• Assessed, defined, and recommended on the structure, standards, and relationships between suites of sub-projects and applications.
• Identified common re-useable services/components; the organization and layering of software and the determination of interfaces
• Assisted in defining, maintaining, & enforcing organization wide Enterprise Architecture practices/standards to ensure solution architectures.
• Identified, analyzed, evaluated, and resolved any problems, issues and concerns, including clarification of overall business function, services, rules and processes; security and privacy issues, service delivery concerns.
• Developed technical architectural documentation that includes diagrams and blueprints.
• Presented technical architecture to clients, architecture review board, operations and other stakeholders.
• Participated in multiple projects as a part Ministry of Transportation modernization project segment deliverables.
• Reviewed and approved Siebel Technical Design Documents and maintained a review log.
• Participated in application solution reviews, providing input to the solution and impacts on the technical environments.
• Evaluated, reviewed & participated in the procurement of new technical solutions for Ministry of Transportation.
• Conducted reviews on infrastructure design deliverables, providing documented feedback.
• Led analysis and definition of the design solution for the MTO-Carrier technical environments, resulting in practical and economical recommendations regarding hardware, network products, and system software.
• Reviewed & integrated technical requirements of the system, including applications, security, integration, performance, quality, and operational requirements.

Confidential

Siebel Application Designer

Responsibilities:

• Worked in collaboration with 3rd Party offshore vendor; provided leadership on technical solutions to meet Siebel Call Center, Service to Sales, and B2C requirements.
• Developed technical architectural documentation that included diagrams & blueprints.
• Presented technical architecture to client, architecture review board, BSA(s), and project managers.
• Performed functional and technical code reviews for all Siebel requirements, & worked closely with on shore / off shore development teams.

Confidential

Siebel Middleware/ Infrastructure Consultant

Responsibilities:

• Develop various components of Siebel including Siebel business objects, business components, screens, views, applets, business rules, assignment manager rules, workflows, & scripts.
• Integrated an end-to-end Siebel Public sector application with Oracle BI Enterprise which included Oracle BI Server, BI Answers, Interactive Dashboard, BI Publisher, and BI Scheduler.
• Analyzed Siebel case management business requirements to identify gaps and suggest technical solutions.
• Addressed BI dashboard and report security issues for all user roles and integrated Siebel application with LDAP, SSO authentication for OBIEE.
• Resolved Siebel application problems/issues that arose during the design & development.
• Provided senior-level technical assistance during Siebel implementation, conversion and migrations processes.

Confidential

Siebel Technical Lead

Responsibilities:

• Architected & deployed a highly available/load balanced/multi-lingual/Secure Siebel 8.1 solution for Public Works department; Lead teams in one of largest Siebel projects under taken by Confidential .
• Developed & Analyzed data warehouse applications using Oracle Business intelligence version 10.1.3.x & 11.1.1.x.
• Customized and configured business intelligence application using OBIEE Answers, OBIEE iBots, OBIEE Dashboards, BI Publisher and Administration Tool.
• Developed Dimensional Hierarchies/New logical columns/Filters/Variables per business requirements.
• Worked on Informatica tool’s Source Analyzer, Target Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Configured Siebel business components, and developed new Siebel screens, views, applets for Siebel e-Public Sector application to support 1000 case management call center agents.
• Developed Siebel custom workflows & leveraged Siebel out-of-box workflows to integrate Siebel Inbox functionality.
• Created custom server & browser e-scripts per client design specifications.
• Build a real time integration solution using Siebel integration objects, customized business services, workflows.
• Lead multiple development threads (custom development, package based development, COTS integration) within an overall SOA architecture.
• Led a team of Siebel developers in implementing Siebel quarterly maintenance releases.
• Implemented Siebel Universal Customer (UCM) version 8.1 solution for real time data feed from Siebel Call Center application.
• Planned Siebel upgrade processes & deployed Siebel 8.1 Case Management applications.
• Implemented Siebel Business Intelligence & Informatica enterprise servers.
• Worked collaboratively with other technical leads, coordinate development activities to achieve overall release goals.
• Lead Functional Qualification Testing (FQT) (development testing) via design, development, execution, and documentation of tests.
• Designed, developed, & implemented Siebel case management assignment rules.
• Developed estimates and allocated work in support of overall release delivery goals and project timeline.
• Prioritized the correction of defects, work closely with System Integration Testing, and coordinated development activities with other development leads to produce a coherent development baseline.
• Planned, maintained, monitored, and administered Siebel Enterprise applications.
• Analyzed, defined, designed, developed, & deployed Siebel Actuate Reports.
• Implemented and integrated Oracle Identity Management (Single Sign On) with Siebel Enterprise for 1000+ users.
• Designed and configured Siebel CTI solution with genesys middleware voice component for 500+ users
• Installed and documented genesys g-plus adapter; modified CTI business Services for EAI synchronization between Siebel & computer telephony servers.
• Installed, Configured Oracle Enterprise Manager application to diagnose performance issues & benchmark Siebel Object Managers.

Confidential

Siebel Technical Consultant

Responsibilities:

• Architected, deployed, and setup Siebel 8.1.1.5 Siebel e-Finance application environments.
• Installed & deployed HTTP Server for Clustered Application Servers using virtual Hosting.
• Configured JDBC Providers, data Sources & connection pooling via IBM web-sphere application servers.
• Deployed and tested applications in WAR, JAR, and EAR formats in an IBM web-sphere environment
• Conducted Siebel application server architecture reviews, and provided database server sizing recommendations.
• Participated in Fit/Gap Analysis sessions, and assisted in mapping business requirements with Siebel application.
• Developed Siebel Application Deployment Manager (ADM) processes to expedite migration across Siebel.
• Configured & integrated Siebel ADSI adapter with Microsoft Active directory.
• Designed, Configured, Installed, & Integrated Oracle Data Quality with Siebel e-Finance application.

Confidential

Siebel Infrastructure Lead

Responsibilities:

• Provided technical leadership to business units in a complex multiple vendor environments with-in various public sector groups.
• Architected & deployed Siebel 8.2 Public Sector Application.

Confidential

Lead Siebel Consultant

Responsibilities:

• Provided leadership and direction through technical subject matter expertise on systems integration, Siebel Data Model compatibility and multiple platform integration within Confidential framework and Confidential data components.
• Responsible for analyzing, developing, improving and maintaining cross-functional application practices, processes, structure, and tools, including participation in design meetings with Project managers and Confidential executives.
• Participated in project management activities and the planning process; monitor and reported to senior management on the status of project efforts and provide work effort estimates.
• Provided data expertise on a short notice to Confidential management and internal customers.
• Developed and ensured service levels metrics are met in co-ordination with Confidential Call Center team.
• Supported Siebel administration activities and Interface development.
• Monitored, and reported on issues with Siebel Production systems.
• Worked with the Confidential Business Technology team to facilitate the development and roll out of new releases and patch fixes.
• Supported Confidential processes for Territory alignments and Customer targeting in Siebel application.
• Updated and maintained Canadian sales territory assignments within a fast-paced and continuously changing environment.
• Fixed incorrect accounts/contacts/lead assignments based on pre-defined territory and assignment rules.
• Maintained custom interfaces with new and existing customer information systems for efficient management of inventory. Typical interfaces include receiving and sending products, customers, accounts, and samples data to third party vendors, Confidential data warehouses, and external Confidential systems.
• Designed, developed, and generated weekly, monthly COGNOS reports.

Confidential

Senior Siebel Consultant

Responsibilities:

• Lead a team of Siebel Trainers in delivering Confidential Siebel 7.8 Training throughout Canada.
• Transformed YPG business and functional requirements into Siebel technical design.
• Configured Siebel Order Management application; devise unit tests; assist quality assurance during testing; integrated developed solutions into Siebel repository.
• Devised strategies to improve performance and functionality of Siebel Quotes/Proposal application, taking initiative to drive changes in the best interests of end users.
• Provided level three application support as required for production defects and Incident Reports.

Confidential

Lead Siebel Consultant

Responsibilities:

• Provided timely technical expertise in system analysis, application performance improvement, design, testing, and implementation activities.
• Defined business requirements; implement change requests; modify Siebel business components, applets, views, and screens.
• Designed & developed workflows / workflow policies to meet Service Level Agreements (SLAs) based on Service request priority.
• Created and modified Siebel workflows to support e-mail processing and automatic notifications.
• Re-configured existing workflow processes for improved performance and scalability.
• Provided Level-3 Siebel 2000 and Siebel 7.5.3 application support to 200+ Confidential telecommunication customers worldwide.
• Diagnosed and resolved Confidential helpdesk agent’s Siebel issues; and act as single point of contact for any technical/Siebel related queries for the entire company.
• Transitioned legacy telecom customers from Siebel 2000 to Siebel 7.5.3 platforms.
• Managed highly customized development, testing, and production environments; Administer Siebel 2000 and Siebel 7.5.2 applications

Confidential

Senior Siebel Developer

Responsibilities:

• Designed and developed a comprehensive Sales Aggregates and Sales detail solution which ensured gathering of precise insurance data from a variety of data-ware houses and configured it into a single Siebel application screen.
• Implemented a fully functional Siebel Data Quality / List Management connector for Siebel e-Finance application.
• Architected a complete Web-Services solution to integrate a 3rd party software application into Siebel Finance.
• Participated in a large full cycle implementation of Siebel 7.5.3 e-Finance Services application for Manu-life Insurance Company of Canada.
• Configured business components; developed new screens, views, and applets based on customer requirements.
• Developed EIM jobs and mapped legacy data elements to Siebel database fields using Siebel Tools.
• Managed Manu-life delta releases; production moves; patch installs; defect resolution.
• Provided consultation to Manu-Life business managers on Siebel logical and hardware architecture.
• Liaised business requirements from Sales force representatives and documented design specifications.
• Researched and implemented business automation rules for Siebel Territory Assignments.

Confidential

Siebel Architect

Responsibilities:

• Architected a fully functional, end-to-end high availability Siebel\CRM solution for Confidential Canada call center users, using Microsoft Clustering techniques and Resonate Load balancing.
• Lead a team of 3 engineers in successfully upgrading Confidential production, development, and testing environments within a 58 hour window without any disruptions to business.
• Installed and Administrated Siebel 7 Analytics servers & clients; customized analytics repository and configured Siebel Answers application.
• Designed unit tests, system failover scenarios, and load-runner scripts to ensure Siebel implementation meets high quality standards and all business requirements.
• Installed, configured, and maintained development, QA and production Siebel Server environments.
• Programmed Siebel Application Server environment maintenance automation scripts using VBScript.
• Mapped and fully documented processes for Siebel Administrator and technical support tasks.
• Suggested ways to improve OLAP and OLTP backup/restore performance; Siebel File system cleanup, backup and recovery.
• Implemented Siebel Anywhere connector to distribute repository changes and upgrade kits from regional office in Toronto to headquarters in Illinois, USA.
• Monitored application events, network and application performance for bottlenecks and failures.
• Devised a detailed plan to bring production and development repositories in-sync with current databases.

Software Engineer

Responsibilities:

• Responsible for development, maintenance and enhancement of ODBC layer and database utilities; other related areas of responsibility include: debugging and fixing database defects; certifying fix-packs provided by database vendors; gathering server and client traces for analysis.
• Systems engineering responsibilities include: testing, analysis, and verification of server components to ensure every component meets Key Performance Acceptance; developing load runner scripts to verify (Siebel) application will support a multitude of users.
• Develop system check utility to verify application server and database server environments; server reporting tool to extract data and automatically report results upon test completion.
• Manage systems development for Siebel’s Build Engineering Team by resolving application and environment issues; also create scripts to setup server environments, and recommend database-sizing parameters prior to any major release.
• Perform automation for overnight test runs by integrating a third party application, components include: Marketing, Sales, Call Center, Analytics, Assignment Manager, EAI, Work Flow, Siebel Remote, and Enterprise Integration Manager.
• Train engineering teams on various topical issues in Performance and Development.
• Deliver department-wide presentations. Past topics include: setting up debug and release environments for testing and development; the use of profiling tools to monitor application performance; and trouble-shooting performance issues.

Confidential

Software Developer

Responsibilities:

• Responsible for development and maintenance of database access layer on all supported platforms.
• Identified bottlenecks and designed regression test cases to improve database layer performance; other areas of responsibility included: detecting and fixing runtime errors, memory leaks in Application Server and COM components.
• Created and configured Data Objects/Service Objects for the deployment in 2-tier and n-tier Client/Server environments.
• Administered database backups/restore, import/export, replication/upgrades; created database files, tables, indexes, views, stored procedures, and triggers.