Lead Systems Analyst Resume
OH
SUMMARY:
- A Business Analyst with extensive experience of over 8 years in business process design, streamlining and gathering requirements in fields as diverse as Retail (ecommerce), Insurance, Identity and Access Management, Mortgage lending and Finance.
- Accomplished Product Owner offering progressive experience in the Agile/Scrum SDLC blend of analytical skill, sales success, and management capabilities.
- Experience writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams (Sequence diagrams, Collaboration diagrams) and Class diagrams based on UML Methodology & Business process flow diagrams using MS Visio.
- Financial analysis of statements was thoroughly conducted and excel spreadsheets were maintained to ascertain various tier levels for customers and maintenance of different credit score levels.
- Strong command on working in a waterfall environment.
- Ability to write strong BRD and FRD’s. Checking and Validating Requirements in conjunction with the stakeholders. Tracing and managing requirements throughout the development process.
- Extensive experience in producing documents like Software Requirement Specifications (SRS), Creating Request for Proposals (RFP), creating Requirements Traceability Matrix (RTM), Statement of Work (SOW)
- Good experience on US regulatory reporting using various reporting tools, OBIEE.
- Ability to work with functional teams in an agile environment, Ensured that user stories are good, has business values and story points.
- Designed training plans and develop a SharePoint curriculum to train customers on SharePoint functionality and encourage self - sufficiency
- Deep knowledge of Ecommerce space including User Interface processes and tools, ability to create and design of information architectures, wireframes, using user-centric design techniques.
- Prepared comprehensive ecommerce process analysis for high end customers.
- Well versed in all phases of Software Development Life Cycle (SDLC) and using Agile and Waterfall methodologies.
- Proficient in Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Experience in developing business processes and system delivery solutions for Point of Sale (POS), e-commerce and payment card systems.
- Experienced in training users and developing training manuals.
- Strong team building, conflict management, time management and escalation protocol skills.
- Excellent communication and interpersonal skills. Well versed in managing multiple projects simultaneously.
- Analyze, create and maintain enterprise master data supporting quote to cash process. Communicate with internal & external customers to address issues and provide support on data quality and integrity improvements.
PROFESSIONAL EXPERIENCE:
Confidential, OH
Lead Systems Analyst
Responsibilities:
- Serves as a liaison between the business client and IT in order to lead develop solutions that meet a business need, typically of low to medium risk and moderate complexity.
- Primary focus on Identity and Access management and lifecycle use cases.
- Creation of Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
- Good understanding of business data flow and data relations, utilized Tableau server to publish and share reports with business users.
- Maintain and manage requirement content via a variety of means and generates System Development Life Cycle (SDLC) artifacts that include source-to-destination data mapping, report requirements, legacy system requirements, business requirements, nonfunctional requirements
- Adheres to SDLC and IT Service Management (ITSM) processes.
- Ensures requirement discipline artifacts can be effectively leveraged by other SDLC disciplines.
- Facilitates requirements review sessions with business and IT.
- Facilitates discussion with business clients for the development and/or enhancement of solutions and/or processes.
- Provide guidance in the development of communication materials, defining of supporting procedures and standards, documenting training materials, and assisting in training efforts.
- Assists with defect or incident root cause analysis in support of mid-level severity incidents and problem management processes.
- Assists with other medium size or mid-complexity functions including vendor coordination, planning, project management, release and change management as assigned.
- Facilitates the identification and analysis of automation alternatives within solutions.
Environment: MS Office, Tableau desktop, Tableau Server, Sharepoint, ATLAS, PING, Secure Auth. Sailpoint, People soft, Duck creek policy processing system
Confidential, Atlanta, GA
Senior Business Analyst
Responsibilities:
- Lead role in the team that implemented a corporate-wide identity and access management solution to centralize management for high risk access
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements for the mortgage LOS
- Tasked with tracking, monitoring and reporting on User Access reviews, Enterprise Role reviews and Access Model reviews across the bank.
- Designed use cases, OBIEE reports and ad hoc tools.
- Converted existing BO reports to Tableau dashboards.
- Tableau data visualization using cross tabs, Heat maps, Box and Whisker charts.
- Ensured the correct balance of access capabilities provided by Access Models and Enterprise Roles to mitigate the risks associated with user access to high-risk applications.
- Provided support for audits, regulatory examinations, and assessments of the information security program
- Fully evaluate the construct and design of all entitlements within the application, leveraging the appropriate resources.
- Put a documented, sustainable process in place to work with the other areas in documenting and understanding their access needs.
- Created and implement communications plan and outreach strategy for communicating governance changes, business efficiencies, and other SharePoint features
- Provide guidance in meeting control requirements, get attestation for Key financial applications such as Loan IQ, Wall Street systems, Impact and Bloomberg trading systems.
- Developed and maintained Segregation of Duties (SoD) rules for high risk access
- Conducted periodic review of Roles and Access Models to ensure accuracy. Consulted with Corporate Audit and Corporate Risk Management on important self identified issues.
- Conducted periodic application risk assessments and scope reviews to ensure that all high risk applications have been identified for centralized provisioning
- Reporting operational, risk and governance metrics for the Identity Access Management program
Environment: BASEL 2 & 3,CCAR, OBIEE, MS. EXCEL, MS SHAREPOINT, LOAN IQ, BLOOMBERG TRADING SYSTEMS, ALGO COLLATERAL MANAGEMENT, AGILE, MS. VISIO, TABLEAU SERVER AND DESKTOP
Confidential, Deerfield, IL
Senior Business Analyst
Responsibilities:
- Work across teams in a matrix environment
- Attend daily scrums
- Pure Agile environment
- Requirement gathering, inception, creating user stories
- Maintaining stories in JIRA and dashboards
- Assigning tasks to Development and Q.A teams and following up
- Working in a 3 week sprint, ensuring timely completion of stories
- Conducting defects triage to ensure proper deletion of bugs
- Collaborate and work with project manager
- Manage the AEM workflow queue for content publishing.
- Attained good knowledge of Architecture, core platform, performance testing and environment issues.
- Involved in designing the Technical Design Documents for the Workflow development process.
Environment: JIRA, Agile, Ecommerce, AEM, Cloud, Endeca, IBM MDM, JAVA, Logstash, JSON, XML
Confidential, Monticello, NY
Senior Business Analyst
Responsibilities:
- Managed end-to-end projects and project teams, focusing on excellence in timeline, budget, quality and customer satisfaction (software delivery, process improvement and third party software evaluation and delivery projects).
- Conducting Joint application development (JAD) sessions for gathering requirements, and Rapid application development (RAD) sessions to converge early toward a design acceptable to customer and Request for Proposal (RFP), Request for Information (RFI).
- Writing user stories for the ordering and product catalog workflow models with the help of wireframes.
- Provided ongoing analysis to upper management and research cost effective ways to gather the information needed to compete in the online space in both ecommerce and Social Media
- Perform “ Confidential ” system study to understand the business process and design “TO BE” system structure
- Identify GAP in various business processes. Conduct discussion sessions with various business owners and redefine business processes for the new POS system.
- Immensely diverse and critical role in a growing organization, encompassing IT Project Manager, Business Analyst and E-Marketing Specialist.
- Worked on Confidential distribution and manufacturing tool to enter Inventory Transactions, perform Inventory Inquiries, Print Reports, and enter category codes. Used the tool to help with the creation of Price Schedules, Adjustments, Hierarchies, and Price Details.
- Solely responsible to extract and document technology strategy and all individual project requirements from executives and develop into an implementation plan.
- Active Directory user Windows administration. (Windows Server 2003).
- Involved in onsite and offshore co-ordination.
- Participated in Retail merchandize, kiosk setup and product promotion activity
- Design customer loyalty program to maintain the purchase history of the customer for rewards program
- Plot process flow diagram and data flow diagram for various modules using MS Visio
- Define business process rules to help implementing SOB (Share of Business) Process for optimizing procurement process, leading 25% increase in smooth order cycle.
- Created Mock-ups to better explain how system works to the retail stores.
- Set up the rules for auto generation of Purchase Order and it can be verified by the retail store manager
- Implement new methods to replenishment inventory based on sales pattern, Min-Max, Days of Inventory, Inventory replenishment based on actual sales and manual order entry
- Responsible for delivering the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business Objects BI and SAP Business warehouse BW platform.
- Built and distributing functional specification documents to BO developers and Business users across the organization.
- Converted BO reports to Tableau dashboards.
- Customer Hierarchy maintenance and updating customer records.
- Involve in database design and write complex query to generate customize reports in SQL.
- Configuring POS DM integration with other SAP components for goods movement types, Values for category codes and Values for sales item category.
Environment: MS Office, OBIEE, Tableau, MS Project, C, MS Visio, SQL Server 2008, MDM, JIRA, Confluence, Confidential Distribution, SAP BI, SAP BO, SAP POS DM.
Confidential, Plano, TX
Sr. Business Analyst
Responsibilities:
- Participated in website development from inception through implementation and maintenance; updated and optimized the online content to improve organic search indexing, rank and conversion.
- Implemented Customer, product, and pricing domains for master data
- Monitored and reported on multiple websites; established dashboards for various decision makers and developed, managed and provided analysis with recommendations using multivariate testing plans focused on optimizing landing pages.
- Developed proposals (RFP), bids, quotations and other documents
- Review digital content authored on AEM platform to validate if it’s meeting business objectives and corporate standards.
- Focused on entirely on the documentation creating Use Case and Test Cases along with UML diagrams.
- Knowledge of Confidential, e-commerce technology platform which supports faster site performance, more effective merchandising and easier management of multiple web sites.
- Gathered business rule for landing pages and microsites housed in Adobe AEM.
- Collaborate with business users of Digital Marketing teams, Vendors, and IT teams to introduce process to implement AEM for the IT/Digital Marketing teams.
- The main focus of requirement gathering involved e-commerce transactions.
- Conducted daily SCRUM meetings during the Sprint Development as a part of Agile Methodology. Also captured and addressed concerns from IT (during SCRUM Meetings) to Product Management or Business Team as needed.
- Successful in managing and setting up the data and configured the components in Sterling order management system.
- Provided best practice recommendations in the areas of Order Management System and CRM.
- Followed Omni-Channel fulfillment strategy for effective delivery related to online orders.
- Involved in all phases of the Iterative approach of the Software Development Life Cycle from Requirement phase to Implementation and effectively used Test Director for implementation of Requirements gathering.
- Conducted walkthroughs with the Development and Test Team members to emphasis the main points of concern with the application.
Environment: Confidential, Endeca. Confluence, Tableau, MS Visio, JIRA, IBM Sterling OMS, AEM Adobe Experience Manager, Confidential
Confidential, Lake Mary, FL
Business Analyst
Responsibilities:
- Drafted Interface Requirement documents.
- Got in depth knowledge of T24, the banking software for Confidential .
- Manage pipeline of conventional, government, and portfolio loans.
- Serve as an intermediary for loan issues with Loan Originators and other related departments.
- Assist in training new hires.
- Worked on interface requiring document regarding commercial lending, loans, mortgages.
- Did in depth analysis and reviewed Testing documents and also prepared TCR’S.
- Captured screen shots from the environment and made sure everything is in alignment.
- Conducted JAD and JRE sessions and participated actively in Team meetings.
- Worked closely with the management and was an integral part of the project steering committee to give essential output regarding revised project plan and how to achieve goals and targets based on my experience.
- Experience with FX, Equities, Derivatives, loans, CCAR, Regulatory reports.
- Familiar with change management.
- The banking software included interface development for online retail banking features
- Documentation was prepared for consumer loans and mortgages listing their functionalities for backend and front end usage.
Confidential, Portland, ME
Business Analyst
Responsibilities:
- Performed Requirement Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
- Superior skill in translating complex and abstract ideas into sound, easily understood technical directions. Excellent team leader skilled in managing people and processes while developing motivated, high performing staff eager to take on challenges and work collaboratively to contribute to the organization's growth plan .
- Responsibility for business analysis and project management of multiple ecommerce initiatives to drive revenue in the payday loan market
- Writing technical documents, RFP/RFI and statement of work and objective to enhance project scope.
- Project experience with commercial and retail banking, investments, FX Trading, brokerage, mortgage industry and automotive industry. Enhancing online process involving commercial lending.
- Evaluate customer Income statement, Balance Sheet, perform financial analysis including cash flow statements, evaluate attainability of cost and profit objectives via alternate strategies.
- Commercial lending experience, with good understanding of debit and credit.
- Performed monthly analysis comparing the monthly interest rate calculation to interest income booked to the general ledger.
- Worked closely with the design team on UX and UI, made sure that it aligns with the business requirement for loan origination functionality deployed in the bank website.
- Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
- Reconciled gain/loss accounts to the general ledger
- Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
- Conducted project kick off meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
- Designed workflows and allocated permissions within SharePoint.
- Prepared scenarios, Use Cases & UML State Diagram for scenarios.
- Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
- Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.
- Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
- Assisted the technical team in translating application functionality into application architecture.
- Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
- US regulatory reporting, such as FRY9-C.
- Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
- Organized meetings to discuss outstanding issues with QA and developers.
- Assisted in online banking issues such as error messages or technical trouble shooting.
- Handled check free (FISERV) bill pay processing. Also processed stop payments.
- Strong record for delivering on IT and Non-IT projects for Home Lending / Mortgage Banking, including process improvement, strategic projects, Government projects, audit / risk projects, modification solicitation programs, and reporting requirements
Environment: Confidential (Oracle), Mainframe, OBIEE, Tableau, CCAR,DocEngine, PEGA BPM, PRPC,Windows NT/XP/2000, UML, UNIX, MS-Project,JAVA, SharePoint, MS-Office Suite, Informatica, IBM, MS Visio, WinRunner, Test Director.
Confidential, Providence, RI
Business Analyst
Responsibilities:
- Analyzed business process, quality assurance testing, and customer data
- Evaluated quarterly and annual income of the bank and suggested processes changes and new investment schemes
- Estimated, planned, and executed system design matching with requirements
- Monitored and stored business specifications and functional data
- Collected business data and translated them to the development team
- Supported stakeholders by implementing their requests into the system
