PROFESSIONAL SUMMARY 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. 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). Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules and SQL Performance Tuning. Expertise in writing and debugging Stored Procedures and Triggers. Created complex DTS Packages for Data Migration and Transformation. Involved in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000 Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages (Microsoft Data Transformation Services). Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands. Knowledge of Database backup and disaster recovery procedures. 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). Well understanding in database and data warehousing concepts (OLTP & OLAP). Experience in data mining and analysis, design and construction of data marts, data views. Involved in logical and physical data modeling and database design using Erwin. Worked on Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS). Built Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS). Experienced in using ETL tools in (SSIS) MS SQL 2005 and DTS in MS SQL 2000 Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups. Created simple and parameterized SQL Reports using SSRS 2005/2008. Expert in designing report layout in SQL Server Business Intelligence Development Studio. Strong Knowledge of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report formatting, Report distribution, Report delivery and Report security. Experienced in writing Distributed Queries between Servers. 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. 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. Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL documenting and rolling out. 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 |
| 