SUMMARY

• Primed with 9 years of IT Expertise, that focuses on Design, Development and Administration of huge database ranging in volumes of terabytes on SQL Server 2008/2005/2000 , Business Intelligence Tools 2008/2005 - Integration, Reporting and Analysis Services and SharePoint 2007 deployments on Production, DR, Development, QA and SIT on Clustered and Non-Clustered environments.
• Experience in Database Designing, Warehousing, Modeling, Development and Administration.
• Proven expertise for a broad range of industry domains like Financial, Retail, Healthcare and Aeronautical.
• Versatile team leader/player with progressive management skills focused on delivering solutions that create business value, strong business and technical vision in addition to excellent oral, communication, written and management skills.

TECHNICAL SKILLS

Databases & Related Technologies: SQL Server 2008/2005/2000 , Microsoft Office SharePoint Server (MOSS 2007)Microsoft Access, Oracle 8i/9i/10g/11g

SQL Server Skills: Data Transfers, Log shipping, Clustering, Database Design, Database Security, Replication, Management Studio, Performance Monitoring and Tuning, NT performance monitor, Query Analyzer, Business Intelligence Development Studio, SQL Profiler, Disaster Recovery, Backup and Restore

Business Intelligence Tools: SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Data Transformation Services

Languages: SQL, T-SQL, PL/SQL, MySQL, MS ACCESS, C, Java

Web Technologies: HTML, XML, IIS 6.0

.Net Technologies: ASP, VB

Office Tools: Microsoft Office 9 and XP

Operating Systems: Windows 95/98/NT/2000/XP, Red Hat Linux, Unix

Software Tools: Erwin, SQL Loader, Toad, MS Visio, Tidal

SSIS Tasks: Control Flow - Task Containers, Various Tasks like Data Flow Task, Execute SQL Task, Bulk Insert Task, FTP Task, Send Mail Task, Transfer Database Task, etc Data Flow - Audit, Conditional Split, Data Conversion, Derived Column, Fuzzy Grouping and Lookup, Merge Join, Slowly Changing Dimensions, etc

SSRS Report Types: Tabular, Drill Down, Drill through, Subreports, Graphical, etc

PROFESSIONAL EXPERIENCE

Sr. SQL Server Dev

Confidential, New York

Responsibilities:

• Gather client requirement, analyzing and documenting project design and coding specifications.
• Document all changes for the SDLC and notes for various issues for future references.
• Design and develop data warehouse based on client requirement.
• Implement application database code objects for applications (database diagrams, tables, views, joins, stored procedures, triggers, functions, temp tables and table variables).
• Plan and implement recurring server jobs for all Business Applications on all different environments.
• Design SSIS packages to transfer data from various sources to SQL Server 2008.
• Generate reports using SSRS based on business requirement.
• Monitor database and query performance and tune slow running queries and indexes at regular intervals.
• Created system for table synonyms, capturing, reporting and correcting error data.
• Monitor Database Support queue and troubleshoot issues.
• Work as part of a team and provide 24*7 on-call support when required.

SQL Server Dev

Confidential, New York

Responsibilities:

• Gathered and analyzed client requirement, documented project design and coding specifications.
• Planned and designed Relational Data Warehouse for reporting.
• Implemented application database code objects for applications (database diagrams, tables, views, joins, stored procedures, triggers, functions, temp tables and table variables).
• Mapped objects and developed SSIS 2008 packages for Data Migration from DB2 to SQL Server.
• Implemented data transfer through SSIS to Extract, Transfer and Load data as per clients’ backend and frontend requirements and implemented Package Configurations.
• Designed SSAS cubes based on the OLAP reporting needs.
• Transferred jobs, logins and objects from Old to New Servers.
• Used SSRS to generate reports based on business requirement.
• Implemented suitable performance tuning and query optimization techniques.

SQL Server Dev

Confidential, New York

Responsibilities:

• Gathered Client requirement, analyzed all stages of SDLC and documented project and coding specifications and planned deliverable schedule.
• Responsible for all database architecture including planning and design of Relational Data Warehouse.
• Implemented application database code objects for applications (database diagrams, tables, views, joins, stored procedures, triggers, functions, temp tables and table variables).
• Migrated databases from SQL Server 2005 and SQL-Lite to SQL Server 2008.
• Developed SSIS packages for Extract, Transfer and Load as per requirement and implemented Package Configurations and deployed Packages on different environments.
• Transferred jobs, logins and objects from Old to New Servers.
• Designed SSAS cubes based on the OLAP reporting needs.
• Used SSRS to generate reports based on business requirement.
• Monitor database and query performance and tune slow running queries and indexes at regular intervals.
• Created system for table synonyms, capturing, reporting and correcting error data.
• Implemented Data Archival techniques periodically to ensure database is not growing constantly.
• Managed Internal SharePoint Site for Reports, Calendars, Lists, Tasks, etc.
• Monitored Quality Center for defects and bug-fixes and managing Onsite and Offshore teams and providing 24*7 call support for the Critical issues.

Sr. SQL Server Dev

Confidential, New York

Responsibilities:

• Installed SQL Server 2008, Replication and Clustering on all nodes and applied Service Packs on different environments.
• Designed and developed Data Warehouse, Data marts with Business Intelligence tools.
• Planned, designed and implemented application database code objects (Tables, Views, Stored Procedures, Triggers and Cursors etc) for applications.
• Designed migration strategy and database mappings from Oracle to SQL Server 2008.
• Designed and developed SSIS packages for Extract, Transfer and Load as per requirement and implemented Package Configurations.
• Designed SSAS cubes based on the OLAP reporting needs.
• Used SSRS to generate reports based on business requirement.
• Created system for table synonyms, capturing, reporting and correcting error data.

SQL Server Dev

Confidential, New York

Responsibilities:

• Designed migration strategy and SQL scripts to verify data and migrated databases from SQL Server 2000 to SQL Server 2005/2008.
• Planned, designed and implemented application database code objects (Tables, Views, Stored Procedures, Triggers and Cursors etc) for applications.
• Designed SSIS packages to transfer data from various sources to SQL Server 2008.
• Used SSRS to generate reports based on business requirement.
• Involved in Administration of SharePoint Services.
• Provided 24*7 on-call support for production systems with rotation basis.

SQL Server Dev

Confidential, New Jersey

Responsibilities:

• Designed and developed data warehouse.
• Developed T-SQL code for the application and wrote cursors, triggers and stored procedures.
• Migrated DTS packages from SQL Server .
• Developed SSIS packages to Extract, Transfer and Load data.
• Evaluated query performance and tuned slow running packages and queries.
• Set up SQL Server configuration settings and SSIS package configurations.

SQL Server Dev

Confidential

Responsibilities:

• Developed T-SQL code for the application and also wrote cursors, triggers and stored procedures.
• Created DTS packages.
• Evaluated query performance and tuned slow running packages and queries.
• Provided 24*7 on-call support for production systems with rotation basis.