PROFESSIONAL SUMMARY:

• Over 8+ Years of combining expertise in data management, business analysis and project management. Proven ability in working with enterprise level large Data Warehouses, RDBMS systems, ETL and modeling tools/techniques.
• Oracle Database SQL certified, adept in leveraging SQL for data analysis and data validation.
• Strong team player and have demonstrated strong performance on individual assignments.
• Expertise various Software Development Life Cycle methodologies including Agile (Scrum), Waterfall and Rational Unified Process (RUP).
• Proven excellence in analyzing business processes, eliciting requirements, defining business needs and translating it to Business Requirement Document (BRD), Functional Requirement Document(FRD), Software Requirement Specification (SRS)/ Technical Requirement Documents, User Stories, Use - case Specification and Non-functional Requirements.
• Expertise in coordinating with cross functional teams, having developers, end users, testers etc., in assisting them with requirements and technical design documents, information on project timelines.
• Expertise at creating and maintaining Requirement Traceability Matrix (RTM) document, to ensure thorough requirements coverage against User Stories and Test cases.
• Experience in performing GAP analysis, to identify the GAP between AS-IS and TO-BE states of the application/processes.
• Expertise with Data Transformation, Data Mapping, Data Mart Modeling, Data Profiling etc.
• Supported conceptual, logical data modelling efforts, schema diagrams and have created data mapping documents.
• Developed and maintained source to target documents (STM) and interface control documents.
• Excellent working knowledge of Data Warehousing concepts including Metadata and Data Marts.
• Hands on experience in Data Modeling with experience in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables.
• Involved in writing complex SQL queries DDL and DML and test scripts for data validation, backend testing and data analysis.
• Skilled at facilitating JAD (Joint Application Development) and JRP (Joint Requirement Planning) sessions with various end- user groups/stake holders, Subject Matter Experts and development team by sending out meeting agenda, documents etc.
• Experience in writing test plans and in maintaining and executing test cases in Quality Center.
• Expertise in Functionality, Smoke, Ad-hoc, System and Regression Testing through all the levels from developing test plans through test execution.
• Supported the QA team in system testing and participated in user acceptance testing.
• Expertise working with off-shore teams, to delegate tasks and to ensure the assigned tasks are completed within the project timeline.
• Possess strong communication and presentation skills.

TECHNICAL SKILLS:

Modeling Languages: Rational Rose, MS Visio, Snagit9, UML

Languages: SQL(Certified),PLSQL, C,C++, Shell scripting, Python

Operating Systems: Windows Vista, XP,7,8,Unix

Databases: Oracle 8i, 9i, 10g,11g, MS SQL Server (2000, 2005, 2010), MS Access Oracle FMW SOA Suite 10g/11g - WebLogic 10.1.x, Oracle Application Server 10gBPEL, Mediator, Business Rules, Human Workflow, Adapters - DB Adapter, B2B adapter, JMS Adapter, File Adapter, FTP AdapterOracle Service Bus, Business Activity Monitoring

Microsoft Tools: MS Office, MS Outlook, MS Project, MS Visio

Project Management Tools: Clear Quest, Rational Requisite Pro, SharePoint, Quality CenterDOORS, Clear Case, Clear View, Jira

Reporting Tools: QlikView, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, South SFO, CA

Senior Data Analyst

Responsibilities:

• Performed data analysis of Oracle and Excel sources during analysis phase of the project.
• Performed analysis on existing MS Access model to understand the methodology of the forecasting model and help QlikView developers understand the requirements.
• Supported the end to end implementation of QlikMart, QlikView Forecasting tool and Qlik Dashboards.
• Developed and maintained various documents including test plans and test case documents.
• Worked with HP ALM to develop and maintain test cases and to communicate the identified bugs to development team.
• Scripted SQL queries on the source databases to analyze and validate the data required for the tool.
• Validated the data at QVD level, QlikMart level and Dashboards level of the 3-tier architecture of the tool using both Qlikview and Excel.
• Understand current and future data requirements from the business and work with cross-functional teams to document BRD and Tech spec.
• Documented STMs for both the projects SFDC publish & subscribe and Data migration.
• Enable developers build master data management capabilities to ensure data integrity for the organization’s analytical and operational needs.
• Identified data challenges and develops process improvements to address the issues.
• Analyzed various sources such as AMS, IMS, BOT, DEA, NPI, MEDPRO, SHS that provide the data for our MDM application to create base objects and to formulate match rules.
• Understand flow and usage of master data in consuming systems and business functions including flow of data to downstream SFDC applications.
• Facilitate error resolution with data coordinators and data owners through development and enforcement of data remediation processes.
• Analyzed and cleansed the data to migrate from old legacy system to new PACT system.
• Developed adHoc reports for the business and solution architects to enable the decision making for data cleansing and data migration processes.
• Created and developed scripts to extract the required data to create the initial universe for the PACT as well as FRMs.
• Developed scripts to provide data to the external data cleansers to enable their manual match and merge process after in-house automated self match is performed.
• Validated the data related to publish & subscribe jobs for the SFDC applications.
• Validated the data that is part of data migration process from legacy case management system to the new patient access management system.
• Developed and executed data quality checks to:
• Ensure that all and only the expected records appear
• Ensure that calculated values are correct
• Ensure that abnormal/edge cases are handled as expected
• Ensure that all values fall within expected range
• Check null value handling, etc.
• Developed the deployment documents for the publish & subscribe and data extraction process.

Environment: /Tools: MS Project/Visio, UML, Agile, Oracle 11g, MS Access 2013, Infa MDM 9.1, SFDC RealForce, Force.com explorer, TOAD, SQL,, Quality Center Microsoft Office, Agile, JIRA board, HPALM, Data warehouse, MDM, QlikView 11

Confidential - Mclean, VA

Senior Data Analyst

Responsibilities:

• Accountable for coordinating application scoping, planning, prioritization, build, test, implementation, and support transition.
• Provided business data analysis services for the Credit Loss Management division of Confidential .
• Performed requirements gathering and worked between cross functional groups for requirement clarifications.
• Performed functional analysis, proposed solutions for data requirement(s).
• Worked closely with business along with business analyst to put together master data attributes comprising of loan attributes, property attributes, workout attributes, liquidation attributes and servicer attributes.
• Organized meetings and presented story boards to ensure accurate comprehension of the existing situation is conveyed to different teams.
• Worked with cross-functional teams (SMEs, Developers, DBAs, Production Support).
• Participated in brainstorming sessions for conceptual and logical data modeling.
• Supported the end to end implementation of centralized Data Mart.
• Arranged meetings with end clients to gather all business reporting requirements.
• Functioned as a master data knowledge resource by helping the business understand master data.
• Worked as gatekeeper of master data standards - upholds master data standards by validating/normalizing/cleansing data to ensure adherence to business rules, naming conventions, abbreviations, etc.
• Worked closely with data stewards to resolve alerts.
• Experience with the different levels of master data layers and their purpose.
• Audited of all master data accounts to streamline business processes and procedures and ensure processes are followed accordingly.
• Prepared and maintained various documents including data mapping document, data definition documents and test case documents.
• Organized and actively participated in scrum meetings to track the progress of project, understand the concerns of ETL developers and DBAs.
• Scripted SQL queries on the source databases to analyze and validate data.
• Created adhoc and custom excel reports for business users.
• Acted in the capacity of a functional scope owner for NSO DM.
• Built and developed data flow diagrams and system context diagrams using Microsoft Visio.
• Analyzed Use cases from functional requirements, composed Use Case Specifications and designed business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams) in MS Visio.
• Communicated with stake holders, information architecture and technology teams conducting JRP sessions.
• Reviewed test plans and test cases during SIT and UAT and performed data validation for the reports developed.

Environment: /Tools: TFS, MS Project/Visio/Access, UML, Agile, Oracle 11g, Toad, SQL, Flash 4.0, Quality Center, Tableau

DataAnalyst

Responsibilities:

• Learning the existing student information system of MPS and their apps incorporated in the e-Discovery.
• Worked closely with the Executive level, specially the Chief Information Officer and IT Director by conducting weekly stand up meetings for delivering updates.
• Outlining the requirements for the target state which helps the server from overload by merging the apps that perform similar functions
• Examining the technical architecture of the application (excel based) and documenting them for preparing a report on all the apps MPS uses.
• Conducted JAD sessions with the application developers who worked on the development of in-house apps to understand their functionality
• Proposed a target state for the existing system by merging apps, killing un-used apps and shaping few other apps adding functionalities.
• Responsible for preparing data flow diagrams for all the in-house applications specially the core student- teacher app called Classroom for Success
• Analyzed the existing excel based applications and documented the underlying assumptions, source attributes, transformations and formulae used.
• Experience in handling change management e-helpdesk tickets for major app Classroom for Success.
• Worked closely with developers, SAP team for employee data and SSIS team of e-Discovery for Student Data.
• Documented reporting requirements.
• Analyzed the data of the Classroom for Success application and was involved in data profiling to examine statistics of the student attendance information.

Environment: /Tools: MS-EXCEL, .NET, MS-PROJECT, MS-OFFICE, SQL Server 2008, MS-Visio, Modified Waterfall.

Confidential, NY

Business Analyst

Responsibilities:

• Created & maintained data mapping templates and tracked the data lineage at various hops to ensure better data quality across various systems.
• Facilitated and resolved outstanding issues with business, audit and technical team.
• Created flow diagrams for easier understanding of the data flow between various systems, for the team to it.
• Followed & maintained Meta data standards set by the data governance team.
• Performed data mining and data profiling on source data to make sure that data is accurate for our reporting needs.
• Created standard codes in dimension tables as per the guidelines of Data Governance team.
• Tracked all changes (data lineage) for the existing codes that had a high risk and priority set by the Data Steward and Governance council teams.
• Assessed data repositories for compliance with data governance policies and standards. Worked with all areas of the business to ensure data quality and integrity.
• Experienced in working with semi-structured and/or unstructured data and data repositories used for data mining.
• Complied with enterprise data governance strategies to achieve organization s business strategy and objectives.
• Participated and answered questions raised by SMEs in the deep dive sessions.
• Supported ad-hoc requests from a variety of sources.
• Actively participated and suggested changes to the KBE tracker tool as and when needed to in corporate changes to support our business process.
• Took ownership of the modules to deliver high quality deliverables.
• Delivered the source to target mapping for assigned systems before deadline.
• Wrote SQL queries to perform data quality checks, to know the domain of values and to determine reasonableness conditions for the fields that were getting mapped.

Environment: /Tools: Requirements Analysis, UML, RUP, Use Case Analysis, MS Visio, Rational Rose, Requisite pro, Oracle DB, SQL, Informatica, .Net, PeopleSoft CRM, CRYSTAL, SIEBLE, CMMI Standards.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Worked as Business analyst in Global Outsourcing RealTrans and Fulfillment departments, Generating client reports for clients like Funding America, First America, Credit Suisse etc
• Generating various reports that help in measuring the operational efficiency of the product & various departments e.g. Underwriting, Closing, etc.
• Generating SBU client billing per contract terms on a monthly basis to include reconciliation to Ocwen and client systems.
• Coordinating with the client in case of direction & support
• Preparing daily & monthly MIS reports.
• Understanding client requirements, documentation & PPT presentation
• Experienced in development of test cases for Business Integration, system integration and user acceptance Testing.
• Testing the new CR’s for the customer requirements or functionality.
• Attending daily & weekly Status call with clients
• Attending conference calls with clients for any clarifications and discussions
• Interacting with Project Manager consistently to meet the business requirements
• Conducted meetings, interviews and JAD sessions with SMEs, business users and stakeholders to understand their business process and elicit requirements
• Worked with Development & supported them in testing
• Understanding of SLA’S, accomplishing & communicating them to associates.
• Credit reporting, analysis on delinquent mortgages etc.
• Handling Outward Assignment- for Default loan servicing.
• Handling pre-underwriting: Data Integrity, Property Appraisal, Compliance
• Giving online to broker, vendor and appraiser as and when required

Environment: /Tools: MS Visio, MS Excel, MS word, Access, SQL, Citrix, RealTrans app etc.

Confidential

Jr. Business Analyst

Responsibilities:

• Supported various web application and middleware development related testing efforts that were outsourced to offshore team.
• Involved in all phases of software development life cycle for this project, which used Waterfall.
• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Coordinate with the front end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Involved in writing PLSQL procedures, functions, triggers, and packages for new requirements.
• Developed Informatica Mappings using various Transformations and packages to extract, transformation and loading of data.
• Involved in large and complex data conversion from the existing system to the new system which did help End-Users to use both old and new systems and helped in the development of new system that replicates the old system as is.
• Read data from flat files and uploading that data into oracle tables using SQL*loader.
• Involved in the production support and solved the tickets that are raised by the end users.
• Involved to prepare user level and system level maintenance documentation.

Environment: /Tools: Oracle 10g, PL/SQL, MS Office Suite, UNIX, SQL Loader, Toad, WPF/.NET framework, HTML, Quality Center