SUMMARY

• Over 6+ years of experience as a Business and Technical Analyst in deployment of Web - based and Client-Server applications, with extensive experience in business process design, streamlining and gathering requirements in fields as diverse as IT, Banking, Business, Mortgage and Healthcare.
• Extensive Experience in documenting Business Process Modeling (BPM), Business Requirements (BRD), System Requirement Specifications (SRS) and Functional Requirement Specifications (FRS).
• Worked with all facets of the software development life cycle including design, analysis, and development and testing of web-based and n-tier client/server applications.
• Worked extensively on Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use case modeling (UML) and MS Office (Word, Excel, Access, Visio) developing dashboard applications.
• Experience in conducting Impact Analysis, SWOT analysis, Risk Analysis, modeling Business Process, and preparing Training manuals and Knowledge Transfer manuals.
• Expertise in Creating Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity diagrams, Sequence diagrams, data flow, Context diagrams and Component diagrams.
• Strong experience in conducting User Acceptance Testing (UAT), Integration Testing, and documentation of test cases.
• Experienced in conducting JAD sessions with superior organization and presentation skills.
• Expertise in Project Planning, Project Management, Scrum, Waterfall and Agile Methodologies, Cognos BusinessIntelligence systems.
• Expertise and knowledge of financial reporting and analysis using MS Word, Visio, Excel, (Macros, VBA) PowerPoint, Road Map, SAP BusinessObjects and Knowledge
• Experienced in conducting Requirement Analyses, Root Cause, Test Plan, Test Case generation, Requirements Traceability and Gap Analysis.
• Expertise in Extract, Transform and Load concepts.
• Knowledge of Six Sigma methodologies.
• Knowledge of (PMBOK) Project Management Body of Knowledge.
• Hands on Experience working on Bug tracking systems like JIRA and Confluence.
• Extensive experience in SDLC process development, Project Life Cycle, complex data analytics, implementation and high level involvement in global strategic businessdevelopment strategies.
• Excellent Communication skills, Team Participation skills, Leadership qualities, Analytical skills & Problem Solving skills.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Business Systems Analyst

Responsibilities:

• Performed analysis and assessment of business needs and cross system impacts and developed procedures for Mortgage servicing processes.
• Identified process improvements that will increase the efficiency and effectiveness of the mortgage line of business and executed tasks for selected improvements.
• Facilitated and participated in the meeting sessions with the business users and stakeholders to define the project scope and boundaries using the RequisitePro.
• Updated the loan originator system process to establish a tiered and committee based manual approval process and to extend the manual loan approval process by adding controls to final evaluations. This loan originator system helped in faster and accurate processing, better and quick communication with the borrowers and helped the internal users achieve higher efficiency.
• Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
• Performed database testing using SQLqueries to validatedata.
• Documented loan disclosure procedures in accordance with regulatory and procedural requirements.
• Assessed deficiencies in current process and implement corrective actions. Reviewed and assessed compliance and quality outcomes identified in the different stages of processing and develop action plans to correct deficiencies.

Environment: Windows, MS Visio, SQL, Oracle, SQL server, Linux, Apache, Tableau, RequisitePro, MS-project and MS Office Suite, Encompass, LSAMS.

Confidential, Houston, TX

Business Systems Analyst, AVP

Responsibilities:

• Managed three agile scrum teams (each team having 4- 7 members), one support teams (with 4 members) between three different locations i.e. US, UK and India.
• Enhanced web portal for the existing functionality of Client Profitability module & cleaning its critical data for accurate and flexible profitability analysis.
• Responsible for building a qlikview tool application that helps the business to have quick access to real time data along with trend and history. This reporting tool with highly interactive user interface serves sales managers to view large volumes of data, slice and dice the information to perform administrative tasks.
• Worked with business managers, cross applications partners, and application owners to create business and functional requirements for global features.
• Performed end-to-end analysis of multiple investment Bank systems applications including requirements gathering, prioritization, and estimating, planning and writing functional /technical specifications.
• Worked with GTI developing an inbuilt solution for business users to make outbound calls and blast voicemails using CISCO and turrent phones and CISCO keypad. Facilitated client interviews and workshops to gather, understand and set client’s project goals. This inbuilt solution helped the firm saving lot of money that was spent on third party vendor product
• Work includes analysis/documentation of systems, acting as a liaison between technology team and end users. Manage the expectations and deliverables along with progress updates and identifying risks and challenges on day -to -day basis.
• Provided BOXI reports to the clients by performing XML Schema validation.
• Worked with Investment Bank technical analyst/developers to ensure clear understanding of technical documentation and functional specifications.
• Worked with databases like SQL writing SQL statements.
• Ensured that technical system changes meet the same analysis, documentation, and testing materials.
• Documented use cases, identified gaps, and participated in solution design for these features. Track their progress through the JIRA bug tracking systems.
• Documented and supported a number of internal Confluence sites for enterprise initiatives.
• Creates internal and external partner documentation, including user guides/ manuals and developer documentation, diagrams and process related assets on confluence pages.
• In corporate SharePointweb parts, discussion boards, project task lists, and calendars into team site(s)
• Create & facilitate SharePoint(Change Request) workflow & approval documents; monitor evaluation progression and notify evaluators of submission timelines.
• Developed SharePointRecords Center/Document management site.
• Create workflow and system diagrams to better document platform processes and current state.
• Ensure that technical system changes meet the same analysis, documentation, and testing standards.
• Worked extensively on Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards.
• Gathered sales information, such as sales name, sales id, product details and worked on ETL process to store it into the data warehouse
• PerformedBusinessProcess Mapping and performed AS IS and TO BE analysis
• Reported tracked defects with reference to severity and types using TFS and JIRA.
• Prepared the High level and ETL Technical specifications for ETL jobs.
• Developed, schedule ETL jobs and maintained production jobs about (Daily/Monthly/Yearly) scheduled jobs.
• Provided daily customer support in order to ensure customer satisfaction. Develop and maintain good relationships with lines of business.

Environment: Windows, Linux, Unix, Apache, MS Visio, UML, SQL, PL/SQL, Oracle, JIRA, Confluence, SQL server, MS-project and MS Office Suite

Confidential, Atlanta, GA

Business Data Analyst

Responsibilities:

• Worked extensively with the stakeholders and with different levels of management to identify requirements, business events and to develop wishlist, product backlog and sprint backlog.
• Led Web-site Re-engineering project for MortgageOriginations to ensure better quantity and quality of leads
• Review customer loansto accurately determine transaction recoverability according to state and federal guidelinesas applicable to default cure events such as foreclosure, short sale, loan modification, deed inlieu, or a charge off.
• Reviewing mortgage loans utilizing the appropriate businessrules to determine the most desirable outcome to assist the clientwith preventing harm to the borrower.
• Escalating loans for client clarification based on my interpretation of the transaction hierarchy review documents to analyze borrower funding in escrow and suspense, borrower recoverable transactions, non-recoverable transactions, third party recoverable transactions and validating offsetting transactions to ensure a complete and accurate mortgage loan review.
• Ensure timely claim filings on HUD and Investor claims. Manage the aging of their portfolios (of claims to be filed and claims already filed) to determine claim status and initiate QC procedures when claim filings are completed.
• Document and maintain all systems necessary for proper claim handling and follow-up.
• Manage all traffic of the claims inbox on a daily basis. Ensure all communications are handled effectively and timely.
• Research issues and obtain proper supporting documentation from multiple data sources (i.e., systems and media) in a timely manner as needed to complete the claim filing processes.
• Validate all funds received and HUD and/or Investor remittances are attained for proper hand-off to the Loss Analysis and Liquidity Management groups.

Environment: MS SharePoint, Visio, UML, SQL, MS Project, MS Office, ClearCase, RequisitePro.

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Developed business process models in Agile methodology to document existing and future business processes and worked along with Business owners to understand end-to-end processes and mapping the requirement to the specifications. Participated in System design phase, worked with the usability team and generated the Detailed Design Document.
• Worked with business owners and SME’s to define and document technical and business rule specifications for data under review maintained under Enterprise Content Management System. Used SQL queries to extract data to create charts and reports for analysis. Merged data from SQL Server and Excel to create the Monthly Reports for each business unit.
• Understanding FAM Care Reports & PET Care Plant Model Design
• Documented requirements for the application and identified interfaces required for the system.
• Performed GAP analysis of existing system and evaluated benefits of new system.
• Used MS Visio for flow-charting, process model and architectural design of the application. Used MS Project for status reporting and project planning.
• Interacted with the QA developers on resolving the reported bugs.
• Conducted Walkthroughs and User Acceptance Tests (UAT) and worked closely with the UAT personnel to both ensure that their needs are met.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures and updated the requirement documentation. Conducted Regression testing and logged the defects. Worked on Post Release Revision documentation.
• Utilized macros in Excel to pull data from our defect/change management tool Remedy P/CM to generate daily reports. Performed Technical Analyst duties including executing and validating data corrections using SQL Server stored procedures and ad-hoc reports.

Environment: UML, PDF, R programming, RUP, MS Excel, MS Power Point, MS Visio, Rational Requisite Pro, MS Office, RequisitePro.

Confidential

Business Analyst Advisor

Responsibilities:

• Responsible for the development of the Network Plant Assignment Management System for Confidential Telecommunications (Australia).
• Developed business process models to design and in corporate a better user interface for the business clients.
• Created and modified bilingual IVR applications using VXML elements such as sub-dialogs, to achieve multi-document application
• Designed and documented complex business and technical requirements to build a custom application that will manage and track toll free and DNISnumbers for the Marketing Departments.
• Navigate through call tree services, and understand routing of all DNISgroups as they pertain to specific 800#’s.
• Managed and led IVR application development effort. Developed and deployed a full featured complex IVR speech/DTMF enabled self-service application.
• Responsible for single-handedly upgrading the Global database and developing the Functional requirement documents.
• Implemented SQL scripts using CVS tool to perform data Inserts, updates, and deletes in Oracle database.
• Worked on SQL database to fix the Production aborts, Monitored the Batch Job Failures and fixed them regularly
• Developed team resources, project plans, and implemented strategy by following in-depth product launch phase.
• Proposed a solution to automate the extraction of data which is need by the clients to meet their challenges.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Analyzed, designed, and coded several online subsystems for the telecommunication systems.
• Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Setup JAD sessions for each application and helping the individual BAs to plan for the JAD sessions by mentoring and guiding them.
• Extensively used calculations, variables and sorted inputs, drill down, slice and dice, alerts for creating business object reports.
• Used Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: MS SharePoint, Visio, UML, SQL, MS Project, MS Office, COTS software, ClearCase, RequisitePro.

Confidential

Business Analyst/ Transaction Risk Management

Responsibilities:

• Responsible for gathering requirements, analysis, bug reports, documentation, and quality assurance.
• Identified fraudulent transactions and cancel them from further processing.
• Generated in depth Root cause analysis reports in relation to critical issue.
• Collected and documented the business processes and business rules.
• Provided key inputs while working with the users in defining project and system requirements.
• Facilitated and managed meeting sessions with committee of SME's from various business areas including Business Rules, Advertisements data.
• Followed the UML based methods using Rational Rose/MS Visio to create Use Cases, Activity Diagrams and Sequence Diagrams.
• Assured that all Artifacts are in compliance with corporate RUP Methodology and guidelines.
• Conducted formal interviews and JAD sessions with business users of all levels including the executive team & Project Directors.
• Participated in creating a UAT test plan, and test cases for all the seven reports for release. Reviewed & performed manual testing.
• During UAT, performed frequent meetings with the business users as well as the developers to ensure the understanding at all the levels.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Mentored new teams with enhancements, rules and policies pertaining to software tools.

Environment: MS SharePoint, Visio, UML, SQL, MS Project, MS Office.