Data Analyst Resume Miami, FL - Hire IT People

SUMMARY:

Over 7 years of IT Professional experience of SQL Server 2008/2012/2014, Data Loading and Reporting tools such as: SSRS, SSIS
Strong Experience in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
Working experience with IBM Netezza and MicroStrategy
Strong Experience in T - SQL coding and testing: functions, views, stored procedures etc.
Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
Proven ability to approach problems effectively, prioritize and complete multiple tasks.

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, Miami, FL

Environment: IBM Netezza, MS SQL Server 2012/2014, SSRS, SSIS, Report Builder, Microstrategy, Visual Studio 2012, T-SQL

Develop automated tools and reports that test and validate the accuracy and completeness of data loaded into the data warehouse
Visualize results of data integrity analysis in form of reports, graphs, charts, tables and scorecards
Design, develop and test Data Quality Datamart, supporting data quality dashboard, scorecards and reports.
Troubleshoot, document and work to resolve production level data issues found within the business applications
Coordinate the collection and validation of new data and refinement of existing data sources
Work with business and technical leads in the development of functional, business and technical requirements to ensure that all data related requirements are met
Provide data validation and data quality support throughout the QA testing phase
Develop adhoc reports and analysis as requested by the business and technical teams

BI Analyst

Confidential,3 Miami, FL

Environment: MS SQL Server 2008R2/2012, SSRS, SSIS, Report Builder, Visual Studio 2008, 2012, T-SQL

Developed a High level dashboard using SSRS
Designed and created Report templates, bar graphs and pie charts based on the financial data, sales and shipping data of multiple branches
Using T-SQL and Stored procedure to pull data from multiple tables. Developed various types of complex reports like matrix, Drill Down, Drill through, sub report,.
Designed multi-Parameterized Reports for generating Ad-Hoc reports as per the manager requirements. Authored performance based reports for the managers to show sales against various measures like Time, Area.
Maintain existing reports to enhance performance
Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
Designed and developed SSIS Packages to import sales and shipment data from MS Excel, SQL Server and Flat files from vendor and shipping partners
Data Transformation and cleansing using SSIS packages
Schedule jobs through SQL server agent to execute SSIS package weekly
Involved in Dimensional modeling by identifying the fact and dimension tables based on the reporting requirements.
Experienced in writing complex SQL Queries, Stored Procedures, Views, Joins, Constraints, DDL, DML to implement the business logic.

Data Analyst

Confidential, Miami, FL

Environment: SQL Server 2008/2008R2, SSRS, BIDS, Excel, Access,

Perform analysis against customer behavior and sales data and develop marketing analytics models that answer specific business questions.
Analyze market trends and competitive landscape.
Provide analysis to support business initiatives with new products
Developing reports on SSRS on SQL Server .
Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
Using Excel and ACCESS to general marking/sales report

Business Analyst

Confidential, Miami, FL

Created test cases, scripts and data based on business requirements, functional and technical specifications. Executed unit, functional, system and regression testing on altogether seven environments,
Mentored and trained junior testers.
Successful planned and executed the system integration and functional test of two production boxes.
Worked with Customer Support, coordinated methods of problem determination, provided resolution and workarounds.