We provide IT Staff Augmentation Services!

Bi Cloud Architect Resume

RedmonD

SUMMARY

  • 9+ Years of experience in the field of Data - warehousing /Business Intelligence and Cloud implementation with expertise in implementing solutions based on Business Objects XIR2/R3/R4, HANA, Data services 4.0,Xcelius 2008, Bex explorer, Bex Query Designer, Business Warehouse, Informatica 8.6.1, Oracle 10g, Teradata, SQL Server 2008 and sales force integration
  • Implementation Experience with Amazon AWS architecture EC2/ Redshift/S3/MangoDB, Tableau and Informatica cloud integration.
  • Worked in Confidential for Cloud solutions BI.ondemand on Architecture and engineering team
  • Developed creative and scalable Datawarehousing and business Intelligence solutions for leading Financial and Life science clients using Informatica, Business objects, SQL server, Oracle and HANA
  • Solid understanding of system architecture and data warehousing concepts like Ralph Kimball methodology, Dimensional modeling, OLAP systems Data Marts and Confidential Business warehouse design.
  • Design and build BI and ETL Solutions / Strong knowledge in Software process and standards / Experience handling huge Data marts and Operational Data Stores / Expertise in different modeling techniques like Logical Modeling, Relational ER Modeling, Dimensional and Dimensional Relational Modeling
  • Excellent Communication and Client Interfacing Skills / Good Team Leadership & Collaboration Skills / Quick Learner of new technologies / Consistent and Key performer in every project executed
  • Agile / Scrum development and implementation expert

TECHNICAL SKILLS

  • Business Intelligence
  • /Data Architect/
  • AWS cloud
  • AWS
  • EC2
  • S3
  • Redshift
  • MangoDB
  • IAM
  • Route53
  • VPC
  • Subnet
  • ELB and RDS
  • Business Objects XIR2
  • R3& R4(IDT
  • Designer
  • Web intelligence and Import Wizard)
  • QWAAS Live office
  • Confidential BI 7.0(Bex explorer
  • Query designer and Web Application Designer) and
  • Crystal Reports XITableau 8.1.6
  • ETL
  • Informatica cloud/
  • Data services 3.0/4.0
  • Informatica 8.6.1/cloud
  • Oracle PL/SQL
  • SQL Server DTS
  • HANA
  • Redshift
  • MS SQL SERVEROracle 10GTeradata and
  • MDX query
  • Programming Languages:
  • SQLPL/SQL
  • C
  • C++Python
  • VB6
  • Platforms:
  • Win 98/NT/2000
  • Unix
  • BEA Weblogic 8.0
  • Apache Tomcat 5.5
  • MS SharePoint
  • Mercury Test DirectorMercury Quality Centre 10

PROFESSIONAL EXPERIENCE

BI Cloud Architect

Confidential, Redmond

Responsibilities:

  • Implementation and maintenance of BI cloud Infrastructure
  • Establishing VPC connection between Confidential Redmond and AWS Datacentre
  • Built the secure three tier architecture system within AWs using subnet/security groups/IAM
  • EC2 instance / Redshift /S3 launching, configuration and maintenance
  • S3 script development for dataload, backup and archival process
  • Automation script based AWSCLI and BOTO system monitoring with Nagios/Amazon cloud watch/Big brother/PRTG
  • Modeling physical and logical model for EDW and DataMart
  • Designing ETL Jobs for Redshift /HANA
  • Installation, configuration and support of Tableau
  • Designing and deployment of Tableau reports
  • Designing and deployment of Salesforce related Informatica ETL
  • Setting up the operational process for system maintenance
  • Interacting with Change management and compliance team on best practices

BI Cloud Consultant

Confidential, Palo Alto

Responsibilities:

  • Implementation and maintenance of BI cloud Infrastructure in AWS
  • Designing Pre-configured data services Jobs for SFDC and SFTP configured for BI tenants
  • Installation, configuration and support of HANA database
  • Designing and deployment of HANA artifacts to HANA based customers
  • Onboarding and configuring tenants and automating the deployment process
  • Designing and deployment of BI.ondemand application layer
  • Development of Streamwork based BI reports in BIOD with HANA
  • Setting up the operational process for BIOD maintenance
  • Interacting with Change management and compliance team on best practices

BI Consultant and Business Analyst

Confidential, NY

Responsibilities:

  • Designed Business Intelligence solution as a Lead consultant.
  • Created complex reports and dashboards from the meta-models using Universe Designer Web Intelligence, QWAAS and Xcelsius
  • Developed interactive Metric dashboards and Web intelligence reports with row level security, drill drown, Alerts and Ranking functionality
  • Desgined and developed Datastore objects and infocubes, Bex queries for Wyeth HR data and Integrated the Data with existing Xcelsisus dashboard
  • Designed monthly Prescription assistance report with web application designer
  • Designed and Implemented Informatica Mappings and workflows from external systems like Argus 4.2, Med, Medics and Novalert load etc
  • Responsible for requirement gathering, feasibility study, Requirement and design documententation
  • Created scalable Meta models and universes to satisfy adhoc requests from business units
  • Designed and Customized the BI Platform using JDK according to growing needs of business.

BI consultant

Confidential, Seattle

Responsibilities:

  • Involved in ED BI Requirement gathering, System Design, resource planning and implementation
  • Developed Web intelligence repots, EPM and Xcelsius dashboards for Home Loans and Deposits subject area
  • Designed and Integrated BO Universe and Webi report based on existing BW Infocubes and ODS
  • Built InfoObjects, InfoSources, InfoPackages and InfoCubes for HR reports
  • Performance tuned reports by creating Aggregate tables for the transactional reports and dashboards.
  • Performance tuned Informatica mapping and reduced the significant execution time
  • Designed project specific tools like XCEL Universe designer and DESKI documenter for expediting the enhancement process.
  • Maintained End user communication Process through InfoView Page, SharePoint and MERSI Distribution List
  • Displayed excellent client interfacing skills working with one of the highly demanding customers.
  • Coordinated and lead a BI team including onsite and offshore.
  • Interacted with multiple vendors and suppliers effectively

BI Consultant

Confidential, WA

Responsibilities:

  • Analysis of the existing (LODS and CMDB) system and preparing the high level ETL design document for the new enhancement.
  • Developing the informatica mappings as per new design document.
  • Preparation of detailed unit test cases and System Integration testing for the mappings developed thus ensuring minimal defects further
  • Played an ETL developer lead to co-ordinate the offshore development and QA testing team to complete the project successfully on right time.
  • Involved in analyzing the production related issues and fixing the issues at provided minimal required time.
  • Played an important role in improving the performance of the mappings and stored procedures by analyzing them, identifying potential gaps and plugging them

BI & ETL Developer

Confidential

Responsibilities:

  • Involved in all the phases of the project creating High level designs, process flows and program specifications.
  • Designed complex CRM reporting system that involves linked universes and aggregate table concepts.
  • Involved in migration of Business Objects 6.5 components to XI R2(Users, Content and Security Design)
  • Developed number of Stored Procedures using Oracle PL/SQL and SQL.

Hire Now