Banner Image

All Services

Other

SQL /Database/BI Developer(SSRS/SSIS)

$10/hr Starting at $25

? Over 5+ years of IT experience as a MS SQL Server 2012/2008R2/2008 Developer in various industries like Finance, Advertising, and Insurance. ? Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation. ? Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects. ? In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions. ? Experienced in report generation using Crystal Reports, XML, MS Access and Excel. ? Proficient in creating Chart reports, Drill down and Drill through reports by passing parameters using SSRS 2012. ? Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support. ? Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting. ? Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning. ? A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.

About

$10/hr Ongoing

Download Resume

? Over 5+ years of IT experience as a MS SQL Server 2012/2008R2/2008 Developer in various industries like Finance, Advertising, and Insurance. ? Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation. ? Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects. ? In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions. ? Experienced in report generation using Crystal Reports, XML, MS Access and Excel. ? Proficient in creating Chart reports, Drill down and Drill through reports by passing parameters using SSRS 2012. ? Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support. ? Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting. ? Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning. ? A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.

Skills & Expertise

AccessAdvertisingAnalysisCrystal ReportsData Import/exportData ModelingData WarehouseDatabase DesignDatabase EngineDesignDeveloperDimensional ModelingERwinEtlExcelFinanceImportMicrosoft SQL ServerModelingMsReportsSQLSsisSSRSXML

0 Reviews

This Freelancer has not received any feedback.