SUMMARY

• Over 8 years of experience in Microsoft SQL Server and 5+ years extensive experience in Microsoft Business Intelligence Tools - SSIS, SSRS, SSAS, etc. in various domains telecom, healthcare, insurance and utilities.
• Expertise in SQL Server 2008 SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Extensive experience in Data Migration, Data Conversions, Data Extraction/ Transformation/ Loading (ETL) using DTS, SSIS
• Expertise in database design, development for OLTP (batch processing, online processing), OLAP, ODS, ETL, MDX, data warehousing and data modeling.
• Well-developed skills in SQL Server Integration Services 2008/2005/2000 for data extraction, transformation and loading using different heterogeneous source systems like flat files, Excel, Teradata, Oracle, SQL Server.
• Experience in migrating DTS packages to SSIS, migrating databases from SQL 2000 to SQL 2005, and troubleshoot migration issues, importing and exporting packages to SQL Server and file system.
• Expert in developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2008/2005.
• Proficient in developing multi-dimensional cubes, Dimensions, Facts using SSAS, SSAS-Data Mining Models, Deploying and Processing SSAS objects.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience in configuring and maintaining report manager and report Server for SSRS.
• Designed and developed matrix, tabular and parametric in the SQL Server Reporting Services.
• Experience in developing linked reports, sub reports, create complex reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Experienced in handling Slowly Changing Dimensions while loading data into data warehouse. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience with Transact-SQL coding in creating complex stored procedures, functions, views, indexes, user profiles, relational database models, data dictionaries, data integrity and appropriate triggers to assist efficient data manipulation and data consistency.
• Designed complex mappings, expertise in performance tuning and optimizing databases by using Index tuning Wizard and SQL Profiler.
• Strong T-SQL Development skills including Stored Procedures, Indexed views, User Defined Functions (UDL), Triggers, BCP, Bulk Insert, Correlated Sub queries, Inline views, CLR, CTE and Distributed Queries.

TECHNICAL SKILLS

ETL Tools: MS SQL Server Integration Services 2008/2005, DTS.

RDBMS: SQL Server 2008/2005/2000 , Oracle, Teradata, MS Access

Languages: SQL, T-SQL, PL/SQL, MDX, C, C#, ASP.net, Visual Studio 2005

Data Modeler: Erwin 7.2/4.5/4.0, MS Visio 2003/2007

Packages: Microsoft Office 2007/2003/2000

Web Technologies: HTML, XML, ISS

Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS).

Operating Systems: Windows Server 2008, Windows 7/Vista/XP/NT, UNIX.

BI Tools: Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SQL Server Management Studio.

OLAP/Reporting Tools: SQL Server Analysis Services, MDX, SQL Server Reporting Services 2008/2005 (SSRS), Crystal Reports, Cognos.

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SQL Server BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Developed T-SQL Stored Procedures for SSIS packages. Performed query optimization and implementing good programming practices.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Developed applications using ASP.NET, C# with SQL SERVER Confidential the back end.
• Migrated DTS packages using DTS editor wizard inSSIS, validated and tested all packages on development server.
• Implemented and maintain ETL processes & SSIS packages to consolidate data from other business units and departments (Excel, CSV, and Text).
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Developed PL/SQL parameterized stored procedure in Oracle package from SSIS.
• Used script component in the dataflow task to execute Oracle PL/SQL code.
• Worked on different levels of ETL like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Created SSIS/DTS packages for application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups.
• Implemented Event Handlers, Error Handling in SSIS packages and used package configurations to make packages available for deploying in different environments.
• Worked with Data Modeling and handling OLTP Databases and ability to design databases upon requirements.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Created and Configured OLAP Cubes (Star Schema and Snow flake Schema Modeling) using SSAS 2008 and created calculated members using MDX and dimensions design and scaling to large numbers of users.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Expertise in writing complex MDX queries for calculated members and measure groups (SSAS).
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Created different graphs like Pie charts, Bar charts, line charts.
• Wrote the queries for the drill down reports, identified and added the report parameters.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Formatted the reports using the global variables and expressions, deployed the generated reports on to the server.
• Created SSRS reports based on requirement. Create Linked reports, Sub reports, Parameterized reports, drill down reports.
• Organized and performed code reviews for the SSIS packages, SSRS Reports and the objects involved.

Environment: Microsoft SQL Server 2000/2005/2008 R2 Enterprise edition, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), BIDS, Microsoft Visual studio, Internet Information Server (IIS), Visual Source Safe 2008, ERWIN, C#, ASP.net, PL/SQL, SQL Profiler.

Confidential, PA

SQL Server SSIS/SSAS Developer

Responsibilities:

• Created complex stored procedures for complex reports developed using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Created Standard Subscriptions and Data Driven Subscriptions using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snow-flake schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed calculated measures using multi-dimensional expression (MDX), mathematical formulas and user-defined functions.
• Created partitions, calculated members for fact tables and cubes.
• Optimized the query performance on cube by following the recommended best practices.
• Experienced in analyzing multidimensional cubes in SSAS by using slicing and dicing, drill down, drill up, and drill through.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used Script Task to perform complex Transformations using C#.Net and Vb.Net coding.
• Applied various data transformations like SCD (Slowly Changing Dimension) - to maintain the history of the data, aggregate, multicasting, conditional split and derived column.
• Created configuration files to enhance the ease of deployment in testing and production servers
• Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Extensive testing on the performance of the stored procedures.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Experienced in writing complex MDX queries for calculated members and measure groups (SSAS).
• Experienced in creating complex Reports on Analysis Services cubes (SSAS).
• Created Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), C#, .Net framework, Microsoft Office Share Point Server, Oracle 10g, XML, MS Visual Source Safe.

Confidential, Des Moines, IA

SSIS/SSAS/SSRS SQL Developer

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS) 2005.
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Experienced in analyzing multidimensional cubes in SQL Server Analysis Services (SSAS) 2005 by using slicing and dicing, drill down, drill up, and drill through.
• Experienced with writing MDX which multi dimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Defines Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security Roles in SSAS 2005.
• Created Partitions, Calculated Members, Schemas, and File Groups for Fact Tables and Cubes.
• Designed and developed various Reports on SSAS Cubes as the data source.
• Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2005.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Designed SSRS reports with sub reports, expressions and queries, and preparing Ad-Hoc reports through report builders.
• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS 2005.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2005.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per the requirements.
• Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Experience with Data migration utilities (Import & Export, BCP, Bulk Insert) from text to SQL Server.

Environment: MS SQL Server 2005/2000, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, C#, VB, Visual studio2005, Erwin, Windows Server 2003.

Confidential, Atlanta, GA

Senior SQL Server Developer(SSRS/SSIS)

Responsibilities:

• Designed normalized database schemas for document repository project. Coordinated with business unit and development staff to design most efficient schema
• Developed complex T-SQL Programs, writing stored procedures with proper exception handling, Triggers (DDL & DML), cursors, indexes and views
• Maintained the table performance by following the tuning tips like normalization, creating indexes and updating statistics.
• Created queries for generating drill down reports in SSRS, the reports thus developed were more interactive.
• Configured database mail and created job alerts using SSMS to send notifications using email.
• Maintained change control and release management process for all database objects like tables, views, procedures and triggers using Team Foundation Server.
• Wrote T-SQL Procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Data Extracted, Transformed and Loaded (ETL) from different Servers like MS Access, Flat Files and Oracle Source using SSIS.
• Performed migration of DTS packages to SSIS. Created detailed mapping and design documents
• Generated various SQL Server reports and report models on views using SSRS for the Revenue Assurance team, DTV and the downstream billers and deployed them on to the production reporting server
• Responsible for scheduling the subscription reports with the subscription report wizard
• Involved in testing and data validation of reports
• Worked on optimization of long running queries, poor indexing, parallelism issues and their effects on the database /application. Utilized performance tools including SQL Profiler, Performance Monitoring, Query Analyzer Execution Plans, and Database Engine Tuning Advisor.
• Designed backup strategies and implemented the same to minimize the server downtime incase of any database failures.
• Administered the MS SQL Server by creating roles, user logins, monitoring user accounts, granting user permissions to users and groups.
• Archived the tables and files from business and other teams periodically to increase database free space.

Environment: SQL Server 2005/2008, Oracle 9i/8i, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Office, Windows, Visual Studio, T-SQL, Team Foundation Server (TFS).

Confidential

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system analysis and design, and creating stored procedures.
• Designed and developed interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using C#.
• Created DTS packages to schedule jobs for Batch Processing.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Used DBCC commands to check physical and logical consistency of the databases
• Optimized database performance using SQL Profiler
• Optimized SQL queries using Query Analyzer
• Designed the logical and physical databases of SQL Server.
• Performed database testing & maintaining the data by using the procedures.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Imported and exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Designed a report on the monitoring of server performance using Task manager and Performance Monitor

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, C#.

Confidential

SQL Server Developer

Responsibilities:

• Involved in the development of the system.
• Involved in ER diagrams and mapping the data into database objects.
• Design of the database and tables.
• Created database Tables, Indexes, Views and created customized Stored Procedures, Triggers and Cursors
• Installed and configured SQL Server 2000 successfully.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules.
• Wrote procedures to check some of the rules Confidential the backend Confidential the time of entering data.
• Developed SQL scripts to insert/update and delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Testing and debugging of procedures.
• Monitored the database and performed fine tuning, query optimization for improved performance.
• Used ADO.NET for fetching and storing of data from SQL Server 2000.
• Used XSLT to create templates.

Environment: SQL Server 2000, Enterprise Manager, SQL Profiler, T-SQL.