SUMMARY

• Over 6+ years of experience in design, development & analysis of SQL Server and 2012 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objectslike tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins to generateComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• T-SQL Programming using DDL, DML, DCLcommands for various business applications
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications
• Extensive experience in using SQL Server Profilerto monitor the SQL server fordeadlocks, long running queries and tune the same to improve performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Proficient in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx)involving ETL process, Extracting Data from variousflat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• ETL implementation using SQL Server Integration Services(SSIS).
• Transformed data from one server to other servers using tools like Bulk Copy Program(BCP),Data Transformation Services(DTS) andSQL Server Integration Services(SSIS) (2005/2008).
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling, precedence Constraints, Break Points, Check points and Logging.
• Experienced in Maintenance and Admission of SSIS by creating Job Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages usingSSIS/DTS, Import and Export Data
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Expertise in designing complex reports likeDrill-Down Reports,Drill-ThroughReports,and ParameterizedReports using SQL Server Reporting Services(SSRS)based on client requirement.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drill-Down, Drill-Through, Multi-valued parameters etc.
• Built effective queries for high-performance reports and rendered them toHTML, XML, PDF and Excelformats usingSSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
• Worked with report manager for deploying the reports across all the environments.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008/2005 , Oracle 10g/9i/8.0, MS Access, MS Excel

Tools: and Packages SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Lite speed, MDX, Visual Studio .Net, ProClarity, DB Pro, Visual Source Team Foundation, Informatica, Erwin, Power Designer

Languages: T-SQL, PL/SQL

Operating Systems: Windows 7/Vista/XP/, Windows Server 2008/2003

Application Package: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

SQL / BI Developer

Responsibilities:

• Designed the Functional Requirements and Mapping Technical Specificationson the basis of Functional Requirements.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, Policies andProcedures.
• Performingquery plansand making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggersfor validating the integrity
• Used Performance Monitor and SQL Profilerfor Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packagesin Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data todata warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in usingReport Designeras well asReport Builder.
• Developed custom reportsand 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).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• BuildCubeson Enterprise Date Warehouse (EDW).
• Analyzed MultidimensionalCubesinFacts and Dimension TablesusingSSAS.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server 2012/2008, MS SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe.

Confidential, Birmingham AL

SQL / BI Developer

Responsibilities:

• Gathered Business Requirement and System specification form system users.
• Designed Data Models using Erwin. Developed physical data models and created DDL scripts to create Database schema and Database objects.
• Migrated datafrom SAS environment to SQL Server 2008 via SQL Server Integrated Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• CreatedDatabases, Tables, Views, and Indexes and wrote complexstored procedures, queries,triggers.
• Managed index, statistics and optimizing queries by using execution plan.
• Responsible for transferring the data using SSIS packages.
• Developed Analysis Services Project.
• Responsible for Dimensional modeling.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubesand defined the dimensions.
• Responsible for Understanding the world scope data feed, help design thetarget schema and develop an ingestion feed process using SSIS.
• Expert in providing Logging, error handling by using event handler and break points for SSIS Packages.
• CreatedDimensionswith thecube wizardand also individually and Generated Named calculations and named queries.
• Designed dimensional modeling with Star schema and Snowflakes schema provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Experience in Maintenance and Admission of SSIS by creating Job Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builderin SSRS.
• BuiltDrill Down,Drill through,linked and subreports using SSRS 2008.
• Documented alldatabase objects and packages for future s.
• Educated team on load process and data movement changes.
• Analyzed and designed of software and database solutions.

Environment: MS SQL Server 2008/2008 R2,, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual Source Safe, Windows XP, Oracle, T-SQL, Query Analyzer.

Confidential, Franklin TN

SQL/BI Developer

Responsibilities:

• Createdtables, views, stored procedureas per design needs.
• Maintaineddata integrityby performing validation checks.
• Optimized queriestuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Importeddata from various sources into astaging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS(SQL Server Integration Services)to produce a Data Martfor reporting.
• Implemented SSIS data transformationscripts, created maintenance procedures and provided data integrity strategies.
• Responsible forcreating the reportsbasing on the requirementsusing SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of thedata sourcing and data flows, data quality analysis,working in conjunction with the data warehouse architect on the development of logical data models.
• Deployed the generated reportson to the server.
• Assisted in migratingdenormalized report DB into aStar Schema design.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, Oracle, T-SQL, Query Analyzer.

Confidential, Grapevine TX

SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000/2005, MS Access.
• CreatedDatabase Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Tested to optimize theStored Procedures and Triggersto be used in production.
• Maintained client relationship by communicating the daily status and weekly status of the project.
• Designed and implemented theLogical and Physical modelof the database.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Developed complexT-SQL codefor the application.
• Installed and maintained MS SQL Server 2005.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implementedfine-tuningof database objects and server to ensure efficient data retrieval.
• Involved in the performance tuning and optimization of T-SQL queries.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Managed and monitored the use ofdisk space.
• Planned Backup strategy based on projects requirements.
• Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQL Server 2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2003 Server.