SUMMARY:

• 5+ years of Experience in Data analysis, Data Modeling, Business Analyst, Quality Assurance and Testing in different customer environments and platforms.
• Proficient in SQL, experience in Performance Tuning of SQL and Stored Procedures and exposure to PL/SQL coding.
• Writing complex SQL queries in T - SQL and PL/SQL joining multiple tables across schemas, self-referencing joins and correlated sub-queries
• Validated and informed the technical design through data analysis across multiple layers of data warehouses, source systems and B2B channels.
• Extensive experience in handling different feed files like XML, Flat files and fixed length files.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams.
• Experience in Data Warehouse applications using ETL tools like Informatica, Data Stage and SSIS.
• Experience in creating data visualizations using work books and dash boards in tools like TABLEAU.
• Well versed with various types Software Development methodologies- Waterfall, Agile, and Iterative.
• Experienced in conducting JAD sessions and creating data blue print and mapping document based on business rules.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, AB Initio and SSIS ETL tools.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution
• Extensive experience in Functional testing, Integration/System testing, Regression testing, creating regression test suites and User Acceptance testing.
• Excellent Experience in preparing Test Plan, Test cases and RTM.
• Experience in Data Analysis and Data Profiling using SQL Server and SAS tools and Root Cause Analysis (RCA) on the defects.
• Extensive experience in Confidential Quality Center, ALM for maintaining requirements, RTMs, executing test scripts and defect tracking purposes.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Experienced in source data quality analysis, defining of quality criteria and data governance.

SKILLS:

Data Warehousing: Informatica 9.x, SSIS, DataStage

Data Modeling: Data Warehousing and ETL concepts, Star-Schema Modeling, Snowflake-Schema Modeling

Testing Tools: Confidential ALM, Jira

RDBMS: Oracle 10g/9i, MS SQL Server 2005/2008

Programming: UNIX, SQL, PL/SQL, Java, VB Script

BI/ Reporting: SSIS, SSRS, Business Objects, SAS ODS, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Fort Collins, CO

BI/Data Analyst

Responsibilities:

• Worked closely with Business users and SMEs to resolve conflicting scenarios and create the mapping document.
• Extensively involved with dataquality anddatagovernancesolutions including platforms and supportingdataprocesses
• Have tested SSIS packages according to business requirements and data mapping requirement documents.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created daily and monthly reports using SQL and UNIX for Business Analysis.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SAS enterprise guide for loading data from excel, csv and text files into SAS data sets and then into Teradata tables.
• Worked on loading data from flat files to Teradata tables using SAS Proc import, Export and Fast Load Techniques.
• Created SAS queries to compare Teradata and Oracle sources and performed analysis on the results.
• Reviewed test data and scenarios for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• After requirement gathering on new tables I did support Data Architect and Data Modeler for Designing Dimension tables / Fact tables for MDM using ERWIN Data Modeler Tool.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Performed adhoc testing on several complex reports generated by SAS including Dashboard, Summary Reports, Master Detailed, Drill Down.
• Performed data testing for ETL to compare Source and Target database systems there by identified requirement gaps to reduce business risk ahead.
• Create Test design estimations timeline based on reviewed scope.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Created and tracked the RTM to ensure 100% dev and test coverage.
• Created SAS Reports and Data centric tests for to satisfy business in testing SQL server environments
• Validate data loads in Pre-prod/UAT environment before deployment to Users
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results. Experience in creating UNIX scripts for file transfer and file validation.
• Created reports and data visualizations using dashboards in TABLEAU
• Co-ordinate with the team to ensure and track total quality deliverables to satisfy business need.

Environment: ETL Informatica 9.x,SQL Server 2012, SSIS, SQL, PL/SQL, Windows XP, SAS, MS Office Suite, SAS, Confidential ALM 12, Cognos 10, Tableau 9.3, SQL Server reporting Services (SSRS), XML, SQL ASSISTANT-TERADATA V2R6, SQL Server Management Studio.

Confidential, NY

BI/Data Analyst

Responsibilities:

• Created Mapping Documents formula and rule engine.
• Involved in Logical and Physical modeling of various Data marts as well as data warehouse
• Analyzing change request for the existing mapping and creating an impact analysis for the change on Data
• Writing new mappings specification according to the business data requirements
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Involved in completing data testing before the UAT.
• Created SQL queries and database triggers for state mandated reports and data elements.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in validating SSIS and SSRS packages according to functional requirements
• Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints
• Shared lessons learnt from the DQ analysis to the data governance team.

Environment: ALM 11, DataStage, SSIS, Agile, Java, .NET, XML, HTML, SAS, Windows and Unix, Shell Scripting, SQL, PL/SQL, TOAD for Oracle 9.1, Oracle 10g, MS Office, COGNOS, TABLEAU 9.3.

Confidential, Dallas, TX

BI/Data Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collaborate with data modelers, ETL developers in the creating the Data mapping document.
• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Involved in Testing SSIS Packages, and also involved in Data Migration.
• Used SWIFT messaging system to test the flow of messages from and into the new system and was involved in ETL process
• Suggested the data formats on the front-end screen to ensure its compatibility with SWIFT format
• Extensively used Teradata Advanced Techniques in writing the scripts
• Assisted design logical models (relationship, cardinality, attributes, candidate keys) as per business requirements using Erwin Data Modeler.
• Generated flat files using the Teradata Export for the Segmentation process
• Designed and implemented SQL queries for QA testing;
• Coordinated with the QA Offshore team for testing activities across multiple systems and managed test execution.
• Participated in QA Team meetings and bug tracking meetings
• Provided testing results and weekly status reports to the QA Manager
• Tested Performance & Accuracy related queries under SQL Server
• Created relationships in Requirement Traceability Matrix linking Business Requirements / Mapping document to test case design document.
• Configured the Data mapping between Oracle and SQL Server 2008

Environment: Microsoft Office Suite, SSIS, Microsoft Visio, Windows NT/XP, Oracle, SQL, SAS, SQL Server, Teradata, VBScript, UNIX, Business Objects.