Project Support
Resume:
Nikhil Chandra
Sr. Certified Boomi Consultant
***********@*****.***
Professional Summary:
●Certified Dell Boomi Integration Developer I & II
● Around 8 years of strong experience in development of enterprise-level applications, functional and technical design.
●4+ years of strong experience in building and deploying of Dell Boomi AtomSphere Processes.
●3 years of extensive experience in designing and creating Integration projects using Tibco ActiveMatrix Suite of Products, such as Tibco BusinessWorks (BW), Tibco Business Studio, Enterprise Message Service (EMS), Rendezvous (RV), Designer, Tibco Adapters, Hawk.
●Extensive experience in implementing SOA enabled web services using Boomi
●Implemented API components with configured SOAP and REST endpoints.
●Extensive experience in implementing interfaces using Boomi
●Extensive Experience with Boomi connectors like Database,Anaplan, SAP, FTP, Web Services Soap Client,
Webservice Server Connector, HTTP Client, Mail, JMS, Salesforce.
●Designing and Implementing Integration and messaging solutions using TIBCO Business Works, TIBCO EMS.
●Extensive Administration experience in EMS - creating and managing destinations, bridges, routes, configuring various EMS design options and implementation of Load Balancing, Fault Tolerance.
●Proficient in DB design, stored procedures, triggers and function.
●Experience working in Agile and Waterfall Development project.
●Review and create Architectural documents, design documents, system documentation.
●Extensive Experience on version control systems like Git, SVN and Clear case.
●Experience in all the aspects of software development life cycle including requirements gathering, business analysis, technical design, development, Administration, on call Support and Offshore-onsite coordinator role.
●Experience in the design and development of Common Logging and Error Handling Framework (CLE), implemented SOAP over JMS/HTTP, RESTful Webservices.
●Experience in using Web development tools such as HTML, DHTML, XML, XSL, XSLT and XPATH
●Expertise in database design, Oracle 8i/9i,10g,11i,12c, SQL Server, MYSQL Server 7.0/6.5.
●Experience in Groovy Scripting and Java scripting languages
●Experienced in communicating with stakeholders to provide accurate and timely reporting and information regarding the ongoing projects and initiatives.
●Excellent Team Member with good Communication and Interpersonal skills and Exceptional ability to interact with customers and developers, communicating changes in requirements, resolving conflicts and ensuring project delivery on time.
●Exceptional ability to build relationships with colleagues, clients, and vendors across all functional and technical disciplines, providing focused project management, and accurate and detailed business and system analyses.
Technical Skills:
Integration Technologies
Dell Boomi AtomSphere, PL/SQL, TIBCO BusinessWorks 6.3, 5.13, TIBCO Designer 5.9, TIBCO Enterprise Message Service (EMS) 8.2
Technologies
XML, XSLT, Integration Design Pattern, XPATH, UML (Rational Rose, Visio), SOAP and RESTFUL Web Services.
Programming Languages
Java, Java scripting, Groovy Scripting
Databases
Oracle 8i/9i/10g,11i,12c, MYSQL, DB2, Microsoft SQL Server 2000/2005.
Source Control
Git, SVN, Visual SourceSafe and CSS, Serena.
Operating System
Red Hat Linux, NT, Windows 8/7/ XP / 2000, UNIX, DOS
Tools
MS Excel, Word, PowerPoint, Outlook,Filezilla,SOAP Ui,Postman,Anaplan, Salesforce, Qlik View, Cognos
SDLC Methodologies
Agile and Waterfall
Protocols
TCP/IP, UDP, FTP, HTTP, SMTP, SOAP (WSDL), REST
Professional Experience: Oct 2017 - Till Date
Moet Hennessy USA (MH USA)
New York City, NY
ETL Developer (Sr. Boomi Consultant)
Project NABCA Integration
NABCA project is designed and implemented to integrate competitive datasets into MH USA internal systems.
Responsibilities :
●Worked with Business Analytics and Business Intelligence team to meet the Business requirements and define best possible Integration processes.
●Collaborated with External vendors and Data providers to identify the user requirements.
●Gathering requirements and worked on documentation the implement architecture.
●Implemented a process to pick files from remote FTP server and load into Oracle database.
●Developed procedures using PL SQL and analyze the data to load into final target objects.
●Implemented reporting views to extract data from database and load into Qlik view reporting tool.
●Implemented data process, map, message, notify, try - catch,branch, Route, flow control shapes.
●Implemented processes to convert flat file to database profile.
●Implemented MAIL connector to send email every day on the status of the accumulated file.
●Maintained all the developed processes to deploy in Production Atom.
●Involved in system testing, performance testing and UAT
● Provided 24/7 tier 4 production support
SAP and Anaplan WAVE-3 Integration :
Wave-3 Integration is designed and Implemented to integrate SAP MH product Depletions and Distributor information to forecast in Anaplan tool.
Responsibilities:
●Worked with Finance and Brand Teams to define different integration interfaces.
●Implemented Functional and Technical requirement documentation and use case diagrams.
●Merging data from SAP and EPOS system to load into Database and remove duplicates.
●Implemented MAIL connector to provide alerts in case of duplicate data.
●Implemented processes to extract distributor and product data by using SAP BAPI and load into Anaplan.
●Create on demand processes whenever finance team request to run the Job.
●Implemented a Process that converts xml message into a CSV file.
●Implemented JSON pagination concept to load data into Database.
●Implemented Anaplan, SAP, Http Client, FTP and Database connectors.
●Migrated from Anaplan connector into Anaplan V2 connector in all the integrations.
●Implemented the processes to run in sequential load into Anaplan for the forecast.
●Worked closely with Environment support team to deploy processes into different Boomi environments
●Involved in System Testing, Performance testing and UAT
●Provided 24/7 tier 4 production support
Salesforce Integration:
(Account/Goal Surveys Trackings)
Accounts and Goal surveys is designed and implemented to integrate Store Information and Distributor goal targets information into Salesforce.
Responsibilities:
●Worked with Salesforce Team and Business Analytics Teams to define different integration interfaces.
●Collaborated with External Vendors and Distributor to meet the user requirements.
●Implemented Functional and Technical requirement documentation and use case diagrams.
●Implemented the data to load in different hierarchy level into Salesforces.
●Implemented the process to convert and Flat file to xml messages.
●Implemented the processes to run in sequential load into Salesforce for the forecast.
●Implemented branch, Route, set properties, Map,Try- Catch, Data process,Decision shapes.
●Implemented Salesforce, Http Client, FTP and Database connectors.
●Worked closely with Environment support team to deploy processes into different Boomi environments
●Involved in System Testing, Performance testing and UAT
●Provided 24/7 tier 4 production support.
Carlson Wagonlit Travel (CWT) Oct 2015– Sept 2017
St. Louis, MO
Sr. Boomi Consultant
Project Unused Ticket Integration
Unused Ticket Integration project is designed and implemented to integrate unused tickets into CWT
Client systems.
Responsibilities:
●Worked with Architect and Business Analyst to define different integration interfaces
●Published a soap web service to receive unused tickets from document bank system
●Implemented web services Soap client shape to retrieve traveler details from backend OSS system.
●Implemented JMS connector to send xml messages into AMQ
●Implemented a Process that converts xml message into a CSV file
●Implemented a Process that read data daily once to send accumulated CSV file to remote FTP server using FTP connector
●Implemented Try-Catch, dynamic document and process properties, Map, Set Properties, Shapes
●Implemented MAIL connector to send email every day on the status of the accumulated file.
●Worked closely with Environment support team to deploy gateway web service to different environments
●Involved in System Testing, Performance testing and UAT
●Provided 24/7 tier 4 production support
Project Booking Gateway
Booking Gateway project is designed and implemented to integrate traveler bookings to CWT OSS system.
Responsibilities:
●Involved in requirement gathering, analysis and design and participated in architectural design.
●Implemented Gateway web service using Dell Boomi Atomsphere to integrate traveler bookings.
●Implemented different connectors like Web Services Server connector, web services soap client, JMS, Mail, DB connector
●Configured API component to expose secure soap and restful web service to end clients.
●Implemented WSS4J encryption and signature using PHP certificates.
●Implemented Map shape to convert incoming booking to canonical data format.
●Implemented Business rules shape to configure Business mapping rules.
●Configured JMS connector to send messages to Internal AMQ server.
●Implemented custom scripting in Map shape.
●Created the deployment documents and created the necessary deployment deliverables.
●Worked closely with Environment support team to deploy gateway web service to different environments
●Involved in System Testing, Performance testing and UAT
●Provided 24/7 tier 4 production support
Project Profile Gateway
Profile Gateway project is designed and implemented to integrate profiles between CWT and Client Profile Systems. Gateway supports both Inbound and Outbound profile synchronization.
Responsibilities:
●Worked closely with Dell Boomi Solution Architects and CWT Internal Solution Architect to define the architecture of Profile Gateway
●Implemented Gateway real time inbound integration soap and restful webservices to integrate client profiles into CWT Portrait system.
●Implemented Gateway real time Outbound Integration soap and restful webservices to integrate full client profiles into Client systems
●Used Postman and SOAPUI to test implemented gateway Restful and Soap Web Service.
●Implemented Business rule mappings to route client profiles to different EMS queues based on incoming http header.
●Implemented API component, Webservice Server and Client connectors, HTTP client connector, JMS, Database, Mail and Disk connectors
●Created the deployment documents and created the necessary deployment deliverables.
●Worked closely with Environment support team to deploy gateway web service to different environments
●Involved in System Testing, Performance testing and UAT
●Provided 24/7 tier-4 production support
Wells Fargo Nov 2013 – Sept 2015
San Francisco CA
Sr. Boomi Developer
Project Salesforce Account/Contact Integration
Project Account and Contact Integration project is designed and implemented to integrate salesforce accounts into local operational support system
Responsibilities:
●Project involves of transferring data between Salesforce to Database and Database to Salesforce.
●Involved in requirement gathering, analysis and design and participated in architectural design.
●Collaborated with internal customers, other functional teams, development teams, and other stakeholders to identify user requirements
●Design, development, testing, implementation, and deployment for new integrations using Boomi and Troubleshooting to fix defects.
●Determine information gaps and deficiencies, as-well as evolving information needs.
●Proposing and executing enhancements to the existing integrations.
●Involved in increasing Performance of the existing processes
●Used Boomi connectors as Salesforce connections, Database Connections, Mail Connections and
Web Services SOAP Client Connection.
●Involved in deploying the processes, triggering and monitoring the execution
●Involved in unit testing and integration testing
●Co-ordination with the upstream and downstream applications and direct interaction with the client team.
●Developed process documents and quick reference manuals for the end users.
●Was involved in end to end implementation, issue management, communication and change management.
●Managing coordination of critical due dates for integrated system testing, documentation and reporting.
●Go-live, migration and post production deployment support.
Project Mortgage Data Integrity
Sr.Tibco Developer
Mortgage Data Integrity project is designed and implemented to integrate reverse mortgage data from Mortgage application to local reverse mortgage portal database.
Responsibilities
● Developed standards and created use cases
●Developed and maintained a centralized Process Control Engine with Java and TIBCO Suite for managing the life cycle of a loan for reverse mortgage.
●Developed process and component based applications for the data integrity and transformation using Business Works.
●Implemented TIBCO BusinessWorks processes to convert the reverse mortgage formatted response to canonical formatted response XML transactions for Wells Fargo mortgage.
●Developed BW processes to receive messages from JMS Queues, transforms data and store the information in database.
●Created XML schemas (XSDs) for XML transactions
●Worked on the test scenarios to cover each branch of the developed processes.
●Developed test scripts and involved in various levels of testing including Unit testing, Integration testing in UNIX Environments.
●Installed, configured and maintained TIBCO products/applications on UNIX.
Environment: TIBCO ActiveMatrix BusinessWorks 5.x, TRA 5.x, SOAP, XML, XSD, XSLT, XPATH, PL/SQL, TIBCO Administrator 5.x, SoapUI, Altova XMLSpy, Clearcase
Reliance Communication Dec 2010 – Sept 2013
Tibco Developer
Project Order Entry workflow integration is designed and implemented to integrate Siebel and Clarify Order entry systems into Savion BPMS workflow system.
Responsibilities
●Designed and implemented various Sequence Diagrams specifies how the integration workflows
●operate and the data to be passed through Request/Reply and Pub/Sub operations
●Created various documentation including troubleshooting, migration, best practices etc.
●Implemented schemas as common objects to represent Siebel, Clarify and Workflow data objects.
●Extensively implemented SOAP palettes and Services palette to develop various interfaces to support
●SOAP advanced features provided by TIBCO
●Extensively implemented JMS palette activities to integrate Siebel workflow into EAI architecture
●Implemented JMS correlation Id feature to design request reply integration pattern between Siebel and Tibco
●Created Queues, Topics and Bridges on EMS server for Siebel related communication.
●Involved in configuring Siebel EMS in a Load Balancer and Fault Tolerance configuration mode.
●Created test cases and Implemented them to test different integration workflows.
●Involved in System, UAT and Production testing support
●Worked as a tier-4 production support and timely resolved the issues
Environment: TIBCO BusinessWorks 5.x, TRA 5.x, TIBCO EMS 5.x, SOAP, XML, XSD, XSLT, XPATH, PL/SQL, TIBCO Administrator 5.x, TIBCO Hawk 5.1, SoapUI, Gems, Altova XMLSpy, Clearcase
Project Workflow Inventory Integration project is designed and implemented to integrate Savion workflow system into Granite Inventory system.
Responsibilities
●Designed and implemented various integration workflows between Savion and Granite systems.
●Implemented Request Reply pattern SOAP webservice to send Inventory request from BPMS to Granite
●Implemented Pub-Sub pattern soap webservice to consume Inventory notification and Integrated the notification to BPMS workflow
●Extensively used SOAP, JMS, HTTP, General activities, General palette activities to implement soap web services
●Extensively used Mapper activity to convert BPMS data object into Inventory data object.
●Created various documentation including troubleshooting, migration, best practices etc.
●Created Queues, Topics and Bridges on EMS server to integrate Inventory notification to Different system like Workflow, Siebel and Finance Systems.
●Created test cases and Implemented them to test different integration workflows.
●Involved in System, UAT and Production testing support
●Worked as a tier-4 production support and timely resolved the issues
Environment: TIBCO BusinessWorks 5.x, TRA 5.x, TIBCO EMS 5.x, SOAP, XML, XSD, XSLT, XPATH, PL/SQL, TIBCO Administrator 5.x, TIBCO Hawk 5.1, SoapUI, Gems, Altova XMLSpy, Clearcase
Contact this candidate