SUMMARY

• Over 8+ years of experience in Designing, Developing, Administering, Supporting Business Intelligence applications such as Tableau, Power BI.
• Experience in Database Design, Development, and maintenance of database applications on SQL Server 2005/2008 R2/2012/2016 in OLTP/OLAP/BI environment.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Capable of handling responsibilities independently as well as a proactive team member.
• Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2005/2008 R2/2012/2016 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Expert in designing ETL data flows using SSIS. Creating mappings, workflows to extract data from SQL Server and Data Migration and Transformation from Oracle, Access, Excel Sheets using SQL Server SSIS.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Experience in creating jobs, SQL Mail Agent, Alerts and scheduling SSIS Packages.
• Experience in transforming data from DB2 to SQL Server.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management such as Migrating DTS packages using SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling such as Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SSAS
• Good experience in Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Expert in Tableau, Power BI Dashboard Development and publishing them to respective server, Cloud.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Implemented data blending technique on data sources like Oracle, Teradata, SAS, SQL, DB2.
• Experience in Production and Technical Support activities and managing production rollouts
• Identifying and removing bottlenecksin order to improve the performance of dashboards and reports.
• Worked on implementing Modern Analytics toolkit using Amazon Redshift and Tableau Software which form a Data warehousing and analytics solution that allows users to analyze datasets.
• Experience in writing complex SQL queries to perform End - to-End ETL validations and support Ad-hoc business requests.

TECHNICAL SKILLS

ETL Tools: Microsoft SQL Server Integrated Services

Data Visualization Tools: Tableau, Power BI, Einstein Analytics, SSRS, Report Builder

Database: SQL, Oracle, DB2, Teradata, T-SQL

Database GUI: Teradata, SQL Server, SQL Developer, DB2

Methodologies: Agile, Waterfall

Programming Languages: SQL, Python, R, PL/SQL, HTML, Core Java

IDE’s: Eclipse, jGrasp, PyCharm, Dream weaver, Rational Rose

Framework: Hadoop, Django, Flask

Software Packages: Microsoft Visio

Operating Systems: Windows and Mac

PROFESSIONAL EXPERIENCE

Lead BI Developer

Confidential

Responsibilities:

• Designed, developed, modified, and debugged programs.
• Responsible for designing, developing, and maintaining reports as per the business requirements.
• Importing data from different data sources like SAP BW, Azure Analysis Service, Snowflake, SharePoint, and Excel.
• Hands on experience with different data import modes in Power BI like Import, Live connection, and Direct Query.
• Creating interactive reports by using different visualizations like table, matrix, line, Line and stacked column, Slicers, clustered column charts in Power BI Desktop.
• Created calculated measures and calculated columns using DAX Queries.
• Experience on creating different levels of filters like visual level, page level, and report level filters.
• Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions & Interactions in Power BI.
• Experience with composite models, Data Modelling and Power Query editor like appending queries, splitting data into separate columns, adding columns, Advance editor, creating groups etc.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Performing unit testing on created reports to get desired output from the data.
• Published reports into required Workspaces.
• Created workspaces for different environments and share it with Business users and Team Members.
• Maintained existing applications and designed and delivered new applications.
• Wrote and optimized SQL statements to assist business intelligence practices.
• Write Custom SQLbi queries to pull data into tableau/ Power BI.
• Supported Power BI reports, Power BI dataflows on Service, Tableau reports on tableau Server and Cognos reports.
• Performance tuning the extract run time and report load time.
• Automate the monitoring of tableau reports update status and extract status.
• Automated alerts from tableau server using pager duty application.
• Automated tableau server backup using YAML file.
• Experience using gateways to connect to on premise data base.
• As a tableau server administrator performed tableau server upgrades to various versions.
• Responsible for License renewals, refresh and providing access to users on tableau server.

Environment: SQL Server 2016/2008, T-SQL, PL/SQL, SSIS, SSAS, SSRS, Cognos, Tableau 2018.2/ 2019.1/2020.2.2/ 2021.1.8 /2022.1.8 , Oracle 11g, Einstein Analytics, Power BI, Power BI Report Builder, Power BI Service, Python.

Sr BI/Report Developer

Confidential - Charlotte, NC

Responsibilities:

• Maintained proficiency with latest database technologies.
• Migrated DTS packages from SQL Server and modified Stored Procedures to comply with the current versions of SQL Server.
• Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements.
• Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
• Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.
• Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.
• Created and Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements instead of Cursors in T-SQL
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created and analyzed reporting within Tableau based on the business requirement.
• Designing and developing Supply Chain data models by integrating data from multiple sources
• Developing Inventory Control dashboards using Tableau to analyze vendor defects
• Writing SQL queries solved many critical requirements by digging the required data.
• Developing Tableau interactive dashboards to monitor KPIs related to Overages, Shortages and Damages etc.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.

Environment: Power BI Desktop, Power BI Service, Snowflake, DAX, QlikView, DB2, Netezza, Excel, Rally, Window 7

Power BI Developer

Confidential - Weston, FL

Responsibilities:

• Responsible for designing, developing, and maintaining reports as per the business requirements.
• Installing and upgrading latest versions of Power BI Desktop.
• Imported data from different data sources by using import & direct query options.
• Creating interactive reports by using different visualizations like bar, pie, card, table, matrix, line charts in Power BI Desktop.
• Created calculated measures and calculated columns using DAX Queries to fulfill client perspectives, executing DAX queries based on requirement of data.
• Retrieve data from snowflake using direct query option in Power BI.
• Worked on different levels of filters like visual level, page level, report level filters.
• Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions, Interactions.
• Hand-on experience on creating Row Level Securities in Power BI.
• Created drill through pages as per user requirements.
• Publishing Power BI reports into Power BI service and sharing with colleagues and business users.
• Responsible for scheduling data based on different timeslots like daily, weekly, monthly, and monitoring the reports based on scheduled time.
• Export reports to PDF format and Power BI Templates.
• Re-created QlikView dashboards into Power BI for General Insurance Application
• Worked with the database like Netezza and DB2.

Environment: Power BI Desktop, Power BI Service, SQL Server, Azure SQL DB, SharePoint, Excel, DAX, python, Window 10

SQL/ Tableau Developer

Confidential

Responsibilities:

• Maintained proficiency with latest database technologies.
• Migrated DTS packages from SQL Server and modified Stored Procedures to comply with the current versions of SQL Server.
• Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements.
• Worked closely with both the offshore Application and Database teams to regularly monitor system for bottlenecks and implement appropriate solutions.
• Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.
• Worked extensively with the Business Analyst using the Rally to create user stories based on the business requirements.
• Created and Modified Stored Procedures, Triggers, Tables, Views and making use of Merge Statements instead of Cursors in T-SQL
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created and analyzed reporting within Tableau based on the business requirement.
• Designing and developing Supply Chain data models by integrating data from multiple sources
• Developing Inventory Control dashboards using Tableau to analyze vendor defects
• Writing SQL queries solved many critical requirements by digging the required data.
• Developing Tableau interactive dashboards to monitor KPIs related to Overages, Shortages and Damages etc.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems.

Environment: Tableau Desktop, Tableau Server, SQL Server, T-SQL, DB2, MS Excel.