Data Professional

Senior Data Professional

Expert Data lead with over 10 years of experience configuring and customizing solutions for clients, including Enterprise clients in Healthcare, Financial, Manufacturing, Ecommerce and Technology. Expert in database tools such as SQL Server, Stored Procedures T-SQL, Power BI as well as programming and other technologies and applications. Worked closely with Fortune 500 clients, project managers, and developers both in the US and globally. 8 years with IBM and Kenexa as a software engineer, 5 years of experience as data manager and 1 year experience as Data Solution Consultant. Able to work remotely, hybrid or on site. US Citizen

Areas of Expertise

Subject Matter Expertise (SME): Data Management, Data Analysis, Reporting and Analytics, Documentation and Communication, Complex SQL Querying and Optimization

Database Tools: Microsoft SQL Server, T-SQL, SSRS, SSIS, Snowflake

Data Visualization Tools: Power BI, Alteryx, MS Visio

Version Control, Troubleshooting and Ticketing: Jira, Smartsheet, Gitlab, Datadog and Splunk

Data Management Skills: ETL, SSIS, Stored Procedures, UDFs, Automation, PII protection

Programming: .Net, JavaScript, CSS, XML, Perl, HTML

Experience

Export from Nepal, Dallas, Tx (https://exportfromnepal.com/) June 2023 – Current

Data Solutions Consultant

Export From Nepal is an emerging global ecommerce company specializing in distributing Himalayan products globally.

Analyzed large datasets from online transactions, website traffic, customer data to identify trends, customer behavior, patterns, and insights for business strategies.

Led and collaborated with team of developers and data operations to ensure smooth daily workflows.

Maintained ETL processes to ensure seamless data integration from multiple sources into Snowflake data warehouse, enhancing data accessibility and accuracy.

Maintained and monitored data quality and collaborated with developers to improve the system and database design.

Analyzed the testimonials and feedback data to prepare and present sentiment analysis report.

Perceptyx, Temecula, CA June 2018 – June 2023

Data Manager

Perceptyx is a leading global organization in customer, culture and people analytics working with Fortune 500 companies. Served as SME and data contact for all projects and clients such as CVS and Ameriprise.

Implemented ETL process by gathering data from Excel, CMDB, SAP and other data sources and conducted comprehensive data analysis, scrubbing, manipulation, and processing to ensure a smooth migration and integration of customer data into the Perceptyx platform.

Engineered personalized data solutions for employee engagement surveys developing and maintaining complex SQL queries, effectively retrieving, and manipulating data for analysis and reporting.

Led all the primary data related escalations and supported Project Managers by providing guidance on system limitations, data management and procedures related to application usage and privacy compliance targeting enterprise-level customers.

Led data-focused initiatives across the team as a SME to improve accuracy and optimize processes. For e.g.: Using Perl scripting automated normalization of demographic data, automate the distribution of reports based on user privileges, collaborated with team members to maintain and update master translation file saving translation cost for the client by 20% to 30%.

Automated the data cleaning process with python to ensure data is imported accurately reducing the data cleaning time by 50% and increasing accuracy by 30%.

IBM, Dallas, TX April 2013 – February 2018

Senior Software Engineer

Created advanced SQL queries and T-SQL stored procedures, and user-defined functions (UDFs) for data analysis.

Designed and created mock-up report templates using SSRS and implemented in various projects to reduce the project life cycle timeline.

Created automated processes through stored procedures utilizing T-SQL to facilitate additional features and functionality of tools and reports.

Mapped out the implementation strategy for various customizations, implemented changes, and generated various reports that included demographic frequency, comment exclusions, and user access reports.

Acted as a Subject Matter Expert (SME) and mentor; trained new software engineers on survey tools/reporting process.

Collaborated with the Quality Assurance and Data Integrity teams to, troubleshoot, and resolve issues.

KENEXA CORPORATION, Minneapolis, MN December 2009 – April 2013

Software Engineer

Oversaw the project cycle of the employee engagement survey for different national/international clients, including the review and reformatting of data, performing data cleansing, and data type conversions.

Created advanced SQL queries, functions, and T-SQL stored procedures and audited the report definition manager tool, debugged tool set-up, and enhanced the standard process.

Loaded data from Excel, Access, or flat data files into SQL tables using Table Import, reformatted the data, and inserted the reformatted data to perform data cleansing analysis to set up survey tools.

Education & Technical Skills

BELLEVUE UNIVERSITY, Bellevue, NE, Master of Science Degree in Computer Information System

KATHMANDU ENGINEERING SCHOOL, Kathmandu, Nepal, Bachelors in Computer Engineering

Contact this candidate