> > ** > *Send me requriement at [email protected]* > ** > *Excellent certified SQLSERVER SSIS/SSRS/SSAS/ETL/BI DEVELOPER/DBAAvailable > * > > * * > > *Professional Summary: > > ** *** > > > > · 6 years of administration and development experience on > Database Design and Development in SQL server 2005/2000 system in OLTP and > OLAP environment. > > · 6 years of 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. > > · 6+ years 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. > > · Excellent knowledge of using variables and expressions in > packages. > > · 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. > > · 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-calculatingthe > 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 > Server Analysis 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 > > >
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Visa Transfer OPT, CPT, PT, H1,H4" 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/paul_talluri?hl=en -~----------~----~----~----~------~----~------~--~---
