SUMMARY

• Over 8+ Years of experience as a Business Analyst/Business System Analyst/Data Analyst in various domains including Banking Finance,, Mortgage, e - Commerce, Pharmaceuticals, Insurance (Property & Casualty/Worker’s Compensation)
• 4+ years of experience working with Business Intelligence (BI) and Data warehousing tools like Tableau, Cognos, Hyperion Essbase, Hyperion Planning, and Informatica., and remove the other reference.
• Expert communicator (written, verbal and presentation) involved in high level interaction and influence with variety of audiences (Senior Executives, Clients PMs, developers, SME) as well as PMO
• Experience analyzing and documenting project scope documents and SOWs, project plan, project/requirement change request forms, BRD, FRD, SDD, requirement traceability matrix, use cases/sequence diagrams, UML, wireframes/mockups, end user documentation and BPM notations
• Worked extensively with teams for development of Business Rule Engines to support SOA architecture and web services.
• In depth knowledge of the Software Development Life Cycle (SDLC) using Agile and other methodologies such as Rational Unified Process (RUP) and Waterfall
• Experienced working with Business Intelligence (BI) and Data warehousing tools like Cognos, Hyperion Essbase, and Informatica.
• Experience in design, configuration, development and deployment of Business Intelligence applications using OBIEE.
• Proficient in IBM Security Identity and Access Management (IAM)
• In-depth knowledge of Project Management Book of Knowledge (PMBOK)
• Proficient in creating and managing Requirement Traceability Matrix (RTM) for tracking and managing changes based on project’s evolving needs.
• Facilitated Joint Application Design (JAD) and Rapid Application Development (RAD) teams with all IT group members for communicating & managing expectations and to discuss various means for integrations with current system using an adoption through execution strategy.
• Working knowledge in writing SQL queryforidentifying databases involved in the application development.
• Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
• Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities
• Understanding of investment banking, asset management and other fund management functions.
• In-depth knowledge of Anti Money Laundering (AML) and Bank Secrecy Act (BSA). Worked on Suspicious Activity Reporting (SAR), OFAC reports, Currency Transaction Report (CTR), Foreign Bank & Financial Accounts (FBAR) and CMIR reports.
• Understanding of different mortgage instruments like Mortgage Backed Securities (MBS), Collateralized Mortgage Obligations (CMO), Asset Backed Securities (ABS), including the tranche structuring and credit enhancement processes to manage prepayment and credit risk. Knowledge and understanding of the functions of mortgage agencies like Ginnie Mae, Fannie Mae and Freddie Mac.
• Understanding of Dodd-Frank Act and the implications of its various key provisions like Volcker rule, Collins Amendment on bank’s trading activities and capital requirements including Basel II, Basel III.
• Extensive experience in developing and enhancing applications for financial processes including Hedge Funds Pricing, Trade and Settlements operations.
• Worked with star and snow flat schemas to create fact and dimension tables.
• Created tabular, matrix, pie, bars and column reports to meet client requirements.
• Performed ETL and analyze different sources of incoming data and performed various transformations.
• Performed GAP and cost-benefit analysis as required.
• Worked extensively with application programmers to develop proposed solution prototypes.
• Wrote use cases and Developed Test Plans and created Test Cases.
• Obtained expertise in performing System, Acceptance, Regression, Integration and Functionality Testing.
• Exceptional understanding of the QA life cycle, from test plan, test scripts, issue resolution to User Acceptance (UAT), System Integration (SIT) and end-to-end testing
• Performed financial analysis such as cost analysis, NPV, IRR, and ROI as well as risk analysis
• Worked on Reports based on the requirements and Test driven development (TDD)
• Experience using DMAC and RASCI methodologies, root cause analysis etc.
• Proficient in Creating and Transforming Business Requirements into software requirement specification (SRS) using MS Word and Rational Requisite Pro.

TECHNICAL SKILLS

Project Methodologies: RUP, Waterfall, Agile (SCRUM)

Business Modeling Tools: MS Visio, Rational Rose

Requirement Management Tools: Rational Requisite Pro, Caliber RM

Quality Management: DevTrack, Bugzilla, Jira, Quick Test Professional

Defect Tracking Tools: Rational Clear Quest, Quality center

Languages: C#, Java, HTML, .NET, XML

Operating Systems: Windows NT/XP/2000/7

Web dev tools: Dreamweaver, FrontPage

Databases: Oracle 11g, Oracle (8i/9i/10g), SQL Server, MS Access

Tools: MS PROJECT, SQL, HTML, SharePoint, MS Office

BI/ETL Tools: Informatica, Cognos 8.4, Essbase, OBIEE 11g,Tableau

PROFESSIONAL EXPERIENCE

Confidential - Enfield CT

Business Analyst/System Analyst

Responsibilities:

• Interacted with the Subject Matter Experts (SME’s) and stakeholders to get a better understanding of client business processes and gathered business requirements for Reconciliation and Reporting functionalities
• Created detailed Business Process Models (BPM) and documentation during the initial discovery phase of the project.
• Defined and updated BPM (Business Process Models) for various applications by interacting with the application owners and Subject Matter Experts (SME’s).
• Prepare project progress reports and status reports for management on an ongoing basis.
• Collect and analyze existing customer data and external market data, to identify market trends and opportunities.
• Manage OBIEE technical requirements based upon SME information and determine optimal development approaches.
• Develop OBIEE metadata repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer. Work on customizing Repository and configure metadata objects (Subject Area Table Column) and Web Catalog Objects such as Dashboards, Pages, Folders, and Reports.
• Use Data Modeling (Physical & Logical), Data Analysis and wrote High level and Low level Design Specifications for ETL and Business Intelligence (BI). Work with ETL team for data mart modeling to design complex OBI repositories & BI solutions.
• Collaborate with project and client leadership to configure interactive dashboards to track progress.
• Create iBots to send preprocessed reports using OBIEE Delivers.
• Generate tables, listings, and graphs using Excel, also used Excel to generate end of day reports for input into OBIEE.
• Utilize OBIEE Administration Tool components in both Application and Business modeling.
• Responsible for developing/converting over 200 discoverer reports using OBIEE 11g.
• Validate reports using OBIEE and Oracle data warehouse in comparison to current FMT reports.
• Lead requirement reviews with business and technology teams.
• Critically evaluate information gathered from multiple sources.
• Reconcile conflicts and break-down high-level information into details.
• Distinguish user requests from the underlying true needs for Reporting Functionality.
• Performed extensive requirement analysis including data analysis and GAP.
• Design detailed Use Cases to then derive Functional requirements from detailed Use Cases.

Environment: s: OBIEE 11g, Oracle 11g, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher MS Visio, SQL, PL/SQL, InteGREAT, SharePoint, Lync, WebEx.

Confidential, Pittsburgh, PA

Business Analyst/System Analyst

Responsibilities:

• Gathered, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Documented business rules, understood the business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for the SRS document.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Selected the appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with the back office portfolio management and sign offs on requirement artifacts from project managers.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Determined the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
• Executed two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.
• Led numerous JAD, mitigation, and negotiation sessions with key stakeholders to discuss alternate solutions for Process improvement.
• Worked with the Remediation team to identify and analyze the ISA (Information Security Administration) functions to check for compliance and open CAP (Corrective Action Plan), RA (Risk Acceptance) or RE(Risk Exception) for AML (Anti Money Laundering), Bond trading and Fraud prevention applications.
• Participate in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.
• Worked on various credit card applications to ensure PCI compliance and perform other ISA (Information Security Administration) functions.
• Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1,2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.
• Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss the impact of change request on the project.
• Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment
• Used Enterprise Architect and exercised UML methodology in creation of UML diagrams such as, Activity and Use Case, Context diagrams.
• Initiated and exercised various strategies involved in website Usability, Functionality, and Compatibility testing.
• Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.
• Assisted the project team to enhance the Personal Loans, Credit Card, Internet Services, Mortgage Services divisions and Mortgage payments functions.
• Created Test Plan document, test cases, test scripts and expected results for UAT.

Environment: RUP SDLC, Risk Management, Tableau, Enterprise System, Core Banking, MS Project, MS Access, Dreamweaver, Mobile Application, SQL Server, IBM Requisite Pro.

Confidential, Greenwood Village, CO

Business System Analyst

Responsibilities:

• Gathering requirements from Business Line Mangers and SME’s for the redesigned Confidential Client Portal, Client Database and to Digitize the Transactions.
• Perform system and document analysis to understand the current systems.
• Develop Process Model and detailed Business Policies and documenting the same in Business Requirement Document.
• Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for Confidential Client Portal functionalities in Visio.
• Develop Use Case diagrams, Use case Narratives and User Stories.
• Administered Identity and Access Management (IAM) (including password management) controls for staff and vendors assigned to department-level projects.
• Prepare Wireframes, Prototypes and Mock up screens for different web pages.
• Develop Customer Database Mapping Document and Digital Transactions Mapping Document to map all Policy Administration Systems.
• Identify the required fields for Client Database from Client extracts and Contract extracts from different Policy Administration Systems.
• Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
• Created and Managed User Stories in Epics, Themes and Sprints; also calculated velocity and Story-points in TFS. (I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool).
• Coordinate with offshore team in documenting the gathered Requirements in to BRD’s and FRD’s.
• Interact with SOA architects for developing Integration Service Bus(ISB) & Enterprise Service(ESB).
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Develop Service Mapping Documents to map UI Literals to Administration Systems.
• Help developers understand Business Requirements and design for Graphical User Interface (GUI), Client Database and Digitize Transactions.
• Coordinate with QA team to determine and develop Test Plans, Test Cases and methods for Unit Testing, Integration and Functional Testing based on testing requirements.
• Participate in User Acceptance Testing (UAT) and developed Training Manuals.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
• As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; Created dummy accounts to validate against the back-end and the front-end data.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data.
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Perform data validation using SQL queries and run ad-hoc queries to show data to the business users.

Environment: Business Objects, Cognos 8.4, Informatica, Rational Requisite, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer, IBM Master Data Management (MDM).

Confidential - NYC NY

Business Analyst/Data Analyst

Responsibilities:

• Performed business specification (BRD) and data requirements, use case models, GUI, use cases, functional specifications and data flow diagrams, ER diagrams, unit testing and beta testing to create a library of financial modeling tools for our applications for the analysis and modeling of derivatives for valuation, pricing and simulation, interest rate risk assessment, cash flow forecasting, intraday quotations from data feeds, contract specifications, trade capture, trading, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications for various trading platforms including Bond trading.
• Designed and maintained Tableau 5.1 reports used to graphically analyze business data.
• Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure for trading for implementing the derivatives trading application - a diagrammatic flow of investment process, trading, data transaction between application, pricing and analytics, database, data feeds and back office integration (trade confirmations, processing, settlement, collateral management, market data), portfolio valuation including bond rating and accounting
• Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, and Exotic Options.
• Coordinated with various data feeds (Reuters, Bloomberg, Markit) for market data, reference data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics
• Performed detailed analysis and work - flow diagrams for derivatives trading which included - preparation of market & reference data, analysis & decision support, modeling a contract, preliminary instrument setup on the application
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Extensively worked on Validating and Testing report in Query Studio and Analysis Studio, which included trading data & portfolio performance, holdings reports, end of day reports, broker summary reports, prime brokerage reports, risk analytics reports, TCA & cash forecast report
• Created different Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of Reports.
• Created new ETL process to extract, transform and load data from different sources to data ware house.
• Participated in Data Mapping, Data Conversion, creation of the Data model and used SQL and Toad to extract, filter and validate data
• Created T-SQL objects such as tables, views, joins and store procedures to meet client requirements.
• Analyzed systems and data to identify functionality gaps for front end module, Trade Worksheet and Back office Module for various CDS and asset management platforms which includes fixed income, annuity, mutual funds and bonds.
• Involved in manual trade data reconciliations, analyzing the chart of accounts, tracking the GL transactions and validating them from their mainframe systems.
• Worked closely with the business users to build the models and delivered based on the sign-off.

Environment: s: Business Objects, Informatica, Rational Requisite, Tableau, Rational Rose, Rational Clear Case, UML 2.0, MS Project 2000, MS Office, Oracle 10g, Windows 2000, XML, Power Designer

Confidential - Mount Laurel, NJ

Business Analyst

Responsibilities:

• Gathered requirements from business users and analyzed them using Rational RequisitePro
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to automate the loan approval process for home Mortgage (online application, workflow - for the credit department, upon approval the system routes the application to the underwriters for review)
• Acquired in-depth knowledge of the banking industry (Mortgage, Assets, and Accounts Receivables/Accounts Payables etc)
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system
• Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology
• Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio
• Involved in testing all the data elements in Mortgage Account Inquiry Service, which is called to obtain Mortgage loan data from MSP
• Worked on mapping of MSP Web services to Enterprise Interface Partners and coordinated with FIS on MSP
• Sketched diagrams of proposed and existing systems using Visio
• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Acted as a liaison between business users and system development team during development process
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro
• Supported IT & Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow
• Created a RACI matrix based on the organization standards for ongoing operations and issue resolution procedures
• Gained thorough understanding of Cash Management, Liquidity Positions and Liquidity Ratios
• Worked with the Quality Assurance team to create Test Plan and Test Cases and conduct unit, integration, and system testing
• Tracked changes using Rational Clear Quest
• Assisted QA lead in developing quality procedures and ensuring that appropriate documentation is in place
• Conducted User Acceptance Testing (UAT)
• Participated in developing of Training Materials for the new technology and User Training
• Worked effectively with Project Manager in handling the whole project

Environment: s: SDLC, Agile Methodology, Rational Clear Quest, UML, Oracle, MS Project and MS Office.

Confidential - Farmingham, MA

Business Analyst

Responsibilities:

• Served as a liaison between the business and technical developers to define problems, enhancements, and solutions.
• Facilitate Work sessions and Solution discussions across business units to understand reported problems and to drive acceptable solutions / workarounds.
• Working with clients to better understand their needs and present solutions using agile approach.
• Interacted with the agile team to gather requirements from the customer and documented for use by the developers through Story Card.
• Created best-practice requirements deliverables, such as use cases, system process flows and context diagrams
• Gathered requirements, developed Process Model and detailed Business Policies.
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Review Use Case History to identify existing requirements that support claimed functionality performance.
• Documented the FRDs and BRDs for Ecommerce projects.
• These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface
• Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
• Conducted Gap Analysis for the system considering AS IS and TO BE features.
• Develop user manuals, presentations and training manuals as per project specifications and timelines.
• Created the Traceability Matrix to ensure that all the user stories are being tested and covered in the testing plan.
• Drive Problem Resolution by holding resources accountable for delivery dates and pursuing continual follow through as necessary, this can include additional technical team meetings to brainstorm ideas.
• Conducted UAT sessions to approval.
• Facilitated the design and development of Business Rule Engines to support SOA architecture and web services.
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Extensively involved in Data Governance process. Assisted in data grouping and defined relationship among the different tables.
• Partner with Release Management areas to insure any potential issues or road blocks are avoided and approved Release Candidates are deployed on time.
• Proficient in writing good SQL queries.
• Develop and foster relationships with business and development teams to ensure transparency of processes to resolve more Critical / high priority problems that meet our business and ultimately our Guests expectations.
• Provided overall project management to multiple projects successfully completing them on-schedule and on-budget.
• Build and managed a cohesive team to meet deliverables per project / track assigned.
• Provided customer support as required to meet service level agreements.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.

Environment: s: SharePoint, MS Office, MS Project, Oracle Agile PLM, SharePoint 2010, Informatica, Java, XML, MS Visio, Agile, Quality Center, SOA, SQL.

Confidential - Newport Beach, CA

Business Analyst

Responsibilities:

• Analyzed client systems and Business processes.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and requirement gathering
• Gathered Business Requirements, created Functional Requirements (FRD) and analyzed data/workflows to define the scope, project financials and progressed from problem statements to well documented designs.
• Documentation of the AS-IS and TO-BE process for current and future phases of the Claims Management System
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Gathered requirements for Policy Admin, Claims and Billing module for Non-Standard Auto, Home Owners, and Worker’s Compensation policies.
• Created a file of ACORD Forms for both Personal and Commercial Lines of Business used as the standards in all Property and Casualty markets.
• Worked as a Personal Lines Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Documented and delivered Functional Specification Document, DD Documents and various other documents needed for the project team
• Conducted JAD sessions for communicating with Stakeholders and Project delivery heads.
• Developed business requirement specification documents as well as high-level project plan
• Developed timelines for Project delivery and Managed projects/resources
• Imparted functional knowledge and understanding through facilitating training and mentoring to development and Testing teams
• Provided Training, UAT and Product support
• Involved in the creation for Manual Raters for Auto products
• Monitoring the Configuration and Customizations activities
• Change Management
• Worked as a Single point of Contact for Offshore and Onsite Model.

Environment: s: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), Facets 4.21, UML, Rational Rose, Mercury Test Director and MS Office Tools.

Confidential

Business Analyst /Data Analyst

Responsibilities:

• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
• Assisted in the design and support of ETL jobs and SSIS packages.
• Documented Risks, Issues, and Dependencies as required weekly and send communication via email with the necessary updates.
• Gathered, analyzed and defined business rules used in report requirement documents.
• Conducted JAD sessions and user interviews at both in-house and client locations, gathering and analyzing requirements using Rationale tools.
• Authored complex stored procedures used in ad-hoc and subscription based SSRS reports.
• Designed, deployed and maintained SSRS reports.
• Assisted Project Teams in preparing Functional and Non-Functional Requirement documentation.
• Performed Gap Analysis by identifying existing technologies documenting the enhancements to meet the end state requirements. Also responsible for writing Functional Requirement Specifications (FRS).
• Assisted teams in extraction of data using SSIS, from staging database and performed the various transformations and load data into the Data Warehouse Database.
• Assisted in user testing of systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Expertise with business process modeling using Visio to present functionality to the users.
• Incorporated RUP methodology to create Business Requirement Document Specifications.
• Managed and documented risks, change requests, and issues and escalated when required.
• Assisted teams in creating different SSIS packages in different Control Flow and Data Flows.
• Created manuals adhering to quality, security and included requirements, design, operational, test, installation, migration, proposals to ensure project implementation and support.
• Functioned as the primary liaison between the business line and the technical areas throughout the project cycle.
• Created UML Diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), Web Page Mock-Ups, thus defining the Business Process Model.
• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Documented Business Requirement Documents (BRD) from essential Business Process, Business Rules.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Developed Test Strategy and Test Plan to ensure that test cases reflect user needs for functional, performance, and usability and security requirements.
• Involved in debugging and troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Communicated the bugs and defects to the developers tech lead, analyzed and worked with the Business and IT team in the resolution of the System Testing Defects and in the resolution of the Production issues by reviewing the requirements.
• Assisted with the analysis and management of critical storage and data protection capacities. Improved reporting by producing business requirements documents to capture metrics, and by creating resulting charts and graphs to provide rapid understanding of issue management.
• Extracted key progress metrics for entire team, Drive risk and issues process. Maintained program-wide approaches, plans, policies and procedures and provided Program Management Support.

Environment: s: Test Driven Development (TDD ) cycle, SSIS, Quality Center, MS Project, MS excel, MS Word, Teamcentre, MS Visio, MS .NET, MS SQL, MSBI.