Sr. BI Developer Resume Torrance, CA - Hire IT People

SUMMARY

Highly motivated BI professional with 10+ years of progressive experience in developing strong business information solutions to support business management decisions using BI tools (SSMS, SSRS, SSIS, SSAS), data analysis (SQL, MS Access, Excel, Statistica) and application development (VBA, VB.Net, C#). My strong blend of technical, communication and presentation skills enable me to quickly build rapport with internal and external business partners.

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

Sr. BI Developer

Designed and developed several dashboards and OLAP cubes that serve different use cases. Examples are:
Member Retention cube: primary tool used by Operation leaders to monitor member attrition at different levels of geography;
MedOps dashboard and cube: consolidates KPIs across multiple clinical and operational categories for all owned and IPA medical sites; Provides decision makers a single - source for financial, utilization and Quality metrics that includes trending and visualization.
GL/Cost of Care cube: finance-centric cubes to support financial analysis; distilled complex allocation of financial, encounter and capitated data into elegant and simple information for ease-of-use by financial analysts and regional finance leaders
Partnered with executive sponsors, medical directors, data scientists and operation leaders in all phases of project development; serves as an intermediary who can translate business desires for functionality into technical plans and, conversely, technical constraints into business reality.
Supported Finance department in developing Provider P&L analysis and in development of budget models.

Confidential, Los Angeles, CA

Sr. Risk and Pricing Analyst

Researched and analyzed key risk factors which directly affect expected and realized losses related to auto portfolio acquisitions. Designed, developed, automated, and maintained a wide variety of BIRT and SSRS reports in support of all aspects of portfolio acquisition
Performed complex ad-hoc T-SQL/SQL queries when immediate access to financial datasets was required. Integrated data from MySQL and SQL Server databases, including historical data from flat files and spreadsheets, using SSIS and MS Access.
Collaborated with department director and manager to develop a new portfolio verification system to increase productivity and maximize profitability; acted as both business analyst and developer responsible for gathering business requirements and documentation, and development of the application; application was released for production use in less than (2) months of project inception.
Extensively involved in the creation of a new statistical model for portfolio pricing; performed data preparation, correlation analysis and development of cash flow analysis to determine expected loss and ROI

Confidential, Cypress, CA

Business Analyst/Application Developer

Acted as a liaison between business operations units and IT in supporting IT initiatives across corporate trust units in CA, PA and TX. Assessed business needs and created business requirement documents for system improvements and system issue resolutions
Developed applications using SQL/SSMS, VB.net/Visual Studio, MS Access and MS Excel for reporting purposes and to automate daily tasks, such as data scrubbing, data manipulation and file reconciliations.