We provide IT Staff Augmentation Services!

Business Systems Consultant Resume

New York, NY

PROFESSIONAL SUMMARY:

  • Experienced in application development and support with excellent communication skills in client interfacing, requirement gathering, project management, user support, quality assurance, problem solving, and documentation.
  • Extensive experience in documentation of business requirements BRD and system functional specifications FRD/FSD.
  • Expert in Informatica Master Data Management (MDM), with extensive experience in creating and managing centralize system of records and then distributing to downstream system.
  • Experienced and knowledgeable in Insurance, Finance, Banking, Healthcare, Telecom, Retail, HR / Payroll, Supply Chain & Logistics, Pricing, POS, E - commerce.
  • Experienced in managing both on-shore and off-shore teams of Business Analysts, Developers, and Quality Analysts.
  • Experience in business consulting involving business process improvement and identifying strategic options for clients using various methods such as As-Is and To-Be process maps, functional maps and gap analysis.
  • Self-starter with excellent communication, negotiation, and organization skills with good attention to detail; work well in a team or independently.
  • Good understanding of project management techniques and the use of MS-Project for project management.
  • Expertise in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and tracking of results.
  • In-depth understanding of various Fixed Income instruments and their analytics, characteristics and benchmarks with knowledge of derivatives and its processes.
  • Assisted and worked as Project Manager on various Product Deployment / Project Management activities, like planning product backlog, spring backlog, keeping track of project status, identifying gaps in development plans, Compliance Issues, and resource planning.
  • Knowledge of front office software development with an Asset Management, Hedge fund or Investment Bank.
  • Proven knowledge of technical infrastructure, networks, databases and systems as they relate to cybersecurity risk, proficiency with information risk management best practices.
  • Experience and strong understanding of business process analysis in a web-based and clients-server environment.
  • Experienced in business intelligence, data warehousing, metadata, data marts, data extracts, and business architecture.
  • Knowledgeable in HR / Payrolls systems such as SAP, ADP, ACH, etc.
  • Knowledge of telecommunication/cable billing, customer care systems.
  • Experience working with web service APIs using WSDL, XML/JSON, SOAP/REST
  • Experience working with a variety of web technologies such as PHP, MySQL, jQuery, Bootstrap, data structure, HTML5, CSS3, XML and JavaScript. Familiarity with Adobe applications and Google Apps a plus.
  • Build and execute SQL queries for data mining, data quality, and data trend and data structure analysis.
  • Experience in data quality rules/dimensions, cleansing, standardization, and verification processes.
  • Effective product management/product deployment and implementation skills with a proven track record of working cross-functionally across a wide variety of interdisciplinary stakeholders, including engineers, systems developers and designers, marketing, sales, service and trainers.
  • Experience in Information Technology: Business Analysis, Quality Assurance, Smoke Testing, UAT, SIT, Regression Testing, Product Deployment, Project Management, Change Management, Defect Management and Release Management (Clear Quest/Work Group Admin).
  • Extensively used Visio to create UML diagrams, and Adobe tools for Screen Mockups/Interface Designs.
  • Knowledge of Capital Market and understanding of Fund, Investment banking and accounting.
  • Extensive experience in Product deployment/Project Management and Project coordination with emphasis on Change Management and Release Management.
  • Experienced at handling stress, and skilled at multi-tasking and prioritizing tasks in complex projects.
  • Comprehensive knowledge and experience in all aspects of the Software Development Life Cycle (SDLC) which includes gathering requirements, analysis, design, development, testing, implementation, and product deployment. Proficient in object oriented analysis, design and development.
  • Good Understanding of Data Warehousing, data mapping, data mining.
  • Experience in implementing the Waterfall, Rational Unified Process (RUP) and Agile methodologies throughout the various phases of a project
  • Excellent understanding of transformation and validation in ETL context, data profiling, data quality checks, data mapping and Meta data.
  • Experience in Process Modeling using Unified Modeling Language (UML), Use Cases, Sequence Diagrams, Activity Diagrams and Flowcharts.
  • Experienced in defining Business processes, work flow and data flow through use case diagram and use case models.
  • Experienced in creating various kinds of Use Case scenarios, System Use cases and business use cases.
  • Experienced in conducting Impact analysis, Research analysis and Root cause analysis.
  • Thorough knowledge of Business Intelligence concepts and helped in making complex decisions and conducted various kinds of analysis to know the behavior of markets.
  • Competent in using business intelligence tools of enterprise resource planning, online analytical processing (OLAP), data mining.
  • Proficient in writing advance SQL queries for data analysis.
  • Good at data source analysis and data profiling using Oracle Developer, Teradata SQL assistant, etc.
  • In-depth knowledge of Relational database (RDMS) structures, theories, principles and practices.
  • Experienced in organizing JAD sessions with project sponsors, software developers, technical advisory teams and users.

TECHNICAL SKILLS:

Project Methodologies: Waterfall, Agile, Rational Unified Process (RUP)

Project Management Tool: MS Project.

Business Modeling Tools: MS Visio, Axure, Rational Rose.

Requirement Management Tools: JIRA, Rational Requisite Pro

Defect Tracking Tools: JIRA, QC (Quality Center), Rational Clear Quest, Test Director.

Operating Systems: UNIX, Windows, Mac

RDBMS: MS SQL Server, Oracle.

Languages: SQL, HTML, CSS, PHP, Java, VB scripts

Business Applications: MS Word, Excel, PowerPoint, Outlook, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Business Systems Consultant

Responsibilities:

  • Created Business Requirements (BRD)/Functional Specification Documents (FSD) including UI designs, Source to Target mappings, Consumption view Layers, Metadata lineage and data dictionary, use cases, and activity diagrams.
  • Created the Business Continuity plan (BCP) to continue operation during failures. Received success card / thank you letter from Confidential CEO, Tim Sloan, for leading the BCP plan during Confidential widespread outage on February 7 2019.
  • Assisted project manager with project planning, including timeline and resource planning.
  • Created Master Data Management (MDM) Match and Trust rules to create Golden Records / Best Version of Truth (BVT) of data.
  • Acted as subject matter expert (SME) in the team and trained other Business Consultants in the team. Also created and provided materials to downstream consumers.
  • Worked with Architect and Data Modelers to create the architectural design and data model for the application.
  • Extensively profiled data from all sources for data mapping, including hierarchy such as Credit Hierarchy, WF Legal Hierarchy, WCIS Legal Hierarchy, Related Entities, etc.
  • Created Data Dictionary and Meta Data Lineage for EPIC application working with Enterprise Metadata Hub (EMH) team.
  • Acted as SME on EPIC project and assisted both internal and external teams to learn more about the EPIC project and data.
  • Assisted downstream consumers and Project & Oversight team to better understand data and to create SQL queries.
  • Extensively review Information Classification Matrix with data modeler and architect to Mask data and ensure data is shared with specific partners only on need to know basis.
  • Worked with partners to create and update service level and operational level agreements (SLAs/OLAs).
  • Acted as a liaison between the client area and technical organization by planning, conducting, and directing the analysis of highly complex business problems to be solved with automated systems.
  • Created project task lists and estimated work efforts based on business requirements by leading cross - functional team meetings including relationship managers, project sponsors, business analysts, project managers, development teams, and quality analysts.
  • Provides technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet
  • Business requirements in a Data Warehouse environment.
  • Works with user groups to provide, resolve questions, assess user needs, and recommend changes.
  • Acts as an internal consultant within technology and business groups by using quality tools and process definition/improvement to re-engineer technical processes for greater efficiencies, provided direction and guidance to less experienced staff.
  • Data Management & Insights (DMI)
  • Project & Oversight team (i.e Data Quality team)
  • Enterprise Metadata Hub (EMH)

Environment: MS Visio, Teradata, Informatica MDM, Oracle, MS Suite, QC/ALM, SharePoint, SQL, SDLC, Data Warehouse.

Confidential, Philadelphia, PA

Lead Sr. Business Analyst

Responsibilities:

  • Worked closely with business team to gather business requirements and analyzed the program to increase efficiency.
  • Created Functional Specification Documents (FSD), Software Requirement Specifications (SRS), Use Cases, and Flows.
  • Lead Confidential on-shore and offshore team of Six (6) Business Analysts and Quality Analysts.
  • Worked as Lead / Sr. Business Analyst for the onshore team, and worked on complex tasks.
  • Worked and trained other Business Analysts in the team to develop requirement documents.
  • Identified business needs and analyzed gap between the need and capabilities.
  • Served as business liaison between business areas, senior leadership, IT development and support teams.
  • Confidential currently uses Encompass by Confidential to originate and process loans, but that system is very slow and not very user friendly. Confidential recently started using iMP for Loan origination; I worked on design and creation of IMP, and also worked on data migration from iMP to Encompass.
  • Reviewed business & user requirements, system requirements and technical design specifications.
  • Used SQL for digging up the data for research and analysis.
  • Worked with developers and business management teams to resolve defects and making any mapping changes if required.
  • Use knowledge of Mortgage, Financial markets, Instruments and Fixed Income to design the application.
  • Worked closely with the Marketing teams to address their technical requirements.
  • Worked extensively on MS VISIO and other MS SUITE tools in creating the process flow and data flow diagrams.
  • Worked on FastPass (Time Sensitive / Quick Turnaround) technical requirements, create Change Requirement Documents, Configure Encompass, Quality Test, and Release within one to two weeks.
  • Worked on the Change Request Process and Created the CR’s
  • Interacted with internal and external teams to analyze impact on the existing system when new changes are implemented.
  • Modeled business processes with emphasis on workflow driven requirement engineering and identified areas of improvement.
  • Worked with data warehouse containing data from different financial clients like FNMA, FHA, VA etc.
  • Reviewed test cases and defects created by QA team. Analyzed and worked with team members to resolve the defect.
  • Prepared and communicated daily status report to management and team.

Environment: MS-Project, Visio, MS Suite, QC/ALM, SharePoint, Java, .Net, SQL, MS Office.

Confidential, Minneapolis, MN

Business System Analyst

Responsibilities:

  • Created Functional Specification Documents (FSD), Software Requirement Specifications (SRS), Use Cases, and Flows
  • Identified business needs and analyzed gap between the need and capabilities.
  • Conducted meetings with cross-functional team and came up with all required documentation throughout different phases of the project abiding by the quality standards of the company and meeting the scheduled time frames and stay within budget.
  • Served as business liaison between business areas, senior leadership, IT development and support teams.
  • Reviewed business & user requirements, system requirements and technical design specifications.
  • Use knowledge of Mortgage, Financial markets, Instruments and Fixed Income to design the application.
  • Worked extensively on MS VISIO and other MS SUITE tools in creating the process flow and data flow diagrams.
  • Maintained requirement traceability matrix in MS excel and HP quality Centre.
  • Created Source to target mapping from Database to XML schemas.
  • Conduct JAD sessions with business to elicit the requirements.
  • Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, Budget, Release Management, and Compliance Issues.
  • Created Business Requirement Documents (BRD) after identifying all the user requirements.
  • Worked closely with developers to review and validate Current State Documentations.
  • Participated in Functional Specifications Document (FSD) reviews and responding to questions related to the mappings, modeling and processing logic flows.
  • Responded to user’s defects/questions and making changes to the mapping document if necessary.
  • Worked on the Change Request Process and Created the CR’s
  • Interacted with internal and external teams to analyze impact on the existing system when new changes are implemented.
  • Modeled business processes with emphasis on workflow driven requirement engineering and identified areas of improvement.
  • Worked with data warehouse containing data from different financial clients like USDA, FNMA, FHA, Rules, SMDU etc.
  • Participate in Smoke Testing, User Acceptance Testing (UAT), Regression Testing, and System Integration Testing (SIT).
  • Reviewed test cases and defects created by QA team. Analyzed and worked with team members to resolve the defect.
  • Integrated the changes in functional requirement as per the discussion with the UI/UX teams.
  • Used SQL for digging up the data for research and analysis.
  • Coordinated with various teams onsite and offshore to make the project a success.
  • Worked on multiple releases simultaneously.
  • Worked with developers and business management teams to resolve defects and making any mapping changes if required.
  • Involved in GAP analysis through various project phases.
  • Created use case diagram using UML and managed the entire functional requirements lifecycle using AGILE.
  • Involved in handling business intelligence and responsible for implementation and delivery.
  • Interacted closely with SMEs to understand and visualize the problem domain.
  • Prepared and communicated daily status report to management and team.

Environment: J2EE, Java, MySQL 5.5, Tomcat 7, IBM MQ 7.5, Oracle 10g, SQL, UNIX, HP Quality Center, MS Office, Waterfall, SharePoint, Data modelling and mapping, Data Warehouse and Data Validation.

Confidential, Edina, MN

Project Manager / Sr. Business Analyst

Responsibilities:

  • Worked closely with Confidential leaders / executives to gather business requirements and analyzed the program to increase efficiency.
  • Supervised and Lead the Development, Testing, and Operations teams; scheduled and managed production releases.
  • Worked closely with BIW teams: 1) Implementation Team, 2) Communication/Marketing Team, 3) BIW’s Confidential Reward System Team, 3) BIW’s AT&T Reward Management Team, 4) BIW’s Vendor HR / Payroll Management System team, and 5) Project Leaders.
  • Worked with Confidential ’s Finance team/system and CitiBank to integrate Confidential ’s LTS system with CitiBank’s to provide LTS specific debit card to Confidential ’s 26,000+ employees.
  • Worked closely with internal and external teams to enhance/implement the HR / Payroll systems to manage the payment process to users.
  • Documented Salesforce CRM functional specifications and CRM configuration as member of support team. Worked on Setup and implemented Role and Hierarchy structure.
  • Worked with various Confidential teams, channel managers, national operation groups, and program participants.
  • Managed Workload list and lead IT Status calls every Tuesday with the National Operation Group leaders.
  • Worked with ITA group ( Confidential ’s previous vendor) for data transition planning.
  • Assisted Vice-president of the project to revise statement of work.
  • Assisted Project Director in resource planning, revising project timeline, and managing task to development tram.
  • Worked and trained other Business Analysts in the team to develop requirement documents.
  • Lead multiple development efforts, ARZ site, Web reports development, Push Reports development, Import/Export file automation, Periodic Checking Process, and Payout Process.
  • Met with client groups to determine user requirements and goals.
  • Proficient in Team Foundation Server and Pivotal tracker/Chili/NetSuite bug tracking tool, MS Project, FTP tools, SQL queries.
  • Conducted JAD sessions to understand the detailed requirements.
  • Created Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Metadata mapping and data definiations, Use cases, and Activity Diagrams.
  • Gathered the requirements, developed process models and detailed Business Policies, and modified the business requirement document.
  • Used JIRA to manage the development of the projects, and assisted project director to create sprint backlog.
  • Created and setup Salesforce reports and dashboards for tracking performance metrics related to case closure and case escalations
  • Assisted and worked as Project Manager on various Product Deployment / Project Management activities, like planning product backlog, spring backlog, keeping track of Project Status, identifying gaps in development plans, Compliance Issues, and resource planning.
  • Created and validated business requirement documents (BRD) and the technical specifications as per user requirements.
  • Worked closely with the technical team and project manager to analyze, document and optimize on the durations and resource allocations on the project.
  • Supported data migration team in executing, managing and monitoring regular data loads in the Salesforce production instance
  • Prepared the Business Workflow using MS-Visio with input, output, pre/ post conditions.
  • Helped with conflict resolution between the client groups and the development team.
  • Worked with developers to test the iterations of the system under development (SUD) to ensure it met the users’ needs.
  • Actively participated in enhancement meetings. Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.

Environment: MS-Project, Visio, Axure, Requisite Pro, Agile, Clear Quest, QC, QTP, Jira, SharePoint, Oracle, Scrum, Java, SQL, Scrum, MS Office, WebSphere.

Confidential, Minneapolis, MN

Business System Analyst

Responsibilities:

  • Worked with eight groups simultaneously (5 business Committees, Vendor, Quality Analyst Team, Functional team)
  • Actively participated in enhancement meetings. Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.
  • In-depth knowledge of Healthcare domain to ensure research complies with rules and regulations
  • Met with client groups to determine user requirements and goals.
  • Frequently present findings and solutions at large groups meetings to ensure every group is on the same page.
  • Negotiated with different groups to find the best solution that meets everyone’s need.
  • Created Mockup, Use cases, Activity Diagrams, Functional Design, and Data elements.
  • Assisted the customer in defining the high-level Functional Requirements and needs.
  • Gathered the requirements, developed process models and detailed Business Policies, and modified the business requirement document.
  • Worked with the Project Manager on various Product Deployment / Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
  • Assembled and validated business requirement documents (BRD) and the technical specifications as per user requirements.
  • Prepared the Business Workflow using MS-Visio with input, output, pre/ post conditions.
  • Worked on project inception to completion and post-implementation review to ensure integrity of applications.
  • Analyzed, documented, and managed all project requirements and changes to requirements throughout the software development lifecycle using Rational Requisite-Pro.
  • Helped with conflict resolution between the client groups and the development team.
  • Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
  • Analyzed team performance with the QA manager and implemented the changes if any with respect to raising the efficiency of the entire team.
  • Worked with developers to test the iterations of the system under development (SUD) to ensure it met the users’ needs
  • Participated and executed Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.

Confidential, Beaverton, OR

Business Analyst

Responsibilities:

  • Work with cross-functional team such as Consumer online, Sales, Product Management, and Engineering, to determine user requirements and goals.
  • Conducted JAD/RAD sessions to understand the detailed requirements
  • Wrote Use cases and Activity Diagrams.
  • Assisted the customer in defining the high-level Functional Requirements and needs.
  • Gathered the requirements, developed process models and detailed Business Policies, and modified the business requirement document.
  • Worked with the Project Manager on various Product Deployment / Project Management activities like keeping track of Project Status, Deadlines, Environment Request, and Compliance Issues.
  • Assembled and validated business requirement documents (BRD) and the technical specifications as per user requirements.
  • Experience facilitating meetings with both IT and Business Users.
  • Working closely with the technical team and project manager to analyze, document and optimize on the durations and resource allocations on the project.
  • Utilized RUP to create use cases, activity, class diagrams and workflow process diagrams.
  • Prepared the Business Workflow using MS-Visio with input, output, pre/ post conditions.
  • Worked on project inception to completion and post-implementation review to ensure integrity of applications.
  • Analyzed, documented, and managed all project requirements and changes to requirements throughout the software development lifecycle using Rational Requisite-Pro.
  • Helped with conflict resolution between the client groups and the development team.
  • Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
  • Analyzed team performance with the QA manager and implemented the changes if any with respect to raising the efficiency of the entire team.
  • Worked with developers to test the iterations of the system under development (SUD) to ensure it met the users’ needs
  • Participate in Smoke, UAT, and Regression testing.
  • Actively participated in enhancement meetings. Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.

Confidential, Goodlettsville, TN

Business System Analyst

Responsibilities:

  • Involved in gathering, documenting and verifying business requirements.
  • Interacted with stakeholders as well as with SME’s for requirements gathering and specifying the user requirements into functional requirements.
  • Translated user requirements into business requirements that are testable and traceable through business and functional requirements and/or workflow changes.
  • Identified end to end requirements for all systems and business units that may be impacted by the project
  • Defined the timeline for gathering business requirements.
  • Management of E-commerce POS to facilitate the customers.
  • Web Testing in Retail/E-Commerce with different browsers and Operating Systems.
  • Practically worked on E-commerce POS to observe customer’s problems and concerns.
  • Collected and managed requirements to develop efficient E-commerce POS.
  • Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system
  • Worked with customer’s internal business processes and developing detailed analysis of how to effectively deploy SharePoint Services throughout the enterprise environment.
  • Work with business and IT to ensure that risks are clearly articulated in a manner that is understood by business and technology audiences
  • Worked with the Development and QA team to create a demo website for User Acceptance Testing (UAT). Demonstrated the use of the new system to the business unit and ensured that feedback was relayed to the development team.
  • Developed requirements integrating E-R diagrams and designed the testing process flows.
  • Configure/customize NetSuite application to meet their business requirements.
  • Updated NetSuite records, tasks, dashboards to resolve support requests
  • Followed the RUP methodology for the entire SDLC.
  • Established and maintained traceability matrix until business requirements were signed off.
  • Conducted walkthrough and lead work sessions.
  • Created test files and analyzed test results using MS-Excel.
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process effort in different iterations and phases (Inception, Elaboration, Construction and Transition) of the Software Development Life Cycle.
  • Ensured Use-Cases were consistent and covered all aspects of the Requirements documents.
  • Involved in project status meetings and Coordinated and facilitated the execution of User Acceptance testing.

Environment: Windows XP, UML, SQL, Rational Tools, Axure, MS Visio, MS Word, Excel, PowerPoint, Access, SharePoint.

Hire Now