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 "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
