EXPERIENCE SUMMARY

• Adept at being a strong team player and have demonstrated strong performance on individual assignments.
• Expertise and understanding of various Software Development Life Cycle methodologies, 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 at creatingand maintaining Requirement Traceability Matrix (RTM) document, to ensure thorough requirements coverage against Use cases and Test cases.
• Proficient wif UML Diagrams such as creating Use Case diagrams, Sequence diagrams, Activity diagrams etc.
• Experience in performing GAP analysis, to identify the GAP between AS-IS and TO-BE states of the application/processes.
• Knowledge on Data warehousing concepts such as Data transformation, Data Mapping, Data Mart Modeling, Data Profiling etc.
• Expertise in coordinating wif cross functional teams, having developers, end users, testers etc., in assisting them wif requirements and technical design documents, information on project timelines.
• Expertise in testing phases through all the levels from developing test plans through test execution.
• Supported the QA team in system testing and participated in user acceptance testing.
• Coordinate wif off-shore teams, to delegate tasks and to ensure the assigned tasks are completed wifin the project timeline.
• Involved in writing SQL queries and test scripts for data validation, backend testing and data analysis.
• Skilled at facilitating JAD (Joint Application Development) and JRP (Joint Requirement Planning) sessions wif various user groups/stake holders by sending out meeting agenda, reference documents etc.
• Expert in broad range of technologies, including business process tools such as MS Excel, MS Access, MS PowerPoint, MS Visio (Microsoft Suite) and Testing tools.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows, Linux

Business Modeling Tools: ER Studio, Microsoft Visio, MS Office

Database and Tools: Oracle 10g/9i/8i, My SQL, TOAD, MS SQL Server, Teradata

BI Tools: Business Objects, Tableau, COGNOS, SSIS, SSMS

ETL Tool: Informatica Designer, Workflow, OBW

Methodologies: Rational Unified Process, Agile, Waterfall, RAD and Prototyping

Quality Management: HP-ALM(QC) Quick Test Professional, Win Runner

Other Tools: SharePoint, Lotus Notes, XML Spy

Others: ERP, CRM

PROFESSIONAL EXPERIENCE

Confidential - Fremont, CA

Business Data Analyst

Responsibilities:

• Led business requirements gathering effort wif business partners and internal/external Stakeholders.
• Interacted wif SOR teams to understand the technical specifications, transfer modes, frequencies, confidential fields etc.
• Validate the Data Model, Delta Report to CR & report the discrepancies/gaps to respective teams.
• Managed end to end coordination for Sample and Test data ensuring environment availability.
• Supported end to end UAT effort and customer queries against business application.
• Involved in release plan, scheduling timeline to align wif upstream and downstream teams.
• Managed testing time constraints efficiently and meeting the project deadlines.

Confidential - San Jose,

Business Data Analyst

Responsibilities:

• Performed BI and ETL Analyst role interfacing wif subject matter experts to understand and define the functional requirements supporting reporting applications by outlining data strategy and report specifications.
• Developed test plans and test cases to ensure dat requirements have been accurately addressed.
• Interpret the collected report's data by dissecting underlying SQL of the report.
• Interpret Informatica and OBW mapping data and make comparisons wif the planned activities.
• Led Requirement Validation effort to verify requirements, enhancements and modifications by populating FSD and getting Signoff from Stakeholders and Managers.
• Prepared detail Specific Data Requirement document wif required data elements to support Logical and Physical Data modeling sessions.

Confidential - San Leandro, CA

Business Data Analyst

Responsibilities:

• The System Data Stewards key activities for master reference data.
• Provided inputs and reviewing requirements to ensure the completeness of detailed requirements captured
• Reviewed relevant definitions and metadata for ensuring valid values finalized have taken into account all relevant applications/ systems

Confidential - Cupertino, CA

Functional Analyst

Responsibilities:

• Communicated well wif Business and Confidential IS&T team members, including SAP Basis, SAP BW and EDW Teradata development team.
• Analyzed issues faced by business and proposed solution to IS&T.
• Understand the technical solution and constraints faced by IS&T, communicate to Business.
• Performed data analysis pertinent to the business problem.
• Created test plan and executed test cases to ensure dat business requirements were met correctly.
• Developed Mapping between SAP PX4 >> SAP BW >> EDW Teradata Core and Semantic Layer
• Validated Data in UAT and Production environment between SAP and Teradata.