SUMMARY:

• Highly Skilled at Software Installation, upgrades, updates and hardware replacement. Also virus removal and perfomance tweaks. Well - versed in troubleshooting and repairing malfunctioning hardware and software. Devise innovative strategies to resolve recurring computer and network problems.
• Over 8+ Years of IT Experience in using Microsoft SQL Server IT Projects involving Business Intelligence (BI), Data Warehousing and Data Conversion in System Design, Development and Support of Microsoft SQL Server 2016/2014/2012/2008/ R2/2008 in Development, Data warehouse, Test and Production Environments on various business domains like Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Delivery Services.
• 2+ years' experience in a Helpdesk / IT Technician role
• A basic understanding of Windows migrations and troubleshooting.
• Installing and configuring Dell Hardware
• The ability to multi-task, punctual and flexibility with work hours
• Over 3 years of experience developing interactive dashboards using Power BI and Over 3 years of experience working with Tableau using 8.x/9.x/10.x/2019. x.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting MS SQL Server 2012/ 2008/2008 R2/2014.
• Experienced in using T-SQL for developing Stored Procedures, Triggers, Tables, Indexes, Views and User Defined Functions.
• Expertise in the usage of ETL tools including SSIS, DTS for large-scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2000/2005, DB2 and Oracle.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created and organized knowledge supply & knowledge supply Views, Dimensions, Cubes, Measures, Partitions, mistreatment SQL Server 2008/R2 Analysis Services. worked on all the Products in Power BI such as power BI Desktop, power BI pro, Power BI Report Server, Power BI Premium, Power BI Mobile.
• Expertise Knowledge in writing DAX Queries and MDX Queries.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites
• Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines etc.
• Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.
• Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
• Extensive experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
• Worked on Power BI and created reports and dashboards and published them on service.
• Experienced and Created 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 2012.
• Expertise working with SSAS Tabular model to produce reports in excel files using pivot tables.
• Excellent T-SQL programming skills and experience in the development of SSIS packages using BIDS, complex Stored Procedures, Configuration Files, Tables, Views, Triggers and Functions.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

WORK EXPERIENCE:

Agile Business Analyst / Senior Power BI Developer

Confidential

Responsibilities:

• Acted as the liaison between product and IT teams and stakeholders to understand customer demand for new features and new potential markets to move into.
• 2+ years' experience in a Helpdesk / IT Technician role
• A basic understanding of Windows migrations and troubleshooting.
• Installing and configuring Dell Hardware
• The ability to multi - task, punctual and flexibility with work hours
• Fostered more open communication between executive stakeholders, engineering and marketing resulting in an improvement in speed of the feature development life-cycle by 22% year over year.
• Developed gherkin user stories for a new product leading more focused marketing copy resulting in an ROI increase by 16%.
• Led a team of one full-time employee and three contracts.
• Managed the product backlogs and efficiency re-prioritized the backlog resulting in coming under budget.
• Created user story acceptance criteria to get buy-in from stakeholders.
• Connect to data
• Transform and prepare data
• Define business logic by adding Data Analysis Expressions (DAX) calculations
• Enforce data permissions with row-level security by adding roles
• Publish the model to Power BI
• Risk Managementexperience I have.
• Developed Rich looking Analytical Dashboards and Reports in Power BI for Business Executives to take better decision.
• Worked with Data Sources such as Amazon Redshift and Azure SQL Data Warehouse.
• Developed Power BI Custom Visual custom table bars with D3 Java Script and Type Script.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER, RANK.
• Created Drilldowns, Drill throughs and Bookmarks in Power BI Reports for easy navigation and storytelling.
• Worked in 'M' Language and Power Query for data cleansing in Power BI desktop query editor.
• Created and Managed Parameters in Power BI Desktop for changing the source with different environments such as development, test and production.
• Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.
• Developed Measures, Calculated Columns, Conditional Columns, Custom Columns in Power BI.
• Developed different types of reports such as Descriptive, Predictive, Prescriptive for end-users.
• Created and developed Dynamic and Static Row-Level-Security in Power BI Desktop according to the roles assigned to the users
• Created various visualizations such as Scatter Charts, Bubble chart, Slicers, Stacked Charts, Pie Charts, Donut Chart. Cards according to business requirements.
• Installed and Configured Power BI gateway (Personal/Enterprise) to schedule daily jobs to refresh reports/dashboards in Power BI Service.
• Wrote SQL Queries in Amazon Red shift & Azure SQL Data warehouse to test the data and verify the quality of data.
• Designed Data Models in Power Bi Designer by using schemas such as STAR, SNOWFLAKE and GALAXY.
• Handled Relationships in Power BI desktop such as MANY-MANY, ONE-MANY, MANY-ONE, ONE-ONE.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Embedded Power BI Reports in to our own .Net Application via REST API's for giving better access and flexibility to the end-users
• Worked with both the modes of connection in power bi such as Direct/Import Query Modes.
• Azure Data Lake/Data Factory
• Created, Managed, Scheduled Pipelines in Azure Data Factory.
• Worked with both the version in Azure Data Factory such as V1 & V2.
• Development level experience in Microsoft Azure providing data movement and scheduling functionality to cloud-based technologies such as Azure Blob Storage and Azure SQL Database.
• Wrote U-SQL Scripts to transform RAW Data in to meaningful data stores and data lakes.
• Created Copy activities and linked service for both source and destination Databases.
• Worked on all the different activities such as Data Movement, Data Transformation and Control activities.
• Installed and Configured Integration runtime for Data Source.
• Worked on backing up and restoring the Azure Data Factory V2.
• Used Poly base for loading data into the destination of copy activity.
• Perform on-site and preventive maintanance on petsonal computers and related peripherals. Evaluated technical issues, solved computer concerns, and troubleshot computer problems in efficent and courteous manner. Built custom computers to best serve the customer needs. Scheduled work and ordered parts. Estimated and invoiced repairs.

Environment: Power Bi Desktop, Power Bi pro, Azure Data Lake, Power BI Premium, Power BI Embedded

Power BI Developer

Confidential, Louisville, KY

Responsibilities:

• Generated periodic reports for Marketing, Logistics in Tesoro.
• Data Sources Used: SAP BW, Salesforce and Excel Files
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Hands-on working on dummy projects with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, and Histograms in Power BI.
• Developed Custom Visualization in Power Bi such as Fuel tank, Liquid fill Gauge, Charts.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required.
• Used Import Theme Concept such as custom theme to color the report in meaningful way using JSON files.
• Familiar with Apps workspaces and Embedding power bi reports from Power BI Service.
• Published Power Bi reports to end user via mobile and content packs.
• Worked on various Conditional formatting in power bi visuals to define the data in appropriate way.
• Designed trend by Year, Quarter and Month by using visuals such as Line & Stacked column chart, Line & Clustered column chart, Combo chart
• Showcased the Geography data in Power BI using visuals such as MAP, Field Map, Shape Map, ArcGIS and Globe Map.
• Worked with Longitude and Latitude data to plot the locations exactly and give insights of particular location to show the progress.
• Weekly Presentation of Power Bi Prototype and wireframe reports to business users and stake holders and also provide training how to use and navigate power bi report.
• Worked on Data Cleansing Part in Power BI desktop using concepts such as, Merge Columns, Merge Queries with necessary joins, Pivot, Unpivot and Transpose columns and rows in query editor
• Created the KPI to show the difference between actual, budget and forecast data using visuals such as DUAL KPI, KPI and Power KPI.
• Created and Presented Power point presentation to business users on Prototype and Wireframe of Power bi reports visually every week.
• Created Several User Roles and Groups to the end -user and provided row level security to them
• Analyzed all the SAP BW data dimensions, Measures and created data dictionary for all the data elements needed for report.
• Worked on Type script, D3 Java script, html, CSS and developed custom visualization in Power BI.
• Created KPI, Gauges, Clustered column chart, Slicers for better understanding of the report.
• Developed Operational Reports for the Marketing in Tesoro Corporation such as daily reports

Environment: Power Bi Desktop, Power Bi pro, office 365, SAP BW, Salesforce, MS Excel, txt file, SAP HANA

ETL/Power BI/ Tableau Developer

Confidential

Responsibilities:

• Developed complex stored procedures and views for generating reports like drill-down, parameterized using SSRS.
• Developed SSIS packages using various Tasks such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Analyzed existing SSIS packages to improve performance.
• Applied hypothesis testing and advanced statistical methods in R (clustering, random forest, regressions) to Deployed SSRS reports using report server and responsible for monitoring and tuning reports.
• Developed reports in Tableau by performing visual analytics by inter connecting with R environment for in depth analysis.
• Designed interactive dashboards in Power BI by creating calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Provided security for Power bi data sets in Power bi service among organizational content pack.
• Worked on all types of transformations that are available in Power bi query editor.
• Created stored procedures and SQL queries to pull data into power pivot.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published.

Environment: MS SQL Server, SSIS, SSRS, Crystal Reports, R, Tableau, Power BI

Tableau Developer/BI Analyst

Confidential, Minnetonka, MN

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Involved in the complete Life cycle of the Project and in the data analysis process.
• Gather the various requirement matrices from the business analysts.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Created technical designs for the various reporting requirements.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Helped end users with integration of their front-end application with tableau server by establishing trusted authentication.
• Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Maintained Test Log and wrote Test Evaluation, Summary Reports.
• Setup and Deployed tableau server to publish dashboard to a central location for portal integration
• Implemented row level security and windows AD authentication for Tableau reports
• Worked with the tableau community to extensive test the tableau 8 beta version

Environment: Tableau 8.x (Desktop/Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, JIRA Microsoft Office Suite (Word, Excel, Power Point, Visio).

ETL Informatica Developer

Confidential

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Translated business requirements into Informatica mappings/workflows.
• Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Created UNIX scripts for automation of ETL process.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Trained on building Conceptual, Logical and Physical data model
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Worked with DBA to identify source and target bottle necks.
• Involved in bug fixing and Debugged the issues during QA level.

Environment: Informatica Power Center8.6.1/9.1, Oracle 10g, PL/SQL, Business Objects XIR2, Toad, Linux, UNIX Shell Scripts.

SQL Server/MS BI Developer

Confidential

Responsibilities:

• Experience in Creating, Configuring, and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS)
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Dimensional modeling.
• Knowledge in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS)
• Created Tabular, Matrix, Chart, Drilldown Reports, Parameterized, Cascading reports according to business requirement and deployed the generated reports directly on the client's workstation.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS
• Excellent T-SQL skills including Stored Procedures, Indexed Views, User Defined Functions, Common Table Expressions, and Triggers.
• Involved in Huge data migrations, transfers using utilities like SQL Server Integration Services (SSIS)

Environment: s: MS SQL Server 2008/2008 R2/2012, SSIS, SSRS, T-SQL, Windows Server 2008, MS Excel, and MS Office, SQL Server Management Studio 2012, DOT NET Framework 4.5, XML.