SUMMARY

• SQL BI Developer with over 8 years of IT Experience in SystemDesign, Development and Support of Microsoft SQL Server / in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance.A Smart Working, Motivated, Detail - oriented team player with excellent communication, Leadership, Interpersonal and problem solving skills.
• Experience in installation, upgrade and configuration of MS SQL Server database.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Migrated XML scripts into SQL server 2008 forming sequenced tables.
• Proficient in writing complex queries and stored procedures in SQL Server 2008.
• Proficient in data migration from SQL Server 2005 to SQL Server 2008.
• Migrated SQL server 2008 tables into CSV files using SSIS packages.
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Proficiency in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
• 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.
• Experience with SQL Server 2005 and MS SQL Server 2008 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Transformed data from one server to other servers using tools like Data Transformation Services (DTS) (2000) and Sql Server Integration Services (SSIS) (2005).
• Transformed database objects from one server to others server using SSIS.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Migrated Organization, Orders, Adjustments, Objectives and Callide data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS).
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP,
• Data Replication and DTS Packages.
• Extensive experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment, Production Support and Help Desk support.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Worked with the team in building the daily dollar, summary, funnel genie, objective and adjustments reports.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Expertise in writing and debugging Stored Procedures and Triggers.

TECHNICAL SKILLS

Databases: SQL Server 2005, 2008, 2012, 2014, Access, Oracle 8i/9i/10g, MySql, data warehouse.

Database Tools: SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL

Languages: T-SQL, C, C++, VB.NET, PL/SQL, C#

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, UNIX, Windows 7 Professional, Windows Server 2008R2.

PROFESSIONAL EXPERIENCE

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Experience writing complex T-SQL Queries.
• Created stored procedures for SSRS reports.
• Used Execution plan to analyze Query performance.
• Implemented indexes to improve the performance of the reports and stored procedures
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports.
• Migrating SQL Server database from 2008/2012.
• Worked with production support team to troubleshoot the issues during production deployment.
• Used Sql server profiler to understand the application flow and fix issues.
• Experience creating useful indexes to enhance query performance.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Created Triggers to enforce data and referential integrity.
• Defined Views, Constraints and Triggers to implement business rules.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling.
• Backing up and restoring the databases in Production Environment.
• Involved in testing and debugging stored procedures.
• Scheduled database backup and performed full, incremental and differential backups of database and transaction logs.
• SQL Business Intelligence (SSIS, SSAS, SSRS)
• Re-designed and create new SSIS packages.
• Upgraded existing SSIS packages (2008/2012).
• Created SSIS packages with complex transformations.
• Created dynamic data flow task using script task.
• Created complex sub reports, bar charts and matrix reports.
• SSRS reports as per the requirement.
• Responsible for maintaining and upgrading reporting service.
• Integrated Reports with the UI.
• Experience creating Data Marts.
• Used Data marts to create report model for the report builder and write report builder reports.
• Responsible for reporting services permissions.
• Experience with drill down and drill through and Ad-hoc reporting.
• Used MDX in reports to retrieve data from cubes.
• Created calculated measures that fit business logic, using MDX queries.
• Experience with managing the Cube process scheduling and maintenance.
• Implemented Custom SSIS logging to the existing packages.
• Modifying existing Crystal reports.
• Used Script task extensively while creating the packages.
• Maintaining and TroubleShooting Existing Packages.
• Experience in scheduling database backup and performed full, incremental and differential backups of database and transaction logs.
• Creating function specification (FSD) and Quality control documents for the new functionality and defects.
• Created Autosys and sql server jobs to schedule SSIS.
• Deployed the DTSX, configuration files and .net scripts to various environments using Anthill pro
• Used TFS to check in Database objects and .net code.
• Experience with Microsoft office
• Uploading files into SharePoint.
• Creating SharePoint web parts.
• Experience in using version control tools such as TFS and SVN.
• Designed and modified reports using Tableau.
• Used c# and vb.net to create script tasks in SSIS.
• Used IBM Direct Connect in SSIS packages for secured file transfer.
• Enhancing existing crystal reports.
• Experience with IIS.
• Experience with scripting languages such as batch, PowerShell.
• Used HTML in script task to create dynamic Emails.
• Experience with other BI tools such as OBIEE, Tableau.
• Experience with reporting tools such as Cognos and crystal reports.

Environment: SQL Server 2008/2012,2014, SSIS, SSRS, SSAS,C#.Net, ASP.Net,VB.Net,.Net Frame work 4.0 and 4.5,Visual Studio 2010,2012 T-SQL, ETL, Oracle 10g, DB2, ActiveX, Tableau,Microsoft Office, MS Access, Windows 2008R2,Autosys,IBM Direct Connect, Crystal reports, Cognos

Confidential, Oakland,CA

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Installed and configured SQL SERVER 2008 in test environment with latest service packs and migrated few databases.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and Modified Triggers and Dynamic Cursors in T-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers.
• Designed ETL packages for different data sources (XML, SQL Serverand Flat Files). Created indexes for the fast retrieval of data from the database.
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Created Triggers to enforce data and referential integrity.
• Tested to optimize the procedures and triggers to be used in production
• Defined Check constraints, Business Rules, Indexes, and Views.
• Actively Involved in Testing and Debugging the stored procedures
• Testing QA data against Production data.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SSIS packages to migrate the old Bills info, Customer Information, Contracts Information and other important data from the Oracle System.
• Designed and implemented data caching algorithm.
• Used Performance point service to integrate SSRS reports using Dashboard filters.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Cubes and used basic MDX to retrieve the result.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed.
• Developed the front-end screens in C# .NET using Visual Studio IDE.
• Written conversion scripts using SQL, PL/SQL, stored procedures to migrate data from SQL server database to Oracle database and to retrieve data using cursors and exception handling.
• Created a SQL reporting services (SSRS) and SSIS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used Power pivot to create tables using SSRS.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Using SSRS delivering enterprise, Web-enabled reporting, create reports that draw content from variety of data source.
• Used SSRS report catalog to store the configuration, Security and Caching Information for the operation of report server.
• Consumed Web Service Components for authenticating the user credentials.

Environment: SQL Server 2005/2008, SSIS, SSRS, SSAS,C#.Net, ASP.NET(2.0), T-SQL, ETL, ERWIN 4.0, Oracle 10g, DB2, Active X, .net, Microsoft Source safe, MS Access, Windows 2003

Confidential, Knoxville,TN

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Designed and Maintained SSIS packages with complex Transformations.
• Experience with Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Deployed Reports, SSIS packages, Reports to production Environment.
• Scheduled SSIS packages using Autosys.
• Used Anthillpro to check- in database objects and .Net code
• Scheduled and Maintained Multiple SSIS packages.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Migrated Sql database from
• Created complex stored procedures and referred the stored procedures in ASP.Net.
• Updated existing Crystal reports and SSRS reports with new business logic.
• Worked on Query Optimization through query Analysis and Index Optimization.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Used HP Application lifecycle management to log defects.
• Deployed reports on report server and integrated to Silverlightapplication.
• Proficient in working on errors and event handling: Break points, Checkpoints and precedence Constraints.
• Used C# to write complex SSRS reports.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Created SSRS reports with Drill down and drill through functionality.
• Moving reports from one server to another server.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created Pl/SQL scripts to extract the data from the operational database into simple flat text files.

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS,C#.Net, ASP.Net,VB.Net,.Net Framework 4.0 and 4.5,Visual Studio 2010,2012 T-SQL, ETL, Oracle 10g, DB2, ActiveX, Microsoft Office, MS Access, Windows 2008R2,Autosys,IBM Direct Connect, Crystal reports.

Confidential, Scottsdale, AZ

SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Created SSIS packages to migrate the Anti-Virus Test results to Sql 2012 Database.
• Scheduled and Maintained Multiple SSIS packages.
• Migrating SQL Server database from 2008/2012.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2012 (using SSRS, T-SQL, scripts, stored procedures and views)
• Designed ETL packages for different data sources (XML, SQL Server, Flat Files). Created indexes for the fast retrieval of data from the database.
• Create SSRS reports against Team Foundation Server Database.
• Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups.
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Experience with .NET 4.0 and 4.5
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Retrieved Data from cubes using Complex MDX Queries.
• Worked extensively writing Release and Product Reports for stakeholders.
• Wrote customized Team foundation reports according to the companies’ customized workflow.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Used C# to write complex SSRS reports.
• Developed Multiple Cubes using SSAS, managed the Cube process scheduling and maintenance.
• Created MDX script for representing Cube Calculation using SSAS.
• Involved in Creation of Dimensions using STARand SNOW FLAKE Schema.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Involved In writing Complex T-sql Queries.
• Backing up master & system databases and restoring them.
• Worked on Query Optimization through query Analysis and Index Optimization.
• Actively involved Normalization & Denormalization of database.
• Involved in integration of c#.Net front end with SQL Server backend.
• Developed Stored Procedures and Functions to implement necessary business logic for interface and reports
• Experience with SharePoint and SharePoint web parts.
• Involved in testing and debugging stored procedures.
• Scheduled database backup and performed full, incremental and differential backups of database and transaction logs.

Environment: SQL Server 2008/2012, SSIS, SSRS, SSAS,C#.Net, ASP.NET(2.0), T-SQL, ETL, ERWIN 4.0, Oracle 10g, DB2, ActiveX, .net, MS Access, Windows 2003,Microsoft Excel.

Confidential

SQL BI Developer

Responsibilities:

• Involved in taking backups of SSAS database and restoring them when needed.
• Created indexes on tables, views to improve the performance of queries.
• Developed flowcharts for complex stored procedures.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services.
• Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages.
• Worked on creation of dashboards, scorecards and building reports using performance point server 2007.
• Used Lookups Transformation to get the data from reference data sets
• Scheduling the SSIS packages and Jobs.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Responsible for modifying the stored procedures, rebuilding indexes for improving performance.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005
• Created SSIS Packages to migrate slowly changing dimensions
• Used OLAP Processing Tasks for automatic processing of OLAP Databases.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Worked on ProClarity to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Worked with T-SQL, DDL, DML and DCL.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Involved in demoralization of tables for reporting purposes.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created permanent tables, temporary tables and table variables.
• Translating business requirements into technical design specifications.
• Used Query Analyzer to optimize SQL queries.
• Developed perspectives to simplify the process of browsing the cubes.

Environment: MS SQL Server 2005, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, Erwin, ProClarity, QueryAnalyzer, MS Office 2003.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005/2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office SharePoint portal server MOSS 2007.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#.
• 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.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Dashboards and reporting services web parts using Moss 2007.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• 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.

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