Employment History 

• Power BI Developer

  COLABERRY INC

  August 2018 - Present

   Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server, SSIS and SSRS
   Gathered business requirements, definition and design of data source and data flows.
   Develop technical design specifications and code specifications to meet business requirements/specifications.
   Building, Maintaining SSIS package, Package Configuration, ETL Process, Package deployment. Enabling new packages with companies’ framework.
   Extracting data from Excel files, Flat files, OLE DB source, XML Files and so on and loading the data into different destinations. Within the data flow, I have utilized various sources, transformations, and destination to manage packages.
   Within the control flow, I have utilized Data Flow Task, Execute Task, Script Task to enhance package deployment, Sequence Container, ForEach and For loop Containers.
   Maintained and configured packages with checkpoints, breakpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
   Migration of data from and into SQL, Excel file and other applications using SSIS tools.
   Strong proficiency in the use of SQL for developing complex stored procedures, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
   Using SQL System Functions like Cast, Convert, Case Statements, Substring to change data type and length.
   Scheduling jobs to run automatically as needed and setting enablers.
   Designed, developed, and deployed SSRS reports that include parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports.
   Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
   Develop and maintain BI solutions using Power BI, including data models, reports, and dashboards.
   Design and develop data models that are optimized for reporting and visualization.

• Business Intelligence Reporting Developer

  24/7ai

  February 2017 - August 2018

   Responsible for defining and designing implementation of Power BI Reports and dashboards for Technology customer success.
   Strong knowledge in Power BI to import, shape and transform data for Business intelligence, visualize data, author reports schedule automated refreshes of report and create and share dashboards based on reports in power-bi desktop.
   Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
   Utilized Power BI (Power View) to create various analytical reports and dashboards that depict KPIs along with slicers and dicers enabling end-user to make filters.
   Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
   Created both dimensional & relational models like star-schema, and snowflake schema model using fact and dimension tables in Power Pivot.
   Created dashboards that provide aggregate information regarding daily departmental operations and performed ad hoc analysis to identify potential issues.
   Secured the reports using Row-Level Security on data in Power BI Desktop.
   Published Power BI reports in the required originations and made Power BI Dashboards available on the Web for clients and mobile apps.
   Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
   Advance with the DAX language including the manipulation of filter context, variables, and performance techniques.
   Involved in planning, defining, and designing databases based on business requirements.
   Served as a team member in Project Management and Software Development Life Cycle
   (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.
   Working with many complex SQL queries using joins and date functions to generate various reports.
   Designed, developed, and deployed SSRS reports that include parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports.
   Used Trend Lines Statistics and Log Axes, Groups hierarchies, time intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.
   Worked on Power BI dashboards using stacked bars, bar graphs, scattered plots, waterfall charts, geographical maps using show me functionality.