Oracle ERP
An Accounting/IT professional with over nine (9) years' experience in various domains such as Finance, Aviation and Healthcare. An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Thorough working knowledge of HIPAA policies and procedures. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Able to perform multiple duties in business analysis, project or program management, and functional leadership. A wonderful team player who can relate and work efficiently with diverse groups.
• Worked closely with the project team to normalize the data and availability for visualization and supported the project by training the team on the use of the dashboards.
• Created Tableau Dashboards that meet accessibility and requirements as applicable and as a design principle.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by, and OLAP (Online Analytical Functions). • Created mock-up layout design and wireframes using visualization features available in tableau and other internally provided tools.
• Developed ETL scripts in Python using Pandas library to get data from one database table and insert, update the resultant data to another database table.
• Define and implement routine reports (daily/weekly / monthly) of key performance metrics and action item alerts as well as on an ad hoc basis to drive results.
• Work directly with our provider partners and other internal units in designing and implanting evolutionary changes.
• Demonstrated a high level of expertise with healthcare data and healthcare informatics with solid understanding of HIPPA compliance and GPO Audits.
• Ad-hoc data extraction through queries in SQL, Excel, SAS, Tableau report, or PDF.
RDBMS
Oracle ERP
SAP ERP
Radixx
SAGE 100 ERP
QuickBooks
Tally
Business Intelligence Tool
Tableau, Power BI, Excel and PowerPivot, SSRS
Databases:
MS SQL SERVER
2008/2012/2016/2018, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g
Proficient in Microsoft Office
(Excel, Access, Word, and PowerPoint)
Operating Systems
(Win XP, Vista, 7, Windows Server 2008,
2010(X32, X64),)
ETL / Other Tools SSIS,
Erwin Data Modeler, ER Assistant, ALTERYX, Informatica
Querying Tool
0SQL Management Studio 2008/2012/2016/2018,
SQL Plus, SQL Developer, Python 3.9.6, SAS
Business Intelligence Tool
Tableau, Power BI, Excel and PowerPivot, SSRS, Jira
Databases:
MS SQL SERVER
2008/2012/2016/2018, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g
Proficient in Microsoft Office
(Excel, Access, Word, and PowerPoint)
Operating Systems
(Win XP, Vista, 7, Windows Server 2008, 2010(X32, X64),)
ETL / Other Tools,
SSIS , Erwin Data Modeler, ER Assistant, ALTERYX, Informatica,Power Query
Querying Tool
0SQL Management Studio 2008/2012/2016/2018, SQL Plus, SQL Developer, Python 3.9.6, SAS
Programming Language
SAS, TSQL, PL-SQL, Python, Scala