Vaibhav Pujari

Career Summary

Over 2+ years of professional IT experience . Good understanding of postgres as database, understanding of AWS for data migration, implementation of Cognos for BI solutions, learning and implementing python for data analysis.

Roles & Responsibilities as Data Engineer:

• Used AWS Data Migration Service for replicating data from OLTP systems to DWH databases.
• Automated the data load from different API's to DWH using Python.
• Automate bursting of excel reports using Python.
• Installed, upgraded, configured and tuned Cognos systems and all associated middleware in LINUX environments.
• Automated BI reports for secure virtual server environment.
• Trained End users on using Self-Service BI, allowing them to access and analyze data easily without depending on IT.
• Analyze the data and provide data insights on weekly basis.
• Created and improved intelligence resources by creating data marts to facilitate consistent result.
• Designed & maintained DB scripts to meet unique needs and goals determined during initial evaluation and planning process.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.

Career Summary

Worked as data warehouse analyst for the MIS team.

Responsibilities as Data warehouse Analyst:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Implemented security based on LDAP Authentication.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Designed reports using OBIEE Mobile Application Development.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.

Career Summary

Worked as database developer.

Roles & Responsibilities as Associate Software:

• Involved in full development cycle of Planning, Analysis, Design, Development, testing and implementation.
• Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.
• Involved in source code version review and deployment.
• Optimization of search modules using dynamic queries and table partition.
• Created jobs for data synchronization and for gathering statistics.
• Building and maintaining SQL scripts and complex queries for data analysis and extraction.
• Created packages for report generation using analytic functions like RANK, DENSE RANK, and PARTITION OVER.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections, object types and Triggers.