Data warehouse developer/Analyst Resume Framingham, MA - Hire IT People

SUMMARY

Expertise in the area of Business Intelligence Development including Data mining using tools such as SSIS, ERWIN, and VISIO, developing SSAS cubes, creating of reports using SSRS, Business object and Ad - hoc reporting using Excel, Tableau.
An Experience in database design and administration. Confidential graduated from Confidential with a Masters in Information Science has a wide experience in the installation, configuration, replication and administration of SQL servers and Business intelligence Software’s.

AREAS OF EXPERTISE

Data Warehouse/ETL Development/Design
Analysis Cube design and Configuration
Report design and development
SQL Database design, server installation, configuration, Clustering and Administration

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Data warehouse developer/Analyst

Responsibilities:

Creating SSIS Packages and associated SQL Agent Jobs
Creating T-SQL statements, Queries and tuning them
Working on data validation.
Working on Purge scripts, stored procedures and triggers.
Working on Replication between Register servers and central databases servers.
Daily downloading files/records to the database using Data loader software (SQL Load)
Designing of SSRS reports
Building ad-hoc reports using DB2 Database
Building ad-hoc reports using Excel
Ensuring the security and access of the reports and associated cube
Troubleshooting failed Package jobs, and access to the reports, cubes and packages
Automating a daily database refresh from DB2
Helping in creating Business Requirements
Helping in creating Test cases for Quality Control
Technical Documentation of various types

Confidential, Norfolk, VA

Data warehouse developer/Analyst

Responsibilities:

Creating SSIS/DTS Packages and associated jobs
Building of SQL Server Analysis Cube
Building reports using Business Objects
Redesigning and creating new SSIS packages with Data cleaning and various Transformations.
Working on the Previous stored procedure substituting them with Triggers.
Creating new stored procedures, User Defined Functions, Views and Indexes.
Designing new maintenance plan and executing DBCC commands.
Building ad-hoc reports using Excel
Ensuring the security and access of the reports and associated cube
Troubleshooting failed Package jobs, and access to the reports, cubes and packages
Troubleshooting of data pulling issues from My micros and Laborpro applications
Ensuring data pulling and validating connectivity with people soft
Reengineering the entire Data warehouse to the new SQL 2012 environment with other team members

Confidential, Dallas, TX

BI developer

Responsibilities:

Working on the on the ETL data warehouse building.
Creating SSIS Packages and associated jobs
Building of SQL Server Analysis Cube
Creating different tables, views and indexes on the database.
Designing, testing and managing disk\tape backups and recovery strategies.
Installing and configuring JIRA project and issue tracking software.
Responsible for Crystal Reporting Service Installation and developing of Crystal reports
Building reports using SSRS
Building ad-hoc reports using Excel
Ensuring the security and access of the reports and associated cube
Troubleshooting failed Package jobs, and access to the reports, cubes and packages

Confidential, NC

Database Administrator

Responsibilities:

Working on database promotions from development to production and vice versa using SSIS, DTS packages
Creating stored procedures /triggers
Creating T-SQL statements, Queries and tuning them
Setting up of the use of Business development(BID) tools and reporting methods
Creating SQL jobs, scheduling and executing
Troubleshooting failed jobs, SQL server side issues
Creating users, roles and permissions on the server and database sides
Working on the SQL server performance issues
Working on the Configuration and setup of Clustering
Designing new maintenance plans
Ensuring the security of the SQL servers and databases
Working on the DTS/ SSIS packages on SQL data cleansing and staging for loading
Assisting users on the SQL server and database issues
Creating database connectivity on both ASP servers and ColdFusion servers
Developing baseline documents and standard operating procedures