Data Specialist Resume

SUMMARY

Organized, results - oriented professional with exceptional knowledge in Data Analytics, financial strategies, marketing practices and client relations.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Specialist

Confidential

Responsibilities:

Wrote queries to fetch data from different table by using JOINs, Sub-queries, and CTEs on SQL Server platform.
Generated Tableau visualizations and dashboards with quick/context filters, parameters, data source filters, level of detail expression and calculated fields on Tableau reports.
Created Tableau dashboards with interactive views, trends and drill downs.
Developed SQL Raw views and Materialized Views for Tableau workbooks from multiple data sources.
Gather business requirements through JAD meetings.
Implements Software Development Life Cycle in developmental projects
Create Data mapping document in Excel as a basis for development
Developed SQL Stored Procedures and Views to generate reports that provide clear and concise industry-specific KPIs.
Develop the mappings using the needed transformations in SSIS tool according to technical requirements.
Developed workflows, sessions using task developer, worklet designer and workflow designer in workflow manager for data loading and monitored the results using workflow monitor.
Created mappings that involved implementation of business requirements to load data in to staging area MSSQL Server.
Use advanced SQL concepts like windowing functions, date functions, string functions and aggregate functions.

DATA ANALYST

Confidential

Responsibilities:

Devloped SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Created KPIs to measure employee and product sales performance for bonus system by aggregating data and finding averages.
Created Filters, quick filters, table calculations, calculated measures and parameters.
Created Tableau scorecards, dashboards using bar graphs, scattered plots, geographical maps, heat maps, trend line demonstrating key information for decision making.
Hands on experience to extract, manipulate and built complex formulas in Tableau for various business calculations.
Written complex SQL queries and optimized queries for performance tuning.
Developed data import and export routines and SQL queries to support ETL and validation activities within a MSSQL environment.
Produced standard monthly reports using Tableau.
Created several SQL Indexes, Views, Stored Procedures, triggers and appropriate User defined functions.

Data/business Specialist

Confidential

Responsibilities:

Developed Views, Functions and Stored Procedures for business report generation
Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security
Acts as liaison for SQL Server DB performance, integration, migration, upgrade, storage, and replication strategies
Monitors the database systems to ensure secure services with minimum downtime.
Experienced with extract, transform, and load (ETL) processes and reporting
Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives
Experienced in full software development life cycle (SDLC) including requirements definition, prototyping, design, coding, testing and maintenance
Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution
Documents, tracks and escalates issues as appropriate
Participates in Scrum teams in support of Agile projects while supporting end-to-end support for build, deployment, and operational activities
Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments
Routine operation maintenance including installations, upgrades, patching, monitoring, auditing, issue resolution