Sr. Business Analyst Resume
Orlando, FL
SUMMARY:
- Sr. Business Analyst with 6+ years of experience in business Process analysis, Business Process Modeling, Data modeling, Data Analysis, SupplyChainQuality, business requirements gathering, database design and development of Web Based, and Client/Server applications.
- Industrial experience involving technical writing, Media & Entertainment, Sales Engineering, Application Design, GUI implementation, Systems Integration, SQA techniques using automation tools by Rational, Test Case Analysis and Maintenance.
- In - depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
- Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
- Strong knowledge of the Software Development Life Cycle methodologies (phases and gates) like Agile, Scrum and Waterfall models.
- With expertise in quality management systems,supplychainmanagement, process improvement andbusinessanalysis,
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Extensive knowledge in SDLC methodologies.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
- Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
- Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
- Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum.
- Extensive experience using WideOrbit Ad Sales and Traffic Management.
- Strong experience working as a Technology business analyst for the RightsLogic rights management system (RMS).
- Develop procedures for coordination ofsupplychainmanagement with other functional areas, such as sales, marketing, finance, production, or quality assurance.
- Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
- Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data.
- Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
- Research advancedsupplychainpractices and performance and benchmarks companies in relevant peer groups.
- Good command over Logical and Physical entity relationship data modeling using Oracle Designer and Power Designer.
- Experience in Agile Methodology, XP (Extreme Programming), Six Sigma.
- Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
- Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
- Expertise in planning and implementing MS SQL server Security and database permissions. Creation and maintenance of databases, creating roles and managing user permissions.
PROFESSIONAL EXPERIENCE:
Confidential - Orlando, FL
Sr. Business Analyst
Responsibilities:
- Involved understanding the current business process, defining scope of the project along with position statement.
- Acted as a liaison between the offshore development team and onsite business team.
- Assisted in the production of user training documentation and work with the business to train users in their Marketing, Digital Asset Management, and Production Scheduling Systems and applications. Report bugs/defects for problem resolution using JIRA; issue tracking software.
- As a Business Analyst managed complete implementation of multiple sub-systems such as: Oracle, Wideorbit, Gabriel and Puridium.
- Created and categorized the needs of network cable ad sales operations in order to build a new planning system for account executives and their teams to build sales plans and reports.
- Established a Program Office to manage Offshore business units or vendors
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Technology/Strategy dept. in planning and scheduling project goals, milestones, gathering of Reporting and Media Service'sMAMrequirements.
- Directed communication between vendor (WideOrbit) and various business groups (Traffic, Sales, Inventory, Billing, and Research.
- Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
- Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, User Interface, Performance, Usability and Security requirements (PCI, SOX, Change Management, etc.).
- Performed user acceptance testing, documented user manuals and held walkthroughs for educating business community in use of content management system software for publishing website content.
- Extensively involved in every phase of the RUP process starting from Inception to Transition
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Interacted with external vendors, marketing experts and asset owners to consolidate the process for managing digital assets; created process for handling digital rights management.
- An understanding of thesupplychain"big picture" and the ability to apply JIT/demand forecasting principles on a tactical basis to improve customer service, reduce inventory expense, and redeploy of procurement resources
- Spearheaded cross-functional initiative to retrieve and analyze data and helpsupplychainteam making better decisions
- Create comprehensive functional specification documents to capture new and existing requirements for an enterprise digital asset management system and its integrated systems.
- Oversaw the ratings in order to explore trends and direct sales teams to rectify a shortfall or over delivery.
- Provide information to PSL/functions through systematic collection ofsupplychaindata.
- Ensured accurate and timely measures of digital media programs and website performances.
- Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
- Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
- Worked Closely with Application Architects and Business teams to converge on requirements for the New Workflow Management System and Content Management System.
- Subject Matter Expert on internal development of a Digital Asset Management System to address multi-divisions across the organization.
- Documented post pilot business and technical defects in JIRA. Analyzed, prioritized, and successfully converted defects into improved business and technical solutions.
- Developed overall pricing direction for commercial units based on inventory availability and sales goals.
- Consolidated allsupplychannels through an integration process fostering partnership
- Gather data and conduct analysis with the goal of improving the organization'ssupplychainoperations.
- Configured the Data mapping between Oracle and SQL Server 2005.
- Communicatebusiness, strategicsupplychain, and performance opportunities and recommends action plans.
- Responsible for the creation of CSG Billing System Operator ID database for Internal Care and Outsourcers.
- Actively involved in requirements analysis for digital media campaign planning, managing and reporting needs.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Administrated work by recording, tabulating and filing sales transactions.
- Create, execute and maintain data programs to answer business questions from Teradata.
- Conduct initial Interwoven Teamsite template testing related to projects on an individual project basis
- Provide Executive Management with progress and status reports for content related initiatives.
Environment: Microsoft Office Suite,, UML, Windows NT/XP, Oracle, SQL, SQL Server, XML, Agile/Scrum/Jira, TestDirector, LoadRunner, SDLC, RUP, Mircosoft suite, Excel/word/Access/PowerPoint/Visio, SOX, GAAP
Confidential - Century City, CA
Business Analyst
Responsibilities:
- Facilitated JAD/JAR/JRP sessions with the business users to understand current business process, the limitations of the current AD Sales systems, to define system requirements and brainstorm solution design during analysis phase.
- Participated in User requirement gathering,BusinessAnalystrequirement assessment, Documenting requirements in the form of use cases, flow charts and various Demos.
- Worked closely withbusinessusers in demonstrating POCs, finalizing the requirements, and use cases followed by technical specifications.
- Evaluated thebusinessand user needs, documented the requirements, proposed solutions, defined the scope of the project, identified possible dependencies and acted as a translator in delivering the proper specifications to the development team
- Worked closely with key users across business units to determine scope; gather business requirements; formalize the documentation in support of the Advanced Rights Management upgrade.
- Build world class AdvancedSupplyChainprocess tailored to customer’s needs and success
- Estimated and calculated company budgets, assessed sales forecasting and maintained sales records.
- Worked on data modeling and produced data mapping and data definition documentation
- Tested Performance & Accuracy related queries under SQL Server
- Designed and implemented basic SQL queries for testing and report/data validation
- Communicated with thebusinessusers and/or functional team to developbusinessrequirements and analyze information needs, delivered the functional requirements,businessrequirements documents, use cases, test cases and user guides
- Responsible for maintain the client queue's to see the server running healthy with good performance without losing any transactions.
- Participate in WideOrbit migration work sessions with business and technical teams.
- Trained sales assistants and sales planners and supervised their work and development.
- Assured that the full cycle of the planning process was optimized, expeditious and accurate, Sales Planner.
- Involved in configuring the JDBC adapter to communicate to Oracle 10g, MSSQL Server 2005 databases.
- Data entry intoSupplyChainsystems as needed with regard to account reconciliation and PO's.
- Involved in designing the Process Models for handlingBusinessProcess Automation using Designer.
- Involved in Installing and Configuring TN server, Configuring digital certificates, troubleshooting the VAN communication issues.
- Worked with Lifetime and WideOrbit Teams to successfully implement WideOrbit.
- I wrote requirements, user stories, and created Jira issues to track progress. I created Confluence project to communicate with Team and documented progress.
- Recommended process changes and documented the same so as to align them in accordance with SOX requirements.
- Monitor forecasts and quotas to identify and determine their effect onsupplychainactivities
- Served as liaison between thebusinessand the technology team with an understanding of thebusinessprocesses and technology solutions in the enhancement of the Billing system
- Create the Trading Partner Profiles, Trading Partner Agreements (TPA's), TN Documents.
- Work involved Developing Flow and Java Services for EDI Mapping and Integration.
- Responsible for code maintenance, bug fixing, and production support, transaction recovery, Server Administration and Maintenance.
- Creating weekly JIRA status reports and tracking status of enhancements, defects and tasks weekly.
- Involved in user training and troubleshooting.Configured the Data mapping between Oracle and SQL Server 2005.
- Tested Performance & Accuracy related queries under SQL Server
- Designed and implemented basic SQL queries for testing and report/data validation
Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, UML, MS Word, MS Excel, MS Access, Agile/Scrum, JIRA, MS Project, MS Power Point,, SQL Server, Windows
Confidential - Camarillo, CA
Business Analyst
Responsibilities:
- Involved understanding the current business process, defining scope of the project along with position statement.
- Acted as a liaison between the offshore development team and onsite business team
- Established Off-shore Project teams within PMO
- Prepared and documented System Requirements and workflows for the Content Management Application tool Interwoven.
- Assisted developers with website support in regards to Content Management to take control of the Web pages by managing the content as distinct from the design.
- Worked in all aspects of online advertising sales including lead generation, RFP responses, creation of account specific opportunity proposals, deal negotiations to campaigns delivery.
- Created business use case, functional (FRS) and technical specifications for trading system.
- Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose.
- Working with clients to better understand their needs and present solutions using structured SDLC approach.
- Supported PMO by mentoring specific projects in application of the new SDLC based on the Agile Unified Process.
- Successfully implemented system for the Marketing department including Creative, Graphics, New Media, Program Planning, Production, Editing, Post-Production.
- Performed Unit and Integration testing with the development team as well as User Acceptance Testing and Regression Testing of the application using QTP, Quality Center and Jira.
- Liaised between sales, planning and agencies consistently anticipating and meeting the needs of all parties.
- Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
- Oversaw iterative realization of requirements in collaboration with development teams and their project managers under the direction of, and in daily dialog with, the Program Manager.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Designed and Performed standard QA process to include creation and streamlining of new and existing Test Plans / Suites; Maintained DevTrack bug database.
- Quickly and efficiently created and revised sales plans from the speculative to order stage based on the evolving dynamics of the negotiation.
- Performed SOX analysis of IT processes comparing company policy to current practices.
- Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
- Designed the UI (web interface) of the application, along with prototyping.
- Validated business rules and all artifacts with users, approval and sign off.
- Working with the architect, developers on business and technical issues, helping in designing of the system; and testers to ensure all requirements are correctly translated.
- Documented and assisted in version upgrades for ad sales systems; mainly Gabriel & Invision Deal Maker.
- Maintained sales operating system (i.e. adding new brands, advertisers, agencies, selling titles, etc).
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- Updated and modified progress and resources allocation in MS project for the team.
- Created test plans, scripts and facilitated user acceptance testing.
- Helped in deployment of portal a venue for the on-line trading application a collaboration bundle solution.
- Ensured that the application met user and management expectations.
- Organized requirements, test scripts and other artifacts in JIRA and Confluence.
- Created Excel spreadsheets to provide market analysis along with possibilities for currency trading.
- Used MS Visio to create Flow diagrams and Use Case Diagrams.
Environment: MS Visio, DB2, MS Project, UML, Agile, Scrum, JIRA, Microsoft Office Suite, Documentum, Windows NT/XP
Confidential - Stamford, CT
Business Analyst
Responsibilities:
- Gathered User and Business level Requirements for SMEs from various departments like Accounting/Finance and Information Systems and designed the business requirement collection approach based on the project scope using AGILE methodology
- Facilitated joint application development (JAD) sessions for communicating and managing expectations with SME's and to understand the business process and the interface requirements, which need to be incorporated in the application.
- Involved in the cross matching system requirements and specifications.
- Interacted with subject matter experts to gather requirements and goals through interviews and surveys to understand the business process.
- Conducted controlled brainstorming sessions with project focus groups.
- Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
- Designed Use Cases, Use case diagrams to present a better view of the system as a whole to the technical team for them to identify the key processes.
- Adhered to SDLC based on the Agile Unified Process and SOX compliance, End User Testing and Vendor Management.
- Interacted with technical architects to identify and analyze the given information, procedures and decision flows and evaluated existing procedures.
- Acted as a liaison between the SME's and the technical teams, handled all scheduling, resource planning and allocation matters, ran all status meetings and compiled reports.
- Extensively worked on creating user requirement specifications (URS), and the Business Process Documents and also developed System requirements.
- Prepared Use Cases, Use case Scenarios and elaborated these using UML diagrams like Case diagrams, activity Diagrams, Data flow diagrams, Business process and data process diagrams using MS Visio.
- Mentored staff in methodology and encouraged best practiced in project management and planning.
- Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
- Creating weekly JIRA status reports and tracking status of enhancements, defects and tasks weekly.
- Updated Quality Center for SOX Compliance to track software deliverables for UAT testing and deployment.
- Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
- Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
- Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
- Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
Environment: Microsoft Office Suite, Windows NT/XP, Oracle, SQL, SQL Server, Agile/Scrum, JIRA, TestDirector, LoadRunner
Confidential , TX
Business Analyst
Responsibilities:
- Served as liaison between business users and project team by assisting the business in identifying, understanding and documenting requirements.
- Gathered and analyzed business processes and customer requirements through surveys, interviews and Joint Application Development (JAD) sessions and translated them into system requirements.
- Suggested measures and recommendations to improve the current applications' performance.
- Executed detailed functional decomposition analysis to redesign the existing process flows for increased efficiency and utility.
- Performed GAP analysis the legacy system workflows and the new system to identify the functional changes required to the new system.
- Coordinate with development team throughout all phases of agile methodology.
- Prepared Use Cases, Use Case scenarios and elaborated those by using UML diagrams like Use Case Diagrams, Activity Diagrams using Rational Rose.
- Extensively worked on creating Business Requirements Document (BRD) and Functional Requirements Document (FRD)
- Co-ordinate and manage the Change request Control Process for the project by facilitating one-on-one interviews, group meetings and corresponding through emails with work stream owner to discuss the impact of change request on the project.
- Documented the Impact Assessment Report on the project, due to change requests from the business stakeholders and the project management.
- Conducted regular meetings with development team members, Project Manager and testing team to better understand system functionality in order to improve quality.
- Responsible for generating project plans and updating weekly project status reports.
- Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
- Leveraged expertise with JIRA to develop/manage business documents and business objects.
- Participated in the bug review meetings and updated requirement document as per business user feedback and change in functionalities of the application.
Environment: UML, RUP, Agile, MS Office, Rational Rose, Rational Clear Quest, Requisite Pro, Quality Center, SQL