Summary

• Over 6 years of IT experience in requirements gathering, documenting Business Requirement Document’s(BRD) and SSD’s(System Specification Document) , data analysis and data modeling, design, development and deployment of Data warehouse, Relational Database Management Systems, Internet and Client Server applications in various environments.
• Experience in carrying out projects through SDLC project methodologies.
• Experience in acting as a liaison when interacting with various business units and working with cross-functional teams.
• Hands-on experience in the design, development and execution of test plans and test strategies.
• Expertise in analyzing, designing and writing the required documentation procedures for the verification, validation and implementation of accurate business strategies for the successful deployment of real-time solutions.
• Extensive knowledge of Rational Clear Quest, Rational Clear Case and Visio.
• Proficient in maintaining business requirement documentation like the business requirements, processing notes and detailed functional specifications for all interfaces and procedures.
• Extensive experience in project initiation, conceptual design, requirements definition, database design/modeling, system/programming specifications and documentation, quality assurance/system testing, and implementation.
• Experience in interacting with business users to identify information needs and initiating process changes.
• Proficient in developing Process flow diagrams using Visio, knowledge of DOORS and Share point.
• Cross-functional collaboration - ability to facilitate liaison between technical and non-technical personnel and among customers, vendors, management, and other partners.
• Extensive experience reviewing and understanding business and requirements and writing detailed Test Plans, Test Cases, and Test Scripts by understanding and working with Use Cases.
• Adept at facilitating of joint application development (JAD) sessions and interviews, written correspondence, reports, implementation requirements, project status reports, and oral presentations to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Excellent communication and interpersonal skills.

Programming Languages SQL, PL/SQL,
Operating Systems Windows 95/98/NT/2000/XP,Unix
RDBMS Oracle 8i/9i, SQL Server 2000, DB2, MS Access 2000, TOAD
Data Warehousing : Business Objects Developer Suite 5.1/6.5(Designer, Business Objects, Supervisor)
Management Tools Rational Products (Requisite Pro, Clear Quest, Clear Case), MS- Visio, MS- Project, Dream Weaver, DOORS V9.2
Version Control Visual Source Safe, PVCS, Clear Case,
Methodologies System Development Life Cycle(SDLC),Application Maintenance Control Process( AM-CP), Use Cases,
Defect Tracking Tools Test Director6.0/7.0/7.6/8.0, Clear Quest, Quality Center
Reporting Tools Crystal reports 10.0/9.0/8.5, Crystal Enterprise 10.0/9.0/8.5/8.0,Visual Studio, MS Access, MS Excel

Education
Bachelors of Technology in Mechanical Engineering.
Experience

Project: MISMO Advantage
The MISMO(Mortgage Industry Standards Maintainenance Organization) for Loan Delivery project focuses on Freddie Mac’s ability to accept the MISMO defined loan-level attributed data set from the seller for loan delivery. This would entail the transition away from the use of the Form 11/Form 13 as the data set for loan information at delivery. While Freddie continues to support customers who may not be able to meet the conversion timeline, Freddie wants to develop the ability to read in a data file whose loan attribute data is defined according to the MISMO industry standard.

Responsibilities:

• Effectively involved in MISMO project as a Systems/ Business Analyst and was involved in defining and documenting the system requirements in the project.
• Responsible for defining requirements approach as well as producing project requirement deliverables.
• Co-coordinated with the BA Lead in providing input to Level Of Effort (LOE) on the assignments as well as general tasks such as cross impact analysis, Project definition, scope, deliverables and maintained the Requirements/System Analysis task list for the project.
• Facilitated interview sessions to determine the needs of the project and was engaged in review of general and detailed system designs, identifying gaps and possible errors in the translation of the business requirements.
• Ensured that assignments and tasks fall within the defined project scope. Identified scope gaps or changes in scope and make recommendations for resolution.
• Responsible for delivering the process model SDLC artifacts-the system requirements, composed detailed system process flows/use cases and reviewed functional specifications ,system requirements to ensure accurate and complete translation of business requirements with the business, development and testing teams.
• Lead the resolution of conflicts between the design and requirements by responding to (development teams issues) concerning business requirements and system design in a timely manner.
• Lead the peek and the peer review sessions of the requirements with the business, developers and testers and clarified any issues.
• Updated the DOORS modules with system requirements for the project functions once the requirements have been reviewed, updated for any issues/concerns and approved by the business and made pre-baseline checks and distributed to the respective dev and test teams.
• Maintained and was responsible for Requirements Traceability between the business and system requirements in collaboration with the test lead.
• Ensured that all the issues/risks beyond the teams ability to resolve were escalated to the project lead and successfully helped priority issues to be solved on time for the code drops as well as requirements delivery deadlines
• Responsible for creating the Htmls through Dreamweaver for the Best Efforts(BE) loan delivery execution path Screens. Worked on the Htmls through Dreamweaver, and filled in the role of UI team, for the project needs to assist the developers in the GUI screens
• Also facilitated the walkthroughs for the review of Htmls with the User Acceptance Testing team, System Integration Testing team and developers and obtained the approvals.
• Reviewed System and User Acceptance Test plan to ensure business requirements are accurately tested.
• Served as first point of technical business analyst in order to research potential technical defects/root cause. Identified data needs for specific project application and supported data creation and ensured the validity for test scenarios with the testing team.
• Lead and coordinated the defect resolutions. Prepare the change requests for approval and drive the resolution of the issues with the requirements
• Responsible for creating the Change Request Central tickets by coordinating with the Development and Test teams as well as BA teams during the development to testing phases for inputs on the CR LOE’s when resolving the defect tickets and provided the Project manager with the specifics so that he can approve of the changes..
• Coordinated with the UAT testing team in efficiently solving their concerns in Certification and providing them with transparent requirements by clarifying data and system interpretation of the data and effectively modifying/updating the requirements for clarity and transparency as well as gain more insight in to the system.
• Involved in the validation of the XML loan files to verify the data as given in the requirements while executing the test cases using XML Spy. Also was assigning the schemas to the XML file in case the DTD schema was not already assigned.
• Ensured availability to both testing and development teams to clarify any issues/concerns during the development and testing.
• Provided guidance to the testers on the testing team for project needs by assisting in preparing the loan files and provided knowledge transfer/training by clarifying.

Project: Loan Prospector (LP)
Loan Prospector is Freddie Mac\'s automated underwriting risk assessment tool that gives lenders ready access to Freddie Mac\'s credit and pricing terms. The Home Value Suite application leverages statistical derived property valuation data to provide the following services: Home Value Explorer (HVE) - a fee based property valuation service primarily targeted to equity loan originators and Home Value Suite Batch (HVS Batch) which offers the ability to bundle a series of transactions for bulk processing.

Responsibilities:

• Effectively involved in HVE in LP project and participated in all the phases of the project life cycle as a Systems Analyst and was involved in defining, designing, development, testing and implementation of the requirements.
• Analyze business needs and requirements for proposed new business products or processes.
• Analyze, interpret and resolve complex data analysis and provide higher management with the results by giving out process flow charts/graphs and excel spreadsheets.
• Create Enhancement Request tickets in Clear Quest explaining the requirements and describing the LOE and any risk factors associated with the requirements.
• Create the requirements document pertaining to LP by writing the Functional/ Business Requirement documents using DOORS as per SDLC project methodology and co-ordinate with testing team in creating the Requirement Traceability Matrix.
• Perform the SIT Testing to ensure that the requirements functioned as desired and expected.
• Develop the SIT test plan, which involved creating the test cases and the test data files set up.
• Prepare and maintain system documentation in accordance with business requirements.
• Prepare detailed system test cases that adequately represent the business application\'s needs.
• Communicate with and coordinate efforts among various team members.
• Complete the testing and log the results, any issues encountered during the testing, resolution for the issues in the SIT document, and obtain sign off from Test lead.

Data Warehouse Analyst (December 2006 – Oct 2009)
Project: Corporate Data Warehouse (CDW)
The company generates and maintains large inventory of corporate data, which is stored in a centralized data repository with purpose to maximize the value, quality, and usability of data. The data stored in CDW can be used for decision support, management reporting, ad-hoc and trend analysis, modeling and data mining purposes. It is the largest corporate data warehouse at Freddie Mac as it is the repository of more than 2/3rd of all financial data, which is crucial to the business.

Responsibilities:

• Responsible for the management of multiple Project Enterprise releases (HMP- Housing Affordable Modification Program Release I, EI, Monthly WRSI, PE 7.0 & PE 7.1,LP Scorecard 5.0,LP BCAS, SFP Pricing Analytics & EROIII) adhering to Freddie Mac Technology Delivery (FTD) model.
• Participated in all the phases of the project life cycle as a Business Analyst and was involved in defining, designing, development, testing and implementation of the requirements for Integrated Operation Data Store (IODS) and Corporate Data Warehouse (CDW) sub systems.
• Represented the CDW team in the peek and peer review meetings of the Business Requirements to analyze the project impact on the CDW and communicated meeting minutes after important discussions so that everyone was on the same page about decisions made and action items.
• Co-coordinated with the manager to create the Project LOE’s, Project schedule and send out weekly status of the projects by creating the Project dashboards for business stakeholders.
• Performed extensive research on complex/large datasets of high volumes (almost 100 million records)
• Imported the data into different environments from Access database/Excel spreadsheets as well as the identification and correction of errors and discrepancies in data.
• Identified, collected and organized data from multiple sources for monthly, quarterly, annual and ad-hoc reports provided to higher management for the Weighted Recent sales Index (WRSI).
• Worked with the DA’s in creating the data models by explaining the key points of the data and bringing in to the warehouse.
• Created the functional Business Requirement documents and RTM in SharePoint.
• Provided best possible solutions for any issues related to the implementation of the requirements.
• Reviewed the scope/work plan and performed impact analysis.
• Participated in the design meetings with Data Analyst, Database Architect and Technical Analyst to finalize the data models.
• Created Enhancement Request tickets in Clear Quest explaining the requirements and describing the LOE and any risk factors associated with the requirements.
• Created/modified the BRS with the requirements.
• Facilitated BRS walkthrough session to obtain the sign off from business owners, and data quality team.
• Performed the BRS Testing to ensure that the BRS was well documented and was ready to store in the central repository or DOORS/SharePoint for some projects, which could be referred by other teams.
• Performed UAT Testing to ensure that the requirements functioned as desired and expected.
• Developed the UAT test plan, which involved creating the test cases and the test data set up.
• Completed the testing and logged the results, any issues encountered during the testing, resolution for the issues in the UAT document, obtained the sign off from the Business Owner and Data Quality team.
• Performed the Pre Implementation and Post Implementation tasks, monitored the data after the implementation until the warranty period to ensure successful implementation and roll out of the requirements.
• Closed the Enhancement Request tickets, CTT and the Remedy Tickets after the Postproduction validation signoffs from the Business Owners.
• Identified and reported Data Quality issues.
• Performed the analysis and created the DCU/DML document for the resolution of the issue.
• Obtained "approval to proceed" from the BO and DQ. Performed the pre and post implementation UAT test to ensure proper resolution of the issue and obtained "sign off" on the documents.
• Developed data quality reports to reconcile the data between the source and target tables.

Environment: DB2, MS Access, Rapid SQL, SAS, MS Project, MS Office, Windows XP, Data Stage 7.5.2/7.1, Plan View, Rational Suite (Clear Case, Clear Quest), MS SQL 2005 MS-Access, MS-Excel, PowerPoint, Visio, DOORSv9.2,DreamWeaver,Unix ,XML Spy, Quality Center

Confidential, Aug 2005– Nov 2006
Business Analyst

Project: POWER
POWER (PCT Operations Workflow Electronic Review) is designed to support an automated, workflow-driven, client/server environment, working with an electronic application in an integrated desktop environment. POWER automates the United States Receiving Office (RO/US) processing of applications filed under Chapter I and Chapter II of the PCT. The POWER system technical architecture consists of a User Interface layer and Business Logic layer, which include interfaces to a Services layer. The User Interface layer is comprised of Graphical User Interface (GUI) elements that were developed using VB 6.0. GUI elements interface with objects of the Business Logic layer, Advantage Gen Servers. The Business Logic Layer provides services that implement business processes, enforce business rules, and provide system/task management.

Responsibilities:

• Analyzed the business and functional requirements, involved in several brains storming session.
• Worked with business users to understand project requirements and to figure out the scope of test strategy and test planning.
• Facilitated requirement gathering sessions with the Business Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes to create functional requirements documents and process flows.
• Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
• Arranged walkthrough sessions with the user group to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Worked closely with business clients to develop an understanding of their business processes and created the Business Process Models (flow diagrams) using Visio.
• Met with developers daily to identify problems or issues.
• Communicated with project management regarding issues and project status.
• Acted as a liaison between various business units and the technical staff.
• Worked with Clear Quest system admin to create the traceability matrix and track the defects associated with requirements during testing phase.
• Reviewed the test cases created by QA testers to ensure that the testing team understood the functionality.
• Participated in the regression testing to ensure the validity of the data and confirm that all the requirements were met.
• Developed detailed test strategy, test case documents based on the TRD and SDD.
• Worked closely with developers and other testers to nail down the technical problems for production issues.
• Performed extensive database testing by writing complex PL/SQL queries to test the different scenarios in the application.
• Tested the application for Section 508 compliance using JAWS 5.0.
• Involved in completing User Acceptance Testing of the application.
• Used test director to create, update and maintain test cases, test steps and test results for maintaining centralized repository.
• Used Test Director to log defects, communicate and tracking the defects through out the defect life cycle.
• Created Requirement Traceability metrics using Test Director.
• Created test completion, test coverage, strategy-tracking reports using Test Director.
• Coordinated and communicated the whole BA/Tester effort by effectively working with different teams.
• Used MS Excel and Word features for different stages of testing the application.
• Successfully rolled out the project at the scheduled release date.

Environment: Rational RequisitePro, Clear Quest, SQL 2000/2005, MS Access, MS Project, MS Office, Windows XP,Test Director 8.0 / 8.2 , Oracle 9i, Shell scripting, JavaScript, JSP,ASP, VBA, Adobe Acrobat, Adv Gen 6.5 , PVCS, SFTP, Crystal Reports, Jaws 5.0, MS Office, XML, Unix, Windows NT and 2000,

Confidential, Jan 2005 – Jul 2005
Programmer Analyst

Project:
CIGNA HealthCare (CHC) initiated the Transformation effort to build a Data warehouse from various claims & member source feeds and Integrating the Application to end user on the World Wide Web. Web application was created to automate the ROI (Release of Information) process from scanning the patient records from the hospitals/clinics to entering the data in the database to printing and mailing the records while maintaining the security measures recommended by HIPAA.

Responsibilities:

• Identified constraints in the existing mechanism and designing solution to overcome constraints.
• Interacted with clinic personnel and administrators to obtain requirements and designed custom reports using Crystal Reports.
• The Crystal Reports designed were complex and used formulas, grouping, parameters, selection criteria, and sub reports.
• Responsible for creating the complex Crystal reports (On demand, Adhoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, and aging reports).
• Created views and stored procedures for Reports using complex SQL, PL/SQL.
• Published Crystal Reports in web-based environment using Crystal Enterprise.
• Involved in design and development of reports for Insurance Claims system using Business Objects and Crystal reports.
• Developed BO Universes using designer and operational reports using Business Objects.
• Created various classes, objects, Filters and Conditions in the Universes.
• Review User Acceptance testing plans.

Environment: Business Objects 6.5, Crystal Reports 10.0, Crystal Enterprise WinNT, Oracle9i, Informatica Power Center 7.1, SQL, and PL/SQL.