Kaberi Patra

Data Modeler/Data Analyst

email: ac5vav@r.postjobfree.com

phone: 669-***-****

Professional Summary

Over 6 years of professional experience in Information Technology with expertise as Business Intelligence Consultant using Tableau Desktop and Server versions,Pentaho BI Suite, Jaspersoft, Symphony RPM, Data Warehouse/Data Mart and Business Intelligence tools.

Worked on the complete Life Cycle Development process SDLC using Tableau 10.3, 9.3, Pentaho, Jasper soft, Birst, SQL and other BI tools.

Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment

Extensive experience with Data warehousing implementations

Worked on Collaborating with end users, project stakeholders and support partners to identify needs, goals, and business models. Possesses excellent written and verbal communication skills.

Technical Skills

BI Tools: Tableau 10.3, Tableau9.3, Pentaho, Jaspersoft, Qlikview, SDK and Symphony RPM.

ETL Tools: Pentaho Data Integration

OS: Windows, UNIX (Sun Solaris, AIX, HP-UX, Linux)

GUI: TOAD 8.0, Erwin

Tools: ERwin Data Modeler, Excel, PowerPoint

RDBMS: Oracle, DB2, SQL Server, MySQL, PostgreSQL

Languages: JavaScript, HTML, XML, SQL, PL/SQL

AWS: Hands on with AWS Stack (S3, Redshift, RDS, MySQL)

Certifications

Data Visualization with Tableau from University of California, Davis

Professional Experience

Symphony Teleca, Aviall Inc., Mountain View, CA Oct 2011 – July 2014

Aeronautics and Supply Chain

Data Modeler

Analyzed the business data and business logic to create the proposed OLAP data model.

Data model design using Symphony AS (for Event Based Analysis and Sales and Operation Planning).

Worked on Data models,Data / Gap analysis in various environments and suggest best approaches to team in resolving the data issues using SQL

Develop Complex, Interactive/Dynamic Reports Dashboards Visualizations with Tableau Desktop and Symphony RPM.

Fine tune/Enhance and Publish dashboards developed by Business groups to desktops of the intended users. Conduct business analysis, requirements gathering and develop new financial reports for daily consumption Reports

Environment: Tableau 10.3 Desktop and Server, Sql Server, SQL Server Management Studio, Erwin, Jira

GTM, Mountain View, CA Oct 2011 - June 2014

Retail and Supply Chain domain

Data Modeler

Conduct Business analysis, Requirements gathering to develop new Reports and Dashboard and create high level design documents and technical specifications for Tableau Dashboards,Visualizations and Reports

Administer Tableau servers, security,Installations

Document design specifications, installation instructions, and other system-related information. Design, develop complex reports, dashboards using Tableau

Handling Disaster Planning and unplanned outages of Tableau Servers

Design and review Technical Design Documents and queries through onsite/offshore mail coordination.

Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.

Uses Tableau Server and Tableau Online to Publish the Dashboards to use in Mobiles and Tablets

Environment: Tableau Desktop and, Symphony RPM, Microsoft Excel, JIRA, Erwin

AES Energy Storage, Bangalore, India Oct 2010 – Oct 2011

Energy domain

Senior BI Developer

To develop Operational reports for AES power storage.

To develop ETL scripts to automate the data retrieval of real time data feeds from different org sites.

Creation of data warehouse, OLAP cubes, report busting (both desktop and mobile compatibility).

To design and develop cross tab reports, drill down reports, flash charts for reporting operational KPIs.

Design OLAP cubes using Pentaho Schema Workbench for multidimensional analysis of the operational data.

Performed requirements gathering and developed new Reports and Dashboards.

Documented the flow of data across various systems in the organization and proposed new changes.

Environment Pentaho Data Integration (ETL), Pentaho Reporting, Pentaho Dashboard framework

PUMA-GBS\PUMA-PID, Bangalore, India

Retail domain Oct 2010 – Dec 2010

Senior BI Developer

Gathered business requirements, performed data analysis, created mapping documents and conducted code reviews.

Performed source to target data mappings for the Pentaho ETL. Designed and managed physical and logical data models of enterprise data warehouses, data marts and operational data stores.

Involved in daily meetings and calls with various teams for the project development status and issues.

Migrated all the reports from Crystal Reports to Pentaho.

Conducted performance tuning of the reports based on the report queries generated at the database level.

Analyzed and debugged the data issues with the Pentaho ETL jobs.

Monitored data quality, resolving problem data issues with Pentaho ETL jobs and ensuring timely updates.

Improved cube build time and access time by consolidating data and incrementally updating the cube.

Environment: Pentaho BI Suite, Crystal Reports, SQL Server.

Cignex Recruitment Analysis, Bangalore, India

Human Resource domain Jan 2010 – Mar 2010

Senior BI Developer

Responsibilities

Establish data warehouse to analyze the Statistical Data pertaining to Cignex Recruitment team (reports consumed by H.R and the Higher Management.

Designed, developed and maintained relational data models, metadata models, reporting and metrics using Pentaho BI Suite.

Conducted performance tuning and query optimization in SQL Server environment.

Created data sources and deployed the contents from QA to Production environments.

Environment: Pentaho Data Integration, Pentaho Report Designer, Sql Server 2008 R2

Cignex Help Desk Analysis, Bangalore, India

Apr 2010 – Aug 2010

Retail manufacturing domain

BI Developer

Responsibilities:

Ensured data accuracy and quality of the report result by running queries against the database.

Performed all the tasks from deployment, installation, configuration, development and some administration.

Establish data warehouse to analyze the help desk requests, tickets, Jira issue tracking belonging to Cignex Help Desk team (reports consumed by Higher Management, Help Desk Manager)

Trained users on the framework front. Helped them manipulate relationships and create work-abounds in order to perform their work tasks efficiently and effectively.

Environment: Pentaho Bi Suite, Pentaho Data Integration and MySQL

Genscape Business Intelligence, Bangalore, India Oct 2008 – Dec 2009

Energy domain

BI Developer

Responsibilities:

Created Dashboard Reports identifying the KPIs of the business.

Created reports in Pentaho Report Designer and OAP Cubes.

Worked on monitoring the ETL jobs which were submitted to the web service.

Coordinated with the database administrator in creating aggregate / summary tables.

Ensured data accuracy and quality of the report result by running queries against the database.

Created user accounts using Pentaho Connection and then determined capabilities.

Maintained/updated report and framework documentation as needed.

Trained users on the framework front. Helped them manipulate relationships and create work-around in order to get their work done efficiently and effectively.

Environment: Pentaho Schema workbench, Report Designer, Pentaho Data integration, MYSQL

Temping Yield Maximization Model, Bangalore, India Oct 2007 – Oct 2008

Human Resource Domain

BI Developer

Responsibilities:

Created Pentaho Reports extensively using Pentaho Report Designer using conditional blocks, conditional formatting, drill through functionality, and master detail reports.

Provided technical assistance, training and mentoring to users and business partners for automating tasks and job scheduling.

Used Pentaho Administration for organizing, securing, scheduling and distributing reports.

Created user accounts using Pentaho Connection and then determined capabilities for the users.

Environment: Pentaho Report Designer, MySQL,

Education

Bachelors in Electronics and Telecommunication, Biju Patnaik University of Technology, Orissa, India, 2007

Contact this candidate