We provide IT Staff Augmentation Services!

Senior Consultant/data Architect Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • I have over Fifteen years of IT consulting career, helping Enterprises to architect, develop, implement and manage the Business Intelligence, Customer Relationship Management & DATAWAREHOUSE solutions.
  • I have been consistently successful in achieving the customer’s objectives and priorities using the Technology, People and Tools.
  • I have strong experience & training in the design, development, testing, deployment and production support of Oracle Technologies (Siebel CRM, Data Warehouse, BI Analytics OBIEE) and INFORMATICA Integration solutions. I have excellent communication, interpersonal skills and analytical skills.
  • Worked over 10 years as Technical Lead/Project Management leading multiple projects from estimates, design, development, testing and production support using SDLC methodology in the Enterprises.
  • Over 5 years involved in Business Requirements Analysis, Application Design, Data Modeling, Development, and Testing of Data Warehousing as Technical Lead, ETL Integration/Reporting Developer and Architect.
  • Extensive experience in Data Warehousing using Siebel Analytics/OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand - Alone and Integrated Siebel Analytics implementations. Extensively worked in creating hierarchies and aggregates in the BMML.
  • Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE. Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
  • Keeps informed & updated on the latest IT Technology such as Service Oriented Architecture, Cloud Computing and Big Data

TECHNICAL SKILLS:

DW Tools: OBIEE 10g, 11g, Informatica PowerCenter, DAC, AutoSys

Languages: SQL, PL/SQL, VBScript, JavaScript, Java

CRM: Siebel Analytics, BI Publisher, Siebel 7.x, 8.x

Databases: Oracle 11/10g, DB2, MS SQL Server

Tools: ClearCase/Quest, HP QualityCenter, XML, MS Project, Visio

Operating Systems: Window 2000 Server, UNIX, AIX, Linux, Mainframe OS

EXPERIENCE:

Confidential, Boulder, CO

Senior Consultant/Data Architect

Responsibilities:

  • Application Data Analysis, Migration & Deployments
  • Unit Testing, Catalog/Security Management, and defect Management
  • Building the Data Export strategy and Data Loading process using Informatica
  • Customization to the User Dashboard, ETL Configuration & BI Reports

Confidential, Salem, OR

Lead member and Reporting/Analysis Architect

Responsibilities:

  • Application Configuration/Interface Development, Migration & Deployment
  • Data Analysis and Data Flow from and to various data sources
  • Application Integration Requirement and Design, Coding & Mapping Review
  • Customization to the User Dashboard, ETL Configuration & BI Reports

Confidential, Reston, VA

Lead member and Reporting/Analysis Architect

Responsibilities:

  • Application Configuration Development, Migration & Deployment under SDLC 2.0
  • Customization to the User Dashboard & BI Reports for Service Analytics
  • Involved in Data Analysis & Data Flow between Enterprise Applications
  • Build the Reporting Data warehouse using OBIEE, SAS & BI Publisher for Reporting
  • Release management for deployment of SRF, RPD, templates, CSS, Catalog, Security and configuration artifacts to QA, UAT and Production
  • Batch Data Load & ETL Interface design using EIM, Informatica and AutoSys

Confidential, St Louis, MO

Integration Analyst

Responsibilities:

  • Modification for SQL packages and Informatica ETL mappings for enhancement
  • Customization to the User Dashboard & BI Reports
  • Application Migration Analysis, Deployment, Administration & On-Call Support
  • Streamlined and optimized the ETL and Batch interface from various Data Sources jobs.
  • Review/update the customization of Mappings with the best practice for upgrade.
  • Administration and Migration of Siebel Analytics - 77 to OBIEE
  • Customization and Deployment of the RPD, ETL mapping, Dashboard & BI Reports
  • Enhance the Data interface with external system (SAP, legacy system) using EIM, EAI, XML, XSL and Web services.
  • On Call production support, troubleshooting and resolution of ETL data loads

Confidential, Austin,TX

Integration Analyst

Responsibilities:

  • 3rd Level Production support
  • Root/Cause analysis for Production, Hot-fix and QA testing cycle support
  • Gather User requirements for Application/Integration enhancement, design & Configuration and Map the user requirements to the Application Data/functional Design
  • Write the Technical Design document and conduct code reviews
  • Define/Modify the XSD Schema, Integration Objects, Work-flow & Business Services.

Confidential, Dallas, TX

IT Project Lead

Responsibilities:

  • Gathering and Reviewing the Business Requirements and GAP analysis
  • Conduct conference room pilot session
  • Setting up the test/benchmark environment for Evaluation
  • Develop sales process & mapping the CRM Product
  • Conduct design workshop, user session for training & deployment

We'd love your feedback!