Sr Business Systems Analyst Resume
Cincinatti, OH
SUMMARY
- Full SDLC experience, numerous full custom software implementations
- Experienced with iterative project delivery methodologies (e.g. Agile, Scrum, etc) and Waterfall
- Consulting industry experience working with external clients
- Adept Confidential eliciting and translating business and functional requirements into User Stories.
- Identify, manage, and where appropriate, escalate, project risks
- Proficient in written and verbal communication to a technical or business audience.
- Lengthy experience in IT working in multiple roles ( dev, pm, sa, ba, qa, dba, etc )
- Strong knowledge of software principals, XML, SQL, databases (e.g. Oracle), Java, C++
- ERP, e - commerce, integration, CRM and CMS system experience
- Is adaptable, accountable, solution orientated and possesses excellent analytical & problem solving skills
TECHNICAL SKILLS
BA/PM/SA/UX SKILLS: User Stories, Use Cases, System/Functional/Business Requirements Definitions, Technical Design, Process Flow Diagrams, Workflow Diagrams, Dataflow Diagrams, Activity Diagrams, Architecture Document, Requirements Traceability Matrixes, Requirements Workplans, Project Plans, Gannt Charts, Entity Relationship Diagrams, Data Dictionary, Data Mapping, Data Modeling, State Diagrams, System Integrations, Interface Definition, UX Design, Wireframe Creation, Audited Communication, Authentication, Defect Management, E-Commerce, Online Shopping, JAD, SDLC, Agile, SCRUM, RUP, Waterfall, RAD, SOA, NIEM, HEDIS, B2B, B2C, ERP, Responsive Design
IT PROCESS TOOLS: Jira, Confluence, Kanban, Box, Maven, Enterprise Architect UML 2.1, IBM DOORS, Lyx, Sharepoint, tSpace, TopTeam, MS Office, MS Word, MS Visio, MS Project, MS Excel, MS Powerpoint, Rally, OmniGraffle, EA, Enterprise Architect, Jira, Confluence, Quality Center, Mercury Test Director, Clearcase, Jenkins, GitHub, Git Bash, TOAD, SVN, CMVC
LANGUAGES & DATA CONSTRUCTS & OS: Visual Basic, Java, C, C++, Perl, HTML, XML, DTD, XSD, WSDL, JSON, HTTP, SOAP, REST, EDI, 4gl, shell, bash, csh, Aix, Unix, Linux, Windows, MacOS, Mainframe, HP-UX, ios, android
SOFTWARE TOOLS: XML Spy, SOAP UI, Oracle, Oracle IAM, OIG, IAM, DB2, Sybase, MySQL DB, SQL, SQL Developer, Stored Procedures, DBA CRUD, DB2 Performance Tuning, Siebel, Siebel CRM, Siebel DB, Siebel UCM, Adobe Experience Manager, AEM, Shopify, SOA, SAS, MMS, SMS, Mobile, Cloud Computing, SAS, SACS, Microservices, SpringSource Toolsuite, Java Freemarker, Hybernate, Eclipse, SAP ERP, SOAP UI
SYSTEMS INTEGRATION PLATFORMS & TOOLS: Oracle BPEL, Oracle ESB, IBM Websphere TX, Mercator, MQ Series, IBM Websphere MQ, Webmethods, SAP NetWeaver Xi, SAP PI, SAP IDOC, Siebel, FTP, SFTP
PROFESSIONAL EXPERIENCE
Sr Business Systems Analyst
Confidential, Cincinatti, OH
Responsibilities:
- This was a 100% remote position.
- Maintained technical and business knowledge of financial applications in Confluence and Jira.
- Scheduled meetings, JAD sessions to collect, document and vet business requirements
- Developed, optimized and delivered end-to-end financial business processes
- Translated business requirements into functional and system requirements in the form of Agile Epics, User Stories and Tasks.
- BA team lead and set BA documentation standards
- Identified and documented data structures.
- Reverse engineered complex Visual Basic code into functional requirement documentation.
- Supported QA and Dev teams with test case review, writing, execution and defect creation.
- Performed deep dive data structure analysis on legacy systems and databases.
- Proficient in writing SQL queries for data analysis
- Worked with offshore project delivery teams to troubleshoot project implementation issues and remove barriers to project success
Technologies used: Atlassian Jira, Confluence, SCRUM, Kanban, Excel, Word, Powerpoint, Visio, MongoDB, Oracle, MacOS, Slack, Skype, Azure Data Studio, SQL, SQL Server, Process Flow, Workflow, Visual Basic (VB), JSON, XML.
Platform Architect
Confidential
Responsibilities:
- This was a 95% remote position based in Atlanta, GA.
- Held multiple analyst job titles ending with a promotion to a Platform Architect
- Participate in JAD session with Business, DB, Architecture, Application, Cloud and Dev teams
- Worked with OAuth and other grant types to specify the authentication and authorization protocols for external API calls to Confidential &T via their Apigee Gateway.
- Worked with monetized API web services, software as a service ( SAAS )
- Created Interface documentation standards within my group
- Documented identity and access management (IAM) for clients of Confidential &Ts software as a service offering, many of which were cloud based.
- Documented interface agreements between disparate java based service oriented systems.
- Extensive use of Data Mapping, SQL, JSON and XML.
- Maintained a catalog of microservices and supported its growth within Confidential &T.
- Investigated and performed data mapping between systems, APIs and databases.
Technologies used: Enterprise Architect, SOA, IAM, Rally, Visio, Word, Excel, Sequence Flow Diagrams, Activity Diagrams, Process Flow Diagrams, JSON, XML, REST, SOAP, HTTP Methods: POST, GET, PUT, DELETE, Oracle, Mobile Applications, MSISDNs, MIMs, authentication, access tokens, MMS, SMS, Business Management Systems, Audited Communications, Cloud Computing and microservices.
Technical Business Systems Analyst
Confidential, Atlanta, GA
Responsibilities:
- This was a 95% remote part time position based in Atlanta, GA.
- Worked for clients in banking, insurance and gas/electric energy/utilities.
- Defined functional and business requirements for AEM based websites.
- Defined custom AEM components and field mappings for AEM page templates.
- Identified and documented AEM integration points to third party venders.
- Perform data mapping for both AEM and non-AEM content to render within AEM controlled templates.
- Cataloged a repository of AEM controlled assets.
- Identified data to be migrated from legacy DB into new AEM CRX content repository.
- Documented functional requirements for e-commerce system on an Oracle ATG platform.
- Defined E-commerce requirements for product catalog, search, navigation, product comparison, shopping cart, checkout, payment methods
- Attended meetings with clients to collect & review business requirements and objectives.
- Documented business requirements in relation to the desired system.
- Participate in JAD session with Business, Creative, DB, Application and Dev teams
- Created and maintained use cases, functional & data mapping requirements
- Acted as SME on functional requirements throughout project lifecycle.
- Documented functional requirements in Jira using stories, tasks and epics.
- Ran ad-hoc testing, created defects in Jira, and identified what code contained the defect.
- Performed extensive data mapping between multiple data sources and application fields
- Performed gap analysis between multiple documents: wireframes, graphic designs, business requirements, and functional requirements.
- Reviewed and provided input on test cases to off shore QA Team.
Technologies used: AEM, CRX, Oracle ATG, Atlassian Jira, Omnigraffle, Word, Powerpoint, MS Project, MS Excel, Adobe
Content Strategist
Confidential, Atlanta, GA
Responsibilities:
- This was a 95% remote position based in Atlanta, GA.
- Created and updated a website copydeck for all site pages under design and development.
- Maintain language, grammar, typeface, font size and consistency throughout all site pages.
- Identify all error scenarios and create copy text for every error condition.
Systems Analyst
Confidential, Atlanta, GA
Responsibilities:
- Created system level process flow diagrams
- Created data/xml/json mapping spreadsheets, elaborate Word docs
- Performed extensive Data Mapping between multiple data sources and application fields
- Interpreted XML/XSD/WSDL
- Understanding of middleware interface design, data mining, database table structures, data types, data modeling
- Knowledge of Service Oriented Architecture (SOA) and java web development and code dependencies.
- Business facing, worked with stakeholders.
- Attended daily SCRUM meetings and multiple JAD sessions.
- Defined GPS requirements for automotive tracking application
- Documented e-commerce system requirements for an Oracle ATG system.
- Identify and document all user profile fields for the oracle directory service.
- Identify and document multiple user access privileges, roles and entitlements to be configured with the Oracle Identity Access Management (IAM) tools
- Worked with applications that had a hierarchy of user roles.
- Technologies used: Siebel CRM, Oracle DB, OAM, OIG, IAM, SQL Developer, TopTeam, Enterprise Architect, soapUI, Visio, Oracle BPEL, Oracle ESB, Oracle ATG, HP Quality Center, SOA, XMLSpy, GPS, MMS, SMS, CSP,VIN, GeoFencing, ICCID/SIM Card, IMEI/ESN, IMSI, SSID.
Senior Consultant
Confidential
Responsibilities:
- Created several types of design and requirements documents for web services
- Created and worked through defects in HP Quality Center
- Collected/updated status for developers and testers
- Updating a Gantt Chart for daily status
- Business facing, elicited requirements from business stakeholders,
- Analyzed and cataloged metadata
- Created documentation including: An Inventory of User Configurable Parameters, a Requirements Traceability Matrix, High Level Designs, Detailed Designs, Solutions Specifications and Field Mapping documents for Java Domain Objects, and ETL requirements to both Oracle and Sybase database fields.
- Created functional, technical requirements for DB migration, data transformation.
- Documented updates to data mapping using IDSS Import templates to support HEDIS data collection for a Health Insurance client.
- Used HEDIS domain taxonomy / data dictionary to create data mapping and transformation requirements for data migration interfaces.
- Maintained documents in IBM Rational DOORS
- Integrated IBM DOORS to HP Quality Center test cases and RTM. NOTE: DOORS is an acronym for Dynamic Object-Oriented Requirements
- Set up a Java Controller class that uses RESTful services for a Loan Proposal function, including Junit tests and JSON data object manipulation.
- Set up the initial development environment for Java using the Spring Source Toolsuite (STS.exe) with Eclipse and Maven.
- Performed java coding on RESTful Services for R&D.
- Gained knowledge of residential mortgage processing and mortgage backed securities processing.
- Technologies used: Agile, Web Services, SpringSource Toolsuite(STS), Eclipse, Java, JSON, RestAPIs, TOAD, SVN, XML, XSDs, Oracle, Sybase, IBM - Rational DOORS, Embarcadero RapidSQL, SQL, Excel, HP Quality Center, HEDIS, CMS STARS, IDSS
XML Analyst
Confidential, Atlanta, GA
Responsibilities:
- Produced java centered functional and technical requirements documentation for several search and display web-based interfaces for a Public Records Data Search system used by legal, government and law enforcement agencies. NOTE: Converted from contractor to regular employee Confidential this company.
- Ran database queries, extracted sample data to text files and xml files, studied and documented anomalies in the data, generated XSDs from DTDs, documented field mapping via Excel spreadsheets. The data field mappings were from XML to Java application fields for the search and display functions for a web based front-end. Read the XSDs to document the cardinality of XML elements and the element hierarchy parent-child structure. Read the java RestAPI designs and sync-ed up with the field mapping documents. Attend technical design meetings with development teams in Minnesota, New York and Atlanta to synchronize functional, data and field level requirements. Test system functionality and write up defects to be assigned to development. Verify bug fixes in the application in the QA environment. Advised and led developers through technical requirements.
- I created UML models for several system to system interfaces using Sparx Systems' Enterprise Architect UML modeling tool. This involved classifying data fields to create a data taxonomy based on common characteristics. I converted the models to XMI files and imported them into the NIEM ( National Information Exchange Model Tools) online. Note: NIEM is a GA Tech application. I mapped the XMI files to standard NIEM fields and generated Exchange and Subset Schemas for the development team. Technologies used: Enterprise Architect UML 2.1, Java Freemarker, RestAPIs, XML, XSDs