SUMMARY

• Around 7+ years of IT experience in the Analysis, Administrating, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
• Microsoft Certified Technology Specialist in Business Intelligence and SQL Server 2008 R2.
• Working Experience on SQL 2000/2005/2008/ R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• SQL Server 2005/2008/2012 RDBMS database development including Confidential - SQL programming.
• Worked on reporting services, power view, PowerPivot and power view with SharePoint integration.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Developing reports on SSAS & SSRS on SQL Server (2005/2008/2008 R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Working Experience in creating SSIS packages using Active X scripts with Error Handling.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.
• Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Experience in creating Gauge Reports with Report Model and Report Builder 1.0, 2.0.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• 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.
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012 and excellent communication and analytical skills, understands business requirements in various domains.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, PowerPivot, power view. SharePoint.

Databases: SQL Server 2000/2005/2008/ 2008 R2/2012, MS Access, Oracle

Programming Languages: SQL, Confidential -SQL,PL/SQL,VB

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux.

Scripting: HTML, XML,VBScript, JavaScript,ASP,C#,ASP.NET,VB.NET

Tools: Erwin, Visual Studio 2008/2005 and Report Builder 1.0/2.0/ 3.0

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. SQL Server Developer

Responsibilities:

• Actively involved ingathering and analyzingtheuser requirementsin coordination with Business.
• Performed thescope analysisof the user requirements.
• Migrated around DTS packages to SSIS 2008 version.
• Transferred data from various data sources/business systems includingDB2 (AS400), MS Excel, MS Access, Flat Filesetc. to SQL Server using SSIS/ETL using various data transformations components like data conversion, look up transformations etc. Created derived columns from the present columns for the given requirements.
• Created several batch processes which loads data from DB2 (AS400), MS Excel, MS Access, Flat Filesetc. to SQL Server on daily basis based on the business requirement.
• Worked with huge tables present in DB2 AS400 database, the table with maximum number of rows we worked with is 900 Million records.
• Created ComplexETL Packagesusing SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created a Reporting Services report that is based on a PowerPivotworkbook that has been published to SharePoint.Reporting Services offers rich data visualization through charts and maps, additional rendering formats such as PDF or Word, and comprehensive subscription and delivery options. Using Reporting Services to visualize, render, or distribute PowerPivot data gives you powerful alternatives for making business intelligence data available to other people in your organization.
• Created logging for ETL load Confidential package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Organized the ETL Packages and SQL Scripts in TFS 2008 (Team Foundation Server) to make all the objects centralized
• Used SQL Server configurations for all the ETL’s using environmental variable.
• Extensively usedT-SQLin constructing userfunctions, views, indexes,user profiles, relational database models, data dictionaries, and data 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.
• Wrote Store Procedures, Functions, Views etc.,
• Developed, monitored and deployedSSIS packages.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.
• Performance improvement discussions every week to reduce the process timing of each milestone deliveries and implemented successfully several times

Environment: SQL Server 2000/05/2008 R2/2012, Confidential -SQL, SSIS/SSRS, TFS 2008,XML Files, XSD, Oracle 11g, HP Quality Center 10, Toad, Visual Studios 2008/2010, AS400 DB2, Active X Script, VBScript,C#,VB.NET, .Net, ADO.Net, ASP. Net, MS-Excel, Visio 2007, Windows 2010/2008/2003.

Confidential, Addison, TX

Sr. SQL Server Developer

Responsibilities:

• Actively involved ingathering and analyzingtheuser requirementsin coordination with Business.
• Performed thescope analysisof the user requirements.
• Migrated around 50 DTS packages to SSIS 2008 version.
• Transferred data from various data sources/business systems includingDB2 (AS400), MS Excel, MS Access, Flat Filesetc. to SQL Server using SSIS/ETL using various data transformations components like data conversion, look up transformations etc. Created derived columns from the present columns for the given requirements.
• Created several batch processes which loads data from DB2 (AS400), MS Excel, MS Access, Flat Filesetc. to SQL Server on daily basis based on the business requirement.
• Worked with huge tables present in DB2 AS400 database, the table with maximum number of rows we worked with is 900 Million records.
• Created ComplexETL Packagesusing SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created a Reporting Services report that is based on a PowerPivotworkbook that has been published to SharePoint.Reporting Services offers rich data visualization through charts and maps, additional rendering formats such as PDF or Word, and comprehensive subscription and delivery options. Using Reporting Services to visualize, render, or distribute PowerPivot data gives you powerful alternatives for making business intelligence data available to other people in your organization.
• Created logging for ETL load Confidential package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Organized the ETL Packages and SQL Scripts in TFS 2008 (Team Foundation Server) to make all the objects centralized
• Used SQL Server configurations for all the ETL’s using environmental variable.
• Extensively usedT-SQLin constructing userfunctions, views, indexes,user profiles, relational database models, data dictionaries, and data 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..
• Developed, monitored and deployedSSIS packages.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.
• Performance improvement discussions every week to reduce the process timing of each milestone deliveries and implemented successfully several times

Environment: SQL Server 2000/2008, Confidential -SQL, SSIS/SSRS, TFS 2008, Visual Studios 2008/2010, AS400 DB2, Active X Script, VBScript, .Net, ADO.Net, ASP. Net, MS-Excel, XML, Visio 2007, Windows 2008 R2/2003.

Confidential, Seattle, WA

SQL Dev

Responsibilities:

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Involved in migration of SQL Server /2012.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Developed MDX Queries against SSAS cubes to generate reports.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI’s in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Designed, developed, tested, deployed, supported, maintained and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server 2007 and SQL Server Analytical Services.
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008/2012 and SQL code.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Automated and enhanced daily administrative tasks including space management, database backup and recovery. Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Installed and Configured SQL sever 2008 R2/2012

Environment: SQL Server 2005/2008 R2/2012, Confidential -SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio

Confidential, Dallas, TX

MS SQL Server Dev

Responsibilities:

• Participated in creating reports that deliver data based on stored procedures.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Experience in creating SSIS packages using dashboard.
• Involved in writing classes for business logic layer using C#.
• Back end Experience in MS SQL Server development, writing Confidential -SQL stored procedures, coding, triggers and cursors.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Developed several Web controls -- composite and standard web controls -- using VB.NET and C#.
• ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
• Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Iteration planning for new features and user stories in Agile Development methodology.
• Configured and maintained huge OLTP databases.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
• Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using Confidential -SQL.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.
• Installed and configured SQL Server 2008/2008R2

Environment: SQL Server 2008, SSIS, SSAS, SSRS,, MDX, OLAP, XML, MS PowerPoint, MS SharePoint, MS Project, MS Access 2007/2003 & UNIX, .NET, C#, Agile Programming, Shell Scripting, Oracle, Crystal Reports.

Confidential, Medford, MA

SQL Dev

Responsibilities:

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Subreports using Sql Server Reporting Services 2008.
• Created SQL Server Analysis Project using MS SSAS 2008.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created complex SSAS cubes with multiple fact measures groups.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterizedand cascading reports using SSRS 2008.
• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Created Analytical reports by PROCLARITY tool.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle

Confidential, NEWYORK, NY

SQL Dev

Responsibilities:

• Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.
• Migrated SQL Server 2000 DTS packages to SSIS 2005.
• Developed SSIS 2005 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
• Developed, deployed and monitored SSIS Packages.
• Developed custom reports and deployed them on server using SSRS.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions and Functions for the reports.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.
• Published dashboards on an intranet site using SharePoint Server.
• Configured Report Model for developing ad-hoc reports by the end-users.
• Uploaded reports on to the report manager and organized them into folders.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Assisted in the application development, debugging, configuration, and optimization from database perspective.
• Involved in implementation of replications like Snapshot and Transactional.

Environment: - MS SQL Server 2005, Windows Server 2008,.MDX, DTS, SSIS, SSRS, PPS, SharePoint, Confidential -SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.

Confidential

SQL Dev

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions
• Created SQL scripts for tuning and scheduling
• Performed data conversions from flat files into a normalized database structure
• Created and managed users, roles and groups and handled database security
• Created Triggers to enforce data and referential integrity
• Defined Check constraints, Business Rules, Indexes, and Views
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
• Data migration (import & export - BCP) from Text to SQL Server
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Performed development support, document reviews, test plan, integration of the system
• Creation/ Maintenance of Indexes for fast and efficient reporting process
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access)

Environment: SQL Server 2005, Confidential -SQL, PL/SQL, TOAD, Forms 6i and reports 6i.