SUMMARY

• Around 8+ years of professional experience in Dynamic Business Analyst/ Quality Assurance, Software testing, Process Improvement Analyst & Business Process Management for Fortune 500.
• In depth knowledge of Software development life cycle (SDLC), testing methodologies, Software Quality Assurance and Software Testing on Manual/Automation as a Sr. QA, include Software Quality Assurance, Business Analysis, Project Management, Release Management, Defect Manager, Automation Testing (QTP, Win Runner), Automation Frame Works, Training, experience in testing of various Web - based, Object oriented, Client Server, Window and Data Driven. Expertise in ATG ecommerce environment.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications. Good knowledge of PL SQL, ETL, Data warehousing and ACE.
• Experience in B2B, B2C and Ecommerce portals web application developments.
• Manual Testing, Automated Testing and Technical Writing. Quality Assurance of various Client/Server, ERP and Web Applications.
• Introduced the Agile SCRUM process for the Risk Data team and utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings. Experience in business requirements gathering and documentation. Worked on Enterprise Architect in order to prepare use cases.
• Lots of experience with Business Process Management (BPM), Business Rules Management (BRM), Knowledge Management (KM), Business Intelligence (BI), and Data Warehousing (DW).
• Extensive knowledge and good understanding of Avaya IVR applications
• Strong Working knowledge of Equity Cash Trading Concepts.
• Provided financial leadership to various product line managers.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis. Strong understanding of capital market instruments.
• Knowledge of 401K Retirement Domain (Insurance)
• Extensive experience in SQL testing for Validation of ETL Processes in Enterprise Data Warehouse (EDW).
• Analyzed processes and provided Direct reports on revenue to be submitted to management.
• Strong skills in developing Use Case Diagrams and creating Use Case Specification Documents
• Actively involved in developing, executing and managing User Acceptance Testing (UAT). Exposure to all aspects of software development, troubleshooting, testing, and maintenance.
• Good understanding of Software QA Principles and Processes.
• Obtained knowledge and wrote specifications for configuring business rules and functionalities in Guidewire.
• Write Test Documentation: Test Plans, Test Scenarios, Test Cases, Test Specifications.
• Developed/Maintained Test Plans, Test Cases, Black Box testing/grey box testing, Defect Tracking and reporting for both Manual and Automated Test Environments.
• Apply ultimate test automation tools such as QTP(VB scripting).
• Proficient in functional, negative, regression, System integration (SIT), User acceptance (UAT), load/performance, security, browser compatibility, and performance testing
• Extensive work with various rational tools like Requisite Pro. Requirement gathering/maintenance, Use Case document maintenance, Clear Case- version control and Clear Quest/Test Director for bug tracking, Rational Rose for Use case diagrams, Sequence diagrams and activity diagrams.
• Used Siebel Customer order management to simplify the complex of tracking products across multiple catalog and systems, present targeted product bundles for greater revenues, reducing operating costs.
• Experienced in developing functional specifications through JAD sessions and user interviews.
• Skilled with SIX SIGMA, DOE AND LEAN MANUFACTURING by applying to different strategies for improving business processes.
• Used Extreme dialogue for customer communication management, document automation and management system.
• Used TSS to process safe secure payments, keep track of all finance billing information's.

TECHNICAL SKILLS

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, STV, SDLC.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Web sphere, BEA Web Logic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro Documentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS), SSAS, SAS

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Boston MA

Responsibilities:

• Documented the mappings used in ETL processes.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Used HP Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Involved depth understanding of Credit Risk management for the application
• Utilized Agile Scrum methodology and aggressively worked on every stages of SDLC.
• Developed project artifacts like Requirement List, Process Models, Wireframes, Data Journal, and the Business Rules Catalog using MS-Visio and Rational Rose.
• Responsible for analyzing and translating business requirements for the development of business rules for Investment banking, Credit Risk and other business units.
• Worked on brokerage applications for trading, risk management and processing.
• Analyzed and prepared portfolio analysis report and P&L (profit and Loss) report by performing Risk Analysis (Credit Risk, Market Risk, Reinvestment Risk and Inflation Risk) based on client's investment objective and submitted to trade, and also developing and executing short and long term financial strategies customized to meet client needs
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Performed requirement analysis, went through all the product backlog and created sprint backlog.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walk throughs.
• Worked on data modeling and produced data mapping and data definition documentation during data governance.

Sr. Business analyst

Confidential, Columbus, OH

Responsibilities:

• Reviewed Business requirements, IT Design documents and prepared Test Plans for all assigned projects.
• Offered necessary on site administration along with proper quality control measures for ensuring the entire project finish on time and due budget.
• Performed ITGC (IT General Controls) and ITAC (IT application controls) as part of a global audit for a reputed MNC financial services firm.
• Provide necessary coordination and planning for the contractors along with the subcontractors of a team size > 10 in multiple projects. Created customized solutions/pitches for enterprise clients.
• Developed loading processes and scripts to combine data from disparate systems using ETL (Informatica) for Data warehousing purposes
• Leverage the knowledge of PAS product and P&C Business knowledge to provide quick solutions to the well as offshore team.
• Experience in fixed income markets data and portfolio and accounting data is highly desirable.
• Organize cost control with required payroll management.
• Created Use-Cases, Wireframes and State Diagrams to demonstrate software architecture and interaction of system components before prototyping.
• Working with technical developers to ensure they understand all aspects of the requirements, including assisting with the logical data modelling.
• Work closely with clientele to develop a personal brand facing and upgrading sensitive documents to an online format, versus paper brand.
• Managed the procurement of tools such as Adobe Analytics, and Tableu critical for marketing decision making.
• Responsible for hiring and retaining analysts working the tools to produce Analytical reports that helped organizational leaders to make decisions based on performance.
• Working with other loss mitigations specialist to better assist the clients and Communicated with multiple clients to perform loss mitigation and end to end mortgage servicing
• Experience working in the Commercial Package Policy, Monoline Insurance Policy, Workmen's Comp and Commercial farm Insurance
• Executing and testing with XML messages and SOAPUI for Web services testing for Clear Par as well as Markit Clear
• Supervised and managed Collection Agencies and Supervised and managed Collection Agencies
• Monitored the global capital markets for portfolio growth opportunities using fundamental and technical analysis
• Integrated and migrated all admin systems into a single platform called Accenture Life Insurance Platform (ALIP)
• Logged in all issues on SharePoint to MDM Senior Data Quality Analyst and Team Leader for corrective action.
• Delivered online customer analyses, such as: Customer Segmentation, record Retention Analysis and Lifetime Value Analysis.
• Experienced in working with oracle ERP systems including SAP Procurement modules
• Experience in analyzing and resolving performance issues with Site core CMS
• Carried out budget preparation, estimation and bids along with producing various proposals, planning and necessary contracts.
• Monitored constantly the externally imposed CCAR Requirements from FED
• Responsible for subcontract negotiations and purchase orders as well as usual contracts with customers.
• Experience in Avaya IVR development, configured and troubleshoot IVR applications, configured voice portal management systems. Prepared wireframe by using Axure.
• Incorporated all the required reports and the relevant data and calculations into EDW.
• Wrote specifications for tasks, activities, and Guidewire Contact Center.
• Developed dashboards, automated reports and report templates using advanced Tableau functions.
• Provided guidance insight on data visualization and tableau dashboard design best practices.
• Extensive knowledge in OTC (Order to cash)with pricing, billing, shipping, and order management, etc
• Promoted Cross Selling Wealth Management Products & Cash Management Products
• Experience in BA tasks like requirement gathering, analysis, scoping, requirement elicitation and documentation
• Prepared Business Requirement Documents (BRD) for Enterprise Risk Case Management (eRCM) functionality of Actimize. Possess excellent experience in RFP/RFI Proposal response.
• Actively involved with training and mentoring new analysts with commercial lending, business process, and quality control.
• Created Oracle SCM document for the first time in the project and circulated among stake holders
• Act as a custodian for all HR Policies and responsible for policy revision, benchmarking and its advocacy at periodic intervals
• Connected tableu to impala using ODBC drivers to run ad-hoc queries
• Provided Report in User Access Management and SOX Audit with Oracle Business intelligence tool.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process.
• Used ILOG to make visualization interfaces (Views) and resources and online trading or credit decision making.
• Used BRMS to define, deploy, execute, monitor and maintain the variety and complexity of decision logic of operational systems.
• Supported the Sell side Fixed Income Research team for a Bulge-Bracket US Bank.
• Extensive knowledge and experience in trading and post-trade processes in the US fixed income markets.
• Experience in wealth management, trading systems, brokerage money movement and/or FDIC insured money market products.
• Analyze business requirements to develop and test Xcelsius/Tableu dashboards, and enterprise reports
• Performed data profiling identified data quality issues and recommended remediation strategies for EDW.

Business Analyst

Confidential, Boston, MA

Responsibilities:

• Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
• Designed Use cases, Use case diagrams to present a better view of the system as a whole to the technical team for them to identify the key processes.
• Created and maintained data model/architecture standards, including master data management (MDM).
• Monitored, measured and reported on HR issues, opportunities and development plans in agreed formats.
• Experienced and versatile with the concepts of Data Modeling / Data Warehousing and RDBMS Concepts.
• Solid Knowledge in Comprehensive Credit Analysis Review (CCAR) regulations and reporting, that focuses on the Retail (FRY 14 M) Schedules and Wholesale (FRY-14Q) Schedules.
• Created groups and roles in Guidewire Claim Center system, activating / deactivating Users in Guidewire Claims system.
• Actively involved in sourcing the data from varied sources into EDW, and profiling the data to meet the requirements of the project at various stages.
• Upgraded Blue Martini ecommerce platform which included defining implementation strategy.
• Solid Knowledge and extensive experience in wealth management and trading systems.
• Reviewed and updated 401(k) enrollment booklets for plan specifications and accuracy. Prepared handouts for client meetings with applicable fund changes.
• Analyzed more complex CCAR issues and provided recommendations to ensure compliance and risk reduction.
• Assisted with the strategic planning and long-term direction of Enterprise Case management solution at the bank
• Strong knowledge of Insurance domain and processes, especially in P&C with the understanding of policy and claims processing.
• Handled inbound and outbound calls for manufacturing plant
• Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Coordinated with various supported internal businesses, users and external market vendors to update inventory based on changes in market data risks services.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process.
• Utilized strong knowledge of data warehousing for data reporting and improving data quality.
• Tuned Actimize CDD models and conducting statistical analysis of data in order to perform system optimization and increase efficiency.
• Identified and resolved problems affecting PDM/PLM applications
• Involved in sales presentations to clients and PLM vendors on the new mobility solutions developed.
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data.
• Solid experience with Data Warehouse development and technologies
• Provided technical advisory service now for multiple options and risks.
• Assisted and maintained the AML Technology and Analytics Manager in achieving AML objectives through the timely completion of projects and initiatives.
• Interacted with line of business managers and coordinated the transition into the security database to assure business compliance with SOX.
• Identified key ITGC Controls for User Access Management, Change Management, Physical and logical security.
• Solid understanding of functional requirements and OMS implementations
• Acted as liaison between the SME's and the technical teams, handled all scheduling, resource planning and allocation matters, ran all status meetings and compiled reports.
• Extracted the data from database and provide data analysis using SQL to the business user based on the requirements.
• Extensively worked on Creating User requirement Specifications (URS), Functional Requirement Specifications (FRS), and Business Process Documents and also developed System Requirements.

Environment: MS Excel, MS Word, MS PowerPoint, Windows XP/ME, PMBOK, BABOK, Quality center, MS SQL Data Base, EDW, JAVA, MS Outlook, SharePoint, HP ALM (QC), HP Quality Center 10.0, Caliber RM, Web Hosting SAP, MS Office, Windows 2000, Windows Vista, MS Visio and IBM Rational DOORS, HP SharePoint, MS Project, and IBM Rational DOORS, SQL, SOA Infra, XML

Sr. Business Analyst/QA

Confidential, Norristown, PA

Responsibilities:

• Gathered Mortgage and online suite requirements from PNC clients and analyzed them
• Worked in ETL environment involving Informatics/Data Stage and Business Intelligence tools like Cognos, Business Objects.
• Performed business systems analysis, gathered requirements. Worked on Client Server environment
• Preparing & Modifying Automation scripts using Win Runner
• Executed the Automation scripts using QC and Win Runner
• Performed Functional, GUI and Security testing of the Web based application
• Performed and supervised reviewing of project documents including functional specification, business requirements and design documents
• Worked on data mapping of source to target elements performing gap analysis Conducted interviews
• Experience in creating prototypes, wireframes, developing use case diagrams, sequence diagrams, state diagrams and activity diagrams.
• Involved in full life cycle of building a Data Warehouse including Dimensional and Fact Table Data Modelling.
• Implemented enhancements and improvements on Fixed Income applications that will enable AXA IM Fixed Income ambitions.
• Experience in making HR Dashboards for the Line of Business
• Worked with non-technical users in understanding their requirements, interpreting them to concrete reports using Tableau.
• Performed ITGC as part of the annual statutory audit for various companies, based across various sectors such as manufacturing, FMCG, retail, financial services, software services.
• Good understanding about how data is stored in OFSAA Database, experience using different OFSAA Allocations types
• Analyzed more complex CCAR issues and provided recommendations to ensure compliance and risk reduction.
• Defined, tested, trained, implemented, and supported multiple functional areas within the oracle ERP system.
• Developed Test Plans, Test Cases and Test Scripts using QA Director.
• Initiated Requirement gathering, analyzing, validating, and authoring use cases using UML
• On HP Coactively involved in developing, executing and managing User Acceptance Testing (UAT).
• Used TSS to process safe secure payments, keep track of all finance billing information.

Environment: Seibel, MS Project, MS Word, MS excel & Share point 2010, Axure, MS Visio and IBM Rational DOORS, Web hosting, Agile Methodology

Business Analyst

Confidential, Shelton, CT

Responsibilities:

• Gathered and analyzed requirements and transformed into Business Requirement Documents (BRD)
• Used ILOG to make visualization interfaces (Views) and resources and online trading or credit decision making.
• Worked in ETL environment involving Informatics/Data Stage and Business Intelligence tools like Cognos, Business Objects.
• Formatting spreadsheets using advanced excel functions to accommodate entire client requirements
• Used BRMS to define, deploy, execute, monitor and maintain the variety and complexity of decision logic of operational systems. Drive through development to production.
• Developed a comprehensive enterprise level web based application to manage end to end quality control process.
• Created Data Requirement documents (DRD) containing data elements list and its explanation.
• Managed Requirements using Application Lifecycle Management.
• Experienced with Oracle e-business suite especially Order to Cash and Financials modules.
• Assist with business analysis in other regulatory reporting for OTC Derivatives to EMIR, CFTC and other jurisdictions including Asia.
• Designed and developed all User stories and UML models using MS Visio and IBM Rational DOORS for structuring / modeling the whole project.
• Created user interface wireframes, prototypes as per business requirements.

Environment: Seibel, MS Project, PL/SQL, MS Word, MS excel & Sharepoint 2010, Axure, MS Visio and IBM Rational DOORS, Web hosting, Agile Methodology.

Business Analyst/QA

Confidential, Williston, VT

Responsibilities:

• Defined and developed business functional requirements and use cases and participated in technical walk-through meetings to develop the functional design for the implementation.
• Conducted JRP sessions with clients and technical units and (JAD) sessions with IT Group.
• Performed Gap analysis for the modules in production and also conducted feasibility study for the performance impact analysis.
• Performed Enterprise Analysis to capture the business process.
• Worked in ETL environment involving Informatics/Data Stage and Business Intelligence tools like Cognos, Business Objects.
• Automated the test scripts for the GUI, functional, performance and regression testing using Win Runner on Windows NT platform.
• Collected test metrics weekly from the Test Director database that reflected the current status of the test execution and the state of the defects.
• Coordinated activities between business unit and technical staff, developing new methods, policies and procedures to meet the business needs and business requirements.
• Provided extensive staff development & training on products, applications, & tools utilized by the department to support clients. Experience in defining the PLM roadmap for any given client.

Environment: PL/SQL, Oracle Forms, C, C++, Visual Basic, Windows NT 4.0, MS Office Suite, MS Visio and IBM Rational DOORS, Load Runner, Win Runner, Oracle, Test Director, XML, HTML, JavaScript, SharePoint 2010