SUMMARY

• Over 8+ years of experience in IT industry MSBI Developer in windows environment.
• Extensive experience with SQL Server 2016,2014,2012, 2008R2, 2008, 2005 and worked extensively on BI Tools like Integration services (SSIS), Reporting services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Views, Functions, Triggers (DDL and DML), indexes, and user defined functions.
• Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Constraints (Primary key, Foreign Key, Unique, Default).
• Experience in Fine Tuning SQL queries and T-SQL and PL\SQL queries & improving the performance of the Database using SQL Profiler.
• Experience in performance tuning in SSIS using row transformations, block and unblock transformations.
• Experienced in creating, migrating, deploying complex SSIS packages with complicated transformations like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task using SQL Server Integration Services (SSIS)
• Excellent report creation skills using Microsoft SQL Server Reporting Services (SSRS).
• Expertise in generating drill downanddrill throughreports using SSRS
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members using Microsoft Analysis Services (SSAS).
• Experience in Developing and ExtendingSSASCubes, Dimensions and data source viewSSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Managed all database servers in development, staging, test and production environments.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries usingSQLServer Activity monitor,SQLprofiler, Extended events and handling them by implementing better Query Execution plans.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2016/2014.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Worked on Source control tools like GITHUB, Team Foundation Server.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

TECHNICAL SKILLS

SDLC: Agile, Scrum, Waterfall, and Spiral

Databases: MS-SQL Server 2016/2014/2012/2008 R2/2008/2005,SQL Azure

Data Modeling: ERWIN, MS Visio

Business Intelligence Tools: Power BI

Collaboration Tools: SharePoint

Integration Services (SSIS):

Analysis Services (SSAS, OLAP Cubes):

Reporting Services (SSRS, Report Builder):

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

Programming Language: T-SQL Programming, PL/SQL

PROFESSIONAL EXPERIENCE

Senior MSBI/SQL Developer

Confidential, Phoenix AZ

Responsibilities:

• Involved in gathering business requirements, interacting with the client and preparing detailed design document.
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Created and optimized database objects such as views, functions and stored procedures as per requirement.
• Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• 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.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the SSIS packages. Identify and document the source to target packages.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Design and document the error-handling strategy in the ETL load process using Event handlers.
• Created OLAP cubes using SSAS and created reports from them.
• Designed and built Tabular cube using SQL Server analysis Services with dimensions and built daily partitions on fact tables.
• Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with DAX, developing reports using DAX and T-SQL.
• Performed Data migration utilities (Import & Export, BCP, Bulk Insert) from text to SQL Server.
• Created test data and unit test cases to ensure successful data loading process.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Used Notification services to generate error messages and send them to the user through e-mails. Created report snapshots to improve performance of SSRS.
• Gathered data from multiple data bases across the organization and produced reports for different departments.
• Converted existing Excel based reports and crystal reports to SSRS reports.
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions.
• Created dashboards for Sales, Inventory, Performance and finance.
• Deployedanduploaded the SSRS reportstoReport Manager &SharePoint Serverfor the end users and involved in enhancements and modifications.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.

Environment: MS SQL Server 2016/2014, T- SQL, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS, Microsoft SQL Server Analysis Services (SSAS Tabular Model), SQL Server Business Intelligence Development Studio, GIT/TFS, Erwin 8.0/MS Visio 2010.

Senior MSBI/SQL Developer

Confidential, Boise, ID

Responsibilities:

• Defined multiple constraints in the logical phase of the data modeling life cycle.
• Generated T-SQL scripts to create a multitude of database objects such as tables, views, and procedures.
• Built complex stored procedures for operations such as data profiling and index de-fragmentations.
• Implemented error handling techniques and functions such as try-catch blocks in scripts and stored procedures.
• Optimized the performance of queries and procedures with multiple approaches.
• Created SSIS packages which extract data from multiple input sources to load into the OLAP destination.
• Debugged exceptions in SSIS packages utilizing event handlers and precedence constraints.
• Implemented master-child package models to improve the performance of the complex ETL strategy.
• Deployed SSIS packages to multiple environments with the project deployment model.
• Designed and created OLAP cubes with dimensions and facts.
• Created cube objects such as KPIs, perspectives, and calculated members to improve analyses.
• Assigned appropriate storage modes to partitions within cubes to improve performance.
• Created reports with drill-down, drill-through, and cascading parameterized functionalities.
• Delivered reports in multiple rendering formats utilizing standard and data driven subscriptions based on demand.
• Created dashboard reports utilizing Power BI tools such as Power View.
• Optimized report data sets to improve report generation times.
• Designing, Creating & maintenance of Reports in SSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports.

Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, Erwin, SSIS, SSAS, SSRS, SharePoint, Power BI, Power View, TFS, DTA, SQL Profiler

MSBI Developer

Confidential, Redwood City, CA

Responsibilities:

• Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join.
• Created SSIS packages to load data into Data Warehouse using Various SSIS tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Used SSIS and SQL Server stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Used SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data warehouse.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Created report snapshots to improve performance of SSRS.
• Gathered data from multiple data bases across the organization and produced reports for different departments.
• Converted existing Excel based reports and crystal reports to SSRS reports.
• Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions.
• Created dashboards for Sales, Inventory, Performance and finance.
• Deployedanduploaded the SSRS reportstoReport Manager &SharePoint Serverfor the end users and involved in enhancements and modifications.
• Created OLAP cubes using SSAS and created reports from them.
• Designed and built cube using SQL Server analysis services with dimensions and built daily partitions.
• Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Performed Data migration utilities (Import & Export, BCP, Bulk Insert) from text to SQL Server.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Created test data and unit test cases to ensure successful data loading process.
• Used Notification services to generate error messages and send them to the user through e-mails.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, Spot Light, Toad, SQL Profiler, Team Foundation Server and Windows Server 2008/2010, Oracle 10.0 G.

MSBI Developer

Confidential, Worcester, MA

Responsibilities:

• Collaborated with business users to gather requirements and analyze source data.
• Created and managed multiple schema objects such as tables, views, indexes, and referential integrity.
• Maintained data integrity with the creation of constraints and DML triggers.
• Tuned and optimized T-SQL queries utilizing execution plans and profiler.
• Designed and implemented data integration modules for extract/transform/load (ETL) functions.
• Create ETL packages to validate, extract, transform, and load data with SSIS.
• Implemented slowly-changing transformations to maintain historical data in the data mart with ETL.
• Debugged packages with breakpoints, checkpoints, event handlers, and loggings.
• Implemented SSAS cubes, facts, and dimension tables to perform analyses.
• Wrote MDX queries to extract data from the data mart.
• Wrote T-SQL scripts for generating data sets for reporting.
• Created reports with combined queries, filters, drill-down, and cross tabs.
• Published automated reports to the business intelligence catalog utilizing SharePoint.
• Managed code version control in TFS (Team Foundation Server).

Environment: ERWIN, SQL Server 2012, SSIS, SSAS, SSRS, SSDT, Power Pivot, Power View, MS Excel, TFS, SharePoint

MSBI/SQL Developer

Confidential, San Antonio, TX

Responsibilities:

• Review, develop and designs data models, in conjunction with the application development team.
• Generated SQL scripts for creating objects such as procedures, views, tables, functions.
• Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes.
• Implemented business logic with the creation of complex stored procedures.
• Created SSIS packages to get data from sources, consolidate and cleanse the data and merge it into single source.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Created SSIS packages that would transfer data between servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and worked with users in training and support and has experience in incremental data loading.
• Designed and created report templates, bar graphs, and pie charts based on financial data.
• Created queries to generate reports for data analyses with SSRS report builder.
• Generated reports with global variables, expressions, and functions in SSRS.
• Installed, configured, and managed the report server.
• Scheduled report deliveries with data driven subscriptions in SSRS.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, Windows 2008 Server, T-SQL, MS Excel, Visual Studio 2008s, Microsoft Visio

SQL/ETL Developer

Confidential

Responsibilities:

• Communicate and coordinate with clients to understand business needs and expectations from the ETL Process.
• Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and Indexes.
• Modified existing stored procedures to improve performance.
• Generated scripts with joins, sub queries, and set operators.
• Created ETL strategies to populate the data warehouse and data mart with facts and dimensions.
• Updated mapping documents for new SSIS mappings.
• Created views and procedures for SSIS OLEDB sources.
• Implemented slowly changing transformations with SSIS to maintain historical data in the data mart.
• Debugged SSIS packages with error log details, checkpoints, breakpoints, and data viewers.
• Deployed SSIS packages to the production server with XML and SQL server configurations.
• Scheduled SSIS packages to execute during non-peak hours.
• Generated Excel reports for managers utilizing SSIS in the desired format.
• Implemented loggings in SSIS packages to troubleshoot runtime issues.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSAS, SSRS, Query Analyzer, T-SQL, Excel, TFS, DTA, SQL Profiler