| · 7+ years of experience in project life cycles, including systems analysis, programming, relational database design, system maintenance, data migration, quality assurance, and customer support. · Excellent command on SQL SERVER 2008. · Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills. · Experienced in creating Tables, Views, Indexes and other SQL joins and query writing. · Created Reports with complex formulas and to query the database for Business Intelligence. · Experience in migrating from SQL Server 2000 to SQL Server 2005/2008. · Hands on experience in installing, configuring, managing, upgrading and monitoring and troubleshooting SQL Server 2008. · Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS). · Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). · Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. · Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS. · Have good experience in converting DTS packages to SSIS packages, expert in developing stored procedures and Trigger in SQL-Server. · Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS). · Expertise in designing Data Flow task and Work Flow task on SSIS. · Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS) · Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages. · Good understanding in database and data warehousing concepts (OLTP & OLAP). · Experience in Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS). · Experience in creating dashboards, scorecards and building reports using performance point server 2007. · Responsible for developing drilldown reports using MDX and SQL. · Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources. · Experience in Creation and deployment of cubes on SSAS. · Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments. Technical Skills Databases | SQL Server 2008/2005/2000,7.0, Oracle 9i/8i/7.x, MS Access, DB2, TeraData | Database Tools | SQL Server Management Studio, Business Intelligence Development Studio, Database Tuning Advisor, SQL Profiler, Enterprise Manager, Query Analyzer. | ETL Tools | SSIS 2008/2005, DTS, BCP (Bulk Copy Program) | Reporting Tools | SQL Server Reporting Services 2008/2005/2000 (SSRS), Crystal Reports Performance Point Server 2007 | OLAP Tools | SQL Server Analysis Services 2008/2005 | Programming Languages | SQL, T-SQL, PL/SQL, C, C++, VB 6.0, Perl, VB Script. | Data Modeling | ERWIN, MS Visio, ProClarity | Operating Systems | UNIX (Solaris/Linux/AIX), Windows (95/NT/2000/XP) | Packages | Microsoft Office | Web Development Tool | HTML, XML |
|
No comments:
Post a Comment