Data Analyst / QA Resume

TECHNICAL SKILLS:

Databases: SQL Server 2012, SQL Server 2014, Oracle 11g, DbVisualizer

Languages: SQL, HTML, JavaScript, CSS

Office Tools: MS Word, MS Excel, MS Access, MS PowerPoint

BI Tools: SSIS, SSAS, SSRS, Ab Initio, DB2, QlikView, QlikSense

Data Quality Tools: Talend, Data Match 2013, Ataccama

Visualization Tools: Tableau Desktop & Server, TreeMap, TIBCO Spotfire

ProjectManagement: Agile, SDLC

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst / QA

Responsibilities:

Discussing requirements with both Internal & external stakeholders.
Installation of the tools around data.
Creating/building test plans for each module.
Performed data analysis, data profiling by writing SQL queries to the data.
Validating the data across three data points i.e. source, operational data store & destination.
Creating/building test cases for each module.
Creating/building score cards for each module to be tested.
Working with unique identifiers and performing VLOOKUP’s to look for these unique identifiers in another worksheet/workbooks.
Automation of task using Excel Macros.
Creating/building architectural diagrams, data flow diagrams, use case diagrams & ER diagrams using Lucidcharts.
Helping business with new business rules/business logic.
ETL Testing.
Educating/ both internal and external stakeholders on data quality & data governance.
Training the team on data analysis & how to investigate on data quality issues.
Validating the mapping documents & crosswalks with respect to values from source and how they map in destination.
Using reference data to validate the pattern recognition & data standards.
Creating project documentation & loading it to HP ALM.

Environment: MS SQL Server, Oracle SQL Developer, HP ALM, JIRA, WIKI, Talend ETL, Lucidchart.

Confidential

Specialist

Responsibilities:

Processing of batches for native and tiff in tools like Clearwell and eCapture.
Post processing the DAT files as per the client requirements and making them ready for loading.
Loading natives, tiffs and metadata into Relativity based the project requirements.
Performing peer level QC on the all the above mentioned stages.
Designing queries for QC if required.
Have been involved in many scenarios of Regression Testing for Tools related to e - Discovery.
Have been a super-user in Relativity with attention to finer details.
Performed Regression Tests over the tool on various fronts and provided dynamic outputs with details reports accompanying the same.
Performing OCR, IPRO PDF or TIFF conversions and
Designed queries to ensure quality on all operations tasks.
Creating Search terms and Search term reports in Relativity based on client’s requirement.
Have been a very pro-active user of this Hosting Tool, working day-in and day-out during the productive years of the domain
Have been a very keen observer giving utmost detail to the working of the tool.
Analyzed and provided genuine feedbacks ; critical reports at times to aid in improving subsequent versions
Have had the distinction of initiating and performing regression tests across various versions.
Strong SQL skills have led to bringing forth simplified processes through back-end of the platform.
Have developed a query set, which lightens the QC checks to be performed after hosting to Relativity.