Banner Image

All Services

Programming & Development

Database Developer / Architect

$35/hr Starting at $35

I have strong 9 years of work experience in various Database using SQL Server, SSIS, SSRS, Pentaho etc. Following are my Key skills. ? Design Data Warehouse for the program and migrate data from Lotus Notes, Excel, Rest API, CSV to SQL Server using SSIS tools dynamically using variable ? Run SQL Agent for monthly and weekly job in SQL Server. ? Create Job and Transformation in Pentaho using variable to move data from various sources to Salesforce environment. ? Remove all duplicate data while transferring data from one source to another. ? Create Table, Constraint, Default key, Schema from scratch in Normalization form. ? Capture and handle error using SISIS and Pentaho tool while loading data. ? Create Process Flow Diagram in MS Visio and Lucid Chart ? Create Stored Procedure, Trigger, and Views to support Asp.Net application as well as designing database. ? Deploy Asp.Net application on Development, Test and Production environment. ? Provide analysis of production data using various SQL function like rank, max, min, cube, rollup and create various ? Report like Drilldown, Drill through, Parameterized, Cascading and Matrix using SSRS. ? Create Stored Procedure using Parameter for generating SSRS Report as well as use Try and Catch block for error handling, Temptable, With CTE in SQL 2008 and SQL 2012 ? Alter many not Working Stored Procedure in Production Database. ? Deploy Reports on SharePoint mode and create subscription for business user. ? Create various views using Left Join, Right Join, Index for the user. ? Create Alter script in Production environment and test it using TSQLt. ? Create Asp.Net Web form Application and Deploy on different server on IIS. ? Use Attlantis Jira management tool for project tracking.

About

$35/hr Ongoing

Download Resume

I have strong 9 years of work experience in various Database using SQL Server, SSIS, SSRS, Pentaho etc. Following are my Key skills. ? Design Data Warehouse for the program and migrate data from Lotus Notes, Excel, Rest API, CSV to SQL Server using SSIS tools dynamically using variable ? Run SQL Agent for monthly and weekly job in SQL Server. ? Create Job and Transformation in Pentaho using variable to move data from various sources to Salesforce environment. ? Remove all duplicate data while transferring data from one source to another. ? Create Table, Constraint, Default key, Schema from scratch in Normalization form. ? Capture and handle error using SISIS and Pentaho tool while loading data. ? Create Process Flow Diagram in MS Visio and Lucid Chart ? Create Stored Procedure, Trigger, and Views to support Asp.Net application as well as designing database. ? Deploy Asp.Net application on Development, Test and Production environment. ? Provide analysis of production data using various SQL function like rank, max, min, cube, rollup and create various ? Report like Drilldown, Drill through, Parameterized, Cascading and Matrix using SSRS. ? Create Stored Procedure using Parameter for generating SSRS Report as well as use Try and Catch block for error handling, Temptable, With CTE in SQL 2008 and SQL 2012 ? Alter many not Working Stored Procedure in Production Database. ? Deploy Reports on SharePoint mode and create subscription for business user. ? Create various views using Left Join, Right Join, Index for the user. ? Create Alter script in Production environment and test it using TSQLt. ? Create Asp.Net Web form Application and Deploy on different server on IIS. ? Use Attlantis Jira management tool for project tracking.

Skills & Expertise

ArchitectsAtlassian JiraBusiness AnalysisCRM DatabasesData WarehouseData Warehouse ArchitectureDatabase DevelopmentEtlMySQLPentahoSQLSsisSSRST SQL Stored Procedures

0 Reviews

This Freelancer has not received any feedback.