SUMMARY

• 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data-warehousing.
• Expert Knowledge of Integration Services (SSIS), and Reporting Services (SSRS) in MS SQL Server 2008R2.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008R 2/2008/2005.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert at Dimensional Modeling and ETL design.
• Experienced in using ETL tools in (SSIS) MS SQL 2008R2,MS SQL 2008 and in MS SQL 2005
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experienced in managing Alerts, Operators and Jobs through SQL Server Agent.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Proven ability in Performance Tuning, Query Optimization.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development

TECHNICAL SKILLS

Languages: Transact SQL, VB.Net.

Databases: MS SQL SERVER R 2 / 20, MS Access 97/2000/2003

Operating Systems: Windows NT/XP/7 platforms

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSRS, SSIS / ETL

Other Tools: Microsoft Visual Studio 2008/2005, Crystal Reports, MS Office, Erwin

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. BI Developer

Responsibilities:

• Created security for the reports on the username level and data level.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Drill-through and Sub reports.
• Configured and deployed SSRS reports to Share point and SSRS Report Server.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports (SSRS)
• Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, MySQL.
• Subject Matter Expert when it comes to SQL Development.

Confidential, MD

Sr. SSRS Developer

Responsibilities:

• Created bar and line charts and matrix reports using SSRS
• Creating Reports as per user requirements using MS Reporting Services 20012. Created different types of reports such as Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 20012/2008 R2Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Created and managed subscriptions for the reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and Responsible for defining calculated members
• Various transformations, developing SQL queries

Environment: MS SQL Server 2012, Team Foundation Server, (SSRS) SQL Server Reporting Services, Visual Studio 2005, T-SQL, VB.Net

Confidential, PA

Sr. MS SQL Server /BI Developer

Responsibilities:

• Worked with Business Analysts and clients in gathering requirements and translating them to technical specifications.
• Created SSIS packages for Uploading of different formats of files (Excel, CSV, Flat Files, XML) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Created SQL Jobs to schedule SSIS Packages
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Working with complex SQL, Stored Procedures, Triggers, cursors, and packages in very large databases from various servers.
• Create and maintain clearly written technical, user, and system documentation.
• Develop inbound and outbound SSIS packages under the direction of a client representative adhering to the development standards and formats.
• Set up configurations for existing packages as clients transition from one plan year to another and work with medical claims.
• Loading Data for Inbound Feed through SSIS packages.

Environment: MS SQL Server 2012, Team Foundation Server, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, T-SQL, VB.Net

Confidential, NY

Sr. MS SQL Server / BI Developer

Responsibilities:

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Created SQL Jobs to schedule SSIS Packages
• Designed SSRS 2008R2 reports with Cascaded Parameters, Gauges and Interactive Charts, Tablix etc.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008R2.
• Creating Reports as per user requirements using MS Reporting Services 2008R2/2008 Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS 2008R2/2008
• Design report models based on users requirements, explain and train users to use report builder to generate their own personalized reports.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Working with complex SQL, Stored Procedures, Triggers, cursors, and packages in very large databases from various servers.
• Collecting requirements from business users and transforming them into logical and physical database designs.
• Create and maintain clearly written technical, user, and system documentation.

Environment: MS SQL Server2008R2/2008, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, T-SQL, VB.Net

Confidential, NJ

BI Developer

Responsibilities:

• Involved in Migration of SSRS 2005 to SSRS 2008.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports (SSRS)
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• Configured and deployed SSRS reports to Share point.
• Used Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Used the row count transformation and event handlers control flow to populate the special log tables with high level SSIS package execution results
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of T-SQL.
• Worked with development teams in the design of physical databases and in modification.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Environment: SQL Server 2008,T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, ETL, Erwin, SQL Profiler, MS Excel 2003, MS Visio, Share Point.

Confidential, NYC, NY

MS SQL Server / BI Analyst

Responsibilities:

• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Deployed SSRS Reports inSharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created reports usingstored procedure and also involved inscheduling, creating snapshotsand subscriptions for the reports SSRS.
• Involved in improving the performance of the system.
• Developed and executed several optimized queries in SQL.

Environment: MS SQL Server 2005/2008, Windows 2000/NT/XP, SSIS, SSRS, T-SQL, Query Analyzer, MS Office 2003

Confidential, Austin, TX

MS SQL Server BI/SSRS Developer

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Worked with data extraction using SSIS and Data Warehouse staging, and loading.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Created and managed subscriptions for the reports.
• Implemented user based security in SSRS reports to limit the access of reports.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions and Responsible for defining calculated members
• Created SSIS packages to move data from oracle to SQL Server which involved using Various transformations, developing SQL queries

Environment: SQL Server 2005, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services, Oracle 9i/10g

Confidential, Ada, Michigan

SQL Server/Reports Developer

Responsibilities:

• Created various tables, views, stored procedures, Functions and Indexes.
• Migration of databases from MS SQL Server 2000 to MS SQL Server 2005.
• Created Jobs, Alerts and scheduled DTS to generated Reports
• Created SSIS package to load data to SQL Server, from Flat files or excel spreadsheet
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS /SSIS package
• Created SSIS Packages for migration of data between SQL Server and other databases like MS Access, MS Excel and Flat Files.
• Created reports and performed all Administrative activities. Also Installed and maintained SQL Server Reporting Services (SSRS) 2005
• Extensively used SQL Server Reporting Services to generate various types of reports.
• Created ad-hoc reports for business users using SSRS.
• Developed Stepped and Block reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Assigning work to team members based on their ability to handle work load.
• Checked queries and tables to update them for performance.

Environment: Windows 2003 Advanced Server, TSQL, SSIS, SSRS, MS SQL Server 2000/2005, Visual Studio (BI) Tool.