Objective: Seeking challenging Data Warehouse Business Intelligence Architect position that can best utilize my technical skills and experience.

Technical Skills and Capabilities:

• 15 years of extensive experience with enterprise software applications. 9 years with Data Warehouse and Business Intelligence applications. Expertise in Data Modeling, Data integration,MDM,ODS, Dimensional Modeling Star-Schemas Kimball , ETL process and frameworks. Deep understanding of Big Data analytic theory practices.
• Expertise's with programming languages: SQL, Oracle 10g , PL/SQL, Teradata 13.10, Teradata 14.10, C/C , Java, UNIX Shell Scripts, Perl, .NET,ASP, PHP.
• Experts of Unix system architecture Solaris 10, AIX 6.x, RedHat Enterprise Linux , Oracle Enterprise Linux and Win 2003/2008 R2 servers
• Extensive Experiences with business intelligence tools, including Siebel Analytics 7, OBIEE 10g/11g, SAP BusinessObject, IBM Infosphere 8.5, DataStage/QualityStage and BEA WebLogic server 9.x. ERWin, Toad, Teradata SQL Assistant. Informatica 8.6 9.1 PowerCenter, DataTransformation. DataMirror CDC.

Working Experience:

Confidential

Senior Technical Advisor, EDW Architect

• My role as a senior Teradata architect includes : Work as a senior technical advisory source for all EDW projects. Provide technical advices in Teradata physical data model design and implementations.
• Attend multiple EDW project design reviews per week. Performance tuning for current production jobs ETL Microstrategy reports in CVS's Teradata Enterprise EDW environment. ETL code review and provide performance enhancements solutions. Review RxClaim,Med D new data mart projects' physical model design ETL code review for all new PBM EDW projects.
• Worked as senior architect for Aster/Hadoop Big Data solution initiatives for data archiving solution.
• Teradata DBA Production support : Review Code push from QA to prod. PROD Data backup,archive and refresh to QA/DEV using Teradata BAR Tivoli. Help production support team debug production job failures and provide technical solutions.
• Create database monitoring alerts on top of Viewpoint existing alerts. . Create production SQL profiling tools to find out usage patterns. Worked on setting up TASM workloads. Assist in database planning for new business initiatives. User Profiling manage various roles.

Confidential

Title : Data Warehouse Architect Teradata DBA ETL Lead

Responsibilities:

• BI Architect: Review current DW ETL process and provide assistance for improving current SPEND/MAP/SLA ETL processes implemented using Wherescape RED. Debug MicroStrategy Reports that having performance issues due to physical model design issues. Rebuilt physical models to achieve 20x fold report performance gains.

• Created ETL frame work to extract data from corporate EDW SDI data-mart to provide updated info to external corporate customers. Automated the whole process which was not possible before by building PERL script frameworks.

• Worked with GHX7 team to re-invent the corporate GHX7 extract ETL process. Rebuilt existing SQL Stored procedures to make the SPs worked fast on Teradata system.

• Teradata Production DBA:Worked as Data architect to convert logical models into Teradata physical implementation. Created database artifacts database,tables and views,SP,FUNCTIONs needed for business analyst group users. Backup of production databases, tables and data dictionary. Worked with Teradata GSC to patch upgrade production systems. Worked closely with ETL team to migrate corporate SQL Server data 5T into Teradata. Admin for all dev/qa/uat Teradata systems.

Confidential Title : Data Warehouse Architect Teradata DBA ETL Lead

Responsibilities:

• EDW ETL Architect: Design and develop corporate ETL framework for Enterprise Claim data warehouse. Built ETL process scripts from scratch. Lead in inventing proprietary ETL solutions to integrate terabytes of data from corporate Mainframe source systems. Lead in forklift project to make sure it's delivered on time. Design and develop Informatica mappings for the data integration of EDW. Lead a team of 4 ETL designers 3 onshore and 1 offshore . Worked closely with team members on triage of data quality issues.
• Got CEO recognition for my innovation on the new PCF ETL massive data load from MF to TD process. Got CIO reward of the year for employee technology innovation.
• Changed Data Capture Solution Lead
• Designed architecture and made project planning for DataMirror CDC solution. Installed IBM's CDC 6.2 agents on RedHat 5.7 linux production servers. Configured Access server and admin console to capture HMS's PCF EC DB2 data store's daily updated data. Brought CDC solution to production from initial conceptual design.
• Teradata Production DBA
• Worked with Data architect to convert logical models into Teradata physical implementation. Created database objects tables and views needed for business analyst group users. Daily/weekly backup of production databases, tables and data dictionary. Created store procedures to manage user access user rights and database space usage. Worked with Teradata GSC to patch upgrade production systems. Worked closely with ETL team to migrate corporate MF DB2 data 15T into Teradata. Used ARC to do daily and weekly backup to NFS drive. Worked with BA to create views for front-end reporting. Worked on data analysis/profiling for revenue projection.

Confidential Title : Data Warehouse Solution Architect

Responsibilities:

• Teradata Application DBA. Lead project of converting wireline/wireless Oracle 10g data marts to Teradata V2R6. Created physical model db,tables,views,Store Procedures based on previous Oracle schemas. Created ETL scripts for ELT process, using BTEQ, MLOAD, TPT scripts. Created all needed UNIX shell/PERL scripts for ETL process. Debugged ETL issues with business analyst team.
• Provide BI/DW application architecture design and roadmap for AT T's corporate Data Warehouse projects. Design implement clustering for high-availability and high performance. Design implement system outage/performance degradation alert tools/scripts. Provide detailed infrastructure solution hardware platform, selection of software packages ,etc for such data warehouse projects/environments. Lead in Data Warehouse application upgrade design implementation.
• Production/QA/ST administrator for OBIEE 10g , BusinessObject , IBM Infosphere 8.x. and Informatica 8.6.Support on-call and outage emergencies. Debug performance issues with DBA. Lead a team of offshore engineers for 24/7 coverage of all environments.
• Upgrade of afore mentioned BI/DW tools. Work with vendors to resolve upgrade issues. Work with PM closely to guarantee project success.
• OBIEE business repots development for Siebel marketing and Sales cubes.
• Worked on developing production ETL workflows/mappings, OBIEE repository development. Lead code migrations and code deployments.

Confidential Title : Senior Data Warehouse Consultant

• Onsite senior consultant for Leap Frog Corporation's Oracle Business Intelligence solution system:
• Develop new ETL processes to support design, UAT and production environments of the data marts in Siebel Marketing cubes. Develop logical and physical data models for Client's new Siebel Marketing Segment cubes. Complete POC architecture design of Siebel CRM / OBIEE OBI 7 systems
• Lead and administer systems performance including on-going optimization and tuning of Informatica/DAC environment. Analyze and evaluate data sources and bug fix for ETL tasks/Informatica mappings. Customization Siebel Analytics / Oracle Bi and DAC integration Oracle eBusiness Suite. Deliver new ETL mappings, new RPD design and Web Catalog design.
• Responsible for the delivery of production ready systems of Informatica/DAC/OBIEE environment including automation, job scheduling, dependencies, monitoring, security , and administration.

Confidential Title : MTS4, Senior System Engineer

• Senior member in corporate Siebel CRM Siebel Analytics data warehouse solution team. Responsible for production administration of Siebel CRM Analytic applications. Worked as iPlanet Web server administrator. Data warehouse application integration with iPlanet server.
• Production fallback/clustering architect design. Production code deployment.
• Debug and triage ETL failures, data abnormality and other data integration issues.

Confidential Title : Senior System Engineer

• Deploy new Siebel Analytics system to client's linux servers.
• POC project lead for Siebel marketing campaign implementation.

Confidential Title : Staff Software Engineer

Microcode developments of video decoder chip. Maintain and write new features for the video processing microcode of DVD4 decoder project. Worked on bringup. Verified the CPU, HOST controller, VLD, Audio and Video Output units.

Confidential Title : Embedded Software Engineer

• Write micro-code in MIPS assembly for two generations of 10/100 Ethernet switch controllers.
• Develop test bench BFM module to verify the Address Resolution Logic chip.