Business And System Analyst Resume
Pittsburgh, PA
SUMMARY
- 9+ years of Financial and Banking Business Analysis experience with the ability to work independently and manage business expectations with a delivery - focused approach to work; ability to build and maintain strong working relationships with senior and junior business sponsors, as well technical specialists.
- Proficient and Experienced in Agile Management and Software Development with Extreme Programming, Scrum, RAD and “Agile”
- Strong Financial Services/Banking experience, including projects in support of Confidential .
- Proficient in writing SQL Queries, BPM Modeling, XML/XSD, XSLT, XQuery, Data Mapping, Data Transformation
- Champion of Agile principles and values across all organizational levels
- Experienced in documenting the "AS-IS" and the "TO-BE" process flows using BPMN 2.0 and Microsoft Visio
- Project Management, Scheduling Techniques, Critical Path method, Resource Management, Budget Management
- Proficient with Microsoft Project Plan (MPP)
- Experience with Data warehousing ETL tool like Informatica WebCenter.
- A self-starter proficient in working independently and with cross-functional teams.
- Critical thinking, decision making and problem solving skills
- Proven ability handling multiple projects simultaneously and working in high pressure and time crunch situation.
- Preparing Dashboards in Excel and generating reports by writing SQL queries
- Transition BAU applications and assist with the remediation of security part of the application
- Familiar working with various types of Financial and Banking Data.
- Experience interacting with Internal Product Teams, External Customers & Vendors to gather and understand high level Business Requirements based on identified Scope items. Document all Business Requirements, Business Process Scenarios, and Business Process Flows in Business Requirements Document (BRD) and documenting all High Level and Detailed Scope Items in Scope Document.
- Experienced in System Development Life Cycle (SDLC), involved in all phases of development from Information analysis, Data modeling and Object oriented design and analysis.
- Experience working with end users to create business requirements. Experience working with development and testing team to create Business level testing requirements, functional specifications and testing cases.
- Proven experience in conducting JAD sessions and delivering various Systems Analysis tasks such as investigating system requirements; translating Business Requirements into Functional Requirements, Use Cases and Page Specifications; document all details in Functional Requirements Document (FRD).
- Create Functional and Technical Use Cases: Expertise in creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams using MS Visio according to UML methodology.
- Hands on experience in MS-SQL. Well versed in writing SQL queries.
- Strong understanding of Business Requirement Gathering, Business Process flows, Business Process Analysis and Project Coordination.
- Excellent requirements gathering and elicitation skills, assessing user needs, interviewing the business area and providing as a liaison between IT and Clien t.
- Experience in writing Project Documentation like Project Charter, Business Requirements Document (BRD), Functional Requirements Document (FRD), Test Reports, Meeting Minutes, Action Items Log, and Issue Logs utilizing MS Word.
- Experienced in creating process flow diagrams and functional Use cases.
- Organized JAD meetings with client to convey the project progress and to solve the problems on the critical path.
- Excellent written and verbal communication skills to manage multiple projects simultaneously from initial conception through design, development, testing and release phases.
- Strong focus on quality. Effective Confidential multitasking and determination in accomplishing overall objectives.
- Outstanding negotiation, facilitation, and consensus building skills.
- Ability to effectively communicate across multiple levels (Executive Sponsors to team members); Ability to communicate technical issues to non-technical individuals.
- Possess a very good understanding of how to interpret customer business needs.
- Ability to work effectively in a team environment.
- Ability to meet deadlines in a fast-paced work environment.
TECHNICAL SKILLS
Web Technologies: JavaScript, VBScript, Java, XML, XSD, WSDL, SOAP
Operating Systems: Windows 2003, XP, Win 7, Unix, Linux
Databases: Oracle Microsoft SQL Server, DB2, MySQL, MS Access
Tools, Technologies and Application Software: Quick Test Pro, Quality Center, MS Office, Internet Tools, MS Visio, C, Java, Cobol, BPM (Business Process Management), BPMN 2.0, Process Modeling, Wireframes, BMC Remedy, SQL, Service Bus, WebLogic Server 11g, HP Quality Center, JIRA, SOAP UI, TOAD, SQL Developer, Microsoft Project Plan (MPP)
PROFESSIONAL EXPERIENCE
Confidential - Pittsburgh, PA
Business and System AnalystResponsibilities:
- Establish and manage governance structure and reporting, project schedules, project reporting
- Project status monitoring, reporting, and coordination of efforts
- Analysis and troubleshooting of Java, JEE applications
- Hands on with Java, XML, schema/XSD, Java Script
- Analysis of application logs of Java applications deployed on WebLogic server
- Extensive experience in estimating resource requirements, budgeting process.
- Used Agile methodology to collaboratively and iteratively deliver solution
- Maintained documentation of the SOX controls within the Compliance Manager system.
- Review user/functional requirements, risk assessments, and validation plans in order to recommend revisions or changes in scope, format, content, and methods of validation execution
- Assess the organization’s maturity level for specific Agile methodologies and develop a strategy to align existing processes with Agile and to scale Agile from the team to the enterprise level
- Coach and support Development team in agile / Scrum best practices
- As part of the Citi GCT (Global Consumer Technology) and ISA (Information Security Administration) project involved with application owners and Team leads to identify non CISS (Citi Information Security Standards) compliance issues.
- Interfaced with user groups to prepare and update Business System Requirements and Specifications for applications involving Infrastructure components, Databases, Web applications, Mainframe and other type of security systems.
- Gather user requirements, analysis and design reviews of data exchange solutions.
- Modeled As-is and to-be processes in BPM using BPMN 2.0 (Oracle BPM Composer and Oracle BPM Jdeveloper 11g)
- Used IBM BPM (Lombardi and Blueworks Live) v8.5 for process modeling
- Building UI prototypes using HTML and wireframes
- Presenting UI screen mocks to business users and technical developers
- Using JIRA, Wiki for collaboration
- Used project coordination skills on projects using Waterfall, and ITIL
- Develop and apply organization-wide ID Administration models to support the migration from local ISA (Information Security Administration) groups of the Center of Excellence.
- Work with software development engineers on business and functional requirement documents.
- Perform validations for the applications to meet the IT security standards.
- Transition all Global Business system applications to Information Security Administration (ISA) centralized center of excellence and ISA teams
- Responsible for understanding requirements from internal business department and playing a liaison role for COE and Internal Business
- Worked with automation team to automate applications that are high in volume
- Remediation: Connect with CMT to evaluate risks associated with applications
- Work with Audit, Risk Management, Assurance, and Compliance monitoring team to provide required document/information
- Work with BISO and Subject Matter Experts to evaluate the risk and come up with a compliant solution
- Validates the applications are developed according to the business requirements.
- Work with automation team on automating the web-based applications by explaining the business work flow to the automation team.
- Involve in training the team and resolving the tickets raised by the end users to perform ISA functions (Information Security Administration).
- Key coordinator between multiple project teams to ensure enterprise-wide consolidation of ID administration and controls into the Centers of Excellence.
- Provide group facilitation and additional forms of knowledge transfer.
- Interacted with the Subject Matter Experts (SME’s) and stakeholders to get a better understanding of client business processes and gathered business requirements.
- Created detailed Process Control Manuals (PCM) and documentation for various Citi third party applications during the initial discovery phase of the project.
- Defined and updated PCM (process control manuals) for various applications by interacting with the application owners and Subject Matter Experts (SME’s).
- Performed extensive requirement analysis including data analysis and GAP analysis.
- Developed business requirement specification documents as well as high level project plan.
- Designed and developed project document templates based on SDLC methodology.
- Created Traceability Matrix to reflect how the Business Requirements, Confidential a high level, will be satisfied throughout the lifecycles (Requirements, Design, Build and Testing) of the project.
- Liaise with Business Owners, Business Information Security Officers (BISOs) and Technical Information Security Officers (TISOs) to perform root cause analysis and coordinate entitlement remediation for in-scope applications.
- Experience in designing, implementing and managing Infrastructure, AD, LDAP based applications.
- Sound knowledge in Identity Management in the following areas:
Confidential
Business and System Analyst
Responsibilities:
- Model the Business flows using the Oracle BPM Tool Create Change Management Documentation as needed to support the new initiatives Tracks and Reports Project activities
- Writing XSLT, XQuery for data transformation
- Writing HTML, Java Script for web pages
- Tested key Sarbanes-Oxley (SOX) controls over financial reporting
- Defined SOX compliance techniques and procedures; created procedural documents as part of audit requirements.
- Defining the project scope, gathering and formulating business requirements, translating requirements into functional specifications.
- Developed implementation project plans including installation interval, partner/customer expectation and responsibilities
- Communicate expectations and project scope to minimize risk and maximize customer satisfaction.
- Coached development team, Product Owner, and business on agile principles and practices
- Involves regular communication with IT and Business to agree on the system solution and, ensuring business requirements are delivered and change requests are managed .
- Conducting facilitation sessions with cross-functional team of business Subject Matter Experts.
- Participate and work with clients to scope, identify and Analyze applications to be included in ETL process
- Train new staff on the business process and system architecture to bring them Confidential par.
- Conducting SCRUM meetings on daily basis and ensuring the progress of work as per deadlines for each release
- Develop Test Scenario, Test Plan creation and reviews to ensure requirements coverage according to the source to target mapping document. Ensure Test Execution and defect management
- Performed Data profiling and Data Cleansing on source to compare with list of valid values while mapping source to target and writing exception cases if necessary.
- Conducting JAD sessions with software development team along with the business stakeholders.
- Involved in debugging mappings, recovering sessions and developing error-handling methods.
- Involved in identifying the defects and developed Defect Tracking report using Quality Centre this involved Bug life cycle.
- Identify and document business rules, dependencies, assumptions, risks, supportability, performance and training needs.
- Identify and documented issues, risk and Gaps, their descriptions, their impact and provide recommendation and alternatives to develop the application to meet the user requirements.
- Lead requirements review sessions with a team comprised of systems and junior analysts.
- Interviewing and coordinating sessions with clients to identify business requirements.
- Writing detailed functional solutions to ensure business requirements are met.
- Work with project manager to reduce project delays and costs of implementation.
- Participation in the creation of Use Case models and the writing of corresponding Use Cases produced .
- Coordinate with QA team for load testing and other different QA requirements .
- Reviewed test plan and test cases prepared by QA and coordinate defects and fixes online with business users and developers .
Confidential
Business and System Analyst
Responsibilities:
- Collected, documented, and managed enhancement requests from internal and external sources
- Worked with project team members to collaboratively develop end-to-end process flows and test cases
- Worked on Billing System (Ericsson BSCS) to define different rate plans for corporate and retail customers
- Integration of Billing System (Ericsson BSCS) with Order Management System
- Telecom Order Fulfillment for New Order, Modify Order, Cancel Order for both Pre-Paid and Post-Paid plans
- Maintained updated project and system documentation as changes are made along the development cycle
- Developed process flows, activity, and class diagrams using Visio and BPMN 2.0
- Involved in keeping project details up to date in MS Project and making sure that we meet targets as per time allocated in Project Plan.
- Train new staff on the business process and system architecture to bring them Confidential par.
- Helped analyze test plans, including definition of testing requirements; testing criteria, test scripts, user acceptance conditions and end-to end test requirements.
- Written SQL queries to retrieve data from SQL server 2000 data base
- Prepare Maintenance documents for defects and enhancements for monthly releases
- Analyzes, Plans, organizes, schedules, develops and directs projects; Interfaces with Senior and middle management; Liaison between programmer and users
- Process Modeling for various business processes such as Order Management, Order Fulfillment
- Preparing Dashboards in Excel and generating reports by writing SQL queries.
Confidential, NY
Business Analyst
Responsibilities:
- Perform mapping, gap analysis and lead business analysts’ team in the requirement gathering and testing process and interviewed team members Confidential all levels of the organization to understand business drivers and prioritized requirements
- Proposed and led full SDLC lifecycle for legacy mindset to new highly dynamic and scalable system.
- Lead the team of analyst to create and review business requirements document with Functional and supplemental specifications including use cases to ensure completeness, accuracy.
- Identify and document business rules, dependencies, assumptions, risks, supportability, performance and training needs.
- Experience developing and manages all appropriate project management documents, including project plan, resource estimates, project budget, project schedule, team roster and assignments, issue management, risk management, change control, and periodic status reports.
- Involved in keeping project details up to date in MS Project and making sure that we meet targets as per time allocated in Project Plan.
- Train new staff on the business process and system architecture to bring them Confidential par.
- Helped analyze test plans, including definition of testing requirements; testing criteria, test scripts, user acceptance conditions and end-to end test requirements.
- Written SQL queries to retrieve data from SQL server 2000 data base
- Prepare Maintenance documents for defects and enhancements for monthly releases.
- Make recommendations for “buy vs. build” decision.
- Understanding of various aspects of Insurance business like documentation of NB (New Business), policy administration, Sales and Marketing, Accounting, Actuarial, Underwriting, Claims, Products Pricing, Quality, Risk Analysis, AML guidelines, KYC Norms, SOX Rules etc
Confidential
QA Analyst
Responsibilities:
- Executed Test Case in Test Lab module in Quality Center
- Created macros in Excel to create product reports for senior management
- Responsible for GUI, Functional and System Testing involved in execution, status report, issue tracking
- Responsible for Functional Testing using QTP
- Generated Reports & Graphs and documented
- Preparation of weekly and monthly status reports
- Clear look on updating concepts and finding defects, sending it with suggestions