Business Analyst /service Analyst Resume
Katy, TX
SUMMARY:
- More than 15 years of IT experience with 10+ years of working with SOA and eCommerce tools with XML and Middleware products & 5+ years with Data Analysis and similar experience with EDI translator products.
- Responsible fordefining, analyzing and documenting, user requirements, procedures, problems and assistingwith design efforts to offer new solutions or value propositions tocustomers, to improve existing business processes and support of coreorganizational functions and business processes.
- This includes gathering and analyzing data in support of business cases,proposed projects, and systems requirements to develop and documentrecommended solution options. As a Business Process Analyst is alsoresponsible for managing customer relationships and ensuring success ofthe customer projects. Apply communication,analytical, and problem - solving skills to help maximize and quantify thebenefit of IS system investments for the business units.
- Development of business processes to facilitate the implementation and support of web based applications.Involved in creation of Functional Specification Document (FSD)/Technical design documents.
- Interacted with internal users and customers to learn and document requirements that are then used to produce business requirements documents.
- Managed the balance between business requirements and user expectations, while being a liaison between users and technologists to drive requirements to design.
- Responsibilities included business process development, project work, troubleshooting and resolution of issues efficiently; identified areas of improvement, testing.
- Experience includes multiple file formats such as XML/IDOC/EDI/MISMO/Flat File (9 years), analyzing and working with electronic payment processing (credit card; 2 years), writing use cases (6+ years), webMethods, DataPower XI 50 Contivo mapping technologies (7 years), SQL (6 years), MS Office (9 years), Incident/Problem/Change tools (9 years), CVS (1 year), and ClearQuest (2 years) ReqPro (2 years), XMLSpy (15 years).
- Working knowledge of TOAD & SQLNav4 database management tools.
- Worked with IGNITE tool for Soap based webServices and RESTful API Services development and management and Swagger Editor for JSON validation.
TECHNICAL SKILLS:
Requirement Gathering & Designing Tools: Rational Requisite Pro, Enterprise Architect, MS Visio, Rational Rose.
Web Services: XML, XSD, SOAP, WSDL, Apache Axis, SAML, OASIS, OAGi
SOA middleware: webMethods 7.x, Contivo, Mercator WTX, Ignite2.0
DBMS: Oracle 9i/10g, SQL Server.DB2, MSAccess, MySQL
ERP: SAP MM/ SD Functional
Mark up languages: HTML, XML
Tools: MS Office, MS Visio, ReqPro, Eclipse IDE, SVN, WinCVS,Toad, SQLNav4, XML Spy, ClearCase,ClearQuest etc.
RELEVANT PROJECT EXPERIENCE:
Confidential, Katy, TX
Business Analyst /Service AnalystTechnology: Sterling OMS, webSphere Commerce Server, WAS, MB, MQ, SOA with IBM Middleware stack
Responsibilities
- Attended daily scrum meetings with team members wherein contributed inputs and updated the team with activities performed on previous day and the actions to be taken n the same day.
- Explored and studied pre-existing project documents and artifacts in shared location on network.
- Understood the project architecture and ongoing development tasks for Sterling OMS and high level Webshere Commerce server.
- Participated in conference calls and live meetings that were invited for discussion and reviews.
- Identified new development work and documented requirements as JIRA Issues/ tickets.
- Visualized implications and provided solutions and recommendations and created user stories, business rules, facilitated requirements gathering sessions, documented requirements, with necessary business analyst tools.
- Quickly identified the information needed to evaluate new business situations and collected / organized appropriate quantitative and qualitative information.
- Arranged priorities, met deadlines, and managed project’s activities.
- Prioritized backlogs and moved them to the next sprint.
- Based on Agile development methodology, user stories, tasks and sub-tasks were created/updated in JIRA.
- Process steps for updated Tlogs flow and its test scenario was documented and the team tasks were coordinated to evaluate the impact on downstream system by removing the flow to the Cardinal system.
- Performed as a liaison between business and technical teams to ensure business needs are well understood, documented end-to-end process and delivered as part of a high quality solution.
- Assisted team members in development and support of products, services and solutions.
- Performed independent decisions with review in one or more of the following areas: Requirements Development, Data Analysis, Client Support and Quality Control.
- Collaborated with subject matter experts (SME’s) and solution architect to translate business requirements to technical specifications and user stories for implementation.
Business Analyst /Service Analyst
Confidential, Mason, OH
Technology: SOA with IBM Middleware stack DP XI52, Oracle 9i/10g, SQL Server, webSphere WAS, BPM, MB
Responsibilities:
- Worked with this Healthcare Insurance Company for approx. 4 .5 years on 40+ Small Medium and Large size SOA Enterprise Application Integrations projects using Soap based webServices for IBM DataPower devices and RESTful API based Services for Apigee Servers.
- Created user stories, business rules, flowcharts, facilitated requirements gathering sessions, document requirements, and withnecessary business analyst tools.
- Interpreted the data, analyzed results using statistical techniques and provided ongoing reports.
- Developed and implemented the most efficient and cost-effective solutions.
- Developed and maintained SQL reports using Microsoft SQL Reporting Services.
- Responded, identified, researched, and resolved reporting, database or related system performance problems with internal and external customers.
- Performed as a liaison between business and technical teams to ensure business needs are well understood, documented end-to-end process and delivered as part of a high quality solution.
- Communicated with a variety of groups within a solution team, offering feedback and guidance to ensure solutions meet the clients' business and functional needs.
- Worked with clients to define and documented requirements for new and existing products, services and solutions.
- Worked as liason between the technical team, internal and external users and clients.
- Assisted team members in development and support of products, services and solutions.
- Performed independent decisions with review in one or more of the following areas: Requirements Development, Data Analysis, Client Support and Quality Control.
- Collaborated with subject matter experts (SME’s) and solution architect to translate business requirements to technical specifications and user stories for implementation.
- Associated with customers/users to provide detailed acceptance tests for the requirements. Provided User Acceptance QA plan for test scripts. And Supported QA/Performance tests with corresponding teams.
Support Engineer & Business Analyst
Confidential, Seattle, WA
Technology: Contivo mappings,XML Interface updating and automated testing
Responsibilities:
- Amazon Sellers use Excel (flat-file) and XML Feeds and Reports to manage a high volume of listings and sales on Amazon. Worked as support engineer with strong XML skills.
- Facilitated Joint Requirements Sessionsfor eliciting business requirements.
- Analyzed the high level requirements and documented the functional specifications.
- Created Use Cases, Activity, Sequence and Wireframe Diagrams using MS Visio.
- Mapped host data fields to the Webservices elements and conducted gap analysis for the missing fields.
- Designed the data models for user interfaces (stubs and skeletons) and WSDL for SOAP calls to make web service calls
- Integrated the rules engine using web services.
- Assisted in development of client framework. The framework is being used in production on multiple applications within the Enterprise environment.
- Worked with engineering teams on the delivery of new templates to support ongoing category expansions. The work involved generating the new templates, creating the appropriate Contivo mappings and ensuring automated testing created and any issues discovered by such testing is addressed.
- Worked having good familiarity with XML and Excel with solid communication skills with internal stakeholders for clarifying requirements.
- The VLA team is part of Merchant Technologies, responsible for the development and operation of Amazon’s selling platform and used by more than a million sellers worldwide.
- Worked well in a fast-moving team environment and was able to juggled with many tasks and projects.
- Experienced working with Contivo for data transformation and VB skills.Worked with XML, XSD and XSLT and Excel skillsets.
Confidential, Phoenix, AZ
Data Integration Designer/Contivo AnalystTechnology: webMethods7.1 Services
Responsibilities:
- A This project aims Confidential integrating the Business documents (EDI, XML) with the mainframe system and also Partner data using Trading networks to exchange between partners.
- Defined Trading Partner Profiles, Document Types, Processing Rules and Trading Partner Agreements (TPA) in Trading Networks.
- Developing Flow Services with necessary Mappings, Validations, and Business Rules for Inbound and Outbound Interfaces.
- Defined mappings for various EDI Transactions like 850, 855, 810 and 997.
- Involved in implementing AS2 communications setup with Trading partner for EDIINT.
- Developed mapping routines to Map incoming XML to a canonical document and deliver it to a queue and to map from a canonical document to outbound XML and deliver it to the customer.
- Involved in transformation and representation of XML files using XPath and XSLT.
- Involved in configuring the setup for cXML PunchOut Sessions via webMethods.
- Developed process models to implement the flow of the order in order fulfillment process using webMethods Modeler.
- Configured and Developed SAP Communicaitons for the R/3 system.
- Managed packages and services, which includes tasks such as activating/deactivating services, copying packages, and updating services and/or packages as necessary.
- Checked for expiration of client certificates and importing new client certificates and mapping it to users.
- Suggested and used X server to connect from Unix Box to configure GUI Adapter an Development box.
- Developed services to process incoming IDoc’s from SAP, mapping services to translate from IDoc to XML format and also configured routing rules.
- Configured MQ Adapter for connecting with MQ Series instances and listening notifications using webMethods Administrator.
- Developed services to process messages put on MQ queues by applications like OrderMax, Broadvision.
- Actively participated in migration of code and files from webMethods6.1 to webMethods7.1 server and assisted in testing the functionality on the new platform.
Environment: SAP R/3 4.6 Adapter, WebMethods Product Suite 7.1( Integration Server, Broker, Developer, Monitor, Modeler, Trading Networks Console), MainFrame, Gentran, WebSphere MQ Adapter 3.0, XML, cXML, xCBL, deXML, INOVIS, GXS, Sterling commerce, Commerce One, Unix.
Data Integration Designer/XML Schema Designer
Confidential, Portland, ME
Technology: XML Schemas, XML Canonical Data Model, SOA, WSDL
Responsibilities:
- Designed and developed XML Canonical Data Model for the Enterprise.
- Created XML Schemas for Batch Process using FTP Protocol for consolidating data between legacy GSA database and new Oracle SORs and Web Services for B2B integration using HTTP/ HTTPS Protocols between Siebel application and ODS/DW SORs.
- Interacted with Business and created the XML Schemas for message based services including electronic payment processing, with credit cards.
- Validated Schemas and the WSDLs by the W3 standards and ensured their suitability for consuming into the SOA environment.
- Created XML test data and validated it with corresponding schemas.
Environment:XML Schemas, XML Canonical Data Model, SOA, WSDL
Data Integration Designer/Contivo Analyst
Confidential, Dallas, TX
Technology: SharePoint, XSD schemas, WSDL, Contivo Analyst, TIBCO iProcess, CVS
Responsibilities:
- Created the project related High Level Design document and Detail Design Document and uploaded them into SharePoint Server location for the corporate designers and developers
- Attended conference meetings for business requirements and Solution Approach documentations.
- Performed release level tasks of moving forward the existing Version Proxy Maps and upgraded the maps by running the script and changing the map titles to new version.
- Created process flow diagrams using TIBCO Business Studio for integrating the WalMart retail application SOR with the Device Activation and Billing servicing system SORs.
- Worked in aService Oriented Architecture (SOA) environment and developed data mapping for business process using interfaces from multiple systems of records for consolidating the data by using the enterprise level Canonical Data Models.
- Maintained and updated Data model according to the naming standards and grouping by the functions.
- Created XML schemas, WSDL and validated using XMLSpy and created mapping for request/response schemas using HTTP Protocol, and generated corresponding java transforms using Contivo Analyst 3.11.2.1.6 and checked them Into CVS which is the version control server for storing the code files.
- Created TIBCO Business Process Models for business cases using TIBCO Business Studio and created XPDL files for deployment into TIBCO iProcess Engine Environment to provide the technical workflow solutions for business.
- Attended meetings and interacted with the business and IT team members for successfully implementing the Business Process Models into automated workflow solution.
- Created Interface Specification document for corporate developers.
- Created many new Web Services related entries in the preexisting WSDL file.
- Created business use cases for the testing team.
- Participated in interface impact sessions to identify affected data elements and systems.
- Participated in requirements sessions to study/analyze the interfaces impact.
Environment: SharePoint, XSD schemas, WSDL, Contivo Analyst, TIBCO iProcess, CVS
Confidential, Reston, VA
Data Integration Designer/Contivo AnalystTechnology: SOA, XSD schemas, WSDLs, XMLSpy, MapForce, WebMethods 6.1, DataPower XI 50
Responsibilities:
- Worked in a Service Oriented Architecture SOA environment and developed data mapping for interface requirements with corporate standard Canonical Data Model
- Created DataPower XI 50 compliant services using Contivo Analyst and deployed and tested them on DataPower XI 50 Environment.
- Generated application design document for interface developers using DataPower XI 50.
- Maintained and updated Data model according to the naming standards and grouping by the functions.
- Created XSD schemas, WSDLs and validated using XMLSpy and MapForce and created mapping for request/response schemas using HTTP/REST Style Protocols, XSLT using Contivo Analyst 3.11.2.1.6.
- Participated in interface impact sessions to identify affected data elements and systems.
- Participated in requirements sessions to study/analyze the interfaces impact.
Environment: SOA, XSD schemas, WSDLs, XMLSpy, MapForce, WebMethods 6.1, DataPower XI 50
Contivo Mapping Analyst
Confidential, Des Moines, IA
Technology: Contivo3.11.x Mapping Studio, Contivo Interface Modeler, Contivo EIM Server Repository & Semantic Dictionary, IBM Rational Clear Case Source Safe, Altova XMLSpy2007 applications and MISMO based wfXML2.1 standard interfaces.
Responsibilities:
- Changed and Reviewed SIM services data and content data analysis tasks such as data mapping, gap analysis, mapping document conversion, XML Schema (XSD) updating, XML Schema conversion to Excel spreadsheet formats.
- Created the documents for data mapping and transformation work done between the SIM services based XSD schemas and the database format documents.
- Performed IST/UAT and generated stand alone Java transforms for the Contivo maps.
- Supported Service Oriented Architecture (SOA) Solutions within the Wells Fargo Lending Business Services (LBS) Technology platform, using Contivo3.10 Mapping Studio, Contivo Interface Modeler, Contivo EIM Server Repository & Semantic Dictionary, IBM Rational Clear Case Source Safe and Altova XMLSpy2007 applications and wfXML2.1 and MISMO2.3.1 Industry standard Documents for the Mortgage Industry for lending and Title documents..
Environment: Contivo3.11.x Mapping Studio, Contivo Interface Modeler, Contivo EIM Server Repository & Semantic Dictionary, IBM Rational Clear Case Source Safe, Altova XMLSpy2007 applications and wfXML2.1
Confidential, Washington, DC
Data Integration Designer/Contivo AnalystTechnology: Webmethods 6.1
Responsibilities
- Created the weMethods6.1 integration package in webMethods Developer for consolidating the VRS vendor registration system data with the PeopleSoft ERP central Information system.
- Resolved the defects in the existing integration code for integration between the web hosted Vendor RFQ submitting application and the PeopleSoft ERP. The web application was also a webMethods server and this was a B2B integration.
- Provided overall technical leadership for webMehods6.1 as a Lead webMethods Developer, in the development of new and support (including production support) of existing integrations. Also worked as a member of the development team serving as technical expert in flow services implementation and testing.
- Performed configuration management activities for the project including testing, component migration, staging plans, and sign off for component migration (Debug/Development to QA to production).
- Maintained expertise in the business systems and integration interactions. Completed estimates and impact analyses for business requirements.
- Participated in technical reviews with the systems integration Manager. Managed defects, issues, design changes, etc.
Environment: Webmethods 6.1
WebMethods6.1 Developer
Confidential, Phoenix, AZ
Technology: Webmethods, Trading Networks6.1 components, PL/SQL, IDOC
Responsibilities:
- Designed the Integration architecture for integrating and synchronizing the databases using the Canonical udms with OAG7.21 Open Application Group Integration Specification standard for publish/Subscribe technique with webMethods Brokers and RosettaNet V02 02 XML based standard for transporting the business messages over the Internet using the Trading Networks6.1 components for B2B partner integration.
- Migrated the existing packages to new platform and Created New integration packages and Flow services in webMethods6.1 and enhanced the existing packages to meet the specific integration requirements between the Oracle9i ERP application and the legacy databases for Confidential Office and Confidential other distributed locations.
- End to end testing for the packages using the PL/SQL for insert, update and delete commands on source database tables and verification for changes to corresponding target database tables was conducted. In this process, the logical mapping compliance and data definition documents guidelines were also confirmed.
Environment: Webmethods, Trading Networks6.1 components, PL/SQL, IDOC
Confidential
WebMethods6.1 Developer, Cincinnati, Ohio
Technology: WebMethods6.1, JDEdwards EnterpriseOne, Oracle DBMS
Responsibilities:
- Developed new integration packages in webMethods6.1 and enhanced the existing packages to meet the specific integration requirements between the JDEdwards EnterpriseOne ERP application and the Common Data Location CDL Oracle database for consolidating the data Confidential Confidential .
- Interface development was done by using the Wm Message Broker and publish/subscribe technique and by mapping to canonical document types.
- Performed end to end testing for the packages using the PL/SQL for insert, update and delete commands on source database tables and changes to corresponding target database tables was confirmed .In this process, the logical mapping compliance and data definition documents guidelines were also verified.
- Wm Document Tracker tool was used for the documents published through the Broker.
- Using the wMAdministrator the Integration Server and the Broker configurations were updated. The new packages were enabled and reloaded. The adapter services and Notification services were enabled. The JDBC connections to the databases were created. The xpi adapter for PeopleSoft EnterpriseOne was installed and enabled.
- The updated and new packages were published using wM Administrator in the Development Environment and migrated to Test, Acceptance and Production environments.
- The stress test and performance test was done for Integration server by using the large file sizes.
- Logging and error handling feature was tested for reporting errors and messages. The error log database was queried using the SQL statements and verified for expected loggings.
- Analyzed the Logical design documents and Technical requirements documents and created the corresponding physical design documents for the above integration initiatives.
- The new and updated packages were checked into PVCS for source control and maintaining the version.
Environment: WebMethods6.1, JDEdwards EnterpriseOne, Oracle DBMS