Professional Summary:

• Over 8 years experience as MS-SQL Server Developer, involved in Design, Development and Support of MS SQL Server 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.
• Through 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
• 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.
• Experience in Performance Tuning in SSIS packages by using Row Transformations.
• Developed dashboard reports using SQL Server Reporting Services SSRS , Report Model and ad-hoc reporting using Report Builder.
• xperiences in SQL Server Analysis Services OLAP Cubes.
• 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.
• Worked with category for implementation master data management MDM of new products, customers and vendors.
• Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
• Created Scorecards/Dashboard Pages in SSRS.
• 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.
• Experience with EMS DB Extract for SQL Server.

Skill Summary:

• RDBMS : MS SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008,
• Oracle 8i/9i/10g, Sybase, Teradata.
• Languages : T-SQL, PL/SQL, MDX, C, ASP.net, VB.net, C .NET , Unix Scripting
• Tools Packages : SQL Server Management studio, Enterprise Manager, Profiler, SQL Server DTS, Visual Studio .NET, ETL, Spotlight, Business Intelligent studio.
• Operating Systems : Windows vista/XP/2003/2000, Windows Server 2000/2003/2008.
• BI Tools : SSRS, SSIS, SSAS, MS Visio, Erwin, Informatica6.x
• Web Technologies : XML, HTML, XSL, JavaScript.
• Application Packages : MS Office, MS Outlook, Windows SharePoint Services.

Experience:

Confidential

MSBI Developer/ ETL Developer

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.
• Closely working with category for implementation master data management MDM of new products, customers and vendors.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2012.
• Developed complex T-SQL queries for the ETL packages.
• 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 2012 with new features.
• Create and maintain data model/architecture standards, including master data management MDM .
• Used master data management MDM to define reference data
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Created packages with Ragged Right data mapping.
• Conversant with all phases of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• 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.
• 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, MS SQL Integration Services 2008, MS SQL reporting Services2008,Microsoft Visual Studio 2010, SharePoint Designer, SQL Server Management Studio.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Identified various data sources, formulated data dictionaries, design and develop data models physical/logical data models based on the given specs and requirements.
• Involved in designing and implementing database applications using MS SQL Server 2005/2008 and Business Intelligence BI tools to support transactions and business decision-making.
• Developed complex T-SQL code for the application.
• Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Created various database objects such as tables, indexes and views based on the requirement.
• Implemented constraints on tables.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created stored procedure for generating reports using SQL Server Reporting Services SSRS .
• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Adept in creating Reports using SSRS 2008/2005 like drill down, cross tab, matrix style layouts, performance issues handling, Ad-hoc Reporting framework design
• Designed and implemented Parameterized and cascading parameterized reports using SSRS
• Created Sub-Reports, Drilldown-Reports, and Summary Reports in SSRS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Involved in creating Cubes using SQL Server Analysis Services SSAS .
• Monitor and provide support to the application during the testing and production environments
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Created various kinds of reports like f004, f006, f003, Aging reports.
• Involved in checking various Performance issues using RS objects of the reports in SSRS and in data integrity issues.
• Automation of creating Accounting code module for each bill.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Wrote complex T-SQL queries for data extraction.

.

Environment : SQL Server 2008 R2 / 2008/2005, SSRS SQL Server Reporting Service , SSIS SQL Server Integration Services ,Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional.

Confidential

SQL Server/ETL Developer

.Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams Physical and Logical using Erwin and mapped the data into database objects.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up Recovery.
• Developed stored procedures, functions, views and triggers.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and drill through Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• creating Reports using SSRS 2008/2005 like cross tab, matrix style layouts, performance issues handling, Ad-hoc Reporting framework design
• Responsible for stylish design layout like Pie charts and Graphs.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements and design of data warehouse entities.
• Conduct code walkthroughs and review peer code and documentation.
• Created and maintained the data mart for different LOB.
• Fine tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and functions.
• Used Visio for diagramming in the design phases.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Created and Configured OLAP Cubes using SSAS
• Performed Data Migration from SQL Server 2000 to SQL Server 2005.
• Assisted in defining Query for generating drill down reports in SSRS.
• Developed SQL Server Integration Services SSIS packages to transform data from various data sources to MS SQL 2005.
• Assisted in creation of SQL Server Analysis Services SSAS cubes for analysis.
• Experience in using global variables, expressions and functions for the reports.
• Experience in handling parameterized reports in SSRS.
• Deployed packages from one environment to another Development to testing to production .
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Performed documentation of standards, best practices, and ETL procedures
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provided on-call support to production system to resolve any issues.

Environment:

Windows 2000 Server, Windows 2003 Server, Rational Clear Quest SSIS 2005, DTS,Oracle 9i/ 10g, SQL Server 2005, MS Access, T-SQL, PL/ SQL, SQL, Erwin 4.2, SSRS.