SUMMARY

• 8+ years experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 7.0/ 2000/2005/2008 for both OLTP and OLAP Systems.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files. Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. Deployed reports across Test, Dev and production environments.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Performed Data Mining activities on central repository for various application and dashboard functionalities. Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
• Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
• Created Scorecards/Dashboard Pages in Performance Point Server (PPS).
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans. Creating and Managing logins, users, roles and assigning necessary permissions.

ACADEMIC QUALIFICATION

Master’s

CERTIFICATIONS

• Microsoft Certified Technology Specialist in SQL Server 2008.
• Brain bench Certified in SQL Server 2008.

PROFESSIONAL EXPERIENCE

Confidential,Tampa, Florida Sep 2011 – Till Date
SQL Server Developer/ SSIS and SSRS Developer

Description: Investments IT delivers premier global IT solutions that add business value and competitive advantage for MetLife Investments. The organization develops and supports front, middle and back systems for derivatives, securities, agriculture & real estate investments, and international investments.IIDB is a Data warehouse application to support US GAAP and Federal Reserve/BHC reporting requirements. Main Purpose of IIDB is to consolidate securities data from various countries into one location for generating FAS 115 & 157 reports. This application also provided Business Intelligence facility for analytical purpose. Overall this system increases the accuracy and speed of generating external financial reports.

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated reports from Cognos to SSRS.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked closely with the Data modeler.
• 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 FAS 115 and 157 reports and some end user request reports on periodic basis.
• 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 and Created a stack of stepped reports using the Tablix.
• Developed reports and deployed them onto SharePoint 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.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Worked very closely with Business owners, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential,Texas June 2010 – Aug 2011
SQL Server Developer/ SSRS Developer

Description: Dell is an Americanmultinational information technology corporation that develops, sells and supports computersand related products and services. This project is all about maintenance and keeps track of all the recent surveys. This project is used to provide accurate survey result to the business user which helps in increase of more benefits to the customer and to provide great support 24/7.

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS).
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• 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.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

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


Confidential,MS SQL Server Developer

Description: As a sales and marketing services company, Maritz understands the core of what drives a company’s success-people. Maritz help clients unlock the power of their business strategies by unleashing the potential of their people through understanding, enabling, and motivating employees, channel partners, and customers.

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for processing CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL 2007.


Confidential,Santa Clara, CA Feb 2008 – Mar 2009
SSIS/SSRS/SSAS Developer

Description: Intel Corporation is the largest semiconductor company worldwide and the leading manufacturer of computer, networking, and communications products globally. The project aimed at integrating the existing data sources for Intel ordering web-site to reduce the maintenance and to increase efficiency of ordering. It aimed at consolidating the data sources of various applications like General Business, Retail consumer into one centralized data source. This involved merging the current legacy systems into a single SQL Server data source which is more than 2 TB in size.

Responsibilities:

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Involved in updating slowly changing dimensions strategies.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS).
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005.