SUMMARY

• 8 years of Industry experience as a Data Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications, Application Design.
• Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data ware house processes.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections. Training and some experience in commercial lending, including financial statement and cash flow analysis.
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Heavy experience with BI environment involving Cognos/Crystal Reports and production support.
• Sound Knowledge of data architecture concepts, data warehouse and data marts.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Strong knowledge on the Systems Development Life Cycle (SDLC), Rational Unified Process Methodology (RUP), RAD, SWOT, and CRM.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

• ERWIN
• ETL: Ascential Data Stage (7.x 6.x 5.x)
• Star - Schema Modeling
• Snowflake Modeling
• FACT and dimension tables
• Erwin 4.0
• Business Objects
• Micro strategy
• SAS
• Macros
• Erwin 4.x
• C/C++
• Java SE 1.4
• TURBO PASCAL 7.0
• VB.Net
• HTML
• Cognos
• COBOL
• SQL Server
• SOA
• SAP SD
• My SQL
• Agile/Scrum
• Oracle
• PL/SQL
• Visio
• Sybase ASA (6 - 9).ASP/ASP.net
• PHP
• Microprocessors 8085 & 8086
• Unix
• MVS
• MS Windows/95/98/NT/2000/XP
• MS DOS
• MS Office 2000

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Data Analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Worked on Business Intelligence tools like Cognos, Business Objects.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing,data modeling Websphere and Cognos.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Worked with key members from various cross-functional teams to analyze various third-party CRM solutions to make a ‘buy vs build’ decision. Conducted cost/benefit and impact analysis.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Worked on Business Intelligence tools like Cognos, Business Objects.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Worked on data modelling and produced data mapping and data definition documentation
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Cognos, Microsoft Visio, Documentum, Windows NT/XP, Oracle, PL/SQL, SQL, SQL Server, Sybase, SharePoint, UNIX, Agile/Scrum, C#. NET, Business Objects, Test Director, Load Runner.

Confidential, Norfolk, VA

Data Analyst

Responsibilities:

• Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
• Successfully managed the production support team for mortgage servicing application.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Execution of PL/SQL on oracle table in order to view successful transaction of data.
• Responsible for the data cleansing in Quick Base, as per the court orders.
• Validated the test data in DB2 tables on Mainframes and on Tera data using SQL queries.
• Documented the evaluation of various reporting tools like Cognos/Business Objects, made recommendations about the product depending on the reporting requirements.
• Developed small applications with Tera data at the backend.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Implemented Information Technology & Service Management (ITSM) and Information Technology & Information Systems Consulting (ITIS) along with TQM, Six Sigma, Business Process Management, Business Process Engineering, Business Process Re-engineering, CMM etc. to enhance the business process.
• Experience in Designing, Creating and maintaining the Universes, Business object reports, WEBI reports and Domains (Security, Universe, Document) in Business Objects.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel.
• Used Visual Basic Editor (VBE) for developing and testing Macros in Excel
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Data Stage, and creating ETL jobs in Data Stage.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Prepared system Test Plan and scenarios for Test Scripts.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: Rational Enterprise Suite (Rose, Clear Case, Clear Quest), RUP, Tera data, Visual Basic, SQL, SQL Server, Business Objects, Oracle, C#, PL/SQL, HTML, Unix, Agile/Scrum, MS Visio, MS Office, Cognos, Load Runner, Win Runner, DOORS

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Developed business process flows, Use Cases, and other documentation for expansion of Client’s MBS loan servicing, securitization, and trading model while coordinated with DevelopmentTeam in translating business requirements into design specifications for expansion ofloan securitization business.
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data modelling, Data Warehousing, Web sphere and Cognos.
• Involved in testing all the data elements in RSIs Mortgage Account Inquiry Service, which is called by CCW to obtain Mortgage loan data from MSP.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Performed Business Process Mapping and performed AS IS and TO BE analysis
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Responsible for executing Volume Testing, Compliance Testing, Data Quality Testing.
• Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Rational Clear Case,Doors, IBM WebSphere, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, MS Office, Agile, Cognos, SQL Server Reports, PL/SQL, Win Runner, Load Runner, Quick Test Pro

Confidential

Data Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Documented the evaluation of various reporting tools like Cognos/Business Objects, made recommendations about the product depending on the reporting requirements.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Managed the implementation of new hierarchy design into enterprise data warehouse(Teradata)
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Worked in mainframe environment and used SQL to query various reporting databases
• Created reports from SAP modules using Business Objects / Crystal Reports based upon business requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Rational Clear Case, Doors, Business Objects, UNIX, IBM Agile, WebSphere, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro