SUMMARY

• Around 8 years of IT Experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementation of Business Intelligence of Microsoft SQL Server 2012/2008/2005 with various business domains like Financial, Healthcare and Manufacturing.
• Good noledge of Normalization/De-normalization, data design methodology and building Referential Integrity for teh relational Database Model implementing as per business requirement.
• Efficient in creating joins and sub-queries for complex queries involving multiple tables and expert in maintainingError loggingusingExceptional HandlinginSQL Server.
• Hands on experience in creating indexed Views, complex Stored Procedures, TEMPeffective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Code optimization and improving efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Scheduled and maintained nightly and weekly loads of data by creating teh corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Sources, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• 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.
• Experience in implementing Dynamic ETL and utilized several Transformations like Lookup, Fuzzy Lookup for implementing teh Transformation Logic in teh Packages.
• Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration services Performance and activity, and implementing Security considerations for SSIS Packages.
• Extensive noledge and experience in Designing, Developing and deploying various kinds of reports and dashboards using SSRS from multidimensional data.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports and formatting them.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Knowledge of developing reports from Cubes using teh KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Experience on Creating SSAS Tabular models to minimize teh maintenance of objects in server and further created reports in Excel - Power Pivot.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

RDBMS/Databases: MS SQL Server 2005/2008/2012 , MS Access 2003/2007, MYSQL.

Programming Languages: T-SQL, PL/SQL, C, XML, HTML, JavaScript, Visual Basic 6.0, ASP .NET

Data Modelling: MS Visio, Fact & Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

BI Tools: SQL Server Reporting Services (SSRS 2005/2008/2012 ), SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Analytical Services (SSAS 2008), Power BI (Power Pivot, Power View), Data Transformation Services (DTS), Visual Studio, BIDS.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS)

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010

PROFESSIONAL EXPERIENCE

Sr. SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Optimizing Stored Procedures and other long running queries using Query-Optimization techniques and indexing strategies as creating various Clustered, Non-Clustered or Covered Indexes.
• Compressed data files by removing empty database pages and updating index statistics.
• Responsible in writing stored procedures, Triggers, User-defined Functions, Views, Cursors and also creating constraints for both Online and Batch requests handling business logic and functionality of various modules.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Written complex SQL statements using joins, sub queries and correlated sub queries
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created packages by testing and cleaning teh Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Performed SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading teh data into teh Data warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Creating and maintaining automated jobs for database backup on a weekly basis based on teh percentage used and made sure teh backup is current.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, charts, and synchronized queries.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS and Excel.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services(SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Understanding teh OLAP processing for changing and maintaining teh Warehousing, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Actively interacted with users,team lead, DBAs and technical manager to fully understand teh requirements of teh system.

Confidential, Charlotte, NC

Sr. SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Designed, developed, and maintained numerous database reporting solutions, tables, views, stored procedures, Triggers and various functions.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Lead optimization efforts around top performance problems in teh environment and reduce query waits in teh environment by suggesting code optimization and data indexing changes.
• Analyzed teh complex DB structure and provided teh solution based on user requirements.
• Extensively used SSIS for transferring data by utilizing various control flow and data flow elements and also involved in end to end unit testing.
• Wrote various stored procedures for teh purpose of application development.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Used teh row count transformation and event handlers control flow to populate teh special Log tables withhigh level SSIS packageexecution results.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Generated reports using Global Variables, Expressions and Functions using SSRS.
• Implemented and enhanced existing reportslike Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-valve Parameters.
• Administered and developed financial reports (SSRS) for numerous managing applications with SQL Server.
• Created data sources, connection strings and defined teh datasets for generating teh report.
• Used various report items like tables, sub report and charts to develop teh reports in SSRS
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Created Cubes and performed data mining on teh data using teh fact table and teh dimension using SQL Server Analysis Services.
• Worked in Creating partitions and Designing various storage modes to increase teh performance of a cube using SSAS.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star schema using Dimensional data modeling principles in SSAS.
• Created aggregations, KPI’s and perspectives for a cube as per business requirements and Created roles using SSAS to restrict cube properties.

Environment: SQL Server 2012/2008 R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), T-SQL, MS Excel (Power Pivot), MS Access, SharePoint 2010, Team Foundation Server (TFS).

Confidential, Arlington, VA

SQL / BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Modified teh existing SQL queries according to teh requests and executed them to check teh performance.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints and also performed Table Partitioning on very large scale databases.
• Responsible in writing T-SQL queries, Store Procedures and used them to build packages and handled Change Data Capture (CDC) to maintain teh history of teh data.
• Used SQL Server Profiler to trace teh slow running queries and teh server activity.
• Worked on existing complex SQL Codes to fix teh errors and change teh procedures to match teh requirements for various business reasons.
• Created complex SSIS packages for transferring and reviewing data from heterogeneous sources like (Excel, MS Access, MySQL, PostgreSQL, CSV, flat file, Text Format Data).
• Understanding teh OLAP processing for changing and maintaining teh Warehousing, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Managed up gradation of DTS packages to SSIS packages
• Implementation end to end packages that must include variables, parameters, expressions, transactions, Script task, Script component using C#.
• Apply various transformations like Slowly Changing Dimension (SCD), Multicasting, Union, Derived Column and Data Conversion.
• Developed and deployed data transfers packages using SSIS, also maintained teh jobs running on Servers.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports in Power BI preview portal utilizing teh SSAS Tabular via Analysis connector.
• Developed complex reports using multiple data providers, user defined objects, charts and synchronized queries.
• Created static reports using MDX queries and creating MDX base report definition and also wrote MDX queries to extract data from data marts.
• Discussed and documented teh building of data warehouse at every step.
• Proficient in building Star schema and Snow Flake schema depending on business requirements
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star schema using Dimensional data modeling principles in SSAS.

Environment: SQL Server 2008 R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), T-SQL, MS Excel, SharePoint, T-SQL, XML, TFS.

Confidential, Cleveland, OH

SQL / BI (SSIS/SSRS) Developer

Responsibilities:

• Design, create and regular tuning of physical database objects (tables, views, indexes) to support normalized and dimensional models.
• Worked on complex queries to map teh data as per teh requirements.
• Worked as a developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery
• Responsible for testing to optimize teh procedures and triggers to be used in production.
• Created database maintenance planner for teh performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Explored ways to optimize existing ETL processes and enhance their performance.
• Created SSIS package configuration using environment variable to change teh value of variables.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Developed and deployed data transfers packages using SSIS, also maintained teh jobs running on Servers.
• Used various control flow tasks like For Loop, Execute package/SQL tasks, Script task, send mail task and different data flow tasks/transformation.
• 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.
• Experience in using Visual Studio Team Foundation Server (VSTF) including creating deployment builds.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• UsedSub Reports, Graphing, Data Drill-Down, Drill-Through, and Data sorting/grouping and created various dynamic reports using SSRS.
• Schedule SSRS reports Daily, Weekly and Monthly using Subscriptions.
• Responsible for Deployment of SSRS reports onto different environments.
• Refreshing teh cube to get teh latest information updated and deployment of Cubes to teh production server.

Environment: SQL Server 2008 R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), T-SQL, MS Excel, MS Access, Team Foundation Server.

Confidential

SQL / SSRS Developer

Responsibilities:

• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Troubleshooting and resolving performance issue in teh SQL Server and PostgreSQL for teh long running queries or teh stored procedures.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Generated Sub-Reports, Drill down reports, Group Reports, Reports having totals & Sub-totals, Cross Tab Reports and Parameterized reports using SSRS.
• Created queries for generating drill down reports in SSRS. Formatted teh reports using teh Global variables, expressions and Functions.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Created Linked Servers to connect OLE DB data sources and providers.
• Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations

Environment: SQL Server 2008/2005 Enterprise Edition, T-SQL, Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SQL Profiler, SQL Server Management Studio, Visual Source Safe.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in installation and configuration of MS SQL Server 2005.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain teh consistency and data integrity.
• Used Try catch and @@error for exceptional handling.
• Managed, created and altered Tables, Views, Indexes, and Constraints with business rules usingT-SQL
• Created DTS/ETL package to schedule teh jobs for batch processing.
• Worked with SQL 2005 Advanced features like CTE’s, Except, Intersect, Pivot and Un-pivot.
• Involved in performing database Backup and Recovery.
• Used SQL Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.

Environment: SQL Server 2000/2005 Enterprise Edition, T-SQL, SQL Server Management Studio, BCP, DTS, XML, HTML, VB, SQL Profiler, Index Wizard, Visual Source Safe.