SUMMARY

• Around 7+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment. Strong technical noledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience wif different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• In-depth noledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BIsuite, Reporting and Analyticsand ETL implementation using SQL Server Integration Services (SSIS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Extensive experience in creating complex Stored Procedures, Functions,Triggers, Views, Cursors, Joins and Sub queries wif T-SQL.
• Experience wif working on ProClarity Analytics server to analyze results produced in the Dashboard and SQLServer 2000/2005/2008 RDBMS database development including T-SQL programming
• SQL Server 2005 OLAP database development including KPIs, Data mining, working wif changing dimensions.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture. Experience wif adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
• Proven ability in generating Drill down and Drill through reports wif Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008
• Expert level skills inPHP, ASP, VB, COLDFUSION, HTML, DHTML wif MySQL, ORACLE and MS-ACCESS, DB2, SQL Server as database in developing custom applications based on client’s business requirements 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.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Experience in Creation and deployment of cubes on SSAS.
• Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions TEMPeffectively and aggressively in challenging environments.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008/2008R2/2012,SQL Source Control, DTS, SSIS, SSRS

Database: MS SQL Server 2012/2008/2005, MS Visual Studio 2008/2012, MS-Access

Language: C, C++, T-SQL, PL/SQL,HTML, C#, ASP.NET

ETL Tools: SQL Server 2012/2008/2005 Integration Services (SSIS)Data Transformation Services (DTS, Import Export Data, Bulk Insert

IDE & Application Server: Microsoft Visual Studio 2008/2005, SharePoint Server 2010, Qlikview

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Lead BI Developer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Developed, monitored and deployed SSIS packages.
• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• De- normalized existing normalized schemas to support quick data retrieval in reporting and OLAP workloads.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Created alerts for successful and unsuccessful completion of scheduled jobs into Enterprise Data warehouse (Kimball Methodology).
• Problem identification, troubleshooting and index tuning databases.
• Designed and developed Meta Data Service (MDS) and Data Quality Service (DQS) logic to maintain data integrity in data warehouse and transactional databases.
• Created functions to provide custom functionality as per the requirements.
• Utilized scripting technologies to clean data, move files from FTP locations to server file locations.
• Created Ad-Hoc reports, summary reports, sub reports and Drill-down reports using SSRS.
• Scheduled SSRS reports for daily, weekly, monthly reports for executive management team and customer representatives for various streams of the organization.
• Deployed SSRS reports in to SharePoint portal and Report Builder 3.0.
• Utilized Microsoft team foundation server and its features for code sharing and updates from other members.
• Used SSIS to implement slowly changing transformation, to maintain historical data in data warehouse.
• Used various SSIS tasks such as conditional split, derived column, which were used for data scrubbing, data validation checks during staging, before loading the data into data warehouse.
• Created SSIS packages to export and import data from different sources like CSV files, text files and load data into data warehouse.

Environment: MS SQL Server 2008R2/2012, Visual Studio 2008/2012,and BI tools SSIS, SSAS, SSRS. MS Office 2010/2013, MS Access, MS Excel, Framework, Visual Studio Team Foundation Server (VSTS), SQL Source Control

SQL BI Developer

Responsibilities:

• As a member of Database team, involved in gathering Requirement, Design, Development, Testing and Implementation of BI Analytics needs.
• Designing and implementingStored Procedures, Views, Indexes (Clustered and Non-Clustered), Functions and Triggersfor automating tasks.
• Developed (Monthly) trust level Performance Management Framework dashboard for executive management team and presented at EMT board.
• Trained business users and executive management teams in new BI tools power pivot and power view.
• Provided Quality/Assurance documentation to commissioners on weekly and monthly reports.
• Reported national level Quality Indicators, Quality assurance reports and Adhoc reports.
• Developed various Drill-through reports, parameterized reports and linked reports using SSRS. Deployed SSRS reports into Confidential SharePoint portal and Report Builder 3.0.
• Extracted Data from MIS data source provider on daily basis setup SQL server agent jobs to populate enterprise data warehouse using SSIS.
• Used SQL Profiler for troubleshooting, monitoring,optimizationof SQL Server and SQL code.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc.
• Designing and implementingETLprocesses to make data available for reporting purpose wifin a data warehouse.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Developed dashboards wifmulti-tabbedapplications wif multiplechartsper tab, lots of drilldowns to new views,calculationson-the-fly, the ability to slice and dice around specificdimensionsetc.
• Developedadvanced backupsystem through QlikView Publisher to allow forautomaticsaving of multiple versions of all QlikView applications and supporting files.
• Successfully loaded data from Excel, Access andFlat Files(.txt) into a SQL Server database Table.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Environment: MS SQL Server 2008R2/2012, Visual Studio 2008/2012, MS Office 2007/2010, MS Access, MS Excel, Visual Studio Team Foundation Server (VSTS), SQL Source Control, and BI tools SSIS, SSAS, SSRS, Power pivot, Power view,Qlikview 11Version R3.

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple joinstatements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Worked on Cross platforms like SAS (Statistical Analysis System) to SQL server, Transformed the SAS Macros to SSIS.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Developed, monitored and deployedSSIS packages.
• Worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
• Strong experience in working wifBCP,SSIS(DTS,DTSX)packages forData Integration Services.
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008/2012.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports wif sub reports, dynamic sorting, defining data source and subtotals for the report.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Identified and added the reportparameters and uploadedreports on to the report manager and organized them in folders.
• Worked in SDLC(Systems Development Life Cycle) for developing systems/Software

Environment: MS SQL Server 2012/2008 R2, MS SQL Server Integration Services 2005/2008, SQL Server Analysis Services, MS CRM 3.0/4.0, Windows Server 2003, ASP.NET, Query Analyzer, VB.Net, C#, Unisys, Wintel, Visual Studio, HTML, Java Script, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, SQL Clustering, Oracle, SAN,Source Control Management System, Index Tuning Wizard, SDLC, Data Warehousing, Data Transformation Services (DTS)

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
• Performing Replication (snapshot and transactional).
• Experience in Designing, Building the Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.

Confidential, Boston, MA

SQL Server Developer

Responsibilities:

• Worked wif Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Developed Cubes using SQL Analysis Services (SSAS).
• Involved in creating Named calculations and named queries.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQLprogramming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, Erwin, XML, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle