We provide IT Staff Augmentation Services!

Bi/etl/olap Tester Resume Profile

Omaha, NE

SUMMARY:

  • 7 years as of experience in Design, Testing, Development Support of MS SQL Servers 2008/2005/2000/7.0 oracle 9i/10g.
  • Experienced in testing ETL/BI applications.
  • Wrote complex SQL and MDX queries for
  • Expert in Data Migration from SQL Server 2000 to Oracle 10g.
  • Experienced in Upgrading from SQL server 7.0 to SQL server 2000/2005.
  • Experience in Data Migration, Database Transferring and related objects in SQL Server from one server into other Remote servers.
  • Experienced in creating the SSIS packages, DTS packages.
  • Experience in SQL Server Reporting Services SSRS 2008/2005/2000, installation, configuration, administration and maintenance.
  • Worked in various Healthcare areas like Enrollment, Benefits, Claims, Medicare, and EDI X12 etc. Experience in Healthcare concepts such as HIPAA, SOX etc.
  • Worked on various EDI X12 transaction sets 837 I/P, 275/276, 270/271, 834 etc
  • Experience as Business/Systems Analyst with expertise in Insurance, Healthcare processes, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.
  • Experienced in developing database packages, functions, procedures views.
  • Experienced in developing the data mapping document for both SQL Server Oracle data migration needs.
  • Experienced in installation, configuration of MS SQL Server 2000, 2005, 2008.
  • Designed and Developed OLAP Cubes using SSAS.
  • Experienced in Database Backup, Recovery and Disaster Recovery procedures.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
  • Proficient in troubleshooting database issues and Experienced in using performance Monitor/profiler to solve dead locks/ long running queries
  • Designed various Dimensional models and also Fact table, Star Schema, Virtual dimensions.
  • Experience in Online Analytical Processing OLAP techniques
  • Experienced in physical and logical data modeling by using Erwin
  • Rich Development Experience in DDL, Complex and Efficient Queries, Tables, Indexes, Stored Procedures, Function, Triggers and maintaining referential integrity, DTS Packages/SSIS Packages and SQL Jobs.
  • Experience in RDBMS Programming Microsoft SQL Server T-SQL , Oracle PL/SQL , MS Access and associated SQL Programming Knowledge.

Technical Skills:

Data Warehousing: Informatica 8.6.1/8.1/7.x, Ab Initio CO>OP 2.15, GDE 1.15, Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite, Crystal Reports

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension

tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center 10.0

RDBMS: Oracle 9i/8i/7.x, MS SQL Server 6.5/7.0, 2000, UDB DB2, Sybase, SQL Server

12.0/11.x, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL Plus,

PL/SQL, TOAD, C

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

PROFESSIONAL EXPERIENCE

Confidential

BI/ETL/OLAP Tester

Responsibilities:

  • Wrote VBScripts to update the data in SQL tables using the data in ORACLE tables, moving files from one server to other.
  • Wrote Scripts, Cursors and Stored Procedures to Update and Insert data into SQL and ORACLE Tables.
  • Developed Test Plan, Test Strategy for ETL and BI applications.
  • Developed the traceability matrix to cover every requirement and every test case.
  • Worked with several ETL sources including Flat Files, XML Files, CSV Files SQL Server
  • Written complex SQL queries for validating the data across different sources and targets.
  • Extensively worked on designing various output and management reports Using SQL Server Reporting Services SSRS .
  • Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate various tables.
  • Migrated DTS packages from SQL Server 2000 to SSIS in SQL 2008.
  • Validating data after loading into the target databases.
  • I was responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target
  • Identify the primary key logical / physical and put update or insert logic
  • Involved in implementation of HIPAA EDI Transactions 835,837,820,276
  • Facilitated Electronic Data Interchange.
  • Performed GAP Analysis for HIPAA 4010 and 5010 transactions.
  • Deleting the target data before processing based on logical or physical primary key
  • Design and execute the test cases on the application as per company standards
  • Responsible for monitoring data for porting to current versions.
  • Involved in testing procedures, functions, packages and triggers as a part of backend testing using Toad.
  • Preventing occurrences of multiple runs by flagging processed dates
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags
  • Interacting with senior peers or subject matter experts to learn more about the data
  • Identifying duplicate records in the staging area before data gets processed
  • Extensively written test scripts for back-end validations and Ensured that the mappings are correct
  • Write SQL queries to validate that actual test results match with expected results
  • Check the naming standards, data integrity and referential integrity.

Environment: SQL, T-SQL, SSRS, SSIS/DTS, HIPAA/ EDI X12, SQL Server 2000/2005/2008, XML, XSLT, XML Spy 2008, Test Plan, Test Cases, Oracle 9i/10g, Stored Procedures, PL/SQL, Windows Server 2003,VB Script

Confidential

OLAP/BI/ETL Tester

Responsibilities:

  • Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
  • Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
  • Wrote complex SQL s to validate target data based on the business requirements.
  • Used PL/SQL programs for performance testing.
  • Used SQL and PL/SQL scripts to perform backend database testing.
  • Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
  • Write SQL queries to validate that actual test results match with expected results
  • Check the naming standards, data integrity and referential integrity.
  • Responsible for monitoring data for porting to current versions.
  • Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
  • Involved in assessment of tools for use in future HIPAA 4010/5010 migration and compliance by performing GAP Analysis. Provided business and technical process flow recommendations.
  • Executed the Test Scripts in TOAD and documented the results in RTM.
  • Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL Loader.
  • Performed comparative analysis and gap analysis to identify variation in the process as per HIPAA X12 4010 and 5010 guidelines to incorporate updates as per 5010 guidelines
  • Verified correctness of data after the transformation rules were applied on source data.
  • Implemented data verification procedures for ETL processes in load testing.
  • Responsible for testing packages using SSIS ETL to verify data completeness, data transformation, data quality, integration testing, UAT regression testing.
  • Create and modify Stored Procedures and Functions to generate reports.
  • Conducted Black Box Functional, Regression and Data Driven. White box Unit and Integration Testing positive and negative scenarios .
  • Mapped EDI 4010 provider claim payment/advice/status 835/837/276 from clearinghouse sources to ASC X12 formats.
  • Involved in testing several Business Reports and tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
  • Defects tracking, review, analyze and compare results using Quality Center.
  • Monitor and modify performance using execution plans and Index tuning.
  • Rebuild the indexes at regular intervals for better performance.
  • Implement and manage the clustering environment.
  • Use log shipping for synchronization of database.

Environment: PL/SQL, ERWIN, HIPAA/ EDI X12, MS SQL Server 2000/2005, Oracle 9i, SQL, XSLT, XML, XSD, VB Script, SSIS, SSRS, SSAS, T-SQL, Windows 2003/2000/XP, BCP

Confidential

SQL Tester/ETL Tester

Responsibilities:

  • Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS.
  • As the Sr. QA Analyst my responsibilities included developing and documenting Product Test Plans, using several SDLC methodologies Assisted in writing efficient and effective Master Test Plan, Test Strategy, System Testing, End-to-End Test and User Acceptance Test Plan
  • Performed end-to-end System Integration testing which covered the entire business process flow from the initial point of sales through to all the 10 downstream systems and XML output files, including apps/interfaces.
  • Used MS Visio for flow-charting, process model and architectural design of the application.
  • Strong experience in conducting Gap Analysis GAP , Functional testing, User Acceptance Testing UAT , and System Integration testing SIT , SWOT analysis, Cost benefit analysis and ROI analysis.
  • Involved in implementation of HIPAA EDI Transactions 835,837,820,276
  • Facilitated Electronic Data Interchange.
  • Analyzed HIPAA EDI transactions in XML and X12 responses and of 270 and 276 and looked for defects for amendment.
  • Tested several DTS/SSIS packages for ETL data extraction and data loading.
  • Naming Convention of DTS/SSIS Packages is well organized to segregate according to Functionality.
  • Write SQL queries to validate that actual test results match with expected results
  • Check the naming standards, data integrity and referential integrity.
  • Performed GAP Analysis for HIPAA 4010 and 5010 transactions.
  • Used EDI tools to verify mapping to X12 format
  • Recommended changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
  • Configured MERGE Replication Creating Distribution Databases, updating Publishers, creating managing Publications, managing Replication monitors .

Environment: MS-Visio, MS Office, MS Project, TOAD, SQL, Quality Center, HIPAA/ EDI X12, FACETS, Oracle, SharePoint, FTP. Erwin, T-SQL, SQL Server 2000, 2005 OLAP, DTS, SSIS, Microsoft report analyzer

Confidential

SQL Server Developer

Responsibilities:

  • Created PL/SQL procedures, triggers, views, functions.
  • Gathered information about the transaction process, planning and development of the various screens.
  • Responsible for designing database tables and writing SQL PL/SQL procedures, functions.
  • Developed various forms screens and some complex reports.
  • Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
  • Written complex SQL queries for each level of data validation.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
  • Generated daily transaction reports with transaction no, loan no, borrower's address, particulars, credit, debits liability.

Environment: Oracle 7.x, Visual Caf , Rational Rose, Clear Case, Clear Quest, Windows 2000

Hire Now