PROFESSIONAL SUMMARY:

• 10 years of IT experience as a Business System Analyst in SDLC: analysis, design, development, deployment, testing, and implementation of projects for various business and finance organizations.
• 5+ years of diversified experience Quality Assurance Testing working in all phases of testing life cycle.
• 3 +years of experience in IT Project Management handing project planning, resource allocation, project governance and stakeholder communication.
• Worked on different SDLC Methodologies including Waterfall, Agile, RUP, Scrum and IDEF.
• Expertise in preparing Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and Manual testing using Rational Test Manager.
• Expertise in Manual Testing and Automated Testing for Web and Client/Server applications on UNIX and Windows Platforms.
• Strong working experience in planning and carrying out of Teradata system upgrade initiatives, Data Warehousing, MPP (Multi parallel processing) and Large - Scale Database Management.
• Good knowledge and understanding of data modeling, data integration, data quality, and data cleansing concepts.
• Hands on experience using Teradata utilities (SQL, BTEQ, FastLoad, MultiLoad, FastExport, etc.)
• Excellent skills in Business Analysis, Data Analysis, GAP Analysis, Financial Data Analysis, Risk Analysis, Requirement Analysis, Business Modeling and Use Case Development using UML methodology.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using MS Visio.
• Good working knowledge of Service Oriented Architecture (SOA) standards-based design approach.
• Good expertise in creating Test Cases on the basis of product features, client requirements and technical documents. Developed, executed and maintained Test Scripts. Reviewed and documented system Test Plans.
• Ability to understand and interpret Entity Relationship Diagrams and document them.
• Proficiency with Rational Enterprise Suite (Requisite Pro, Rational Rose, Clear Case, Clear Quest) in support of the RUP methodology.
• Experience in Financial Industry with exposure to Automated Financial Systems, SWIFT messaging, FX Rates, Risk Analytics, STP Processing, Retail Banking, Treasury Management and Investment Banking
• Understanding of different Money Market Investment Tools including Treasury Bills, Bonds, Notes, CDs, and Commercial Papers.
• Good knowledge of Cash Management and Treasury Management services (Account Reconcilement Services, Positive Pay, ACH, Lockbox, Sweep Accounts, etc.) and tools (Fiserv, CheckFree, Fidelity Systems, etc)
• Understanding of Financial Statements, Options, Fixed Income Securities, Equities, Futures, Cash Flows, Financing Structures, Stock Valuation, Bond Pricing, and Hedge Funds, Derivatives.
• Experience in developing business and functional Requirements, including requirements traceability, categorization, and prioritization.
• Successfully worked on iterative offshore/onshore IT Business Development model.
• Proactive approach to streamline different IT efforts and also worked to set up core IT processes.
• Able to effectively converse, relate and liaise with multifunctional teams, including business owner, stake holders, mangers, architects, developers and testers at all levels.
• Good Interpersonal skills in listening, mentoring, coaching, negotiation, mediation, influencing, and conflict resolution.
• Strong communication, written and presentation skills.

TECHNICAL SKILLS:

Rational Tools: Rational-Rose, Requisite-Pro, Clear-Case, Clear-Quest and Test-Manager.

Data-Modeling Tools: MS Visio, MS Word, MS Project, MS Excel, Enterprise Architect.

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

Business Intelligence: Cognos, Business Objects, Microsoft RS, Adhoc Reports and Crystal Reports.

ETL Tools: Data-Stage, Informatica.

Testing Tools: Win-Runner, Load-Runner, Quality Center, Test Director, Quick Test Professional (QTP)

Operating Systems: UNIX, Solaris, Linux, Windows NT/2000/XP.

Other Tools: SnagIT, TIM/ TAM (Tivoli Identity Manager/ Tivoli Access Manager), Novell, Serengeti Tracker, Ariba Buyer, SAP Accounts Payable, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Project Manager/ Business Systems Analyst/ Data Analyst

Responsibilities:

• Responsible for working on multiple initiatives for Targeted Interactions (TI) including nSegment (Member Segmentation), Campaign Mart, TI Mart, etc. following TI’s Scrum methodology.
• Responsible for supervision of the nSegment project including - creating new nSegment(s), driving new functionalities, reporting, business interactions/ project reporting and error reporting, etc.
• Extensively used Tableau 9.0 to develop, publish, re-design and maintain reports for multiple projects for TI.
• Facilitate stand-up meetings, JAD sessions, weekly status meetings, etc. as a part of multiple projects.
• Responsible for maintaining the customer segmentation log for Sears’ N-segment functionality.
• Facilitated data requirements sessions for data migration efforts and assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica.
• Responsible for creating architecture diagrams, data flow diagrams co-ordinating with the Teradata DBA’s.
• Responsible for creating for data migration strategies for from Oracle to Netezza environment.
• Responsible for performing AS-IS analysis of the Confidential ’s Legal department including policies, procedures, forms, cross dependencies and reports to derive the requirements and process gaps and documenting using MS Visio.
• Responsible for base lining existing business processes and identifying key areas for process improvement/ enhancement and driving a broader awareness of those areas.
• Developed the Business Requirements, Functional Requirements, Technical Design Specifications, Use Case Document, UML diagrams, Traceability Matrix, Minor Design Document (MDD) and Business decks presentations.
• Responsible for preparing the RFP document and contract negotiation with the vendor Serengeti Law.
• Facilitated JAD sessions, Requirement Gathering Workshops with the stakeholders to derive requirements.
• Facilitated agile development scrum stand-up meetings with the security and infrastructure teams.
• Responsible for the complete AS-IS analysis of the Confidential ’s media sales business including domain knowledge, procedures, reports, third parties and data structures to derive the requirements.
• Responsible for creating Datawarehousing artifacts such as - Reporting Dashboard mockups, Mapping document, File Specifications, Source to Target Documents, etc.
• Successfully completed a POC with HADOOP architecture for nSegment project.
• Responsible for gathering requirements for MicroStrategy Reporting platform which includes Canned Reports, Self-Service dashboards and Score Cards.
• Responsible for suggesting architecture best practices, providing deployment support, production support as a part of the project.
• Responsible for providing frequent status reports to the higher management regarding tasks, risks, pending decisions, impediments and release progress.
• Responsible for managing the project from inception to closure creating Project Plans, Project Matrix, Resource Sheets, RACI documents, Communication Plans, Training Plans, etc.
• Responsible for mentoring business analysts, other teams and mentoring (onshore and offshore).
• Responsible for project management activities such as business communication, status meetings, conflict resolution, task allocation prioritization and mentoring.
• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Responsible for resource planning and allocation on the project (including getting approvals on resources, etc.)
• Responsible for overall success of the project including handling change management, stakeholder communication and project risk management.
• Responsible for testing activities such as developing test scope, test plan & strategy, test cases and involved in multiple stages testing.
• Involved in various different testing roll outs such as Functional, Integration, Regression, UAT (User Acceptance Testing), etc.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Working on Query designer to build the reports in the Web intelligence.
• Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.
• Created Multiple Universes in Designer in secure connection as well shared connection.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Created Technical and Design Documents, Test Consideration Documents, Run documents for new Reports and Universes.
• Involved in all he stages of scrum - sprint planning, daily stand ups, sprint review and sprint retrospective.
• Performed project manager responsibilities such as - Project planning, Project Control & Insight, End-to-End Implementation support, etc.
• Responsible for creating, reviewing and implementing nSegments using SQL based on the business requirements.
• Responsible for reviewing the nSegment engine code (SQL/ Unix) for implementation of the system enhancements.
• Created multiple system requirements documents as a part of N-Segment functionality improvement.
• Created
• Responsible for maintaining the product backlog for log for Sears’ N-segment functionality and implementing as per agreed upon terms.
• Extensive worked on Self Service Audience Engine - creating wireframes, system requirements, test documents and user acceptance testing.
• Facilitated data requirements sessions for data migration efforts and assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica.
• Responsible for creating architecture diagrams, data flow diagrams co-ordinating with the Teradata DBA’s.
• Created and modified Teradata BTEQ scripts to load data from different databases to Target database to support MSTR/Tableau Reports.
• Responsible for supporting multiple applications and monitoring/ production support jobs in Control-M application scheduler.
• Worked with Micro Strategy for creating Liquidity and Incrementality Scorecards, Dashboards and Extensive reports

Environment: Teradata (12.X, 13.X, 14.X), IBM DataStage, Parallel Extender 8.1, Unix Shell Scripting, Teradata SQL Assistant, Tableau, Control-M, GitHub Version Control, Visio, Micro Strategy 9.x, Scrum, IceScrum. Fast load, Fast Export, HADOOP

Confidential, Charlotte, NC

Business Systems Analyst/ Jr. Project Manager

Roles and Responsibilities:

• Responsible for the complete AS-IS analysis of the Confidential ’s media sales business including domain knowledge, procedures, reports, third parties and data structures to derive the requirements.
• Responsible for documenting the process flows using MS Visio 2010 with UML specification.
• Responsible for performing GAP analysis on the existing process and suggest improvements as needed.
• Responsible for preparing business decks for project scope verification and facilitating hands-on meeting with higher management to lock-in the scope of the project.
• Responsible for project co-ordination activities such as developing high level project plan, LOE (Level of estimate) document, conducting status meetings and creating resource structure for the project.
• Liaise with higher level management to conduct co-ordinate project implementation & roll outs.
• Responsible for leading the project through matrixed teams to ensure proper delivery of the project.
• Developed the Business Requirements, Reporting Dashboard mockups, Mapping document, File Specifications, Source to Target Documents, etc.
• Responsible for base lining existing business processes and identifying key areas for improvement/ enhancement and driving a broader awareness of those areas.
• Responsible for performing data analysis and creating data structures using SQL.

Environment: TOAD, SQL, Agile, Netezza, Informatica, MS Visio 2010, MicroStrategy, MS Project 2010, MS Excel 2010, MS Word 2010

Confidential, San Rafael, CA

Sr. Business Analyst/ Project Manager

Roles and Responsibilities:

• Responsible for the complete AS-IS analysis of the Confidential ’s Legal department including policies, procedures, forms, cross dependencies and reports to derive the requirements.
• Responsible for documenting the process flows using MS Visio 2010 with UML specification.
• Developed the Business Requirements, Functional Requirements, Use Case Document, Traceability Matrix and Business decks presentations.
• Responsible for performing GAP analysis on the existing process and suggest improvements as needed.
• Responsible for base lining existing business processes and identifying key areas for improvement/ enhancement and driving a broader awareness of those areas.
• Facilitated JAD sessions, requirement gathering workshops with the stakeholders as needed.
• Responsible for managing the project from inception to closure creating Project Plans, Project Matrix, RACI documents, Communication Plans, Training Plans, Resource Sheets, etc.
• Responsible for building project team, managing resource needs based on project requirements, track project deadlines, time, tasks, completions, milestones, and allocation of internal and external resources.
• Provide appropriate and timely written and oral communications with all projectteam members, department managers, andIT management throughout the life of theproject.
• Responsible for overall success of the project including handling change management, stakeholder communication and project risk management.
• Responsible for preparing the RFP document and negotiating the contract with the vendor Serengeti Law.
• Responsible for providing vision (including technical and business vision) and insight of the project with higher management, department heads, stakeholders through monthly meetings, business presentations and process flows to both technical and non-technical parties.
• Responsible for providing direction to the project by conducting project team meetings to gather project status and guidance to the project team members information, track and prioritize tasks, etc.
• Participated in the user stories and sprint planning sessions hosted by security teams.
• Responsible for tracking, resolution and escalation of impediments during sprint planning.
• Responsible for providing frequent status reports to the higher management regarding tasks, risks, pending decisions, impediments and release progress.
• Facilitated agile development scrum stand-up meetings with the security and infrastructure teams.
• Ensure the project health/status metrics and performance indicators are accurate and communicated effectively to the higher management.
• Performed the role of being the primary customer contact between the project team, business partners, stakeholders and higher management. Mediates and resolves project team conflicts.
• Responsible for developing test scope, test plan & strategy, test cases and involved in multiple stages testing.
• Involved in various different testing roll outs such as Regression, Rolling Regression, UAT (User Acceptance Testing), etc.
• Extensively used SAP Business Objects Webi (Web Intelligence) to perform analysis on existing reports, functional dependencies with SAP Accounts Payable, SAP General Ledger (G/L).
• Responsible for creating custom BO universes as a part of the project and performing adhoc queries for reporting purposes.

Environment: Agile, Scrum, MS Visio 2003, SAP Business Objects, Serengeti Tracker, Ariba Buyer, SDLC, SaaS, Cloud Computing, MS Project 2010, MS Excel 2010, MS Word 2010.

Confidential, Charlotte, NC

Sr. Business Analyst & Test Analyst/ Jr. Project Manager

Roles and Responsibilities:

• Understanding of the current Consultant Views and RPPM systems based on the BLC platform supporting products such as IRA’s, SEP IRA’s, Keoghs, 401k, 403b, etc.
• Responsible for communicating with the various teams such as AIS Consultants, Trust Consultants, Technology teams, Stakeholders and Product Owners on a daily basis.
• Responsible for managing project from start to finish and ensure project meets overall defined scope.
• Facilitating review sessions and JAD sessions with the business to substantiate and finalize the BRD.
• Substantiating the Functional Requirements, Business Requirements document Use Case Document, Traceability Matrix and Business decks presentations.
• Extensively used Caliber RM requirement management tool for requirements management.
• Facilitating the sessions with the business to resolve the open issues items (known as parking lot items).
• Responsible for transferring the functional requirements from Caliber RM to HP Quality Center.
• Responsible for creating test cases and performing manual testing.
• Performed manual testing using the test cases for positive and negative testing.
• Responsible for performing QA reviews for test cases and automated test scripts.
• Worked closely with developers for Defect tracking and reporting.
• Responsible for understanding / substantiating data requirements for data migration efforts.
• Assisted the data modeler in ETL efforts such as creating data model, work flow, mapping using Informatica
• Executed queries in SQL as a part of research activities.
• Responsible for determining risk and issues in the requirements and develop mitigation strategies through meetings
• Responsible for creating initial set of mock up screens, UI design and validating with the appropriate folks.
• Responsible for managing the overall scope of the project.
• Performed project management activities such as developing project plans, RACI matrix, mentoring, resource allocation, etc.
• Prepared business presentations for providing, scope, vision and insight of the project across project team members, department heads and stakeholders during the initial phase of the project.
• Responsible for writing the test cases for interfacing systems such as Siebel Call Center CRM, PEGA PRPC, Fund Allocator, etc.

Environment: Agile, Oracle SQL Developer, SQL, Oracle Analytics, Caliber RM, MS Word, Excel, PowerPoint, Oracle, Clarity, XML Spy, Siebel CRM, HP Quality Center, PEGA.

Confidential, Charlotte, NC

Sr. Business Systems Analyst/ Test Analyst/ Jr. Project Manager

Roles and Responsibilities:

• Responsible for analyzing the existing Brokerage site and the vendor tool One StopTM.
• Responsible for requirements elicitation, verification and substantiation of Requirements document from the Project Definition Document.
• Responsible for performing GAP Analysis and Impact Analysis on the existing brokerage site.
• Responsible for overall project coordination including project planning, establishing cross dependencies, providing strategic direction, SLA Agreements, Document/ Deliverable sign-offs, scheduling status meetings, etc.
• Responsible for facilitation of JAD sessions for stakeholders, technology team, managers.
• Responsible for validating the test case scenarios for the project.
• Interacted with various teams on a day-day basis such as core development team, SAML team business team, production delivery team as a part of the project.
• Responsible for providing Subject Matter Expertise (SME) for the current brokerage system to the end users and business team.
• Responsible for analysis of existing applications to provide input for the application decommissioning.
• Responsible for managing risk throughout project.
• Analyzed user requirements and developed test plans, test cases, test scripts to test the Usability and Functionality scenarios.
• Provided adequate supporting information for bottleneck analysis.
• Created online training demos using Oracle UPK toolset.

Environment: ISG RUP, MS Visio 2007, CMMI Level 3, Agile, MS Project 2007, MS Office 2007, MS Visio 2007,MS Outlook 2007, MS SharePoint 2007, Yodlee, DOORS, XML, HP Quality Center.

Confidential, Lowell, MA

Sr. Business Systems Analyst/ Test Analyst

Roles and Responsibilities:

• Responsible for leading the efforts or Business Analysis, Quality Assurance with the on shore/ off-shore teams, business teams based in UK and Ireland.
• Responsible for working on parallel projects including a migration project.
• Responsible for co-ordination among teams location across multiple time zones.
• Responsible for total requirement management (including definition and prioritize of requirements) and communicating it across business and technical teams spread across the globe.
• Responsible for the preparation and presentation of mock screens, story boards, UI design documents based on the business requirements.
• Responsible for creating use case document by coordinating with various teams such as business team, engineering team, designing team, portal team, stakeholders and CE (Client Experience) team.
• Substantiated the Business Requirement document, Functional Requirements documents, Use case document and the Minor Design Document (MDD) to enhance the existing functionality of the system.
• Worked on various financial products including Fixed Income Bonds, Equities, Money Markets, Loans, etc.
• Facilitating the CE (Customer Experience)/ UC (Use Case) review meeting with the core business team, Web development team, Designing team and the Testing team to present the use case and assist design and development.
• Determining and implementing the scenarios of STP (Straight through Processing) in the existing system.
• Substantiation of process workflows, use case diagrams, use case documents and traceability matrix documents.
• Involved in various different testing roll outs such as Regression, Rolling Regression, UAT (User Acceptance Testing), etc.
• Mentoring a team of Business Analysts offshore as part of the project.
• Analyze the data received from various sources such as FTP (File Transfer Protocol), FMS (File Management System) and Legacy database suggest improvements in the process.
• Extensively used PEGA PRPC 5.3 BPM tools and worked closely with team that developed a Work Management Solution.
• Responsible for creating process flows and uploading in PEGA PRPC.
• Responsible for working with the developer to establish business rules, workflows and clarification on requirements in PEGA PRPC.

Environment: Agile, HP Quality Center, MS Visio 2007, Java, TOAD, FTP, MS Project 2003, MS Excel 2003, MS Word 2003, MS SQL Server/ Oracle, MS Outlook 2007, MS SharePoint 2007, PEGA PRPC, Rational Requisite Pro, Novell.

Confidential, Cherry Hill, NJ

Sr. Business Analyst & Test Analyst

Roles and Responsibilities:

• The project followed TD Bank Financial Group’s (TDBFG) Project Management Life Cycle which (PMLC) included all the phases of SDLC. Served as a liaison between the business and technical team.
• Worked as a Business Analyst and a Test Analyst for all the projects within the organization.
• Worked with multiple external vendors such as Fidelity Information System, CheckFree in finalizing the scope of work and performing testing activities throughout the project.
• Organized business meetings and presentations such as Work Break Down sessions, JAD sessions with the business and technology teams lock the scope and requirements for the project.
• Developed a Test Plan for testing the Functional and Non-Functional requirements.
• Worked on all the phases of the testing activities such as System Testing, System Integration Testing, BAT and PAT.
• Responsible for validating the test scripts for batch processing and automated testing.
• Responsible for analysis of the existing ARP/SMS system offered by both the banks establish GAP and system dependencies.
• Substantiated the new training manuals for the enhanced systems highlighting the changes for all user groups.
• Responsible for analysis of existing applications to provide input for the application decommissioning.
• Extensively used PEGA PRPC 5.3 BPM to document process, working closely with the development team.

Environment: TDBFG PMLC, MS Visio 2003, HP Quality Center, Mainframe, SDLC, FTP, MS Project 2003,MS SQL Server/ Oracle, Intralinks, Planview, CheckFree ARP/SMS, Fidelity, IM, ST, CMMI. PEGA

Confidential, New York City, NY

Sr. Business Analyst & Quality Assurance Analyst & Project Coordinator

Responsibilities:

• Involved in successful migration of 9 in-house systems involved in the SSN Conversion Project.
• Coordinated with 15 different New York City agencies and non-city agencies such as IRS and FRB as a part of change control process.
• Performed GAP Analysis and derived requirements to enhance the existing system and improve efficiency.
• Developed a Project Plan for implementing all the requirements, allocating resources and task scheduling for the development of the new system.
• Identify the business workflows and relationships among the PMS screens, PMS reports, OPA’s applications, forms and outside entities to determine and group the changes that need to be coordinated and implemented together based on their interdependence.
• Responsible for analyzing existing data and designing new reports for the management team and other outside agencies.
• Created a thorough Test Plan to test all the functionality and interfacing systems.
• Created functionality Test Cases after establishing critical values and workflow.
• Performed Backend Testing by writing SQL statements to review the returned data to ensure that the correct data was displayed.

Environment: Waterfall, MS Visio 2003, Mainframe, SDLC, FTP, MS Project 2003, MS Excel 2003, MS Word 2003, MS SQL Server/ Oracle, Intralinks, Planview.

Confidential, St Louis, MO

Business Analyst/ Test Analyst

Responsibilities:

• Worked with the mainframe team, FC’s, stakeholders and management team in gathering various requirements for the project.
• Gathered and documents the requirements using Rational Requisite Pro.
• Discussed these requirements with other members of the team like the DBA, Project Manager, Application developers and the FC’s.
• Performed project management activities such as task scheduling, resource allocation and developing charts.
• Designed detailed logical class diagrams, activity diagrams and other high level process flows.
• Facilitated JAD (Joint Application Development) sessions with the management team, stakeholders, FC’s and mainframe team.
• Performed high level security data risk analysis, GAP Analysis among different applications, incorporated these gaps into models and documents.
• Worked with the mainframe team, caliper application developer and other members of the project team to develop a test base, plan and then create test cases, test scripts and documented them using Test manager.
• Worked with application developers to create a test strategy to implement various phases of testing like Unit testing, volume testing and Integration testing.

Environment: Requisite-Pro, Six, Sigma, Rational Unified Process (RUP), Primavera Team Play, MS Visio, MS Word, MS Excel, Test Manager, Java, Windows NT/2000, F-Secure Client, MS SQL Server, Unix.

Confidential

Business Analyst

Responsibilities:

• Worked with the business team to collect the business requirements, security and service level requirements and documented them using Requisite-Pro.
• Co-authored business requirements document with project teams. Extracted, discussed and refined business requirements from business users and team members.
• Co-authored functional requirements documents by interacting with the development personnel.
• Assist with data conversion activities and all levels of testing (functional, system, regression, and integration) as necessary.
• Assisted the Project Manager in many project management activities such as - Project Planning, Budgeting, Scheduling and Costing. Used Microsoft Project extensively as a part of these activities.
• Conducted user interviews, gathered requirements, and analyzed the requirements using Visio, Requisite-Pro.
• Used the different types of views in Requisite Pro e.g. Attribute matrix, to display requirements of a specified type.
• Documented test cases during requirements gathering, analysis and design phases and loaded them into Test Manager

Environment: Rational Rose, Requisite-Pro, SQL Server, MS Project, MS Visio, MS Word, MS Excel, Test Manager, Microsoft Reporting Services, Java, Windows NT/2000.