SUMMARY

• 7 + years of IT experience in Database Administration, Design, Data Modeling, Data and Database Security, Application Development, Testing, Implementation and Deployments using SQL Server 2012/20 .
• Excellent noledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, TEMPeffective functions, Cursors and Indexes using T - SQL.
• Efficient in using Inner, Outer and Cross Joins, sub-queries for complex queries involving multiple tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Exceptional at generating analytic reports wif SQL Server Reporting Services (SSRS) in SQL Server 2012/2008R2/2008/2005 on SQL Server Data Tools and BIDS.
• Skillful in the migration of data from homogeneous and heterogeneous data sources into SQL Server 2012/2008R2/2008/2005 or other databases using SQL Server Integration Service (SSIS).
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTE’s Views and Cursors
• Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler.
• Experience in using Try Catch block introduced in SQL Server 2005.
• Good noledge in using system tables such as sys indexes, sys processes, sys objects and sys comment in various queries and using Database Console Commands (DBCC).
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases.
• Well-versed in usage of SSIS Control Flow items.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005
• Databases and scheduled them according to requirements.
• Experience in creating SSIS packages using Active X scripts and wif Error Handling.
• Created Crystal Reports on daily, weekly and monthly basis for manager’s review.
• Strong experience in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005/2008 using data from a variety of sources.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2012/2010.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in Designing and Building the Dimensions and cubes wif star and Snowflake schemas using SQL Server Analysis Services (SSAS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server.
• Hands on experience in performance tuning, query optimization, and database optimization.
• Experienced using T-SQL in SQL Server platform.
• Extensive working experience in Normalization and De-Normalization techniques on both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) Indexes.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model wif business users, App Dev and Information architects to make sure all the requirements are fully covered.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2010/2005, 2000 7.0 Oracle, MS-Access 2000/2003

Programming Languages: T-SQL, C, C++,C#, PL/SQL, XML,HTML, VB .NET, Visual Basic 6.0

Operating Systems: Windows 7, Windows Server 2003, Windows XP/ 2000/ 95/ NT

SQL Server Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services(DTS)

OLAP/ Reporting Tools: SQL Server Analysis Services (SSAS), SQL Server Reporting services (SSRS), Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, MA

SQL Server DBA

Responsibilities:

• Designing and implementing Extract, Transform, and Load (ETL) solution, Data Integration and Workflow Solutions using Microsoft SQL Server Integration Services (SSIS), Data Quality Services, and Master Data Services.
• Worked on multiple projects on building reports using SQL Server 2012 reporting services (SSRS), Business Objects Crystal Reports. Support and debug asp.net applications using Visual Studio 2012.
• Defined source data models (design of E-R model, designed logical to physical data marts) to halp evolve a data warehouse strategy dat reduces information access time
• Built the Dimensions, cubes wif Star schema and Snow flake schema using SQL Server Analysis Services (SSAS).
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Creation and development of SQL reports, reporting structure which includes financial and composite reports for existing and new clients using SSRS.
• Manual Testing the UI Applications (Sales Audit) and SSRS Reports by validating the Transactional data showing on both the UI and on the Reports and Providing Code Fixes to the Stored Procedures and views used by the ETL Process and the Reports.
• Proficiently created drill down reports, linked reports, drill through reports and sub reports using SSRS.
• Designed and worked on DQS and MDSSQL Server 2012 Tools to cleanse and establish master data management from various data sources. The resultant data are tan use in the EDW environment dimensions.
• Used script task in splitting the flat file & renaming of the file using C#.
• Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
• Worked on Team Foundation Server (TFS) source control system in the development of SSIS packages and SSRS report development.
• Designing and Developing SSIS ETL migrations and upgrades from SQL Server 2008 R2 to SQL Server 2012 utilizing column store indexes in xVelocity.
• Utilizing SQL Server 2012 Hyper-V virtualization platform wif Live Migration and server replication to cloud hosted environment.
• Involved in planning and migrating SQL Server 2008 and SQL Server 2008 R2 databases to SQL Server 2012 databases. Migration including SQL Server agent jobs, SSIS Packages, DW Databases, Analysis Services Cubes and Reports.
• Created Drill down, Drill through, and Parameterized reports using SSRS

Environment: MS SQL Server 2012/2008, MS SQL Server 2005, Windows Server 2008, Windows Server 2003,SQL Azure, Microsoft Cluster Service (MSCS), SQL .

Confidential, Bethlehem PA

SQL Server DBA

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in Production and test Environments.
• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Backup and recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users wif permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Configured Snapshot and Transaction Replication.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services dat included paper-based and interactive web-based reports.
• Experience in building adhoc reports, parameterized reports, toggle reports, reports wif sub reports using SSRS.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Performed De fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created SSIS packages using ETL tools to migrate data from different source.

Environment: MS SQL Server 2008 R2, T-SQL, MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS),SQL Agent, SQL Profiler, Windows 2008

Confidential, NJ

SQL Server BI Developer

Responsibilities:

• Run the test cases written for integration and functional testing after the deployment of the databases on the DEVRSA environment.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Created ETL packages using SSIS to extract data from relational database and tan transform and load into the data mart.
• Executed SSIS package from .NET passing the SSIS package parameters.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and
• Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in designing, developing, maintaining best solutions for the system and supported SQL Server including SSRS, SSIS, SSAS, and Data warehouse in a highly available environment.
• Created store procedures, views, and tables and generated TSQL script for application
• Health Plan Administration Tool: Facets - Trizetto
• HealthCare Technologies - Member Benefit Enrollment, Claims Processing, EDI Transactions, Care coordination, Utilization Management, SharePoint

Environment: MS SQL Server 2010/2008, SSIS/SSAS/SSRS, MS Access, Windows NT, Windows XP/ 2003/2000/98, MS SQL, ERWIN 7.0X, SQL Profiler, SQL Query Analyzer, T-SQL, MS SQL Server

Confidential, New Jersey

SQL ETL Developer/SSIS/SSRS/SSAS

Responsibilities:

• SQL database design, architecture, data modeling using Erwin; Data Warehousing and Analysis skills: ETL tools, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Business Intelligence Development Studio (BIDS) -- Using BIDS to create, edit, and deploy SSRS, SSAS, and SSIS projects. Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
• Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and
• Deploying and Processing SSAS objects.
• Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different Analysis Services (SSAS) - Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), Perspectives, measure group partitions, partition aggregations, data mining models.
• Deploying and OLAP Processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cubes.

Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, Share point Server 2007 (MOSS), T-SQL .

Confidential 

MS SQL Server Developer

Responsibilities:

• Installed and configured SQL Server7.0 Servers and clients.
• Designed and developed the databases.
• Created a logical design and physical design of the data warehouse using star schema.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked wif DTS to load the data from source systems.
• Writing stored procedures and triggers extensively and working very closely wif developers, Business
• Analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created FTP connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Creating Logins and Roles wif appropriate permissions.
• Prepared and documented Backup & Restore Plans.

Environment: Windows XP, SQL Server Business Intelligence, SSRS, T-SQL, MS Visual Studio 2005, Report builder.