SUMMARY:

• About 8 years of experience in IT environment with primary skill on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and Business Intelligence suite SSIS, SSRS, and SSAS in various domains like HealthCare, Banking and Insurance as SQL Developer and MSBI Developer.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Expertise in developing reports, packages and cubes in SQL Server 2005/2008/2008 r2/2012 BIDS, SQL Server 2012DATA TOOLS.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, CTE, Triggers, cursors.
• Written stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects and so on
• Experience in using the DMVS, DMFS, INFORMATION SCHEMA, and SYSTEM VIEWS and in built GLOBAL VARIABLES for the instant analysis.
• SQL Server 2005/2008/2012 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience in Configuring the Deployment Environment in PROD and QA for SSRS and SSIS
• Good at ETL(SSIS), Data and Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and Production servers.
• Developing reports in SSRS on SQL Server (2000/ 2005/2008/2012 ).
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Report management, Report delivery andReport security.
• Experience in writing Distributed Queries between SQL Servers.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Strong experience in creating various reports like Drill through, Drill down, Sub reports, lined reports, Tablix, matrix reports and Ad - hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Implemented Side by Side Migration of MS SQL SERVER 2000/ /2008r2/2012.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (DTS, SSIS, BCP, Bulk Insert, ActiveX).
• Expert in SSIS Packages for OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) using transformations.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, activity monitor, Event viewer for performance analysis.
• Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Migration experience with DTS to SSIS 2008 and experience with data modeling techniques, logical and physical database design.
• Experience in scheduling and deploying reports on report manager.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Comprehensive knowledge of MS SQL stored procedures, ETL, SSIS and SSRS along with SharePoint integration.
• Wide knowledge ofFacets Data Modelin Membership and Billing.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

TECHNICAL SKILLS:

Databases: SQL server 2000/2005/2008 R2/2012, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports,Tableau

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Star Schema Modeling, FACT, Dimension Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server2008/2012 Analysis Services and SQL Reporting services, DTS, ProClarity.

Sr.SQL DEVELOPER/SSIS/SSRS DEVELOPER

Confidential, COLUMBIA, SC

Responsibilities:

• Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server 2005.
• Monitored Performance and Optimized SQL Queries for maximum efficiency.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Perform DBCC checks to ensure the physical consistency of the database and objects.
• Implemented transactional replication among different servers to have high availability of the data.
• Created DDL, DML scripts, stored procedures, CTE according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database
• Develop, maintain, implement and support all SSIS development & production efforts.ETL development for data warehouse data marts daily refresh and real time reporting, utilizing both SSIS and DTS packages using SQL Server 2005 and 2008.
• Created the packages based on mapping document using SQL Server Integration Services (SSIS).
• Using SSIS 2005, building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages.
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Deploying and scheduling SSIS packages and jobs using SQL Server Agent.
• Create jobs, Alert and schedule DTS/SSIS Packages and SSRS to generate reports.
• Working with reporting team in Designing, Developing and Deploying Reports in SSRS.
• Designed and architected Report Layout including both simple and complex report using SSRS 2005.
• Studying the structure of RDBMS to develop multi dimension Objects (Cubes, Dimension) using SSAS.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Practical involvement in creating dimensions using STAR and SNOWFLAKE schema.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, TABLEAU, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

BI/SSIS/SSRS DEVELOPER

Confidential, OH

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Project Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Giving inputs to the team.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout, Created a stack of stepped reports using the Tablix.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2007, IIS 6.0, MS SQL Server- 2012/2008/2005 Enterprise Edition, SSIS, SSASSSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

SR. SQL SERVER/SSIS/SSRS/SSAS DEVELOPER

Confidential, BOSTON, MA

Responsibilities:

• Worked in AGILE methodology in development of Database Objects in SQL Server 2005/2008/ 2008 R2/2012.
• Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Performed Data Modeling in ER Studio Data Architect 9.0 in the initial stages of the project.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2005 and 2008R2.
• Developed SSIS packages and SSRS reports in SQL Server 2008/ 2008 R2/2012.
• Performed data cleansing by creating tables to eliminate the dirty data and implemented Error Logging using SSIS.
• Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
• Created SSIS packages to do incremental data load between PROD and QA.
• Strong background in Data Warehousing principles and methodologies.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created Report Models for building Ad hoc reports using SSRS.
• Created and managed roles for security in Reports.
• Created Cubes with Star schema in SSAS and developed SSRS reports based on the cubes.
• Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64 bit system .
• Designed, Setup and Documented the Transactional Replication on multi TB database for the reporting purpose.
• Met SLA’s fine tuning the SSRS and long running ETL queries.
• Regularly supported service packs and hot fixes for both clustered and standalone SQL Server.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Worked in SVN version controlling environment.

Environment: SQL Server /2012/2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008, SVN Version controlling.

SQL SERVER/MSBI DEVELOPER

Confidential, GLEN ALLEN, VA

Responsibilities:

• Developed SQL queries to Insert, Update and Delete data in Database.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and maintained Linked Servers.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Generated various SSRS Reports based on requirements.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

SQL SERVER DEVELOPER

Confidential

Responsibilities:

• Involved in Physical and Logical design of the databases.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Created and maintained Data Transformation Service (DTS) packages for migrating data.
• Scheduled Jobs for DTS packages.
• Used BCP/Bulk Insert to publish table output to text files.
• Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
• Used all Declarative Constraints for maintaining Data Integrity.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Auditing using triggers.
• Created schema objects, rules and granted roles to the users.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored the Database Performance using execution plans and Index tuning.
• Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
• Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000 server, Windows NT 4.0.