SUMMARY

• Around 9 years of IT and management experience in Software Development Life Cycle (SDLC) and Project life cycle working as a Business Analyst, Business System Analyst in manufacturing, finance, HR, Payroll, accounting, e - commerce and Supply chain sectors.
• Extensive exposure to Rational Unified Process (RUP), Agile, and Waterfall Methodology.
• Self-starter and able to work interactively and independently with stakeholders. Expertise in managing multiple projects and teams with an excellent track record.
• Facilitate face to face interview, teleconference and web-conference meetings to gather business and functional requirements
• Extensive experience in Gathering and Analyzing Requirements, Modeling Business Process Flows, writing high level documents, Business Requirements Document (BRD), Use case Specifications, Functional/Systems, Design/Systems Requirements Specification (SRS), Transactional Data Dictionary, Business Continuity Plan (BCP), Workflows and using UML, RUP, Agile and Six Sigma methodology
• Facilitate/ participate in JAD sessions for detail requirement analysis and provide solution
• Strong experience in creation of BRD's, FRD's, RTM's and translation/ simplify requirements to assist development and testing teams.
• Proficient in developing process workflows, activity, use cases, sequence diagrams in MS VISIO
• Experience with SQL queries to perform data analysis, data mapping and data validation of the transformed data output
• Experience with Retrofit/ Data Conversions and Root Cause Analysis
• Experience in BI Reporting, structure and mapping
• Prepared and contributed in test scenarios and test cases for testing the functional and non-functional aspects.
• Defects analysis to determine business and technical impact and providing input on the priority of fixing the defects.
• Conduct walkthrough of deliverables with Business to obtain signoff/ approval
• Develop Project plan, Level of effort, Change Request and assist multiple Project Managers throughout delivery execution on multiple releases at a time
• Good experience in Production Support, Identifying root causes, Trouble shooting.
• Performed in depth analysis.
• Advanced proficiency in Microsoft, particularly Word, Excel, Power Point and MS Project
• Prepare executive dashboards and presentations discuss at Executive Steering Committee Meetings.
• Experience in Optimal Trace, Caliber RM, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, JIRA and Application Lifecycle Management (ALM)
• Hands-on experienced in Project Plan, Project Milestone, Issue and risk assessment, value/benefit realization and project management documents

PROFESSIONAL EXPERIENCE

Confidential - Manchester, NH

Sr. Business Analyst/BSA

Responsibilities:

• Helped define Scope and ROM of the project and prepared/documented the request for information and request for proposal.
• Worked with the Business Users to define business requirements and analyzed the possible technical solutions.
• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the analysis of the workflow model.
• Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, Databases, Users, Profiles and Roles.
• Conducted Workflow, Process Diagram and Gap Analysis to derive requirements for existing systems enhancements.
• Perform in-depth analysis of Microsoft Dynamics CRM user issues to determine causes and solutions
• Responsibilities include analyzing the business requirements, performing gap analysis, understanding and documenting the data flows.
• Created and updated documentation, including Infolease monitoring, server decommissioning, Data Center security matrix resolution procedure, various data center inventory spreadsheets, and update to the Aperture User Guide for all Data Owners.
• Develop standards and processes to support and facilitate integration projects and initiatives.
• Managed CRM operations, including consulting, user setups, training, and technical functions.
• Enhanced the high-touch client experience by implementing and improving CRM functions and features
• Validating the load process of ETL to make sure the target tables are populated according the data mapping
• Provided that satisfies the transformation rules.
• Extensively used ETL Tool Informatics to load data from Flat Files, Oracle, SQL Server, Teradata etc.
• Proven understanding of various SDLC Methodologies including Waterfall, Iterative, Parallel, Agile and RUP.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Responsible for assessing requirements and designing and developing the data Integration/ETL strategy, Implementation plan, Solutions, and Delivery.
• Creation of Business Requirement Document (BRD) and Functional Requirement Specification (FRS) for InfoLease custom programming.
• Understand CRM technologies to direct the design, development and testing of a successful implementation.
• Assisted the PM in developing Use Cases and Project Plans, and also managed changes to the scope of the project.
• Reviewed requirements and understood technical recommendations and constraints, and developed comprehensive and accurate Functional Specifications, Data Mapping and Process Flows.
• Requirement Analysis and Designing the integration Solutions.
• Developed business process models in RUP to document existing and future business processes.
• Designed and developed project document templates based on SDLC Methodology.
• Identified internal and external system requirements, design and configuration set-up. Created User Documentation and conducted training classes.
• Successfully delivered business information solutions for data transfer from multiple data sources and formats to target Teradata and Oracle databases.
• Preparation of test plans, requirement analysis, writing test and executing test cases, analyzing and logging defects.
• Responsible for the loan origination process and the coordination of closing activities for a full service, national mortgage lender offering refinancing, FHA and VA loans.
• Participated in daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Participated in data modeling exercises to determine the data-warehouse, data mart and OLAP cube designs.
• Developed Business Requirement Specification documents as well as High-Level Project Plan.
• Created Class Diagrams and ER Diagrams. Used SQL queries to filter data within the db2 database.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Assumed ownership of Use Case Diagrams, Use Case Narratives and other various artifacts.
• Relieved pressure off the PM by maintaining artifacts and portions of the project binder.
• Documented and delivered Functional Specification Document to the project team.
• Assisted Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Responsible for Mortgage lending, Finance lending management, Strategic planning, Understanding of Finance lending., Long-term strategic planning
• Designed and implemented data warehouse by creating databases, tables, and views. Setup User accounts, roles, security and Viewpoint alerts in a Teradata 14 environment.
• Excellent knowledge on overall Testing concepts (Requirement Analysis, Estimation, Test Case Design, Test Case Execution, Defect Management)
• Responsible as a power and casual data steward for personalization, data mapping and reporting operations.
• Submits mortgage loan application file for underwriting approval.
• Assisted PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly, and conducted project related presentations.
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensured that appropriate documentation was in place.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Tracked change requests and monitored workload and schedule.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Conducted User Acceptance Testing (UAT).

Environment: Rational Requisite Pro, Rational Rose, SQL, MS Office Suite, MS Visio, EDI, Agile, Business Objects, UML, RUP, MySQL.

Confidential - Windsor, CT

Business System Analyst

Responsibilities:

• Responsible for identifying and documenting requirements via multiple JAD discussions with SME's from Customer service, vendor relations, billing, finance and accounting
• Act as a liaison between business and technical teams
• Provide walkthrough of the Business requirement document (BRD) to architects, dev and QA teams using Joint application design (JAD) sessions.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Review progress and evaluate results for accuracy and efficiency during system integration testing (SIT)
• Write SQL queries to perform data analysis and prepare data mapping documents explain the transformation rules from source to target tables.
• Lead team in designing, developing and implementing ETL process using SQL, Informatics and Teradata for sourcing data from multiple sources applying transformations per business rules.
• Incorporated agile methodology to create Business Requirement Document specifications utilizing MS Visio and MS Word.
• Business Analyst to define project requirements working with various business stakeholders; propose viable design solutions to business stakeholders.
• Monitored loan covenants monthly, quarterly and yearly. Also, prepared Loan Covenant Report.
• Responsible for leading efforts to review the Requirements Traceability Matrix, Test Case documentation with the onside and offshore teams.
• Requirement gathering, data analysis, data mapping, documenting SDLC and interacting among business and technical team.
• Created test plan, test cases and test scripts . Managed testing cycles, tested developed features, managed defects and reporting; hosted daily standup calls
• Created test plans, test cases and scripts for the consolidated applications in development, testing and production environment. Performed unit testing, functional testing, user interface testing and negative testing.
• Demonstrated use of Use Cases, UML, Context diagrams, Swim Lane diagrams, Data Flow diagrams etc.
• Work with Business to complete User acceptance testing (UAT)
• Work with PMO and release team for production deployment.
• Developed and managed Allowance for Lease and Loan Losses (ALLL).
• Manage change control process to make sure changes are captured properly, impact analysis, coordinate with all the teams for change implementation and perform data validation
• Developed user manuals and training guides for the Supplier Portal
• Experienced in using HP's Application Lifecycle Management (ALM) software for defect tracking and triages
• As part of the systems design worked on developing mockup screens and created interactive versions of the mockup screens using Axure for demonstration purpose.
• Coordinate with the team members to make sure there is no block in the progress of the project

Confidential - Fort Worth, TX

Business System Analyst

Responsibilities:

• Develop business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyze client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client's needs are met.
• Communicate client's business requirements by constructing easy-to-understand data and process models.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Engage client to gather software requirements/business rules, and ensure alignment with development teams
• Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Evaluate risks related to requirements implementation, testing processes, project communications, and training saving the company on average $5,000+.
• Identify and reconcile errors in client data to ensure accurate business requirements.
• Draft and maintain business requirements and align them with functional and technical requirements.
• Facilitate monthly meetings with clients to document requirements and explore potential solutions.

Environment: UML, Windows, SQL, MS Project, MS Word, MS Excel, VB.Net, MS Visio, REST, Smartsheet.

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Several years credit, investment operations and management experience.
• Support in developing financial models.
• Use of exceptional analytical skills and experience to help clients mitigate risk .
• Served as a Consultant on Corporate and Public finance projects .
• Several years of banking, finance and client engagement experience.
• Certified in Wealth Management & Investment Banking domain, designed and developed robust technical & business solutions for the client's mobile banking application.
• Spearheaded the automation of application in both iOS as well as Android platforms.
• Devised an automated archival solution for offloading terabytes of customer data into Hadoop using Sqoop and Oozie frameworks so as to reduce the load and improve the performance of RDBMS systems.
• Formulated a structured data analysis platform on top of the archived data using Impala and Hive as the query engine by aggregating and segregating customer datasets, thereby providing a mechanism for large scale data processing and interactive querying.
• Designed and developed a highly scalable, distributed search platform for structured and unstructured data in Hadoop using Apache.

Environment: MS Visio, Project Professional, JIRA, HP Quality Center, CompliSource, Agile,Salesforce and WMS help desk, Microsoft Office, SharePoint.