SUMMARY:

• Having strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation in SSIS.
• Extensive Knowledge in developing reports on SSAS & SSRS on SQL Server (2000/2005/2008/2012 )
• Proficient in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Worked in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services (SSIS) with .NET.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Parameterized, Drill-down, Top N, Adhoc, Form, OLAP and Sub reports, and formatting them.
• Extensive knowledge in developing SSRS reports such a Sub Reports, Charts, Matrix, Drill Through and Linked reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Experience in SSRS with Report authoring, Report management, Report Delivery and Report Security.
• Experience in Performance Tuning and Query Optimization.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SSIS, SSAS, SSRS, SQL Server Agent, SQL Profiler, Sharepoint 2007(MOSS)

Database: MS SQL Server 2000, 2005, 2008,2008 R2, 2012

Language: C, C++, T-SQL, HTML, c#.Net, ASP.NET

Operating Systems: Windows XP/2000/2003, DOS

Architecture Relational: DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS, Performance point server, Crystal Report.

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Sr. SQL Server SSRS/ SSIS Developer

Responsibilities:

• Understanding of existing business processes, project functional and technical specifications.
• Involved in meeting with business and exploring requirements and planning for creating Data mart for different systems.
• Involved in identifying facts and dimensions for the Datamart based on reporting requirements and existing reports.
• Designed and developed packages/workflows for data warehouse using Integration services (SSIS) SQL Server 2005/2008 and Business objects Data Integrator by Implementing SCD Type 1 and SCD Type 2.
• Created ETL logging Control tables for maintaining a log of all the loads.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Imported data from text files/excel spread sheets, Informix Database into SQL Server 2005/2008 database using SSIS package.
• Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
• Responsible for Deploying SSIS Package onto Production and used different types of Package configurations to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Developed SSIS packages with monitoring features and custom logging, loading audit information and execution results into audit tables.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Wrote complex SQL Queries using multiple joins for creating Adhoc reports using Report builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots, subscriptions for the reports and worked on scheduling of the reports.
• Involved in migration of SSRS from SQL 2005 to SQL 2008R2.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Windows Server 2003, Performance Point Server 2007,C/C++, Oracle 10g,PL/SQL, Visual SourceSafe, visual Studio 2010

Confidential, Portland, OR

Sr. SQL Server SSRS/ SSIS Developer

Responsibilities:

• Involved in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors that support base views and modules involved in the application for Log View, Demographics, Insurance, Coding both Professional and Facility, Visit, Rules
• Worked on recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Designed, Developed and Deployed SSRS reports.
• Developed ASP.NET Website to render the SSRS Reports and modified the ASP Pages to view SSRS Reports
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Utilized cascaded parameters concept to generate a report from two different Data Sets.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed Reports for business end users using Report Builder with updating Statistics.
• Involved with Query Optimization to increase the performance of the Report.
• Identify test environment and configure application to access the business users and coders.

Environment: SQL Server Management Studio, SQL Server 2000/2005/2008 R2, SQL Server Integration Services, SQL Server Reporting Services

Confidential, Portland, OR

Sr. SQL Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports,Subreports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Interact with the Business Admin and gather the requirements and analyzed.
• Interacted with the Project Managers and the Field Managers who would be using the application the most
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Experience in Programming AMO OLAP advanced objects like KPI’s and Perspectives.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services .
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i,Hyperion 11.1,Performance Point Server 2007.

Confidential, Portland, OR

SSRS/ SSIS Developer

Responsibilities:

• Key role involvement in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Worked in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Worked in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services (SSIS) with .NET.
• Worked Extensively on ETL process using SSIS package.
• Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Scheduled DTS Packages and Involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005,Import Export data, Bulk Insert and BCP.
• Involved in the designing, development, modification and enhancing the database structures and database objects
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Ensure high quality code through rigorous code review processes.

Environment: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Management Studio, SQL Server 2000/2005/2008 R2, ASP.Net and HTML