SUMMARY

• Over 7+ years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• 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.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Experience in dealing with high volume transactional data in SQL
• 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).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• 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.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

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 / 98/2000/2003/ XP/Vista

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

PROFESSIONAL EXPERIENCE

Confidential -Woodland Hills CA

Senior SQL BI Developer(SSIS/SSRS)

Responsibilities:

• Key role in team of 4 in brining 2005 SQL database environment to SQL 2008R2 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
• 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.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 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.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• 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.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Used SQL Server Agent for scheduling jobs and alerts.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2012/2008R2/2008/2005, SSRS 2008, SSIS 2008, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, St Petersburg, FL

Senior 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 complexSQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• 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.
• 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.
• 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.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• 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.
• Lead the team of developers to write efficient code.

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

Confidential, Minnesota- MN

SQL SERVER DEVELOPER

Responsibilities:

• Gathered end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic sql queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions and cte's.
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre execute, post execute and error.
• Involved in package logging in both standard (SQL server and file based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using dtexec utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created adhoc reports more often based on end user requirements.
• Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Build effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).
• Managed and implemented SSIS packages to do the nightly refresh of data
• Answered technical inquiries and responded to troubleshooting requests

Environment: SQL server 2000/2005/2008 , SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Participated in the installation of SQL server. Installed SQL server enterprise manager tools using SQL Setup.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Optimized queries by looking at execution plan for better tuning of database.
• Designed and developed various complex reports using drill down, drill through, cross tabbed reports etc.
• Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.
• Responsible for ongoing maintenance & management of existing reports & optimize report performance.
• Used Report manager to deploy reports, schedule reports and created groups and users.
• Designed and developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup, merge join, fuzzy lookup, derived columns etc.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler and third part tools.
• Implemented event handlers & error handling in SSIS and notified process results to various communities.
• Tuned complex SQL Queries.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Server Management Studio, MS Excel-SQL, ERWIN