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.