SUMMARY:

• Over 12 years of experience as a Data Analyst/ Business/Systems Analyst & IT and User Acceptance Testing (UAT).
• Requirement analysis, defining business use cases, JAD sessions, data analysis and BRD’s.
• Excellent understanding of business operations and analytics tools for effective analyses of data.
• Test lead, unit testing, system testing, regression testing, UAT, preparing test plans, test cases.
• Experience in end - to-end configuration in Oracle Taleo - recruiting and onboarding/transition - modules for various implementation projects.
• System analysis, System Requirement Specifications (SRS), System Design Specifications (SDS), Functional Specification.
• Managed teams of 3 -5 professionals.
• Excellent understanding of Data services, Data ETL using SQL query tools and applications.
• Experience in secondary mortgage business market, single-family REO, banking & financial services, healthcare, and manufacturing sectors.
• Ability to meet deadlines and handle pressure coordinating multiple tasks.
• Demonstrated strong interpersonal skills with Confidential ability to work effectively with upper management and excellent leadership skills in motivating others.

TECHNICAL SKILLS:

CORE COMPETENCIES: SQL Server, Business Intelligence, Business Process Modeling, Data Analysis, Metrics & Reporting, Customer Relationship Building, Operational Readiness, Reviewing and executing test cases, Agile Methodology, Oral & Written Communications, Technology Management

APPLICATION SOFTWARE: SharePoint, MS Office, Project, & SharePoint, Access VB Script, SDLC Knowledgeable, Oracle, MS SQL Server & Teradata, Tableau, TIBCO Spotfire & Business Objects, SAS, JIRA, Informatica, Taleo, Confluence

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr.Data Analyst/Business Analyst

Responsibilities:

• Analyze data identifying KPIs to establish performance metrics, developing dashboard mock-ups and partnering with IT to leverage TIBCO Spotfire as Confidential primary reporting solution.
• Conducted JAD sessions with Confidential stakeholders, end users and SME, to determine Confidential critical business processes and identify key functional requirements for LoanServ system adhering to Confidential Mortgage Servicing Industry practices.
• Validated Confidential various business processes with a committee of Subject Matter Experts (SME's) like Mortgage Servicers, Underwriters, Credit Analyst etc, to ensure Confidential rules and guidelines have been met.
• Manage Confidential planning and development of design and procedures for metrics reports
• Develop new reports and delegated tasks to team members
• Support Enterprise Data Management efforts to monitor data quality by researching and resolving failures in EDQ dashboard for SIR.
• Conducted user acceptance testing to ensure that developed systems satisfied Confidential needs of business clients as specified in Confidential functional requirements.
• Assisted clients and team in producing high quality applications.
• QA Lead Support SF REO CLF Project. Confidential system is designed to forecast Single Family credit losses using economic default loans provided by Confidential Loss Forecast Model (LFM) and applying Confidential REO accounting rules and business assumptions to produce SOP-03-3 excluded pro- forma income statement.
• Performed Data Validation,Data extraction, Data Integration and Backend/DB testing using SQL Queries manually.
• Test Schedule, Test Plan, Test Cases and Test Scripts preparation. Worked heavily on SQL Server database to extract data and build Business reports.
• Building reports in Tableau based on Confidential business requirements.

Confidential, MCLean, VA

Sr. Data Analyst/Business Analyst

• Collaborated with functional area SME’s to define and document business requirements, business process models, data analysis and data requirements.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Implemented a variety of projects transitioning from multiple Unix-based environments to a single Windows-based client-server suite.
• Created functional specifications, business requirements analysis, flowcharts and process maps.
• Assessed Confidential risk of Confidential system not operating effectively in a production environment.
• Created SAS datasets by extracting data using SAS/ACCESS from relational databases for data analysis.
• Developed and maintained critical documentation baselined/versioned in Clear case/SharePoint.

Confidential, VA

Data Analyst

• Involved in full cycle of COGNOS reports from Confidential models package to Confidential publisher of COGNOS to make sure that Confidential packages are build and published to use in Confidential COGNOS builder to generate Confidential reports.
• Conducted JAD sessions for effective communication of views between stakeholders and gathered business requirements.
• Created use case diagrams to explain Confidential flow of events and how different software systems interact with each other.
• Designed data marts that were used as Confidential source for analytic reporting.
• Ensured that all Confidential artifacts are in compliance with corporate SDLC Policies and guidelines,

Confidential, VA

Business Analyst

• Extensively used Rational Test Manager for test planning/test case development and test execution. Participated in Test Plan/Test Case Reviews and weekly meetings.
• Maintained detailed Test Matrix using Rational Requisite Pro and Rational Test Manager.
• Performed requirement gathering, using Rational Requisite Pro and defect tracking and reporting using Rational Clear Quest.
• Experience in End to End Configuration in Oracle Taleo - Recruiting & Onboarding/Transition - Modules for various Implementation Projects.

Confidential, Hartford, CT

QA Tester

• Conducted Regression Testing using Win Runner, QTP
• Performed Functional and System testing of Data Stage Jobs.
• Prepared test data to verify Confidential functionality of Confidential jobs.
• Developed and modified UNIX scripts to test and validate ETL Loads/Historical data.
• Supported Confidential build and deployment of code to Confidential test environments and diagnoses problems from client and server
• Conducted volume and stress tests on Confidential server using Load Runner by generating users.

Confidential

Quality Analyst

• Designed and developed a system for Confidential Hyderabad Stock Exchange (HSE) that would maintain a list of permitted securities.
• Developed reports based on volumes of stock traded and security details per Confidential requirement of Stock Exchange Board of India.
• Analyzed and developed on-line system for a 400 member stock exchange.
• Created scripts to generate various reports like service-tax, payment analysis, settlements etc. Transforming Confidential business requirements into technical specifications.
• Designed and implemented Flexible security system that allows user access to system based upon authorization levels, and user functions.