PROFESSIONAL SUMMARY:

• Over 7+ years of strong experience in the IT industry as a SQLServer and BI Developer.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced in practice of extracting, cleansing, transforming and loading data from OLTP databasesand other data sources into Data Warehouse for Analysis using SQL Server Integration Service (SSIS).
• Extensive experience in SQL Server Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Highly proficient in constructing Triggers, Tables, stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity using T- SQL.
• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Handled Tableau POC activities to Client's to produce different views of data visualizations and presenting dashboards on web and desktop platforms to help them make effective business decisions.
• Experienced in designing customized interactive dashboards in Tableau using marks, Action, filters, parameter, calculations and Relationships.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Experience in developing Data marts like Snowflake & Star schema.
• Expertise in understanding dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Involved in Advanced Analytics data analytics context by providing statistical, predictive, and deep geo-spatial analytics.
• Experience with all the data sources SQL Server, Oracle, DB2, or Teradata, Big Data as a data source for Tableau.
• Segmented and profiled customer base targeting those customers with greatest profit potential.
• Expertise in Advanced SQL, Oracle PL/SQL and Performance tuning.
• Good Knowledge in OBIEE 11g Repository development (Physical Layer, BMM Layer, and Presentation Layer), Reports, and Dashboards development.
• Expertise in technical support, troubleshooting, report design and monitoring of system usage.
• Expertise in data extraction (SQL), manipulation of raw data (ETL), data relationships, data mining, ad-hoc analysis and using databases in a business environment with large-scale, complex datasets

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000, Oracle 8i/9i/10g, MS-Access 97- 2007

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services(SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, c#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin, Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL/BI Developer

Responsibilities:

• Worked on the analysis of the Design Specification documents for the Packages and coordinated with team members at the time of changes in Business requirements and changes in Data Mart Schema.
• Designed, reviewed, and created primary objects based on logical design models, user requirements and physical constraints.
• Upgraded the data from one server to another server (SQL Server 2008 to SQL Server 2012) for the SSIS Packages and SSRS reports.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Implemented the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server 2012 for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Created triggers that capture the customer updates and made the required transformations to move the customer ps to ODS.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed daily tasks including backup and restore from disaster recovery in SQL Server 2008/2008R2 using SQL Server Management Studio.
• Configured Replication methods like snapshot replication, transactional replication and Merge replication for two environments.
• Worked on the performance optimization of the ODS import jobs.
• Worked on the analysis of test cases with the team members and make the necessary changes.
• Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2008.
• Performed the Unit testing for packages developed to ensure that it meets the requirements.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements, procedures and functions.

Environment: MS SQL Server 2012/2008, SQL Server Reporting Service (SSRS) 2012/2008, SQL Server Integration Service (SSIS) 2012/2008, T-SQL, PL/SQL, Excel.

Confidential, Plano, TX

SQL/BI Developer

Responsibilities:

• Gathered requirements through meetings with the Users, business analysts and team members.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Created indexes, Constraints, and rules on database objects.
• Created views and stored procedures and optimizing them.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL SSIS.
• Generated Custom ETL scripts using SSIS, develops and unit test SSIS load processes for performance check.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Created and maintained security profiles for MS BI reporting needs.
• Involved in developing Complex SSRS Reports (2008/2005) involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Creating some Score cards and Dash Board Reports Using SSRS 2008.

Environment: s: SQL Server 2005/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer.

Confidential, Franklin Lakes, NJ

SQL/BI Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Data Analysis and Designed the logical and physical model architecture for database.
• Interacted directly with the various SME for gathering the business requirements.
• Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.
• Convert data from Legacy system to SQL Database.
• Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
• Involved in the maintenance of the existing cubes of the data warehouse by adding additional dimensions, user-defined hierarchies, and calculated members using SSAS 2008 and also wrote many MDX scripts while developing the reports from the cubes using SSRS 2008.
• Implemented Auditing using triggers.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Created schema objects, rules and granted roles to the users.
• Involved in Query optimization, Performance Tuning and Index Creation.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports.
• Database Backup and restoring the database.
• Worked in Database Security, Replication, and Log shipping activities.
• Validating and Testing of the Database data, SQL codes and application (White box and Black box).
• Prepared Documentation of the system.
• Involved in administrative tasks such as backup and restore, managing database files, installing third party tools such as JIRA (project tracking tool).
• Created technical specification documents for all ETL packages, Reports and Cubes. Worked closely with QA team to help them understand the same.

Environment: MS SQL Server 2008/2005, SSRS 2008, SSAS 2008, T-SQL, MS-Excel, XML, Windows 2003/NT/XP.7

Confidential, CA

SQL/BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Generated some reports using SSRS (SQL Server Reporting Services) from OLTP and OLAP data sources.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Working knowledge in Data modelling, creating star and snowflake schemas in SSAS.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008, SSRS, SSIS, SQL, T-SQL, Win 2003 Advanced Server and Erwin v7.2.

Confidential

SQL Developer

Responsibilities:

• Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts,stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Created and administered multiple development, and production databases.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2000, Windows 2003/2000 Server, Data Warehousing, C, C#, .NET, Rational Rose Enterprise.

Confidential

Junior SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Created Database Objects - Tables, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
• Successfully implemented indexes on tables and views for optimum performance tuning.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Debugging / editing the existing SQL Scripts.
• Optimized the performance of various SQL scripts.

Environment: MS SQL Server Integration Services 2005, T-SQL, SQL Server Management Studio, Microsoft Visual Studio 2005.