SUMMARY:

• Perceptive Business System Analyst skilled in enhancing existing systems with new features in a fast - paced environment.
• Advanced proficiency in all aspects of Excel and Financial services industry.
• Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
• Strong analytical, problem- Confidential skills with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management. Specialize in applying technical expertise to develop insightful solutions applicable to current business practices. system and data analysis
• Strong ability to coordinate with external or internal clients
• Ability to analyze clients’ existing systems and business models
• Solid understanding of software development lifecycles
• Ability to analyze clients’ existing systems and business models
• Solid understanding of software development lifecycles
• Strong analytical skills
• Report generation
• Extensive experience with Microsoft tools - Excel, Access
• SDLC Methodology - Agile, Waterfall and Iterative
• Interpersonal communication
• Strong knowledge of ETL (Informatica)
• Toad, SQL Navigator, Rapid SQL proficiency

PROFESSIONAL EXPERIENCE:

Confidential, Remote

Production Data Analyst

Responsibilities:

• Developed project plans and managed scope using SDLC methodology.
• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Developed optimized data collection and qualifying procedures.
• Performed data validation using SQL queries and multiple reports.
• Involved with writing basic SAS queries and generating data.
• Leveraged analytical tools to develop efficient system operations.
• Performed impact analysis, went through all the use cases and workflows

Confidential

Production Data Analyst

Responsibilities:

• Worked as a project manager to transition DOJ project. Role involved creating a work flow, data repository, generate testing sample using SQL query.
• Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
• Responsible for data mapping of feeds from several reference data systems
• Performed Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Performed data validation using SQL queries and multiple reports.
• Mapped and documented interfaces between legacy and newer systems
• Worked with Audit team to meet deadlines that involved with multiple tests.
• Generated monthly samples for testing using SQL query.

Confidential

Senior Business Analyst

Responsibilities:

• As a business analyst, worked with the line of business in understanding their data requirements for the tests that were needed to be executed.
• Translated those discussions into actionable requirements for developers to create SQL queries in order to pull the data.
• Acted as a liaison between the developers and the line of business in clarifying questions, providing updates and creating the appropriate documentation (Business requirements document, process documents etc). Also worked with other developers and database owners in researching new data sources for sample pulls.
• Create data verification methods and comply with standard system procedures.
• As a developer on this project - worked with the assigned Business Analyst in understanding the business requirements and translating that into SQL code in order to extract the sample loans as specified in the requirements document. Responsibilities included creation of the SQL code, testing, documentation of code and creating the appropriate production process documentation.
• Prepared testing schedule for complete systems.
• Provided support for change control and system updates.

Confidential, Boston, MA

System Business Analyst

Responsibilities:

• Maintain and support systems for data warehouse and business intelligence (BI) initiatives.
• Perform data analysis, testing, debugging, disaster recovery, and problem resolution.
• Responsible for providing round the clock Level II support for Charles River trading application and supporting day to day issues for all Confidential traders on Charles River
• Responsible for determining data discrepancy on trading platform.
• Tested applications and resolved complex problems throughout software development life cycle (SDLC), including preparing detailed program specifications.
• Lead tester for verifying application updates and enhancements in the UAT environment. Work with traders where necessary to perform UAT and provide training and coaching where necessary.
• Create and maintain articles for department Knowledge Base System illustrating business processes, installations, and issue resolution.
• Performed Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Developed the test plan, test conditions and test objectives to be used in testing of the system
• Used Rational Requisite Pro to analyze and document requirements.

Confidential, Herndon, VA

Senior Business Analyst

Responsibilities:

• Performed loan level validation to ensure data integrity and consistency between different environments (development, acceptance, production). Performed detailed data analysis to identify loans with varying characteristics as defined by the customer. Utilized TOAD/ SQL to extract data from an oracle environment and EXCEL to perform the analysis.
• Responsible for conducting integration and UAT phases of testing and prepared relevant documentation.
• Performed source to target mapping for data movement from RDW to ADW. Responsible for preparing detailed business mapping documents and performed validation in the actual database environment.
• Responsible for creating business requirements, test plans and test summary documents.
• Translated high level business requirements into functional specifications for the IT organization.
• Performed shakeout testing and validated reports for SOX purposes.
• Played key role in design and development activities to ensure software requirements were met.
• Worked with ETL process Data controls, movements, joins, extractions.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams using MS Visio

Confidential, Boston

System Business Analyst

Responsibilities:

• Worked as a liaison between the Business User Groups and the IT Groups to ensure complete understanding of enhancements requested by the line of business. Translated those requirements into work requests for the IT groups. Subsequent to go-live, performed testing and interacted with the business on any issues.
• Assisted development and production teams by determining application design flaws, thereby optimizing SDLC.
• Provided complete Production Support for Charles River Trading Application.
• Served as a knowledge resource for the business on electronic trading platforms.
• As part of the upgrade, identified Use cases from the Functional Requirements and wrote Use Case Specifications. In addition, created 'To-Be' Business Process Workflow diagrams (Activity diagrams) in Ms Visio.
• As part of the Charles River upgrade, facilitated user acceptance testing. Involved in developing of the test strategy and assisted in developing QA Test plans for Functional, Integration and System Testing.
• Utilized data modeling techniques to document business process and data flows.
• Served as a go-to person for the line of business and facilitated with the testing, research, and resolution of issues during deployment.

Confidential, Boston

System Business Analyst

Responsibilities:

• Developed Vision Document and Business Requirement Specifications and gathered Business and Functional Requirements.
• Interfaced with internal clients and technical vendors on new feature requirements and conducted a thorough analysis of the system features to assist project team with implementation of new features.
• Applied process improvement and reengineering methodologies and principles to conduct process modernization projects.
• Traveled to the client’s sites to conducted individual and group (JAD) sessions with business and technical units.
• Performed Functional and GUI Testing to ensure that the user acceptance criteria are met.
• Used Rational Unified Process (RUP) for business requirements, business process design (Use Cases using UML) and activity and sequence diagrams to analyze requirements.
• Conducted Training sessions for the end users and documented various Training manuals.
• Facilitated with the testing, research, and resolution of issues involved in deployment.