We provide IT Staff Augmentation Services!

Software Programmer Resume

SUMMARY

  • I have extensive knowledge of OBIEE 11g and 12c Presentation Services and Repository Administration Tool with familiarity of Fusion Middleware Enterprise Manager (EM) and Console.
  • I have wide compressive understanding of database, data modeling and design.
  • Over the years, I have held positions of System Administrator, Software Engineer/SME, Senior Developer, System Analyst, Business Analyst and Data Analyst.

TECHNICAL SKILLS

Business Intelligence: OBIEE 10g,11g & 12c, Publisher 11g, Micro Strategy, Hyperion, Discover, WEBFOCUS Studio and MRE, Tableau

Oracle Application: FMW Weblogic server 11g Enterprise Manager and Web Console, SQL Developer, Oracle MapBuilder, Endeca, ODI, Informatica PowerCenter, VMware Workstation, Oracle VirtualBox

Databases: Oracle 9i, 10g, 11g, 12g, MSSQL Server

Programming Languages: SQL, PL/SQL, Unix

Operating Systems: MS Windows, Linux

Other Software: ERWIN, Jenkins, SVN, GITHUB, TOAD, SharePoint, JIRA, QC

EXPERIENCE SUMMARY

Confidential

Software Programmer

Responsibilities:

  • Supported O&M tier 2 intake request consisting of user’s access and catalog permissions, tier 3 tickets encompassing general inquires of application’s functionality and technical report consulting.
  • Build Dashboard, Reports, Prompts, KPI’s, Dimensional Hierarchies, Action links and custom calculated fields using analytics.
  • Collaborated with product owners and scrum lead to gather business and technical requirements.
  • Performed data integrity, data discovery and data profiling of several USCIS source systems.
  • Design and code SQL for custom reports by using direct database connect.
  • Maintained and developed repository schematic model of star and snowflake schemas.
  • Modernized existing repository by following OBIEE best practices.
  • Applied row level security by user session variables and identity manager.
  • Created application roles using EM, Console, Repository and Analytics.
  • Assisted in streamlining deployment process which entails automation of repository merge and incorporating data encryption repository using DBMS OBFUSCATION toolkit.
  • Supported ETL efforts of source to target of Operation Data Stores (ODS) by using Informatica Power Center.
  • Create DML scripts to support ETL developers and DBA’s.
  • Experience in Agile and Kanban mythology using JIRA.
  • Writes and revised training instructional documentation and Interface Control Agreement (ICA) Technical Specs for the project.
  • Supported training team of teaching OBIEE 11g and 12c.
  • Trained newly hire team members.

Confidential

System Analyst

Responsibilities:

  • Prepared local installations for OBIEE 11g, RCU and Oracle Database 11g.
  • Build repositories and maintained metadata.
  • Created and maintained Web Catalogs such as Answers, Dashboard, Dimensional Hierarchies, Action Framework and prompts.
  • Experienced 3 - way merge and in charge of migration of OBIEE RPD and Catalog
  • Administrator to EM and Weblogic Console.
  • Supported in systems design document of ODI from source to staging to target mapping and transformation document and responsibility includes ODI development.
  • Performed performance tuning and maintenance.
  • Supported database security for VPD (FGAC).
  • Maintained and managed access
  • Performed data validation.
  • Prepared technical documents.
Confidential

Sr. Consultant

Responsibilities:

  • Created custom reports in Oracle 11g Publisher, Analysis Editor and Dashboard for Centers for Medicare & Medicaid Services (CMS) DECC Program
  • Build Repositories
  • Created reports that which contained visual charts, graphs as well as geographic information using MapViewer
  • Monitored and tracked progress of report defect tickets in QC
  • Assisted in Enterprise Service Development team projects such as designing and building repository in Multiple User Development Environment (MUDE)
  • Produced enterprise level reports to demo to the clients
  • Supported functional areas including putting together Deployment Plan documents, Unit Testing documents for Quality Assurance, submitting Change Request for business requirements, System Design documents and conducted Peer Reviews
  • Managed User Access FMW Console.
Confidential

Sr. Developer

Responsibilities:

  • OBIEE Frontend Developer of the enhancement of decision support system for the Confidential ARMY.
  • Worked closely with backend developers to create tables and views base on client’s requirement.
  • Created custom reports in Answers/Dashboards application and develop OBIEE publisher reports using Office Word RTF template
  • Modified existing answer reports and dashboard based on new client’s requirement
  • Wrote SQL queries against the Oracle 10G/11G database through OBIEE Direct Request app.
  • Used Web design software to create OBIEE Narrative and Text reports
  • Installed Oracle database 10g/11g along with OBIEE 10g/11g on local sandbox
  • Provided Oracle development support such as execute procedures/packages in TOAD or SQL
  • Developed ETL application, cross trained OBIEE users to build and create reports, backup the OBIEE Repository and Web Catalog
  • Tested applications as required, created user accounts and ensured that all user privileges and password and role based maintenance OBIEE repositories are kept up to date
  • Served as a WEBFOCUS Administrator/Software Developer for the Confidential Army Human Resource Command.
  • Installed and configured WEBFOCUS Developer Studio Client on a Windows environment machine
  • Designed reports, coded FOCUS coding, benchmark testing, debugging and documentation of WEBFOCUS reports
  • Used WEBFOCUS Developer Studio to modify and create report programs, etc. conforming to business requirement.
  • Scheduled WEBFOCUS reports in Managed Report Environment (MRE) Report Caster
  • Crossed trained users to make FOCUS reports in Developer Studio Client and Managed Reporting Environment.
  • Performed System and Integration Testing and data validation for FOCUS reports
  • Wrote shell scripts to parse and load MRE for WEBFOCUS reports data into analysis tables
  • Exposed to writing SQL*Loader scripts to load WEBFOCUS data to Oracle table
  • Converted WEBFOCUS queries to SQL and document generic conversion instructions
  • Converted WEBFOCUS reports to OBIEE reports
Confidential,

Systems Analyst

Responsibilities:

  • Provided support in data analysis and production level coding using WEBFOCUS application such as MRE Report Assistance and Report Caster Scheduler
  • Modified WEBFOCUS queries process which sources data for Finance group
  • Migrated WEBFOCUS reports from v. 4.3.5 to v.7.6.x
  • Provided production support for Telco Bill Receipt and Payments Database Systems
  • Performed daily loads of mechanized billing invoices via FTP and NDM, email attachments, tape reels and CD’s to the mainframe
  • Created Telco Audit Report for Audit Centers to assist in daily research of missing invoice loads
  • Assisted Local Exchange Carriers (LEC) in setting up NDM transmission and SFTP transfer mechanized invoices
  • Tested, documented and implemented new or enhanced application functionality
  • Served as liaison between Atlanta, Chicago, Tulsa and Ashburn Audit Centers and the Local Exchange Carriers (LEC)
  • Implemented System Development Life Cycle to improve business process in automating missing invoice notices
  • Supported accounts payable and disbursement department
  • Reconciled expenses create and generate variance and accrual reports

Hire Now