We provide IT Staff Augmentation Services!

Bi- Data Architect Resume

Los Angeles, CA

SUMMARY:

  • Around 12 Years of experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems
  • 3 Years of BI - Data architect experience.
  • Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.
  • Completed a large legal expense EDW project that feeds data on a monthly basis
  • End to end development of business intelligence solutions. Solution selection, business analysis, project management, and ETL coding responsibilities
  • Good understanding of Data warehousing concepts/methodologies- Involved in architectural design, Data Modeling (Star Schema, Snowflake), Designed dimension, Fact and Aggregate tables and slowly changing dimensions
  • Provided Architectural design for engineering data unit and launched an ETL application for converting legacy MHC data structures and mapping them to Oracle table structures
  • Interpreted high-level business requirements into Logical Business Models (Facts, Dimensions)
  • Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
  • Enforced naming standards and data dictionary for data models.
  • Performed SQL Query performance analysis using Toad Client software for Oracle / SQL Server.
  • Responsible for data model design; SSIS/Informatica ETL architecture, design and development; OBIEE architecture, design and development
  • Applied normalization as appropriate. Implemented Type 2 slowly changing dimensions. This data warehouse was several hundred Gb in size.
  • Designed new ETL packages to support changed environment.
  • Create new, modify existing and manage all Informatica ETL programs (more than 250)
  • Proficient in configuring the physical/logical/presentation layers of the OBIEE Administration Tool
  • Extensive working experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks and Repository Variables.
  • Designed/Developed complex reports in OBIEE Answers/Dashboards, BI Publisher Reports and trained the Business/ Power users to create reports in OBIEE
  • Hands On experience integrating OBIEE with Oracle E-Business Suite - Financial Analytics, Oracle Supply Chain and Order Management Analytics
  • Configured segmentation in OBIEE 11g.
  • Created marketing segments in OBIEE for e-mail and mail notifications.
  • Proficiency in object level and data level security management of all aspects of OBIEE.
  • Worked in Multi-User Development Environment (MUD) in OBIEE.
  • Designed and developed reports from ODS, OLTP, EDW and OLAP.
  • Expertise in implementing complex business rules by creating robust mappings, mapplets and reusable transformations using Informatica PowerCenter 9.5.1/9.6.1 and SSIS
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x / 8.x) reports.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Functional experience in Health Care, Manufacturing and Retail Industry. Have Federal Government experience.
  • Excellent skills in Client Relationship Management, interaction with business partners, subject matter experts, portfolio architects and technology partners.
  • Involved in Onsite & Offshore coordination.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003/2008

Languages: SQL, SAS, VB 6.0, COBOL

Databases: Oracle 10g/11g/12c, SQL Server 2008/ 2012,IBM DB2, MS Access

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling

ETL Tools: Informatica Powercenter 9.5.1/9.6.1 , SSIS,ODI 11.1.1

BI Tools: OBIEE 10.1.3.4.1 / 11.1.7.1 / 12 c, BI Publisher, Tableau 8.2 / 9.0.1

OBI APPS: 7.9.6.4 and 11.1.1.7.1

Data modelling tools: Toad Data modeler, ERwin

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

BI- Data Architect

Responsibilities:

  • Experience in Analyzing Data and developing Data Warehouse
  • Drove the standardization of data warehouse design and ETL towards a dimensional model.
  • Converted Hyperion/SQR reports to Informatica/SSIS.
  • Created new ETL Package/Workflow and managed existing packages/workflow.
  • Implemented processes to ensure complete and consistent data extracts were provided to the data warehouse.
  • Work with Enterprise Data Warehousing team to design effective Star/Snowflake schemas for effective reporting.
  • Established the OBIEE 11g BI suite of tools as the preferred standard for presentation and worked diligently to optimize the application architecture and performance.
  • Migrated Hyperion Reports to OBIEE
  • Built out OBIEE repository to meet organization needs
  • Responsible for performance tuning ETL and analytics applications
  • Upgraded custom reporting application from OBIEE 10.x to OBIEE 11g
  • Managed the application maintenance and support relationship for business intelligence with LA Care.
  • Create new and modify existing reports for Senior Management, Financial Management, Claims Management and the Medical Management using OBIEE
  • Managed BI projects and third party resources to deliver results.
  • Improved communication between teams to build trust and a sense of community. Regular mentoring meetings with key analysts enhanced the team's credibility within the company.
  • Responsible for ensuring the Scheduled report jobs complete successfully
  • Administered the OBIEE 11g environment, including RPD development and security
  • Used salesforce as source to HR reports.
  • Configured new application roles and session initialization blocks as part of 11g upgrade.
  • Use aggregate functions, fragmentation and time series functions to provide effective interactive Capitation reports and Claims Processing reports to users.
  • Conducted presentations to other lines of business as a meta role to show value of Tableau as a BI tool
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Full Life Cycle Development - Includes User Interviews, Analysis, Requirements gathering, Design, Development Etc
  • Participate in brainstorm and peer review sessions to do process improvements.

Environment: OBIEE11g / 12c, BI Publisher, Oracle 11g, Tableau 8.2 / 9.0.1, Hyperion, Informatica Power Center 9.5.1/9.6.1 , SSIS, Oracle Data Integrator 11g, SQL Developer, MS SQL Server 2008/2012, Windows 7, TFS, MS-Office Suite and Visio.

Confidential

BI Architect

Responsibilities:

  • Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary. Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
  • Worked on Business data modeling.
  • Analyzed metadata and slowly changing dimensions.
  • Have setup data connection for source systems.
  • Extracted data using SSIS packages (ETL) from different server locations and data sources.
  • Adding new Columns to the Warehouse in accordance with OLTP changes and bringing them to OLAP with new logic to Analytics Metadata for the Star Schema configuration in the Repository.
  • Created Repository and OBIEE reports.
  • Worked on the OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
  • Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer.
  • Developed a Roadmap for the Client Dashboard and work with Client Partner to deploy a beta dashboard
  • Worked for performance tuning by finding out the bottlenecks in Reports.
  • Involved in Migration in Development, Testing and Production environment.
  • Developed security setup for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
  • Extensive Working Experience in creating Calculation Measures, Time Dependent Measures, Initialization Blocks, Repository Variables and Cache Management.
  • Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Implemented Usage Tracking for better administration and auditing purposes.
  • Worked with BI Publisher 11g for document composition and delivery.
  • Designed templates and created reports using BI Publisher.
  • Using BI Publisher developed reports in MS Word using integration feature
  • Integrated Oracle BPM with Web Center Content and BI Publisher reports.
  • Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
  • Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents

Environment: OBIEE 11g/10g, MS SQL Server 2008, Web logic Server, SQL, Informatica 9.5.1, SSIS, BI Publisher.

Confidential, Westborough, MA

Lead BI Consultant

Responsibilities:

  • Customized the Financial Analytics SDE/SILOS Informatica mappings, RPD and reports according to the reporting needs of the client.
  • Identified Facts and Dimensions (with levels & hierarchy) and requested changes to the Data Warehouse as per gaps.
  • Played a key role in installing and configuring OBIA 7.9.6.3 for Oracle Finance Analytics on Windows 2008 Platform
  • Debug and resolve and Financial Statement Generator (FSG) reporting problems for month end purpose
  • Prepared custom financial reports for month end MU process using FSG
  • Created Ad-hoc reports using Oracle FSG.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schema.
  • Added Aggregate measures using Aggregate Persistence Wizard
  • Enabled Usage Tracking Table and Dashboards
  • Worked on the Time Series Wizard and implemented time comparison measures.
  • Worked on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
  • Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations
  • Participate in meetings with business users to review the detail design.
  • Manage offshore team of 4 members and managed deliverable.
  • Reviewing deliverable provided by offshore team
  • Attending milestone meetings with clients.
  • Managed resource issues through resource leveling.
  • Documented Lessons learnt for future reference.

Environment: OBIEE 11g, Windows Server 2008, Web logic Server, OBIA 7.9.6.3, Oracle 10g, Informatica 8.1, BI Publisher, Oracle FSG.

Confidential, Stamford, CT

Lead BI Consultant

Responsibilities:

  • Extensively Involved in Production support, Enhancement and SME support to Rate change management and Warehouse management system.
  • Customized the Order management SDE/SILOS Informatica mappings, RPD and reports according to the reporting needs of the client.
  • Identified Facts and Dimensions (with levels & hierarchy) and requested changes to the Data Warehouse as per gaps.
  • Played a key role in installing and configuring OBIA 7.9.6.2 for Oracle Supply Chain Analytics on Windows 2008 Platform
  • Experience in Siebel Marketing. Managed Rate change communication through Siebel marketing and campaign module.
  • Created push notification using Siebel CRM - marketing and created Survey pages for feedback.
  • Configured segmentation in OBIEE 11g.
  • Created marketing segments in OBIEE for e-mail and mail notifications.
  • Involved in the Peer-Peer Review process from design to implementation.
  • Preparation and review of test plan and test scripts and for unit testing, Integration and system testing.
  • Participate in meetings with business users to review the requirements and provide suggestions when necessary.
  • Project monitoring at various levels with the Team.
  • Follow the quality procedures; prepare the quality documentation and Quality control.
  • Managing Remedy tickets, scheduling and tracking it to closure to meet SLA.
  • Managed security privileges for each subject areas and dashboards according to user requirements.
  • Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Created various narrative views, pivot views, chart views of the data returned by the request.
  • Embedded content such as links/images and HTML objects to create Intelligence dashboards.
  • Implemented drill-down, guided navigation and Dashboard prompts in making interactive and effective dashboards and reports
  • Created Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
  • Designed Interactive Dashboards and created dashboard prompts with multiple selections
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
  • Involved in creating dimensional hierarchies to support drill downs.
  • Perform in depth Data Analysis and implemented Cleansing process and Data Quality

Environment: OBIEE 10 g, OBIEE 11g, Windows Server 2008, Web logic Server, Shell Scripting, Informatica 9.1.

Confidential

Programmer

Responsibilities:

  • Maintain and enhance the corporate application using COBOL, VSAM, DB2, File-Aid and CICS.
  • Developing and review of source code in COBOL, CICS, DB2, JCL, VSAM, Stored procedures
  • Review the code to check for programming standards and format.
  • Develop COBOL programs as per the requirements from the clients
  • Design unit test cases for the requirement.
  • The applications also involved interfacing with People Soft applications that provide us with input data.
  • Planning, tracking and preparing status reports for Project management dashboard (PMO)
  • Used SQL, queried the DB2 database to browse/edit in the development and as well as in the preparation of the Test data.
  • Execute the test cases and check for any deviations from the expected results.
  • Fix any defects found after logging the reason for the defect and the possible solution.
  • Coordinate with the testing team to complete functional testing of the module.
  • Fix any bugs that are reported after doing an impact analysis of the possible fix.
  • Developed new online screens using IMS DC and Transform.

Environment: OS/390, JCL, DB2, COBOL, SQL, VSAM, IMS, Transform.

Hire Now