PROFESSIONAL SUMMARY:

• 7+ years of IT experience as a MS SQL Server Developer 2012/2008/2005 in various Industry verticals like Finance, Health Care and Insurance.
• Experience in Installation and Configuration of SQL Server 2012/2008/2005.
• Experience in T - SQL queries (DDL, DML) creating and managing the databases and all the database objects.
• Excellent in using all kinds of SQL Server Constraints and Dynamic-queries.
• Highly proficient in the dealing with complex Stored Procedures, Views, Data Import/Export, System Views and functions.
• Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler.
• Highly experienced in complete cycle of SQL Server Integration Services ( 2012/2008/2005 ), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
• Strong knowledge on Row Transformations, Partial Block and Block Transformations.
• Experience in Development, Deployment and Troubleshoot Reporting services using SSRS across various environments.
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2008 R2/2008/ 2005, Crystal Reports and MS Excel for the analyzing data at an enterprise level.
• Experience in creating Ad-hoc reports and data driven subscription reports by using Report Builder.
• Experience in using Global Variables, Expressions and Functions for the reports.
• Experience in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX).
• Experience in data architecture design and used data modeling tools like Erwin for designing the logical and physical data models.
• Developed a thorough knowledge in understanding business processes, gathering requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).
• Excellent analytical, Communication and interpersonal skills.
• Proficient in technical writing, presentations and a good team player.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008/R2/2012, Access, Oracle10g.

Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Analysis Services (SSAS), Visual Studio, Query Analyzer, SQL Profiler, TFS.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Languages: SQL, T: SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)Import/Export Wizard, Bulk Insert, BCP.

Scripts: PHP, JavaScript, CSS, VBScript, C#, HTML and XML.

Applications: Microsoft Office 2000/2003/2007.

Operating systems: Windows 2000/XP/2003/2008.

Reporting Tools: Power BI, SSRS, Report Builder, Business Objects, Crystal Reports.

EXPERIENCE:

Confidential, Pittsburgh, PA

SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2012.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Views to maintain security of customer data.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Create Power Pivot data model using the linked tables and pulling data from different sources (SQL DB, Analysis Services) and creating the mappings between the dimensions and the facts.
• Create calculated measures using DAX and then develop Power View reports and host it on share point.
• Schedule the power pivot data model refresh on the SharePoint.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Implemented Unit Tests and Integration Tests.

Environment: MS SQL Server 2012/2008, TFS, Query Analyzer, Windows 2008, SSAS, Excel, Oracle10g.

Confidential, Richmond, VA

MS SQL Server Developer

Responsibilities:

• Installation and Configuration of SSIS/SSRS 2008
• Creating Database objects - UDFs and views, and developing procedures for implementing application functionality at the database side for performance improvement.
• Created complex Stored Procedures, triggers and other SQL joins and statements for applications.
• Extracted data from a staging database and perform the various transformations and load data into the Data Warehouse Database.
• Created several lookup tables and updated couple of existing lookup tables.
• Used different Control Flow Tasks and Data flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleansing the data from different Sources.
• Migrated packages from SQL 2005 to SQL 2008.
• Developed the packages with monitoring features and Logging capturing the audit information of the packages and their execution results for support and troubleshooting.
• Created schedule and troubleshooting jobs.
• Generated Master/Detail summary reports depicted in collapsed/expanded views using Report Builder and SSRS.
• Crated Drill-down reports and parameterized reports.
• Administrated the created Reports by assigning permission to the valid user for executing reports.
• Create subscriptions for the monthly and weekly reports.
• Used System tables and Views, System Stored Procedure, DBCC commands for Database maintenance.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Involved in Translating business requirements into technical design specifications.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, SQL Profiler, T-SQL, DTS, Query Analyzer, Report Builder.

Confidential, Chesapeake, VA

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Analyze the client requirements and translate them into technical requirements.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Create Complex Stored Procedures and function for various applications.
• Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like excel spreadsheets, flat file and vice versa.
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task and different data flow tasks using T- SQL and VB scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Created Ad-hoc reports and data driven subscription reports by using Report Builder.
• Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data warehouse.
• Involved in dimensional modeling with Star & Snowflake schemas and created the data source views (DSV) and cubes using the identified fact and dimension tables.

Environment: MS SQL Server 2008/2005, Reporting Services, SSMS, Enterprise Manager, Query Analyzer, Report Builder, ERStudio.

Confidential, Hopewell, NJ

Data Analyst and SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2005/2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Involved with programming languages C#, XML.
• I Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked with development teams in the design of physical databases and in modification.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2, BIDS, XML, SSIS, SSRS, SSAS, Source Depot, JIRA.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and SSIS.
• Migrated data from Flat files to SQL server 2005 using SSIS.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server 2005, MS Access, MS EXCEL, T-SQL, Windows 2003 server.