SUMMARY:

• Around 15 years+ of experience in Business System Analysis, S/W Development, Project Management, Requirements analysis and elicitation, Requirements documentation and review, UAT documents creation and validations, and support to testing teams.
• Functional domain experience involves Treasury - Capital Market, Mortgage, Branded and Partnership Credit Card, Healthcare, and Financial/Banking Institutions.
• Proficient in creating documents like Business requirements document (BRD) and Software Requirements Specifications (SRS), ETL Mapping document and User Stories.
• Good in providing process improvement tools / mechanisms at various project levels.
• Excellent ability to multi-task and managing multiple projects concurrently by using exceptionally strong management and organizational skills with the ability to work under pressure and meet all critical deadlines.
• Experienced in coordinating resources; setting deadlines; assigning responsibilities; and monitoring, summarizing and communicating the progress of the project.
• Acted as Product Owner in his absence and worked with stakeholders to manage product expectations and product delivery timeline. Coordinated key functional delivery to coincide with the stakeholder’s calendar. Planned, designed and scheduled new application functions for development while managing scope creep.
• Strong experience in creating Mock up screens using Axure, Balsamiq
• Excellent expertise in writing Test Strategy, Test Plans, Test Cases, Test Scenarios and supporting execution for Testing, (Integration, Functional/Non Functional, Black Box, and User Acceptance).
• Experienced in performing User acceptance testing, Functional Testing, Integration testing and validations.
• Worked on software development Models like Waterfall model, Agile-Scrum, and RUP.
• Conduct data mapping sessions with team members and stakeholders.
• Excellent analytical, problem solving, communication and interpersonal skills, also solve possible issues throughout SDLC.
• Good skills in using UML methodology - Process Diagram, Workflow Diagram, Use case Diagrams, Activity Diagrams and ETL technology, Conducting Gap Analysis.
• Successfully worked on iterative offshore/onshore IT Business Development model.
• PM Tools like MS Project for scheduling and Plainview.
• Monitor and control risk register & Issues log. Conduct regular status review meetings, risk audits, project performance reviews, forecasts and EVM (Earned Value method)
• Manage approved & rejected change requests, approved corrective actions, preventive actions and defect repair.
• Expertise in Agile Delivery, Scrum planning, stand-ups, retrospectives and reviews

TECHNICAL SKILLS:

Programming Languages: SQL, Transact SQL, PL/SQL, C, C++, COBOL, Visual Basic 6.0, HTML 4.0, XML, JAVA, .NET framework 3.0, C#, ASP.NET., Spark, Python, SAS

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Hue, Hive, Pig

Cloud Platform: Amazon WebServices

Database Systems: SQL Server, Oracle, DB2, MySQL, MS Access 2003/2000, Teradata, Redshift

Modeling Tools: MS Visio, Rational Rose

Process Tools: Rational Rose Suite, RUP, MS Office Suite, MS Project, MS Visio, MS Share Point, SASV9.0, Version One, XML Spy, Pivot Tables, SSIS, Requisite Pro, Confluence

Reporting Tools: Crystal Reports, Cognosv8.0., SSRS, Tableau

Operating System: Windows NT 4.0/98/2000, XP, UNIX

Version Control System Tools: Harvest, Rational Clear Case, Subversion, GitHub

Testing Tools: Rational Enterprise Suite, QTP V9.5, Win Runner V9.2, Load Runner, HP Quality center 10.0, Clear Quest, ALM

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Lead System Analyst/Scrum Master

Responsibilities:

• Lead analysis effort to gather, formulate, define and design solutions to the business problems. Formulated and defined system scope and objectives based on user needs.
• Worked on various Credit Card Projects both in Branded and Partnership LOB by writing BR, SR, design document (ETL transformation) for ALM Strategy Business Customer.
• Facilitate JAD sessions to gather more details on the intent and requirement.
• Conduct data mapping session with team members and stakeholders.
• Facilitate Scrum ceremonies including Standups, Retrospective, and Sprint Planning.
• Build relationships with Users, Product owners and stakeholders to understand their business areas and help to develop product roadmaps and strategies that will add additional value to the organization as a whole.
• Acted as Product Owner in his absence and worked with stakeholders to manage product expectations and product delivery timeline. Coordinated key functional delivery to coincide with the stakeholder’s calendar. Planned, designed and scheduled new application functions for development while managing scope creep.
• Worked with the stakeholders and UI consultants to meet strict user interface guidelines.
• Lead team of 5 System Analysts.
• Working with Subject matter experts to gather information for System requirements for incoming feeds from First Data, HSBC-WHIRL and TSYS, US and UK Card interfaces.
• Run RedShift SQL queries and perform data analysis to answer business requests.
• Browse through system when required for analysis on data and field info requirements.
• End to end experience in designing data visualizations and preparing Dashboards using Tableau.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Written scripts in Python to automate data load and report generations.
• Performed Gap Analysis and provided solutions.
• Provided Training to users and team members on the process.
• Performed process reengineer to consume the data using AWS and Scala instead of Ab initio.
• Performed QRM data analytics and supported business in building IRR/FTP/GFFI Models.
• Worked closely with Product Owner for writing User Stories and Acceptance Criteria in Version One.
• Report defects using ALM to track the defects.
• Worked on many high profile projects: TSYS, JUSTICE, Lord and Taylor, First Data to WHIRL Conversion project, HBC to WHIRL Conversion, Personal Loans, Cabela’s Integration, performing the gap analysis, source-to-source data validation, writing user stories and system requirements for small enhancements to big projects.
• Good understanding of Big Data, HIVE, PIG, MapR, HBase.

Environment: QRM Balance Sheet Management, Transaction Data Mart (QRM TDM), MS Visio, MS office, Quality center, Share Point, SQL 2008, Agile-Scrum, Version One, ATDD Cucumber with Ruby Mine, Python, R, AWS S3, Redshift, Tableau, SSIS.

Confidential, Richmond, VA

Lead System Analyst/Scrum Master

Responsibilities:

• HRS System Analyst role with emphasis on (but not limited to) business system analysis, design, writing business and system requirements to support business group to meet their goals.
• Facilitate JAD sessions to gather more details on the intent and requirement.
• Lead analysis effort to gather, formulate, define and design solutions to the business problems. Formulated and defined system scope and objectives based on user needs.
• Created Mockup Screens using Balsamiq.
• Worked with the stakeholders and UI consultants to meet strict user interface guidelines.
• Build relationships with Users, Product owners and stakeholders to understand their business areas and help to develop product roadmaps and strategies that will add additional value to the organization as a whole.
• Acted as Product Owner in his absence and worked with stakeholders to manage product expectations and product delivery timeline. Coordinated key functional delivery to coincide with the stakeholder’s calendar. Planned, designed and scheduled new application functions for development while managing scope creep.
• Worked on GA SHBP and Mercer Project by writing BR, SR, design document.
• Working with Subject matter experts to gather information for System requirements for incoming feeds from various interfaces.
• Run SQL queries and perform data analysis to answer business requests.
• Browse through HRS system when required for analysis on data and field info requirements.
• Performed Gap Analysis and provided solutions.
• Performed UAT testing and report defects to the testing team and use Clear Quest to track the defects.
• Worked with cross functional teams like Quality Assurance, Solutions Engineering, Performance Management and Integrated Production Support for timely project delivery.
• Facilitate Scrum ceremonies including Standups, Retrospective, and Sprint Planning.
• Worked closely with Product Owner for writing User Stories and Acceptance Criteria.
• Performed budget estimation and tracking with resource management.
• Created development plans and provided direction to development lead for technical design documentations. Facilitated design reviews with integrated project teams.
• Oversaw quality services lead to understand testing scenarios and test cases.

Environment: Healthy Return System, MS Visio, MS office, Clear Quest, Share Point, SQL 2008, JAVA, SSIS, SSRS, Requisite Pro

Confidential, Richmond, VA

Technical Business System Analyst III/Scrum Master

Responsibilities:

• Lead analysis effort to gather, formulate, define and design solutions to the business problems. Formulated and defined system scope and objectives based on user needs.
• Worked on developing ALM framework (All LIBOR Commercial, Mortgage and Credit Card Hedging) by writing BR, SR, design document (ETL transformation) for ALM Strategy Business Customer.
• Facilitate JAD sessions to gather more details on the intent and requirement.
• Working with Subject matter experts to gather information for System requirements for incoming feeds from Mortgage (LPS/MSP), TSYS, UK Card and US Auto Finance interfaces.
• Run SQL queries and perform data analysis to answer business requests.
• Browse through QRM system when required for analysis on data and field info requirements.
• Facilitate Scrum ceremonies including Standups, Retrospective, and Sprint Planning.
• Write User Stories and Acceptance Criteria.
• Acted as Product Owner in his absence and worked with stakeholders to manage product expectations and product delivery timeline. Coordinated key functional delivery to coincide with the stakeholder’s calendar. Planned, designed and scheduled new application functions for development while managing scope creep.
• Create Prepayment report, Hedging Report, Note Modification Report using ETL Data.
• Performed Gap Analysis and provided solutions.
• End to end experience in designing data visualizations and preparing Dashboards using Tableau.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Report defects to the testing team and use Quality center to track the defects.
• Worked on many high profile projects, INGD Integration, INGD Mortgage Conversion, and Libor and Credit card project, performing the gap analysis, source-to-source data validation, writing user stories and system requirements.

Environment: QRM Balance Sheet Management, Mortgage Banking, Transaction Data Mart (QRM TDM), MS Visio, MS office, Quality center, Share Point, SQL Server 2008, Agile-Scrum, Version One, Tableau, SSIS.

Confidential, Richmond, VA

Technical System Analyst Lead

Responsibilities:

• Collect, interpret, and distill customers’ business requirements into clear specifications and other product/application development artifacts using tools like Rational Requisite Pro and create Business Process model, Use cases using MS Visio and customized ETL mapping doc template.
• Lead team of developers and Testers.
• Coordinate internally with technical development team, designers, and architect, to translate business requirements into product/application features and functions.
• Played a key role in the planning, testing, and implementing system enhancements
• Conducted JAD sessions with the various teams involved in the application development to quickly arrive at solutions for the issues in the design.
• Run SQL queries and analyze the data to close CAT defects.
• Analyze the current system components like MEDB database, STMP, Digital Docs, Elynx and MLCS and help the testing team in validations when required.
• Design of SSIS and SSRS packages (Business Intelligence tools).
• Code SSIS and SSRS packages.
• Analyze test data to verify that testing accurately measures the system capabilities against the baseline requirements.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents.
• Documentation of the requirements using the ETL mapping doc template, Business requirements document template.
• Write User acceptance testing documents for the mapping requirements.
• Validate the XML file based on the XSD and involved in preparing Test cases to meet client Requirements.
• Support QA resources in providing necessary details and to come up with critical testing scenarios. Also assisted in performing high level QA Activities and closing defects.
• Coordinated Systems Integration between various System testing Groups
• Report defects to the testing team and use Quality center to track the defects.
• Performed Process Reengineering to consume data from various sources.

Environment: MEDB, MLCS, STM Partners, Digital Docs, Filenet, Courien, MS Visio, Rational Requisite Pro, XML, MS office, Quality center, SharePoint, SQL 2008, SSIS, SSRS.

Confidential, Richmond, VA

Technical System Analyst Lead

Responsibilities:

• Working with the RPMS system Subject matter experts to gather the system and ETL mapping requirements.
• Maintain the business requirements and system requirements using tools such as Rational Requisite Pro, Share Point and MS Visio.
• Established a standard process for requirement gathering and created a customized ETL mapping template to document requirements.
• The data from 23 different Source systems consists of Deposits, Compass, CPCS, ATM, Teller etc.
• Developed and Modified Sharepoint User Privileges to meet the standard process.
• Documentation of the requirements using the ETL mapping doc template, Business requirements document template.
• Performed Process Reengineering to consume data from various sources.
• Create Business Process model, Use cases using MS Visio.
• Write User acceptance testing documents for the mapping requirements.
• After implementation of the mapping requirements in ETL Ab initio, support during Functional integration testing to analyze and close defects.
• Perform User acceptance testing during UAT phase of the project.
• Report defects to the testing team and use Quality center to track the defects.

Environment: MS Visio, Rational Requisite Pro, MS office, Quality center, VSS, DB2, Cognos 8.0, Ab initio.

Confidential, Richmond, VA

Technical System Lead

Responsibilities:

• Documentation of the key components of the application with process flow diagrams.
• Working with the MSP Subject matter experts to gather the system and ETL mapping requirements using a customized ETL mapping doc template and BSR template.
• Analyze the MSP data available in Passport and Mortgage data available in BDE database to arrive at data fields require for the E Mason Clarifire team in default loans processing.
• Coordinate internally with technical development team, designers, and architect, to translate business requirements into application features and functions.
• Run Passport queries and analyze the data to close CAT defects.
• Browse through MSP system when required for data analysis and field info requirements.
• Use the MSP Navigator tool for finding info on MSP fields and their usages.
• Analyze the current system components like BDE database, MSP, Passport, Navigator tools for validations when required.
• Write User acceptance testing documents for the mapping requirements.
• Support during Functional integration testing to close defects.
• Report defects to the testing team and use Quality center to track the defects.

Environment: MSP, Navigator, Passport, MS Visio, Rational Requisite Pro, MS office, Quality center, VSS, Oracle 9i

Confidential, Atlanta, GA

Technical Lead

Responsibilities:

• High level System analysis and understanding of the Supply Chain Finance Program system functionalities.
• Working with the Supply Chain Finance Program Subject matter experts to understand business and system requirements.
• Good understanding of SOA during analysis phase.
• Performed Process Reengineering to develop a new interface with new technology.
• Created Mockup Screens using Axure
• Creation of Detailed Design Document and develop Code based on Design Document.
• Document and track the queries raised and closed in a query tracker for future references.
• Created Data Flow Modeling and Entity Behavior Modeling Diagrams.
• Support during Functional integration testing to analyze and close defects.
• Provided training to various users and team members.

Environment: MS Visio, Rational Requisite Pro, MS office, Quality center, Harvest, SQL 2005, C#

Confidential, Richmond, VA

Technical System Analyst Lead

Responsibilities:

• Working with the Business folks and Subject matter experts to gather system enhancements requirements
• Act as a liaison between business folks and Vendor to clarify their queries.
• Document and track the queries raised and closed in a query tracker for future references.
• System analysis and understanding of the system functionalities.
• Created Mockup Screens using Balsamiq
• Lead role in gathering the requirements and coordinating with the offshore team to document it appropriately
• Analyze the current STMP system components and help the testing team in validations when required.
• Create Business Process model, Use cases using MS Visio.
• Acted as a Knowledge base during development of the request for any queries on the existing STMP system functionalities.
• Helped the project manager with the effort estimate required for the documentation and came up with a plan with appropriate milestones to compete the project as per schedule.

Environment: MS Visio, MS office, XML, XSD, Quality center, FileNet, VSS, SQL 2000, C#, EMPOWER, MSP

Confidential, Atlanta, GA

Technical Lead

Responsibilities:

• Working with the Business Analyst and Subject matter experts to understand system enhancement requirements
• Create a detailed effort estimate for the changes required to the existing functionality of the application.
• Creation of Detailed Design Document.
• Created Mockup Screens using Balsamiq
• Create Business Process model, Use cases using MS Visio.
• Develop Code based on Design Document.
• Write Unit testing documents for the requirements.
• Experience in configuration management by using Visual source safe for managing requirements and other documents

Environment: MS Visio, MS office, Quality center, VSS, SQL 2000, C#

Confidential, Franklin Lakes, NJ

Technical Analyst

Responsibilities:

• Provide IT project and application support for sales and marketing teams
• Assist in the development of CRM application from a customer perspective
• Develop and maintain configuration and functional design documentation
• Develop test cases, execute testing and coordinate testing with business representative
• Ability to perform all tasks within the software development lifecycle.
• Performed tasks such as requirements, functional specification and other client documentation.
• Coordinate System Integration Testing (SIT), User Acceptance Testing, and associated activities such as test plan, test cases and test execution as related to marketing campaigns and reporting.
• Coordinate Change Management initiatives.
• Coordinate Issue Management events from identification through resolution.
• Worked with Business User to develop complex queries and reporting to assess the viability of marketing programs using SAS base code, SAS Business Intelligence, SAS Marketing Automation, SQL and other reporting tools.