SUMMARY

• Over 7 + years of experience as SQL Server Developer/Admin/Business Intelligence Developer. Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Experience in OLTP,OLAP/Data Warehouse, and DataMart and ODS Data Bases.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Experience with SQL Server 2000,2005, 2008 and Denali 2012.
• Proficient in T - SQL queries using StoreProcedure,Dynamic SQL, joins, Views, User defined functions, Triggers,Cursors, CTE, DML, DDL and etc.
• Proficient in Performance Tuning of SQL query.
• Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, DeNormalization.
• Partitioning, ACID Property, DataWarehouse, Bill-In methodology,Ralph Kimball methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.
• Excellent in MS SQL Server 2005/2008 suite of products like SSIS, SSAS and SSRS
• Good experience in developing reports using SQL Server (SSRS)
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot
• Experience in Visual Studio Team Foundation Server, Visio
• ETL experience across Oracle, Access, MySQL and Excel
• Proficient in writing MDX query and good knowledge of all MDX Functions
• Experienced in Database Administration
• Experience in making formal and informal presentations to technical and non-technical staff
• Expert in Creating and managing roles for security in SSRS reports.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional and high availability process like Shipping and Clustering Data Tuning.
• Creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL.
• Used SSIS Import/Export Wizard for performing the ETL operations.
• Experienced in design and development of parameterized queries and generating formatted reports using Crystal reports 9.0/8.0 and SSRS 2005/2008(R2).
• Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
• Extensive experience in generating different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Expertise with parameterized reports and Cascade Parameterized Reportsin SSRS 2005/2008/ R2.
• Excellent experience in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.
• Experience with Queryanalyzer for SQL Server 2005/2008.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2008R 2/2008/2005/2000 , MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, SSRS OLAP. Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: HTML, C#, Java, T-SQL, SQL, PL/SQL, Dynamic SQL,PERL

Design Technologies/Tools: Erwin, MS Visio

Data Warehouse/Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Proficient in writing complex queries and stored procedures in SQL Server 2008 r2.
• Migrated SQL server 2008 tables into CSV files using SSIS packages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Created and executed SSIS packages to populate data from the various data sources and for different data loading operations on many applications.
• Designed highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Createdpackages using SSIS Designer for exporting heterogeneous data from OLE DB Source.
• Migrated packages to SSIS and modified the packages accordingly using the advanced features of Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc) and loaded the data into target data sources by performing different transformations using SSIS.
• Experience in creating Multidimensional cubes using SSAS.
• Built MDX(Multi DimensionaleXpressions) queries and Data Mining Extensions (DMX) queries for Analysis Services & Reporting Services.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 r2.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backup, restore of entire system & other databases as per requirements, and also scheduled those backups as part of automation in sql management studio.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Confidential, Cleveland, OH

DTS/SSIS/SSRS Developer

Responsibilities:

• Responsible for transformation and loading into the target SQL Server databases using ETL tools, SSIS 2008.
• Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily in order to create and maintain a centralized data warehouse.
• Made the package dynamic so it fits the environment.
• Scaled SSIS to make it work more reliable.
• Expertise experience with administering and debugging DTS and SSIS.
• Created scheduled jobs to execute DTS and SSIS packages.
• Transferred/Rewrote DTS packages to SSIS Packages. Hands on working experience with configuring every aspects of SSIS 2008.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Developed reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2005/2008 Enterprise, Hyperion Essbase, Hyperion Report 9, Microsoft Reporting Service, SQL server BI development studio, Microsoft Visual Studio 2008.

Confidential, Farmington Hill, MI

SQL Server SSIS/SSRS Developer

Responsibilities:

• Installed, Configured, Managed and Monitored SQL Server 2005/2008.
• Creating tables, indexes and designing constraints.
• Written several SQL Scripts such as finding tables with Identity Columns, tables that do not have primary key in order to streamline the process of replication.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Developed and deployed SSIS packages in Production Server.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting, worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: SQL Server 2008/2005, Windows 2003/2008R2, SSIS, SSRS, SSAS, Visual Studio 2005, Microsoft Office Suite, Microsoft Visio, Performance Monitor, ETL, Performance Tuning, SQL Profiler and Erwin.

Confidential, Minneapolis, MN

SQL Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Wrote stored procedures to be used in the SSIS packages.
• Deployed SSIS package involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created various Dimensional Hierarchies, KPI’s as part of cube design.
• Designed aggregations using aggregation wizard.
• Designed STAR, SNOW FLAKE Schemas.
• Worked on database modeling, logical and physical database design using Erwin.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Worked with Managers and Management to design customized Reports to view OLAP cube Data.
• Created custom and Ad hoc reports using SSRS.
• Generated different types of Reports like Tabular, Matrix, and Charts.
• Generated several drill down and drill through reports using SSRS.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Deployed the generated reports directly on the client’s workstation.
• Helped in the Installation and configuration of MS SQL Server 2008.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Had to modify the current stored procedures to meet the current design.
• Identified and defined the Datasets for report generation.
• Wrote T- SQL queries for data retrieval.
• Took part in the normalization and de-normalization of database.
• Worked with team in developing interfaces using C#, ASP.NET.

Environment: SQL Server 2005, Windows Server 2003, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Erwin 3.5.2/4.0

Confidential

SQL ETL Developer

Responsibilities:

• Involved in modification of data model as per the user requirements and studying the source system using Star Schema and Erwin Tool.
• Actively involved in creation of required database, modified tables, triggers, and procedures to clean and validate the data to meet the specifications.
• Created views and indexed views as required by front end developer for easier implementation on web pages.
• Created stored procedures and functions to support data storage and manipulation.
• Involved in metadata modeling, creating a project, creating and publishing the package.
• Used linked / replicated servers and high-volume data storage.
• Converted the DTS Packages into SSIS using Migration Wizards.
• Migrated data from SQL Server 2000 to Server 2005 via SSIS.
• Actively Involved in Testing and Debugging the Stored Procedures and T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Designed models in Framework Manager and worked with parameter maps.
• Ensured data protection, backup and recovery operations using EMC NetWorker.
• Used Script Component to generating the Surrogate key values in Dimensional Tables.
• Involved in query tuning for increasing the query performance.
• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed and implemented critical system recovery plan through different stages of backup and replication.
• Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2000 to Server 2005.
• Build test scenarios and test cases (negative/positive) to validate expected outcome.

Environment: Windows Server 2003, SQL Server 2005, Visual Studio 2005, T- SQL, DTS, MS Office Suite.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• DevelopedUser Defined Functionsand createdViews.
• CreatedTriggersto maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding IndexesandTables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.