Sr. Business Systems/data Analyst Resume
Lewisville, TX
SUMMARY
- 10 years of diverse experience as Business/Systems Analyst with the ability to work independently and manage business expectations with a delivery focused approach to work; ability to build and experience interfacing with Stakeholders, Independent & Cross-Functional Teams, and Senior Management (PMO) with excellent communication and interpersonal skills in Mortgage, Retail and Hospitality domain.
- Expert in Requirement Management- Gathering, Analyzing, Specifying, Documenting, Validating, Tracking requirements, Requirement traceability matrices (RTM) following Agile (SCRUM), RUP and Waterfall methodologies. Highly skilled in every phase of the SDLC with 4 full lifecycle projects.
- Highly efficient in communicating the business directives, goals and needs to the technical team and serving as clients interface managing user expectations and client satisfaction with creative thinking, problem solving and strong analytical skills.
- Experience in designing and delivering large projects and leading small project teams with superior time management and effective execution of the Project and Project Portfolio Management (PPM) to prioritize IT projects based on the cost, benefits and effective use of resources.
- Superior documentation and presentation skills. Thorough knowledge of Software Development Processes, UML, System Design Specifications and System Requirements, Change Requests, Change Controls, Structured and Object Oriented Analysis and Design (OOAD), GAP and Risk analysis.
- Comprehensive knowledge of all Microsoft Office and Microsoft Project Management (MPP).
- Developed and Maintained project plan including Task Scheduling, Resource Allocation and Milestone Analysis.
ERP Package: SAP ECC (MM), Minfosystems
Operating Systems: Microsoft Windows 98/NT/2000/2003/XP/2007/Vista/2010
Microsoft Office Suite: MS Visio, Microsoft Office- Project, Excel, Outlook, Powerpoint, Word, SharePoint, MS Visual Studio.
Data Bases: MS Access, Oracle, MS SQL
Testing/Other Tools: HP Quality Center, JIRA, Rally Dev
Processes/Technologies: Rational Unified Process, Waterfall, Agile
PROFESSIONAL EXPERIENCEClient: Confidential, Lewisville, TX
Designation: Sr. Business Systems/Data Analyst
Key responsibilities involved:
- Extensive analysis and research on CCAR and OCC reporting requirements, data marts, staging tables, transformation rules, the views, stored procedures and database schemas.
- Performed data profiling in the source systems that are required for CCAR and OCC reports.
- Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
- Responsible to define the scope of every sprint (Sprint backlog) every month based on the business priority of the reporting and dependent fields.
- Involved in defining the source to target data mappings, business rules, impacted reporting & staging fields and data transformation definitions.
- Assist data stewards to define the key identifiers for each mapping/interface and to evaluate impact on current implementation, redesign of all ETL logic.
- Responsible for defining/creating the functional requirement documents for each source to target interface.
- Created CCAR and OCC mapping specification document based on the requirements from Black Nights and FRB. Review the FSD and mapping specification with Build, QA and Risk teams.
- Documented data quality and traceability documents for each source interface
- Used data analysis techniques to validate business rules and identify low quality missing data in the existing databases.
- Created and updated the existing mapping document for both the reports.
- Analysis of defect backlog in the HP ALM.
- Run frequencies on over 400 reporting fields with the use of multiple SQL runs, complex Excel rules and the visual basic scrip to validate the impacts, increments, decrements and improvements in the data quality by considering 5% threshold.
- Worked with QA and RISK teams to complete the validation/testing of fields deployed every month.
Environments: SQL, TOAD for Oracle, Data mapping, ETL, Compare IT, HP ALM, MS Office, SharePoint, MS Visio, MS Excel, Oracle, Agile (SCRUM), Snagit.
Client: Confidential, San Antonio, TX
Designation: Sr. Business Systems Analyst/ PM
- Converting the JCL jobs to the JCL templates
- Converting the REXX programs into Crystal reports or .net local jobs based on the output produced.
- Converting NOMAD programs into Crystal reports
- Re design the file transfer with the help of Managed File Transfer (MFT) tool, etc
Key responsibilities involved:
- Performed initial assessment (IA) on the baseline inventory/repository of mainframe application. Rationalize the inventory to finalize the Master Inventory to be migrated.
- Created Business process flows, Application workflows and Current Infrastructure diagrams to represent AS-IS system. Worked with the architect and tech lead to create future state infrastructure required and drew the TO-BE system/process flows.
- Lead the JAD sessions in Vendor selection process. Reviewed the submitted appraisals with the team.
- Completed Proof of Concept to test new SW, BHCS (BARR Systems Host communication Suite).
- Identified the suitable methodology for the project (Combination of Agile and Waterfall)
- Defined and documented the scope for 4 different releases based on the business value/priority.
- Participated in the planning sessions to provide the valuable input around the scope, releases and criticality & complexity of the requirements.
- Maintained Audit trail and approval database with the use of Lotus Notes.
- Lead requirement-gathering sessions to gather the requirements from the SMEs and the end users.
- Elicit requirements and documented those in the Business and Functional Requirement document through requirements workshops and site visits. Created functional design document.
- Translated business requirements into technical requirements. Assisted Tech Lead is creation of the Technical Design Document.
- Reviewed JCL source code and performed Process Improvement wherever necessary.
- Collaborated with .net, Crystal Reports and QA team for the clarifications/questions.
- Assisted development team in getting them the source input like Input files, output files, Copybook of the files to be loaded into the database. Assisted .net team to create DB loaders development.
- Worked with Crystal Report developers and DBAs on data mapping and data modeling.
- Constructed SQL queries to extract the data required for the Crystal Report Development.
- Assist QA, UAT and Pilot teams in end-to-end and parallel testing and to provide the test data.
- Assisted the Business Analyst in creating the User Training Manual (UTM), User Procedure Document (UPD).
- Created draft version of the Project Plan, Estimates, Resource Allocation and later assisted project manager in finalizing them. Analyzed and prioritized the applications with the use of Project and portfolio management methodology (PPM).
- Managed change control and continuous changed the process for the accuracy.
- Maintained a Project Run-Book, also known as System Delivery Specification document (SDS)
- Supported Sharepoint sire for the project. Migrated and organized the new site for the future state system.
- Performed the analysis on Mainframe End of Life (EOL) Connect Direct, VPS and CA7 listing and identified the SSG ownership.
Environments: Mainframe, UML, Lotus notes, MS Office, SharePoint, .Net, MS Visio, JCL, REXX, NOMAD, DAVAST, Business Object Crystal Reports, Autosys, CA7, MS Excel, SQL, HTML.
Client: Confidential, Irving, TX
Key responsibilities involved:
- Extensive study and research on the Uniface based Ordering and Product assortment module.
- Analyzed the requirement backlog of Ordering enhancement and Performed Requirements Analysis, conducted JAD sessions for communicating with the all Project directors and stakeholders.
- Prepared and mapped AS IS and TO BE workflow scenarios.
- Decomposed the business requirements to create Basic Design document (BD).
- Developed Screen Notes document for all screens under enhancement, included Screen mock-ups, data source, sort order and workflow etc. Created HTML forms.
- Lead the team of 3 systems analysts team and mentored team members.
- Proactively communicated and collaborated with both the internal and external customers to analyze, document and review the Business Requirements, Functional Specifications, Business rules and detailed design of the software system.
- Translated business requirements into technical requirements. Mapped business and technical processes by utilizing industry recommended practices for the requirement management systems.
- Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts around Ordering system.
- Created Use-Cases to demonstrate software architecture and system component interaction.
- Kept an open eye for the process improvement opportunities to make the system efficient.
- Created system design document by understanding the source code, forms & triggers used in Uniface.
- Conducted extensive Market Research, Data Analysis, and project Feasibility studies.
- Worked closely with QA, UAT teams and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
- Designed and implemented basic SQL queries for QA testing and report/data validation.
Environments: Uniface, HTML Forms, MS Office, SharePoint, Waterfall, SQL, HTML, .Net, MS Visio, HP Quality Center, POS, Middleware- 7-Transfer, MS Excel.
Client: Confidential, Lewisville, TX
Designation: Sr. Business System Analyst
Key responsibilities involved:
- Gained thorough understanding of mortgage service & default process including but not limited to pre-foreclosure, Foreclosure, short sale, did the luin foreclosure, Auctions, Loan modifications, REO.
- Lead requirement-gathering sessions. Worked on creating a Product Backlog in JIRA. Worked with Product Owner to prioritize the Product Backlog.
- Divided Epics into the User Stories and documented Acceptance Criteria.
- Worked with the SCRUM development team, Product Owner and SCRUM Master in Backlog Refinement meeting to refine and understand the User Stories to find the Estimate.
- Participated in SPRINT Planning meeting to commit to the SPRINT backlog.
- Active participation in Daily Standup meeting to share the status with the team through Burndown chart and Storyboards.
- Lead the SPRINT Review meeting to demonstrate the product to the stakeholders and gain their feedback to find out the options for the process improvement.
- Facilitated SPRINT Retrospective meeting to find out what went wrong and how it can be corrected for the future iterations.
- Created impact matrix to check the impacts on the other applications linked like LPS for Invoice management) billing processes) of the completed valuation products.
- Studied and modified legacy system’s process flows; data modeling to effectively enhance the system.
- Analyzed the backlog- historical defects, production support issues and missed requirements.
- Assisted the Project manager to prioritize the projects with the use of methodologies such as Project portfolio Management (PPM), Forecast-statistics and data management (FSDM).
- Handled Production support requests and Work requests through work request management tool.
- Efficiently worked with ETL team to understand the current database architecture and mapping and to create a data/ETL mapping specification document.
- Identified problematic areas and conducted research to determine the best course of action.
- Constructed and executed SQL queries to obtain requested reports manually.
- Created Data mapping document while working on Automated Collateral Risk Profiler (ACRP) project where an involvement of two different IT vendors in creating Quality control rules engine on Broker’s Price Opinion (BPOs) - Generally Accepted Rules Engine (GAAR).
- Designed data flow processes and created transforming conditions based of the business requirements. Assisted the data architecture and developers in creating a technical design document.
- Worked with QAs to derive QA plans and reports. Worked as an IST tester for production support issues and actively participated in User Acceptance Testing (UAT) due to scarcity of resources.
- Responsible for approving the test cases without any delay so that testing starts on time. Defect Tracking and Bug Reporting was performed using JIRA.
- Effectively review of the code throughout the build phase. Pair programming in SPRINT execution.
- Created Enterprise Change control (ECM) request approved for every SPRINT.
- Worked as a SME for end users to conduct UAT and Prepared UAT signoff documents, user manuals, User Procedure Document (UPD), training plans and participated in demonstration with the help of offshore team.
- Worked with PMO to report the overall status of all three Swimlanes.
Environments: UML, MS Office, Excel, SharePoint, Agile (SCRUM), Waterfall, .Net, Adobe Acrobat. MS Visio, XML, SQL, Jira, Use cases, HTML, User stories, E-Commerce,
Client: Confidential - Indianapolis, IN
Designation: Technical Business Analyst
Environment: UML, Gap Analysis, MS Office, Adobe, Rally Dev, SharePoint, RUP, SQL, Informatica.
Client: Confidential, Pittsburgh, PA
Designation: Business Systems Analyst
Job Profile –
The project involved in migration of existing legacy mortgage systems to a new enhanced Loan Origination System (LOS) and enhancing the reporting system both on the front and back end. The system automates the entire lending process from origination through funding. It automates complex, inefficient and labor-intensive aspects of lending; including automated underwriting.
Environment - Windows, Oracle, Microsoft Office suite, Microsoft Visio, Adobe, MS Visual Studio, SCRUM (Agile), UML, HTML, .net, SQL, Jira
Client: Confidential, Bloomington, IL
Designation: Business Analyst
Job Profile –
The project was to automate the Auto Insurance termination process to incorporate the rules engine as every state has different rules and regulations. Project aims at expediting the system, reduces manual work of underwriters, reduces report generation, and finally aims at fastening the process by making it friendlier to the customers.
Environment: UML, Gap Analysis, Adobe, MS Office, JAVA, XML, Sharepoint
Client: Confidential, Lewisville, TX
Designation: Business Analyst
Job Profile –
Major enhancement to the online loan pre-approval application (E-commerce) called Housing Mortgage Application to allow clients to apply for the housing mortgage online.
Environment: JAVA, Rational Rose, Rational Requisite pro, Windows, Adobe Acrobat Writer, HTML, SQL server, MS office suite, UML, E-Commerce.