PROFESSIONAL SUMMARY:

• MSSQL BI Developer with 8+ years of IT experience in development, analysis, design, testing, presentation and implementation experience using SQL Server 2014/2 and SQL Server Data tools.
• Expertise in Extract, Transform and Load (ETL) using SSIS and various tools including Bulk insert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designed and developed for a Data Warehousing and Data Migrations.
• Hands - on experience in development and implementation of Data Warehouse applications.
• Staging Partitions,Usage Based Optimization (UBO)mechanisms for SSAS 2012 and 2008 OLAP databases.
• Strong SQL development skills including writing Stored Procedures, Triggers, Views & User Defined functions.
• Created Cubes/ Dimensions, deploying, processing Cubes using SQL Server Analysis Services (SSAS).
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Expert in creating objects like Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Vast experience in utilizing SharePoint and Microsoft BI PowerTools such as Power pivot, Power map, dashboards, scorecards for the creation of more interactive, appealing reports.
• Experience in report writing using SQL Server Reporting Services (SSRS) using Reporting Builder 3.0 (SSRS) and creating various reports like Tabular, Matrix, Drill Down and web reporting by customizing URL Access.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Excellent Communication and interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environment.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008, PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0. Teradata.

Languages: C#.Net, VB.Net, XML, ASP.NET, T-SQL.

Scripting Languages: HTML, XML, Java Scripting, VB Scripting

ETL & Reporting/Visualization: SSRS 2014/2012, SSIS 2014/2012, Tableau 8.x, SSRS 3.0

Data Warehousing ETL tools: Informatica Power Center 8 .X,7.X

Tools: Microsoft Business Intelligence Studio, MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2014/2012 Analysis Services (SSAS),COSMOS/SCOPE, Visual web developer, MS FrontPage

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

SQL BI developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards, and scorecards.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS),OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables usingMS Analysis Services.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved inStaging PartitionsandUsage Based Optimization (UBO)mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved inTabular Data warehouseandDAXoperations for SSAS 2012 and 2008 OLAP databases.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Experienced in creating different types of reports such as Drill Down/Drill Through, Cascading Report, Cross Tab Report, Parameterized, Sub reports and Charts using Global variables, Expressions and Functions for the Business Users using SSRS.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• UsedSSISto create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Hide and Show the objects by using conditional blocks.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.

ENVIRONMENT: MS SQL Server 2012, Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad, text editor, MS Visio 2005, DTS, SQL Query Analyzer, Tera Data SQL Developer, SSIS/SSRS.

Confidential, Doral, FL

SQL Server Developer/ BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Perform ETL processes using SSIS tool for SQL Server.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data on heterogeneous Database sources like Oracle, SQL Server & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets, and Schedule jobs.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS)
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, COSMOS etc. to SQL Server usingSSIS/DTS using various features like data conversion etc.
• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

ENVIRONMENT: SSIS/SSRS/SSAS, SQL Server 2008 R2, VB.NET Query Analyzer, Tera Data Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, MA

SQL BI Developer

Responsibilities:

• Created Tablix Reports, Matrix Reports, Parameterized Reports and Sub reports using SQL Server Reporting Services 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Experience in building Reports on Analysis Services cubes.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS 2005/2008 R2).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 R2 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Experience in Reviewing Cube with End user and changing the cube and documentation according to their requirements.

ENVIRONMENT: SQL Server 2005/2008 R2, SSAS, SSIS, T-SQL, SSRS, Oracle 9i, Performance Point Server 2007.

Confidential, Jersey City, NJ

SQL Server BI developer

Responsibilities:

• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS to SQL server.
• Creating SSIS package to load data fromFlat Fileto Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Worked in importing and cleansing of data (using SSIS) from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008R2with high volume data.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, TRY and CATCH blocks using SSIS.
• Scheduling Jobs and Alerting using SQL Server Agent for SSIS packages and other SQL jobs.
• Built SSIS Packages for Processing cubes and Dimensions.
• Provided documentation for all kinds of SSIS packages.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Designed and developed Star and Snow Flake Schema as a data analyst.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.

ENVIRONMENT: SQL Server Reporting Services 2005/2008, SSAS, MS SQL Server 2005/2008,, SSIS, Front Office 8.3 / 10.2 / 10.3, Windows XP / NT / 2000/2003, MS Office 2003/2007.

Confidential

SQL Developer/SQL Server DBA

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.

ENVIRONMENT: SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Crystal Report 10, Crystal Enterprise 10, Microsoft Visio 2000

Confidential

SQL Server Developer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Worked with development teams in the design of physical databases and in modification.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

ENVIRONMENT: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.