SUMMARY

• 7+ years of experience in Data modeling, database design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL Server 2014/2012/2008/2005.
• Extensive experience in Using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading
• Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
• Using Normalization and De-Normalization techniques
• Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Involved in Writing heavy stored procedures, Audit triggers views, creating SQL scripts for data loads and Upgrades for data migrations and data validations
• Proficient in Performance Tuning/Query optimization using indexes
• Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Tuning the performance of stored procedures and large T-SQL Queries using Clustered indexes, efficient coding standards
• Involved in Backing up databases and refreshing Data across environments
• Huge Data transfers from & to SQL Server Databases using utilities/ tools like DTS, SSIS, BCP, Bulk Insert
• Involved in addressing Batch process issues, Job scheduling, Code Debugging, Maintenance and Bug Fixes.
• Experienced in using Block, Unblock and Row Transformations for Performance Tuning in SSIS packages.
• Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent knowledge of using variables and expressions in packages of SSIS.
• Worked with Flat file, Excel file, and SQL server OLEDB destinations for loading data.
• Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008/2000/2005.
• Expert in designing reports using SQL Server Reporting Services (SSRS2000/2005), operating and troubleshooting with data sources.
• Involved in Installation, Configuration, Development, Deployment and Troubleshooting Reporting services using SSRS across various environments.
• Expert in developing and deploying cascading parameterized, Drilldown, Adhoc reports with linking sub reports in various file formats with respect to client requirement.
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• End to end experience in designing and deploying data visualizations using Tableau
• Experience in writing Queries using SQL Server Analysis Services (SSAS).
• Created and Configured Data Source &Data Source Views, Dimensions, Cubes, Measures, Partitions.
• Experience in creating various database objects in C#, Visual Studio and ASP.net and deploying them to the SQL Server 2005/2008.
• Experience in developing applications using C#.NET 2.0/3.0/4.0, VB.NET, ASP.NET 2.0/3.0/4.0 and .NET Framework 2.0/3.0/3.5/4.0/4.5.
• Vital Knowledge in OLAP Storage modes likes Rolap/ Molap/ Holap.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• A well-organized, goal-oriented, highly motivated and effective team player with excellent analytical, troubleshooting, and problem solving Skills.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2014, 2012, 2008, 2005, 2000 &7.0 MS ACCESS 2000, 2003, 2007.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development, Studio, Visual Studio, Configuration Manager, SQL Server Profiler SQL Query Analyzer, SQL Refractor, SQL Server Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP

BI Tools: SSRS, SSAS, Crystal Reports, BIRT, Plateau Report Designer.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Management Tools: SharePoint, Team Foundation Suite (TFS), Microsoft Office Communicator.

Languages: T-SQL, PL/SQL, MS SQL, MDX, C/C++, Java, VB, VBA, HTML, XML.

Web Technologies: HTML, DHTML, XML.

Architecture: Relational DBMS, Client-Server Architecture, OLAP, ROLAP, MOLAP and OLTP

O/S: Windows 2008/2003/2000/ NT Servers, XP, Vista, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SSIS, SSRS and MS SQL Developer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Understanding the report design Requirements and Constraints.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Deployed the created SSIS packages in Development and Testing environments.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Created Adhoc reports and data exploration using Power View.
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
• Scheduled Backups and performed Restore operations for system test data.

Environment: MS SQL Server Management Studio 2012/2014, Query Analyzer, SQL ProfilerIndex Tuning Wizard, Microsoft Visual source Safe, MS SQL Server Integration Services (SSIS)MS SQL Server Reporting Services (SSRS), MS Office 2007.

Confidential, Reynoldsburg, OH

SQL BI Developer

Responsibilities:

• Extensively involved in the full lifecycle of ETL software development - analysis, design, build documentation and testing for the project using SQL Server Integration services.
• Created packages using SSIS for data extraction from Flat files, OLEDB to SQL server using ETL tool.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Moved the static data from various text files to SQL Server2012 DB using Import Export Wizard.
• Developed SSIS packages not only for initial data loads but also for incremental/delta loads.
• Created log tables to capture the SSIS events and used it to perform debugging of the packages.
• Generated the data validation report in SQL server reporting services (SSRS).
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Ad-hoc reports, Cascading reports, Drill down reports.
• Created user groups in Report Manager for limited access to the users in SSRS.
• Involved in unit testing of SSIS packages, query verifications in SSRS.
• Designed and maintained Tableau reports used to graphically analyze business data.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Supported multi environment Tableau infrastructure including server security troubleshooting and general system maintenance.
• Worked with Tableau dashboards deployed on web server.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Maintaining the documents and packages in Team Foundation Server as a version control.

Environment: MS SQL Server 2012/2014, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Dynamics, SharePoint, Team Foundation Server, MS Excel, MS Visio, Windows 7, C#, VBScript, X++.

Confidential, Richmond, VA

MS SQL BI Developer

Responsibilities:

• Involved in the Data modeling, physical and logical design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Designed stored procedures and triggers for automating tasks.
• Defined check constraints, Business rules, Indexes, and Views.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Tuned and Optimized SQL Queries using execution plan and profiler
• Helped in integration of the front end with the SQL Server backend.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS/ETL)
• Created DTS/ETL package to schedule the jobs for batch processing.
• Used SQL Profiler and query analyzer to optimize DTS/ETL package queries and stored procedures
• Configured Server for sending automatic mails to the respective people when a DTS/ETL process failure or success.
• Performed development support, document reviews, test plan, integration of the system

Environment: MS SQL Server 2012, SSRS, SSIS, SharePoint Server 2007, OLAP, Erwin 7.0, DTS/ETL/SSIS, BIDS.

Confidential, Stamford, Connecticut

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views and Queries with best execution plan
• Used C#.Net, Ado.Net and ASP.Net for writing code to make availability of packages in server at scheduled times.
• Used multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes Using MDX and ADX.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
• Created projects to transfer data from MS Excel to SQL Server in SSIS.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Worked on data cleansing techniques using look ups, conditional split, and fuzzy lookup.
• Handling the errors during data moving and sequencing the task as per requirements.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008R2.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.
• Expertise in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services for analyzing purpose.
• Running DBCC consistency checks, and fixing data corruption in application databases.

Environment: MS SQL Server 2008 R2, Windows 2003, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008, .Net Framework 3.5, C#, ASP.Net, VBScript, MOSS 2010, Erwin, MS Visual Source Safe, MS-Visual Studio.

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

• Managed the migration of SQL Server 2005 databases to SQL Server 2008
• Created Tables, Stored procedures and defined functions; created SQL scripts for tuning and scheduling
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational, drill-through and drill-down reports using SSRS
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases
• Involved in the Data modeling, Physical Design of Database using tools like Erwin
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases
• Performing Replication (snapshot and transactional)
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Created calculated measures and dimension members using multi-dimensional expression (MDX)
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date

Environment: SQL Server 2005/2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 10g/9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access

Confidential 

MS SQL Server Developer

Responsibilities:

• Created ER diagrams either Logical/Physical using Erwin.
• Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.
• Created user based databases and installed MS SQL Server 2005/2008.
• Worked in Project planning, Designing & Implementation.
• Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.
• Wrote the stored procedures, checking the code for efficiency with routine backups and restoration. Data transfers between various servers using BCP.
• Defined and created indexes for query optimization and revising scripts for optimal performance.
• Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Tested the stored procedures performance and its path of execution by using SQL profiler.
• Recovered the backups of SQL Server production databases in test server environment.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML.