Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
- Software professional with total 14+ years of experience in Information Technology industry
- Experience in Data warehousing techniques, building dimensional model & architecture.
- Have worked on BI Tools (Micro Strategy, Power BI), SAP HANA and Customize Oracle based applications: Retail applications, Inventory, Garments Production, and Human Resources.
- Oracle database programming experience using PL/SQL, Packages, Stored procedures, Views, Materialized Views, External tables, temporary tables, SQL LOADER,WEBUTIL,HS(Connecting non-oracle databases into oracle ).
- Experience in SAP HANA modeling to develop views (CDS, Calculation, attribute)
- Expertise in Oracle development using Developer6i & 10G as front-ends with ORACLE 8i/9i/10g/11g as back-end.
- Extensive exposure to Software Development Life Cycle (Business Requirement, Analysis, Design, Development, Documentation and Testing).
- Good communication and interpersonal skills with good analytic power.
- Proficient and prompt in learning and adapting to new technologies, self-motivated with Result oriented approach.
项目
工作经历
Senior Advisory Software Engineer
Primarily responsible for architecture, design, development, cube strategy and management of BI reporting project.Led a team of five developers to design and build project to answer financial, planning and utilization requirements.
Managed development cycle in on shore off shore model. Conducted training for both technical and business users.
Perform analysis, design, development, testing, and debugging of complex reports, ETL scripts and dashboards.
Troubleshoot high level issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software (common examples: nulls in data causing joins to function incorrectly; ETLs running out of sequence; Microstrategy Objects not set up properly; HANA out of memory issues).
Write and modify SQL scripts to update tables, views and materialized views and used insert statements, cursors and bulk collects to move new data into the database.
Troubleshoot high level issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software (common examples: nulls in data causing joins to function incorrectly; ETLs running out of sequence; Microstrategy Objects not set up properly).
Created schema, metrics, reports and documents supporting client business goals.
