SUMMARY

• 7+ years of IT Experience as MS SQL Server Database Developer in Database Design, Testing and business intelligence of Microsoft SQL Server 2000/2005/2008/2008 (R2)/2012 in Development and Production Environments with various business domains like Financial, Healthcare, Manufacturing and Insurance services.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008R 2/2008/2005/2000.
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Very good T-SQL Programming skills. Used SQL Profiler, Execution Plan, Performance Monitor to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS).
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Experience in creating snapshots of reports to reduce the load on the server. Managed subscriptions to provide timely reports to the clients and end users and also worked on integration of SharePoint with SSRS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Involved in DBA activities such as backups, restores, replication and creating Logins, Roles on different databases.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS

Database: MS SQL SERVER / 2005, MS Access 2013/2010.

Operating Systems: Windows, Linux.

Programming Languages: Transact SQL, C, and Macros.

Web Technologies: XML.

Productivity Applications: MS Word, MS Excel, MS Access.

DB Tools: SQL Server Management Studio, SQL BIDS, SQL Server Data tools, SQL Profiler

ETL Tools: DTS, SSIS.

Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Crystal Reports, and Microsoft Excel.

Data Modeling Tool: ERWIN, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Akron, Ohio

SQL Server SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Responsible for optimizing SQL queries and stored procedures to improve the performance.
• Developing complex SQL queries using Temporary tables, CTE’s and Sub queries.
• Implemented Error Handling in Stored Procedures using Try and Catch.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Sql Server Data tools
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Transfer data from OLTP databases to staging area by using SSIS and T-SQL stored procedures and finally transfer into data marts.
• Worked on Event handlers for each packages and created the log files to handle the errors.
• Used the common transformations like derived, conditional split, merging, union in different scenarios as per the requirements.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Deployed SSIS packages to Integration Services Catalogdb using Project and Package level Parameters.
• Generated reports using SQL Server Reporting Services 2012 (SSRS).
• Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle, .NET, Visual Studio, MS Server Integration services (SSIS), MS Server Reporting services (SSRS).

Confidential, Kansas City, MO

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in gathering requirements with team lead for efficient Reporting of the database.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Widely used SSIS transformation such as Derived Column, send mail task, fuzzy lookup, fuzzy grouping, data conversion and aggregate.
• Developed auto generated system using SQL Server Agent to schedule the packages.
• Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.
• Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation.
• Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services.
• Used various SSRS expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions.
• Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.
• Integrated MS SSRS with SharePoint Foundation 2010/SharePoint Server 2010 by configuring a report server to run in SharePoint integrated mode
• Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services.

Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.

Confidential, Virginia Beach, VA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created the SSIS packages and scheduled them.
• ETL implementation using SQL Server 2012 Integration Services (SSIS)
• 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).
• Utilized event handling effectively to generate logs for the packages created.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.
• Developed Stepped and Block reports using SSRS. Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created scheduled jobs for daily process to migrate data from other servers.

Environment: SQL Server 2005, SQL Server 2008, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services.

Confidential, Kansas City, MO

SQL SSIS DEVELOPER

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Created documentation as required.

Environment: MS SQL Server 2005, T-SQL, DTS.

Confidential

SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design
• Involved in the migration from SQL server .
• 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.
• Involved in writing SQL batch scripts.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup & restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2005 on development server for designing and testing.

Environment: MS SQL Server 2005, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.