We provide IT Staff Augmentation Services!

Sr. Financial Analyst Resume

3.00/5 (Submit Your Rating)

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.

We'd love your feedback!