Shambhu Kunwar Email & Phone Number

Phoenix, Arizona, United States

• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.• Utilized SAS and SQL to extract data from statewide databases for analysis. • Acquired data from primary or secondary data sources and maintain databases/data systems.• Performed Data Analysis using visualization tools such as Tableau, Spotfire, and SharePoint to provide insights into the data.• Configured Azure platform offerings for web applications, business intelligence using Power BI, Azure Data Factory etc.• Data flow check with source to target mapping of the data.• Data matrix creation for mapping the data with the business requirements.• Data profiling to cleanse the data in the data base and raise the data issues found.• Implementation of Clickstream analytics in the application to analyze & understand user behavior. • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.• Analyse and validated the data in Presto using SQL queries.

Atlanta, Georgia, United States

• Documenting data requirements and performing data analysis, with a clear understanding of differences between business data and metadata• Worked with SAS as an ETL tool to extract and load the data into Teradata table from excel data sources.• Lead the Data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.• Data modeling for data from RDBMS to Cassandra and MongoDB for optimal reads and writes.• Designed and developed reporting dashboards to analyze web activity/clickstream data using Web analytics tools.• Imported clickstream log data from FTP Servers and performed various data transformations using Spark Data frame API and Spark-SQL apis.• Extensive data mining of different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart.• Interpreted complex data mapping and data integration between two or more applications in a producer/consumer construct.

Milwaukee, Wisconsin, United States

• Responsible for gathering data migration requirements.• Identified problematic areas and conduct research to determine the best course of action to correct the data.• Analyzed problem and solved issues with current and planned systems as they relate to the integration and management of order data.• Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports.• Monitor for timely and accurate completion of select data elements.• Monitor data dictionary statistics.• Involved in analyzing and adding new features of Oracle 10g like DBMS_SHEDULER, Create Directory, Data pump, CONNECT_BY_ROOT in existing Oracle 9i application.• Archived the old data by converting them in to SAS data sets and flat files.• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.• Enhance smooth transition from legacy to newer system, through change management process.• Trained team members in PL/SQL and provided Knowledge Transfer sessions on Finance and Banking domains.• Planned project activities for the team based on project timelines using Work Breakdown Structure.

Nepal

• Designed and developed tools, techniques, metrics, and dashboards for insights and data visualization.• Drive an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions.• Build and execute tools to monitor and report on data quality.• Performed Source to Target data analysis and data mapping.• Created SQL queries to validate Data transformation and ETL Loading.• Define the list codes and code conversions between the source systems and the data mart.• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.• Involved in data mapping and data clean up.• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.• Analyzed and maintained SAS programs and macros to generate SAS datasets.• Coded PL/SQL packages to perform Application Security and batch job scheduling.• Created reconciliation report for validating migrated data.

Master Of Business Analytics

Bachelor Of Business Administration - Bba