SUMMARY:

• Detailed - oriented, highly qualified MS SQL Server/ETL/Business Intelligence Developer with over 7 years’ professional experience in designing and developing T-SQL queries, ETL packages using SSIS, and reporting solutions using SSRS and Tableau.
• Experienced in Data Extraction, Transformation and Loading (ETL) on Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server.
• Expertise in developing and debugging Stored Procedures (SPs), User-defined Functions (UDFs), Triggers, Indexes, Constraints and Queries using Transact-SQL (T-SQL).
• Experience in query optimization and performance tuning using performance tools such as SQL Server Profiler and Database Engine Tuning Advisor, as well as analyzing Execution Plans, creating Clustered and Non-Clustered Indexes, and performing Horizontal Table partitioning.
• Proficiency in creating, documenting and deploying ETL packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services (SSIS) to load data into data warehouses and data marts.
• Extensive experience in staging data, cleansing data and transforming data using Sort, Lookup, Fuzzy Logic, Execute SQL Task, and to remove unwanted data, ensure data quality and apply business rules.
• Profound understanding of Enterprise Data Warehouse modeling concepts including OLAP/OLTP, Fact/Dimension tables, Top-down/Bottom-up models, Star/Snowflake schemas.
• Excellent hands-on experience in capturing and preserving the state of data by setting up Slowly Changing Dimensions (SCD), Change Data Capture (CDC) mechanisms to extract data from source data with incremental load.
• Strong knowledge in designing and developing complex reports such as Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports and Snapshot Reports in SQL Server Reporting Services (SSRS) and deploying to end users through Data-Driven subscriptions and SharePoint Server.
• Expertise in building, publishing, customizing interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in System Development Life Cycle (SDLC) from requirement analysis, system design, and acceptance testing, to system deployment, maintenance in Agile and Scrum development environment.
• Good team member and strong individual with excellent verbal and written communication and analytical skills.

TECHNICAL SKILLS:

Database Systems:: MS SQL Server 2005/2008/2008 R2/2012, Oracle Database 10g/11g, MS Access, MS Excel

Development Tools and packages:: SSMS, SSRS, SSIS, Tableau, MS Visual Studio

Languages:: T-SQL, C#, JavaScript, HTML, CSS

Development Environment:: Waterfall, Agile/Scrum, JIRA, TFS, SharePoint, Windows Server

PROFESSIONAL EXPERIENCE:

Confidential, Farmington, CT

BI Developer

• Gathered user requirements from various end users including management and operation teams and related departments.
• Developed the ETL (Extract, Transform, Load) strategy to transfer data from source files to landing area, staging area and the target tables in the data warehouse and OLAP database using SSIS.
• Transferred data from remote datacenter to local datacenter using SSIS.
• Implemented SSIS packages to extract data from Excel spreadsheets to SQL Server, automated all of the SSIS packages and monitored errors.
• Designed and developed reports including drill-down reports, drill-through reports to meet requirements for management and daily/Monthly/Quarterly operation.
• Customized parameterized reports, Sub reports, Nested Region reports and Linked reports.
• Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL Task, Sequence Container, Breakpoint and Checkpoint.
• Manipulated the data cleaning and data mapping between multiple sources and centralized databases.
• Deployed SSRS/Tableau monthly reports and applied business rules to maintain the data security and integrity prior to the disclosure of the information. Gathered and prepared the requirements from clients for product design and enhancement.
• Developed Tableau workbooks to perform YoY, MoM, YTD, QTD and MTD and region division type of analysis.

Environment: MS SQL Server 2012, SSMS, SSIS, SSRS, Tableau Desktop 8.x/9.x, MS Visual Studio 2008, MS Office

Confidential, Winsor, CT

MS SQL/BI Developer

• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file and other file format to MS SQL Server using SSIS services.
• Extensively worked on Stored procedures, triggers, Views, CTEs, T-SQL scripts, schemas, and performance issues with client/server database design.
• Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams.
• Created Tables, Stored procedures, User def ined func tions, Data mapping. Created SQL scripts for tuning and scheduling.
• Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse database and data mart database.
• Worked with data storage sharing across the company and with the TFS for implementation of the business priorities.
• Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards, etc.)
• Created Stored procedures to migrate data from Flat File structure to a Normalized Data structure.
• Developed stacked bar chart in SSRS for the top-level management to view the test status of Apps across the organization.
• Created Parameterized Reports and linked reports and thorough knowledge of report server architecture using SSRS
• Worked as a member of the technical team that includes developers and DBAs and closely with the members of the business team.
• Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables.

Environment: SQL Server 2012/2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio, MS SQL Server, T-SQL, Windows 2007/2010, MS Excel, TFS, Visual Studio 2008/2012.

Confidential, McLean, VA

MS SQL Developer

• Understood and analyzed the business logic and implemented the same into a functional database design.
• Created T-SQL queries with complex logic to search for required operations, service information.
• Debugged the ETL packages by using breakpoint in SSIS.
• Created, developed and deployed multiple drilldown and drill through reports by using SSRS.
• Planned, defined and designed data upon business requirements and provided documentation.
• Created various packages to validate, extract, transform and load data from the existing diversified data sources to centralized SQL Server database using OLE DB providers.
• Filtered data using T-SQL statements, and implemented various types of constraints and triggers for data consistency in SSMS.
• Maintained MS SQL Server database servers in a multi-site environment using clustering and high availability configurations.

Environment: SQL Server Management Studio (SSMS) 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, MS Office.

Confidential, Marlborough, MA

BI Developer

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard/dashboard on SQL Server 2008 using SSIS/DTS, SSRS.
• Monitored full/incremental/daily loads and support all scheduled ETL jobs for batch processing.
• Migrated DTS packages to SSIS packages.
• Involved in migration of Database from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrade of system configuration.
• Installed, configured and deployed reports using SSRS.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Transferred data from OLTP to data warehouse using incremental loads, full loads to perform different data flow and control flow tasks in SSIS.
• Implemented failure alerts using email in SSIS.

Environment: SQL Server Management Studio (SSMS) 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, MS Office.

Confidential

MS SQL Server Developer

• Interacted with system users to identify data required for processing.
• Involved in logical and physical design, development and testing of the system.
• Developed T-SQL code for the application.
• Created Stored procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for the applications.
• Experienced in writing SSIS script tasks, look up transformations and data flow tasks using T-SQL.
• Designed and implemented stored procedures and triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and recovery.
• Developed, deployed and monitored SSIS packages. Performed daily tasks including back up and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Published High-level technical documentation to set standards, guidelines and best practices for SQL Server Database installation, Administration, Database security.
• Developed SQL Server Stored procedure and DTS packages to extract data from database.

Environment: MS SQL Server 2005/2008, SSIS 2008, SSRS 2008, Visual Studio 2008, Windows XP, SQL Server Profiler, MS Office.