Hemant Vishwakarma
Angestellt, Assistant Manager - Business System Analyst, Thomson Reuters
Bangalore, Indien
Werdegang
Berufserfahrung von Hemant Vishwakarma
Bis heute 6 Jahre und 1 Monat, seit Juni 2018
Assistant Manager - Business System Analyst
Thomson ReutersManaging 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.
2 Jahre und 11 Monate, Aug. 2015 - Juni 2018
Senior BI Consultant
Neudesic
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.
2 Jahre und 2 Monate, Juli 2011 - Aug. 2013
Senior Software Engineer
Mastek Ltd
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.
1 Jahr und 2 Monate, Mai 2010 - Juni 2011
Software Engineer
Shawman Software Enterprises
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.
1 Jahr und 8 Monate, Okt. 2008 - Mai 2010
Technical Support Executive
Reliance
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.
Ausbildung von Hemant Vishwakarma
4 Jahre, Juli 2003 - Juni 2007
Computer Science Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Sprachen
Englisch
Fließend