SUMMARY:

• Detail oriented MSBI Developer/Engineer with over 4 years experience in database design and Microsoft SQL Server business Intelligence experience working in manufacturing, industrial and healthcare environments.
• Strong analytical skills, customer focused, takes responsibility for projects and drive results through execution.
• Efficient communicator exhibited by working closely with users to identify and resolve problems

TECHNICAL SKILLS:

• Business Intelligence Tools SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services 2012/2014.
• Data Modeling, Data Mart Development & Maintenance of Data Ware housing.
• OLAP Cubes, Snow Flakes Schema, Star Schema, Hierarchies key, Calculations, KPIs, Actions, Dynamic Partitions, Aggregations and user s roles base security . Multidimensional (MDX), Data Analysis Expressions (DAX), Tabular Model and writing MDX and DAX queries.
• ETL packages for SSIS 2008/2012/2014. Configuring and Fine - tuning ETL workflows, Implementing Checkpoint, Transactions in SSIS, Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Creating Parameterized, Drill through, Drill down, Matrix Reports, Sub Reports, Tabular Reports.
• Developing complex Stored Procedures, handling Slowly Changing Dimensions while loading data into data warehouse.
• T-SQL development skills writing complex queries involving multiple tables, great ability to develop SQL Objects and maintain Stored Procedures and User defined functions. Performance tuning and optimization of queries and stored procedures.
• Creating on demand and scheduled reports in SSRS. C#, MS Excel, SQL Server Business Intelligent Development Studio (BIDS), SQL Server Management Studio, SQL Profiler, Query Analyzer.

WORK EXPERIENCE:

Confidential, Austin, Texas

SQL Server BI/ (SSIS/SSAS/SSRS) ETL Developer

Responsibilities:

• Collaborate with the Data Services team and business stake holders to learn the aspects of the business and develop analytic insight.
• Worked with SSIS to import, export and transform the data between different manufacturing data sources.
• Write T-SQL statements for retrieval of data and performance tuning of T-SQL queries. Created documentation as required.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Held meetings with the business users to gain insight into business requirements and design goals of data warehouse.
• Designed Dimensional Modeling using SSAS packages, created hierarchies, aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Implemented Parameterized and cascading reports using SSRS for manufacturing team and business unit.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Ensures data quality and enforce standards and procedures.

Confidential, ST Joseph, Missouri

SQL Server BI/ (SSIS/SSAS/SSRS) ETL Developer

• Involved in the development of a Data Warehouse and Business Intelligence solutions for plant manufacturing and quality operations. Responsible for the day to day administration of manufacturing and quality BI application.
• Analyzes, interprets, and translates business requirements into specific technical requirements. Designs and develops solutions when necessary.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created ETL standards templates to resolve issues for SSIS jobs.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
• Analyze source system data to determine the data model and ETL solution that will meet business requirements.
• Gathered data from different sources on manufacturing, quality of products, equipment and parts performance, process conditions and specifications, equipment maintenance into a data warehouse.
• Create and modify all the needed stored procedures, user defined functions, scripts, and SSIS packages to extract, transform and load (ETL) the data from several data sources to MS-SQL Server Data Warehouse
• Created SSIS transformations like Conditional Split, Merge Join, Lookup, Sort, Aggregate, Pivot, Script Component etc.
• Worked with Business analyst, Data architect and business users, process and quality engineers to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Designed SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units including plant quality and equipment efficiency.
• Created and implemented a reporting suite of standard reports while also customizing many reports to meet the needs of process engineers, quality engineers, lean manufacturing team and business units.
• Created parameterized, drill down, drill through, Matrix reports, sub reports using SSRS as well as managed reports subscriptions.
• Deployed reports to report manager and troubleshoot errors resulting from execution.