Sumit Dutta

Design, Develop and Implement BI solutions using Oracle PL/SQL, SQL queries. Design and build new reports using Oracle DWH, SAP HANA DWH. Developing ETL scripts using MS SQL Server SSIS packages. Monitoring existing technical environment, diagnosing and troubleshooting issues. Creating reports and dashboards from raw data. Supporting modifications/ alterations to existing BI solutions. Conducting data checks and investigations to improve data quality. Responsible for quarterly business reviews and publishing operational reporting with KPIs.

Involved in RAD customer segregation for sub-regions in EMEA. Responsible for definition, design, and support of solutions based on business requirements. Analyzing data and trends from IDC/ MAP/ Salesforce.com / Secondary Research. Acted as a liaison between business and technology, translating needs into work items. Worked with IT/Business Applications to estimate efforts and define business requirements. Improved data analysis and efficiency in existing reports.

Provided end-to-end secondary research solutions from scoping to designing a questionnaire, data collection, and analysis. Developed executable IT strategies and managed organizational performance. Applied tools to convert raw data into information for better business process management. Published operational reporting (Daily, weekly, monthly). Applied analytical skills for data analysis, data enrichment, and performance management. Recommended and established new reporting methods and procedures.

Delivered service and support to end-users using automated call distribution software. Responsible for overall maintenance of hardware (printers, routers, switches). Installed and configured computer systems, diagnosing hardware and software faults. Provided support, including procedural documentation. Implemented security policy and virus protection.