PROFESSIONAL SUMMARY:

• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 with various business domains like Financial and manufacturing, Health Insurance.
• Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008.
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Worked Extensively on ETL process using SSIS package.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Migration experience with DTS to SSIS 2008.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008.
• Extensive experience with data modeling techniques, logical and physical database design.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users. SQL Server Services (DTS, SSIS, SSRS, SSAS)
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS).
• ETL implementation using SQL Server Integration Services (SSIS)
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports,, and formatting them using both SSRS 2005/2008.
• Very good knowledge in scheduling and deploying reports on report manger.
• Experience in creating reports using Report Builder 3.0.
• Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Experience in deploying created reports in various sources like Web browser, XML and PDF
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS) Stored Procedure, Functions, Views, Joins, Indexes and Cursors
• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions and other T - SQL statements for various applications.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Experience in using T-SQL in SQL Server 2000 and 20005/2008 platform
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experience in using Try Catch block introduced in SQL Server 2005/2008. Query Optimization and Tuning
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance. Database Design and Implementation
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Good knowledge in SQL Server2005/2000 Client Server Architecture.

TECHNICAL SKILLS:

Languages: C, SQL, T: SQL

RDBMS: ETL

MS SQL Server 2008, 2005, 2000, MS-Access: DTS, SSIS

Web Technologies: ASP.Net, HTML, XML

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS

Operating System: Windows 2000/XP/NT.

Reporting Tools: Microsoft Visual Studio 2005, MS Office, Crystal Reports, Tableau 7.0, SSRS, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

SQL BI Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Created complex Stored Procedures, triggers, cursors, tables, Views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Implemented computational sensitive queries in Stored Procedures.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers.
• Experience in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Implemented Complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Created various database objects tables, indexes, views, stored procedures and triggers, Co-related sub queries, Dynamic SQL queries and implemented referential integrity constraints for enforcing data integrity and business rules.
• Experience inError handling through TRY-CATCHstatement,Common Table Expression (CTE).
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in Requirements gathering, Analysis and design of all the client requirements.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Confidential, Alpharetta, GA

SQL BI Developer

Responsibilities:

• Responsible for tuning T-SQL procedures, triggers and other database objects
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• 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.
• Created packages to load data from various sources like Flat File, Excel and OLEDB in SSIS 2008 R2
• Have deployed packages on different servers by using package configurations.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating reports in SSRS 2008 R2.
• Developed drill down, drill through and Parameterized reports using SSRS 2008 R2
• Created Subscriptions, Data driven subscriptions and managed security for reports on SSRS Report Manager
• Experience in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services) from BIDS.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Experience in designing a database design strategy and database for optimal performance.
• Designing and Optimizing Database Solutions with Microsoft SQL Server 2008.

Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2008 Enterprise Edition, Microsoft Visual Basic 6.0, SSIS, SSRS, SSAS, SharePoint 2007, OLAP, OLTP, Erwin

Confidential, San Diego, CA

SQL BI Developer

Responsibilities:

• Created different stored procedures and assigned cursors for running and also used stored procedures for some job automations.
• Generated test data to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Deployed SSIS packages and Reports to Production Servers.
• Migrated data using ETL Tool in SSIS.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Deployed SSRS Reports inSharePoint 2007 for web based access for multiple end users
• Highly involved in creating, structuring, formatting usingReport Designer and Report Builder.
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
• Reviewed and developed data models and database designs with development teams

Environment: MS SQL Server 2008/2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, SSRS, SSIS, OLAP.

Confidential, Sunrise, Florida

MS SQL Server Developer/ BI Developer

Responsibilities:

• Used different T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Analyzed and designed software and database solutions.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Scheduling the SSIS packages and Jobs
• Created SSIS Packages to migrate slowly changing dimensions
• Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created several lookup tables and updated couple of existing lookup tables.
• Developed reports by using SSRS and deployed to the QA, Testing, and Production Servers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.

Environment: MS SQL Server 2005, SQL Server Reporting Services 2005, SSIS, Windows XP / NT / 2000, MS Office 2003.

Confidential

SQL BI Developer

Responsibilities:

• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Written several stored procedures to achieve various functionalities of the system.
• Assisted the Application team in data modeling and T- SQL coding.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: Visual Basic 5.0, Windows NT, T- SQL, EXCEL, Access, SQL Server Enterprise Manager, SQL Profiler.