SUMMARY:

• IT professional with 17+ years of experience in Analysis, Design, Development, Unit/ System Testing, and Quality Assurance.
• Experience in business requirements gathering, define and capture metadata for business rules, creating physical infrastructure, system analysis, design, development and user training associated with the ETL processes
• Experience in working with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Experience in Software Analysis & Design, Gathering Functional and Business Requirements Specifications, User Interface Specifications, Technical Design, Test Cases and Test Plan.
• Strong Knowledge of SDLC, UML, RUP, Waterfall, Agile/Scrum methodology and project life cycle.
• Extensive experience in writing Use Case Specifications, Business Requirement Documents (BRDs), High Level Design Documents (HLDs), Low Level Design Documents (LLDs) and Requirements Traceability Matrices (RTMs).
• Expertise in facilitating Joint Requirement Planning (JRP) sessions, Joint Application Design (JAD) sessions with Subject Matter Experts (SMEs), Business User Groups, Top Management Groups and Technical Groups.
• Excellent experience in developing and executing Test Approach Documents, test plans, test scenarios, test procedures, test cases, test data and test scripts according to Business and Design Specifications.
• RDBMS experience in DB2, Teradata, Oracle, SQL Server and programming experience using PL/SQL, SQL
• JIRA, Quality Center, Test Director and PVCS Tracker tools are extensively used to track the testing efforts and defects.
• Good Functional knowledge in Financial, Telecom and Healthcare domains

TECHNICAL SKILLS:

Languages: COBOL, JCL, JAVA, ASP, VB Script, SQL

Databases/OLTP: DB2, Teradata, Oracle, SQL Server and CICS.

Tools: IBM Rational Rose, Requisite Pro, MS Office suite/ Visio, INTERTEST, Expediter, Endevor, File - Aid, File mast, INSYNC, PRIDE, AHD, OPC, CHANGEMAN, BMC, TOAD, Teradata SQL Assistant,Team Track, Test Director, Quality Center and PVCS Tracker, Axture RP Pro 6.5 and soapUI 4.5.1

Methodologies: Waterfall, Agile/ Scrum methodology, System Development Life Cycle (SDLC), Joint Application Design (JAD), Rational Unified Process (RUP), Unified Modeling Language (UML), User Acceptance Test (UAT), Inmon and Kimball Concepts, Star Schema, Snow Flake Schema.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Analyze the current system RIRW (Risk Insight Risk Warehouse) and make sure the data flows from different sources systems to RIRW.
• Writing test script, use cases, and executing testing on the platform. Test scripts are written based on requirements learnt from business partners.
• Taken the requirements that are stated and prepared test scripts for different scenarios and workflows with multiple systems.
• Interact with business partners and development team on a day to day basis to recommend new features for the application.
• Interact with team to strategize on a development and design of business requirements and systems.
• Write SQL queries using Microsoft SQL Server Management Studio (Microsoft SQL Server 2008/2012) to validate data and test cases.
• Logging, tracking and successfully testing items in JIRA and Quality Center for the release.

Senior Business Analyst

Responsibilities:

• Analyze current system and process gaps in context of functional requirements.
• Participate in Joint Application Requirements (JAR) sessions with Business Users and Work Sessions with stakeholders, Call center/Customer Service, Marketing Communications, Design, HR, Community Outreach, Web/Social Team, Executive Team, and IT Team.
• Document Analysis (Call Center Data, Brand Guidelines, etc.) and also requirements and current state processes
• Interacted with third party applications like Western Union, ESRI/GIS, CCS, and Striata.
• Interacted with Water Metering Systems / AMI advanced meter consumption data teams.
• Created Functional requirements documents (FRD)
• Involved in data governance for assessing, improving, monitoring, maintaining, and protecting organizational information.
• Created Swim Lane diagrams using Microsoft Visio for all the current state (As-Is) and future state (To-Be) work flows and created Use Case documents.
• Proficiency in SQL skills, excellent Analytical skills
• Update project records using MS word, Excel, PowerPoint and Visio documents in SharePoint site.

Senior Business Analyst

Responsibilities:

• Analyze current system MASTARS (Maintenance Activity Scheduling, Tracking, and Reporting System) and process gaps in context of new business and functional requirements.
• Analyze functional requirements and partner with technology resources to translate into technical requirements (RDD).
• Coordinate with Topology Services and other provisioning systems (VI, BGW BAAIS and iVAPP etc.)
• Coordinate with external systems like VI, ETMS, IMPACT, INMS, and OASIS...Etc.
• HP Quality Center 11.5 is used for requirements and defects tracking.
• Develop web based screen mockups using Axure RP Pro 6.5.
• SQuirreL SQL Client is being extensively used to communicate with Oracle 11g database.
• Update project records using MS word, Excel, PowerPoint and Visio documents in SharePoint site.

Senior Business Analyst

Responsibilities:

• In the process of merging Countrywide and Merrill Lynch Deposit, Customer, e-commerce and Mortgage Loans System of Record's are converted to BAC System of Record's and then sourced to The W's production environment.
• Analyze current system and process gaps in context of new business and functional requirements.
• Interact with the End users (Downstream Users) of the “The W” data.
• Analyze business and functional requirements provided from the business and partner with technology resources to translate into technical requirements.
• Facilitated JRP and JAD sessions with the stakeholders for functional requirement gathering.
• Involved in data governance for assessing, managing, using, improving, monitoring, maintaining, and protecting organizational information.
• Created several Business Requirement Documentation (BRD), High Level Documentation (HLD) for Systems Conversion projects as well as for the Business As Usual (BAU) projects.
• Coordinate integrated testing efforts for all Countrywide/Merrill Lynch transition projects impacting The W (Data Warehouse).
• Responsible for all test script execution and uploading test results to Quality Center.

Business Analyst

Responsibilities:

• Working closely with business groups, gathering technical requirements or understand enhancement requests and the affect on shared enterprise storage and mainframe-based platform infrastructure
• Communicated and worked closely with business and developers to translate business requirements into technical requirements.
• Conducted JRP sessions with stakeholders and also with the project team at various project phases.
• Design, develop, install, implement, fine tune, maintain databases, database dictionaries monitor standards and procedures and integrate systems through database design and administration.
• Create Business Requirement Document(BRD) and High Level Document(HLD)
• Involved in development of Enrollment Broker Project.

Business Analyst

Responsibilities:

• Analyze the functional requirements, actively participating in all requirement meetings.
• Strong facilitation skills with ability to elicit requirements from various stakeholders across the organization.
• Commenced general and detailed requirements, system design, employing a JAD/JAR sessions.
• Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams.
• Created Business Requirement Documents(BRDs) and High Level Documents(HLDs)
• Demonstrated problem solver with the ability to work individually or cross functionally to ensure internal and external client satisfaction.
• Implemented SDLC which included Requirements, Specifications, Design, Analysis and Testing utilizing RUP methodology.

Sr. Developer

Responsibilities:

• Developing the programs in COBOL, VSAM and JCLs in the Fixed Income module.
• Communicated with the Business Analysts about the business and the enhancements of the new projects.
• Coordinated other teams to assist them in completing the projects in time.
• Extracted the data from the backups and proving the same to the clients to build the statistics and take the decisions.

Sr. Developer/Sr. QA Analyst/Developer

Responsibilities:

• Analyze the direct and derived requirements of the end users by constant interaction with the primary users.
• Design, Development, Implementation and support of the application.
• Prepared Test Plans and Test Cases, perform QA activities