SUMMARY

• 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementationof Client - Server Applications & Database systems using SQL Server 2000/20 R2/2012.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS 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)
• 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
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) 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.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets and Power Pivot .
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generateddrill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACTand Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Defined group level security standards for Tableau.
• Used Tableau to visually analyze data and create consise and actionable dashboards
• Generated reports from Analysis Services cube by using ProClarity tool.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server 2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design ToolsandData Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques,Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler,Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot,ProClarity, Microsoft Office, Excel Power Pivot.Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, PA

MS SQL/BI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• 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.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Deploying the Packages and Reports on to the server.
• Created different Power Pivot reports as per the client requirement.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

Confidential, Morrisville, NC

MS SQL Server Developer

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• 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.
• 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.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, 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.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server 2008R2\2012, SQL Server Reporting Services (SSRS),VS2008/2012, MS Access, MS Excel, SSIS, BCP, T-SQL,TFS.

Confidential, Columbia, MD

MS SQL/BI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• 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.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save spaceacross different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSASand designing DW schemas.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Windows2003 Advanced Server, ODBC, MS SQL Server 2005/2008/2012, TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential, Oklahoma City, OK

MS SQL Server Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases..
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• 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.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save spaceacross different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSASand designing DW schemas.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition,ODBC, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• 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 SQLServer 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 SQLServerdatabases using SQLServerIntegration 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 SQLServer 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 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding IndexesandTables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.