| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Generals Ct, Centreville, Street Address , VA PHONE NUMBER AVAILABLE EMAIL AVAILABLELINKEDIN LINK AVAILABLEObjectiveSystematic Data Engineer with 11 years of experience in designing, engineering, architecture, data analysis and data modeling in different data domains like US health care, e-commerce, and US general insurance. Proven track record managing all phases of Software Development Life Cycle (SDLC). Analytical thinkers quickly and effectively identify and resolve technical problems.Skills & abilitiesDatabases: MSSQL Server, Oracle, MYSQL, Postgres, MongoDB, Redshift, SnowflakeAnalytics: Zoho AnalyticsELT: SSIS, Five Tran, TalendScripts: PythonCloud: Microsoft Azure, AWSData AnalysisEMR (Electronic Medical Record)AMS (Agency Management System: EPIC)EducationNepal College of Information Technology (Nepal), M.Sc.Major: Computer ScienceWork ExperienceProject: US General InsuranceClient: Renegade InsuranceRole: Senior Data EngineerPeriod: Feb -2019 - May 2023Tools: SQL Server, MongoDB, MySQL, Python, Zoho Analytics, EPIC (Agency Management System), Salesforce, AzureLocation: NepalImport different data sources in SQL Server database using SQL Scripts and PythonAnalyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.Data modeling on MongoDBLoad Data from SQL Server to MongoDB using Python script.Employed data cleansing methods significantly enhanced data quality.Explored the database architecture implemented by third parties (EPIC Agency Management System)Design database, schema, tables, views, functions, stored procedures, triggers etc.Prepared dataset for dashboards and reportsLoad data from RDBMS to analytical tool ZOHO AnalyticsDesigned custom dashboards and reporting interfaces.Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.Mapped data between source systems and warehouses.Prepared data set for Salesforce application (source is AMS) and loaded that data to salesforce using Salesforce data loader tool.Used MySQL database to store applications configuration and user management data.SQL Query OptimizationProvide training to new team members.Cross-team collaborationProject: E-CommerceClient: GrowbyDataRole: Senior Data EngineerPeriod: Nov -2015 - Feb 2019Tools: SQL Server, SSIS, Python, Redshift, Azure cloudLocation: NepalDeveloped database architectural strategies at modeling, design and implementation stages to address business or industry requirements.Implemented all the business logic in MSSQL database using stored procedure, function, view etc.Contributed to internal activities for overall process improvements, efficiencies and innovation.Proposed database changes to ease monitoring and administrative effort.Reviewed database design to recommend enhancements or improvements.Troubleshot complex queries and stored procedures.Worked with software development and testing team members to design and develop robust solutions to meet client requirements.Analyzed existing SQL queries for improvements/optimization.Designed, implemented and maintained complex T-SQL queries, views, stored procedures, functions etc. using MSSQL server.Resolved complex business issues, proposing long-term solutions to avoid repeat problems.Prepared data flow using SSIS.Load data from MSSQL to Redshift (data warehouse) using Python scripts.Project: US Health CareClient: Deerwalk ServicesRole: Data EngineerPeriod: Sep -2012 - Oct 2015Tools: SQL Server, Python, Redshift, AWS, MySQL, OracleLocation: NepalLoad different data source from AWS to Oracle database using PLSQL/python.Restored different databases provided by clients like Oracle, MSSQL, MySQL for analysis purposes.Extracted and interpreted data patterns to translate findings into actionable outcomes.Identified and documented detailed business rules and use cases based on requirements analysis.Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.Implemented all the business logic in Oracle database using stored procedure, function, view, triggers etc.Mapped data between source systems and warehouses.Validated warehouse data structure and accuracy.Designed, implemented and maintained complex PL-SQL queries, views, stored procedures, functions etc. using Oracle server.Supported leadership team with reporting, analysis and business presentations to inform divisional strategies.Prepared queries for different matrix/report using PL-SQL script.Query optimizationAutomated manual process using PL-SQL script. |