PROFESSIONAL SUMMARY:

• Data Analyst with 7 Plus years of experience in various domains of the Financial Industry including online banking, mortgage and loan, credit card, investment banking and retail banking.
• Experience working in all phases of Software Development Life Cycle (SDLC) using methodologies like Waterfall, Agile Scrum and Rapid Unified Process (RUP).
• Solid understanding of system analysis, design, development, and testing client server applications.
• Proficient in all facets of Business Analysis, Data Analysis, Business Process Modeling, and Use Case development.
• Experience in organizing and conducting JAD sessions with product owners, SMEs, stakeholders and end users to elicit and analyze business requirements and functional specifications. 
• Experience in capturing, organizing and prioritizing requirements using IBM Requisite Pro, IBM Doors, and MS Office suite.
• Competent in grooming the product backlog and writing user stories along with detailed acceptance criteria for Agile Scrum projects.
• Proficient in creating Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams using MS Visio and MS Word.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data ware housing, reporting and querying tools, Data mining and Spreadsheets.
• Worked extensively in Data consolidation.
• Worked closely with Data modelers and Architects extensively on Data Modelling and Data Migration.
• Experience in Data Transformation, Metadata, Data Dictionary, Data Loading, Modelling and Performance Tuning.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Experience in software prototyping using UI mockups and wireframes for requirement visualization to improve development process and user experience.
• Extensive experience conducting GAP analysis and managing the development of technical specifications.
• Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications.
• Well versed in analysing requirements, instilling changes in business processes and managing dataflow in a project.
• Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
• Generating weekly and daily reports using and Tableau and exporting to Excel and Access reports.
• Experience with data mapping, querying the source and target tables in the database using SQL for testing purposes.
• Experience using pivot tables and VLOOKUP function for analysing and generating reports.
• Extensive knowledge in performing User Acceptance Testing (UAT), writing test cases and documenting test results while working along with the QA team.
• Experience working in collaborative cross-functional teams including offshore teams.
• Excellent team player with ability to work independently along with strong analytical and communication skills.

TECHNICAL SKILLS:

Programming languages: Java, C#, SQL, PL/SQL, HTML, CSS, XML, JSON, JavaScript 

Databases: Oracle, SQL Server, MS Access, Teradata

Data Modeling: MS Visio, ER Studio, ERWIN

Methodologies & Frameworks: Agile/Scrum, ATDD, BDD, TDD & Water Fall Model

Web Servers: TESTING SOAP UI

Operating Systems: UNIX, Linux, Windows, Mac, IOS, Android

PROFESSIONAL EXPERIENCE:

Confidential, NC

ETL Data Analyst

Responsibilities: 

• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results. 
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution 
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Researched and fixed data issues pointed out by QA team during regression tests.
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Created Tableau views with complex calculations and hierarchies making it possible to analyze and obtain insights into large data sets.
• Creating and executing SQL queries to perform Data Integrity testing on a Teradata Database to validate and test data using TOAD.
• Worked with data architects team to make appropriate changes to the data models.
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Worked with the data governance team to ensure the data quality of compliance reports for EDI transactions.
• Utilized Tableau server to publish and share the reports with the business users.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Tested the data using the Logs generated after loading the data into Data warehouse. Prepared Traceability Matrix with requirements and test cases.
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Worked extensively in Data consolidation and harmonization and T-SQL environment to run out the queries and explore the Databases.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling, Used Informatica / SSIS to extract, transform &load data from SQL Server to Oracle databases.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data. 

Environment: MS-Office Suite (Word, Power Point, Excel), MS Visio, Rally, Windows 7, Java, Quality Center 10.0, SharePoint 2010, TOAD, Oracle

Confidential, Houston, TX

Data Analyst

Responsibilities:

• Met with 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.
• 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.
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyse ed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system.
• Analysed, created and formatted the Reports as per Business Requirements.
• Analysed and created various adhoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy.
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements.
• Analysis of the data identifying source of data and data mappings of BHC.
• 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.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Created and maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements and Documented requirements in a Software Requirements Specification document

Environments: Oracle 10g, Windows, MS Visio, MS Project, Informatica.

Confidential, Leeds, UK

Data Analyst

Responsibilities:

• Understanding and analyzing the requirements from SRS (System requirement Specification) document and identifying the new functionalities and changes in the existing functionalities. 
• Think Finance is a leading regional bank providing full spectrum of financial services. This project supported home financing and account management systems. The project resulted in an end-to-end integration of Mortgage Industry Standard Management Organization (MISMO) standard with the Loan origination processing system for efficient loan application process and data storage.
• Actively involved in all phases of the Software Development Life Cycle. Our team followed the Waterfall methodology in this project
• Involved in gathering requirements, analysis, documentation, maintenance, management, prototyping, and coordination between the business owner and the technical team.
• Conducted several JAD sessions with stakeholders and technical staff to elicit Functional and Nonfunctional Requirements and sent out meeting minutes to all parties involved.
• Produced artifacts such as BRDs, FRDs, and Use Case documents using MS Excel and Visio for documenting system requirements.
• Involved in Logical modeling by converting requirements into models to create process flow diagrams in order to clarify complex requirements for both business owners and the development team.
• Created Requirement Traceability Matrix (RTM) document for developers and QA team.
• Performed select queries and table joins using SQL and exported data to excel for formatting and report generation.
• Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Mined data from complex perspectives and summarized it into Excel.
• Performed report optimization and analysis using pivot tables and V-lookup function.
• Used PowerPoint to create presentations for the management team.
• Created and maintained the Data Mapping and Data Requirement documents.
• Experience using Soap UI Pro for testing web services.
• Developed and documented Test Cases and executed them in a web environment. Also reported any bugs by logging them into Quality Center 

Environment: MS-Word, MS-Excel, MS- PowerPoint, MS-Visio, IBM Rational Requisite Pro, Windows 7, Quality Center 10.0, SQL, SharePoint 2010, Soap UI

Confidential, Leeds, UK

Data Analyst

Responsibilities:

• Involved in application support to analyze and fix data correction issues in live database by interacting directly with various clients.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications. 
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for different Data mapping activities from Source systems to Teradata 
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Executed campaign based on customer requirements 
• Followed company code standardization rule. 
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc 
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata. 

Environment: Informatica, Power Center 8.1, XML, Win SQL, Windows NT 4.0, Teradata, TOAD, Crystal Reports, Oracle 9i, PL/SQL, DB2, BO Reporting Tool

Confidential

Data Analyst

Responsibilities:

• Involved in application support to analyze and fix data correction issues in live database by interacting directly with various clients.
• Worked in all phases of the Software Development Life Cycle implementing Rapid Unified Process (RUP) methodology 
• Primarily involved in gathering requirements, analysis, documentation, follow-ups, reporting and coordinating between the business owners and the technical team. 
• Worked closely with the project manager to identify the scope of the project, interpret business needs, and develop a project plan.
• Facilitated JAD sessions and interviews with SMEs to gather Functional and Non-Functional system requirements.
• Performed Gap analysis between "As-Is" model of the legacy system and "To-Be" model to identify the business needs.
• Gathered business requirements and created Project Scope Documents, Epics, BRDs, FRDs, ER diagrams, and Use Cases using MS Word and MS Visio 
• Created process flow diagram to illustrate and review the system details 
• Generated the Requirement Traceability Matrix 
• (RTM) for the developers and tester to ensure requirements were traceable throughout the development process.
• Performed report validation writing SQL queries using TOAD with the oracle database and perform data validation.
• Experience using Vision Plus (CDM, CMS module) to manage insurance card transactions.
• Involved in developing and executing Test Cases as a part of the UAT team.

Environment: Environment: MS-Word, MS-Excel, MS- PowerPoint, MS-Visio, IBM Rational Requisite Pro, Windows, Quality Center, SQL, TOAD, Oracle