PROFESSIONAL SUMMARY l Around 7+ years of experience as SQL Server Developer in the analysis, design, development, implementation, testing, and maintenance of application systems in Client Server environments. l Worked on MS SQL Server 2000, MS SQL Server 2005 and MS SQL Server 2008 and worked extensively on Reporting services (SSRS), Integration services (SSIS) and Analysis services (SSAS). l Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. l Creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules and SQL Performance Tuning. l Expertise in writing and debugging Stored Procedures and Triggers. l Created complex DTS Packages for Data Migration and Transformation. Involved in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000 l Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages (Microsoft Data Transformation Services). l Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands. l Knowledge of Database backup and disaster recovery procedures. l Involved in Microsoft SQL Server Database Administration including planning, implementing, backup, recovery strategies, DB Security (creating users, roles, assigning permission to them and resolving deadlocks). l Well understanding in database and data warehousing concepts (OLTP & OLAP). Experience in data mining and analysis, design and construction of data marts, data views. l Involved in logical and physical data modeling and database design using Erwin. l Worked on Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS). l Built Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS). l Experienced in using ETL tools in (SSIS) MS SQL 2005 and DTS in MS SQL 2000 l Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups. l Created simple and parameterized SQL Reports using SSRS 2005/2008. l Expert in designing report layout in SQL Server Business Intelligence Development Studio. l Strong Knowledge of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report delivery and Report security. l Experienced in writing Distributed Queries between Servers. l Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations. l Designed and Deployed cubes in SSAS environment with good understanding of conceptual data warehouse design including Star and Snow Flake data model schemas and conforming dimensions. l Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL documenting and rolling out. l Good team player committed to customer satisfaction and quality.
Technical Skills: Certifications: | MCTS, MCP | Systems: | Windows 9X/NT/2000/XP/2003 | Databases: | Relational Databases, SQL Server 2000/2005/2008 | Languages: | Visual Basic, SQL, PL/SQL, HTML, ASP, CSS, C++, C#,.NET, Java | Software: | MS Visio, MS Office, Enterprise Manager, Management Studio 2005/2008, Business Intelligence Development Studio 2005/2008, Microsoft IIS 6.0/5.0/4.0 |
| 