Dear Partners, We have Kumar ( SQL Server Developer Consultant), available to take up new assignment. He is a excellent resource with good command on SQL Server Development as well as DBA Skills.He is perfect in communication please let me know if you have any contract opportunities for him. Here is the summary of his profile. If you need any details of him , you can reach me on 302.994.6789 or email me to [email protected].
Thanks Ravi KUMAR *SQL Server Developer Contact:** Ravi ; Email: [email protected] Phone: 302.994.6789* *SUMMARY: *Highly valuable asset to any firm needing a proficient, professional, detailed oriented experienced *Programmer, Quality Analyst, and Administrator *with a wide variety of application programming in *MS SQL Server (7.0, 2000 and 2005).* *Around eight years* of technical experience from start to finish utilizing the *Full SDLC cycle approach* which facilitates the teaching and technical writing Specialties.* *My experience includes: *SQL Server Developer:* § Developed Complete client server application for Software Change Request System including two applications and Database using Visual Basic, Access and SQL Server § Used Query Analyzer, Execution Plan to optimize SQL Queries and tested and compared Performance & Accuracy related queries under SSMS. § Developed a complete XML file editing application and rewrote existing applications to improve performance and usability. § Worked on general interface to the catalog metadata through catalog views. § Deployment with execution SQL Script and expertise in the creation and maintenance with DML, DDL, Procedures, Triggers and Functions. *SQL Server Administrator:* § Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005. § Responsible for managing a database environment leading to documentation, database backup and recovery methods, manage automation of database administration, performance monitoring, tuning, and capacity planning. § Hands on experience and outstanding knowledge of high availability SQL Server solutions, using replication, Mirroring, Log shipping and SQL Server clustering and installation of physical server hardware and other peripheral devices. § Experience in space allocation, database migrations and database security along with solving *code compatibility check issues* during the migration from 2000 and 2005. § Responsible for standards and design of physical data storage, maintenance, access and security administration. § Responsible for design and correct functioning of backup and recovery on DBMSs. § Configures database parameters, creates prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. § Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. § Evaluates and implements new initiatives on technology and process improvement. § Develops database and warehousing designs across multiple platforms and computing environments. *SQL Server Production Support:* - Worked on sharing of common data by overseeing proper key management and data dictionary maintenance. - Implemented the SQL Server security model and consolidated these global groups from all the trusted domains into the Windows NT/2000 local groups in the SQL Server system. - Experience in evaluating available DBMS products after matching user requirements with system capabilities; reviewed the database design and integration with system enhancements and improvements. - Experience with administration of multi-database environments including SQL Clustering and SAN/EMC storage solutions. *SQL Server Services:* - *DTS as Application Development Platform*: Developed many *custom DTS solutions*, using the graphical tools that extend the number of solutions available by providing programmatic access to the DTS object model, using COM supporting Microsoft Visual Basic and Microsoft Visual C++. - *Integration Services* as Service Oriented Architecture and Data Cleansing: Worked with Web services in the control flow to capture XML data, have good experience in converting *DTS packages to SSIS packages.* - Reporting Services: Worked on custom report items which are server controls that can be embedded in reports to provide additional functionality beyond the built-in Reporting Services (SSRS) controls (textbox, line, image, etc.). - Experienced with *Report Designer (2005/2008 SSRS)* where the controls are added to the Visual Studio Toolbox and have their own set of property pages and dialog boxes. - Analysis Services (SSAS): Good Experience in the processes of partitions, cubes, and dimensions along with the analysis server and Surface Area Configuration manager. - Worked on SQL Server DTS* Data Conversion *and Transformation Considerations that involved a string *(DBTYPE_WSTR) into a date (DBTYPE_DATE) or time (DBTYPE_TIME)* column from a text file (used *CDate function*), also transformed the Microsoft® SQL Server™ 2008 data type * real* into exact *int* value. * Basic ETL maintenance:* - Developed data models and database designs with development teams; Implemented entity-relationship models that are used with relational databases, normalizing, de-normalizing, indexing, and defining views. - Experienced in *Matrix organization* for Extract, Transformation and Loading of Star Schema data. - Assisted in the architectural design and production transition of new applications and enhancements to existing applications along with the technical design reviews and recommend solutions and improvements. - Experienced with High level documentation (HLD) and Design level documentation (DLD) according to the end user specifications. - Worked extensively on the *Integration of SQL Server* 2000, 2005, 2008 with *Active Directory*, connecting SQL server, their components and attributes (Replication publications, cubes, and data mining models) registering in active directory. - Worked on data analysis and mapping tools for the strategic and planned exception reports. - Experienced with functional design, technical design, code development, unit test, defect fix and code migration as per the client needs. *Additional Tasks and Responsibilities:* - Experience performing backups, including generating and interpreting documents related to operating/maintenance instructions, and procedure manuals. - Participated in the identification, project planning, analysis, design, and implementation of assigned project along with Configuration Management (CVS), Issue Tracking (Jira). - Knowledge with HTML, XML, VB Script, Java Script, ASP, IIS, website design, FTP, Telnet, uploading, software development life cycle. - Experience in implementing VMware Server. - Worked on Cluster Server Environments and Load balancing of Database servers. - Worked with the remote access control across SQL Server environment using Team Foundation Server works in three-tier architecture (TFS). - Proficient knowledge of creating feeds from OLTP to OLAP systems. *Technical skills: * Platforms *Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/Vista*, Linux, UNIX *Languages* C, C++ ,*T-SQL*, MySQL, PL/SQL, VB.NET, C#.NET, ADO.NET, JAVA, Cobol. *RDBMS* *Microsoft SQL Server 7.0/2000/2005/2008, *MS Access, Oracle 10g, DB2 *IDE* *Microsoft Visual Studio 2003/2005* *SQL Server Tools* *SSMS*, *Configuration Manager*, Enterprise Manager, Query Analyzer * Profiler*, *DTS*, *SSIS*, SSAS, SSRS, Database Tuning Advisor. *Web Technologies* HTML, JavaScript, PHP, ASP.NET, ColdFusion *Other Tools* *ERwin, UML, OML, MS Visual SourceSafe*, VERITAS Backup Exec 10, MS Office suite, MS Visio, SPSS. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" 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/sap-vendor?hl=en.
