Stuart T

Database Designer - 7 Years of Experience - Near 07097


Database Designer


Jersey City, NJ

Education Level:


Will Relocate:



PROFESSIONAL SUMMARY * Over 7 years of professional experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008 R2/2012, SQL Server Management Studio and MS Business Intelligence Suite (SSIS, SSRS). * Excellent T-SQL Developer skills including writing, reviewing, debugging complex Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors and Transactions. * Extensive experience in working with different environment including SQL Server 2005/2008/2008 R2/2012, Microsoft Visual Studio 2005/2008/2012 and Windows Server 2008 R2/2012. * Worked with multiple System Development Life Cycle (SDLC) methodologies including Waterfall, Agile and Scrum Framework and have extensive experience with working in Development, Production and QA environment. * Highly skilled in developing, documenting and deploying ETL packages with Package/Project Deployment Model with the use of SQL Server Integration Services (SSIS) to load and transform data from one or more sources into data warehouses and data marts to be used for Analytical processing and Reports. * Involved in data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert. * Expert in Architectural Design of SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) and Data conversion process. * Experience in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task to generate underlying data for the reports and to export cleansed data. * Highly skilled in implementing incremental data loading techniques with the use of SQL Merge, Lookups, Slowly Changing Dimensions and Change Data Capture. * Proficient in designing, developing and deployment of different business/use reports with the use of Drill-down, Drill-through, sub-reports, Parameterized, and Snapshot reports in SQL Server Reporting Services (SSRS). * Deep knowledge and understanding of Enterprise Data Warehouse concepts which includes On-line Transaction Processing and On-line Analytical Processing, Star/Snowflake Schemas and Top-down/Bottom-up approach and Dimension/Fact Tables. * Experience with Database Server Administration working with Load Balancing, Clustered environment and Microsoft Hyper-V. Was involved in Installation, Configuration and Updating of SQL Server. * Excellent communication skills, strong analytical thinking, fast learner, and very adaptable to changes. TECHNICAL SKILLSET Relational Database: Microsoft SQL Server 2005/2008/2008 R2/2012/2014/2016, MS Access, MS Excel, MySQL, Oracle 10g/9i





CollapseJob Skills