Summary
Overview
Work History
Education
Skills
Websites
Timeline
SEKHAR THAPA

SEKHAR THAPA

Brentwood,CA

Summary

Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

11
11
years of professional experience

Work History

Data Engineer

CLIFBAR
Emeryville, CA
08.2021 - Current
  • Migrated and Upgraded 50+ SSIS package during Production Database application upgrade
  • Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
  • Monitored and tested SSIS application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
  • Designed, Developed and Maintained complex ETL/ELT Data Pipeline with SSIS and Python
  • Designed and Developed dashboards and paginated report for HR, Sales and Marketing, Business Application, Accounting and Finance teams on PowerBI Application
  • Install and configure two new PowerBI Gateways and configure them as secondary instances for failover cluster and load balancer
  • Developed Data Modeling using Tabular3 and deploy into Test and Production Environment
  • Designed and implemented effective database solutions and models to store and retrieve data.

Senior System Integration Engineer

Chinese Community Health Plan
San Francisco, CA
01.2020 - 08.2021
  • Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation
  • Designed, Developed and Maintained complex ETL Pipeline Packages to streamline data flow
  • Designed and Developed 834 & 837 Inbound and Outbound Data Integration using SSIS, C#, Python and PowerShell scripting language
  • Designed and Developed report in Crystal Reports and SSRS reporting platform for Utilization Management, Finance and QI Departments
  • Designed and Developed Claim Data for Medical, Pharmacy, Vision and Dental Inbound and Outbound Data from Different Vendors
  • Management, Finance and QI Departments
  • Designed and Developed Claim Data for Medical, Pharmacy, Vision and Dental Inbound and Outbound Data from Different Vendors
  • Designed 834 Reconciliation Process CoveredCA and Maintain 95%+ data accuracy
  • Diagnosed issues with SSIS, C Shape and PowerShell systems and quickly repaired flaws to maintain functionality
  • Streamlined troubleshooting processes to improve system support and enhance communication between support team and end-users.
  • Proposed technical feasibility solutions for new system designs and suggested options for performance improvement of technical components.
  • Managed use of various types of databases and configured, installed and upgraded new ones
  • Handled scripting tasks for debugging and automation using Python, PowerShell.

Senior Business Intelligence Developer

Crystal Creamery Inc
Modesto, CA
09.2017 - 01.2020
  • Designed, Developed and Implemented cubes using Partitions, KPIs, Perspectives (Subset of Cube) etc
  • Responsibilities: Developed and Implemented different types of Financial and Budget Report and implemented Data Quality Services (DQS) to improved data quality in financial, manufacturing, and warehouse data service
  • Review and assess current ETL packages and SQL Server Reports and recommend and make changes by following best practices and developer and deployed SSIS package to update Integration Service in SQL Server 2014 environment
  • Migrated 14+ SQL server instances from 2008 to 2014 SQL Server
  • Upgraded all SSIS packages to 2014 environment Meet with users, SMEs, Business Partners to gather, discuss and understand business requirements in more detail
  • Create technical documents using functional documents
  • Develop and Deliver reports on timely manner to users, using SAP Business Objects Suits tools like WEBI, SAP Lumira, SAP Business Intelligence Dashboard etc
  • Dashboard Designer and Analysis and Build Universe, different types of view in HANA Studio in S/4 HANA Environment
  • Performance test and Quality test all reports and get sign off from users
  • Developed complex SAP WEBI canned reports using more than 2 data sources, graphs, document links, and element links
  • Used For-Each and For All context to resolve some of errors in SAP Webi reports
  • Performance Tuning and Monitoring in SQL Server 2008 and 2012 environment
  • Designed and implemented scalable applications for data extraction and analysis.
  • Create Ad-hoc Reports and Dashboards using PowerBI for Business and Financial user in SQL Server 2008, 2012 and SAP S/R HANA environment
  • Planned and conceived computer systems using information engineering, data modeling and structured analysis
  • Researched and recommended process improvements designed to mitigate operational and financial risk
  • Analyzed program data to provide input for key decision making and strategic planning
  • Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
  • Automated and implemented backup and recovery procedures for Test Environment system that resulted in Production Environment
  • Wrote SQL, PowerShell scripts for daily maintenance activities, including indexes and tables analyses
  • Completed technical reviews of existing systems and suggested updates or changes, resulting in system performance improvement
  • Strategized technical support plans and designed budgets, timelines and scopes for over 3 successful projects.
  • Tuned systems to boost performance.

Senior Business Intelligence Developer

San Francisco Unified School District
San Francisco, CA
10.2015 - 09.2017
  • Conducted showcases of developed functionality to business stakeholders to get feedback and identify areas for improvement
  • Use JIRA for Project Management, Bug Tracking and Collaborating with other teams
  • Prepared disaster recovery and business continuity plans in event of unexpected problems
  • Designed customized data collection models for specific visualization tasks.
  • Designed test scripts that effectively demonstrate system's support for all user requirements while collaborating with QA team
  • Used Execution Plan, SQL Server Profiler to trace slow running queries and tried to Optimize SQL queries for improved performance and availability
  • Review and assess current ETL packages and SQL Server Reports and recommend and make changes by following best practices and developer and deployed SSIS package to update Integration Service in SQL Server 2012 environment
  • Use Team Foundation Services (TFS) for version control for SSRS, T-SQL and SSIS Packages Developer and Deployed SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2015
  • Developed and Implemented different types of Financial and Budget Report and implemented Data Quality Services (DQS) to improved data quality in financial and student data service
  • Developed custom database objects, stored procedures and delivered application support
  • Designed and implemented TSQL queries for reporting and complex solution development
  • Prepared memory management for database systems
  • Analyzed existing SQL queries to identify opportunities for improvements
  • Drove data analysis, resolving complex business issues and proposing long-term system solutions
  • Developed, implemented and optimized stored procedures and functions using T-SQL
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
  • Completed technical reviews of existing systems and suggested updates or changes, resulting in faster SSRS report execution.
  • Planned, designed and implemented diverse business intelligence solutions.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.

Senior SQL Server/SQL BI Developer

BA Technolinks
Santa Clara, CA
12.2013 - 10.2015
  • Gathered business requirements by conducting detailed interviews with stakeholders
  • Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
  • Managed, analyzed and converted business requirements into functional specifications
  • Developer user stories with detailed acceptance criteria and ensured that completed stories meet business requirements
  • Designed and Developed new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2013 in 2012 SQL Server environments
  • Defined Check constraints, Business Rules, Indexes, and Views
  • Worked on performance point server to create dashboard and scorecards for business intelligence
  • Developed different kinds reports using SSRS, Power BI tools (DFAST, DQ Dashboard, and KDE Dashboards etc.) Developer and deployed different kinds of report like KPI reports, matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports
  • Extensively worked on Team Foundation Services (TFS) which to maintain databases up to date and also use TFS for storage of updated scripts and to avoid data loss Use Microsoft Visio and Project Management for tracking projects and bug management
  • Developed many complex SSIS packages using proper control and data flow elements Used Execution Plan, SQL Server Profiler to trace slow running queries and tried to Optimize SQL queries for improved performance and availability
  • Extensively worked building Data Warehouse Project (Bottom Up Approach) by building department specific Data-Mart (Risk DM) from scratch and worked on SQL Work book to standardizing SQL Server access by different users
  • Developed custom database objects, stored procedures and delivered application support
  • Designed and implemented TSQL queries for reporting and complex solution development
  • Designed complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
  • Research and Designed high-standard database solutions to meet stability, reliability and performance metrics
  • Produced high-standard database solutions to meet stability, reliability and performance metrics
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements
  • Followed standard practices for migrating changes to test and production environments.

SQL Server Database Developer

Pondera Solutions
Folsom, CA
01.2014 - 12.2014
  • Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints
  • Developed SSIS Templates which can be used to develop SSIS Packages such way system can be dynamically deployed into Dev, Test and Production Environments
  • Developed Complex Stored Procedures, Views and Temporary Tables as per requirement
  • Scheduling SSIS packages and Jobs
  • Troubleshooting performance issues and fine-tuning queries and stored procedures
  • Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers
  • Extensively worked on Team Foundation Services (TFS) which use to maintain databases up to date and also use TFS for storage of updated scripts and also to avoid data loss Helped Quality Assurance Team to generate Test Plans and Test Executions
  • Worked on performance point server to create dashboard and scorecards for business intelligence
  • Experience in creating complex SSIS packages using proper control and data flow elements Involved in updating slowly changing dimensions strategies Participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand Business requirements
  • Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS) Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

SQL Server Database Developer

BA Technolonlinks
Santa Clara, CA
02.2012 - 06.2013
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints
  • Build indexes on selective columns to speed up queries and analyses in SQL Server Management Studio
  • Used Execution Plan, SQL Server Profiler to trace slow running queries and tried to Optimize SQL queries for improved performance and availability
  • Created SQL scripts for tuning and scheduling and performed data conversion from flat file into normalized database structure
  • Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all;
  • Created and implemented database designs and data models
  • Coordinated with project management staff on database development timelines and project scope
  • Tested programs and databases to identify issues and make necessary modifications
  • Managed multiple, concurrent e-commerce projects in fast-paced environment
  • Trained team members in best practices and company standards.

Education

MBA - MIS

Lincoln University, Oakland, CA
12.2016

Skills

  • Scripting Language and Programming Language; SQL, PowerShell, Python, C#
  • Advanced analytics
  • Risk analysis
  • Data analysis
  • RDBMS; MS SQL Server 2008 onwards, Oracle, MySQL, Teradata, S/4 HANA
  • Dashboard & Reporting Tools; BIDS, Crystal Reports, Tableau 90, Power BI, SAP-Web Intelligence, SAP-Lumira for Storytelling and Dashboard Designer and PowerBI
  • Modeling Tools Microsoft Visio, SQL Diagrams, ERWIN 41, SAP Universe Design Tool 42, Information Design Studio 42 and HANA Studio 23
  • Windows Server, Linux and Ubuntu
  • Disaster recovery, Migration, Database Performance Tuning
  • Microsoft Visio, Jira, ER Studio
  • Analyze Data, Information Design, Data Profiling, Data Wrangling, Database Migration, Use Cases
  • Data Mapping, Gap analysis, Custom Reporting, Code reviews, Data Modeling
  • Virtualization technologies, Database Design and Development, Data Mining
  • Algorithm implementation, Database Design and Implementation Database programming, Performance Optimization, Risk Management,
  • Strong Interpersonal skills, Ability to Work Independently, Multitasking, Verbal and Written communication, Time Management, Creative and Critical Thinking
  • Analytical and Critical Thinking

Timeline

Data Engineer - CLIFBAR
08.2021 - Current
Senior System Integration Engineer - Chinese Community Health Plan
01.2020 - 08.2021
Senior Business Intelligence Developer - Crystal Creamery Inc
09.2017 - 01.2020
Senior Business Intelligence Developer - San Francisco Unified School District
10.2015 - 09.2017
SQL Server Database Developer - Pondera Solutions
01.2014 - 12.2014
Senior SQL Server/SQL BI Developer - BA Technolinks
12.2013 - 10.2015
SQL Server Database Developer - BA Technolonlinks
02.2012 - 06.2013
Lincoln University - MBA, MIS

Similar Profiles

CREATE PROFILE
SEKHAR THAPA