SUMMARY:

• Over 6 years of experience with SQL Server 2008/2012 as Business Intelligence developer/DataBase developer.
• Good Experience in developing and designing reports through SSRS.
• Good Experience in Designing and Developing in Ad - Hoc Reports, Drill down and Drill through reports.
• Good Experience in Developing SSIS Packages to extract data from heterogeneous data
• Sources and populate into centralized Data Warehouse.
• Experience in creating database Tables, Views, Stored Procedures, Functions and Triggers in SQL Server 2008/2012.
• Expertise in database activities like Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting and Documentation.
• Experience using SQL Server Management Studio in Microsoft SQL Server 2008/2012, Toad for SQL Server, SQL Developer.
• Excellent Knowledge Designing and Developing in SSAS - OLAP Cube.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent in SQL Server.
• Implemented unique process "Combined Loading Process" to consolidate data fromDifferent tables before moving it to the "FACT" table.
• Excellent technical and analytical skills with clear understanding of design goals of ERModeling for OLTP Systems as well as OLAP Systems.
• Scheduled SSIS Packages using SQL Server Jobs and Involved in ETL process using SSIS inMS SQL Server, Import and Export Wizard, Bulk Insert and BCP.
• Enthusiastic, fast learner who is effective in organizing job functions and developing efficient solutions in BI side.
• Motivated self-starter with exceptional team building, Leadership, Project Management and interpersonal skills.
• Involved in UAT and integration testing of SSIS Packages with QA Team.
• Strong Communication, Presentation and Problem Solving skills as well as very good Interpersonal skills and a Team Player
• Worked In high-pressure environments adhering to product quality standards and delivery dates.

TECHNICAL SKILLS:

RDBMS: SQL Server 2005/2008 R2/2012, MySQL, Oracle 9i

Reporting Tools: Business Intelligence Studio 2008/2012

IDE: MS Visual Studio.NET 2010, MS Visual Studio.NET 2012.

Database Tools: Management Studio, Toad for SQL Server

ETL Tools: DTS, SSIS

Web Technologies: ASP.NET, ASP, XML Web Services

Markup Languages: HTML, XML

Framework: Dot Net 4.0

Scripting languages: VB Script

XML Technologies: XML, XSL, XSLT, XPATH, WSDL, UDDI, Web Services

Packages: MS-Office, Adobe Photoshop 12.0.

Operating Systems: Windows Server 2008 R2, Windows 2012

Version Control: Team Foundation Server, MS Visual Source Safe(VSS)

PROFESSIONAL EXPERIENCE:

Confidential, CA

BI Developer

Environment: Software:BIDS 2012, Management Studio 2012, Toad 6.0 for SQL Server, Visual Studio 2012.

Responsibilities:

• Developed Logical and physical data model using ERWIN.
• Involved in writing Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Extensively used Joins and CTE for complex queries involving multiple tables from different databases via Linked Server/OPENROWSET.
• Improve Query Performance by Analyzing Execution Plans and Statistics.
• Increased the performance by performance monitoring, tuning and optimizing indexes.
• Created SQL Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, script task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Configured SSRS Subscriptions to schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine for DEV BI Servers/QA BI Servers.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Confidential

BI Developer\SQL Developer

Environment: Software: SQL Server 2005/2008 Windows 2000/NT/XP

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Created indexes on selective columns to speed up queries by analyzing the Trace Load.
• Created views to restrict access to data in a table for security.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
• Primary Point of Contact for Deploying Reports in Production Environment.
• Scheduled the monthly/weekly/daily reports to run automatically by Configuring Subscriptions.
• Developed Email Alert Mechanism using the SQL Mail Internal Procedure.
• Designed SQL SSIS Packages to extract data from various Heterogynous data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 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
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server using DMV’s.
• Designing and building Audit Trail of Login Sessions of Production SQL Server.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries