Manager/Architect Resume

SUMMARY

A PMP certified professional with 13 years of experience in the field of Data Warehousing and Business Intelligence
Presently working as Manager/Architect at Confidential & Confidential LLP, USA
Richly experienced in design & development of enterprise level DW/BI solutions
Proven abilities in OBI Apps, OBIEE, Informatica, DAC, SQL, Tableau, Python and UNIX
Good exposure to MDM and Data Quality frameworks
Good exposure to Big Data, Hadoop, HDFS, Map Reduce, PIG, HIVE and HBASE
Good understanding of Process Benchmarking for IT and Finance functions
Excellent communication, leadership and team management skills
Excellent working experience with onshore and offshore delivery models

Areas of Expertise

TECHNICAL SKILLS

Software Languages: SQL, PL/SQL, Python

Methodologies: Agile, Iterative, Waterfall

RDBMS: Oracle, SQL Server

Tools: OBI Applications, OBIEE, Informatica, SSIS, Tableau

ERP System: Oracle Applications R12

Application Servers: Weblogic

Hadoop Framework: HDFS, Map Reduce, PIG, Hive, HBase, Sqoop, Flume

PROFESSIONAL EXPERIENCE

Manager/Architect

Confidential

Responsibilities:

Leveraged multiple analytical tools such as OBIEE, Tableau, SQL Server and Excel for analyzing data sets and presented results to senior management.
Managed development of regulatory reporting framework for Liquidity risk - FR 2052b and 2052A using Informatica and SSIS.
Led requirement gathering sessions for implementation of various data warehousing and business intelligence initiatives across multiple business units / functional areas.
Created business and technical requirement documents for variety of technology implementation projects; liaised between business users and technical development teams.
Partnered with stakeholders (internal and external) to identify needs, articulate key user and client benefits while playing crucial role in supporting business development initiatives.
Created sales documents to support business development activities such as point-of-views, proposals, demos and presentations.
Oversaw multiple work-streams and managed offshore resources on multiple technology development projects.

Project Manager

Confidential

Responsibilities:

Developed project plan, architecture design and delegated tasks within project team.
Supported business development activities by creating proposals and presentations.
Participated in a number of pursuits and helped generate sales.
Designed and developed all three layers of RPD using OBIEE Admin Tool.
Excellent exposure with upgrading of RPD/Catalog, Scheduler from OBIEE 10g to 11g.
Designed high available, scalable and fail-safe Architecture for OBIEE deployment.
Designed the data model using star-schema.
Developed & deployed of RPD using OBIEE Admin Tool.
Designed & developed reports using OBIEE and BI Publisher 11g.
Configured LDAP for user authentication using Weblogic admin console.
Configured security using roles & policies in OBIEE 11g.
Coordinated efforts between onshore and offshore teams to ensure 24x7 development effort with cost optimization.

Program Analyst

Confidential

Responsibilities:

Gathered business requirements and managed key stakeholders.
Designed data model and reporting solution architecture.
Led installation and configuration of OBIEE 11g.
Led upgrade of RPD/Catalog, scheduler schema from OBIEE 10g to 11g.
Designed Data Model using Star-Schema.
Designed & developed RPD, reports, dashboards and configured agents using OBIEE.
Configured user authentication using LDAP
Implemented security using application roles & policies in OBIEE 11g aligned to EBS.
Led performance tuning of existing model leading to high performing and scalable design.

Lead Consultant

Confidential

Responsibilities:

Responsible for creating technical POCs and getting necessary project approvals.
Installed and configured OBIEE 11g.
Performed upgrade from OBIEE 10g to OBIEE 11g.
Designed the Data Model using Star-Schema.
Designed, developed & deployed RPD using OBIEE Admin Tool.
Designed and developed custom reports and dashboards in OBIEE.
Migrated existing Discoverer Reports to OBIEE 11g.
Implemented authentication (Single Sign-On) & data level security in OBIEE.

Consultant

Confidential

Responsibilities:

Responsible for requirements gathering and development of technical design
Installed, configured and customized OBI Apps 7.9.6.2/7.9.6.3.
Designed and developed ETL mappings using Informatica 8.6.1 for dimensions and facts.
Designed, developed & deployed RPD using OBIEE Admin Tool.
Developed custom reports and dashboards in OBIEE.
Designed scheduling mechanism for ETL run using DAC 10.1.3.4.
Implemented authentication & data level Security in OBIEE.
Coordinated between offshore team members and onsite business analysts.

Applications Engineer

Confidential

Responsibilities:

Responsible for design, development and testing for Clinical Analytics products.
Responsible for gathering requirements and translating them to technical design.
Designed and developed ETL mappings using Informatica.
Developed RPD using OBIEE Admin Tool for reporting purpose.
Developed custom reports and dashboards in OBIEE.
Configured OBIEE 10g with Weblogic Application Server.
Involved in the development of Star-Schema data model along with the business analysts and Data-Modeling Team.
Designed, developed and maintain version control system and deployment strategy using CVS and ARCS.
Developed automation scripts using Perl and Unix Shell scripting for process improvement.
Coordinated product management and strategy team for ensure technical feasibility of business requirement document and functional design documents through calls.

Software Engineer

Confidential

Responsibilities:

Responsible for product development for a global Online Learning Management System organization.
Developed analytics reports using SQL & PL/SQL.
Responsible for installation, configuration, patching of Oracle DB, DW/BI Products.
Involved in preparing quality documents for the implementation.