It / Bi Analyst, Technical Lead Resume
San Jose, CA
SUMMARY:
Senior IT Professional with extensive experience in the IT industry. Strong analytical and technical skills with a meticulous passion for data governance and business process analysis. Adaptable skills in working with the business and technical teams to deliver reliable IT solutions. Nine recent years working in the Business Intelligence space as an Analyst / Data Architect / Tech Lead and SME (Subject Matter Expert) and prior to that, thirteen years in the Application Software space engaged in end to end SDLC, delivering custom applications using relational databases and tools.
EXPERTISE AREA:
- Business Intelligence Analyst
- Data Architecture & Governance
- Data Warehouse & Integration
- Master Data Management
- Data Modeling
- SDLC
- Windows / Unix
- Oracle Database and Developer Tools
- Teradata SQL
- Business Objects
- Informatica ETL
PROFESSIONAL EXPERIENCE:
Confidential, San Jose, CA
IT / BI Analyst, Technical Lead
Responsibilities:
- Delivered integrated base data from multiple oracle based source transaction systems for opportunity management to the Service Contract Management team on the Teradata EDW platform.
- Resolved performance bottlenecks by migrating process intensive batch processes to the Hadoop Platform.
- Enhanced the base data to include Advanced Services and Software opportunity to the hardware opportunity data.
IT / BI Analyst, Technical Lead
Confidential
Responsibilities:
- Migrated the Advanced Services BI data from the legacy Oracle based EDW to the Teradata EDW database.
- The primary goal was to migrate from the dimensional model to a 3NF model without impacting the business analytics tools (QlikView / BO / Tableau) that consumed the data.
IT / BI Analyst, Technical Lead
Confidential
Responsibilities:
- Delivered dimensional data / measures on Oracle database for Project Analytics using Business Objects.
- Delivered dimensional data/measures on Oracle Database for CKC ( Confidential Knowledge Center) reporting using Business Objects.
- Delivered dimensional data/measures on Oracle Database for TKL (Technical Knowledge Library - a subscription based customer enablement) reporting using Business Objects.
- Delivered dimensional data/measures on Oracle Database for S2S (Steps to Success - Partner Enablement) (CAP ( Confidential Achievement Program) Award for delivering on time).
Data Architect / Technical Lead
Confidential
Responsibilities:
- Introduced data governance and documentation standards by defining standard forms and templates.
- Created a consolidated document portal enabling easy access to release and entity level documentation
- Developed an end to end ETL/UI infrastructure / architecture diagram for ease understanding for the remote teams.
- Created a consolidated Data and process flow diagram which explains all data and ETL process flows.
- Defined infrastructure and architectural guidelines for ETL design and development (Oracle Warehouse Builder)
- Designed and delivered planned releases and tactical enhancements and worked with the global team in India to develop and enable them manage releases with least supervision while following all required standards and governance.
Confidential, Campbell, CA
Senior Consultant Data and Reporting Architect
Responsibilities:
- Defined and governed application / data standards to migrate the legacy Care (Clarify) application used by Technical Assistance Center, Metrix OpenUpTime used by Global Product and Services Team and Calico product configurator to Solectron configurator. (CAP ( Confidential Achievement Program) Award for delivering on time and quality).
- Designed reporting architecture deployed on Oracle based platform for an organizational data warehouse catering to the reporting needs Technical Services group.
Senior Consultant Technical Lead / Analyst
Confidential
Responsibilities:
- Delivered custom application software, following end to end SDLC including application analysis/design/development, application fine tuning, resolved database performance issues, defined application / data standards, user testing support, user training and new hire / Intern mentoring.