SUMMARY:

• A result - oriented and innovative IT professional wif over 12 years of comprehensive and demonstrated consulting experience in lead, design and development of complete project life cycle for data warehouse and business intelligence, data governance, data modeling, ELT/ETL implementation. Technical skill set include:
• Data Modeling -wif ERDs (ER Studio, Erwin) for OLAP, OLTP, ODS, DM, EDW.
• Relational and Dimensional Modeling - ERDs
• Schema: 3NF, Star & SnowFlake
• Process Modeling (MS Visio)
• Data Profiling, Data Quality, MDM
• (Talend Open Studio 5, Trillium, SSIS)
• Data Security, Governance, Compliance and Stewardship

TECHNICAL SKILLS

Methodologies: Agile, waterfall, OOAD, UML, OMT

Big Data: Hadoop- HDFS, Hive, Pig

ETL: PL/SQL, Informatica, Data Stage, ODI

BI Reporting: Tableau 7, BO, MicroStrategy, Cognos TOAD, SQL Loader Teradata - BTEQ, multi-load, fast-load

Language: C, C++, Basic, Cobol, Pascal, ASP, Python, ASP, HTML, Java, Unix shell Script

Network and Security: FTP, SSH, PGP, SSL, PKI-Public Key Infrastructure, RSA Digital Signing, SHA-1MD5.

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara-CA, USA

Sr. Data Analyst/Architect

Responsibilities:

• Understanding, configuration, & use of related Oracle E-Business Suite modules & providing ongoing operational support in managing complex strategic analysis and architecture of data environments (DM/DW) and its processes for BI Analytics and reporting.
• Leading cross-functional teams and coordinating on multiple projects.
• Gathering, business, functional and user requirements in support of BI analytics and reporting needs.
• Will work wif Vendors and the Business to map out all sources and ensure they are all captured in the project requirements.
• Perform data mining, analysis and support various BI group to develop analytical and operational reporting.
• Perform various statistical analyses using data drawn from diverse sources to map and identify genuine trends and relationships
• Identify data quality and consistency issues and work wif other teams improve data collection and processing

Environment: UNIX, Shell Scripting, Oracle 11g - PL/SQL, Erwin, TOAD 9.0.1, Informatica Power Center 9, Tableau 8.3, SAP Business Objects.

Confidential, CA

Sr. ETL Lead/Architect

Responsibilities:

• Lead a development team to implement high-quality solutions usingInformaticaand related technology for decision support systems
• Translate business requirements into integration specifications, working wif ETL developers to oversee the implementation of ETL designs and manage product releases/code migration through DEV, SIT, UAT and Production environment.
• Development and maintenance of interface control documents and facilitate requirements data mapping, and business rules definition sessions, document analysis, workshops, etc.
• Support the development and enforcement of integration standards using knowledge of the current data environment, regulatory issues and industry trends to identify and implement leading industry data practices.

Environment: UNIX, Shell Scripting, MS-SQL, Oracle 10g - PL/SQL, Erwin, TOAD 9.0.1, Informatica 9, Autosys Job Scheduling;

Confidential -CA

Sr. Project Lead/Consultant

Responsibilities:

• Lead, design, develop and support enterprise data governance processes - assess current state of data, identify source of truth,, identify data providers, Data Custodians, Data Consumers
• Work wif business subject matter to resolve issues in data policies, data definitions, data usage, data quality and metrics.
• Designs, develops, and present finding of complex data queries necessary to fully understand data quality issue/opportunities
• Discover, document, and analyze data collection and data transformation processes determining the cause of issue/improvement opportunities.
• Maintain and manage logical/physical model providing insight, feedback, in data governance processes.

Environment: MS Server 2008, SSIS, SSRS, Oracle 10g - PL/SQL, Erwin Data modeler r7, Talend DQ.

Confidential, San Jose-CA

Lead Sr. ETL-Data Analyst/Consultant

Responsibilities

• Lead project offering checkout for over 100 million customers and increasing revenue by 1-3%.
• Liaised wif business analyst to understand requirement and define road map for building data mart.
• Lead development and designed scalable decision framework and system of measurement that is dynamically, delivering optimal offer Confidential check out for customer.
• Designed and implemented multifactor segmentation strategy based on preferences that drives sustainable long term profitable consumer engagement.
• Analyzed & segmented customers by dividing a customer base into groups and implemented ETL processes governing data wif quality, for eligible customers using various payment products like BML, uACH, GE Credit and PAD.
• For merchants unsatisfied wif PayPal presentment, supported business by data analysis and generating BI reporting (Tableau - Dashboard, Charts) on Merchant conversions showing presentment improving conversions.

Environment:UNIX, Shell Scripting, Teradata 12 - SQL Assistant, BTEQ, Erwin Data modeler r7, Oracle 11g, TOAD 9.0.1, PL/SQL, Informatica Power Center 8.6, Tableau 7, Talend Open Studio 5

Confidential, Cupertino-CA

Lead DW/BI Consultant

Responsibilities:

• Analyzed customer’s requirements from its CRM system, gaps and challenges, designed and consolidated data model to meet both the business and technical requirements maintaining ERD document.
• Worked wif business partners internal and external by identifying data quality issues and addressed them in matter of urgency and priority.
• Maintained and sync data models, data mapping documents, aligning it wif business requirement.
• Lead ETL developers in implementation and responded to resolution of issues in support of OV suite of products OVSM, OVSD, OVSC.

Environment:UNIX, Shell Scripting, Oracle 10g - PL/SQL, Erwin Data modeler r7, TOAD 9.0.1, Informatica Power Center 8.6, MS-TSQL

Confidential, Oakland-CA, USA

Sr. ETL Lead

Responsibilities:

• Lead and manage integration requirement for migrating data
• Lead the application development team in providing support & maintenance of data conversion, migration.
• Maintained integrity of data movement into TCR and SAFE-T system.
• Defined road map in loading data into Transmission Control Repository (TCR) from source (Wachovia Apps).
• Created and designed logical and physical data model TCR covering project’s informational needs.
• Defined and captured metadata and rules associated wif ETL processes.
• Implemented ETL processes using Informatica Power Center..

Environment:UNIX, Shell Scripting, MS-SQL (TSQL) -SSIS, SSRS, Oracle 10g - PL/SQL, Erwin Data modeler r7, TOAD 9.0.1, Informatica 8.1.1. Trillium DQ.

Confidential San Ramon-CA

Sr. ETL & Data Lead (DW/BI)

Responsibilities:

• Lead & managed team of developers (8), and governed architecture of the productivity data mart.
• Liaised wif business subject matter experts in gathering requirements (Productivity related - KPIs)
• Supported business for its static and ad-hoc reporting requirement and troubleshooting data related issues.
• Setup-Up data governance policies for MDM, its process, controls in maintain single version of information
• Managed repository and mapped source data elements from - Avaya, CMS-Customer Management System, Outbound dialers, SBR, and IVR to CCPM systems.
• Designed and developed technical/functional specification for ETL development and implementation.
• Defined ETL road map - analyzing dependencies for workflow for various ETL processes.
• Analyzed source data related to Work force, Call Stats/Productivity, Contact, Contact quality, Training, Hierarchy Final, Coaching.
• Applied business rules to the data in the raw data mart and loaded it to the reporting data repository.

Environment: UNIX,Teradata - SQL Assistant, BTEQ, Mload, FastLoad, FastExport, Python, Oracle 10g - PL/SQL, Erwin DM r7, TOAD 9.5, Informatica Power Center 8.6, MicroStrategy 8.1

Confidential, Seattle-WA, USA

Sr. ETL & DW/BI consultant

Responsibilities:

• Analyzed business requirements – prescription specific data sources consist of Patient, Doctors, Drug, Store related information.
• Architected and implemented end-to-end solution building data models and DBMS schema.
• Defined and executed the technical characteristics of the overall strategy for DW and ETL.
• Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.

Environment:UNIX SunOS 5.10, Shell Scripting, Oracle 10g – PL/SQL, SQL Server Integration Service (SSIS), Erwin Data modeler r7, TOAD 9.0.1, PGP Encryption, network protocols- FTP, telnet, HTTP(S), and SSH.