SUMMARY:

• 14 Years of proven track record as value - adding professional with hands-on expertise spanning in System Analysis, Architecting Financial applications, Data warehousing, Data Migrations, Data Processing, ERP applications, SOX Implementation and Process Compliance Projects in Capital Markets
• Accomplishments in analysis of large-scale business systems, Project Charters, Business Requirement Documents, Business Overview Documents, Authoring Narrative Use Cases, Functional Specifications, and Technical Specifications, data warehousing, reporting and testing plans.
• Expertise in creating UML based Modelling views like Activity/ Use Case/Data Flow/Business Flow /Navigational Flow/Wire Frame diagrams, System Context diagrams(SCD) using Rational Products & MS Visio.
• Proficient as long time liaison between business and technology with competence in Full Life Cycle of System (SDLC) development with Waterfall, Agile, RUP methodology, IT Auditing and SOX Concepts as well as broad cross-functional experiences leveraging multiple frameworks.
• Experience in Data Analysis, Feed Analysis, Data Mapping, Data Modeling, Data Reconciliation, Data Entity Relationship Diagram, Normalization and strong understanding of Relational DBMS.
• Extensive experience in analyzing and documenting business requirements and system functional specifications including use cases.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good understanding of Data Modeling with Star and SnowFlake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good experience working with ETL analyzing BI reports, a good understanding of BI life cycle
• Thorough knowledge of SDLC 2.03and its integration with QA methodology and Test Methodologies like Waterfall, AGILE (Scrum). Familiarity with the following frameworks: TMMi, CMMi, ITIL, PMI
• Experienced with Object Oriented Analysis and Design using UML, Rational Unified Process(RUP), Rational Rose, Requisite Pro, Rational ClearCase and Visio.
• Well versed with QA Methodologies. Prepared and documented Test Plans, Test Strategy, Test Summary Report, Test Cases and Test Scenarios for both Manual and Automated testing

TECHNICAL SKILLS:

• Microsoft Windows 2000/XP/NT 4.0
• UNIX
• Linux
• Ab Initio
• Autosys
• Control M
• APPLIX
• Informatica
• Test Manager
• WebSphere
• MS Office Suite
• Microsoft Access 2000
• Win SCP
• Rapid FTP
• PuTTY
• MS Project
• MS Visio
• Shell Scripting
• C
• C++
• Teradata
• Java
• SQL
• StarTeam
• ILOG
• Oracle 11g
• XML
• SOAP UI
• XSD
• XSLT
• COGNOS
• SAP Business Objects
• SAP ABAP
• Load Runner
• Confidential ALM QC 11.0
• JIRA
• Confluence
• QTP
• DOORS
• Requisite Pro
• Clearquest
• SDLC 2.03
• PVCS
• MS SQLServer 2000/2005
• TOAD
• AQT
• DBVisualiser

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr Business Analyst

Responsibilities:

• Conduct GAP analysis for the replacement of Book Bond Model with the TBM(Tax Bond Model) in the Corporate Tax Space
• Validate the data of various DCUs for Excess Yield Variance and resecuritization and giving go ahead to operational team to continue processing for Tax analysts by developing SQL queries
• Run OMAS adjustments in the JEMS(Journal Entry Management system)
• Prepare beginning balance and data for the Tax SF REO and Non REO loans
• Run various EUCs like HSA(Home Saver Advance) process, Excess MI and documented the procedure for the junior team members
• Interact with Subject Matter Experts (SMEs) and stakeholders to get a better understanding of client business processes
• Work with various upstream and downstream interface teams to keep them in loop for various tech mandate(TAXBUS) and other impacting projects
• Work on FUSE, LAI conversion initiatives for TAX and LOANS
• Participate in meetings to update senior management

Environment: UNIX, Windows NT/XP, MS Office, MS Visio, Confidential ALM, Oracle 11g, ToAD, DBVisualiser, Rapid FTP, COGNOS, PuTTy, Crystal Reports

Confidential, Eagan, MN

Business System Analyst

Responsibilities:

• Conduct GAP analysis of the different reports that are being presented to clients to accommodate their requirements
• Validate the data of reports by developing SQL queries in SQL Developer against Data Mart tables and ODS.
• Participated in Backlog grooming, Sprint planning, Daily standup, Sprint Demo, Retrospective meetings
• Evaluate processes and ongoing support structures to guarantee future reusability and overall structure efficiency
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Documented data quality and traceability documents for each source interface.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Work with internal architects in the development of current and target state data architectures
• Work with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Use data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW)
• Responsible for giving Test Estimation/LOE and making sure SLAs are met
• Provide Project Manager project’s testing milestones, task level estimates, assumptions, and risks
• Evaluate processes and on-going support structures to enable reuse and efficiency.
• Create daily and weekly defect tracking report (HPQC 10.0), play key role in daily defects triage with Business and development.
• Attended project meetings, release meetings, and status meetings.
• Provide leadership and work guidance to less experienced personnel.
• Identify project risks and mitigation activities for resolution meeting technical and business needs.
• Actively participate in Program & Delivery Management process improvements.

Environment: UNIX, Windows NT/XP, MS Office, MS Project, Quality Center 11.0, Oracle 11g, DBVisualiser, Rapid FTP, COGNOS, PuTTy

Confidential, Naperville, IL

System Analyst

Responsibilities:

• Analyzed the business and wrote Business Rules Document.
• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.
• Used MS Visio for Context diagrams, business flow diagrams and defined the workflows.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Participated in Designing and development of the application.
• Used user stories approach for describing the requirements using the user story template.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design system.
• Created Use Case specifications, business flow diagrams and sequence diagrams to facilitate the developers and other stakeholders to understand the business process according to their perspective with possible alternate scenarios.
• Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development confines to the business requirement.
• Performed data mapping from source to target.
• Extensively used SQL for accessing and manipulating database systems
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Created Use Case Diagrams using UML to define the Functional requirements of the application.
• Performed Acceptance Testing (UAT), Unit Testing and Documenting.
• Attended project meetings, release meetings, and status meetings.
• Evaluate work products to assess quality and reports findings. Research alternative solutions to problems, determine proper approaches, make verbal and/or written recommendations to appropriate parties and implement solutions. Implement recommendations as approved.
• Define and maintain an effective and efficient quality programs including developing and presenting associated training and familiarization to affected staff. Revise standard practices and procedures as appropriate.
• Participate in special projects, external audits and process improvements in support of quality assurance initiatives.
• Provide leadership and work guidance to less experienced personnel.

Environment: UNIX, Windows NT/XP, MS Office, MS Project, Quality Center 11.0, Oracle 11g, DBVisualiser, Rapid FTP, COGNOS, PuTTy

Confidential, Woonsocket, RI

Business System Analyst

Responsibilities:

• Reviewed QA Test plans, Test Strategy documents for ETL testing
• Gathered and documented Use Cases, Business Rules, created and maintained Requirements/Test Traceability Matrices.
• Helped in the development of Data flow diagrams
• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users
• Drive to complete project testing through by formal test planning, use of quality assurance tools, templates, and procedures.
• Accountable for testing software products, facilitating defect resolution, and researching customer issues related to software functionality.
• Test and investigate issues to determine the appropriate resolution. Provide educational information to customer issues if the problem is issue related.
• Work with the QA Organization to create documentation.
• Track issues to assist in trend analysis and the updating of the user guides and standard operating procedures.
• Serve as a coach and mentor to the department staff regarding how to develop and execute a test plan.
• Serve as a process improvement leader for the QA department.
• Responsible for identifying areas for improvements, implementing process improvements and ensuring long term compliance. Act as the lead in managing QA participation.
• Set policies, standards and procedures for cross-teams system development life cycle, workflow and the interfaces with QA.
• Partner with team to prepare comprehensive QA project plan, estimates as well as the implementation for phases of projects.
• Monitor the schedule of testing phases for all projects based on project specifications, scope, and coverage.
• Participate in the logical and physical design sessions to review design documents and data models
• Work with the client architecture team in defining tools, processes and technologies to be leveraged on the datawarehouse.

Environment: UNIX, Windows NT/XP, MS Office Tools, MS Project,, Quality Center 11.0, Oracle 11g, DBVisualiser, RapidSQL, TOAD, Rapid FTP, Informatica, SAP Business Objects, PuTTy

Confidential, Tampa, FL

Business Analyst

Responsibilities:

• Analyzed business rules and practices in the area of AML, KYC and CDD
• Gained familiarity with various international AML and terrorist financing combating laws like Bank Secrecy Act, Patriot Act, International Money Laundering Abatement and Anti-Terrorist Financing Act, UK Proceeds of Crime Act 2002, Third European Money Laundering Directive, FATF’s 40 plus 9 regulations
• Gathered requirements for KYC Risk Assessments( Rule based and Algorithm based), Risk parameters, Risk scores
• Participated in the brainstorming sessions to gather requirements with various stakeholders in the area of KYC and Enterprise case management to assess various cases and manage KYC assessments.
• Worked onWorkflow of Financial Crime and Compliance Management in OFC.
• Major Interface between the business line, operations, and the technical areas throughout the project cycle
• Providing End-user Training and documentation for customer reporting services.
• Worked on exporting reports in Excel and exporting of KYC batches
• Worked with Technical Experts to Improve Report Performance and performed acceptance testing.
• Evaluated processes and on-going support structures to enable reuse and efficiency.
• Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
• Attended project meetings, release meetings, and defect status meetings.
• Facilitated release readiness CCB meetings with various stakeholders to ensure best practices were utilized for efficiency and auditability.
• Prepared all the artifacts as per SDLC 2.03
• Led offshore team of 7 persons

Environment: UNIX, Windows NT/XP, MS Office Tools, MS Project,, Quality Center 10.0, Oracle 11g, IBM AttachMate, reflection, File aid, OFS KYC, AML

Confidential, Herndon, VA

System Analyst

Responsibilities:

• Analyzed business rules and practices in the area of Customer Information applications.
• Lead the efforts of the client architecture team in defining the Business Intelligence / DataWarehouse end-to-end architecture.
• Managed a data team of four to fulfill data request from different work streams, data reconciliation, data validation, data quality and data analysis
• Gathered detailed business and data requirements and created upstream/downstream data requirements documents
• Participated to resolve upstream and downstream data issues and accelerated the process for critical data issues using Rational Clear Quest
• Major Interface between the business line, operations, and the technical areas throughout the project cycle
• Helped to develop QA Test plans
• Provided data expertise during pre-execution phase and designed complicated data manipulation processes using vivid process flow diagrams in MS-Visio
• Regularly use sophisticated SQL code to retrieve data from the ORACLE database
• Responsible for giving Business LOE and making sure SLAs are met
• Participated in the logical and physical design sessions and developed design documents and data models
• Assisted in colleting historical prices of Confidential issued Mortgage Based Securities (MBS)
• Worked with the client architecture team in defining tools, processes and technologies to be leveraged on the datawarehouse.
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart and reporting needs to the end user community.
• Evaluated processes and on-going support structures to enable reuse and efficiency.
• Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
• Generating High Level Architecture, High Level Design, ETL Mapping, OLAP Reporting and Process Flow diagram documents
• Created UAT test plan, Oversee users during UAT, Oversee migration to production.
• Report to the business owners the current status of the testing. Discussed the high priority issues and escalate them accordingly.
• Used Rational Clear Quest to log and track defects.
• Attended project meetings, release meetings, and status meetings.
• Prepared all the artifacts as per SDLC 2.03( RTM, UAT test plan etc)
• Responsible for training junior team members

Environment: UNIX, Windows NT/XP, MS Office Tools, MS Project, Quality Center 10.0, Oracle 11g, DBVisualiser, RapidSQL, TOAD, Rapid FTP, Rational ClearQuest, Ab Initio, SAP Business Objects, Crystal reports, PuTTy, Autosys, Kalido DIW, Warehouse Manager

Confidential, Plano TX

System Analyst/ UAT Lead

Responsibilities:

• Designed and implemented basic SQL queries for report and data validation requirements.
• Took part in the preparation of Project plan, user acceptance testing.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Took part in the meetings with BA team and managers and understood various process plans, business process, and functionality in detail. This helped me to prepare Integration Test Plan which was used by functional team as well as development team for doing a detailed testing on the business application.
• Worked on various workflow management tools like NOtA CP( Circuit Provisioning), NOtA UKIMEA and NOtA OM.
• Tetsed various Order Management Canned reports for verification of data integrity, performance and troubleshooting
• Analyzed and helped in modifying the use cases using MSVisio and created the Test cases based on them.
• Worked on conversion of manual integration tests into automated tests using QTP
• Worked on VBA/Macros in MS excel to generate user defined functions
• Executed tests and participated actively in system testing and regression testing.
• Developed and maintained automated test scripts to support regression testing.
• Used the Quality Center as a repository for all of the testing efforts.
• Ensured the application delivered is meeting the criteria set up by stakeholders and is functioning as per the user requirements
• Used Quality Center/ Clear quest for the defect reporting and tracking
• Attended and hosted project meetings, release meetings, and QA status meetings
• Presented various defect metrics to management in weekly status meetings
• Worked as Quality Center Administrator(Project Customization, Defining Releases and Cycles, User management, Triggering Alerts, Dashboard)
• Uploaded test cases from Excel to Quality Center by installing Excel Add in.
• Worked on Business objects to create and test various user and canned reports in crystal reports format.
• Instrumental in both leading and taking initiative in testing activities, gotexcellent feedback from both the management and users equally.

Environment: Windows NT/XP, Confidential QTP 9.2, Test Director, Confidential Quality Center 9.2, UNIX, Java, J2EE, Ab Initio, SQL Server 2005(SSIS, SSRS, SSAS), MS Visio, MS Project, IBM Web sphere studio 5.1.1, crystal enterprise server 9.0/10.0, Borland StarTeam,Caliber, Rational ClearQuest, Business Objects

Confidential, Savannah, GA

SystemsEngineer/ Lead

Responsibilities:

• Analyzed the user/business requirements, functional specs and Use Case System documents to write the test plan for UAT
• Prepared user training manuals and successfully conducted user training sessions.
• Lead the defect review boards. Assigned priorities to the defects based on business intent. Give ETA’s to Dev Leads and different vendors. Worked with dev Leads to resolve issues.
• Worked with development team, release management team, and environment to plan deployment of new builds that contains new functionalities and code fixes.
• Did POS, CARE, WNP( wireless number portability) testing.
• Done ETL(Ab Initio) testing by comparing the source and destination data and other checkpoints involved in Datwarehouse testing
• Worked on VBA/Macros in MS excel to generate user defined functions
• Tested POS system as per PCI compliance
• Developed test strategy for UAT and made sure that the user acceptance testing is thoroughly done as per the user needs.
• Used Confidential QC to create RTM, test cases, scripts and different reports to track the progress for the upper management and for the audit purposes.
• Coordinated with the production support team to set up different environments for system, UAT and regression testing
• Hosted the test approach walkthroughs for new functionality and made test sets, written test cases after the tollgate review
• Manually tested functional test cases in Quality center.
• Used Test Director/Quality center to log and track defects.
• Written complicated SQL Queries manually for validation of data and automated them by using wrapper shell scripts and HTML.
• Used Quality Center to create and maintain the Test cases and the Test scripts for both System Testing and Regression Testing.
• Worked with Business Objects to run and to test various crystal reports for the data validation with the backend database
• Manually written SQL queries to test the back end data base.
• Attended UTR walkthroughs with development to review the results of Unit testing.
• Used StarTeam and APPLIX to track various CRs
• Run Daily, Cycle and monthly bill runs with scheduler
• Done extract testing and ER/CR testing.
• Good experience working in Web Services Architecture, Application Server Technology and Security Access Controls
• Trained users on Confidential QC 9.2, resolved any QC related issues in timely fashion, Created and supported users and integrated QC with QTP.

Environment: UNIX, Windows NT/XP, MS Office, MS Project, Confidential QTP, LoadRunner, Confidential QC 9.2, Test Director 8.0, SSRS, JavaScript, WebServices, XML, HTML, DBVisualiser, TOAD, Business Objects, DOORS, JMeter, Requisite Pro, Rational ClearCase, Rational ClearQuest, Test Manager, Ab Initio, Rapid FTP, PuTTy

Confidential, Herndon, VA

Functional Lead

Responsibilities:

• Prepared the user/business requirements, functional specs and Use Case System documents
• Gathered financial and trade information from business users based on SEC requirements.
• Designed and implemented basic SQL queries for report and data validation requirements.
• Extensively worked on MS Access, MS Excel, and SQL
• Worked with test data team to set up and resolve test data issues for integration and system testing.
• Report the UAT status to Project manager
• Worked in all the phases of Datwarehouse Testing, ETL testing
• Worked on various security master tables as lookup for various CUSIPs
• Used Rational Clear Quest to log and track defects.
• Used the SQL and verified the Oracle database for the purpose of data verification.
• Attended project meetings, release meetings, and QA status meetings.

Environment: UNIX, Windows NT/XP, MS Office Tools, MS Project, Test Director, Quality Center 8.0, Oracle, PVCS, DBVisualiser, RapidSQL, TOAD, Rapid FTP, Rational ClearQuest, Test Manager, Ab Initio, Business Objects, Crystal reports