SUMMARY

• A dynamic professional with 6years of IT experience in System Analysis, 业务分析, DW开发, 测试, Implementation and Integration of various Data Warehouse Systems and Business Intelligence Applications on Client - Server, SOA和大型机环境.
• DWH: Have strong experience in Design and Implementation of Data warehouse Methodologies like Ralph Kimball and Inmon in Implementation of ODS, EDW和元数据存储库.
• Informatica: 5+ years of Data Warehousing experience using 信息力量中心.1/8.6.1/8.1./5.1 , OLAP, OLTP, Autosys, Strong experience in 设计ing and developing complex 映射 to extract data from diverse sources including flat files, RDBMS表, 和遗留系统文件.
• 数据库: Extensively worked on 甲骨文 10g/9i, DB2 8.0/7.0, MS SQL Server 2005, Teradata V13, PostgresSQL, HPNeoview.
• Experienced in integrating data from various Heterogeneous sources (Relational database, SIEBEL, 平面文件, XML文件, COBOL文件, Excel) into Data Warehouse and Data Mart.
• Worked on operating systems UNIX, Linuxand Windows. And have experience in InformaticaandBusiness Objects Administrationand strong experience in installing in windows, Unix环境.
• Unix: Have very good experience in Writing Bash Shell Scripts.Strong testing experience on UNIX based applications.
• Production Support - Done extensive 24x7 production support and issue resolutions.
• Offshore Team Co-ordination - Onsite-offshore co-ordination experience and well versed with off-shore teams ensuring timely and quality results.
• Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions.
• Excellent in Documentation, End-User Training, Knowledge Transfer and Production Support.

技术技能

ETL工具: Informatica 9.x/8.x /7.x (PowerCenter)

语言: PL/SQL, Shell脚本，C, c++

数据库: 甲骨文 11g/10g/9i, DB2, SQL Server 2008 R2/2005, Teradata 13.10、主机

工具: 和实用程序:分享Point, LSMW, 欧文, SQL助理, Teradata经理, Teradata管理员, BTEQ, 蟾蜍, 质量中心专家, ITSM工具(ServiceNow), 补救措施), 文件管理器, 改变的人, SPUFI之类, FMIMS, SOAPUI (UI),DAC.

操作系统: Z’ OS, Windows 2008 server/XP, UNIX, Linux

调度工具: Autosys, Control-M

专业经验

保密, Concord, New Hampshire

Sr. ETL开发人员

职责:

• Involved in requirements gathering, 分析, 设计, 发展, testing and implementation of Hub ODS.
• Developed ETL for Data Extraction,Data Mapping and Data Conversion using 信息力量中心.5.1.
• Work with multiple teams and Subject Matter Experts (SMEs) performing 发展 activities across all phases of the project 发展 lifecycle and participated in GAP 分析.
• Provided in-depth technical consultation to ensure 发展 of efficient application systems by utilizing established methodologies and best practices.
• Followed AgileDeployment methodology starting from the User Stories reviews, 规划, 发展 and testing of the objects.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Developed re-usable transformations, Mapplets following the Informatica best practices.
• Extensively used almost all of the transformations Source Qualifier, 过滤器, 更新策略, 联盟, 分选机, 表达式, 聚合器, 乔伊纳, 连接 & Unconnected Lookup transformation, Sequence Generator etc.
• Coordinated deployments that include Informatica deployments as well as Unix Shell Scripts, 数据库的DDL, DML脚本.
• Extensively wrote user SQL coding for overriding generated SQL query in Source Qualifier.
• Automated scripts to enable Job status information.
• Used 设计er debugger along with session log to monitor data flow and fix related bugs.
• 提供详细的技术, process and support documentation like daily process rollback and detailed specifications and very detailed document of the project with the workflows and their dependencies.
• Created and scheduled Interface jobs to feed data into Dashboard applicationsusingAutosys
• Involved in Unit testing of Mappings, Workflows and debugging 映射 for failed sessions.
• Involved in end-to-end Integration testing and issues/defects resolution and coordination with off shore team
• Used ITSM tool ServiceNow for troubleshooting user issues and service requests.

环境: 信息力量中心.5, 甲骨文 9i, 甲骨文 11g, UNIX, Windows XP, Citrix, ServiceNow,Autosys,DB2.

机密，WoodlandHills, CA

ETL开发人员

职责:

• 设计 the ETL Framework that included Data modeling for Staging Database
• Written single reusable Code with Table driven/Parameterization for migration of 8 source systems
• Involved in the meetings with business analysts and DBAs to gather and understand the business requirements and process flow details in order to plan the ETL loading
• Worked with data modelers in preparing logical and physical data models.
• Integrated 3rd Party Business Rule engine to validate the Staging Provider Information
• Understanding functional specification, data model requirement and ETL specification documentand preparing HLDs and LLD’s of, 待实现需求.
• Perform mock conversions to load data in test environments
• Involved in Integration testing and UAT Support.
• Analyzed existing system and prepared and presented Impact Analysis.
• Prepared technical 设计 documents based on BRD and SRSin a standard template explaining entity relationships and its components.
• Created Shell scripts for Automating of Worklets, batch processes and Session schedule using pmcmd.
• Good hands on over Teradata fastload and bteq commands.
• Implemented performance tuning logic on Targets, 来源, 映射, sessions to provide maximum efficiency and performance.
• Performed the Unit 测试 which validate the data is mapped correctly which provides a qualitative check of overall data flow and if deposited correctly in Target Tables.
• Scheduled the jobs through UNIX shell scripts using DAC.
• 执行测试, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• On-call support to enable 24x7 coverage.
• Used Remedy to log and track user issues.
• Extensively worked with QA team to resolve the issues
• Worked extensively with the release team to plan and execute the releases.
• Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod).

环境: 信息力量中心.6,TeraData, DB2, MS SQL Server, UNIX, MVS Mainframes

保密, Woodland Hills, CA

Informatica开发人员

职责:

• Extensively used Powercenter 设计er to develop various parallel jobs to extract, 净化, transform into Enterprise Data Warehouse Tables.
• Translation of project requirements into project objectives and tasks; manages project resources and reports on project progress throughout its lifecycle.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, 清理和数据集成, and loading from different data sources using Power Center 7.5. (Data Designer, WFManager, Monitor, and Administrator).
• Responsible for the Data Cleansing of Source using LTRIM,RTRIM along with all mathematical and logical functions of the 表达式 Transformation
• Extensively worked with both 连接 and Un-连接 Lookups using all types of Look up Caches to improve the performance of the lookup transformations
• Replicate operational tables into staging tables, Transform and load data into enterprise data warehouse tables using Informatica from their legacy systems and load the data into targets by ETL process through scheduling the workflows.
• 参与sql的开发, which are used to apply all business rules on the data before load into the target tables.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & 会话后shell脚本.
• Developed and executed effective test plans to ensure quality and stability and provide direction to contractors performing tasks.
• Worked with reusable objects like Re-Usable Transformation and Mapplets
• Handled various loads like Daily Loads, 每周的负载, Monthly Loads and Quarterly Loads using Incremental Loading Technique
• Worked on ERWIN Tool for data modeling.
• Worked extensively with the release team to plan and execute the releases
• 参与生产支持

环境: Informatica PowerCenter.6/7.1, UNIX, MVS Mainframes, COBOL, JCL,Windows,甲骨文10g, SQL, Shell Scripts. 欧文,Control-M.

保密

Intern/ Trainee/ Informatica and Mainframe Developer

职责:

• Involved in Requirements gathering, Logical 设计 model & physical 设计 model meetings to understand the data flow, frequency of data loads into EDW and create Mapping documents and Visio diagrams.
• Captured data from a variety of sourcesincludingDB2,VSAM文件, MS SQL Server, 赛贝斯公司, 甲骨文, and flat files and other formats
• 设计 & developed numerous Jobs in all the projects which involved complex transformations, 性能增强, 验证, 参照完整性, 代理键, SCD’s on mainframe and distributed environments.
• Written Shell Scripts to automate files, schedule batch jobs and developed various SQL queries on the UNIX OS and ran batch files on the UNIX using Cron utility.
• Learning the parallel processing, shared nothing architecture using Teradata.
• Involved in Database Migration/upgrade & 测试 from existing legacy systems to single db.
• Written Various SQL procedures for insert, update and bulk load into EDW.
• Involved in documenting changes and potential Production Issues, Workflow Analysis and Standards.
• Prepared unit test, 集成测试, and performance test plan documents. 执行单元测试, 集成测试, and performance test as per the approved test plan, 并记录测试结果.
• Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc.
• Analysis of Issues in Production Runs and fixes.

环境: 动力中心8.x/7.x、DB2、甲骨文 9i、Teradata 13.10, MS SQL Server 2000, Windows 2000, Autosys, Control-M