Tegration Consultant Resume
IN
SUMMARY:
- Architecture and Design: Experienced in SOA, object - oriented design and programming, architectural patterns and component infrastructure.
- Leadership: Hands-on team leader, mentor and coach with a record of success in making projects work using the skills of existing staff.
- Subject Matter Expert: Expertise working on Service Oriented, Business Process Management using technologies such as ESB, BizTalk Server 2004/2006/2010/2013/2016 , Windows Workflow Foundation (WF), Windows Communication Foundation (WCF) and REST API.
- Expertise working on Business Intelligence solutions and Data warehouse ETL solutions using SQL Server 2014 Integration, DQS, R Services, SQL Server Azure, MS excel and Power BI.
- Expertise working on portal and Document management solutions using SharePoint Server 2010 / 2013, SharePoint Online / Office 365 and C#
- Extensive knowledge about HIPPA, Salesforce and SAP.
PROFESSIONAL EXPERIENCE:
Confidential, IN
Integration Consultant
Responsibilities:
- Designed and developed custom authentication manager / behavior which will be leveraged to consume LOB REST API (e.g. Salesforce, Veeva) using OAuth 1.0 / 2.0 and other authentication protocol.
- Provided BizTalk 2016 POC to communicate with Salesforce directly and avoiding using Roche API gateway.
- Worked on Sample Harmonization interface which processes and reports Sample request using Salesforce REST API, SAP PI, SharePoint and BizTalk Server 2010.
- Worked on Veeva (Cloud based Content Management System) integration using SharePoint, SAPPI, Azure Service Bus and BizTalk Serve 2016. Implementation of BAM and ESB 2.4 to implement dashboard for managing exceptions and business intelligence reports.
- Provided concept on leveraging Power BI / Tableau, BAM and ESB to implement dashboard.
- Provided support to existing EDI and other BizTalk Server 2010 applications.
Confidential, CA
Integration Architect
Responsibilities:
- Involved in multiple discovery sessions to gather the requirement and understanding impact on existing BizTalk interfaces.
- Worked with Salesforce Technology Architect and business Analysts to provide Salesforce Transformation - Account Hierarchy prototype.
- Provided Integration design document for implementing BizTalk interfaces to integrate Salesforce with SAP. The Integration interfaces include Account SYNC, Contacts SYNC and Sales Order Process. The integration design document include scope, design patterns used, detail steps with sequence diagrams.
Confidential, NY and FL
BizTalk Architect / EDI Messaging Specialist
Responsibilities:
- Worked on multiple initiatives, which involved collaborative efforts between NUCO2 parties and NUCO2 for implementing EDI solutions using EDI 810 , EDI 820, EDI 823 , EDI 864 and EDI 997 and BizTalk 2010.
- Worked on upgrading BizTalk Server 2010 to BizTalk Server 2013 .
- Worked on installation and configuration BizTalk 360 Admin tool
- Worked on providing BizTalk admin tools to manage receive locations and suspended messages.
- Worked on the implementation of Ortec solutions integrating with JDE and PAL devices using Web API and BizTalk Server 2013.
- Implemented BizTalk Tactical Approach by custom BizTalk Archive and tracking SQL server job .
- Implemented integration solution using Biztalk to send encrypted data to the partner via SFTP adapter.
- Designed BizTalk Enterprise architecture for implementing High Availability, Security and performance.
Confidential
BI Developer / Office365 SharePoint Online Consultant
Responsibilities:
- Worked on creating SSIS 2014 packages and DQS projects for Confidential .
- Architecture, Design Review, application and database development for Confidential Using Visio, SharePoint Online and SQL 2014 Azure.
- Migration of SQL data from SQL on premises to SQL Azure and vice versa
- Performance Tuning using SQL Server 2014 Partition Switching, Indexing and Buffer Pool Extensions.
- Implementation of Database mirroring on SQL Azure and Microsoft Azure VM.
- Architecture, Design review and suggested best practices to Confidential, NY.
- Upgraded from Moss 2007 to SharePoint Server 2013 for Confidential. Completed Document Management system using Manage Metadata, SQL Server 2012 and SharePoint Server 2013.
- Implemented Real Estate management system for RAM Real Estate using SharePoint Online. Worked on migrating databases to SQL Azure VM.
- Implemented POC on Power Analysis solutions for Infinix Ad Agency using Google Analytics API, Power BI , MariaDB and PHP. Introduction of MS dynamics CRM to the Ad Agency and development Dashboard on CRM portal
- POC for Stellar Materials on SharePoint Server 2013 Document Management System and leveraging custom app Parts. Implemented Excel Dashboard using SharePoint, VBA and MS excel
- Researching on workflow Manager Integration services on cloud with BizTalk Services 2013 to overcome BizTalk Server 2013 orchestration on cloud limitation.
- Implemented POC on Power Analysis solutions for Infinix Ad Agency using Google Analytics API, Power BI, MariaDB and PHP. Introduction of MS dynamics CRM to the Ad Agency and development Dashboard on CRM portal
Confidential, NJ
Integration Specialist
Responsibilities:
- Performed role as BizTalk Architect and provided BizTalk Server 2010 / 2013 standards including Design Patterns, Development Standards, Build Guidelines, QA guidelines and Installation guidelines for Confidential .
- Worked on installing BizTalk Server 2010 / ESB 2.1 and upgrading to BizTalk Server 2013 and ESB 2.2 .
- Worked on monitoring BizTalk Server environment and implemented the approach to resume suspended messages.
- Initiated the implementation of SCOM in Confidential environment using Microsoft SCOM and BizTalk Server Management Pack .
- Provided BizTalk Server and ESB Technology Architecture and technical design for IPSR- CES integration to technology group.
- Focused on initiating BizTalk/SOA patterns including Metadata Centralization pattern, Central Communication Pattern, Asynchronous Communication Pattern, Splitter and Aggregator pattern, Routing Slip Pattern, and Pub-Sub Pattern to present Enterprise integration architecture.
- Implemented BizTalk/SOA patterns including Asynchronous Communication Pattern, Splitter and Aggregator pattern, Routing Slip Pattern, and Pub-Sub Pattern.
- Worked on building IPSR- CES integration using BizTalk Server 2010 / 2013, BRE , ESB 2.1 and SharePoint Server 2010. Created Rule Management WCF services and implemented region based business rules policies.
- Initiated the implementation of SharePoint based WCF services and LINQ to SharePoint to perform CRUD operation on single and multiple lists.
- Worked on creating stored procedures SQL Server 2012 to process XML data and implementation of SQL classes using Entity framework 4.5.
- Provided Confidential Business Rules framework training to Business Users.
Confidential, TN
Integration Specialist
Responsibilities:
- Provided proof of Concept on SalesForce BizTalk integration using BizTalk Server 2010, ESB 2.1 and WCF services.
- Worked on JavaCaps to BizTalk migration projects using BizTalk Server 2010, ESB 2.1 and SSIS services.
- Designing SQL server service event broker using ESB 2.1, BizTalk Server 2010 and SQL query notification pattern.
- Focused on implementing BizTalk/SOA patterns including Central Repository pattern, Population Pattern, Asynchronous Communication Pattern, Query Notification pattern to present integration architecture
Confidential, FL
.Net Consultant
Responsibilities:
- Worked on BizTalk Server 2006 to BizTalk Server 2009 initiative.
- Implemented PayPlan BizTalk application which integrates existing Raynods CSV formatted data provider System and new PayPlan System.
- Introduced Service Facade and decoupled contract pattern to implement layer of abstract and to accommodate changes in service contract.
- Worked on designing BizTalk Business Rank rule core policies which has been accessed by Rank WCF Service instead of BizTalk Orchestration.
- Worked on designing and developing PayPlan claim aware WCF services using Entity Framework 4.0 , SQL Server 2005 , Active Directory Federation Service 2.0 and Windows Identity Framework.
- Worked on database Design, creation of stored procedures and SQL server classes using Entity Framework 4.0.
- Introduced claim aware authentication mechanism for PayPlan application using ADFS 2.0, WIF and using service security pattern.
Confidential, FL
Senior SharePoint Developer
Responsibilities:
- Worked on implementing Change Management System using SharePoint Server 2010 and InfoPath.
- Developed SharePoint Approval/Process Workflow for Change Management System.
- Initiated and implemented new SharePoint Server 2010 architectural design which is primarily focusing on adding functionalities through new service applications, introducing business intelligence, Microsoft dynamics integration, reporting and collaboration.
- Configuration and implementation of SQL Server Reporting services integration with SharePoint Server 2010.
Confidential, FL
BizTalk Integration Architect / Lead Developer
Responsibilities:
- Assembled a team for the projects.
- Served as the primary interface between Developers, IT Business Analyst and Business Partners, worked closely with business owners and software developers (local and remote) to understand and develop requirements, priorities, and processes for required solutions.
- Lead design reviews and driven feedback on architecture and design issues including system integration, performance, and scalability.
- Implemented service refactoring, service messaging patterns and central repository patterns for proof of concept of Confidential Service Bus using BizTalk ESB 2.1, appfabric and UDDI.
- Provided proof of Concept on Common Rule Framework using BizTalk Server 2010, Business Rule Engine (BRE) ESB 2,0 BRE resolver and WCF Services. The framework has been leveraged by BizTalk and .NET application.
- Implementation of Long Term Facts using custom fact retriever in Business Rule Engine.
- Provided scale up approach and BizTalk Messagebox scale-out approach to existing BizTalk 2006 R2 environment.
- Managed BizTalk 2006 R2 applications and worked closely with Business owners, developers (local / remote) to understand and develop requirements, priorities, and processes for required solutions.
- Worked on designing and developing KVE-CampusVue Integration, KU-GoArmyEd Integration and KU-Azure Integration.
- Worked on reviewing, supporting and providing guidance on eCollege-KCE /KHEC -CampusVue Integration, CELCAT-CampusVue Integration,
Environment: BizTalk Server 2010, ESB 2.1, BizTalk Server 2006 R2, Business Rule Engine, C#, WCF, Workflow Foundation 3.5/4.0, UDDI 3.0, SQL Server 2008 R2 /2005, IIS 6 /7.
Confidential
Responsibilities:
- Worked on service application architectural design for implementing SharePoint Server 2010.
- Worked on code review and provided best practices guide for Confidential .
- Guided SharePoint developers and Production support team to resolve the issues in lower environment and production environment.
Environment: WSS 3.0, MOSS 2007 / SharePoint Server 2010, Windows Communication Framework, Workflow Foundation 3.5/ 4.0, App Fabric, Windows Server 2008 R2, SQL Server 2005 / 2008 R2, Analysis Services, IIS 7
Confidential, FL
BizTalk Integration Specialist
Responsibilities:
- Worked for Enterprise Services and Architecture team and performed the role as an Architect.
- Worked on BizTalk 2006 R2 and SQL Server 2005 physical architecture.
- Worked on installing BizTalk 2006 R2 and supporting components in development and QA environment.
- Provided proof of concept for integrating BizTalk 2006 with LOB Siebel and SAP by implementing service oriented architecture (PUB SUB Model).
- Reviewed architecture technical design and provided proof of concept to implement WCF, SSO as cluster resource and MSMQ.
- Designed Business Rule policies related to BizTalk SalesForce Integration.
- Worked on performance analysis on BizTalk Application Server 2006 R2 as well as SQL Server 2005.
- Worked on writing Admin WMI and SQL script for monitoring and maintaining all the environments.
- Worked on implementing BizTalk 2006 Purge SQL Server job, Backup job and SQL Server alerts.
- Provided the BizTalk 2006 guidelines to BizTalk development and SQL Server development team.
- Provided assistance to development and production team for technical as well as admin issue.
- Worked on implementing BizTalk 2006 Best Practices Analyzer and BizTalk Security Analyzer.
Environment: BizTalk Server 2006 R2, BizTalk Server 2004, SAP, C#, SQL Server 2005, IIS 6.
Confidential, FL
MOSS Consultant
Responsibilities:
- Installation and Configuration of MOSS 2007 on medium Server Farm.
- Provided proof of Concept on organizing scattered documents using SharePoint 2007 document workflow, features and BDC Catalog feature.
- Presentation of Dashboard using SQL Server Analysis Services, SQL Server 2005 Reporting Services WebPart, KPI WebPart and Excel 2007.
- Provided documentation on implementing custom workflow using SharePoint Designer 2007.
- Worked on building Custom Search WebPart using Enterprise SQL Query model and BDC Catalog.
- Worked on download controller module using Custom HTTP Handler, Custom Download HTTP module and Information Right Management which limits the user to download maximum number of documents every day and applies right management policy to document.
- Worked on Document Content Search Highligher WebPart
Environment: MS SharePoint (MOSS) 2007, WSS 3.0, SQL Server 2005 Reporting & Analysis Services 2005, Excel 2007, IIS 6.
Confidential, Fort Lauderdale, FL
BizTalk Messaging Specialist
Responsibilities:
- Worked on WMI scripts as well as SQL server jobs for BizTalk administrators
- Reviewed the design and development of Sales Contract BizTalk project.
- Articulated BizTalk Server performance guidelines to achieve better performance and scalability.
- Implementing Business activity monitoring solution for Customer Interface and purchase order project by integrating with Reporting Services 2005 and SharePoint Portal.
- Working on High availability / Fault tolerance architecture by clustering SQLServer, MSDTC and Master secret Server.
Environment: BizTalk Server 2004, SharePoint 2003, SAP, EDI accelerator, C#, SQL Server 2005 Reporting Services 2005, IIS 6.
Confidential, Fort Lauderdale, FL
Architect / Lead Developer
Responsibilities:
- CAPPS allows payroll for employees and distribute funds in the form of debit instrument, such as an ATM Card. Funds are automatically posted to the employee’s account when processed and debit instruments are replenished upon next use of the card.
- Closely worked with Project Manager and Development Managers to build the Project Proposals and Project Plans. Ensuring that the Project Deadlines are met by setting up Development Milestones for Work Measurement.
- Detail Requirement study for creation of High Level Design and Effort Estimation.
- Suggested general approach to gather requirements for multiple trading partners.
- Provided system documentation including use case diagram.
- Performed Design Review, Code review and Unit test plan.
- Implemented Human workflow using sharePoint 2003 and InfoPath form which delivers functionality to approve or reject operation and provides enhancement to Cash Management Services.
- Articulated, designed and developed orchestrations for operations occurred during different time window.
- Implemented PGP pipeline to in corporate secure transmission.
Environment: BizTalk Server 2004, SharePoint 203, MS InfoPath, .NET Web Services, C#, Windows Server 2003, MSMQ, MSMQT, IIS 6.
Confidential
Responsibilities:
- MasterCard RPPS performs online consumer bill payment in a fully electronic format. It streamlines Confidential lending remittance system.
- Performed System Architect role to identify and provide solutions based on the requirement gathered by Business analyst.
- Developed Orchestrations and Business rules for processing transaction file provided by MasterCard RPPS.
- Developed and implemented PGP pipeline to in corporate secure transmission.
- Coordinated with different team to implement MasterCard.
Environment: BizTalk Server 2004, .NET, Windows Server 2003, IIS 6.
Confidential
Responsibilities:
- Worked on BALINK portal which identifies individual and departmental tasks on a day-to-day, weekly and monthly basis and provides the enterprise solutions. BALINK portal meets the guidelines determined by various departments/ Focus groups.
- Initiated the new technology BizTalk Server, Live Communication Server, SQL Server Analysis Services, Reporting Services and Project Web Server based on the focus groups use cases.
- Architected, Designed and developed Quarterly Business Review Meeting site, Network Management for IS-LAN & IS-WAN division site, Performance Review Management Site, Division Team Site and Business Intelligence Tool for Marketing and Finance Management.
- Developed Foreign Currency, Associate Directory, My Team Sites, My Meetings and My Score Card web parts.
- Designed and developed SharePoint Search webpart which extends the SharePoint search and allows the admin user to add search filter at runtime.
- Environment: SharePoint Portal Server 2003, WSS 2.0, BizTalk Server 2004, .NET, C#, VBNET, Windows Server 2003, IIS 6, SQL Server 2000 Analysis Services.
Confidential
Responsibilities:
- Architected, developed and administered Confidential based on Windows SharePoint Services 2.0 and SharePoint portal Server 2003. The system composed of a repository around a SharePoint Document library with custom WebParts to cater different views.
- Designed and developed document workflow webparts with SharePoint integrating with k2.
- Articulated the components using .NET enterprise services to handle transactions across SharePoint database and Confidential database.
- Managed Search service specific to Policylink Published policies/procedures.
- Worked on Confidential and Custom Site Definition deployment using stdasm utility.
- Use Custom Site Definitions to gain fine control over the site.
- Mentored users from different division in SharePoint Technologies.
- Implementation of Custom e-mail alert by changing NOTIFSITEHDR.xml
- Provided SharePoint Deployment Architecture to implement Medium Server Farm.
- Provided Compressive maintenance plan to protect data and documents by implementing SharePoint Portal Server Backup and Restore
- Implementation of Site Usage Analysis to provide number of Hits and unique users.
- Implementation of Site Use Confirmation and Deletion which allows to clean unused sites
- Responsible for providing continuous guidance, troubleshooting and advice to the customer on their SharePoint Portal Server setup and workarounds.
- Involved in providing support for any enhancements the customer desires.
Environment: SharePoint Portal Server 2003, WSS 2.0, .NET, C#, ASP.NET, .NET Web Services, SQLServer 2000, FrontPage 2003, WebPart Packaging, Windows Server 2003, IIS 6.
Confidential, MD
Senior Microsoft .NET Web Consultant
Responsibilities:
- Maintained Real Time Dashboard used by top tier executives. Real Time Dashboard provides the functionality to link/share the documents and to present the graphs dynamically. Configured the BizTalk Server to implement remote data interchange with Confidential.
- Presented the Architecture for Real Time Dashboard system for the new enhancement.
- Developed components using COM+ services and C#, used for Content Management tool.
- Maintained Web services developed using SOAP header and extensions for rendering graphs using VB.NET and SQL Server 2000.
- Installed and configured BizTalk Server 2000.
- Presented the runtime graphs using Macromedia Flash and Action Script.
- Established the business processes using XLANG Orchestration Services, BizTalk Editor
- Debugged and fixed the errors in the Web Services.
- Employed XML to store and present data on the web server.
- Designed and developed stored procedures, user defined functions using SQL Server 2000.
Environment: .NET Framework, Web Services, SOAP/HTTP, C#, VB.NET, ASP.NET, ADO.NET, COM+, VBScript, JavaScript,, CSS, SQL Server, XML, BizTalk Server 2000, Macromedia Flash and Action Script, IIS ver. 5.0.
Confidential
Responsibilities:
- Worked on multiple initiatives, which involved collaborative efforts between Confidential (VZC) and Confidential Wireless ( Confidential ) for joint product offerings to reward valued customers, increase customer satisfaction and reduce churn.
- Confidential ® is a Retail markets strategic initiative that enables customers to view and/or pay Confidential Wireless charges along with Confidential (Local and/or Long Distance) landline bill. eStore is a Web-based application used in Confidential Communication call centers to sell Confidential
- Managed the GUI and Middle Tier Development Teams.
- Developed composite custom controls such as report grid, one bill frame control using VB.NET.
- Implemented page caching concept and also overall cache management.
- Designed and developed stored procedures, user defined functions using SQL Server 2000.
Environment: .NET Framework, Web Services, SOAP/HTTP, C#, VB.NET, ASP.NET, ADO.NET, COM+, VBScript, JavaScript,, CSS, SQL Server, XML, BizTalk Server 2000, Macromedia Flash and Action Script, IIS ver. 5.0.
Confidential, Lake Jackson, TX
Senior Microsoft .NET Web Consultant
Responsibilities:
- Developed Training Mine Action Tracking system using C#, VB.NET, ASP.NET, CSS, XML, XML Data Source Object, SQL Server database, DHTML and IIS 5.0
- Developed components using C# and implemented a Marshalbyref Object and Serialization.
Environment: .NET Framework, C#, VB.NET, ASP.NET, ADO.NET, VBScript, JavaScript, COM+, Web Services, SOAP/HTTP, SQL Server, XML, XML DSO, DHTML, IIS 5.0
Confidential
Senior Microsoft DNA Consultant
Responsibilities:
- The Sales Funnel is an enabler of the SOAR: Sales Process. It was designed specifically to facilitate opportunity management discussions during SOAR: Sales Process account team meetings.
- This web-based reporting tool allows account teams to track the progress of opportunities through the various stages of the Sales Funnel by Company, Office, Service Line, Industry, Opportunity Lead and more.
- The Sales Funnel allows you to select the opportunity data that is displayed by creating filters.
- Filtering allows only data that meets the specified criteria to be displayed. For example, you may create a filter that simply displays all opportunity data for Confidential . Or you may create a more complex filter such as one that displays Business Consulting opportunities in the Energy & Utilities Industry in GMU 055. The Sales Funnel automatically creates a sales funnel graphic report and several text-based reports from the opportunity data stored in the Global Sales System.
- The My Accounts application is a web-based application, which is part of the Global Sales System toolset. My Accounts enables the SOAR: Sales Process by providing high level, global financial summary data. More specifically, it provides a personalized scorecard containing sales plan, sales opportunities and action items for a GMP's specific accounts. The application also allows users to create opportunities and action items.
- Designed & Development of following ASP components under MTS (Microsoft Transaction Server)
- This is the ActiveX EXE implemented as DCOM server which is used extensively by the web application and several other VB applications. It has 2 methods. One for searching the given column in the enterprise directory. The C DLL is used within this EXE for searching in the enterprise directory. The other method is to call a stored procedure with any no. Of parameters. The parameters are passed to the method by an array.
Environment: ASP 2.1, XML, MTS, COM+, VBSCRIPT, JAVASCRIPT, CSS, VISUAL INTERDEV 6.0, FRONTPAGE 98, IIS 4.0, VISUAL BASIC 6.0, VISUAL SOURCESAFE, SQL SERVER 7.0/2000, ADO2.5, ACTIVEX, UNDER WINDOWS NT
