SQL SERVER BI DEVELOPER

• 7 Years of extensive experience in SQL Server Development including writing T - SQL Programming, Physical and logical Database Design, SQL server 2008 suite of products SSIS, SSRS.
• Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008 R2.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes
• Experience in Normalization & De-normalization of database, Performance Tuning and Query Optimization.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, Correlated sub queries, Cursors and Triggers.
• Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), WritingTransact SQL (T-SQL) Queries, & Dynamic-queries.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2000/2005/2008.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart, Line graphs, sorting the data,defining subtotals in SSRS 2005/2008.
• Proficient in using global variables, expressions and functions for the reports.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• 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).
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Extensively created dashboards/scorecards against SSAS cubes using ProClarity and SSRS.
• Worked on Exception Handling with @@Error and Try/Catch Methods.
• Expert in defining calculated members, KPI's, cubes, dimensions with SSAS 2000/2005.
• Great Knowledge in Dimensional Modeling, applying Kimball's methodology, Star Schema/Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.

Education

Bachelors in Electrical and Electronics Engineering

TECHNICAL SKILLS

• Databases: SQL Server 2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MySql, data warehouse.
• Database Tools: SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Database Engine Tuning Advisor, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL, Litespeed.
• Languages: T-SQL, C,C++, VB 6.0, HYPERLINK \\t " blank" VB.NET, PL/SQL, C# 2.0, LINQ, HYPERLINK \\t " blank" ASP.NET 2.0, Java, HTML, UML, XML, XMLA, Java script, MS Sharepoint, MS windows
• Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP
• Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux
• Miscellaneous Tools: Windows Server 2008, Informatica, PowerCenter 7.x, Cognos

Professional Experience:

Confidential , St. Louis, MO July 2011- Till Date

ROLE: SQL BI DEVELOPER (SSIS/SSAS/SSRS)

Confidential, founded in 1957, is the largest rental car company in North America with more than 1 million cars and trucks and 65000+ employees.

Project: Project: As a Senior Software Engineer in the Operational Analysis Team, my main duties were to create, maintain and support reports for the IT department using SSRS, SSAS and SSIS while maintaining high level of accuracy and timeliness.

Responsibilities:

• Team involved in various databases including Service Center, Asset Center of Enterprise.
• Distributed reports to the users by uploading them to Report Web.
• Performed unit testing in DEV and UAT for migrating reports
• Created SSIS Packages to load data from Oracle to SQL Server
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created partitions of the Analysis Services cube to improve performance.
• Created report snapshots to improve the performance of SSRS.
• Created Event Handlers for the SSIS package on Error, on Post execute.
• Used named calculations and new named query cubes to calculate values at run time.
• Worked with T-SQL, DDL, DML and DCL.
• Used Performance Point server 2007 to integrateSSRS reports.
• Designed reports and tuned them for optimal performance when using multiple parameters.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle, DB2.
• Created complex SSIS packages using various transformations.
• Used Lookups Transformation to get the data from reference data sets
• Created cubes and defined the dimensions.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures

Environment : MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

Confidential, Mentor Ohio Jan 2010- June 2011

Role: SQL SEVER BI DEVELOPER (SSIS/SSRS)

Confidential It\'s a global leader in the making of adhesive labels used on packaging, mailers, and other items. Itmanufactures papers, films, and foils coated with adhesive and sold in rolls to printers.

Project: Team was handling the data related to the “Consumer Packaged Goods” sector. Different labels and packaging materials were manufactured for the consumer goods like Food, Beer and Beverages, personal care etc. The project included data migration, reporting and analysis using the SSIS, SSRS and SSAS.

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes andSSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Worked with Transactional and Snap-shot Fact-Tables.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard.
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server 2005/2008.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance
• Used MDX scripting for querying OLAP cubes.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2005/2008.
• Generated reports using the Crystal Reports and Reporting Services 2005/2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005/2008.
• Developed XML tags to structure data and improve the data migration process.
• ETL process was documented for future references.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
• Created OLAP CUBEs using SQL Server Analysis Services (SSAS).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created complex SSIS packages using various transformations.

Environment : MS SQL Server 2000/2005/2008, Windows Server 2003, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

Confidential, Rosemont IL July 2008 - Dec 2009

Sr. SQL BI Developer

Confidential provides professional banking solutions to privately held, middle-market businesses, Individuals and small businesses. It offers a wide array of commercial and personal banking products and services as well as trust, private banking and investments through our wealth management division.

Project: The team was managing the data related to “Customer Data Management”i.e all the data related to customers. Worked on different database systems in developing reports, analysis, importing the data into SQL server from external and internal sources depending on the requirement.

Responsibility:

• Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Worked with T-SQL, DDL, DML and DCL.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g,Infopath files, text files and Excel files.
• Encapsulated frequently used SQL Statements into stored procedures and coding thereby reducing the execution time.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Created partitions of the Analysis Services cube to improve performance.
• Analyzed the xml data (XMLA) and transformed to access and SQL server database.
• Involved in taking backups of SSAS database and restoring them when needed.
• Created data driven subscriptions for different users using Report Manager.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Involved in dimensional modeling to design data warehouse.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data
• Experience in reporting services based on existing xml documents.
• Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).
• Developing backup/restore and recovery procedures, performing weekly backup databases by using SQL Server 2005 and restoring these databases in different server.
• Created cubes and defined the dimensions

Environment:SQL Server 2005/2008 Enterprise, WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, Server 2004, InfoPath, Access, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, C#, ASP.Net 3.5, VB.Net.

Confidential, Chicago West IL Nov 2007-June2008

SQL Server Developer/ SSRS/SSIS

Confidential is a global biopharmaceutical company that discovers, develops and delivers life-changing therapies for Patients living with severe, life-threatening and often ultra-rare diseases. It has fully integrated scientific, medical, regulatory, manufacturing and commercial capabilities.

Project: The team was involved in developing, maintaining different ETL operations and reports generation with SSIS and SSRS for the IT department based on the data related to the sales of the pharmaceuticals

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, cursors, UDF's.
• 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.
• 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 2005/2008.
• Created SSIS Packages to migrate slowly changing dimensions.
• Did a C#, ASP.Net / VB.Net / SQL Server project converting their existing VB6 desktop application to a web application.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008.
• Worked on improving the performance of the system.
• Involved in the tuning of the existing Database Objects.

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

Confidential, India May'06 - Oct'07

Developer

Confidential aprofessionallydriven infraengineering company providing a wide range ofproducts & services to address customer requirements, primarily in the powerandtelecom infrastructuresegments.

Project: The project involved migration of data from MS Access to SQL Server 6.5 and then executing complex queries on the data.

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• 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.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.

Environment:

SQL Server 6.5, Visual Basic 5.0, Windows NT, T- SQL, EXCEL, Access