SUMMARY

• Having 8+ years of professional experience in Data - warehouse, SQL Server Development and BI tools (SSIS, SSRS, SSAS).
• Having good experience over T-SQL statements and Having three years of experience in pl/sql.
• Created stored procedures, triggers, UDFs, views, tables, and generated T-SQL script for application.
• Good understanding in Data Marts and Data Warehousing concepts (OLTP & OLAP) and worked with Data mining and slowly changing dimensions (SCD).
• Extensive experience in database tuning, server logins and database permissions.
• Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases, updating statistics.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance that increases my ability in Performance Tuning, Query Optimization.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data base applications.
• Manage SSIS packages, stored procedures, jobs, and utilize Server-Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default &Traces to analyze other issues on the server.
• Expert level skill in Extraction, Transformation and Loading (ETL) in SQL SERVER.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Participation of team meeting on a Bi-weekly basic for a discussion on the ongoing process and upcoming
• Working with Reporting Services to generate reports in different formats.
• Working with Analysis Services to generate cubes for Adhoc Reporting
• Having good Knowledge on Data warehouse design concepts.
• Working with sql server agent jobs to call and schedule SSIS packages.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent skills in understanding business needs and providing technical solutions.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Good experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS

Databases: MSSQLServer 2014/2012/2008/2008 R2, Teradata, Oracle, Sybase and MS-Access

SQL Server Tools: SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS., Query Analyzer.

Operating Systems: Windows 7/vista/XP/98/95, Linux and UNIX

ETL/ Analysis Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential

Senior Consultant

Responsibilities:

• Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft SQL Server platform (TSQL, SSIS, SSRS, SSAS).
• Creating and managing schema objects such as Temporary tables, Stored Procedures, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Developing the ETL processes using SSIS to load data from different sources to target SQL Server database by performing a different kind of transformations and automate, optimize, and execute process improvements on existing workloads.
• Created numerous simple to complex queries involving joins, correlated sub-queries and CTE’s techniques for diverse business requirements.
• Involved in Query Optimization, Performance Tuning rebuilding the Indexes at regular intervals for better performance and used string functions for space management in database.
• Involved in developing SSIS packages for incremental loading process including getting data from transactional system to data warehouse
• Experience in creating Tabular reports, Matrix reports, Parameterized reports, Sub reports, Ad hoc reports using SSRS.
• Configured Reporting Services subscription in SSRS to deliver reports to users at a specific time in Excel and PDF formats through email and shared location.

Environment: MS SQL server 2014, Visual Studio 2014, SQL Agent Jobs, Agile, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS Excel, Performance Monitor.

Confidential - Bloomington, Illinois

Senior Consultant

Responsibilities:

• Provide SQL Development using MS SQL Server, SSIS and SSRS in relation to analyze and troubleshoot errors in the reports and packages.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Experience in creating Tableau dashboards with combination charts for clear understanding and created ad hoc reports to users in Tableau by connecting various data sources.
• Created and developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc. ) and loaded the data into destination databases by performing different kinds of transformations using SSIS.
• Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down & drill-through reports, matrix reports, chart and tabular using SSRS .
• Created Dimensions and Cubes with star schema using SQL Server Analysis Services ( SSAS ).
• Performed data analysis to generate various trend reports and generated Ad-hoc, matrix and tabular reports using SQL Server Reporting Services (SSRS) based on client needs.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS & Deployed packages on different servers by configuring it.

Environment: MS SQL server 2014, Visual Studio 2014, SQL Agent Jobs, Agile, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS SQL Server Analysis Services(SSAS), MS Excel, Performance Monitor.

Confidential

Senior Consultant

Responsibilities:

• Developed Tables, Database objects, Reports and support the existing components.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions. Created complex queries, which involve usage of Joins, Sub-queries, Functions, Temp tables etc.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports using SSRS.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for databases and Scheduling the SSIS packages and Jobs.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Developed custom reports using SQL Server Reporting Services (SSRS) to review scorecards, business trends based on the data from different retail locations.
• Developed various T-SQL stored procedures, triggers, views and adding / changing tables for data load, transformation and extraction.
• Deployed SSRS reports on the reporting server and manage the subscriptions.
• Experience in writing expressions using T-SQL and SSRS based on Business requirements.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.

Environment: MS SQL server 2012, Oracle, Visual Studio 2012, TFS,T-SQL, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS SQL Server Analysis Services(SSAS), MSExcel.

Confidential

Senior Consultant

Responsibilities:

• Created Database Objects like Tables, Stored Procedures, and Views.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan.
• Created indexes (Clustered, non-Clustered, Unique) for better performance.
• Tested the data with complex queries, joins and sub queries.
• Wrote new stored procedures based on the BRD and support the monthly actuarial jobs.
• Supporting monthly running reports for actuarial reports (In force, new business, Underwriting and terminated).

Environment: MS SQL server 2012, Oracle, Visual Studio 2012, TFS,T-SQL, Sql Profiler, Agent Jobs.