Hi
Consultant Available : *SQLSERVER SSIS/SSRS/SSAS/ETL/BI DEVELOPER/DBA* ** *Send me req at [email protected]* ** * * *Professional Summary: ** *** · 7 + years of administration and development experience on Database Design and Development in SQL server 2005/2000 system in OLTP and OLAP environment. · Experience in SSIS, SSAS and SSRS of MS SQL Server. · Excellent command on SQL SERVER 2008. · Data modeling using Erwin Data Modeler and MS Visio. · Expert in designing and implementing relational database model as per business needs. · In-depth knowledge of Transact-SQL (DDL, DML). · Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency. · Experience in T-SQL programming. · Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility. · Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005. · Proficient in implementing all transformations available on the SSIS toolbox. · Experience in creating master and child packages, package configurations and logging.. · Migrated DTS packages to SSIS and modified using DTS editor wizard. · Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML). · Experience in writing distributed queries(RAS). · Experience in Importing/Exporting Data from various data sources like Excel, Oracle ,DB2 and Flat file using DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQLcommands. · Experience in installation, upgrade and configuration of Microsoft SQL Server and databases. · Experience in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies. · Develop data warehouses, including requirements gathering, data analysis and cleaning, then building and deploying packages using SSIS and VB.NET <http://vb.net/>, creating cubes in SSAS and dashboard and other parameterized reports in SSRS, ProClarity and Performance Point 2007. · Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. · Experience in failover clustering. · Experience in implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication. · Experience in implementing log shipping and mirroring. · Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance. · Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages. · Extensive experience in database tuning, server logins and database permissions. · Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes · Experience in designing, creating, processing and partitioning of cubes using SSAS. · Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions. · Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005. · Excellent hands on experience in creating groups and measures, KPIs. · Expertise in generating reports using MS Reporting Services 2008/2005/2000. · Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL ServerReporting Services ( SSRS). · Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.. · Experience in Dundas charts. · Experience in Dimensional Modeling. · Experience working with XML documents. · Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger. · Excellent command on subscriptions, report snapshot and report cache. · Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team · Some experience in DB2 queries. · Experience in .NET coding. · Good skills in MSACESS. · Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives. · 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: ** *** * * RDBMS/DBMS: MS-SQL Server 2005/2000/7.0, Oracle 8i/9i/10g, MS Access. Programming Languages: T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET Software/Databases: MS SQL Server 2005 / 2000/7.0, MS SQL Server Reporting Services 2008/2005/2000 (SSRS), MS SQL ServerAnalysis Services 2005(SSAS), MS SQL Server Integration Services 2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP),ProClarity Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server. Version Control: Visual SourceSafe (VSS), Team Foundation Server (TFS). Web Servers: IIS 6.0, Apache, Share Point (MOSS), Performance Point Server. IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005, Crystal Reports Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose Design Methodology Unified Modeling Language 1.1 using Rational Rose. Reporting Tools SQL server Reporting Services (SSRS), Crystal Reports, Dundas Chart ETL Tools SQL Server Integration Services (SSIS), DTS, Netezza Thanks Durgesh shroti Urooj Corporation 201 334 5251 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" 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/open-source-erp-crm -~----------~----~----~----~------~----~------~--~---
