EXECUTIVE SUMMARY:

• Around 6 years of IT experiencein all phases of SoftwareDevelopment Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of SQL BI in domains like Finance, Insurance, and Logistics.
• Extensive experience in MS SQL Server 2008/2012 with Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Experience in installation and configuration of SQL Server 2008 and 2012.
• Proficient inlogical and physical data modeling, Forward and Reverse engineering using ERwin, Normalization, de - normalization and building Referential Integrity Constraints.
• Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures,triggers, views, functions and cursors using.
• Expert in monitoring SQL Server Performance, troubleshooting using Execution Plan, SQL Profiler and IndexTuning Wizard.
• Extensive experience in creating various reports using Reporting Services (SSRS 2008 R2/ 2012) and Deploying and managing reports on Report Server and SharePoint Server.
• Experience in creating different kinds of subscriptions to deliver reports to users on schedule basis.
• Experience in creating visualizations and dashboard reports using Tableau Desktop.
• Experience in ETL process using Integration Services (SSIS) SSIS Import ExportData, Bulk Insert, BCP and DTS/SSIS Packages.
• Experience in creating, deploying and automate SSIS Packages.
• Automating teh Database Maintenance tasks, SSIS packages by creating Jobs using teh SQL Server Agent.
• Experience in business intelligence/data warehousing practices and tools (including SSAS)
• Extensive experience in creating multiple reports (SSRS) including parameterized reports, Tabular forms, Matrix forms, Drill-down reports, Drill-through reports, Charts, Sub-reports using SSRS2012/2008
• Knowledge in developing SSAS cubes using visual studio 2008 R2/2012. Creating reports from cubes using MDX
• Experience in implementing Partitions, Aggregations, and handling many to many relationships between tables in teh cube.
• Knowledge of VB, C#.NET, ASP.NET, ADO.NET.
• 24X7 on call support for Production Servers. Experience in working with offshore team.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and teh ability to think outside teh box.
• Excellent Written, Analytical Skills, Verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Database Management System: MS SQL SERVER 2012/2008R 2/2008/2005/2000, MS-Access,DB2

Database Utilities: Enterprise Manager, query analyzer, SQL server, Profiler, SQL Server Management Studio.

ETL Tools: SQL Server integration services (SSIS), Data Transformation Services

Reporting Tools: MS SQL Server Reporting Services, Crystal Reports, Tableau

Programming Language: TSQL, SQL,C,C++,VB,C#.NET

Operating Systems: WindowsServer 2000/2005/2008/2008 R2/2012

Utility Tools: MS Office, Visual Source Safe 6.0

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Developer / SSRS, SSIS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call teh packages and Stored Procedures.
• As a Team Player, involved in gathering teh Business Requirements for Extraction of Data from different sources.
• Responsible for database design and creation of tables, views and functions.
• Developed custom reports using SSRS/SQL Server BI studio.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Provide database coding support to application development team.
• Extract Transform Load (ETL) development using SQL 2012/2008 Integration Services (SSIS).
• Created SSIS packages using various Data transformations like conditional splitting, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.
• Used system stored procedures and DBCC commands.
• Wrote some complicated stored procedures in order to meet teh requirements.
• Successfully migrated teh data from various sources such as Oracle, Flat files, Excel files and MS Access.
• Created new SSIS packages for Extracting data using Sequence Container, For Each Loop, Container, Execute SQL Task, Merge Transformation etc.,
• Modified teh Existing SSIS Packages to improve teh performance of Data Load.
• Generated Quarterly, Semi-Annual and Annual reports through Tabular and Matrix reports using SSRS Reporting tool.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2005/2008/2012, T-SQL, Oracle 11g.

Confidential, Columbus, OH.

SQL BI Developer

Responsibilities:

• Involved in gathering, understanding and validating teh project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services 2012.
• Developed complex T-SQL queries for teh ETL packages.
• Designed packages in SSIS2012 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Wrote teh ETL scripts to load teh data into database from various source files. Experienced in errorhandling and troubleshooting teh scripts in failure to load teh data into database.
• Created user variables, property expressions, script task in SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.Expert in SSIS Deploying and Scheduling packages
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented teh table relationships with diagrams.
• Designed different type of reports including: Tabularforms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interactedreports (drill-down and sorting functionality).
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: MS SQL Server 2005/ 2008/ 2012, T-SQL, MS SQL Integration Services 2008/2012, MS SQL reporting Services2005/ 2008 R2/ 2012.

Confidential

SQL BI Developer

Responsibilities:

• Developed T-SQL queries, stored procedures, functions and triggers for dis complex integration. Actively involved in different stages of Project Life Cycle.
• Generated reports (using SQL Server Reporting Services) based on teh user requirements to produce detailed summary for analysis.
• Developed complex StoredProcedures, triggers, cursors, tables, constraints, views and other SQL joins and statements for applications.
• Scheduled Jobs on various stored procedures and packages to automate processes.
• Created SQL serverReports using SSRS 2008. Created drill down reports, drill through reports and parameterized Reports in SSRS 2008.
• Identified teh data source and defining them to build teh data source views. Generated Reports using global variables, expressions and functions for teh reports.
• Responsible for deploying and managing reports on Report Server.
• Responsible for creating various kinds of Subscriptions like Email subscriptions and File share Subscriptions.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Used ETL to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing teh d data.
• Created packages in SSIS with error handling worked with different methods of logging in SSIS.
• Experienced in critical problem solving, building tools to integrate and manage large sets of data.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: SQLServer2005, 2008, 2012, SSRS 2008 R2, SSIS, SSAS .Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML, VB6, VB Script, Java Script, C#

Confidential

MS SQL Server Developer

Responsibilities:

• Actively participated in gathering business requirements and system specifications.
• Created new databases, tables and established relationships between teh tables in teh database.
• Created efficient stored procedures and functions to support organized data storage and manipulation.
• Created views to display required information on user interface and trigger to validate consistent data entry into teh database.
• Extensively involved in writing stored procedures, triggers, common table expressions and functions based on client requirement.
• Created and administered multiple developments, production and databases.
• Reduced system downtime risk through automatic offsite backup and recovery over network.
• Responsible for installing and configuring SQL Server 2005 on Windows NT Operating systems.
• Used BCP utility to publish table output to text files.
• Identified, tested and resolved database performance issues like monitoring and tuning to ensure database optimization
• Maintained SQL scripts for changes in database objects.
• Involved in running trace from teh profiler to troubleshoot database and used DBCC check commands to check teh consistency of teh database.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Set up SQL mail and created jobs to automate and schedule many tasks.
• Involved in support team and halped in 24X7 production support.
• Involved in coordinating post-implementation events such as testing.

Environment: SQL Server 2005, T-SQL, Windows NT, MS Access, Visual Basic 6.0, Enterprise Manager.