PROFESSIONAL SUMMARY:

• 7+ years of working experience in the Information Technology (IT) Industry as a Business Data Analyst in various domains like Financial, Telecommunication, Retail and Insurance.
• In depth understanding of SDLC methodologies like Waterfall, Agile (SCRUM) and RUP (rational unified process).
• Experience in coordinating with business and IT across all phases of software development life cycle (SDLC). Hand on experience on full life cycle of the project.
• Extensive experience on interaction with system users in gathering business requirements through user interviews, workshop and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Experience in creating Business Required Document (BRD), Functional Required Documents (FRD), and Functional Specification Document (FSD).
• Experience in Data Modeling using tools like ERwin, Toad Data Modeler.
• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
• Experience on creating Source to Target mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram (DFD). Working directly with ETL team for data extraction, Data Quality (DQ) team for validation.
• Worked closely with Data modelers and Architects extensively on Data Modeling and Data Migration.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, Slow Changing Dimension (SCD) Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Experienced in Manipulating, cleansing & processing data using Excel, Access and SQL.
• Worked with heterogeneous relational databases such as MS Access, Oracle, Teradata, DB2 and SQL Server.
• Experience in working third party tools like WinSQL and TOAD.
• Extensive experience in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).
• Experience in Data Profiling, Data Parsing, Data cleansing, and Data mapping.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Strong experience working in the data management team to maintain data quality by implementing different DQ validation rules and Strong experience in handling Exception data by creating a complete Workflow process for remediation.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Experience in providing Production Batch support.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS

Software/Hardware: Java, Microsoft .net (Visual Basic.net, C#.net), C++, Html, VB Script, Web Logic, SQL Server,MySQL,Oracle, Teradata, Db2,SQL, MS Office, MS Visio, MS Access, Firebird DB, Informatica, Microsoft Dynamic,Project Management(MS Project, ProjectLibre), MS Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, BROOKS, CA

SR.Businss Data Analyst

Responsibilities:

• Requirement Scoping and analyzing high priority requirement for implementation of the proposed system.
• Involved in defining the business requirement through user interviews, meeting with SMEs and the stakeholders and re-defining the scope as necessary.
• Perform the cost benefit analysis to present it to the stakeholders and to emphasize on thenecessity of the project.
• Assisted PM team to define the task and to allocate the right person under each task.
• Involved in writing the Business Required Document (BRD) clarifying all the requirement as needed by the business along with the functional/non-functional requirement (FRD) that are associated to each business requirement.
• Assisted PM in creating project plans, taking into consideration projects mission, process flow and timelines
• Prepare Functional Specification Document (FSD) to send it to various LOBs for data sourcing.
• Worked closely with the Data Architect team to develop the data model of the staging layer.
• Prepare a Data Flow Diagram (DFD) working closely with the ETL development team.
• Involvement in data management tasks like exceptional data handling, writing rules for maintaining the data quality and data integrity to be applied in the ETL codes before landing the data in the staging layer.
• Create template for source to target mapping document in excel spreadsheet and also included functionality to help PM to get reports on the progress on the mapping.
• Createsource to target data mapping documents between the source database Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.
• Prepared data mapping excel sheets.
• Conducted economic and financial analysis to identify business trends and development opportunities.
• Involved in variety of reporting tools such as SQL and MS ACCESS for querying underlying database tables and resolved data issues.
• Extensive use of EXCEL PIVOT tables to run and analyze the result data set.
• Created spreadsheet reports and graphs from statistical analysis of customer data to help determine the highest priority for the sales teams to pursue selling to customers.
• Built and maintain Excel reports using VBA, formulas, and pivot tables.

Environment: SQL Server, SSIS, SSRS, MS-Visio, MS Project,Quality Center, Requisite Pro, Windows XP Professional, MS Access 2010, MS Excel, RUP, Requisite Pro

Confidential, TORRANCE, CA

SR. Business DATA ANALYST

Responsibilities:

• Involved in requirement gathering from the stakeholders and business users through periodic meetings and interviews to create a Business Required Document (BRD).
• Involved in Requirement Scoping and analyzing high priority requirement for implementation of the time entry / tracking application for the employees within Toyota Financial.
• Assisted PM in creating project plans, taking into consideration projects mission, process flow, timelines, and requirements and documented them.
• Worked with different teams within the project group for finalizing all the requirements via required sign offs and aligning task and allocating work hours to assist PM.
• Conduct JAD sessions with the Business Users and the application development team to prioritize both functional as well as non-functional requirements to fit into each sprint cycle for the front end application development team.
• Involved in writing the Functional Specification Document (FSD) to source the data as per required by the back end of the time entry application system.
• Involved in performing gap analysis on the existing legacy system versus the new system and close out the gaps by discussing with the SMEs.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams.
• Involved in testing the ETL codes which includes data quality validation as well as business logic transformation rules and log the issues.
• Worked with the development team as well testing team to remediate those issues based on the priority as per the project plan.
• Built and maintain Excel reports using VBA, formulas, and pivot tables.
• Creating and publishing a Project Charter Document.

Environment: Oracle, SQL, ALM,Rational Requisite Pro, MS-Visio, MS Project, MS Office, ETLInformatica Power

SR. DATA ANALYST / DATA MODELER

Confidential

Responsibilities

• Worked closely with the Project Manager in creating the process swim lane and also estimates for completion of the technical artifacts needed for development.
• Involved in creating an ER diagram, Conceptual Data Model and Physical Data Model for the enterprise data warehouse with Data Architects to build up subject area specific models.
• Worked with DBA’s to forward engineer the Physical Data Model to create a physical database, make changes on the data model as per the CRs, worked on the enhancement of the model to support the changes in the business requirements.
• Verified and validated data model structure and E-R modeling with all related entities and relationship with each entity based on the rules using Erwin as per the business requirements.
• Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Oracle Staging/Target Area.
• Worked closely in conjunction with the BTG team to get business requirement and source-to-target mapping clarifications.
• Provided pseudo code for ETL developers to reproduce the code, worked closely with Data Quality (DQ) team for data validation rules.
• UsedSQLto analyze the data from theOracleand MS SQL Server databases and provide the reports to the DQ team for data cleansing work.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Extensively usedInformatica Debuggerto validate maps and to gain troubleshooting information about data and error conditions.
• Actively participated inSystem testing,integration testingand unit testing as per required.
• Involved in writing SQL queries on the source and the target database for validating the UAT test cases.

Confidential, AZ

Business DATA ANALYST

• Performed data analysis, data extraction, data compilation, and reporting tasks using complex SQL queries against oracle database using toad.
• Worked in identifying the source and target tables and creating source-to-target mapping documents capturing all the requirements to provide it to ETL developers for writing codes.
• Involved in performing Dependency Analysis to set up the process in line.
• Involved in checking and validating data in the Mapping document running the queries on Oracle using SQL developer before sending it for system testing.
• Documented and maintained RTM (Requirement Traceability Matrix) to ensure that all requirements are traceable from top to bottom, hence provide a basis for test plan.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation using MS Excel (features such as pivot tables andV-Lookups).
• Worked closely with Data modelers’ to define entities and attributes in a Logical data model.
• Modified the existing mapping template to a more clear and easy to understand template with additional functionality to do reporting from the managerial perspective.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Performed Data alignment and Data cleansing.
• Drive the issue handling meeting by creating tickets on the existing issues captured by the testing team, provide ad hoc queries as per their requirement and do analysis to remediate the issue.
• Organized and conducted cross-functional meetings to ensure linearity of the phase approach.
• Collaborated with a team of Business Analysts to ascertain capture of all requirements.
• Managed and exceeded counterparts’ and leaderships’ expectations.
• Worked on analyzing the data statistically and also prepared statistical reports using SAS tool.
• Worked closely with the data architect to resolve the referential integrity problems.
• Delivered the artifacts within the restricted time lines and excelled in the quality of deliverables.