About Me
12+ experience in Power Bi, Tableau, Qlik Sense, SSRS, SQL Server, Oracle, BI Tools, SAP BO, VB6.0, Azure ADO for Agile process
... Show MoreSkills
Data & Analytics
Programming Language
Web Development
Development Tools
Mobile Apps
Others
Database
Operating System
Software Engineering
Portfolio Projects
Company
UIT- EDW Data Analytics and Visualizations
Role
Software Architect
Description
- Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
- Created Dax Queries to generated computed columns in Power BI.
- Generated computed tables in Power BI by using Dax.
- Involved in creating new stored procedures and optimizing existing queries and stored procedures.
- Created Azure Blob Storage for Import/Export data to/from .CSV File.
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
- Explore data in a Variety of ways and across multiple visualizations using Power BI
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
- Published reports and dashboards using Power BI.
Show More Show Less
Company
Datamart and Reporting
Role
Software Architect
Description
- Coordinate with the Application Management team/onsite leads to gather requirement.
- Requirement Analysis, Reviewing SRS, Writing Functional and Technical Design Docs.
- Preparing daily workloads for team & coordinating the daily allocation of work.
- Managing the team members for delivering high quality results with deadlines.
- Developing reusable components that can be used for all the repeated work.
- Designing Universes/Creating WEBI reports, Dashboards.
- Reviewing the code as a member of code review committee.
- Writing Release Notes for deployment into production.
Company
CIRT Xpress Base study V2, V3, V4, V5- including oncology concept
Role
Software Architect
Description
- Coordinate with the Project Management team/onsite leads to gather requirement.
- Requirement Analysis, Reviewing URS/SRS, Writing Functional and Technical Specs.
- Preparing daily workloads for team & coordinating the daily allocation of work.
- Managing the team members for delivering high quality results with deadlines.
- Developing reusable components that can be used for all the future studies.
- Designing Universes/Creating WEBI reports, Dashboards.
- Reviewing the code as a member of code review committee.
- Writing Release Notes for deployment into production.
Company
Watcher ( Time and Attendance Management )
Role
Software Architect
Description
In order to meet the increasing demand to automate HR and Admin activity of any organization, Watcher has been designed to ease their work pressure. Watcher comes with powerful MIS report to meet the organization’s various time and attendance related activity of all the employees. Watcher brings a culture of discipline in the employees to swipe the card when a person is entering or leaving the office for various reasons. Watcher is a multi user package and options are user password restricted for enhanced security. Manual entry option with user authorization for swipe discrepancy or forget to bring the ID card
Watcher supports
- Various shift timings including break shift according to the user requirement.
- Generation of various reports like Late In / Late Out / Extra Hours Worked / Leave / absent / Tour / Holiday/ Employee Individual movement / Muster report etc for any given date period.
- All the reports can be generated for All or Department wise or for Individual Employees.
- Shift Scheduling for the entire year for a Department / Section / Individual employees.