SUMMARY

• Over Seven+ years of experience in design, development & analysis of SQL Server 2005/2008 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
• Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008.
• Development and Administration experience on Database Design and Implementation of OLTP and OLAP environment using SQL server 2008.
• Experience in Designing and Implementation of Relational Database Model for business requirements using Normalization forms.
• Good at creating Tables and Views as per the business and design requirements using T-SQL.
• Extensive experience in developing Stored Procedures, Functions (Arithmetic, String and DateTime) using T-SQL.
• Implemented Triggers at different levels of Database Objects to apply Security Constraints.
• Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings.
• Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008/2012 ).
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Generated C# scripts used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in generating Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS.
• Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Expert in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Summary and Sub reports, ad-hoc reports and formatting them.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
• Good knowledge of Defining, Developing and Deploying Start Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Flexible, enthusiastic and project oriented team player with solid communication and Leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008/2005/2000 , MS Access,, MS Excel

Tools: and Packages SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, MDX, Visual Studio .Net

Languages: T-SQL, C, C#.

Operating Systems: Windows vista/XP/2003/2000, MS-DOS

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

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

PROFESSIONAL EXPERIENCE

Confidential, RI

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Created tables, views, stored procedure as per design needs.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets to and from SQL Server using BIDS.
• Worked on designing packages, deploying packages and Package security.
• Created Partition on tables with SQL server 2012.
• Developed reports using SSRS 2012.
• Developed Cross Tab, Drill Down and Drill Through reports.
• Involved in designing and deploying complex queries to perform various data base maintenance operations involving data profiling and data verification.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Generated reports using Relational databases, relational data warehouse, and OLAP cubes.
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.

Environment: SQL Server 2012, SQL Server Agent, Integration Service, Analysis Services, Reporting Services.

Confidential, FL

SQL Server BI Developer

Responsibilities:

• Created tables, views, stored procedure as per design needs.
• Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Developed, monitored and deployed SSIS packages.
• Performing query plans and making sure each and every query is using appropriate useful Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Defined the report layout in SSRS.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports, parameterized reports.
• Identified and added the report parameters.

Environment: MS SQL Server Management Studio 2008/2005, 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, FL

SQL Server BI Developer

Responsibilities:

• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server using BIDS.
• Worked on designing packages, deploying packages and Package security.
• Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Worked as a developer in creating Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Modified existing Stored Procedures according to the new user requirements during the migration process.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
• Involved in writing C# scripts using script task transformation to create multiple reports based on providence Insurance client’s information.
• Worked on Troubleshooting SSIS packages.
• Developed reports using SSRS 2008.
• Developed Cross Tab, Drill Down and Drill Through reports.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Worked with business users to gather various business requirements and implemented them while designing various SSIS packages and SSRS reports.
• Modified existing Crystal Reports according to the new database during the upgrade process.
• Improved query performance by adding covered indexes, adding file groups.
• Designed Test Scripts to validate the data and test the data integrity.

Environment: MS SQL Server 2005/08, SSIS 2005/08, SSRS 2005/08,C#, Visual Studio 2008, BIDS.

Confidential, Arlington, TX

Responsibilities:

• Redesigned and tuned existing stored procedures, triggers, UDF, views that ultimately improved the performance of the queries.
• Involved in designing and deploying complex queries to perform various data base maintenance operations involving data profiling and data verification.
• Performed the migration from SQL server 2000 to SQL 2005 following the Normalization standards to maintain data consistency.
• Designed data flow processes for data migration to the Data Warehouse using DTS.
• Developed Procedures to implement type 1 and type 2 slowly changing dimension.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Created several calculated members, translation, KPI’s, perspectives, and hierarchies
• Optimized cubes by assigning appropriate storage modes to partitions, and created usage based optimizations for better query performance.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications.

Environment: ER-Win, SQL Server 2005, SQL Server Agent, Integration Service, Analysis Services, Reporting Services

Confidential, KY

SQL Server BI Developer

Responsibilities:

• Tables, views, stored procedure were created as per design needs.
• Optimized queries tuned 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.
• Imported data from various sources into a staging 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.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Deployed the generated reports on to the server.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Environment: MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, Query Analyzer.

Confidential

SQL Server Developer

Responsibilities:

• Monitoring Log shipping/Replication and trouble shooting of errors.
• Created Linked Servers between SQL server 2000 & Oracle 9i.
• Wrote complex stored procedures, User Defined Functions, Triggers using T-SQL.
• Created DTS packages for data transfer between the two environments.
• Security issues related to logins, database users, and application roles and linked servers.
• Performance tuning of SQL queries and stored procedures using SQL profiler and Index tuning advisor.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.

Environment: SQL Server 2000 Enterprise Edition, Windows 2000/NT, UNIX, Excel, SQL Profiler, Replication, DTS,MS Access, T-SQL, Crystal Reports.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created DTS packages for the loading the data.
• Used the reporting services to create, schedule and publish the reports required.
• Implemented and maintained database security.
• Designed and implemented integrity constraints, written triggers and stored procedures to offload middle-tier transactions.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).

Environment: MS SQL Server 2000, Windows 2000 Server, Query Analyzer, Enterprise Manager.