| · Over 7+ years of IT experience in Analysis, Design, Implementation & Administration of Business Intelligence Solutions with Microsoft SQL server 2008/2005/2000 with various business domains like Financial, Banking, Insurance Sector. · Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2005/2008. · Extensive experience in SQL Sever 2008/2005 with Business Intelligence in SQL Server Reporting Service and SQL Sever Integration Service. · Excellent skills in designing Logical and Physical Modeling using ERWIN Tool and ER Studio. · Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. · Actively involved in migration of SSRS reports from SQL 2000 to SQL 2008/2005 and migration with DTS to SSIS 2008/2005. · Proficient in OLTP, OLAP and Data warehousing Design concepts · Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions, and Process Documentation. · Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL · Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2008/2005 · Expert in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS. · Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. · Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS). · Thorough understanding of KPI, using MDX queries, Data mining structures. · Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, adhoc reports, parameterized reports, interactive reports & custom reports · Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment. - Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
- Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
- Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, Also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
- Excellent communication skills, analytical skills, understand business requirements in various domain
- Self learning ability and Leadership Quality.
- Good team player, strong interpersonal and communication skills combined with self motivation, initiative and ability to think beyond to achieve better performance.
Technical skills Databases Tools | SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS) | ETL Tools | Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS) | Reporting Tools | SQL Server Reporting Services (2008/2005/2000), MS Access, MS Excel | Database | MS SQL Server 2008/2005/2000, MS Access, Oracle 9i/8i | Programming | T-SQL, PL-SQL, C | Web Technologies | HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL | Operating Systems | Windows (95/98/2000), Windows 2003 Server, Windows XP, Windows Vista | Other Tools | MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash. |
|
