Systems Administrator Resume Profile
SUMMARY:
- 9 years of IT experience in Microsoft Technologies. Extensive experience in analysis, design, development, coding, documentation, testing, bug fixing, deployment and implementation of complex Client /Server and Internet, intranet, n-tier applications, Enterprise Application Integration, B2B Integration, Portals, Content Management with 6 years of ASP/ASP.NET, C .NET and VB.NET experience.
- Having 5 years of exp developing and designing high level solution architecture and loosely coupled integration solutions using SOA, BizTalk Server 2010/2009/2006R2/2006/2004.
- 3 years of experience with EDI X12/EDIFACT standards,HIPAA,HL7
- 2 years of experience in BizTalk Administration, Integration/UAT/Production testing and support and monitoring BizTalk server with MOM 2005/SCOM 2007, upgrading BizTalk environment.
- Having experience with Hub and Spoke, SOA, BUS Architecture.
- Having 5 years of experience in XML/XSLT/XPATH/XSD/SOAP and WebServices.
- Experience Integrating BizTalk with SAP/SQL/Oracle/PeopleSoft/Mainframes/DB2/SharePoint/WebServices.
- Having experience with Business Activity Monitoring, Business Activity Services, Business Rules Engine, Health and Activity Monitoring, Tracking profile editor, custom XSLT/Functoids/Pipelines
- Exposure to Financial, Insurance and Health Care domain.
- Having 2 years of experience with WSS 2.0/3.0, SPS 2003/ MOSS 2007, SharePoint Designer 2007, SharePoint object model, Performance Point Server, InfoPath 2007.
- Having experience with SSIS/SSAS/SSRS, Data modeling, stored procedures.
- Having experience with planning, installing and configuring BizTalk Server on Multi-Server Environment.
- Having experience installing BizTalk on VMware, SQL Server Clustering, and Database Mirroring.
- Having experience with installing and configuring SQLServer/MOSS/MOM/SCOM.
- Having experience with upgrading BizTalk server and migrating applications to new environments.
- Having experience creating MSCS Cluster for Fault Tolerance, NLB Cluster for High Availability.
- Experience with Windows Server 32/64 bit/VMware Administration, Active Directory, LDAP, SiteMinder.
- Having experience creating virtual machines using Virtual PC/ VMware to set up dev/test environments.
- Experience installing client certificates, SSL Certificates, creating IIS Application Pools.
- Experience with winforms, webapps, windows services, XML WebServices, .NET Remoting.
- Strong knowledge of Object Oriented Concepts, UML, .NET Design Patterns, BizTalk Design Patterns, ESB Tool kit 2.0.
- Having experience in gathering customer requirements, preparing technical specs and providing training.
- Highly motivated, self-motivated, excellent team player, quick learner, with good communication skills.
Technical Skills:
- EAI/B2B: BizTalk Server 2004/ 2006/2006R2/2009/2010, Host Integration Server 2006
- Languages: C, C , VB.NET, C .NET, Java1.4/1.5, PL/SQL, CSS, VB/JavaScript, .Net 2.0/ 3.0/3.5,
- Web Techniques: ASP.NET, ADO.NET, ASP, VB 6.0, COM /DCOM, DHTML, HTML, LINQ, XQuery, XSLT
- XML, XPATH, WCF, WPF, WF, WCS, Web Services, WSDL, Ajax, Silverlight, WSS 2.0/3.0
- Development Tools: Visual Studio.Net 2008/2005/2003 , InfoPath 2003/2007, MS Visio 2003/ 2007
- FrontPage 2003, Crystal Reports, Business Objects, SSIS, SSRS, SSAS
- Application Servers: IIS 6.0/5.0, MS SharePoint Portal Server 2003/ MOSS 2007, Commerce Server 2007
- Database: SQL Server 2000/2005/2008, MS Access 2000, Oracle 9i/8i, DB2.
- Monitoring Products: MOM 2005/ SCOM 2007
- Operating Systems: Windows 2000/XP/2003/2003 R2/2008, Windows NT, UNIX, Red hat Linux.
- BizTalk Accelerators Covast EDI Accelerator 2006, HIPAA Accelerator 3.3, Biztalk Accelerator for HL7 2.0
- BizTalk Adapters HTTP,FTP,FILE,POP3,SMTP,SFTP,WSS,MSMQ,EDI,AS2,SAP,SOAP,SAP 3.0/2.0,
- SQL,Oracle,WCF http, MQSeries,BizTalk Adapter For Host Systems,WCF Custom ,DB2,
- PeopleSoft, BizTalk Adapter pack 2.0
- Version Control Visual Source Safe, Team Foundation Server, Clear Case
- Virtualization VMware ESX Server 3.5/4.0, Hyper-V, Citrix.
CERTIFICATIONS:
- Microsoft Certified Application Developer
- Developing XML Web Services and Server Components with Microsoft Visual C and .NET Framework.
- Developing and Implementing Web Apps with Microsoft Visual C .NET and Visual Studio .NET.
- Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
- Microsoft Certified Technology Specialist BizTalk Server 2006/2006R2
- Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2006 R2
- Developing Business Process and Integration Solutions Using BizTalk Server 2006.
- Microsoft Certified Technology Specialist MOSS 2007/WSS 3.0
- Microsoft Office SharePoint Server 2007 Application Development/Configuring
- Microsoft Windows SharePoint Services 3.0 - Application Development/Configuring
- Microsoft Certified Systems Administrator/Engineer Microsoft Windows Server 2003
- Managing and Maintaining a Microsoft Windows Server 2003 Environment
- Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
- Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
- Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
- Designing Security for a Microsoft Windows Server 2003 Network
- Configuring Microsoft Windows Vista Client
- VMware Certified Professional VCP 410 vSphere 4
Professional Experience:
CONFIDENTIAL
CONFIDENTIAL is to integrate the Genzyme lab systems with their external clients and their billing systems. Interfaces are developed for electronic transmission of the lab Report in HL7 format to all interfaced clients. BizTalk will read the reports exposed by Web methods from SOFT laboratory application. All these messages are transmitted to the Client in an HL7 format. Information regarding the sent results is transmitted to the billing system. Claims of the results are also sent from the Lab system to the California's Screening information system in HL7 format.
Responsibilities: BizTalk Administrator/BizTalk Developer
- Development of the interface between Genzyme Lab System and the California state SIS.
- Development of interface between Genzyme lab system and their billing system Xifin.
- Creating and developing maps, pipelines, orchestrations, business rules, exception handling for supporting the interfaces.
- Installation of BizTalk Server 2009 in the Production and Validation Servers for Phase2 and Phase 3 in a multi-server environment, installing Enterprise single sign on, on both the nodes of the SQL Cluster
- Installing BizTalk accelerator for HL7 2.0, WCF LOB SDK, Adapter Pack 2.0
- Installation and Configuration of SCOM 2007 to monitor the Production and Validation Servers,
- Trouble shooting, Production Support and using Clarify ticketing system to resolving the issues.
- Performing Patch updates on all the BizTalk Servers, off hour and weekend support.
- Deploying and testing the code from Dev to Testing and Production environments.
- Deploying the MSI's to the QA, validation and production environment.
- Build, Deploy and test the existing integration application and also changes made to it
- Perform BizTalk related Administration tasks, create MSI's and Binding files, deploying the applications, using power shell and WMI objects, performed the Administrative tasks programmatically.
Environment: BizTalk Server 2006R2/2009, Windows Server 2003 32 bit/2008 64-bit, Visual Studio 2005/2008, C . Net, VB.NET, MS SQL Server 2005/2008, Clear Case, IIS 6.0/7.0, Web Services, WCF-SQL Adapter, WCF-Oracle Adapter, SOAP Adapter, SMTP, SFTP, File, MLLP Adapter, BizTalk Accelerator for HL7 2.0, XML, XSLT, SCOM 2007,VMware ESX 4.0., Clarify, Livelink
ADP Dealer Services
CONFIDENTIAL
CONFIDENTIAL allows dealerships to receive leads directly from OEM and to participate in incentive programs offered by the OEM by sending lead follow-up information back to the manufacturer. Had to access the existing integration platform, research and recommend changes where technology can be better used within the overall integration systems environment to improve efficiency, lower costs, and enhance the quality of the integration application by increasing the performance of the existing integration project.
Responsibilities: BizTalk Architect/ Performance Enhancements
- Make changes to the Integration application to include Exception Handling and Error Control.
- Troubleshooting, correcting issues and analyzing problems in the existing integration system and architecture.
- Deploying and testing the code from Dev to Testing and Production environments.
- Making changes to the existing Vb.net, C .Net code used by the interfaces in the integration application.
- Build, Deploy and test the existing integration application and also changes made to it
- Document, giving demos for the existing changes made to the integration system.
- Perform BizTalk related Administration tasks, create MSI's and Binding files.
- Installing and Configuring BizTalk Server VMware environment / SQL Server in a Multi Server Environment
- Design and develop a Fault Tolerant and Highly Available Integration system.
- NLB Clustering on BizTalk Servers, MSCS Cluster on the SQL Servers.
- POC for using MSCS SQL Clustering vs. Database Mirroring with BizTalk Server
- POC for using Standard vs. Enterprise licensing of SQL Server 2005/2008, BizTalk Server 2009 cost saving
- Recommend and help in getting the software licenses needed for the new integration infrastructure.
- Performance Tuning of BizTalk Server, SQL Server Agent Jobs, Backup and restore of Databases.
Environment: BizTalk Server 2006/2009, Windows Server 2003/2008, Visual Studio 2005/2008, C . Net, VB.NET, MS SQL Server 2005/2008, Clear Case, IIS 6.0/7.0, Web Services, HTTP Adapter, SQL Adapter, SOAP Adapter, XML, XSLT, SCOM 2007,VMware ESX 4.0.
CONFIDENTIAL
CONFIDENTIAL Project is establishing reconnections between Shell and OOC other oil companies , such as Chevron, BP, Engen, Sasol, SAPREF Oil Refinery , Spoornet Transporters . 22 interfaces such as inbound order, delivery confirmation, inbound movement, etc between Shell GSAP and GXS Middleware were developed. SSIS is used to move data between Oracle and Sql Server and then the large scale data is processed in batch using service broker and transferred to another SQL server.
Responsibilities: BizTalk Consultant
- Involved in the design and the architecture of the Project.
- Establishing and developing interfaces between BizTalk and GXS middleware to establish reconnections between Shell GSAP and OOC's. Creating SSIS packages to move data from SAP oracle to SQL Server for the synchronization of material codes and plant codes.
- Developing orchestrations, exception handling, maps, custom pipelines, BAM, custom XSLT Scripts functiods for maps, batching, de-batching of the messages.
- Composing and deploying Business Rule Policies.
- Installing and nsoftware adapters and configuring the SFTP adapter to receive and send data.
- Creating partner profiles in SAP and associating them with the inbound and outbound messages in SAP.
- Testing the interfaces by triggering the iDOCs in SAP and also check SAP to view the posted messages.
- Creating the deployment scripts and sending them to integration, Acceptance and testing them.
- Creating architectural diagrams in Visio, preparing proof of concepts, and preparing technical specifications and reviewing code with senior architects, Performance Tuning and Capacity Planning
- Implementation of Exception Handling using Enterprise Service Bus Exception Management Framework.
- Production support and onshore offshore coordination for deployments
- Preparing the design documents, resolving defects in Mercury Quality Center and installation of the certificates in the certificate store.
- Environment: BizTalk Server 2006 R2/2009, Windows Server 2003 R2, Visual Studio 2005/2008, C . Net, VB.NET, MS SQL Server 2005, Visual Source Safe, SFTP Adapter, SAP Adapter, WCF Channel Model, Enterprise Service Bus, nsoftware adapters, GXS VAN, XML, XSLT, IDOCs, WCF Custom, MSMQ, Mercury Quality Center 9.0, SCOM 2007.
- CONFIDENTIAL that were developed between Shell and the Hauliers and vendors in Benelux Europe . The inbound EDI EDIFACT files come from 3rd parties using HTTP over AS2/ SFTP. The incoming data is transformed and sent to SHELL SAP. The outbound idocs are sent from SHELL SAP to 3rd parties over AS2/SFTP.
Responsibilities: BizTalk Consultant
- Involved in the design and the architecture of the Project.
- Establishing and developing interfaces between BizTalk and GXS VAN/ directly with 3rd parties Freightmax, Suederlbe, Steenbergen, Derike, phillipines
- Developing orchestrations, Role links, exception handling, complex maps, custom pipelines, Business rules, BAM, Custom XSLT Scripts functiods for maps
- Creating and configuring Trading Partners/Parties and AS2 Properties.
- Using C to write custom .net components needed in BizTalk.
- Creating architectural diagrams in Visio, preparing proof of concepts, and preparing technical specifications and reviewing code with senior architects, Performance Tuning and Capacity Planning.
- Installing and nsoftware adapters and configuring the SFTP adapter to receive and send data.
- Creating partner profiles in SAP and associating them with the inbound and outbound messages in SAP.
- Testing the interfaces by triggering the iDOCs in SAP and also check SAP to view the posted messages.
- Invoking Operations on the SAP System, Receiving Inbound operations from SAP System using WCF Channel Models.
- POC for Receiving the IDOC Typed, string, rfc from SAP using WCF Channel Model.
- POC for Sending the IDOC Typed to SAP using WCF Channel Model.
- POC for Streaming Flat File IDOCS in the WCF channel Models and sending to SAP
- POC for Receiving the IDOC from SAP and sending the response IDOC back to SAP using the WCF Channels.
- Implementation of Exception Handling using Enterprise Service Bus Exception Management Framework.
- Evaluating System Performance using Performance monitor.
- Creating the deployment scripts and sending them to integration, Acceptance, Production and testing them.
- Production support onshore offshore coordination for deployments
- Preparing the design documents, resolving defects in Mercury quality center and installation of the certificates in the certificate store.
Environment: BizTalk Server 2006 R2, Windows Server 2003 R2, Visual Studio 2005, C . Net, VB.NET, MS SQL Server 2005, Visual Source Safe, SFTP Adapter, SAP Adapter, WCF Custom, nsoftware adapters, GXS VAN, XML, XSLT, HTTP Adapter, EDIFACT, HTTP Adapter, AS2, IDOCs, MSMQ, MOM2005, Enterprise Service Bus, Mercury Quality Center 9.0
CONFIDENTIAL
Shell has decided to move their ERP SAP to Global GSAP. So all the existing connections to the SAP Trident should be moved to GSAP. Old transactions were in Gentran. BizTalk is used as the new middleware for development of any new interfaces. 26 interfaces involving Lubricants supply chain, Procure goods and services, Shell to Business customers, Delivery for own Account. were developed and the mappings were moved from Gentran to BizTalk.
Responsibilities: BizTalk Consultant
- Involved in the design and the architecture for BizTalk in the later stages of the project.
- Developing 26 ANSI X12 850,860,856,944,214,204/216,852,810,etc interfaces between BizTalk, GSAP, Gentran, Sql Server and establishing reconnections between Shell, suppliers, hauliers, customers etc.
- Developing orchestrations, exception handling, complex maps, custom pipelines, Business rules, BAM, Custom XSLT Scripts functiods for maps
- Configuring SFTP, SQL, and SAP 2.0/3.0 adapter, InfoPath and BizTalk Integration.
- SharePoint adapter configuration, integration. Sending the documents in/out of the document lib for approval.
- Creation of SQL Cluster and NLB Cluster on Windows Servers hosting BizTalk Server
- Designing Infopath forms, Connecting to datasources, Importing forms from excel, word,
- Development of the n-tier BAM portal using ASP.NET 3.5, .NET Framework 3.5, LINQ, WCF webservices for the Data Tier, UserControls, Session Management, master pages, nested master pages.
- Performance improvement of the Web Application using Page Output Caching, Unit test of the Web Application
- Generated reports using SQL Server Reporting Services, and used SQL Service Broker to consolidate data from different databases.
- Using C to write custom .net components and developing SQL stored procedures needed in BizTalk.
- Creating partner profiles in SAP and associating them with the inbound and outbound messages in SAP.
- Creating architectural diagrams in Visio, preparing proof of concepts, and preparing technical specifications and reviewing code with senior architects, Performance Tuning and Capacity Planning.
- Implementation of Exception Handling using Enterprise Service Bus Exception Management Framework.
- Testing the interfaces by triggering the iDOCs in SAP and also check SAP to view the posted messages.
- Using Health and Activity Tracking HAT for tracking data.
- Retrieving data from PeopleSoft and writing data to PeopleSoft using BizTalk adapter for PeopleSoft.
- Creating of schemas from PeopleSoft adapter metadata and establishing connectivity between BizTalk and PeopleSoft.
- Production Support and onshore offshore coordination for deployments.
- Resolving defects logged in Mercury Quality Center 9.0.
Environment: BizTalk Server 2006 R2, Windows Server 2003 R2, Visual Studio 2005/2008, C . Net,VB.NET, MS SQL Server 2005, ANSI X12, SAP adapter, WCF Custom, HTTP Adapter, SQL Adapter, SFTP adapter, FTP adapter, SMTP adapter, Enterprise Service Bus, Visual Source Safe, MOSS 2007, XML, XSLT, IDOCS, Gentran, GXS VAN, PeopleSoft , BizTalk PeopleSoft Enterprise Adapter, MSMQ, InfoPath 2007,MOM 2005, Mercury Quality Center 9.0, ASP.NET 3.5, .Net Framework 3.5, LINQ,CSS,HTML, JavaScript, SSRS.
CONFIDENTIAL
Confidential has number of farmers who supply products to them and they wanted to establish an interface between their ERP Lynx and the third party web application eOriginal that supports storing the contracts between the Confidential.
Responsibilities: BizTalk Architect/Consultant
- Installing and configuring BizTalk Server 2006 R2, Performance Tuning and Capacity Planning.
- Designing the architecture for BizTalk, and preparing the Project estimates.
- Establishing and developing an interface between BizTalk and eOriginal to handle the HTTP post with forms authentication. Includes Uploading the PDF, XML documents, creating transactions, Watermarking the PDF, retrieving the PDF from eOriginal using C .
- Publishing orchestrations as web services, enabling lynx to send data to BizTalk using the Web service.
- Consuming web services exposed by Lynx to send data to Lynx
- Configuring IIS to handle the web service request.
- Using Health and Activity Tracking HAT for tracking data.
Environment: BizTalk Server 2006 R2, Windows Server 2003 R2, Visual Studio 2005, C .Net, VB.NET, MS SQL Server 2005,UDDI, Web Services, WSDL, Microsoft Virtual PC 2007, Team Foundation Server, SOAP Adapter, HTTP Adapter, IIS 6, XML, XSLT, XPATH, Fiddler HTTP.
CONFIDENTIAL
- CONFIDENTIAL has engaged the services of Dealertrack Digital Services and Continental Data Graphics CDG to outsource the scanning, hosting and handling of contract-related documents. DDS will be receiving the paper documents from the dealers and will scan these documents into images. DDS will then send metadata and these images to CDG for hosting. In addition DDS will be sending HMFC Daybreak the same metadata, without images, to update Daybreak. Daybreak will send the return to dealer documents Dealertrack. The exchange of data is done over HTTP with sending and receiving the acknowledgements for the same.
- Project 2. Redundancy project is to modify the existing BizTalk Architecture and deploying the existing application for High Availability by installing BizTalk 2006 on a multi-server environment. Someone before did the existing project and Hyundai team does not know about the Black Box that sits in between IIS and the MSMQ. So had to understand the current application and then prepared the BizTalk environment with 2 BizTalk Servers and used a load balancer before BizTalk to route the requests to Windows Server 2003 R2 which hosts BizTalk Server R2 as well as IIS.
Responsibilities: BizTalk Architect/Consultant
- Installing, configuring BizTalk Server 2006 R2 in a multi server environment, Upgrading to BizTalk Server 2006 R2.
- Design of the new architecture for BizTalk, identifying the bottlenecks in the present BizTalk Environment.
- Installing Oracle Client, BizTalk line of business Oracle adapter, hot fixes to the Oracle adapter.
- Developed Schemas, Canonical Schema, Maps, Business rules, POC
- Preparing Functional and Technical Documentation.
- Developed Orchestrations for the inbound and outbound process.
- Developed Orchestration to de-batch inbound messages from Oracle Adapter. Direct binding ports
- Developed Orchestrations to handle Error Handling, which emails the BizTalk Admin upon error.
- Developed C components to support error handling to generate error message.
- Developed Custom Pipelines to Send/receive data to/from Dealertrack over HTTP.
- Creating the testing environment on the Virtual Hard Disk from VMWare, that can be deployed on the ESX Server.
- Developed custom functoids/ C components for database operations and to retrieve the configuration information from the registry.
- Used Health and Activity Tracking for tracking data.
- Developed C application which sends the data to test the BizTalk Application over HTTP.
- Used BizTalk documenter to document the BizTalk artifacts in production.
- Performed Unit, Integration and load testing of the application. Done extensive load testing on the Receive location that Oracle uses to poll against the Oracle DB, tuning of the polling interval accordingly to the performance
- Training the staff on the deployment of the application.
- Working with the firewall team to know the URL's that are used while receiving / sending data over HTTP.
- Configuring HTTP Receive locations with the above URL's
- Ensure that the load balancer is hitting the both BizTalk servers.
- Created SSIS Packages to transform the data.
- Provide high-availability configuration through scaled-out tiers of hosts. Creating separate hosts for each primary function Receiving, Sending and processing, Performance Tuning and Capacity Planning.
Environment: BizTalk Server 2006 R2, Windows Server 2003 R2, Visual Studio 2005, MS SQL Server 2005, Web Services, Microsoft Virtual PC 2007, VMWare, Visual Source Safe, BizUnit, Oracle 10g, Oracle DB Adapter, HTTP Adapter, IIS 6, XML, Xpath, MSMQ, C .NET,VB.NET, VMware, ESX Server .
CONFIDENTIAL
Triad Financial will be using a messaging system as a means to integrate various services to provide solutions for their business needs. One of the many business needs requires Triad Financial to accept car loan applications from select partners via the internet. Triad Financial receives car loan applications from many channels. The incoming loan applications must be entered into Triad's internal system, Daytona, in order for the loan applications to be scrutinized and processed. Daytona has been given a service fa ade to keep Daytona decoupled from any specific application. Partners will send information to a Triad service. The Triad service is a message gateway to the messaging system BizTalk . The messaging system is responsible for validating incoming information and routing it to the Daytona service fa ade to be entered into the Daytona system.
Responsibilities: BizTalk Architect/Consultant
- Establishing development, testing Q/A , and production BizTalk environments
- Installing and configuring BizTalk Server 2006 R2, SQL Server 2005 in a multi-server environment.
- Installing, configuring Microsoft Operations Manager 2005 and applying BizTalk 2006 Server R2, SQL Server 2005 management pack for MOM 2005.
- Installing and configuring SqlServer 2005, implementing Basic BAM Portal.
- Ensure that the load balancing configuration supports the state full connections required for the BizTalk failover mechanism to work correctly
- Provide high-availability configuration through scaled-out tiers of hosts. Creating separate hosts for each primary function Receiving, Sending and processing.
- Deploying BizTalk within the Triad's environment, Performance Tuning and Capacity Planning
- Performing end to end testing, Unit Testing, Integration testing on the development, Testing and Production environment.
- Writing scripts to use BizUnit for Unit testing.
- Designing, creating and testing the setup MSI packages created using WIX and Visual Studio 2005.
- Monitoring the event logs in SQL Server 2005 and BizTalk Server 2006 R2.
- Converting complicated scripts to MSI's for easy application deployment in the dev, test and Production environment
- Provide production training for IT administrative team on BizTalk server and the associated components
Environment: BizTalk Server 2006 R2, Windows Server 2003 R2, Visual Studio 2005, MS SQL Server 2005, Web Services, Microsoft Virtual PC 2007, Visual Source Safe, MOM 2005, BizUnit, HTTP Adapter, Oracle adapter, IIS 6, XML,C .NET, VB.NET
CONFIDENTIAL
CONFIDENTIAL project is aimed at automating the process of exchanging purchase orders X12-850 Inbound/Outbound , Purchase Order change requests X12-860 Inbound/Outbound , Invoices X12-810 Inbound/Outbound , acknowledging the orders X12-997 Inbound/Outbound , sending advance shipment notices ASN X12-856 , Benefit Enrollment and Maintenance X12-834 Outbound from Graham . The project is being developed with MS BizTalk Server 2006 Covast EDI Accelerator 2006 to understand the incoming EDI's, cXML docs and process them. Saved lot of money for the Client, by installing the SAP Adapter successfully on BizTalk Server as well as configuring the SAP R/3 with the Program ID needed for BizTalk to receive the IDOC's from SAP. Client was considering using IWAY Adapters, which is expensive
Responsibilities: BizTalk Architect/ BizTalk Consultant
- Involved in requirements analysis of the integration project with Unilever, Wellman, Valvoline, Pepsi, Coke, Chevron, Aetna, Dial
- Installation of BizTalk Server 2006, VirtualServer2005 R2, Virtual PC 2004, Covast EDI Accelerator 2006.
- Designing the Service Oriented Architecture and creating separate application for each trading partner.
- Creating xml schemas xsd out of DTD's, cXML, EDI X12 Documents, Generating Schemas for SAP Idoc's from SAP R/3 using SAP Adapter, and generating schemas from Covast .asc files.
- Deploying Applications on to the VPC, Creating MSI and binding files and using them to deploy applications on staging and production servers, Performance Tuning and Capacity Planning.
- Monitoring the Event viewer to detect Errors. Developing orchestrations for failed message routing for both inbound and outbound transactions. Upon any error, Emails are sent to the inbound/outbound contact person using SMTP Adapter.
- Installing the SAP Adapter on the BizTalk Server VPC, Production and Staging to send IDocs from SAP R/3
- Performance evaluation of VPC 2004, VPC 2007, Virtual Server 2005 R2.
- Developed maps using BizTalk as well as custom XSLT complex maps often need Custom XSLT
- Setting up COVAST EDI Accelerator 2006 to receive X12 documents, creating party, party alias for each trading partner, configuring each Trading Partner Party and generating acknowledgements X12-997 .
- Developed orchestrations to send /receive messages to SAP and to archive the inbound and outbound messages.
- Developed Custom receive and send pipelines to process the messages based on content.
- Developed common utility components for database operations using C .
- Implementing PGP send side encoding component and receive side decoding component.
- Configuring Health and Activity Monitoring to view the tracked data.
- Worked on X12-850/860/856/810/834 version 3040/4010/5010 EDI Documents
- Implemented Business Rules and trading partner relationship management using BAS.
Environment: BizTalk Server 2006, Oracle 10g, Windows Server 2003, Visual Studio 2005, MS SQL Server 2005, Covast EDI Accelerator 2006, Windows Share Point services 2.0, Web Services, Microsoft Virtual PC 2004, Microsoft Virtual PC 2007, Microsoft Virtual Server 2005 R2, Visual Source Safe, SAP R/3, INOVIS, AS2, C .NET,VB.NET
CONFIDENTIAL
Implementation of the HIPAA X12 4010A1 837 Professional claims, Dental claims, Institutional claims , 834,820,835 Claim Payment , 270 Eligibility Request , 271 Eligibility Response , 276 Status Request , and 277 Status Response with the help of HIPAA Accelerator 3.3 and BizTalk Server 2006.
Responsibilities: BizTalk Consultant/Architect
- Designed, developed Schemas, Maps, Pipelines and orchestrations.
- Installing and Configuring BizTalk Server 2006 and SQL Server 2005, Performance Tuning and Capacity Planning.
- Configuration of the HIPAA accelerator for BizTalk Server 2006
- Generated C components for storing data in to the SQL Server DB
- Configuring the BizTalk Adapter for DB2 DB2/MVS,SNA LU 6.2 , BizTalk Adapter for Host Files COBOL
- Create the metadata definitions for Host Files, import Host Definitions, gac and registering the assembly.
- Using the BizTalk adapter for Host Applications adapter to call the cobol programs in the CICS environment mainframes
- Export and import the Host definition files.
- Create TI WIP assemblies and XSD representation using the TI Designer
- Used TI Manager to connect to the remote environment CICS , configure and deploy assembly created by TI designer.
- Creating the TI WIP ASMX Web service to retrieve patient information in Mainframe CICS and using ASP.Net to display the data in the Web Application.
- Created stored procedures for smoother access of the DB.
- Calling the web services from inside the orchestrations.
- Building XML web services to expose DB2,Host Files data using ASP.NET
- Created Business workflow process for inbound and outbound HIPAA, HL7 transactions.
- Configuration/creation of the parties in HIPAA Accelerator and its Administration.
- Developed business rules and implemented Business Activity Monitoring.
- SSIS Package to move the Claim information in to the Data Mart for reporting.
Environment: BizTalk Server 2006, Windows Server 2003, Visual Studio 2005, MS SQL Server 2005, HIPAA Accelerator 3.3, Windows Share Point services 3.0, Moss 2007, InfoPath 2007, ANSI X12, FTP, Web Services, BizTalk Adapter for Host Systems, IIS, MOM 2005, Host Integration Server 2006, Web services, ASP.NET 2.0, C .Net, CICS, Z-series IBM z/OS Mainframes, AS400.
CONFIDENTIAL
Obtaining Certification and Accreditation Report by using security audit techniques, following up a pre-determined security and privacy checklist and Transaction compliance for Health Insurance Portability and Accountability Act HIPAA . Development of Gap analysis, contingency plans and risk analysis and mitigation procedures. The customization of 834, 835, 837 transactions using EDI ANSI X12, BizTalk Server 2006, HIPAA Accelerator 3.3, Windows 2003 platform, XML data and Oracle Server as back-end.
.
Responsibilities: Application Developer
- Involved in preparing the Methodology document for the HIPAA implementation
- Involved in Project planning, project monitoring activities- used MS Project and Ms Visio extensively
- Involved in Analysis and Implementation for Intranet Based Management Information System.
- Implementation of 5 key aspects of HIPAA - Transactions, Identifiers, Codes, Privacy and Security, Non-Compliance issues and penalties
- Developed Schemas of EDI ANSI X12 Claims 837 and Eligibility forms in XML.
- Created Maps using BizTalk Server 2006 and also embedded business rules using business rules engine.
- Developed orchestrations for 834, 835, 837 process.
- Used Oracle DB adapter for updating, retrieving and inserting the data related to 834,835,837 transaction sets.
- Prepared test plan and test cases for testing of the system and tool for validation / compliance.
- Development of custom database access components in VB.NET
CONFIDENTIAL
CONFIDENTIAL, is amongst the largest global suppliers of technologically advanced aerospace and industrial products. HS B2B project is aimed at automating the process of receiving purchase orders X12-850 , Order change requests X12-860 , acknowledging the orders and sending advance shipment notices ASN . This project is aimed at integrating HS processes with those of its partners like Boeing, PWC, Navy, Govt, Lockheed etc. The project is developed with MS BizTalk Server 2006 Covast EDI Accelerator 2006 to understand the incoming EDI's and process them.
Responsibilities: Lead Developer
- Involved in requirements analysis of the integration project with Boeing
- Creating xml schemas .xsd out of DTD's, EDI X12 Documents.
- Developing maps incorporating the Business rules to generate HS's Standard messages.
- Setting up Covast EDI Accelerator 2006 to receive X12 documents, generating acknowledgements X12-997 .
- Developed Orchestration process which creates Standard message and also invokes the c library to generate JDE Message Portal Messages, from which the data will be inserted into DB2, Oracle databases subsequently.
- Converting the existing code from SeeBeyond to BizTalk Server.
- Developed orchestration/maps to generate 856 X12 Document for Advance Shipment Notice. ASN .
- Developed a Custom receive pipeline to route the messages based on content content based routing .
- Developed common utility components for database operations using C .
- Worked on X12-850/860/856 EDI Documents
- Sending copy of the order to the SharePoint document library, InfoPath integration with SharePoint.
- Implemented Business Rules, BAM.
Environment: BizTalk Server 2006, DB2, Windows Server 2003, Visual Studio 2005, MS SQL Server 2005, Covast EDI Accelerator 2006, SSIS, Windows Share Point services 2.0, SeeBeyond.
CONFIDENTIAL
CONFIDENTIAL is amongst the largest global suppliers of technologically advanced aerospace and industrial products. Boeing is the world's leading aerospace company. Both the companies partnered as part of Boeing's Integrated Materials Management IMM initiative. Through this program, Boeing and suppliers such as Hamilton Sundstrand maintain airline's inventory of spare parts, providing items as needed. By reducing inventory, IMM reduces airlines cost of doing business. Boeing's offering of IMM is aimed at maximizing efficiencies within the supply chain. This project is aimed at automating the process of receiving transactions like STOCK TRANSFER INSTRUCTION, Stock Transfer Receipt Notification, Changeover Acknowledgement, and Supplier Inventory On-Hand from Boeing in the form XML. This project also aimed at sending out transactions related to Advance Shipment Notification, SHIPMENT SCHEDULE ADVISORY.
Responsibilities: Lead Developer
- Involved in requirements analysis of the project with Boeing.
- Developed custom pipeline to decrypt the xml files sent by Boeing using PGP GnuPG decrypter component.
- Migration of the project from BTS 2004 to BTS 2006.
- Creating xml schemas .xsd out of the XML Documents also from the files tables on DB2 Database using Database adapters.
- Developed maps incorporating the Business rules to generate database insert/update messages.
- Developed Orchestration process which looks into SQL server database to check whether a particular transaction have already come in or not and constructs the db2 messages.
- Developed orchestration/maps to generate Advance Shipment Notice ASN to be sent out to Boeing.
- Developed common utility components for database operations using C .
- Developed custom functoid to call a DB stored procedure from a map.
Environment: BizTalk Server 2006, DB2, Windows Server 2003, SSIS, Visual Studio 2005, MS SQL Server 2005, DB2.
CONFIDENTIAL
Unassisted Orders captured in the CONFIDENTIAL Front as well as Assisted Orders captured in the LA Call-Center are saved in the local ISCS Integrate Simple Commerce Solution Transaction Database. This B2Bis interface built using BizTalk Server 2004 will be looking for both types of these orders and will pass on the orders to B2Bis in the xCBL 3.5 Orders format. The schema used for the outbound order is Order.xsd. The successful completion of this process would be determined by the receipt of an Acknowledgement from B2Bis.
Responsibilities: Lead Developer
- Involved in requirement analysis for LA-B2Bis Interface
- Created xml schemas .xsd to construct messages for Incoming Order LA Order Outgoing order XCBL Order .
- Developed BizTalk maps .btm to convert LA Order to XCBL Order.
- Written Custom XSLT's to apply in the BizTalk map.
- Developed Orchestration process which submits the LA Order as XCBL Order to http port send port .
- Developed Orchestration services to decrypt the credit card numbers as well verification numbers.
- Created BizTalk Rules for order tax calculations to apply in the Orchestration Process.
- Developed the SQL stored procedures required to maintain the status of Order Migration Process from LA to B2Bis on Audit as well as Transaction databases.
- Developed common utility components for database operations using C .
- Installation validation of BizTalk Client/Server side software tools on various environments QA, UAT, PROD .
- Automated BizTalk deployment: Developed BizTalk Deployment Scripts that are required to deploy the solution on QA, ITG, PROD environments.
Environment: BizTalk Server 2004, DB2, Windows Server 2003, Visual Studio 2003, MS SQL Server 2000, DTS.
CONFIDENTIAL
The objective of this project is to migrate the content from multiple servers branches across USA to Share Point Portal server 2003, so that user groups from multiple locations can share, access and upload the data to centralized system. The major tasks include creation of site map, user management, document library management, restructuring/reorganizing the links, managing and customizing search and identifying content updates required. The major feature of this project is content search and it includes basic search, search by Keyword, search by File Type, and search by Categories/Sections/workspace. Another major feature in this project is giving the online donations to the organization it validates the credit card by using secured hypertext transport protocol.
Responsibilities:
- Studied and Analyzed Requirement Specifications.
- Involved in design of the sitemap.
- Created SharePoint services sites document management libraries, look up list fields, custom views for document libraries
- Designed Applied corporate look feel to SharePoint portal sites team sites, using CSS and FrontPage 2003.
- Created team sites that use form web parts, content editor web parts, list web parts, image web parts for displaying information.
- Used Calendar and MyInbox web part that is integrated with Microsoft Exchange Server.
- Configured the Share point team site with the MS Index Server
- Web services are designed and developed by using ASP.NET
- Created batch files to backup portal site and site collection using stsadm.exe and spsbackup.exe tools.
- Managed the user groups and assigned user roles
Environment: MS Share Point Portal Server 2003, Windows Share Point Services2.0, IIS, ASP.NET, ADO.NET, XML, MS SQL Server 2000, Windows Server 2003, FrontPage 2003,Visual Studio.NET 2003.
CONFIDENTIAL
This project deals with online registration of the contracting agents, suppliers to the GE Transportation Systems. The system allots unique supplier code, gsl code, and account code to the agents and suppliers, in the process of activation of the supplier, the system sends the emails to the corresponding managers. After getting approval from the manager, the system takes the inputs such as bank details for accounts purpose and it takes the details of Electronic fund transfer and Wireless Fund transfer details too.
Responsibilities:
- Studied and Analyzed Requirement Specifications.
- Involved in design of the database.
- Developed the User Interfaces by using the HTML and ASP.NET.
- Front-end validations are done using Java Script and server side scripts using by ASP.NET.
- Used IIS as web server.
- The Website uses XML, HTML for displaying information.
- DLLs are designed by using VB.NET
- Involved in writing the stored procedures.
- Involved in writing test scripts for unit test and writing test plans.
Environment: VB.Net, ASP.Net, ADO.Net, XML, SQL Server 2000, Crystal Reports 8.0, Nunit
CONFIDENTIAL
Designed and implemented accounting system module, billing module and report generating module for the Transportation Company. Developed GUI interfaces to check for budget, place purchase order, generate checks, process voucher, tracking the approval of voucher, process payment, generate checks, track payment, process journal entry, post journal entry to general ledger GL system. The other important modules in this project are to update, delete and modify master files, enter voucher, inquire outstanding payments, evaluate vendors, Inquire invoice information and payment history.
Responsibilities:
- Analyzed, designed, developed and implemented template based site navigation using ASP.Net user controls.
- ADO.Net components are used to perform data manipulation in relational database.
- Wrote functions, stored procedures, Views using T-Sql and Excel to SQL server data transformation package.
- Developed billing module, and dealer commission module calculations
- Developed a wrapper component to upload MS Excel sheet data into existing database
- Experienced with unit testing, Microsoft Visual Studio Dot Net testing and programming tools.
- Extensive experienced in implementing OO architectures in .NET, securing .NET applications, serialization.
- Developed and directed software system testing procedures, programming, and documentation.
- Designed, developed and implemented Web Based Applications to generate Crystal Reports
- Configured IIS 5.0 and TCP/IP to process user requested pages.
Environment: ASP.Net, C .NET, XML, XSL, XSD, MSDE 2000, JavaScript, VisualStudio.Net, IIS 5.0, VSS 6.0, Windows Server 2000.
CONFIDENTIAL
This project deals with the Inventory Control. It is a high performance database system designed specifically for tracking drugs and laboratory supplies etc. Drug product shortages have become a constant problem for hospitals and health systems. Managing these shortages is often frustrated by the lack of information. The purpose of this resource center is to provide pharmacists and others responsible for patient care and for drug product acquisition and inventory management with appropriate information, sources of information, and guidance about managing drug product shortage situation.
Responsibilities:
- Involved in high level designing of the application
- Designed the flow of the Application
- Involved in Client Interaction Handling change requests
- Implementing the Application on the Client side
Environment: VB.NET, ASP.NET, XML, ADO.NET, Crystal Reports, SQL Server2000, Windows 2000
CONFIDENTIAL
- This project deals with the Bank automation. All transactions in a bank including General services SB accounts, Current accounts, Demand Drafts, check maintenance, term deposits, fixed deposits, locker maintenance, demand loans, term loans, HRMS etc., . And it generates all kinds of MIS reports.
- LOANS: This system handles all types of loaning transactions since it allows different types of loans such as commercial loans, discounted loans and multipurpose regular loans. The system is tailored in such a manner to enable the enterprise to choose the method that is flexible enough to effectively run its loaning policy and objectives, through the facilities provided for the enterprise to automatically create its own installment schedules with flexibility and as per the loan contract, compute interests and commissions in different manners such as compound, time, periodic and discounted ones, define repayment and interest/commission application schedules, allowance window interest / commission calculation method, overdue interest / fines calculation method and reschedule loan or unpaid installments.
Responsibilities:
- Involved in Loans Module, analyzed and Studied Requirement Specifications.
- Designed and implemented the database, Components DLLs/EXEs are designed by using VB.
- Designed and Develop the User Interfaces by using VB.
- Write the Coding for front end and back end validations.
- Reports are done by Crystal Reports.
- Involved in writing test scripts for unit test and writing test plans.
Environment: VB6.0, Oracle 8i, Crystal reports, COM
CONFIDENTIAL
- The application is an intranet based foundry process flow that keeps track of all the movement of scrap, metal, ores into, and the finished products out of the foundry. The application is also useful for other departments in Quality Control, Contract Re-orders, Furnace Utilization, and calculations for Power and Water usage.
- Involved in developing web pages using ASP.
- Involved in generating client side scripting using VB Script and Java Script.
- Used ADO objects with OLEDB in interfacing the application with SQL Server database.
- Created functions and procedures and used in the application.
- Written stored procedures for saving network traffic and improving the performance of database transactions. All 'SQL Send' to the server from client were parsed and optimized before execution.
- Developed Stored procedures to be used as central SQL library and privileges levels were incorporated in usage of stored procedures called them using ASP.
Environment: ASP, HTML, JavaScript, Stored Procedures, SQL Server 7.0, Windows NT
CONFIDENTIAL
In this project a website is developed for cadence, using ASP, Java script and DHTML. IIS and SQL Server is the back end.
Responsibilities:
- Analyzing requirements specifications, Database design
- Designing and Developing User Interfaces using HTML and ASP.
- Front end validations using Java Script and server side programming with ASP
- The Website uses XML, HTML for displaying information.
- Host the web site and involved in the support and maintenance of site.
Environment: HTML, DHTML, Java Script, ASP, VB, SQL Server, IIS and COM