SUMMARY

• Around 8 years of IT Experience in System Design, Development and Support of Microsoft SQL Server2012/2008 R 2/2008/2005/2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Experience in Data Schema Design, and Table Design.
• Experience with T - SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience in Using multiple join statements to retrieve data from multiple tables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
• Worked in SDLC(Systems Development Life Cycle) for developing systems/Software
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.
• Experience in MS Business Intelligence tools like SQL Server Integration Services, Analysis Services and Reporting Services.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005/2008/2012 via SQL Server Integrated Services.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Created ETL packages usingSSISto move data from various heterogeneous data sources.
• Created logs forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Implemented error handling and roll back process inETLload.
• ConfiguredSSISpackages usingPackageconfigurationwizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
• Worked with Financial companies for application related pricing and security applications
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema
• Experience in multidimensional databases with demonstrated ability to create calculated members and MDX scripting
• Proficient in buildingCubes,definingd Relationshipsand creating Hierarchies in SSAS
• Expertise in creatingCell Level Securityin cubes usingSSAS.
• Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using ‘pulled’ and ‘pushed’ methodologies.
• Developed Reports using efficient data retrieval techniques
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Built and wrote MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS

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

Operating Systems: Windows NT/98/2000/XP/Vista/2003, MS-DOS

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), MDX, Business Objects 6.x, crystal reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C, SQL, PL/SQL, T-SQL, C#, Asp.NET.

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server2000 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSS

PROFESSIONAL EXPERIENCE

Confidential, Brentwood TN

Sr. SQL BI Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2008 R2.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created SSIS packages to populate data from various data sources like oracle using PL/SQL queries.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Created SSIS packages and populated data into GUIDEWIRE Claim central.
• Experience in data loading from Excel to MS SQL Server using BCP and SSIS Services.
• Experience in Error handling on GUIDEWIRE Claim Central.
• Involved in data moving from SQL Server to GUIDEWIRE Claim Central using GUIDEWIRE Claim Central Commands.
• Experience in fixing integrity check errors on data loads from SQL server to GUIDEWIRE Claim Central.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 and SQL Server 2012.
• Experience in converting RTF data into text on SSIS Script task using asp.net.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Creates custom SQL Server Reporting Services (SSRS) Reports to be displayed in a Microsoft SharePoint 2010 web application.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Coding, debugging and testing of GUIDEWIRE Claim center.

Environment: MS SQL Server 2005/2008 R2/2012, Management Studio, SharePoint, ETL, Squish Notification Services, T-SQL, SQL Profiler, SSIS, SSRS, GUIDEWIRE application, community server.

Confidential, Atlanta, GA

Sr. BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Create joins and sub-queries for complex queries involving multiple tables.
• Generated dynamic stored procedures, triggers for the database development.
• Involved in installation and configuration of SQL Server 2005, SQL Server 2008 and SQL Server 2012 with latest Service Packs.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008 R2/2012.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Created SQL server Reports using SSRS.
• Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008/2012.
• Report writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS).
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008/2012.
• Using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Configure the report server and generated the report models for user interactions.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports according to the business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• 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.
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008.

Environment: MS SQL Server 2005/2008 R2/2012, Management Studio, SharePoint, ETL, DTS, Notification Services, Crystal Reports, Data Modeling, OLAP, Data ware Housing, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS, community server.

Confidential, NYC, NY

SQL BI Developer (SSRS/SSAS)

Responsibilities:

• Created SQL Server Integration Services (SSIS) packages to import data from heterogeneous data sources like Oracle 9i, SQL Server Text files (CSV, Xls, and XML).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Involved in design and development of ETL Jobs using SQL Server Integration Services (SSIS) for data migration between different maintenance systems (VMS, VTrak, and D7i).
• Worked on scheduling data loading and transformations using SQL Server Integration Services (SSIS) between different maintenance systems.
• Created many drill through and drill down reports using SSRS.
• Generated custom and parameterized reports using SSRS.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Deployed these reports into the SharePoint after developing the reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Scheduling the SSIS packages and Jobs
• Developed perspectives to simplify the process of browsing the cubes.
• Used Lookups Transformation to get the data from data sets
• Created SSIS Packages to migrate slowly changing dimensions

Environment: SQL Server 2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008, Oracle 9i, Ms excel 2003, Microsoft Visual Studio 2008.

Confidential, San Francisco, CA

SQL BI Developer (SSRS/SSIS)

Responsibilities:

• Analyzed the requirements and selected the appropriate fact tables/created fact tables
• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
• Created the storage type (ROLAP), Created cubes for Business Intelligence.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005to SQL Server 2008.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Experience in designing and managing SSAS projects.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Experience in building and maintaining Data marts. Created roles for using the cubes
• Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages
• Transferring data between XML document and SQL server
• Performed activities such as database creation, database tuning, performance planning, backup planning and database administration
• Actively involved in Normalization & De-normalization of database
• Materialized views, dimensions and stored outlines for optimal performance
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, ERwin, XML, VB.NET, MS PowerPoint, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential, Chicago, IL

SQL Server Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Installed and Configured SQL Server 2005/2008.
• Logical and Physical design of SQL Server databases
• Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
• Performance Monitor to track the size of your SQL Server database transaction logs and set up alerts to notify the server before the transaction log fills, thus averting problems that might otherwise seriously affect users and applications.
• Created Stored Procedures, Triggers, Functions, client specific Views for the Application. Extensive testing on the Performance of the Stored Procedures.
• Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.
• Imported and exported data to and from various heterogeneous sources using various techniques like BCP, DTS.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases.
• Administered database users/profiles and security (Managing Security).
• Wrote scripts to monitor backup and restore activities.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
• Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
• Generated reports with dynamic grouping and dynamic sorting as well as running values.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc. for better performance during package execution.
• Scheduled SSIS Packages for loading Facts and Dimensions.

Environment: T-SQL, SQL Server 2000/2005, OLAP Services, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler, Informatica.

Confidential

SQL Server Developer

Responsibilities:

• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.
• Maintained a good client relationship by communicating daily status and weekly status of the project.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various Used Data departments
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Develop code that matches the prototype and specification, is maintain and, as necessary, portable to other environments.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Logical Data Modeling using ER-Win to fit business requirement.

Environment: SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL.