SUMMARY

• Highly skilled and enthusiastic Information Technology professional with over 7 years working experience as a Power BI Developer / BI Developer/SQL Developer, of which, 4+ years I worked on SSIS and SSRS projects, and for over 3 years, I worked on Power BI projects. I have a solid understanding of the ETL and Reporting processes and am well equipped to provide valuable skills and knowledge to the benefit of any organization.
• Collaborated with Analysts and Knowledge Experts to design, build, and customize reporting packages
• Maintained and debugged existing Power BI reports
• Expert in creating and developing Power BI Dashboards in to rich look.
• Developed SQL Views, Common Table Expressions, and Temporary Tables
• Integrated custom visualization according to the business requirements document
• Migrated existing reports to Power BI
• Experience in developing report such SQL Server Reporting Services(SSRS), SSAS, MDX, Power BI, CUBES, SQL Server Integration Services(SSIS), DTS Packages and Performance tuning
• Developed reports in Power BI Desktop and deployed to both Power BI Report Server and Power BI Service
• Developed Data Analysis Expression Language (DAX) calculations, measures, report parameters, and report performance optimization
• Converted SQL Query code into DAX code for reports
• Designed reports and dashboards using Filters, Drill - down/Drill-through Reports and Sub-reports reports in Power BI Desktop.
• Developed Integration Services (SSIS) packages for extracting data from Flat Files, XML files, CSV files, Excel files, SQL Server, and transformed and loaded the data to a data warehouse.
• Developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, derived columns, conditional split, data conversion with multiple data flow tasks.
• Implemented various error handling and event handling techniques in SSIS to ensure efficient package execution.
• Experience in developing report such SQL Server Reporting Services(SSRS), SSAS, MDX, Power BI, CUBES, SQL Server Integration Services(SSIS), DTS Packages and Performance tunin
• Strong experience in developing and deploying SSIS packages using dataflow and control flow components, creating SQL mail alerts and job scheduling using SQL Server Agent.
• Developed logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed SSIS jobs and scheduled packages using SQL Server Management Studio for the daily load.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, Conditional Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Designed packages using control flow tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task and Data Flow Task
• Created Sub-Reports, Drill-down, Drill-through Parameterized, Matrix reports, and Dashboards using SSRS.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Customized SSRS delivery formats for Word, Excel and PDF.
• Experience in developing report such SQL Server Reporting Services(SSRS), SSAS, MDX, Power BI, CUBES, SQL Server Integration Services(SSIS), DTS Packages and Performance tuning
• Customized SSRS delivery formats for Word, Excel and PDF.Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Enhanced SSRS report performance using numerous techniques.
• Managed report subscriptions.

TECHNICAL SKILLS

• Power BI Desktop, Power BI Service, Power BI Report Server, Power BI Mobile and DAX
• SSIS, SSRS, SSAS, SSMS, SQL Server and T-SQL
• MS Visual Studio, MS Excel, Microsoft Office, PowerPoint, Outlook
• Knowledge of Agile, Waterfall, SCRUM, Inmon and Kimball Methodologies

PROFESSIONAL EXPERIENCE

Power BI Developer/SQL BI Developer

Confidential

Responsibilities:

• Developed and build the Reports, Dashboards and deployed into Power BI Service
• Imported, reshaped and modeled the data
• Used various SSIS tasks such as Conditional Split, Derived Column, Look-Up that were used for Data validation Scrubbing, Data checks during Staging, before loading the data into the Data Warehouse.
• Created Power BI reports and visualizations
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Created App Workspaces and content packs to share your insights.
• Designed, built and tested SSAS Cubes on SQL Server 2008.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Designed drill through, drill down, linked, sub reports and parameterized reports utilizing SSRS .
• SSRS reports formatting by applying parameters, assigned default values and data types.
• Using ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Imported data from Azure and build the dashboards according to requirements
• Scheduled dashboards according to frequency (daily, weekly, monthly)
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Created Workspaces and share insights to business customers and partners
• Collaborated with Analysts and Knowledge Experts to design, build, and customize reporting packages
• Maintained and debugged existing Power BI reports
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014 and Flat files.
• Developed complex SQL Views, Common Table Expressions, and Temporary Tables
• Integrated custom visualization according to the business requirements document
• Migrated existing reports to Power BI.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Developing the reports using POWER BI, Power Pivot and SSRS and SSIS, SSAS and COSMOS.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosstabs and chart.
• Created date and string expressions in SSIS packages and passed them to create dynamic queries for SSIS source SQL commands.
• Developed reports in Power BI Desktop and deployed to both Power BI Report Server and Power BI Service
• Developed complex Data Analysis Expression Language (DAX) calculations, measures, report parameters, and report performance optimization
• Converted SQL Query code into DAX code for reports
• Designed complex reports and dashboards using Filters, Drill-down Reports and Sub-reports reports in Power BI Desktop.

Sql Developer/Power BI Developer

Confidential

Responsibilities:

• Developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Developed Integration Services (SSIS) packages for extracting data from Flat Files, XML files, CSV files, Excel files, SQL Server, and Transformed and Loaded the data to a data warehouse.
• Worked on SSAS, SSRS and SSIS and Cubes and Power BI for reports development
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• 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.
• Worked on SSAS, SSRS and SSIS and Cubes and Power BI for reports development
• Developed, designed and deployed matrix and tabular reports with drill-down and drill-through features using SSRS.
• Involved in creation and deployment of reports using SSRS and configuring the SQL Server Reporting Services.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• 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).
• Developed logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed SSIS jobs and scheduled packages using SQL server management studio for the daily load.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task
• Created Sub-Reports, Drill through, Drill down, Parameterized, Matrix reports, and Dashboards using SSRS.
• Deployed SSRS reports in Microsoft share point portal server.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Enhanced SSRS report performance using numerous techniques.
• Managed Report Subscriptions.
• Created and monitored Control-M jobs for SSIS packages
• Created stored procedures, triggers, user-defined functions, views handling business logic and functionality of various modules.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures
• Established referential integrity, data consistency, indexing and data cleanup procedures to maintain high quality data that can be used for reporting