SUMMARY

• 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.
• Extensive Experience on SQL 2000/2005/2008/ R2/2012 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in SQL Server 2005/2008/2008 R2 RDBMS database development including T - SQL programming.
• Expert in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Expert in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Very Good Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Expert in Developing reports on SSAS & SSRS on SQL Server ( 2005/2008/2008 R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture using BIDS
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• Experienced in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Experienced on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 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 Architecture.
• Developed MDX Queries against SSAS cubes to generate reports using BIDS
• 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.
• Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R2/2005/2000 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, 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, ADOMD.NET

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

PROFESSIONAL EXPERIENCE

Client: Confidential,FL

SQL Reporting Analyst/SSIS.

Confidential,is one of the top most E-commerce company which is a leading online retailer of officially licensed sports merchandise and provides the ultimate shopping experience to sports fans. Comprising the broadest online assortment, Fanatics offers hundreds of thousands of officially licensed items via its Fanatics and FansEdge brands. In addition, the Company powers the e-commerce sites of all major professional sports leagues (NFL, MLB, NBA, NHL, NASCAR, PGA), major media brands (ESPN, NBC Sports Network, CBS Sports,FOX Sports and over 100 collegiate and professional team properties.

Responsibilities:

• Involved in reviewing the E-commerce application and interacted with business users to understand the report requirements for creating documents like data dictionary and technical specs.
• Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
• Involved in upgrading the databases and servers of SQL Server 2008R2 to SQL Server 2012.
• Created reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services and SharePoint.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Involved in migration of several reports of SQL Server 2005 to SQL 2008.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2008 and then created reports using this data using SSRS 2008
• Configured and maintained Report Manager and Report Server for SSRS
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Developed an automated report subscription process using SSRS 2008.
• Developed user requested reports using Crystal Reports and Excel
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created report links to refer other reports in a particular report. And also created report links for different servers.
• Created report snapshots to improve the performance of SSRS.
• Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
• Worked with SharePoint 2010 to publish documents and share reports for various Users.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005 and SQL 2008
• Developed complex reports against SSAS Cubes and MDX Queries.
• Using SSIS, built high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
• 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 and SQL code.

Environment: SQL Server 2008, 2008R2 and 2012, T-SQL, SQL Profiler, Report Builder, SSRS, SSIS, Visual Studio 2005/2008, XML, Crystal Reports, Excel.

Client: Confidential,NJ

SQL BI Consultant.

Confidential,is a Property and Casualty insurance division of Chartis Inc (AIG) offering Management Liability, Professional Liability, Environmental, Accident & Health, Construction and Excess Casualty for Small Businesses. The project that I was involved in is to develop, implement and maintain a new Web Based Underwriting Platform. This platform currently handles Defense Shield (Covers EPL defense costs), Not For Profit Protector (Product includes coverage’s such as D&O, EPLI, Fiduciary, CRIME, Employed Lawyers and Kidnap & Ransom Extortion for Non-Profit Companies) and Private Edge Plus (Coverage’s for Private companies).

Responsibilities:

• Involved in reviewing the insurance application and interacting with business users to understand the user requirements.
• Involved in migration of SQL Server 2005 to 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Managed AMO (Analysis Management objects) using BIDS.
• 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 using Business Intelligence development studio.
• 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 and SQL code.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Worked with SharePoint to publish and share reports for various clients.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

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

MS SQL Server Developer/SSAS/SSRS/SSIS.

Confidential,is the nation\'s largest non-profit, private-sector scholarship and educational support organization.Scholarship America is working with around 1400 different corporate and other individual clients willing to donate for the noble cause of education and charity. Scholarship America has distributed more than $2.7 billion to 1.8 million students across the country through various programs including Dollars for Scholars, Dream keepers and Scholarship Management services.

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 using Business intelligence development studio.
• 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.

Confidential,Atlanta, GA

SQL BI Developer

Confidential,offers one of the most-complete e-mail marketing applications. Combined with its very usable interface, it represents an excellent value for marketers, particularly those seeking self-service solutions. Professional Servicesgroup provideshighest quality strategic and integration/development services enabling Silverpop customers to most effectively use applications to their fullest potential

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 using Business intelligence development studio.
• 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,Atlanta, GA

SQL BI Developer

Confidential,is one of the nation\'s largest and strongest financial holding companies. The company provides deposit, credit, trust and investment services to a broad range of retail, business and institutional clients. Worked as a part of a team to develop, implement and maintain databases including stored procedures, triggers and complex queries which includes assisting in administration of various bank databases in both development and production environment.

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

Client: Confidential,Hyderabad

SQL Programmer

Project Description: Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions and for managing banks property and equipment.

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions
• Created SQL scripts for tuning and scheduling.
• Involved in Migration of databases of SQL Server 2000 to SQL Server 2005.
• 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 2000 and 2005, T-SQL, PL/SQL.