CAREER SUMMARY

• 15 years of software industry experience of which 9+ years in ETL/DW/BI developing as a senior developer. Developed more than 16 BI applications including (4 full cycle implementations), covering energy, insurance, finance, tax administration, and etc
• Strong OWB and DataStage design and delivery experience, as well as experience in ETL best practices,design templates and frameworks
• Proficient in developing ETL applications with Oracle Warehouse Builder and DataStage
• Strong experience on integrating data between flat files, CSV files, XML, COBOL files, database and WebSphere MQ.
• Extensive experience with all phases ofData Warehouse development including EDW and data mart architecture design, development, testing, documentation, performance tuning and training end-users
• Strong understanding of RDMS structures, theories, principles and practices
• Strong Analysis and Process skills in Systems Development Life Cycle (SDLC).
• Excellent skills for problem analysis and problem solving. Good team player committed to customer satisfaction and quality

• Databases: Oracle 8/9i/10g/11g (10 years), MS SQL Server 7.0/2000 (3 years), DB2 8/9 (3 years),
• Languages: SQL(10 years), Unix Script(10 years), VB.NET(4 years), XML/XPATH/XSLT, WebSphere MQ, Web Services, JAVA(2 years)
• Database Tools: ERwin 4.1/7.1 (5+ years), Toad 9.1
• ETL: OWB(3+ years),DataStage 7.5/8.0.1/8.1 (6+ years)
• BI Tools: BusinessObjects 5.1/XI R2/R3.1 (5+ years)
• Methodologies: Ralph Kimball design theories, UML, OOA/D
• Other Tools: MS Office, IIS, WS_FTP
• Operating Systems: Windows NT/2000/2003/XP/Server, MS DOS, Unix, Linux

• BusinessObjects Certified Professional-- BusinessObjects Enterprise™
• IBM Certified Solution Developer-- DataStage Enterprise Edition v7.5/8.0
• Training: DataStage Essentials V8 (DX444)
• Training: What\'s new in InfoSphere DataStage V8 (DX801)
• Training: DataStage Advanced Enterprise Edition (DX436)
• Training: BusinessObjects XI R1/R2 Universe Design (DM310R2)
• Training: BusinessObjects Web Intelligence XI R1/R2 Report Design (QA210R2)

Confidential, Calgary, Canada 03/2011 - Now
Business Objects developer
Enterprise EDW and Reporting System

• Asset Management and Finacial Management system analysis and enhancements
• Worked with end users to collect and analyze requirements from business departments, designed BO reporting technology solutions.
• Involved in enterprise reporting design standards, process & guidelines ensuring effective report management including created naming conventions and report templates
• Implemented of enterprise BI solutions, Universes, classes and objects, aggregate awareness, hierarchies, user prompts, conditions and filters,
• Constructed reports using the business object functionality like queries, slice and dice, drill down, functions and formulas, created master detail and cross tab reports, provided various management levels with reports, time series graphs and pie charts
• Designed user access security including BusinessObjects authentication, authorization, universe access restrictions, and database level securities.
• Created the warehouse logical and physical model, designed mappings that populated the data into the target
• Provided guidance, coaching and mentoring to other team members
• Environment: BusinessObjects XI R3.1, Informatica 8.6, Toad9.6, Oracle 10g, Sun Unix

Confidential, Toronto, Canada 01/2009 - 02/2011
ETL Developer
Campaign Management Data Warehouse

• Gathered, analyzed, and transformed business requirements into logical data models, validated logical data models with business subject matter experts, assisted Database Administration in transitioning to database schemas from logical data models
• Developed ETL design documents, source-to-target mapping specifications and developed ETL mappings and PL/SQL routines, extracted, transformed, cleaned and loaded data into a data warehouse from the transaction databases/files
• Used external tables, mapping input/output parameter, sequence, table, view, expression, filter, joiner, key lookup, aggregator, pivot, unpivot, sorter, set operation, transformation to build mappings. Used mapping, route, fork, and, assign and used define activities to build process flows.
• Developed generic PL/SQL stored procedures and functions to detect, compare, split, validate and recycle data dynamically; developed the stored procedure for SCD 1 and SCD 2 logic
• Created stored procedures to generate mappings dependency control sequence for the ETL scheduling
• Create Oracle database maintenance routine functions such as gathering table stats, stale table detecting, tables and partition cleanup.
• Performed the test plan for unit and integration testing.
• Developed Unix shell scripts to download, validate, merge, FTP and archive data files
• Developed the ETL processes for loading data and monitored data quality, identified and fixed the problems
• Extensively worked in the performance tuning of the mappings, Gathered tables stats and ddded proper Oracle hints to the mappings to optimize SQL performance or keep the execution plan stable or adjust table join sequence
• Provided daily production support and troubleshooting, monitored mapping running status through audit logs, reviewed the mapping SQL execution plans and table load progress. Cleaned up mapping/progress/scheduler sessions in Oracle if needed.
• Built OMB+ Script to import/export, deployment, synchronization mappings/process flows. Changed the mapping/process flow logic through OMB+ script in batch.
• Provided knowledge transfer to India team
• Environment: OWB 11.1.0, OMB Script, ORACLE 11g , PL/SQL, Korn Shell, ERWin, BugZilla, SUN_UNIX , Oracle SQL Developer

Confidential, Toronto, Canada 05/2008 - 01/2009
DataStage and PL/SQL Developer
United Customer Information Repository (UCIR) System

• Integrated the daily billing, customers and gas consumptions information for reports and analysis and also can be accessed by registered on-line customers.
• Analyzed the requirements and built technical design document. Participated in the review and approval of the technical, business transformation requirements document.
• Extensively used ETL to load data from both fixed width as well as Delimited Flat files, XML files, COBOL files and also from the Oracle.
• Developed PL/SQL packages, procedures, and functions to fill gaps where ETL design is not supported by DataStage, such as transforming data with complex business rules in Oracle.
• Developed Korn shell scripts to download, pre-match, validate, merge, split, FTP and archive data from clients. Created batches and sequencers to control sequence of jobs by using Control-M.
• Developed, maintained programs for data extracting, loading and transformations using DataStage engine. Used link partitioner, link collector, sort, aggregator, transformer, hash file stages in designing the jobs. Developed user defined routines and transformations by using stage variables.
• Used workflow Monitor to monitor the performance of the Jobs. Extensively worked in the performance tuning of the ETL process.
• Created and performed the test plan for unit and integration testing. Assisted unit & integration test in SAP system.
• Environment: DataStage 7.5, ORACLE 10g R2, PL/SQL, Korn Shell, SAP, HP Quality Centers, HP_UNIX B.11.11, SQL Developer

Confidential, London, UK 03/2007 - 05/2008
ETL and BI consultant
Insurance Data Warehouse and Business Intelligence System

• Created source to target mapping documents from data sources to staging area, from staging area to data warehouse and from data warehouse to various data marts.
• Developed low-level job design, used DataStage Designer for developing various jobs to extract, cleans, transform, integrate and load data into data warehouse using different stages of DataStage and T-SQL, functions and macros, parameterized DataStage jobs to allow portability and flexibility during runtime.
• Created Batches and Sequencers to control sequence of jobs. Developed Unix Scripts to control the Batch processes and archive and FTP the generated files.
• Documented report specifications with BO Universes, constructed reports using the business object functionality like queries, slice and dice, drill down, functions and formulas, created Universes, Metrics, Calendar, Rules and Alerts for the dashboards, tested the universes, reports and dashboards
• Created BO naming conventions and report templates, created universes, classes and objects, aggregate awareness, user prompts, conditions and filters
• Created and performed the test plan for unit and integration testing.
• Environment: IBM WebSphere DataStage 8.0.1, BusinessObjects XI R2, Korn Shell, Erwin 4.1, PL/SQL, SQL Server 2005, Unix
  

Confidential, Changchun, P.R. China 11/1999 - 12/2006
Senior ETL developer
Tax Administration Information Analysis System for Changchun Municipal Taxation Bureau

• Collected and analyzed user requirements from tax collection, tax account, tax statistics and tax supervision departments to identify data structures and process flows , involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse/data mart
• Defined data warehouse architecture and ETL standards, best-practices and templates including naming conventions, reusability standards, etc. to govern the design, development and testing
• Ensured semantic consistency and synchronization of field values across all warehouse layers and from multiple source system
• Designed and implemented data warehouses, data marts, and data stores, while ensuring high levels of data availability
• Developed ETL design documents, source-to-target program specifications and developed complex ETL programs and routines
• Provided guidance, coaching and mentoring to other team members in the use of OWB
• Environment: OWB 10g, BusinessObjects 5.1, Erwin4.1, Oracle 10g, SQL Server2005, Windows 2003, Unix

• Master of Engineering in Computer Science
• Bachelor of Engineering in Computer Science

Available upon request