SQL Server / SSIS SSAS SSRS Developer

Professional Summary:

• An accomplished, quality-driven IT professional with over 7 years of experience in design, development and implementation of business requirements as a Microsoft SQL Server 2008/2005/2000 Developer/BI Developer.
• Domain expertise in Consulting, Retail, Banking, and hospitality.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS and SSRS
• Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle.
• Hands on Experience in Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2005/2008/2008 on different Windows Environments.
• Excellent understanding of Relational Database Systems, Normalization, Data Mining, and Data Warehousing.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects.
• Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages, DTS and BCP utility.
• Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
• Extensive experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS) 2008 and excellent understanding SSIS Control Flow items and SSIS Data Flow items
• Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS) using SQL SSRS 2005/2008.
• Good Understanding ofData warehouse conceptssuch as like Kimball model, Inman model, Star-schema and Snow flake schema.
• Skilled in creating MDX cubes and dimensions and their performance optimization
• Developed Scorecards with advance set of dashboards using different Business Intelligence tools such as ProClarity and Performance Point Server.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008) and features.
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Experience In the integration of SSRS Reports using various web parts into Dashboards and Sharepoint

Technical Skills:

• RDBMS: SQL Server 2005/2008/2008R2, MS Access
• Languages: Basic C++, T-SQL, PL/SQL, Visual Basic 6.0., Unix Scripting, Java
• Operating Systems: Windows Server 2003, Windows 2000 Advanced Server/Server, Windows NT 4.0, Windows XP, Windows 7, MAC OSX, Linux, Unix
• Tools/Utilities: Enterprise Manager, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Database Tuning Advisor, SQL Profiler, Query Analyzer, Microsoft TOAD (for Oracle)
• Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET.
• ETL Tools: SSIS, DTS (Data Transformation Services)
• Tools: SSAS, Erwin 4.0/3.5,Performance Point 2010
• Reporting: SSRS (MS SQL Reporting Service), Crystal Reports, MS Access, Excel, Data Analyzer

Work Experience:

Role: Sr. BI Developer

Insurance Auto Auctions (IAA) is one of the leaders in the salvage auto auction industry which operates in partnership with variety of sellers including insurance companies, dealerships, rental car companies, and fleet lease companies. Our team was responsible for implementing Enterprise Data Warehouse conversion project from Business Objects to MS SQL Server where we performed data migration with the help of ETL and stored procedures. In addition, our team performed analysis using cubes and developed reports for end users using SSRS.

Responsibilities :

• Analyzed the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
• Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Developed and worked with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2008.
• Created Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations
• Worked with a combination of multiple Control Flow Tasks, Data Flow Tasks and Dataflow Transformations to build packages in SSIS packages especially For Loop and For Each Loopcontainers with Execute SQL and Script Tasks.
• Implemented major Event Handlers like OnError, OnProgress and OnTaskFailed for SSIS Packages.
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Developed the OLAP processes for changing and maintaining the Data Warehouse, Optimizing Dimensionsand adding new Aggregations to the Cube.
• Worked with Calculations, Key Performance Indicators and Aggregations on SSAS Cubes.
• Analyze, design, develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes as well as migrating reports to SQL Reporting Services from Crystal Reports and Microsoft Access.
• Extensively used Report Manager to configure Web URLs, E-mail and Databases to prepare reports and make reports visually appealing by adding different report formatting options and also provided back-end support for functional testing and performance testing.

Environment: SQL Server 2008R2 Enterprise, Windows Server 2003 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Erwin, Performance Point Server, Microsoft Office Share Point Server, OLTP, OLAP, XML.

Role: Sr. SQL Server / SSIS / SSAS / SSRS Developer

Ericsson is a world-leading provider of telecommunications equipment and services to mobile and fixed network operators. The objective of the project was to develop a Data Integration and Analysis system to cost-effectively triple the data capacity of a GSM/GPRS network, paving the way for advanced data services. This includes building SSIS Packages to load data from various sources into SQL Server with necessary transformations, performance tuning of SSIS Packages, Building SSAS Cubes and Report Generation with SSRS.

Responsibilities:

• Extensively used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Designed complex T-SQL queries, user defined functions; stored procedures and triggers followed by thorough analysis and testing of those database objects before deployment to the production server.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environment and extracted the data usingSSIS from OLTP to OLAP.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data.
• Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Worked on variety of types of chart reports such lines, columns, bars with both 2D and 2D views in order to display cumulative totals based on day to day requirement.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL and SSRS

Role: SQL Server/SSIS /SSRS Developer

State Street is a leading financial services provider serving some of the world’s most sophisticated financial, corporate, and business institutions. The project was to re-organize the customer database with the latest information on loans, payments, fixed-deposits and huge transactions. As a SQL / BI Developer, I was involved in altering the physical design, developing stored procedures and functions, developing DML scripts, fine tuning complex queries and also maintaining backups.

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page

Environment: Microsoft SQL Server 2005/2008, Windows Server 2003, Windows XP, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Role: SQL Server Developer/ SSIS / SSRS

Foot Locker,Inc. is the world\'s leading retailer of athletic footwear, apparel and accessories. I was part of the team performing various ETL operations to gather information on customer online orders from the OLTP and load into an existing Operational Data Storage to make necessary data transformations for the orders to be processed efficiently. In addition, our team designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Participated in the Normalization and De-Normalization of database along with creating and managed clustered and non-clustered indexes to improve database performance.
• Designed SSIS packages that could run on various environments by creating various types of XML and SQL Server configuration files for the variables being used in the packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations and actively supported business users for change requests.
• Extensively used for loop Containers and foreach loop containers to perform dynamic tasks in SSIS.
• Monitored performance and optimized SQL queries for maximum efficiency and planned the complete Back-up of various Databases for disaster recovery scenarios.
• Identified and added the report parameters; uploaded reports on to the report manager and organized them in folders.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed the generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, MS Excel, Window XP, Toad.

Role: MS SQL/BI Developer

BCG is one of the most prestigious management consulting firms in the world. The objective of the project was to develop a Data Integration and Analysis system to generate incentives for an international retail banking client based on the information from customer transactions. Being a part of the reporting team our primary objective was to design and develop time and expense reports for the application using SSRS and present it in a clear and coherent manner to the senior management. Played a key role in the design and developing the reports and in the performance tuning of the reports.

Responsibilities:

• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
• Created SSIS Packages to integrate data from Text files and Excel files and File Transfer from one location to the other using FTP task.
• Involved in Data Migration of Packages from DTS to SSIS by using advanced features in SSIS (Aggregate, Sort).
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and different Data Flow Tasks.
• Worked on Extracting Transforming and Loading data using SSIS Import/Export Wizard.
• Worked extensively with Key Performance Indicators (KPIs) and published them to SharePoint for further Business Analysis.
• Import Data Sets from various sources like Oracle, Flat Files, Excel into SQL Server Data Warehouse.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Performed Sorting, formatting, and Grouping to custom reports in (SSRS) and also published reports to the Report Server virtual directory.

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio,.Net 2.0 FrameWork, SQL Server Profiler, SSIS, SSAS,SSRS, IIS, T-SQL, PL/SQL

Role: MS SQL Developer

Himalayan Bank is one of the leading banking companies in Nepal offering financial services to industrial organizations. The project was to develop the application for the online transactions, which calculate the commissions for brokers and employees based on number of deals completed. I was involved in requirement analysis, creating database, tuning stored procedures, making DTS package to setting up jobs, backup’s and restores.

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases. Using joins, database links and formatted the results into reports and kept logs.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: MS SQL Server 2005, T-SQL, DTS, Windows XP, MS Visio 2000, MS Projects 2000.

Education

• Bachelors of Arts in Economics