SUMMARY:

• 7+ years of 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.
• 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. and some experience in commercial lending, including financial statement and cash flow analysis.
• Experience in creating reports from SAP modules using BO / 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.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, Data Stage, SSIS, SSRS

Data Modeling: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio

Databases: Oracle 9i, 10g, MS SQL Server, MS Access, Teradata

Operating Systems: Windows and UNIX, Sun Solaris, AIX, HP

Programming Languages: SQL, PL/SQL, Visual Basic, Net, Unix Shell Scripting, XML

Reporting Tools: Business Objects 5.0, Cognos 7.0 and Crystal Reports

WORK EXPERIENCE:

Confidential, San Antonio TX

Sr 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.
• 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.
• Interacted with 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.
• 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 modeling and produced data mapping and data definition documentation
• Used Trillium as a Data Cleansing tool to correct the data before loading into the staging area
• 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: MS 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, Erwin, Load Runner.

Confidential

Sr 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, Erwin, WebSphere, XML, Java, J2EE, JSP, RUP, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick Test Pro

Confidential, CT

Data Analyst

Responsibilities:

• Work with the Project Management in the creation of project estimates.
• Analysis of the data identifying source of data and data mappings of HCFG.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME's to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Performed data profiling activities by using Trillium & IDQ DQ tools to monitor point-to-point quality
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that the data elements and attributes are properly named,
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Involved in Creating and Testing the SSIS packages developed for security.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix / Tabular Reports, Charts and Graphs

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS 2005, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Informatica, Erwin

Confidential

Data Analyst

Responsibilities:

• Met Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• Worked closely with the claims processing team to obtain patterns in filing of fraudulent claims.
• Conducted JAD sessions to gather requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interacted with the SME's to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.
• Collaborated with data modelers, ETL developers in the creating the Data Functional Design documents.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Ensured that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Patterns were observed in fraudulent claims using text mining in R.

Environment: Oracle 10g, Sql-2008, Teradata, Microsoft Excel, Microstrategy, MS Visio, MS Project, Erwin, Informatica, SAS.

Confidential

Jr Analyst

Responsibilities:

• Translated and assembled business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Evolved the UML class diagrams for the proposed system using ER-Studio Software Architect.
• Executed data modeling using data modeling tool Embarcadero Data Architect.
• Created the data models for OLTP and Analytical systems.
• Implemented in depth data analysis on Oracle and Teradata systems.
• Experience in Teradata SQL Assistant and Toad.
• Engaged in data profiling to integrate the data from different sources.
• Experience in performing the gap analysis and impact analysis.
• Worked with SME, developer to gather database requirements, actively participated in functional requirement gathering, system requirement gathering, and application design.
• Assisted with DBAs on support needs and provide guidance on architectural issues.
• Worked with development teams with loading data, extracting data (ETL) etc.,
• Facilitated QA for developing test plans and test cases for Unit Testing, System Testing and Enterprise testing.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.

Environment: Oracle Database 10g, Teradata, Windows XP, TOAD, ER/Studio Data Architect, ER/Studio, JIRA.