SUMMARY

• Over 10 years of experience in Financial and banking industry with good understanding of mortgage banking products.
• Over 8 years of working experience in software development, data management and analysis with an emphasis on problem solving.
• Strong analytical and writing skills to augment solid experience in writing functional and technical specifications, test plans, project plans, reviewing test cases, and manual testing.
• Outstanding organizational skills, superior analytical capabilities, attention to detail, and strong communication skills.
• Experience in defining analytical approaches for projects and applying a range of analytical tools to synthesize insights and develop solutions
• Experience in preparing a broad variety of reports and provided data and management information for clients, internal and/or external audience. Created automated, standardized reports using SQL and SAS.
• Good Understanding of project management methodology and the project life - cycle, business needs and, processes of the client.
• Experience in Release Management
• Experience in writing Gherkin test scenarios
• Experience in full development cycle of a Data Warehousing, including requirements gathering, design implementation and maintenance.

TECHNICAL SKILLS

GUI tools: Oracle APEX, Oracle forms 5.0, Visual Basic 6.0, ASP, MS ACCESS 7.0, Word, Excel

Database: Oracle, 11g, MS Access 1.1. DB2, Teradata

Design tools: Visio

Languages: PL/SQL, Assembler language, DBASE, HTML, Java, VB script 6.0.

Platforms: IBM PC, SUN SOLARIS.

Operating systems: MSDOS 5.0, Windows 98, Windows NT4.0, Windows XP, SUN OS 5.5.1.

PC skills: MS Excel, Word, PowerPoint, Visio, MS Access

Data Warehousing: Informatica Power Center 10.1.1(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Worklet Designer, Task Developer, Workflow Monitor) ETL, Data Mart, OLAP, Star Schema, Snowflake Schema, OLTP, SQL.

Reporting Tools: Business Objects, Cognos, Tableau, and Toad

SDLC Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential

Responsibilities:

• Responsible for understanding various processes and data streams that amass information from a number of sources into centralized databases. Requires ability to support changes to these processes as driven by business needs.
• Work with IT support team to define business requirements
• Work with the offshore vendor teams (such as TCS or others) on requirements documentation, functional design,
• Proactively validate conflicting or unclear inputs from business teams and technical
• Perform UAT End to End Testing of the Data Mart
• Create and Document ETL Test Plans, Test Cases, and Test Scripts.
• Test the data whether the data is as per the data model and Mapping Documents. Monitor workflow for loads.
• Interact with solution to validate current system design, and how proposed solutions affect that design in order to fulfill stated requirements

Environment: Oracle 11g, Oracle SQL Developer 1.5.5, Informatica Power Center 10.1.1, Project and Portfolio Management Center (PPM)

Confidential

Business Analyst

Responsibilities:

• Worked with business partners to validate, clarify, and normalize business requirements
• Worked with business partners to review and implement business requirements through the Agile methodology in an agile scrum environment.Created High level documents and Technical specifications
• Worked within and interface with Business, QA, and Application Development teams
• Interact with solution to validate current system design, and how proposed solutions affect that design in order to fulfill stated requirements
• Wrote test scenario in Gherkin for QA to run the test script in Cucumber.
• Worked as a change management lead, collaborated with development, testing, and release managers
• Coordinated with multiple teams and projects to determine the critical path of tasks within a release event (risks, dependencies, issue resolution etc)

Environment: Agile, Oracle 11g, RSAM, EPV, Application Life Cycle Management, ITSM.

Confidential

Project Manager

Responsibilities:

• Provided summarized complex business problems and detailed analysis with precision and a focus on problem solving.
• Worked with business partners to review and implement business requirements through the Agile methodology in an agile scrum environment.Created High level documents and Technical specifications.
• Worked on the technical elements of each change with Business Process Analyst, IT teams and testing teams to ensure the design is feasible, business and user goals are met and test plans/scripts are complete before promoting changes to production.
• Impact analysis of client requests and implementation options against application/product roadmap.
• Led high level business initiatives and assist with all levels of metrics reporting and demonstrate proficiency in accessing multiple systems, platforms, applications, and data repositories in various data environments.
• SME of Mortgage Express Applications (Onbase and MPX applications) for configuration related activities and provide visibility and options after research of all configuration items.

Environment: Agile, MPX and OnBase Loan Origination System application.

Confidential

Business Analyst

Responsibilities:

• Handled overall management of various projects in flight within the default department from designing phase to implementation phase.
• Capability of translating business process definitions and requirements into technical specifications ensuring traceability to business requirements and expected out comes.
• Worked closely with the business to analyze their requirements and review/produce specifications in order to design/build reports/applications according to management specs.
• Demonstrated track record for delivering multiple, complex technical projects on time/within budget.
• Solely responsible for designing and developing an online backup application for MSP (Mortgage Servicing System) for Chase Home Finance Centers.
• Created daily/ weekly/ monthly quality reporting process and data administration

Environment: Oracle Apex 3.1.1.2, 4.2, Toad 11.1.0, INFO1, Teradata.

Programmer Analyst

Confidential, Columbus, OH

Responsibilities:

• Responsible for Application development, process development, quality management and testing to ensure compliance with project requirements.
• Developed applications to automate the mortgage system for Call Center and Customer Care Research.
• Worked closely with the business to analyze business requirements and review/produce specification for any new /changes to technology applications.
• Developed Apex applications to monitor, track and report project milestones and timeline.
• Analyzed the process for the mapping of Mortgage Tables into MSP.
• Wrote and Executed Test Scripts and Test cases for database objects in Quality Center
• Served as a Subject Matter Expert on MSP and Mass Trans (Voyager Project)..
• Coordinated with offshore Passport team of Mass Trans for WAMU loans.

Environment: Oracle Apex 3.1.1.2, Toad 8.4.7, Fidelity Lending Portal/MSP Director Scripting, MSP Passport 7.2.3, CPI Navigator 1.2, Mercury Quality Center 9.2., INFO1.

Data warehouse Developer

Confidential, Columbus, OH

Responsibilities:

• Designed the mapping templates for Extraction, Merge, Transform and Enterprise Data Warehouse. Simplified the development and maintenance of ETL by creating re-usable Sources, Targets, Mapplets, and Transformation objects.
• Developed mapping documentations for jobs from flat file, Oracle sources to Oracle targets and downstream processes.
• Developed complex Informatica mappings, mapplets, and transformations using various active and passive transformation options.
• Used Power Center Workflow Manager to create sessions and tasks like session, event wait, event raise, email to run with the logic embedded in the mappings. Partitioned the sessions to reduce the load time. Export of Informatica objects into XML files.
• Knowledge of Star and Snowflake schema, dimensional data modeling, fact and dimensional tables & slowly changing dimensions.

Environment: Informatica Power Center 6.2 Designer, Workflow Manager, Workflow Monitor, Oracle 8i, UNIX Shell Scripting, SQL, PL/SQL, Windows XP.