PROFESSIONAL EXPERIENCE

• Over 7 years of experience as SQL Server/Business Intelligence Developer in database designing, modeling and reporting using SQL Server 2012/2008/2005, SSIS and SSRS.
• Around 4 years of experience in Tableau Business Intelligence/Business Analytics software.
• Worked on each phase of data warehouse development life cycle - technical design and functional requirement documents, development, production deployment and support.
• Experience with all phases of software development life cycle (SDLC) and project methodologies.
• Expert in creating various SQL server objects like database, schemas, tables, indexes and indexed views, complex stored procedures, effective functions and appropriate triggers to facilitate efficient data manipulation and data consistency.
• Well experienced in data extraction, transformation and loading (ETL) between homogeneous and heterogeneous systems such as Oracle, DB2, Sybase and MS Access using DTS,BCP,SSIS 2005/2008/2012 and creating complex work flows with different tasks, containers (for loop, for each loop, sequence) and different transformations.
• Experience in developing custom reports and various Tabular Reports, Matrix Reports, Ad hoc Reports, Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise manager.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Expert in dashboards and visualizations using Xcelsius2008 and Tableau7.0/8.0/8.1.

TECHNICAL SKILLS

Languages: C,C++,T-SQL, VB, .net, Java

Databases & Business Intelligence Tools: MS SQL Server 2012/2008/2005/2000, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS)2012/2008/2005/2000, MS Access, Enterprise Manager, Tableau 8 Server/ Desktop

Web Technologies: XML Web Services, Microsoft Office SharePoint Server (MOSS) 2007

Reporting Tools: SQL Server Reporting services 2012/2008/2005/2000,Spotfire,Qlikview Logi XML, Crystal Reports

Web Server Technologies: Data Modeling Tool, ETL, Microsoft Visio, ERWIN, SharePoint

Operating System: Windows 2008, Windows 2000/2003 Server, data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

MSBI /Tableau Developer

Responsibilities

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Gained working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Optimized and Aggregated cubes with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.
• Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, Tableau 7.0/8.1 Server and Desktop, Eclipse, Windows Server/professional, Oracle 12g, C#,VISIO, ERWIN.

Confidential, Knoxville, TN

SQL Server/MSBI/Tableau Developer

Responsibilities:

• Involved in installation of SQL Server 2008 with the latest service packs.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Worked on database capacity planning and space forecasting.
• Migrated Database from SQL Server 2005 to 2008 by using side-by-side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Actively worked on SQL XML and X-path queries.
• Wrote scripts to review object permissions in all databases.
• Involved in Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Created SSIS packages in SQL Server 2008 for sources database for Tableau dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Migrated DTS packages from SQL Server 2005 to 2008 and scheduled their execution time.
• Created SSIS packages using Active X scripts and with Error Handling.
• Worked on enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Administered the created Reports by assigning permission to the valid user for executing the reports.
• Created and Maintained Database Maintenance Plans.
• Implemented Database Mirroring between Development and Test Server.
• Involved in Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Integrated SQL Server 2008 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Reviewed Third Party tools so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.

Environment: MS SQL Server 2005/2008, Tableau 8.0/8.1 server and desktop, SharePoint Portal, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, VSS, SQL Diagnostic Manager, Power Designer.

Confidential, Montvale, NJ

SQL Server/MSBI/Tableau Developer

Responsibilities:

• Dynamically supporting business users & Customers for given requirements and developed reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Tableau combination charts using Tableau visualization software.
• Generated various reports with drilldowns, drill through, calculated members and dropdowns.
• Created data sources, connection strings and defined the datasets for generating the report.
• Using various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Built and deployed Report Models using Report Builder 2.0 to facilitate ad-hoc reporting for end users. Working with various Delivery mechanisms of Reports like Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2012/2008/2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau 7.0, Logi XML, Spotfire, Qlikview, Business Intelligence Development Excel, Visual Source Safe (VSS), Windows XP, VB, Crystal Reports.

Confidential, OH

SQL SERVER/MSBI DEVELOPER

Responsibilities

• Created and reported applications from MS Excel and MS Access using Crystal Data mining and query development using SQL scripting providing Level I & II Support for the project.
• Developed and maintained custom data driven applications using SQL Server, Reporting and Integration (SSRS, SSIS) Services to track Data transactions such Collections and Banking.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Automated tasks using job schedulers, optimized Transact-SQL code, performed SQL query performance analysis and tuning on a regular basis.
• Developed SSRS reports from back end 2005/2008 SQL Server Database using Stored Procedures, Triggers, Transact SQL, Views and Queries
• Maintain, analyze, troubleshoot, and repair computer systems, hardware and computer peripherals (laptop and desktop).
• Data uploading, retrieval from a server, analyzing, testing and Encryption using Eclipse system. Reinstalls software programs or adjust settings on existing software to fix DVD/CD Manufacture machine malfunctions.
• Developed back end 2005 SQL Server Database using Experience in Stored Procedures, Triggers, Transact SQL, Views and Queries.
• System Administration, DNS/ DHCP, TCP/IP connectivity, and Active Directory i.e User log and password reset.
• Technical and Application support such as, diagnose, troubleshooting and resolve software and hardware problems. Desktop and laptop repair, software imaging/reloading on PC and Mac.
• Configure and connect share printers into network, System security such us virus and malware removal system deployment and upgrading.

ENVIRONMENT: SQL Server 2005/2008, MS Excel, SQL BI Suite (SSIS, SSRS), Windows Server 2008, Oracle 12g, C#.

Confidential

SQL Server Developer

Responsibilities:

• Merged existing databases and to design new data models according to the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configure SQL Servers 2005 and 2008 on development server for designing and testing.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created complex Stored Procedures, Views, Triggers, Tables and other SQL joins.
• Maintained data integrity by performing validation checks.
• Provided research, design, and creation of a robust system ensuring effective processing of financial information from multiple external locations.

ENVIRONMENT: MSSQL Server 2005, Windows Server 2003/2000, Windows NT, Visual SourceSafe, DTS, MS Access, Enterprise Manager, Analysis services 2000,HP Helpdesk, MS office 2003,VB macros.