SUMMARY

• 7 Years of experience in IT industry as SQL Server/SQL Server BI Developer in SQL Server 2008/2005/2000.
• Worked extensively on Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), OLTP and OLAP.
• Experience in creating complex Views, Stores Procedures, T - SQL (DDL, DML, DCL, DTL).
• Expert in creating Indexes, Views, User Defined Functions, Cursors and Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Database Design activities including Data Files, File Group Organization, Capacity Planning, Data Partitioning and Data Normalization.
• Experience in Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Experience in building SSIS packages, DTS for ETL process, extracting data from various Flat files, Excel files, legacy systems and loading into SQL server.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience with SQL database Administration that includes SQL Server Installation, Monitoring, Upgrades and Migration.
• Experience in Replication, Disaster Recovery, Backups/Recovery.
• Extensive experience in various High Availability technologies such as Log Shipping, Clustering and Database Mirroring
• Extensive experience working with OLAP and OLTP applications, cubes, star schema and crystal reports in monitoring database for potential problems and creating end user reports
• Expert in creating parameterized reports, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SQL Server Reporting Services(SSRS)
• Exposure Microsoft’s .NET Framework and high level programming languages such as VB.Net, C#, VB, C and C++.
• Good team player with excellent oral, verbal, documentation and interpersonal skills
• Excellent communication skills bridging client interaction and team management.
• Self-motivated and enjoy in working a team environment.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008 , MySQL, Oracle 9i/10g

Operating System: Windows 2000/2003, Linux, HP UNIX

.NET Technologies: ASP.net, C#, VB.net

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, Replication tools

Programming Languages: C, C++, Java

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS

Database Access Technology: ADO.NET, DTS

Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server Developer/SSRS

Responsibilities:

• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Generated several drill down and drill through reports usingSSRS.
• Created SQL server Reports usingSSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc.

ENVIRONMENT: SQL Server 2005, 2008R2, SSIS, SSRS, MS Excel.

Confidential, Minneapolis, MN

MIS Code Developer

Responsibilities:

• As uncovered by an audit, the business created ~ 180 access databases containing non-secure info.
• To become OCC compliant all the databases must be converted and loaded into a secure database (Sql Server 2008 R2).
• Worked as a BA to determinewhat data sources, what do are you do with data in T-Sql, what is the output.
• Involved in unwinding requirements and mess created in access, apply business rules to stored procedures (T-Sql), write SSIS package to move data in to Sql Server.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008R2 and Flat files.
• Involved in Reduction of manual application administration by automating tasks and bulk data loads.
• Data Storage limitations are alleviated by utilizing SQL tables instead of Access
• Increasing volumes and peak processing times will be managed within current processes
• Integration of multiple sites process to single data storage tool will create efficiencies and business continuity back up.

Environment: SQL Server 2008 R2, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Business Intelligent Studio, MS Access

Confidential, Salt lake City, UT

SQL Server Developer

Responsibilities:

• Involved in T-SQL programming in writing and debugging stored procedures and triggers.
• Involved in Performance Tuning, Query Optimization, Client/Server Connectivity, running Database consistency checks using DBCC Utilities.
• Implemented different types of Replication models like Snapshot, Merge and Transactional.
• Involved in Migrating/Upgrading SQL Server 2008, Usage of Upgrade advisor, In- place upgrade and new server builds.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Involved in Huge data migrations involving multi million records in both OLTP and OLAP environments using Bulk Copy Program (BCP) and SSIS.
• Worked in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Worked in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations

Environment: SQL Server 2000/2008/2005 , SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Business Intelligent Studio

Confidential, Cape Girardeau, MO

SQL Server Developer

Responsibilities:

• Involved in designing and implementing database applications using MS SQL Server 2005/2008 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Create and maintain the databases using SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server.
• Wrote complex T-SQL queries for data extraction.
• Created DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Monitor and provide support to the application during the testing and production environments

Environment: SQL Server 2008/2005, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Business Intelligent Studio, SQL Server Management Studio, Windows XP, MS Access, MS Excel, HTML.

Confidential, New Hampshire, NH

SQL Server Developer

Responsibilities:

• Involved in migration of MS SQL Server 2000 environment to SQL Server 2005
• Conversation DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Involved in developing and maintaining existing Stored Procedures.
• Performed documentation for all kinds of reports, DTS and SSIS packages.
• Designed the databases and created different objects like tables, views, Stored Procedures, User defined functions.
• Validated the packages as they were migrated to ensure that each package will run in the production environment individually or as a part of a scheduled Job.
• Responsible for ensuring availability and performance of the migrated databases and all associated SSIS packages and Jobs that supported the reporting system.
• Deployed SSIS packages from various sources like BIDS, Management Studio, file systems etc.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Combined many simple unrelated Database Accesses to improve performance.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, Windows Server 2003, MS Access, MS Excel, SQL Query Analyzer, Erwin Data Modeler.

Confidential, Omaha, NE

SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2005 Server including SSIS, SSRS.
• Designed, created and deployed SSIS packages to move data from various data sources like Oracle My SQL, Microsoft Excel and text files.
• Designed packages for incremental data load using lookup data flow transformation and merge join transformation in SQL Server.
• Created tables, views and stored procedures for both ETL and reporting purpose.
• Created and modified configuration files used by SSIS packages during runtime.
• Designed SSIS packages using Data profiling task and used data profile viewer to analyze data quality and prevent data quality problems.
• Implemented checkpoint usage in SSIS package enabling the packages to run from the point of failure instead of rerunning the entire package..
• Involved in gathering the requirements for analyzing/designing the data warehouse
• Upgraded SSIS/DTS packages using upgrade tools as well as manually to/from SQL Server.

Environment: SQL Server 2005, MS EXCEL, DTS, SQL Query Analyzer, SQL Profiler, Windows Server 2003, XML, MS SQL Server Reporting Services (SSRS), Erwin .

Confidential

Junior SQL Server Developer

Responsibilities:

• Analyze, design and develop code for large-scale data manipulation.
• Created new Databases, tables, established relationship among tables in a database.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Involved in using Sybase business intelligence solution.
• Worked on data warehousing and data mining of Sybase.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used SQL Server System Catalog to find Stored Procedure, User Defined Functions, Triggers, Tables, indexes and constraints on existing databases.
• Implemented constraints on tables.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Involved in System testing and interacting with the front end developers and troubleshooting. .
• Handled Stored Procedures in complex situation.
• Involved in coding, testing and debugging programs for complex projects.
• Providing consultation to development teams.
• Created SQL Server Reports using SSRS 2005.
• Developed Query for generating drill down reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Responsible for transferring the data using SSIS packages.
• Developed SSIS solution for developing a fully fledged data warehouse solution
• Developed, monitored and deployed SSIS packages.

Environment: SQL Server 2005 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard), MS SQL,T-SQL,SQR, Reporting Services, Windows XP, MS Access, MS Word

Entry level SQL Server DBA/Developer

Responsibilities:

• Create and maintain the databases using SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Plan the Backup policy for the databases.
• Plan and Schedule the Online/Offline Backups.
• Performing database recovery using the backup sets.
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and tuning.
• Creation of additional databases, logins and roles.
• Involved in writing complex queries using T-SQL.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Ensuring that the backups are running fine for various databases on different servers.
• Providing support to the Application developers on the application databases.

Environment: SQL Server 2000, VBScript, ASP, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0