PROFESSIONAL SUMMARY:

• Over 8+ years of Experience in Information Technology department, particularly in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2008 R2/2005 in Development, Test and Production Environments with various business domains like Financial, Clinical and manufacturing.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008/2008 R2.
• Expert Knowledge on Transact - SQL (T-SQL) Integration Services (SSIS) and Reporting Services (SSRS).
• Sound experience in designing Data model diagrams, logical diagrams and E-R diagrams according to the business need, using MS Visio and other tools.
• Experience in using T-SQL in SQL Server 2012 and 2008 platforms.
• Very good experience in designing databases, and writing queries using constraints like PRIMARY KEY, FOREIGN KEY, DEFAULT, UNIQUE and others.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Have experience in using Indexes, Stored procedures and temporary tables.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Very good knowledge on writing complex queries to pull up the data from various tables using functions like Join to fulfill business logic.
• Wrote complex queries using WHILE, CASE statements to generate new columns along with data from tables, with description useful to end users.
• Effectively used views to prevent unauthorized access. Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Developing reports on SSRS on SQL Server 2012/2008/2008 R2.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Matrix and Chart.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Worked Extensively on ETL process using SSIS package.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in Data Conversion and Data Migration using SSIS services across different databases like MS access and flat files.
• Good knowledge of System Development Life Cycle (SDLC). Worked under cycles like waterfall and agile methods of SDLC.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and end users.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0, Windows 7/vista/XP/98/95, MS DOS, Linux.

RDBMS: MS SQL SERVER 2012/2008/2005/2000, MS Access.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server, Query Editor, Reporting Server, Ms-Access, Oracle.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services

Data Modeling: ER-Win 4.0, MS Visio 5.0.

BI Tools: MS SQL Business Intelligence, Business Objects.

Programming Languages: SQL, T-SQL, PL/SQL, MDX, C, C#, UML, XML, ASP.NET.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Sr. MS SQL Server/BI Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Developed stored procedures and triggers to facilitate consistent data entry into the database using SQL Server 2008/2012.
• Wrote store procedures to generate account statements for different types of accounts.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Improved the performance of the slow running queries by using performance tuning.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• 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.
• Created SSIS packages to migrate data from Oracle to SQL Server 2012.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 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.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• SSISArchitecture
• Created customSSISManagement Framework. I.e. Package Configurations, Package Logging and Auditing, and aSSIS Template for Packages.
• SSISChild Package Template includes common connection managers, parent package variables, package variables, and Execute SQL Tasks for logging package start, package end, package errors, pre-execution, and post-execution designing for roll-back and disaster recovery.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2012/2008.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) 2012/2008/2005.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, reports using SSRS 2012/2008.
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
• Expertise in designing the complete ETL process from the source to Data Warehouse.

Environment: SQL Server 2012/2008 R2/2008, SSIS, T-SQL, SSRS, Windows Server 2007.

Confidential, Pleasanton, CA

Sr. MS SQL Server/BI Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports.
• Collected business requirements from the business users and developed data models.
• Worked on designing conceptual, logical and physical data models using Microsoft Visio.
• Worked with PowerBI to develop enhanced and interactive excel sheets
• Created many database objects like tables, views, indexes, functions and advanced queries for database in both development and production environments using SQL Server Management Studio’s Database engine.
• Worked on creating complex queries to pull up data from various tables using Loops and creating variables.
• Used Triggers to maintain consistency in data.
• Created joins and sub-queries for complex queries involving multiple tables.
• Worked on Performance tuning to increase the performance. Worked with SQL profiler and tuning advisory. Query optimization is performed for user defined stored procedures to increase the performance.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012 from different environments.
• Created the SSIS and scheduled them using SQL Server agent.
• Developed Stored Procedures in SQL Server 2012 and modified existing stored procedures as needed.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join.
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Pulled data from various tables and databases to generate reports using different types of joins.
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
• SSISArchitecture:
• Created customSSISManagement Framework. i.e. Package Configurations, Package Logging and Auditing, and aSSIS Template for Packages.
• Custom Package Logging and Auditing logs execution and error information for: batches, packages, and package containers and tasks.
• Designing for roll-back and disaster recovery.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Created sub reports and pass through parameters from main report to the sub reports.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: SQL Server 2012/2008R2, MS Server Integration services(SSIS), SSRS (MS server Reporting Services), Window 2007 Server, T-SQL,TFS.

Confidential, New Jersey

SQL Server Developer/ BI Developer

• Participated in gathering User Requirements and System Specifications.
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures
• Extract Transform Load (ETL) development using SQL Server 2008R2, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling And Logging.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created SQL Jobs to schedule SSIS Packages
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Migrating SQL Server 2008 databases into SQL Server 2008r2.
• Installed SQL Server 2008 R2 on standalone and cluster environments
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Creating Reports as per user requirements using MS Reporting Services 2008/2008R2 Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and Sub reports, and formatting them using both SSRS
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2008R2/2008. Extensively worked in sorting the data, defining subtotals for the reports
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed flowcharts for complex stored procedures.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Effectively used views to prevent unauthorized access.

Environment: SQL Server 2008/2008 R2, VBScript, XML, SQL Profiler, SQL Crystal Reports, MS Visual Studio.NET, Performance Point Server, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Visio, Access, XML, Web Services, VB.NET.

Confidential, Manhattan, NY

MS SQL Server/BI Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, dashboards, and scorecards.
• Involved in the dimensional modeling.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Improved the performance of the slow running queries.
• Wrote store procedures to generate account statements for different types of accounts.
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Generated several drill down and drill through reports using SSRS.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2008.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Extensively used transformations, control flow tasks, containers and event handlers.
• Used checkpoints to implement the restart ability of the packages in SSIS
• Implemented custom logging in SSIS using event handlers and execute SQL task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio(MSVS)
• Created dynamic Package Configuration of type SQL Server table.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like MS access and Microsoft Visio
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan

Environment: SQL Server 2008R (2), MS Server Integration services, SSRS (MS server Reporting Services), Crystal Reports.

Confidential

MS SQL Server / BI Developer

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design..
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created different type of reports including Cross-tab, Conditional, and Drill-down and Sub reports
• Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
• Experience in creating reports using REPORT MODEL and applying row level security filters.
• Experience in designing CRYSTAL REPORTS visualizing them Exploring and delivering the reports via the web.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Created partitions to improve the performance of data retrieval..
• Have deployed packages on different servers by using Package configurations.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Requirement gathering - Solution design .
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• 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.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 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.

Environment: MS SQL Server 2008/2005, T-SQL, DTS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Profiler.