Data Developer
Resume:
Kaberi Patra
Data Modeler/Data Analyst
email: ***********@*****.***
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