SUMMARY

• 8+ Years of extensive IT experience as a Microsoft SQL Server /2008/2008 R2. Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Finance and HealthCare.
• Expert in designing and implementing relational database model as per business needs.
• In - depth knowledge of Transact-SQL (DDL, DML).
• Strong technical knowledge in MS SQL Server development including Microsoft Integration Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experienced in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Experienced in using Try Catch block in SQL Server 2005/2008.Query Optimization and Tuning
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created many complexSSISpackages with complicated transformationslikeLookup, Derived Column, ConditionSplit, Multicast, Sort, Union All, Cache Transform, and ConditionalSplitetc
• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Check points, Package Securities and User Defined Variables for SSIS Packages. Hands on experience in creating the MDX cubes and dimensions (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005/2008/2008 R2.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS), Stored Procedure, Functions, Views, Joins and Cursors.
• Supported team in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experienced in deploying created reports in various sources like Web browser, XML and PDF.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
• Good Knowledge in managing Data and Transaction log files, Files Groups. Hands on experience in troubleshooting database issues.
• Excellent experience in designing and developing Reporting System using Business Objects.Experience with Finance, Banking & Accounting Clients.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL, Java, PHP

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2008R 2/2008/2005/2000 , MS Access

Operating Systems: Windows Server 2008R1/2008R2/2003/2000 Windows 2007/2008/ NT/95/XP, UNIX

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

SQL /SSIS/SSRS/SSAS developer

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Used to create Star schema cubes usingSSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• DevelopedMulti-dimensional Objects(Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Experience in creating complexSSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created data loads and Performed Data validations
• Created packages inSSIS with error handling.
• Worked with different methods oflogging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Havedeployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Monitoring the jobs in case of heavy data loads and high memory usage. .
• Worked on SSRS to generate reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts

Environment: SQL Server2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP,SharePoint server 2007.

Confidential, Plantation, FL

SQL /SSIS/SSRS/SSAS developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting need.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2005.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, MS SQL Server 2000/2005, TSQL,Visual Studio 2005,Oracle, SSRS, SSIS, Erwin.

Confidential, Stamford, CT

SQL /SSIS/SSRS/SSAS developer

Responsibilities:

• Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.
• Gathered functional requirements, analyzing and writing the technical specifications.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Created Time Dimensions on OLAP Cubes using SSAS.
• Fine tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• DesignedDimensional ModelingusingSSASpackages for End-User.
• CreatedHierarchiesin Dimensional Modeling using SSAS.
• Experience in debugging Stored Procedures using Visual Studio Tool by setting break points.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers (DDL & DML), User Defined Data types and Functions (UDF).
• Expertise in Troubleshooting Locking, Blocking, Deadlocking and performance issues with very good understanding in SDLC (Software Development Life Cycle).
• Work with App Teams on creating a productive Development, Test and Production environment for App Databases.
• Make recommendations for File group Creation and Placement, Right Data types for the Structures created.
• Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.

Environment: SQL Server 2005/2008, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, SSRS, SSIS, XML.

Confidential, Riverside, CA

SQL /SSIS/SSRS/SSAS developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.

Confidential

Sql server/msbi developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Involved in the entire System study, analysis and Design.
• 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.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.
• 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.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: MS SQL Server 2000, T-SQL, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

Confidential

Sql server/msbi developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer)
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Created and administered multiple development, training and production databases
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks
• Programmed complex data structures in C and CPP.

Environment: MS SQL Server 2000, T-SQL, DTS, Oracle 8i/9i, TOAD, Windows XP,2000, Micro strategy 7.x, Microsoft Visual Source Safe 6.0, MS Visio 2000, MS Projects 2000.