PROFESSIONAL SUMMARY:

• 11+ Years of experience in the field of Data - warehousing and Business Intelligence and cloud implementation with expertise in AWS Redshift, Tableau, Informatica cloud, Oracle 11g/12C, SQL Server 2008/2012, Business Objects XIR2/R3/R4 and R
• 3+ Years of experience in the Big Bata, NoSQL and AWS BI implementation with experience in AWS Redshift, EMR, Mongo DB, Apache Hadoop, Apache Spark, Hive, Pig Script and Python
• Design and Implemented Business Intelligence solution in Hybrid Cloud Environment with AWS Redshift, EC2, S3, Lambda, Tableau, Informatica cloud and Attunity Replication. Designed the cloud Infrastructure security with VPC, VPN, Security Groups, IAM and Route tables
• Implemented Predictive analytics and statistical analysis solution for Major Aviation and Pharmaceutical client using R and Python
• Implemented and Maintained Confidential Multi-Tenant Datawarehouse Environment BI.ondemand and Lumira
• 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
• Solid understanding of system architecture and data warehousing concepts like Ralph Kimball methodology, Enterprise Datawarehouse, Dimensional modeling, Row/columnar data, OLAP systems, Data Marts and Confidential Business warehouse design.
• 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:

Primary Skills: Business Intelligence/Data Warehouse Architect/ Data Scientist

Reporting & BI Tools: Tableau 9/8.1.6, Business Objects XIR2, R3& R4(IDT, Designer, Web intelligence and Import Wizard)

Databases: AWS Redshift, Postgres SQL, MS SQL SERVER 2008/2012, Oracle 12c

NoSQL Databases: Apache Hadoop, Apache Spark and MongoDB

ETL: Informatica cloud, Informatica 8.X/9.X, Attunity Replicator & SSIS

AWS: EC2, S3, Redshift, IAM, Route53, VPC, Subnet, ELB and RDS

Programming: Python, C, C++, .Net and PL/SQL

Platforms: Windows 2008/2012 enterprise

PROFESSIONAL EXPERIENCE:

Data Architect/ Data Scientist

Confidential, Atlanta

Technologies: AWS Redshift, Lambda, S3, Tableau 9, Hadoop, Server 2012, R and Python

Responsibilities:

• Design and implement Datawarehouse on AWS Redshift to address the growing business Demand
• Identify and Implement NoSQL Database platform to analyze the Hauler Sensor Data
• Built ETL jobs to load data from various source systems like Hauler App, Microsoft Dynamics, Zuora and Salesforce
• Establishing a hybrid AWS environment with VPC, Subnet, Route Tables, IAM and VPN
• Developing complex data transformations for Fuel efficiency and Customer Cost saving
• Building Datmarts and summary tables in redshift for Tableau reports

DW&BI Architect

Confidential, Houston

Technologies: Tableau 9, Oracle 12c, Redshift & Informatica 9.X

Responsibilities:

• Analyzing data in various source system and identify the data redundancy
• Modeling the Master data Database Design with attributes from various system
• Building informatica jobs to load the data to staging area, Process the records through de-duplication and Data quality services
• Defining business rules for attributes and dimension
• Developing procedures for complex data transformations
• Loading the summary data in redshift using Attunity replicator and Building Tableau reports

BI Cloud Architect

Confidential, Redmond

Technologies: AWS CLOUD, SQL server 2012, Redshift, Informatica, Business Objects, Tableau 8.X/9.X

Responsibilities:

• Implementation and maintenance of BI cloud Infrastructure
• Establishing VPC connection between Confidential Redmond and AWS Datacenter
• Built the secure three tier architecture system within AWs using subnet/security groups/IAM
• Modeling ER, Logical and physical model for EDW and DataMart
• Designing Informatica ETL Jobs from DB2 source system to various Target environments Oracle/SQL Server/Redshift
• Designing cubes in SSAS
• Setting up the operational process for system maintenance
• Interacting with Change management and compliance team on best practices
• Integrating tableau reports to Salesforce platform
• Performance tuning complex report at query and design level
• Improving data visualization in dashboard for effective data analysis
• Converting Business Object reports to Tableau and universes to Datasources
• Designing and deployment of Salesforce related Informatica ETL and Tableau reports
• Setting up the operational process for system maintenance and Data load
• Providing end-user product training and support
• Documenting operational process for offshore Team and review Offshore development delivery
• Working with project Management for Project Planning, Delivery Estimation and Resource onboarding

BI Architect

Confidential, Palo Alto

Technologies: Business Objects R3/R4 (IDT, Web Intelligence and Xcelsius), Tableau, Data services 3.0/4.0, Informatica, SQL server 2008/2012,HANA 1.0

Responsibilities:

• Implementation and maintenance of BI cloud Infrastructure in AWS
• Designing Pre-configured Informatica and Data Services Jobs for SFDC and SFTP configured for BI tenants
• Data Modeling Multitenant Datawarehouse with inbuilt security and Data restriction
• Extracting Data from client Database and loading to cloud Oracle and SQL server Databases
• Develop Oracle PL/SQL procedures for Data cleansing, processing and aggregation
• Optimize and Performance tuning the report queries
• SQL performance tuning with indexes, materialized views and aggregate tables
• Developing UNIX shell scripts to automate process of data loading with SQL*Loader and further processing with Plsql programs 
• Creating OLAP cubes for advanced analytics and accessing through Tableau and Business Objects reports
• Setting up the operational process ETL and BI Maintenance
• Installation, configuration and support of Business Objects
• Configuring user security, groups and folders in Business Objects administrative page
• Designing and deployment of BI.ondemand application layer
• Interacting with Change management and compliance team on best practices
• Converting Microstartgy report to Business object reports
• Designing and deployment Tableau report base on HANA Database and features

BI Consultant and Business Analyst

Confidential, NY

Technologies: Business Objects 6.0/R2,Microstaertgy, Data services 3.0/4.0, Oracle 10g and Bex explorer/Query Designer

Responsibilities:

• Designed Business Intelligence solution as a Lead consultant.
• Created and maintain Microstrategy projects including its configuration, schema and application objects like sophisticated reports using advanced filters, advanced metrics, custom groups, consolidations, advanced prompts, customer drill maps, report services, dashboards, etc
• Identify opportunities to use new functionality In-Memory Cubes, Report Based Cubes, SQL Optimization, VLDB Settings. Designed monthly Prescription assistance report with web application designer
• Installing and configuring Tableau and Microstrategy environments
• 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 .net according to growing needs of business.

BI consultant

Confidential, Seattle

Technologies: Business Objects XIr2 and R3 (Designer, Web Intelligence and Xcelsius), Confidential BI 7.0, BW 3.5, Informatica 8.1.1, Oracle 10g and Teradata

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

Technologies Used: Informatica 8.1.1,Oracle 10g and Teradata

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

Technologies Used: Business Objects XIr2 and 6.5, Informatica 8.0, Crystal Reports 10 and Oracle 9i.

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.