- 4 years of experience in the IT Industry as a Business Intelligence Developer.
- Extensive experience in Data integration and migration ETL using SSIS and Pentaho from various data sources like Flat files, Excel, Oracle, DB2.
- Expert in creating, executing, and deploying SSIS packages as well as in configuring files, error handling and logging in SSIS.
- Proficient in developing Tabular, Matrix, Drill- Down, Drill-Through, Sub-Reports and Parameterized Reports using SSRS, Tableau.
- Providing data analysis, informational reports and tracked performance of online order fulfillment.
- Using Tableau for data visualization, such as making dashboards and real time mapping of order destinations and origins on the map of USA.
- Creating and updated tables in database on daily, weekly, and monthly basis.
- Using Pentaho data integration for ETL operations involving large volumes of data.
- Performing ad-hoc queries on regular basis for tracking performance of online order fulfillment.
- Gathered requirements, designed, developed, tested, implemented, and maintained reports using SSRS.
- Developed several reports with consistent drill-down functionality including summary reports and Master Detail reports.
- Created SSIS package in which records were loaded daily, also from other data resources such as Flat File, Oracle, and XML, in order to create and maintain a centralized data warehouse.
- Created reports using Report Manager, Report Builder, Reporting Security, and Reporting Services Configuration manager.
- Prepared documentation of all the requirements and enhancements to reports and cubes.
- Created, designed and maintained Reports using SSRS.
- Improved the presentation of data in reports following the company report standards to give reports more elegant and decent look.
- Managed deployment of reports and cubes to different environments.
- Scheduled SSIS package to update data every morning with previous business data to OLAP database.
- Created tabular, matrix, ad-hoc, drill down, and drill through reports using SSRS.
- Technical Skills:- TECHNICAL HIGHLIGHTS
- Database/BI tools: Oracle, SQL Server, Toad, SSIS, SSRS, MS Access, Teradata, Pentaho, Tableau.
- Languages: SQL, mySQL, PERL, C , JAVA/JSP, XML, HTML, VB.net, VBA
- Operating Systems: UNIX, MS Windows NT/2000/XP/Vista