Email: [email protected] com Phone: 216-264-6066
• Over 7 years of Encounter in Creating, Developing, Keeping Client/Server and Business Intelligence (BI) database applications using SQL Server 2008R2/2008/2005/2000/Integration Services (SSIS)/Analysis Services (SSAS) /Reporting Companies (SSRS). • Expertise in creating intricate T-SQL Stored Procedures, (DML/DDL) Triggers, User Defined Features, Cursors, Opinions and indexes (Clustered, Not Clustered, Unique) maintaining ACID SOLUTION rules and database normalization. • Comprehensive knowledge of Relational Database Management Systems (RDBMS). • Experience in creating directories, transactions, dining tables, indexes, limitations, writing and debugging placed procedures, triggers, views, capabilities and cursors using SSMS & SQLCMD. • Extract, Transform and cargo (ETL) info from various heterogeneous info sources like Access, Excel, CSV, Oracle, flat file, Text Structure Data applying OLE DB connection by simply creating various DTS & SSIS plans. • Qualified in growing T-SQL (DDL, DML) statements, Data Ethics (constraints), Guidelines, Performance Tuning, Query Marketing and Acceptance issues. • Extensively proved helpful in migrating (ETL) info from Excel, Oracle, CSV file resources to Oracle, DB2, Sybase and MS Access, MS SQL Storage space and vice versa by using Data Transformation Companies (DTS), Import/export data, Mass Copying Plan (BCP) and SSIS utility. • Experienced in creating jobs applying SQL Hardware Agent to schedule, change and deploy SSIS Packages daily/weekly basis which create Alerts, Postal mail (SQL Mail Agent) when ever having problems. • Knowledge in question optimization & performance fine-tuning, Using SQL Server Profiler, Execution Strategy, Performance Monitor and DBCC Commands. • Expert on various control flow responsibilities and info flow transformations like derived column, Slowly Changing Measurements, conditional divide, lookup and pivot. • Extensive experience in the advancement Reports employing SQL Server Reporting services (SSRS). • Working Encounter in designing, implementing, retaining, and recording complex data source applications, data warehouse (OLAP, Star Schemas, Snowflake Schemas, Cube, Fact Tables, and Dimension tables. • Very Experienced in SQL Machine reporting services (SSRS) in designing, developing and implementing complex and interactive (OLAP, OLTP) reviews like Cascaded reports, Parameterized reports, Interim reports, Listar reports, matrix reports, connected reports, drill down information, drill Through, sub reports, charts applying SSRS. • Excellent knowledge in rendering reports, managing subscriptions and data motivated subscriptions, creating reports with report designer, report snapshot and report cache. • Strong Connection and Time Management expertise and exceptional team player and ability to modify quickly to changing environments.
• Jawaharlal Nehru Technological School; Bachelor of Technology, Electric powered & Electronic devices Engineering
• Microsoft Certified Technology Specialist -- Business Intelligence SQL Server 2005
|Operating Devices |Windows NT /2000/2003 Storage space, Windows XP, UNIX, Windows 08 R2. | |Languages |C, C++, T-SQL, Oracle PL/SQL, MS_DOS. | |RDBMS |MS SQL Storage space 2008/2005/ 2000/ 7. 0, MS Gain access to 2003/2007, Oracle 9i& 10g. | |SQL Server Equipment |Configuration Manager, Enterprise Supervisor, Query Analyzer, SQL Fallanalytiker, DTS, SSIS, SSRS, SSAS, SSMS, DTS, | |...