Sr. Financial Analyst Resume
SUMMARY:
- Business Intelligence (BI) developer with focus on Data Visualization with Tableau.
- Extensive knowledge of Oracle and SQL Server.
- Experienced in Health Care & Insurance industries
- Certified Tableau Developer
- Certified Oracle DBA and Developer
- Hands on with SAS Enterprise Guide. (reporting, data extraction)
- Knowledgeable in DotNet Framework
- Enjoys working in a team.
TECHNICAL SKILLS:
- Create, publish and share dashboards
- Create visualizations with Filters, Params, Sets
- Use of Data Joining & Blending
- Create Cross Tabs, Pie and Bar charts
- Create Geographic maps, Heat maps, Tree maps
- Report scheduling using Tableau server
- Install, upgrade, tune Oracle DB
- Perform maintenance: Backup, recovery, clone
- Define DB schema and other DB objects
- SQL Trace, TKPROF, Pinning
- Integrated with Oracle Finance (Accounts Payable, General Ledger)
- PROC REPORT, PROC SQL, PROC FREQ, PROC TRANSPOSE and PROC PRINT
- Define schema, T - SQL, Data migration
- C#, IIS, ASP.NET, Visual Studio, TFS
EMPLOYMENT HISTORY:
Confidential
Sr. Financial Analyst
Tools and Technologies: SQL Server Management Studio, MS Access, SSIS, Microsoft Visual Studio, Tableau Visualization
Responsibilities
- Gather data for Health exchange members from QNXT, Wex Healthcheck, 834 files.
- Daily reconciliation of of QNXT system and Wex health.
- Working on Monthly binder cancel, grace period Process, termination of member and binder override.
- Create a report from QNXT system using SQL Server to find discrepancies and present the outcome into Excel Sheet.
- Ensure QNXT, Exchange Point and Reconciliation tables are synchronized; if there is discrepancies, bring them to the manager attention, and report to MIU team or appropriate team for correction.
- Validate enrolments and create a report from 834 file to MPSS-AR based on requests.
- Work with stakeholders to prioritize the requirements.
- Design, develop and test the binder cancel and grace period Process.
- Collaborate within the team to enforce process adherence.
- Performs other analysis, documentation, and programming tasks as required by the Manager
Confidential
Programmer Analyst
Tools and Technologies: Tableau Desktop, Tableau Server, ASP.NET, Oracle, SQL Server, TFS, Visual Studio, TOAD, Ms Access
Responsibilities
- Coordinate with business leads in Patient Care to gather requirements.
- Analyse business requirements and translate them to system requirements.
- Work with stakeholders to prioritize the requirements.
- Design, develop and test the system requirements.
- Collaborate within the team to enforce process adherence.
Confidential
Oracle DBA
Tools and Technologies: ORACLE 11g, AIX4.3, OEM, DB2, Performance and Troubleshooting, Toad, SQL Developer
Responsibilities
- Setup, tune Oracle DB
- Backup & restoration management
- Data modelling, and creation of DB objects
- Create Stored Procedures, Functions
- Query optimization using SQL Trace, TKPROF, Pinning
- Create and optimize reports
Confidential
Oracle Developer
Tools and Technologies: ORACLE 11g, AIX4.3, OEM,DB2, RAC, OEM, MODELING, TOAD, PL/SQL Developer, ASP.NET, Visual Studio
Responsibilities
- Coordinate Technical Architect and Biz teams to analyse requirements.
- Database setup, tuning, backup management and restoration
- Create stored procedures, functions, triggers to automate admin processes.
- Migrate data from Oracle 10i to 11i and from application to reporting instance.
- Create regulatory reports using Oracle Reports for HR & Finance.
- Replicated tables, views and triggers using SNAPSHOT and MATERIALIZED VIEWS.
Confidential
Developer
Tools and Technologies: ASP.NET, Visual Studio, VSS, TOAD, SQL Developer
Responsibilities
- Analyse requirements to create technical design
- Work with Technical Architect to get approval.
- Develop stored procedures, functions and other DB objects.
- Write ASP.NET & C# code to interface with the DB objects.
- Unit test the integration to ensure quality. Support UAT by fixing defects.