SUMMARY

• Experience in Microsoft BI Tools (SSIS/SSAS/Power BI) and T - SQL.
• Experience in Power BI, Tableau and other data visualization tools in Business Intelligence.
• Experience in T-SQL, Creating, developing new database objects by like Tables, Views, Indexes.
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union .
• Expertise in Visualizing and Analyzing Data using Power BI with cloud based applications.
• Worked on Azure cloud database servers, ADW and Blob Storage for ETL use. Also have knowledge on External and Internal tables along with Azure ADF job scheduling.
• Experience with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
• Expert in creating Effective Reports using visualizations and Dashboards using Power BI.
• Experience in creating custom visual using R Script.
• Experience in creating measures and calculated columns using DAX in Power BI.
• Good Experience in transforming and cleansing the data in Power Query.
• Expert in implementing Row level security (RLS) for user authentication in Power BI.
• Good knowledge in Power BI Embedded functionality to embed Power BI reports into their own web apps.
• Experience in working with Larger Datasets using Power BI premium.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Experienced and passionate developer implementing new emerging Microsoft-related technologies like PowerApps.
• Experience in Implementing Self Service BI Model.
• Migrated reports from Tableau, OBIEE to Power BI
• Self-motivated and possess ability for critical thinking, analysis, team-oriented, technically motivated and creative, good interpersonal and communication skills. User oriented with a desire to learn client and business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Databases: MS SQL Server, ORACLE, MS Access, DB2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, Visual Studio, SSDT

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: Power BI, SSRS, Excel, Tableau.

Programming: T-SQL, PL/SQL, DAX, MDX, Power Query M.

Operating Systems: Windows 7, Windows 10, MAC.

PROFESSIONAL EXPERIENCE

Confidential

PowerBI Developer / Business Analyst

Responsibilities:

• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Worked with the use of Data Modeling Standards for all projects requiring a standard means of defining and analyzing data within an organization, to manage data as a resource, for the integration of information systems, for designing Databases/Data Warehouses (Azure).
• SSIS packages to update tables with monthly data and automated it through scheduled jobs for the beginning of every month.
• Designed SSIS packages, which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.
• Developed packages in SSIS with error handling.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Used M language to create Custom, Conditional columns and Append files from SP folder in Power Query.
• Created different types of visualizations viz., geographical visualizations after slicing and dicing the account operations related data to analyze financial data across different locations.
• Published many reports and visualizations created to the Power BI service and thereby develop dashboards.
• Experienced in working with DAX commands to pull up more calculated data out of the tables.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Created SQL Joins, sub-queries and other SQL code to implement business rules.
• Performance tuning, and optimization of procedures and queries.
• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, and Lookup Table.
• Created a form with Power Apps to users to enter Budget data every month.
• Created a PowerApps app to gather requirements from the users related to access which in turn helped us to implement Row Level Security (RLS) and storing the data in the database.
• Integrated a PowerApps app with Power BI which served as a ticketing system to gather anomalies related to data, visualization (A form which takes screenshot and inputs from the user)
• Created Paginated reports using Power BI builder and published to Power BI Service, which helped users to see data in form of data tables and easy exporting of data.
• As part of requirement, migrated various tableau reports to Power BI.
• Developed custom visual using R Script as per the requirement.
• Utilized Performance analyzer to analyze the performance of DAX measures, visuals and query that is running the measures.
• Utilized DAX studio to improve the performance of the measures.

Confidential

SQL Power BI Developer / Analyst

Responsibilities:

• Involved in gathering the user requirements.
• Performed tasks like execute SQL task, data flow task, file system task for ETL process.
• Worked Extensively on ETL process using SSIS package.
• Used all types of container tasks such as for loop, for each loop and sequence container in SSIS.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Coordinated with DBA in creating and managing tables, indexes, triggers and privileges.
• Used Power BI to OBIEE BI Connector to directly connect from Power BI to OBIEE reports and subject areas, While migrating reports
• Designed production and sales dashboard for Sales and procurement departments using Power BI.
• Using Microsoft Power BI for data visualization.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Published reports and dashboards to the Power BI service.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.
• Used various sources to pull data into Power BI such as SQL Server, SharePoint, Excel, etc.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on transformations that are available in Power BI query editor.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Shared the dashboards among multiple users in the group.
• Implemented row level security by restricting the users for the data access.
• Created Content packs that package up a dashboard, report, and dataset to share with users.
• Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).
• Used agile development Methodology.

Environment: SQL SERVER 2005/2008, Power BI, T-SQL, SSIS (2005), SSRS (2005), Business Objects, Windows Server 2008, Visual Studio.

Confidential

Junior SQL Developer

Responsibilities:

• Involved in all the phases of software development life cycle (SDLC) including requirement gathering and analysis, design, implementation, testing, deployment, and maintenance, related to various database projects.
• Developed Data warehouse logical and physical data model using Erwin tool.
• Built Star Schema data model DW.
• Built SSIS packages to Load data from source systems to Data warehouse.
• Built SSIS packages for dimension and fact tables.
• Used staging tables to cleanse the data and, also to transform data wherever required.
• Used For each loop container to load multiple files at a time into the table and archived the loaded files.
• Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server.

Environment: SQL SERVER 2008 R2, Microsoft Reporting Services, Toad, T-SQL, SSIS (2012), SSRS (2012), Business Objects, Windows Server 2008, Visual Studio.