
Sandip Khanna
- Solution Architect / SOA Architect
- Pittsburgh, PA
- Member Since Mar 25, 2023
Sandip Khanna
SUMMARY OF QUALIFICATIONS
● Hands-on Solution Architect/SOA Architect/Software Consultant with NINETEEN years of experience in Information Technology in areas of Software Architecture, Design, Development, Evaluating new technologies, Establishing best practices and standards, Mentoring, Mgmt. guidance on software development effort, applications integration and Project Management. Focus on Health Care, Financial and Telecom
● Extensive experience in architecting, designing and developing solutions and applications and leading teams (up to team size of 15), expertise in pre-sales (Customer engagement and proposal/solution preparation) and project delivery (as Solution/Technical Architect)
● Experience in architecting and developing SOA solutions on Oracle Fusion middleware on 12c,11g and 10g for clients like Astra Zeneca (MedImmune), FINRA, Verizon Business, Novartis and WMATA on Oracle BPM, Oracle Service Bus, Oracle SOA Suite (BPEL), Oracle Data Service Integrator, OSR using SOAP and REST
● Expert in architecting, designing, and developing JEE solutions (Cloud, on-premises and hybrid)
● Experienced in infrastructure sizing, setup and validation in Cloud and non-Cloud environments
● Well versed in architectural processes such as TOGAF and Open Group.
● Proficient in Design Patterns and their usage to deliver Best-of-Class Solutions
● Expert in Java and JEE Technologies
● Expert in Oracle Fusion middleware stack such as SOA Suite, OSB, BPM, WebLogic Application Server, Oracle Service Bus, Oracle Data Services Integrator, API manager, Oracle Healthcare, Oracle B2B - conversant with similar open source products
● Extensive expertise in performance tuning of Oracle Fusion stack including OSB, SOA Suite, ODSI and JEE applications including tuning of JVM, database and application code
● Extensive experience in integrating systems using Java Messaging
● Extensive experience doing designing and developing high availability, high volume systems.
● Proficient in NoSQL databases like AWS Dynamo DB, Google Firebase, Apache Cassandra
● Experienced in BPM products such as Oracle BPM, JBPM 5 and Activiti
● Experienced in Portal products such as Oracle Weblogic Portal, LifeRay, Sun One Portal
● Experienced in setting up the SOA platform and processes to enable agile development for future projects
● Extensive experience in DevOps
● Extensive experience on SOAP and REST Web Services.
● Extensive experience in leading teams to ensure final delivery of the solution (from pre-sales to final delivery)
● Extensive Experience with in CI/CD using SCRUM as the methodology
● Enrolled in Alpha-testing of Google Cloud function, evaluating use with Google Firebase
● Certified Scrum Master
● Well versed in Agile architectures such as Micro services
● Well versed in use of containers in CI/CD and Serverless Architectures
● Extensive experience in UML, JMS, JEE, WebLogic, Spring, Hibernate, XML, XSLT, Jason, Servlets, JSP, Ant, AJAX, JUnit, Erwin, PL/SQL developer, SQL, Oracle 9i, DB2, WIN CVS, log4j
TECHNICAL SKILLS
Applications: Oracle Fusion Middleware (including OSB, SOA Suite, ODSI, Oracle Traffic Director), JBPM, Activiti, Oracle Weblogic 12c/11g application server, Web logic Portal, Apache Tomcat, Spring, AngularJS, Axis, Ant, JUnit, Java Server Faces, JSTL, Hibernate, Log4J, Jersey.
AWSTechnologies: EC2, IAM, S3, Dynamo DB, Lambda, API Gateway, SQS
Google Cloud Technologies: Firebase
Mobile: Android Platform
Languages: Java, Python, Groovy, SQL, HTML, Java Script, C++.
Big Data: Apache Spark, Hadoop ecosystem technologies
Technologies: JEE (JAXB, JPA, JSF, EJB, JMS, JDBC, Servlets, JSP), Web Services, XML, UML, Servlet, JDBC, Swing.
ORM: Eclipse Link, TopLink, Hibernate
Containers: Docker, AWS ECS
Message Brokers: Apache Kafka, Active MQ
Database: Oracle 12c,11g, Amazon Dynamo DB, Google Firebase, Apache Cassandra.
Caching Solutions: Oracle Coherence
UI Frameworks: Angular JS, GWT, JSF
CI/CD: Jenkins, Hudson
Version Control: GitHub, Subversion
Operating Systems: Linux, Sun Solaris, NT.
Design Methodologies: Scrum, RUP.
JDK: 1.8,1.7, 1.6, 1.5.x, 1.4.x, 1.3.x.
IDEs: Eclipse, Oracle JDeveloper/Workshops, IntelliJ.
Industry Standards: CDISC, HL7
PROFESSIONAL EXPERIENCE
Duquesne Light Company, Pittsburg August, 2017 – Present
Architect
Duquesne Light Company, an electricity provider based out of Pittsburg, Pennsylvania is implementing IBM Maximo as their asset management system. The implementation requires integration of the existing Oracle Customer Care and Billing (CC&B) system with the IBM Maximo system that is being implemented. Oracle SOA Suite (version 11g) is being used to integrate the Oracle CC&B (version 2.3.1) with IBM Maximo. The Oracle SOA Suite uses the Oracle AIA Field Work Process Integration Pack and customizations need to be done to the Field Work PIP to enable the new integration. The CCB-MAXIMO integration project is being executed to enable this integration.
Responsibilities
· Design and develop architecture in Oracle SOA/OSB/BPM/BPEL platform based applications
· Design and implement applications on SOA platform at enterprise level
· Develop technical standard and provide resolution of system issues
· Design, develop and deploy business process integration using Oracle SOA Suite, Fusion Middleware
· Work with Oracle SOA Suite technology adapter for integration solution between enterprise applications: Database, JMS, B2B, FTP, File, Web Service, BAM and Oracle application & Web Services, SOAP, WSDL, XML, XSLT, XPATH, HTML and UDDI
· Evaluate and recommend new or enhanced technologies that can improve current system
Environment: RedHat Enterprise Linux, BEA WebLogic Server 10.x, Oracle SOA Suite 11g, Oracle Service Bus 11g, Oracle AIA Field Work PIP for Utilities, JMS, WebServices (SOAP and REST), XML, XSD, JPA(TopLink), AngularJS, Oracle 11g, SOAP UI, Erwin, PL/SQL developer, SQL, SVN, JDeveloper
WMATA, Washington DC October,16 – August, 17
Sr. SOA Tech Lead
SOA Integrations
The integration platform is WMATA's high availability integration solution platform for integration of enterprise applications. The platform is designed to meet varied requirements across the enterprise and as such involves multiple components as part of the integration stack in it architecture.
Responsibilities:
● Facilitate the definition of integrative and canonical views of data or information across multiple content types (structured, semi-structured, XML or unstructured) to support convergence of information asset migration planning or impact analysis.
● Design the architecture of Information Systems in accordance with the WMATA’s strategy and agreed solutions and practices
● Participate in the IS Strategic Plan and associated architecture process
● Carry out studies that allow appropriate choices for transversal solutions
● Develop guidance for securely integrating new systems into the company’s IS landscape
● Assess the impact of new solutions on existing or planned architectures
● Managing risks related to IT and information assets
● Lead or participate in strategic studies
● Participate in defining the approach for the evolution and integration of the different business and technological components of Enterprise Information Systems.
● Develop Proof-of-concepts related to new technologies as required in architecting and designing solutions
● Design and Develop highly available systems using the Oracle Fusion Middleware stack
● Conduct code reviews
Environment: RedHat Enterprise Linux, BEA WebLogic Server 12c, Oracle SOA Suite 12c, Oracle Service Bus 12c, Oracle Managed File Transfer 12c, Oracle API Manager, Oracle SOA Suite for Health Care, JMS, WebServices (SOAP and REST), XML, XSD, JPA(TopLink), AngularJS, Oracle 11g, SOAP UI, Erwin, PL/SQL developer, SQL, SVN, JDeveloper
MedImmune, MD Aug 12 - Sep 16
Solution Architect/SOA Architect
Astrazeneca/MedImmune Integrations
The eClinical HUB is MedImmune integration solution platform for clinical trials. The platform enables integration of various systems involved in clinical trials and caters to different integration requirements within the overall clinical trial process. The platform consists of a number of integration solutions with each leveraging a set of common reusable services while maintain flexibility to solve the business problem at hand.
Responsibilities:
● As the solution architect, did the Proof-Of-Concept to establish the technical feasibility for the business requirements enabling business to finalize the solution to their problems
● Provide solution architecture and detailed design for various integrations solutions
● As the solution architect, ensured that the solution catered to the non-functional requirements such as performance, availability etc.
● Utilized the Oracle SOA Suite (BPEL), OSB and client Web services to implement the data transfer processes while ensuring maximum reusability to enhance speed of delivery and consistency of the solution
● Ensured that the solution leveraged the existing enterprise products to the maximum, adhered to enterprise direction with regard to their product roadmap while at the same time delivered the best of breed functionality and performance
● Designed and implemented the solution working in close cooperation with the Business and other technical stake holders, hand holding them and providing solutions to their issues as required
● Set up the design to be used for future claims based systems leveraging the MedImmune Ping Federate Identity Provider
● Researched the feasibility of LifeRay as the portal server AngularJS for providing a unified view of Clinical configuration, Clinical Error UI and SOA Audit UI, using AngularJS as the JavaScript framework and AWS based REST services as the service layer
● Did extensive PoC around use of the AWS as alternate platform, which included creating and managing EC2 instance using AWS S3, designing and implementing rest services with AWS API and AWS Dynamo DB to manage Study data from different systems
● The final expert for any production issues that may arise in the solution
Environment: RedHat Enterprise Linux, BEA WebLogic Server 11g/12c, Oracle Data Services Integrator 10.x, Oracle SOA Suite 11g/12c, Oracle Service Bus 11g, JMS, WebServices (SOAP and REST), XML, JPA(TopLink), EJB3, StAX, Oracle 11g, SOAP UI, Erwin, PL/SQL developer, SQL, SVN, Rational System Architect, JDeveloper
MedImmune OneCTT/ eClinical Hub:
MedImmune had been working on its own Clinical Trial Transparency solution. The MedImmune solution automates the registration and publishing of all MedImmune and AZ sponsored clinical trial information to the public Website clinicaltrials.gov. The One CTT (Phase 2) project enhanced the solution by making architectural changes in the integration segment of the solution while ensuring that it met AZ requirements as well. It will also ensure that the solution is able to meet disclosure requirements for public Websites beyond just ClinicalTrials.gov (viz. EudraCT).
Responsibilities:
● As solution architect was responsible for enhancing the solution and ensuring that it met the existing and new requirements
● Evaluated options for Single Sign-On for AZ/MedImmune users and for external CROs in collaboration with the Enterprise Architecture team
● Changed the architecture of the existing integration solution to align it with industry best practices
● Introduced the Oracle SOA Suite (BPEL) to implement processes that had earlier been implemented into OSB
● Designed and implemented the first process that was migrated under the OneCTT project onto the BPEL environment
● Designed and implemented the migration of the existing SAS to PharmaCM study results transfer to make it more scalable and robust.
● Designed the schemas to be used for the OneCTT project and aligned them with AZ standards
● Realigned the OneCTT project integration architecture to the MedImmune SOA platform architecture
● Guided the testing team to implement automated regression testing for existing processes thus enabling faster development and regression testing
Environment: RedHat Enterprise Linux, BEA WebLogic Server 11g/12c, Oracle Data Services Integrator 10.x, Oracle SOA Suite 11g/12c, Oracle Service Bus 11g, JMS, WebServices (SOAP and REST), XML, JPA(TopLink), EJB3, StAX, Oracle 11g, SOAP UI, Erwin, PL/SQL developer, SQL, SVN, Rational System Architect, JDeveloper
MedImmune SOA Platform:
The MedImmune SOA project is an initiative to implement an enterprise SOA platform at MedImmune. The objective is to bring together various efforts within MedImmune to form a coherent SOA strategy, that aligns the MedImmune SOA efforts with the ones being undertaken by AstraZeneca and generally collaborate on how to implement SOA principles to achieve agility and reusability.
Responsibilities:
● Architected a new solution as per industry best practices
● Collaborated with the MedImmune integration architect to ensure that the SOA architecture tied in with the larger integration architecture strategy
● Ensured that existing projects were able to leverage the new solution while providing a path to full portability to new the architecture as required in the future
● Participate in discussions with new SOA clients to enable on-boarding
● Onboarded existing clients from old to the new platform
● Worked collaboratively with the business analyst and client team to design service contracts based on client discussions
● Implement the first release of the solution as per the new architecture using industry best practices
● Prepare the High Level Designs for Proxies and Transformations
● Designed and develop the Audit service
● Designed and develop the error handler to be used as a common component
● Designed the Email Service
● Guided the test team in the test approach, automation technology selection and developing the testing framework that could be applied to the new solution
● Define and establish practices to be used by future project teams
● Install and administer the new environment, on Oracle 11g, till final handover to the MedImmune COE team
● Developed the administration framework to ensure proper maintenance of the platform
● Developed the on-boarding questionnaire as part of establishing the governance process for the MedImmune SOA platform
● Developed the roadmap for configuration management process to bring about agility to the SOA projects
● Performance tuned the platform to ensure maximum utilization of existing resources
Environment: RedHat Enterprise Linux, BEA WebLogic Server 11g/12c, Oracle Data Services Integrator 10.x, Oracle SOA Suite 11g/12c, Oracle Service Bus 11g, JMS, WebServices (SOAP and REST), XML, JPA(TopLink), EJB3, StAX, Oracle 11g, SOAP UI, Erwin, PL/SQL developer, SQL, SVN, Rational System Architect, JDeveloper
FINRA, MD Dec 08 - Aug 12
Oracle Service Bus/BPM Solution Lead
Enterprise Service Bus:
The NYSE and NASDAQ merger for Regulatory Affairs required rapid assimilation of a diverse set of applications into the FINRA infrastructure. It was decided to implement an enterprise integration platform based on an Enterprise Services Bus towards this objective. The aim was to provide a reference implementation to guide FINRA applications integrate with the ESB. Define and institute an ESB Governance Model for management of the ESB adoption by applications and the ESB operations.
Responsibilities:
● Re-architect the existing solution to rectify performance issues.
● Architect and design a proof-of-concept based on the suggested architecture to migrate the existing transformation engine to a full-fledged BPM solution (on JBPM 5).
● Participate in on boarding discussions with new Service Bus clients to understand their requirements
● Work collaboratively with the business analyst and client teams to design service contracts based on client discussions
● Design the OSB components based on the overall architecture
● Prepare the High Level Designs for Proxies and Transformations
● Design the Email Service
● Design and develop the monitoring module to enable operational monitoring of the application
● Design and develop the data model for storing the last n-days messages functionality
● Design and Develop the BPM services for the Rule 134 module
● Design and develop the module to invoke Web Services using JMS messages
● Design and develop the generic proxy to accept messages over HTTP transport using Web services and transform the same into JMS messages for further processing within the ESB
● Develop the consume proxy to send JMS messages to clients as emails using SMTP transport
● Design and develop the ESB dashboard using the Google Web Toolkit
Environment: RedHat Enterprise Linux, Oracle Service Bus 11g, BEA WebLogic Server 11g, JBPM 5, Spring 3.x, Google Web Toolkit 2.x , JMS, WebServices (SOAP and REST), JPA(EclipseLink), StAX, XML, Active MQ, JUnit, Erwin, PL/SQL developer, SQL, Oracle 10g, Star Team, log4j.
Verizon Wireless, CO Dec 07 - Nov 08
BPM/Web Services/Portal Expert
Circuit Pricing Tool:
This project is part of a larger project called the Single Stack Initiative. The architecture of the project is Service Oriented Architecture involving 11 systems. The scope of the Circuit Pricing Tool is to provide the users with a mechanism to change pricing arrangements at the service level for individual components, circuits or access. The CPT will provide a means to place a service on hold, prior to billing, in order to override the charge for that particular component so that it matches the customer's contractual agreement with Verizon. Once the component is overridden, it can be released from hold and billed.
Responsibilities:
● Making architectural design decisions based on business requirements and technological capabilities
● Design of the screen specifications
● Design and development of Web Services using the Aqualogic Data Services product
● Design and Development of WebLogic portal portlets
● Design and development of the BPM process and bringing it to standard using best practices
● Proposing and implementing modifications to the existing process
● Configuring and administering the BPM server, deploying processes on the server, generation of the portal ears.
● Configuring and administering the user administration database for the CPT
● Doing technology investigations and proposing new technologies/frameworks to enhance the architecture, leading the team to implement them
● Troubleshooting critical areas of the existing application based on varied client requirements
Environment: Sun Solaris 5.1, BEA WebLogic Server 9.2.2, BEA Portal Server 9.2.2, BEA AquaLogic BPM 5.7, BEA AquaLogic Data Services Platform 2.5, AquaLogic Service Bus 2.65, Servlets, JSP, Ant, AJAX, JUnit, Erwin, PL/SQL developer, SQL, Oracle 9i, DB2, WIN CVS, log4j.
Novartis, East Hanover, NJ Jan 07 - Aug 07
Technical Architect / Lead
Service Order Request Automation System:
The Service Order Request Automation System is the first Business Process Management solution rolled out by the client. This was a strategic rollout for the client meant to highlight the value proposition of BPM based solutions and act as a sales driver for the BPM service offering. It was also meant to lay the groundwork for offering BPM solutions as a service offering to different business units in the client’s organization.
Responsibilities:
● BPM consultant for the client (Onsite & Offshore). Identification of appropriate process for strategic rollout and completing the pre-sales phase (Onsite).
● Proposing the solution architecture for the application (Onsite).
● Leading and managing the setting up of the client’s deployment environment (Onsite).
<p class="MsoNormal