SUMMARY

• 7 years of strong experience in the IT industry as a SQL Server Developer with sound business analysis skills.
• Extensive SQL Development experience in Banking, Insurance and Healthcare industries with a strong understanding of data and analytics.
• Knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex Views, Dynamic SQL, Triggers and Cursors.
• Have experience in design and development of Business Intelligence tools like SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Developed SSIS packages for Extraction, Transformation and Loading (ETL) operations using various tools like Bulk Insert (BCP), Import/Export data and SQL Server Integration Services.
• Proficient in T - SQL for developing stored procedures, triggers, tables, user defined functions, SQL joins, views, indexes.
• Have experience in creating and deploying SSIS packages in production and testing environments.
• Proficient in SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Aggregate, Derived Column, Event Handlers, and Error Handlers etc.
• Have experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Created different types of Tabular reports, matrix reports, drill-down reports, drill-through reports, Ad-hoc reports, charts/graphs and also had strong ability in defining queries for generating above reports using parameters and cascading parameters.
• Expertise in defining data source, creating data sets by query designer, creating sub-reports, formatting report layout, sorting the data, subtotals for the reports using expressions and can perform arithmetic, logical operations on data by using expressions.
• Proficient in debugging stored procedures, SSIS packages, coding issues and troubleshoot data/logical bug.
• Good Knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS)
• Good knowledge on scripting languages like VB, Java Script.
• Excellent written and oral communication skills and can work in a team environment as well as independently.
• Good in understanding business requirements in banking, insurance and health care domains.
• Ability to work in tight schedules, efficient in time management, highly motivated team player with excellent interpersonal, analytical, problem solving, technical and communication skills.

TECHNICAL SKILLS

Languages: T-SQL, PL-SQL, C, C++, VB.NET, C#.NET, ASP.NET, ADO.NET, HTML.

RDBMS: MS SQL 2012/2008/2008 R2 /2005 / 2000, MS Access 2010/2007/2003.

Tools: and Packages: SSMS 2008/2005, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), Crystal Reports9.0, MS Office 10/07/03, Visual Source Team Foundation.

Designing Tools: MS Visual Studio and MS Visio.

BI TOOLS: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS).

Operating Systems: Windows 8/7/Vista/XP/2000, LINUX, Macintosh.

PROFESSIONAL EXPERIENCE

Confidential, Valley Forge, PA

Sr. SQL Server BI Developer

Responsibilities:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created SSIS packages to extract data from text files, Teradata, oracle, XML to SQL Server.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Created daily and monthly reports in MS-Office Access, MS Excel and Crystal Reports.
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Developed Query for generating drill down reports in SSRS 2012 and Crystal Reports 9.0.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS
• Used SSRS to create reports, customized reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Created OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.

Environment: SQL Server 2012, T-SQL, MS SQL Server 2012, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, Windows 7, Windows Performance monitor.

Confidential, Iselin, NJ

SQL Server Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle, documented the data flow and the relationships between various entities.
• Actively participated in gathering of user requirement and system specification.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2008.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Designing and building data load procedures, using MS SQL Server SSIS
• SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, ExecuteSQLTask, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Implemented Backup and Recovery of the databases.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Created Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Scheduled automatic generation of reports, report snapshots. Also implemented caching of reports and stored them in a shared drive.
• Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams
• Expert in creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Expert in defining data source and building data source views and recognizing fact and dimension tables.
• Expert in identifying KPIs using MDX expressions in SSAS 2008 to evaluate the business process.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: SQL Server 2008, T-SQL, MS SQL Server 2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, Windows 7, Windows Performance monitor.

Confidential, Orlando, FL

SQL Server Developer

Responsibilities:

• Experienced in writing complex SQLQueries, Stored Procedures, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQLServer 2008 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created report models using Report Builder and managed reports using Report Manager.
• Responsible for creating complex reports like Drill down and Sub reports.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Created Tabular, List, Matrix, Charts, Ad-hoc reports using SSRS.
• Created Data Warehouse Cubes using SQL Server Analysis Service (SSAS).
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Created partition tables for very large database for better performance.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Wrote stored procedures for some job automations.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), C#.Net.

Confidential, Boston, MA

SQL Server Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively used SQL Server BCP Utility, DTS Import/ Export to load the database from text files received from different applications.
• Involved in creation of DTS Scheduled Packages for the daily transfer of data from SQL Server Databases to Oracle database.
• Configured the Linked Server with the Oracle database.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Monitoring SQL server performance using profiler and Windows System Monitor.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), .Net Framework.

Confidential

MS SQL Server Developer

Responsibilities:

• Developed physical data models and created DDL scripts to create database schema and database objects.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Carried out a Developer’s role on MS SQL Server 2005, MS Access Databases (using DTS, Stored Procedures and Views).
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008..
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Daily Database backups and integrity checking.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, Script Components, Error Handling.
• Creation/Maintenance of Indexes for fast and efficient reporting process.
• Developed SQL Scripts to Insert/Update/Delete data, satisfying the referential integrity constraints.
• Involved in Data Migration and used SSIS to import and export data into tables using SQL Server 2005, creating tables, views and Stored Procedures using SQL Server.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports using Global Variables, Expressions and Functions using SSRS.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performance tuning to optimize SQL queries using query analyzer.
• Parameters for parameterized reports using SSRS.

Environment: MS SQL Server 2005, MS Access, T-SQL, Stored Procedures, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), DTS, SQL Server Query Analyzer, SQL Profiler, MS Office.