Systems Analyst Resume Profile
SUMMARY:
I serve fundamentally as a liaison between various stakeholders within business and technical domains to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems. Successful delivery is predicated on an understanding of business problems and opportunities within the context of the aforementioned requirements, and the recommendation of solutions that enable the organization to achieve its goals. I am a 2003 MBA graduate.
MAJOR ACTIVITIES:
- Implement advanced strategies for gathering, documenting, and reviewing requirements.
- Prepare entire sets of artifacts to define and present requirements to various audiences throughout the organization.
- Design User Interfaces to maximize user experience.
- Utilize advanced data definition, traceability, and quality management techniques.
- Utilize strategies for dealing with requirements changes and their impact on quality.
- Facilitate Business Process Management paradigms utilizing the three BPM core dimensions business value, process transformation, and management enabling.
CORE COMPETENCIES:
- Experience with Agile and Waterfall SDLC
- Functional Requirements Gathering
- JAD sessions
- Use Case Development
- Story Card Development
- SQL
- Business Process Management
- Business Process Modeling Notation BPMN 2.0
- UI Design
- UML Diagrams
- ETL and Logical Data Modeling
- RUP and utilization of best practices
- Extensive Presentation Skills
- Object-Oriented Design I am an intermediate-level Java developer
TECHNOLOGIES: PARTIAL LIST
- Microsoft Office
- Visio
- Word
- Excel
- PowerPoint
- MS Project
- Lotus Notes
- SharePoint
- Various Wireframe Technologies
- Business Objects
- Rational Requisite Pro
- Doors
- DB2
- Oracle
- SQL Server
- MS Access
- Mercury Quality Center
EXPERIENCE:
Confidential
SYSTEMS ANALYST
- Serve as liaison between business stakeholders, development, and testing groups to articulate systems requirements necessary for developing new and enhancing existing critical leave management software applications in both Waterfall and Agile environments. Applications are developed to conform to FMLA, State, and Client-specific policy restrictions. Utilize various tools including Microsoft Visio, Word, Excel, SQL, HP Quality Center, SharePoint, and SnagIt. Clients include fortune 500 companies such as Apple Computer and Nationwide Insurance. Specific responsibilities include,
- Consensus development between stakeholder groups
- Process Analysis and Modeling.
- Business Process Modeling Notation BPMN 2.0 .
- Functional Requirements elicitation and specification using Use Cases and more recently Story Cards.
- Specification of technical requirements using various artifacts.
- Coordination of development efforts
- Coordination of testing efforts
- Coordination of UAT
Confidential
- I currently determine system requirements and assist in design activities for enhancements to the existing Nationwide Insurance FUSION application in an Agile Environment. Specific responsibilities include,
- Process Analysis and modeling using Business Process Modeling Notation BPMN 2.0 .
- Requirements elicitation.
- Technical analysis.
- Creation of Story Cards and associated artifacts in conformance with Nationwide documentation standards.
- Utilization of Rational tools to manage release deliverables throughout development lifecycle.
Confidential
- This assignment involved capturing and documenting business processes for facilitating all phases of Storage Area Networking SAN reservation and implementation throughout the organization. Also involved in design of new application to track inventory and provide accurate forecasts of available resources in future periods, in an effort to increase organizational resiliency with regard to fluctuating demand. Design includes encapsulation of business rules to provide a UI that captures required attributes in an innovative fashion, and captures the information necessary to provide pertinent business intelligence.
- Serving as liaison between stakeholder and development groups
- Facilitating JAD sessions
- Determining stakeholder expectations
- Determining functional requirements
- Performing Process Analysis.
- Writing various documentation.
- Making presentations to management
- Eliciting approvals
- Deliverable artifacts include,
- Vision Documents
- Functional Requirements Documents
- Use Cases
- Flow charts using Business Process Modeling Notation BPMN 2.0
- UI Design
Confidential
Current assignment involves data profiling and analysis for a new enterprise initiative to standardize data across the entire organization. Responsibilities include the gathering of various metrics for data consumption, analysis of existing schema and entity relationships, examination of data relationships and facilitation of Master Data Schema development, development of data and process standards, development of documentation to implement ETL code for the purposes of moving data between various stages, and in-depth testing of data to ensure transformation and accurate loading on Oracle platform. Standardization and cleansing of data is facilitated by a third-party application Silver Creek . Validation logic is based on source-to-target mappings, and is applied to source data to anticipate resulting attribute values, based on movement of data and any required transformations. Design of SQL queries is required to validate results and compare with expected results at each stage as data is routed through the entire system. Various tools are utilized to accomplish the tracking and testing of data, including Business Objects and Rational Requisite Pro. Delivered artifacts include,
Data Profile
- Functional Requirements.
- Use Cases for technical and business users
- Process Modeling.
- Test Plans including developing test deck.
- Test Scripts
- Traceability Matrices
- UI Design
Confidential
- Current assignment involves the initial phase of analysis to make a build or buy decision for a new enterprise call center application, utilizing the Rational Unified Process. The application deals with the delivery of charter retail transportation services delivered from 600 branch sites across the US and Canada.
- The system components under analysis include Quotation, Order Entry, Invoicing, and Logistics. Gap analysis is performed in terms of present and future states to identify required new system functionality. The system under study is to include interfaces to existing Logistics and JD Edwards ERP systems. Analysis was required to determine optimal UI design based on input from various users. I also served as functional architect, performing Business Process Engineering and Re-engineering, to capture and implement best practices throughout the organization. Specific deliverables include,
- Vision Document
- Business Requirements Document
- Process Modeling.
- Functional Specifications
- UI Design
- Use Cases RUP
- UML Activity Documents
- UML Class Documents Showing relationships and multiplicity
- Data Models
- Identification of Stakeholders and their interests
- Identification of Actors and their roles
- Reporting Requirements for Business Intelligence and Trend Analysis
Confidential
- This position involves the design of a Health Care information repository that will serve as the predecessor to a data warehouse. My responsibilities include the analysis of existing data feeds, and the development of logical data models to aid in the ETL development process. Daily activities include interfacing with business data consumers and ETL development staff, writing documentation to determine format and process for new feeds, interfacing with technical teams to validate development from a functional data perspective, and working with testing team to ensure adequate testing plans are developed. Client utilizes Oracle Database platform.
- Process Modeling.
- Work with various stakeholders to determine data requirements
- Perform GAP analysis on existing data feeds
- Analyze statistical relationships in data to make modeling recommendations
- Perform Logical Data Modeling
- Prepare Functional Specifications, including logic flow, to serve as basis for physical modeling
- Participate in User Acceptance Testing
- Create test scripts for Unit Testing
Confidential
- Serve in the role of Business Analyst in charge of overseeing five major interfaces from a new enterprise management system and various legacy systems to a Teradata Data Warehouse. Data feeds are comprised of configuration and transaction data from daily operations at 1600 retail Super Store America locations across the U.S. The entire integration process begins with data captured at the point of sale. Sales activity is in turn transmitted to an enterprise management system on a daily basis. This system processes and stores retail activity, back-office data including inventory receipts, and configuration data required to support the aforementioned processing. Data is exported in XML format to an Informatica middleware layer, where it is checked for validity, and written to flat files to be loaded into a Teradata data warehouse. Various business units consume this data for trend analysis, loss prevention, and financial auditing purposes. Responsibilities also include assisting in restructure of data models for the purpose of de-normalizing, in an effort to decrease loads, joins, and active tables in use, while balancing tradeoffs between redundancy and performance. Additionally in charge of unit, system, and user acceptance testing design and execution. Client utilizes Teradata Data Warehousing platform and Oracle Databases. Major daily activities include,
- Facilitate JAD sessions
- Determine data requirements for Business Intelligence users
- Serve as liaison between business and technical organizations
- Write Use Cases, Story Cards, and various functional specifications
- Perform data and process modeling activities
- Interface with application vendors
- Review resulting technical specifications
- Perform GAP analysis
- Write and manage change requests to vendors
- Document acceptance criteria and write test scripts
- Validate data feeds
- UI Design
Confidential
- Serve as a consultant on the Agent Gateway Marketing application within Nationwide Insurance. The application is designed to allow external agencies and other identified users to utilize an all-encompassing portal to satisfy marketing initiatives, while leveraging scoring and rating algorithms used by Nationwide Corporate to identify specific market segments for targeted marketing efforts. The system is to be rolled-out to approximately 20,000 internal and external users. My responsibilities included the following:
- Drive business requirements-gathering sessions
- Perform Process Modeling.
- Interface with various technical and business user groups to identify required functionality
- Design user interface UI
- Determine data requirements for the application
- Write documentation Story Cards to map required business processes and software requirements in Agile SDLC environment
- Write acceptance criteria
