SUMMARY

• Over 6 years of extensive experience in Database design, development and administration of applications with MS SQL Server versions 2014/2012/2008 R2/2008 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in creating and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS 2012/2008R2.
• Expert in generating Drilldown reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, charts in SSRS 2008R2/2008.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Executed effective processes for modification of existing SSIS packages as per new business requirements.
• Experienced in working with project manager, development team, business analyst and end-users.
• Experienced in SQL Server Analysis Services OLAP Cubes and Data Mining.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Used SQL Server reporting services 2008R2/2008 for generating reports.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Experience in Database Backup, Recovery and Disaster Recovery procedure
• In depth knowledge in T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Experience in creating Dashboards using QlikView.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to multitask, adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows /2000/2003

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Responsible for working with business analyst to translate functional and technical specifications into a comprehensive reporting design.
• Understand user requirements and Data Model defined and developed by the business analyst and data architects.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed and architected of OLAP cubes to support business analystreporting and forecasting processes.
• Extensively worked on Data Flow tasks like For each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2012 using SSIS.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS), Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2012(SSAS)
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Deployed the packages to production using XML package configuration.
• Configuration and Deployment of all reports across various SDLC environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Defined parameters for parameterized Reports using SSRS

Environment: SSRS 2012, SSIS 2012, Data Stage, DB2, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe.

Confidential, Pittsburgh, PA

Sr. SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Requirements gathering from the business analyst and preparing POC documents for the design & development of BI solutions(ETL/Reporting)
• Analyzed, Defines, and documented the businessprocesses and user requirements in accordance with current policies and procedures.
• UsingSSIS, loaded XML data to the Database tables and Extracting Data usingSSISinto Excel Files for Marketing purpose.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS.
• Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Performed server installation and configuration using SQL server2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Created automated stored procedures for day end operations using SQL server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, Fast export.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Worked in Enterprise Manager for job scheduling and batch queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MS OLAP Services.
• Maintained the consistency of the client’s Database using DBCC.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment: SQL Server 2012, 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential, Walnut Creek, CA

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complex SSIS packages extensively for data loads and businesslogics implementation.
• Worked on different tasks in control flow like For each loop container, Execute process task, execute SQL tasks to implement the businessneeds
• Coordinated with businessteams to plan application remediation efforts for incompatible applications.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2008R2 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Created complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Developed reports using SSRS 2008 and SSRS 2008 R2.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Experience in creating snapshots of static reports and configure subscription.
• Involved in data Extraction and Transformation from source database and Loading to EDW (Enterprise Data Warehouse) with DataStage using DataStage design toll in the parallel processing mode.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Used DataStage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Erwin, TFS, MDX, Oracle 10g, ProClarity, MS Excel.

Confidential, Edison, NJ

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in developing Packages for implementing Businesslogic through Stored Procedures and Functions.
• Understanding business requirements and conduct follow-up meetings, if necessary, with end-users
• Developed new process for the new Implementations, support activities and Change requests and to update the BusinessProcess Management (BPM) document accordingly.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL
• Worked with development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Involved in Database design & Data modeling various databases.
• Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
• Prepared technical documents like High Level Design
• Involved in Business Analysis & Requirement collection.
• Understanding Customer requirement via interaction and writing functional specification.
• Wrote complex stored procedures and cursors to implement various business logics as per the client requirements
• Optimizing existing queries and fixing query performance issues.
• Actively interacted with end user to gather business requirement, system specification and enhancement.
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Experience working in agile environment and supported iterative testing methodology.
• Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating with my counterparts in the other teams.

Environment: MS SQL Server 2008/2008R2, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, ProClarity, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Confidential

SQL Server Developer

Responsibilities:

• Involved in planning, defining and designing data based on businessrequirement and provided documentation for further reference.
• Documented BusinessRequirement Documents (BRD) from essential BusinessProcess, Business Rules.
• Assisted with the analysis and management of critical storage and data protection capacities. Improved reporting by producing businessrequirements documents to capture metrics, and by creating resulting charts and graphs to provide rapid understanding of issue management.
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.

Environment: SQL Server, SSRS 2005, Windows 2003 server.