PROFESSIONAL SUMMARY:

• Experienced Data Analyst/Business Analyst with 7+ years experience in IT, Banking and insurance industry.
• Adapt at analyzing and modeling business processes, requirements gathering and expectation management.
• Skilled at developing a deep understanding of an organizations business and culture and building collaborative environments receptive to views of divergent stakeholders.
• Experienced in data mapping, data modeling and collecting various data metrics for marketing, performance return of investments and customer - level engagement projects.
• Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications.
• Well versed in analyzing requirements, instilling changes in business processes and managing data flow in a project.
• Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
• Experience in full Software Development Life Cycle (Waterfall, Spiral, Agile Scrum implementation) and Project Management Life Cycle (PMLC).
• Strong experience in UML artifacts related to Business Modeling and Requirements, to support requirements Elicitation, Analysis, Specifications, Traceability, Validation, Verification and Requirement Management.
• Experienced in preparing Score Cards and metric reports using MS Access and MS Excel.
• Technical expertise in BI Reports, DW ETL, Data profiling, Data Cleansing, Data Integrity, Deference Data, Data Security and Data Quality Management.
• Worked with data validation, adhoc report, report validation using excel, VBA Macro, crystal Reports and Business Objects.
• Excellent SQL and PL/SQL skills for creating queries, procedures, database triggers to collect profile and scan data.
• Worked with Teradata, MS SQL Server, Oracle and MySQL database environment.
• Good analytical and communication skills and ability to work independently with minimal supervision vis- -vis contributing productively as a team member.
• Experienced in creating and review data models PDM using ErWin and ERstudio. And reverse engineering documentation and understanding the CDM using Visio.
• Extensively used HP QC for reviewing the data / data quality related issues that needed escalation to the governance team / steward.
• Actively used Requisite Pro to capture data requirements that helps improve scalability and traceability of application.
• Used configuration management tools like VSS, clear case and BMS
• Performed Data profiling and scanning for the data governance team to set the data quality criteria using rules engine

TECHNICAL SKILLS:

Operating Systems: UNIX, WINDOWS and LINUX

Databases & Tools: ORACLE, MySQL, MS SQL 2008, DB2, Teradata

Data warehouse ETL: Informatica, Data Stage, Ab Initio, SSIS

Reporting Tools: Crystal Reports, Hyperion 11x/Essbase, Planning, Oracle, OBIEE, Cognos

Languages: SQL, PL/SQL, XML, MS Excel, MS Word, MS Visio, MS Project,DB2,Toad

Quality Management: ALM/HP Quality Center, Jira

PROFESSIONAL EXPERIENCE:

Confidential, East Providence, RI

Sr. Data Analyst

Responsibilities:

• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked with Asset Class owners to validate the results and configuration.
• Mapped Data Lineage for various source system, right from data origination to results area.
• Worked with Market Risk and Operational Risk team which were part of a different initiative.
• Worked with Internal modeling team for data analysis and profiling.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed a Testing format to compare the data at different systems.
• Worked with Data governance and quality.
• 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.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Assessed Credit Risk strategies with various internal credit tools and implemented Basel II strategies to augment Credit availability.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Performed ETL Informatica development task s like creating jobs using different stages, debugging etc.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Gathered data from the legacy system (db2) to the present updated system using data warehouse tools such as Informatica
• Involved in strategic projects
• Performed extensive Requirement Analysis including data analysis and gap analysis
• Worked on data modeling and produced data mapping and data definition documentation
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system.
• Conducted JAD sessions to resolve critical issues
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio), Wireframes, Informatica, Oracle 11g, OBIE, IBM Mainframes, RUP, UML, SQL, SWOT analysis, Quality Center

Confidential, Pittsburgh, PA

Data Quality Anlyst

Responsibilities:

• Working closely with data mapping SME and QA team to understand the business rules for acceptable data quality standards.
• Performed data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Performed unit testing on transformation rules to ensure data moved correctly.
• 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.
• Creating and executing SQL queries to perform Data Integrity testing on an 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)
• Experience in designing complex Drill - Down & Drill-Through Reports using Business Objects.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Generate ad-hoc or management specific reports using SAS and Excel.
• Analysed the subscriber, provider, members and claim data to continuously scan and create authoritative master data.
• Assisted with validating hierarchies for data combination process.
• Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings and profiling results

Environment: SQL, PL/SQL, Oracle 11g/10g, ERWIN, Quality Center, ETL Informatica, Business Intelligence Business Objects, SQL Server, Teradata SQL Assistant, Excel, Visio, Erwin, UNIX and MDM

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Tested mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.
• Involved in testing the designing and development of data warehouse environment.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Extensively used SQL* loader to load data from flat files to the database tables.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Written PL/SQL procedure and functions to identify certain patterns in data and then to update the data as per business rules
• Tested database & UNIX Scripts needed to meet the system requirements.
• Optimizing SQL queries for better performance using Hints, Indexes and Explain Plan.
• Tested ETL mappings using Informatica to support the reporting data mart.
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed detailed System test plan including test procedures and test cases
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Developed test automation scripts for Regression and Performance testing
• Identified and resolved many application bugs and bottlenecks

Environment: Informatica Power Center 7.1, MS SQL server, Oracle 9i, T-SQL, UAT, QTP v5.5/6.5, Load Runner v6.5/7.8,Toad, SQL, PL/SQL, XML, XML Spy 2008, XSD, XPath, Stored Procedures, Test Director v7.6, VBScript, Crystal Reports, Teradata V2R5

Confidential, Chicago, IL

Data Quality Analyst

Responsibilities:

• Implementing logical and physical data modeling with STAR schema using Erwin in Data Mart.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases, test plans, test data and test scripts for customers.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Scheduled various mainframe nightly jobs using JCL.
• Production support for the monthly loads of data.
• Worked with testing business logic inside the Stored Procedures, function and packages.
• Extensively involved with backend testing. Performed SQL tuning to improve the performance of the queries.
• Executing complexSQLqueries to validate actual vs. expected results and to validate data from source to target.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Developed mapping for loading data from flat file to relational tables
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plans test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: Informatica Power Mart 5.1, Toad, Test Director, Visual Basic 6.0, UAT, Oracle 8i, Windows 2000, UNIX.