Hemant Vishwakarma

Managing and Leading Elite BI Finance Team; Coordinating with multiple teams; Reporting team activities, weekly update and progress status to Director, Delivery Head and VP; Providing Business Intelligence, Data warehouse and Reporting solution; Designing and Developing ETL framework, packages and process flow. Designing data-modeling diagram, data lineage and database scripts. System Migration, System support and Troubleshooting.

Understanding business requirement and delivering BI solution in a timely and accurate manner; Analyzing, estimating and pointing a user story; Working with business owners to define application and reporting requirements as well as edge cases for data; Develop and test SSIS packages to import data from source data systems to staging, and from staging to RTR.DW and MongoDB; Designing and planning user story implementation approach and artifacts to deploy SSIS and database objects on different environment;

Involving in requirement gathering and knowledge transition phase to understand the existing system, processes, architecture and interfaces; Understanding business needs and evaluating and documenting the requirements; Communicating plan with the client for implementing new changes. Estimating PBI’s goals and assigning task to the team members. Designing and configuring MDS database and web site on development server. Deploying and managing MDS model. Developing SSIS packages and SQL objects.

Gathering business requirements and designing of data model and data flow. Developing SSIS packages, Data-stage Jobs and SSRS reports using efficient data retrieval techniques. Implementing dimensional modelling and creating SSAS cubes. Managing cube meta-data, attributes, partitions and hierarchies. Deploying SSIS packages and deploying/ processing cube on FST, SIT, UAT and Prod environment. Tuning SSIS package and SQL Scripts. Production support and troubleshooting the system issues.

Creating DW solution for a Casino project by implementing dimensional modelling and SSAS Cube. Collecting requirements and managing dimensions, hierarchy and measure groups. Designing Database model and ETL framework. Designing and managing SSIS packages, SQL objects, T-SQL and MDX query. Involving in gathering Report Development Specifications and working to design and publish several reports. Designing web and windows form to integrate new features in SCMS application. Data validation.

Creating SSIS packages to extract data from different operational data store and load it in to internal Data Warehouse. Validating data loads and verifying audit logs to ensure the loads and resolving data issue. Developing SQL procedure, functions and other database scripts. Maintaining performance of the portals and their servers by checking their status on hourly basis and maintaining their reports on daily, weekly and monthly basis. Troubleshooting and resolving issues.