A new Resume, ID: 251756 <http://www.ejobsville.com/display-resume/251756> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://www.ejobsville.com/>
Title: Samjana_SQL BI/DBA posted on 2014-09-25 08:56:17 Objective: *Profile Summary:* - *8+ YEARS of Experience as an IT* professional in *System Analysis and Design, Development* & Support of *MS SQL Servers 2005 2008 R2* and *2012* in *Production, QA and Development* Environments. - Working knowledge of *software development life cycle (SDLC)* and project methodologies, as well as tools and techniques within each phase. - *Extensive reporting* experience using *SSRS 2008 R2* - Expert in defining *Query* for generating *drill down reports* in *SSRS 2008/2005*. - Hands on Experience in *Extracting and transforming Data* by using *DTS and SSIS*. - Hands on working experience in *SQL Server 2008/2005 *administration and support, including database *installation, configuration, upgrade, maintenance, performance tuning, optimization*, *backup, recovery*, monitoring, security planning and *trouble-shooting*. - Hands on experience with *SQL Server and T-SQL* in constructing *triggers, tables*, user defined *functions, views, indexes*, relational database models, data dictionaries, and data integrity. - Extensive experience in writing *Complex **Stored procedures* as well as analyzing and debugging existing complex stored procedures. - Experience in *Performance Tuning, Query Optimization*, Client/Server Connectivity, *Database Consistency Checks using DBCC Utilities*. - Experience in creating applications to perform *Data Cleansing*, *Data Conversion* and *Data Loading.* - Experience in *Database* *Backup* and *Recovery* procedures and in troubleshooting database issues. - Expert in working with *trace files* and *execution logs*. - Experience in designing *dashboards,* including *scorecards* and *reporting *with the *Dashboard Designer *deployed through*Microsoft Office Share point Server.* - Experience in *administering *the *server applications.* - *Migration:* copied production *SQL Server 2005 *databases to test server running Windows 2003 Advanced Server and *SQL Server 2008.* - Experience in Implementation of* Microsoft Business Intelligence (BI) *platforms including* Performance Point Server 2007 (PPS), Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) *and *Microsoft Office SharePoint Server (MOSS).* - *Experience *in creating *batch* files to set a *ODBC* connection - Strong experience in developing Sub* Reports*, *Matrix Reports*, * Charts*, Drill* down reports*, using *SQL Server Reporting Services.* - Experienced in creating different reports (*parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports*) depending on the business requirement. - Experienced in creating the subscription for reporting services. - Experience in creating complex *SSAS cubes* with multiple fact measures groups, and *multiple dimension hierarchies* based on the* OLAP* reporting needs. - Experience in creating *QNXT *Schemas. - Experienced in working with *Star Schema* modeling to develop *ROLAP/MOLAP* Cubes using *SQL Server 2005 *Analysis Services. - Experience in enhancing and deploying the *SSIS* Packages from development server to production server. - *Assist**ed* with various *ad hoc query* requests - Experience in interacting with end users right from collecting requirements. - Accomplished in working with users to understand and assess their needs and requirements prior to developing application systems and Work effectively as a part of team or independently under deadlines and extreme pressure. Click here to view and download the Resume <http://www.ejobsville.com/display-resume/251756> ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
