SUMMARY

• Over ten years of information technology, business analysis, systems analysis, requirement analysis, reconciliation, project management experience, testing and custom development
• Over 7 years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Experienced in developing Data Mapping and Identifying Bottlenecks of sources, mappings.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Analysis and review of Software and Business Requirement Documents.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Experience with leading multiple projects as a project manager
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
• Substantial knowledge of the Mortgage Banking Industry, practices of the Secondary Mortgage business, Asset Servicing, Real Estate financing and Government Consulting
• Extensive working knowledge of analysis, requirements gathering, testing in the Data Warehouse (DW) environment
• Strong analytical, problem solving and result - oriented skills
• Excellent organization, verbal and written communication skills
• Experience in the time-sensitive, fast-paced environments
• Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and effectively.
• Excellent team player with an ability to perform individually, good interpersonal, analytical skills, multitasking and detail oriented
• Ability to work independently and as a cooperative team member in a deadline-driven environment
• Experienced in developing accurate business process requirements
• Excellent communicator focused on customer service.

WORK EXPERIENCE

Confidential, Herndon, VA

Sr Business/Financial/Acquisition Data Analyst

• Worked closely with management and business partner to identify, prioritize and analyze business requirements.
• Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Preformed gaps and requirements analysis to ensure functional requirements are met.
• Worked closely with the development team and provided input on design solutions
• Involved from beginning of the project such as of Statement of Work (SOW) to post implementation of SDLC process.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as Quality Assurance Testing (QA), User Acceptance Testing (UAT) and Unit Integration Testing.
• Worked closely with cross functional teams to facilitate gathering of business requirements.
• Created and managed multiple project plans for projects
• Lead multiple projects as a project manager
• Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into detailed mapping documents
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Interacted with stakeholders to understand client business processes.
• Created and managed multiple DW Project plans for the Finance, HR and cross functional team projects to help keep projects on schedule and deliver on time.
• Lead and managed a cross functional DW project for environment upgrade to the cloud environment
• Held meetings with projects team to help ensure company best practices, lessons learned, deep dives to ensure process compliance.
• Managed and lead DW environment upgrade
• Met and lead efforts with clients to capture detailed business requirements, functional specifications, and transformation rules
• Documentation, analysis and testing of the existing Financial and Acquisition data capture process and recommendations on streamlining the process in a new data warehouse
• Provide meaningful analysis on financial data to minimize the impact of inaccurate data on downstream users and systems
• Partner with the development team staff to ensure that the business and functional requirements are properly communicated and correctly translated into ETL code
• Successfully preformed Quality Assurance testing for Financial and Acquisition data capture, transformation and storage processes
• Lead team in time sensitive and fast passed projects
• Preformed Quality Assurance testing using the Toad and SQL developer for oracle tool
• Created and executed Quality Assurance SQL scripts used for manual testing

Confidential, Herndon, VA

Business/IT Analyst

• Lead role in implementing Business Objects reporting tool as an Adhoc function
• Created and developed Business Objects reports and queries
• Designed end user universes in BOXI to support the customers
• Lead role in creating and maintaining Business Objects migration and change management process
• Created test events and scripts to facilitate the execution of the business user’s acceptance test
• SME (subject matter expert) for Business Objects on the MIS team
• Supported all requests for Audit and Investor Reporting teams
• Met with business stake holders, relevant departments, and groups to identify, assess, document, and review business requirements
• Served as a SME (subject matter expert) associated with content, processes, and procedures associated with implementing applications
• Detailed understanding of inputs/outputs and importance of data quality and data efficiency to an operational environment
• Standardized operational deadlines to ensure that deliverables were met on time and within budget
• Identified, evaluated and lead the implementation of process improvement initiatives
• Team lead for successful migration of ASC Main (Production Database) from an Active Directory Server to a dedicated production server. Activities included: needs assessment, requirements writing, test case preparation, UAT test execution, training, and rollout in line with Confidential standards
• Prepared presentations for senior management with a clear summary of changes, trends and analysis
• Interacted with all levels of management from Master Servicing and other divisions on a daily basis
• Performed daily ad-hoc reporting in support of Auditors, Analyst and Servicers
• Identified and developed business requirements for business needs, created testing documentation and supported migration efforts
• Developed, maintained and managed the creation of user reference guides
• Created and provided data presentations for lender visits
• Performed regular daily and monthly updates to business critical EUC (ASC Main)
• Responsible for updating and distributing the month end management reports
• Led efforts for gathering requirements to fulfill business users needs

Confidential, Herndon, VA

Business/Data Analyst

• Lead role in identifying risk and establishing controls for Multiple Addresses Project with FMIS and NSO
• Implemented a process to reduce the 130K population of identified risk and fraud issues
• Lead role in organizing, processing and supervising the accurate execution and control of Servicemembers Civil Relief Act (SCRA) MBS and Portfolio loans within established deadlines; reconciled related accounts and identified and corrected related reconciling items
• Developed SCRA policies and procedures for management with flow charts and documentation evaluating controls and operational risks
• Led automation process initiative for SCRA with Business Requirements and Servicing Guide changes
• Coordinate project tasks and deliverables to ensure timely completion and implementation
• Developed, produced and interpreted Management Information Systems (MIS) weekly and monthly reports for upper management
• Established and maintained strong relationships with internal customers such as Investor Reporting, Credit Policy, Credit Research and Servicing Consultants, and external customers such as Confidential Servicers
• Supervised training and execution of various processes within the business group
• Managed multiple projects including planning, client management, tracking and reporting

Confidential, Herndon, VA

Business/Data Analyst, and Tester

• Supported the creation, testing and implementation of a new web based system capable of processing different loan and pool products with increased flexibility and speed
• Developed a Microsoft Access database to facilitate the business user’s acceptance test for processing mortgage-backed securities, whole loan deals, excess servicing fee strips and other pools
• Developed and maintained complex modeling tools in Visual Basic to replicate monthly pool aggregations, investor distributions, disclosure creations, accounting transactions and interfaces/reports
• Created test events, scenarios and scripts to facilitate the execution of the business user’s acceptance test
• Created universe and reports using Business Objects to improve data availability for end users
• Coordinated with other business teams to select test data and ensure smooth end-to-end testing
• Mitigated risk by thoroughly testing the system to ensure business requirements are met and controls are in place
• Coordinated with the technical team to answer business requirement questions, make updates and resolve issues
• Assisted in other aspects of the business user’s acceptance test including processing different loan remittance type A/A, S/A, S/S and different loan products like “bi-weekly, daily simple interest, and adjustable rate type mortgages

COMPUTER SKILLS

Web Tools: FrontPage, Adobe Illustrator 8, Adobe PhotoShop 5.5, Adobe Premiere 5.1, Macromedia Director 7, Macromedia Dreamweaver 3, Macromedia Fireworks 3, Flash 4, Sound Forge XPv4.557., Webtrends

Languages: Visual Basic 6, VB Application, SQL, PL/SQL, HTML 4, DHTML, Java Script, and ASP

Databases: Ms Access, Oracle 8x

Tools: Ms Word, Ms Excel, Ms Power Point, Ms Visio, ERwin 4.0(Case Tool), Business Objects, Clear Quest, DOORS, Toad, SQL Developer

Operating Systems: Windows 95, Windows NT, Windows XP, Windows 7

Web Server: Microsoft IIS