We provide IT Staff Augmentation Services!

Business Analyst Resume

Columbus, OH

TECHNICAL SKILLS

Hardware: HP/UX 90 00 10 .20, HP/UX 90 00 11 .00, Sco - Unix, VAX, Windows, Linux, Dos and Java.

Software: Informatics, FitNesse, Subversion, ESDM Methodology Quality Center, HP-QTP, SOAPUI, XMLSpy, IgniteXML, Quick Test Professional, Oracle 9I, Oracle 8.I, Oracle 8.0.6, Oracle 7.0. I Informix, Sql Server, Oracle NT, Windows-NT, Oracle Developer, ORACLE, IEAdvantage, Design IDEF, TI Composer, Erwin and BP win, Oracle Forms, Windows 95, Word for Windows, WordPerfect, Excel, LOTUS 1-2-3, Harvard Graphics, Freelance Graphics, PowerPoint, Visio, Access, Microsoft Project, Power Designer Case Tool and Informatica Metadata Exchange SDML

PROFESSIONAL EXPERIENCE

Confidential

Columbus, OH

Business Analyst

Worked with business analyst to create and define requirements for Mortgage Escrow project Created and reviewed task/stories in JIRA for Agile working environment Worked in Mortgage banking System Integration (MBSI) to create web services with developers Created mapping spreadsheets based on Web Service to define data transformations Became familiar with Escrow Management Mortgage Business practices Queried MSP application to define screen, elements and data Became familiar with Lending Processing System to reuse web services already in production Created requirements from business needs, databases and application code. Trained on several web based classes in Mortgage Banking area Developed working relationships with business and developers Windows Presentation Foundation (WPF) build pipeline framework for .net development Extensible Application Markup Language (XAML) for visual design artifacts in web services phone designs. Mapped COBOL files to Oracle database tables and attributes to web services. UAT acceptance review Experience writing and managing business processes Process mapping and Gap analysis Gherkin Requirements documentation Created SQL queries to select data from databases/applications

Confidential

Columbus, Ohio

Testing Analyst/Data Modeler

Create and functionally test services using FitNesse tool in the Customer Inquiry Area Utilized XMLSpy XSLT to transform XML services to meet needed format Work in customer Inquiry area with business leader to develop requirements Analyze business needs and turn into requirements and functional test Create solution requirements to address business needs for current systems Gherkin Requirements documentation Document business solutions in Quality Center and Web Sphere Registry & Repository (WSRR) Integrate Customer Inquiry System with the Claims business system Work closely with business users to provide end user needs Work with system architects to develop user solutions - Gathered Functional requirements

Wrote Excel Macros to analyze data and support transactional data trends Used SQL queries to gather data and analysis. Experience writing and managing business processes Provides input to the development of formal business cases when enterprise-wide business solutions Contributes a business or process perspective during design reviews Executes software quality assurance through the development and maintenance of test plans Guides and advises Application Development teams to make the fully informed decisions Deep understanding of business and technologies, with specific expertise in the business area of this LOB Identifies, recommends, and implements IT process improvements Foresees issues/risks and provides solutions before they are realized Determines and manages scope of the project with the Line of Business partners Process mapping and Gap analysis Used Informatica for reporting Created SQL queries to select data from databases/applications Created and updated relational data models

Confidential

Columbus, Ohio

Testing Analyst

  • Created SOAPUI projects in subversion to test Web services for happy path & exceptions
  • Added assertions to SOAPUI projects to automate scripts
  • Created “AS-IS TO- BE” process for LEAN Requirements documentation for testing and analysis
  • A major contributor in testing “AS-IS TO-BE” LEAN process to be utilized in AGILE environment
  • Functional Testing for SOA WEB & MQ services
  • Utilized XPATH to with XMLSpy to create assertions for SOAPUI projects
  • Created a process diagram to incorporated Testing in SOA Demand Management Process
  • Worked on Capability Maturity Model (CMMI) for our area
  • Lead daily scrum meetings working in agile environment
  • Logged project traceability matrix in Quality Center
  • Developed Test coordination process incorporating testing in SOA project resources, status reports and demand management process
  • Utilized Load runner to test new service capacity
  • Used Pivot tables to analyze added test data t for accuracy.
  • Experience writing and managing business processes
  • Converting legacy system to web-based service processes
Confidential

Columbus, Ohio

Data Engineer

  • Created XML Schemas, request and response messages
  • Created WSDL’s
  • Generated Insurance canonical model using Insurance Application Architecture (IAA)
  • Utilized Unified Modeling Language to structure schemas, following the canonical models paths
  • The models provides data to create request and response messages/instances, which are turned over to developers and processed through Data Power
  • Helped develop and design governance for WebSphere Registry & Repository (WSRR)
  • Used IgniteXML to trim schemas to provide better performance
  • Created Integration design documents to document transformations of data for SOA
  • Worked on resource access database to capture SOA project resourcing
  • Utilized the rational unified process (RUP) a software process product designed as an object-oriented and web-enabled program development methodology.
  • Created mapping spreadsheets to capture specific data transformation rules from one applications data to another.
  • Designed a process to get data architects involved in SDLC early to capture SOA services data needs.
  • Wrote Excel Macros to analyze data and support transactional data trends.
  • Wrote story cards for Agile methodology
  • Used Powerview tools to create presentation
  • Converting legacy system to web-based service processes
  • Created and reporting on KPI’s
  • Created and updated relational data models

Confidential

Dublin, Ohio

Production Database Administrator

  • Oracle 9I production DBA
  • Created oracle databases on UNIX operating system
  • Rebuild Oracle instances, recover databases when they have problems
  • Resized tablespaces and database files
  • Did routine maintenance to create blobs of data usually these were objects
  • I do daily monitoring of the oracle instance to make sure it is operating correctly
  • I monitor flatfiles that use Acucobol, that interact with the Oracle database.
  • Work with developers to create snapshots, stored procedures and to make sure sequel statements are tuned in development, before migrating to a production instance.
  • I have been doing testing on Oracle 10g preparing to upgrade our client’s databases.
  • Extracted data when doing upgrades’
  • Ran ad-hoc reports for particular manager for business reporting.
Columbus, Ohio

Database Administrator Production

  • Oracle 9I production DBA & Informix production DBA on UNIX environment
  • Oracle NT DBA
  • Creating the instances, tuning the instances, creating backup schedule Resized tablespaces and database files
  • Creating a recovery manager catalog in Oracle 8x, registering the databases in the recovery I monitor flatfiles that use
  • Testing scripts, including shell scripts in UNIX, a little Perl script for DOS environments, and of course Sequential Query language (SQL).

Confidential

Columbus, Ohio

Database Administrator Production

  • Oracle 8 production DBA SCO UNIX environment
  • Rebuild Oracle instances, recover databases when they have problems
  • Resized tablespaces and database files
  • Did routine maintenance to create blobs of data usually these were objects
  • I do daily monitoring of the oracle instance to make sure it is operating correctly

Confidential

Dublin, Ohio

Production DBA/Application Database Administrator

  • Oracle 7 production DBA UNIX environment
  • Rebuild Oracle instances, recover databases when they have problems
  • Resized tablespaces and database files and added users
  • Did routine maintenance to create blobs of data usually these were objects
  • I was a application D BA, created schemas based on requirements given by business
  • Tested schemas in development, IT and PT environments before releasing to production
  • Tuned queries, added constraints, indexes etc.
  • Optimized tables for performance, add foreign keys when needed.
  • Converting legacy system to web-based service processes

Confidential

Columbus, Ohio

Computer Specialist

  • Responsible for the analysis and standardization of data, repository administration and compliance with Department of Defense regulatory guidance
  • Set up the connectivity from the server at Fort Belvoir, VA to the client in Columbus, Ohio.
  • Manage the areas where other associates work on and kept the integrity of the data model.
  • I was team leader for data modeling and process modeling on all new development designated for forward engineering, and all current systems selected for reverse engineering or data warehousing.
  • I coordinate and facilitate Joint Application Development (JAD) sessions with customers to determine and capture business rules and project requirements.
  • Converting legacy system to web-based service processes

Confidential

Columbus, Ohio

Program and Management Analyst

  • Responsible for Project Planning, Project Management and Analysis.
  • Major accomplishments included the development of a standard Business Model for systems development and software engineering.
  • After developing a draft business model that was consistent with the phases of Life Cycle Management (LVM), I organized a working group consisting of the business and system experts in order to identify specific project deliverables for each LCM phase, including the responsible and approving authorities.
  • Attended ‘Process Reviews” for all levels of management, both military and civilian.
  • Served as a representative on the Metrics and Measurement Council and served as member of the Configuration Management Working Group.
  • I conducted analysis of the current metrics procedures in place within my organization and did a comparison to the Capability Maturity Model, developed by the Software Engineering Institute at Carnegie Melon University.
  • I identified disconnects with the current process and made specific recommendations for achieving the desired level of the Capability Maturity Model. In addition, I was responsible for the preparation of the bi-annual budget submission and coordinated with the project managers and higher-level management to ensure the validity and accuracy of the data.
  • Converting legacy system to web-based service processes

Hire Now