PROFESSIONAL SUMMARY:

• Microsoft Certified Business Intelligence Developer with 7 years of work experience
• Strong experience in using the Microsoft BI Stack (SQL, SSIS, SSAS, SSRS and Power BI). Worked with SQL Server 2012/2014/2016.
• Experienced in Microsoft Power BI, Power Query, Power Pivot, Power BI Service, Power BI Desktop
• Experienced in using Power BI Premium, and Power bi Pro.
• Extensive experience in MS SQL Server 2014/2012/2008 R2/2005 Business Intelligence in MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS).
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
• Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Excellent DAX skills with the ability to create and troubleshoot complex calculations and measures.
• Involved in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers, Primary keys and foreign keys.
• Developed SSIS packages that can extract data from Excel/flat files into SQL server using different SSIS components.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Excellent back-end skills in creating SQL objects such as Tables, Complex Stored Procedures, User-defined Functions, Views, Indexes, Triggers, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• A well-organized, goal-oriented, highly motivated effective team member with strong analytical, troubleshooting, and problem solving skills.
• Proficiency in the use of T-SQL for developing stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
• Experienced in configuring SSIS packages using package logging, Breakpoints, Checkpoints, and Event Handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.
• Experienced in designing and developing a considerable number of reports in SSRS using the data from ETL Loads. Proficient in developing Drill-through and Drill-down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience using recent versions of Microsoft Visual Studio 2012/2014/2014.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery, and Report security.
• Participated in AGILE iterative development methodology.
• Actively supported business users for changed requests. Helped the users to test the reports created and optimized the performance of the end reports.
• Strong knowledge of data marts, Operational Data Store (ODS), SSAS Tabular, Star Schema modeling, and Snowflake modeling for Fact and Dimension tables.
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio(SSMS)2012, 2014, SQL Server Business Intelligence Development Studio (BIDS), SSIS, ETL

BI Tools: Visual Studio 2012: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS)

Languages: T-SQL

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer/Power BI Developer

• Designed and created an ETL solution to consolidate mortgage loan applications received from various sources. Numerous reports were also created to meet the client’s need.
• Worked on all activities related to the development, implementation, administration, and support of ETL processes.
• Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
• Used advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Performed efficient tuning of SQL source queries for data load/usage of Stored Procedures for optimized performance.
• Enhanced performance using optimization techniques - normalization and indexing.
• Developed SSIS ETL Packages& also modified packages into different environment (Development, Testing & Production), as ongoing requirement changes
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Performance Tuning of queries and Stored Procedures.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed SSRS Reports on the newly developed ERM Model for financial data users.
• Involved in Performance tuning the SQL Server Queries used in SSRS Report and also used Report Snapshots for better performance.
• Created user groups in Report Manager for limited access to the end users in SSRS.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Experience in developing executive dashboards and scorecards using Power Bi and MS SQL Server Reporting Services (SSRS) with industry standard tools, methods and requirements.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client.
• Created & modified SSRS reports (2012 & 2016) depend on the requirement on the priority basis from the DW & BW bug tracker applications.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosstabs and chart.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Worked on the performance and high priority critical issues to meet deadlines for SSIS package execution and for SSRS reports rendering.
• Enhance SSIS packages to perform dynamic functionalities from static configuration and changed many of the packages by using C# coding for generic usage within the organization.
• Created and developed Sub-Reports, Drill-down reports, Drill-through reports, Parameterized reports, and Matrix reports using SSRS.
• Created dashboards, Tabular and Matrix reports, charts, graphs, and gauges as per customer requirements using SSRS.
• Rendered reports in different formats like PDF, Excel, etc. Scheduled to be executed automatically on a weekly or monthly basis and managed subscriptions.
• Applied security to reports on Item and Folder level.

Environment: T-SQL, MS SQL Server 2008, BIDS, Management Studio (SSMS), ETL, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), OLAP, Cubes, Data-warehousing, Windows 2008.

Confidential

SQL Developer/MSBI Developer

• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, for loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Created technical specifications, test plans and test data to support ETL processes.
• Created SSIS Packages to load Data from Existing Data Model to new Data Model and Data Ware House.
• Involved in designing complex packages moving data from various servers and environments using SSIS.
• Deploying SSIS Packages on respective server and effectively using configuration files for using same packages on other environments.
• Scheduling the SSIS packages by creating a Job using SQL Agent in SSMS.
• Designed, built and tested SSAS Cubes on SQL Server 2008.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS). Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Gather requirements from the user community and write Functional Design Specifications.
• Created parameterized reports for the users and clients, with drill-down, drill-through features.
• Worked with users and business analysts to design and develop matrix, gauges, Charts, drill down interactive reports.
• Coordinated with DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.
• Regular monitoring of Time/Data driven Subscription based SSRS reports (Daily, Weekly) and SSIS external file transfers.
• Work in designing & deploying SSIS packages for transferring data from heterogeneous data to and from SQL Server.
• Worked on creating Stored Procedures, Views to support Web front Dashboards and reports.

Environment: MS SQL Server 2014/2012, Transact-SQL, SQL Server Integration Services (SSIS), Power BI, SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel.