Likhitha
***************@*****.***
OBJECTIVE
Seeking a position as BizTalk developer using my experience and
expertise in BizTalk Server 2004/2006/2006-R2/2009/2010,
VisualStudio.Net 2005/2008/2010..NET Framework (ASP.NET, Web/Windows
Applications, ADO.NET, Web Services), & SQL Server 2003/2005/2008
Professional Summary:
. Over 7 years of experience in software field, which includes 5 years
as a BizTalk developer and 2 years as a .Net developer.
. Good understanding of Enterprise Integration Patterns like Message
Construction and Transformation patterns using BizTalk.
. Extensive working experience in developing BizTalk Solution objects
such as creating and validating Schemas, Mappers, Pipelines and
creating Orchestration and using .NET components in Orchestration.
. Installed, configured BizTalk Server 2006/2006R2/2009/2010, Visual
Studio and SQL Server 2005/2008/R2, Host Integration server 2010 in
the Development
. Strong Knowledge in all phases of Software Development Life Cycle
(SDLC) of Business Intelligence Applications such as Developing,
Testing and Production Support.
. Strong database (SQL) experience with an emphasis on SQL programming.
. Hands on experience in Biztalk code migration from 2006 to 2010.
. Experience with VB.NET, C#, Web Services, IIS, XML, XSD, and MS SQL
Server.
. Heavy experience in configuring BizTalk Server adapters that ships
with BizTalk.
. Knowledge in Configuring Oracle, SQL, SOAP, POP3, HTTP, my SAP
adapter.
. Adequate knowledge in Configuring in WCF LOB Adapters - Oracle DB2,
SAP, SQL, WSHttp.
. Heavy experience on HIPAA EDIX12 tansactions such as 270/271,
276/277, 835, 837/820.
. Developed the XML Schemas, Orchestrations, and Maps for BizTalk and
Configured send and receive ports.
. Worked in different organizations like Financial Services, Health
Insurance, and Energy industries.
. Good understanding of technical trends, architectures; self-learner
and motivated to stay on top of latest technology, new software and
products.
. Enthusiastic and project-oriented team player with good written and
oral communication skills.
. Excellent written and verbal communication, documentation skills, team
player and ability to work across organizations to achieve results
with minimal handholding.
SKILL SET
OS & Tools: Windows Vista/XP/Professional/NT/2000/98/95, Windows Server
2008/2003, MS Office 2010
Programming/Web/Database: C, C++, C#, Win Forms, IIS 5.0/6.0, SOAP, WSDL
XML, XLST, SQL, PLSQL, Oracle-8i/9i, MS-SQL Server 2005/2008.
BizTalk Server (2004/2006/R2/2009/2010): Schema's, Adapters, DB2 Adapter
for HIS BizTalk 2006, IBM MQ Series Adapter for BizTalk 2004/2006, HIPPA
EDI Adapter for BizTalk 2006, Native BizTalk Adapters like File, FTP, HTTP,
SOAP, SQL etc.,Microsoft commerce server 2007, SAP Adapter for BizTalk
2004/2006,Ports/Pipelines, Orchestration, Map/Functoids, Business Rule
Composer, HAT, Messaging and Orchestration Patterns, Installation, Design
and Development, Management, Deploying, Migration.
PROFESSIONAL EXPERIENCE:
GEP, Nov 2013 to Current
Clark, NJ
Sr.BizTalk Developer
SMART by GEP is something new - a complete, unified sourcing and
procurement platform native to cloud, touch and mobile technologies -
from one of world's leading global providers of procurement solutions,
GEP. SMART cleanses, validates, classifies and reports spend data across
disparate systems. The result is accurate, actionable information, with
item-level visibility across the enterprise.
Responsibilities:
. Designed and implemented applications using BizTalk Server 2013
Visual Studio 2012 and SQL Server 2012
. Worked with trading partners to understand the Business
requirements and prepared Technical Design Documents
. Co-ordinated with the off shore team to understand the workflow
. Worked on complex EDI mapping
. Used various functoids like scripting, value mapping, logical
functoids in the map
. Designed and developed 850 purchase order, 810 invoice and 855
purchase order acknowledgement transactions
. Installed and configured windows azure storage emulator v2.2.
Integrated Biztalk with Azure blob storage using WCF custom
adapter
. Used WCF Custom, WCF Basic-Http,HTTP and file adapters
. Created EDI party agreements for the header level mapping
. Used custom pipeline components for PGP encryption and PGP
Decryption
. Migrated applications from Development to QA, UAT
Environment: BizTalk Server 2013,SQL Server Management studio 2012, MS
Visual Studio 2012,Visio 2010, Windows Server 2008 R2, Windows 7,
IBM VAN, XML schemas, Xpath
Xerox Corporation, May 2013 to Nov 2013
Richmond, VA
Sr.BizTalk Developer
Virginia Medicaid program is administered by the department of medical
assistance services(DMAS). DMAS is one of the twelve state agencies under
the Virginia secretary of Health and Human resources. DMAS is the agency
that monitors Medicaid and the State Childrens Health Insurance Program
(CHIP) in Virginia. Medicaid was created to assist people with low income,
coverage is dependent on their eligibility.
. HIPAA CORE Operating Rules Phase I, II & III:-
Responsibilities:
. My responsibilities include developing the Orchestrations that
interfaced with the external Web Service applications.
. Installed and Configured Microsoft BizTalk Server 2010, Host
Integration Server 2010, SQL server 2008 R2, IIS, Visual studio
2010 on Dev machine.
. Worked with trading partners to understand the Business
requirements and prepared Technical Design Documents.
. Designed and developed various 5010X12 transactions 835 Claim
Payment,270 Eligibility Inquiry,271 Eligibility Response,276
Health Care Claim Status,277 Health Care Claim Notification.
. Processed both SOAP and MIME requests for all the transactions.
. Used HTTP adapter and WCF-WSHttp adapters to process the request
messages.
. Created Functional Acknowledgment (997/999) for all my clients.
. Designed and developed schemas for source and destination XML
messages.
. Integrated BizTalk with IBM Mainframe using HostApps adapter and
TI Manager of Host Integration Server 2010.
. Involved in Analysis, Testing and development cycles performing
multiple tasks throughout the project.
. Used SQL Adapter to access database in implementing Business
Process.
. Migrated applications from Development to QA, UAT.
Environment: BizTalk Server 2010,SQL Server Management studio 2008 R2, MS
Host Integration Server 2010,MS Visual Studio 2010,Visio 2010, Windows
Server 2008 R2, Windows 7, IBM Mainframe CICS, MoveIt Dmz, XML schemas,
Xpath
.
Aetna, March 12 - April 2013
New york, NY
Sr.BizTalk Developer
Aetna is an Insurance company, a sister company for Blue cross Blue shield,
which is most experienced provider of health care coverage, where in
company deals mainly in processing claims on healthcares which deals with
different EDI documents of HIPAA.
Responsibilities:
. Responsible for designing, developing and implementing applications
using BizTalk Server 2009, C#, .Net Framework 3.5.
. Revived Business requirements and prepared a Technical Design
Documents.
. Upgraded BizTalk Server 2006R2 environment to BizTalk Server 2009.
. Designed & Derived XSD Schemas Documents for BizTalk messaging.
. Used BizTalk Mapper for Mapping BizTalk XSD Schemas.
. Created transformation maps using various functoids such as logical
functoids, scripting functoids, String functoids, Value mapping
fuctoids, Database lookup funtoid etc.
. Modeled, designed, Business processes using BizTalk Server
Orchestrations.
. Designed and developed Correlated Orchestration.
. Created custom pipeline for encrypting messages.
. Devised BRE policies and Rules based on Typed messages.
. Used WCF SAP adapter and SQL for EAI.
. Implemented security privileges around SQL server.
. Created BAM Portal for business end users and managers to monitor Key
Performance Indicators (KPI), which measure progress toward a business
goal and information about the business process.
. Worked on Team foundation server.
. The Interfaces were Deployed in the Integration Server by creating MSI
and BINDING xml files and environment information.
. Necessary changes were done for errors after deploying in the
Integration Server.
. Documented the process for knowledge transfer.
Environment: BizTalk Server 2009, 2006R2, Windows Server 2003, C#, Visual
Studio.NET 2005, SQL Server 2005, ESB 2.0,TFS
CUNA Mutual Group / Payment Protection Calculation Services, Aug 2011 -
Feb 2012
Madison, WI
Sr. BizTalk Consultant/.Net Developer
All credit unions associated with CUNA Mutual Group deal with four major
transactions such as Charge, Refund, ReCalc and Adjustment. The PPCS Engine
that was created for this purpose uses the loan file which is sent by the
credit Unions and processes any one of the above mentioned transactions.
The PPCS Engine allows for Credit Unions to submit Charges in order to
calculate monthly premium charges for its members protected loans. Other
PPCS Process Transactions (PPCS PT) are also possible which can act to
reverse the existing charge, replace the existing charge or adjust the
existing charge. The PPCS Engine Enhancements are meant to automate the
PPCS Process Transactions (PPCS PT) is order that Credit Unions will have
fast and accurate posting file and CUNA Mutual Group employees will be
required to perform less and more focused manual intervention to the PPCS
Engine .
Responsibilities:
. Designed and implemented applications using BizTalk Server 2006, SQL
Server 2005 and .Net Framework in a B2B Integration Architecture.
. Migrated the code and continued development in Biztalk 2010 Server
using SQLServer 2008 and Visual Studio 2010 with a 4.0 .NET Framework.
. Obtained the inbound loan files from the WebService from a common drop
location which is constantly monitored by Biztalk.
. Collected the necessary data from the DB2 database by using the
filename of the incoming loan file.
. Handled external calls to the .NET assemblies, by referencing them in
the Biztalk application.
. Created parallel process to handle the various transactions such as
Charge, Refund, ReCalc & Adjustment.
. Handled general exceptions for all the scopes that was created for
each transaction.
. Configured the FILE and SQL adapters in the Biztalk admin console to
send and receive files to the respective locations.
. Strong developing experience using C# and .Net.
. Configured the WCF-Custom adapter once the code was migrated to
Biztalk 2010.
. Created the required deployment files through Service Center for
release to QA environment and helped in the QA cycle for defects
resolution and patch release.
. Deployed and delivered the builds for the various environments like
Dev Staging, QA, and Production environments.
Environment: BizTalk Server 2010/2006, C#, Visual Studio 2010/2005, SQL
Server 2008/2005, Windows Server 2003
HCR Manor Care, Oct 2010 - Jun 2011
Toledo, OH
Sr. BizTalk Consultant
All transactions from one of HCR ManorCare's major partners, Omnicare,
currently go through a manual approval process at the facility level where
each transaction is verified and the line items are approved. These are
then manually keyed into the Point Click Care (PCC) system. The Omnicare
and Point Click Care (PCC) Integration Project is a strategic initiative
for HCR Manor Care to integrate the transaction processing with the
sharing of information and data in-between the systems. This would involve
a significant cost savings to the organization. As part of the initiative,
the transactions from Omnicare to HCR Manor Care use HIPAA EDI format
through the BizTalk Server which is the middleware framework. The data from
the transactions are stored in PCC using an automation process. The goal of
the first phase is to create a BizTalk Application to integrate the
following:
. HCR Manor Care
. Omnicare
Responsibilities:
. Designed and implemented applications using BizTalk Server 2006 R2,
SQL Server 2005 and .Net Framework in a B2B Integration Architecture.
. Installed and configured BizTalk 2006 R2 in the development
environment.
. Obtained the inbound transaction files from the MSMQ by configuring
the MSMQ adapter.
. Reviewed the transaction file from HCR Manor Care and created the
HIPAA EDI schema for the inbound 270 transaction file used AS2
connectivity.
. Reviewed the file for Omnicare and created the EDI schema for the
outbound 271 transaction file.
. Created transformation maps for HIPAA transactions 270, 271, 276, 277,
837, 835,5010 using various functoids such as logical functoids,
scripting functoids, String functoids, Value mapping fuctoids, etc.
. Created the EDI receive pipeline to handle the batch processing using
the EDI disassembler and the EDI send pipeline.
. Configured MSMQ Adapters in the Biztalk Administration Console at the
Receive port to retrieve the inbound transaction files (270, 276) from
the queues.
. Created the SQL tables to be used as placeholder for historic data.
. Created stored procedures to handle insert and extract data for
interaction into the SQL Tables in the database.
. Configured the SQL adapter to communicate with the database.
. Also configured the FTP adapter to send the outbound transaction (271,
277) files to Omnicare.
. Created Test documents and test scenarios for testing the work flow.
. Performed functional testing and integrated testing of various stages.
. Created the load test and performance test plan for the testing of
HIPAA EDI file.
. Helped create test cases to cover all the scenarios.
. Analyzed test results and prepared test reports.
. Created the required deployment files for release to QA environment
and helped in the QA cycle for defects resolution and patch release.
. Deployed and delivered the builds for the various environments like
Dev Staging, QA, and Production environments.
Environment: BizTalk Server 2006, C#, Visual Studio. NET 2005, SQL Server
2005, Windows Server 2003
UBS, Mar 2009 - Oct 2010
Stamford, CT
Sr. BizTalk Developer
Residential Mortgage Clearing System (RMCS) is a Mortgage related
application that assists the UBS Loan Managers to provide title clearance
and closing on a mortgage. The application has several integration points
between systems serving different teams inside/outside the firm. Various
banks send the applications via web, fax or manual entry for closing and
Title search through enterprise service bus (cactis), which is built on top
of Microsoft BizTalk and .Net. During the Application Processing, vendors
are assigned for each application and based on Business Rules Engine,
vendors communicate back to the banks about its approval through system
automation. The front end of the application is designed in Asp.Net and C#
is used to develop middle tier and data tier.
Responsibilities:
. Designed, Developed and Created Schemas, Maps, Pipelines, and
Orchestrations.
. The Enterprise Service Bus controls the flow of loan data (using a
common message format) between seven in-house applications and five
external vendors.
. Made extensive use of cross-reference database and functoids, and
tools to migrate the cross-reference values.
. Involved in integration of this project (Cactis) with Vision (Title
info provider) using c# middle layer, Asp.Net and BizTalk 2009
. Involved in the integration of legacy mainframes AS/400 systems and
developed adapters enabling enlisting and exposing COBOL, DB2 and
other mainframe resources as Biztalk endpoints.
. Created C# "helper" routines using DOM, XPath Queries.
. Web Applications called BizTalk orchestrations published as WCF web
services.
. Designed and worked with WCF developers to create a data access layer
(DAL) for SQL2005 database which acted as the system of record for all
loans.
. All development and QA was done on virtual machines using VMWare.
. Actively Involved in Error Handling and Bug Fixing.
. Worked with four other BizTalk consultants on this project, and
mentored the customer's staff in BizTalk and WCF.
. Implemented patterns such as sequential convoy and advanced
correlation.
Environment: BizTalk Server 2006, BAM, BRE, Mainframes DB2, COBOL, DB2,
Windows Server 2005, Visual Studio 2005, Visual C#, SQL Server 2005, IIS
7.0 EDI / XML Schemas.
Fidelity Investments, Jul 2008 - Jan 2009
Boston, MA
Sr. Programmer Analyst
Fidelity Investments, is one of the largest mutual fund groups in the
world. Fidelity Investments manages a large family of mutual funds,
provides fund distribution and investment advice services, as well as
providing discount brokerage services, retirement services, wealth
management, securities execution and clearance, life insurance and a number
of other services. Involved in delivering various components for
configurations including analysis, design, development, unit test, system
integration test, HAT test support, partner integration testing and
deployment to production.
Responsibilities:
. Installed and configured BizTalk Support Environment.
. Involved in creating Software Development Life Cycle (Analysis,
Design, Development, Testing and Deployment) of project.
. Developed and Created Schemas, Maps, Pipelines and Orchestrations.
. Used BizTalk Mapper to establish the communication between the schemas
and various Functoids.
. Actively Worked with BizTalk Rules Engine (BRE), written Business
Process Rules and monitored business activity with BAM.
. Involved in writing Script/Custom Functoids based on various
protocols, used different adapters (SMTP, HTTP, and FTP) to serve
clients request.
. Implemented Custom Pipeline components.
. Involved in Error Handling to effectively and actively monitor the
business activities.
. Used Health and Activity Tracking (HAT) to track and view specific
events and messages.
. Developed Web Service Interface to submit the project requests and
approve the project requests.
. Extensively written technical specifications for various modules
according to the Microsoft specifications. Strictly followed the
Microsoft Application Development Standards and Quality Process.
Environment: BizTalk Server 2006, Visual Studio 2003, SQL Server 2005,
Windows Server 2000, ASP.NET, C#.NET, XML, Web Services.
Metropolitan Life Insurance, Jan 2007 - Feb 2008
Bangalore, India
.NET Programmer
This project facilitates Loan Originations and Loan Processing
functionality. This is a Web Based user interface, which consists of
different pages for New Loan Application, Authentication, Borrower-Cosigner
Information and Account Generation, Prequalification, and history Status.
Responsibilities:
. Analyzed the project and enhanced the existing application with new
functionality.
. Developed new user interface for new features and functionality to the
application using ASP.Net.
. Used VB. NET in the code behind page.
. Developed Functional and Data Access classes for all Web Server
controls.
. Designed and Developed Web forms using C#.NET.
. Implemented JavaScript.
. Developed UI using ASP.Net and Winforms.
. Used ADO.Net for data retrieving, querying, storage and manipulation.
. Used Microsoft SQL Server on Microsoft Windows XP and exist in the
Active Directory structure.
. Created stored procedures, triggers, views for data access and
manipulation.
. Extensively used Data grids, Data Tables and Datasets for Data
manipulation.
. Used XSL defined schema structures for XML files.
. Used JavaScript to validate the web page and loaded the content
dynamic in iFrames.
. Used Visual Source Safe for Version Control.
. Involved in GUI web Functional Testing using win Runner.
. Used SOAP protocol for Message Format.
. Used .Net Remoting to interact across application domains, processes,
and machine boundaries.
. Integrated various reports into the application.
. The reports were created using SQL Reporting.
Environment: Windows XP, Microsoft Visual Studio 2000, HTML, DHTML, Java
Script, C#.NET, VB.NET, ADO.NET, SQL Server 2005, IIS 4.0
Verusant Technologies, Aug 2005 - Dec 2006
Hyderabad, India.
Programmer/Analyst
The project was to design and develop a customer database. This system
helps the customer service representatives to perform all their duties
helping customers in assisting their problems and questions. This project
also helps the representatives in update/delete/modify customer profile and
also arrange for bill Payments.
Responsibilities:
. Extensively involved in requirements gathering and data gathering to
support developers.
. Involved in designing and of functional specifications for the
development of user interfaces.
. Extracted data for multi-dimensional analysis.
. Modifying the existing universes, adding new objects editing joins
mapping the existing objects with renamed tables.
. Created Hierarchies from providing drill down options for the end-
user.
. Creating new connections and editing existing to run the report in
different database test, development.
. Experienced with cardinalities, contexts, joins, and aliases to
resolve loops and verified.
. Generated number of reports on a daily, weekly and monthly basis using
Business Objects Report module.
. Experienced creating Data Marts using ETL functions and OLAP tools.
. Involved in designing of Entity Relationship Diagrams.
. Created tables, indexes, sequences, constraints and snapshots.
. Developed PL/SQL scripts to validate and load data into interface
tables.
. Fixed software bugs and interacted with developers to resolve
technical issues.
. Helped in writing proposals, documentation and training.
. Designed and developed a Generic Billing system for a
Telecommunication company.
Environment: Oracle 7.3.2, SQL, PL/SQL, Shell Scripts, Oracle Forms
4.5/Reports 2.5, MS Access, MS Excel
EDUCATION
B. Tech, Hyderabad, India, GPA 3.8/4.0