SUMMARY

• 6+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008/2005/2000 in Development, Test and Production Environments.
• Expert in MS SQL Server BI components, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation and Load) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Knowledge in developing T - SQL queries (DDL and DML).
• Experienced in creating Tables, Views and other SQL joins and query writing.
• Expert in creating Clustered and Non-Clustered Indexes to improve the performance of the SQL queries.
• Good hands on experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique).
• Actively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Hands on experience on Extraction Transformation and Loading (ETL) processes using tools like SSIS, DTS, BCP between different homogeneous/heterogeneous systems and SQL Server and implemented Incremental load in SSIS packages
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in creating SSIS packages to transfer data from OLTP data base to Data warehouse.
• 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, Ad hoc and Sub Reports.
• Expertise in designing Data Flow task and Work Flow task on SSIS.
• Expert in cube development, partition and aggregations and optimizing using SSAS.
• Good experience in creating Stored Procedures, User Defined functions, Triggers and writing sub-queries to simplify complex queries involving multiple tables.
• Experience in creating scheduling jobs, alerts, SQL Mail Agent, and scheduled DTS packages.
• Expert in extracting and transforming data using DTS Import/Export Data, Bulk Insert.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows Server 2008, Windows 7/Vista/XP, Linux

Data Bases: SQL Server 2014/2012/2008/2005/ 2000, Oracle 8i/9i and 10g, MS Access

Data Base Tools: SQL Server Management Studio(SSMS), SQL Enterprise Manager, Query Analyzer and SQL Profiler, SQL Server Data tools

Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Microsoft Excel, Cognos.

Data Modeling Tools: Erwin, VISIO

ETL Tools: DTS, MS SQL Integration Services(SSIS), SSDT

Languages: SQL,T-SQL,PL/SQL,C#,Vb.net

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

MS SQL BI Developer

Responsibilities:

• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Created SSIS packages to import and export data from flat files dynamically.
• Deployed SSIS packages to different environments using package configurations of type environment variable and SQL Server table.
• Designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Written T-SQL scripts, dynamic SQL, complex stored procedures, functions.
• Created SSIS packages to pull data from SQL Server and exported to flat files, CSV files and Excel Spreadsheets and vice versa.
• Involved in tuning of SQL scripts using stored procedures and functions.
• Generated back up file for data base using Back up Database task in SSIS.
• Involved in maintenance and administration of SSIS by creating Jobs, alerts and schedule SSIS packages.
• Experience in creating and managing linked servers.
• Generated scripts to back up and restore data bases.
• Managed the imports and exports for the data bases and troubleshoot load failures.
• Created SSIS packages to unzip files and move them to folders dynamically based on the file names.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Developed queries to generate various charts, parameterized reports and conditional reports.
• Involved in performance tuning and optimization of stored procedures and queries.
• Provided daily support, troubleshooting, monitoring of jobs running on SQL Server.
• Created Drill Down and Drill Through Reports in SSRS.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.

Environment: SQL Server 2012/2014 R2, T-SQL, MS Server Integration services, SSRS (MS server Reporting Services), MS Visual Studio 2008,Microsoft Visual source safe (VSS)

Confidential, Cincinnati, OH

MS SQL Developer

Responsibilities:

• Participated in gathering and analyzing the requirements, attributes and the facts for the project. Also involved in creating Business and Data Requirement documents.
• Worked with database project in visual studio 2012.
• Created Parameterized Reports by identifying and creating Dataset with the parameter.
• Created complex SSIS packages using proper control and data flow elements to transfer Data from OLTP to OLAP.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and MS Access and CSV files to data warehouse
• Created master ETL packages for loading and migrating historical data from Legacy system into D/W.
• Deployment, Configuring and scheduling of ETL packages along with performance tuning of reports and ETL packages.
• Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2012 using Execution Plan and on necessity SQL Profiler too.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution.
• Design and development of more than 60 operational reports using SSRS 2008 R2 both from transactional system and DW.
• Worked on ad hoc reports Query studio analysis studio to demonstrate relational dimensional reporting.
• Used performance point dashboards in developing business intelligence reports.
• Involved in writing MDX queries for cubes in Business Intelligence Development Studio (BIDS), deploying them on the server using (TFS) Team Foundation Server.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2014, SQL Server Reporting Services 2012 (SSRS), MS Access, visual studio 2012, XML, VB. net, SQL Server Integration Services (SSIS), Windows Server XP and MS EXCEL, TFS (Team Foundation Server).

Confidential

Database Developer

Responsibilities:

• Collaborated with business users and teams to outline business requirements.
• Analyzed BRD and documented FRD via team meetings.
• Designed and developed complex stored procedures, user defined functions, and triggers to implement business rules.
• Improved the performance of inefficient queries by creating clustered/non-clustered indexes, indexing views, analyzing execution plans, utilizing SQL profiler, and querying DMVs.
• Developed the ETL strategy for data (text-based files, Excel spreadsheets) to SQL server databases utilizing SSIS.
• Created SSIS packages to extract data from the existing SQL server OLTP to the OLAP data model.
• Created SSIS packages to filter out bad data utilizing multiple transformations.
• Implemented error handling functions in SSIS packages to generate runtime error logs for debugging.
• Utilized checkpoints, breakpoints, and watch windows for package debugging.
• Deployed SSIS packages in the MSDB database and production server; scheduled deployments with agent jobs.
• Created multiple financial reports for financial analysis/decision-making with SSRS and power pivot.
• Expert in generating daily updating reports withTableauDesktop.

Environment: MS SQL Server 2012, SSIS, SSRS, Erwin, Tableau, SharePoint, Power Pivot, TFS, Excel, Windows Server

Confidential

Database Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications.
• Designing logical / physical data models and defined primary key, foreign key. Extensively involved in designing (Logical and Physical) of Databases.
• Created database objects like tables, views, indexes etc. using T-SQL statements. Created and modified stored-procedures, triggers, cursors. Created and managed the Database Users, Login Ids and Security.
• Wrote different complex SQL queries including inner, outer join update queries.
• Used Temp tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created DTS package to export and import data from SQL Server to Access, text and Excel Files.
• Used SQL Profiler for getting the trace activity for the various stored procedures and used Index Tuning wizard for performance betterment.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS)
• Used DTS to create jobs to populate some of the tables with data from other servers.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, Visual Studio 2012/2008, Erwin r7.2, MS Access.