Senior Consultant

SURESH VARADARAJAN, M.B.A., PMP

*** ******** **. *******, ** 75019

972-***-**** (H) 214-***-**** (M)

********@*****.***

Synopsis:

• Extensive experience in aligning customer touch-points, business processes and technological solutions to continuously improve customer experience and providing methodical solutions into IT, Data Warehousing, Customer Relationship Management (CRM), Marketing and Communications.

• Project Management: Involved in project planning, scoping, scheduling, defect tracking, risk analysis, and reporting. Facilitated client interactions and client training.

• Solution Concept to Execution: Unique competency in translating business issues into customer solutions including requirements development, software development management, delivery, support, and analysis.

• Comprehensive knowledge in gathering requirements, writing business documents, use cases and generating business and technical models.

• Product development: Full lifecycle experience in scoping, designing, developing, deploying, and supporting enterprise scale business application.

• Teaming and collaboration: Specialize in creating cross-functional, cross-organizational teams with the customer to identify, prioritize, and design solutions for business requirements.

• Strong interpersonal skills in dealing with non-technical clients in requirements analysis and development of projects and building collaborative relationships among cross-functional groups internally as well as with external customers.

• Self-motivated, efficient team player and adaptable to new technologies and needs.

• Advanced communication skills across all media: email, presentations, web content.

Education: M.B.A. in Information Systems, University of Texas, Arlington (1999)

M.S. in Statistics, University of Madras

B.S. in Statistics, University of Madras

Professional Certification:

Certified Project Management Professional (PMP)

Siebel Certifications

- Siebel 7

- Siebel 7 Business Analyst

- Siebel 2000 Customer Certification

Accomplishments and Strengths:

Excellent communication and interpersonal skills

University Rank Holder in B.S

Extensive Consulting experience

Technical Skills:

ETL Tools Informatica (Power Center 7.1.2/6.2/5.1)

Operating Systems MVS - OS/390, OS/400, UNIX, Windows NT Windows 2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red Hat Linux 7.2/7.3

RDBMS DB2/S390, DB2/UDB on NT,Oracle 7/8i/9i(SQL, PL/SQL, Stored Procedures, Functions), MS-Access 2002/2003, SQL Server 2000/7

Data Base Tools Toad, SQL Navigator 4.0, SQL Loader

Data Modeling Erwin

Reporting tools Business objects, Cognos, Cognos Report net

Configuration & Tools Siebel Sales and Call Center, Siebel ERM; Siebel 6, Siebel 7.8, Siebel 8.1, Siebel Tools 6/7/8, ABAP

Web Technology HTML, Java Script, SOA, Web Services, multi-tiered architecure

Languages JAVA, Java Script, SQL, COBOL II, JCL, PL/SQL,ABAP/4, BAL/370, Siebel VB, eScript ,HTML, PL/SQL

Productivity Tools TSO/ISPF, SDF/SDF II, SPUFI, QMF, MS Project, Livelink, eRoom, Visio, Powerpoint, MS Office

Work Experience:

Alcon Labs (11/2009 – 05/2010)

Siebel Project Manager/Business Analyst for Siebel 6 to Siebel 8.1 conversion

• Created Business Process inventory for Sales & Marketing, Customer Service and Technical Services processes.

• Developed a process to track BP changes for weekly status reporting

• Enabled Screen to Screen comparison of Siebel 6.1 and 8.1 processes to verify the integrity of conversion process

• Mapped Siebel 6.1 views to Siebel 8.1 and recorded the process changes

• Resolved Siebel 8.1 conversion issues through Siebel tools configuration

Process Consultant for Health Care Provider (05/2009 – 10/2009)

• Developed process to track and improve claims submission

• Developed reporting process for claims and revenue management

• Managed a software product called Medisoft, which is used for Patient

Management, Claims Management and Statement Management

Ludicity Inc (08/2008 – 02/2009)

• Implemented Siebel Call Center 8.0 for AZZ Inc., Fort Worth, TX.

• Configured Service Request, Contact, Project and Communication screens,

BO, BC, Views, Applets, user properties to satisfy customer requirements.

• Designed and developed custom solution for approval process using Siebel

Workflow Process, Business Service, WF policies and Actions. .

Keane Inc. 10/2002 – 06/2008

On Consulting Assignment at RadPharm Inc., Princeton, NJ (02/2008 – 03/2008)

• Siebel Technical Lead: Involved in the design of Siebel Life Sciences application

for RadPharm Inc. in Siebel 8.0 environment.

On Consulting Assignment at Cisco Systems, Richardson, TX (10/2002 – 01/2008)

Technical Architect:

• Siebel application Architect/Integrator at Cisco HRC Siebel 7.8 multi-tiered, multi-lingual (English, Japanese, Chinese and Korean) ERM (Employee Relation Management) implementation for Employee Case Management system

• Provided consulting services on Functional Areas – Siebel ERM, eMail Response, Siebel Workflow Process, and Custom integration solution.

• Involved in gathering requirements, and creating functional and technical specifications.

• Successfully lead the integration of three new groups (Employee Relations, Regulatory Affairs and MMC) into the Siebel ERM application.

• Developed and implemented Queue Based assignment of Service Request using Assignment Manager Process.

• Successfully defined the functional process to create Service Request from inbound email using Siebel eMail Response module, custom Business Services and Workflow.

• Successfully designed, developed and implemented the integration process between Cisco HRC ERM and ACS (external vendor handling Benefits cases for US/Canada based Cisco employees).

• Successfully completed Siebel 7.5.3 to 7.8 upgrade and migration of WMS application from UNIX to Windows.

• Lead Application support for all four (HRC, ER, RA and MMC) application user group.

• Involved in the extraction (ETL) of data from Siebel Base tables such as S_SRV_REQ (Service Request), S_EVT_ACT (Activity), S_CONTACT (Contact),S_USER and Audit Item table to provide data for analysis. Extensively used ETL to load data from wide range of source such as flat files, XML to Oracle

• Worked with Informatica Power Center 6.2 using transformations such as Source Qualifier, Sorter, Filter, Lookup, Expression, Aggregator, Joiner, Update Strategy, Router and Rank to slice and dice data, to populate target tables (Fact and Dimension tables) for BI reporting. Created various target tables populated with Service Request details such as count, service request elapsed time, service request owner, service request status and sub-status, service request contact and service request source for reporting.

• Developed slowly changing dimension mappings to populate target table with service request status/sub-status changes based on last update time on the service request.

• Worked on Informatica Workflow Manager to create and execute workflow for the mappings created in Designer. Used workflow monitor to monitor workflow processes and troubleshoot issues

• Used Debugger in troubleshooting the existing mappings

Project Management:

• Prepared project plans, schedules, Business need Analysis, Issue logs and Risk Matrices.

• Produced road maps, templates and followed best practices in Business Requirement gathering.

• Worked with Audit teams to make WMS Siebel Application HIPAA and SOX compliant.

• Worked with infrastructure team to setup development, stage and production environments. Established guidelines to monitor all three environments. Worked closely with Off-Shore QA team in preparing test scripts and conducting QA tests. Coordinated and conducted volume and regression testing. Helped in identifying, tracking, documenting and resolving defects. Worked with Active Directory team to setup test users.

• Extensively involved in all phases of SDLC – Feasibility study, Analysis, Discovery, Design, Development, Delivery, Testing, Performance evaluation, Maintenance and Training.

• Met regularly with Stakeholders, Business Leads and Coordinators to evaluate their needs and control Project Schedule and Scope.

• Facilitated and developed reports to track SLA.

• Provided subject matter expertise and prepared project status reports.

• Mentored and Trained Off-Shore resources.

• Scheduled, Facilitated and conducted knowledge transfer sessions for Off-Shore resources.

• Worked closely with global teams – APAC, EMEA, Emerging Markets and Americas and provided day-today support.

Siebel Systems, Dallas, TX

10/2000 – 08/2002

On consulting assignment (EAI Specialist) for HP-Compaq using Siebel 7

• Involved in requirement gathering for migrating Siebel Application. Gathered interface requirements to send and receive data from external system, namely SAP.

• Drew up requirement document and gap analysis document.

On consulting assignment (EAI Specialist) for Nextira One Communication (Siebel 7 and Siebel 6.3)

• Worked on analyzing, designing, documenting and prototyping the various integration/interfaces to the client’s java framework. The integration strategy involved creating real-time synchronous interfaces to java servlets using Siebel’s HTTP adapters and passing requests to these servlets using the GET method. The java servlets receive and service these requests by passing hyperlinks to reports, which are then rendered in a Siebel applet. The Siebel eAI framework was leveraged for this effort.

On consulting assignment (Project Manager and EAI specialist) for Nokia Corporation using Siebel 6.3

Siebel Marketing implementation

• Designed and developed workflow policies and processes to initiate notification process and electronic routing and approval of documents. Also involved in configuration of business components and workflow policy objects to enable workflow process.

On consulting assignment (EAI Specialist) for Alltel (Telecom Company) using Siebel 6.3 (Siebel SFA Implementation)

• Developed workflow processes to create activity upon creating service request and to escalate unattended service request status.

• Set up workflow processes, workflow policies and workflow monitor agents in order to process workflow requests.

On consulting assignment (as Technical Architect) for ATX Technologies using Siebel 6.3)

Siebel Call Center implementation

• Implemented Siebel Call Center Application to support over one hundred customer care call center representatives. The Siebel application is used to manage and support in-vehicle emergency-response services - to high-end car owners like Mercedes, Jaguar, Infinity, Ford, Lincoln etc. using on-guard tracking system.

• Implemented Siebel Call Center to support – Accounts Management, Opportunities, Contacts Management, Asset, Service Request, Products and Activities management. Worked on the workflow that creates/updates Opportunity, Activity, Service Agreement, Order Entry, Contact, Service Request and Account dealer information whenever a change in the Account Status occurs.

Epic Data International, Irving, TX

Lead Systems Integrator, 10/1998 – November 2000

• Provide custom solution for SAP warehouse and Material Management process.

Participate in the design and development of automated data collection process. The development is done on both two-tier and three-tier client server architecture.

Design and develop Java server for the data collection process.

Design and develop function modules using ABAP/4, which will be invoked remotely (RFC) to perform transactions in WM and IM modules under Material Management in the SAP system.

• Developed solution for integration of SAP transactions such as goods receipt, goods movement, transfer requirement, transfer order and inventory control.

• Worked closely with customers and their user groups to provide customized solutions.

• Offered custom solution to variety of customers including SonoPress, Marathon Cheese, Pratt & Whitney, Al Wheaton Group and BC Gas. Gained proficiency in custom IDOC development and ALE configuration.

Abacus Technical Resources, Dallas, TX.

Senior Technical Consultant, 05/1997 - 10/1998

• Worked on the configuration of MAP (Market Analysis and Profitability) system in Integrated Test Environment for Frito Lays Inc., Dallas, TX. This involved configuration of DB2 and IMS databases for the application.

• Worked on Year 2000 conversion project at Texas Instruments, Dallas, TX. Gained proficiency in using REVOLVE, a tool from Micro-Focus that analyses the impact of two digit dates. Participated in all with all four phases - Inventory, Analysis, Renovation and Testing – of the project.

Online-Resources/Comsys, Harrisburg, PA

Technical Consultant, 11/1992 - 05/1997

• Involved in the design and development of CARS Allocation CARS Supply determination system for Burlington Northern Santa Fe, Fort Worth, TX. Extensively used IBM MQ Series on OS/390, IMS and DB2 to provide solution. This was done on IBM mainframe system using WORKFLOW (IBM MQ series), DB2, IMS DB/DC, COBOL II and PL/1.

• Participated in the design and development of Financial Application Systems at Pennsylvania Blue Shield, Harrisburg, PA. Developed a sub-system that bridges the Trend Analysis System and Management Reporting System for financial planning.

• Involved in the design and development of loan-servicing subsystem for Pennsylvania Higher Secondary Education Agency at IBM Harrisburg, PA. Developed UI in CICS and business logic in ADW COBOL interface. Extensively used IBM’s automated testing tool called WITT. This system was developed using ADW (a fourth generation development tool), COBOLII, DB2, CICS and WITT (Workstation Interactive Testing Tool).

R.S. Software, Calcutta, India.

Project Manager/Technical Consultant, 01/1989 - 10/1992

• Involved in the design, development and maintenance of IBM’s financial system called CAPS at IBM Southbury, CT. Extensively used COBOL, IMS and REXX. Also used EDI/EFT to route funds between customers and banks.

• Participated in the development and maintenance of Iowa Medicare System for EDS, Dallas, TX. The Medicare System was developed in BAL 370, COBOL, CICS and VSAM.

Contact this candidate