SUMMARY:

• Business Analyst Expert with 8 years IT experience on all phases of a SDLC project with a primary focus on analysis, product implementations, system - integration/migration and process improvement. Multitalented and flexible professional with significant experience in Business/Data Analysis, Testing, Workflow and Process Development, and Change Management.
• Extensive experience in theDataWarehousing implementations for Financial/Finance,Insurance, Mortgage.
• Strong knowledge in Capital Markets, Equities, Debt, Mutual Funds, Mortgage, Portfolio Management, Performance Analysis, Risk Analysis and Wealth Management.
• Experienced in helping organizations with process development, requirements definition, user acceptance testing, and training development and delivery.
• Experienced inDataModelling, ETL &DataAnalysis experience using DimensionalDataModelling and RelationalDataModelling, Star Schema/Snowflake, Modelling, FACT & Dimensions tables, Physical & LogicalDataModelling.
• Hands-on experience with an enterprise Content Management System
• Experience in OLTP, OLAP, Slowly Changing Dimensions,DataCleansing andDataMigration.
• Experience working Business Process Analysis, Business system Management and Requirements Management,DataExtraction,DataCleansing,DataProfiling,DataConsolidation, andDataQuality for various businessdatafeeds.
• Experienced in SQL queries to extract data from various databases for data analysis and generating reports per the formal specified Subject Matter Experts (SME's)
• Experienced in conducting Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs, and customer interviews.
• Profound experience in the field ofDatawarehousing and Business Intelligence implementation with expertise in AWS Redshift, AWS S3, AWS Athena, AWS GlueDataCatalog, Informatica, Power center, InformaticaDataQuality (IDQ), Informatica cloud, Business Objects
• Experienced in writing numerous SQL Queries and Performing ADHOC analysis.
• Written XSLT scripts for various XML needs and used XPath, XQuery fordataretrieval from XML documents.
• Expertise in writing Business Requirements Document (BRD), Functional Specification Document (FSD), Non-Functional Specification Document, System Design Specification, Use Cases, and training manuals.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies
• Expertise in feasibility requirements analysis, design, construction, testing, implementation, and UML methodology.
• Experience of working in the area of data management including data modeling, metadata, data analysis, data migration, Data alignment, Data cleansing and data mapping.
• Experience inDataWarehousing using ETL tools like Informatica & Teradata and reporting tools like Business Objects for business intelligence.
• Experience in dealing with differentdatasources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Experience in creating data dictionary having the business definitions of data mapping to map the logical data elements in use cases to physical data elements (record source).
• Skilled in gap analysis using AS-IS and TO-BE business process, SWOT analysis and cost/benefit analysis.
• Proficient in coordinating various technical and managerial teams to develop process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Expertise in change request management and developing configuration management documents.
• Significant experience in conducting User Acceptance Testing (UAT) verifying performance and fault tolerance issues.
• An effective communicator, excellent team player, quick learner and creative problem solver with finely tuned analytical skills and significant.

TECHNICAL SKILLS:

Project Management Tools: MS Project, Visio, iRise, Documentum, IBM DOORS, Team Track, MS Access, Microsoft Office Suite Word, Excel, Outlook, PowerPoint, Informatica, Crystal Reports, Business Objects

SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and Waterfall.

Requirements/Document Tools: Rational Requisite-Pro, Rational Clear-Quest and MS SharePoint/ MS wordDefect tracking tools Rational Clear Quest, Clear caseModeling and Design Tools Rational Rose, Microsoft VisioTesting Tools Load Runner, Quality, Win Runner and Quick Test Pro (QTP)Languages Visual Basic, C++, Java/J2EE, Oracle, VB.Net, ASP.Net, C#, HTMLDatabases MS SQL Server, MYSQL, PL/SQL, Oracle, MS AccessOperating System Microsoft and Mac

WORK EXPERIENCE:

Sr. Business Analyst/Data Analyst

Confidential, Columbus, OH

Responsibilities:

• Involved in preparing the project scope and objectives and Gatheredbusinessrequirements by conducting client group interviews, focused groups, workshops and online surveys.
• Conducted Joint Application Development (JAD) sessions with SMEs and stakeholders.
• Good understanding and hands on experience requirement gathering & analysis of BI projects
• Coordinated with project stakeholders to track the progress of the project, updated status and lead review meeting to ensure that schedules and deliverables are met.
• Created customized SQL Queries using MS SQL Management Studio to pull specifieddatafor analysis and report building in conjunction with Crystal Reports
• Performeddataanalysis on various financial reports that were generated in excels spreadsheets and was managed by MS Access database.
• Followed the AGILE methodology for the entire “SDLC”.
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Designed Use Cases, Use Case diagrams, Activity diagrams, Sequence diagrams in UML methodology using MS Visio
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.
• Developed and tested Store procedures, Functions and packages in PL/SQL forDataETL.
• Authored use cases, test cases and took ownership of traceability matrix by tracing the requirements in HPALM
• Hosted Daily scrum calls by shadowing the project manager when necessary to update sponsor on status updates and project progress.
• Created sprint burn-down charts, Facilitated daily stand-ups and review meetings.
• Facilitated the process by resolving the conflicts in the team and avoiding the impediments.
• Performed the analysis and visualization of thedatathrough Qlikview.
• Used Share Point for content management, and to share the information with the groups involved during the project.
• Assisted in working on the SQL to check the accuracy and consistency of thedata.
• Assisted in the client sidedatavalidations for thedataand generated many reports for thedata mapping indatawarehouse by Informatica and BI reporting.
• Good knowledge into financial domain like banking, credit management, capital market, Anti-money laundering and risk management.
• Helped the UAT team identify process related issues with the functionality of the models at the application level or at the component model level.
• Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.
• Assisted in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Interacted with developers to reportdatarelated bugs thorough JIRA and re-tested the fixed issues.

Environment: scrum (agile), MS-Visio, QlikView, Version one, .net, MY SQL, MS Word, MS PowerPoint, SharePoint, Excel, JAD, HP ALM, Web Services, HTML, XML, MySQL, Informatica 9.5, Agile, JIRA, Rational clear quest.

Sr. Business Analyst/ Data Analyst

Confidential, Mayfield Heights, OH

Responsibilities:

• Gathered business requirements through interviews, surveys, and meeting with the users.
• Understood and articulated business requirements from user interviews and then translated those requirements into functional and technical specifications.
• Interacted with SME's (Subject Matter Experts) of different divisions (Information Technology, Policy and Operation) and established a business analysis and design methodology around the RUP (Rational Unified Process).
• Prepared Logical Data Models and BRD supporting documents like the use case, sequential diagrams containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements using MS Visio.
• Responsible for running SQL queries against Oracle database to generate reports.
• Utilized Agile Scrum methodology and aggressively worked on every stage of SDLC
• Worked with Documentum and eRoom for storing documents like RTM and keep track of the projects.
• Worked with Capability Maturity Model as a guide to monitor the growth of all the processes throughout the project.
• Validated thedatabetween mortgagedatawarehouse and Baseldatawarehouse on monthly basis by developing numerous test cases/scripts in Teradata.
• Created rapid prototypes using iRise and facilitated usability testing to the end users and other stake holders
• Used batch control reports to upload data to the new system databases, to ensure no data was lost in the migration process.
• Developed and tested Store procedures, Functions and packages in PL/SQL forDataETL.
• Participated in design sessions, data and systems analysis, created data map and development integration documents
• Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
• Held group meetings, walkthroughs with the stakeholders on regularly basis.
• Developed and maintained relationships with clients on all on-going projects.
• Involved in writing Test Cases and developing strategies with Quality Assurance group to implement them.
• Efficiently responded to client inquiries and resolved discrepancies. Identified, prioritized, tested and proved essential business functions to assure compliance with vendor and internal auditing.
• Participated in System Testing along with testers. Conducted UAT with the business.
• Involved in Data validation in both front and back end.
• Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.

Environment: MS Visio, Rational Requisite Pro, Windows XP, MS Office, Informatica, Team Track, Rational Clear Case, MS Excel, Rational Clear Quest, XML, HTML, Microsoft SQL Server, LoadRunner

Business Analyst

Confidential, New York, NY

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed and documented business requirements based on the analysis of mortgage loan processing workflow model.
• Ensured verification and sign-off of business requirements by various stakeholders/investors under SOX Compliance.
• Worked with cross functional teams in order to establish comprehensive business and functional requirements and then translated those requirements into software design specifications.
• Created Gantt chart and used them to develop project schedule, allocate resources and make cost estimates using MS Project.
• Extracteddatafrom the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a singledatawarehouse repository
• Applied best practicebusinessprocess reengineering (BPR) techniques to develop efficient strategies for improvement including use cases, UML and BPMN.
• Involved in capturingdatalineage, table and columndatadefinitions, valid values, and others necessary information in thedatamodels
• Prioritized the requirements gathered from financial specialists, business users, domain experts through interviews and JAD sessions.
• Tested the ETL Informatica mappings and other ETL Processes (DataWarehouse Testing)
• Identified the deliverables at the end of the inception and elaboration phase of the Rational Unified Process (RUP) life cycle in terms of business modeling and requirements analysis.
• PerformedDataAnalysis andDatavalidation by writing basic queries against the database.
• Version control of the artifacts generated within the life cycle using Rational Clear Case.
• Created various Charts and Graphs like Bar Chart, Line graphs, Pie Charts for analysis.
• Analyzed UAT test scripts and scenarios for functional testing of new development, reports and issues resolution and created training material for users and QA group.
• Created and executed SQL queries and scripts to validate data movement.

Environment: Microsoft Office Suite, MS Visio, MS Project, MS Excel, Java, JSP, Windows XP, Solaris, Requisite Pro, Clear Quest, PVCS, Oracle, Toad

Business Analyst

Confidential

Responsibilities:

• Produced clear, detailed project scoping and design documentation to be used by technical specialists to build appropriate solutions in agile SDLC methodology.
• Elicited and developed clear, traceable requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, and task and workflow analysis.
• Drove and challenged business units on their assumptions of how they will successfully execute their plans.
• Collaborated with developers, architects, subject matter experts, and other IT team members to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Translated Business requirements and functional specifications into program specifications and database change requirements to the technical teams.
• Involved indatastructuring anddatamodeling of databases, creating tables, reports and maintaining them in MYSQL.
• Created Mapping Specification document to outline mappingdatafrom source systems to the targetdatawarehouse.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers
• Assisted in the development of business cases, considering financial, resource, and technological constraints; develops cost estimates with consideration to business impacts and risks.
• Useddataanalysis techniques to validate business rules and identify low quality missingdatain the existingdata.
• Ensured that approved requirements are developed in sufficient scope and detail to result in the delivery of a solution that meets customer needs as they perceive them.
• Performed analysis and created Source to target mapping document for incoming LOB and existing projects for process improvement.
• Interacted with business customers to define, analyze, and deliver customer testing requirements and complete acceptance testing.
• Worked on preparing the UAT Test Plan and Test cases for the project and identified any gaps within the effort.
• Mentored and trained junior Business Analysts and Developers when performing system and acceptance testing.
• Created and executed SQL queries (using Rapid SQL and MS Access) and scripts to validate data movement.
• Created product documentation, including online help, printed user manual, and training materials.
• Supported the organization's project management policy, practice, methodology and documentation requirement.
• Proactively communicated and collaborated with external and internal customers to analyze information needs and functional requirements and delivered the following artifacts: Functional Requirements; Technical Requirements, include architecture, interfaces, security and business continuity; Use Case documentation.
• Participated in project audits, closure activities or other quality initiatives.

Environment: UNIX, Erwin, MS Visio, Mercury Quality Center, .Net, SQL Server, iRise, MS Access, MS Windows, Team Track, Requisite Pro