SUMMARY

• Over 7+ Years of experience as SQL Developer, BI Developer (SSIS, SSRS) as well as Database Administrator.
• A very good experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in the Microsoft SQL Server.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS 2008.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008/2012.
• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Experienced in Creating, strategically implementing and Updating the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Highly experienced in whole cycle of DTS/SQL Server integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Involved in usage of various SSIS components like Forloop, Foreachloop, Variables, and Error Handling etc.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional Table, Matrix, Chart, and Sub Reports, and formatting them using both SSRS 2005/2008.
• Very good knowledge in scheduling and deploying reports on report manger.
• Experience in creating reports using Report Builder 3.0.
• Involved in Data Modeling using Erwin, Star and Snowflake Schemas.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good knowledge in SQL Server 2008/2005/2000 Client Server Architecture.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

Languages: C,SQL,T-SQL

RDBMS: MS SQL Server 2012/2008/2008 R2, 2005, 2000, 7.0, MS-Access

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

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

Data Modeling Tool: ERWIN, Visio

Operating System: Windows 95/98/2000/XP/NT,MS Dos and UNIX

Tools: Microsoft Visual Studio 2008, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Bluffton, SC

MS SQL BI Developer

Responsibilities:

• Designed and developed database solutions based on functional requirements
• Implemented database solutions that met expected quality standards
• Monitored project status to meet milestones and resolve issues that might impact on quality or the ability to deliver to timescales or estimates
• Produced technical design documents for the Schema and Stored Procedure specifications
• Troubleshoot production, real-time performance and concurrency issues
• Deliver work on time and to specification, with minimal supervision
• Created Stored Procedures, User Defined Functions, Views and TSQL Scripting for complex business logic
• Created Stored Procedures which generated the necessary Fact and Dimension tables and Functions that allowed performing necessary calculations depending upon the requirements
• Migrated heterogeneous databases to MS SQL Server 2008R2
• Developed logical and physical data model using MS Visio and mapped the data into database objects
• Designed and created different ETL packages using SSIS from Oracle source to SQL server 2008R2
• Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets
• Designed and implemented SSIS packages for data integration
• Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them
• Extensively worked on Cross Tabbed and Matrix reports using SSRS
• Designed and implemented indexing to optimize transactional and reporting performance.

Environment: Windows OS, MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, MS SQL Integration Services 2008R2, T-SQL, ERWIN, Microsoft Visio

Confidential, Franklin, TN

SQL BI Developer

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed Stored Procedures, Triggers, and Views in SQL Server 2008 R2 for accessing the database.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Used Merge and CTE’s in Sql Server 2008 R2
• Used Sub queries, joins, CTE’s and Analytical functions for data retrieval.
• Worked with different methods of logging in SSIS.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Formatted the reports using the Global variables and expressions.
• Authored performance based reports for the managers to show sales against various measures like Time, Area and Price-Range.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• 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.
• 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.
• Tuned SQL queries using execution plans for better performance.

Environment: MS SQL Server 2008 R2/2008, DB2, MS SQL Reporting Services( SSRS), SSIS, T- SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel, Business Intelligence Development Studio (BIDS), Visual Studio 2010/2012.

Confidential, Richmond, VA

SQL BI Developer (SQL/SSIS/SSRS)

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Involved in the tuning of the existing Database Objects.
• The task involved writing a lot of TSQL Code, including use of complicated joins and cursor loops.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various Web applications, maintained referential integrity and implemented complex business logic.
• Involved in translating business requirements into technical design specifications.
• Involved in managing data sources from other sources to SQL Server.
• Designed and deployed various complex reports using MS Reporting Services.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created and generated reports to display data.
• Used Query Profiler to optimize SQL queries.
• Managing the Clustered environment databases and was fixing the errors when they arose.
• Involved in execution and creation of SSIS packages using Business Intelligence Development Studio
• Involved in Deployment and Administration on SSIS packages
• Performed ETL operations to support the data loads and transformations.
• Developed and designed DTS packages for importing the data from MS Access and MS Excel.
• Loaded data from flat files into SQL Server 2008 R2.
• Developed and executed several optimized queries in SQL.
• Setup and installation of databases including test, development environments
• Involved in DBA activities such as Backup, Recovery, Performance tuning and User administration
• Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Query Analyzer.
• Fine tuning of database objects and server to ensure efficient data retrieval

Environment: MS SQL Server 2008 R2/2008, DB2, MS SQL Reporting Services( SSRS), SSIS, T- SQL, Crystal Reports, Windows XP, Query analyzer, SQL Profiler, MS Excel, Business Intelligence Development Studio (BIDS), Visual Studio 2010/2012.

Confidential

SQL Server Developer (SQL/SSRS)

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• 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)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries

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