Sql Developer Resume Profile
Professional Summary
- 7 years of IT experience with emphasis on subject matter expertise on design, development, documentation and implementation of Web - based Applications, Enterprise Application Integration solutions using BizTalk Server 2010/2009/2006 R2/2004 and creating and validating Schemas, Maps, Pipelines and creating Orchestrations and handling .NET components in Orchestration.
- Expertise in Architecture, Design and Administration of BizTalk SOA Solutions.
- Extensive knowledge of Software Development Life Cycle SDLC methodology and Agile Methodology
- Having strong work experience in XML, XPATH, EDI/HIPPA and Web Services WCF using BizTalk Server
- Experience working with integration of BizTalk with SQL
- Extensive knowledge with various Adapters within BizTalk File, SQL/Oracle/DB2, SOAP/HTTP, FTP, SMTP, POP3 and WCF Adapters
- Exposure to various databases and to relational modeling and ability to develop stored procedures
- Expertise in working with various IDE's like Visual Studio 2010/20082005/2003
- Experience and knowledge with WSDL, XML Schemas, XSLT and Xpath
- Experience in Biztalk integration testing with Azure system
- Experience in unit testing of Biztalk integration
- Experience using TFS for check in/check out the codes and for Reporting purpose
- Expertise of consuming and publishing BizTalk Artifacts as Web Services and WCF Services
- Experience in using ESB and other integration tools with Biztalk
- Excellent communication and interpersonal skills coupled with fine analytical, technical leadership qualities
Technical Expertise
Data Formats Flat File, XML, XSD, XSLT, EDI, ANSI ASC X12, HIPPA EDI Transactions 834, 835, 837, 270, 271, 276, 277 Languages C, C, C, SQL, XML, XSLT Applications Microsoft BizTalk Server 2010/2009/2006 R2/2006/2004, JDEdwards WorldSoft,EnterpriseOne BizTalk Tools HAT, BAM, BRE, TPE BizTalk Adapters HTTP, File, SOAP, SQL, WCF, FTP, SMTP, POP3, MSMQ, EDI, HIPAA Accelerator, WCF Adapters Concepts Waterfall, Agile Database s MS SQL Server 2008/2005, IBM DB2, SQLite Application Server IIS, Tomcat Web Technologies Html, Web Services Operating Systems Windows 8 RC, Windows 7, Windows Server 2008/2003, XP Pro/NT/2000 Pro/98 and Red Hat Linux, Unix Application Tools Microsoft Visual Studio 2010/2008/2005/2003 , Eclipse 3.2 Configuration Management TFS TFVC, VSS Visual source safe Packages MS Office, VisioProfessional Experience
Confidential
Senior BizTalk Developer
Responsibilities:
- Developed BizTalk interfaces from scratch to the end, from Arcitectural design through documentation.
- Created Scripting functoids using Inline C and External C and created Custom XSLT for maps.
- Created a Schedule adapter and C code to create tasks for the Schedule adapter to automate a call WEBSERVICE at regular time intervals with the given parameters.
- Designed and developed orchestration with EMAIL FUNCTIONALTY using SMTP Adapter and SQL database connectivity.
- Debatched FlatFiles with pipelines and created Header Schema to remove the headers from FlatFiles.
- Conversion of XML message to encoded Strings to be sent to SQL dabtabase and decoding of same when retrieved from database.
- Designed and created Custom Pipelines.
Confidential
BizTalk Developer
Responsibilities:
- Developing BizTalk Applications using BizTalk Enterprise Service Bus ESB 2.1 Itineraries, BRE Resolver.
- Develop WCF Web service to expose Cobol based Assist services to .Net based Web Application.
- Consuming Assist Application services and expose the services through BizTalk Hub.
- Developed Business Rule Engine BRE Policies.
- Importing and Exporting BRE from BizTalk Message Database.
- Mapping Complex Federal Documents.
- Implement Complex Mapping using XSLT.
- Batching and Debatching XML messages.
- Implementing Logging and Tracer in Orchestration to track the each flow of orchestration.
- Handling exceptions.
- Helped fellow BizTalk developers working in tight deadlines in the application.
- Discuss with Trek Lead and Business Analysis to understand the design and functional requirements whenever we get new task.
- Daily Reporting at the end of the day about Task Status.
- Validate defects before Codes are sent to Dev Environment for further testing.
- Validate Codes get Checked in at the end of the day to avoid code conflict in TFS.
- Help Team mate when there is Work Deadline arrives.
- Co ordinate other Functional Team, Tester and Developers.
- Environment: BizTalk Server 2010, Microsoft Visual Studio 2010, WCF-Custom adapter, Windows 7, SQL Server 2008, Soap UI 4.5.1, C .
Confidential
Senior BizTalk Developer
Responsibilities:
- Responsible for interacting with vendors/customers, exchanging EDI policy document, answering related questions like input/output formations, transmission methods, satisfying the requirements of customers in outbound transactions/acknowledgments.
- Building a relationship between different modules like Purchase Order/PO, PO acknowledgement, Invoice and functional acknowledgement .
- Support maps, orchestrations to map inbound/outbound EDI transaction sets to XML and native ERP format.
- Developed custom .NET classes to execute stored procedures to extract/update data in the backend SQL Server.
- Support for testing and deploying BizTalk EDI applications.
- Developed Schemas, Flat File Schemas, Maps, Pipelines, Orchestrations required for the project.
- Worked on Envelope Schema, Document Schema, and debatching of files.
- Worked mainly on SQL, FILE, SMTP, SOAP, WCF adapters.
- Wrote the SQL store procedures for high transaction data to be utilized by SQL adapters.
- Wrote C .Net modules to be called from BizTalk.
- Worked with Business rule engine.
Environment: BizTalk Server 2009,2010, Flat Files, XML, Web services, Microsoft Visual Studio 2008/2010, C .Net, Windows Server 2003/2008, Business Rules Engine, MS SQL Server 2008
Confidential
BizTalk Developer
Responsibilities:
- Designed and implemented applications using BizTalk Server in a SOA Framework Architecture
- Installed and configured BizTalk Server in the QA non-clustered and staging clustered environment
- Created the required deployment files and release notes for BizTalk Server Production deployment and gave a demo of the same to the Change Control team which facilitated the necessary sign offs for Staging and Production Deployments
- Involved in supporting Production Support Development team third level support and helped identifying the problem in a production itinerary due to a data type mismatch in ongoing transactions and some intense issues logged tickets with Microsoft support team
- Was part of the architecture team that reviewed the Enterprise Architecture Document for the overall initiative
- Worked with WCF custom Adapter
- Created a detailed design document for the Integration Application which involved the overall Architecture and the SOAP setup
- Collaborate with the Operational business units to assess, design and maintain online reference materials on SharePoint
- Designed and created a custom pipeline component for the zipping and unzipping of outbound/inbound documents
- Created a custom C component for cleansing of the SOAP message before sending the message
- Extensively used XSLT scripting functoids for changing existing complex coded mappings
- Documented the release notes for the deployment of the Integration interface to the various environments like QA, Stage and Production
Environment: BizTalk Server 2010, C, Visual Studio. NET 2010, SQL Server 2008 R2, Windows Server 2008
Confidential
BizTalk Consultant
Responsibilities:
- Created Custom Pipeline components for dynamically change the file name and decrypting messages.
- Used XPath to spilt large XML files for creating small individual message.
- Used call orchestration in Parallel convoy to call all web services simultaneously.
- Implemented Integration patterns like scatter, gather.
- Consuming java based Web Services in Orchestration.
- Integrated BizTalk application with planet press for .PDF form generation.
- Used MQ Series Adapters for receiving Files.
- Created external assembly in C for Audit logging.
- Used inline XSLT in scripting functoid for complex mapping.
- Created WCF services and configured WCF Adapter to consume WCF Web services.
- Used start shapes to update database without affecting other process.
- Created Orchestrations to dynamically send emails using SMTP Adapter.
- Installed and configured BizTalk 2006 R2 and SQL Server 2005.
- Implemented Robust Error Handling for failed Long Running transactions
- Created Query with T-SQL and used with SQL Adapter to Insert, Update individual transaction information in the Database.
- Created MSI Installation Packages and Deploy BizTalk applications using Environment Specific Binding Files for different staging environments like Development, UAT, QA and Production
Environment: BizTalk Server 2006 R2, Windows Server 2003/R2,C, Microsoft Visual Studio .Net 2005 with Microsoft .Net Framework 2.0, WCF,T-SQL, JSP, TFS, Web sphere MQ, IBM DB2,IBM mainframe, JSP .
Confidential
IT Tech Support
Responsibilities:
- Troubleshooting of escalated technical calls dealing with link related problems.
- Performed functional testing.
- Worked with various testing on routers, modems based on ADSL 2 and ADSL 2 technology.
- Have the knowledge of IP Addressing.
- Deal with various DSLAMS as providing the connection on DSLAMS.
- Have accessibility tools for creation of PVC, Static IP Routing and Port Binding.
- Given excellent support in setting up Desktop/Laptop, LAN, Wireless Networks, applications and computer imaging.
- Knowledge and experienced with support in Lotus Notes eMail Support, Network Printing Issues, Video Conferencing, Windows 2000/XP, MS Office.
- BizTalk Server SQL Server EDI EDI/HIPPA BizTalk Server SQL Server EDI EDI/HIPPA
- BizTalk Server SQL Server EDI EDI/HIPPA