Available MS SQL Server Full name: Mrugesh Location : MD Relocation: Yes Visa Status: GC Availability: Immediate
PROFESSIONAL SUMMARY: • Around 7 years of experience as MS SQL Server 2008/2005/2000 Database Developer & BI Developer. • Wide exposure to Product development, Requirement Analysis, System Study & Analysis, Design, Coding, Debugging, Testing, Implementation and Maintenance. (SDLC process). • Experienced in designing and developing Data Warehouses, Data Marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes. • Strong experience in MS SQL Server 2005 with Business Intelligence in SQL Server Integration Services (SSIS) ,SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). • Experience in Data Warehousing & Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using SQL Server Integration Services (SSIS), Data Transformation Services (DTS). • Experience in enhancing and deploying the SSIS Packages from development server to production server, creating SSIS packages using Active X scripts and with Error Handling. • Profound working knowledge in transaction processing. • Expert in Using Synchronous, Asynchronous and advanced data transformations in SSIS. • Experience in creating and customizing cubes using SQL Server Analysis Services. • Good knowledge on in developing attribute relations and building Attribute hierarchies as a part of developing Cubes. • Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts & column report. • Expert in developing the Report Model with Entities and Fields, which make the work of Report Builder User’s simple. • Expert in Developing Shared Data Sources and in doing connection pooling when using the same credentials. • Expert in Using SSRS Native tool, Report Builder to do ad-hoc reporting. • Expert in creating Index, Views, complex Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency SQL and PL/SQL. • Experienced in performance tuning by Query optimization. • Experience in .NET coding. • Extensively worked on developing and deploying applications using VB.NET, ASP.NET. • Experience in Data Modeling using Erwin and In-depth knowledge of Transact-SQL (DDL, DML) • Experience of Relational Database Management systems (RDBMS). Database design issues like normalization and de-normalization • Good skills with computer science concepts and programming. • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player. TECHNICAL SKILLS: Databases MS-SQL Server 2008/2005/2000, MS Access, Oracle 8(SQL & PL/SQL). ETL Tools SSIS (SQL Server Integration Services), DTS (Data Transformation Services). Database Utilities MS DTS, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, Replication Tools, SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services). Data Modeling Erwin Data Modeler 4.5/4.0 Versions. Languages T-SQL,PL/SQL, C/ C++, Visual C++, Visual Basic 6.0, HTML, XML, VBScript, VB.Net,ASP.Net Design Methodologies UML, OOP Reporting Tools SQL Server Reporting Services, Excel Spread Sheets, Crystal Reports Application Packages MS Office, MS VSS. Operating Systems Windows XP /Vista/Windows7,Windows Server 2003/2000/NT. Network Technologies Internet Information Server (IIS), MS-Front Page, TCP/IP, LAN, WAN, In-depth knowledge of Routing and Switching Technology. Cisco Routers (1700, 1841, 2500, 2600, 3640 & 7200). Cisco Switches (3500, 2900). Routing Protocol (BGP, OSPF, EIGRP, IGRP, RIP, Frame Relay), Routed Protocol (TCP/IP, IPX/SPX). Implemented traffic filters using Standard and Extended Access-lists, Distribute-Lists, and Route Maps. Ability to effectively implementing and troubleshooting Switching Technology (STP, RSTP, PVSTP, VLAN). Implementation of HSRP, DHCP, DNS, FTP, TFTP, AAA, NAT/PAT. Configured VPN server on Cisco Router with IPSec tunnels and Site-to- Site VPN IPSec tunnels. Best Regards, Murali . Dizer Corp. 1912 Mentor Ave| Painesville| OH | 44077 “ Certified Minority-owned Business Enterprise (MBE)” Off: 440-368-0212 E-Mail: [email protected] gmail: [email protected] yahoo: [email protected] -- *************************************************************************************** For all SAP related tutorials,Articles,Faqs,Tips www.sapbrainsonline.com **************************************************************************************** You received this message because you are subscribed to the Google Groups "sapbrains" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sapbrains?hl=en
