PROFFESIONAL SUMMARY:

• Over 5 years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) using SQL Server 2008R2/ 2012/2014/2016 .
• Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables with stakeholders in cross - functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security, as well as standards development and process improvement.
• Technically and logically very sound in SQL Programming, SSIS, SSRS, SSAS, Data warehousing, Business Intelligence etc.
• Highly self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet project & operational deadlines. I have always been recognized as a best programmer within the organization.
• Deft in database designing skills and experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/ 2008 R2/2005. Experience in writing SQL (DDL and DML) scripting all MS SQL server environments.
• Demonstrated expertise in MS SQL Server 2012/2010 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services) and SSAS (MS SQL Server Analysis Services)
• Strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional Table and Matrix, Charts. Specialized in using Relational data warehouse and OLAP Cubes.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience in OLTP/OLAP environment and Data Warehouse.
• Created and Configured Data Source and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2010/2012 Analysis Services.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong ability in defining query for generating drill through, drill down reports, with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2010/2014.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed reports using global variables, expressions and functions.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 , MS Access, RDBMS.

SQL Server Tools: SSMS, SSIS, SSAS, SSRS.

ETL Tools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SSRS 2016/2014/2, Excel, Power BI.

Data Modeling: Fact and Dimensions tables, Physical and Logical data modeling, Star and Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio.

Programming: Dynamic SQL, MDX, DAX, C#.

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota

SQL Server /Power BI Developer

Responsibilities:

• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Worked on performance tuning of Views, CTE’s, stored procedures.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Used star-schema in designing data marts for creating SSIS ETL packages.
• Used DAX operations that were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2012.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used SSIS 2015 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Used Power BI Custom visuals like Power KPI, Info Graphic Designer, Spline Chart to make the visuals look and understand better.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Deployed Dashboards, Reports and Data sources in the Power BI Service .

Environment: MS SQL Server 2016/2012 Enterprise Edition, SQL Server Integration Services 2015/2012, MS SQL Server Reporting Services 2015/2012, SQL Server Analysis Services 2015/2012, Power BI, Windows 10.

Confidential, Alabama

SQL BI DEVELOPER (SSIS, SSAS & SSRS)

Responsibilities:

• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS 2015.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Converted data types using Derived Column, Data Conversion Transformation .
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Identified and worked with Parameters for parameterized reports in SSRS 2015.
• Used SSRS to create reports, customized Reports, on-demand reports and involved in analyzing multi-dimensional reports in SSRS.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps and integrated them to share point.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Deployed the generated reports directly on the client’s workstation.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used star and snowflake schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Datawarehouse and DAX operations for SSAS 2015.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Managed Power BI - Data refreshes / User management and set up gateway data refresh.
• Building, publishing customized interactive reports and dashboards, report scheduling using SQL Server Reporting Services (SSRS).
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.

Environment: MS SQL Server 2016/2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSRS, SSAS, Performance Monitor, Power BI, ETL, Microsoft Visio 2003, MS Visual Studio 2012/2015.

Confidential

MS SQL Server Developer/SSRS/ SSIS/SSAS Developer

Responsibilities:

• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• 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 developed SQLSSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Applied different transformations, control lookups, SCD, Derived column to easily migrate SSIS package from one server to another.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Built SSIS Packages for Processing cubes and Dimensions.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS.
• Responsible for scheduling the reports based on the subscriptions defined.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Responsible for creating dimensional and fact tables and building cubes using SSAS.
• Responsible for maintaining and tuning existing cubes using SSAS.
• Worked with the Planning team to forecast the business requirements.
• Experience in Designing, building the Dimensions, Cubes on star schema using SQL Server Analysis Services (SSAS) for business analysis.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Involved Backup and Recovery Strategies, and Disaster Recovery Plan.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Customized interactive KPI reports and dashboards built using SQL, Excel, Power BI, statistical modelling to identify gaps in supply chain processes resulting in an improve.
• Used SSAS Cube Data models as source in Power BI to do Analytics with direct query connection in Power BI.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Extensive use of DAX (Data Analysis Expressions) functions in creating Power BI dashboards, reports and Tabular Models.

Environment: Server 2012/2014, SSIS, SSRS, SSAS, SQL, Visual Studio.

Confidential

SSIS/SSRS Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Worked on ETL Tool for designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets to and from SQL Server using BIDS.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Developed efficient Stored Procedures to support SSIS Packages and Business Intelligence Reporting.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
• Used Power Query to perform data cleansing operations and to import data from multiple log files.
• Involved in C# scripting for use in script components in SSIS Packages.
• Involved in creating efficient multiple parameterized stored procedures for various kinds of reports.
• Worked on Table Partitions for better performance in SQL server 2008.
• Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Extensively worked on OLAP Cube Life Cycle Process, Power view, Power Pivot.
• Worked on Cube partitioning for better database performance.
• Defined Data sources, data sets, dimensions and measures using SQL Server Analysis Services (SSAS).
• Worked on processing and deploying of cubes on to the database servers.

Environment: Windows SQL Server 2008/2008R2/2012, BIDS, MSMS, Microsoft Reporting, Integration, Analysis Services, Power BI, SQL Server Data Tools, Team Foundation Server, .Net.