PROFESSIONAL SUMMARY:

• 7+ years of experience in IT industry as a SQL Server Developer/BI developer with strong expertise in SQL server development, designing Stored Procedures/Transact - SQL coding, SSIS/SSRS/SSAS,OLTP and OLAP
• Expert in installing, configuring, monitoring and troubleshooting MS SQL server 2000/2005/2008.
• Expert in developing stored procedures, functions, triggers, views, optimizing queries, table normalization
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS 2005 and 2008.
• Experience in Creating SSIS Packages and migrating DTS Packages from SQL 2000 to SQL 2005.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Proficient in handling parameterized reports in SSRS 2008.
• Created ETL packages usingSSISto move data from various heterogeneous data sources.
• Created logs forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Solid knowledge and recent experience with all aspects of SQL Server Management Studio (SSMS) including Query Editor, Server objects, SQL Server Agent, Replication, Management and Notification Services .
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema
• Experience in integrating the SSRS reports into web applications using Report viewer control
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube
• Transformed data from one server to other servers using Bulk Copy Programming and Data Transformation Services
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Expert in creating normalized databases, authentication, query tuning, assigning proper indexes creating stored procedures, functions, triggers and data types.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Successfully implemented Transactional and Snapshot Replication methods for Backup and Restore of Database. Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server 2008 Reporting Services (SSRS), DBCC, BCP, SQL Server Profiler

ETL: DTS, SSIS

Reporting Tool: SSRS, Crystal Reports, Business Objects

Programming Languages: C, C++, Java,T-SQL,PL-SQL

Databases: MS SQL Server 2005/2008, Oracle 9i/10g, MS Access 2000/2003

Data Modeling Tool: Erwin, Microsoft Visio 2000/2003

Operating System: Windows server 2003, Windows NT/2000/XP, Windows 98

Backup Tools: Lite Speed, Veritas.

PROFESSIONAL EXPERIENCE

Confidential, Decatur, AL

SQL Server BI Developer (SSRS/SSAS/OLAP)

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012, 2014 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2012/2010/2008R2/2008/ (SSAS)
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Used SQL Profiler and Query Analyzer to optimize ETL package queries and stored procedures.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Performance tuning for database objects and ETL packages.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Purchase, NY

SQL Server BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2010/2008R2/2008/2005(SSAS)
• Used SQL Profiler and Query Analyzer to optimize ETL package queries and stored procedures.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Scheduling the SSIS packages and Jobs.
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2012/2010/2008R2/2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Building KPI reports for the cubes and optimizing the reports.
• Perform database and ETL tuning
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008R2/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential New York City, NY

SQL Server BI Developer

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005 from different environments for the SSAS cubes.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008R2/2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL2007.

Confidential,Jersey City, NJ

SQL Server Developer

Responsibilities:

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Involved in updating slowly changing dimensions strategies.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005,2008R2, BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005. C# and .net

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Created Indexes to get the high level performance.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2000/2005/2008, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, Oracle 7.0

Confidential

SQL Server Developer

Responsibilities:

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables, enforced the referential integrity constraints through indexing
• Backup recovery schedules, Backup scripts.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master screen using VB Script.
• Generated complex reports using stored procedures in crystal reports
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.

Environment: SQL Server 2005 /2000, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.