SUMMARY

• 9 year 5 months of total IT experience in the Business Requirements Analysis, 解决方案设计, 数据架构,数据集成,数据质量, Implementations of Data warehousing and Database business systems for Telecom, 银行及科技行业.
• 3年以上BSS系统(如BSCS)工作经验 & 客户关系管理-希贝尔.
• 8年以上的数据仓库ETL (Extract)经验, 变换, 使用Informatica 7 / 8/ 9电源中心, SQL Server, Oracle, Teradata, SQL, PL/SQL, Unix Shell脚本, Sun Solaris和Windows, including complete System Life Cycle from Analysis and Design to Implementation.
• 2+ Years experience with OLAP Tool- 业务对象 XI R2 (Designer, Web Intelligence).
• 2 + years experience in Big Data Technologies, Hadoop Mapreduce, Hive, Pig,,
• Extensive database experience using Oracle 10g/9i/8i/7.SQL Server 12 . x.0、Teradata、Erwin、SQL、PL/SQL、SQL*Plus、win3.x/95/98/2000, Win NT 4.0和Sun Solaris 2.x.
• Experience with ETL integration efforts of various data sources into a staging area; Installation and Developed common logic using Reusable transformations and mapplets. Developed Strategies for Extraction 变换ation Loading (ETL) mechanism;
• Knowledge on Bigdata technologies HADOOP Map-Reduce, Hive, HBase,Sqoop,Phoenix, R Programming.

技术技能

电信产品: 二元同步通信,CRM-Siebel.

ETL工具: Informatica, Pentaho Kettle

OLAP & 报告: 业务对象

数据建模: Erwin, Visio, SQL数据建模器.

RDBMS: Oracle, SQLServer, Teradata

脚本: Unix, BTeq脚本

语言: Java, c++， C, UNIX Shell脚本.

OS: UNIX, Windows 98/2008 R2/NT /XP/7/8, Sun Solaris, Linux.

BI的方法: Kimbal, Inmon.

BigData技术: Apache hadoop,Mapreduce, Hive, HBase,Pig,Phoenix, Sqoop,Oozie, Hadoop Cluster Setup.

专业经验

保密

解决方案架构师 & 大数据分析师

职责:

• Part of building the BI data model to support E/// events from BI/IDW Teradata CDM data model & 财务分析数据来源.
• Working as source data analyst for BSCS customer,Product & 财务数据.
• Mapping the 保密 events against the E/// CBIO DB attributes for applications like BI/IDW,佣金及活动管理.
• Reviewing the business and functional requirements from 保密 .
• 参与JAD会议.
• High level designing for E/// out of box reports from different applications E///billing, 订单管理和ECNM的drop1版本1.
• Reviewing the 保密 customer and product model and validate product changes in CBiO to accomadate 保密 requirements.
• Gathering the reporting requiremetns from TMOB and solution design.
• 用户故事 & 为报告需求创建FSP文档.
• 使用水晶报表进行报表开发 & BO 4.0.
• 用于控制的Hadoop集群设置 & 合规管理系统 .
• Data loading using Hive/Pig programming for CDR data analysis & 日志分析.

环境: BSCS iX 4.0, BO 4.0, Oracle, Unix, Visio, Brackets UML, Golden Gate, Hadoop Hive & 数据建模师.

保密

Sr.数据仓库开发人员

职责:

• Logical/physical modeling of DB objects in the SQL Server.
• Developing ETL design, change data capture, created SQL views.
• Follow the quality standards and guidelines for configuration management, testing, 项目计划与执行.
• 对变更请求进行影响分析.
• Establishing and monitoring issue management, change management and quality management processes.
• Loading data from Flat Files into the Staging area using Informatica PowerCenter into Sql Server.
• 使用设计器设计映射, which populated the Data into the Target Star Schema on SqlServer Instance.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

环境: Windows、Informatica PowerCenter.1、SQL Server 2012、Octopus、Visual studio 2012(VSTF).

机密，普莱诺，德克萨斯州

Sr.数据仓库开发人员

职责:

• Worked with Business Users to identify Key Business Rules and Measures and recommend controls to validate the information.
• Perform Data Profiling to analyze the data from correctness, 完整性, 精度, 完整性, 一致性维度
• Coordinate with Business Leaders and 项目经理s to assure the solutions are complying with Business Strategies and are according to IT strategic plan.
• Architect for Data Management Framework for 保密 &数据仓库质量数据管理.
• Program, 包括但不限于元数据管理, 事件管理, 变更管理, 数据质量管理, 主数据管理.
• Designed Conceptual, Logical and Physical Data Model using ERWIN Data Modeler
• 用于捕获数据定义的已定义流程, 元数据, 过程血统, 数据源, 及下游应用.
• 与开发团队协调, 离岸团队, 项目经理, 业务用户交付关键的项目里程碑.
• 在Unix和Btech脚本上工作.
• Defiening and ipleenting data quality metrics on diffirent subject areas like Customers, Orders, Payments, 通话明细记录, 保密 &宇宙等.
• Used different techonologies like Oracle, Teradata to capture the different metrics.

环境: Teradata, Oracle, Bteq, Unix Scripting,Erwin

保密,SanJose, CA

生产支持

职责:

• 在所有交付中协调离岸团队.
• 生成和审查审计报告.
• Involving 变更管理 Process, Release plans and Upgrading plans.
• Root Cause Analysis of various aborts in Golden Gate,Datamover and Informatica.
• 客户端状态报告.
• 影响分析和部署支持.
• 美元U调度和监控.
• Unix脚本 and Teradata stored procedure implementation.

环境: Informatica PowerCenter.1,Oracle Golden Gate, Data mover, Teradata, Oracle 10g, SQL,Unix Shell Scripting.

保密,夏洛特

Sr.数据仓库开发人员

职责:

• Interacting with onsite co-ordinator and client in understanding the requirements.
• 编写底层设计文档.
• SQL Scripting usind Netezza and building the model microstrategy
• Developing informatica mappings/sessions/maplets/workflows.
• 准备和执行单元测试用例.
• 修复作为系统测试一部分提出的缺陷.
• Deploying the informatica and database objects in different environments like SIT,UAT and PROD.
• 为工艺流程控制开发Autosys工作.
• Developing/Enhancement of stored procedures in oracle, teradata and netteza database.
• Unix脚本和BTeq脚本.

环境: Informatica PowerCenter.1, Netezza Oracle 9i, Teradata, SQL, TOAD, Autosys, Unix Shell Scripting.

保密

数据仓库开发人员

职责:

• 需求分析.
• 影响分析 on Du’s data warehouse system due to change requests.
• Data integration from various BSS/OSS source systems into enterprise data warehouse system using ETL tool Informatica.
• ETL代码的单元测试.
• Guide team members in learning datawarehousing and telecom domain.
• 良好的数据仓库概念和SQL知识.
• Oracle存储过程实现.
• Unix脚本.
• Developing informatica mappings / transformations / sessions /workflows.
• Good knowledge in the below areas of 业务对象 XI R2
• 设计的宇宙.
• Resolving loops in universes using concepts like aliasing and contexts.
• Creating classes and objects(dimensions, measures and detail).
• 用lov和级联lov创建对象.
• 编制报告(书桌一) & Web-I) .
• Knowledge on BSS applications systems like BSCS,SIEBEL-CRM,Prepaid Intelligence Network etc.

环境: Informatica PowerCenter.1、业务对象、Oracle 10G、Unix Shell脚本.

保密

订单管理开发人员

职责:

• 需求分析.
• 影响分析.
• Developing the code for BT’s transaction workflow management.
• Oracle存储过程增强.
• Unix脚本.
• 单元测试
• 测试支持.

环境: Oracle, css -订单系统