PROFESSIONAL SUMMARY

• Over 7 years of extensive experience in IT industry as MS SQL Server BI Developer with SQL 2014/2012/2008 R2/2008/2005 (SSRS, SSIS, SSAS).
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as proactive team member.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Extensive knowledge in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, CTE (Common Table Expressions), Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors to facilitate efficient data manipulation and data consistency.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Bulk Copy Process (BCP)
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)
• Experienced in creating, migrating, deploying complex SSIS packages with complicated transformations like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc using SQL Server Integration Services (SSIS)
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in migration of SSRS reports from different versions of SQL Server
• Experience in developing Custom Report and different types of Tabular Reports, Drill down, Drill through, Parameterized, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance
• Experience in creating and managing fragmentation of Indexes to achieve better query performance, Query optimization and performance tuning
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Proficient in installation, configuration, and migration of data from MS SQL 2008 R2 to 2012.
• Hands on experience in developing QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
• Experienced working in Agile environment as a Scrum Master.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2008 R2/2005, MS office Suite (Access, Word, PowerPoint, Excel), Oracle 8i/9i/10g, MYSQL, Data warehouse, SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS)
• T-SQL, MDX, PL/SQL, XML, SharePoint, SQL Server Reporting Services (SSRS), Crystal Reports, OLAP, Tortoise SVN, GIT, Visual Source Safe (VSS), Team Foundation Server (TFS), Linux, Windows, Scrum, Agile Methodology, Qlik View, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, NH

SQL Server BI Developer

Responsibilities:

• Conducted daily scrum (Agile) meetings for our team also organized sprint planning, sprint retrospective and sprint demo.
• Actively participated in the role of Scrum master for our team which also involved gathering task requirement and creating stories in Version One.
• Gathered user requirements, analyzed and designed of software and database solutions.
• Created documentation for report development standards, report styling standards, defined the scope of data content, the structure, naming convention, keys, versioning, retention schemes, aggregations, recovery strategy and other key components to build the data warehouse.
• Developed database objects such as Stored Procedures, CTE, Functions, Tables, Triggers and Indexes using T-SQL.
• Created views to reduce database complexities for end users.
• Created DML scripts to create database schema and database objects.
• Development of custom scripts and stored procedures for data import and manipulation.
• Fine tuned DML, DDL scripts with lock hints for performance boost.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Created SSIS package to Export and Import data from SQL Server to Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Created ETL SSIS packages both design and code to process data to target databases.
• Used various SSIS task such as conditional split, derived column, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts.
• Maintain historical data in data warehouse used ETL to implement the slowly changing transformation.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created SSRS reports such as parameterized, cascade, drill down, drill through, charts, linked and sub reports as per company standards and requirements.
• Improving query / stored procedure performance for fast generation of reports.
• Deployment and maintenance of reports to report server.
• Auto dispatching of simple and complex reports with parameters to different business users using Data driven subscriptions all across the organization based on defined schedules.
• Managing off shore team.

Environment: Windows, Agile, SQL Server 2012/2014, SQL Server Business Intelligence Studio SSIS, SSRS, SSAS, Visual Studio, OLE DB, Erwin, Excel 2010, Access 2010, SVN, GIT, Qlik View, Version one.

Confidential, Graham, NC

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Designed Data Mapping, DDL scripts, Data Dictionary and Meta data
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• 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.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS
• Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
• Defined Calculated members, named sets, and executed other script commands using MDX expressions.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows, SQL Server 2008 R2/2012, SQL Integration Services (SSIS), SQL Reporting (SSRS), SQL Analysis Services (SSAS), Business Intelligence Studio, Visual Studio, OLE DB, Erwin

Confidential, Norristown, PA

SQL Server BI Developer

Responsibilities:

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, 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.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports, Linked, cascaded, parameterized, Drill Down and Drill-through
• Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Responsible for defining the complete Data Warehouse architecture (e.g. ODS, ETL process)
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed, developed and implemented the Dimension Data Model through multiple expert interviews for multiple fact tables.
• Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008 R2.
• Performed data transfers using BCP and BULK INSERT utilities.
• Performed performance tuning by studying Execution Plan, Analyzing Indexes.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Environment: MS SQL Server, SQL Server Management Studio (SSMS), SSIS, SSAS, OLAP, OLTP, SSRS, SQL Server Profiler, Visual studio, SQL Analyzer, Enterprise Manager and SQL Server Agent.

Confidential

SQL Server SSRS Developer

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Models for Business Users to create their own reports.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or other ETL jobs didn't interfere with each other.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Environment: SQL Server 2005/2008, Windows, T-SQL, SSRS, Share Point 2010, BIDS

Confidential

SQL Server Developer

Responsibilites:

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used MS access in test environment.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Experience in Data Modeling using Erwin Design Tool
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, SQL Server, MS Access, SSMS, Erwin, Windows, Visual Basic.