SUMMARY:

• 8+ years of professional experience in business analyst in multiple domains like retail, CPG, healthcare, pharmaceutical and manufacturing.
• Strong experience in implementing agile scrum methodology in application development and participated in sprints and stand ups.
• Acted as liaison between developers, product owners and applications end - users.
• Assisted with overall team management, communications and maintaining positive client/consulting team relationship.
• Experienced in processing XML messages with exceptions and performed message transformation, translation, validation for incoming messages, XML file lookups, database inserts.
• Worked in all the phases of software development life cycle including planning, analysis, design, development, testing and maintenance.
• Identified issues encountered by the end-user, troubleshoot and resolved the issues.
• Skilled in preparing business cases, business requirement documents, use cases, technical specification documents, test plans, test scripts and software development plans.
• Analyzed and optimized data governance, quality, and security.
• Used JMS and IBM MQ to read/browse/put messages in XML format from/to a queue.
• Strong analytical, interpersonal, problem-solving and communication skills.
• Good programming skills in designing and analyzing of multi-tier and distributed applications using Java, J2EE, HTML, XSLT, object oriented methodologies.
• Designed, analyzed and tested J2EE applications as SOA based Web Services using Eclipse and IBM Rational Application Developer 7.0

TECHNICAL SKILLS:

Programming Languages: Java, SQL, PL/SQL.

Web Technologies: XML, HTML.

Operating Systems: Windows, Unix.

Source Control: CVS.

Database Technologies: Oracle 10g/11g, SQL Server, IBM DB2 9.1/9.7.

Methodologies: UML, Waterfall model, Agile

Others: Microsoft Visio, Excel, Notepad++, Word, TOAD, Putty, WinSCP.

PROFESSIONAL EXPERIENCE:

Confidential,Battle Creek, MI

Global PIM Business Analyst

• Managed team of contract developers
• Maintained and verified master data for products and websites that resides in a MDM system across many brands and countries.
• Worked with e-Commerce, IT, marketing, nutrition, and digital agency partners around the globe.
• Created and maintained user access for the portals and STEP workbench for different users in different roles globally in MDM console.
• Hands on experience in all of the functionalities of STEP application and LANSA.
• Created and maintained attributes, attribute groups, classifications including websites for Confidential ’s globally using the STEP workbench and agency portal.
• Created/edited/deleted product master data in PIM (MDM system) using the inputs provided by the global teams.
• Coordinated conference meetings and calls during and after work hours to provide input and resolve MDM system related issues with digital agencies from other regions across the world.
• Worked closely with agencies worldwide to resolve/troubleshoot any MDM system issues that are raised via At Task tickets, JIRA tickets and implemented creative solutions.
• Helped the team to gather product data from different business units and delivered that data to the retailers.
• Created and designed technical flow charts, process diagrams, and test strategies.
• Experienced in interfacing with data providers to develop and/or enhance product content and information gathering processes
• Experienced in Unix to troubleshoot XML’s that interface between MDM System and downstream systems.
• Experienced in providing inputs to maintain the data in MDM system and also ensure that the data being provided is compliant with company’s data governance and security policies.
• Responsible to work with global teams in gathering business requirements.
• Identified and implemented robust improvement methods within data management processes, related to MDM system and Agency Portal
• Maintained data accuracy and timeliness, which impact supply chain and sales effectiveness, financial performance of the business, and customer perception through on-time delivery and product data quality.
• Have good knowledge/experience with GS1 specifically focused on the use of the GLN, GTIN and the GDSN

Environment: STEP 6.0(Workbench, portals and Content Matrix), PIM (MDM), LANSA, Unix 9.7, XML, XSL, XSLT, AT Task, JIRA.

Confidential, Minneapolis,MN

Business Analyst

• Technical and functional understanding of the interfacing modules.
• Involved in different activities such as design, deployment, unit testing and test case scenarios creation.
• Designed, developed and implemented business rules, Endpoint Integrations for connecting to various other systems to provide solutions for MDM system using STEP.
• Created and maintained attributes, attribute groups, reference types, LOV’s and objects for a product using MDM tool.
• Very good understanding of gathering MDM requirements from the business users and implementing them using STEP application.
• Trained by STIBO in Workbench and Portals.
• Worked closely with product owners to introduce new integrations from external systems to Product Information Management (PIM) using Outbound and Inbound integration endpoints.
• Involved in designing and developing integration endpoints, business rules and workflows to integrate with other systems, to create an item/product and send it downstream applications.
• Good hands on experience with importing and exporting data from PIM.
• Organized demos and status meetings to track progress of the project and provided status reports to various business users within the organization.
• Helped product owners with effective tracking and communicating the risks at the earlier stage of the project.
• Worked with business team on the go live issues reported in production environment, reproduced them in the test environment and fix them based on priority.
• Performed system test, system integration test and performance test scenarios and provided feedback.
• Worked on different systems like IMN, PIM, and PRISM to integrate all the data and helped the data to flow through the integration layers and then to the downstream systems like Confidential .com, WCS and more.
• Designed, developed and reviewed project specifications, technical flow charts, process diagrams, and test strategies.
• Reviewed and analyzed existing business/system processes to provide solutions, enhance and improve.
• Participated in technical collaboration meetings and workshops to provide the project management team with periodical reviews on technical implementations, analysis and estimates as well as daily/weekly reports on task plan for project implementation.
• Removed critical blockages for system integration and user acceptance team so that deliverables can be met on timely manner.

Environment: STEP 7.0(Workbench, Portals, Smart Sheets), Unix, JavaScript, XML, XSLT, IMN, JIRA, Mainframe, PIM (MDM)

Confidential,Johnston, IA

Business System Analyst

• Designed and analyzed the requirements to build OAF screens for the customer to login to create/update/delete user profile and buy/order products online.
• Documented business process and requirements.
• Liaised with the IT team to build Custom OAF screens to create, update and delete records in OLFM module.
• Verified logic to create and update customer details, financial details and credit application details for phase -1.
• Analyzed custom logic to attach files for a party (Upload and download an image/Document). The logic can download or upload any kind of mime content type.
• Designed master detail page for party and address result tables, when a party (customer) is selected the address for that particular party is displayed in the result table below on the same page.
• Creatively designed a navigation page where the user is specified with the different types, directions and transportation in order to reach the party.
• Involved closely with the business team to get the feedback for all the OAF screens that are developed and made changes if necessary.
• Designed a remarks screen for the user to add or update remarks for a party or credit applications.
• Actively involved in the requirements phase.
• Designed, analyzed, verified, tested all extended screen in OAF at the client site.
• Worked on sub versioning to communicate with the other team members.
• Created functional and technical design documents for all the custom OAF screens.

Environment: SQL, Oracle Application R12, SQL Developer, Microsoft Visio, Putty, WinSCP.

Confidential,North Wales,PA

Business System Analyst

• TS utility for event offload: The main parameters for this utility are database environment, to get specific events between fromRecordTime to toRecordTime, and the directory to store these files. With the given parameters the logic is used to offload (retrieve) the xml files from multiple databases and write them to a file system.
• TS utility for event transformation: The main parameters for this utility are source directory, destination directory, from version and to version. According to these given parameters the logic works to parse the xml files from one version to another version that are either offloaded from the database or xml files that are in the file system using DOM parser. If it is the offloaded xml files, then the logic copies these files from source directory to destination directory and then parses the xml files.
• TS utility for event Generation: The main parameters for this utility are the product code, the highest quantity and the directory to store the generated events. This logic is uses these parameters and generates the events. It actually generates a sequence of serial numbers for a bunch of pills, cases, and pallets. Then it commissions each item and aggregate it to the higher level like case or pallet and then finally creates a transfer shipment with total amount of highest level like a pallet or a truck etc also including the to and from of business and physical location in the same xml message.
• TS utility for event submitter: The main parameters for this utility are the database, action to perform either reading from the queue or writing to the queue. This logic is used to read and write these xml messages to the IBM MQ queue.
• Designed and gathered requirements to build a SOA BPEL process to continuously monitor the MQ queues of two different versions and if there is an xml message in the one of the queue then it polls that particular xml message and parse it to another version and writes back to a destination queue that is specified.
• Provided performance tuning to the SQL queries for optimal performance.
• Actively involved with the database developers to write the required stored procedures, triggers, functions on the backend database Oracle 11g.
• Involved in the requirements gathering, design, and analyzing phases.
• Written all the functional design specifications as required for the projects.

Environment: IBM RAD 7.0, Web sphere application server 7.0, HTML, SQL, XML, Oracle database 11g, Microsoft Word, Visio, Putty, WinSCP.

Confidential,Adison,NJ

Business Analyst

• Designed and analyzed UI screens with JSF to provide interactive screens to display data for Provider module.
• Implemented client side and server side validations.
• Developed the business layer logic and created the functional documents.
• Designed, analyzed and tested message flows as SOA based Web Services using SOAP and http.
• Designed and tested JMS to pick XML file from IBM MQ series Queues that parsed xml documents using DOM parsers to get data.
• Liaised with IT teams to transform request messages from SOAP XML to the backend database tables based on the requirement.
• Helped performance tuning to the SQL queries for optimal performance.
• Worked on bug fixing and enhancements on change requests.
• Involved in creating the test scenarios with the QA team.
• Worked with QA team for testing and resolve defects.
• Strong experience in all the phases of software development life cycle including requirements gathering, analysis, design, implementation, deployment and support.
• Involved in documentation of the module and project.
• Interacted with team Members for code reviews and designing the database.
• Worked closely with department heads and project managers.

Environment: Websphere Application server 7.0, HTML, XML, Microsoft Word, Visio, Excel, Putty, WinSCP.