SUMMARY

• Over 11 years of professional IT experience in all phases of software development Life cycle which includes hands on experience in Big Data Analytics and Siebel CRM configuration/customization.
• 2 + years of work experience in ingestion, transformation, processing and analysis of Big Data with hands on experience inCloudera distributions hadoop which includes HDFS, HUE, Oozie, Hive, Zookeeper, Impala, Flume, Sentry, Solr and YARN(MR2).
• Experience in data ingestion from RDBMS systems using sqoop and other in - house development tools to Hive and HDFS.
• Data governance using Cloudera Navigator.
• Experience in writing Hive queries and Pig scripts.
• Experience in Oozie workflows.
• Experience in various data formats and compression codecs.
• Worked extensively on Siebel versions: 8.2.2.3, 8.1.1.4/ 8.0/7.8/7.7 and version 7.5.
• Expertise in Siebel EAI - Integration Workflows, EBC, VBC, Web Services, MQ Series, Integration Objects, Siebel Adapters, EAI Transport Adapters, Data Mapper, SOAP UI, XSL Transformation, and WSDL.
• Developed stored procedures and queries using PL/SQL.
• Expertise in RDBMS like Oracle, MS SQL Server, MySQL and DB2.
• Team player with excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Big Data/Hadoop: HDFS,HadoopMap Reduce, Zookeeper, YARN, Hive, Pig, Sqoop, Flume, Oozie, HBase.

Languages: Java, SQL/PLSQL, Python, Shell Scripting, Pig Latin, HQL.

Project Methodologies: Agile, Waterfall model.

Databases: PostgreSQL, HBase, IBM DB2,Oracle 11g, MySQL, MS SQL server.

Web Tools/Frameworks: HTML, Java Script, XML, ODBC, JDBC.

Siebel Applications: Siebel ePharma 8.x, 7.x, Siebel eCommunications, Siebel Call Center 8.x,7.x,Siebel Call Center 8.x7.x, Siebel Public Sector 8.2.x, Siebel Finance 8.x,7.x, Siebel eEvents Management.

Siebel Modules: Siebel Architecture,Siebel Configuration, Siebel EAI, Siebel Business Services, Siebel eScripting / VB, Siebel Configuration, Siebel Workflows, Siebel Assignment Manager, Siebel Server Administration, Siebel UCM.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Big Data Consultant

Responsibilities:

• Sqoop to extract data from IBM DB2 and DB2 on Zos databases to Hive and HDFS.
• Data transformation using Hive.
• Data formats like Avro and Parquet.
• Compression Codecs like snappy,GZip,BZip and LZ4.
• XML to avro and XML to parquet conversion using open source projects from github.
• Data compression testing.
• Data governance using Cloudera navigator.
• Data ingestion and transformation from nCluster Aster database using python and hive.
• Sqoop Benchmark testing with 1 to n mappers for small, medium and large tables.
• Created hive backed reporting tables for BI tools like Cognos and Qlkview.
• Source control using GitLab.
• Scheduling jobs using Oozie and shell scripts.
• Performance tuning in production Hive scripts
• User credentials encryption in sqoop using bouncy castle.
• Partitioning and bucketing in Hive tables for query performance and data sampling.
• Query builders using Hive, impala, hive CLI and Beeline editor.
• Source database editors like IBM Data base studio, DB2 CMD and Aster ACT.

Confidential

Tech Lead \ Onsite-Offshore Coordinator

Environment: Siebel 8.0.0.9, 8.1.1.10, Informatica, Actuate Reports, Siebel CTI, Windows, Solaris, HP Unix, Oracle 11g.

Responsibilities:

• Led the Upgrade and Development teams in upgrade and future enhancement changes.
• Coordination with offshore technical team members in a daily basis to track the progress of technical deliverable to ensure the timely delivery of items as per the schedule committed to the business.
• Meeting with the business team to get the requirements for the possible application related enhancements, evaluate and prioritize them based on criticality.
• Involved in interactive intelligence CTI installation and integration/configuration with Siebel servers.
• Actively participated in pre upgrade, upgrade (upgrep and upgphys) an post upgrade activates in DEV, SIT, Training and QA environments.
• Repository Management for multiple deployments (Dev to SIT, SIT to QA)
• Identified the key file types involved in customizing the Siebel eDealer Open UI client.
• Customized the Siebel eDealer Open UI client by modifying JavaScript and cascading style sheets.
• Customized the manifest files both new and predefined(Adding Expressions, java Script files, etc.)
• Configured applets to use different web templates according to their mode for Siebel eDealer Open UI application
• Customized titles for the list applets for the eDealer application.
• Customized Siebel web templates as per requirements.
• Worked with Oracle Support team on Open UI issues.

Confidential, San Jose, CA

Tech Lead

Environment: Windows XP, Siebel e-Communications 8.1, Oracle 10g, Workflow Process, HTTP, Web Services, XML, XSD

Responsibilities:

• Supported current EAI real time integration jobs in production. Troubleshoot issues that cannot be resolved by dedicated L1/L2 support resources.
• Involved in Review of business requirements and functional design document.
• Identified approaches for development based on the Business Requirement document and created Configuration and Interface Technical Design Documents.
• Designed and developed Symbolic URL’sfor various Confidential site pages with piggy backing feature. The Symbolic URL’swere designed to support 20 different countries.
• Integrated third party system Confidential Site using XSD, XML on HTTP Protocol. Also created external and internal IO’s, Data Maps, EAI Value Maps, Client side Custom Business Services & Workflow as a part of the process

Confidential, TX

Sr. Siebel Consultant

Responsibilities:

• Was part of the team through the full life cycle of the project from requirements gathering to go-live.
• Was key in the Integration & Data team through Requirements gathering, Design, Build, Test and Deployment phases
• Design, Development, Testing of various Web services to integrate Siebel with Sakai, AAV Systems within CME Department.
• Configured eEvents Customer Portal screens and process flows to match the enterprise web look and feel. Performed Web template customization and Style sheet (CSS)modification extensively.
• Customized the out-of-box eEvents Checkout process to in corporate the external Payment processor within Siebel Portal - Using IFRAMEs and Symbolic URLs.
• Customized the eEvents User Registration Workflow Process by incorporating custom email Search functionality.
• Configured My Profile screens for customer demographic management and address maintenance.
• Integration between Siebel and Global Transport Payment Gateway (third party payment processor) using Siebel web service frameworks.
• Implemented Payment Reversal and Repeat sales from Back Office and Customer Portal Siebel applications using Outbound Web services.
• Integrated Siebel CRM with Oracle UCM to have real time customer master data across the

Environment: Siebel 8.1.1.4, Siebel Financial Services & Siebel eEvents, Oracle 11g RAC,Red hat Linux (RHEL 5)

Confidential, TX

Sr. Siebel Consultant

Responsibilities:

• Designed and implemented an EAI framework for integration using workflow policies and workflow processes and business services.
• Developed technical design, Test cases, Deployment plan, and Operations guide.
• Developed an integration strategy for Siebel - Oracle Webcenter 11g through Oracle Service Bus (OSB) Middle ware (FUSION Stack).
• Developed EAI daily interfaces for entities like Order, Account, Contact and Addresses.
• Developed Workflows and Business Services for CRUD operations for entities Order, Recurring Order, Constituents, Payments etc.
• Unit tested all Siebel Inbound web services using SOAP UI.
• Load tested all Siebel Inbound web services using SOAP UI Pro.
• Resolved many complex data issues within the organization in perspective of integration.
• Developed the Unix Shell Scripts for EIM Export daily batch job.
• Automated the EIM daily batch job in UNIX environment using CRON jobs.
• Developed technical and end-user documents.

Environment: Siebel 8.1.1.4, Siebel Financial Services, Oracle 11g RAC,Red hat Linux (RHEL 5)

Confidential, Easton, PA

Sr. Siebel Consultant

Responsibilities:

• Part of a seven member Configuration/EAI team that went through the configuration and data design effort for SFA and Call Center.
• Participated in a number of client meetings and developed a data strategy to complete the application upgrade and data migration efforts.
• Scripted Custom Business Services for generating Custom Email templates for different combination of Service Requests and Escalation Workflows for Call Center application. Designed Task flows for complex Service Request business scenarios.
• Configured Screens, Task Views and Task Applets for Service Request Task flows.
• Wrote eScript to invoke Taskflow from through Create SR button click from Account and Service Request screens for SR Creation
• Developed Task flows for Service Request creation based on the Area, SubArea, SubArea1 and SubArea2 combinations.
• Worked closely with the high level design team implement a process to prevent possible performance problems from being configured into the application.
• ModifiedSiebelVanilla Email Response workflows to facilitate user requirements.
• Developed and implemented the CTI definition and Business Service script needed for the SIEBEL and Apropos integration usingSiebelTools.
• Performed Unit Testing of CTI and Email response integration.
• Developed the Siebel Integration Objects/Components to send/received XML messages from their eCommerce application.

Environment: Siebel Financials Services 7.8.2.7, Siebel Financials Services 8.1.1,Lotus Notes Client, Oracle Server - Enterprise Edition 10g, Microsoft Windows Server 2003 SP1

Confidential, Easton, PA

Sr. Siebel Developer

Responsibilities:

• Reviewed the high level designs and recommended changes to improve performance and follow Siebel’s best practices.
• Configured Task flows for Project(Opportunity)creation.
• Developed the assignment rules to assign SFA leads being migrated from the legacy lead management system to appropriate Sales representative based on the territory.
• Was responsible for the configuration of Lotus Notes Integration (Invoking Lotus Notes using F9 with Siebel for outbound communications and activity creation for each such F9 email).
• Designed and Configured Siebel secured Web services for Blackberry Mobile Edge App integration with SFA.
• Configured a number of Siebel SFA views including the Single View for an account (360).
• Designed and configured Integration Objects for SFA Application.
• Managed the load testing of web services using SOAP UI.

Environment: Siebel Financials Services 7.8.2.7, Siebel Financials Services 8.1.1, Lotus Notes Client, Blackberry Enterprise Server(BES), Oracle Server - Enterprise Edition 10g, Microsoft Windows Server 2003 SP1

Confidential, Albuquerque, NM

Siebel Developer

Environment: /Components: Siebel Call Center 7.8, Oracle 10g, See beyond ICAN Suite 5.x, FACETS, EPIC & MEDIPAC

Responsibilities:

• Completed the assessment work and delivered a roadmap of the to-be state architecture
• Documented a number of to-be call flows and documented the to-be architecture
• Configured workflows to synchronize the Call Center and UCM data
• Configured a number of Member Services screens including the Member 360 View
• Developed the business service as part of the integration with the online payment service.
• Developed task flows to complete a number of Member services transactions including ID card change and Physician scheduling
• Developed system test plans and participated in the System Integration effort

Environment: Siebel 7.8, Siebel Call Center, Siebel Tool, Oracle 10g

Confidential, Atlanta

Siebel Developer

Environment: / Siebel Components: Windows 2000, Oracle 9i,Siebel Call Center, Siebel Tools, Siebel VB/eScript, Siebel Workflows, Siebel EAI, Siebel EIM.

Responsibilities:

• Involved in preparation the Functional & Technical Design Documents
• Implemented Siebel eScript code to meet client's critical business needs: For Base Package Integration with the external Web Service
• Involved in the Design and development of the Rate Load Integration with the external web service
• Involved in the Design and development of the Various workflows for the Integration with the external Middleware to cater the business requirements of the client
• Designed UI for new requirements (e-Script, Virtual Business Components, Business Components, Business Object)
• Modified the existing screens, views as per user requirement in the Product Administration.
• Modified and created new applets based on the business requirements
• Configured Joins, Links, and Pick applets using Siebel Tools.

Confidential

Siebel Developer

Environment: / Siebel Components: Windows 2000, Siebel 7.5.2, Siebel Call Center, Siebel Order Management, Siebel Workflows, Siebel Tools, Siebel EAI, Siebel EIM, Siebel VB, Siebel Configuration.

Responsibilities:

• Actively participate in the requirements and process mapping workshops for the project.
• Participated in the design of various development templates and methodology documents.
• Was part of the Quote and Order Management Configuration and was actively involved in the design, development, testing and deployment phases for this project.
• Participated in the design and configuration of the business object layer including configuring the Quote, Quote Items, Order, Order Line Items, Product and Product Line Items business components
• Worked extensively in the design and development of all Order processing workflows including Order Validation, Order Submission, Order Revision, Quote-to-Order Deep Copy and Receiving Order Status.
• Designed and developed numerous common services including the Deep Copy business service, Error Handling business service, common pick applets and MVG applets
• Configured & tuned Server components including monitor agents and server tasks to run the various Order processing and Eligibility check Workflows.
• Server administration tasks such as running and setting Workflow Monitor/Action Agent, repeating component requests, Workflow Process Manager, generating database triggers.
• Involved in trouble shooting and performance tuning the application

Confidential

Siebel Developer

Environment: Siebel 7.5.2, Siebel Call Center, Siebel Order Management, Siebel Workflows, Siebel Tools, Siebel EAI, Siebel EIM, Siebel VB, Siebel Configuration.

Responsibilities:

• Was part of the Use Case analysis to understand and document the requirements and complete process flows.
• Extensively participated in client meetings to extract and document all functional & system requirements.
• Completed the gap analysis and provided customization estimates to the client on various Siebel components.
• Configured the Order Management views, applets, web templates & business components.
• Developed the common component framework for the development effort including design/development templates, Error Handling Services, and common pick and MVG applets.
• Modified the Order Submit and Order Validation workflows and related integration objects to meet the custom order processes.
• Developed VBC based views to display Order Status including shipping status by developing an interface to the inventory application and dealer systems for shipping tracking information.
• Completed end-to-end integration testing and bug fixes resulting from the integration effort.
• Participated in knowledge transfer, and offshore work transfer efforts.