SUMMARY:

• Extensive experience in testing of Data Warehouse, Server Applications and implementation of Business Intelligence Solutions using Manual and automated testing tools.

TECHNICAL SKILLS:

Business Tools: Oracle Financial/SAP/EBS/People Soft/Salesforce.com/Tableau Software

Reporting Tools: Crystal Reports/SAP/OBIEE

Languages: Java/XML/C/C++/JavaScript/HTML/VBScript/Perl/Shell Script/Python/R

Database: Oracle/My SQL/SQL server/PL SQL/ SAS/Access/Sybase/IMB DB2/SPSS

ETL: Informatica

Operating System: Windows/UNIX/LINUX

UML: MS Visio/Rational Rose

Testing Tools: HP Quality Center/Jira

Project Management Tools: Rational Requisite Pro/Doors/MS Project/SharePoint

MS Office: Word/Excel/Power Point/Office 365

PROFESSIONAL EXPERIENCE:

Confidential, VA

Senior Data Analyst

Responsibilities:

• Involve in FACETS Implementation, FACETS billing, FACETS enrollment, and FACETS Claim Processing and FACETS module
• Help with building ICD 9 to ICD 10 crosswalk map by grouping thousands of codes and ranges in Clinical, Benefits, Financial, Medical policy waves
• Extract Data using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Create ETL execution scripts for automating jobs
• Work with ETL group for understating mappings for dimensions and facts
• Extensively use ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica
• Work on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Create test scripts using Quality Center and performing regression testing on new versions of the software
• Analyze Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts
• Develop, execute, and maintain Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP QC
• Use SQL tools to run SQL queries and validate the data loaded in to the target table
• Extensively Query through SQL to check the database record
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL
• Involve extensively in doing back end testing of the data quality by writing complex SQL
• Experience in Data Validation, Data Modeling, Data Flows, Data Profiling, Data Quality, Data Integration, Data Verification, and Data loading
• Analyze data and create detailed reports utilizing proprietary tools and third party technologies to identify and resolve data quality issues to ensure quality assurance and drive data quality initiatives.
• Perform the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Involved in creating Data model for different Data mapping activities from Source systems
• Create the Oracle Workflow processes or procedures and packages

Confidential, VA

Quality Assurance

Responsibilities:

• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing
• Tested ETL process to push the transactional data from the normalized data structure into the data marts
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Understand the business requirement and the different environment batch cycles.
• Worked on data quality analysis of data warehouse applications and performing technical data quality using software tools
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Proposed Data Quality solutions to cleanse multiple billions of records
• Strong testing Quality Assurance experience within agile environment
• Validated the data upon each job start and end point in the database
• Defect raising, tracking and updating of defect in HP QC on regular basis
• Strong technical expertise in Integration testing, Functional testing, GUI testing, and Backend testing
• Created test scripts using Quality Center and performing regression testing on new software
• Created Manual Test Scenarios and Test Scripts by analyzing Functional, Business and Technical Requirements

Confidential

Quality Assurance

Responsibilities:

• Worked with functional leads to transform and develop new requirements into design, implementation
• Designed, developed and deployed the Custom objects, Page layouts, Custom tabs, Components, Visual Force Pages, Apex classes & Triggers to suit to the needs of the application
• Developed working Knowledge on Sales Cloud, Service Cloud, Custom Cloud and Apex On Force.com Platform
• Involved in data migration and integration using DATA LOADER
• Creating Automation Scripts (VBScript) in the sprints and stored them in the Test-Plan module of Quality Center
• Worked in Administration, Configuration, Implementation and Support of sales force CRM and Sales force SFA applications
• Extensive experience in lead case management (Web-to-Lead, Email-to-Case)
• Experience working with Salesforce sandbox and production environments
• Worked with Visualforce Pages, Custom Controllers, Extension Controllers, Apex Coding, Apex Batches, Apex Web Services, App Exchange deployment, Apex Classes and Apex Triggers
• Unit and integration testing for new requirements and get the UAT from the business owner
• Created Profiles and Roles based on Organizational role hierarchy, implemented Record-Level and Field level security and configured their sharing settings
• Created Custom Objects, Tabs, and Sharing Rules as per the business requirements
• Worked on various Salesforce objects like Accounts, Contacts, Leads and Opportunities
• Designed junction objects and implemented various advanced fields like Pick list, Custom Formula Fields, Field Dependencies, Validation Rules, Work Flows, and Approval Processes for automated alerts, field updates, and Email generation leading to effective Web-to-Lead communication with customers and partner portals
• Used SOQL & SOSL with in Governor Limits for data manipulation needs of the application using Force.com Explorer
• Developed Apex Triggers, Apex Classes and Test Methods using proper controls & syntax and also experience in writing unit test cases
• Experience with Managing the complex data Experience in Integrating App Exchange Applications with Salesforce, Informatica On Demand, Mass E-Mail Management, Application management using Force.com IDE in Sandbox and Production Environments, Working with different aspects of Web Services (XML, SOAP, REST) & Salesforce API integration with SDFC
• Worked on configuration, security and security controls aspects of Salesforce
• Created various custom Reports and Dashboards as per the customer requirements
• Worked on Record Types, Validation Rules, Triggers and Page Layouts
• Involved in Salesforce Application Setup activities and customized the apps to match the functional needs of the organization
• Integrated the SOAP and REST based Web Services for extracting the data from external systems to display in the pages of salesforce.com
• Provided support for ongoing Salesforce maintenance by reviewing trace logs, developing action plans and other administration services including periodic data cleansing, workflows and approvals

Confidential

Database Tester

Responsibilities:

• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Work with the development, User Interface (UI), testing and other work streams to ensure effective communication of requirements
• Involved in designing the mockup screens for GUI interfaces to visually demonstrate the proposed web based functionality to clients
• Created and executed functional test plans and cases for system validation and regression tests, ensuring issues are properly identified, tracked, reported and resolved in a timely manner
• Performed Data Analysis and data manipulation of source data with SQL Server. Prepared a validation plan and framework for validating data from the Oracle data warehouse
• Managed data integrity from various functions (front office, IT, operations, compliance) and reconciliation between the systems
• Developed information systems, including analysis of business and user needs, documenting requirement and revising existing systems
• Loaded data in excel and ran analysis for data migration
• Captured technical metadata through data modeling tools
• Ensured the feasibility of the logical and physical design models
• Developed SQL queries for Data Cleaning and Data Mapping
• Performed data validation and testing over different databases
• Reversed engineered all the Source Database's using SQL queries
• Constructed and reviewed test plans, scenarios, cases and scripts, ensuring that requirements coverage is adequate
• Reviewed the ETL code on Informatica before data get loaded on to the database
• Participated in requirement and design review. Maped business requirement, functional and technical specifications to test scenarios and test cases
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW)
• Interacted with the customer and the SME(s) to identify the relationship between the data element and the business rule to document the data
• Performed the following activities: requirements definition, design, development, testing and implementation
• Created UAT plans with several test cases for each production release to ensure that the system runs smoothly after the proposed enhancements or changes have been made
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams
• Generated Adhoc SQL query to create reports for downstream partners
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of ETL logic
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems

Confidential

Summer Intern

Responsibilities:

• Helped with filing, copying, scanning documents
• Created invoices weekly using Excel spreadsheets
• Filed documents to maintain an organized and efficient office environment
• Processed all expense reports and coordinated submission or all receipts, invoices or other financial documents
• Prepared and sent various correspondences to include letters, memos, forms, presentations
• Prepared UPS forms for shipping and mailing correspondence for all administrative departments