SUMMARY

• Over Eight years of IT Experience in Database Design, Development and Support of Microsoft SQL Server 2014, 2012, 2008R2/2005 in Development, Test and Production Environments with various business domains like IT Solutions, Financial, Manufacturing, and Education.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2014, 2012, 2008R2/2005.
• Experience in using Data Modeling Tools like Erwin, Microsoft Visio.
• Expertise on Normalizing and De - normalizing the tables and maintaining referential integrity
• 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.
• Strong in Power Shell scripting and automating day to day maintenance tasks using Power Shell scripts, converting existing TSQL batch scripts to Power Shell scripts and improving SQL Server maintenance jobs performance.
• Expertise on SQL Server Administration tasks in improving the performance of SQL Server.
• Worked on SSIS Packages enhancing and designing with error handing.
• Writing stored procedures and ad-hoc querying for generating reports using SQL Server Reporting Services (SSRS). And experience in administrating the created reports and assigning permission to the valid users.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Design, develop, and supportSpotfireVisualizations with complex data sources across multiple applications and platforms (SQL, Oracle, Access, Excel, Text, HTML, etc.)
• Excellent knowledge in creating Databases objects, stored procedure, DDL/DML triggers, views, user defined data types, cursors and indexes using T-SQL.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in creating and updating Indexes and Statistics to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Knowledge of Software Development Life Cycle (SDLC).
• Experience in working ITIL environment organization and virtual and global teams of organization.
• Efficient in interacting with business requirement teams and refining the requirements for clarity and simplicity.
• Self-starter with strong inter personal and excellent communication skills and ability to work individually as well as in collaborative team environment.

TECHNICAL SKILLS

Languages: T-SQL

RDBMS: MS SQL Server 2014, 2012, 2008R2, 2005.

Reporting Tool: BI SQL Server Reporting services, Micro strategy SQL Server BI suite

Data Modeling Tool: ERWIN, MS Visio

Operating System: Windows 2000/2003/2008 R2 Server

Version Control Tool: Visual Source Safe, TFS

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL BI Developer

Responsibilities:

• Designing the Interface Database objects based on the Reporting Warehouse (RWH) Interface schema definitions and requirements.
• Using Data mapping we utilized ASAP methodology of project preparation to identify business objectives to integrate companies, blueprint of the company requirements, realization of the configuration, final preparation of testing, cutover, reporting, training and, go live and support, analyzing the gap, writing functional specifications, configuration and testing.
• Utilize complexSpotfirefeatures to build complex corporate dashboards and visualizations with multiple graphs and charts.
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.
• Developed reports usingSpotfireProfessional and published the same toSpotfireServer for Business Users use.
• Building automated report solutions for easy access to the developing Interface Schemas and changes.
• Working with source owners in extracting the data for ETL solutions of Interface Data. And worked with both source and RWH parties in mapping exercises.
• Designing Interface Domain Models to support accurate interface data transfer between two different CRM Applications.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Highly proficient using PowerShell script language
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Used different data flow elements like FlatFile, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Worked on the analytical solutions and creating/deploying the reports on SharePoint sites.
• Working as the support expert for the Reporting Transformation project Interface issues.
• Creating the automated documentation solution for ETL solutions and preparing documentation of end to end process in business and technical perspectives as per organization norms.
• Creating ETL packages with standard framework for easy transition between environments, and built the center point monitoring reports for all integration operations.
• Worked on web services tasks for data transfer to the centrally located RWH and to receive the reverse interface data from RWH.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2008R2 to SSIS 2012 packages.
• Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of mission-critical operational systems, benchmark establishment, and capacity planning.
• Worked on Dimensional Data Modelling using Star and snowflake schemas for Fact and Dimension tables
• Designed, created, tested, and support over 60+ Enterprise Reports utilizing all aspects of Reporting Services (SSRS) functionality: Calculated fields, Formulas, Parameters, Sub-Reports, Conditional Formatting, and external web service calls
• Created reports that included formatting options such as Grouping, Sorting, Parameter prompts.
• Generated various reports with drilldowns, drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server using Excel.
• Modified report content and exported reports in multiple formats based on user input.
• Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager

Environment: Microsoft Windows 2003 Advanced Server, Spotfire web player, Microsoft SQL Server 2014, 2012 and 2008, Oracle, Visio, Micro Strategy.

Confidential, Bellevue, WA

ETL and SSAS Developer

Responsibilities:

• Involved from the start of Project’s Active development phase.
• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Extensively used the MS office Excel application as the report final format files.
• Responsible for automation of the each report we made in the project
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Designed and Develop new SSAS Tabular Models which uses xVelocity (formerly Veritpaq) in-memory engine.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Extensive use of DAX.
• Wrote Technical specification for the related work for each SSAS Tabular models.
• Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors. worked with multivalve parameters for parameterized reports in SSRS.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Managing the reports posted onto SharePoint and archiving from time to time.
• Made the Scorecard Reports using MS Access, MS SQL Server, Teradata and Oracle databases.
• Used the SharePoint Document List’s data as the source of the report, along with the other databases.
• Worked on code reviews and the documentation preparation for each report and the major task involved.
• Converted the MS Access based reports to the Teradata SQL.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Tabular model by retrieving data and aggregates directly from a relational database system, usingDirect Query mode.
• Used IBM Datastage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created the semi-permanent tables in the Teradata databases and scheduled the task as the data changes.
• Making ready the required database objects and helping the application programming development team
• Working on the transition of the work and maintained the development standards as per specifications.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2012 and 2008, Microsoft Visual Basic 6.0, TERADATA 12.0

Confidential, Phoenix, AZ

SQL Server SSRS/SSIS Developer

Responsibilities:

• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from SQL Server 2012/2014, MS Excel and Flat files.
• Involved in migration from SQL Server and 2014.
• Used various transforms in SSIS to load data from flat files to the SQL databases.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Created several reports to support price analyzations by using power pivot.
• Used different techniques to obtain margins and discount of sales reports.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Bring data (from different sources) and connect by using Power Pivot.
• Used Visual Team Foundation server for version control, source control and reporting.
• Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS).
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services.
• Defined Key Performance Indicator metrics to create scorecards.
• Creates and maintains data dictionaries forPowerPivot models.
• Strategic reporting - leverages Excel, SQL/ PowerPivot and other BI tools for daily views of corporate, regional and divisional metrics.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Hands on experience PowerPivot interactive through form controls.
• Participated in Databases Architecture and data modeling design.
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS).

Environment: SQL Server 2008R2 & 2012/2014 Enterprise Edition, Microsoft Visual Studio 2008/2010, MDX, T-SQL, MS Access, MS Excel, Windows 2008 Server, OLAP, Visual basic .NET.

Confidential, Buffalo Grove, IL

SSAS Developer

Responsibilities:

• Designed and developed SQL Server Reporting Services (SSRS) SQL Server 2005/2008.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SSRS.
• Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Subreports, Adhoc reports (SSRS).
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.
• Configure the report server and generated the report models for user interactions.
• Involved in Partition of cubes in order to increase the performance of cubes.
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
• Used windows Power Shell Script to automate application deployment process.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database development.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used Informatica to Extract and load the Data as per the requirement.
• Interacting with Business users and BA’s to gather requirements for creating ETL Packages and Reports.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Creating SSIS Packages using different type’s task and with Error Handling.
• Performed ETL operations mapping different fields of source and target
• Experience in creating complex SSIS Packages with error handling using control and dataflow elements.
• Fine-tuned the complex database stored procedures to increase performance.
• Performance tuning and optimization of procedures and queries.
• Experience with Batch processing to load production databases from data entered over internet
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
• Created SQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Created Analytical reports by ProClarity tool.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards 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).
• Involved in Unit testing process.

Environment: MS SQL Server 2005/2008, Tableau 9.0, Management Studio(SSMS), ETL, DTS, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, Share point (2003/2007), T-SQL, SQL Profiler, IIS 6.0, DB2, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008,, community server, Erwin

Confidential

MSBI Developer

Responsibilities:

• Work with various business units to understand reporting requirements to provide practical and cost effective solutions.
• Develop, maintain, implement and support all SSIS development & production efforts.
• ETL development for data warehouse data marts daily refresh and real time reporting, utilizing both SSIS and DTS packages using SQL Server 2005 and 2008.
• Developed and created database objects like stored procedures, advanced queries, triggers, views, indexes and functions for databases.
• Create stored procedures to create dynamic SQL Queries to adopt dynamic environment.
• Created the packages based on mapping document using SQL Server Integration Services (SSIS).
• Using SSIS 2005, building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages.
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Deploying and scheduling SSIS packages and jobs using SQL Server Agent.
• Create jobs, Alert and schedule DTS/SSIS Packages and SSRS to generate reports.
• Working with reporting team in Designing, Developing and Deploying Reports in SSRS.
• Designed and architected Report Layout including both simple and complex report using SSRS 2005.
• Studying the structure of RDBMS to develop multi dimension Objects (Cubes, Dimension) using SSAS.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Practical involvement in creating dimensions using STAR and SNOWFLAKE schema.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using T-SQL, SQL Profiler in SQL Server 2005.
• Monitored performance and Optimized SQL Queries for maximum efficiency.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Perform DBCC checks to ensure the physical consistency of the database and objects.

Environment: Windows server 2007, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential

SQL DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: SQL Server 2000/2005/2008 with Clustering, MS Access, VMware ESX, Windows 2000/2003, Lite speed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.