PROFESSIONAL SUMMARY:

• Over 15 years of IT industry experience in Analysis, design, development, testing, integration, administration and support of diversified applications using various technologies.
• Extensively worked with data like transformations, loads, reporting, analysis etc.
• Expertise in writing complex SQL queries, Query performance optimization, Stored Procedures/functions, Data loads and data quality.
• Oracle Siebel 7.7 CRM Certified Professional with experience in Analysis, Design, Development, Integration, Administration, Testing and Support of Siebel CRM applications.
• Experience in various domains like Loyalty, Public Sector, Call Center, Sales, Service, Insurance, Finance, Payroll applications.
• Expertise with various modes of application integration
• Worked in Agile methodology of implementation of projects.
• Experience in writing Test Scripts for system, Integration and User Acceptance Testing and executing test scripts in HP Quality Center.
• Excellent technical, analytical and troubleshooting skills.
• Enthusiastic & invaluable team member.
• Experience with off - shore model by leading off-shore teams and deliverables.

TECHNICAL SKILLS:

Big Data/Science Technologies: Hadoop1/2, HDFS, Spark, Spark Streaming, MapReduce, Hive, Sqoop, Kafka, Flume, Zookeeper, Pig

IDE/GUI dev Tools: IntelliJ, Eclipse, MS Visual Studio, Netbeans

Programming Languages: Scala, Java, JavaScript/jQuery, SQL, PL/SQL, T-SQL, HTML/DHTML/CSS, VB Script, XML, VBA, Python, PHP

Siebel: Siebel 8.x/7.x, Configuration/Integration

Databases: Oracle9i/10g,11g, MySQL, SQL Server, Hbase, MongoDB

Database Tools: SQL Query Analyzer, Data Import/Export, SQL Profiler, Toad, SQL Developer

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS), MS Excel, MicroStrategy

Testing Tools: HP-Quality Centre, BugZilla, other custom testing applications

Integration: Siebel Integrations (EAI, Web Services, HTTP Transports, MQ adapters, integration, VBC), Soap UI

Distributed Technologies: Java REST API, Java Servlets, JSP, JDBC, Siebel Web Services

Servers/OS: Unix/Centos, Ubuntu, Tomcat, IIS, BEA Weblogic Server, Windows Server(s), Unix/Linux(Ubuntu, Linux Mint etc)

ETL Tools: SQL Server Integration Services (SSIS)

Build Tools: Maven, SBT, Ant

Misc. Tools: Putty, SVN, GIT, MS Visio, MS Project, Ambari

SDLC Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. Technical Consultant

Responsibilities:

• Working on analysis, design & development of integrations between Siebel CRM & middle-ware application layer.
• Loading the Loyalty application log data using Spark Streaming into HDFS (Hive) through Kafka pipelines
• Reading the delimited file data using Spark & analyzing the application exceptions/errors after the new major release.
• Loading the data into Hive partitions
• Working with Siebel Data Model & optimizing the Siebel’s SQL queries by analyzing Oracle Execution Plans, creating/optimizing the database indexes.
• Working on Siebel Loyalty application setup including Program, Promotions, Member, Accruals, Redemptions, Points processing, Points expiration, Tier processing, Coupons etc.
• Design of Technical Design for integrating Loyalty Accrual & Redemption transactions, Loyalty member, cards, coupons between Siebel and other transaction sources.
• Troubleshooting & analyzing the data using SQL scripts.
• Creating various test-cases
• Integration & Load Testing using Soap UI test cases
• Writing various SQL queries to analyze and validate the data.

Environment/Software used: Apache Spark Streaming, Kafka, Flume, IntelliJ, Scala, Siebel 8.1 Loyalty application, Siebel Tools/Client, Oracle 11g, SoapUI, SQL, PL/SQL, SQL Developer/Toad, Subversion, Sharepoint, HP-ALM/QC, Unix, Putty etc.

Confidential

Log Files Analysis

Responsibilities:

• Analysis of Apache Web Log files & Power Plant’s predictive Analytics using Apache Spark
• Perform Extract Load & Transform the data using Spark transformations
• Extract the dataset into RDDs and DataFrames to perform various operations
• Extract each component of data & perform analysis of log errors using Histogram
• Perform Regression Analysis & Predictive Analytics using Spark’s ML methods.

Environment/Software used: Databricks Hadoop Cluster, Spark 2

Confidential, Minneapolis, MN

Application/Data Engineer

Responsibilities:

• Worked on the analysis & design of Integration between Siebel & web applications using Shell Scripts, Web Services, Spark Scala, SQL Scripts, Oracle ActiveMQ.
• Used Apache Spark RDDs to transform & analyze the Delivery schedules data.
• Storing the data in HDFS/Hive on Hadoop cluster.
• Writing various SQL queries to analyze and validate the data.
• Scheduled periodic integration between Siebel SR/Activities and Cisco Auto-dialer by generating CSV files using Shell Scripts & SQL Scripts.
• Created Siebel jobs for scheduled integration between Siebel SR/Activities and a Job tracker Web Application using Siebel Outbound Web Services.
• Created Workflow Processes to query data into Integration Objects and submitting the message XMLs to the Oracle AQ (configured by JNDI mapping)
• Created Workflow Processes to generate the request message to invoke Outbound Service and updating the payload in Siebel.
• Created PL/SQL Package & Stored Procedure to query from Siebel to generate a file to be sent to Cisco Auto-dialer for outbound calls.
• Created Siebel RCRs to schedule various jobs to invoke Workflow Processes that Business Service script to validate the Quote line items and Order line items with various business rules.
• Configuring various Siebel objects (Views, Applets, extending table etc.)

Environment/Software used: Apache Spark, Scala, Siebel 8.1 Call Center Tools/Client, Apache Spark, Oracle 11g, SQL, PL/SQL, Shell Scripts, SQL Developer, Subversion, Sharepoint, HP-ALM/QC, Unix, Putty etc.

Confidential, Sunnyvale, CA

Sr. Technical Consultant

Responsibilities:

• Design & Developed the Java RESTful Services for integration with Siebel CRM
• Worked on integration with Siebel CRM.
• Working on Order management entities: Quotes, Orders, Fulfillment, Work Orders, Assets/MACD.
• Created Siebel EBCs to display external data on Product attributes.
• Created Business Service script to validate the Quote line items and Order line items with various business rules.
• Built a tool using Java to generate & import the Product Eligibility Compatibility rules into Siebel.
• Worked with (Asset) Data Migration team with SQL scripts in importing legacy Assets.
• Writing SQL queries to analyze and validate the data.
• Working with Siebel Data Model & optimizing the Siebel SQL queries by analysing Oracle Execution Plans, creating/optimizing the database indexes.

Environment/Software used: Eclipse Neon, Java RESTful API, Tomcat8, Siebel 8.1 Call Center Tools/Client, Oracle 11g, SQL Server, SQL, T-SQL, SQL Developer/Toad, HP-ALM/QC, BI Publisher, Subversion, Sharepoint etc.

Confidential, Portland, OR

Siebel CRM Integration Consultant

Responsibilities:

• Created Java RESTful Services needed for Portal integration for Member enrollment.
• Created Workflow Processes to expose as Web Service
• Working with Siebel data model for integration .
• Working with Data Maps for data transformation.
• Created new Siebel screens and views for Health Provider/Network/Plans.
• Writing SQL scripts to analyze and validate the data.
• Worked with configuring Siebel objects as per Oracle Expert Services review comments.
• Exposure to Siebel Open UI.

Environment/Software used: Eclipse IDE, Java REST API, Tomcat7, Siebel 8.2.2.3 Public Sector, Oracle 11g, SQL, Soap UI, SQL Developer, XML, JIRA etc.

Confidential, S. Portland, ME

Siebel CRM Integration Architect

Responsibilities:

• Analysis, Design, Development of Siebel to B2B integration.
• Working with Siebel real-time integration using HTTP Transports, Web Services, Runtime events and Workflow Policies
• Develop various workflow processes that are invoked by runtime events
• Created a RTE service layer to capture Runtime Events as jobs
• Worked with Server Requests business service to submit workflow request jobs to specialized component.
• Worked with Siebel Integration Objects for integration between Siebel & web applications.
• Worked with various Siebel component jobs/RCRs.
• Worked with HTTP transports to send IO/XML messages to a web application.
• Siebel application configuration involving various Siebel objects using Configuration, eScripting, Server Component administration.
• Working with various SQL scripts to verify data.
• Working with ETL tools (Informatica, SSIS) for migrating data.
• Working with Communications Outbound Manager, Communication profiles to send emails
• Server administration tasks like full compilation, srf replacement, browser-scripts, component administration, Server shutdown/restart
• Working on Siebel Data Model & analyze the SQLs.

Environment/Software used: Siebel 8.1 Call Center, Oracle 11g, SQL, SQL Server 2010, SSIS, HP ALM/QC, Soap UI, Putty, Unix, Toad, XML, Subversion etc.

Confidential, Santa Clara, CA

Siebel Integration Consultant

Responsibilities:

• Analysis, Development, Testing of Siebel to Mobility integration.
• Developed various Siebel Inbound Web Services to enable Mobile Integration Platform to consume & display data in Mobile devices using mobile app.
• Exposed custom workflow processes as Inbound Web Services
• Worked with the Integration Objects, its Components and keys to be used for data to be exchanged between Siebel & Mobile app.
• Worked with Data Mapping to convert the data from one IO format to another
• Developed custom workflows to enable the Mobile app to choose appropriate Statuses by integrating with Siebel State Model for Service Requests & Activities
• Worked on Web Service WSDLs to generate the SOAP requests
• Worked with the SSO & AD based integration using Session Tokens between SOAP requests
• Siebel application configuration involving various Siebel objects using Configuration, Scripts (eScripting), Server Component administration.
• Designing the High Level Design Documents for application integration.
• Testing SOAP requests using Soap UI.
• Working with SQL scripts using joins defined in Business Component.

Environment/Software used: Siebel 8.1 HTIM, Oracle 11, SQL, Soap UI, MS-Visio, MS-Project, HP Quality Center, XML etc.

Confidential, Culver City, CA

IT Specialist/Analyst

• Analysis of the new development changes needed for the existing Siebel application by interacting with business users and proposing new solutions
• Worked with Siebel EAI using HTTP transports and Web Services
• Data imports using SQL loads and SSIS packages
• Developed and supported Siebel HTTP Inbound transport interfaces that receive Opportunity data from other payroll processing applications and engines
• Developed EAI HTTP transport that send the messages to customer and Quote status to other web applications.
• Worked on inbound Web Service that sends Opportunity & Order data to payroll processing applications.
• Worked on Proposals generation in Siebel application
• Worked on various workflows to update the XML data passed onto the workflow and insert the data into Siebel database.
• Siebel application development & support involving various Siebel objects using Configuration, Scripts (eScripting), Component administration.
• Developed many reports using the SQL queries, stored procedures, Crystal Reports, SSRS.
• Designing the High Level Design Documents for application integration.
• Testing various internal applications.

Environment/Software used: Siebel 8 Finance, Oracle 10g, SQL Server, SQL/T-SQL, Eclipse, MySQL, MS-Visio, Soap UI, Crystal Reports, SSRS, SSIS, Putty, Unix, XML etc.

Confidential, Jacksonville, FL

Siebel Analyst/Developer

• Involved in analysis/design of product visibility using Catalog Categories & Access Groups.
• Writing test scripts for testing the specific business requirements.
• Close interaction with the business/end users for understanding the business requirements and the Test Scripts to be created.
• Developing the Test Scenarios in Mercury Quality Center and interacting with various teams for integration testing.

Environment: Siebel Finance, Siebel 7.5 Client, Oracle 9i, HP ALM/QC, XML, SQL, PL/SQL, MS-Visio, Unix

Confidential, Milwaukee, WI

Siebel Techno-Functional Consultant

Responsibilities:

• Analysis of Business Requirement related to Order Management objects (Opportunities, Revenues, Quotes, Activities).
• Development of new Siebel application requirements using Application Configuration, eScript, Workflows, Assignment Manager, Data Maps.
• Application configuration using data Tables, Business Components, Business Objects, Pick Lists.
• Designed various Workflows as per the requirements
• Worked on Application Internationalization using Symbolic Strings and apply them to various UI objects.
• Worked with Data Maps for copying data from Opportunity to Quote.
• Performed Code Review meetings to ensure the application confirms to Siebel recommended standards.
• Wrote various Design Documents HLD, LLD and Review the design documents
• Writing the Test Scripts (OQ) for testing application navigation to test UI and the negative testing
• Executing test cases in HP Quality Center.
• Provided support for testing phases (OQ, PQ) by providing the test data, analyzing and clarifying the issues as necessary and supported the users as a post go-live process
• Extracting the component logs and troubleshooting various application issues

Environment: Siebel Life Sciences, Siebel 8.0 Tools & Client, SQL Server, Windows/Unix, HP Quality Center, XML, SQL, PL/SQL, MS-Visio

Confidential, Hoffman Estates, IL

Sr. Siebel Developer

Responsibilities:

• Involved in migration of Siebel database from Oracle 9i to 10g.
• Configured and setup database drivers needed that support Siebel 8.0.
• Supporting various Queue & HTTP transport based integration modules
• Setting up the new Development, Test and Production environments by Installing Database, Gateway, Siebel servers, SWSE on Windows servers.
• Starting & shutting down of the Siebel server, gateway, and web server to replace srf or troubleshoot the application.
• Experience in creating Database extract for the developers for their local database initialization.
• Siebel Server administration and user management, roles and responsibilities.
• Responsible for coordinating the requirements, design, development and testing.
• Configured the Siebel objects Confidential business object, UI layers for enhancements required by the business.
• Designed the table level Mapping between External Table/columns to Siebel EIM Table/columns
• Worked with SQL loader utility to load the data from flat files onto Siebel temporary tables.
• Developed the database procedures & triggers to process the data before entering the Siebel database.
• Prepared IFB files and created EIM jobs to load Siebel base tables
• Establishing the communication between Siebel and web application running on Tomcat web server.
• Analyzing the Siebel application logs and troubleshooting the issues.

Environment: Siebel Financial, Siebel 8.0 Tools & Client, Windows Server 2005, Oracle 10g, Apache Tomcat, JSP, SQL, PL/SQL

Confidential

Techno-Functional Siebel Consultant

Responsibilities:

• Implemented Business Object layer by customizing/creating Tables, Business Components and their mappings to view the relevant data on UI.
• Implemented Presentation layer by customizing/creating the UI objects like list/ form/ MVG/ Association Applet, Views, Screens.
• Understand Siebel Data layer and create any EIM loads needed to import data into the relevant tables
• Analysis and development of Integration business requirements for the data coming into Siebel from various interfaces (ODM, BAL, CMPAL).
• Configured the specialized Drilldowns (static & dynamic) for navigation to various views/applets as per the business needs.
• Devised and developed the workflows for processing the event-feed messages coming from interfaces.
• Worked on Integration Objects that represent the data that is passed across systems through an MQ Series middleware.
• Interaction with interface teams for bringing the consistency with the messages/XMLs exchanged between systems.
• Designed the workflow that verifies the data content in the XML and insert the data in Siebel based on the content in XML.
• Created a core API/Business Service to record/track all kinds of communications to the customer in the form of Email/SMS/Letter/Callback.
• Created various Communication Templates for Email/SMS/Letter.
• Worked with Inbound and outbound Web Services to process data with and from java/web applications.
• Worked extensively with XMLs and their processing objects.
• Modified the CSS/template files for adjustment of layout of the application.
• Configured the customer Dashboard.
• Worked with Component Requests and the workflows to be invoked periodically
• Writing various design documents, LLD and HLD

Environment: Siebel Call Centre, Siebel 7.7 and 7.5.3 Tools/Client, Oracle 8, Unix, SQL Loader, XML, SQL, PL/SQL