
- #USE RAZORSQL TO CREATE SCRIPTS SOFTWARE#
- #USE RAZORSQL TO CREATE SCRIPTS CODE#
- #USE RAZORSQL TO CREATE SCRIPTS WINDOWS#
Created database table partitions, functions and schemes to enhance performance and troubleshooting locking and blocking issues on large tables. Deployed SSIS packages into SQL server integration services catalogs(ICS). Developed ETL/SSIS solutions for data extraction, transformation and loading. Created store procedures for data mapping, data cleaning, data transformation and validation from source systems to staging and dimension tables. Created database objects tables, indexes, views, store procedures, and functions for data extraction from staging tables to dimension tables and fact tables. Developed T-sql scripts to create dimension and fact tables for data warehouse building. Involved in the analysis, design, Implementation and integration of data warehouse solutions. Involved on creating a data model by reverse engineering using ER/Studio Data Architect for the data migration from legacy system IBM Informix to MS SQL based system. Deployed and tested SSIS solutions on multiple SQL servers and environments. Created and scheduled SQL agent jobs and proxy to automate daily SSIS packages run.
Created environmental variables and configured with SSIS project parameters. Developed store procedures based on data mapping business rules for a daily data loading from staging to base tables. Analyzed Legacy Informix 4gl programs for conversion to T-sql store procedures for data mapping and transformation from staging to base tables. Developed parameterized connection strings at run time using environmental variables to be able to run SSIS solutions in multiple environments (DEV,TEST and PROD). Created complex ETL/SSIS solutions to extract data from multiple source systems (around 70 courts) to a central data repository staging tables with a foreach loop iteration functionalities. Identified and designed process flows to transform data and populate the target databases Analyzed the requirements and framed the business logic for the ETL process. Conducted detailed analysis of the legacy Informix data model to migrate to a new MS SQL based platform. Participated in the development of detailed data migration plans and designs from IBM Informix Databases into Microsoft SQL Server. #USE RAZORSQL TO CREATE SCRIPTS WINDOWS#
Programming Languages: - T-SQL/MDX/IBM Informix 4gl/C#/C++/Visual Basics/.NET frameworkĮnvironment: MS SQL Server 2008/2012/2014/2016 SSIS, SSAS, SSRS, Excel, Windows server, Visual Studio
Operating Systems: Windows Server 2003/2008/R2, 7/8/windows 10 Experience in creating Parameterized Reports, Drill down, sub cascading Reports and Reports using SQL server Reporting Services and customized reporting applicationsĭatabase Tools: MS SQL Management Studio, MS Visual Studio 2013/2015/2017.Experience in Importing/Exporting Data from data sources like Excel, and Flat file & SSIS package.Optimized T-SQL Scripts by analyzing Execution Plans as well as using Microsoft Tools like SQL Profiler and Database Tuning Advisor.Proficient in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2008/2008 R 2/ 2012/2014/2016 Servers.Knowledgeable about Multi-dimensional cube and tabular Models.Worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
#USE RAZORSQL TO CREATE SCRIPTS CODE#
Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments. Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2012/2014/2016. Extensively created and debugged large SQL database scripts and batches. Experience working on Cross platform technologies including MS SQL, IBM Informix and Oracle Database applications. Hands on experience working on IBM Informix database systems, RazorSQL and 4gl programs. Very well versed in writing T-SQL and MDX for querying tables and Cubes. #USE RAZORSQL TO CREATE SCRIPTS SOFTWARE#
Experience with software development lifecycle (SDLC) and project management methodologies. Over 6 years IT experience with extensive expertise in implementing end - to-end Business intelligence solutions using the Microsoft BI Stack (SSAS, SSIS and SSRS).