OBJECTIVE

• Capitalize on my professional Database Development skills with a team of skilled, energetic and result oriented professionals at an innovative company.
• A challenging environment that welcomes creativity and enhancements of skills possessed, wherein the application of my technical education allows me to apply my analytic, documentation and Database Analysis’s an immediate contribution as an integral part of a progressive company.

SUMMARY

• Highly motivated SQL server Developer with 12 Years of IT Experience in Database development, Administration and Production Support with expertise on ETL process and Reporting using SQL Server 2012/2008 R2/2008/2005, SSIS and SSRS.
• Expertise in Database design, Entity Normalization and Database Creation.
• Extensive experience in T - SQL (DDL, DML, DCL), Views, Stored Procedures, Cursors and Triggers.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Experience Creating SQL Server drill down and drill through reports using both SQL Server 2005/2008/2012 Reporting Services (SSRS).
• Experience Creating dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports, and formatting them.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Built various packages in SSIS to load the data coming from various input sources like excel, flat files using FTP.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Advantage of having worked in all phases of software development lifecycle (SDLC) including requirements gathering, analysis, design, reviews, scoping, coding, testing, debugging, documenting, building and deployment.
• Implemented SSIS tools for Extracting, Transforming and Loading of data from any source
• Experienced in Migration data from SQL Server 2005 to SQL Server 2008 and 2008R2/2012.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Experienced in installation, upgrade and configuration of Microsoft SQL Servers 2000/2005/2008/2008 R2/2012.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008R 2/2008/2005/2000

TOOLS: SSMS, SSDT, SSIS, SSRS, SQL Profiler, Activity Monitor, Database Engine Tuning, Advisor, Enterprise Manager, Query Analyzer, Oracle SQL Developer

LANGUAGES: T-SQL, PL/SQL, ANSI SQL, VB.NET, C#, C++, Java.

APPLICATION: Visual Studio, Microsoft office, Third party SQL server Performance

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer/DBA

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers and integrated it with the front end application.
• Designed and developed Crystal Reports, matrix and tabular reports, drill through and drop down menu option using SSRS.
• Created Reports (Ad-Hoc, Summary, Sub, and Drill-down Reports) using SSRS.
• Diagnosing and tuning the server optimal performance using SQL Server 2012/2008 SQL Profiler, Spot lite and Database Engine Tuning Wizards.
• Assigned permissions to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.
• 24 X 7 Production Database on Call Support.

Environment: MS SQL-Server 2012/2008R2/2008, SQL Diagrams, Erwin, SSRS, SSAS, SSIS, C#, Windows 2012 Server, MS Access, T-SQL, Outlook, MS Visio, Visual Studio.

Confidential

BI Developer

Responsibilities:

• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Implemented SSIS data, created and testing maintenance procedures and provided data integrity strategies Using ETL tools.
• Developed custom reports and deployed them on server using SQL Server Reporting
• Services (SSRS).Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.
• Responsible for the designing advance SQL queries, procedure, cursor and triggers.

Environment: SSIS, SSRS, MS SQL Server 2012/ 2008/2005 , C#, VB.NET, Visual studio 2008, MS Access, MS Excel, MS Visio.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Created different T-SQL scripts for automated execution of the tasks. Created SSIS packages for data Importing, Cleansing, and Parsing etc. ExtractedCleaned and validated.
• Created drill down and drill through reports using SSRS and created OLAP Cubes using Star Schema and Snow Flake Schema.
• Customized financial reports to support various analytical and presentation needs using Access Database, Excel, Visio template and VBA programming.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Environment: SQL Server 2005/2008, Business Intelligence, MS Visio, MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS).

Confidential

SQL Server Developer

Responsibilities:

• Created required indexes, new Stored Procedures and reduced the response time and failure rate for application and reports.
• Created drill down and drill through reports using SSRS and created OLAP Cubes using Star Schema and Snow Flake Schema.
• Performed Data Validation to ensure data integrity in source, staging, core and destination database for the Data Mart Project.
• Was Responsible for creating, deploying and scheduling new SSIS packages.
• Worked with the other IT associates to design, implement, test, and enhance stored procedures and other applications necessary to support systems and file processing.

Environment: SQL Server 2000/2005, MS Analysis Service, MS Access 2003& Profiler, Query Analyzer. Visual Studio.

Confidential

SQL Database Administrator

Responsibilities:

• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Auditing stored procedures for optimization and improving performance.
• Administration, Production support for various applications, Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures.
• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Running DBCC consistency checks, fixing data corruption on application databases.

Environment: SQL Server 2000 Analysis Services, Integration Services and Reporting Services, Windows server 2000/Windows NT 4.0, Windows 2000 / Windows 98.