Description
PROFESSIONAL SUMMARY: Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012/2014 in Development, Test and Production Environments on various business domains like Financial, Insurance, Software and Manufacturing. * Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects. * Working experience in BI Solutions (ETL) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, and DCL commands for various business applications. * Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements. * Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors. * Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes. * Expert in using SQL Server Agent to Schedule and monitor Jobs. * Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability. * Experience in Error handling and debugging coding issues and troubleshoot production problems. * Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance * Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) * Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues. * Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations. * Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. * Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS. * Experience in creating configuration files to deploy the SSIS packages across all environments. * Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data. * Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting. * Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008R2) & features. * Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports. * Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms. * Experience in developing applications using C#. Net, VB.Net. * Strong Experience in Unit, Integration and System Testing.
Accomplishments
Highlights:
Keywords
