We provide IT Staff Augmentation Services!

Database Analyst Resume Profile

3.00/5 (Submit Your Rating)

PROFFESIONAL SUMMARY

  • Over all 7 years of IT experience, which includes 5 years in EAI middleware technologies like Microsoft BizTalk Server, in providing enterprise application integration, Business to business communication, Business Process Automation and application development, modeling in n - tier architecture.
  • Experience in all phases of software development life cycle SDLC and various project methodologies viz. Waterfall, Spiral, Agile, Prototyping etc
  • Microsoft Certified Technology Specialist in Developing Business Process Integration Solution Using MS Biz Talk 595 .
  • Worked on BizTalk server architecture concepts and artifacts such as Adapters, Pipelines, Schemas, Maps, Orchestrations, Send port groups, Role Links, context based routing, Publish-Subscribe messaging model.
  • Experience working on BizTalk Editor, Mapper, Pipeline designer, Orchestration Designer, Orchestration Debugger, BAM web portal, Business Rule Composer, web service / WCF publishing and consuming wizard and Tracking Profile Editor, MSI Export wizard
  • Familiarity with BizTalk Mapping and Orchestration Business Process Design and advanced concepts like BizTalk such as Security, Transaction, Compensation, Convoy and Scalability.
  • Hands on experience working with SOAP1.1/SOAP1.2/ WSDL and WCF publishing BizTalk orchestrations and schemas as webServices and also consuming web services
  • Experience working with various standards and data formats like EDI ANSI X12, HIPAA, HL7, Flat files, and XML / XSDs
  • Familiarity in preparing technical, functional and detailed design documentation.
  • Knowledge in and Worked in industries like Health care, medical industry, Supply chain and warehouse management, manufacturing and retail.
  • Good team player with excellent communication skills, interpersonal skills, keen analytical skills and strong organizational skills.
  • University of Maryland Eastern Shore- Office of International Programs Database /Application design Officer
  • Develop, produces and maintains structural design of application, and database using Content Management System

TECHNICAL SKILLS:

  • EAI: BizTalk Server 2010/ 2009/ 2006 R2/ 2006/ 2004, BAM, BRE, BizTalk
  • Administration and Installation and configuration
  • Databases: Oracle 9i, 10g, MY SQL, SQL Server 2005/2008/2008 R2.
  • Utilities: SQL Management studio, SQL Plus, SQL Developer, EMC, TOAD.
  • Operating Systems: Windows 2008/2003R2/2003/2000/NT/XP, DOS, Virtual PC, UNIX.
  • Data Formats: SOAP, HIPAA ANSI X12, EDI, XML, IDOC, FLATFILES, HL7
  • EDI Transactions: ANSI X, 820, 850, 855, 856, 860, 997, HIPAA 834, 270/ 271 etc.
  • Languages: SQL, T-SQL, PLSQL, ORACLE, C, C, JAVA, C .Net, ETL.
  • Web Technologies: WCF, SOAP, ASP.NET, XML, XSL, XSLT, X-Path, CSS,
  • VBScript, JavaScript, Servlets, JSP, HTML, DHTML, web services.
  • Tools: MS Visual Studio 2010/2008/2005, MS Project, Testing Tools Load runner

Work Experience

Confidential

BizTalk Consultant

The company provides quality health care products and services designed specifically to meet the ever changing needs of customers. Blue Cross and Blue Shield of Louisiana provide customers with a wide variety of medical including Medicare and Medicaid, dental, prescription drug Rx, and health and wellness insurance products and services for individuals as well as local and national employers. Working through its subsidiaries

Responsibilities:

  • Published WCF service to Call Back-end system.
  • Creating and Developing Schemas, Maps, Orchestrations, Configurations of various adapters
  • Customized default HIPAA 5010 ANSI X12 270/271, 278 EDI Schemas in BizTalk 2010, Maps and Orchestrations for Inbound and Outbound HIPAA Transactions.
  • Worked on complex XSLT in BizTalk 2010 Maps.
  • Implemented custom pipeline components.
  • Publishing Schemas to web service to handle web service requests with third party partners.
  • Created new BizTalk hosts and host instances for optimal usage.
  • Responsible for creating, moving MSI's and deploy to DEV, Stage, UAT, and production Environments.

Environment: BizTalk Server 2010, SFTP, HIPAA, XML, Web Services, UML, SQL Server 2008, Visual Studio.NET 2008,C, ASP.NET

Confidential

BizTalk Developer

WellMed Medical Management is a diversified healthcare company and health plan provider serving more than 87,000 patients and plan members. Project involves implementation of HIPAA EDI transactions for client with different partners and upgrading existing integrations to new partners introduced.

Responsibilities:

  • Coordinate activities which include gathering requirements for different partners of the client, documenting all the requirements and technical and functional details.
  • Installed and configured BizTalk 2009 server.
  • Implemented EDI transactions like 837 Claims Professional and Institutional, 834 Eligibility for different parties as per HIPAA compliance.
  • Created and configured party information for all the parties in BizTalk admin console.
  • Designed and developed complex Orchestrations using patterns like singleton, sequential convoy, parallel convoy, Split pattern and aggregator pattern for managing message throttle.
  • Developed mapping involving complex mappings and business rules. Extensively used custom inline C components and XSLT in mappings.
  • Extensively used Native BizTalk SQL Adaptor and WCF Custom SQL Adapter for communication with SQL Server 2008.
  • Developed Custom Pipeline components as per the requirements.
  • Developed SQL Triggers and Stored Procedures for archiving purposes.
  • Developed Vocabularies and polices for business rules using Business Rule Composer Tool..
  • Designed BAM Activities and Aggregations for different flows.
  • Worked on performance tuning of BizTalk server by enabling the BizTalk performance counters, when throttling situation was occurred due to the large 837 claim load.
  • Worked on HL7 transactions to process the Lab results.
  • Configured the BizTalk host instances and Adapters for Host.
  • Extensively worked on promoting code from development to other environments, Customized packages and deployed on multiple servers.

Environment: BizTalk Server 2009, .Net, C .Net, VS 2008, Oracle 10g, EDI Notepad, SQL Server 2008, T SQL, HIPAA 837, 834 1, HL7 2.X,.NET Framework, BAM, BRE.

Confidential

BizTalk Consultant.

Responsibilities:

  • Worked in Business requirements gathering, Business process flow discussions and Team meetings.
  • Authored BRD, Detailed design and High level Design document of the project, Forward Warehouse to reverse warehouse EDI transfers.
  • Worked with BizTalk 2009, Visual Studio 2008, Configured WCF SQL adapter, created parties in administration console etc.
  • Worked with EDI transactions 940 ware house shipment order, 856 advanced shipment notice, 944 warehouse shipment transfer advice.
  • Created parties as interchange senders and receivers, in administration console to work with EDI transfers.
  • Worked with various artifacts like mappings, custom pipelines, pipeline components, Schemas, complex Orchestrations for the business logic.
  • Configured adapter metadata to invoke the stored procedure schema to map 940 EDI and insert into SQL Database.
  • Developed custom functoids and pipelines using C .NET.
  • In the administration console worked with application event log, tracked all message events and process events and exceptions.
  • Configured various send and receive ports using WCF SQL, WCF Custom, and File in this project.
  • Worked with MSI files, Binding Files, involved in code migration between various environments.
  • Performed unit testing, System testing, integration testing and user acceptance testing in this project.

Environment: C .Net, BizTalk 2009, Visual Studio 2008, BRE, XML, SQL Server 2005, .NET Framework 3.5, Microsoft Visio, Windows Server 2008, EDI X12.

Confidential

BizTalk Consultant.

  • Working as a BizTalk Developer for developing and migrating existing EDI BizTalk Server 2006 R2 interfaces to BizTalk server 2009.
  • Migrated existing maps for Purchase Order 850, advanced shipment Notice 856 and Purchase Order change request 855 .
  • Working on new partner maps from Purchase order 850 to ORDERS05.
  • Integrated with SAP using SAP Adapter and mapped inbound transaction 850 to ORDERS05.
  • Developing new Invoice transaction 810 and developing map ANSI X12 810 to INVOICE01.
  • Designed complex orchestrations for execution of business process and Exception handling. Implemented BRE for business validations
  • Configured BAM activities and Aggregations in the BAM portal to view end to end messages. To view Received and Send messages through BAM custom implementation Portal. Create BAM alerts for failed messages.
  • Configured SOAP, MQ Series and SQL Adapter on multiple servers to handle real-time transactions.
  • Tracked Messages Flow, Orchestration and logged process exceptions to existing integration portal.
  • Published orchestrations and schemas as webServices and consumed webServices to know the supplier information and price details.
  • Thorough understanding of Service Oriented Architecture, SOA using webServices and SOAP Protocol.
  • Involved in database development for creating stored procedures, indexes, views, triggers in SQL Server 2005.
  • Handled exceptions in all BizTalk processes using common error handling orchestration and configured process to send alerts to System Admins.
  • Designed and created BAM reports for EDI 850,855,867,856 and 810 transactions and also logged exceptions data to BAM DB.
  • Involved in code migration between various environments and also performed unit testing, integration and End End testing for the developed process.

Environment: C .Net, BizTalk 2006 R2 / 2009, Visual Studio, HTTP, SOAP, webServices, BAM, XML, SQL Server 2005, VisualStudio.NET 2005,.NET Framework 3.5, Microsoft Visio, Windows Server 2008

Confidential

BizTalk Developer

Responsibilities:

  • Worked with the business Process and BA to gather business requirements.
  • Application architecture design and implementation.
  • Migration from BizTalk R2.
  • EDI to and from SAP transactions, Excel to SAP.
  • Built different Schemas, and mapped to and from EDI, IDOCs.
  • Applied advanced Web Service techniques such as customized SOAP headers, Array
  • Parameters and multiple existences of the same schemas etc
  • Used SQL, and File adapters and built custom pipeline components
  • Configured EDI adapter and managed EDI Parties for AS2, EDI transactions.
  • Involved in developing business logic layer and Data Access layer and developed custom C classes from XSD schemas to validate and serialize the XML based accumulator data from the web services.
  • Created ASP.NET web pages and wrote code behind pages using C and VB.Net.
  • Extensively used C for developing Custom Objects as per the requirements.
  • Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
  • Performed application documentation and provided technical support.
  • Tutored other developers on BizTalk.

Environment: C .Net, VB.Net, ASP.Net, BizTalk Server 2004/2006, FTP, BAM, EDI, SAP, SQL. File Adapters, XML, Web Services, SQL Server 2000/2005, Windows Server 2003, VisualStudio.NET 2005, Microsoft Visio 2003.

Confidential

Database Analyst and Developer

Responsibilities:

  • Created functional, technical and detailed design documentation.
  • Responsible for creating conceptual data model design using ER diagrams, logical database design and physical implementation of the database.
  • Implementation of business rules by applying necessary constraints, triggers, views, joins, sub queries, aggregate functions, grouping etc.
  • Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
  • Creation. Modification and testing of PL/SQL scripts to query and retrieve existing organizations Oracle database.
  • Created users, roles, responsibilities to provide database security.
  • Involved in optimizing SQL statements using Indexes and Hints.
  • Used SQL loader and external tables to load data from text files into the database.
  • Involved in writing complex SQL statements.
  • Created UNIX shell scripts to invoke the SQL scripts which are run daily.
  • Worked on Extract, Transform and Loading of the data, ETL processes.
  • Responsible to coordinate with customers, Business analysts and team members.
  • Performed unit testing, system testing and performance tuning to rectify errors and achieve accuracy of data.

We'd love your feedback!