SUMMARY

• IT professional with 8+ years of experience in System Analysis and Design, Development & Support of MS SQL Servers 2005/2008R2/2012 in Production, QA and Development Environments.
• Working knowledge of software development life cycle (SDLC) and project methodologies, as well as tools and techniques within each phase.
• Extensive reporting experience using SSRS 2008 R2
• Expert in defining Query for generating drill down reports in SSRS 2012/2008/2005.
• Hands on Experience in Extracting and transforming Data by using DTS and SSIS.
• Hands on working experience in SQL Server 2012/2008/2005/2000 administration and support, including database installation, configuration, upgrade, maintenance, performance tuning, optimization, backup, recovery, monitoring, security planning and trouble - shooting.
• Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, relational database models, data dictionaries, and data integrity.
• Extensive experience in writing Complex Stored procedures as well as analyzing and debugging existing complex stored procedures.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Experience in creating applications to perform Data Cleansing, Data Conversion and Data Loading.
• Experience in Database Backup and Recovery procedures and in troubleshooting database issues.
• Expert in working with trace files and execution logs.
• Experience in designing dashboards, including scorecards and reporting with the Dashboard Designer deployed through Microsoft Office Share point Server.
• Experience in administering the server applications.
• Migration: copied production SQL Server 2000 databases to test server running Windows 2003 Advanced Server and SQL Server 2005.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Performance Point Server 2007 (PPS), Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS).
• Experience in creating batch files to set a ODBC connection
• Strong experience in developing Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services.
• Experienced in creating different reports (parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports) depending on the business requirement.
• Experienced in creating the subscription for reporting services.
• Experience in creating complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in creating QNXT Schemas.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005 Analysis Services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Assisted with various ad hoc query requests
• Experience in interacting with end users right from collecting requirements.
• Accomplished in working with users to understand and assess their needs and requirements prior to developing application systems and Work effectively as a part of team or independently under deadlines and extreme pressure.

TECHNICAL SKILLS

Relational Databases: SQL Server (2005, 2008, 2012), My SQL, Oracle 11g.

Querying/Reporting: T-SQL,PL/SQL, TOAD,ORACLE.

Reporting Tools: SSRS,Crystal reports.

ModellingTools: SQL Server Analysis Server 2005(SSAS),ER-Studios.

ETLTools: Microsoft Integration Services (SSIS).

DataMiningTools: Microsoft Analysis Services(SSAS).

DataMiningModels: Classification, Association Rule Mining, Clustering.

ProgrammingLanguages: C, C++,T-SQL,PL/SQL,.Net.

Operating Systems: Windows (98, 2000, NT, XP, VISTA, 7), Windows Server 2000/2003.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL Server BI Developer/DBA

Responsibilities:

• Created different reports (parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports) depending on the business requirement.
• Proven ability in defining Query for generating drill down reports in SSRS 2008.
• Modifying the existing the Dynamic Sql Stored Procedures to point to the EDW environment and applying the data model changes.
• Modifying the existing 100 reports to point to the new EDW environment.
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports and Map reports.
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Created snapshot of large reports to save the run time of the stored procedures and processing impact on report server.
• Created different sub reports that display another report inside the body of the main report.
• Exported the reports result into the PDF format and I had forwarded this OPS team.
• Created Cached reports to improve the performance by reducing the number of processing requests.
• Created different reports from SSAS by using MDX queries.
• Worked with different MDX queries to generate the different reports.
• Installed and monitored configuration of Performance point Server 2007 and integrated Performance Point Server with SharePoint.
• Created different reports and scorecard in Performance Point Server.
• Created different filters and KPI’s in Performance Point Server.
• Created Weekly, Monthly and yearly Dashboards and deployed it to SharePoint.
• Experienced in creating logical and physical ETL packages.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS 2012/2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLTP databases.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Used BCP command for copying large amount of data.
• Experienced in implementing an ETL solution that meets the corporate and production operations best practices
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used different storage method for SSAS. Used ROLAP storage method for performance of SSAS.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Worked with slowly changing dimensions.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Environment: Microsoft SQL Server 2005/2008/2012 Enterprise Edition, MS Access, MSBI Stack( SSRS,SSIS,SSAS),ProClarity, XIMS, .Net, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, Performance Point Server, Source Safe, T-SQL.

Confidential, Alexandria, VA

Sr. MS SQL Server Tech Lead

Responsibilities:

• Working with Cognizant for RHI Reporting integration with EDW.
• Experience with SQL Server 2008 and SQL Server 2005.
• Created different reports (parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports) depending on the business requirement.
• Proven ability in defining Query for generating drill down reports in SSRS 2005/2008.
• Modifying the existing the Dynamic Sql Stored Procedures to point to the EDW environment and applying the data model changes.
• Modifying the existing 100 reports to point to the new EDW environment.
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports and Map reports.
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Created snapshot of large reports to save the run time of the stored procedures and processing impact on report server,
• Created different sub reports that display another report inside the body of the main report.
• Exported the reports result into the PDF format and I had forwarded this OPS team.
• Created Cached reports to improve the performance by reducing the number of processing requests.
• Created different reports from SSAS by using MDX queries.
• Worked with different MDX queries to generate the different reports.
• Installed and monitored configuration of Performance point Server 2007 and integrated Performance Point Server with SharePoint.
• Created different reports and scorecard in Performance Point Server.
• Created different filters and KPI’s in Performance Point Server.
• Created Weekly, Monthly and yearly Dashboards and deployed it to SharePoint.
• Experienced in creating logical and physical ETL packages.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLTP databases.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Used BCP command for copying large amount of data.
• Experienced in implementing an ETL solution that meets the corporate and production operations best practices
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used different storage method for SSAS. Used ROLAP storage method for performance of SSAS.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Worked with slowly changing dimensions.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Environment: Microsoft SQL Server 2005/2008/2012 Enterprise Edition, MS Access, MSBI Stack( SSRS,SSIS,SSAS),ProClarity, XIMS, .Net, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, Performance Point Server, Source Safe, T-SQL.

Confidential, PA

MS SQL Server /SSRS /SSIS/SSAS Developer

Responsibilities:

• Experience with SQL Server 2008 and SQL Server 2005.
• Experienced in creating logical and physical ETL packages.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLTP databases.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Used BCP command for copying large amount of data.
• Experienced in implementing an ETL solution that meets the corporate and production operations best practices
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed and developed Data Warehouses, Data marts using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Create, manage, and query your enterprise data warehouse with SQL Server2005.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used different storage method for SSAS. Used ROLAP storage method for performance of SSAS.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Worked with slowly changing dimensions.
• Created different reports (parameterized, linked, adhoc, sub reports, map reports, drill through and drilldown reports) depending on the business requirement.
• Proven ability in defining Query for generating drill down reports in SSRS 2005/2008.
• Writing queries and stored procedures to generate reports for analysis of data using SQL Server Reporting Services.
• Responsible for scheduling the packages using Batch files every night and generating Sales Ranking reports using SSRS
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Created snapshot of large reports to save the run time of the stored procedures and processing impact on report server,
• Installed SharePoint and integrated SSRS with SharePoint.
• Installed and monitored configuration of Performance point Server 2007 and integrated Performance Point Server with SharePoint.
• Created different reports and scorecard in Performance Point Server.
• Created different filters and KPI’s in Performance Point Server.
• Created Weekly, Monthly and yearly Dashboards and deployed it to SharePoint.
• Experience in Testing for data-warehousing (Data Completeness and Data Quality).
• Assisted DBA team in configuring database mirroring and log shipping.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, MS Access, MSBI Stack( SSRS,SSIS,SSAS),ProClarity, XIMS, .Net, VB.Net, HTML, IIS, Visual Studio, C#, SharePoint 2007/2010, Performance Point Server, Source Safe, T-SQL.

Confidential, FL

MS SQL Server / SSRS /SSIS/SSAS Developer

Responsibilities:

• Experience with SQL Server 2008 and SQL Server 2005.
• Experience with web based architecture for front end OLTP.
• Used SQL Server Integration Services (SSIS) to implement the ETL operations that are required to build a data warehouse.
• Worked with different stored procedures, views and Functions.
• Added data to the Data Warehouse through development of source to targets maps and transformation rules using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages. Used BCP command for copying large amount of data.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models and in data analysis.
• Create, manage, and query your enterprise data warehouse with SQL Server2008.
• Proven ability in defining Query for generating drill down reports in SSRS 2005/2008.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Responsible for scheduling the packages using Batch files every night and generating Sales Ranking reports using SSRS
• Drill down Sales Report using Pie Chart or Bar Chart Representation.
• Architected, developed, tested, and deployed project Reports using ASP.NET 3.0.
• Developed reports using SSRS 2005 and Crystal reports and used table control, matrix control for cross tab reports
• Experience in Testing for data-warehousing (Data Transformation and Integration testing).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and Defined Key Performance Indicators and created aggregations in SSAS 2005/2008.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created different SSRS reports & dashboards from SSAS cube by making use of MDX queries.
• Integrates SSRS with SharePoint and deployed all the reports to SharePoint.
• Worked as BI SQL Tester who is responsible for back end SQL testing work.
• Conducted Performance Tuning using SQL Profiler and making using of execution plan for reports performance.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, MS Access, SSRS, SSIS, SSAS, ProClarity, XIMS, .Net, VB.Net, HTML, IIS6.0, Visual Studio, C# ASP.Net 3.0,T-SQL,TFS Server.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Involved in various stages like development, system Analysis &design, and creating stored Procedures.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Wrote different stored procedures for Reporting purpose.
• Created different SSRS report depending on the business requirement.
• Created different Tabular, Matrix and Chart Reports.
• Strong experience in developing Sub Reports, Matrix Reports, Charts, Drill down reports, using SQL Server Reporting Services.
• Involved in performance tuning of the SSRS reports.
• Created SSIS Packages to load the data from different files to SQL Server Database.
• Developed and coded applications in T-SQL.
• Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor. This report gives a detail report to the management on the Performance of the server.
• Maintained SQL Script for creation of Database Objects.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.

Confidential

Database Developer/Trainee

Responsibilities:

• Wrote User Defined Functions and Stored Procedures, and also defined Roles and Privileges to control access to database
• Created tables, Constraints, Defaults, Triggers, Views, and Indexes
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Load data using Bulk Insert.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Apply Service Packs for SQL Server database. Creation of new database, starting from scratch i.e. deciding the location of data files and log files on the disks. Reorganization of existing databases to standardize the placement of various databases related files.
• Creation of additional databases, logins and roles.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.
• Ensuring that the backups are running fine for various databases on different servers.
• Providing support to the Application developers on the application databases.

Environment: SQL Server 7.0/6.5, Visual Basic 6.0, and Windows NT 4.0