SUMMARY

• Certified Microsoft BI developer with over 8+ years of extensive experience in Tableau, Power BI, database design, development and administration with MS SQL Server versions 2012, 2014, and 2016 using SSIS, SSAS and SSRS at Manufacturing and Tax organizations.
• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience with Business Intelligence Development Studio (BIDS)
• Experience working with AWS query
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience with SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Exposure to Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• 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.
• Demonstrated verbal and written communications skills with strong customer service orientation
• Positive attitude, ability to work in a team and ability to multi - task in a fast-paced environment with minimal supervision.

TECHNICAL SKILLS

MS Office: Windows 98,2000, XP, NT, 7, Vista, 10, 2010 MS Office Excel, Word, Outlook, PowerPoint, Snag ItDatabase Tools: SQL Server Management Studio (SSMS), SQL Profiler, Query Analyzer, DTS Designer, AWS

BI Tools: SQL Server Business Intelligence Development Studio, Power BI, QlikView/Qlik Sense, ER Studio, Visual Studio 2010 & 2015

Languages: T-SQL, MySQL

Operating systems: Windows Server 2008/2003/XP/Vista, Windows 7/8/10

ETL Tools: SQL Server Integration Services (SSIS), DTS, SQL Server Import/Export Wizard

Report Tools: SQL Server Reporting Services (SSRS)

Data Modeling: SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE

Confidential

Sr Data Engineer (TABLEAU / SQL / SSIS / SSRS )

RESPONSIBILITIES:

• Developed and built the Reports, Dashboards and deployed into Power BI Service
• Developed, maintained and supported end to end BI solutions for simple and complex projects.
• Created solutions for automated data integrations, querying and visualizations.
• Developed, designed and supported complex interactive Dashboards, Stories using features such as Data Blending, Joins, Custom SQL Queries, Calculations, Filters, Advance analysis Actions, Parameters, Sets, Groups etc.
• Built solution-driven dashboards by developing different visualizations like Crosstab's, Heat/Geo/Tree Maps, Dual Axis, Funnel Chart, Waterfall Chart, Pie/Bar Charts, Circle Views, Line/Area Charts, Donut Charts, Scatter Plots, Box Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created reports involving Level of Detail Expressions, Context Filters, Hierarchies, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's.
• Identified and decommissioned reporting and data processes that are inefficient for data management infrastructure to provide high quality and timely data.
• Actively participated in team meetings (standup, planning meeting, retrospectives) to utilize agile way of working.
• Worked with business users and other IT areas to collect, shape, and use functional/business requirements to then design and develop end-to-end solutions including ETL, governance, presentation, data mining.
• Actively engaged in business stakeholder requirements gathering sessions to understand, interpret and translate requirements into an effective technical solution
• Crafted and executed ad-hoc database queries and conduct analyses upon request for the business.
• Created and maintained ETL packages in warehousing projects working with multiple sources: Oracle, Excel, Flat files, etc.
• Effectively used different techniques to troubleshoot failed packages, as well implement processes for error handling.

Confidential

Sr BI Developer (POWER BI, SQL, SSIS, SSRS)

RESPONSIBILITIES:

• Created Power BI and Tableau reports and visualizations
• Maintained and debugged existing Power BI reports
• Migrated existing reports to Power BI
• 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
• Developed and build the Reports, Dashboards and deployed into Power BI Service
• 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.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created queries and data validation using AWS
• Connected Power BI reports using ODBC connexion to connect the Data lake to the report
• Conducted meetings with stakeholders for requirements gathering planning and implementation process of small to medium projects, I participated in the creation and review of the Business Requirements Document.
• I have been involved in the development and maintenance of Database Schema, Entity relationship diagrams, Data modeling. I developed tables, constraints, schemas, indexes, views, creating complex stored procedures, triggers, functions.
• Have developed and maintained complex SQL queries using joins, sub queries and correlated sub queries. Developed complex store procedure and user-defined functions.
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, XML files, CSV files, Access, Excel files, OLE DB to SQL Server, and load data to the Data Warehouse.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• 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, Subreports.
• Created complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Deployed the solutions on web server, involved in creating user security and roles in reporting services at both parent level and report level.