Description
Professional Summary: * Over 8 years of strong experience with Demonstrated success in the Database Design, Development and Deployment of large-scale enterprise applications. * Experience in MS SQL Server 2008/2005/2000 suite of products like SSIS, SSAS and SSRS. * Hands on experience with Database development in OLTP and OLAP. * Experience in creating stored procedures, functions, triggers, cursors, tables, views, indexed views, temp tables, dynamic sql, CTEs, osql, sqlcmd commands. * Solid knowledge of Relational Database Management Systems and Data Warehouse Concepts. * Worked on T-SQL, DDL, DML, Primary Keys and Foreign Keys. * Experience in using Try Catch block * Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access and DB2 into SQL Server 2008 R2/2005 databases. * Created SSIS packages with Error handling, notifications and package configurations. * Created audits/logging for SSIS packages on task level and package level. * Worked on Control Flow tasks like For each loop, execute process tasks, execute package tasks, script tasks and Data Flow tasks like derived column, look up, merge, script, union. * Used SSIS Checkpoints, property expressions and variables to customize data processing. * Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages with the use of environment variables. * Extensive experience in report generation using SQL Server Reporting Services (SSRS) from OLTP, relational databases and OLAP cubes. * Hands on experience in developing Custom Reports and different types of Tabular reports, Matrix reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). * Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts. * Creating YTD, MTD and WTD sales and inventory reports on store level. * Developing report models to give users flexibility to create dashboards of their own choice. * Created and Executed the Stored Procedures and Complex Queries for Reports. * Worked on setting up SSRS reports for data driven subscriptions. * Experienced in creating Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server. * Designing aggregations both manually and Usage based aggregations. * Creating relations and attribute hierarchies in cube. * Configuring user roles, groups, database email accounts and profiles. * Deploying SSIS Packages, SSRS reports and SSAS cubes to production server * Extensive experience in Administration Tasks like setting up batch jobs, configuring IIS, Data uploading, Backup and Recovery, Database mirroring, Log shipping, SQL Server Agent Jobs and monitoring day-day database activities. * Creating Database partitioning, Databases/file groups/files/transaction logs. * Understanding query flow using execution plan and tuning the query to use appropriate Scan/Seek (Index Seek, Index Scan and Table Scan). * Using SQL server hints, DMVs and DBCC commands whenever necessary. * Proven ability in Performance Tuning and Query Optimization. * Experience in client interaction while providing technical support and knowledge transfer. SSRS SSIS MS SQL Server Analysis Services 2008 OLAP Performance Point Server 2007 ETL UML Erwin DTS/SSIS BIDS SharePoint Portal Server 2007 Windows 2008.
Accomplishments
Highlights:
Keywords
