Business-Data Analyst Resume

SUMMARY

3 years of experience in the IT industry with skills in analysis, design, development and implementation of Data warehousing projects.
Proficient with writing SQL queries and scripts to increase departmental efficiency and automate repeatable tasks.
Experience in creating dashboard and reports with Tableau.
Performed Data QA Process and UAT Testing
Experience in different Data sources like Teradata, Oracle, SQL Server and Flat Files.
Experienced with Teradata loading utilities like fast load, multi load, fast export, BTEQ and T - Pump.
Worked on development on ETL tool like Informatica.
Familiar with Sharepoint, Workflow, HTML.
Proven ability to work creatively and analytically to solve the problem
Familiar with Software Development Life Cycle phases like Waterfall and AGILE methodologies for projects.

TECHNICAL SKILLS

Database Systems: Oracle11g, My SQL, SQL Server, Teradata

ETL Tool: Informatica 9.x.

Others: Dimensional-Star Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, SQL, Tableau, Scrum, Agile, HTML, Sharepoint

PROFESSIONAL EXPERIENCE

Business-Data Analyst

Confidential

Responsibilities:

Worked as a data analyst in Agile and Waterfall methodology for various regulatory reporting projects.
Created and defined the Data Quality BRD requirements and worked on the implementation of DQ reports.
Experience in data profiling and analysis to improve Data Quality
Created and maintained Reference data (dimensions) for multiple standards such as Geography (Zip-City), Country, Industry Code (NAICS), Collateral etc.
Excellent in writing SQL and handling multiple tables in multiple small/large databases
Captured various reporting data using SQL for performing analysis and providing information to the management
Creation of ETL development using Informatica for data loading to Customer tables
Created Test plan, Test cases, Test data, Test Scripts for testing of the application
Administer sharepoint of the group for access control and set up of new sharepoints

Environment: s: SQL Server, Oracle, SQL, Informatica, Sharepoint, Tableau

SQL Data Analyst

Confidential

Responsibilities:

Worked on creating the detailed functional specification document from BRD for new appoints module by expanding the use cases to the detail scenario.
Migration of data from flat-files and other databases to SQL Server
ETL development and creation of Database script for automatic data upload.
Creation of SQL reports for the application
Created Test cases, Test data, Test Scripts for testing of the application
Creating test tables and Uploading test data to the tables using scripts
Set up of the test cases in Quality Center (QC) tool
Configuring various reports and graphs from the QC tool
Tested the application screens manually
Tested data at various data points, tables etc. using SQLs and Excels

Environment: s: SQL Server, Oracle, SQL, HTML, Java, Sharepoint

SQL Developer

Confidential

Responsibilities:

Documenting the types and structure of the business data (logical modeling).
Extracted, compiled and tracked data, and analyzed data to generate reports.
Data analysis, profiling, pivots, charts and graphs
Analyzing and mining business data to identify patterns and correlations among the various data point.
Creating Tables, Views and uploading data to the database.
Programming SQL Queries, developing reports, and filtering.
Respond to issues, promoting discussion and analyzing pull requests
Work daily in Sharepoint, HTML, CSS, and many other tools and technology.
Administer sharepoint of the group for access control

Environment: s: Oracle, SQL Server, SQL, HTML, Sharepoint, Outlook, Windows

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship