PROFESSIONAL SUMMARY:

• Over 7 years of strong SQL Server Developer and Business Intelligence. Expertise in MySQL, MS SQL Server 2012/2008R2/2008/2005/2000 and Business Intelligence including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering and maintaining MySQL, Microsoft SQL Server 2012/2008R2/2008/2005 databases.
• Highly proficient in the use of T - SQL and MySQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Expert knowledge and experience with managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Proficient in Joins (Inner join, Left Outer, Right Outer Joins, Full join and Cross join) and Indexes.
• Experienced in database design, performance tuning, data modeling & working with databases.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services and experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility.
• Proficient in SQL Server and MySQL Performance tuning and Query Optimization.
• Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Proficient in creating and managing roles and security of reports and scheduling Subscription of Reports using SSRS.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale databases.
• Strong leadership, communication, problem-solving and multi-tasking abilities.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment and working well under pressure.

TECHNICAL SKILLS

Technical Skills: SQL Server 2005/2008/2008R2/2012, TFS (Team foundation Server), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Agent, SQL Server Profiler, Database Engine Tuning Advisor, Report Builder, DTS, SharePoint, MS Office (Word, Excel, Access, PowerPoint, Visio), T-SQL, XML, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Kenilworth, NJ

SQL Server BI Developer

Responsibilities:

• Gathered user requirements for analysis and design of software & database solutions.
• Utilized documentation prepared by Business Analyst to complete projects.
• Established scope, planned and prioritized multiple deliverables based on data dependencies and changing business needs.
• Implemented complex business requirement in backend using efficient T-SQL stored procedures and flexible functions and facilitated easy implementation to the front end application.
• Created and managed schema objects such as tables, views, clusters, indexes, stored procedures and triggers in order to maintain Referential Integrity.
• Extracted data from various data source including OLE DB, Excel, flat files and XML using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, and Merge.
• Increased T-SQL query performance, necessary for reporting after performing monitoring, tuning and optimizing indexes.
• Managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, Message Queue Task.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Implemented automated jobs for Database Backup on a weekly and monthly basis.
• Proficient in creating drill down reports, ad-hoc report, linked reports, drill through reports and sub reports using SSRS.
• Implemented complex conceptual database design and database architect into SQL Server 2005/2008R2 using various constraints and triggers.
• Played a major role in production support of SSIS jobs.
• Proficiently created and manage roles and security of reports and scheduled the Subscription of Reports using SSRS.
• Automated processes using SQL Server Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Deployed 2008 R2/2012 Reporting Services (SSRS) RDL files to Reports server.

Environment: SQL Server, SSIS/SSAS/SSRS, MS Access, Windows, UNIX, ERWIN, MS VISIO, SQL Profiler, SQL Query Analyzer, Microsoft SharePoint, ASP.NET, MS Office

Confidential, Middletown, DE

SQL Server BI Developer

Responsibilities:

• Responsible for creating reports based on the business requirements using SSRS
• Developed and supported many ETL’s involving complex data loading and transformations.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Worked with cross-functional teams of developers, tech writers, and QA analysts to produce fully integrated products.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created complex stored procedures, efficient triggers, and required functions, creating indexes, and indexed views for improving performance.
• Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
• Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically.
• Scheduled Sessions and involved in gathering the report specifications by interacting with the business users.
• Developed, implemented and maintained various database objects such as T-SQL Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: SQL Server, SQL Server Management Studio, T-SQL, SSIS, ETL Tools, Visual Source Safe, SQL Profiler, Query Analyzer, Microsoft Source Safe.

Confidential, Trenton, NJ

SQL Server BI Developer

Responsibilities:

• Generated database T-SQL scripts and deployed databases including installation and configuration.
• Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Involved in creating various T-SQL scripts to load the data to and from production servers to the development servers.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Designed and developed different type of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created T-SQL stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder and scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts and manager.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Designed and developed Packages using Lookup, Merge, Merge Join, Conditional Split, Aggregate and Export Column.
• Created Drill-through, Drill-down, Cross Tab and Sub-Report using SQL Server Reporting Services (SSRS).
• Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS).
• Worked on Stored Procedures and Database Triggers and business analytical functions.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Used SQL Profiler and Query Analyzer to optimize queries and Stored Procedures.

Environment: MS SQL Server, Excel, TFS, Database Engine Tuning Advisor, Profiler SQL Server Management, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSRS

Confidential

SQL Server/ SSRS Developer

Responsibilities:

• Created T-SQL new tables, stored procedures for Application Developers.
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration.
• Coordinated with the front-end developer to put in the business rules.
• Developed test plans to determine if all business case requirements had been met, and track user issues through to resolution with engineering team.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Built advanced reports using query parameters, report parameters, user access restrictions, filters and interactive sorts.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Created Drill-through, Drill-down, Cross Tab and Sub-Report using SQL Server Reporting Services
• Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Scheduled the reports to run on a daily and weekly basis in Report Manager and then provided them to the analysts to review in Excel Spread Sheet.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Expert in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting.
• Involved in deploying, configuring, and managing reports using Report Manager and Report Builder.
• Formatted reports using the Global variables and expressions.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008 (SSRS), VSS, Microsoft Visual Studio, SSMS, MS Excel, T-SQL

Confidential

SQL Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.
• Wrote T-SQL, designed and modified database objects such as tables, views, triggers, indexes, Stored Procedures, defaults, function to meet the business and audit specifications.
• Developed T-SQL stored procedures and views for managing efficient data retrieval.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: SQL Server, SQL Server Management Studio (SSMS), Windows, DTS, T-SQL, Report Builder, SharePoint, Server Agent, Profiler, Database Engine Tuning Advisor, Query Analyzer.