Senior Consultant/data Architect Resume
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 ArchitectResponsibilities:
- 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 AnalystResponsibilities:
- 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