Research and evaluate new Business Intelligence/Data Warehouse or other customer-reporting requirements. Design and development of dimensional data structures and ETL programs that populate those structures efficiently. Build advanced ETL processes, functional routines, and testing to ensure compliance with business requirements. Develop ETL processes using Business Objects Data Services and Informatica Power Center 9.5. Develop BI solutions and reports using Business objects, Qlikview and OBIEE to provide access to KPIs. Develop Essbase cubes and various OLAP application models using Hyperion Essbase. Develop database objects like stored procedures, functions and packages using Oracle PL/SQL. Responsible for creation, maintenance and migration of production data warehouse projects/jobs. Provide on-call support for DW clients and to work closely with technology services to facilitate issue resolution. Document business requirements for the data integration, mapping and testing.Integrate multiple research systems into a central repository for advanced data query, analysis and reporting.

Project management of overseas engineering team to develop enterprise data warehouse and dashboards.Created user requirements,owned and implemented of BI solutions.Gather customer requirements and deliver solutions for analytics and health intelligence reporting.Analysis of Medicare members risk score and review of medical records and to optimize funding and cost.Involved in the development and maintenance of complex data storage structures to support DW functions.Developed ETL mappings and scripts.Developed Medicare member budgetary statistics along with the claims information to manage utilization.Build dashboards using Qlikview for trend identification and measurement of medical program outcomes.Maintained validation routines and troubleshoot data warehouse issues to support EDW. outcomes•Developed and maintained validation routines to support data mining and report presentation•Produced reports and presentations to communicate analytical findings to the business

Created test procedures to ensure system stability for new and modified codes using manual and automated test methodologies. Conducted functional, regression, end-to-end, system, and UAT to ensure that requirements are met. Facilitated analysis sessions to finalize test requirements, plan and documentation. Customer support and troubleshoot data issues for various applications as well as gathered recommendations for product enhancement.Proficient in gathering and analyzing information to address and resolve root cause issues.Managed monthly testing of the Microsoft patches to rollout dev/test/production environments appropriately.Documented procedures to fix data issues and published training document on SharePoint.

Performed financial planning and analysis to create analytical reports.Reviewed Profit and Loss sales report and created performance alert dashboard. Designed and developed BI solution using Siebel Analytics. Familiar with control procedures as defined by QA department including those related to compliance.Developed Sales and COGS dashboard for trending and drill down by functional area, product and business unit.Developed end user reports for performing market trend analysis using Siebel Analytics. Identified new functionalities on system implementations and process re-engineering.

Process verification on newly issued fixed income data and for data quality and timeliness.Prepared competitive benchmarks for analyzing and improving the efficiency of helpdesk service requests.Integration of support data from various sources and data analysis to produce performance reports.Worked with the end uses and provided recommendations document for process improvement.Provided analysis and recommendation to project teams to ensure quality assurance.Worked as a helpdesk analyst to trouble shoot data issues on Reuter's products.Worked on Reuter’s products: 3000xtra, Bridge, Reuters plus and Wealth manager.Developed matrices to analyze the service requests in identifying the six sigma project modules.

Involved in financial servicing of secondary mortgage loans and asset management.Proficient in bankruptcy and foreclosure filing process.Create and maintained a data mart to create reports on default loans for the foreclosure and sale.Coordinated foreclosure procedures with loan resolution consultants on title, lien and payment issues. Responsible for application testing to ensure data security and report access.Documented business processes and system requirements to securely integrate financial data.