SUMMARY

• Over 7 years of IT experience as MS SQL BI developer.
• Experienced in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2005/2000 .
• Expertise in database activities like Data modeling, physical and logical database design, constructing Tables, Triggers, Functions, Views, Stored procedure, Data Dictionaries and Data Integrity.
• Highly experienced with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Expertise in Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication.
• Extensive experience in report generation using Crystal Reports, XML, MS Access and Excel spreadsheet, Developed Drill through and Drill down reports using SQL Server Reporting Services.
• Strong experience in MS SQL Server 2008/2005 with Business Intelligence in SQL Server Reporting Services(SSRS),SQL Server Integration Services(SSIS) and SQL Server Analysis Services(SSAS).
• Experienced with aggregation using OLAP analysis services cube and Proficient in implementing surrogate key generation strategy in the Data warehouse, Experienced in Data Modeling using Erwin.
• Experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP.
• Hands on working experience with working on SharePoint portal, Visual Studio and C#.
• Expert in installing, upgrade, troubleshooting and configuration of MS SQL Server 2005/2008 Database. Also, Involved in Migration from heterogeneous sources to MS SQL Server.
• Skilled in creating multidimensional cubes using the SQL Server Analysis Services 2008/2005. Also, Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling SSIS packages.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• MS SQL Server Reporting Service
• MS SQL Server Analysis Services
• MS SQL Server Integration Services
• MS Access
• ERWIN
• HTML
• XML
• MS Visio
• VSS
• Oracle 9i/10g
• T - SQL
• PL/SQL
• JavaScript
• Crystal Reports
• Windows NT/2000 Server/XP
• SharePoint
• VS 2008
• C#.

PROFESSIONAL EXPERIENCE

Confidential, Coatesville, PA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Installed Management tools and SQL Server 2008 using SQL Server Setup Program.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Developed new and worked on existing T-SQL stored procedures and triggers, preserve referential integrity, and implemented backup and database maintenance plans.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design model, physical model and user requirements.
• Wrote aggregate functions and query the database to generate ad-hoc reports and deployed them successfully to the portal. Tuned SQL queries using show plans and execution plans for better performance.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created SQL Server database, resolved various performance issues by running DBCC command and used profiler to find badly performing queries and deadlocks.
• Performed daily tasks including backup and restore, used SQL Server 2008 tools like SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Changed the layout of SharePoint website by generating the templates, Master pages, branding and chroming. Also, worked on existing reports to have a great look and feel.
• Generated reports and deployed it on SharePoint portal. Worked on out of box web parts and workflow.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history.
• Tested the reports and fixed bugs in the stored procedures.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services, SQL Server Integration Services, Windows Server 2003, SharePoint 2007,C#, VS 2008, MS Access, MS Excel 2007.

Confidential, Parsippany, NJ

MS SQL Server/SSIS Developer

Responsibilities:

• Involved in gathering, understanding and validating the technical specifications.
• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks. Provided and created different business logic script for ASP pages with web developer.
• Created database, indexes and views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data.
• Created custom web part to show required database tables on SharePoint website using ADO.NET.
• Createddegenerative dimension within OLAP environment. Data transferred between various servers using BCP and Data Transformation Services in SQL Server Integration Services.
• Analyzed the requirements and fine tune the stored procedures to improve performance. Also, Involved in Query Optimization using Index implementation and Index Tuning Wizard.
• Created Database Maintenance Planner for the performance of SQL Server 2008, which covers Database Integrity checks, Database Statistics update.
• Created multidimensional cubes in ssas 2008, mdx queries and also created various types of reports using SSRS.
• Created List template, Site template and Site definition to customize SharePoint Portal 2007. Developed rich UI forms using InfoPath 2007.
• Created master pages and applied Branding to the portal and team sites using SharePoint designer, Cascading Style Sheet (CSS) and JavaScript to give uniform look and feel the portal.
• Worked on Client/Server tools like SQL Server 2008 Enterprise Manager and Query Analyzer to administer SQL Server 2008. Also, developed packages in SSIS, Import/Export for transferring data from heterogeneous database.

Environment: MS SQL Server 2008, T-SQL, MS Excel, MS Access, and Windows NT, ASP.Net, SQL Server Integration Services, SQL Server Reporting Services, SharePoint, C#, InfoPath 2007.

Confidential, Livingston, NJ

MS SQL Server Developer

Responsibilities:

• Actively involved as part of team for gathering and analyzing the needs of end user requirement and system specification. Modified existing database by adding tables and relationship to data model.
• Created database objects like tables, views, indexes etc. and modified stored procedures, triggers, cursors and views.
• Wrote custom T-SQL stored procedures and triggers, preserve referential integrity and provide additional application functionality. Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes.
• Migrated Databasesfrom SQL Server . Determined the technical approach of Migration used when migrating from SQL Server .
• Migrated data from various sources into the SQL Server 2008 using ETL (Extract, Transform, Load) tool SQL Server Integration Services.
• All data were migrated to the staging server and then those data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• Created complex views and scripts to convert business logic for different reports. Also, utilized pivot tables to provide structure to reports in proper format like months etc.
• Used temp tables to reduce the number of rows for joins, to aggregate data from different sources.
• Created complex stored procedures for about SQL Server Integration Services (SSIS) which are used in the report to customize the report data and to make data analysis efficient and created functions to support complex wealth management logic.
• Worked with BCP and DTS to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed using SQL Server Integration Services.
• Involved in testing, bug fixing and documentation for the project.

Environment: Windows XP, Microsoft SQL Server 2008/2005, Microsoft Excel, SQL Query Analyzer, Erwin, Visual Source Safe, SSIS, SSRS

Confidential, Philadelphia, PA

MS SQL Developer

Responsibilities:

• Involved in gathering information form the business users for the HRMS application.
• Involved in creating technical document on web application of HRMS and designed the logical and physical architecture of the database by using ERWIN tool.
• Involved in ER diagram (logical design) and mapping the data into database objects and actively involved in Normalization (3NF) and De-Normalization of database.
• Login and user management, adding logins, roles, groups to the windows XP and MS SQL server and maintaining proper security procedures.
• Capacity planning in estimating and sizing of table, Created new tables, triggers to enforce data and referential integrity written stored procedures for application developers and user defined functions.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery, and performance monitoring.
• Created High level Requirement Document, Detailed Requirement Document, Data Journal, Business rules Document.
• Transformed data from various data sources using OLEDB connection by creating various SSIS packages. Also, extensively involved in using SSIS tools like Import and Export Wizard for developing the packages.
• Created connectivity between the application and the database using ASP.net and C#.
• Documented and maintained history of changes for future reference.

Environment: MS SQL Server 2005 Enterprise Edition, T-SQL, MS SQL Reporting Services2005, Erwin, MS SQL server Integration services2005, MS Office and Windows XP platform.

Confidential

MS SQL Server Developer

Responsibilities:

• InstalledandConfiguredSQL Server 2000 on windows 2000.
• Created New Databases and maintenance of existing User Databases and System Databases.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery. UsedSQL Profilerto monitor theserver performance, debug T-SQL and slow running queries
• Tested to optimize the procedures and triggers to be used in production and managed SQL user logins.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Configured Snapshot replication for reporting, user acceptance test and development servers.
• DevelopedDTS Packagesto transfer the data between SQL Server database and files.

Environment: MS SQL Server 2000, T-SQL, Query Analyzer, SQL Profiler, Windows 2000, Crystal Report