SUMMARY

• Ten years of work experience in IT Industry.
• Worked as Business Analyst with strong Business Intelligence tools and data analysis with an in-depth understanding of designing and creating Business Intelligence Applications and Repository Solutions.
• Worked as Systems Analyst/Test Engineer in software development of various commercial, web and windows applications in Client/Server environment.
• Analyze the business and user needs to develop requirement documentation for the implementation or revision of system and application projects for specified business unit. Understanding complete Software Development Life Cycle.
• Expertise in Business Intelligence, Data Analytics, Data Warehousing and understanding of the organizations system and capabilities to ensure the most efficient use of resources.
• Working in conjunction with business users, development and QA teams both Onsite and Off-shore , responsible for creation and execution of application test scripts, scenarios, and test plans that validate initial business requirements.
• Collaborate with developers, product personnel and end user to establish the technical vision and analyze tradeoffs between usability and performance needs.
• Liaise with other project groups and business to ensure co-ordination of functionality affecting other functional areas and initiatives
• Subject Matter Expert on Business Intelligence, Data Analysis, Business Process, and Business Methodologies.
• Work independently with end users to define concepts and understand direction of project managers.
• Experience testing web-based applications developed with C .Net, Java, Web Service, Active Server Pages, HTML, XML, Visual Basics, Siebel, Cold Fusion.
• Experience working/using BI/DW Tools such as Mircrosoft - SQL 2012 Suite SSAS, SSIS, and SSRS , PL/SQL and SQL Plus, usage of IIS, SharePoint and Active Directory.
• Expertise in Writing, Executing and Maintaining BRD's, FSD's, SoW, Use Cases, Test Plans, Test Cases, Test Scripts, driving triage meetings, effectively coordinating with integrated team, building deployments in every release and in all phases of SDLC.
• Experience in Analysis, Design, and Development of Agile/SCRUM Methodologies.
• Experience in Unit Testing, Functionality Testing, Performance Testing, Integration Testing, System Testing, Regression Testing and User Acceptance Testing.
• Worked on Logical and Physical data modeling and other design review sessions to determine and describe data flow from source to target databases by coordinating with DBA's and Application Architects.
• Performance of the Client/Server Applications such as Databases and Websites. Experience in working with various Automation Tools.
• Familiar with concepts of SQL queries ranging from DML, DDL, TCL, Views and Cubes.
• Security policy/procedure development and risk analysis with focus on HIPAA certified and Business Process Management.
• Experience in Testing the VRU-IVR systems applications and Mobile device experience Android, iPhone, iPad, etc. .
• Strong analytical and product management skills with thorough understanding of business needs and translate them into application and operational requirements.
• Key Player with excellent inter-personnel communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
• Quick learner of new application process and tools.

PROFESSIONAL EXPERIENCE

Responsibilities:

• Elicit Requirements using triage meetings, data analysis, business process descriptions, uses cases, scenarios, business analysis, and workflow analysis.
• Project Management and Test Coordination. Responsible in deploying the product on estimated time frame and planning Business Intelligence Data Warehouse Testing process.
• Leading a Team of 6-8 Analyst assigning the tasks, managing the data needs, tracking the status, ensuring its proper and timely execution from functional, running the reports and check point/stand up meetings.
• Comprehensive project management inclusive of ensuring that projects are documented, approved, structured and planned in a manner that delivers appropriate business.
• Reviewing/Updating the BRD's, FSD's, RRD's, and Use Cases through each Product Life Cycle and reviewing the process of production release.
• Expertise in preparing Test Metrics and reports using Microsoft Excel.
• Liaise with technology and business teams on Web Content Management, test definition, planning, control and execution by overseeing documentation for testing approach/strategy
• Actively work with development and business personnel to develop and execute plans to validate systems/applications and business requirements developing user documentation, first draft of training materials, manual updates, understand, analyze the requirements and arrange defects triage meetings.
• Partnering with onsite BI and QA teams. Analyze business, system, and data mapping requirement specifications.
• Identifying areas of improvement in current design and testing processes. Create testing documentation, test scripts, requirement traceability matrices, and test summary reports.
• Mentoring QA analysts, training them on BI testing - Data Warehouse, Dashboards, Cubes, Views, ETL best practices and on tools SQL 2012 Suites SSAS, SSIS, and SSRS and SharePoint Performance Point.
• Used Agile Methodologies in all phases of software testing during development, prior to the application being launched and continuing during the product life cycle.
• All the Software defects in the applications were logged and tracked on daily basis.
• Excellent Communication skills, ability to interface with the business while working in a collaborative environment.

Environment Technologies Used

C .Net, ASP.Net, Web logics, Web Services, Java, J2EE, HTML, XML, XSL, COM, DCOM, IIS, Oracle11g, SQL Developer, SSAS, SSIS, SSRS, Cubes, SharePoint, Team Foundation Server, Quality Center - ALM, Selenium, SnagIt.

Responsibilities:

• Collaborate with developers and subject matter experts to establish technical vision and analyze tradeoffs between usability and performance needs.
• Actively work with development and business personnel to develop and execute plans to validate systems/applications and business requirements developing user documentation, first draft of training materials, manual updates, understand, analyze the requirements and arrange defects triage meetings.
• Ensure the requirements, plans, risks, issues, actions, costs, schedules, benefits, and other related project artifacts are documented and tracked with appropriate scope, milestones, and dependencies.
• Involved in Leading an End-to-End process of a Smart Works UI , Account Opening, Rep Reassignment, Rep On Demand, Commissions Trade Activities, 12B1, OPS, MECA- Month End Commission App , Money Settlements, Prime Sweep, eSearch, Net Wire, Aspire SSO, Mutual Funds, Folio, Advisory Billing Reports, Batch/PVIR, Historical Reporting CIS Cetera Investment Services and IMR Information Mgmt Reporting , Customer Mailing, and Sales Force process of testing.
• Support and coordinate system implementations through the project lifecycle initiation, planning, analysis/design, development, implementation, testing, rollout, and hand-over working with other teams on a local and global basis.
• Used Agile Methodologies in all phases of software testing during development, prior to the application being launched and continuing during the product life cycle.
• All the Software defects in the applications were logged and tracked on daily basis.
• Drive and challenge business units on their assumptions of how they will successfully execute their plans
• Developed detailed Testing Methodologies, Test Matrices, Test Plans, Test Cases and Test Scripts for both Manual Testing and Automation Testing.

Environment Technologies Used

C .Net, ASP.Net, Web logics, Web Services, Java, J2EE, HTML, XML, XSL, COM, DCOM, IIS, HOGAN, MVS, CISC, Shell Scripting, TSO/ISPF, DB2, Oracle11g, SQL Developer, Business Objects, IVR, SharePoint, Ascendis, Gemini, QTP, Quality Center - ALM, QA Complete, Selenium.

Responsibilities:

• Involved Validating an End-to-End flow of a Deposits and Wholesale/Whole tail/Retail Lockbox Products such as Retirement X-9.37 Products, Insurance, Annuity, Electronic Presentment, Automated Clearing House ACH , Automatic Enrollment System AES , Unified Authorization Module UAM , Account Reservation System ARS , Operations Image Browser OIB , Treasury Information Reporting TIR , Electronic Window, Lockbox Image Data Distribution LIDDS , Lockbox Archive Data Retrieval System LARDS , Integrated Wholesale Lockbox Images, Lockbox System of Records, VICOR/RIDS platform.
• Support and coordinate system implementations through the project lifecycle initiation, planning, analysis/design, development, implementation, testing, rollout, and hand-over working with other teams on a local and global basis.
• Used Agile Methodologies in all phases of software testing during development, prior to the application being launched and continuing during the product life cycle.
• All the Software defects in the applications were logged and tracked on daily basis.
• Drive and challenge business units on their assumptions of how they will successfully execute their plans
• Developed detailed Testing Methodologies, Test Matrices, Test Plans, Test Cases and Test Scripts for both Manual Testing and Automation Testing.

Environment Technologies Used

C .Net, ASP.Net, Web logics, Web Services, Java, J2EE, HTML, XML, XSL, COM, DCOM, IIS, HOGAN, MVS, CISC, Shell Scripting, TSO/ISPF, DB2, Oracle9i, SQL, T-SQL, PL/SQL, SharePoint, SOAP UI, QTP, Quality Center - ALM, Loadrunner, Selenium, HPOO, BPT, Clear Quest/Defect Tracking, Araxis Merge.

Responsibilities:

• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Preparing a Test Matrices through each Product Life Cycle and Reviewing the process from project kickoff to production release.
• Project Management and Test Coordination of Business Process Management using Appian Enterprises.
• Analyzing specifications, preparing data and test requirements, developing QA test plan and ensuring its proper and timely execution from functional specification documents.
• Actively involved with the business users to understand and analyze the plan participants, plan sponsors trading transactions, Automating Control Disbursements, Defined Benefits, Defined Contribution, Payments, Trade, Reconciliations and Web Content Management.
• Involved verifying and validating an Algorithmic Validation of customized 401 k applications such as Age Based Allocations, Active Employee Withdrawals, Enrollments, Document Management, Creating a Portfolio and Plan Sponsors, Insurance, Trading, Brokerage, Retail, Wholesale and Annuity.
• Used Agile Methodologies in all phases of software testing during development, prior to the application being launched and continuing during the product life cycle.
• Implemented Business Process Management to set up plan participants and plan sponsors with respect to Restricted Shares, Internal ID's, Share Prices, Scanned Images, Model Generators, and Reports.
• All the Software defects in the applications were logged and tracked on daily basis.
• Experience testing Web applications, writing test code and creating test data.
• Creating/Executing test plans, test cases, integration of applications on a multi-server environment, and perform basic troubleshooting, conducting regression tests using BPT Business Process Testing .
• Developed detailed BRD's, CRD's, FSD's, SoW, and Testing Methodologies, Test Matrices, Test Plans, Test Cases and Test Scripts for both Manual Testing and Automation Testing.
• Performed backend testing by executing SQL queries such as Stored Procedures, Packages, Triggers, to compare/match the data inserted into the tables.
• Compose SQL queries for data warehousing tests, data extracts, star schemas and executive information requests using DDL and DML.
• Experience with Siebel CRM tools and applications for Sales, Marketing, Call Center and Self Servicing, E-Billing, and Relationship Management.
• Extensively used Selenium IDE to test the performance of the web application in Firefox browser and Mac Systems.
• Used Selenium to test the applications that runs the HTML/Java Scripts on the web browser, both the Client/Server side script. Used Selenium IDE to Record, Edit and Run the test cases.

Environment Technologies Used

Siebel, C .Net, ASP.Net, Web Services, Java, HTML, XML, XSL, VXML, COM, DCOM, IIS, Business Objects, MVS, CISC, Shell Scripting, TSO/ISPF, VRU IVR , CISCO, DB2, Oracle9i, SQL, T-SQL, PL/SQL, SOA, Share Point, Omni Plus, Appian Enterprises, Quick Test Pro, Quality Center, Loadrunner, Selenium.

Responsibilities:

• Participated in design reviews and quality inspections for each release
• Actively involved with the business analyst and the business users to understand and analyze the requirements and Web content Management.
• Manually performed Ad-Hoc testing, end-to-end testing, System testing, Regression Testing, Function testing Performance testing, User Acceptance testing.
• Implementing HL7 standards for development of international healthcare informatics interoperability.
• Writing Test Plan, Test Cases and Test Scripts. Front-end testing includes Functionality, navigation, Alignments, links validation, Session management, cookies, Authentication, company specific colors, privacy policy using different web browsers and verifying all the web pages.
• Virtual user scripts to test the performance of the application with virtual users.
• Evaluating the performance of web based applications.
• Written SQL queries and Database checkpoints to verify data quality.
• Developed complex Stored Procedures, Functions, Triggers, Star Schemas and Packages using SQL and PL/SQL.
• Execute UNIX shell scripts to transfer/load data from one database to another and compare them running the SQL queries.
• Created Virtual User Scripts to interact with the applications GUI. Created Rendezvous points to test the transaction time responses of a Client/Sever end of an Application.
• Evaluating the scalability of web based applications.
• Developed automation scripts for the application and Performed back-end testing
• Prepared Test Data and performed Positive and Negative testing
• Responsible for performing all phases of Quality Assurance software testing during development and prior to the application being launched and continuing during the product life cycle.
• Defects in the applications were logged and tracked.
• Created Testing Methodologies, Test Matrices, Test cases and Test scripts.
• Analyze Data Base tables for data content and consistency.
• Performed Functional/Regression testing and Unit testing, Integration testing, Black box, System Testing and User acceptance testing.
• Experience working on complex multi-tier enterprise applications.

Environment Technologies Used

BEA Web Logic, C .Net, ASP.Net, HTML, XML, VXML, Active Directory, COM, DCOM, Oracle 9i, SQL Server, IIS, ETL Tool Informatica , Toad, Winrunner, Loadrunner, Test Director, JUnit, VRU.