PROFESSIONAL SUMMARY:

• Over 5+ years of Experience in Microsoft Business Intelligence technologies in SQL Server Integration Services (SSIS), SQL Server Analysis Services(SSAS) and SQL Server Reporting Services (SSRS).
• Expertise in utilizing Azure Data Factory v2 to create pipelines from various on - premise data sources into BLOB storage and Perform data modeling for Reports in Power BI.
• Used Microsoft Azure date storage and Azure Data Factory for transforming data and Configured Azure SQL database with Azure storage Explorer and with SQL server.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity and query writing.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor.
• Expertise in solving run time issues using error and event handler, breakpoint, check point and loggings in SSIS.
• Well experienced in creating various types of reports like Tabular, Matrix, Drilldown, Cascaded parameterized, Sub reports, Ad-Hoc Reports, Cross Tab Reports in multiple formats like Excel, Word, PDF, Image, and Power Point using SQL Server Reporting Services (SSRS) and Tableau based on client requirements.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN and hints.
• Extensively worked in Client-Server application development using SQL, T-SQL, SQL Server 2012/2014/2016 , SSIS 2012/2014/2016 , SSRS 2012/2014/2016 .
• Experience in the Analysis, Design, Development, Testing and Implementation of business application systems.
• Experience in MS Excel skills like Pivot Tables, Macros.
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data and deploying them on various production servers.
• Experience in Production Support and troubleshooting data quality and integrity issues.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using T-SQL to populate the tables in OLTP and OLAP Data Warehouse Environment.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Experienced in Deploying reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Expertise in Creating Complex reports using CSV files as source to fetch the data and Created Dashboards, Reports and Datasets using Power BI

TECHNICAL SKILLS:

Technology: Microsoft Business Intelligence Tools (MSBI)

ETL Tools: Azure, SQL Server 2012/2014/2016 Integration servicesQuery Analyzer, SSDT Tool, SQL Server Profiler

Analysis Tools: SQL Server 2012/2014/2016 Analysis services

Reporting Tools: SQL Server 2012/2014/2016 Reporting services, Power BI

Languages & OS: T-SQL, HTML, Windows

Version Controller: TFS, IBM Rational Synergy and Doors

Other Tools: Erwin, Microsoft Visio, Data Analysis, Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

WORK EXPERIENCE:

SQL BI Consultant

Confidential, Monterey Park

Responsibilities: -

• Developed Azure Data Factory (ADF) interfaces to grab data from databases, web services, and flat files.
• Creation of database objects tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Involve in creating, modifying and troubleshooting ADF Pipelines.
• Developed various Azure Storages such as Blob Storage, Queues, Files and Tables
• Worked on Dimensional modeling to Design and develop STAR Schemas and Dimension Tables
• Involved in development of Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them.
• Scheduling/enabling triggers for the ADF Pipelines developed.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Worked on creating Visio diagrams to explain the design process.
• Imported Data to Power BI from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services, Excel, etc...
• Designed Power BI data visualizations utilizing cross tabs, Maps, Scatter plots, Pie, Bar and density charts.
• Managing all the relationships in Power BI, Created Dashboards and published.
• Worked on writing DAX Queries to Generate Computed Columns.
• Installed and configured Enterprise Gateway and Personal Gateway in Power BI services.

Environment: MS Azure, SQL server 2016, T-SQL, SQL Server Data tools, MDX, MS-Office, MS Access, Visio, Erwin, Power BI.

MSBI Developer

Confidential, San Jose,CA

• Extracted data from various sources SQL Server 2012/2014, Oracle, .CSV, Excel and Text file from Client servers through FTP.
• 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. for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• 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.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2014 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2014 OLAP databases.
• Involved in Tabular Data warehousing and DAX operations for SSAS 2012 and 2014 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects.
• Assess the risks and recommend/ install service packs or hot fixes when needed.

Environment: SQL Server 2012 and SQL server 2014, SSIS, SSAS, SSRS, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN

MSBI developer

Confidential

Responsibilities: -

• Created database objects, tables, views, indexes, stored procedures, Packages using SQL.
• Exposure to SQL Loader and ETL concepts in a data warehousing environment with large volume databases.
• Actively participated in gathering Business Requirements and System Specification.
• Participated in implementing the logical design to the physical design by creating tables.
• Involved in the design of new schema, new tables, field definitions and mappings, queries.
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Prepared the document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drilldown and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency
• Loaded data from Source to destination using different format file like Text file, OLDB file, Excel file in SSIS.
• Created SSIS Packages to read claims status data from Oracle and SQL databases and generated output files that hold the payment information in various file formats like TXT, Excel, .CSV, etc.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Exposure to data modeling concepts in a RDBMS environment.
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.

Environment: SQL Server 2012, SQL *Plus, MS-Office, T-SQL, Beyond Compare, SVN, SSIS 2012, SSRS 2012, Toad, Visual Studio, Windows, Unix.