Email: email@example.com Phone: 216-264-6066
• Over 7 years of Experience in Designing, Developing, Maintaining Client/Server and Business Intelligence (BI) database applications using SQL Server 2008R2/2008/2005/2000/Integration Services (SSIS)/Analysis Services (SSAS) /Reporting Services (SSRS). • Expertise in creating complex T-SQL Stored Procedures, (DML/DDL) Triggers, User Defined Functions, Cursors, Views and indexes (Clustered, Non Clustered, Unique) maintaining ACID rules and database normalization. • Extensive knowledge of Relational Database Management Systems (RDBMS). • Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD. • Extract, Transform and Load (ETL) data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages. • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues. • Extensively worked in migrating (ETL) data from Excel, Oracle, CSV file sources to Oracle, DB2, Sybase and MS Access, MS SQL Server and vice versa by using Data Transformation Services (DTS), Import/export data, Bulk Copying Program (BCP) and SSIS utility. • Expert in creating jobs using SQL Server Agent to schedule, configure and deploy SSIS Packages daily/weekly basis which generate Alerts, Mail (SQL Mail Agent) when having errors. • Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands. • Expert on various control flow tasks and data flow transformations like derived column, Slowly Changing Dimensions, conditional split, lookup and pivot. • Extensive experience in the development of Reports using SQL Server Reporting services (SSRS). • Working Experience in designing, implementing, maintaining, and documenting complex database applications, data warehouse (OLAP, Star Schemas, Snowflake Schemas, Cube, Fact Tables, and Dimension tables. • Highly Experienced in SQL Server reporting services (SSRS) in designing, developing and implementing complex and interactive (OLAP, OLTP) reports like Cascaded reports, Parameterized reports, Ad Hoc reports, Tabular reports, matrix reports, linked reports, drill down reports, drill Through, sub reports, charts using SSRS. • Excellent knowledge in rendering reports, managing subscriptions and data driven subscriptions, creating reports with report builder, report snapshot and report cache. • Strong Communication and Time Management skills and excellent team player and ability to adapt quickly to changing environments.
• Jawaharlal Nehru Technological University ; Bachelor of Technology, Electrical & Electronics Engineering
• Microsoft Certified Technology Specialist - Business Intelligence SQL Server 2005
|Operating Systems |Windows NT /2000/2003 Server, Windows XP, UNIX, Windows 2008 R2. | |Languages |C, C++, T-SQL, Oracle PL/SQL, MS_DOS. | |RDBMS |MS SQL Server 2008/2005/ 2000/ 7.0, MS Access 2003/2007, Oracle 9i&10g. | |SQL Server Tools |Configuration Manager, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS, SSRS, SSAS, SSMS, DTS,| |...
Please join StudyMode to read the full document