Business Systems Analyst Resume Profile
North, ChicagO
SUMMARY:
- 8 years of professional experience as a Project Manager/Scrum Master/Business Systems Analyst/Business Analyst/Data Analyst in Pharmaceutical/Agriculture/State Government Agriculture Department /Retail/Healthcare/Insurance environments.
- Expertise in content management that includes understanding the business needs, defining a creative and useful software solution to the management, implementing and training the application to the user community.
- Identified the options for potential solutions assessed them for both technical and business suitability applied technical as well as organizational changes according to the new system.
- Experienced in analysis of complex business problems prioritizing, translating, organizing and documenting problem to the technical team.
- Highly proficient in analyzing requirements and developing product backlogs and requirement lists.
- Expertise in Requirement Analysis, requirement modeling using Unified Modeling Language UML and Object Oriented Analysis.
- Call center experience and hands-on Siebel CRM that optimizes various business related tasks by creating a seamless architecture by allowing an enterprise to perform and coordinate multiple processes over the internet and other channels.
- Experienced requirement elicitation techniques like interviews, brain-storming, document interface analysis and organizing sessions with Subject Matter Experts focus groups .
- Extensive experience in JAD and RAD.
- Hands on experience in Project Management while assisting Senior Project Manager.
- Assisted in project costing and coordination.
- Experience in writing test plans, reviewing test cases and mentoring QA teams.
- In-depth knowledge of conducting User Acceptance Test UAT , data quality checks using SQL, gap analysis and Requirement Traceability.
- Expertise in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence .
- Hands-on experience in working with Micro strategy Congo's, which are very flexible and intuitive reporting tools which facilitate creation of effective graphical representations of data and reporting.
- Participated actively in analyzing documenting requirements for the creation of business continuity plans that involve identification of critical business functions, documentation implementation that helps recover these functions in times of disaster, organizing a business continuity plan to ensure disaster recovery providing sufficient training to the team to make sure that the plan execution is in place.
- Expertise with supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
- Experience in writing Use Cases and producing Use Case Model, Analysis model, Behavior diagrams sequence diagrams, collaboration diagrams , and Class diagrams.
- Organized Joint Application developments JAD , Joint Application Requirements sessions JAR , Interviews and Requirement Elicitation sessions.
- Experience in Functionality Testing, User Acceptance Testing, Database Testing, Regression testing and Risk Based Testing
- Experience in assuring the software quality standards.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Extensive experience in verification, validation cross-functional testing and SDLC Process
- Excellent working experience with SQL Server
- Effectively use technology to increase profit, productivity, and competitive edge while simultaneously delivering significant reductions in cost of doing business.
- Analytical, methodical and process-centric approach towards the problems, identifying the root causes, corrective actions to meet short term as well as long-term business requirements.
- Exceptional interpersonal, communication, organizational and decision making skills.
- Experience in providing comprehensive post go-live training to business users.
Technical Skills:
- Operating Systems : Windows, Linux, Pocket PC, Win CE
- Servers : Citrix, Windows Server, SQL Server
- Databases : SQL Server 2000, SQL CE, MS Access, Sybase and Oracle
- Application development Tools :Visual Basic, Power Builder, eVB, .NET, Crystal Reports
- Languages : SQL, C, C , C JAVA, DB2
- Web tools : HTML, XML, MS Front Page
- Business Intelligence : Business Objects, Crystal Reports, Micro strategy
- Testing Tools : Test Director, Quality Center, Quick Test Pro, Load Runner
- Methodologies : RUP, OOAD, UML, RAD, Waterfall, Agile and Business/Data Modeling
- Business Modeling Tools : MS Office, UML, Rational Rose and MS Visio
Professional Experience:
Confidential
Project Manager/Business Systems Analyst
- With Accurate documentation
- In Perfect condition
- At the Right location
- On time
- In the Right quantity
- Deliver the Right item
- Develop an AbbVie Perfect Order Qlikview Dashboard which provides the percentage of orders that:
- The dashboard can be segmented by product, enterprise, region and affiliate.
- With the Perfect Order dashboard AbbVie management will have the greater abilities to measure the performance of its supply chain, identify opportunities to improve inventory, shorten cash-to-cash cycle times, and achieve greater assurance of supply.
- The project involved combining information from three different data repositories SAP BW, GT Nexus and VIVALDI and extracting all the necessary KPIs Key performance metrics through an external user interface design tool called QlikView.
Responsibilities:
- Performed the role of a Project Manager by leading the team, enhancing coordination among team members, ensuring smooth progress of the project by handling tough and delicate situations with diplomacy and ease.
- Also, performed the role of a Business Systems Analyst by driving requirement analysis, gathering sessions with the Business users, SMEs, Sponsors and other Stakeholders to sketch the process flow and elicit detailed level requirements.
- Exhibited great skill in acting as a liaison between the Business and the technical team.
- Followed an agile development process for system development.
- Successfully tested the application and ensured perfection.
- Exemplary performance in driving UAT sessions, providing user training and support.
- Proficient in using many tools and applications like JIRA, MS Project, MS Visio, MS Excel, MS Word and Share point.
Environment: JIRA, SAP BW, GT Nexus, VIVALDI, QlikView, Share point, MS word, MS Excel, MS Project, MS Visio, Windows 7.
Confidential
Scrum Master/Sr. Business Analyst Veg Crops
- My project in Monsanto revolved around the pre-commercial stage of a product development. This is an intermediate stage between the R D and commercial stages. The pre-commercial stage is further divided into phases 3B, 4A and 4B. The goals behind the project were:
- Monsanto is one of the world's biggest agricultural companies that deliver agricultural products that support farmers all around the globe. The mission that drives Monsanto is to teach farmers the way to enhancing production as much as they can while focusing on optimum utilization of limited natural resources.
- Building a portal that grants different access levels to various users and helps in Identifying and verifying disease claims across various crops/products by performing testing on them and recording test results to confirm which of the disease are possible so that remedial action can be planned to avoid them in the future.
- Optimizing the trials that are part of the 3B, 4A and 4B phases in the pre-commercial stage by enforcing standardization and optimization wherever possible and ensuring a better decision making process for those integral steps that do not lend themselves to automation.
Responsibilities:
- Performed the role of a scrum master and also a Sr. Business Analyst by driving discussions and brain storming JAD sessions with business users to sketch the process flow and elicit detailed level requirements.
- Followed a strict agile development methodology throughout the life cycle of the project.
- Performed an exemplary job in coordinating with the whole team and taking the project forward without any significant road blocks and show stopper issues.
- Expertise in content management
- Exhibited excellent team management and client satisfaction capabilities all through the project.
- Proficient in using many BPM tools like JIRA, Blue works live, MS Visio, MS Excel, MS Word and Share point.
- Appreciated for conducting very interesting and informative business user interactive sessions and a successful UAT towards the end of the project.
- Received accolades from senior level management for dynamism and gaining excellent domain knowledge and understanding.
Environment: JIRA, BPM tools, Share point, MS word, MS Excel, MS Access, MS Visio, ASP.NET 4.0, VB.NET Visual Studio 2012, NET Framework 4.0, IIS 7.5, SQL SERVER 2008 R2, HTML, XML, JavaScript, CSS, AJAX, Windows 7.
Confidential
Business Systems Analyst - Web forms
Confidential mission is to serve, promote, and protect the agricultural producers, processors, and consumers of Missouri's food, fuel, and fiber products. To support this mission the MDA functions as a licensing and regulatory agency, which requires them to create and process a large number of forms. At the time, all of the documentation was in paper format, and required staff to manually process forms, payments, and licenses. The main objective of this project was to modernize the process and make it convenient for customers to securely complete forms on-line, upload attachments, and make payments to MDA.
Responsibilities:
- Interviewed Business Users clients to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager, subject matter experts and development team.
- Followed Agile Methodology throughout the life cycle of the project.
- Proficient in creating UI specifications which make use of BPM notation, designing screen mock-ups using MS visio tool, test case documentation and many more requirement analysis and documentation based tasks and conducting reviews with system and business users.
- Expertise in the use of BPM designing tools like MS visio and Rational Rose which are used to design screen mock ups, flow diagrams, UML diagrams like Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collaboration Diagrams, Database ER diagrams and many others.
- Prepared UI specifications including screen prototypes and mock ups after the collection of Functional Non-functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
- Continual interaction with business and system users in order to facilitate the management of change control mechanisms, verifying requirements and updating existing documentation.
- Involved actively in the development of test plans and various test scenarios to be utilized in testing based on business requirements, technical specifications and/or product knowledge.
- Conducted user acceptance testing, gathered and documented user manuals and business rules.
Environment: MS word, MS Excel, MS Access, MS Visio, ASP.NET 4.0, VB.NET Visual Studio 2012, NET Framework 4.0, IIS 7.5, SQL SERVER 2008 R2, HTML, XML, JavaScript, CSS, AJAX, Windows 7, and TFS.
Confidential
Product Owner/Scrum Master/Sr. Business Analyst
The scope of the project is to convert an existing version of a portal to the next upgrade. The portal is a common interface for business between Wal-Mart and its trading/business partners. The portal is named EDI portal/Vendor self-testing portal. This interface also integrates different independently operating applications/systems to provide combined/comprehensive functionality. It is to be noted that Wal-Mart and its global trading partners spread across GB, AR, BR, MX, US, CA and so on setup connections and interact by means of retail EDI transactions. The project involved both functional and non-functional requirements gathered and documented to aid in enhancing both the technicality and also user experience of the portal.
Responsibilities:
- Interviewed Business Users to gather Requirements and performed analysis of the feasibility of their needs by coordinating with the project manager and technical lead.
- Followed agile methodology during the course of the project as well in the development phase.
- Conducted extensive requirement analysis using rational requisite pro.
- Prepared Business Requirement Documents BRD's Business Requirement Lists BRL's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
- Extensive work experience on Agile methodology. Expertise in managing sprint deadlines and sprint planning.
- Hands-on experience as a scrum master and team lead in managing agile projects on a global scale across different countries all over the globe.
- Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
- Worked on SQL and Supply Chain Management modules
- Designed the business requirement collection approach based on the project scope and SDLC Methodology.
- Extensive experience on Microstrategy Cognos reporting tools that employ advanced visualizations that aid in effective identification of trends or anomalies within the data.
- Assisting in the planning and implementation of a customer relationship management CRM solution using Siebel tool.
- Made extensive use of Siebel CRM solutions that enable an organization to provide every customer with efficient, multichannel service while simultaneously cutting costs.
- Involved in the creation distribution of Business Continuity Resource Requirements to business process managers along with instructions about how the processes information needs to be effectively used to produce the expected results.
- Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Designed and developed Use Cases, Activity Diagrams, and OOD using UML.
- Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities.
- Expertise in the use of designing tools like MS visio which are used to design flow diagrams that involve various BPM notations, UML diagrams, Database ER diagrams and many others.
- Created screen-mockups using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
- Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
- Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
- Conducted Joint Application Development JAD sessions with IT groups.
- Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
- Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using BPM notations in Microsoft Visio.
- Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
- Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
Environment: MS word, MS Excel, MS Access, MS Project, Visio, Windows NT/XP, Oracle, SQL Server, Sybase, Rational requisite pro, VBScript, DOORS, Java, XML, C , and ASP.NET.
Confidential
Product Owner/Scrum Master/Business/System Analyst
With its market presence exploding over the last three years, American Eagle Outfitters AE needed to extend its retail momentum to the online market place. But its outmoded commerce platform didn't scale or integrate customer touch points, making that objective far out of reach. The target is centralized management of not only its Website, but its call center and order management systems, as well. With ATG Art technology group , AE gained total control of its multichannel business. The new ATG platform enabled AE to manage the entire customer experience from the retail store to the Web site to the call center. It also gives the client the foundation they needed to grow their existing brand, and launch new ones. The Project also involved creating a data warehouse to support the reporting requirements.
Responsibilities:
- Coordinated participation and sign-off of various business partners and customers.
- Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Gathered requirements around customization of salesforce.com SFDC pertaining to dashboards, reports, custom fields and custom-built applications such as Quotes/RFPs.
- Thoroughly studied the requirements for the process re-engineering
- Applied HTML for PHP web pages with upload file functions.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Followed agile methodologies during the course of the project.
- Created and worked with 'One key event' functions of PHP Ajax to create hint on search bar.
- Responsible for cost estimation and timelines for various Business Intelligence reports.
- Involved in enhancing retailers' booking methods from GDS, Supplier Web sites, and phone.
- Provided recommendation for use of ATG Commerce for B2B and B2C business.
- Utilized corporation developed Agile SDLC methodology.
- Extensive work experience on Agile methodology. Expertise in managing sprint deadlines and sprint planning.
- Expertise in the use of designing tools like MS visio which are used to design flow diagrams, UML diagrams, Database ER diagrams and many others.
- Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
- Hands-on experience in the usage of BI reporting tools like Cognos Microstrategy that help in the integration of existing workbooks, presentations or documents with reporting, analysis monitoring capabilities.
- Contributed to gathering requirements related to Business Continuity Planning, sharing the gathered information with managers, having managers to complete worksheets, identifying gaps or inconsistencies, if any, revisiting them in consequent discussions with managers and resolving these questions to obtain the necessary information.
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
- The Supply Chain scope includes the entire supply chain from production order to shipping delivery and order management.
- Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
- Extensively involved in the modeling and development of Reporting Data Warehousing System
- Was participating in the creation of new E-Commerce Products and maintain sites.
- Was involved in the creation of new E-Commerce Products Arrival Notices and Customized Reporting
- Accumulated system requirements from various departments through surveys and interviews.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL, PL/SQL queries to filter data.
- Create technical design documentation for the data models, data flow control process, metadata management.
- The advantages of CRM which is its power to deliver elements that work together in harmony including the ability to offer the most flexible CRM solutions that cater to almost all business needs has been leveraged.
- Hands-on experience on Siebel CRM which is available in many different modifications tailored to the specific needs of specified industries and covering completely the management of the following processes: sales, service, contact centre, marketing, customer loyalty management and partner management.
- Responsible for defect and change management.
- Successfully helped in improving response time, and increased productivity along with a host of other benefits thanks to Sales force that allows a company to handle all their business applications with a single data model, one sharing model, and one user interface.
- Worked on exporting data using Oracle and SQL databases in ETL uses
- Analyzed the data collected and process maps to determine the root causes and identify opportunities.
- Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies
- Created business requirement documents and integrated the requirements and underlying platform functionality.
- Interfaced between Business new product builders and System platform builders.
- Worked with systems area to translate business needs into system requirements.
- Made sure the test cases and test process guarantee accountability to business and systems requirements.
- Involved in the testing phase right from the Unit testing to the User Acceptance testing.
- Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
- Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
- Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
Environment: RUP, UAT, GAD Gap Analysis Document , MS Visio, SQL Server, Windows 2000 Advanced Server, UNIX / Oracle Platform , Oracle PL/SQL, IBM datastage7/7.5 E TL , C , and ASP.NET.
Confidential
Business/Data Analyst
The project involved development and update to the current electronic transaction application and Forms from current ICD9 version to the new updated ICD10 version. The goal of the project was to develop the application as per HIPAA 5010 standard and to support ICD10 update to enable UHG to add, manage and terminate members via multiple channels, specifically paper, web, EDI, and phone. The project also involved working with a third-party vendor to develop the enrolment engine as per EDI standard.
Responsibilities:
- Leveraged Waterfall methodology for portal development.
- Translated business requirements to technical staff to ensure the requirements are incorporated into system design by preparing following documents: Functional Document Specifications FDS , System Requirement Inventory SRI , System Solution Document SSD and Impact Estimation Table IET .
- Empowered development team by helping them understand requirements through release planning. Part of iteration meeting was to ensure requirements and user stories were well-understood and in compliance with business requirements.
- Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap
- Identify Member, Provider, Coverage, Medicare, and Medicaid
- Firsthand knowledge of HIPAA claims processing.
- Collaborated with development team through iteration and attended every SCRUM meeting to represent product team. Served as product champion to assist team.
- Responsible for resolving and/or driving the resolution to issues and risks through evaluation of differing opinions to negotiate resolution and priority.
- Developed Activity Diagrams, Use Case Diagrams, and Workflow Diagrams using Microsoft Visio.
- Proficient in using BPM notations.
- Provided support during Integration testing and UAT
- Reviewed and executed feature test cases and ensured that feature testing validated the business technical requirements for system implementation
- Provided application support testing and documentation for a new java and J2EE portal using Service Oriented Architecture SOA available to all IB T dealers.
- Maintained documents on Confluence, and SharePoint to facilitate seamless interaction with multiple teams with different document repositories.
- Interfaced between users and diverse teams and was involved in application development to enhance understanding of business and IT processes.
- Hands on experience in all facets of User Acceptance Test: UAT scheduling, walkthrough sessions, UAT test plan and cases, creating data set, user manual, rollout plan, release note, smoke test etc.
- Worked with team to stay abreast with new process and render it more effective.
- Succeeded in creating alternate strategies to ensure development was completed as required.
- Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
Environment: Requisite Pro, Rational Rose, Agile, PL/SQL, HTML, MS Office, MS Visio, EDI, UML, Manual Tester V6.1, SOA, Rational Clear Quest, Facets 4.31, UNIX, Java, XML, Oracle, SQL Server, Sybase, SQL advantage, SQL Plus, SQL Navigator, ASP.NET, Mainframe, Manual Testing
Confidential
Business/Data Analyst
Confidential of Insurance Companies is one of America's leading providers of affordable health insurance for the self-employed, individuals and families, as well as small businesses. The purpose of this project involves population of the Enterprise Data Warehouse EDW which is used in critical reporting and analysis. The data is pulled together from multiple, disparate systems.
Responsibilities:
- Gathered and documented business requirements for existing and future business systems.
- Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Microstrategy.
- Made use of reporting tools like Microstrategy that enable usage of simple and intuitive actions like drag drop, mouse click menus, toolbar icons allow business users to easily navigate, sort, pivot, drill on fields, create new calculations and switch between cross-tab, graphical views, and interactive visualizations.
- Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
- Healthcare system implementation including enterprise Electronic Medical Records EMR software.
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
- Created surrogate key tables to map the required dimensions.
- Used Query Analyzer, Execution Plan to optimize SQL Queries
- Involved in Service Oriented Architecture SOA of the claims processing system.
- Ensured that project requirements are properly tracked and documented.
- Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.
- Developed straightforward DBMS queries, knowledge of HL7 and xml interface messaging.
- Assisted in monitoring ancillary data transactions and addressed problems with HL7 messages.
- Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
- Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking and Mercury Test Director for Test Case Management.
- Drafted business Use Cases such that any future changes could be easily managed.
Environment: Microsoft Office 2003 Professional Outlook, Word, Excel, Visio, Access, etc. , Microsoft SharePoint 2003,UML, RUP, UAT, db2, Peoplesoft GL, Mercury Test Director, SQL, .NET, Clear Case
