Sr. Business Systems Analyst Resume
Cincinnati, OH
SUMMARY
- Business Systems Analyst working in IT Industry for about 8+ years, which includes Application Development, Business Development Process and System and Data analysis.
- Experience with working in the domain of Finance, Insurance, and Banking.
- Seeking a position in the challenging and creative environnent where I can enhance my skills; gain hands - on experience and contribute towards the goals of the organisation.
- Proficient in SDLC methodologies like Agile Scrum, Waterfall and have a thorough understanding of RUP, Spiral, Kanban and other methodologies.
- Extensive experience in discovery sessions, interviews, focus groups,JAD sessions, prototyping, document-reviews.
- Experience in conducting GAP, SWOT, Root cause, Feasibility study, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis.
- Experience in Business process re-engineering, Business process improvements, Historical Data Reports Analysis and creating Business Requirements documents (BRD), Use-Case Specifications and System Requirements Specifications (SRS).
- Well acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams.
- High experience in tracing requirements throughout the development process and verifying to Requirement Traceability Matrix (RTM).
- Facilitated Sprint Ceremonies (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master.
- Experienced in writing User stories and handling the Requirement Churn. Efficient in performing, prioritizing techniques, MoSCoW, KANO and Business Value Based.
- Experience in Using Estimation techniques, Planning Poker, T-shirt sizing.
- Involved with extensive client interactions and converting Business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments.
- Experience supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
- Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, Proven leadership capabilities and Time management skills.
- A proactive and dedicated team player, with proven track record in producing high quality work under tight deadlines and multi-tasking to meet business goals.
- Provide technical expertise and recommendations in assessing new IT software projects and initiatives to enhance current systems processing.
- Experienced in SOA, Web Services, XML, REST, JSON, API, client side, and server side validation. Have knowledge on SOAP, REST (GET, POST, PUT and DELETE) methods.
- Knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Experience in Data Analysis, Data Mapping, Data Modeling, Entity Relationship, and other diagrams.
- Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
- Strong knowledge of SQL, data analysis and data validation using SQL.
TECHNICAL SKILLS
Project Management Tools: Unified Modeling Language (UML), MS-Project, MS SharePoint 2013 SharePoint 2010, SharePoint 2007
Requirement Management: MS Office, JIRA, Rally, HP ALM 11.5.
Reporting Tools: IBM Cognos, Tableau, MS office Suite
Databases: MySQL Server 2012, MS Access, Oracle 9i,10g, IBM DB2
Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint 2013, MS Project, MS Visio
Testing Tools: HP QC, HP ALM 11.5, Load runner, Bugzillla and SOAP UI, Selenium.
ETL Tools: Informatica PowerCenter, Microsoft SSIS, IBM Data Stage
Languages: Java, HTML, CSS, JavaScript, python, PL/SQL.
Other Tools and Frameworks: Eclipse, Bootstrap, Chef, AWS, J2EE servlets and JSP, web Services (SOAP and REST), SQL developer, IBM Data Studio
PROFESSIONAL EXPERIENCE
Confidential, Cincinnati, OH
Sr. Business Systems Analyst
RESPONSIBILITIES:
- Conducted GAP Analysis to derive requirements for the project to be implemented.
- Used Agile Scrum - waterfall Hybrid SDLC methodology.
- Interviewed Business users for eliciting requirements using JAD sessions, Survey/Questionnaire, Interviewing, Focus Groups and analyzed the feasibility of the requirements and acted as a liaison between the business users and the technical team.
- Elicited requirements from the stakeholders and analyzed them for consistency, completeness and flexibility.
- Conducted User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria for Potentially Shippable Product Increment.
- As a Scrum Master I facilitated Scrum events including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
- Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
- Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
- Analyzed the Iteration Burn Down charts and reviewed defects.
- As experienced Scrum Master always did my best to solve any impediments for the team and keep them focused on the goal of the sprint. Used SharePoint 2013 as the collaboration tool.
- Used JIRA for issue tracking, user story management and requirement traceability.
- Assisted with User Acceptance Testing, developing and maintaining quality procedures. Assisted in Black box, UAT and Regression testing. Was involved in Data Analysis.
- Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
- Worked on Service Oriented Architecture(SOA) using SOAP and REST web Services.
ENVIRONMENT: Scrum -waterfall Hybrid, MS Visio, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint), MS Project, SOA, web services (SOAP),Spring MVC, J2EE, JBoss Enterprise SOA platform, Bootstrap 3.3.0, oracle 10g.
Confidential, New York
Sr. Business Systems Analyst
RESPONSIBILITIES:
- Worked closely with the Business users and the Product owner in understanding the requiremnts,elicit and analyse them.
- Worked closely with the team to make them understaand the requirments.
- Used Agile Scrum SDLC methodology.
- Interviewed Business users for eliciting requirements using JAD sessions, Survey/Questionnaire, Interviewing, Focus Groups and analyzed the feasibility of the requirements.
- As a Scrum Master worked closely with the team in making the scrum process smooth.
- Time boxed the sprint ceremonies suc has daily stand-up, sprint-review meeting,sprint retrospective meeting and made sure the team was focused on the goals.
- Helped the team resolve any impediments.
- As Scrum master tracked team velocity and Sprint progress using Sprint Burn down Chart
- Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing and logged down defects using JIRA.
- Handled Requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the Triple Constraint and discussing them in Daily Scrum.
- Used SQL Queries to generate visualization in Tableau.
- Worked on generating various reports using Tableau.
ENVIRONMENT: Scrum, MS Visio, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint), MS Project SDLC, Oracle 9i, J2EE, JBoss 7.1.0 Application Server, Tableau.
Confidential, Los Angeles, CA.
Sr. Business Systems Analyst/Data Analyst
RESPONSIBILITIES:
- Used Waterfall SDLC methodology.
- Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems. Used SharePoint 2010 as the collaboration tool.
- Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
- Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
- Assisted in creating Data Dictionaries, Data Mapping template and in creating Data modeling.
- Developed Conceptual and Logical Data Models.
- Assisted in Designing data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks. Performed Data Mining to make find any correlation and patterns in the data.
- Used SQL for generating reports and also to validate and analyze data.
- Involved in slicing and dicing of data marts for analytical decision making support.
- Performed Data Analysis,experience in Data Mapping and making Data Dictionaries and with the Extract, Transforma nd Load process(ETL).
- Worked on generating reports using Tableau which would help higher management people to understand the bigger picture.
ENVIRONMENT: Waterfall SDLC, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL Server 2012, Informatica PowerCenter, Tableau.
Confidential, Owings Mills, Maryland
Sr. Business Systems Analyst/Data Analyst
RESPONSIBILITIES:
- Used Waterfall SDLC methodology.
- Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
- Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
- Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
- Was involved in creation of Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS).
- Analyzed, modified and validated these documents.Was also involved in creating the low level document(LLD)
- Created Data Mapping template and assisted in creating Data modeling.
- Developed Conceptual and Logical Data Models.
- Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
- Was involved in data miningfor analyzingdatafrom different perspectives and summarizing it into useful information - information that can beusedto increase revenue, cuts costs, or both.
- Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
- Identified Source systems for data profiling .
- Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
- Designed and developed all Use Cases and UML models using MS Visio.
- Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
- Establish Incident Reporting and Change Control procedures.
- Assisted in generating reports for facilitating in the decision making process for higher management.
- Worked closely with the ETL team using the IBM Data Stage for Extraction, Transformation and loading of the data.
- Assisted in Data Analysis and helped in Data Mapping and creating Data Dictionaries.
- Used SQL queries to validate and verify the data.
- Used SQL to generate report in the IBM Cognos.
ENVIRONMENT: Waterfall, MS Visio, MS Office Suite (MS word, MS Excel, PowerPoint), IBM DB2, Web Sphere 7.0 Application Server, IBM Cognos, IBM Data Studio, IBM Data Stage
Confidential
Business Analyst
RESPONSIBILITIES:
- Involved in the Requirements collection & Analysis from the business team.
- Acted a liaison between Business Users and the technical team.
- Worked on building the Work Breakdown structure using the MS Project.
- Gathered requirements and worked on making the BRD artifact.
- Made the SRS artifact from the BRD.
- Used MVC design pattern for efficient development of the application.
- Used J2EE servlets and JSP for building the new features in the web application.
- Helped the QA team in writing the test cases and carrying out the integration testing
- Successfully deployed the application in the production Environment.
ENVIRONMENT: HTML, CSS, Java Script, J2EE, MVC architecture, Apache Tomcat.
Confidential
Java Developer
RESPONSIBILITIES:
- Involved in the Requirements collection & Analysis from the business team.
- Created the design documents with use case diagram, class diagrams, sequence diagrams using Rational Rose.
- Implemented the MVC architecture using Apache Struts1.2 Framework.
- Implemented Action Classes and server side validations for account activity, payment history and Transactions.
- Implemented views using Struts tags, JSTL2.0 and Expression Language.
- Implemented session beans to handle business logic for fund transfer, loan, credit card & fixed deposit modules.
- Worked on the JAVA Collections API for handling the data objects between the business layers and the front end.
- Implemented the Web Services client to consume the third-partyservice API for validating credit cards.
- Used XML,Web Services using SOAP to transfer the amount to transfer application that is remote and global to different financial institutions.
- Used Java Messaging Services (JMS) for reliable and asynchronous exchange of important information such as payment status report.
- Developed Unit test cases using JUnit.
ENVIRONMENT: Apache Struts 1.2 Framework, JSTL2.0, Servlets, JSP, SOAP web services, JBoss, Oracle9i
Confidential
Java Developer
RESPONSIBILITIES:
- Designed and developed critical modules of the system.
- Involved in development new Controller Classes.
- Involved in JSP’s development for the application.
- Participated in Unit and end to end testing of the application.
- Designed and developed Use Cases, Class diagrams and sequence diagram using UML.
- Configured rules engine for new reports based of requirements and reports generation.
- Worked closely with the Testing team to make sure there were no bugs in the application
ENVIRONMENT: UML, MVC architecture, J2EE Servlets &JSP, Apache tomcat, oracle 9i
