SUMMARY:

• Around 7 years of IT experience in the Analysis, 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 T - SQL programming.
• SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• 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 on slowly changing dimensions and 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 KPI’s, Report Model and Report Builder 1.0, 2.0.
• Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL 2008/2012 Architecture.
• Developed MDX Queries against SSAS cubes to generate reports.
• 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.

SQL Server Tools:

SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools:

SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Informatica 7.1.3/6.2

Databases:

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

Programming Languages:

SQL,T-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

Client: Confidential, Chicago, IL

SQL BI Consultant.

Responsibilities:

• Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
• Involved in migration of SQL Server 2005 to 2008/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.

Environment: SQL Server 2005/2008 R2/2012, T-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

MS SQL Server Developer/SSAS/SSRS.

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 T-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 T-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.

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.

Client: Confidential,Medford, MA

SQL BI Developer

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

Client: Confidential,NEWYORK, NY

SQL BI Developer

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 ExcelintoSQL 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, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008.

Client: Confidential

SQL Programmer

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, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.

Client: Confidential

SQL Developer

Responsibilities:

• Participated in the installation of SQL Server.Installed SQL Server Enterprise manger tools using SQL Server Setup Program and Interacted with Development Teams, Managers to analyze business needs and developed technicalServers.
• Migrated access objects to SQL Server 2000.
• Created tables, indexes and constraints.
• Created Stored Procedures, Indexes, Views, Triggers, Stored Procedures in T-SQL and DTS Packages.
• Wrote database triggers in T-SQL to check the referential integrity of the databases.
• Defined stored procedures for module integrity and application.
• Used Database Engine Tuning advisor andSQL Profilerfor Monitoring memory, processor, Disk I/O and SQL Queries.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan and scheduled Jobs weekly, monthly.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal reports.
• Preparation of project documentation.

Environment: SQL server 2000/2005, Visual Basic 5.0, Win NT, Crystal Reports 8.0