SUMMARY

• A result - oriented and innovative IT professional with 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
• Design and developed data warehouse and business intelligence solutions
• Managed organizational data that embodies - Data Quality, Data Management, Data Policies and Risk
• Discovery of data assets to manage content, structure, rules, relationship and quality of data.
• Defined and delivered business processes and metadata foundation architecture for Data Subscription / Distribution, Security, Governance, Compliance, and Stewardship
• Defined roadmap from Data protection policies to control standards, objectives and activities
• Ensured quality of data by cleansing, matching and unifying data across data domains
• Maintained and managed data architecture/data structure of an organization.
• Build Logical and Physical data models with 3NF, Star and Snowflake Schemas for OLTP, OLAP and Operational data store (ODS) applications.
• Expert knowledge in Ralph Kimball and Bill Inman methodology for Dimensional Modeling
• Build ETL/ELT Architecture - focusing on its subsystems - Data Profiling, Change data Capture, Extract data, Cleanse data, Error event tracking, auditing data, de-duplicating data and confirming data.
• Transformed and implemented ETL/ELT processes meeting business requirements.
• Optimized processes - tuning ETL/SQL Queries for DBMS - Teradata, Oracle, MS TSQL, mysql.
• Defined and Managed BI - charts and dashboards using Tableau, BO, MicroStrategy, Cognos.
• Expertise in user requirement study, Analysis, Design, Development, Implementation, Testing, Customization, Maintenance and Support
• Provided end-to-end solution, building multi-tier SOA SWIFT compliance canonical architecture for bank
• Provided tier-1, tier-2 and tier-3 level support and tracked issues/requests for system enhancements
• Managed configuration - identifying and controlling product release and changes.

TECHNICAL SKILLS

Data Modeling -with ERDs: (ER Studio, Erwin) for OLAP, OLTP, ODS, DM, EDW.

Relational and Dimensional Modeling: ERDs

Schema: 3NF, Star & SnowFlake

Process Modeling: (MS Visio)

Methodologies: Agile, waterfall, OOAD, UML, OMT

DBMS: Teradata, Oracle, mysql, AsterData

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

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 with 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 with 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, San Francisco-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 with 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 with 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 with 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 with quality, for eligible customers using various payment products like BML, uACH, GE Credit and PAD.
• For merchants unsatisfied with 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 with 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 with 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

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 with 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 with 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

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.