7 Years of extensive IT experience as a Microsoft SQL Server 2000 /2005/2008/2008R2/2012 Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs.

• 7 years of IT experience in Database Development, Design, Analysis, Support of MS SQL Servers 2008, 2005, 2000 in Development, Testing and Production Environments with various business domains.
• Hands on experience with features and functions of Microsoft SQL Server 2012.
• Experience on data migration from SQL Server 2008 to 2012.
• Very good working experience of T-SQL.
• Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions UDF , Database Triggers, using tools like SQL Profiler and Database Tuning Advisor DTA .
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables.
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF's, constraints.
• Involved in Installation, Configuration and Administration of Cognos 8 BI
• Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio, and SSIS ETL tools.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Very Strong skill in building and using CTE's Common table Expressions for building recursive queries.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
• Very strong implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS and Microsoft office SharePoint Server 8 in SQL Server 2005/2008.
• VB.Net and C used for scripting in Script Tasking in SSIS to control the flow of SSIS package.
• Experience in designing, configuring, deploying SSIS packages and providing security for packages.
• Implemented incremental Load for many SSIS packages.
• Experience in Error handling, Debugging, error logging for production support in SSIS.
• Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• SQL Server 2008/2005/2000 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Performed Logging and Deployment of various packages in SSIS.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• ETL implementation using SQL Server Integration Services SSIS , Reporting Services SSRS .
• Strong ASP.NET, VB.NET knowledge.
• Developing reports on SSRS on SQL Server 2000/2005/2008 .
• Created stored procedure for generating reports using SQL Server Reporting Services SSRS .
• Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Good knowledge Database Console Commands DBCC .
• Experienced in managing Data and Transaction log files, Files Groups.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experienced 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 .
• Very good communication skills, good interpersonal skills desire to excel, fast learner, hardworking and a versatile team player.

Responsibilities:

• Involved in gathering, understanding and validating the 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-2008.
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
• Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Good understanding and experience in SQL 2008 new features like Change Data Capture CDC , Transparent Data Encryption TDE and Policy based Management.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Developed transact-SQL commands including complex queries, views, functions, stored procedures, cursors and triggers on SQL server 2008 R2/2008/2005/2000.
• Ability to convert Crystal Reports and Webi Reports to Cognos Reports.
• Created packages with Ragged Right data mapping.
• Conversant with all phases of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Ran and monitored the Data in Data Stage Director Stage jobs.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
• Managed reports using Cognos Connection as Web Portal.
• Modeled and designed the architecture of the SQL Server 2005 database.
• Designed different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports.
• Designed Cascading Collapsed , Printable, interacted reports drill-down and sorting functionality .
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment:MS SQL Server 2008 R2, T-SQL, Cognos, Data Stage. MS SQL Integration Services 2008, MS SQL reporting Services2008,Microsoft Visual Studio 2010, SharePoint Designer, SQL Server Management Studio.

Confidential multinational corporation that designs and sells consumer electronics, networking and communications technology and services. Cisco is one of the world's biggest technology corporations.This project was intended to create a data warehouse, which uses various data sources SQL Server 2005/2008 R2 and Oracle to provide valuable information to discover customer needs and provide this information to the marketing department to aid them in creating new products and identifying customer needs that may be also satisfied by existing products.

• Responsibilities:
• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data and normalized tables.
• Established Joins and created Clustered/Non-clustered Indexes wherever necessary.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Database and Log Backups Restoration, Backup Strategies, Scheduling Backups. Backing up master system databases and restoring them when necessary.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Monitored and scheduled existing/new jobs on production environment.
• Formatted folders, reports and other contents on Cognos Connection.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Involved in Migration of SQL 2005 to SQL server 2008 R2
• Worked to tune the SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures by creating new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services SSIS .
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• 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.
• Migrated DTS objects to SQL Server Integrated Services SSIS environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Target dashboards.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005/2000, DTS, T-SQL, XML, Cognos, Flat File, Data Stage, SQL Server SSIS, SSRS, SSAS, Visio, IIS, Windows XP/2000

Confidential is one of the nation's leading providers of healthcare solutions for hospitals, emergency departments and office-based practices. By offering a complete range of practice support and business intelligence tools such as coding, billing, revenue cycle management, compliance and auditing, medical record scanning and more.

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks
• Trained users to use the Cognos connection to access their corresponding reports and cubes.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.
• Experience in writing custom code expressions in SSRS.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions
• Created Report Models for Business Users to create their own reports.
• Designed created OLAP Cubes with Star schema using SSAS 2008 R2.
• Database Administrator, Database Programming.
• Created Dashboards and Scorecards with Key Performance Indicators KPI in SQL Server Analysis Services SSAS .
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and also Perspectives within the OLAP cube.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Involved in deploying the changes to QA, Staging and Prod environments.
• Managed off shore team in Report migration project.
• Followed agile methodology and coordinated daily scrum meetings.
• Involved in Product Releases and support calls.

Environment: SQL Server 2005/2008R2, Windows Server 2003/2008R2, Data Stage, T-SQL, SSIS, SSRS, SSAS, Crystal Reports, Share Point 2010, BIDS

Confidential is most trustworthy source of benefit administration services. Being trusted involves both possessing character and possessing the right skills and capabilities to provide extraordinary outcomes for our clients. Our trustworthiness as a partner and provider is guided by the following fundamental beliefs that guide every aspect of our services, leadership team and operations.

Responsibilities:

• Developed optimized stored procedures, T-SQL queries, User Defined Functions UDF , Cursors, Views and Triggers , SQL Joins and other statements for benesmart reporting Application, maintained referential integrity and implemented complex logic .
• Enhancing the layouts available for the reports in the BeneSmart application
• Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Required developing ETL processes that utilized the ETL GUI tool Data Stage.
• Develop Data Stage jobs to load the target data into the AS400 Database server. Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C .NET, ADO.NET, ASP.NET.
• Perform including filters to the reports and make it parameter-driven
• Perform including SQL Agent jobs to update source of data by use of SSIS package.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages ETL .
• Deploying the reports to staging server prior to business user acceptance testing.
• Perform including security to the reports and data in the application
• Implement updates of reports in BeneSmart application to recognize same-day data updates/changes.
• Doing release builds and fixing issues related to reports in staging environment of BeneSmart application.
• Created data driven subscriptions for different users using Report Manager.
• Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET and LINQ Language Integrated Query to access and update database
• Expert in debugging an application using debugging tools provided by the Visual Studio.Net IDE.
• Sound Knowledge in ADO.NET to communicate with database for retrieving, accessing, and updating data.
• Proficient with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.

Environment: SQL Server 2008 Enterprise Edition, Data Stage, MS SQL 2008 r2, SQL Server BI Suite SSRS, SSIS and SSAS , Microsoft Visual Stuidio.NET 2010, Microsoft Visio 2003, ASP.NET 3.5, ADO.NET, C .NET, MS EXCEL 2007.