Description
SUMMARY: * 6+ years of experience in IT industry and Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008R2/2008/2005/2000. * Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases. * Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS package and SSIS of MS SQL Server. * Experienced in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services. * Experienced in integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server using OLE DB connection providers by creating various SSIS packages. * Developed Web Pages as per new enhancements and CRs and implementing the functionality. * Performed several transformations and data cleansing on data including Bulk insert task, fuzzy lookup, slowly changing dimension, union all, merge join and check points. * Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse. * Experience in developing and extending MS SQL Server Analysis Services 2005 Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries. * Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services. * Good experience with Erwin Data Modeler and good experience in data warehouse methodology. * Experienced in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports. * Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global-variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports and using advance options available in reporting servicing. * Experience in scheduling the reports weekly and monthly basis as per the Client Requirements. Had knowledge in backup/restore of SQL server databases. * Excellent experience in Designing, Maintaining & Tuning various RDBMS like SQL server 2000/2005/2008/2008R2/2012, MS Access databases and strong knowledge of SDLC principles. * Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on Tables. * Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers and Distributed Transactions. Good understanding of Databases, SQL and Data warehouse. * Experience working in an agile development team and implementing WebServices.
Accomplishments
Highlights:
Keywords
