PROFESSIONAL SUMMARY:

• Business Analyst with more than 7 years of experience in Software Development, Application Development, Product development, Mortgage, Banking, Financial Services domains with extensive exposure to gathering & analyzing user requirements, business modeling, process simulation and data analysis.
• Effective Project management skills and effectively acted as Project Manager on various occasions to maintain Scope, resource scheduling, status reports update and project plan updates.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile with JIRA.
• Knowledge in Business Intelligence tools like Business Objects, Cognos, Tableu, Spotfire and OBIEE
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Expertise in creating Project Vision Document, Requirement Management Plan, User Stories, Use Cases, Business Requirement documents (BRD), Requirement Traceability Matrix (RTM), Functional Specification Document (FSD), System Requirement document (SRD )and Test cases.
• Hands on experience in working with UML documentations like class diagrams, use cases, sequence diagrams and ERDs.
• Ability to collaborate with peers in both business and technical areas, to deliver optimal business process solutions, in line with corporate priorities and uncompromised quality.
• Managed requirements for web based solutions, reporting & business process management.
• Experience conducting GAP Analysis, SWOT Analysis, and ROI analysis.
• Good understanding of Real time analytics and SQL Server Architecture in terms of ETL and query processing, structure and performance and table partitions.
• Expert in Data Integrity, Performance Tuning, Repairing dead locks, Query Optimization and Validation issues.
• Strong in ETL, Teradata, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Expert in usage of queries/reporting tools to support, analyze large volumes of information within the Data Warehouse.
• Proficient in conducting Meetings, Interviews, Joint Application Development (JAD) sessions and Requirement review sessions with various Stake holders and flexible in coordination across various groups and vendor partners
• Extensively interacted with the QA Team to help them execute various Test plans (GUI, Functionality test, system test, integration test, defining Test Cases, POC,) and facilitated UATs.
• Participated in design walk - through with SMEs to baseline the business architecture and expertise in using both Service Oriented Architecture (SOA) and Product oriented Architecture(POA) in phases of system development and integration
• Experience in Manual, automation, Functional (System & System Integrated Testing) and Regression Testing.
• Experience of creating Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Experienced in working with Cross Functional Teams and interacting with all levels of management for requirements, resources and project status and delivering custom applications in phases
• Highly adaptable to new softwares, schedules, roles and responsibilities and outperform in spite of the changing scenarios and Strong communication skills both verbal and written including strong presentation skills.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS:

Databases: SQL Server 2012, MS Access, IBM DB2, Oracle 9i

Visualization Tools: Tableau, Qlikview

Business Intelligence Tools: SAS Enterprise Miner, XL Miner, Cognos, SAP Business Objects

Methodologies: Agile, Waterfall, RUP, RAD

Software Applications: MS Visio, Toad for Oracle

BI Tools: ETL, Informatica, SSIS, SSRS

Modeling Tools: MS Visio, iGrafx, Rational Rose

Requirement Management: RTC, DOORS, VersionOne

Process: Use Case Diagrams, Activity Diagrams, State Diagrams, Sequence Diagrams

Testing Tools: HP Mercury Quality Center, QTP

Others: MS Project, MS Office, Teradata, DB2, STAR Team, IBM, Clear Case

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Business/Data Analyst

Responsibilities:

• Work with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow.
• Work closely with the Teams (Business and Technology) to ensure they have captured all the requirements correctly and documenting BRD, FSD and SRD etc.
• Responsible for Project Start off/Kick off meeting, JAD sessions, Scrum calls and daily sprints etc.
• Work closely with various financial and mortgage business teams in gathering the business requirements.
• Work with the Project Management in the creation of project estimates.
• Analysis of the data identifying source of data and data mappings of HCFG Teradata DWH.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Assigned tasks among development team monitored and tracked progress of project following Agile methodology.
• Overlook the creation of Traceability Matrix that shows the complete flow from the Business Requirement to System Requirements and ultimately mapped to Test Cases.
• Managing the data within finance to ensure adherence to consistent definitions, business naming standards, development of standard calculations, security requirements perCCARrequirements.
• Leading the Data Lineage project from source systems to theCCARReporting tool using Teradata Metadata Manager.
• Utilized Teradata toolset (Teradata Data Miner and Teradata Data Quality) to analyze legacy data for data profiling.
• Developed complex SQL for COGNOS BI reports to extract data from the Backend and also for Validation of data.
• Interact with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system.
• Documentdata quality and traceabilitydocuments for each source interface
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information.
• Developed business process models in Agile to document existing and future business processes.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Reading Teradata maps and preparing Standard Operating Procedure’s (SOP’s) for the end users.
• Involved in the development (create, load and test) of custom tables for COGNOS reports.
• Support development teams creating applications against supported databases.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for defect and change management Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Provide 24 x 7 problem management support to the onsite and off-shore development teams.

Environment: SQL, COBOL, Teradata, MS Excel, MS Access, Agile, Cognos, Oracle 10g, Rational Rose.

Confidential, Providence, RI

Sr. Business Analyst

Responsibilities:

• Prepared and review complex financial analyses including transaction impact analysis.
• Build detailed financial models to evaluate performance under various operating scenarios and to analyze the impacts of different capital structures, portfolio rebalance and analysis, compliance and credit research.
• Acted as a liaison between investment bank brokers, wealth management team, industry experts, system users, client managers and software development team to gather requirements and document work flow and result of business analysis in to Business Requirement Document (BRD) that meets audit and SDLC standards.
• Constantly Partnered with project leads to ensure the team is providing solutions that meet established standards, procedures & practices, address issues, risk and mitigation plans. And analyze candidate credentials using HRIS to help recruiting best employees.
• Assisted Project manager in maintaining and monitoring the progress and status of the project, providing high level estimate of efforts for analysis, implementation and support, estimating delivery schedule and resource allocation.
• Analyzing and developing reporting streams using rules and methodologies for BaselIII Standardized and Advanced Approaches and CCAR(Comprehensive Capital).
• Successfully managed credit risk reporting projects, migration projects andCCARstress testing projects; the migration projects has saved the business billions of dollars on RWA.
• Responsible for converting BSA/AML regulations into functional documents and including forms and reports onto internal committee boards.
• Participated in annual Comprehensive Capital Analysis and Review (CCAR) stress testing effort.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve any issues, come to an agreement and achieve goals. Also conducted Status report meeting for Waterfall model.
• Performed feasibility and risk analysis to identify the business critical areas from the user perspective based on capital market risk in various securities, derivatives and OFAC regulations that enable investors to analyze and rebalance portfolio.
• Measured project performance on time and budget as per project plan.
• Expert in creating Dashboards, Scrum boards, Issue tracking on JIRA and using JIRA query language to conduct complex search queries.
• Developed Use Case diagrams for every conceivable scenario, Activity diagrams, and UML diagrams in MS Visio.
• Performed requirement walkthroughs with the development and QA teams with the aim to develop testing strategies and test plan such that test cases reflects user needs.
• Responsible to provide training to few sections of Business to successfully switch to SaaS from On-site CRM.
• Documented and track defects, as well as produced detailed report using Quality Center.
• Worked extensively with client requirements to generate customized SQL reports.
• Defined and reviewed the data warehouse requirements with the business users for getting the right data from source system to reporting purpose.
• Provided remote and onsite support to end user during and post implementation.

Environment: MS Office, MS Visio, UML, Microsoft SQL Server, JIRA, Quality Center, JAD.

Confidential, Cincinnati, OH

Sr. Business Analyst

Responsibilities:

• Worked according to the RUP software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Interacted with the sampled customers and application development and maintenance teams to know their viewpoint of what an online application has to offer and designed use cases based on it.
• Extracting the business requirements from the end users by several Requirement Gathering Sessions (RGS) keeping in mind their need for the application, and documenting it for the developers.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements and gather requirements using WebFocus and Historical Data.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Developed PL/SQL Business Functions and calling into the Cognos Tools Designed and Developed Power Prompts for Web Users For Flexible Querying.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis using Microsoft BI Stack.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse.
• Worked extensively with the ERwin Model Mart for version control and generate DDL from model.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL and customization of data mart.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Upgraded the present application by adding new functionalities and adding new reports enhancing to support Teradata.
• Responsible for managing both System and Application DBA to increase flexibility of the Stucky’s application and make sure the system and disk fragmentation is performing appropriately.
• Interacted with business owners to identify business system needs, proposed solutions for business problems and evaluated alternate methods to increase efficiency of the overall process.
• Worked as a team with other business analysts to make an object oriented model of the application and create use cases.
• Responsible for the creation and approval of the functional specification. Worked as a technical writer working on technical specifications, converting business specifications into technical specifications, quality control, information security, customer manuals and online documentation.
• Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers.
• Worked on server check, reporting and maintaining the smooth functioning of the online project. Worked on complex graphical user interface (GUI) and Web-Based user interface (WUI).
• Carried out forward and backward tracing for verification and validation purposes.
• Provided support to the QA team in User Acceptance Testing.
• Created reports for business analysis purposes using Crystal Reports and Microsoft Excel.

Environment: Rational Requisite Pro, Rational Rose, RUP, Agile, Waterfall, UML, SQL, MS Office (MS Word, MS PowerPoint, MS Excel, MS Access), MS Project, MS Visio, Erwin, Web Focus, Teradata, COGNOS, Sharepoint.

Confidential, Louisville, KY

Business Analyst

Responsibilities:

• Responsible for preparing Business Requirement Document and then translating into functional specifications. Conducted logical data analysis, data modeling and communicated data-related standards.
• Performed data profiling in the source systems that are required for Dual Medicare Medicaid Data mart.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Followed agile methodology for gathering requirements and converting those requirements into Functional specifications.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Reverse engineered all the Source Database’s using Embarcadero
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in Teradata data warehouse and Data mart design.
• Experience with various ETL, data warehousing tools and concepts and operational and transactional analysis using DB2.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding using JIRA
• Good Experience with Mainframe enterprise billing systems Involved in defining the business/transformation rules applied for Dual Medicare Medicaid data.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Confidential Enterprise data warehouse (EDW).

Environment: SQL/Server, Oracle10&11g,MS-Office,Embarcadero,Netezza,Teradata, Enterprise Architect, ER Studio, Agile, JIRA, XML, DB2, OBIEE

Confidential, Chicago, IL

Business/Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for ICP data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools(e.g. Teradata)
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality

Environment: SQL/Server, Oracle 9i, MS-Office, Agile, Teradata, ER Studio, XML, Business Objects

Confidential

Business Analyst

Responsibilities:

• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process Modeling.
• Reviewed Development Plans, Quality Assurance Test Plans and User Documentation to ensure correct interpretation of original specifications.
• Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Matrix
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.

Environment: Microsoft Office, Oracle 9i, Rational Clear Case, XML, MS Visio and Manual Testing

Confidential

Jr. Business Analyst

Responsibilities:

• Worked as a software associate for Confidential Solutions, working for a client called L&T.
• Involved in the design phase of the project, communicated with the business and prepared Technical Specification Document.
• Actively participated in the development and Peer reviews of new applications and enhancement work.
• Used SQL queries to compare the database and the periodic reports generated by the application at various levels.
• Prepared Test plans, Test Cases and based on business requirements for functional testing.
• Interacted with the Functional and the technical team in identifying and building test data.
• Performed Positive and Negative test cases for various business scenarios.
• Analyzed data and created class diagrams and ER diagrams for designing databases. Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Documented System Test Summary report for project sponsors and obtained business sign-offs.

Environment: Windows XP, MS Access, Excel, MS Visio, Win Runner and Quick Test Pro, Quality Center, ClearQuest, UML 2.