SUMMARY

• Expertise in Dimensional Modeling - Star and Snowflake
• Expertise in Conceptual, Logical and Physical data models - OLTP and OLAP.
• Expertise in ETL Architecture, Design & Development - INFORMATICA 9.x
• Strong experience in developing home grown ETL frameworks - PL/SQL and T-SQL programming
• BI Schema Architecture- Schema objects, Public objects, Report service documents - MICROSTRATEGY 9.x
• Business Intelligence in Cloud based Environment
• Expertise in BIG DATA (Hadoop) technologies - Hive, Sqoop, Hbase, Map Reduce and HDFS
• Demonstrated expertise in EDW Solution and Data Architect
• Data Analysis, Data governance and Data quality reporting
• Published, updated, and provide training on data standards, polices, and procedures.
• Extensive experience in RDBMS - ORACLE 11g/10g/9i, MS SQL SERVER, DB2 UDB and MySql
• Strong Experience in Data Model - Erwin and MS Visio
• Good understanding of MPPs -Teradata, MS SQL PDW
• Good at scripting languages - Perl, Unix shell
• Strong Experience in Agile-Scrum Delivery model

PROFESSIONAL EXPERIENCE

Confidential - Addison, TX

Responsibilities:

• Work with the account manager in reviewing proposals and bid documents
• Preparing road-map for a new product

Confidential - Oakland, CA

Technical Architect / Lead

Responsibilities:

• Responsible for identifying and controllingBIprojects scope, quality, and schedule. Worked on strategic initiatives
• Implementing Business Intelligence and Data Warehousing principles, ETL methodologies, Approaches, Technologies and architectures including the concepts, designs and usage of data warehouses and data marts
• On-site interaction with Product Management
• Responsible for Dimensional Data Modeling
• Developed ETL solutions using Informatica PowerCenter 9.x
• Involved and managed an ETL conversion project to convert existing ETL logic in Legacy stored procedures to Informatica PowerCenter
• Worked alongside BI team, DBA team and the application development team to identify and fix performance bottlenecks and data quality issues
• Created a pilot environment for the development team to test Informatica Data Quality tools
• Mentored team members with velocity methodologies on coding and naming standards
• Coordinated releases and liaison with Production Support team on issues logged during batch loads
• BI Schema Architecture - Large Scale Multi Enterprise, Multi-Tenant Environment
• BI Deployments - Setting up process
• BI Administration - Data security and User accessibility
• Adhere to Agile Development
• Agile - Scrum Master
• Deployment Strategies
• Produced technical artifacts including Data dictionary, Bus Matrix, Data Flows, ER diagrams, Data Interaction Diagrams, Mapping Documents etc.

Confidential

Technical Architect / Lead

Responsibilities:

• Architecture, Design & Development of complete end-to-end Data Flow (RDBMS - HDFS - NoSQL(HBase) - RDBMS)
• Design and development of ELT / ETL process
• Development using Hadoop ecosystem frameworks
• Integrating DW and Hadoop

Confidential, Mountain view, CA

Data Architect / Senior Engineer

Responsibilities:

• Developed project plan to support the business process reengineering effort, the development of the business architecture, and the supporting artifacts to the complete the logical layer of an data warehouse implementation
• Responsible for Dimension Modeling
• Responsible for Logical and Physical data model
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Responsible for “prototyping” for each model as POC to technical team
• Extensive involvement in performance tuning and Query Tuning (Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice)
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.

Confidential - Bellevue, WA

Sr. Database Analyst/ Project Lead

Responsibilities:

• Responsible for Dimension Modeling
• Responsible for Logical Model and Physical implementation
• Architect and Design of home grown ETL framework
• Developed ETL using database programming PL/SQL
• Develop logical and physical design for variety of data formats to process very large amounts of data, including batch and real-time data.
• Worked closely with DBAs, Product development teams, infrastructure and project managers in agile environment to produce deliverables
• Extensive involvement in performance tuning and Query Tuning (Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, db2advice)
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Maintenance of data warehouse, data fixes, fixing existing bugs
• Produced technical artifacts including Data Flows, ER diagrams, Data Interaction Diagrams etc.
• Support all production oracle issues as needed and participate in emergency on call support activities

Confidential

Sr. Database Analyst/ Project Lead

Responsibilities:

• Involved in complete product life cycle.
• Responsible for system study, requirement analysis, converting high-level requirements of the core system into detailed requirements documentation for the technical phase of the project.
• During the different phases of project execution, I have solicited input and feedback from the clients to determine application needs.
• Designed & Pipelined the log data from different components to the database using log4j 1.2.9 as a pug-in.
• Designed the database schema using Erwin.
• Designed, developed and integrated back end using Oracle PL/SQL procedures/packages (development using Toad 8.2)
• Responsible for maintaining the testing, integrity, and availability of data throughout the project life span.

Confidential

Sr. Database Analyst

Responsibilities:

• Involved in complete project life cycle.
• Responsible for system study, requirement analysis, converting high-level requirements of the core system into detailed requirements documentation for the technical phase of the project.
• Designed the database schema using Erwin/ERX 3.5.2
• Designed, developed and integrated back end using Oracle PL/SQL procedures/packages (development using Toad 8.2)
• Responsible for maintaining the testing, integrity, and availability of data throughout the project life span.

Confidential

Database Analyst

Responsibilities:

• Designed and developed data migrations techniques for existing products.
• Involved in building the transfer tool, modified the existing tools for known applications. (using oracle SQL*Loader & PL/SQL )
• Developed PL/SQL procedures needed for batch migration.
• Restore/backup data backups from client sites to staging servers (using oracle imp/exp utility)
• Data migration to staging area for testing and client reviews etc.
• As a part of client review, worked in conjunction with support team to resolve database as well as migration issues.
• Transferred the data to final destination databases after the final migration.

Confidential

Database Analyst

Responsibilities:

• Working with Oracle databases to manage data for development, training and production environments.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Developing and Tuning SQL, PL/SQL triggers and stored procedures.
• Developed SQL *Loader scripts, conversion scripts for the conversion of the data for schema design changes.