PROFESSIONAL SUMMARY:

• Experienced in Data Visualization development using Tableau, PowerBI to create complex, instinctive, and imaginative dashboards.
• Hands on experience in PowerBI Desktop, and Tableau Server.
• Experienced in designing, developing, deploying, and supporting business intelligence software, using both Waterfall and Agile development methodologies
• Strong learning and comprehension of SQL and capacity to write SQL queries.
• Involved in trouble shooting of performance issues which were associated with PowerBI reports.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices. Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

TECHNICAL SKILLS

• Data Analysis
• PowerBI, Tableau, SAP Business Objects, MS EXCEl, SAP BOXI
• Data Base
• SQL, Oracle, SQL Server, PL SQL
• Business Analysis
• MS Project, SharePoint, JIRA, ALM
• ETL
• Informatica
• Language
• C#, C++

PROFESSIONAL EXPERIENCE

Confidential, Illinois

Business Intelligence Developer

• Created PowerBI functional reports based on user requirements.
• Worked on parameters, filters, calculated fields, groups, etc. and developed interactive dashboards.
• Exercised on different data sources including database, excel and delimited files.
• Built dashboards for measures with forecast, trend line and reference lines.
• Strong understanding of advanced PowerBI features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions. Performed UNIT testing and help the UAT testing team to performing various testing scenarios.
• Resolved the JIRA tickets raised during the UAT testing.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in PowerBI desktop to validate and reconcile data.
• Utilized PowerBI server to publish and share the reports with the business users Involved in administration tasks such as setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Developed mappings that performed Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations.
• Wrote SQL queries to test the data in database using TOAD and validated the data.
• Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Helped users in creating and modifying reports and data visualization dashboards.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created drill down and navigation reports using the PowerBI Desktop.
• Utilized advance features of PowerBI.
• Extensively worked on QC to resolve the issues rose by Business promptly.

Confidential, Davie, Florida

Full - Stack Software Developer

Responsibilities:

• Developing a loan application software which can completely automate process of lending loan using MVC, razor views using CSHTML, web services, WEB APIs, WCF, JQuery, Bootstrap JSON, AJAX and XML, CSS, JavaScript, C# and also working on cross-platform app development using Xamarin
• Analyzed system and functional requirements for the user stories. Separated the stories down into logical tasks and identified technical requirements for each task.
• Used bootstrap templates for the responsive and cross-browser website.
• Used TDD (test driven development) methodology in the development approach.
• Mapping business requirements to application features and the most suited technology to provide business value
• Involved in requirement gathering both in functional and technical specifications.
• Involved in AGILE SCRUM environment and involved in meetings, Implementing User Stories etc.
• Built and consumed SOAP Web Services in .NET and Windows Communication Foundation (WCF) in web-based application.
• Planned, designed, and implemented application database code objects, such as stored procedures and views.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provided database coding to support business applications using Sybase T-SQL.
• Reviewed and developed data standards, data exchange and data sharing model

Confidential, Chicago, IL

Campus Intern ( Tableau developer/tester)

• Created, managed, deployed, and maintained templates on Azure for a project of Sempra Energy and Sempra Infrastructure.
• Developed workbooks from multiple data sources using Data Blending.
• Created and assisted users in Tableau dashboard development.
• Developed and audited SQL queries to validate data.
• Scheduled extract refresh for weekly and monthly reports.
• Worked extensively with advance analysis Actions, Calculations, Parameters, Maps, Trend Lines, Statistics and table calculations.
• Created Scatter Plots, Stacked Bars, Box, Bullet charts, Heat Maps, and Maps according to deliverable specifications.
• Performed user trainings in Tableau Desktop. Participated and organized various POC to promote the usage of Tableau.
• Published the dashboard on Tableau server. Resolved various performance issues.

Confidential, Illinois

Research and Teaching Assistant

• Formulated reports in Tableau desktop 9.3, 10.1 and Ms Excel.
• Created Tableau scorecards, dashboards using bar graphs, scattered plots and geographical maps.
• Experienced in providing Tableau public and tableau desktop training.
• Tutored courses like Data Structures, Information Technology Infrastructure, Computer Networks and System Security.
• Held office hours for getting knowledge of DS, IT Infrastructure, Network Securities and courses my supervisor teaches.
• Proctored exams.
• Assisted my professor with a large lecture class by teaching students in recitation, laboratory, or discussion sessions for courses like Data Structure.
• Did research on the topic "Big Data Challenges and their Solutions".
• Helped students in using Wireshark and with hands-on programming exercises in JAVA wherever they face difficulties.
• Graded assignments, projects and in-class exercises.
• Prepared and verified labs, quizzes and in-class exercises.

Confidential

Lead Software Developer

Responsibilities:

• Developed and tested Windows Phone & Windows Store applications.
• Worked with team of 7-10 people and involved in Full Project Life Cycle and Software development life cycle. (Requirement Analysis, Conceptual Data -Modeling, Database Building, Graphical User Interface Designing, Coding and Deployment) of a project through implementation and testing.
• Worked on Model-View-View-Model (MVVM)/Model-View-Controller (MVC) architecture.
• Extensive programming experience using ASP.NET, VB.NET, HTML, and XML.
• Developed resolution independent desktop applications using WPF
• Analyzed business, functional, and technical requirements to make sure project met expectations.
• Developed various applications for domains like Kids, Entertainment, Games, Financial Services, Business, Books & Reference, News, and Education.
• Worked on various devices and different versions of Windows OS.
• Created test cases to test web and windows application.
• Focused on coding, troubleshooting, complexity analysis, and debugging.
• Reviewed the codes and presented ideas for system improvements. Saved time by automating processes by writing automation scripts using VBScript and AutoIt.
• Worked with analysts, designers, product managers and staff, produced detailed specifications and wrote the program codes, tested the product in controlled, real situations before going live.
• Sideloaded line-of-business (LOB) Windows Store apps to a Windows image by using Windows PowerShell or the Deployment Image Servicing and Management (DISM) platform.
• Used Agile development methodology for all software applications.
• Developed cross-platform applications using PhoneGap.