Business System Analyst Resume Champaign, IL - Hire IT People

SUMMARY:

6+ years of experience in IT industry on Analysis, Design, Development, Implementation, and Maintenance for Banking Domain Application which deal with Capital Markets and Investment Banking.
Strong experience working in Software Development Life Cycle (SDLC) using various methodologies including RUP, Agile, Waterfall, and other client specific internal methodologies.
Experience in interacting with business users and executives to identify business needs, gather Requirements and authoring business Requirement Documents (BRD), Functional Requirements Documents (FRD), Use Case Diagrams, Activity Diagrams and State Diagrams and UI diagrams using UML modeling.
Having Good knowledge in Excel macros(VBA), have developed several tools to reduce the redundant time - consuming application works
Good Knowledge in Excel formulas and macros
Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR)
Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Impact Analysis, Cost benefit analysis, Portfolio Analysis and ROI analysis.
Effectively monitored the Defect Tracking process in the functional, integration and regression test phases of the project. Creating and maintained Requirement Traceability Matrix (RTM) using MS Excel
Documented Test Plans, tests cases, test data, and experienced results for the User Acceptance Testing (UAT). Familiar with database testing using SQL.
Familiar with Core Java, Java script, and HTML, AWS applications.
Working experience of Big Data, SAS jobs, Handling of Metadata, consequently the Real time data transfer and Batch jobs using real time tools such as Hadoop, NiFi and Cassandra, Meta GUI,
Collabra, API calls and their corresponding mappings for Data transformation, persistence and logs.

TECHNICAL SKILLS:

BI Software/ Programming languages: Tableau, SSAS.

Platforms: Windows, Microsoft, Stored Procedures, MVS, DB2 Utilities, IBM utilities

Tools: Microsoft Office (Word, Excel, PowerPoint, Access), ETL.

Data Platforms: DB2, Oracle, MS/Access, MS SQL Server 2014, MySQL.

Languages: SQL, PLSQL.

PROFESSIONAL EXPERIENCE:

Confidential, Champaign, IL

Business System Analyst

Responsibilities:

Prepared technical reports by collecting, analyzing and summarizing information and trends.
Working in the Data cleanup process of the already existing system from upstream to downstream.
Creating the BRDs, Project process flows and User guides to define the workflow within the systems.
Creating the system and users Entitlements for separation of duties purpose and define the work flows for data stewards and their approval process.
Involve throughout the transitioning phase of waterfall into agile and the business solution development life cycle (SDLC) as a business system analyst.
Heavily worked in SQL management, risk management and Metadata management tool to identify the sources for the application and data mapping and data cleanup process.
Updated project approvals and documents in SharePoint and Confluence.

Environment: Agile, Outlook, Blue Print MS Office, JIRA, Confluence, MS Visio, MS Access, SQL Management Server.

Confidential

Business Analyst

Responsibilities:

Associated with the business users, business analysts, system analysts, architects and team lead to understand the business requirements.
Created the detailed design document and technical artefacts.
Performed data profiling, validation and scrubbing, which will be used to make decisions regarding how to measure business rules.
Extensively worked to optimize performance by creating session level partitions, disabling and enabling indexes and fine tuning the SQL.
Deployed and supported the staging, pre-prod and production deployments successfully.
Accomplished the change requests and deployed on timely manner.
Generated adhoc Tableau reports on demand for providers.
Good knowledge on Tableau Metadata tables and Post gre SQL.
Handling of Tableau migration and scheduling.

Environment: UML, RUP, Outlook, MS Office, MS Project, MS Visio, Clear Quest, Rational Clear Case, SQL Server.

Confidential

System Analyst

Responsibilities:

Creating & Modifying Stored Procedures, Views, Functions, Tables, Indexes
Created complex T- SQL queries, expert in developing T- SQL (DDL, DML, DCL) statements.
Working with database administration operations in a Microsoft SQL Server environment.
Data modeling, query design and optimization, stored procedures.
Managing security, monitor server performance and activities.
Monitoring Replication configured in our environment.
Monitoring Disk spaces fail jobs and Trouble shooting.

Environment: Agile, UML, Requisite Pro, Rational Rose, Clear Quest, SQL, Windows, MS Office Suite (Word, Excel, Access, Power Point, Outlook), PL/SQL, Oracle

We provide IT Staff Augmentation Services!

Business System Analyst Resume

Champaign, IL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship