SUMMARY:

• 8+ Years of extensive experience in SQL Server Development including writing T - SQL Programming, Physical and logical Database Design, SQL server 2008/2012 suite of products SSIS, SSRS.
• Experience in migrating from SQL Server 2008R2 to SQL Server 2012
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes
• Experience in Normalization & De-normalization of database, Performance Tuning and Query Optimization.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters .
• Developed Tableau workbooks from multiple data sources using Data Blending .
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, correlated sub queries, Cursors and Triggers.
• Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2008/2012.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2008/2012
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart, Line graphs, sorting the data, defining subtotals in SSRS
• Proficient in using global variables, expressions and functions for the reports.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Migrated 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.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases

TECHNICAL SKILLS:

Databases: SQL Server 2008, 2012, SQL Server 2005, SQL Server 2000/7, Access, 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, PL/SQL, XML, MS SharePoint, MS windows

Reporting Tools: SQL Server Reporting Services (SSRS),OLAP

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux

Miscellaneous Tools: Windows Server 2008

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Lead SQL BI Tableau DEVELOPER

Responsibilities:

• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed a 360 business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Improve application's performances.
• Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.
• Prepare documentations for database applications.
• Using Teradata as source for Tableau reports
• Combining multiple data source to create a universal source for reports for different domains
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.

Confidential, Fort Lauderdale, FL

Lead SQL BI SSIS, SSRS/ETL DEVELOPER

Responsibilities:

• 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.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.
• Used cascaded parameters to generate a report from two different data sets.
• Developed reports for business end users using report builder with updating statistics.
• Interacting with business analysts and developers in identifying the requirements and designing and implementing the database schema.
• Documented and maintained database system specifications, diagrams, and connectivity charts
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Store procedures, User defined functions, Views, T-SQL scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending
• Created Health check reports with automatic notification.

Environment: MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2014,SQL SERVER 2014, oracle 12.1, Tableau10.0

Confidential, Miami, FL

Lead SQL BI SSIS, SSRS, Talend DEVELOPER

Responsibilities:

• Extensively used Joins and sub - queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• 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 the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Experience in creating Actuate reporting
• Experience with ASP.Net mvc
• Expertise In IT with exposure in Client Server and Web Development
• Creating Dynamic/Interactive web pages using Internet Tools.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad - Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• created Talend 5.1 as ETL transformation tool to migrate data from Oracle to SQL server 2012

Environment: MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, SSISSSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008,SQL SERVER 2008 R2 Master Data Services, oracle 12.1, Talend 5.1.

Confidential, Huntington Beach, CA

Sr. SQLBI SSIS, SSRS DEVELOPER

Responsibilities:

• Automated SSIS packages to load multiple files to SQL server
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Build SSRS reports to pull data as Pivot
• Worked with T-SQL, DDL, DML and DCL
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures
• Experience with ASP.Net mvc
• Expertise In IT with exposure in Client Server and Web Development
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Supported all production operation activities, with focus on integration and development of new and existing products and services
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Worked with internal and external clients for import and normalization of third-party data.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Environment: MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008,SQL SERVER 2008 R2 Master Data Services.

Confidential

SQL BI SSIS, SSRS DEVELOPER

Responsibilities:

• Created SSIS Packages to load data from Oracle to SQL Server
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Created Reports in Tableau and deployed them to production server.
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Developed Query for generating drill down reports in SSRS 2008/2012.Prepared AD HOC reports through report builders
• Created power pivots in excel
• Experience with ASP.Net mvc
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created reports using power BI
• Created report snapshots to improve the performance of SSRS.
• Created Event Handlers for the SSIS package on Error, on Post execute.
• Worked with T-SQL, DDL, DML and DCL
• Used Performance Point server 2012 to integrate SSRS reports
• Designed reports and tuned them for optimal performance when using multiple parameters.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle, DB2.
• Created complex SSIS packages using various transformations.
• Used Lookups Transformation to get the data from reference data sets
• Created permanent tables, temporary tables and table variables
• Making a Report as per user requirement using MS Reporting Services 2005/2008/2012.
• Worked on testing
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures
• Worked on share point architect

Environment: MS SQL Server 2008/2012, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008,SQL SERVER 2008 R2 /2012 Master Data Services.