SUMMARY:

• I am a self - motivated and goal-oriented professional with can-do attitude committed to my employer.
• In this position, I would like to gain a better understanding and performance of positive business, administrative and managerial practices while working for this respected organization.

TECHNICAL SKILLS:

Databases: Oracle, SQL server, MySql, Acces

Data Governance: Infosphere

Programming Language: Java, Delphi, PHP.Net,VB

OS: Linux/Unix, Windows

ETL Tools: OWB, Informatica, Datastage, SSiS

BI skills: Data governance,Data modeling, Requirements gathering,KPI

SME for Industries: Healthcare (Claims,Provider,Pharmacy,Member,Capitation,Payeer), Banking (mortgage, retail, commercial, investment, operations)

Reporting tools: Obiee,Tableau,SAAS,SAP,Jasper reports, Crystal reports, SQL reporting/MDX/DMX services,Business Objects,QlikView,Microstrategy,Cognos

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Data Architect Senior Systems Consultant

• Hyperion reports conversion into Obiee
• Converted 200+ reports and 75 batch scheduler to Obiee ibots
• Upgraded claim codes ICD 9.0 to ICD 10 format
• Trained and hired 2-3 resources to complete project
• Sunset Hyperion tool
• Finance department report conversion
• Converted finance department data infrastructure from access to SQL server. Moved 10 years’ capitation of text files into Sql server DB.
• Rebuilt 50 reports from access into SSRS/SSIS/MDX reporting and trained local report writers on reports with documentation and work flows
• Helped develop the Affordable healthcare reporting for new program (Obama Care) with integration into developed data infrastructure
• EDI conversion project
• Develop Architecture for EDI out bound 834-837 files from QNXT system.
• Created 22 extracts with documentation via SSIS to be delivered t EDI file conversion process
• Trained 2-3 resources to take over maintenance of process
• Provider Department report conversion
• Document 80 reports and redevelop access report into MS reporting stack ssis/ssrs/mdx
• Managed state provider submission reports
• Developed 120 reports to manage audit process fro provider group (Qnxt and in-house system
• Hired and trained 3 resources to handle intake process, use existing data infrastructure to develop reports.
• Building extract for new 274 outbound interface for state of California

Confidential, Honolulu, HI

Data Architect Senior Systems Consultant

• Conversion of BI platforms from Business Objects to Oracle Business Intelligence.
• Built a project plan that would convert 30+ Business Objects Universes into 30+ Oracle business Intelligence subject areas.
• Lead a team of 7 as the technical lead to migrate 1000+ business objects reports into 1000+ oracle business intelligence reports.
• Designed repository for metadata and gathered information about data.
• Provided training to analytical users to use data warehouse.
• Designed the delivery of the reports into our report archiving system STARNET. Built a scheduler to fire OBI ibots when the data for the reports are ready. Built an error handling process to alert production support of any pending issues and send users email to inform them of the status of their reports.
• Delivered solution to 1000+ users
• Attributed to 500K cost savings.
• Built performance dashboard for personal banking, private client services and commercial banking division in OBIEE.
• Built project plan for the three division performance management dashboards
• Gathered requirements for these business areas by meeting with the units discussing strategic objectives, incentive plans and identifying systems that being used for day-to-day activities. Performed process modeling for each process identified in requirements gathering and identified efficiency by providing on-demand data.
• Lead a team of 10 and designed a solution of a data mart designed to provide data analysis and performance measurements that could lead into a balanced scorecard for each organization.
• Designed repository for metadata and gathered information about data.
• Provided training to analytical users to use data model.
• Designed and implemented 20+ dashboards for 300+ users. Each dashboard designed for each user role using the data identified to increase efficiency for each role by decreasing the process time with on-demand data.
• Used ODI/OWB to gather data from multiple systems for ETL.
• Provided revenue projections based on new/potential sales and portfolio retention/lose to identify potential issues and opportunities.
• Delivered solution to 300+ users.
• Attributed to 1-2M in increased revenue for each line of business.
• Built a profitability model for retail banking division in OBIEE.
• Built a project plan for profitability model for retail banking division
• Gathered requirements by identifying business problems, documenting process and associating to strategic objectives.
• Helped Identify improvements to process through process analysis
• Lead a team of 10 and designed a solution of a data mart designed to provide data analysis and performance measurements that could lead into a balanced scorecard for the retail organization.
• Used ODI/OWB to gather data from multiple systems for ETL.
• Designed repository for metadata and gathered information about data.
• Incorporated financial data into data model to “foot to financials” in order to project profitability.
• Provided training to analytical users to use data model.
• Delivered solution to 1000+ users
• Implemented first phase of enterprise wide data governance program
• Gathered information for MDM assessment for IBM.
• Install configure infospere
• Facilitate business glossary meetings with business units to define data governance

Confidential, Pasadena, CA

Sr. Programmer/Analyst

• Built a loan portfolio forecast model for risk management division.
• Built a project plan for loan portfolio forecast model data mart
• Gathered requirements by identifying business problems, documenting process and associating to strategic objectives.
• Built model by modeling payment schedules for 15 different loan programs and incorporating variables such as income level increase/decrease and home appraisal level increase/decrease. In corporate segmentation for loan risk grade, zip code, loan program to project risk levels and profitability margins.
• Designed repository for metadata and gathered information about data.
• Built data model using star schema. Built data mart using SQL server 2005 and ETL processes using SSIS process.
• Provided training and support to 10+ analytical users.
• Implemented CRM for retail banking division.
• Coded interface using PHP and AJAX java scripting.
• Implemented two upgrades on CRM.
• Built ETL process to migrate information from data warehouse to the CRM and custom process to support marketing target lists.
• Built ETL processes to export CRM data into data warehouse
• Designed and implemented cross-sell engine (java program) that took loan origination data and automatically processed data into target list in CRM.
• Delivered solution to 1000+ users
• Managed and maintained loan origination system for Mortgage department.
• Developed on Delphi/.net platform
• Added new loan programs into software.
• The system funded 2,000 mortgage loans a month.
• Designed repository for metadata and gathered information about data.
• The system help grow the loan portfolio by 4 billion in 4 years.
• Worked on continually optimizing process for Loan Origination System.
• Supported system for 500+ users

Confidential, Anaheim, CA

Sr. Programmer/Analyst

• Built CRM for organization.
• Implemented for 200+ users.
• Designed and fine-tuned lead generation process for the call center and mortgage officers.
• Resulted in generation of 200+ loans funded a month.
• Built custom java programs to import and export data from CRM