PROFESSIONAL SUMMARY:

• Over 8 years of industrial experience as a Business Analyst in the domains of Finance, Mortgage, Investment banking and capital markets with expertise in implementing large enterprise applications with strong knowledge of the SDLC product life cycle methodologies like Waterfall, RUP & Agile/SCRUM.
• Expert in developing Project Plans, Functional Specifications for Business Process Refinement, Re - Engineering, Business Process Modeling, Business Intelligence and Automation, excellent understanding of client-server architectures.
• Highly Experienced with Data Analysis, Modeling, Entity Relationship Diagrams (ERD), Process Modeling, Data Flow Diagrams (DFD) and other UML Diagrams.
• Experienced in modeling Transactional Databases, Data Marts and Data Warehouses using tools like Erwin, perform Data Mapping, also involved in receiving Data Feed from updated Data Sources.
• Experienced in Implementing Normalization/De-normalization techniques for optimum performance in OLTP/OLAP database environments.
• Experienced working on the Testing Lifecycle, understood various kinds of testing which include Black Box, Gray Box, White box, Performance, Load, Stress, Regression Testing.
• Conducted User Accepting Testing (UAT) with users and stakeholders, prepared Standard Operating Procedures.
• Works with user to identify the user's need and delivered the quality systems solutions to business problems.
• Provided supervision in developing group goals and objectives, monitored and controlled client production charges.
• Also developed and evaluated staffing plans by utilizing formal SDLC to coordinate system development activities.
• Provided project status reports and also identified user needs, analyzed project proposals.
• Develop conceptual systems requirements and systems integration requirements, prepared systems phasing plan.
• Provided business application consultation; provide problem tracking/management; and prepare and deliver presentations

TECHNICAL SKILLS

Skillset: Java, HTML, MS Office Suite 2000, MS Excel, MS Visio 2000, MS Project 2000, MS SharePoint, SQL Server 2000/2005, Oracle 8i/9i/10g, DB2, MS Access 2000, Rational Clear Case, Rational Clear Quest, Rational Software Modeler 7.5, Rational Requisite Pro, HP Service Manager, HP Quality Center, Erwin Data Modeler 7.1/4.0, Auto Cad 2004.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Business Analyst

Hardware/Software: MS SQL Server 2005, Oracle 9i/10g, MS Office Suite 2007, MS Word 2007, MS Excel 2007 MS Visio 2007, MS Project 2007.

Responsibilities:

• Gathered user and business requirements through brainstorming sessions and other requirement gathering strategies for ETL process.
• Conducted Data Archiving, Data Mapping and involved in receiving the Data Feed from updated Data Sources and perform ETL Validation, writing requirements to enhance ETL process using Informatica.
• Created the Data Mapping Document to specify the Mapping from various sources to the target database, performed Data Archiving conducted Data Analysis and received Data Feed from updated Data Sources.
• Involved in creating, designing reports framework, and dimensional data models from the data warehouse based on the Ralph Kimball paradigm star schema and snow flake schema.
• Worked extensively with the users and with different levels of management to identify requirements, business events and to develop functional specification.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing system term considerations, the long term considerations and its benefits.
• Conducted process improvements, status meetings, presided over the Changed Control Board meetings to discuss Defect, Enhancement and Database Change tickets.
• Created a Master Data Management Plan as a part of Production Readiness Review, played an active role in Production Support, Troubleshooting and maintenance of the application.
• Developed a conceptual level requirements in the analysis phase and supported the production environment proactively through management activities.
• Provided business application consultation; provide problem tracking/management; and prepare and deliver presentations.

Confidential, Iselin, NJ

Sr. Business System Analyst

Hardware/Software: MS SQL Server 2005, Oracle 9i/10g, MS Office Suite 2007, MS Word 2007, MS Excel 2007 MS Visio 2007, MS Project 2007, HP Quality Center Enterprise version, Bugzilla 3.0.

Responsibilities:

• Designed the business requirement collection approach based on the project scope and Software Development Life Cycle methodology.
• Primary liaison between Business users, the Technology group during the redesign of the processing for sales, resulting in process understanding and cooperation during testing and approval stages.
• Created the Business Requirement Document (BRD), keeping in mind that capital allocation is more risk sensitive, separating the operational risk from the credit risk, highly experienced in Risk analysis, Margins and Limits.
• Organized and Conducted JAD session to extract the requirements from the Users, performed analysis on how the application would affect the current processing of Business.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing system enhancements from system AS-IS and TO-BE processes to understand the key findings, the short term considerations, the long term considerations and its benefits.
• Created Use Cases and Test Cases for each of the allocated requirements and forwarded it to the Developers for the design and development of the system. The Test Cases to be used by the Testers after the Unit Testing is done by the developers.
• Coordinated with Project Manager, developed Concept Proposal including Business Case, Cost-Benefit Analysis, and conducted Feasibility Study, Risk Management Plan.
• Design interfaces and process flow to source loan and hedge data for calculating pricing and other reporting functionalities.
• Involved in creating, designing reports framework and dimensional data models from the data warehouse using the fact and look-up tables.
• Worked with the QA Team as a Tester during the test phase, maintained an Issue Track Log to make sure all the issues are addressed, played a part in troubleshooting before the QA Analysis.
• Developed the User Acceptance Test Plan, trained the users on the system and implemented required changes after being approved by the Change Control Board.

Confidential, New York

Business System Analyst

Hardware/Software: MS SQL Server 2000, Business Intelligence - Crystal Reports, MS Office Suite 2005, MS-Project 2005, MS-Visio 2005.

Responsibilities:

• Gathered user and business requirements through brainstorming sessions and other requirement gathering strategies using Rational requisite pro.
• Wrote Use Case, Test Cases, Prepared Business Object Models, and Business Process Models that included modeling of all the activities of business from conceptual to procedural level using MS Visio.
• Created the Data Mapping Document to specify the Mapping from various sources to the target database, performed Data Archiving conducted Data Analysis and received Data Feed from updated Data Sources.
• Involved in creating, designing reports framework, and dimensional data models from the data warehouse based on the Ralph Kimball paradigm, using the fact and look-up tables.
• Performed testing using the Test Cases prepared, maintained an Issue Log, troubleshooting all the issues, making sure it’s being addressed, rectified and updated.
• Assisted with user testing of systems (User Acceptance Testing), developing, maintaining quality procedures, ensuring that appropriate documentation is in place.
• Conducted process improvements, status meetings, presided over the Changed Control Board meetings to discuss Defect, Enhancement and Database Change tickets.
• Coordinated with the QA Team for the sign-off process before deployment and assisted the Project Manager on creating the Lessons learned document.
• Created a Back out Plan as a part of Production Readiness Review, played an active role in Production Support, Troubleshooting and maintenance of the application.
• Worked extensively with the users and with different levels of management to identify requirements, business events and to develop functional specification.
• Conducted workflow, process diagram and GAP analysis to derive requirements for existing system term considerations, the long term considerations and its benefits.
• Assisted the testing team in developing the test plan, test conditions, and test cases based on business requirements and technical specifications.

Confidential, New York

Business Analyst

Hardware/Software: MS Office Suite 2005/2007, MS Visio 2003, MS Project 2003, SQL Server 2005, Oracle 9i, Microsoft Visual Studio 2005, Business Intelligence, Erwin Data Modeler 4.0, HP Service Manager.

Responsibilities:

• Organized, conducted JAD sessions for requirements gathering. Prepared Business Requirement Documents and Functional requirement Documents.
• Worked extensively on MS Project to develop Work Flow, Resource Planning, Activity Network diagrams, using Program Evaluation and Review Technique (PERT).
• Created Requirement Traceability Matrix to maintain all the requirements extracted from the Users, Stakeholders, made sure all the documents are being accounted for.
• Developed different UML diagrams like Context Diagrams, Wireframes, Swim Lane Diagrams, which helped in Rapid prototyping and pinpointing potential problems early in the process.
• Coordinated with Project Managers, Developers, SME’s to design, create Work Flow Diagrams using MS VISIO.
• Prepared Business Process Models that included modeling of all the activities of business from conceptual to procedural level on the Data Mart having a Snowflake Schema design based on the Ralph Kimball paradigm.
• Involved with the requirements design, development, testing, and administration of transactional and analytical data constructs/structures.
• Conducted Data Archiving, Data Mapping and involved in receiving the Data Feed from updated Data Sources and perform ETL Validation, writing requirements to enhance ETL process using Informatica platform, also worked on the validation and integrity of the migrated data.
• UAT was carried out with prospective users, Conducted status meetings, any Defect, Enhancement and Database Change tickets were conveyed to the Change Control Board.

Confidential, New York, NY

Business Analyst

Hardware/Software: J2EE, SQL Server 2005, Oracle 9i, Erwin Data Modeler 7.1, MS Office Suite 2007, MS Visio 2007, MS Project 2007, HP Service Manager, HP Quality Center Enterprise Edition.

Responsibilities:

• Worked with Project manager, created Work flow diagrams, Activity Diagrams on MS Visio/MS Project using Program Evaluation and Review Technique (PERT).
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and other requirement gathering strategies using Rational requisite pro, build an Enterprise-Reporting System to support the company’s mortgage and fixed income functions.
• Wrote Use Case, Test Cases, Prepared Business Object Models, Business Process Models that included modeling of all the activities of business from conceptual to procedural level using MS Visio.
• Performed testing using the Test Cases prepared, maintained an Issue Log, troubleshooting all the issues, making sure its being addressed, rectified and updated.
• Assisted with user testing of systems (User Acceptance Testing), developing, maintaining quality procedures, ensuring that appropriate documentation is in place.
• Conducted Joint Application Development (JAD) sessions for requirements gathering with Business Stakeholders, SME’s, Users, refined it using Wireframes, Use Case Diagrams and made conceptual illustrations.
• Processed the data requirements to present them as Bar charts, Pie Diagrams for financial analysts to perform trending to integrate with the Express Scripts system.
• Coordinated with business users to prepare, update Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Created Use Cases documents for requirements.
• Coordinated with Project Manger to prepare the Project Charter, received status update from project managers which was used to calculate and estimate project resource percentage consumption.
• Developed weekly reports that were used by management to assess the percentage of progress being made by the project team, compared it with hours burnt, worked on Investor reporting issues/remediation strategies.
• Developed source to target mapping document containing all the Business required fields along with the business rules, database and table names, created the fact and look-up tables.
• Conducted Data mapping to collect and show relations between data from dashboard function to the ODS table on My SQL database, represented this mapping using ERDs, and Process Modeling DFD’s on MS Visio.
• Scheduled meetings with developers, System Analysts, testers to collaborate resource allocation, project completion, managed workload, schedules and coordinated status review meetings with project managers, business managers, cross block BAs and team members.