SUMMARY:

• 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.
• 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 Tableau 7.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, Roseland, NJ

MSBI 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.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• 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 Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• 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.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• 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.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• 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, MS SQL Server 2012/2008/2005, Tableau 7.0/8.1 Server and Desktop, Eclipse, Windows Server/professional, Oracle 12g, C#,VISIO, ERWIN.

SQL Server/MSBI 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 Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP 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.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• 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.
• Design and automate reports in SSRS for business People.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• 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.

SQL Server/MSBI 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.
• Perform data validation to ensure accuracy of analytic and operational models and SSRS reports.
• 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 ad-hoc 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.
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using 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.

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.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Design, develop, support and maintain Microsoft SQL Server Reporting Services (SSRS) reports.
• Provided MS SSRS 2008 training to clients in order for them to develop their own ad-hoc reports.
• Perform data validation to ensure accuracy in SSRS.
• Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
• 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.