Banner Image

All Services

Programming & Development

Sr.SQL Developer

$35/hr Starting at $25

• Configured SQL Server Reporting server, scheduled various desktop reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams. • Ability to collaborate effectively and work as part of a team. • Strong attention to detail. • Hands on experience in creating SSRS Reports, crystal reports, PowerBI reports, Tablue reports. • Strong knowledge and experience with reporting packages such as business objects, databases (SQL, mySQL, Oracle), ETL framework. • Technical expertise in data models, database design and development, data mining, segmentation techniques and data warehousing. • Strong analytical skills with the ability to collect, organize, analyze and disseminate significate amounts of information with attention to detail and accuracy. • Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. • Knowledge of Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling. • Created star schema in SSAS and developed SSRS reports based on the cubes. • Administered and modified the SSIS Package to transfer data from various locations using the FTP task. Created SSIS and used the task to import and export files. • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within multiple MS SQL Server environments.

About

$35/hr Ongoing

Download Resume

• Configured SQL Server Reporting server, scheduled various desktop reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams. • Ability to collaborate effectively and work as part of a team. • Strong attention to detail. • Hands on experience in creating SSRS Reports, crystal reports, PowerBI reports, Tablue reports. • Strong knowledge and experience with reporting packages such as business objects, databases (SQL, mySQL, Oracle), ETL framework. • Technical expertise in data models, database design and development, data mining, segmentation techniques and data warehousing. • Strong analytical skills with the ability to collect, organize, analyze and disseminate significate amounts of information with attention to detail and accuracy. • Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. • Knowledge of Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling. • Created star schema in SSAS and developed SSRS reports based on the cubes. • Administered and modified the SSIS Package to transfer data from various locations using the FTP task. Created SSIS and used the task to import and export files. • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within multiple MS SQL Server environments.

Skills & Expertise

.NETBusiness ServicesData AnalysisDatabase DevelopmentDesignExtract Transform and LoadFTPMicrosoftPower BIReportsSoftware DevelopmentSQLSQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)

0 Reviews

This Freelancer has not received any feedback.