SUMMARY

• Having 12+ years of project management experience and 19+ years of total IT experience serving major clients as a Project Manager, Operations Manager, SME & Architect, Lead Analyst, Support & and Implementation specialist of several projects in Pharma, Healthcare, Financial domains.
• Managed 30 plus globally implemented projects from inception to transition phase by following SDLC processes and different project methodologies such as Agile (Scrum, Scaled Agile Framework), Waterfall and Iterative lifecycles. Advanced experience of leading teams to translate business requirements into technical design, development, code reviews, integration and implementation of complex and challenging technology solutions.
• Expertise in managing globally distributed non - collocated teams (off-shore/on-site model), international organizations, flex teams, by mentoring and coordinating with appropriate resources to ensure timely deliverables, 24x5 support & maintenance activities by meeting strict SLA’s with no escalations.
• Responsible for Project deliverables by managing and directing the teams to meet project planned time-lines during all project phases of Initiation, Planning, Execution, Monitoring & Controlling and Closing.
• Strong project management skills including Project Planning, Scope Management, Quality Management, Cost Management, Resource Management, Risk Management, Stakeholder Management, Vendor Management, Training and operational support.
• Good experience and knowledge of creating Project Charter, Project Management plans, Scope documents, WBS, Activities List, Risk Analysis and Assessments, Communications plans, RCA’s, Conflict Resolutions and Support plans within preset budgets. Reviewed and finalized testing plans, implementation plans and training plans.
• Managed project teams to drive deployment of several project and process improvement strategies & methodologies, ensuring maximum operational efficiency. Excellent time management skills by leading multi-tasking activities along with good analytical and qualitative abilities.
• Excellent understanding and implementation experience of Project Management processes and ITIL processes. Excellent knowledge of ITIL and service based delivery models with 7x24x365 operations. Ability to implement new business processes and lead discussions to arrive at better solution options and design considerations.
• Expertise in interacting with Business teams and Business User Groups, IT teams, QA teams, Project Management Teams (PMO), end users, vendors, along with Significant consulting/client facing experience.
• Ability to implement new business processes and lead discussions to arrive at better solution options and design considerations. Expert managing teams in both matrix and projectized organizations. Applied knowledge of operational processes and industry best practices of internal controls and risk management/assessment.
• Strong planning, organizational, project management skills and Vendor Management skills. Interacted directly with external vendors and internal customers to manage customer expectations and SLA’s.
• Worked closely with Stakeholders, Process Owners and Functional Management to assist study teams with the CTMS process, system enhancements and standards process queries. Excellent problem solving and decision making skills along with Analyze troubleshooting problems and make necessary recommendations for resolution and provide status to upper level management.
• Proficient in IBM Rational Suite, Microsoft Project, Visio, Word, Excel and PowerPoint.
• Communicate effectively and efficiently with stakeholders to identify needs and propose business solutions. Excellent written and verbal communication skills with outstanding team work skills. Communicates plans, status and issues to management and relevant stakeholders on a regular basis.
• Self-starter and effective team player with excellent interpersonal, organizational, project management, and analytical skills. Ability to quickly understand current processes, drive process improvements and to adapt to and initiate change.
• Experience with CRM Implementations with Siebel Call Center, Siebel Clinical Trails (CTMS) and ePharma, Financial Services, Sales & Marketing, Self-Service Portal applications (Standard Interactivity). Experience with design, Architecture, infrastructure, Data Model implementation & configuration, complex integrations and Tier-Two Production Support.
• Vast experience and good knowledge of Salesforce & Siebel CRM Architectures, data model along with various technologies such as Clarify, Apex, triggers, visual force pages, JavaScript, CSS, HTML, OOPS, C++, Visual Basic, XML, SOAP, Web Services, ASP, MQ Series, COM/DCOM, MTS etc. Proficiency with HP ALM, IBM Rational Suite, MS-Visio and MS-Project.
• Excellent knowledge and understanding of Big data and OBIEE architectures, data analysis, data migration, data governance, MDM, data management techniques using Oracle, SQL Server, DB2, Sybase, Access, Big Data, OBIEE, Informatica, Dimensional modeling, QlikView Analytics, Cloudera Hadoop, Hive, Pig and Sqoop, NoSQL etc.
• Participated in training real-time users and business users. Involved in technical presentations to customers and business teams.
• Good knowledge of FDA guidelines and GCP, Rave systems, VTMF integrations, ODS, SSID and Protocol Creations on P5 systems. Interactions with Clinical Super Users, Global Trial Managers, Local Trial Managers and Site Mangers to resolve any issues and assist with submitting visit reports in a timely manner to meet Federal time lines.
• Thorough knowledge of departmental policies and SOP’s to assure compliance with GCP and corporate policies. Ensure all staff adheres to professional standards and SOPs established for clinical research.

TECHNICAL SKILLS

CRM: Salesforce CRM, Apex, triggers, visual force pages, data loader, SOQL, SOSL, Workflows and Approvals, Eclipse, SOAPUI, JavaScript, CSS, HTML, OOPS, Siebel 8.0.3/7.5.3/7.0/6.3/6.0/5.0 , Call Center, Sales & Marketing, IVRS, EAI, WSDL, XML, SOAP, Web Services, SOAPUI, Force.com Eclipse, Runtime Events, Email Response & Integration, Assignment Manager, VBC, EBC, ePharma, Siebel Finance, eCommunications, Siebel Tools, e-Script and Siebel VB, Siebel eBusiness applications, Smart Scripts, EIM, Installation and Upgrade, Server Administration tasks, Actuate Reports

Databases Data Warehouse: Oracle 11i/10g/ 9i/8i/7, SQL Server 2014/2012/2008/2005/2000/7.0/ 6.5/6.0 , DB2 OS/390 8.1.5, Sybase and Access 2000/7.X, OBIEE, Informatica, QlikView Analytics, Big Data, Cloudera Hadoop, Hive, Pig and Sqoop

Operating Systems: Windows 10/8/XP/2003/NT 4.0/2000/98, UNIX, Linux, ZOS, MS-DOS, Sun Solaris

Programming Languages: Apex, C/C++, JavaScript, Siebel eScript, VB script, XML, HTML, PL/SQL, VC++, Java

GUI and Internet Tools: Visual Basic 6.0/5.0, Visual Interdev, Dream weaver, ASP 2.0, IIS 6.0, Java Server Pages (JSP)

Technology Tools: IBM Rational Suite, HP ALM, MS-Project, MS-Visio, SQL Plus, XML SPY, COM, DCOM, ATL COM, MTS 2.0, Active X, Web logic, Web Sphere, MSMQ 2.0, MQ Series, ADO 2.0, VSS 6.0 and PVCS

PROFESSIONAL EXPERIENCE

Confidential, NJ

Project Manager / Lead & Architect

Responsibilities:

• Managed multiple clinical trials application projects with a team of 12 resources driving towards project deliverables by monitoring closely time and budget during all project phases of design, development, implementation and production support activities.
• Managed globally distributed non-collocated teams (off-shore/on-site model), international organizations, flex teams, by mentoring and coordinating with appropriate resources to ensure timely deliverables, 24x5 support & maintenance activities by meeting strict SLA’s with no escalations. Managed tier-2 and tier-3 production support team members by assigning work and directing team to resolve critical issues.
• Responsible for Project deliverables by managing and directing the teams to meet project planned time-lines during all project phases of Initiation, Planning, Execution, Monitoring & Controlling and Closing.
• Created Project Charter, Project Management plans, Scope documents, WBS, Activities List, Risk Analysis and Assessments, Communications plans, RCA’s, Conflict Resolutions and Support plans within preset budgets. Reviewed and finalized testing plans, implementation plans and training plans.
• Experience of leading teams to translate business requirements into technical design, development, code reviews, integration and implementation of complex and challenging technology solutions.
• Worked closely with various IT teams on complex and critical activities and delivered projects with preset budgets. Worked on complex and critical activities and shared with the team.
• Responsible for project deliverables by monitoring closely on time and budget during all SDLC phases of design, development, implementation and production support activities to achieve SLA’s and project deliverables.
• Performed cost estimates for various projects, change controls and Support activities.
• Expertise in working with Microsoft Project and Visio along with all MS-Office products.
• Review and finalize testing plans, implementation plans and training plans.
• Participated in business requirements reviews, architecture and infrastructure discussions, high-level and Detailed Technical Design (DTD) specifications and reviews.
• Handled major projects independently such as Master Contact and Account ID, Master Site ID, Siebel Upgrade, Utilities development Change Controls and incident reports during all project phases by following SDLC and best practices.
• Provided solutions and architectural designs for critical business scenarios and issues by working directly with internal customers and external vendors.
• Thorough knowledge of departmental policies and SOPs to assure compliance with GCP and corporate policies. Good exposure to FDA audits, Rave systems, VTMF integrations, ODS, SSID and Protocol Creations on P5 systems.
• Participated in review of clinical trial data and clinical trial files and provided clinical review for annual reports.
• Direct interactions with Clinical Super Users, Global Trial Managers, Local Trial Managers and Site Mangers to assist resolving critical issues such as visit reports submissions in a timely manner to meet Federal time lines. Working with Medidata Cloud Pharma application for last 2 years.
• Coordination with IVRS teams to upload Subjects data into Siebel CTMS application and communicating with study teams for any roll-up counts discrepancies.
• Expertise in providing support and handling Siebel administration activities in deployments. Performed various tasks and roles for on-going Siebel releases, Siebel patch installations 8.0.0.7 and 8.0.0.10 for windows-7 and IE-8 browsers, creating and testing Siebel upgrade kits for mobile clients, support HI clients, ddlsync and Siebel software installations.
• Expert in analyzing production issues by capturing data from transaction log tables and audit trial data for any user accidental data updates and providing any deleted data to users.
• Worked on OBIEE with monitoring daily and weekly ETL loads and verifying log files for any errors. Worked with OBIEE in providing mapping documents from siebel data fields to Operational Data Warehouse (ODW) system and down-stream systems.
• Proficient in siebel application programming and writing complex e-scripts such as loading data using business services and supported existing production business services. Converted e-script to ST-engine compatible script for major entities.
• Written SQL queries as part of Production Support to verify data related issues and to validate on-going development activities.
• Provided reports to migration teams from siebel based on data range and clinical trial status. Performed Data loads using SQL Loader and Control files.
• Modified Business Services CTMS Counts Rollup and CTMS Dates Rollup using e-script to update Consented Dates and Counts from Subjects to Protocol level.
• Upgraded Clinical Administration Screens for Visit Templates, Protocols and Subjects to attach Visit Tempaltes to Sites and Subjects. Upgraded Clinical Subjects Screen and worked on Screen/Enroll functionality issues for creating additional Visit Activity of type Document.
• Responsible for Configuration and development of various CTMS screens such as Clinical Programs, Protocols and Sites Views and applets. Worked on UI Enhancements to convert 2-column to 3 -column layouts, showing Category View drop-down by modifying web templates.
• Back-up resource for executing daily subject uploads received from various operating companies and load excel data into Siebel database and performing roll-up counts and dates validation and provided reports of same by EOD.
• Customized CTMS Business components using e-script to auto generate Protocol #'s based on the Compound Name, Clinical Program Name and Phase # and Sequence #.
• Configured Workflow for posting clinical trial payments to SAP Beacon system using HTTP Transport. Created & updated Workflow Policies for roll-up counts from site level to region and protocol levels.
• Created various business services based on adhoc requests to load data as per the client needs and executed them as client-side services. Created data utilities to trigger Protocol and Region workflows for specific protocols to send XML to WebMethods to OPX2 systems.
• Updated Workflows to send Clinical Payments data from Siebel to SAP systems via WebMethods as a middle-ware. Developed Workflow Policies to trigger roll-up Dates from Subjects to Sites to Regions to Protocol levels.
• Developed interfaces to load protocol data from OPX2 system into Siebel CTMS application using ADODB connection, Business Services and Workflows. Involved in decommissioning CTMS Europe interface from Siebel to WebMethods for Incurred Cost data and Order Creation request interfaces.
• Good knowledge of and Certified in CTMS concepts like GLP, GCP, GXP and FDA process. Completed all certifications on-time as per clinical standards such as SOP, Regulatory and Compliance so on.

Environment: Microsoft Project, MS-Visio, IBM Rational Suite (Clear Quest & Clear Case), MS-Office, Share-point sites, Salesforce, Siebel 8.0.10/8.0.0.7 , Siebel eClinical and Life Sciences, Oracle 10g, Siebel e-script, TOAD 9.7.2.5/8.6 , PL/SQL and Windows XP.

Confidential

Delivery Manager / SME / CRM Lead Analyst

Responsibilities:

• Responsible for analyzing business requirements and writing functional Specifications. Defined system scope and translated functional requirements into technical specs and provided cost estimates for projects.
• Worked extensively with on-Site/off-shore development model by leading off-shore team and responsible for deliverables and development work by validating and taking care of System Integration & testing (SIT), UAT testing and migrating to Production during weekends.
• Mentored off-shore siebel resources via WebEx and telecon sessions by leading globally distributed team.
• Configured and customized various Siebel Screens for Members, Providers, Referral Submission, HCFA 1500, UB-92, Authorizations & Referrals, ID Card Request, Temporary ID Card request, Contacts, Service Requests, and Activities.
• Customized Siebel Self-Service Portal applications (Member Portal and Provider Portal) for Inquiry and Submission transactions like Claims, Payments, Eligibility & Benefit Accumulations, Auth, Referral and Claim Submissions and so on.
• Configured and Customized Applets, Business Components and Business Components, Views, Screens, Pick Applets, MVGs using MVLs, Dynamic & Static Pick lists using LOV’s, Joins, drill-downs, User Properties and so on.
• Expert in writing complicated Siebel eScript Code at Applet, Business Component, Business Service and Application levels to achieve business functionality wherever not possible through Siebel Configuration. Used Siebel debugging and troubleshooting techniques such as Siebel Tools debugger, SQL spooling and event logging.
• Good knowledge of using User Properties at Applet/Control/Business Component level to avoid scripting wherever possible.
• Worked on Email Response and Integration (Inbound and outbound Communications) for sending real-time email to subscribers after submitting EOB Suppression request to DB2 from Siebel. Also, batch email workflow is configured to send email to send email alerts to members for their on-line EOB availability.
• Created Siebel EBC’s (External Business Components) to integrate with DB2 database server OS/390 8.1.5 version. Expert in establishing a DB2 Connection and writing DB2 SQL queries. Created VBC’s (Virtual Business Components) to interface with external database to get Claims, Claim Payment and Auth/Referral information.
• Integrated Siebel with JAVA using J2C Connector and Siebel Properties files and workflow to upsert data into Siebeldb and for Application-login Authentication (LDAP)
• Specialist in Customizing GUI by modifying/creating Web Templates and CSS files to provide corporate look-and-feel to Siebel for Call Center, Sales and Portal applications. Also, used JavaScript, HTML, ASP, XML, dream weaver to achieve complex GUI functionality for Siebel Self-Service Portal SI applications.
• Created Smart Scripts with set of pages and questions, scripting and invoked using e-script for Claim Submission of Inpatient and Outpatient CMS1500 and UB04 transactions. Also, responsible for deployment and maintenance of smart script files to production servers and releasing the files onto File Systems. Responsible for writing scripts and invoking Smart Scripts using eScript. Validated Smart Script pages for conditionally required fields writing page-level and Script-level code.
• Created Symbolic URL’s to integrate Siebel with legacy systems to get Capitation Reports and EOB’s/EOP’s. Created Run-time Events to invoke Custom business services during Application login process and parsed Java Cookie information to send the same as input parameters to MOM web services. Created Personalization Rules to control visibility at applet and view level.
• Extended Siebel base tables S REFERRAL, S INS CLAIM, S CONTACT X etc as part of enhancements. Also, created stand-alone tables to integrate Siebel with DB2 application to base EBC’s (CX FEE REQ, CX EFT PAY). Written extensive SQL and DB2 Queries to analyze and resolve production issues.
• Used Haley Business Rules for simple validations of Service Request and Activity routing rules.
• Created new Business Components in Siebel for Actuate Reports purpose as per the requirements. Worked with reporting objects such as Report Object, View Report Object etc. in creating Data Supply library file (.ROL file) for Actuate reports.
• Coordinated with Testing teams and Project Release teams while performing UAT testing. Responsible for Web-Trend Reporting tagging work on Siebel end.

Environment: Siebel 8.0.3 / 7.5.3 / 6.0 , Siebel Call Center, Siebel Financial Services, Siebel Sales & Marketing, Siebel Portals (echannel), Siebel e-script, Siebel VB, IBM Rational Suite, Siebel EAI, Smart Scripts, Email Integration, CTI, Haley Rules Engine, SQL Server 2005, DB2, Actuate Reports 4.0, Siebel EIM and Windows 2000

Confidential, PA

Siebel Consultant/ Siebel Analyst

Responsibilities:

• Worked on Campaign Management screens and applets to populate Contact information into DNB document templates. Used Siebel VB Script Send Keys functionality to populate Contact information.
• Customized List Management views and applets “All Lists across Organization”, Contact/Prospect Campaign Response List Applet to align the screens as per the enhancement requirements and performed extra validations on the screen.
• Configured and customized various views and applets such as Campaign/Contact List Applet, DB CIS Customer Entry Applet and so on.
• Created new views such as DB CIS Home View, DB Smart Script Player View etc. for accommodating newly created applets into different sectors as per the design and added these views to the relevant Screens.
• Extended base tables and interface tables S SRC DTL, S ACCNT SRC, EIM ACCNT SRC, EIM SRC DTL, S PROD CONSUME etc. and EIM Table Mappings for the same.
• Modified existing BC’s DB Contract, DB Correspondence Templates and so on as per the need. Used and modified Joins and Links for use in Business Components and Business Objects.
• Worked extensively with Siebel VB in achieving various critical functionalities like communicating and integrating with MS-office products from Siebel application, locking campaign records while being edited by other users and so on.
• Written SQL Queries to handle and resolve production support issues.
• Involved in Testing Siebel applications during SIT (System Integration Testing).

Environment: Siebel Tools 2000, Siebel Sales 6.3, Siebel Marketing 6.3, Oracle 8i, PL/SQL, SQL Plus, Actuate Reports 3.2, Siebel VB, Siebel EIM and Windows 2000

Confidential, Indianapolis, IN

Siebel Developer

Responsibilities:

• Responsible for Configuration and development of Siebel Pharma views and applets for Samples and Call management screens Account Calls, Contact Calls, Pharma Sample List Applet, Reconcile Applet and Sample Adjustments.
• Responsible for extracting Mobile Clients and supporting them for Synchronization issues.
• Resolved Mobile Clients Transaction Log issues with Notes and Activities data.
• Used e-script to Reconcile Samples based on the difference of Sample Inventory.
• Analyzed existing EIM mapping documents for Samples and Medicals and leveraged the same for converting into EAI Interfaces.
• Worked on Enhancements in adding new Call Types to the Call Type pick list in Pharma Activity header applet.
• Involved in Administration activities migrating the SRF file from development to QA environment during deployment performing activities such as workflows, LOV’s, Views & Responsibilities, creating new Responsibilities and Employees, Extracting local databases.

Environment: Siebel 6.3, Siebel ePharma and Life Sciences, Siebel VB-script, Siebel EAI, Oracle 8i, TOAD, PL/SQL, Siebel EIM and Windows 2000.

Confidential

Programmer Analyst /Siebel Configurator

Responsibilities:

• Created new Applets, Views, and Screens since the requirements included heavy a customization, which could be sorted out by entirely creating new Application.
• Configured Siebel application using Siebel tools, Siebel VB for developing Custom build Screens, Views and Applets. Set up of Joins, Links pick lists, Drilldown links, and Siebel extension table’s usage as per the process Design.
• Created predefined queries for analysis purpose for the Call Center Managers and Supervisors Identify the Business transaction flow and developed process Flow charts.
• Developed design specifications for modifying existing Business Components, Business Objects.
• Involved in Creation of New Organization, Divisions, Position, Responsibilities, Employees, and association & assignment between employees, responsibilities & divisions.

Environment: Siebel Tools 99, Siebel Call Center, Siebel Sales, Siebel Workflow Manager, Siebel Assignment manager, SQL Server 7.0 & Windows NT 4.0